Open-ILS/src/sql/Pg/upgrade/0775.schema.config_z3950_source_attr_cascade_delete.sql

   1
   2 BEGIN;
   3
   4 SELECT evergreen.upgrade_deps_block_check('0775', :eg_version);
   5
   6 ALTER TABLE config.z3950_attr
   7     DROP CONSTRAINT z3950_attr_source_fkey,
   8     ADD CONSTRAINT z3950_attr_source_fkey
   9         FOREIGN KEY (source)
  10         REFERENCES config.z3950_source(name)
  11         ON UPDATE CASCADE
  12         ON DELETE CASCADE
  13         DEFERRABLE INITIALLY DEFERRED;
  14
  15 COMMIT;