salix/db/versions/11285-orangeErica/00-firstScript.sql

4 lines
179 B
MySQL
Raw Permalink Normal View History

-- Place your SQL code here
ALTER TABLE vn.itemShelving DROP COLUMN IF EXISTS isMoving;
ALTER TABLE vn.itemShelving ADD IF NOT EXISTS movingState ENUM('selected','printed') NULL;