Changeset c2dc38225cd07f2a35ccc35dd0a2a5d5e1b0929e

Show
Ignore:
Timestamp:
11/08/09 19:34:30 (5 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1257708870 +0000
git-parent:

[5bb306cd48a5523c1719766ad6cd61624f997929]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1257708870 +0000
Message:

add a sequence for the peeps

Files:

Legend:

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

    r16e27d8 rc2dc382  
    1818-- Name: event_criteria; Type: TABLE; Schema: stratcon; Owner: reconnoiter; 
    1919-- 
     20 
     21CREATE SEQUENCE event_criteria_id_seq 
     22    INCREMENT BY 1 
     23    NO MAXVALUE 
     24    NO MINVALUE 
     25    CACHE 1; 
     26 
     27ALTER TABLE event_criteria_id_seq OWNER TO reconnoiter; 
     28REVOKE ALL ON SEQUENCE event_criteria_id_seq FROM PUBLIC; 
     29REVOKE ALL ON SEQUENCE event_criteria_id_seq FROM reconnoiter; 
     30GRANT ALL ON SEQUENCE event_criteria_id_seq TO reconnoiter; 
     31GRANT SELECT,UPDATE ON SEQUENCE event_criteria_id_seq TO stratcon; 
    2032 
    2133CREATE TABLE event_criteria_numeric (