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.
15 lines
681 B
SQL
15 lines
681 B
SQL
create table admin_auths
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
name varchar(20) not null comment '名称',
|
|
auth_ids varchar(1000) not null comment '权限IDS JSON',
|
|
remark varchar(100) not null comment '备注',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO lkpe.admin_auths (id, name, auth_ids, remark, del, created_at, updated_at) VALUES (1, '医院最高权限', '["22","23","24","25","26","27","28"]', '', 2, '2023-06-09 15:56:40', '2023-06-09 22:13:43');
|