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

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Thu Oct 22 22:24:04 EDT 2009


Author: robert
Date: 2009-10-22 22:24:03 -0400 (Thu, 22 Oct 2009)
New Revision: 996

Added:
   branches/skeksis/sql/tables/noit.metric_numeric_rollup_config.sql
Log:
config table for doing rollups, with default rollups

Added: branches/skeksis/sql/tables/noit.metric_numeric_rollup_config.sql
===================================================================
--- branches/skeksis/sql/tables/noit.metric_numeric_rollup_config.sql	                        (rev 0)
+++ branches/skeksis/sql/tables/noit.metric_numeric_rollup_config.sql	2009-10-23 02:24:03 UTC (rev 996)
@@ -0,0 +1,61 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+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_numeric_rollup_config; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE TABLE metric_numeric_rollup_config (
+    rollup text NOT NULL,
+    seconds integer NOT NULL,
+    dependent_on text,
+    span integer NOT NULL
+);
+
+
+ALTER TABLE noit.metric_numeric_rollup_config OWNER TO reconnoiter;
+
+--
+-- Data for Name: metric_numeric_rollup_config; Type: TABLE DATA; Schema: noit; Owner: reconnoiter
+--
+
+INSERT INTO metric_numeric_rollup_config VALUES ('5m', 300, NULL, 86400);
+INSERT INTO metric_numeric_rollup_config VALUES ('20m', 1200, '5m', 604800);
+INSERT INTO metric_numeric_rollup_config VALUES ('30m', 1800, '5m', 1209600);
+INSERT INTO metric_numeric_rollup_config VALUES ('4h', 1440, '1h', 7862400);
+INSERT INTO metric_numeric_rollup_config VALUES ('1d', 86400, '4h', 31536000);
+INSERT INTO metric_numeric_rollup_config VALUES ('1h', 3600, '30m', 2592000);
+
+--
+-- Name: metric_numeric_rollup_config_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 
+--
+
+ALTER TABLE ONLY metric_numeric_rollup_config
+    ADD CONSTRAINT metric_numeric_rollup_config_pkey PRIMARY KEY (rollup);
+
+
+--
+-- Name: metric_numeric_rollup_config_dependent_on_fkey; Type: FK CONSTRAINT; Schema: noit; Owner: reconnoiter
+--
+
+ALTER TABLE ONLY metric_numeric_rollup_config
+    ADD CONSTRAINT metric_numeric_rollup_config_dependent_on_fkey FOREIGN KEY (dependent_on) REFERENCES metric_numeric_rollup_config(rollup);
+
+
+--
+-- PostgreSQL database dump complete
+--



More information about the Reconnoiter-devel mailing list