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.
56 lines
2.6 KiB
56 lines
2.6 KiB
1 week ago
|
-- ----------------------------
|
||
|
|
-- 一定要在与upms相同的数据库中执行该脚本。
|
||
|
|
-- ----------------------------
|
||
|
|
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- 移动端入口表
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `zz_mobile_entry`;
|
||
|
|
CREATE TABLE `zz_mobile_entry` (
|
||
|
|
`entry_id` bigint NOT NULL COMMENT '主键Id',
|
||
|
|
`tenant_id` bigint DEFAULT NULL COMMENT '租户Id',
|
||
|
|
`parent_id` bigint DEFAULT NULL COMMENT '父Id',
|
||
|
|
`entry_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '显示名称',
|
||
|
|
`entry_type` int NOT NULL COMMENT '移动端入口类型',
|
||
|
|
`common_entry` int NOT NULL DEFAULT '0' COMMENT '通用入口对所有角色可见',
|
||
|
|
`image_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '图片数据的Base……￥',
|
||
|
|
`extra_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '附件信息',
|
||
|
|
`show_order` 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 '更新者Id',
|
||
|
|
`update_time` datetime NOT NULL COMMENT '最后更新时间',
|
||
|
|
PRIMARY KEY (`entry_id`) USING BTREE,
|
||
|
|
KEY `idx_tenant_id` (`tenant_id`) USING BTREE,
|
||
|
|
KEY `idx_show_order` (`show_order`) USING BTREE,
|
||
|
|
KEY `idx_common_entry` (`common_entry`) USING BTREE,
|
||
|
|
KEY `idx_entry_type` (`entry_type`) USING BTREE
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='移动端入口表';
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- 数据权限和移动端入口对应关系表
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `zz_mobile_entry_data_perm`;
|
||
|
|
CREATE TABLE `zz_mobile_entry_data_perm` (
|
||
|
|
`data_perm_id` bigint NOT NULL COMMENT '数据权限Id',
|
||
|
|
`entry_id` bigint NOT NULL COMMENT '移动端入口Id',
|
||
|
|
PRIMARY KEY (`data_perm_id`,`entry_id`) USING BTREE,
|
||
|
|
KEY `idx_entry_id` (`entry_id`) USING BTREE
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='数据权限和移动端入口对应关系表';
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- 角色和移动端入口对应关系表
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `zz_mobile_entry_role`;
|
||
|
|
CREATE TABLE `zz_mobile_entry_role` (
|
||
|
|
`role_id` bigint NOT NULL COMMENT '角色Id',
|
||
|
|
`entry_id` bigint NOT NULL COMMENT '移动端入口Id',
|
||
|
|
PRIMARY KEY (`role_id`,`entry_id`) USING BTREE,
|
||
|
|
KEY `idx_entry_id` (`entry_id`) USING BTREE
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='角色和移动端入口对应关系表';
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|