52 lines
2.1 KiB
SQL
52 lines
2.1 KiB
SQL
--hse巡检增加隐患类型
|
|
alter table HSSE_Hazard_HazardRegister
|
|
add HiddenType nvarchar(50) NULL;
|
|
|
|
--专项检查增加隐患类型
|
|
alter table Check_CheckSpecialDetail
|
|
add HiddenType nvarchar(50) NULL;
|
|
|
|
--综合检查增加隐患类型和级别
|
|
alter table Check_CheckColligationDetail
|
|
add HiddenHazardType nvarchar(50) NULL;
|
|
|
|
alter table Check_CheckColligationDetail
|
|
add HiddenType nvarchar(50) NULL;
|
|
|
|
--隐患整改单增加隐患类型和级别
|
|
alter table Check_RectifyNoticesItem
|
|
add HiddenType nvarchar(50) NULL;
|
|
|
|
alter table Check_RectifyNoticesItem
|
|
add HiddenHazardType nvarchar(50) NULL;
|
|
|
|
|
|
|
|
--增加隐患类型
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'高处坠落','高处坠落',1,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'物体打击','物体打击',2,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'车辆伤害','车辆伤害',3,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'机械伤害','机械伤害',4,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'起重伤害','起重伤害',5,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'触电','触电',6,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'火灾','火灾',7,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'灼烫','灼烫',8,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'坍塌','坍塌',9,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'淹溺','淹溺',10,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'爆炸','爆炸',11,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'中毒窒息','中毒窒息',12,'Hiddendangertype')
|
|
insert into Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
values(newid(),'环境损害','环境损害',13,'Hiddendangertype')
|