37 lines
1.1 KiB
MySQL
37 lines
1.1 KiB
MySQL
|
|
|||
|
|
|
|||
|
|
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD>⣺Σ<EFBFBD>ռ<EFBFBD><EFBFBD><EFBFBD>Ϊ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݴ<EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
update Hazard_HazardSelectedItem
|
|||
|
|
set HazardLevel='84e1d680-5bfe-48d2-a255-59f43aa3615a'
|
|||
|
|
where HazardLevel is null and HazardJudge_D<=120
|
|||
|
|
GO
|
|||
|
|
update Hazard_HazardSelectedItem
|
|||
|
|
set HazardLevel='01537cc5-e8d2-497c-ba53-1faca1faf495'
|
|||
|
|
where HazardLevel is null and HazardJudge_D<=170 and HazardJudge_D>120
|
|||
|
|
GO
|
|||
|
|
update Hazard_HazardSelectedItem
|
|||
|
|
set HazardLevel='6baaf2bb-ee7c-410c-9a32-13208626c467'
|
|||
|
|
where HazardLevel is null and HazardJudge_D<=320 and HazardJudge_D>170
|
|||
|
|
GO
|
|||
|
|
update Hazard_HazardSelectedItem
|
|||
|
|
set HazardLevel='c9e6285c-2da3-4997-8dc9-fb6ab404346e'
|
|||
|
|
where HazardLevel is null and HazardJudge_D>320
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>鲹<EFBFBD><EFBFBD><EFBFBD>ֶΣ<EFBFBD><EFBFBD><EFBFBD>Դ˵<EFBFBD><EFBFBD>
|
|||
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CQMS_Meeting' AND COLUMN_NAME = 'SourceDes')
|
|||
|
|
BEGIN
|
|||
|
|
ALTER TABLE CQMS_Meeting ADD SourceDes nvarchar(500);
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>߲<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֶΣ<EFBFBD><EFBFBD><EFBFBD>Դ˵<EFBFBD><EFBFBD>
|
|||
|
|
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Comprehensive_InspectionMachine' AND COLUMN_NAME = 'SourceDes')
|
|||
|
|
BEGIN
|
|||
|
|
ALTER TABLE Comprehensive_InspectionMachine ADD SourceDes nvarchar(500);
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|