salix/db/versions/10835-brownCarnation/29-buy_edi_k012.sql

5 lines
256 B
MySQL
Raw Permalink Normal View History

ALTER TABLE IF EXISTS `vn2008`.`buy_edi_k012` RENAME `edi`.`ektK1`;
ALTER TABLE IF EXISTS `edi`.`ektK1`
CHANGE COLUMN IF EXISTS `buy_edi_k012_id` `id` smallint(6) unsigned NOT NULL,
CHANGE COLUMN IF EXISTS `description` `description` varchar(50) NOT NULL;