summaryrefslogtreecommitdiff
path: root/server
diff options
context:
space:
mode:
authordeva <deva>2011-02-04 13:06:52 +0000
committerdeva <deva>2011-02-04 13:06:52 +0000
commite6a824034c742b9a414d32ecfbcc8531180f93dc (patch)
treeaca10eaf2448f3dde238f5befb46616501ae2cd3 /server
parent08ee04e6bfa31a1edf823ab27e2519be17c2f633 (diff)
New database layout
Diffstat (limited to 'server')
-rw-r--r--server/pracro.psql35
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
--