dev615.sql
679 Bytes
-- yhb_operations
ALTER TABLE `yhb_operations`.`operation_sorts`
ADD COLUMN `is_new_page` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT 'Y:新页面打开;N:当前页面打开' AFTER `sort_ico_big`;
-- yh_events
ALTER TABLE `yh_events`.`special_activity` ADD COLUMN `web_cover_url` varchar(300) NULL AFTER `cover_url`;
ALTER TABLE `yh_events`.`special_activity` MODIFY COLUMN `yh_channel` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' AFTER `order_num`;
ALTER TABLE `yh_events`.`special_activity`
MODIFY COLUMN `plateform` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `title`;