root/sql/tables/noit.metric_numeric_rollup_30m.sql

Revision bd7ae6bdfb27483bdc6fab6971aa4dfd1beb52d3, 1.3 kB (checked in by Robert Treat <robert@omniti.com>, 9 years ago)

synch rollup tables with desired reality

  • Property mode set to 100644
Line 
1 --
2 -- PostgreSQL database dump
3 --
4
5 SET client_encoding = 'UTF8';
6 SET standard_conforming_strings = off;
7 SET check_function_bodies = false;
8 SET client_min_messages = warning;
9 SET escape_string_warning = off;
10
11 SET search_path = noit, pg_catalog;
12
13 SET default_tablespace = '';
14
15 SET default_with_oids = false;
16
17 --
18 -- Name: metric_numeric_rollup_30m; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
19 --
20
21 CREATE TABLE metric_numeric_rollup_30m (
22     sid integer NOT NULL,
23     name text NOT NULL,
24     rollup_time timestamp with time zone NOT NULL,
25     count_rows integer[],
26     avg_value numeric[],
27     counter_dev numeric[]
28 );
29
30
31 ALTER TABLE noit.metric_numeric_rollup_30m OWNER TO reconnoiter;
32
33 --
34 -- Name: metric_numeric_rollup_30m_new_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
35 --
36
37 ALTER TABLE ONLY metric_numeric_rollup_30m
38     ADD CONSTRAINT metric_numeric_rollup_30m_pkey PRIMARY KEY (rollup_time, sid, name);
39
40
41 --
42 -- Name: metric_numeric_rollup_30m; Type: ACL; Schema: noit; Owner: reconnoiter
43 --
44
45 REVOKE ALL ON TABLE metric_numeric_rollup_30m FROM PUBLIC;
46 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_30m TO stratcon;
47 GRANT SELECT ON TABLE metric_numeric_rollup_30m TO prism;
48
49
50 --
51 -- PostgreSQL database dump complete
52 --
53
Note: See TracBrowser for help on using the browser.