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.
20 lines
983 B
SQL
20 lines
983 B
SQL
create table admins
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
nickname varchar(30) not null comment '名称',
|
|
admin_auth_id int not null comment '权限ID',
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null,
|
|
hospital bigint not null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index admins_hospital_index
|
|
on admins (hospital);
|
|
|
|
INSERT INTO lkpe.admins (id, nickname, admin_auth_id, status, del, created_at, updated_at, hospital) VALUES (1, '超级管理员', -1, 1, 2, '2023-04-06 23:01:36', '2023-04-06 23:01:36', 0);
|
|
INSERT INTO lkpe.admins (id, nickname, admin_auth_id, status, del, created_at, updated_at, hospital) VALUES (2, '测试医院管理员', 1, 1, 2, '2023-06-09 15:31:02', '2023-06-09 22:15:44', 1);
|