ALTER TABLE `redpack`.`ims_red_activity`
ADD COLUMN `parent_activity_id` int(11) COMMENT '上级关联活动' AFTER `remark`,
ADD COLUMN `is_hide` int(2)  NOT NULL COMMENT '是否显示' AFTER `parent_activity_id`;
--------------------------2018-11-15--------------------------



ALTER TABLE `redpack`.`ims_ewei_shop_member`
ADD COLUMN `admin_account_all` int(5) COMMENT '所有门店' AFTER `admin_goods_id`,
ADD COLUMN `admin_goods_all` int(5) COMMENT '所有商品' AFTER `admin_account_all`;

ALTER TABLE `redpack`.`ims_ewei_shop_member`
ADD COLUMN `admin_account_id` text COMMENT '内部人员拥有管理权门店' AFTER `remark`,
ADD COLUMN `admin_goods_id` text COMMENT '内部人员拥有管理权商品按标签' AFTER `admin_account_id`;
-------------------18-10-31--------------------------------------------


ALTER TABLE `redpack`.`ims_red_order`
ADD COLUMN `account_id` int(11) NOT NULL COMMENT '门店id' AFTER `order_num`,
ADD COLUMN `sign_name` varchar(100) NOT NULL COMMENT '门店名称' AFTER `account_id`;
------------------18-10-29----------------------------------------------


增加表ims_red_order_detail_log

ALTER TABLE `redpack`.`ims_mc_credits_record`
MODIFY COLUMN `uid` varchar(100) NOT NULL AFTER `id`;

ALTER TABLE `redpack`.`ims_mc_credits_record`
MODIFY COLUMN `credittype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `uniacid`;
--------------------18-9-25----------------------------------------------