Open-ILS/src/sql/Pg/upgrade/0186.schema.acq-on-delete-li.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0186'); -- Scott McKellar
   4
   5 ALTER TABLE acq.distribution_formula_application
   6         DROP CONSTRAINT distribution_formula_application_lineitem_fkey;
   7
   8 ALTER TABLE acq.distribution_formula_application
   9         ADD FOREIGN KEY (lineitem) REFERENCES acq.lineitem( id )
  10                 ON DELETE CASCADE
  11                 DEFERRABLE INITIALLY DEFERRED;
  12
  13 ALTER TABLE acq.lineitem_attr
  14         DROP CONSTRAINT lineitem_attr_lineitem_fkey;
  15
  16 ALTER TABLE acq.lineitem_attr
  17         ADD FOREIGN KEY (lineitem) REFERENCES acq.lineitem( id )
  18                 ON DELETE CASCADE
  19                 DEFERRABLE INITIALLY DEFERRED;
  20
  21 ALTER TABLE acq.lineitem_detail
  22         DROP CONSTRAINT lineitem_detail_lineitem_fkey;
  23
  24 ALTER TABLE acq.lineitem_detail
  25         ADD FOREIGN KEY (lineitem) REFERENCES acq.lineitem( id )
  26                 ON DELETE CASCADE
  27                 DEFERRABLE INITIALLY DEFERRED;
  28
  29 ALTER TABLE acq.lineitem_note
  30         DROP CONSTRAINT lineitem_note_lineitem_fkey;
  31
  32 ALTER TABLE acq.lineitem_note
  33         ADD FOREIGN KEY (lineitem) REFERENCES acq.lineitem( id )
  34                 ON DELETE CASCADE
  35                 DEFERRABLE INITIALLY DEFERRED;
  36
  37 COMMIT;