salix/db/versions/10835-brownCarnation/30-buy_edi_k03.sql

5 lines
254 B
SQL

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