openpgp-ca-lib 0.14.1

OpenPGP CA is a tool for managing and certifying OpenPGP keys
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91

table! {
    bridges (id) {
        id -> Integer,
        email -> Text,
        scope -> Text,
        cert_id -> Integer,
        cas_id -> Integer,
    }
}

table! {
    cacerts (id) {
        id -> Integer,
        active -> Bool,
        fingerprint -> Text,
        priv_cert -> Text,
        backend -> Nullable<Text>,
        ca_id -> Integer,
    }
}

table! {
    cas (id) {
        id -> Integer,
        domainname -> Text,
    }
}

table! {
    certs (id) {
        id -> Integer,
        fingerprint -> Text,
        pub_cert -> Text,
        user_id -> Nullable<Integer>,
        delisted -> Bool,
        inactive -> Bool,
    }
}

table! {
    certs_emails (id) {
        id -> Integer,
        addr -> Text,
        cert_id -> Integer,
    }
}

table! {
    revocations (id) {
        id -> Integer,
        hash -> Text,
        revocation -> Text,
        published -> Bool,
        cert_id -> Integer,
    }
}

table! {
    users (id) {
        id -> Integer,
        name -> Nullable<Text>,
        ca_id -> Integer,
    }
}

table! {
    queue (id) {
        id -> Integer,
        created -> Timestamp,
        task -> Text,
        done -> Bool,
    }
}

joinable!(bridges -> cas (cas_id));
joinable!(bridges -> certs (cert_id));
joinable!(cacerts -> cas (ca_id));
joinable!(certs -> users (user_id));
joinable!(certs_emails -> certs (cert_id));
joinable!(revocations -> certs (cert_id));
joinable!(users -> cas (ca_id));

allow_tables_to_appear_in_same_query!(
    bridges,
    cacerts,
    cas,
    certs,
    certs_emails,
    revocations,
    users,
);