summaryrefslogtreecommitdiffabout
path: root/test/RP-db.sql
authorMichael Krelin <hacker@klever.net>2008-01-20 21:10:23 (UTC)
committer Michael Krelin <hacker@klever.net>2008-01-20 21:10:23 (UTC)
commitd16e79b1c792352eade736e7080c401a6c7ace03 (patch) (side-by-side diff)
tree545a905ab8ef5c2a2135c17d2f949556b354b842 /test/RP-db.sql
parent9bfb6fadf71c46bf4cb5adabba0c96c32e84c1bc (diff)
downloadlibopkele-d16e79b1c792352eade736e7080c401a6c7ace03.zip
libopkele-d16e79b1c792352eade736e7080c401a6c7ace03.tar.gz
libopkele-d16e79b1c792352eade736e7080c401a6c7ace03.tar.bz2
test part rewritten
* cut down test.cc to only test rfc uri normalization * redone idiscover to only list discovered endpoints * added test RP cgi Signed-off-by: Michael Krelin <hacker@klever.net>
Diffstat (limited to 'test/RP-db.sql') (more/less context) (ignore whitespace changes)
-rw-r--r--test/RP-db.sql37
1 files changed, 37 insertions, 0 deletions
diff --git a/test/RP-db.sql b/test/RP-db.sql
new file mode 100644
index 0000000..71a82d4
--- a/dev/null
+++ b/test/RP-db.sql
@@ -0,0 +1,37 @@
+CREATE TABLE assoc (
+ a_op text,
+ a_handle text NOT NULL,
+ a_type text DEFAULT 'HMAC-SHA1',
+ a_ctime text NOT NULL,
+ a_etime text NOT NULL,
+ a_secret text NOT NULL,
+ a_stateless integer NOT NULL DEFAULT 0,
+ a_itime integer,
+ UNIQUE(a_op,a_handle)
+);
+
+CREATE TABLE nonces (
+ n_op text NOT NULL,
+ n_once text NOT NULL,
+ PRIMARY KEY (n_op,n_once)
+);
+
+CREATE TABLE ht_sessions (
+ hts_id text NOT NULL PRIMARY KEY
+);
+
+CREATE TABLE auth_sessions (
+ as_id integer PRIMARY KEY AUTOINCREMENT,
+ hts_id text NOT NULL REFERENCES ht_sessions(hts_id),
+ as_normalized_id text,
+ UNIQUE (hts_id,as_id)
+);
+
+CREATE TABLE endpoints_queue (
+ as_id integer NOT NULL REFERENCES auth_sessions (as_id),
+ eq_ctime integer NOT NULL,
+ eq_ordinal integer NOT NULL,
+ eq_uri text,
+ eq_claimed_id text,
+ eq_local_id text
+);