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.
33 lines
3.1 KiB
SQL
33 lines
3.1 KiB
SQL
INSERT INTO dev_poms.sys_auth (name,code,`group`,is_deleted,version,create_user,create_time,update_user,update_time) VALUES
|
|
('添加用户','SYSTEM:USER:SAVE','user',0,1,'admin','2022-10-26 17:40:33',NULL,NULL),
|
|
('删除用户','SYSTEM:USER:DELETE','user',0,1,'admin','2022-10-26 17:56:10',NULL,NULL),
|
|
('更新用户','SYSTEM:USER:UPDATE','user',0,1,'admin','2022-10-26 17:57:23',NULL,NULL),
|
|
('修改用户','SYSTEM:USER:MODIFY','user',0,1,'admin','2022-10-26 17:58:01',NULL,NULL),
|
|
('查询用户','SYSTEM:USER:LOAD','user',0,1,'admin','2022-10-26 17:59:56',NULL,NULL),
|
|
('分页查询用户','SYSTEM:USER:PAGE','user',0,1,'admin','2022-12-28 14:32:21',NULL,NULL),
|
|
('查询角色列表','SYSTEM:ROLE:LIST','role',0,1,'admin','2023-01-28 11:31:24',NULL,NULL),
|
|
('查询权限列表','SYSTEM:AUTH:LIST','auth',0,1,'admin','2023-01-28 13:51:44',NULL,NULL),
|
|
('分页查询权限','SYSTEM:ROLE:PAGE','role',0,1,'admin','2023-01-29 15:49:43',NULL,NULL),
|
|
('更新角色','SYSTEM:ROLE:UPDATE','role',0,1,'admin','2023-01-30 13:56:11',NULL,NULL);
|
|
INSERT INTO dev_poms.sys_auth (name,code,`group`,is_deleted,version,create_user,create_time,update_user,update_time) VALUES
|
|
('查询部门列表','SYSTEM:DEPT:LIST','dept',0,1,'admin','2023-01-31 12:35:22',NULL,NULL),
|
|
('查询部门信息','SYSTEM:DEPT:LOAD','dept',0,1,'admin','2023-01-31 13:11:45',NULL,NULL),
|
|
('赋予权限','SYSTEM:AUTH:AUTHORISE','auth',0,1,'admin','2023-02-02 13:09:14',NULL,NULL),
|
|
('撤销权限','SYSTEM:AUTH:UNAUTHORISE','auth',0,1,'admin','2023-02-02 13:10:08',NULL,NULL),
|
|
('查询用户列表','SYSTEM:USER:LIST','user',0,1,'admin','2023-02-08 11:22:13',NULL,NULL),
|
|
('更新组织信息','SYSTEM:DEPT:UPDATE','dept',0,1,'admin','2023-02-08 13:56:32',NULL,NULL),
|
|
('查询未读消息列表','SYSTEM:MESSAGE:LIST','message',0,1,'admin','2023-02-16 13:28:11',NULL,NULL),
|
|
('修改消息已读状态','SYSTEM:MESSAGE:UPDATE','message',0,1,'admin','2023-02-21 15:49:39',NULL,NULL),
|
|
('发布公告','SYSTEM:NOTICE:SAVE','notice',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('删除公告','SYSTEM:NOTICE:DELETE','notice',0,1,'admin','2023-02-23 14:11:11',NULL,NULL);
|
|
INSERT INTO dev_poms.sys_auth (name,code,`group`,is_deleted,version,create_user,create_time,update_user,update_time) VALUES
|
|
('分页查询公告','SYSTEM:NOTICE:PAGE','notice',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('添加组织','SYSTEM:DEPT:SAVE','dept',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('删除组织','SYSTEM:DEPT:DELETE','dept',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('审核积分','SYSTEM:POINT:AUDIT','point',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('添加积分项','SYSTEM:POINT:SAVE','point',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('删除积分项','SYSTEM:POINT:DELETE','point',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
('添加会议','SYSTEM:MEETING:SAVE','meeting',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
(' 删除会议','SYSTEM:MEETING:DELETE','meeting',0,1,'admin','2023-02-23 14:11:11',NULL,NULL),
|
|
(' 更新会议','SYSTEM:MEETING:UPDATE','meeting',0,1,'admin','2023-02-23 14:11:11',NULL,NULL);
|