root/sql/tables/noit.metric_text_archive.sql

Revision 88d5aaab122fefd6471e1d4604f54cd1a6df433b, 1.5 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

text metric tables

  • Property mode set to 100644
Line 
1 -- formerly loading_dock_metric_text_archive
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_text_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
21 --
22
23 CREATE TABLE metric_text_archive (
24     sid integer NOT NULL,
25     whence timestamp with time zone NOT NULL,
26     name text NOT NULL,
27     value text
28 );
29
30
31 ALTER TABLE noit.metric_text_archive OWNER TO reconnoiter;
32
33 --
34 -- Name: metric_text_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
35 --
36
37 ALTER TABLE ONLY metric_text_archive
38     ADD CONSTRAINT metric_text_archive_pkey PRIMARY KEY (whence, sid, name);
39
40 --
41 -- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: noit; Owner: reconnoiter
42 --
43
44 CREATE TRIGGER metric_text_archive_log_changes
45     AFTER INSERT ON metric_text_archive
46     FOR EACH ROW
47     EXECUTE PROCEDURE metric_text_archive_log_changes();
48
49
50 --
51 -- Name: metric_text_archive; Type: ACL; Schema: noit; Owner: reconnoiter
52 --
53
54 REVOKE ALL ON TABLE metric_text_archive FROM PUBLIC;
55 REVOKE ALL ON TABLE metric_text_archive FROM reconnoiter;
56 GRANT ALL ON TABLE metric_text_archive TO reconnoiter;
57 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_archive TO stratcon;
58 GRANT SELECT ON TABLE metric_text_archive TO prism;
59
60
61 --
62 -- PostgreSQL database dump complete
63 --
Note: See TracBrowser for help on using the browser.