You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
8.1 KiB
SQL
49 lines
8.1 KiB
SQL
create table auths
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
name varchar(50) not null comment '项目名称',
|
|
title varchar(20) not null comment '显示标题',
|
|
icon varchar(100) default '' not null comment '显示图标',
|
|
pid int not null comment '上级ID',
|
|
type tinyint not null comment '1-分组 2-页面/接口',
|
|
check_type tinyint not null comment '1-不需要验证 2-需要验证 3-特殊验证规则',
|
|
`show` tinyint default 1 not null comment '1-显示 2-不显示',
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
`order` int default 0 not null comment '排序',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (1, 'admin_basics', '后台基础接口', '', 0, 1, 1, 2, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (2, 'admin_basics_login', '后台登录', '', 1, 2, 1, 2, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (3, 'admin', '管理员设置', 'every-user', 0, 1, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (4, 'admin-info', '个人设置', 'user', 3, 2, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (5, 'admin-auth', '权限管理', 'personal-privacy', 3, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (6, 'admin-list', '管理员列表', 'every-user', 3, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (7, 'settings', '后台管理', 'setting', 0, 1, 1, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (8, 'settings-config', '后台配置', 'setting-config', 7, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (9, 'settings-router', '路由配置', 'left-and-right-branch', 7, 2, 2, 1, 1, 2, 0, '2023-04-06 23:01:36', '2023-04-06 23:01:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (10, 'config', '基础设置', 'config', 0, 1, 1, 1, 1, 2, 0, '2023-04-07 14:41:39', '2023-04-07 14:41:39');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (11, 'config-hospital', '医院管理', 'hospital', 10, 2, 2, 1, 1, 2, 0, '2023-04-07 14:43:14', '2023-04-07 14:43:14');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (12, 'appointment', '预约管理', 'plan', 0, 1, 1, 1, 1, 2, 0, '2023-04-07 23:52:36', '2023-04-07 23:52:36');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (13, 'appointment-template', '计划模板', 'add-mode', 12, 2, 2, 1, 1, 2, 0, '2023-04-07 23:59:18', '2023-04-07 23:59:18');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (14, 'appointment-holidays', '节假日', 'beach-umbrella', 12, 2, 2, 1, 1, 2, 0, '2023-04-08 14:08:10', '2023-04-08 14:08:10');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (15, 'appointment-list', '预约计划', 'plan', 12, 2, 2, 1, 1, 2, 0, '2023-04-10 11:08:18', '2023-04-10 11:08:18');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (17, 'config-additional', '医院额外配置', 'tips-one', 10, 2, 2, 1, 1, 2, 0, '2023-04-11 09:31:54', '2023-04-11 09:31:54');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (18, 'user', '用户管理', 'user', 0, 1, 1, 1, 1, 2, 0, '2023-04-12 11:55:39', '2023-04-12 11:55:39');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (19, 'user-list', '用户列表', 'user', 18, 2, 2, 1, 1, 2, 0, '2023-04-12 11:55:58', '2023-04-12 11:55:58');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (20, 'user-person', '体检人列表', 'peoples', 18, 2, 2, 1, 1, 2, 0, '2023-04-13 09:24:52', '2023-04-13 09:24:52');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (21, 'hospital', '医院&小程序管理', 'plus-cross', 0, 1, 1, 1, 1, 2, 0, '2023-06-09 22:00:36', '2023-06-10 14:27:48');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (22, 'hospital-info', '基础信息', 'info', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:02:15', '2023-06-09 22:02:15');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (23, 'hospital-home', '首页管理', 'home', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:04:02', '2023-06-09 22:04:02');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (24, 'hospital-combo', '套餐管理', 'graphic-stitching-three', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:05:09', '2023-06-09 22:05:09');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (25, 'hospital-additional', '额外配置', 'setting-two', 21, 2, 2, 1, 1, 2, 0, '2023-06-09 22:06:09', '2023-06-09 22:06:09');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (26, 'order-order', '订单管理', 'order', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:06:55', '2023-06-10 14:25:09');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (27, 'order-template', '计划模板', 'plan', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:08:32', '2023-06-10 14:25:15');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (28, 'order-appointment', '计划管理', 'plan', 29, 2, 2, 1, 1, 2, 0, '2023-06-09 22:09:15', '2023-06-10 14:25:22');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (29, 'order', '计划&订单', 'order', 0, 1, 1, 1, 1, 2, 0, '2023-06-10 14:24:29', '2023-06-10 14:24:29');
|
|
INSERT INTO lkpe.auths (id, name, title, icon, pid, type, check_type, `show`, status, del, `order`, created_at, updated_at) VALUES (30, 'order-super_order', '超级订单管理', 'text-wrap-overflow', 29, 2, 2, 1, 1, 2, 0, '2023-06-10 14:44:41', '2023-06-10 14:44:41');
|