EmploymentSite/doc/待更新脚本.txt

-- 2024-5-28 修改企业数据可视化地图菜单与权限数据
INSERT INTO sys_function_code VALUES ('T0110', '数据可视化地图', 'T01', 7);
INSERT INTO sys_function_code VALUES ('T011001', '企业数据可视化地图', 'T0110', 1);
DELETE FROM sys_function_code WHERE FunctionCode = 'T010203';
INSERT INTO `sys_menu` VALUES ('T0110', 9, '数据可视化地图', 'GlobalOutlined', NULL, '/dataMap', 'T01', NULL, 0, 1, 0, 'T0110', 1, NULL);
INSERT INTO `sys_menu` VALUES ('T011001', 1, '企业数据可视化地图', NULL, 'views/dataMap/companyDataMap', '/companyDataMap', 'T0110', NULL, 0, 1, 1, 'T011001', 1, NULL);
DELETE FROM sys_menu WHERE MenuNo = 'T010203';
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0110');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011001');
DELETE FROM sys_role_sys_function_code WHERE FunctionCode = 'T010203'

-- 2024-5-28 添加驿站站点数据可视化地图菜单与权限数据
INSERT INTO sys_function_code VALUES ('T011002', '驿站站点数据可视化地图', 'T0110', 2);
INSERT INTO `sys_menu` VALUES ('T011002', 2, '驿站站点数据可视化地图', NULL, 'views/dataMap/siteDataMap', '/siteDataMap', 'T0110', NULL, 0, 1, 1, 'T011002', 1, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011002');

-- 2024-5-29 求职人员数据可视化地图菜单与权限
INSERT INTO sys_function_code VALUES ('T011003', '求职人员数据可视化地图', 'T0110', 3);
INSERT INTO `sys_menu` VALUES ('T011003', 3, '求职人员数据可视化地图', NULL, 'views/dataMap/jobUserDataMap', '/jobUserDataMap', 'T0110', NULL, 0, 1, 1, 'T011003', 1, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011003');

-- 2024.5.31
alter table sys_menu add IsBlank tinyint(1);
update sys_menu set IsBlank=1 where MenuNo='T011001';
update sys_menu set IsBlank=1 where MenuNo='T011002';
update sys_menu set IsBlank=1 where MenuNo='T011003';


-- 2024.6.3
alter table pc_recommend_mgt add remark varchar(500);