| | 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: postgres; 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 postgres; |
|---|
| | 34 | |
|---|
| | 35 | -- |
|---|
| | 36 | -- Name: fmetric_numeric_rollup_5m_pkey; Type: CONSTRAINT; Schema: noit; Owner: postgres; 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: postgres |
|---|
| | 45 | -- |
|---|
| | 46 | |
|---|
| | 47 | REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM PUBLIC; |
|---|
| | 48 | REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM postgres; |
|---|
| | 49 | GRANT ALL ON TABLE metric_numeric_rollup_5m TO postgres; |
|---|
| | 50 | GRANT ALL ON TABLE metric_numeric_rollup_5m TO reconnoiter; |
|---|
| | 51 | GRANT SELECT ON TABLE metric_numeric_rollup_5m TO prism; |
|---|
| | 52 | GRANT ALL ON TABLE metric_numeric_rollup_5m TO stratcon; |
|---|
| | 53 | |
|---|
| | 54 | |
|---|
| | 55 | -- |
|---|
| | 56 | -- PostgreSQL database dump complete |
|---|
| | 57 | -- |
|---|
| | 58 | |
|---|
