升鲜宝高性能多语言解决方案（一）---升鲜宝生鲜配送供应链管理系统

 

升鲜宝高性能多语言解决方案（一）---升鲜宝生鲜配送供应链管理系统

 

数据库多语言改造说明

       

/*
 Navicat/MySQL
 Source Server         : sxb_scm_prod
 Source Server Version : MySQL 8.0
 File Encoding         : utf-8

 说明：
 1. 本脚本为“升鲜宝多语言数据库业务系统”完整 DDL。
 2. 命名风格对齐升鲜宝现有库：id / enabled / del_flag / sort_code / creator / create_date / updater / update_date / remark / dept_id。
 3. 本脚本以“新增表”为主，不直接删除现有 sys_static_translation / sys_dynamic_translation / pms_goods_i18n。
 4. 推荐原则：
    - 消息类：sys_i18n_message + sys_i18n_message_item
    - 界面文本类：sys_i18n_ui_resource + sys_i18n_ui_resource_item
    - 业务数据类：各业务主表对应 *_i18n 子表
    - 旧表 sys_static_translation 可继续兼容 UI 静态文本
    - 旧表 sys_dynamic_translation 不再作为未来主方案扩展
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

USE `yiwu_scm_prod`;

/* ============================================================
   一、语言中心
   ============================================================ */

DROP TABLE IF EXISTS `sys_i18n_language`;
CREATE TABLE `sys_i18n_language` (
  `id` bigint NOT NULL COMMENT '主键id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码，如 zh_CN、en_US、zh_TW、ja_JP',
  `lang_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言名称',
  `lang_native_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '语言本地名称',
  `lang_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '语言图标',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `default_flag` int NOT NULL DEFAULT '0' COMMENT '是否默认语言 0=否 1=是',
  `built_in_flag` int NOT NULL DEFAULT '0' COMMENT '是否系统内置 0=否 1=是',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_lang_code` (`lang_code`) USING BTREE,
  KEY `idx_sort_code` (`sort_code`) USING BTREE,
  KEY `idx_enabled_del` (`enabled`,`del_flag`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-语言定义表';

DROP TABLE IF EXISTS `sys_i18n_locale_setting`;
CREATE TABLE `sys_i18n_locale_setting` (
  `id` bigint NOT NULL COMMENT '主键id',
  `setting_scope` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作用域 system=系统 org=机构 user=用户 shop=门店',
  `setting_scope_id` bigint NOT NULL DEFAULT '0' COMMENT '作用域对象id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '默认语言编码',
  `timezone_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '时区编码',
  `currency_id` bigint DEFAULT NULL COMMENT '默认币种id=base_currency.id',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_scope_lang` (`setting_scope`,`setting_scope_id`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-默认语言设置表';

/* ============================================================
   二、消息中心（异常提示、审核提示、接口提示）
   ============================================================ */

DROP TABLE IF EXISTS `sys_i18n_message`;
CREATE TABLE `sys_i18n_message` (
  `id` bigint NOT NULL COMMENT '主键id',
  `message_code` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息编码，如 sys.save.success、wms.stock.not.enough',
  `message_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '消息分组，如 sys、crm、wms、hwms、fin',
  `message_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'info' COMMENT '消息类型 success/info/warn/error',
  `default_text` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '默认文案（建议中文）',
  `placeholder_count` int NOT NULL DEFAULT '0' COMMENT '占位符数量',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `built_in_flag` int NOT NULL DEFAULT '0' COMMENT '是否系统内置 0=否 1=是',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_message_code` (`message_code`) USING BTREE,
  KEY `idx_message_group` (`message_group`) USING BTREE,
  KEY `idx_enabled_del` (`enabled`,`del_flag`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-消息主表';

DROP TABLE IF EXISTS `sys_i18n_message_item`;
CREATE TABLE `sys_i18n_message_item` (
  `id` bigint NOT NULL COMMENT '主键id',
  `message_code` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息编码',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `message_text` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息翻译文本，支持占位符 {0} {1}',
  `version` int NOT NULL DEFAULT '0' COMMENT '版本号',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_msg_lang` (`message_code`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE,
  KEY `idx_enabled_del` (`enabled`,`del_flag`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-消息翻译表';

/* ============================================================
   三、界面资源中心（菜单、按钮、Label、列名、placeholder）
   ============================================================ */

DROP TABLE IF EXISTS `sys_i18n_ui_resource`;
CREATE TABLE `sys_i18n_ui_resource` (
  `id` bigint NOT NULL COMMENT '主键id',
  `resource_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源编码，如 crm.customer.list.btnAdd',
  `module_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模块编码，如 crm、wms、mall',
  `page_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '页面编码，如 customer.list',
  `platform_type` int NOT NULL DEFAULT '0' COMMENT '平台类型 0=web 1=app 2=mini 3=pos 4=wpf',
  `component_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件类型 menu/button/label/column/placeholder/tab/dialog/title',
  `default_text` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '默认文本',
  `resource_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '页面路径或组件路径',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `built_in_flag` int NOT NULL DEFAULT '0' COMMENT '是否系统内置 0=否 1=是',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_resource_code` (`resource_code`) USING BTREE,
  KEY `idx_module_page` (`module_code`,`page_code`) USING BTREE,
  KEY `idx_platform_type` (`platform_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-界面资源主表';

DROP TABLE IF EXISTS `sys_i18n_ui_resource_item`;
CREATE TABLE `sys_i18n_ui_resource_item` (
  `id` bigint NOT NULL COMMENT '主键id',
  `resource_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源编码',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `resource_text` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源文本',
  `version` int NOT NULL DEFAULT '0' COMMENT '版本号',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_ui_lang` (`resource_code`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE,
  KEY `idx_enabled_del` (`enabled`,`del_flag`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言-界面资源翻译表';

/* ============================================================
   四、业务数据多语言子表
   原则：主表保留默认值，翻译文本落到 *_i18n 子表
   ============================================================ */

DROP TABLE IF EXISTS `sys_menu_i18n`;
CREATE TABLE `sys_menu_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `menu_id` bigint NOT NULL COMMENT '菜单id=sys_menu.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `menu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单名称翻译',
  `menu_tip` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单提示翻译',
  `app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '移动端菜单名称翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_menu_lang` (`menu_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单多语言表';

DROP TABLE IF EXISTS `sys_notice_i18n`;
CREATE TABLE `sys_notice_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `notice_id` bigint NOT NULL COMMENT '通知id=sys_notice.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题翻译',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_notice_lang` (`notice_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通知多语言表';

DROP TABLE IF EXISTS `sys_dict_type_i18n`;
CREATE TABLE `sys_dict_type_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `dict_type_id` bigint NOT NULL COMMENT '字典类型id=sys_dict_type.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `dict_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_dict_type_lang` (`dict_type_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典类型多语言表';

DROP TABLE IF EXISTS `sys_dict_data_i18n`;
CREATE TABLE `sys_dict_data_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `dict_data_id` bigint NOT NULL COMMENT '字典数据id=sys_dict_data.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `dict_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典标签翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_dict_data_lang` (`dict_data_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典数据多语言表';

DROP TABLE IF EXISTS `cms_category_i18n`;
CREATE TABLE `cms_category_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `category_id` bigint NOT NULL COMMENT '帮助分类id=cms_category.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_cms_category_lang` (`category_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='帮助分类多语言表';

DROP TABLE IF EXISTS `cms_help_i18n`;
CREATE TABLE `cms_help_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `help_id` bigint NOT NULL COMMENT '帮助id=cms_help.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题翻译',
  `article_content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '正文翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_cms_help_lang` (`help_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='帮助内容多语言表';

DROP TABLE IF EXISTS `base_payment_i18n`;
CREATE TABLE `base_payment_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `payment_id` bigint NOT NULL COMMENT '支付方式id=base_payment.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `payment_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付方式名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_payment_lang` (`payment_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支付方式多语言表';

DROP TABLE IF EXISTS `base_currency_i18n`;
CREATE TABLE `base_currency_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `currency_id` bigint NOT NULL COMMENT '币种id=base_currency.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `currency_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '币种名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_currency_lang` (`currency_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='币种多语言表';

DROP TABLE IF EXISTS `fin_category_i18n`;
CREATE TABLE `fin_category_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `category_id` bigint NOT NULL COMMENT '财务类别id=fin_category.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '财务类别名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_fin_category_lang` (`category_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='财务类别多语言表';

DROP TABLE IF EXISTS `pms_goods_category_i18n`;
CREATE TABLE `pms_goods_category_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `category_id` bigint NOT NULL COMMENT '商品分类id=pms_goods_category.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品分类名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_goods_category_lang` (`category_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品分类多语言表';

DROP TABLE IF EXISTS `crm_sales_team_i18n`;
CREATE TABLE `crm_sales_team_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `team_id` bigint NOT NULL COMMENT '团队id=crm_sales_team.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `team_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '团队名称翻译',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '团队描述翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_team_lang` (`team_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='销售团队多语言表';

DROP TABLE IF EXISTS `cus_customer_source_i18n`;
CREATE TABLE `cus_customer_source_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `source_id` bigint NOT NULL COMMENT '客户来源id=cus_customer_source.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `source_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户来源名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_customer_source_lang` (`source_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户来源多语言表';

DROP TABLE IF EXISTS `cus_customer_star_i18n`;
CREATE TABLE `cus_customer_star_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `star_id` bigint NOT NULL COMMENT '客户星级id=cus_customer_star.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `star_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户星级名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_customer_star_lang` (`star_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户星级多语言表';

DROP TABLE IF EXISTS `cus_customer_period_i18n`;
CREATE TABLE `cus_customer_period_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `period_id` bigint NOT NULL COMMENT '客户账期id=cus_customer_period.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `customer_period_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账期名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_customer_period_lang` (`period_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户账期多语言表';

DROP TABLE IF EXISTS `cwms_inv_workhouse_i18n`;
CREATE TABLE `cwms_inv_workhouse_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `workhouse_id` bigint NOT NULL COMMENT '仓库id=cwms_inv_workhouse.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `workhouse_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仓库名称翻译',
  `address` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_workhouse_lang` (`workhouse_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户仓库多语言表';

DROP TABLE IF EXISTS `cwms_inv_workhouse_area_i18n`;
CREATE TABLE `cwms_inv_workhouse_area_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `area_id` bigint NOT NULL COMMENT '库区id=cwms_inv_workhouse_area.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `workhouse_area_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '库区名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_workhouse_area_lang` (`area_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户库区多语言表';

DROP TABLE IF EXISTS `cwms_inv_shelves_i18n`;
CREATE TABLE `cwms_inv_shelves_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `shelves_id` bigint NOT NULL COMMENT '货架id=cwms_inv_shelves.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `shelves_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '货架名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_shelves_lang` (`shelves_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户货架多语言表';

DROP TABLE IF EXISTS `cwms_inv_bin_i18n`;
CREATE TABLE `cwms_inv_bin_i18n` (
  `id` bigint NOT NULL COMMENT '主键id',
  `bin_id` bigint NOT NULL COMMENT '货位id=cwms_inv_bin.id',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `bin_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '货位名称翻译',
  `remark_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注翻译',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_bin_lang` (`bin_id`,`lang_code`) USING BTREE,
  KEY `idx_lang_code` (`lang_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='客户货位多语言表';

/* ============================================================
   五、兼容与迁移辅助表
   ============================================================ */

DROP TABLE IF EXISTS `sys_i18n_missing_log`;
CREATE TABLE `sys_i18n_missing_log` (
  `id` bigint NOT NULL COMMENT '主键id',
  `biz_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '缺失类型 message/ui/data',
  `biz_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务编码，如 message_code/resource_code/实体标识',
  `lang_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '语言编码',
  `fallback_value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回退文本',
  `hit_count` int NOT NULL DEFAULT '1' COMMENT '命中次数',
  `last_hit_date` bigint DEFAULT NULL COMMENT '最后命中时间',
  `sort_code` int NOT NULL DEFAULT '1' COMMENT '排序码',
  `del_flag` int NOT NULL DEFAULT '0' COMMENT '删除标记 0正常 1删除',
  `enabled` int NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1正常',
  `create_date` bigint DEFAULT NULL COMMENT '创建时间',
  `creator` bigint NOT NULL DEFAULT '0' COMMENT '创建人id',
  `update_date` bigint DEFAULT NULL COMMENT '修改时间',
  `updater` bigint NOT NULL DEFAULT '0' COMMENT '修改人id',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT '0' COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_missing_biz_lang` (`biz_type`,`biz_code`,`lang_code`) USING BTREE,
  KEY `idx_last_hit_date` (`last_hit_date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='多语言缺失命中日志表';

/* ============================================================
   六、初始化数据（可按需保留）
   ============================================================ */

INSERT INTO `sys_i18n_language`
(`id`,`lang_code`,`lang_name`,`lang_native_name`,`lang_icon`,`sort_code`,`default_flag`,`built_in_flag`,`del_flag`,`enabled`,`create_date`,`creator`,`update_date`,`updater`,`remark`,`dept_id`)
VALUES
(1000000000000000001,'zh_CN','简体中文','简体中文',NULL,1,1,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'系统默认语言',0),
(1000000000000000002,'en_US','英文','English',NULL,2,0,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'英文',0),
(1000000000000000003,'zh_TW','繁體中文','繁體中文',NULL,3,0,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'繁体中文',0),
(1000000000000000004,'ja_JP','日语','日本語',NULL,4,0,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'日语',0);

INSERT INTO `sys_i18n_message`
(`id`,`message_code`,`message_group`,`message_type`,`default_text`,`placeholder_count`,`sort_code`,`built_in_flag`,`del_flag`,`enabled`,`create_date`,`creator`,`update_date`,`updater`,`remark`,`dept_id`)
VALUES
(1000000000000001001,'sys.save.success','sys','success','保存成功',0,1,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'系统内置消息',0),
(1000000000000001002,'sys.update.success','sys','success','修改成功',0,2,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'系统内置消息',0),
(1000000000000001003,'sys.delete.success','sys','success','删除成功',0,3,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'系统内置消息',0),
(1000000000000001004,'sys.data.not.exist','sys','error','数据不存在',0,4,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'系统内置消息',0),
(1000000000000001005,'wms.stock.not.enough','wms','error','商品【{0}】库存不足，当前可用数量【{1}】',2,5,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'库存不足消息',0),
(1000000000000001006,'sys.bill.already.approved','sys','warn','单据已审核，不能重复审核',0,6,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'审核类消息',0);

INSERT INTO `sys_i18n_message_item`
(`id`,`message_code`,`lang_code`,`message_text`,`version`,`sort_code`,`del_flag`,`enabled`,`create_date`,`creator`,`update_date`,`updater`,`remark`,`dept_id`)
VALUES
(1000000000000002001,'sys.save.success','zh_CN','保存成功',0,1,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002002,'sys.save.success','en_US','Saved successfully',0,2,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002003,'sys.update.success','zh_CN','修改成功',0,3,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002004,'sys.update.success','en_US','Updated successfully',0,4,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002005,'sys.delete.success','zh_CN','删除成功',0,5,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002006,'sys.delete.success','en_US','Deleted successfully',0,6,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002007,'sys.data.not.exist','zh_CN','数据不存在',0,7,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002008,'sys.data.not.exist','en_US','Data does not exist',0,8,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002009,'wms.stock.not.enough','zh_CN','商品【{0}】库存不足，当前可用数量【{1}】',0,9,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002010,'wms.stock.not.enough','en_US','Insufficient stock for product [{0}], available quantity [{1}]',0,10,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002011,'sys.bill.already.approved','zh_CN','单据已审核，不能重复审核',0,11,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0),
(1000000000000002012,'sys.bill.already.approved','en_US','The document has already been approved and cannot be approved again',0,12,0,1,UNIX_TIMESTAMP()*1000,0,UNIX_TIMESTAMP()*1000,0,'',0);

SET FOREIGN_KEY_CHECKS = 1;