summaryrefslogtreecommitdiff
path: root/backend/node/src/clipperz.schema.sql
Unidiff
Diffstat (limited to 'backend/node/src/clipperz.schema.sql') (more/less context) (ignore 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
@@ -2,13 +2,13 @@ CREATE 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
@@ -58,10 +58,10 @@ CREATE TABLE clipperz.theotp (
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);