| 1 | | -- formerly loading_dock_metric_numeric_archive |
|---|
| | 1 | -- formerly loading_dock_metric_numeric_archive |
|---|
| | 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_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: |
|---|
| | 20 | -- |
|---|
| | 21 | |
|---|
| | 22 | CREATE TABLE metric_numeric_archive ( |
|---|
| | 23 | sid integer NOT NULL, |
|---|
| | 24 | whence timestamp with time zone NOT NULL, |
|---|
| | 25 | name text NOT NULL, |
|---|
| | 26 | value numeric |
|---|
| | 27 | ); |
|---|
| | 28 | |
|---|
| | 29 | |
|---|
| | 30 | ALTER TABLE noit.metric_numeric_archive OWNER TO reconnoiter; |
|---|
| | 31 | |
|---|
| | 32 | -- |
|---|
| | 33 | -- Name: metric_numeric_archive_whence_key; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: |
|---|
| | 34 | -- |
|---|
| | 35 | |
|---|
| | 36 | ALTER TABLE ONLY metric_numeric_archive |
|---|
| | 37 | ADD CONSTRAINT metric_numeric_archive_pkey PRIMARY KEY (whence, sid, name); |
|---|
| | 38 | |
|---|
| | 39 | |
|---|
| | 40 | -- |
|---|
| | 41 | -- Name: mark_metric_numeric_rollup_buffer; Type: TRIGGER; Schema: noit; Owner: reconnoiter |
|---|
| | 42 | -- |
|---|
| | 43 | |
|---|
| | 44 | CREATE TRIGGER mark_metric_numeric_rollup_buffer |
|---|
| | 45 | AFTER INSERT ON metric_numeric_archive |
|---|
| | 46 | FOR EACH ROW |
|---|
| | 47 | EXECUTE PROCEDURE mark_metric_numeric_rollup_buffer(); |
|---|
| | 48 | |
|---|
| | 49 | |
|---|
| | 50 | -- |
|---|
| | 51 | -- Name: metric_numeric_archive; Type: ACL; Schema: noit; Owner: reconnoiter |
|---|
| | 52 | -- |
|---|
| | 53 | |
|---|
| | 54 | REVOKE ALL ON TABLE metric_numeric_archive FROM PUBLIC; |
|---|
| | 55 | REVOKE ALL ON TABLE metric_numeric_archive FROM reconnoiter; |
|---|
| | 56 | GRANT ALL ON TABLE metric_numeric_archive TO reconnoiter; |
|---|
| | 57 | GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_archive TO stratcon; |
|---|
| | 58 | GRANT SELECT ON TABLE metric_numeric_archive TO prism; |
|---|
| | 59 | |
|---|
| | 60 | |
|---|
| | 61 | -- |
|---|
| | 62 | -- PostgreSQL database dump complete |
|---|
| | 63 | -- |
|---|
| | 64 | |
|---|
