xinkeaboard/xinkeaboard-server/doc/DDL/update.sql

ALTER TABLE member
ADD COLUMN country VARCHAR(100) NULL COMMENT '国家',
ADD COLUMN city VARCHAR(100) NULL COMMENT '城市',
ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '会员类型 1:海外门户 2:国内分销门户';

ALTER TABLE goods ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '发布站点 1：国外站 2：国内站' AFTER goods_id;

ALTER TABLE goods ADD COLUMN goods_name_cn VARCHAR(200) NOT NULL COMMENT '商品中文名' AFTER goods_name ;

ALTER TABLE product ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '发布站点 1：国外站 2：国内站' AFTER product_id;

ALTER TABLE product ADD COLUMN goods_name_cn VARCHAR(200) NOT NULL COMMENT '商品中文名' AFTER goods_name;

ALTER TABLE goods_related_template ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

ALTER TABLE goods_parameter_group ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

ALTER TABLE enquiry ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

ALTER TABLE  enquiry_receive_mail_setting ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

ALTER TABLE  sys_tpl_pc_mall_data ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

ALTER TABLE  sys_tpl_pc_mall_deco ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER deco_id;

ALTER TABLE  store_inner_label ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER inner_label_id;

ALTER TABLE  goods_brand ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER brand_id;

ALTER TABLE  store_profile_text_list ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id;

ALTER TABLE  store_profile_list ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id;

ALTER TABLE  store_certificate_list ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id;

ALTER TABLE  store_company_show_list ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id;

ALTER TABLE  store_bind_category ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户';

CREATE TABLE `store_name`
(
    `id`          bigint                                                  NOT NULL AUTO_INCREMENT COMMENT 'id',
    `web_site`    tinyint                                                 NOT NULL DEFAULT 1 COMMENT '站点',
    `store_id`    bigint                                                  NOT NULL COMMENT '店铺ID',
    `store_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺名称',

    `create_id`   bigint                                                  NOT NULL COMMENT '创建人',
    `create_time` datetime                                                NOT NULL COMMENT '创建时间',

    `update_id`   bigint                                                           DEFAULT NULL COMMENT '更新人',
    `update_time` datetime                                                         DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='店铺名称表';



CREATE TABLE `store_site_info`
(
    `id`               bigint                                                  NOT NULL AUTO_INCREMENT COMMENT 'id',
    `web_site`         tinyint                                                 NOT NULL DEFAULT 1 COMMENT '站点',
    `store_id`         bigint                                                  NOT NULL COMMENT '店铺ID',
    `store_logo`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺logo',
    `store_banner_pc`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'pc端店铺横幅',
    `main_business`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺主营商品名称',
    `service_phone`    varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci  NOT NULL COMMENT '店铺客服电话',
    `email`            varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
    `address`          varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺开店详细地址',
    `store_map_info`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺地图参数-经度',
    `store_map_info_w` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺地图参数-维度',
    `create_id`        bigint                                                  NOT NULL COMMENT '创建人',
    `create_time`      datetime                                                NOT NULL COMMENT '创建时间',

    `update_id`        bigint                                                           DEFAULT NULL COMMENT '更新人',
    `update_time`      datetime                                                         DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='店铺站点基础设置表';

ALTER TABLE  stats_brand_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_brand_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_brand_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_brand_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_brand_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_category_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_category_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_category_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_category_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_category_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_goods_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_goods_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_goods_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_goods_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_goods_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_member_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_member_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_member_store_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_store_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_store_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_member_store_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_member_store_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_store_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_store_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_store_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_store_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_store_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


ALTER TABLE  stats_platform_day ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_platform_hour ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_platform_month ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE  stats_platform_week ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;

ALTER TABLE stats_platform_year ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER stats_time;


INSERT INTO sys_setting (name, title, value, description, type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name IN (
               'basic_site_name', 'basic_site_icp', 'basic_site_copyright', 'basic_site_technical_support',
               'basic_site_phone', 'basic_site_email',
               'hot_search_words', 'verification_code_check_is_enable',
               'sys_seo_title', 'sys_seo_desc', 'sys_seo_keywords', 'pt_map_parameter', 'pt_map_parameter_1',
               'about_banner', 'about_pic', 'about_text',
               'basic_site_address', 'gz_code', 'guide_funds_banner', 'guide_funds_text'
    );


INSERT INTO sys_setting (name, title, value, description,type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name IN (
               'main_site_logo', 'main_user_center_logo', 'main_user_logon_bg', 'main_user_register_bg',
               'pc_home_bottom_adv', 'main_user_forget_password_bg',
               'main_user_register_logo', 'main_seller_center_logo', 'vendor_login_left_bg', 'vendor_login_bg',
               'main_admin_top_logo', 'admin_login_left_bg', 'admin_login_bg'
    );

INSERT INTO sys_setting (name, title, value, description,type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name IN (
               'default_image_store_logo', 'default_image_user_portrait', 'default_image_store_banner_pc',
               'default_image_store_list_top'
    );

INSERT INTO sys_setting (name, title, value, description,type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name = 'seller_center_entrance_is_enable';

INSERT INTO sys_setting (name, title, value, description,type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name = 'pay_test_enable';

ALTER TABLE sys_seo DROP INDEX code_UNIQUE;

ALTER TABLE sys_seo ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id;


ALTER TABLE sys_agreement ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER agreement_code;
INSERT INTO sys_agreement (agreement_code, web_site, title, update_time, update_admin_id, update_admin_name, content)
SELECT CONCAT(agreement_code, '_2') AS agreement_code,
       '2',
       title,
       update_time,
       update_admin_id,
       update_admin_name,
       ''
FROM sys_agreement;

INSERT INTO sys_setting (name, title, value, description,type)
SELECT CONCAT(name, '_2') AS name,
       title,
       value,
       description,
       type
FROM sys_setting
WHERE name = 'goods_publish_need_audit';

ALTER TABLE goods_category ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER category_id;

ALTER TABLE goods_attribute ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER attribute_id;