56 lines
2.8 KiB
Transact-SQL
56 lines
2.8 KiB
Transact-SQL
|
|
|
|
--新增隐患类型
|
|
|
|
|
|
|
|
update HSSE_Hazard_HazardRegister set Risk_Level='一般事故隐患' where Risk_Level='一般';
|
|
go
|
|
|
|
update HSSE_Hazard_HazardRegister set Risk_Level='重大事故隐患' where Risk_Level='重大';
|
|
go
|
|
|
|
update HSSE_Hazard_HazardRegister set Risk_Level='较大事故隐患' where Risk_Level='较大';
|
|
go
|
|
|
|
|
|
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '15B87AA0-556E-49A0-9293-0EA4EACF8D04', '其他伤害', '其他伤害',14,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '15B87AA0-556E-49A0-9293-0EA4EACF8D04' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT 'D40FB4D8-E062-472F-A207-579A8693C2FD', '其他爆炸', '其他爆炸',15,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = 'D40FB4D8-E062-472F-A207-579A8693C2FD' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '229655EC-D220-483A-85A3-632FD092A158', '透水', '透水',16,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '229655EC-D220-483A-85A3-632FD092A158' AND GroupId='Hiddendangertype');
|
|
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '6D51F2BB-0BE1-4B7A-896F-32AFE26FD1C6', '冒顶片帮', '冒顶片帮',17,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '6D51F2BB-0BE1-4B7A-896F-32AFE26FD1C6' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '75E13D80-CD89-4D38-85F2-AF71C6CA94B3', '放炮', '放炮',18,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '75E13D80-CD89-4D38-85F2-AF71C6CA94B3' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '106FAA43-22B6-43A8-BBFA-E7E4129416CF', '瓦斯爆炸', '瓦斯爆炸',19,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '106FAA43-22B6-43A8-BBFA-E7E4129416CF' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '7CAC43A0-CC3F-4AD0-9FFD-BC4FA9B6169D', '火药爆炸', '火药爆炸',20,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '7CAC43A0-CC3F-4AD0-9FFD-BC4FA9B6169D' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '18B44A92-D602-44AC-BCEF-913873A94757', '锅炉爆炸', '锅炉爆炸',21,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '18B44A92-D602-44AC-BCEF-913873A94757' AND GroupId='Hiddendangertype');
|
|
|
|
INSERT INTO Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
SELECT '59A2D1CB-311F-4015-9F55-88707101284B', '容器爆炸', '容器爆炸',22,'Hiddendangertype'
|
|
WHERE NOT EXISTS (SELECT 1 FROM Sys_Const WHERE ID = '59A2D1CB-311F-4015-9F55-88707101284B' AND GroupId='Hiddendangertype');
|
|
go
|