root/sql/tables/prism.saved_worksheets_dep.sql

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

prism tables

  • Property mode set to 100644
Line 
1 --
2 -- Name: saved_worksheets_dep; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace:
3 --
4
5 CREATE TABLE prism.saved_worksheets_dep (
6     sheetid uuid NOT NULL,
7     ordering integer NOT NULL,
8     graphid uuid NOT NULL
9 );
10
11
12 ALTER TABLE prism.saved_worksheets_dep OWNER TO reconnoiter;
13
14 --
15 -- Name: saved_worksheets_dep_graphid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter
16 --
17
18 ALTER TABLE ONLY prism.saved_worksheets_dep
19     ADD CONSTRAINT saved_worksheets_dep_graphid_fkey FOREIGN KEY (graphid) REFERENCES prism.saved_graphs(graphid) ON DELETE CASCADE;
20
21
22 --
23 -- Name: saved_worksheets_dep_sheetid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter
24 --
25
26 ALTER TABLE ONLY prism.saved_worksheets_dep
27     ADD CONSTRAINT saved_worksheets_dep_sheetid_fkey FOREIGN KEY (sheetid) REFERENCES prism.saved_worksheets(sheetid);
28
29
30 --
31 -- Name: saved_worksheets_dep; Type: ACL; Schema: prism; Owner: reconnoiter
32 --
33
34 REVOKE ALL ON TABLE prism.saved_worksheets_dep FROM PUBLIC;
35 REVOKE ALL ON TABLE prism.saved_worksheets_dep FROM reconnoiter;
36 GRANT ALL ON TABLE prism.saved_worksheets_dep TO reconnoiter;
37 GRANT ALL ON TABLE prism.saved_worksheets_dep TO prism;
38
39
Note: See TracBrowser for help on using the browser.