root/sql/tables/noit.tasklock.sql

Revision 2b8f8c20cf8db128b58a867bceb25006514a662e, 1.2 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

fix up bugs now that it's tested

  • Property mode set to 100644
Line 
1 -- formerly tasklocks
2 --
3 -- PostgreSQL database dump
4 --
5
6 SET client_encoding = 'UTF8';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
11
12 SET search_path = noit, pg_catalog;
13
14 SET default_tablespace = '';
15
16 SET default_with_oids = false;
17
18 --
19 -- Name: tasklock; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
20 --
21
22 CREATE TABLE tasklock (
23     id integer NOT NULL,
24     name text NOT NULL
25 );
26
27
28 ALTER TABLE noit.tasklock OWNER TO reconnoiter;
29
30 --
31 -- Name: tasklock_name_key; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
32 --
33
34 ALTER TABLE ONLY tasklock
35     ADD CONSTRAINT tasklock_name_key UNIQUE (name);
36
37
38 --
39 -- Name: tasklock_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:
40 --
41
42 ALTER TABLE ONLY tasklock
43     ADD CONSTRAINT tasklock_pkey PRIMARY KEY (id);
44
45
46 --
47 -- Name: tasklock; Type: ACL; Schema: noit; Owner: reconnoiter
48 --
49
50 REVOKE ALL ON TABLE tasklock FROM PUBLIC;
51 REVOKE ALL ON TABLE tasklock FROM reconnoiter;
52 GRANT ALL ON TABLE tasklock TO reconnoiter;
53 GRANT SELECT,INSERT ON TABLE tasklock TO stratcon;
54
55 --
56 -- PostgreSQL database dump complete
57 --
58
Note: See TracBrowser for help on using the browser.