21 lines
1.0 KiB
Transact-SQL
21 lines
1.0 KiB
Transact-SQL
--修改试车菜单
|
|
update sys_menu set SortIndex=0 where menuid='BC860C85-B224-48A6-B207-D7042BB71088';
|
|
|
|
update sys_menu set menuname='系统资产导入' where MenuId='F0E06491-B1DA-4510-ABCA-D09F4B24EE50';
|
|
|
|
update sys_menu set menuname='试车记录管理' where MenuId='29F80818-17A5-4BC0-8C38-A17415B0AC83';
|
|
|
|
update sys_menu set menuname='投料试车记录管理' where MenuId='B62482DA-9A12-45AC-9427-D0CF8A78EE2C';
|
|
|
|
update sys_menu set menuname='开车工程师项目工作总结' where MenuId='9EBA628D-E725-4A0B-B765-171F405D0821';
|
|
|
|
--增加索引，执行速度会有点慢
|
|
CREATE INDEX ProjectId_Index ON SitePerson_Checking (ProjectId);
|
|
CREATE INDEX IdentityCard_Index ON SitePerson_Checking (IdentityCard);
|
|
CREATE INDEX IntoOutTime_Index ON SitePerson_Checking (IntoOutTime);
|
|
CREATE INDEX IntoOut_Index ON SitePerson_Checking (IntoOut);
|
|
CREATE INDEX UnitId ON SitePerson_Checking (UnitId);
|
|
|
|
CREATE NONCLUSTERED INDEX [SitePerson_Checking_ProjectId_IntoOut_IntoOutTime_Index]
|
|
ON [dbo].[SitePerson_Checking] ([ProjectId],[IntoOut],[IntoOutTime])
|
|
INCLUDE ([IdentityCard]); |