菜单_系统更新说明.sql
1.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
-- 系统更新说明：管理端动态菜单（挂在「系统管理」下，与「系统公告」同级）
-- 页面：antis-ncc-admin/src/views/lqChangelog/index.vue
-- 路由：/lqChangelog
SET @ModuleId = 'lq-changelog-admin';
SELECT F_Id INTO @ParentId
FROM BASE_MODULE
WHERE F_FullName = '系统管理' AND F_Type = 1 AND F_DeleteMark IS NULL
LIMIT 1;
SELECT F_Id INTO @SourceModuleId
FROM BASE_MODULE
WHERE F_FullName = '系统公告' AND F_Type = 2 AND F_DeleteMark IS NULL
LIMIT 1;
DELETE FROM BASE_AUTHORIZE WHERE F_ItemId = @ModuleId;
DELETE FROM BASE_MODULE WHERE F_Id = @ModuleId;
INSERT INTO BASE_MODULE (
F_Id, F_ParentId, F_Type, F_FullName, F_EnCode, F_UrlAddress, F_Icon,
F_SortCode, F_EnabledMark, F_Category, F_DeleteMark, F_LinkTarget,
F_PropertyJson, F_IsButtonAuthorize, F_IsColumnAuthorize, F_IsDataAuthorize,
F_IsFormAuthorize, F_CreatorTime, F_CreatorUserId, F_Description
)
VALUES (
@ModuleId,
@ParentId,
2,
'系统更新说明',
'system.changelog',
'lqChangelog',
'icon-ym icon-ym-generator-notice',
18,
1,
'Web',
NULL,
'_self',
'{"iconBackgroundColor":"","moduleId":""}',
1, 1, 1, 1,
NOW(),
'admin',
'系统版本更新日志管理（新增/发布）'
);
INSERT INTO BASE_AUTHORIZE (
F_Id, F_ItemType, F_ItemId, F_ObjectType, F_ObjectId, F_SortCode, F_CreatorTime, F_CreatorUserId
)
SELECT REPLACE(UUID(), '-', ''), 'module', @ModuleId, 'Role', t.F_ObjectId, 1, NOW(), 'admin'
FROM (
SELECT DISTINCT F_ObjectId
FROM BASE_AUTHORIZE
WHERE F_ItemId = @SourceModuleId AND F_ItemType = 'module' AND F_ObjectType = 'Role'
) t;