root/sql/tables/noit.metric_numeric_rollup_20m.sql

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

synch rollup tables with desired reality

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