salix/db/versions/.archive/10332-greenMedeola/00-firstScript.sql

11 lines
431 B
MySQL
Raw Permalink Normal View History

ALTER TABLE vn.itemShelving DROP COLUMN deep__;
ALTER TABLE vn.itemShelving DROP COLUMN quantity__;
ALTER TABLE vn.itemShelving DROP COLUMN available__;
ALTER TABLE vn.itemShelving DROP COLUMN level__;
-- deprecar shelve, priority, stars
ALTER TABLE vn.itemShelving RENAME COLUMN shelve TO shelve__;
ALTER TABLE vn.itemShelving RENAME COLUMN `priority` TO priority__;
ALTER TABLE vn.itemShelving RENAME COLUMN stars TO stars__;