[Reconnoiter-devel] [reconnoiter commit] r908 - branches/skeksis/sql/tables

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Tue Sep 29 17:43:29 EDT 2009


Author: robert
Date: 2009-09-29 17:43:28 -0400 (Tue, 29 Sep 2009)
New Revision: 908

Modified:
   branches/skeksis/sql/tables/noit.check_tag.sql
   branches/skeksis/sql/tables/noit.metric_tag.sql
Log:
tag tables

Modified: branches/skeksis/sql/tables/noit.check_tag.sql
===================================================================
--- branches/skeksis/sql/tables/noit.check_tag.sql	2009-09-29 21:15:45 UTC (rev 907)
+++ branches/skeksis/sql/tables/noit.check_tag.sql	2009-09-29 21:43:28 UTC (rev 908)
@@ -1 +1,71 @@
 -- formerly check_tags
+
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = stratcon, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: check_tag; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE check_tag (
+    sid integer NOT NULL,
+    tags_array text[]
+);
+
+
+ALTER TABLE stratcon.check_tag OWNER TO reconnoiter;
+
+--
+-- Name: check_tag_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY check_tag
+    ADD CONSTRAINT check_tag_pkey PRIMARY KEY (sid);
+
+
+--
+-- Name: update_metric_name_summary_fulltext; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter
+--
+
+CREATE TRIGGER update_metric_name_summary_fulltext 
+    AFTER INSERT OR UPDATE ON check_tag
+    FOR EACH ROW
+    EXECUTE PROCEDURE update_mns_via_check_tag();
+
+
+--
+-- Name: check_tag_sid_fkey; Type: FK CONSTRAINT; Schema: stratcon; Owner: reconnoiter
+--
+
+ALTER TABLE ONLY check_tag
+    ADD CONSTRAINT check_tag_sid_fkey FOREIGN KEY (sid) REFERENCES map_uuid_to_sid(sid);
+
+
+--
+-- Name: check_tag; Type: ACL; Schema: stratcon; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE check_tag FROM PUBLIC;
+REVOKE ALL ON TABLE check_tag FROM reconnoiter;
+GRANT ALL ON TABLE check_tag TO reconnoiter;
+GRANT ALL ON TABLE check_tag TO prism;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_tag TO stratcon;
+
+
+--
+-- PostgreSQL database dump complete
+--
+

Modified: branches/skeksis/sql/tables/noit.metric_tag.sql
===================================================================
--- branches/skeksis/sql/tables/noit.metric_tag.sql	2009-09-29 21:15:45 UTC (rev 907)
+++ branches/skeksis/sql/tables/noit.metric_tag.sql	2009-09-29 21:43:28 UTC (rev 908)
@@ -1 +1,71 @@
--- formerly metric_tags 
+- formerly metric_tags 
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = noit, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: metric_tag; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE metric_tag (
+    sid integer NOT NULL,
+    metric_name text NOT NULL,
+    tags_array text[]
+);
+
+
+ALTER TABLE noit.metric_tag OWNER TO reconnoiter;
+
+--
+-- Name: metric_tag_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY metric_tag
+    ADD CONSTRAINT metric_tag_pkey PRIMARY KEY (sid, metric_name);
+
+
+--
+-- Name: trig_update_tsvector_from_metric_tag; Type: TRIGGER; Schema: noit; Owner: reconnoiter
+--
+
+CREATE TRIGGER update_metric_name_summary
+    AFTER INSERT OR UPDATE ON metric_tag
+    FOR EACH ROW
+    EXECUTE PROCEDURE update_mns_via_metric_tag();
+
+
+--
+-- Name: metric_tag_sid_fkey; Type: FK CONSTRAINT; Schema: noit; Owner: reconnoiter
+--
+
+ALTER TABLE ONLY metric_tag
+    ADD CONSTRAINT metric_tag_sid_fkey FOREIGN KEY (sid) REFERENCES map_uuid_to_sid(sid);
+
+
+--
+-- Name: metric_tag; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE metric_tag FROM PUBLIC;
+REVOKE ALL ON TABLE metric_tag FROM reconnoiter;
+GRANT ALL ON TABLE metric_tag TO reconnoiter;
+GRANT ALL ON TABLE metric_tag TO prism;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_tag TO stratcon;
+
+
+--
+-- PostgreSQL database dump complete
+--
+



More information about the Reconnoiter-devel mailing list