/*字典表增加故障服务项.sql*/
declare
v_cnt1 number;v_cnt2 number;
v_cnt3 number;v_cnt4 number;
begin
--先查询是否有这些数据
select count(*) into v_cnt2 from ak_publiccode where id =1051;
select count(*) into v_cnt3 from ak_publiccode where id =1052;
select count(*) into v_cnt4 from ak_publiccode where id =1053;
if v_cnt1 = 0 then
--如果没有则插入数据
end if;
if v_cnt2 = 0 then
insert into ak_publiccode values(1051,'服务',null,'事件类型',null,0,0);
end if;
if v_cnt3 = 0 then
insert into ak_publiccode values(1052,'客户服务器重启',1051,'事件类型',null,0,0);
end if;
if v_cnt4 = 0 then
insert into ak_publiccode values(1053,'查看设备状态',1051,'事件类型',null,0,0);
end if;
end;