root/sql/tables/noit.metric_numeric_rollup_config.sql

Revision 30843e711d79e7e70d0c0e014c94bba11cb0b642, 1.7 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 4 years ago)

fix bugs -- all appears to work as expected now

  • Property mode set to 100644
Line 
1
2 set search_path=noit,pg_catalog;
3
4 --
5 -- Name: metric_numeric_rollup_config; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
6 --
7
8 CREATE TABLE metric_numeric_rollup_config (
9     rollup text NOT NULL,
10     seconds integer NOT NULL,
11     dependent_on text,
12     span integer NOT NULL
13 );
14
15
16 ALTER TABLE metric_numeric_rollup_config OWNER TO reconnoiter;
17
18 --
19 -- Data for Name: metric_numeric_rollup_config; Type: TABLE DATA; Schema: noit; Owner: reconnoiter
20 --
21
22 INSERT INTO metric_numeric_rollup_config VALUES ('5m', 300, NULL, 86400);
23 INSERT INTO metric_numeric_rollup_config VALUES ('20m', 1200, '5m', 604800);
24 INSERT INTO metric_numeric_rollup_config VALUES ('30m', 1800, '5m', 1209600);
25 INSERT INTO metric_numeric_rollup_config VALUES ('1hour', 3600, '30m', 2592000);
26 INSERT INTO metric_numeric_rollup_config VALUES ('4hour', 14400, '1hour', 7862400);
27 INSERT INTO metric_numeric_rollup_config VALUES ('1day', 86400, '4hour', 31536000);
28
29 --
30 -- Name: metric_numeric_rollup_config_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
31 --
32
33 ALTER TABLE ONLY metric_numeric_rollup_config
34     ADD CONSTRAINT metric_numeric_rollup_config_pkey PRIMARY KEY (rollup);
35
36 --
37 -- Name: metric_numeric_rollup_config_dependent_on_fkey; Type: FK CONSTRAINT; Schema: noit; Owner: reconnoiter
38 --
39
40 ALTER TABLE ONLY metric_numeric_rollup_config
41     ADD CONSTRAINT metric_numeric_rollup_config_dependent_on_fkey FOREIGN KEY (dependent_on) REFERENCES metric_numeric_rollup_config(rollup);
42
43
44 REVOKE ALL ON TABLE metric_numeric_rollup_config FROM PUBLIC;
45 REVOKE ALL ON TABLE metric_numeric_rollup_config FROM prism;
46 GRANT SELECT ON TABLE metric_numeric_rollup_config TO stratcon;
47
48 --
49 -- PostgreSQL database dump complete
50 --
Note: See TracBrowser for help on using the browser.