root/sql/tables/stratcon.current_node_config_changelog.sql

Revision 4bd41daf5972011000e2f08b921a9809998bd036, 1.0 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 4 years ago)

some more missing tables

  • Property mode set to 100644
Line 
1 CREATE TABLE stratcon.current_node_config_changelog (
2     remote_address inet NOT NULL,
3     node_type text NOT NULL,
4     whence timestamp with time zone NOT NULL,
5     config xml NOT NULL
6 );
7
8
9 ALTER TABLE stratcon.current_node_config_changelog OWNER TO reconnoiter;
10
11 --
12 -- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
13 --
14
15 ALTER TABLE ONLY stratcon.current_node_config_changelog
16     ADD CONSTRAINT current_node_config_changelog_pkey PRIMARY KEY (remote_address, node_type, whence);
17
18 --
19 -- Name: current_node_config_changelog; Type: ACL; Schema: stratcon; Owner: reconnoiter
20 --
21
22 REVOKE ALL ON TABLE stratcon.current_node_config_changelog FROM PUBLIC;
23 REVOKE ALL ON TABLE stratcon.current_node_config_changelog FROM reconnoiter;
24 GRANT ALL ON TABLE stratcon.current_node_config_changelog TO reconnoiter;
25 GRANT SELECT ON TABLE stratcon.current_node_config_changelog TO prism;
26 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE stratcon.current_node_config_changelog TO stratcon;
27
Note: See TracBrowser for help on using the browser.