New database layout

1 files 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
@@ -41,12 +41,29 @@ 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,
@@ -72,6 +89,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
 --