summaryrefslogtreecommitdiffabout
path: root/test/OP-db.sql
Unidiff
Diffstat (limited to 'test/OP-db.sql') (more/less context) (ignore whitespace changes)
-rw-r--r--test/OP-db.sql25
1 files changed, 25 insertions, 0 deletions
diff --git a/test/OP-db.sql b/test/OP-db.sql
new file mode 100644
index 0000000..424b5ff
--- a/dev/null
+++ b/test/OP-db.sql
@@ -0,0 +1,25 @@
1CREATE TABLE assoc (
2 a_op text,
3 a_handle text NOT NULL,
4 a_type text DEFAULT 'HMAC-SHA1',
5 a_ctime text NOT NULL,
6 a_etime text NOT NULL,
7 a_secret text NOT NULL,
8 a_stateless integer NOT NULL DEFAULT 0,
9 a_itime integer,
10 UNIQUE(a_op,a_handle)
11);
12
13CREATE TABLE nonces (
14 n_once text NOT NULL PRIMARY KEY,
15 n_itime integer
16);
17
18CREATE TABLE setup (
19 s_password text
20);
21
22CREATE TABLE ht_sessions (
23 hts_id text NOT NULL PRIMARY KEY,
24 authorized integer NOT NULL DEFAULT 0
25);