41 lines
2.0 KiB
Transact-SQL
41 lines
2.0 KiB
Transact-SQL
--老数据清理
|
|
truncate table PreRun_SubInspectTerm
|
|
truncate table PreRun_SubInspectTermItem
|
|
truncate table PreRun_InspectTailTerm
|
|
truncate table PreRun_InspectTermApproveRecords
|
|
GO
|
|
--新菜单
|
|
delete Sys_Menu where MenuId='F184E0FC-96E3-48A5-9515-21EAD37053B3'
|
|
delete Sys_Menu where MenuId='19865B64-E0AA-4D32-9712-05C14FE6288F'
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F184E0FC-96E3-48A5-9515-21EAD37053B3','现场实施',null,'TestRun/BeforeTestRun/SiteImplementationList.aspx',12,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('19865B64-E0AA-4D32-9712-05C14FE6288F','试车记录上传',null,'TestRun/BeforeTestRun/TestRunRecordUploadList.aspx',13,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
|
go
|
|
|
|
--分包商通过日期
|
|
alter table PreRun_SubInspectTerm add SubcontractorAllPassData datetime null
|
|
--承包商通过日期
|
|
alter table PreRun_SubInspectTerm add ContractorAllPassData datetime null
|
|
--监理通过日期
|
|
alter table PreRun_SubInspectTerm add SupervisionAllPassData datetime null
|
|
--业主通过日期
|
|
alter table PreRun_SubInspectTerm add OwnerAllPassData datetime null
|
|
--检查表流转是否全部通过0:未通过1:通过
|
|
alter table PreRun_SubInspectTerm add WanderIsComplete int null
|
|
--检查表流转完成日期
|
|
alter table PreRun_SubInspectTerm add WanderCompleteData datetime null
|
|
--现场实施是否完成0:未完成1:已完成
|
|
alter table PreRun_SubInspectTerm add IsSiteImplement int null
|
|
--现场实施确认人
|
|
alter table PreRun_SubInspectTerm add SiteImplementUser varchar(50) null
|
|
--现场实施记录确认时间
|
|
alter table PreRun_SubInspectTerm add SiteImplementConfirmData datetime null
|
|
--现场实施记录上传日期
|
|
alter table PreRun_SubInspectTerm add RecordUploadData datetime null
|
|
--检查表是否关闭0:未关闭1:已关闭
|
|
alter table PreRun_SubInspectTerm add InspectIsClose int null
|
|
--检查表关闭人
|
|
alter table PreRun_SubInspectTerm add InspectIsCloseUser varchar(50) null
|
|
--检查表关闭日期
|
|
alter table PreRun_SubInspectTerm add InspectCloseData datetime null
|
|
GO
|