summaryrefslogtreecommitdiff
path: root/backend/node/src/clipperz.schema.sql
Side-by-side diff
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
@@ -4,9 +4,9 @@ CREATE TABLE clipperz.theuser (
u_id serial PRIMARY KEY,
u_name varchar NOT NULL UNIQUE,
u_srp_s varchar NOT NULL,
u_srp_v varchar NOT NULL,
- u_header json NOT NULL,
+ u_header varchar NOT NULL,
u_statistics varchar NOT NULL,
u_authversion varchar NOT NULL,
u_version varchar NOT NULL,
u_lock varchar NOT NULL
@@ -60,8 +60,8 @@ CREATE TABLE clipperz.theotp (
);
CREATE TABLE clipperz.thesession (
s_id varchar PRIMARY KEY,
- s_data json,
+ s_data varchar,
s_ctime timestamp DEFAULT current_timestamp,
s_mtime timestamp DEFAULT current_timestamp
);