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.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/backend/node/src/clipperz.schema.sql b/backend/node/src/clipperz.schema.sql
index ba6f482..1c2305c 100644
--- a/backend/node/src/clipperz.schema.sql
+++ b/backend/node/src/clipperz.schema.sql
@@ -58,3 +58,10 @@ CREATE TABLE clipperz.theotp (
otp_rtime timestamp NOT NULL DEFAULT current_timestamp,
otp_utime timestamp NOT NULL DEFAULT current_timestamp
);
+
+CREATE TABLE clipperz.thesession (
+ s_id varchar PRIMARY KEY,
+ s_data json,
+ s_ctime timestamp DEFAULT current_timestamp,
+ s_mtime timestamp DEFAULT current_timestamp
+);