X-Git-Url: http://www.project-moonshot.org/gitweb/?a=blobdiff_plain;f=schema.sql;h=6ae869067d2ae36c26bfc5030f358a10fcf10403;hb=refs%2Fheads%2Fhartmans%2Frefactor;hp=f829ffec0cdcc0c298a70cfbae8d265b5ef6707e;hpb=34802d5d6365fa47ceab128bb5f10e10ba35a29e;p=trust_router.git

diff --git a/schema.sql b/schema.sql
index f829ffe..6ae8690 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,4 +1,9 @@
 create table if not exists psk_keys (keyid text primary key, key blob, client_dh_pub raw(20));
+create table if not exists authorizations( client_dh_pub raw(20), coi string, acceptor_realm string, hostname string, apc string);
+create index if not exists authorizations_dhpub on authorizations( client_dh_pub);
+CREATE VIEW if not exists authorizations_keys as select keyid, authorizations.* from psk_keys join authorizations on psk_keys.client_dh_pub = authorizations.client_dh_pub;
+ 
+
 .quit