File: OP-db.sql

package info (click to toggle)
libopkele 2.0.4-5.3
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 1,884 kB
  • sloc: sh: 10,137; cpp: 4,879; makefile: 126; xml: 82; ansic: 70; sql: 55
file content (25 lines) | stat: -rw-r--r-- 475 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
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_once text NOT NULL PRIMARY KEY,
 n_itime integer
);

CREATE TABLE setup (
 s_password text
);

CREATE TABLE ht_sessions (
 hts_id text NOT NULL PRIMARY KEY,
 authorized integer NOT NULL DEFAULT 0
);