X-Git-Url: https://the.earth.li/gitweb/?a=blobdiff_plain;f=onak.sql;h=9fc033cf93e273835bd7b354c6e8a1b48a5c476c;hb=42dbc6b5efa87e868116549c5932ab62cf716568;hp=6abb0293d64d1475ec2f7992c700e2e903a3dc20;hpb=4b8483ae278577a3adc8d84da81d77019704466f;p=onak.git

diff --git a/onak.sql b/onak.sql
index 6abb029..9fc033c 100644
--- a/onak.sql
+++ b/onak.sql
@@ -3,16 +3,18 @@ DROP TABLE onak_uids;
 DROP TABLE onak_sigs;
 
 CREATE TABLE onak_keys (
-	keyid	char(8) NOT NULL,
+	keyid	char(16) NOT NULL,
 	keydata	oid NOT NULL
 );
+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
 );
 
 CREATE TABLE onak_sigs (
-	signer	char(8) NOT NULL,
-	signee	char(8) NOT NULL
+	signer	char(16) NOT NULL,
+	signee	char(16) NOT NULL
 );