From 570b69de62cf780bf86d81756fddbcaa61af05f1 Mon Sep 17 00:00:00 2001
From: deva <deva>
Date: Fri, 3 Jul 2009 13:54:58 +0000
Subject: Removed initdb file and corrected pracro.psql

---
 server/initdb.psql | 149 -----------------------------------------------------
 1 file changed, 149 deletions(-)
 delete mode 100644 server/initdb.psql

(limited to 'server/initdb.psql')

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
---
-
-- 
cgit v1.2.3