root/sql/tables/noit.check_currently.sql

Revision 35417f1d20ade67bfbf99b03c861fe1756ee11cd, 1.7 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

layout of primary check tables

  • Property mode set to 100644
Line 
1 -- formerly mv_loading_dock_check_s
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: check_currently; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
21 --
22
23 CREATE TABLE check_currently (
24     sid integer NOT NULL,
25     remote_address inet,
26     whence timestamp with time zone NOT NULL,
27     id uuid NOT NULL,
28     target text NOT NULL,
29     module text NOT NULL,
30     name text NOT NULL
31 );
32
33
34 ALTER TABLE noit.check_currently OWNER TO reconnoiter;
35
36 --
37 -- Name: check_currently_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
38 --
39
40 ALTER TABLE ONLY check_currently
41     ADD CONSTRAINT check_currently_pkey PRIMARY KEY (sid);
42
43 --
44 -- Name: check_currently_uidx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace:
45 --
46
47 CREATE UNIQUE INDEX ucheck_currently_id_uidx ON check_currently USING btree (id);
48
49
50 --
51 -- Name: trig_update_tsvector_from_mv_dock; Type: TRIGGER; Schema: noit; Owner: reconnoiter
52 --
53
54 CREATE TRIGGER update_metric_summary_fulltext
55     AFTER INSERT OR UPDATE ON check_currently
56     FOR EACH ROW
57     EXECUTE PROCEDURE update_metric_summary_fulltext();
58
59
60 --
61 -- Name: check_currently; Type: ACL; Schema: noit; Owner: reconnoiter
62 --
63
64 REVOKE ALL ON TABLE check_currently FROM PUBLIC;
65 REVOKE ALL ON TABLE check_currently FROM reconnoiter;
66 GRANT ALL ON TABLE check_currently TO reconnoiter;
67 GRANT SELECT ON TABLE check_currently TO prism;
68 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_currently TO stratcon;
69
70
71 --
72 -- PostgreSQL database dump complete
73 --
74
Note: See TracBrowser for help on using the browser.