summaryrefslogtreecommitdiff
path: root/server
diff options
context:
space:
mode:
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
--