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`;