Changeset be06d4c772959d7f67b61729ed0fcfa446eb59a4

Timestamp:

10/16/08 16:17:38 (5 years ago)

Author:

Denish Patel <denish@omniti.com>

git-committer:

Denish Patel <denish@omniti.com> 1224173858 +0000

git-parent:

[715840d4b421a0aa705ef456cbf153bd32651a40]

git-author:

Denish Patel <denish@omniti.com> 1224173858 +0000

Message:

fixed ownership of tables

Files:

• sql/reconnoiter_ddl_dump.sql (modified) (3 diffs)

sql/reconnoiter_ddl_dump.sql

@@ -73 +73 @@
-ALTER TABLE prism.saved_graphs_dep OWNER TO reconnoiter;
-
+--
+-- Name: saved_worksheets; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE saved_worksheets (
+    sheetid uuid NOT NULL,
+    title text,
+    saved boolean DEFAULT false,
+    ts_search_all tsvector,
+    tags text[],
+    last_update timestamp with time zone DEFAULT now() NOT NULL
+);
+
+
+ALTER TABLE prism.saved_worksheets OWNER TO reconnoiter;
+
+--
+-- Name: saved_worksheets_dep; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE saved_worksheets_dep (
+    sheetid uuid NOT NULL,
+    ordering integer NOT NULL,
+    graphid uuid NOT NULL
+);
+
+
+ALTER TABLE prism.saved_worksheets_dep OWNER TO reconnoiter;
+
-SET search_path = public, pg_catalog;
+
+--
+-- Name: foo; Type: TABLE; Schema: public; Owner: omniti; Tablespace: 
+--
+
+CREATE TABLE foo (
+    a timestamp with time zone
+);
+
+
+ALTER TABLE public.foo OWNER TO omniti;
-
-SET default_with_oids = true;
@@ -2142 +2182 @@
-
-
+--
+-- Name: saved_worksheets_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY saved_worksheets
+    ADD CONSTRAINT saved_worksheets_pkey PRIMARY KEY (sheetid);
+
+
-SET search_path = public, pg_catalog;
-
@@ -2547 +2595 @@
-ALTER TABLE ONLY saved_graphs_dep
-    ADD CONSTRAINT saved_graphs_dep_sid_fkey FOREIGN KEY (sid, metric_name, metric_type) REFERENCES stratcon.metric_name_summary(sid, metric_name, metric_type);
+
+
+--
+-- Name: saved_worksheets_dep_graphid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter
+--
+
+ALTER TABLE ONLY saved_worksheets_dep
+    ADD CONSTRAINT saved_worksheets_dep_graphid_fkey FOREIGN KEY (graphid) REFERENCES saved_graphs(graphid);
+
+
+--
+-- Name: saved_worksheets_dep_sheetid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter
+--
+
+ALTER TABLE ONLY saved_worksheets_dep
+    ADD CONSTRAINT saved_worksheets_dep_sheetid_fkey FOREIGN KEY (sheetid) REFERENCES saved_worksheets(sheetid);
-
-