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/080.schema.money.sql

    r8052 r9543  
    77CREATE TABLE money.collections_tracker ( 
    88        id              BIGSERIAL                       PRIMARY KEY, 
    9         usr             INT                             NOT NULL REFERENCES actor.usr (id), -- actor.usr.id 
    10         collector       INT                             NOT NULL REFERENCES actor.usr (id), 
    11         location        INT                             NOT NULL REFERENCES actor.org_unit (id), 
     9        usr             INT                             NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, -- actor.usr.id 
     10        collector       INT                             NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, 
     11        location        INT                             NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED, 
    1212        enter_time      TIMESTAMP WITH TIME ZONE 
    1313); 
    … …  
    286286 
    287287CREATE TABLE money.bnm_desk_payment ( 
    288         cash_drawer     INT     REFERENCES actor.workstation (id) 
     288        cash_drawer     INT     REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED 
    289289) INHERITS (money.bnm_payment); 
    290290ALTER TABLE money.bnm_desk_payment ADD PRIMARY KEY (id);