root/sql/tables/prism.saved_worksheets.sql

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

prism tables

  • Property mode set to 100644
Line 
1 --
2 -- Name: saved_worksheets; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace:
3 --
4
5 CREATE TABLE prism.saved_worksheets (
6     sheetid uuid NOT NULL,
7     title text,
8     saved boolean DEFAULT false,
9     ts_search_all tsvector,
10     tags text[],
11     last_update timestamp with time zone DEFAULT now() NOT NULL
12 );
13
14
15 ALTER TABLE prism.saved_worksheets OWNER TO reconnoiter;
16
17 --
18 -- Name: saved_worksheets_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace:
19 --
20
21 ALTER TABLE ONLY prism.saved_worksheets
22     ADD CONSTRAINT saved_worksheets_pkey PRIMARY KEY (sheetid);
23
24
25 --
26 -- Name: saved_worksheets; Type: ACL; Schema: prism; Owner: reconnoiter
27 --
28
29 REVOKE ALL ON TABLE prism.saved_worksheets FROM PUBLIC;
30 REVOKE ALL ON TABLE prism.saved_worksheets FROM reconnoiter;
31 GRANT ALL ON TABLE prism.saved_worksheets TO reconnoiter;
32 GRANT ALL ON TABLE prism.saved_worksheets TO prism;
33
34
Note: See TracBrowser for help on using the browser.