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