Changeset 9542 for trunk/Open-ILS/src/sql/Pg/080.schema.money.sql

Timestamp:

05/09/08 12:31:09 (2 months ago)

Author:

dbs

Message:

Make all foreign keys deferrable, so we can DELETE and INSERT inside a transaction without constraints hobbling us

Files:

• trunk/Open-ILS/src/sql/Pg/080.schema.money.sql (modified) (2 diffs)

trunk/Open-ILS/src/sql/Pg/080.schema.money.sql

@@ -7 +7 @@
 CREATE TABLE money.collections_tracker (
         id              BIGSERIAL                       PRIMARY KEY,
-        usr             INT                             NOT NULL REFERENCES actor.usr (id), -- actor.usr.id
-        collector       INT                             NOT NULL REFERENCES actor.usr (id),
-        location        INT                             NOT NULL REFERENCES actor.org_unit (id),
+        usr             INT                             NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, -- actor.usr.id
+        collector       INT                             NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED,
+        location        INT                             NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED,
         enter_time      TIMESTAMP WITH TIME ZONE
 );
@@ -325 +325 @@
 
 CREATE TABLE money.bnm_desk_payment (
-        cash_drawer     INT     REFERENCES actor.workstation (id)
+        cash_drawer     INT     REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED
 ) INHERITS (money.bnm_payment);
 ALTER TABLE money.bnm_desk_payment ADD PRIMARY KEY (id);