Show
Ignore:
Timestamp:
11/11/09 03:59:35 (4 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1257911975 +0000
git-parent:

[6154e3c58475b805c2251d767c44dbe6a6cb8acf]

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

adjust pks

Files:

Legend:

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

    r6154e3c r4dd74de  
    1616 
    1717CREATE TABLE event_criteria_numeric_rulesets ( 
    18   event_criteria_id integer not null primary key references event_criteria_numeric on update cascade on delete restrict, 
     18  event_criteria_id integer not null references event_criteria_numeric on update cascade on delete restrict, 
    1919  minimum numeric, 
    2020  maximum numeric, 
     
    2222  ordering integer not null, 
    2323  priority integer not null, 
    24   check (coalesce(minimum,maximum) IS NOT NULL)  
     24  check (coalesce(minimum,maximum) IS NOT NULL), 
     25  primary key (event_criteria_id, ordering)   
    2526); 
    2627 
     
    3233  absence boolean not null default true, 
    3334  ordering integer not null, 
    34   priority integer not null 
     35  priority integer not null,  
     36  primary key (event_criteria_id, ordering)   
    3537); 
    3638