root/sql/tables/noit.metric_numeric_archive.sql

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

numeric metrics

  • Property mode set to 100644
Line 
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
Note: See TracBrowser for help on using the browser.