Show
Ignore:
Timestamp:
05/09/08 12:34:30 (5 months ago)
Author:
dbs
Message:

Merge rev. 9542 from trunk: add deferrable to all FKs

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • branches/rel_1_2/Open-ILS/src/sql/Pg/300.schema.staged_search.sql

    r9147 r9543  
    99    id          SERIAL  PRIMARY KEY, 
    1010    active      BOOL    NOT NULL DEFAULT TRUE, 
    11     field       INT     NOT NULL REFERENCES config.metabib_field (id), 
     11    field       INT     NOT NULL REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED, 
    1212    bump_type   TEXT    NOT NULL CHECK (bump_type IN ('word_order','first_word','full_match')), 
    1313    multiplier  NUMERIC NOT NULL DEFAULT 1.0