ifm/WebRoot/xgwd/wscl1.0.sql

create table da_wssb 
(
   ID                   char(10)                       not null,
   MCID                 int(10),
   SBID                 int(10),
   XGSJ                 timestamp,
   XGR                  int(10),
   ZFBZ                 varchar(20),
   constraint PK_DA_WSSB primary key clustered (ID)
);

create table wscl_bjsz 
(
   ID                   int(10)                        not null,
   SBID                 int(10),
   MCID                 int(10),
   KG                   varchar(200),
   BJXID                varchar(200),
   BJXW                 varchar(200),
   SJHM                 varchar(200),
   BZ                   varchar(200),
   XGR                  varchar(10),
   XGSJ                 timestamp,
   constraint PK_WSCL_BJSZ primary key clustered (ID)
);


create table wscl_gyfldy 
(
   ID                   int(10)                        not null,
   SBID                 int(10),
   MCID                 int(10),
   ZDYXKG               varchar(10),
   GZYLB                varchar(10),
   GZJCJ                varchar(10),
   GZZDDJ               varchar(10),
   GZZDS                varchar(10),
   GZSLB                varchar(10),
   GZPWB                varchar(10),
   GZLYB                varchar(10),
   GYWYLC               varchar(10),
   GYWWSC               varchar(10),
   GYWLYC               varchar(10),
   DYWWSC               varchar(10),
   DYWYLC               varchar(10),
   DYWLYC               varchar(10),
   SCYLB                varchar(10),
   SCJCJ                varchar(10),
   SCZDDJ               varchar(10),
   SCZDS                varchar(10),
   SCSLB                varchar(10),
   SCPWB                varchar(10),
   SCLYB                varchar(10),
   SCBJ                 varchar(10),
   SCSJ                 timestamp,
   constraint PK_WSCL_GYFLDY primary key clustered (ID)
);


create table wscl_zyns1 
(
   ID                   int(10)                        not null,
   MCID                 int(10),
   SBID                 int(10),
   XTQD                 varchar(10),
   XTTZ                 varchar(10),
   GLSXDYW              varchar(10),
   GLSXGYW              varchar(10),
   ZJSXDYW              varchar(10),
   ZJSXGYW              varchar(10),
   JSFK									varchar(10),
   JSFG                 varchar(10),
   CXFK                 varchar(10),
   CXFG									varchar(10),
   XHFK                 varchar(10),
   XHFG                 varchar(10),
   SPFK                 varchar(10),
   SPFG                 varchar(10),
   XPFK                 varchar(10),
   XPFG                 varchar(10),
   FXFK                 varchar(10),
   FXFG                 varchar(10),
   CSFK                 varchar(10),
   CSFG                 varchar(10),
   CPFK                 varchar(10),
   CPFG                 varchar(10),
   NFJSYL               varchar(10),
   NFCSGY               varchar(10),
   NFCXFK               varchar(10),
   NFCXFG               varchar(10),
   NFGYBYX              varchar(10),
   NFGYBGZ              varchar(10),
   MCXBYX               varchar(10),
   MCXBGZ               varchar(10),
   ZYBYX                varchar(10),
   ZYBGZ                varchar(10),
   ZGJJYJLBYX           varchar(10),
   PHJYJLBYX            varchar(10),
   YJJJYJLBYX           varchar(10),
   UF1SFXSJ             varchar(10),
   UF1YXSJ              varchar(10),
   UF1XFXSJ             varchar(10),
   UF1ZXSJ              varchar(10),
   UF1YXSYSJ            varchar(10),
   UF1SFXSYSJ           varchar(10),
   UF1XFXSYSJ           varchar(10),
   UF1ZXSYSJ            varchar(10),
   UF1QD                varchar(10),
   UF1TJ                varchar(10),
   UF1DJ                varchar(10),
   UF1YX                varchar(10),
   UF1SFX               varchar(10),
   UF1XFX               varchar(10),
   UF1ZX                varchar(10),
   UF1FX                varchar(10),
   NFGYBPL              varchar(10),
   MCXBPL               varchar(10),
   UFZYBPL              varchar(10),
   NFKJCXSJ             varchar(10),
   NFYXSJ               varchar(10),
   NFTJCXSJ             varchar(10),
   NFKJCXSYSJ           varchar(10),
   NFYXSYSJ             varchar(10),
   NFTJCXSYSJ           varchar(10),
   NFQD                 varchar(10),
   NFTJ                 varchar(10),
   NFJT                 varchar(10),
   NFDJ                 varchar(10),
   NFKJCX               varchar(10),
   NFYX                 varchar(10),
   NFTJCX               varchar(10),
   SCSJ                 timestamp NULL DEFAULT NULL ,
   constraint PK_WSCL_ZYNS1 primary key clustered (ID)
);

create table wscl_zyns2 
(
   ID                   int(10)                        not null,
   MCID                 int(10),
   SBID                 int(10),
   XTQD                 varchar(10),
   XTTZ                 varchar(10),
   CXSXDYW              varchar(10),
   CZSXGYW              varchar(10),
   ZJSXDYW              varchar(10),
   ZJSXGYW              varchar(10),
   JSFK           	varchar(10),
   JSFG                 varchar(10),
   CXFK                 varchar(10),
   CXFG			varchar(10),
   XHFK                 varchar(10),
   XHFG                 varchar(10),
   SPFK                 varchar(10),
   SPFG                 varchar(10),
   XPFK                 varchar(10),
   XPFG                 varchar(10),
   FXFK                 varchar(10),
   FXFG                 varchar(10),
   CSFK                 varchar(10),
   CSFG                 varchar(10),
   CPFK                 varchar(10),
   CPFG                 varchar(10),
   ROJSYL               varchar(10),
   ROCSGY               varchar(10),
   ROCXFK               varchar(10),
   ROCXFG               varchar(10),
   ROGYBYX              varchar(10),
   ROGYBGZ              varchar(10),
   MCXBYX               varchar(10),
   MCXBGZ               varchar(10),
   UFZYBYX              varchar(10),
   UFZYBGZ              varchar(10),
   ROZYBYX              varchar(10),
   ROZYBGZ              varchar(10),
   NFZYBYX              varchar(10),
   NFZYBGZ              varchar(10),
   ZGJJYJLBYX           varchar(10),
   SWJMQYX              varchar(10),
   UF2SFXSJ             varchar(10),
   UF2YXSJ              varchar(10),
   UF2XFXSJ             varchar(10),
   UF2ZXSJ              varchar(10),
   UF2YXSYSJ            varchar(10),
   UF2SFXSYSJ           varchar(10),
   UF2XFXSYSJ           varchar(10),
   UF2ZXSYSJ            varchar(10),
   UF2QD                varchar(10),
   UF2TJ                varchar(10),
   UF2DJ                varchar(10),
   UF2YX                varchar(10),
   UF2SFX               varchar(10),
   UF2XFX               varchar(10),
   UF2ZX                varchar(10),
   UF2FX                varchar(10),
   ROGYBPL              varchar(10),
   MCXBPL               varchar(10),
   UFZYBPL              varchar(10),
   ROKJCXSJ             varchar(10),
   ROYXSJ               varchar(10),
   ROTJCXSJ             varchar(10),
   ROKJCXSYSJ           varchar(10),
   ROYXSYSJ             varchar(10),
   ROTJCXSYSJ           varchar(10),
   ROQD                 varchar(10),
   ROTJ                 varchar(10),
   ROJT                 varchar(10),
   RODJ                 varchar(10),
   ROKJCX               varchar(10),
   ROYX                 varchar(10),
   ROTJCX               varchar(10),
   SCSJ                  timestamp NULL DEFAULT NULL ,
   constraint PK_WSCL_ZYNS2 primary key clustered (ID)
);
create table da_yckzsms 
(
   ID                   int(10)                        not null,
   MCID                 int(10),
   SRC                  varchar(200),
   ZFBZ                 varchar(1),
   XGSJ                 timestamp,
   XGR                  int(10),
   constraint PK_DA_YCKZSMS primary key clustered (ID)
);
create table xx_sbgz 
(
   ID                   int(10)                        not null,
   MCID                 int(10),
   SBID                 int(10),
   GZLX                 varchar(20),
   FSSJ                 timestamp,
   CLSJ                 timestamp,
   SFTZ                 varchar(20),
   constraint PK_XX_SBGZ primary key clustered (ID)
);

DROP TABLE IF EXISTS `wscl_sbgz`;
CREATE TABLE `wscl_sbgz`(
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `MCID` int(10) NULL DEFAULT NULL,
  `SBID` int(10) NULL DEFAULT NULL,
  `GZLX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FSSJ` timestamp NULL DEFAULT NULL,
  `CLSJ` timestamp NULL DEFAULT NULL,
  `SFTZ` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

DROP TABLE IF EXISTS `xx_sbgz`;
CREATE TABLE `xx_sbgz`  (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `MCID` int(10) NULL DEFAULT NULL,
  `SBID` int(10) NULL DEFAULT NULL,
  `GZLX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FSSJ` timestamp NULL DEFAULT NULL,
  `CLSJ` timestamp NULL DEFAULT NULL,
  `SFTZ` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

DROP TABLE IF EXISTS `wscl_sbgz`;
CREATE TABLE `wscl_sbgz`(
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `MCID` int(10) NULL DEFAULT NULL,
  `SBID` int(10) NULL DEFAULT NULL,
  `GZLX` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FSSJ` timestamp NULL DEFAULT NULL,
  `CLSJ` timestamp NULL DEFAULT NULL,
  `SFTZ` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;
INSERT INTO `ifm`.`xt_dmlb` (`LBID`, `LBMC`, `JC`, `SXH`, `XGR`, `XGSJ`, `ZFBZ`, `cs1`) VALUES ('58', '污水故障类型', '1', '58', '1', '2019-07-24 15:56:32', '0', NULL);

INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '1', '原料泵过载', '2', '1', NULL, NULL, '1', '2019-07-24 16:02:04', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '2', '挤出机过载', '2', '2', NULL, NULL, '1', '2019-07-24 16:02:38', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '3', '振动电机过载', '2', '3', NULL, NULL, '1', '2019-07-24 16:02:57', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '4', '振荡筛过载', '2', '4', '', '', '1', '2019-07-24 16:02:57', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '5', '上料泵过载', '2', '5', NULL, NULL, '1', '2019-07-24 16:03:46', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '6', '排污泵过载', '2', '6', NULL, NULL, '1', '2019-07-24 16:04:21', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '7', '滤液泵过载', '2', '7', NULL, NULL, '1', '2019-07-24 16:04:49', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '8', '原料池高液位过高', '2', '8', NULL, NULL, '1', '2019-07-24 16:05:40', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '9', '污水池高液位过高', '2', '9', NULL, NULL, '1', '2019-07-24 16:06:02', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '10', '滤液池高液位过高', '2', '10', NULL, NULL, '1', '2019-07-24 16:06:30', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '11', '原料池低液位过低', '2', '11', NULL, NULL, '1', '2019-07-24 16:06:53', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '12', '污水池低液位过低', '2', '12', NULL, NULL, '1', '2019-07-24 16:07:13', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '13', '滤液池低液位过低', '2', '13', NULL, NULL, '1', '2019-07-24 16:07:53', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '14', '原料池低液位故障', '2', '14', NULL, NULL, '1', '2019-07-24 16:08:16', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '15', '污水池低液位故障', '2', '15', NULL, NULL, '1', '2019-07-24 16:08:36', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '16', '滤液池低液位故障', '2', '16', NULL, NULL, '1', '2019-07-24 16:09:02', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '17', '原料泵输出故障', '2', '17', NULL, NULL, '1', '2019-07-24 16:09:23', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '18', '挤出机输出故障', '2', '18', NULL, NULL, '1', '2019-07-24 16:09:52', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '19', '振动点击输出故障', '2', '19', NULL, NULL, '1', '2019-07-24 16:10:17', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '20', '振荡筛输出故障', '2', '20', NULL, NULL, '1', '2019-07-24 16:10:56', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '21', '上料泵输出故障', '2', '21', NULL, NULL, '1', '2019-07-24 16:11:16', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '22', '排污泵输出故障', '2', '22', NULL, NULL, '1', '2019-07-24 16:11:59', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '23', '滤液泵输出故障', '2', '23', NULL, NULL, '1', '2019-07-24 16:12:22', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '24', '过滤水箱液位过高', '2', '24', NULL, NULL, '1', '2019-07-24 16:12:49', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '25', '过滤水箱液位过低', '2', '25', NULL, NULL, '1', '2019-07-24 16:14:02', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '26', '过滤水箱液位故障', '2', '26', NULL, NULL, '1', '2019-07-24 16:14:29', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '27', '中间水箱液位过高', '2', '27', NULL, NULL, '1', '2019-07-24 16:14:57', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '28', '中间水箱液位过低', '2', '28', NULL, NULL, '1', '2019-07-24 16:15:30', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '29', '中间水箱液位故障', '2', '29', NULL, NULL, '1', '2019-07-24 16:16:09', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '30', '进水阀1故障', '2', '30', NULL, NULL, '1', '2019-07-24 16:16:35', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '31', '冲洗阀1故障', '2', '31', NULL, NULL, '1', '2019-07-24 16:17:02', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '32', '循环阀1故障', '2', '32', NULL, NULL, '1', '2019-07-24 16:17:25', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '33', '上排阀1故障', '2', '33', NULL, NULL, '1', '2019-07-24 16:17:45', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '34', '下排阀1故障', '2', '34', NULL, NULL, '1', '2019-07-24 16:18:23', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '35', '反洗阀1故障', '2', '35', NULL, NULL, '1', '2019-07-24 16:18:48', '0');

INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '36', '产水阀1故障', '2', '36', NULL, NULL, '1', '2019-07-24 16:19:13', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '37', '产排阀1故障', '2', '37', NULL, NULL, '1', '2019-07-24 16:19:34', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '38', 'NF冲洗阀故障', '2', '38', NULL, NULL, '1', '2019-07-24 16:19:59', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '39', 'NF进水压力过低', '2', '39', NULL, NULL, '1', '2019-07-24 16:20:22', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '40', 'NF产水压力过高', '2', '40', NULL, NULL, '1', '2019-07-24 16:20:46', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '41', 'NF高压泵故障', '2', '41', NULL, NULL, '1', '2019-07-24 16:21:08', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '42', '膜冲洗泵1故障', '2', '42', NULL, NULL, '1', '2019-07-24 16:21:29', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '43', '增压泵1故障', '2', '43', NULL, NULL, '1', '2019-07-24 16:22:00', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '44', '冲洗水箱液位过高', '2', '44', NULL, NULL, '1', '2019-07-24 16:24:52', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '45', '冲洗水箱液位过低', '2', '45', NULL, NULL, '1', '2019-07-24 16:24:56', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '46', '冲洗水箱液位故障', '2', '46', NULL, NULL, '1', '2019-07-24 16:26:02', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '47', '进水阀2故障', '2', '47', NULL, NULL, '1', '2019-07-24 16:26:06', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '48', '冲洗阀2故障', '2', '48', NULL, NULL, '1', '2019-07-24 16:26:17', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '49', '循环阀2故障', '2', '49', NULL, NULL, '1', '2019-07-24 16:26:53', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '50', '上排阀2故障', '2', '50', NULL, NULL, '1', '2019-07-24 16:27:13', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '51', '下排阀2故障', '2', '51', NULL, NULL, '1', '2019-07-24 16:27:37', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '52', '反洗阀2故障', '2', '52', NULL, NULL, '1', '2019-07-24 16:28:03', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '53', '产水阀2故障', '2', '53', NULL, NULL, '1', '2019-07-24 16:28:56', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '54', '产排阀2故障', '2', '54', NULL, NULL, '1', '2019-07-24 16:29:23', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '55', 'RO冲洗阀故障', '2', '55', NULL, NULL, '1', '2019-07-24 16:29:44', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '56', 'RO进水压力过低', '2', '56', NULL, NULL, '1', '2019-07-24 16:30:06', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '57', 'RO产水压力过高', '2', '57', NULL, NULL, '1', '2019-07-24 16:30:30', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '58', 'RO高压泵故障', '2', '58', NULL, NULL, '1', '2019-07-24 16:30:54', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '59', 'UF2增压泵故障', '2', '59', NULL, NULL, '1', '2019-07-24 16:31:16', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '60', '膜冲洗泵2故障', '2', '60', NULL, NULL, '1', '2019-07-24 16:32:03', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '61', 'NF增压泵故障', '2', '61', NULL, NULL, '1', '2019-07-24 16:32:28', '0');
INSERT INTO `ifm`.`xt_gydm` (`LBID`, `DMID`, `DMMC`, `JC`, `SXH`, `PYM`, `WBM`, `XGR`, `XGSJ`, `ZFBZ`) VALUES ('58', '62', 'RO增压泵故障', '2', '62', NULL, NULL, '1', '2019-07-24 16:33:07', '0');


DROP TABLE IF EXISTS `wscl_agps`;
CREATE TABLE `wscl_agps`  (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `GID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TIME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ICCID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IMEI` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RSSI` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ACCESSSERVER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MCC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MNC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CI` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LAC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SIGNAL` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;