You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
51 lines
2.5 KiB
51 lines
2.5 KiB
-- ---------------------------- |
|
-- 需要在租户运营的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;
|
|
|