--2024-5-8 企业表索引
ALTER TABLE `employmentsitedb`.`pc_firm` ADD INDEX `nameIndex` ( `FirmName` );
--2024-05-08 日志、任务路由调整
update sys_menu set IsVisible= 0  where MenuNo='T0104';
update sys_menu set ParentMenuNo = 'T01' where ParentMenuNo='T0104';
update sys_menu set OrderNo = '5',Icon='FlagOutlined',Url='/workTask',isLeaf=1 where MenuNo='T010401';
update sys_menu set ViewPath = 'views/workTask/index'  where MenuNo='T01040101';
update sys_menu set ViewPath = 'views/workTask/add'  where MenuNo='T01040102';
update sys_menu set ViewPath = 'views/workTask/edit'  where MenuNo='T01040103';
update sys_menu set ViewPath = 'views/workTask/detail'  where MenuNo='T01040105';

update sys_menu set OrderNo = '6',Icon='ScheduleOutlined',Url='/taskAndLog',isLeaf=1 where MenuNo='T010402' ;
update sys_menu set ViewPath = 'views/workLog/index'  where MenuNo='T01040201';
update sys_menu set ViewPath = 'views/workLog/add'  where MenuNo='T01040202';
update sys_menu set ViewPath = 'views/workLog/edit'  where MenuNo='T01040203';
update sys_menu set ViewPath = 'views/workLog/detail'  where MenuNo='T01040205';

update sys_menu set OrderNo = '7' where MenuNo='T0105';
update sys_menu set OrderNo = '8' where MenuNo='T0106';
--2024-5-8 工作日志表添加驿站ID
ALTER TABLE `employmentsitedb`.`pc_dowork` ADD COLUMN `SiteID` VARCHAR ( 50 ) NULL AFTER `WorkTime`;