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

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Tue Sep 29 18:22:19 EDT 2009


Author: robert
Date: 2009-09-29 18:22:18 -0400 (Tue, 29 Sep 2009)
New Revision: 910

Modified:
   branches/skeksis/sql/tables/noit.metric_text_archive.sql
   branches/skeksis/sql/tables/noit.metric_text_changelog.sql
   branches/skeksis/sql/tables/noit.metric_text_currently.sql
Log:
text metric tables

Modified: branches/skeksis/sql/tables/noit.metric_text_archive.sql
===================================================================
--- branches/skeksis/sql/tables/noit.metric_text_archive.sql	2009-09-29 21:53:51 UTC (rev 909)
+++ branches/skeksis/sql/tables/noit.metric_text_archive.sql	2009-09-29 22:22:18 UTC (rev 910)
@@ -1 +1,63 @@
--- loading_dock_metric_text_archive
+-- formerly loading_dock_metric_text_archive 
+
+--
+-- 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_text_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE metric_text_archive (
+    sid integer NOT NULL,
+    whence timestamp with time zone NOT NULL,
+    name text NOT NULL,
+    value text
+);
+
+
+ALTER TABLE noit.metric_text_archive OWNER TO reconnoiter;
+
+--
+-- Name: metric_text_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY metric_text_archive
+    ADD CONSTRAINT metric_text_archive_pkey PRIMARY KEY (whence, sid, name);
+
+--
+-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: noit; Owner: reconnoiter
+--
+
+CREATE TRIGGER metric_text_archive_log_changes
+    AFTER INSERT ON metric_text_archive
+    FOR EACH ROW
+    EXECUTE PROCEDURE metric_text_archive_log_changes();
+
+
+--
+-- Name: metric_text_archive; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE metric_text_archive FROM PUBLIC;
+REVOKE ALL ON TABLE metric_text_archive FROM reconnoiter;
+GRANT ALL ON TABLE metric_text_archive TO reconnoiter;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_archive TO stratcon;
+GRANT SELECT ON TABLE metric_text_archive TO prism;
+
+
+--
+-- PostgreSQL database dump complete
+--

Modified: branches/skeksis/sql/tables/noit.metric_text_changelog.sql
===================================================================
--- branches/skeksis/sql/tables/noit.metric_text_changelog.sql	2009-09-29 21:53:51 UTC (rev 909)
+++ branches/skeksis/sql/tables/noit.metric_text_changelog.sql	2009-09-29 22:22:18 UTC (rev 910)
@@ -1 +1,61 @@
--- loading_dock_metric_text_s_changelog 
+-- loading_dock_metric_text_s_change_log
+--
+-- 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_text_changelog; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE metric_text_changelog (
+    sid integer NOT NULL,
+    whence timestamp with time zone NOT NULL,
+    name text NOT NULL,
+    value text
+);
+
+
+ALTER TABLE noit.metric_text_changelog OWNER TO reconnoiter;
+
+--
+-- Name: metric_text_changelog_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY metric_text_changelog
+    ADD CONSTRAINT metric_text_changelog_pkey PRIMARY KEY (whence, sid, name);
+
+
+--
+-- Name: xx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE INDEX metric_text_changelog_sid_name_whence_idx ON metric_text_changelog USING btree (sid, name, whence);
+
+
+--
+-- Name: metric_text_changelog; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE metric_text_changelog FROM PUBLIC;
+REVOKE ALL ON TABLE metric_text_changelog FROM reconnoiter;
+GRANT ALL ON TABLE metric_text_changelog TO reconnoiter;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_changelog TO stratcon;
+GRANT SELECT ON TABLE metric_text_changelog TO prism;
+
+
+--
+-- PostgreSQL database dump complete
+--
+

Modified: branches/skeksis/sql/tables/noit.metric_text_currently.sql
===================================================================
--- branches/skeksis/sql/tables/noit.metric_text_currently.sql	2009-09-29 21:53:51 UTC (rev 909)
+++ branches/skeksis/sql/tables/noit.metric_text_currently.sql	2009-09-29 22:22:18 UTC (rev 910)
@@ -1 +1,54 @@
 --formerly current_metric_text 
+--
+-- 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_text_currently; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE metric_text_currently (
+    sid integer NOT NULL,
+    whence timestamp with time zone NOT NULL,
+    name text NOT NULL,
+    value text
+);
+
+
+ALTER TABLE noit.metric_text_currently OWNER TO reconnoiter;
+
+--
+-- Name: metric_text_currently_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY metric_text_currently
+    ADD CONSTRAINT metric_text_currently_pkey PRIMARY KEY (sid, name);
+
+
+--
+-- Name: metric_text_currently; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON TABLE metric_text_currently FROM PUBLIC;
+REVOKE ALL ON TABLE metric_text_currently FROM reconnoiter;
+GRANT ALL ON TABLE metric_text_currently TO reconnoiter;
+GRANT SELECT ON TABLE metric_text_currently TO prism;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_currently TO stratcon;
+
+
+--
+-- PostgreSQL database dump complete
+--
+



More information about the Reconnoiter-devel mailing list