c_nokia.sql

linux下c 编写的 某项目代理服务端部分的代码。其中包括网络通信

DROP TABLE fx_alarm;
Create Table fx_alarm(
consec_nbr    number(10)  not null,
INT_ID        number(10)  not null,
ALARM_STATUS  varchar2(1)   NOT NULL,
ALARM_TIME    DATE        NOT NULL,
CANCEL_TIME   DATE ,
ALARM_NUMBER  varchar2(4)   NOT NULL,
SEVERITY      varchar2(1)   NOT NULL
);

drop table objects;
create table objects(
INT_ID       number(10)   not null,
NAME         varchar2(20) 
);

delete from fx_alarm;
delete from objects;
insert into fx_alarm values('12345','11111','0',to_date('2005.07.0610:34:30','yyyy.mm.ddhh24:mi:ss'),
to_date('2005.07.0610:37:21','yyyy.mm.ddhh24:mi:ss'),'7401','1');

insert into fx_alarm values('12453','22222','0',to_date('2005.07.0610:37:30','yyyy.mm.ddhh24:mi:ss'),null,'7402','2');
insert into fx_alarm values('14521','33333','0',to_date('2005070610:34:30','yyyymmddhh24:mi:ss'),null,'7403','3');
insert into fx_alarm values('12565','44444','0',to_date('2005070610:34:30','yyyymmddhh24:mi:ss'),
to_date('2005070610:37:21','yyyymm ddhh24:mi:ss'),'7404','4');
insert into fx_alarm values('24153','55555','0',to_date('2005070610:34:30','yyyymmddhh24:mi:ss'),
to_date('2005070610:37:21','yyyymmddhh24:mi:ss'),'7405','5');
insert into fx_alarm values('82345','66666','0',to_date('2005070610:34:30','yyyymmddhh24:mi:ss'),
to_date('2005070610:37:21','yyyymmddhh24:mi:ss'),'7406','6');

insert into objects  values('11111','zhongshu');
insert into objects  values('22222','ganmao');
insert into objects  values('33333','zhongfeng');
insert into objects  values('44444','xiaoxixi');
insert into objects  values('55555','lehehe');
insert into objects  values('66666','meizizi');