Open-ILS/src/sql/Pg/upgrade/0152.schema.acq.undo-spending-limits.sql

   1 BEGIN;
   2
   3 -- Undoing some ill-considered changes...
   4
   5 INSERT INTO config.upgrade_log (version) VALUES ('0152'); -- Scott McKellar
   6
   7 ALTER TABLE actor.org_unit
   8         DROP COLUMN spend_warning_percent;
   9
  10 ALTER TABLE actor.org_unit
  11         DROP COLUMN spend_limit_percent;
  12
  13 DROP FUNCTION acq.default_spend_limit( INT );
  14
  15 DROP FUNCTION acq.default_warning_limit( INT );
  16
  17 COMMIT;
  18
  19 -- If there is no auditor schema, the following ALTERs
  20 -- will fail, and that's okay.
  21
  22 ALTER TABLE auditor.actor_org_unit_history
  23         DROP COLUMN spend_warning_percent;
  24
  25 ALTER TABLE auditor.actor_org_unit_history
  26         DROP COLUMN spend_limit_percent;
  27