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/1.2.1-1.2.2-upgrade-db.sql

    r9529 r9543  
    171171    id          SERIAL  PRIMARY KEY, 
    172172    active      BOOL    NOT NULL DEFAULT TRUE, 
    173     field       INT     NOT NULL REFERENCES config.metabib_field (id), 
     173    field       INT     NOT NULL REFERENCES config.metabib_field (id) DEFERRABLE INITIALLY DEFERRED, 
    174174    bump_type   TEXT    NOT NULL CHECK (bump_type IN ('word_order','first_word','full_match')), 
    175175    multiplier  NUMERIC NOT NULL DEFAULT 1.0