root/sql/tables/prism.graph_templates.sql

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

prism tables

  • Property mode set to 100644
Line 
1 --
2 -- Name: graph_templates; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace:
3 --
4
5 CREATE TABLE prism.graph_templates (
6     templateid uuid NOT NULL,
7     title text NOT NULL,
8     json text NOT NULL
9 );
10
11
12 ALTER TABLE prism.graph_templates OWNER TO reconnoiter;
13
14 --
15 -- Name: graph_templates_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace:
16 --
17
18 ALTER TABLE ONLY prism.graph_templates
19     ADD CONSTRAINT graph_templates_pkey PRIMARY KEY (templateid);
20
21
22 --
23 -- Name: graph_templates_title_key; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace:
24 --
25
26 ALTER TABLE ONLY prism.graph_templates
27     ADD CONSTRAINT graph_templates_title_key UNIQUE (title);
28
29
30 --
31 -- Name: graph_templates; Type: ACL; Schema: prism; Owner: reconnoiter
32 --
33
34 REVOKE ALL ON TABLE prism.graph_templates FROM PUBLIC;
35 REVOKE ALL ON TABLE prism.graph_templates FROM reconnoiter;
36 GRANT ALL ON TABLE prism.graph_templates TO reconnoiter;
37 GRANT ALL ON TABLE prism.graph_templates TO prism;
38
39
Note: See TracBrowser for help on using the browser.