salix/db/versions/10835-brownCarnation/27-awb_unit.sql

4 lines
168 B
SQL

ALTER TABLE `vn2008`.`awb_unit` RENAME `vn`.`awbUnit`;
ALTER TABLE IF EXISTS `vn`.`awbUnit`
CHANGE COLUMN IF EXISTS `awb_unit_id` `id` varchar(10) NOT NULL DEFAULT '';