root/sql/tables/stratcon.current_node_config.sql

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

map table plus placeholders for upcoming schema

  • 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 = stratcon, pg_catalog;
12
13 SET default_tablespace = '';
14
15 SET default_with_oids = false;
16
17 --
18 -- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
19 --
20
21 CREATE TABLE current_node_config (
22     remote_address inet NOT NULL,
23     node_type text NOT NULL,
24     whence timestamp with time zone NOT NULL,
25     config xml NOT NULL
26 );
27
28
29 ALTER TABLE stratcon.current_node_config OWNER TO reconnoiter;
30
31 --
32 -- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
33 --
34
35 ALTER TABLE ONLY current_node_config
36     ADD CONSTRAINT current_node_config_pkey PRIMARY KEY (remote_address, node_type);
37
38
39 --
40 -- Name: current_node_config; Type: ACL; Schema: stratcon; Owner: reconnoiter
41 --
42
43 REVOKE ALL ON TABLE current_node_config FROM PUBLIC;
44 REVOKE ALL ON TABLE current_node_config FROM reconnoiter;
45 GRANT ALL ON TABLE current_node_config TO reconnoiter;
46 GRANT SELECT ON TABLE current_node_config TO prism;
47 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE current_node_config TO stratcon;
48
49
50 --
51 -- PostgreSQL database dump complete
52 --
53
Note: See TracBrowser for help on using the browser.