942 lines
57 KiB
SQL
942 lines
57 KiB
SQL
-- ======================================================================
|
||
-- Wuhan Saga - Fresh DB (CREATE DATABASE + schema + seed data)
|
||
-- Generated: scripts/build-fresh-install-sql.ps1 (edit source files, re-run script)
|
||
-- Run: mysql -u root -p < database/wuhan_saga_fresh_install.sql
|
||
-- MySQL 5.7+ / 8.0+, utf8mb4
|
||
-- ======================================================================
|
||
|
||
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
CREATE DATABASE IF NOT EXISTS wuhan_saga
|
||
CHARACTER SET utf8mb4
|
||
COLLATE utf8mb4_unicode_ci;
|
||
|
||
USE wuhan_saga;
|
||
-- ================================================================
|
||
-- Wuhan Saga official website - Schema Initialization
|
||
-- MySQL 5.7+ / 8.0+ | utf8mb4 | InnoDB
|
||
-- Spring Boot will execute this file first, then data.sql
|
||
-- ================================================================
|
||
|
||
-- 必须用 UTF-8 连接执行；否则中文会变成乱码
|
||
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
||
-- ================================================================
|
||
-- 系统用户表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS sys_user (
|
||
user_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
username VARCHAR(64) NOT NULL COMMENT '用户名',
|
||
password VARCHAR(200) NOT NULL COMMENT '密码(BCrypt)',
|
||
nickname VARCHAR(100) COMMENT '昵称',
|
||
avatar VARCHAR(255) COMMENT '头像路径',
|
||
email VARCHAR(100) COMMENT '邮箱',
|
||
phone VARCHAR(20) COMMENT '手机号',
|
||
status TINYINT(1) NOT NULL DEFAULT 1 COMMENT '状态：0禁用 1正常',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (user_id),
|
||
UNIQUE KEY uk_sys_user_username (username)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户表';
|
||
|
||
-- ================================================================
|
||
-- 公司信息表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_company_info (
|
||
company_info_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '公司名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '公司名称（英文）',
|
||
established_year INT NOT NULL COMMENT '成立年份',
|
||
business_scope_zh TEXT COMMENT '主营业务（中文）',
|
||
business_scope_en TEXT COMMENT '主营业务（英文）',
|
||
core_data_zh TEXT COMMENT '核心数据（中文）',
|
||
core_data_en TEXT COMMENT '核心数据（英文）',
|
||
technical_source_zh TEXT COMMENT '技术来源（中文）',
|
||
technical_source_en TEXT COMMENT '技术来源（英文）',
|
||
markets VARCHAR(500) COMMENT '覆盖市场（逗号分隔）',
|
||
vision_zh TEXT COMMENT '企业愿景（中文）',
|
||
vision_en TEXT COMMENT '企业愿景（英文）',
|
||
mission_zh TEXT COMMENT '企业使命（中文）',
|
||
mission_en TEXT COMMENT '企业使命（英文）',
|
||
values_zh VARCHAR(500) COMMENT '核心价值观（中文）',
|
||
values_en VARCHAR(500) COMMENT '核心价值观（英文）',
|
||
spirit_zh VARCHAR(200) COMMENT '企业精神（中文）',
|
||
spirit_en VARCHAR(200) COMMENT '企业精神（英文）',
|
||
phone VARCHAR(50) COMMENT '联系电话',
|
||
email VARCHAR(100) COMMENT '电子邮箱',
|
||
address_zh VARCHAR(500) COMMENT '公司地址（中文）',
|
||
address_en VARCHAR(500) COMMENT '公司地址（英文）',
|
||
website VARCHAR(200) COMMENT '官网地址',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (company_info_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公司信息';
|
||
|
||
-- ================================================================
|
||
-- 联系方式表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_contact (
|
||
contact_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
company_info_id BIGINT NOT NULL COMMENT '关联公司',
|
||
phone VARCHAR(50) COMMENT '电话',
|
||
fax VARCHAR(50) COMMENT '传真',
|
||
email VARCHAR(100) COMMENT '邮箱',
|
||
address_zh VARCHAR(500) COMMENT '地址（中文）',
|
||
address_en VARCHAR(500) COMMENT '地址（英文）',
|
||
zip_code VARCHAR(20) COMMENT '邮编',
|
||
map_coordinates VARCHAR(100) COMMENT '地图坐标',
|
||
business_hours_zh VARCHAR(200) COMMENT '营业时间（中文）',
|
||
business_hours_en VARCHAR(200) COMMENT '营业时间（英文）',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (contact_id),
|
||
KEY idx_f_contact_company (company_info_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='联系方式';
|
||
|
||
-- ================================================================
|
||
-- 关于我们表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_about (
|
||
about_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
company_info_id BIGINT NOT NULL COMMENT '关联公司',
|
||
section_type VARCHAR(50) NOT NULL COMMENT '内容类型',
|
||
title_zh VARCHAR(200) NOT NULL COMMENT '标题（中文）',
|
||
title_en VARCHAR(200) NOT NULL COMMENT '标题（英文）',
|
||
content_zh TEXT COMMENT '内容（中文）',
|
||
content_en TEXT COMMENT '内容（英文）',
|
||
image_path VARCHAR(255) COMMENT '配图相对路径',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (about_id),
|
||
KEY idx_f_about_company (company_info_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='关于我们';
|
||
|
||
-- ================================================================
|
||
-- 轮播图表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_banner (
|
||
banner_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
company_info_id BIGINT NOT NULL DEFAULT 1 COMMENT '关联公司',
|
||
image_path VARCHAR(255) NOT NULL COMMENT '图片相对路径',
|
||
title_zh VARCHAR(200) NOT NULL COMMENT '标题（中文）',
|
||
title_en VARCHAR(200) NOT NULL COMMENT '标题（英文）',
|
||
subtitle_zh VARCHAR(500) COMMENT '副标题（中文）',
|
||
subtitle_en VARCHAR(500) COMMENT '副标题（英文）',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (banner_id),
|
||
KEY idx_f_banner_company (company_info_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='轮播图';
|
||
|
||
-- ================================================================
|
||
-- 车间展示表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_workshop (
|
||
workshop_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
company_info_id BIGINT NOT NULL COMMENT '关联公司',
|
||
workshop_type VARCHAR(50) NOT NULL COMMENT '车间类型',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '车间名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '车间名称（英文）',
|
||
description_zh TEXT COMMENT '描述（中文）',
|
||
description_en TEXT COMMENT '描述（英文）',
|
||
equipment_list_zh TEXT COMMENT '设备清单（中文）',
|
||
equipment_list_en TEXT COMMENT '设备清单（英文）',
|
||
area_size VARCHAR(50) COMMENT '占地面积',
|
||
image_path VARCHAR(255) COMMENT '配图相对路径',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (workshop_id),
|
||
KEY idx_f_workshop_company (company_info_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='车间展示';
|
||
|
||
-- ================================================================
|
||
-- 核心技术表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_core_technology (
|
||
core_technology_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '技术名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '技术名称（英文）',
|
||
description_zh TEXT COMMENT '技术描述（中文）',
|
||
description_en TEXT COMMENT '技术描述（英文）',
|
||
advantages_zh TEXT COMMENT '技术优势（中文）',
|
||
advantages_en TEXT COMMENT '技术优势（英文）',
|
||
icon_class VARCHAR(100) COMMENT '图标类名',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (core_technology_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='核心技术';
|
||
|
||
-- ================================================================
|
||
-- 产品分类表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_product_category (
|
||
product_category_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
name_zh VARCHAR(100) NOT NULL COMMENT '分类名称（中文）',
|
||
name_en VARCHAR(100) NOT NULL COMMENT '分类名称（英文）',
|
||
module_type VARCHAR(20) NOT NULL DEFAULT 'product_line' COMMENT '模块类型 product_line/equipment/spare_part',
|
||
parent_id BIGINT NULL COMMENT '父分类ID',
|
||
icon_class VARCHAR(100) COMMENT '图标类名',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (product_category_id),
|
||
KEY idx_f_product_category_parent (parent_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品分类';
|
||
|
||
-- ================================================================
|
||
-- 成套机组产品表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_product_line (
|
||
product_line_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
category_id BIGINT NOT NULL COMMENT '所属分类',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '产品名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '产品名称（英文）',
|
||
short_name VARCHAR(50) COMMENT '简称或缩写',
|
||
description_zh TEXT COMMENT '产品描述（中文）',
|
||
description_en TEXT COMMENT '产品描述（英文）',
|
||
specifications_zh TEXT COMMENT '技术规格（中文）',
|
||
specifications_en TEXT COMMENT '技术规格（英文）',
|
||
capacity VARCHAR(200) COMMENT '产能或产量数据',
|
||
applications_zh TEXT COMMENT '应用领域（中文）',
|
||
applications_en TEXT COMMENT '应用领域（英文）',
|
||
achievements VARCHAR(200) COMMENT '业绩数据',
|
||
excerpt_zh VARCHAR(500) COMMENT '列表摘要（中文）',
|
||
excerpt_en VARCHAR(500) COMMENT '列表摘要（英文）',
|
||
content_zh MEDIUMTEXT COMMENT '详情正文HTML（中文）',
|
||
content_en MEDIUMTEXT COMMENT '详情正文HTML（英文）',
|
||
cover_image VARCHAR(500) COMMENT '封面图路径',
|
||
meta_title_zh VARCHAR(200) COMMENT 'SEO标题（中文）',
|
||
meta_title_en VARCHAR(200) COMMENT 'SEO标题（英文）',
|
||
meta_description_zh VARCHAR(500) COMMENT 'SEO描述（中文）',
|
||
meta_description_en VARCHAR(500) COMMENT 'SEO描述（英文）',
|
||
meta_keywords VARCHAR(500) COMMENT 'SEO关键词',
|
||
is_featured TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否推荐',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (product_line_id),
|
||
KEY idx_f_product_line_category (category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='成套机组产品';
|
||
|
||
-- ================================================================
|
||
-- 单体设备表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_single_equipment (
|
||
single_equipment_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
category_id BIGINT NOT NULL COMMENT '所属分类',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '设备名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '设备名称（英文）',
|
||
description_zh TEXT COMMENT '设备描述（中文）',
|
||
description_en TEXT COMMENT '设备描述（英文）',
|
||
technical_highlights_zh TEXT COMMENT '技术亮点（中文）',
|
||
technical_highlights_en TEXT COMMENT '技术亮点（英文）',
|
||
specifications_zh TEXT COMMENT '技术参数（中文）',
|
||
specifications_en TEXT COMMENT '技术参数（英文）',
|
||
excerpt_zh VARCHAR(500) COMMENT '列表摘要（中文）',
|
||
excerpt_en VARCHAR(500) COMMENT '列表摘要（英文）',
|
||
content_zh MEDIUMTEXT COMMENT '详情正文HTML（中文）',
|
||
content_en MEDIUMTEXT COMMENT '详情正文HTML（英文）',
|
||
cover_image VARCHAR(500) COMMENT '封面图路径',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (single_equipment_id),
|
||
KEY idx_f_single_equipment_category (category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='单体设备';
|
||
|
||
-- ================================================================
|
||
-- 备品备件表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_spare_part (
|
||
spare_part_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
category_id BIGINT NOT NULL COMMENT '所属分类',
|
||
name_zh VARCHAR(200) NOT NULL COMMENT '备件名称（中文）',
|
||
name_en VARCHAR(200) NOT NULL COMMENT '备件名称（英文）',
|
||
model VARCHAR(100) COMMENT '型号规格',
|
||
description_zh TEXT COMMENT '描述（中文）',
|
||
description_en TEXT COMMENT '描述（英文）',
|
||
material VARCHAR(200) COMMENT '材质',
|
||
applications TEXT COMMENT '应用场景',
|
||
excerpt_zh VARCHAR(500) COMMENT '列表摘要（中文）',
|
||
excerpt_en VARCHAR(500) COMMENT '列表摘要（英文）',
|
||
content_zh MEDIUMTEXT COMMENT '详情正文HTML（中文）',
|
||
content_en MEDIUMTEXT COMMENT '详情正文HTML（英文）',
|
||
cover_image VARCHAR(500) COMMENT '封面图路径',
|
||
specifications_zh TEXT COMMENT '技术参数（中文）',
|
||
specifications_en TEXT COMMENT '技术参数（英文）',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (spare_part_id),
|
||
KEY idx_f_spare_part_category (category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='备品备件';
|
||
|
||
-- ================================================================
|
||
-- 案例分类表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_case_category (
|
||
case_category_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
name_zh VARCHAR(100) NOT NULL COMMENT '分类名称（中文）',
|
||
name_en VARCHAR(100) NOT NULL COMMENT '分类名称（英文）',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (case_category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='案例分类';
|
||
|
||
-- ================================================================
|
||
-- 成功案例表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_case_study (
|
||
case_study_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
category_id BIGINT NOT NULL COMMENT '所属分类',
|
||
client_name_zh VARCHAR(200) NOT NULL COMMENT '客户名称（中文）',
|
||
client_name_en VARCHAR(200) NOT NULL COMMENT '客户名称（英文）',
|
||
project_name_zh VARCHAR(200) COMMENT '项目名称（中文）',
|
||
project_name_en VARCHAR(200) COMMENT '项目名称（英文）',
|
||
location VARCHAR(200) COMMENT '项目地点',
|
||
description_zh TEXT COMMENT '项目描述（中文）',
|
||
description_en TEXT COMMENT '项目描述（英文）',
|
||
scope_zh TEXT COMMENT '项目范围（中文）',
|
||
scope_en TEXT COMMENT '项目范围（英文）',
|
||
achievement_zh TEXT COMMENT '项目成果（中文）',
|
||
achievement_en TEXT COMMENT '项目成果（英文）',
|
||
is_overseas TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否海外项目',
|
||
is_featured TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否推荐',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (case_study_id),
|
||
KEY idx_f_case_study_category (category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='成功案例';
|
||
|
||
-- ================================================================
|
||
-- 新闻分类表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_news_category (
|
||
category_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
name_zh VARCHAR(100) NOT NULL COMMENT '分类名称（中文）',
|
||
name_en VARCHAR(100) NOT NULL COMMENT '分类名称（英文）',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (category_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='新闻分类';
|
||
|
||
-- ================================================================
|
||
-- 新闻文章表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_news (
|
||
news_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
category_id BIGINT NOT NULL COMMENT '所属分类',
|
||
title_zh VARCHAR(200) NOT NULL COMMENT '标题（中文）',
|
||
title_en VARCHAR(200) NOT NULL COMMENT '标题（英文）',
|
||
excerpt_zh TEXT COMMENT '摘要（中文）',
|
||
excerpt_en TEXT COMMENT '摘要（英文）',
|
||
content_zh LONGTEXT COMMENT '正文（中文）',
|
||
content_en LONGTEXT COMMENT '正文（英文）',
|
||
cover_image VARCHAR(255) COMMENT '封面图相对路径',
|
||
meta_title_zh VARCHAR(200) COMMENT 'SEO标题（中文）',
|
||
meta_title_en VARCHAR(200) COMMENT 'SEO标题（英文）',
|
||
meta_description_zh VARCHAR(500) COMMENT 'SEO描述（中文）',
|
||
meta_description_en VARCHAR(500) COMMENT 'SEO描述（英文）',
|
||
meta_keywords VARCHAR(500) COMMENT 'SEO关键词',
|
||
is_featured TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否推荐',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
view_count INT NOT NULL DEFAULT 0 COMMENT '浏览量',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (news_id),
|
||
KEY idx_f_news_category (category_id),
|
||
KEY idx_f_news_create_time (create_time)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='新闻文章';
|
||
|
||
-- ================================================================
|
||
-- 媒体库表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_media_library (
|
||
media_library_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
file_path VARCHAR(255) NOT NULL COMMENT '文件相对路径',
|
||
file_name VARCHAR(200) NOT NULL COMMENT '文件名',
|
||
file_type VARCHAR(50) COMMENT '文件类型',
|
||
category VARCHAR(50) COMMENT '资源分类',
|
||
title_zh VARCHAR(200) COMMENT '标题（中文）',
|
||
title_en VARCHAR(200) COMMENT '标题（英文）',
|
||
description_zh VARCHAR(500) COMMENT '描述（中文）',
|
||
description_en VARCHAR(500) COMMENT '描述（英文）',
|
||
file_size BIGINT COMMENT '文件大小字节',
|
||
width INT COMMENT '宽度像素',
|
||
height INT COMMENT '高度像素',
|
||
is_published TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否发布',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (media_library_id),
|
||
KEY idx_f_media_library_category (category)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='媒体库';
|
||
|
||
-- ================================================================
|
||
-- 产品与媒体关联表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_product_media (
|
||
product_media_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
product_id BIGINT NOT NULL COMMENT '成套机组产品ID',
|
||
media_id BIGINT NOT NULL COMMENT '媒体库ID',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (product_media_id),
|
||
UNIQUE KEY uk_f_product_media_pair (product_id, media_id),
|
||
KEY idx_f_product_media_media (media_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品与媒体关联';
|
||
|
||
-- ================================================================
|
||
-- 案例与媒体关联表
|
||
-- ================================================================
|
||
CREATE TABLE IF NOT EXISTS f_case_media (
|
||
case_media_id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
case_id BIGINT NOT NULL COMMENT '案例ID',
|
||
media_id BIGINT NOT NULL COMMENT '媒体库ID',
|
||
sort_order INT NOT NULL DEFAULT 0 COMMENT '排序',
|
||
create_by VARCHAR(64) DEFAULT NULL COMMENT '创建人',
|
||
update_by VARCHAR(64) DEFAULT NULL COMMENT '更新人',
|
||
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
|
||
del_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '删除标志：0正常 1删除',
|
||
PRIMARY KEY (case_media_id),
|
||
UNIQUE KEY uk_f_case_media_pair (case_id, media_id),
|
||
KEY idx_f_case_media_media (media_id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='案例与媒体关联';
|
||
|
||
-- ================================================================
|
||
-- FULLTEXT索引 (MySQL 5.7+)
|
||
-- ================================================================
|
||
ALTER TABLE f_product_line ADD FULLTEXT INDEX ft_product_line_zh (name_zh, description_zh, specifications_zh);
|
||
ALTER TABLE f_product_line ADD FULLTEXT INDEX ft_product_line_en (name_en, description_en, specifications_en);
|
||
|
||
ALTER TABLE f_single_equipment ADD FULLTEXT INDEX ft_single_equipment_zh (name_zh, description_zh, technical_highlights_zh);
|
||
ALTER TABLE f_single_equipment ADD FULLTEXT INDEX ft_single_equipment_en (name_en, description_en, technical_highlights_en);
|
||
|
||
ALTER TABLE f_spare_part ADD FULLTEXT INDEX ft_spare_part_zh (name_zh, description_zh);
|
||
ALTER TABLE f_spare_part ADD FULLTEXT INDEX ft_spare_part_en (name_en, description_en);
|
||
|
||
ALTER TABLE f_case_study ADD FULLTEXT INDEX ft_case_study_zh (client_name_zh, project_name_zh, description_zh);
|
||
ALTER TABLE f_case_study ADD FULLTEXT INDEX ft_case_study_en (client_name_en, project_name_en, description_en);
|
||
|
||
ALTER TABLE f_news ADD FULLTEXT INDEX ft_news_zh (title_zh, excerpt_zh, content_zh);
|
||
ALTER TABLE f_news ADD FULLTEXT INDEX ft_news_en (title_en, excerpt_en, content_en);
|
||
|
||
-- ================================================================
|
||
-- 外键约束
|
||
-- ================================================================
|
||
ALTER TABLE f_product_category
|
||
ADD CONSTRAINT fk_f_product_category_parent
|
||
FOREIGN KEY (parent_id) REFERENCES f_product_category (product_category_id)
|
||
ON DELETE SET NULL ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_banner
|
||
ADD CONSTRAINT fk_f_banner_company
|
||
FOREIGN KEY (company_info_id) REFERENCES f_company_info (company_info_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_about
|
||
ADD CONSTRAINT fk_f_about_company
|
||
FOREIGN KEY (company_info_id) REFERENCES f_company_info (company_info_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_workshop
|
||
ADD CONSTRAINT fk_f_workshop_company
|
||
FOREIGN KEY (company_info_id) REFERENCES f_company_info (company_info_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_contact
|
||
ADD CONSTRAINT fk_f_contact_company
|
||
FOREIGN KEY (company_info_id) REFERENCES f_company_info (company_info_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_product_line
|
||
ADD CONSTRAINT fk_f_product_line_category
|
||
FOREIGN KEY (category_id) REFERENCES f_product_category (product_category_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_single_equipment
|
||
ADD CONSTRAINT fk_f_single_equipment_category
|
||
FOREIGN KEY (category_id) REFERENCES f_product_category (product_category_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_spare_part
|
||
ADD CONSTRAINT fk_f_spare_part_category
|
||
FOREIGN KEY (category_id) REFERENCES f_product_category (product_category_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_case_study
|
||
ADD CONSTRAINT fk_f_case_study_category
|
||
FOREIGN KEY (category_id) REFERENCES f_case_category (case_category_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_news
|
||
ADD CONSTRAINT fk_f_news_category
|
||
FOREIGN KEY (category_id) REFERENCES f_news_category (category_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_product_media
|
||
ADD CONSTRAINT fk_f_product_media_product
|
||
FOREIGN KEY (product_id) REFERENCES f_product_line (product_line_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE,
|
||
ADD CONSTRAINT fk_f_product_media_media
|
||
FOREIGN KEY (media_id) REFERENCES f_media_library (media_library_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
ALTER TABLE f_case_media
|
||
ADD CONSTRAINT fk_f_case_media_case
|
||
FOREIGN KEY (case_id) REFERENCES f_case_study (case_study_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE,
|
||
ADD CONSTRAINT fk_f_case_media_media
|
||
FOREIGN KEY (media_id) REFERENCES f_media_library (media_library_id)
|
||
ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
||
-- ================================================================
|
||
-- Wuhan Saga official website - Data Initialization
|
||
-- Spring Boot will execute this file after schema.sql
|
||
-- ================================================================
|
||
|
||
-- 必须用 UTF-8 连接执行；否则中文会变成乱码
|
||
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
||
-- ================================================================
|
||
-- 系统用户（管理员）
|
||
-- ================================================================
|
||
INSERT INTO sys_user (username, password, nickname, status) VALUES
|
||
('admin', '$2a$10$mKCJqgXbF53ZMUSykD.dSOaBQ30I5IVZk8x4PmpETgXkCD8403GVa', '管理员', 1)
|
||
ON DUPLICATE KEY UPDATE nickname = VALUES(nickname), status = VALUES(status);
|
||
|
||
-- ================================================================
|
||
-- 公司信息
|
||
-- ================================================================
|
||
INSERT INTO f_company_info (
|
||
company_info_id, name_zh, name_en, established_year,
|
||
business_scope_zh, business_scope_en,
|
||
core_data_zh, core_data_en,
|
||
technical_source_zh, technical_source_en,
|
||
markets,
|
||
vision_zh, vision_en, mission_zh, mission_en,
|
||
values_zh, values_en, spirit_zh, spirit_en,
|
||
website
|
||
) VALUES (
|
||
1,
|
||
'武汉萨格工程技术有限公司',
|
||
'Wuhan Saga Engineering Technology Co., Ltd.',
|
||
2020,
|
||
'集板带后处理为主营业务的金属深加工技术和装备供应商。',
|
||
'Metal deep processing technology and equipment supplier focused on strip post-processing.',
|
||
'已向国内外客户提供20套连续板带处理生产线；参与制定相关行业产品国家标准。',
|
||
'Delivered 20+ continuous strip processing lines worldwide; contributed to national standards for related industry products.',
|
||
'技术团队来自原冶金部部属设计研究院及国内钢铁企业设计院，组合国外知名公司工作经历与留学归国人员。',
|
||
'Technical team from former Ministry of Metallurgy design institutes and major domestic steel design institutes, complemented by professionals with overseas experience.',
|
||
'俄罗斯、乌兹别克斯坦、土耳其、南美洲',
|
||
'以先进的板材处理技术和优质的服务，做全球知名的装备供应商。',
|
||
'To be a worldwide known equipment supplier by advanced strip processing technology and superior services.',
|
||
'以板材处理技术为核心，向国内外用户提供先进完善的板材系统解决方案。',
|
||
'Based on strip processing technology, provide advanced and complete strip system solutions for customers at home and abroad.',
|
||
'诚信、尊重、公平、多元',
|
||
'Integrity, respect, fairness, diversity',
|
||
'创新、团结、高效',
|
||
'Innovation, unity, and efficiency',
|
||
'https://www.wuhansaga.com/'
|
||
) ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), established_year = VALUES(established_year),
|
||
business_scope_zh = VALUES(business_scope_zh), business_scope_en = VALUES(business_scope_en),
|
||
core_data_zh = VALUES(core_data_zh), core_data_en = VALUES(core_data_en),
|
||
technical_source_zh = VALUES(technical_source_zh), technical_source_en = VALUES(technical_source_en),
|
||
markets = VALUES(markets), vision_zh = VALUES(vision_zh), vision_en = VALUES(vision_en),
|
||
mission_zh = VALUES(mission_zh), mission_en = VALUES(mission_en),
|
||
values_zh = VALUES(values_zh), values_en = VALUES(values_en),
|
||
spirit_zh = VALUES(spirit_zh), spirit_en = VALUES(spirit_en),
|
||
website = VALUES(website);
|
||
|
||
-- ================================================================
|
||
-- 产品分类
|
||
-- ================================================================
|
||
INSERT INTO f_product_category (product_category_id, name_zh, name_en, module_type, parent_id, sort_order) VALUES
|
||
(1, '连续涂镀机组', 'Continuous Coating Lines', 'product_line', NULL, 10),
|
||
(2, '连续热处理机组', 'Continuous Heat Treatment Lines', 'product_line', NULL, 20),
|
||
(3, '表面处理机组', 'Surface Treatment Lines', 'product_line', NULL, 30),
|
||
(4, '后处理及辅机', 'Post-processing & Auxiliary', 'product_line', NULL, 40),
|
||
(5, '单体设备', 'Single Equipment', 'equipment', NULL, 50),
|
||
(6, '备品备件', 'Spare Parts', 'spare_part', NULL, 60),
|
||
(11, '热镀锌/镀铝锌机组', 'Hot Dipped Galvanizing / Galvalume Line', 'product_line', 1, 11),
|
||
(12, '锌铝镁机组', 'Zinc Aluminum Magnesium (ZAM) Line', 'product_line', 1, 12),
|
||
(13, '彩涂机组', 'Color Coating Line (CCL)', 'product_line', 1, 13),
|
||
(21, '普碳钢连续退火线', 'Plain Carbon Steel Continuous Annealing Line', 'product_line', 2, 21),
|
||
(22, '冷轧退火镀锌两用机组', 'Annealing & Galvanizing Combo Line', 'product_line', 2, 22),
|
||
(23, '硅钢连续处理机组', 'Silicon Steel Processing Line', 'product_line', 2, 23),
|
||
(31, '碳钢酸洗机组', 'Carbon Steel Pickling Line', 'product_line', 3, 31),
|
||
(32, '不锈钢退火酸洗机组', 'Stainless Steel Annealing & Pickling Line', 'product_line', 3, 32),
|
||
(41, '拉矫/脱脂/重卷线', 'Tension Leveling, Degreasing, Re-coiling', 'product_line', 4, 41),
|
||
(200, '卷取设备', 'Reeling & Coiling Equipment', 'equipment', 5, 200),
|
||
(201, '炉类设备', 'Furnace Equipment', 'equipment', 5, 201),
|
||
(202, '涂布与焊接设备', 'Coating & Welding Equipment', 'equipment', 5, 202),
|
||
(203, '破鳞设备', 'Scale Breaking Equipment', 'equipment', 5, 203),
|
||
(204, '拉矫矫直设备', 'Leveling & Straightening Equipment', 'equipment', 5, 204),
|
||
(205, '剪切修边设备', 'Shearing & Trimming Equipment', 'equipment', 5, 205)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), module_type = VALUES(module_type),
|
||
parent_id = VALUES(parent_id), sort_order = VALUES(sort_order);
|
||
|
||
ALTER TABLE f_product_category AUTO_INCREMENT = 210;
|
||
|
||
-- ================================================================
|
||
-- 案例分类
|
||
-- ================================================================
|
||
INSERT INTO f_case_category (name_zh, name_en, sort_order) VALUES
|
||
('热镀锌/铝锌产线', 'Hot Dip Galvanizing / Galvalume', 10),
|
||
('锌铝镁产线改造', 'ZAM Line Revamp', 20),
|
||
('硅钢处理', 'Silicon Steel Processing', 30),
|
||
('不锈钢处理', 'Stainless Steel Processing', 40),
|
||
('酸洗线', 'Pickling Lines', 50),
|
||
('感应加热', 'Induction Heating', 60),
|
||
('氢气回收', 'Hydrogen Recovery', 70),
|
||
('镀后冷却', 'Post-plating Cooling', 80)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 新闻分类
|
||
-- ================================================================
|
||
INSERT INTO f_news_category (name_zh, name_en, sort_order) VALUES
|
||
('公司新闻', 'Company News', 10),
|
||
('行业动态', 'Industry News', 20),
|
||
('技术文章', 'Technical Articles', 30)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 关于我们
|
||
-- ================================================================
|
||
INSERT INTO f_about (company_info_id, section_type, title_zh, title_en, content_zh, content_en, sort_order) VALUES
|
||
(1, 'introduction', '公司简介', 'Company Profile',
|
||
'武汉萨格工程技术有限公司，是一家集板带后处理为主营业务的金属深加工技术和装备供应商。自2020年成立至今，一直致力于金属板带生产的技术研发、技术服务和装备供应。SAGA公司已在带钢酸洗机组、带钢连续热镀（铝）锌机组、带钢连续退火机组、硅钢（电工钢）全工序处理机组等领域取得优异成绩。公司专注节能环保技术研发推广，以冷轧处理技术为核心，提供先进完善的冷轧系统解决方案。',
|
||
'Wuhan Saga Engineering Technology Co., Ltd. is a metal deep processing technology and equipment supplier focused on strip post-processing. Since 2020 it has been committed to R&D, steel strip production technical services and equipment supply, with strong track record in pickling, hot dip (aluminum) zinc, continuous annealing, and full-process electrical steel lines, with emphasis on energy saving and environmental solutions.',
|
||
10),
|
||
(1, 'vision', '企业愿景', 'Vision',
|
||
'以先进的板材处理技术和优质的服务，做全球知名的装备供应商。',
|
||
'To be a worldwide known equipment supplier by advanced strip processing technology and superior services.',
|
||
20),
|
||
(1, 'mission', '企业使命', 'Mission',
|
||
'以板材处理技术为核心，向国内外用户提供先进完善的板材系统解决方案。',
|
||
'Based on strip processing technology, provide advanced strip solutions for customers at home and abroad.',
|
||
30),
|
||
(1, 'values', '核心价值观', 'Core Values',
|
||
'诚信、尊重、公平、多元',
|
||
'Integrity, respect, fairness, diversity',
|
||
40),
|
||
(1, 'spirit', '企业精神', 'Spirit',
|
||
'创新、团结、高效',
|
||
'Innovation, unity, and efficiency',
|
||
50)
|
||
ON DUPLICATE KEY UPDATE
|
||
title_zh = VALUES(title_zh), title_en = VALUES(title_en), content_zh = VALUES(content_zh),
|
||
content_en = VALUES(content_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 车间展示
|
||
-- ================================================================
|
||
INSERT INTO f_workshop (company_info_id, workshop_type, name_zh, name_en, description_zh, description_en, equipment_list_zh, equipment_list_en, area_size, sort_order) VALUES
|
||
(1, 'machining', '机加工车间', 'Machining Shop',
|
||
'占地面积4000㎡，配备各类加工机床数十台，包括铣床、车床、磨床、钻床、数控车床、龙门铣床、立式车床、插床、线切割、折弯机、数控火焰切割机、卧式镗铣床等。',
|
||
'4,000 m² machining area with dozens of machine tools including milling, turning, grinding, drilling, CNC lathes, gantry mills, vertical lathes, shaping, wire cutting, press brake, CNC flame cutting, horizontal boring-milling machines, etc.',
|
||
'6130车床、1500立式车床、插床、龙门铣床、数控车床、数控火焰切割机、卧式车床、卧式镗铣床、卧式万能铣床、线切割、折弯机。',
|
||
'6130 lathe, 1500 vertical lathe, shaping machine, gantry milling, CNC lathe, CNC flame cutting, horizontal lathe, horizontal boring-milling, universal milling, wire cutting, press brake.',
|
||
'4000㎡',
|
||
10),
|
||
(1, 'heat_treatment', '热处理车间', 'Heat Treatment Shop',
|
||
'专业从事金属材料热处理，工艺包括淬火、回火、正火、等温淬火、退火、硬化，通过加热、保温、冷却流程优化金属硬度、韧性、强度。应用领域：机械制造、汽车、冶金、航空航天、核工业、机电。',
|
||
'Professional metal heat treatment: quenching, tempering, normalizing, isothermal quenching, annealing, hardening; optimizes hardness, toughness and strength. Applications: machinery, automotive, metallurgy, aerospace, nuclear, electromechanical.',
|
||
'炉体、燃气炉、电炉、液压机、淬火槽等。',
|
||
'Furnace bodies, gas furnaces, electric furnaces, hydraulic presses, quenching tanks, etc.',
|
||
NULL,
|
||
20),
|
||
(1, 'assembly', '装配车间', 'Assembly Shop',
|
||
'负责设备组件质量检验、装配、预装、调试，是生产流程关键环节。',
|
||
'Quality inspection, assembly, pre-assembly and commissioning of equipment components — a key step in the production process.',
|
||
NULL,
|
||
NULL,
|
||
NULL,
|
||
30)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), description_zh = VALUES(description_zh),
|
||
description_en = VALUES(description_en), equipment_list_zh = VALUES(equipment_list_zh),
|
||
equipment_list_en = VALUES(equipment_list_en), area_size = VALUES(area_size), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 轮播图
|
||
-- ================================================================
|
||
INSERT INTO f_banner (company_info_id, image_path, title_zh, title_en, subtitle_zh, subtitle_en, sort_order) VALUES
|
||
(1, '/uploads/banner/banner-01.jpg', '连续板带处理产线', 'Continuous Strip Processing Lines',
|
||
'20+套连续板带处理生产线 worldwide experience', '20+ Continuous Strip Processing Lines', 1),
|
||
(1, '/uploads/banner/banner-02.jpg', '硅钢连续处理技术', 'Silicon Steel Processing',
|
||
'无取向与取向硅钢全工序处理', 'Full-process electrical steel solutions', 2),
|
||
(1, '/uploads/banner/banner-03.jpg', '感应加热解决方案', 'Induction Heating',
|
||
'电磁感应加热与节能应用', 'Advanced induction heating solutions', 3)
|
||
ON DUPLICATE KEY UPDATE
|
||
title_zh = VALUES(title_zh), title_en = VALUES(title_en), subtitle_zh = VALUES(subtitle_zh),
|
||
subtitle_en = VALUES(subtitle_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 联系方式
|
||
-- ================================================================
|
||
INSERT INTO f_contact (company_info_id, email, address_zh, address_en, business_hours_zh, business_hours_en) VALUES
|
||
(1, 'info@wuhansaga.com',
|
||
'（请填写实际办公地址）',
|
||
'(Please fill in office address)',
|
||
'工作日 9:00-17:00',
|
||
'Weekdays 9:00-17:00')
|
||
ON DUPLICATE KEY UPDATE
|
||
email = VALUES(email), address_zh = VALUES(address_zh), address_en = VALUES(address_en),
|
||
business_hours_zh = VALUES(business_hours_zh), business_hours_en = VALUES(business_hours_en);
|
||
|
||
-- ================================================================
|
||
-- 核心技术
|
||
-- ================================================================
|
||
INSERT INTO f_core_technology (name_zh, name_en, description_zh, description_en, sort_order) VALUES
|
||
('节能环保技术', 'Energy Saving & Environmental Technology',
|
||
'高效节能辐射管换热系统、热保护气体循环预热、无氧化加热、氢气回收等。',
|
||
'High-efficiency radiant tube heat recovery, protective atmosphere preheat, non-oxidizing heating, hydrogen recovery, etc.',
|
||
10),
|
||
('感应加热技术', 'Induction Heating Technology',
|
||
'感应加热、闭环温控；应用于焊缝退火、硅钢轧前加热、涂层干燥等。',
|
||
'Induction heating with closed-loop temperature control for weld annealing, electrical steel preheat, coating drying, etc.',
|
||
20),
|
||
('气雾冷却技术', 'Air-Mist Cooling Technology',
|
||
'高氢高速喷气冷却、气雾冷却、喷气冷却（BLADE喷嘴等）。',
|
||
'High-hydrogen jet cooling, air-mist and jet cooling (e.g. BLADE nozzles).',
|
||
30),
|
||
('智能控制技术', 'Intelligent Control Technology',
|
||
'智能PLC控制系统，保障机组稳定运行与工艺优化。',
|
||
'Intelligent PLC-based control for stable operation and process optimization.',
|
||
40)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), description_zh = VALUES(description_zh),
|
||
description_en = VALUES(description_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 成套机组产品
|
||
-- ================================================================
|
||
INSERT INTO f_product_line (category_id, name_zh, name_en, short_name, description_zh, description_en, specifications_zh, specifications_en, achievements, sort_order) VALUES
|
||
(11, '热镀锌/镀铝锌机组', 'Hot Dipped Galvanizing / Galvalume Line', 'GI/GL',
|
||
'带钢表面热浸镀锌/铝锌合金，阴极保护性强。',
|
||
'Hot dip zinc or zinc-aluminum alloy coating with strong cathodic protection.',
|
||
'冷轧0.12–2.5mm，热轧1.5–5mm；宽度550–1500mm；工艺速度max 200m/min（GL线可达240m/min）；炉型：卧式、立式、立卧结合。',
|
||
'CR 0.12–2.5mm, HR 1.5–5mm; width 550–1500mm; speed up to 200 m/min (GL up to 240); horizontal, vertical or hybrid furnaces.',
|
||
'国内外已建成200+条生产线', 11),
|
||
(12, '锌铝镁机组', 'Zinc Aluminum Magnesium Line', 'ZAM',
|
||
'连续热镀生产，耐腐蚀性为传统纯锌涂层10–20倍。',
|
||
'Continuous hot-dip coating; corrosion resistance 10–20× conventional zinc.',
|
||
NULL, NULL,
|
||
'多条产线应用与改造经验', 12),
|
||
(13, '彩涂机组', 'Color Coating Line', 'CCL',
|
||
'二涂二烘、三涂三烘；建材板、装饰板、家电板；涂层种类齐全。',
|
||
'2C2B / 3C3B; construction, decorative and appliance panels; multiple paint systems.',
|
||
'干膜厚度23–70μm；国内外已承建近20条。',
|
||
'Dry film 23–70 μm; nearly 20 lines delivered domestically and abroad.',
|
||
'近20条国内外', 13),
|
||
(21, '普碳钢连续退火线', 'Plain Carbon Steel Continuous Annealing Line', 'CAL',
|
||
'适用于CQ、DQ、DDQ、EDDQ、SEDDQ、HSS、T3–T5等钢种。',
|
||
'For CQ, DQ, DDQ, EDDQ, SEDDQ, HSS, T3–T5 grades.',
|
||
'规格0.15–1.5mm，宽度550–1500mm；速度max 200m/min。',
|
||
'0.15–1.5mm, width 550–1500mm; up to 200 m/min.',
|
||
'国内外近10条', 21),
|
||
(22, '冷轧板连续退火/镀锌两用机组', 'Annealing & Galvanizing Combo Line', 'CAL+CGL',
|
||
'适用SPCC、SPCD、SPCE、IF等钢种。',
|
||
'For SPCC, SPCD, SPCE, IF and similar grades.',
|
||
'厚度0.2–2.0mm，宽度800–1500mm；钢卷最大重量30T。',
|
||
'Thickness 0.2–2.0mm, width 800–1500mm; coil weight up to 30 t.',
|
||
NULL, 22),
|
||
(23, '高效电工钢（硅钢）连续处理机组', 'Electrical Steel Processing Line', 'CAL/CGL-Si',
|
||
'无取向与取向硅钢（CGO/HiB）连续处理，为电机、变压器提供核心原料。',
|
||
'Non-oriented and grain-oriented (CGO/HiB) silicon steel processing for motors and transformers.',
|
||
NULL, NULL,
|
||
'无取向近20条、取向5条', 23),
|
||
(31, '碳钢酸洗机组', 'Carbon Steel Pickling Line', NULL,
|
||
'推拉式与连续式；浅槽紊流酸洗、五级逆流漂洗。',
|
||
'Push-pull and continuous types; shallow turbulent pickling, five-stage countercurrent rinsing.',
|
||
'配置800吨平整机、双头回转塔式圆盘剪等。',
|
||
'Including 800 t skin pass mill, dual-head rotary disc shear, etc.',
|
||
NULL, 31),
|
||
(32, '不锈钢连续退火酸洗机组', 'Stainless Annealing & Pickling Line', NULL,
|
||
'热轧、冷轧、光亮退火等类型。',
|
||
'Hot rolled, cold rolled, bright annealing configurations.',
|
||
NULL, NULL,
|
||
'国内外10条以上', 32),
|
||
(41, '拉矫/脱脂/重卷线', 'TL, Degreasing, Re-coiling Lines', NULL,
|
||
'张力矫直、脱脂清洗、重卷分卷等后处理及辅机。',
|
||
'Tension leveling, degreasing, recoiling and slitting auxiliaries.',
|
||
NULL, NULL,
|
||
NULL, 41)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), short_name = VALUES(short_name),
|
||
description_zh = VALUES(description_zh), description_en = VALUES(description_en),
|
||
specifications_zh = VALUES(specifications_zh), specifications_en = VALUES(specifications_en),
|
||
achievements = VALUES(achievements), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 单体设备
|
||
-- ================================================================
|
||
INSERT INTO f_single_equipment (category_id, name_zh, name_en, technical_highlights_zh, technical_highlights_en, sort_order, is_published) VALUES
|
||
(5, '感应加热系统', 'Induction Heating System', '焊缝退火、硅钢轧前加热、涂层干燥', 'Weld annealing, Si-steel preheat, coating drying', 10, 1),
|
||
(5, '镀后冷却系统', 'Post-plating Cooling System', '喷气冷却、气雾冷却（BLADE喷嘴）', 'Jet and air-mist cooling (BLADE nozzles)', 20, 1),
|
||
(5, '电磁驱渣器', 'Electromagnetic Slag Drive', '替代人工除渣，自动化锌锅', 'Automated zinc pot skimming', 30, 1),
|
||
(5, '红外辐射炉', 'Infrared Radiation Furnace', '涂层干燥，非接触加热', 'Non-contact coating drying', 40, 1),
|
||
(5, '氢气回收装置', 'Hydrogen Recovery Unit', '回收率>75%，2-3年回本', 'Recovery rate >75%, typical payback 2–3 years', 50, 1),
|
||
(5, '合金化炉', 'Alloy Coating Furnace', '直接火焰加热（FLOX/MILD），NOx降50-70%', 'FLOX/MILD firing, NOx reduction 50-70%', 60, 1),
|
||
(5, '燃烧系统改造', 'Combustion System Revamp', '双燃料切换（LPG/NG/COG）', 'Dual-fuel switching (LPG/NG/COG)', 70, 1),
|
||
(200, '开收卷机（机型一）', 'Payoff / Tension Reel (Type A)', '板材开卷、张力卷取与收卷', 'Strip payoff, tension reel and recoiling', 200, 1),
|
||
(200, '开收卷机（机型二）', 'Payoff / Tension Reel (Type B)', '重载卷取与张力控制', 'Heavy-duty recoiling with tension control', 210, 1),
|
||
(201, '立式炉', 'Vertical Furnace', '立式布置热处理炉', 'Vertically arranged heat-treatment furnace', 220, 1),
|
||
(201, '卧式炉', 'Horizontal Furnace', '卧式连续热处理炉', 'Horizontal continuous heat-treatment furnace', 230, 1),
|
||
(202, '焊机', 'Welder', '带钢闪光焊、搭接焊等', 'Flash welding, lap welding for strip joining', 240, 1),
|
||
(202, '立式涂机', 'Vertical Coating Machine', '立式辊涂、涂层施加', 'Vertical roll coater / film application', 250, 1),
|
||
(202, '卧式涂机', 'Horizontal Coating Machine', '水平涂覆与烘干前道工序', 'Horizontal coating application', 260, 1),
|
||
(203, '破鳞机（机型一）', 'Scale Breaker (Type I)', '热轧氧化铁皮破碎与疏松', 'Breaking and loosening hot-rolled scale', 270, 1),
|
||
(203, '破鳞机（机型二）', 'Scale Breaker (Type II)', '另一型式破鳞与延伸', 'Alternative scale breaking configuration', 280, 1),
|
||
(204, '拉矫机', 'Tension Leveler', '带钢拉伸弯曲矫直', 'Tension leveling / stretch leveling', 290, 1),
|
||
(204, '两弯两矫拉弯矫直机', 'Two-bend Two-straight Stretch-bend Leveler', '多辊拉弯矫直改善板形', 'Multi-roll stretch-bend leveling for strip shape', 300, 1),
|
||
(205, '圆盘剪', 'Side Trimmer', '两侧碎边裁剪宽度', 'Side trimming for strip width', 310, 1),
|
||
(205, '碎边剪', 'Edge Chop Shear', '碎边切断与收集', 'Chopping and handling of edge trim', 320, 1),
|
||
(205, '圆盘剪（双刀头）', 'Side Trimmer (Twin Knife Head)', '双刀头提高修边效率', 'Twin knife heads for trimming efficiency', 330, 1),
|
||
(205, '双刀头碎边圆盘剪', 'Twin-head Edge-chop Disc Shear', '碎边与圆盘剪组合结构', 'Combined edge chop and disc shear', 340, 1)
|
||
ON DUPLICATE KEY UPDATE
|
||
name_zh = VALUES(name_zh), name_en = VALUES(name_en), technical_highlights_zh = VALUES(technical_highlights_zh),
|
||
technical_highlights_en = VALUES(technical_highlights_en), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 备品备件（产品目录单品，与官网图册一致；封面请在后台上传 cover_image）
|
||
-- ================================================================
|
||
INSERT INTO f_spare_part (category_id, name_zh, name_en, description_zh, description_en, sort_order, is_published) VALUES
|
||
(6, '翅片管换热器', 'Finned Tube Heat Exchanger', '备品备件', 'Spare parts', 10, 1),
|
||
(6, 'RJC 换热器', 'RJC Heat exchanger', '备品备件', 'Spare parts', 20, 1),
|
||
(6, 'W 型辐射管', 'W-radiant tube', '备品备件', 'Spare parts', 30, 1),
|
||
(6, 'I 型辐射管', 'I-type Radiant Tube', '备品备件', 'Spare parts', 40, 1),
|
||
(6, 'U 型辐射管', 'U-Radiant Tube', '备品备件', 'Spare parts', 50, 1),
|
||
(6, '滑块', 'Slide Block', '备品备件', 'Spare parts', 60, 1),
|
||
(6, '轴套衬套', 'Bush and Sleeve', '备品备件', 'Spare parts', 70, 1),
|
||
(6, '支臂', 'Support Arm', '备品备件', 'Spare parts', 80, 1),
|
||
(6, '炉辊', 'Hearth Roll', '备品备件', 'Spare parts', 90, 1),
|
||
(6, '大炉辊', 'Big Hearth Roll', '备品备件', 'Spare parts', 100, 1),
|
||
(6, '镀铬辊', 'Chromed Roll', '备品备件', 'Spare parts', 110, 1),
|
||
(6, '氯丁胶转向辊', 'Rubber Turning Roll', '备品备件', 'Spare parts', 120, 1),
|
||
(6, '聚氨酯辊', 'PU Roll', '备品备件', 'Spare parts', 130, 1),
|
||
(6, '汲料辊', 'Pick Up Roll', '备品备件', 'Spare parts', 140, 1),
|
||
(6, '托辊', 'Support Roll', '备品备件', 'Spare parts', 150, 1),
|
||
(6, '水淬辊', 'Water Quenching Roll', '备品备件', 'Spare parts', 160, 1),
|
||
(6, '张力辊', 'Bridle Roll', '备品备件', 'Spare parts', 170, 1);
|
||
|
||
-- ================================================================
|
||
-- 成功案例
|
||
-- ================================================================
|
||
INSERT INTO f_case_study (category_id, client_name_zh, client_name_en, location, is_overseas, sort_order) VALUES
|
||
(1, '河北兆建', 'Hebaizhao Steel', '中国', 0, 10),
|
||
(1, '印尼钢铁', 'Indonesia Steel', '印度尼西亚', 1, 20),
|
||
(3, '大力神', 'Dalishi', '中国', 0, 30),
|
||
(6, '中国宝武', 'China Baowu', '中国', 0, 40),
|
||
(7, '宝钢硅钢', 'Baosteel Silicon', '中国', 0, 50),
|
||
(8, '首钢京唐', 'Shougang Jingtang', '中国', 0, 60)
|
||
ON DUPLICATE KEY UPDATE
|
||
client_name_zh = VALUES(client_name_zh), client_name_en = VALUES(client_name_en),
|
||
location = VALUES(location), is_overseas = VALUES(is_overseas), sort_order = VALUES(sort_order);
|
||
|
||
-- ================================================================
|
||
-- 自增ID对齐
|
||
-- ================================================================
|
||
ALTER TABLE f_company_info AUTO_INCREMENT = 2;
|
||
ALTER TABLE f_case_category AUTO_INCREMENT = 9;
|
||
ALTER TABLE f_news_category AUTO_INCREMENT = 4;
|
||
ALTER TABLE f_media_library AUTO_INCREMENT = 500;
|
||
SET FOREIGN_KEY_CHECKS = 1;
|