Changeset 81f7001e39e1c3484d225b7a609fc803c86ba5ef

Show
Ignore:
Timestamp:
09/30/09 17:04:25 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1254330265 +0000
git-parent:

[64c35d610d430e39870bc67c35bdf49298ba29f8]

git-author:
Robert Treat <robert@omniti.com> 1254330265 +0000
Message:

new task locking infrastructure

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/tables/stratcon.tasklock.sql

    ra34bc12 r81f7001  
    1 -- formerly tasklocks 
     1-- 
     2-- PostgreSQL database dump 
     3-- 
     4 
     5SET client_encoding = 'UTF8'; 
     6SET standard_conforming_strings = off; 
     7SET check_function_bodies = false; 
     8SET client_min_messages = warning; 
     9SET escape_string_warning = off; 
     10 
     11SET search_path = stratcon, pg_catalog; 
     12 
     13SET default_tablespace = ''; 
     14 
     15SET default_with_oids = false; 
     16 
     17-- 
     18-- Name: tasklock_id_seq; Type: SEQUENCE; Schema: stratcon; Owner: reconnoiter 
     19-- 
     20 
     21CREATE SEQUENCE tasklock_id_seq 
     22    INCREMENT BY 1 
     23    NO MAXVALUE 
     24    NO MINVALUE 
     25    CACHE 1; 
     26 
     27ALTER TABLE stratcon.tasklock_id_seq OWNER TO reconnoiter; 
     28 
     29-- 
     30-- Name: tasklock_id_seq; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     31-- 
     32 
     33REVOKE ALL ON SEQUENCE tasklock_id_seq FROM PUBLIC; 
     34REVOKE ALL ON SEQUENCE tasklock_id_seq FROM reconnoiter; 
     35GRANT ALL ON SEQUENCE tasklock_id_seq TO reconnoiter; 
     36GRANT SELECT,UPDATE ON SEQUENCE tasklock_id_seq TO stratcon; 
     37 
     38 
     39-- 
     40-- PostgreSQL database dump complete 
     41-- 
     42