cscvs to tla changeset 9

[onak.git] / onak.sql

diff --git a/onak.sql b/onak.sql
index 6abb0293d64d1475ec2f7992c700e2e903a3dc20..9fc033cf93e273835bd7b354c6e8a1b48a5c476c 100644 (file)
--- a/onak.sql
+++ b/onak.sql
@@ -3,16 +3,18 @@ DROP TABLE onak_uids;
 DROP TABLE onak_sigs;
 
 CREATE TABLE onak_keys (
 DROP TABLE onak_sigs;
 
 CREATE TABLE onak_keys (

-       keyid   char(8) NOT NULL,
+       keyid   char(16) NOT NULL,

        keydata oid NOT NULL
 );
        keydata oid NOT NULL
 );

+CREATE INDEX onak_keys_keyid_index ON onak_keys(keyid);

 
 CREATE TABLE onak_uids (
 
 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

 );
 
 CREATE TABLE onak_sigs (
 );
 
 CREATE TABLE onak_sigs (

-       signer  char(8) NOT NULL,
-       signee  char(8) NOT NULL
+       signer  char(16) NOT NULL,
+       signee  char(16) NOT NULL

 );
 );