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

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Tue Sep 29 16:48:20 EDT 2009


Author: robert
Date: 2009-09-29 16:48:20 -0400 (Tue, 29 Sep 2009)
New Revision: 904

Added:
   branches/skeksis/sql/tables/noit.check_currently.sql
Modified:
   branches/skeksis/sql/tables/noit.check_archive.sql
Log:
layout of primary check tables

Modified: branches/skeksis/sql/tables/noit.check_archive.sql
===================================================================
--- branches/skeksis/sql/tables/noit.check_archive.sql	2009-09-29 20:22:36 UTC (rev 903)
+++ branches/skeksis/sql/tables/noit.check_archive.sql	2009-09-29 20:48:20 UTC (rev 904)
@@ -1 +1,66 @@
--- formerly loading_dock_check_s
+--
+-- 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: check_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE check_archive (
+    sid integer NOT NULL,
+    remote_address inet,
+    whence timestamp with time zone NOT NULL,
+    id uuid NOT NULL,
+    target text NOT NULL,
+    module text NOT NULL,
+    name text NOT NULL
+);
+
+
+ALTER TABLE noit.check_archive OWNER TO reconnoiter;
+
+--
+-- Name: check_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY check_archive
+    ADD CONSTRAINT check_archive_pkey PRIMARY KEY (sid, id, whence);
+
+
+--
+-- Name: mv_check_archive; Type: TRIGGER; Schema: noit; Owner: reconnoiter
+--
+
+CREATE TRIGGER check_archive_log_changes
+    AFTER INSERT ON check_archive
+    FOR EACH ROW
+    EXECUTE PROCEDURE check_archive_log_changes();
+
+
+--
+-- Name: check_archive; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE check_archive FROM PUBLIC;
+REVOKE ALL ON TABLE check_archive FROM reconnoiter;
+GRANT ALL ON TABLE check_archive TO reconnoiter;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_archive TO noit;
+GRANT SELECT ON TABLE check_archive TO prism;
+
+
+--
+-- PostgreSQL database dump complete
+--
+

Copied: branches/skeksis/sql/tables/noit.check_currently.sql (from rev 903, branches/skeksis/sql/tables/noit.check_changelog.sql)
===================================================================
--- branches/skeksis/sql/tables/noit.check_currently.sql	                        (rev 0)
+++ branches/skeksis/sql/tables/noit.check_currently.sql	2009-09-29 20:48:20 UTC (rev 904)
@@ -0,0 +1,74 @@
+-- formerly mv_loading_dock_check_s 
+
+--
+-- 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: check_currently; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE check_currently (
+    sid integer NOT NULL,
+    remote_address inet,
+    whence timestamp with time zone NOT NULL,
+    id uuid NOT NULL,
+    target text NOT NULL,
+    module text NOT NULL,
+    name text NOT NULL
+);
+
+
+ALTER TABLE noit.check_currently OWNER TO reconnoiter;
+
+--
+-- Name: check_currently_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY check_currently
+    ADD CONSTRAINT check_currently_pkey PRIMARY KEY (sid);
+
+--
+-- Name: check_currently_uidx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE UNIQUE INDEX ucheck_currently_id_uidx ON check_currently USING btree (id);
+
+
+--
+-- Name: trig_update_tsvector_from_mv_dock; Type: TRIGGER; Schema: noit; Owner: reconnoiter
+--
+
+CREATE TRIGGER update_metric_summary_fulltext 
+    AFTER INSERT OR UPDATE ON check_currently
+    FOR EACH ROW
+    EXECUTE PROCEDURE update_metric_summary_fulltext();
+
+
+--
+-- Name: check_currently; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE check_currently FROM PUBLIC;
+REVOKE ALL ON TABLE check_currently FROM reconnoiter;
+GRANT ALL ON TABLE check_currently TO reconnoiter;
+GRANT SELECT ON TABLE check_currently TO prism;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_currently TO stratcon;
+
+
+--
+-- PostgreSQL database dump complete
+--
+



More information about the Reconnoiter-devel mailing list