CNCEC_SUBQHSE_WUHUAN/DataBase/版本日志/SGGLDB_WH_V2024-07-27-phf.sql

47 lines
2.2 KiB
SQL

alter table sys_menu
alter COLUMN menuname nvarchar(200);
UPDATE SYS_MENU set MenuName='工艺系统清单<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Process System List'
WHERE MENUID='197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB';
UPDATE SYS_MENU set MenuName='非工艺系统清单<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Non-Process System List'
WHERE MENUID='022428DC-FC99-4916-B8AF-6A9DC885DFAF';
UPDATE SYS_MENU set MenuName='管道<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Piping'
WHERE MENUID='D94C1BA4-9DFD-4514-AE12-6F886C5D8C9B';
UPDATE SYS_MENU set MenuName='静设备<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Static Equipment'
WHERE MENUID='982F746C-084C-445C-9AE8-8C37BDFE7994';
UPDATE SYS_MENU set MenuName='动设备<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rotating Equipment'
WHERE MENUID='7E2FB5F9-FB99-4455-B68F-460F1F9A2676';
UPDATE SYS_MENU set MenuName='仪表<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Instrumentation'
WHERE MENUID='88F51059-55B4-4CD5-A38C-36404E5029F6';
UPDATE SYS_MENU set MenuName='电气<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Electrical'
WHERE MENUID='296E75D2-192A-4D1F-8471-DD34263F8691';
UPDATE SYS_MENU set MenuName='消防<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Firefighting'
WHERE MENUID='794E64E2-FDD2-4B7D-8408-F7FB06F9C92A';
UPDATE SYS_MENU set MenuName='土建/建筑/结构<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Civil Structure'
WHERE MENUID='95C39F86-C060-452E-BA37-D891C466A39B';
UPDATE SYS_MENU set MenuName='电信<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Telecom'
WHERE MENUID='58FFBD80-ACB9-4830-A18A-E025D9600D94';
UPDATE SYS_MENU set MenuName='地管<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Plumbing'
WHERE MENUID='95295BF7-FB51-480D-9902-6ADA4E8427FC';
UPDATE SYS_MENU set MenuName='尾项管理<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Punch List Form'
WHERE MENUID='016903B1-3B86-4CF5-AFF8-FF8BE389BEE5';
alter table Transfer_PunchlistFrom
alter COLUMN Num_No nvarchar(50);
alter table Transfer_PunchlistFrom
alter COLUMN IsMatI nvarchar(50);