-- ======================================================================
-- Wuhan Saga - Full init (schema + data merged from database/sql exports)
-- Generated: scripts/merge-sql-exports-to-init.ps1
-- Usage on EMPTY server: mysql -u root -p < database/wuhan_saga_init_from_exports.sql
-- Or: drop database wuhan_saga; then run this file.
-- ======================================================================

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;

-- ---------- Schema (Spring resources/schema.sql) ----------

-- ================================================================
-- 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;
-- ---------- Data (exports under database/sql/) ----------
-- ---- Data from export: sys_user.sql ----
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `nickname`, `avatar`, `email`, `phone`, `status`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 'admin', '$2a$10$mKCJqgXbF53ZMUSykD.dSOaBQ30I5IVZk8x4PmpETgXkCD8403GVa', '管理员', NULL, NULL, NULL, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_company_info.sql ----
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`, `phone`, `email`, `address_zh`, `address_en`, `website`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '武汉萨格工程技术有限公司', 'Wuhan Saga Engineering Technology Co., Ltd.', 2020, '武汉萨格工程技术有限公司，是一家集板带后处理为主营业务的金属深加工技术和装备供应商。自2020年成立至今，一直致力于金属板带生产的技术研发、技术服务和装备供应。\nSAGA公司通过不懈的努力，已在带钢酸洗机组、带钢连续热镀（铝）锌机组、带钢连续退火机组、硅钢（电工钢）全工序处理机组等领域取得优异成绩，我们已向国内外客户提供了20套连续板带处理生产线，。参与制定了相关行业产品国家标准。\n我们的主要技术力量均来自于原冶金部部属设计研究院及国内其他钢铁企业设计院的专业人才，并组合了有国外知名公司工作经历和留学归国人员为首组成的配套机械设备及电气控制的专业技术团队。主要成员全部是长期主持或参加过国家大型钢铁企业工程的设计、制造、施工安装、生产调试工作的冶炼、冶金热工、各类带钢连续线及其相关专业技术专家或骨干，具有扎实的理论基础和丰富的实际工程操作经验。并聘用了多名国内同行业知名专家。形成了我公司特有的技术优势，为公司提供了强有力的技术支持。\n我们致力于节能环保技术的研发和推广应用，使我们的产线在满足客户较低投入、较高产出和优性价比的同时，对环境的改善也做出我们应有的努力。我们以冷轧处理技术为核心、向国内外用户提供先进完善的冷轧系统解决方案，以先进的技术和优质的服务，努力打造中国钢铁业高端技术和装备品牌，为社会创造更多价值。\n', 'Wuhan saga Engineering Technology Co., Ltd. is a supplier of metal deep processing technology and equipment focusing on plate and strip post-processing. Since its establishment in 2020, it has been committed to the technical research and development, technical services and equipment supply of metal plate and strip production.\nThrough unremitting efforts, saga has made outstanding achievements in the fields of strip steel pickling unit, strip steel continuous hot plating (aluminum) zinc unit, strip steel continuous annealing unit, silicon steel (electrical steel) whole process treatment unit and so on. We have provided 20 sets of continuous strip processing production lines to customers at home and abroad. \nOur main technical force comes from the professionals of the design and Research Institute under the former Ministry of metallurgy and the design institutes of other domestic iron and steel enterprises, and a professional technical team of supporting mechanical equipment and electrical control led by the working experience of well-known foreign companies and the returned personnel studying abroad. The main members are all smelting, metallurgical and thermal engineering, various strip steel continuous lines and related professional and technical experts or backbones who have long presided over or participated in the design, manufacturing, construction and installation, production and commissioning of national large iron and steel enterprises, with solid theoretical foundation and rich practical engineering operation experience. And hired a number of domestic well-known experts in the same industry. It has formed the unique technical advantages of our company and provided strong technical support for the company.\nWe are committed to the R & D, promotion and application of energy-saving and environmental protection technologies, so that our production line can not only meet customers\' low input, high output and high cost performance, but also make due efforts to improve the environment. With cold rolling treatment technology as the core, we provide advanced and perfect cold rolling system solutions to users at home and abroad. With advanced technology and high-quality services, we strive to build a high-end technology and equipment brand in China\'s iron and steel industry and create more value for the society.\n', '已向国内外客户提供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', NULL, NULL, NULL, NULL, 'https://www.wuhansaga.com/', NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 13:11:51', NULL, 0);

-- ---- Data from export: f_contact.sql ----
INSERT INTO `f_contact` (`contact_id`, `company_info_id`, `phone`, `fax`, `email`, `address_zh`, `address_en`, `zip_code`, `map_coordinates`, `business_hours_zh`, `business_hours_en`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 1, NULL, NULL, 'info@wuhansaga.com', '（请填写实际办公地址）', '(Please fill in office address)', NULL, NULL, '工作日 9:00-17:00', 'Weekdays 9:00-17:00', NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 13:11:52', NULL, 0);

-- ---- Data from export: f_about.sql ----
INSERT INTO `f_about` (`about_id`, `company_info_id`, `section_type`, `title_zh`, `title_en`, `content_zh`, `content_en`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 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.', NULL, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_about` (`about_id`, `company_info_id`, `section_type`, `title_zh`, `title_en`, `content_zh`, `content_en`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 1, 'vision', '企业愿景', 'Vision', '以先进的板材处理技术和优质的服务，做全球知名的装备供应商。', 'To be a worldwide known equipment supplier by advanced strip processing technology and superior services.', NULL, 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_about` (`about_id`, `company_info_id`, `section_type`, `title_zh`, `title_en`, `content_zh`, `content_en`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 1, 'mission', '企业使命', 'Mission', '以板材处理技术为核心，向国内外用户提供先进完善的板材系统解决方案。', 'Based on strip processing technology, provide advanced strip solutions for customers at home and abroad.', NULL, 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_about` (`about_id`, `company_info_id`, `section_type`, `title_zh`, `title_en`, `content_zh`, `content_en`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, 1, 'values', '核心价值观', 'Core Values', '诚信、尊重、公平、多元', 'Integrity, respect, fairness, diversity', NULL, 1, 40, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_about` (`about_id`, `company_info_id`, `section_type`, `title_zh`, `title_en`, `content_zh`, `content_en`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, 1, 'spirit', '企业精神', 'Spirit', '创新、团结、高效', 'Innovation, unity, and efficiency', NULL, 1, 50, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_workshop.sql ----
INSERT INTO `f_workshop` (`workshop_id`, `company_info_id`, `workshop_type`, `name_zh`, `name_en`, `description_zh`, `description_en`, `equipment_list_zh`, `equipment_list_en`, `area_size`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 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㎡', '/uploads/workshop/b951f2f518d345bfa2274c7cb379e0ab.jpeg', 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:45:12', NULL, 0);
INSERT INTO `f_workshop` (`workshop_id`, `company_info_id`, `workshop_type`, `name_zh`, `name_en`, `description_zh`, `description_en`, `equipment_list_zh`, `equipment_list_en`, `area_size`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 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, '/uploads/workshop/8630e86cc57c4029853acd4f0a917bd4.jpeg', 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:45:45', NULL, 0);
INSERT INTO `f_workshop` (`workshop_id`, `company_info_id`, `workshop_type`, `name_zh`, `name_en`, `description_zh`, `description_en`, `equipment_list_zh`, `equipment_list_en`, `area_size`, `image_path`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 1, 'assembly', '装配车间', 'Assembly Shop', '负责设备组件质量检验、装配、预装、调试，是生产流程关键环节。', 'Quality inspection, assembly, pre-assembly and commissioning of equipment components — a key step in the production process.', NULL, NULL, NULL, '/uploads/workshop/19149361136442d2966d1a8d23cbc42d.jpeg', 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:48:02', NULL, 0);

-- ---- Data from export: f_news_category.sql ----
INSERT INTO `f_news_category` (`category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '公司新闻', 'Company News', 10, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_news_category` (`category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, '行业动态', 'Industry News', 20, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_news_category` (`category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, '技术文章', 'Technical Articles', 30, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_case_category.sql ----
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '热镀锌/铝锌产线', 'Hot Dip Galvanizing / Galvalume', 10, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, '锌铝镁产线改造', 'ZAM Line Revamp', 20, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, '硅钢处理', 'Silicon Steel Processing', 30, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, '不锈钢处理', 'Stainless Steel Processing', 40, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, '酸洗线', 'Pickling Lines', 50, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (6, '感应加热', 'Induction Heating', 60, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (7, '氢气回收', 'Hydrogen Recovery', 70, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_category` (`case_category_id`, `name_zh`, `name_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (8, '镀后冷却', 'Post-plating Cooling', 80, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_core_technology.sql ----
INSERT INTO `f_core_technology` (`core_technology_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `advantages_zh`, `advantages_en`, `icon_class`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '节能环保技术', 'Energy Saving & Environmental Technology', '高效节能辐射管换热系统、热保护气体循环预热、无氧化加热、氢气回收等。', 'High-efficiency radiant tube heat recovery, protective atmosphere preheat, non-oxidizing heating, hydrogen recovery, etc.', NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_core_technology` (`core_technology_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `advantages_zh`, `advantages_en`, `icon_class`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, '感应加热技术', 'Induction Heating Technology', '感应加热、闭环温控；应用于焊缝退火、硅钢轧前加热、涂层干燥等。', 'Induction heating with closed-loop temperature control for weld annealing, electrical steel preheat, coating drying, etc.', NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_core_technology` (`core_technology_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `advantages_zh`, `advantages_en`, `icon_class`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, '气雾冷却技术', 'Air-Mist Cooling Technology', '高氢高速喷气冷却、气雾冷却、喷气冷却（BLADE喷嘴等）。', 'High-hydrogen jet cooling, air-mist and jet cooling (e.g. BLADE nozzles).', NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_core_technology` (`core_technology_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `advantages_zh`, `advantages_en`, `icon_class`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, '智能控制技术', 'Intelligent Control Technology', '智能PLC控制系统，保障机组稳定运行与工艺优化。', 'Intelligent PLC-based control for stable operation and process optimization.', NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_product_category.sql ----
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '整线机组', 'Complete Production Line', 'product_line', NULL, NULL, 10, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, '核心单体设备', 'Core Single Equipment', 'equipment', NULL, NULL, 20, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, '备品备件', 'Spare Parts', 'spare_part', NULL, NULL, 30, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (11, '热镀锌/镀铝锌机组', 'Hot-dip Galvanizing/Aluminum-zinc Coating Line', 'product_line', 1, NULL, 11, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (12, '锌铝镁机组', 'Zinc-aluminum-magnesium Coating Line', 'product_line', 1, NULL, 12, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (13, '普碳钢连续退火线', 'Carbon Steel Continuous Annealing Line', 'product_line', 1, NULL, 13, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (14, '冷轧板退火镀锌两用机组', 'Cold-rolled Sheet Annealing and Galvanizing Dual-purpose Line', 'product_line', 1, NULL, 14, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (15, '彩涂机组', 'Color Coating Line', 'product_line', 1, NULL, 15, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (16, '高效电工钢（硅钢）连续处理机组', 'High-efficiency Electrical Steel (Silicon Steel) Continuous Processing Line', 'product_line', 1, NULL, 16, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (17, '碳钢酸洗机组', 'Carbon Steel Pickling Line', 'product_line', 1, NULL, 17, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (18, '不锈钢连续退火酸洗机组', 'Stainless Steel Continuous Annealing and Pickling Line', 'product_line', 1, NULL, 18, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (19, '拉矫线、脱脂线、重卷线', 'Tension Leveling Line, Degreasing Line, Recoiling Line', 'product_line', 1, NULL, 19, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (51, '红外辐射炉', 'Infrared Radiation Furnace', 'equipment', 2, NULL, 51, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (52, '硅钢轧前感应加热', 'Induction Heating for Silicon Steel Before Rolling', 'equipment', 2, NULL, 52, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (53, '气雾冷却', 'Aerosol Cooling', 'equipment', 2, NULL, 53, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (54, '焊缝退火感应加热', 'Induction Heating for Weld Seam Annealing', 'equipment', 2, NULL, 54, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (55, '氢气回收装置', 'Hydrogen Recovery Device', 'equipment', 2, NULL, 55, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (56, '镀后冷却', 'Post-coating Cooling', 'equipment', 2, NULL, 56, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (57, '涂层干燥感应加热', 'Induction Heating for Coating Drying', 'equipment', 2, NULL, 57, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (58, '合金化炉', 'Alloying Furnace', 'equipment', 2, NULL, 58, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (59, '镀锡软熔感应加热', 'Induction Heating for Tin Plating Reflow', 'equipment', 2, NULL, 59, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (60, '电磁驱渣器', 'Electromagnetic Dross Remover', 'equipment', 2, NULL, 60, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (61, '直燃无焰加热', 'Direct-fired Flameless Heating', 'equipment', 2, NULL, 61, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (62, '圆盘剪、拉弯矫直、涂机、开收卷机', 'Circular Shear, Stretch-bend Straightener, Coater, Uncoiler/Coiler', 'equipment', 2, NULL, 62, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (71, 'W型/I型/U型辐射管', 'W-type/I-type/U-type Radiant Tubes', 'spare_part', 3, NULL, 71, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (72, '翅片管换热器', 'Finned Tube Heat Exchanger', 'spare_part', 3, NULL, 72, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (73, '炉辊、张力辊、镀铬辊、PU辊', 'Furnace Rolls, Tension Rolls, Chrome-plated Rolls, PU Rolls', 'spare_part', 3, NULL, 73, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (74, '水淬辊、汲料辊、托辊', 'Water Quenching Rolls, Dross Skimming Rolls, Support Rolls', 'spare_part', 3, NULL, 74, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (75, '轴套、衬套、滑块、支臂', 'Sleeves, Bushings, Sliders, Support Arms', 'spare_part', 3, NULL, 75, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (100, '翅片管换热器', 'Finned Tube Heat Exchanger', 'spare_part', 3, NULL, 10, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:51:03', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (101, 'RJC 换热器', 'RJC Heat exchanger', 'spare_part', 3, NULL, 20, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (102, 'W 型辐射管', 'W-radiant tube', 'spare_part', 3, NULL, 30, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (103, 'I 型辐射管', 'I-type Radiant Tube', 'spare_part', 3, NULL, 40, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (104, 'U 型辐射管', 'U-Radiant Tube', 'spare_part', 3, NULL, 50, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (105, '滑块', 'Slide Block', 'spare_part', 3, NULL, 60, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (106, '轴套衬套', 'Bush and Sleeve', 'spare_part', 3, NULL, 70, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (107, '支臂', 'Support Arm', 'spare_part', 3, NULL, 80, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (108, '炉辊', 'Hearth Roll', 'spare_part', 3, NULL, 90, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (109, '大炉辊', 'Big Hearth Roll', 'spare_part', 3, NULL, 100, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (110, '镀铬辊', 'Chromed Roll', 'spare_part', 3, NULL, 110, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (111, '氯丁胶转向辊', 'Rubber Turning Roll', 'spare_part', 3, NULL, 120, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (112, '聚氨酯辊', 'PU Roll', 'spare_part', 3, NULL, 130, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (113, '汲料辊', 'Pick Up Roll', 'spare_part', 3, NULL, 140, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (114, '托辊', 'Support Roll', 'spare_part', 3, NULL, 150, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (115, '水淬辊', 'Water Quenching Roll', 'spare_part', 3, NULL, 160, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (116, '张力辊', 'Bridle Roll', 'spare_part', 3, NULL, 170, 1, NULL, NULL, '2026-05-04 17:40:28', '2026-05-04 17:50:14', NULL, 1);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (200, '卷取设备', 'Reeling & Coiling Equipment', 'equipment', 2, NULL, 200, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (201, '炉类设备', 'Furnace Equipment', 'equipment', 2, NULL, 201, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (202, '涂布与焊接设备', 'Coating & Welding Equipment', 'equipment', 2, NULL, 202, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (203, '破鳞设备', 'Scale Breaking Equipment', 'equipment', 2, NULL, 203, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (204, '拉矫矫直设备', 'Leveling & Straightening Equipment', 'equipment', 2, NULL, 204, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_product_category` (`product_category_id`, `name_zh`, `name_en`, `module_type`, `parent_id`, `icon_class`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (205, '剪切修边设备', 'Shearing & Trimming Equipment', 'equipment', 2, NULL, 205, 1, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);

-- ---- Data from export: f_product_line.sql ----
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 11, '热镀锌/镀铝锌机组', 'Hot-dip Galvanizing/Aluminum-zinc Coating 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.', NULL, NULL, NULL, '国内外已建成200+条生产线', '/uploads/other/bc56902299aa475b928eefca392c1a9e.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 11, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:02:08', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 12, '锌铝镁机组', 'Zinc-aluminum-magnesium Coating Line', 'ZAM', '连续热镀生产，耐腐蚀性为传统纯锌涂层10–20倍。', 'Continuous hot-dip coating; corrosion resistance 10–20× conventional zinc.', NULL, NULL, NULL, NULL, NULL, '多条产线应用与改造经验', '/uploads/product/9d84c8c939e8488780f11e97e5420a4c.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 12, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:03:03', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 13, '普碳钢连续退火线', '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.', NULL, NULL, NULL, '国内外近10条', '/uploads/product/c10aa9941c9247bdbdb9cf0a919b5658.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 13, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:03:51', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, 14, '冷轧板退火镀锌两用机组', 'Cold-rolled Sheet Annealing and Galvanizing Dual-purpose 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, NULL, NULL, NULL, '/uploads/product/0c19509ba68849a181f2a87fe3712627.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 14, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:04:42', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, 15, '彩涂机组', '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.', NULL, NULL, NULL, '近20条国内外', '/uploads/product/4506ef5a13c2496b836ee5eb60ee70b3.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 15, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:06:09', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (6, 16, '高效电工钢（硅钢）连续处理机组', 'High-efficiency Electrical Steel (Silicon Steel) Continuous Processing Line', 'CAL/CGL-Si', '无取向与取向硅钢（CGO/HiB）连续处理，为电机、变压器提供核心原料。', 'Non-oriented and grain-oriented (CGO/HiB) silicon steel processing for motors and transformers.', NULL, NULL, NULL, NULL, NULL, '无取向近20条、取向5条', '/uploads/product/9df433e224734fcba1ef2e5317a2f8cf.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 16, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:06:45', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (7, 17, '碳钢酸洗机组', '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, NULL, NULL, NULL, '/uploads/product/2f230804574c4cbe8545c3db20c0dd17.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 17, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:10:21', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (8, 18, '不锈钢连续退火酸洗机组', 'Stainless Steel Continuous Annealing and Pickling Line', NULL, '热轧、冷轧、光亮退火等类型。', 'Hot rolled, cold rolled, bright annealing configurations.', NULL, NULL, NULL, NULL, NULL, '国内外10条以上', '/uploads/product/3db457c2a5b4450399a8554fc3fe0868.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 18, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 12:11:09', NULL, 0);
INSERT INTO `f_product_line` (`product_line_id`, `category_id`, `name_zh`, `name_en`, `short_name`, `description_zh`, `description_en`, `specifications_zh`, `specifications_en`, `capacity`, `applications_zh`, `applications_en`, `achievements`, `cover_image`, `applicable_materials_zh`, `applicable_materials_en`, `thickness_range`, `width_range`, `running_speed`, `equipment_composition_zh`, `equipment_composition_en`, `technical_highlights_zh`, `technical_highlights_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `meta_title_zh`, `meta_title_en`, `meta_description_zh`, `meta_description_en`, `meta_keywords`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (9, 19, '拉矫线、脱脂线、重卷线', 'Tension Leveling Line, Degreasing Line, Recoiling Line', NULL, '张力矫直、脱脂清洗、重卷分卷等后处理及辅机。', 'Tension leveling, degreasing, recoiling and slitting auxiliaries.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 19, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_single_equipment.sql ----
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 51, '红外辐射炉', 'Infrared Radiation Furnace', NULL, NULL, '涂层干燥，非接触加热', 'Non-contact coating drying', '/uploads/product/14c45beb89954cb3b5cd60a658ea87e5.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 52, '硅钢轧前感应加热', 'Induction Heating for Silicon Steel Before Rolling', NULL, NULL, '感应加热、闭环温控', 'Induction heating with closed-loop temperature control', '/uploads/product/b22309676e6f4eb289385a02f9f2bc78.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 53, '气雾冷却', 'Aerosol Cooling', NULL, NULL, '高氢高速喷气冷却、气雾冷却（BLADE喷嘴）', 'High-hydrogen jet cooling, air-mist cooling (BLADE nozzles)', '/uploads/product/bad17b7509d5437d9596d3901442425e.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, 54, '焊缝退火感应加热', 'Induction Heating for Weld Seam Annealing', NULL, NULL, '焊缝退火、消除应力', 'Weld annealing, stress relief', '/uploads/product/d96fbb8a1fef48409c06974c7182d624.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, 55, '氢气回收装置', 'Hydrogen Recovery Device', NULL, NULL, '回收率>75%，2-3年回本', 'Recovery rate >75%, typical payback 2–3 years', '/uploads/product/e29a85b804b24e7e945899de26073754.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 50, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (6, 56, '镀后冷却', 'Post-coating Cooling', NULL, NULL, '喷气冷却、气雾冷却', 'Jet and air-mist cooling', '/uploads/product/fa5f85b49b804fe1a4babced896848b8.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 60, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (7, 57, '涂层干燥感应加热', 'Induction Heating for Coating Drying', NULL, NULL, '感应加热涂层干燥', 'Induction heating for coating drying', '/uploads/product/b092d8c6cc4f45409e9c331df5782c05.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 70, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (8, 58, '合金化炉', 'Alloying Furnace', NULL, NULL, '直接火焰加热（FLOX/MILD），NOx降50-70%', 'FLOX/MILD firing, NOx reduction 50-70%', '/uploads/product/ca2ab4ba45714592b5de832e23b0ef94.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 80, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (9, 59, '镀锡软熔感应加热', 'Induction Heating for Tin Plating Reflow', NULL, NULL, '镀锡板软熔处理', 'Tin plate reflow treatment', '/uploads/product/6d8a2960c3de4fa3a495faabee82bea0.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 90, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (10, 60, '电磁驱渣器', 'Electromagnetic Dross Remover', NULL, NULL, '替代人工除渣，自动化锌锅', 'Automated zinc pot skimming', '/uploads/product/7ac4ae777be84f65b4d9e9e79bc39a90.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 100, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (11, 61, '直燃无焰加热', 'Direct-fired Flameless Heating', NULL, NULL, '无焰燃烧，低NOx排放', 'Flameless combustion, low NOx emission', '/uploads/product/286aa5f9c48a4c94a99eaf940eba3bba.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 110, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (12, 62, '圆盘剪、拉弯矫直、涂机、开收卷机', 'Circular Shear, Stretch-bend Straightener, Coater, Uncoiler/Coiler', NULL, NULL, '精整设备', 'Finishing equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 120, NULL, NULL, '2026-05-02 03:33:24', '2026-05-05 01:39:20', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (43, 200, '开收卷机（机型一）', 'Payoff / Tension Reel (Type A)', NULL, NULL, '板材开卷、张力卷取与收卷', 'Strip payoff, tension reel and recoiling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (44, 200, '开收卷机（机型二）', 'Payoff / Tension Reel (Type B)', NULL, NULL, '重载卷取与张力控制', 'Heavy-duty recoiling with tension control', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (45, 201, '立式炉', 'Vertical Furnace', NULL, NULL, '立式布置热处理炉', 'Vertically arranged heat-treatment furnace', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (46, 201, '卧式炉', 'Horizontal Furnace', NULL, NULL, '卧式连续热处理炉', 'Horizontal continuous heat-treatment furnace', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (47, 202, '焊机', 'Welder', NULL, NULL, '带钢闪光焊、搭接焊等', 'Flash welding, lap welding for strip joining', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (48, 202, '立式涂机', 'Vertical Coating Machine', NULL, NULL, '立式辊涂、涂层施加', 'Vertical roll coater / film application', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (49, 202, '卧式涂机', 'Horizontal Coating Machine', NULL, NULL, '水平涂覆与烘干前道工序', 'Horizontal coating application', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (50, 203, '破鳞机（机型一）', 'Scale Breaker (Type I)', NULL, NULL, '热轧氧化铁皮破碎与疏松', 'Breaking and loosening hot-rolled scale', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (51, 203, '破鳞机（机型二）', 'Scale Breaker (Type II)', NULL, NULL, '另一型式破鳞与延伸', 'Alternative scale breaking configuration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (52, 204, '拉矫机', 'Tension Leveler', NULL, NULL, '带钢拉伸弯曲矫直', 'Tension leveling / stretch leveling', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (53, 204, '两弯两矫拉弯矫直机', 'Two-bend Two-straight Stretch-bend Leveler', NULL, NULL, '多辊拉弯矫直改善板形', 'Multi-roll stretch-bend leveling for strip shape', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (54, 205, '圆盘剪', 'Side Trimmer', NULL, NULL, '两侧碎边裁剪宽度', 'Side trimming for strip width', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (55, 205, '碎边剪', 'Edge Chop Shear', NULL, NULL, '碎边切断与收集', 'Chopping and handling of edge trim', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (56, 205, '圆盘剪（双刀头）', 'Side Trimmer (Twin Knife Head)', NULL, NULL, '双刀头提高修边效率', 'Twin knife heads for trimming efficiency', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);
INSERT INTO `f_single_equipment` (`single_equipment_id`, `category_id`, `name_zh`, `name_en`, `description_zh`, `description_en`, `technical_highlights_zh`, `technical_highlights_en`, `cover_image`, `function_description_zh`, `function_description_en`, `specifications_zh`, `specifications_en`, `product_advantages_zh`, `product_advantages_en`, `applicable_lines_zh`, `applicable_lines_en`, `application_cases_zh`, `application_cases_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (57, 205, '双刀头碎边圆盘剪', 'Twin-head Edge-chop Disc Shear', NULL, NULL, '碎边与圆盘剪组合结构', 'Combined edge chop and disc shear', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-04 20:15:29', '2026-05-04 20:15:29', NULL, 0);

-- ---- Data from export: f_spare_part.sql ----
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 71, 'W型/I型/U型辐射管', 'W-type/I-type/U-type Radiant Tubes', NULL, '工业炉用辐射管', 'Radiant tubes for industrial furnaces', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:51:40', NULL, 1);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 100, '翅片管换热器', 'Finned Tube Heat Exchanger', NULL, '翅片管换热器、RJC换热器等', 'Finned tube and RJC-type exchangers', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:43:29', NULL, 1);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 73, '炉辊、张力辊、镀铬辊、PU辊', 'Furnace Rolls, Tension Rolls, Chrome-plated Rolls, PU Rolls', NULL, '炉辊、大炉辊、张力辊、转向辊等', 'Hearth rolls, tension rolls, deflector rolls', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:51:36', NULL, 1);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, 74, '水淬辊、汲料辊、托辊', 'Water Quenching Rolls, Dross Skimming Rolls, Support Rolls', NULL, '水淬辊、汲料辊、托辊', 'Water quenching rolls, dross skimming rolls, support rolls', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:51:33', NULL, 1);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, 75, '轴套、衬套、滑块、支臂', 'Sleeves, Bushings, Sliders, Support Arms', NULL, '轴套、衬套、滑块、支臂', 'Sleeves, bushings, sliders, support arms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 50, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 17:51:30', NULL, 1);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (6, 72, '翅片管换热器', 'Finned Tube Heat Exchanger', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (7, 72, 'RJC 换热器', 'RJC Heat exchanger', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (8, 71, 'W 型辐射管', 'W-radiant tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (9, 71, 'I 型辐射管', 'I-type Radiant Tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (10, 71, 'U 型辐射管', 'U-Radiant Tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 50, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (11, 75, '滑块', 'Slide Block', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 60, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (12, 75, '轴套衬套', 'Bush and Sleeve', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 70, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (13, 75, '支臂', 'Support Arm', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 80, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (14, 73, '炉辊', 'Hearth Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 90, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (15, 73, '大炉辊', 'Big Hearth Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 100, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (16, 73, '镀铬辊', 'Chromed Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 110, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (17, 73, '氯丁胶转向辊', 'Rubber Turning Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 120, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (18, 73, '聚氨酯辊', 'PU Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 130, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (19, 74, '汲料辊', 'Pick Up Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 140, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (20, 74, '托辊', 'Support Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 150, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (21, 74, '水淬辊', 'Water Quenching Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 160, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (22, 73, '张力辊', 'Bridle Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 170, NULL, NULL, '2026-05-04 17:05:36', '2026-05-04 17:50:14', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (23, 3, '翅片管换热器', 'Finned Tube Heat Exchanger', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 10, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (24, 3, 'RJC 换热器', 'RJC Heat exchanger', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 20, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (25, 3, 'W 型辐射管', 'W-radiant tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 30, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (26, 3, 'I 型辐射管', 'I-type Radiant Tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 40, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (27, 3, 'U 型辐射管', 'U-Radiant Tube', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 50, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (28, 3, '滑块', 'Slide Block', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 60, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (29, 3, '轴套衬套', 'Bush and Sleeve', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 70, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (30, 3, '支臂', 'Support Arm', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 80, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (31, 3, '炉辊', 'Hearth Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 90, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (32, 3, '大炉辊', 'Big Hearth Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 100, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (33, 3, '镀铬辊', 'Chromed Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 110, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (34, 3, '氯丁胶转向辊', 'Rubber Turning Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 120, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (35, 3, '聚氨酯辊', 'PU Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 130, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (36, 3, '汲料辊', 'Pick Up Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 140, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (37, 3, '托辊', 'Support Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 150, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (38, 3, '水淬辊', 'Water Quenching Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 160, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);
INSERT INTO `f_spare_part` (`spare_part_id`, `category_id`, `name_zh`, `name_en`, `model`, `description_zh`, `description_en`, `material`, `applications`, `cover_image`, `model_spec`, `applicable_line_model`, `material_zh`, `material_en`, `lifespan`, `product_advantages_zh`, `product_advantages_en`, `excerpt_zh`, `excerpt_en`, `content_zh`, `content_en`, `specifications_zh`, `specifications_en`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (39, 3, '张力辊', 'Bridle Roll', NULL, '备品备件', 'Spare parts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 170, NULL, NULL, '2026-05-04 20:07:02', '2026-05-04 20:07:02', NULL, 0);

-- ---- Data from export: f_banner.sql ----
INSERT INTO `f_banner` (`banner_id`, `company_info_id`, `image_path`, `title_zh`, `title_en`, `subtitle_zh`, `subtitle_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 1, '/uploads/banner/banner-01.jpg', '连续板带处理产线', 'Continuous Strip Processing Lines', '20+套连续板带处理生产线 worldwide experience', '20+ Continuous Strip Processing Lines', 1, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_banner` (`banner_id`, `company_info_id`, `image_path`, `title_zh`, `title_en`, `subtitle_zh`, `subtitle_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 1, '/uploads/banner/0f146cda148947409d2664f6ae4bbc23.jpeg', '硅钢连续处理技术', 'Silicon Steel Processing', '无取向与取向硅钢全工序处理', 'Full-process electrical steel solutions', 2, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 13:51:38', NULL, 0);
INSERT INTO `f_banner` (`banner_id`, `company_info_id`, `image_path`, `title_zh`, `title_en`, `subtitle_zh`, `subtitle_en`, `sort_order`, `is_published`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 1, '/uploads/banner/b25a56e5c9f94f8a9a75198c06513c7a.jpeg', '感应加热解决方案', 'Induction Heating', '电磁感应加热与节能应用', 'Advanced induction heating solutions', 3, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 15:03:27', NULL, 0);

-- ---- Data from export: f_case_study.sql ----
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 1, '河北兆建', 'Hebaizhao Steel', NULL, NULL, '中国', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 1, '印尼钢铁', 'Indonesia Steel', NULL, NULL, '印度尼西亚', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, 3, '大力神', 'Dalishi', NULL, NULL, '中国', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 30, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (4, 6, '中国宝武', 'China Baowu', NULL, NULL, '中国', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 40, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (5, 7, '宝钢硅钢', 'Baosteel Silicon', NULL, NULL, '中国', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 50, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_study` (`case_study_id`, `category_id`, `client_name_zh`, `client_name_en`, `project_name_zh`, `project_name_en`, `location`, `description_zh`, `description_en`, `scope_zh`, `scope_en`, `achievement_zh`, `achievement_en`, `is_overseas`, `is_featured`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (6, 8, '首钢京唐', 'Shougang Jingtang', NULL, NULL, '中国', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 60, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_media_library.sql ----
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, '/uploads/banner/banner-01.jpg', 'banner-01.jpg', 'image', 'banner', '首页轮播1', 'Home banner 1', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 09:52:36', NULL, 1);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, '/uploads/banner/banner-02.jpg', 'banner-02.jpg', 'image', 'banner', '首页轮播2', 'Home banner 2', NULL, NULL, NULL, NULL, NULL, 1, 2, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 09:52:40', NULL, 1);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (3, '/uploads/banner/banner-03.jpg', 'banner-03.jpg', 'image', 'banner', '首页轮播3', 'Home banner 3', NULL, NULL, NULL, NULL, NULL, 1, 3, NULL, NULL, '2026-05-02 03:33:24', '2026-05-04 09:52:38', NULL, 1);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (500, '/uploads/other/bc56902299aa475b928eefca392c1a9e.png', 'image26.png', 'image/png', 'other', NULL, NULL, NULL, NULL, 1139637, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:01:56', '2026-05-04 12:01:56', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (501, '/uploads/product/9d84c8c939e8488780f11e97e5420a4c.jpeg', 'image37.jpeg', 'image/jpeg', 'product', NULL, NULL, NULL, NULL, 419077, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:02:59', '2026-05-04 12:02:59', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (502, '/uploads/product/cb7058f51a1d42299d748fa8ad06d18b.png', 'image38.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 1025837, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:03:42', '2026-05-04 12:03:42', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (503, '/uploads/product/c10aa9941c9247bdbdb9cf0a919b5658.png', 'image39.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 330634, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:03:50', '2026-05-04 12:03:50', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (504, '/uploads/product/0c19509ba68849a181f2a87fe3712627.png', 'image42.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 399611, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:04:41', '2026-05-04 12:04:41', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (505, '/uploads/product/4506ef5a13c2496b836ee5eb60ee70b3.png', 'image46.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 193198, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:06:07', '2026-05-04 12:06:07', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (506, '/uploads/product/9df433e224734fcba1ef2e5317a2f8cf.jpeg', 'image47.jpeg', 'image/jpeg', 'product', NULL, NULL, NULL, NULL, 107704, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:06:29', '2026-05-04 12:06:29', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (507, '/uploads/product/2f230804574c4cbe8545c3db20c0dd17.png', 'arbon Steel Pickling Line.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 932912, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:10:16', '2026-05-04 12:10:16', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (508, '/uploads/product/3db457c2a5b4450399a8554fc3fe0868.png', 'image57.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 715369, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:11:08', '2026-05-04 12:11:08', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (509, '/uploads/product/14c45beb89954cb3b5cd60a658ea87e5.png', 'image70.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 1696910, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:14:55', '2026-05-04 12:14:55', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (510, '/uploads/product/b22309676e6f4eb289385a02f9f2bc78.png', 'image71.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 502582, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:15:18', '2026-05-04 12:15:18', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (511, '/uploads/product/bad17b7509d5437d9596d3901442425e.png', 'image68.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 540328, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:15:33', '2026-05-04 12:15:33', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (512, '/uploads/product/b3adb0ac61e645268bab04b3b32f72bf.png', 'image66.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 344082, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:15:52', '2026-05-04 12:15:52', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (513, '/uploads/product/d96fbb8a1fef48409c06974c7182d624.png', 'image73.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 716212, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:16:26', '2026-05-04 12:16:26', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (514, '/uploads/product/ca2ab4ba45714592b5de832e23b0ef94.png', 'image66.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 344082, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:16:36', '2026-05-04 12:16:36', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (515, '/uploads/product/442b4b0b33984dd6b5f97add6c220ec9.png', 'image72.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 475922, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:17:01', '2026-05-04 12:17:01', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (516, '/uploads/product/e29a85b804b24e7e945899de26073754.png', 'image72.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 475922, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:17:52', '2026-05-04 12:17:52', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (517, '/uploads/product/fa5f85b49b804fe1a4babced896848b8.png', 'image88.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 919423, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:19:05', '2026-05-04 12:19:05', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (518, '/uploads/product/b092d8c6cc4f45409e9c331df5782c05.jpeg', 'image69.jpeg', 'image/jpeg', 'product', NULL, NULL, NULL, NULL, 1323533, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:19:21', '2026-05-04 12:19:21', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (519, '/uploads/product/6d8a2960c3de4fa3a495faabee82bea0.png', 'image64.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 279772, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:19:40', '2026-05-04 12:19:40', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (520, '/uploads/product/7ac4ae777be84f65b4d9e9e79bc39a90.png', 'image65.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 510604, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 12:20:02', '2026-05-04 12:20:02', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (521, '/uploads/banner/0f146cda148947409d2664f6ae4bbc23.jpeg', 'image47.jpeg', 'image/jpeg', 'banner', NULL, NULL, NULL, NULL, 107704, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 13:51:37', '2026-05-04 13:51:37', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (522, '/uploads/banner/b25a56e5c9f94f8a9a75198c06513c7a.jpeg', 'image69.jpeg', 'image/jpeg', 'banner', NULL, NULL, NULL, NULL, 1323533, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 15:03:26', '2026-05-04 15:03:26', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (523, '/uploads/other/630999551c9b42189e6a7b1db4699d57.jpeg', 'image1.jpeg', 'image/jpeg', 'other', NULL, NULL, NULL, NULL, 30377, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 15:08:06', '2026-05-04 15:08:06', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (524, '/uploads/product/67cdd048436f42c997b5e94ac5d8e457.png', 'image82.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 185560, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 20:03:42', '2026-05-04 20:03:42', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (525, '/uploads/product/4e60026238244f42b560fd901f9fc217.png', 'image84.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 78646, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 20:04:02', '2026-05-04 20:04:02', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (526, '/uploads/product/286aa5f9c48a4c94a99eaf940eba3bba.png', 'image82.png', 'image/png', 'product', NULL, NULL, NULL, NULL, 185560, NULL, NULL, 1, 0, NULL, NULL, '2026-05-04 20:04:23', '2026-05-04 20:04:23', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (527, '/uploads/workshop/00779c456eb04a9881a469d1df22a017.jpeg', 'image7.jpeg', 'image/jpeg', 'workshop', NULL, NULL, NULL, NULL, 682355, NULL, NULL, 1, 0, NULL, NULL, '2026-05-05 01:45:05', '2026-05-05 01:45:05', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (528, '/uploads/workshop/b951f2f518d345bfa2274c7cb379e0ab.jpeg', 'image8.jpeg', 'image/jpeg', 'workshop', NULL, NULL, NULL, NULL, 4060995, NULL, NULL, 1, 0, NULL, NULL, '2026-05-05 01:45:11', '2026-05-05 01:45:11', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (529, '/uploads/workshop/8630e86cc57c4029853acd4f0a917bd4.jpeg', 'image21.jpeg', 'image/jpeg', 'workshop', NULL, NULL, NULL, NULL, 469318, NULL, NULL, 1, 0, NULL, NULL, '2026-05-05 01:45:43', '2026-05-05 01:45:43', NULL, 0);
INSERT INTO `f_media_library` (`media_library_id`, `file_path`, `file_name`, `file_type`, `category`, `title_zh`, `title_en`, `description_zh`, `description_en`, `file_size`, `width`, `height`, `is_published`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (530, '/uploads/workshop/19149361136442d2966d1a8d23cbc42d.jpeg', 'image24.jpeg', 'image/jpeg', 'workshop', NULL, NULL, NULL, NULL, 4662487, NULL, NULL, 1, 0, NULL, NULL, '2026-05-05 01:48:01', '2026-05-05 01:48:01', NULL, 0);

-- ---- Data from export: f_product_media.sql ----
INSERT INTO `f_product_media` (`product_media_id`, `product_id`, `product_type`, `media_id`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 1, 'product_line', 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_product_media` (`product_media_id`, `product_id`, `product_type`, `media_id`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 2, 'product_line', 2, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);

-- ---- Data from export: f_case_media.sql ----
INSERT INTO `f_case_media` (`case_media_id`, `case_id`, `media_id`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (1, 1, 1, 10, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
INSERT INTO `f_case_media` (`case_media_id`, `case_id`, `media_id`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remark`, `del_flag`) VALUES (2, 4, 2, 20, NULL, NULL, '2026-05-02 03:33:24', '2026-05-02 03:33:24', NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;
