salix/db/versions/10835-brownCarnation/31-buy_edi_k04.sql

5 lines
254 B
MySQL
Raw Permalink Normal View History

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