tids: include constraints in database

[trust_router.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index f829ffe..0174159 100644 (file)
--- a/schema.sql
+++ b/schema.sql
@@ -1,4 +1,7 @@
 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);
+
 .quit