diff options
Diffstat (limited to 'server/initdb.psql')
-rw-r--r-- | server/initdb.psql | 149 |
1 files changed, 0 insertions, 149 deletions
diff --git a/server/initdb.psql b/server/initdb.psql deleted file mode 100644 index b1678c5..0000000 --- a/server/initdb.psql +++ /dev/null @@ -1,149 +0,0 @@ --- --- PostgreSQL database dump --- - -SET client_encoding = 'SQL_ASCII'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; - -SET search_path = public, pg_catalog; - -SET default_tablespace = ''; - -SET default_with_oids = true; - --- --- Name: fieldnames; Type: TABLE; Schema: public; Owner: pracro; Tablespace: --- - -DROP TABLE IF EXISTS fieldnames; -CREATE TABLE fieldnames ( - name text, - description text, - "timestamp" bigint -); - - -ALTER TABLE public.fieldnames OWNER TO pracro; - --- --- Name: fields; Type: TABLE; Schema: public; Owner: pracro; Tablespace: --- - -DROP TABLE IF EXISTS fields; -CREATE TABLE fields ( - transaction bigint, - name text, - value text -); - - -ALTER TABLE public.fields OWNER TO pracro; - --- --- Name: transactions; Type: TABLE; Schema: public; Owner: pracro; Tablespace: --- - -DROP TABLE IF EXISTS transactions; -CREATE TABLE transactions ( - patientid text, - macro text, - version text, - "timestamp" bigint, - "user" text, - uid bigint -); - - -ALTER TABLE public.transactions OWNER TO pracro; - --- --- Name: trseq; Type: SEQUENCE; Schema: public; Owner: pracro --- - -DROP SEQUENCE IF EXISTS trseq; -CREATE SEQUENCE trseq - START WITH 1 - INCREMENT BY 1 - NO MAXVALUE - NO MINVALUE - CACHE 1; - - -ALTER TABLE public.trseq 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; -\. - - --- --- Data for Name: fields; Type: TABLE DATA; Schema: public; Owner: pracro --- - -COPY fields (transaction, name, value) FROM stdin; -\. - - --- --- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: pracro --- - -COPY transactions (patientid, macro, version, "timestamp", "user", uid) FROM stdin; -\. - - --- --- Name: x_fieldnames_name; Type: INDEX; Schema: public; Owner: pracro; Tablespace: --- - -CREATE INDEX x_fieldnames_name ON fieldnames USING btree (name); - - --- --- Name: x_fields_name_tid; Type: INDEX; Schema: public; Owner: pracro; Tablespace: --- - -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: --- - -CREATE INDEX x_transaction_patientid_macro_ts ON transactions USING btree (patientid, macro, "timestamp"); - - --- --- Name: x_transaction_patientid_ts; Type: INDEX; Schema: public; Owner: pracro; Tablespace: --- - -CREATE INDEX x_transaction_patientid_ts ON transactions USING btree (patientid, "timestamp"); - - --- --- Name: public; Type: ACL; Schema: -; Owner: postgres --- - -REVOKE ALL ON SCHEMA public FROM PUBLIC; -REVOKE ALL ON SCHEMA public FROM postgres; -GRANT ALL ON SCHEMA public TO postgres; -GRANT ALL ON SCHEMA public TO PUBLIC; - - --- --- PostgreSQL database dump complete --- - |