Use C99 uint32_t rather than u_int32_t

[onak.git] / onak.sql

diff --git a/onak.sql b/onak.sql
index 6abb0293d64d1475ec2f7992c700e2e903a3dc20..3d689101a3fe04456fbd9fe7c621d5d128d4d963 100644 (file)
--- a/onak.sql
+++ b/onak.sql
@@ -3,16 +3,22 @@ DROP TABLE onak_uids;
 DROP TABLE onak_sigs;
 
 CREATE TABLE onak_keys (
-       keyid   char(8) NOT NULL,
-       keydata oid NOT NULL
+       keyid   char(16) 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(8) NOT NULL,
-       uid     varchar(6000) NOT NULL
+       keyid   char(16) NOT NULL,
+       uid     varchar(6000) NOT NULL,
+       pri     boolean,
+       FOREIGN KEY (keyid) REFERENCES onak_keys
 );
 
 CREATE TABLE onak_sigs (
-       signer  char(8) NOT NULL,
-       signee  char(8) NOT NULL
+       signer  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);