salix/db/versions/.archive/10692-silverLilium/00-firstScript.sql

4 lines
210 B
MySQL
Raw Permalink Normal View History

ALTER TABLE bs.salesByItemTypeDay DROP FOREIGN KEY itemTypeSalesByweek_itemCategoryFk;
ALTER TABLE bs.salesByItemTypeDay DROP COLUMN itemCategoryFk;
ALTER TABLE bs.salesByItemTypeDay DROP COLUMN saleComponent;