etrade / dili-xtrade · Files

ALTER TABLE `dili_etrade`.`shop` ADD COLUMN `district_id`  bigint DEFAULT NULL COMMENT '区域id' AFTER `version`;
ALTER TABLE `dili_etrade`.`shop` ADD COLUMN `district_name`  varchar(100) DEFAULT NULL COMMENT '区域名称' AFTER `district_id`;
ALTER TABLE `dili_etrade`.`shop` ADD COLUMN `sub_district_id`  bigint DEFAULT NULL COMMENT '二级区域id' AFTER `district_name`;
ALTER TABLE `dili_etrade`.`shop` ADD COLUMN `sub_district_name`  varchar(100) DEFAULT NULL COMMENT '二级区域名称' AFTER `sub_district_id`;



ALTER TABLE `dili_etrade`.`shop_approve` ADD COLUMN `district_id`  bigint DEFAULT NULL COMMENT '区域id' AFTER `version`;
ALTER TABLE `dili_etrade`.`shop_approve` ADD COLUMN `district_name`  varchar(100) DEFAULT NULL COMMENT '区域名称' AFTER `district_id`;
ALTER TABLE `dili_etrade`.`shop_approve` ADD COLUMN `sub_district_id`  bigint DEFAULT NULL COMMENT '二级区域id' AFTER `district_name`;
ALTER TABLE `dili_etrade`.`shop_approve` ADD COLUMN `sub_district_name`  varchar(100) DEFAULT NULL COMMENT '二级区域名称' AFTER `sub_district_id`;


USE `dili_etrade`;
-- shop_introduction_temp: table
DROP TABLE IF EXISTS `dili_etrade`.`shop_introduction_temp`;
CREATE TABLE `dili_etrade`.`shop_introduction_temp` (
                                                        `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
                                                        `shop_id` bigint NOT NULL COMMENT '店铺id',
                                                        `market_id` bigint NOT NULL COMMENT '市场id',
                                                        `introduction` text NOT NULL COMMENT '店铺介绍',
                                                        `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                                        `modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 COMMENT='店铺介绍临时缓存';