From 352f2216eec032efce4bdeddd2ffe5a9e326a99d Mon Sep 17 00:00:00 2001
From: Michael Krelin <hacker@klever.net>
Date: Mon, 25 Nov 2013 20:52:38 +0000
Subject: postgresql-based clipperz own session store

the use thereof is not mandatory, but may come in handy for the
standalone deployment
---
(limited to 'backend/node/src/clipperz.schema.sql')

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
+);
--
cgit v0.9.0.2