root/sql/tables/noit.check_archive.sql

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

layout of primary check tables

  • Property mode set to 100644
Line 
1 --
2 -- PostgreSQL database dump
3 --
4
5 SET client_encoding = 'UTF8';
6 SET standard_conforming_strings = off;
7 SET check_function_bodies = false;
8 SET client_min_messages = warning;
9 SET escape_string_warning = off;
10
11 SET search_path = noit, pg_catalog;
12
13 SET default_tablespace = '';
14
15 SET default_with_oids = false;
16
17 --
18 -- Name: check_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
19 --
20
21 CREATE TABLE check_archive (
22     sid integer NOT NULL,
23     remote_address inet,
24     whence timestamp with time zone NOT NULL,
25     id uuid NOT NULL,
26     target text NOT NULL,
27     module text NOT NULL,
28     name text NOT NULL
29 );
30
31
32 ALTER TABLE noit.check_archive OWNER TO reconnoiter;
33
34 --
35 -- Name: check_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
36 --
37
38 ALTER TABLE ONLY check_archive
39     ADD CONSTRAINT check_archive_pkey PRIMARY KEY (sid, id, whence);
40
41
42 --
43 -- Name: mv_check_archive; Type: TRIGGER; Schema: noit; Owner: reconnoiter
44 --
45
46 CREATE TRIGGER check_archive_log_changes
47     AFTER INSERT ON check_archive
48     FOR EACH ROW
49     EXECUTE PROCEDURE check_archive_log_changes();
50
51
52 --
53 -- Name: check_archive; Type: ACL; Schema: noit; Owner: reconnoiter
54 --
55
56 REVOKE ALL ON TABLE check_archive FROM PUBLIC;
57 REVOKE ALL ON TABLE check_archive FROM reconnoiter;
58 GRANT ALL ON TABLE check_archive TO reconnoiter;
59 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_archive TO noit;
60 GRANT SELECT ON TABLE check_archive TO prism;
61
62
63 --
64 -- PostgreSQL database dump complete
65 --
66
Note: See TracBrowser for help on using the browser.