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) SELECT CONCAT(name, '_2') AS name, title, value, description 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) SELECT CONCAT(name, '_2') AS name, title, value, description 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) SELECT CONCAT(name, '_2') AS name, title, value, description FROM sys_setting WHERE name IN ( 'default_image_store_logo', 'default_image_user_portrait', 'default_image_store_banner_pc', 'default_image_store_list_top' ); ALTER TABLE sys_seo ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER id; ALTER TABLE goods_category ADD COLUMN web_site TINYINT NOT NULL DEFAULT 1 COMMENT '站点 1:海外门户 2:国内分销门户' AFTER category_id;