From 0f1cc2ac41835ee8fa5dded1593fa95092b54bbe Mon Sep 17 00:00:00 2001
From: Michael Krelin <hacker@klever.net>
Date: Wed, 27 Nov 2013 17:11:26 +0000
Subject: switched postgresql schema from json type to plaintext

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