Fix assumption that a signature on a public key is a revocation

[onak.git] / onak.sql

diff --git a/onak.sql b/onak.sql
index 6afa7376402abae00241cd2107704b6b79cdbe7a..3d689101a3fe04456fbd9fe7c621d5d128d4d963 100644 (file)
--- a/onak.sql
+++ b/onak.sql
@@ -4,16 +4,21 @@ DROP TABLE onak_sigs;
 
 CREATE TABLE onak_keys (
        keyid   char(16) NOT NULL,
-       keydata oid NOT NULL
+       keydata oid NOT NULL,
+       PRIMARY KEY (keyid)
 );
+CREATE INDEX onak_keys_keyid_index ON onak_keys(keyid);
 
 CREATE TABLE onak_uids (
        keyid   char(16) NOT NULL,
        uid     varchar(6000) NOT NULL,
-       pri     boolean
+       pri     boolean,
+       FOREIGN KEY (keyid) REFERENCES onak_keys
 );
 
 CREATE TABLE onak_sigs (
        signer  char(16) NOT NULL,
-       signee  char(16) NOT NULL
+       signee  char(16) NOT NULL,
+       FOREIGN KEY (signee) REFERENCES onak_keys
 );
+CREATE INDEX onak_sigs_signee_index ON onak_sigs(signee);