summaryrefslogtreecommitdiff
path: root/backend/node/src/clipperz.schema.sql
authorMichael Krelin <hacker@klever.net>2013-11-27 17:11:26 (UTC)
committer Michael Krelin <hacker@klever.net>2013-11-27 17:11:26 (UTC)
commit0f1cc2ac41835ee8fa5dded1593fa95092b54bbe (patch) (side-by-side diff)
tree8563cd1578aad126c803be452dedd3b9dd9e0921 /backend/node/src/clipperz.schema.sql
parentb59defff1efe85e43850243910007dd1fe3a4ef2 (diff)
downloadclipperz-0f1cc2ac41835ee8fa5dded1593fa95092b54bbe.zip
clipperz-0f1cc2ac41835ee8fa5dded1593fa95092b54bbe.tar.gz
clipperz-0f1cc2ac41835ee8fa5dded1593fa95092b54bbe.tar.bz2
switched postgresql schema from json type to plaintext
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
@@ -5,7 +5,7 @@ CREATE TABLE clipperz.theuser (
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,
@@ -61,7 +61,7 @@ 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
);