root/sql/tables/stratcon.map_uuid_to_sid.sql

Revision 47a77d02f1268e637a4807266064909be566e1f7, 1.4 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 5 years ago)

flag-day(stratcond,webconsole,database) get realtime graphs working on uuids

  • 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: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
19 --
20
21 CREATE TABLE map_uuid_to_sid (
22     id uuid NOT NULL,
23     sid serial NOT NULL,
24     noit text NOT NULL,
25     storage_node_id integer REFERENCES stratcon.storage_node
26 );
27
28
29 ALTER TABLE stratcon.map_uuid_to_sid OWNER TO reconnoiter;
30
31 --
32 -- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
33 --
34
35 ALTER TABLE ONLY map_uuid_to_sid
36     ADD CONSTRAINT map_uuid_to_sid_pkey PRIMARY KEY (id);
37
38
39 --
40 -- Name: map_uuid_to_sid_idx; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
41 --
42
43 CREATE UNIQUE INDEX map_uuid_to_sid_idx ON map_uuid_to_sid USING btree (sid);
44
45
46 --
47 -- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: reconnoiter
48 --
49
50 REVOKE ALL ON TABLE map_uuid_to_sid FROM PUBLIC;
51 REVOKE ALL ON TABLE map_uuid_to_sid FROM reconnoiter;
52 GRANT ALL ON TABLE map_uuid_to_sid TO reconnoiter;
53 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE map_uuid_to_sid TO stratcon;
54 GRANT SELECT ON TABLE map_uuid_to_sid TO prism;
55
56
57 --
58 -- PostgreSQL database dump complete
59 --
60
Note: See TracBrowser for help on using the browser.