salix/db/versions/11236-blackMedeola/01-firstScript.sql

7 lines
284 B
MySQL
Raw Permalink Normal View History

2024-09-16 10:32:52 +00:00
ALTER TABLE bs.waste
DROP COLUMN saleInternalWaste,
ADD saleFaultWaste decimal(10,2) DEFAULT NULL NULL,
ADD saleContainerWaste decimal(10,2) DEFAULT NULL NULL,
ADD saleBreakWaste decimal(10,2) DEFAULT NULL NULL,
ADD saleOtherWaste decimal(10,2) DEFAULT NULL NULL;