-- ABS-26012
----------   CUSTOMERBUDGETPROTECTION   --------------
ALTER TABLE CUSTOMERBUDGETPROTECTION DROP CONSTRAINT MATERIALMAINTENANCEPERC_CHECK;

ALTER TABLE CUSTOMERBUDGETPROTECTION DROP COLUMN MATERIALMAINTENANCE;

ALTER TABLE CUSTOMERBUDGETPROTECTION MODIFY (MATERIALMAINTENANCEPERCENTAGE NOT NULL);

ALTER TABLE CUSTOMERBUDGETPROTECTION ADD CONSTRAINT MATERIALMAINTENANCEPERC_CHECK CHECK (MATERIALMAINTENANCEPERCENTAGE BETWEEN 0 AND 100);


----------   DISTRIBPOINTBGPROTECTION   --------------
ALTER TABLE DISTRIBPOINTBGPROTECTION DROP COLUMN CUSTOMER_ID CASCADE CONSTRAINTS;

----------   PLPCBUDGETPROTECTION   --------------
ALTER TABLE PLPCBUDGETPROTECTION DROP COLUMN CUSTOMER_ID CASCADE CONSTRAINTS;

ALTER TABLE PLPCBUDGETPROTECTION DROP COLUMN MATERIALMAINTENANCE;
