root/sql/tables/noit.metric_numeric_rollup_5m.sql

Revision 4bd7d843175692be84818c389d9938e7590cd487, 1.3 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 5 years ago)

make it load

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