From e6a824034c742b9a414d32ecfbcc8531180f93dc Mon Sep 17 00:00:00 2001
From: deva <deva>
Date: Fri, 4 Feb 2011 13:06:52 +0000
Subject: New database layout

---
 server/pracro.psql | 35 +++++++++++++++++++++++++++++++++--
 1 file changed, 33 insertions(+), 2 deletions(-)

diff --git a/server/pracro.psql b/server/pracro.psql
index c7d0785..8211397 100644
--- a/server/pracro.psql
+++ b/server/pracro.psql
@@ -40,13 +40,30 @@ CREATE TABLE fields (
 
 ALTER TABLE public.fields OWNER TO pracro;
 
+--
+-- Name: commits; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
+--
+
+CREATE TABLE commits (
+    patientid text,
+    sessionid text,
+    template text,
+    version text,
+    "timestamp" bigint,
+    uid bigint
+);
+
+
+ALTER TABLE public.commits OWNER TO pracro;
+
 --
 -- Name: transactions; Type: TABLE; Schema: public; Owner: pracro; Tablespace: 
 --
 
 CREATE TABLE transactions (
-    patientid text,
-    transaction text,
+--    patientid text,
+--    template text,
+    cid bigint,
     macro text,
     version text,
     "timestamp" bigint,
@@ -71,6 +88,20 @@ CREATE SEQUENCE trseq
 
 ALTER TABLE public.trseq OWNER TO pracro;
 
+--
+-- Name: sessionseq; Type: SEQUENCE; Schema: public; Owner: pracro
+--
+
+CREATE SEQUENCE sessionseq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.sessionseq OWNER TO pracro;
+
 --
 -- Name: trseq; Type: SEQUENCE SET; Schema: public; Owner: pracro
 --
-- 
cgit v1.2.3