root/sql/tables/stratcon.map_uuid_to_sid.sql

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