[Reconnoiter-devel] [reconnoiter commit] r917 - branches/skeksis/sql/tables

svn-commit at lists.omniti.com svn-commit at lists.omniti.com
Wed Sep 30 13:07:46 EDT 2009


Author: robert
Date: 2009-09-30 13:07:46 -0400 (Wed, 30 Sep 2009)
New Revision: 917

Added:
   branches/skeksis/sql/tables/noit.tasklock_sequence.sql
Log:
actually, this should be in noit schema, though we do want to leave it decoupled

Copied: branches/skeksis/sql/tables/noit.tasklock_sequence.sql (from rev 916, branches/skeksis/sql/tables/stratcon.tasklock.sql)
===================================================================
--- branches/skeksis/sql/tables/noit.tasklock_sequence.sql	                        (rev 0)
+++ branches/skeksis/sql/tables/noit.tasklock_sequence.sql	2009-09-30 17:07:46 UTC (rev 917)
@@ -0,0 +1,42 @@
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = noit, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: tasklock_id_seq; Type: SEQUENCE; Schema: noit; Owner: reconnoiter
+--
+
+CREATE SEQUENCE tasklock_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER TABLE noit.tasklock_id_seq OWNER TO reconnoiter;
+
+--
+-- Name: tasklock_id_seq; Type: ACL; Schema: noit; Owner: reconnoiter
+--
+
+REVOKE ALL ON SEQUENCE tasklock_id_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE tasklock_id_seq FROM reconnoiter;
+GRANT ALL ON SEQUENCE tasklock_id_seq TO reconnoiter;
+GRANT SELECT,UPDATE ON SEQUENCE tasklock_id_seq TO stratcon;
+
+
+--
+-- PostgreSQL database dump complete
+--
+



More information about the Reconnoiter-devel mailing list