Changeset 515

Timestamp:

11/04/08 15:23:11 (2 months ago)

Author:

denish

Message:

prism.saved_graphs triggers adjustments

Files:

• trunk/sql/reconnoiter_ddl_dump.sql (modified) (9 diffs)

trunk/sql/reconnoiter_ddl_dump.sql

@@ -41 +41 @@
-
-SET default_with_oids = false;
+
+--
+-- Name: graph_templates; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE graph_templates (
+    templateid uuid NOT NULL,
+    title text NOT NULL,
+    json text NOT NULL
+);
+
+
+ALTER TABLE prism.graph_templates OWNER TO reconnoiter;
-
---
@@ -746 +759 @@
-
---
--- Name: trig_before_tsvector_saved_graphs(); Type: FUNCTION; Schema: prism; Owner: postgres
---
-
-CREATE FUNCTION trig_before_tsvector_saved_graphs() RETURNS trigger
-    AS $$
-DECLARE
- BEGIN
-   NEW.ts_search_all:= to_tsvector(NEW.title);
-     RETURN NEW;
- END
-$$
-    LANGUAGE plpgsql;
-
-
-ALTER FUNCTION prism.trig_before_tsvector_saved_graphs() OWNER TO postgres;
-
---
--- Name: trig_update_tsvector_saved_graphs(); Type: FUNCTION; Schema: prism; Owner: reconnoiter
---
@@ -770 +766 @@
-DECLARE
- BEGIN
+ IF TG_OP = 'UPDATE' THEN
-   IF (NEW.graph_tags <> OLD.graph_tags OR NEW.title <> OLD.title) THEN
-UPDATE prism.saved_graphs SET ts_search_all=prism.saved_graphs_tsvector(NEW.graphid) where graphid=NEW.graphid;
+NEW.ts_search_all=prism.saved_graphs_tsvector(NEW.graphid); 
-   END IF;    
+ ELSE
+     NEW.ts_search_all = to_tsvector(NEW.title); 
+ END IF;  
-   RETURN NEW;
-END
@@ -2167 +2167 @@
-
---
+-- Name: graph_templates_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY graph_templates
+    ADD CONSTRAINT graph_templates_pkey PRIMARY KEY (templateid);
+
+
+--
+-- Name: graph_templates_title_key; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY graph_templates
+    ADD CONSTRAINT graph_templates_title_key UNIQUE (title);
+
+
+--
--- Name: saved_graphs_dep_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace: 
---
@@ -2180 +2196 @@
-ALTER TABLE ONLY saved_graphs
-    ADD CONSTRAINT saved_graphs_pkey PRIMARY KEY (graphid);
+
+
+--
+-- Name: saved_graphs_title_key; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY saved_graphs
+    ADD CONSTRAINT saved_graphs_title_key UNIQUE (title);
-
-
@@ -2488 +2512 @@
-
---
--- Name: trig_before_tsvector_saved_graphs; Type: TRIGGER; Schema: prism; Owner: reconnoiter
---
-
-CREATE TRIGGER trig_before_tsvector_saved_graphs
-    BEFORE INSERT ON saved_graphs
-    FOR EACH ROW
-    EXECUTE PROCEDURE trig_before_tsvector_saved_graphs();
-
-
---
--- Name: trig_update_tsvector_saved_graphs; Type: TRIGGER; Schema: prism; Owner: reconnoiter
---
-
-CREATE TRIGGER trig_update_tsvector_saved_graphs
-AFTE
+BEFORE INSERT O
-    FOR EACH ROW
-    EXECUTE PROCEDURE trig_update_tsvector_saved_graphs();
@@ -2582 +2596 @@
-
---
-graphid_fk
+saved_graphs_dep_graphid_fkey
---
-
-ALTER TABLE ONLY saved_graphs_dep
-graphid_fk FOREIGN KEY (graphid) REFERENCES saved_graphs(graphid)
+saved_graphs_dep_graphid_fkey FOREIGN KEY (graphid) REFERENCES saved_graphs(graphid) ON DELETE CASCADE
-
-
@@ -2634 +2648 @@
-
---
+-- Name: graph_templates; Type: ACL; Schema: prism; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE graph_templates FROM PUBLIC;
+REVOKE ALL ON TABLE graph_templates FROM reconnoiter;
+GRANT ALL ON TABLE graph_templates TO reconnoiter;
+GRANT ALL ON TABLE graph_templates TO prism;
+
+
+--
--- Name: saved_graphs; Type: ACL; Schema: prism; Owner: reconnoiter
---
@@ -2651 +2675 @@
-GRANT ALL ON TABLE saved_graphs_dep TO reconnoiter;
-GRANT ALL ON TABLE saved_graphs_dep TO prism;
+
+
+--
+-- Name: saved_worksheets; Type: ACL; Schema: prism; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE saved_worksheets FROM PUBLIC;
+REVOKE ALL ON TABLE saved_worksheets FROM reconnoiter;
+GRANT ALL ON TABLE saved_worksheets TO reconnoiter;
+GRANT ALL ON TABLE saved_worksheets TO prism;
+
+
+--
+-- Name: saved_worksheets_dep; Type: ACL; Schema: prism; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE saved_worksheets_dep FROM PUBLIC;
+REVOKE ALL ON TABLE saved_worksheets_dep FROM reconnoiter;
+GRANT ALL ON TABLE saved_worksheets_dep TO reconnoiter;
+GRANT ALL ON TABLE saved_worksheets_dep TO prism;
-
-