root/sql/tables/stratcon.current_node_config.sql

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

refs #226

This implements the change, but does not improve upon the stratcon config.
The stratcon config is still inserted with 0.0.0.0 as the remote_address
and now furthers the underachievement by using "" as the common name.

This should be fixed as a part of this ticket as well.

  • 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_cn text NOT NULL,
23     node_type text NOT NULL,
24     remote_address inet NOT NULL,
25     whence timestamp with time zone NOT NULL,
26     config xml NOT NULL
27 );
28
29
30 ALTER TABLE stratcon.current_node_config OWNER TO reconnoiter;
31
32 --
33 -- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
34 --
35
36 ALTER TABLE ONLY current_node_config
37     ADD CONSTRAINT current_node_config_pkey PRIMARY KEY (remote_cn, node_type);
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.