root/sql/tables/noit.metric_numeric_rollup_12hours.sql

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

merge skeksis back into trunk... we're sharded

  • Property mode set to 100644
Line 
1 -- formerly rollup_matrix_numeric_12hours
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_12hours; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
20 --
21
22 CREATE TABLE metric_numeric_rollup_12hours (
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     CONSTRAINT metric_numeric_rollup_12hours_rollup_time_check CHECK (((date_part('hour'::text, timezone('UTC'::text, rollup_time)) = ANY (ARRAY[(0)::double precision, (12)::double precision])) AND (date_part('minute'::text, timezone('utc'::text, rollup_time)) = (0)::double precision)))
30 );
31
32
33 ALTER TABLE noit.metric_numeric_rollup_12hours OWNER TO reconnoiter;
34
35 --
36 -- Name: metric_numeric_rollup_12hours_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
37 --
38
39 ALTER TABLE ONLY metric_numeric_rollup_12hours
40     ADD CONSTRAINT metric_numeric_rollup_12hours_pkey PRIMARY KEY (rollup_time, sid, name);
41
42
43 --
44 -- Name: metric_numeric_rollup_12hours; Type: ACL; Schema: noit; Owner: reconnoiter
45 --
46
47 REVOKE ALL ON TABLE metric_numeric_rollup_12hours FROM PUBLIC;
48 REVOKE ALL ON TABLE metric_numeric_rollup_12hours FROM reconnoiter;
49 GRANT ALL ON TABLE metric_numeric_rollup_12hours TO reconnoiter;
50 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_12hours TO stratcon;
51 GRANT SELECT ON TABLE metric_numeric_rollup_12hours TO prism;
52
53
54 --
55 -- PostgreSQL database dump complete
56 --
57
Note: See TracBrowser for help on using the browser.