root/sql/tables/noit.tasklock_sequence.sql

Revision 420b34c7d61262546669125ae17b29becad77298, 0.9 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

actually, this should be in noit schema, though we do want to leave it decoupled

  • 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 = noit, pg_catalog;
12
13 SET default_tablespace = '';
14
15 SET default_with_oids = false;
16
17 --
18 -- Name: tasklock_id_seq; Type: SEQUENCE; Schema: noit; Owner: reconnoiter
19 --
20
21 CREATE SEQUENCE tasklock_id_seq
22     INCREMENT BY 1
23     NO MAXVALUE
24     NO MINVALUE
25     CACHE 1;
26
27 ALTER TABLE noit.tasklock_id_seq OWNER TO reconnoiter;
28
29 --
30 -- Name: tasklock_id_seq; Type: ACL; Schema: noit; Owner: reconnoiter
31 --
32
33 REVOKE ALL ON SEQUENCE tasklock_id_seq FROM PUBLIC;
34 REVOKE ALL ON SEQUENCE tasklock_id_seq FROM reconnoiter;
35 GRANT ALL ON SEQUENCE tasklock_id_seq TO reconnoiter;
36 GRANT SELECT,UPDATE ON SEQUENCE tasklock_id_seq TO stratcon;
37
38
39 --
40 -- PostgreSQL database dump complete
41 --
42
Note: See TracBrowser for help on using the browser.