summaryrefslogtreecommitdiff
path: root/backend/node/src/clipperz.schema.sql
Unidiff
Diffstat (limited to 'backend/node/src/clipperz.schema.sql') (more/less context) (show whitespace changes)
-rw-r--r--backend/node/src/clipperz.schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/node/src/clipperz.schema.sql b/backend/node/src/clipperz.schema.sql
index 1c2305c..591828a 100644
--- a/backend/node/src/clipperz.schema.sql
+++ b/backend/node/src/clipperz.schema.sql
@@ -1,16 +1,16 @@
1CREATE SCHEMA clipperz; 1CREATE SCHEMA clipperz;
2 2
3CREATE TABLE clipperz.theuser ( 3CREATE TABLE clipperz.theuser (
4 u_id serial PRIMARY KEY, 4 u_id serial PRIMARY KEY,
5 u_name varchar NOT NULL UNIQUE, 5 u_name varchar NOT NULL UNIQUE,
6 u_srp_s varchar NOT NULL, 6 u_srp_s varchar NOT NULL,
7 u_srp_v varchar NOT NULL, 7 u_srp_v varchar NOT NULL,
8 u_header json NOT NULL, 8 u_header varchar NOT NULL,
9 u_statistics varchar NOT NULL, 9 u_statistics varchar NOT NULL,
10 u_authversion varchar NOT NULL, 10 u_authversion varchar NOT NULL,
11 u_version varchar NOT NULL, 11 u_version varchar NOT NULL,
12 u_lock varchar NOT NULL 12 u_lock varchar NOT NULL
13); 13);
14 14
15CREATE TABLE clipperz.therecord ( 15CREATE TABLE clipperz.therecord (
16 r_id serial PRIMARY KEY, 16 r_id serial PRIMARY KEY,
@@ -56,12 +56,12 @@ CREATE TABLE clipperz.theotp (
56 otp_version varchar NOT NULL, 56 otp_version varchar NOT NULL,
57 otp_ctime timestamp NOT NULL DEFAULT current_timestamp, 57 otp_ctime timestamp NOT NULL DEFAULT current_timestamp,
58 otp_rtime timestamp NOT NULL DEFAULT current_timestamp, 58 otp_rtime timestamp NOT NULL DEFAULT current_timestamp,
59 otp_utime timestamp NOT NULL DEFAULT current_timestamp 59 otp_utime timestamp NOT NULL DEFAULT current_timestamp
60); 60);
61 61
62CREATE TABLE clipperz.thesession ( 62CREATE TABLE clipperz.thesession (
63 s_id varchar PRIMARY KEY, 63 s_id varchar PRIMARY KEY,
64 s_data json, 64 s_data varchar,
65 s_ctime timestamp DEFAULT current_timestamp, 65 s_ctime timestamp DEFAULT current_timestamp,
66 s_mtime timestamp DEFAULT current_timestamp 66 s_mtime timestamp DEFAULT current_timestamp
67); 67);