summaryrefslogtreecommitdiff
path: root/server
diff options
context:
space:
mode:
authordeva <deva>2011-02-04 13:47:08 +0000
committerdeva <deva>2011-02-04 13:47:08 +0000
commit41dfe02ea86e329bee9137dbdea9a788915b90d3 (patch)
treeadcb2d321ed84b85252e5800ffe99357761139d5 /server
parent6bae4fd17d2660d53279dac9287de52be2a00c6c (diff)
New database layout.
Diffstat (limited to 'server')
-rw-r--r--server/pracro.psql116
1 files changed, 66 insertions, 50 deletions
diff --git a/server/pracro.psql b/server/pracro.psql
index 8211397..5a34e9d 100644
--- a/server/pracro.psql
+++ b/server/pracro.psql
@@ -2,16 +2,47 @@
-- PostgreSQL database dump
--
+SET statement_timeout = 0;
SET client_encoding = 'SQL_ASCII';
-SET standard_conforming_strings = off;
+SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
-SET escape_string_warning = off;
SET search_path = public, pg_catalog;
+--
+-- Name: session_status; Type: TYPE; Schema: public; Owner: pracro
+--
+
+CREATE TYPE session_status AS ENUM (
+ 'active',
+ 'idle',
+ 'committed'
+);
+
+
+ALTER TYPE public.session_status OWNER TO pracro;
+
SET default_tablespace = '';
+SET default_with_oids = false;
+
+--
+-- Name: commits; Type: TABLE; Schema: public; Owner: pracro; Tablespace:
+--
+
+CREATE TABLE commits (
+ patientid text,
+ template text,
+ version text,
+ "timestamp" bigint,
+ uid bigint NOT NULL,
+ status session_status DEFAULT 'committed'::session_status
+);
+
+
+ALTER TABLE public.commits OWNER TO pracro;
+
SET default_with_oids = true;
--
@@ -21,7 +52,9 @@ SET default_with_oids = true;
CREATE TABLE fieldnames (
name text,
description text,
- "timestamp" bigint
+ "timestamp" bigint,
+ "extract" boolean DEFAULT false,
+ caption text
);
@@ -41,34 +74,37 @@ CREATE TABLE fields (
ALTER TABLE public.fields OWNER TO pracro;
--
--- Name: commits; Type: TABLE; Schema: public; Owner: pracro; Tablespace:
+-- Name: sessionseq; Type: SEQUENCE; Schema: public; Owner: pracro
--
-CREATE TABLE commits (
- patientid text,
- sessionid text,
- template text,
- version text,
- "timestamp" bigint,
- uid bigint
-);
+CREATE SEQUENCE sessionseq
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
-ALTER TABLE public.commits OWNER TO pracro;
+ALTER TABLE public.sessionseq OWNER TO pracro;
+
+--
+-- Name: sessionseq; Type: SEQUENCE SET; Schema: public; Owner: pracro
+--
+
+SELECT pg_catalog.setval('sessionseq', 433, true);
+
--
-- Name: transactions; Type: TABLE; Schema: public; Owner: pracro; Tablespace:
--
CREATE TABLE transactions (
--- patientid text,
--- template text,
- cid bigint,
macro text,
version text,
"timestamp" bigint,
"user" text,
- uid bigint
+ uid bigint NOT NULL,
+ cid bigint
);
@@ -89,48 +125,26 @@ 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
--
-SELECT pg_catalog.setval('trseq', 1, false);
-
-
---
--- Data for Name: fieldnames; Type: TABLE DATA; Schema: public; Owner: pracro
---
-
-COPY fieldnames (name, description, "timestamp") FROM stdin;
-\.
+SELECT pg_catalog.setval('trseq', 2490, true);
--
--- Data for Name: fields; Type: TABLE DATA; Schema: public; Owner: pracro
+-- Name: commits_pkey; Type: CONSTRAINT; Schema: public; Owner: pracro; Tablespace:
--
-COPY fields (transaction, name, value) FROM stdin;
-\.
+ALTER TABLE ONLY commits
+ ADD CONSTRAINT commits_pkey PRIMARY KEY (uid);
--
--- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: pracro
+-- Name: transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: pracro; Tablespace:
--
-COPY transactions (patientid, macro, version, "timestamp", "user", uid) FROM stdin;
-\.
+ALTER TABLE ONLY transactions
+ ADD CONSTRAINT transactions_pkey PRIMARY KEY (uid);
--
@@ -148,17 +162,19 @@ CREATE INDEX x_fields_name_tid ON fields USING btree (name, transaction);
--
--- Name: x_transaction_patientid_macro_ts; Type: INDEX; Schema: public; Owner: pracro; Tablespace:
+-- Name: cid; Type: FK CONSTRAINT; Schema: public; Owner: pracro
--
-CREATE INDEX x_transaction_patientid_macro_ts ON transactions USING btree (patientid, macro, "timestamp");
+ALTER TABLE ONLY transactions
+ ADD CONSTRAINT cid FOREIGN KEY (cid) REFERENCES commits(uid) MATCH FULL ON DELETE CASCADE;
--
--- Name: x_transaction_patientid_ts; Type: INDEX; Schema: public; Owner: pracro; Tablespace:
+-- Name: transaction; Type: FK CONSTRAINT; Schema: public; Owner: pracro
--
-CREATE INDEX x_transaction_patientid_ts ON transactions USING btree (patientid, "timestamp");
+ALTER TABLE ONLY fields
+ ADD CONSTRAINT transaction FOREIGN KEY (transaction) REFERENCES transactions(uid) MATCH FULL ON DELETE CASCADE;
--