-- ----------------------------
-- 需要在租户运营的upms微服务所操作的数据库中执行该脚本
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 租户全局字典表
-- ----------------------------
DROP TABLE IF EXISTS `zz_tenant_global_dict`;
CREATE TABLE `zz_tenant_global_dict` (
  `dict_id` bigint(20) NOT NULL COMMENT '主键Id',
  `dict_code` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '字典编码',
  `dict_name` varchar(2048) COLLATE utf8mb4_bin NOT NULL COMMENT '字典中文名称',
  `tenant_common` int NOT NULL COMMENT '是否为租户公用字典。0不是，1是',
  `initial_data` text COLLATE utf8mb4_bin COMMENT '租户的非公用字典的初始化字典数据',
  `create_user_id` bigint NOT NULL COMMENT '创建用户Id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_user_id` bigint NOT NULL COMMENT '更新用户名',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `deleted_flag` int NOT NULL COMMENT '逻辑删除字段',
  PRIMARY KEY (`dict_id`),
  KEY `idx_dict_code` (`dict_code`) USING BTREE,
  KEY `idx_tenant_common` (`tenant_common`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户全局字典表';

-- ----------------------------
-- 租户全局字典项目表
-- ----------------------------
DROP TABLE IF EXISTS `zz_tenant_global_dict_item`;
CREATE TABLE `zz_tenant_global_dict_item` (
  `id` bigint(20) NOT NULL COMMENT '主键Id',
  `dict_code` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '字典编码',
  `tenant_id` bigint COMMENT '租户Id',
  `item_id` varchar(64) NOT NULL COMMENT '字典数据项Id',
  `item_name` varchar(1024) COLLATE utf8mb4_bin NOT NULL COMMENT '字典数据项名称',
  `show_order` int NOT NULL COMMENT '显示顺序',
  `status` int NOT NULL COMMENT '字典状态',
  `create_user_id` bigint NOT NULL COMMENT '创建用户Id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_user_id` bigint NOT NULL COMMENT '更新用户名',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `deleted_flag` int NOT NULL COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`),
  KEY `idx_show_order` (`show_order`) USING BTREE,
  KEY `idx_dict_code_item_id` (`dict_code`,`item_id`) USING BTREE,
  KEY `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户全局字典项目表';

SET FOREIGN_KEY_CHECKS = 1;