mypara.sql

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

delete from sy_user;
insert into sy_user(user_id,user_name,passwd) values('1','1','1');

delete from sy_MODEL;
insert into sy_MODEL(model_id,name,htm) values('00','网络检测','00.asp');
insert into sy_MODEL(model_id,name,htm) values('01','数据采集处理','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0101','告警信息显示','0101.asp');
insert into sy_MODEL(model_id,name,htm) values('0102','告警信息处理','0102.asp');
insert into sy_MODEL(model_id,name,htm) values('0103','告警/退服基站','0103.asp');
insert into sy_MODEL(model_id,name,htm) values('02','告警查询管理','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0201','告警单项查询','0201.asp');
insert into sy_MODEL(model_id,name,htm) values('0202','告警组合查询','0202.asp');
insert into sy_MODEL(model_id,name,htm) values('03','告警统计管理','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0301','告警单项统计','0301.asp');
insert into sy_MODEL(model_id,name,htm) values('0302','告警复合统计','0302.asp');
insert into sy_MODEL(model_id,name,htm) values('0303','告警同期比较','0303.asp');
insert into sy_MODEL(model_id,name,htm) values('0304','告警基站统计','0304.asp');
insert into sy_MODEL(model_id,name,htm) values('0305','告警异常统计','0305.asp');
insert into sy_MODEL(model_id,name,htm) values('0306','日统计报表','0306.asp');
insert into sy_MODEL(model_id,name,htm) values('04','告警报表管理','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0401','告警信息过录表','0401.asp');
insert into sy_MODEL(model_id,name,htm) values('0402','系统参数表打印','0402.asp');
insert into sy_MODEL(model_id,name,htm) values('040201','各地市基本信息表','040201.asp');
insert into sy_MODEL(model_id,name,htm) values('040202','各设备厂商基本信息表','040202.asp');
insert into sy_MODEL(model_id,name,htm) values('040203','告警名称基本信息表','040203.asp');
insert into sy_MODEL(model_id,name,htm) values('040204','告警基站基本信息表','040204.asp');
insert into sy_MODEL(model_id,name,htm) values('05','系统参数管理','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0501','地市信息维护','0501.asp');
insert into sy_MODEL(model_id,name,htm) values('0502','设备厂商维护','0502.asp');
insert into sy_MODEL(model_id,name,htm) values('0503','告警级别维护','0503.asp');
insert into sy_MODEL(model_id,name,htm) values('0504','告警状态维护','0504.asp');
insert into sy_MODEL(model_id,name,htm) values('0505','告警名称维护','0505.asp');
insert into sy_MODEL(model_id,name,htm) values('0506','告警基站维护','0506.asp');
insert into sy_MODEL(model_id,name,htm) values('0507','IP地址的维护','0507.asp');
insert into sy_MODEL(model_id,name,htm) values('06','系统安全维护','ok.asp');
insert into sy_MODEL(model_id,name,htm) values('0601','用户信息管理','0601.asp');
insert into sy_MODEL(model_id,name,htm) values('0602','用户权限管理','0602.asp');
insert into sy_MODEL(model_id,name,htm) values('0604','功能模块维护','0603.asp');
insert into sy_MODEL(model_id,name,htm) values('0605','查询类型维护','0604.asp');
insert into sy_MODEL(model_id,name,htm) values('0606','数据备份','0605.asp');


delete from sy_query;
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('CITY_NO','所属地市','PARA_CITY_NO','1','x');
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('AGENCY_NO','设备厂商','PARA_AGENCY_NO','2','x');
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('ALARM_LEVEL_NO','告警级别','PARA_ALARM_LEVEL_NO','4','y');
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('ALARM_STATUS_NO','告警状态','PARA_ALARM_STATUS_NO','5','y');
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('ALARM_NAME_NO','告警名称','PARA_ALARM_NAME_NO','6','y');
insert into sy_query(QUERY,name,Q_TABLE,no,mark) values ('ALARM_SITE_NO','告警基站','PARA_ALARM_SITE_NO','7','z');

delete from para_city_no;
insert into para_city_no(CITY_NO,name) values('51','太原');
insert into para_city_no(CITY_NO,name) values('52','大同');
insert into para_city_no(CITY_NO,name) values('53','阳泉');
insert into para_city_no(CITY_NO,name) values('54','晋中');
insert into para_city_no(CITY_NO,name) values('55','长治');
insert into para_city_no(CITY_NO,name) values('56','晋城');
insert into para_city_no(CITY_NO,name) values('57','临汾');
insert into para_city_no(CITY_NO,name) values('58','吕梁');
insert into para_city_no(CITY_NO,name) values('0','所有所属地市');
insert into para_city_no(CITY_NO,name) values('50','忻州');
insert into para_city_no(CITY_NO,name) values('49','朔州');
insert into para_city_no(CITY_NO,name) values('59','运城');

delete from para_Agency_no;
insert into Para_Agency_no(Agency_no,name) values('01','NOKIA');
insert into Para_Agency_no(Agency_no,name) values('02','MOTOROLA');
insert into Para_Agency_no(Agency_no,name) values('03','ALCATEL');
insert into Para_Agency_no(Agency_no,name) values('04','华为');
insert into Para_Agency_no(Agency_no,name) values('05','中兴');
insert into Para_Agency_no(Agency_no,name) values('06','其他');
insert into Para_Agency_no(Agency_no,name) values('0','所有设备厂商');

delete from para_alarm_sort_no;
insert into Para_Alarm_Sort_No(Alarm_Sort_NO,name) values('1','电源');
insert into Para_Alarm_Sort_No(Alarm_Sort_NO,name) values('2','空调');
insert into Para_Alarm_Sort_No(Alarm_Sort_NO,name) values('3','环境');
insert into Para_Alarm_Sort_No(Alarm_Sort_NO,name) values('0','所有告警类型');

delete from para_alarm_level_no;
insert into Para_Alarm_Level_no(Alarm_Level_no,name) values('1','紧急');
insert into Para_Alarm_Level_no(Alarm_Level_no,name) values('2','重要');
insert into Para_Alarm_Level_no(Alarm_Level_no,name) values('3','一般');
insert into Para_Alarm_Level_no(Alarm_Level_no,name) values('0','所有告警级别');

delete from para_alarm_status_no;
insert into Para_Alarm_Status_no(Alarm_Status_no,name) values('1','开始');
insert into Para_Alarm_Status_no(Alarm_Status_no,name) values('2','结束');
insert into Para_Alarm_Status_no(Alarm_Status_no,name) values('3','取消');
insert into Para_Alarm_Status_no(Alarm_Status_no,name) values('0','所有告警状态');

delete from para_alarm_name_no;
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('01','交流断电','1','1','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('02','开关电源设备故障','1','3','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('03','空调故障','2','1','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('04','水浸','3','1','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('05','烟火告警','3','3','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('06','温度告警','3','3','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('07','门禁','1','2','15');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('08','交流缺相','1','2','500');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('09','交流欠压','2','2','500');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('10','交流过压','1','2','500');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('00','监控系统本身故障','1','1','1');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('0','所有告警名称','','','');
insert into Para_Alarm_name_NO(ALARM_NAME_NO,name,ALARM_SORT_NO,ALARM_LEVEL_NO,bound) values('11','直流欠压','1','1','15');

delete from sy_privilegs;
insert into sy_privilegs select '1',model_id from sy_MODEL;

delete from sy_sql;
insert into sy_sql values(0,'SELECT alarm_status_No,Alarm_Time 告警时间,city_no(city_no) 所属地市,agency_no(agency_no) 设备厂商,alarm_site_no(alarm_site_no) 基站名称,alarm_level_no(alarm_level_no) 告警级别,alarm_name_no(alarm_name_no) 告警名称,Remark 备注 FROM ALARM',null);
insert into sy_sql values(1,'SELECT alarm_status_No,Alarm_Time 告警时间,Cancel_Time as 取消时间,city_no(city_no) 所属地市,agency_no(agency_no) 设备厂商,alarm_site_no(alarm_site_no) 基站名称,alarm_level_no(alarm_level_no) 告警级别,Alarm_Status_No(Alarm_Status_No) 告警状态,alarm_name_no(alarm_name_no) 告警名称,Remark 备注 FROM ALARM_ENV a',null);
insert into sy_sql values(3,'SELECT alarm_status_No,Alarm_Time 告警时间,city_no(city_no) 所属地市,agency_no(agency_no) 设备厂商,alarm_site_no(alarm_site_no) 基站名称,alarm_level_no(alarm_level_no) 告警级别,alarm_name_no(alarm_name_no) 告警名称,Remark 备注 FROM ALARM_env',null);



delete from ip_addr;
insert into ip_addr(ip,name) values('10.204.50.120','华为');
insert into ip_addr(ip,name) values('10.204.50.110','大同摩托罗拉');
insert into ip_addr(ip,name) values('133.134.19.110','太原摩托罗拉');
insert into ip_addr(ip,name) values('133.140.19.55','晋中摩托罗拉');
insert into ip_addr(ip,name) values('133.140.19.58','中兴LSC');
insert into ip_addr(ip,name) values('133.146.19.50','临汾阿尔卡特');
insert into ip_addr(ip,name) values('133.142.19.50','长治阿尔卡特');
insert into ip_addr(ip,name) values('133.144.19.50','晋城阿尔卡特');
insert into ip_addr(ip,name) values('133.150.19.50','运城阿尔卡特');

commit;