monitor
-- MySQL dump 10.13 Distrib 5.5.19, for Win32 (x86)
--
-- Host: localhost Database: monitor
-- ------------------------------------------------------
-- Server version 5.5.19
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bookresult`
--
DROP TABLE IF EXISTS `bookresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bookresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bookTime` varchar(50) DEFAULT NULL,
`citys` varchar(50) DEFAULT NULL,
`config` varchar(50) DEFAULT NULL,
`createDateTime` varchar(20) DEFAULT NULL,
`flightNumber` varchar(50) DEFAULT NULL,
`flightTime` varchar(50) DEFAULT NULL,
`isRead` int(11) DEFAULT NULL,
`name` varchar(400) DEFAULT NULL,
`returnCommand` varchar(2000) DEFAULT NULL,
`returnPnr` varchar(50) DEFAULT NULL,
`seat` varchar(50) DEFAULT NULL,
`seats` int(11) DEFAULT NULL,
`sendCommand` varchar(2000) DEFAULT NULL,
`sendDate` varchar(50) DEFAULT NULL,
`vetechUser` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bookresult`
--
LOCK TABLES `bookresult` WRITE;
/*!40000 ALTER TABLE `bookresult` DISABLE KEYS */;
INSERT INTO `bookresult` VALUES (1,'18:09:00','SHAPEK','CTU236','2014-11-05 18:21:59','MU5101','2014-11-15 08:00',1,'??,ZHANG/YUE,','HPGP4L -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r MU5101 Y SA15NOV SHAPEK DK2 0800 1020 \r MU2460 Y SU16NOV PEKWUH DK2 0805 1015 \r MU2501 Y MO17NOV WUHSHA DK2 0830 1000 \r MU5825 Y TU18NOV SHATSN DK2 0910 1120 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','HPGP4L','Y',2,'SS:MU5101/Y/15NOV/SHAPEK/2/0800 1020\rSS:MU2460/Y/16NOV/PEKWUH/2/0805 1015\rSS:MU2501/Y/17NOV/WUHSHA/2/0830 1000\rSS:MU5825/Y/18NOV/SHATSN/2/0910 1120\rNM 1??\r- 1ZHANG/YUE\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1809A\r@I','2014-11-05','NKGW'),(2,'18:08:16','PEKCGQ','CTU236','2014-11-05 18:21:59','CA1629','2014-11-06 14:50',0,'??,','HPGNYF -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r CA1629 Y TH06NOV PEKCGQ DK1 1450 1645 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','HPGNYF','Y',1,'SS:CA1629/Y/06NOV/PEKCGQ/1/1450 1645\rNM 1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070\rCT BY OPT XIAOPI1 2014/11/05 1808A\r\\I','2014-11-05','XIAOPI1'),(3,'18:07:28','SZXPEK','CTU236','2014-11-05 18:21:59','CA1398','2014-11-10 19:15',1,'???,',' CA1398 A MO10NOV SZXPEK DW1 1915 2225 \rHPGNRT -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r *** ??????HC, ?? HC:HELP *** \r','HPGNRT','A',1,'SS:CA1398/A/10NOV/SZXPEK/LL1/1915 2225\rNM 1???\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1807A\r@I','2014-11-05','NKGW'),(4,'18:14:57','SZXCKG','CTU236','2014-11-05 18:42:28','CA4344','2014-11-08 10:50',0,'???,???,??,???,??,???,??,???,',' CA4344 V SA08NOV SZXCKG DK8 1050 1255 V1 \rHPGQNG - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','HPGQNG','V',8,'SS:CA4344/V/08NOV/SZXCKG/8/1050 1255\rNM 1???\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1814A\r@','2014-11-05','TFPWS'),(5,'17:58:23','SZXCKG','CTU236','2014-11-05 18:42:28','CA4344','2014-11-08 10:50',1,'???,???,',' CA4344 V SA08NOV SZXCKG DK2 1050 1255 V1 \rJVD71M - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','JVD71M','V',2,'SS:CA4344/V/08NOV/SZXCKG/2/1050 1255\rNM 1???\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1758A\r@','2014-11-05','TFPWS');
/*!40000 ALTER TABLE `bookresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cancelpnrtime`
--
DROP TABLE IF EXISTS `cancelpnrtime`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cancelpnrtime` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`remark` text,
`time` int(11) DEFAULT NULL,
`timeInterval` varchar(20) DEFAULT NULL,
`vetechUserLevel` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cancelpnrtime`
--
LOCK TABLES `cancelpnrtime` WRITE;
/*!40000 ALTER TABLE `cancelpnrtime` DISABLE KEYS */;
/*!40000 ALTER TABLE `cancelpnrtime` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `emailinfo`
--
DROP TABLE IF EXISTS `emailinfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emailinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`depart` varchar(50) DEFAULT NULL,
`descript` varchar(500) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `emailinfo`
--
LOCK TABLES `emailinfo` WRITE;
/*!40000 ALTER TABLE `emailinfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `emailinfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `etermgroup`
--
DROP TABLE IF EXISTS `etermgroup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `etermgroup` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(50) DEFAULT NULL,
`groupid` varchar(50) DEFAULT NULL,
`memo` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `etermgroup`
--
LOCK TABLES `etermgroup` WRITE;
/*!40000 ALTER TABLE `etermgroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `etermgroup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `exceptionlog`
--
DROP TABLE IF EXISTS `exceptionlog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exceptionlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(5000) DEFAULT NULL,
`queryid` varchar(100) DEFAULT NULL,
`time` varchar(50) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `exceptionlog`
--
LOCK TABLES `exceptionlog` WRITE;
/*!40000 ALTER TABLE `exceptionlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `exceptionlog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `limit_tbl`
--
DROP TABLE IF EXISTS `limit_tbl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `limit_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`parentId` int(11) DEFAULT NULL,
`pw` int(11) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `limit_tbl`
--
LOCK TABLES `limit_tbl` WRITE;
/*!40000 ALTER TABLE `limit_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `limit_tbl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `operationlog`
--
DROP TABLE IF EXISTS `operationlog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `operationlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`commandExplain` varchar(50) DEFAULT NULL,
`ifSuccess` int(11) DEFAULT NULL,
`operationTime` varchar(20) DEFAULT NULL,
`vetechCommand` varchar(30) DEFAULT NULL,
`vetechUser` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `operationlog`
--
LOCK TABLES `operationlog` WRITE;
/*!40000 ALTER TABLE `operationlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `operationlog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pnrstatus`
--
DROP TABLE IF EXISTS `pnrstatus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pnrstatus` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`executeTime` varchar(50) DEFAULT NULL,
`executeType` varchar(50) DEFAULT NULL,
`pnr` varchar(50) DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pnrstatus`
--
LOCK TABLES `pnrstatus` WRITE;
/*!40000 ALTER TABLE `pnrstatus` DISABLE KEYS */;
INSERT INTO `pnrstatus` VALUES (1,'2014-11-05 18:48:16','RT','HPGP4L','XX'),(2,'2014-11-05 18:49:17','RT','HPGNRT','XL'),(3,'2014-11-05 18:49:17','RT','JVD71M','RR');
/*!40000 ALTER TABLE `pnrstatus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role_tbl`
--
DROP TABLE IF EXISTS `role_tbl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(30) NOT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `description` (`description`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role_tbl`
--
LOCK TABLES `role_tbl` WRITE;
/*!40000 ALTER TABLE `role_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_tbl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `seatresult`
--
DROP TABLE IF EXISTS `seatresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seatresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bigPnr` varchar(200) DEFAULT NULL,
`createDateTime` varchar(20) DEFAULT NULL,
`flightNumber` varchar(300) DEFAULT NULL,
`flightTime` varchar(300) DEFAULT NULL,
`isExecute` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`noXeRemark` varchar(100) DEFAULT NULL,
`pnr` varchar(200) DEFAULT NULL,
`remark` varchar(50) DEFAULT NULL,
`seat` varchar(50) DEFAULT NULL,
`seats` varchar(50) DEFAULT NULL,
`sendDateTime` varchar(255) DEFAULT NULL,
`vetechUser` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seatresult`
--
LOCK TABLES `seatresult` WRITE;
/*!40000 ALTER TABLE `seatresult` DISABLE KEYS */;
/*!40000 ALTER TABLE `seatresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sendemaillog`
--
DROP TABLE IF EXISTS `sendemaillog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sendemaillog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`airline` varchar(50) DEFAULT NULL,
`bootime` varchar(50) DEFAULT NULL,
`createtime` varchar(50) DEFAULT NULL,
`flag` varchar(50) DEFAULT NULL,
`flighttime` varchar(50) DEFAULT NULL,
`forid` int(11) DEFAULT NULL,
`info` varchar(1000) DEFAULT NULL,
`passenger` varchar(500) DEFAULT NULL,
`pnr` varchar(1000) DEFAULT NULL,
`ruleno` varchar(50) DEFAULT NULL,
`seat` varchar(50) DEFAULT NULL,
`seats` int(11) DEFAULT NULL,
`user` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sendemaillog`
--
LOCK TABLES `sendemaillog` WRITE;
/*!40000 ALTER TABLE `sendemaillog` DISABLE KEYS */;
/*!40000 ALTER TABLE `sendemaillog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sysconfig`
--
DROP TABLE IF EXISTS `sysconfig`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sysconfig` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`parameter1` varchar(500) DEFAULT NULL,
`parameter2` varchar(500) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sysconfig`
--
LOCK TABLES `sysconfig` WRITE;
/*!40000 ALTER TABLE `sysconfig` DISABLE KEYS */;
/*!40000 ALTER TABLE `sysconfig` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sysparam`
--
DROP TABLE IF EXISTS `sysparam`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sysparam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`descript` varchar(200) DEFAULT NULL,
`param` varchar(50) DEFAULT NULL,
`wfield` varchar(50) DEFAULT NULL,
`wtable` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sysparam`
--
LOCK TABLES `sysparam` WRITE;
/*!40000 ALTER TABLE `sysparam` DISABLE KEYS */;
/*!40000 ALTER TABLE `sysparam` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_tbl`
--
DROP TABLE IF EXISTS `user_tbl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_tbl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountExpired` bit(1) NOT NULL,
`accountLocked` bit(1) NOT NULL,
`createTime` datetime DEFAULT NULL,
`credentialsExpired` bit(1) NOT NULL,
`email` varchar(30) DEFAULT NULL,
`enabled` bit(1) NOT NULL,
`leaveJobDate` datetime DEFAULT NULL,
`loginDateTime` datetime DEFAULT NULL,
`mobile` varchar(20) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`password` varchar(80) NOT NULL,
`username` varchar(30) NOT NULL,
`version` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_tbl`
--
LOCK TABLES `user_tbl` WRITE;
/*!40000 ALTER TABLE `user_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_tbl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_tbl_role_tbl`
--
DROP TABLE IF EXISTS `user_tbl_role_tbl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_tbl_role_tbl` (
`user_tbl_id` int(11) NOT NULL,
`roles_id` int(11) NOT NULL,
PRIMARY KEY (`user_tbl_id`,`roles_id`),
KEY `FK3DAACBCAE69757E7` (`user_tbl_id`),
KEY `FK3DAACBCADEFD023F` (`roles_id`),
CONSTRAINT `FK3DAACBCADEFD023F` FOREIGN KEY (`roles_id`) REFERENCES `role_tbl` (`id`),
CONSTRAINT `FK3DAACBCAE69757E7` FOREIGN KEY (`user_tbl_id`) REFERENCES `user_tbl` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_tbl_role_tbl`
--
LOCK TABLES `user_tbl_role_tbl` WRITE;
/*!40000 ALTER TABLE `user_tbl_role_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_tbl_role_tbl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usertab`
--
DROP TABLE IF EXISTS `usertab`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usertab` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(50) DEFAULT NULL,
`groupid` varchar(50) DEFAULT NULL,
`memo` varchar(500) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
`user` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usertab`
--
LOCK TABLES `usertab` WRITE;
/*!40000 ALTER TABLE `usertab` DISABLE KEYS */;
/*!40000 ALTER TABLE `usertab` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vetechresult`
--
DROP TABLE IF EXISTS `vetechresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vetechresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`config` varchar(40) DEFAULT NULL,
`createDateTime` varchar(20) DEFAULT NULL,
`isRead` int(11) DEFAULT NULL,
`result` varchar(3000) DEFAULT NULL,
`sendCommand` varchar(3000) DEFAULT NULL,
`sendDate` varchar(50) DEFAULT NULL,
`sendTime` varchar(50) DEFAULT NULL,
`vetechUser` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vetechresult`
--
LOCK TABLES `vetechresult` WRITE;
/*!40000 ALTER TABLE `vetechresult` DISABLE KEYS */;
INSERT INTO `vetechresult` VALUES (1,'CTU236','2014-11-05 18:18:54',1,' 1.ZHANG/YUE HPGP4L \r 2. MU5101 Y SA15NOV SHAPEK DK1 0800 1020 76A S 0 R E T2T2 A 3.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 4.BY OPT NKGW 2014/11/05 1809A \r 5.TL/2300/05NOV/HKG147 \r 6.SSR ADTK 1E BY CTU05NOV14/2013 OR CXL CA ALL SEGS\r 7.OSI YY CTCT15958103269 \r 8.RMK TJ AUTH BJS140 \r 9.RMK TJ AUTH CTU165 \r10.RMK CA/MB7MDL\r11.CTU236 \r','SS:MU5101/Y/15NOV/SHAPEK/1/0800 1020','2014-11-05','18:14:11','NKGW'),(2,'CTU236','2014-11-05 18:18:54',1,' CA1313 A SA08NOV PEKSZX HK1 1130 1440 \rHPGQ7G - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SSR FOID YY HK/NI440301198706265424','2014-11-05','18:13:41','NKGW'),(3,'CTU236','2014-11-05 18:18:54',1,'HPGP4L -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r CA 912 D FR07NOV ARNPEK DK2 1820 0940+1 \r CA1313 A SA08NOV PEKSZX DK2 1130 1440 \r EK 305 Y TU10MAR PVGDXB HK2 0615 1225 \r EK 203 Y WE11MAR DXBJFK HK2 0250 0825 \r EK 305 Y TH12MAR PVGDXB HK2 0615 1225 \r EK 203 Y FR13MAR DXBJFK HK2 0250 0825 \r EK 305 Y SA14MAR PVGDXB HK2 0615 1225 \r EK 203 Y SU15MAR DXBJFK HK2 0250 0825 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:CA912/D/07NOV/ARNPEK/2/1820 0940+1\rSS:CA1313/A/08NOV/PEKSZX/2/1130 1440','2014-11-05','18:13:05','NKGW'),(4,'CTU236','2014-11-05 18:18:54',1,' SIMULTANEOUS MODIFICATION - REENTER MODIFICATIONS \r','SS:CA912/D/07NOV/ARNPEK/2/1820 0940+1\rSS:CA1313/A/08NOV/PEKSZX/2/1130 1440','2014-11-05','18:12:53','NKGW'),(5,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 5. EK305 Y2 TH12MAR PVGDXB DK2 0615 1225 SEAME \r 6. EK203 Y2 FR13MAR DXBJFK DK2 0250 0825 SEAME \r 7. EK305 Y3 SA14MAR PVGDXB DK2 0615 1225 SEAME \r 8. EK203 Y3 SU15MAR DXBJFK DK2 0250 0825 SEAME \r 9.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r10.BY OPT NKGW 2014/11/05 1809A \r11.TL/2300/05NOV/HKG147 +','SS EK305/Y/14MAR/PVGDXB/2/0615 1225\rSS EK203/Y/15MAR/DXBJFK/2/0250 0825','2014-11-05','18:12:28','NKGW'),(6,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 5. EK305 Y2 TH12MAR PVGDXB DK2 0615 1225 SEAME \r 6. EK203 Y2 FR13MAR DXBJFK DK2 0250 0825 SEAME \r 7.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 8.BY OPT NKGW 2014/11/05 1809A \r 9.TL/2300/05NOV/HKG147 \r10.SSR ADTK 1E BY CTU05NOV14/1809 OR CXL CA ALL SEGS\r11.SSR ADTK 1E BY CTU07NOV14/1808 OR CXL MU2501 Y17NOV +','SS EK305/Y/12MAR/PVGDXB/2/0615 1225\rSS EK203/Y/13MAR/DXBJFK/2/0250 0825','2014-11-05','18:12:18','NKGW'),(7,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 5.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 6.BY OPT NKGW 2014/11/05 1809A \r 7.TL/2300/05NOV/HKG147 \r 8.SSR ADTK 1E BY CTU05NOV14/1809 OR CXL CA ALL SEGS\r 9.SSR ADTK 1E BY CTU07NOV14/1808 OR CXL MU2501 Y17NOV \r10.SSR OTHS 1E EK 305 10MAR ADD ADVANCE PASSENGER INFORMATION IN SSR DOCS \r11.SSR OTHS 1E EK 203 11MAR ADD ADVANCE PASSENGER INFORMATION IN SSR DOCS +','SS EK305/Y/10MAR/PVGDXB/2/0615 1225\rSS EK203/Y/11MAR/DXBJFK/2/0250 0825','2014-11-05','18:12:09','NKGW'),(8,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK305 Y2 WE11MAR PVGDXB DK2 0615 1225 SEAME \r 5. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 6. EK305 Y3 TH12MAR PVGDXB DK2 0615 1225 SEAME \r 7. EK203 Y2 TH12MAR DXBJFK DK2 0250 0825 SEAME \r 8. EK203 Y3 FR13MAR DXBJFK DK2 0250 0825 SEAME \r 9.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r10.BY OPT NKGW 2014/11/05 1809A \r11.TL/2300/05NOV/HKG147 +','SS EK305/Y/12MAR/PVGDXB/2/0615 1225\rSS EK203/Y/13MAR/DXBJFK/2/0250 0825','2014-11-05','18:11:00','NKGW'),(9,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK305 Y2 WE11MAR PVGDXB DK2 0615 1225 SEAME \r 5. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 6. EK203 Y2 TH12MAR DXBJFK DK2 0250 0825 SEAME \r 7.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 8.BY OPT NKGW 2014/11/05 1809A \r 9.TL/2300/05NOV/HKG147 \r10.SSR ADTK 1E BY CTU05NOV14/1809 OR CXL CA ALL SEGS\r11.SSR ADTK 1E BY CTU07NOV14/1808 OR CXL MU2501 Y17NOV +','SS EK305/Y/11MAR/PVGDXB/2/0615 1225\rSS EK203/Y/12MAR/DXBJFK/2/0250 0825','2014-11-05','18:10:50','NKGW'),(10,'CTU236','2014-11-05 18:18:55',1,'MARRIED SEGMENT EXIST IN THE PNR\r 1.?? 2.ZHANG/YUE HPGP4L \r 3. EK305 Y1 TU10MAR PVGDXB DK2 0615 1225 SEAME \r 4. EK203 Y1 WE11MAR DXBJFK DK2 0250 0825 SEAME \r 5.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 6.BY OPT NKGW 2014/11/05 1809A \r 7.TL/2300/05NOV/HKG147 \r 8.SSR ADTK 1E BY CTU05NOV14/1809 OR CXL CA ALL SEGS\r 9.SSR ADTK 1E BY CTU07NOV14/1808 OR CXL MU2501 Y17NOV \r10.SSR OTHS 1E EK 305 10MAR ADD ADVANCE PASSENGER INFORMATION IN SSR DOCS \r11.SSR OTHS 1E EK 203 11MAR ADD ADVANCE PASSENGER INFORMATION IN SSR DOCS +','SS EK305/Y/10MAR/PVGDXB/2/0615 1225\rSS EK203/Y/11MAR/DXBJFK/2/0250 0825','2014-11-05','18:10:42','NKGW'),(11,'CTU236','2014-11-05 18:18:55',1,'HPGP4L -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r CA 912 D FR07NOV ARNPEK DK2 1820 0940+1 \r MU2501 Y MO17NOV WUHSHA HK2 0830 1000 \r MU5825 Y TU18NOV SHATSN HK2 0910 1120 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:CA912/D/07NOV/ARNPEK/2/1820 0940+1','2014-11-05','18:09:29','NKGW'),(12,'CTU236','2014-11-05 18:18:55',1,'SEATS \r','SS:CA912/D/07NOV/ARNPEK/1/1820 0940+1','2014-11-05','18:09:24','NKGW'),(13,'CTU236','2014-11-05 18:18:55',1,'HPGP4L -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r MU5101 Y SA15NOV SHAPEK DK2 0800 1020 \r MU2460 Y SU16NOV PEKWUH DK2 0805 1015 \r MU2501 Y MO17NOV WUHSHA DK2 0830 1000 \r MU5825 Y TU18NOV SHATSN DK2 0910 1120 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:MU5101/Y/15NOV/SHAPEK/2/0800 1020\rSS:MU2460/Y/16NOV/PEKWUH/2/0805 1015\rSS:MU2501/Y/17NOV/WUHSHA/2/0830 1000\rSS:MU5825/Y/18NOV/SHATSN/2/0910 1120\rNM 1??\r- 1ZHANG/YUE\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1809A\r@I^SS:MU5101/Y/15NOV/SHAPEK/2/0800 1020\rSS:MU2460/Y/16NOV/PEKWUH/2/0805 1015\rSS:MU2501/Y/17NOV/WUHSHA/2/0830 1000\rSS:MU5825/Y/18NOV/SHATSN/2/0910 1120\rNM 1??\r- 1ZHANG/YUE\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1809A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r@I','2014-11-05','18:09:00','NKGW'),(14,'CTU236','2014-11-05 18:18:55',1,'HPGNYF -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r CA1629 Y TH06NOV PEKCGQ DK1 1450 1645 \r ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:CA1629/Y/06NOV/PEKCGQ/1/1450 1645\rNM 1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070\rCT BY OPT XIAOPI1 2014/11/05 1808A\r\\I^SS:CA1629/Y/06NOV/PEKCGQ/1/1450 1645\rNM 1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070\rCT BY OPT XIAOPI1 2014/11/05 1808A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r\\I','2014-11-05','18:08:16','XIAOPI1'),(15,'CTU236','2014-11-05 18:18:55',1,' CA1398 A MO10NOV SZXPEK DW1 1915 2225 \rHPGNRT -EOT SUCCESSFUL, BUT ASR UNUSED FOR 1 OR MORE SEGMENTS \r *** ??????HC, ?? HC:HELP *** \r','SS:CA1398/A/10NOV/SZXPEK/LL1/1915 2225\rNM 1???\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1807A\r@I^SS:CA1398/A/10NOV/SZXPEK/LL1/1915 2225\rNM 1???\rTKTL2300/./HKG147\rOSI YY CTCT15958103269\rCT BY OPT NKGW 2014/11/05 1807A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r@I','2014-11-05','18:07:28','NKGW'),(16,'CTU236','2014-11-05 18:18:56',1,'CZ 3288 Y 05NOV PEKKWL NN2 UNABLE \rUNABLE TO SELL.PLEASE CHECK THE AVAILABILITY WITH \"AV\" AGAIN\r','SS:CZ3288/Y/05NOV/PEKKWL/2/2115 0010+1\rNM 1??\r- 1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070\rCT BY OPT XIAOPI1 2014/11/05 1806A\r\\I^SS:CZ3288/Y/05NOV/PEKKWL/2/2115 0010+1\rNM 1??\r- 1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070\rCT BY OPT XIAOPI1 2014/11/05 1806A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r\\I','2014-11-05','18:06:16','XIAOPI1'),(17,'CTU236','2014-11-05 18:18:56',1,'SEATS \r','SS:CZ3288/Y/05NOV/PEKKWL/2/2115 0010+1\rNM1??1??\rTKTL/2330/./PEK535\rOSI YY CTCT13164295070','2014-11-05','18:06:11','XIAOPI1'),(18,'CTU236','2014-11-05 18:18:56',1,' CA4344 V SA08NOV SZXCKG HK2 1050 1255 V1 \rJVD71M - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SSR FOID YY HK/NI422422197906206518/P1\rSSR FOID YY HK/NI440802198106130036/P2','2014-11-05','17:59:06','TFPWS'),(19,'CTU236','2014-11-05 18:21:58',1,' CA4344 V SA08NOV SZXCKG DK8 1050 1255 V1 \rHPGQNG - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:CA4344/V/08NOV/SZXCKG/8/1050 1255\rNM 1???\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1814A\r@^SS:CA4344/V/08NOV/SZXCKG/8/1050 1255\rNM 1???\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\r- 1??\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1814A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r@','2014-11-05','18:14:57','TFPWS'),(20,'CTU236','2014-11-05 18:21:58',1,'SEATS \r','SS:CA4344/V/08NOV/SZXCKG/8/1050 1255\rNM1???1???1??1???1??1???1??1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609','2014-11-05','18:14:52','TFPWS'),(21,'CTU236','2014-11-05 18:21:58',1,' 1.ZHANG/YUE HPGP4L \r 2. MU5101 Y SA15NOV SHAPEK DK1 0800 1020 76A S 0 R E T2T2 A 3. HU7607 X TU18NOV PEKSHA DK1 0735 0955 333 B 0 R E T1T2 \r 4.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 5.BY OPT NKGW 2014/11/05 1809A \r 6.TL/2300/05NOV/HKG147 \r 7.SSR ADTK 1E BY CTU05NOV14/2013 OR CXL CA ALL SEGS\r 8.OSI YY CTCT15958103269 \r 9.RMK TJ AUTH BJS140 \r10.RMK TJ AUTH CTU165 \r11.RMK CA/MB7MDL +','SS:HU7607/X/18NOV/PEKSHA/1/0735 0955','2014-11-05','18:14:17','NKGW'),(22,'CTU236','2014-11-05 18:21:59',1,' CA4344 V SA08NOV SZXCKG DK2 1050 1255 V1 \rJVD71M - ????????????, ???PNR \r *** ??????HC, ?? HC:HELP *** \r','SS:CA4344/V/08NOV/SZXCKG/2/1050 1255\rNM 1???\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1758A\r@^SS:CA4344/V/08NOV/SZXCKG/2/1050 1255\rNM 1???\r- 1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609\rCT BY OPT TFPWS 2014/11/05 1758A\rRMK TJ AUTH BJS140\rRMK TJ AUTH CTU165\r@','2014-11-05','17:58:23','TFPWS'),(23,'CTU236','2014-11-05 18:21:59',1,'SEATS \r','SS:CA4344/V/08NOV/SZXCKG/2/1050 1255\rNM1???1???\rTKTL/1200/./BJS140\rOSI CA CTCT13220256609','2014-11-05','17:58:19','TFPWS'),(24,'CTU236','2014-11-05 18:48:15',1,' 1.ZHANG/YUE HM890S \r 2. MU5101 Y SA15NOV SHAPEK DK1 0800 1020 76A S 0 R E T2T2 A 3. HU7607 X SU16NOV PEKSHA DK1 0735 0955 333 B 0 R E T1T2 \r 4.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 5.BY OPT NKGW 2014/11/05 1835A \r 6.TL/2300/05NOV/HKG147 \r 7.SSR ADTK 1E BY CTU05NOV14/2036 OR CXL CA ALL SEGS\r 8.SSR ADTK 1E BY CTU07NOV14/1837 OR CXL MU2501 Y17NOV \r 9.OSI YY CTCT15958103269 \r10.RMK TJ AUTH BJS140 \r11.RMK TJ AUTH CTU165 +','SS:HU7607/X/16NOV/PEKSHA/1/0735 0955','2014-11-05','18:39:07','NKGW'),(25,'CTU236','2014-11-05 18:48:15',1,' 1.ZHANG/YUE HM890S \r 2. MU5101 Y SA15NOV SHAPEK DK1 0800 1020 76A S 0 R E T2T2 A 3.CTU/T CTU/T02887777736/CHENG DU CHUN GUANG HANG KONG PIAO WU DAI LI FU WU\r YOU XIAN GON ABCDEFG \r 4.BY OPT NKGW 2014/11/05 1835A \r 5.TL/2300/05NOV/HKG147 \r 6.SSR ADTK 1E BY CTU05NOV14/2036 OR CXL CA ALL SEGS\r 7.SSR ADTK 1E BY CTU07NOV14/1837 OR CXL MU2501 Y17NOV \r 8.OSI YY CTCT15958103269 \r 9.RMK TJ AUTH BJS140 \r10.RMK TJ AUTH CTU165 \r11.RMK CA/NBWSGG +','SS:MU5101/Y/15NOV/SHAPEK/1/0800 1020','2014-11-05','18:39:00','NKGW');
/*!40000 ALTER TABLE `vetechresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vetechuser`
--
DROP TABLE IF EXISTS `vetechuser`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vetechuser` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`createDateTime` varchar(20) DEFAULT NULL,
`enabled` varchar(4) DEFAULT NULL,
`endDate` varchar(20) DEFAULT NULL,
`level` varchar(20) DEFAULT NULL,
`modifyDateTime` varchar(20) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`pidBh` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pidBh` (`pidBh`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vetechuser`
--
LOCK TABLES `vetechuser` WRITE;
/*!40000 ALTER TABLE `vetechuser` DISABLE KEYS */;
INSERT INTO `vetechuser` VALUES (1,'2014-11-05 18:18:54','1','2014-11-08','??1','2014-11-05 18:21:58','???','cxyh269'),(2,'2014-11-05 18:18:54','1','2014-11-1','??1','2014-11-05 18:21:58','??? ','gaoxiongxian'),(3,'2014-11-05 18:18:54','0','2014-11-10','??1','2014-11-05 18:21:58','??','CTU208'),(4,'2014-11-05 18:18:54','1','2014-11-11','??1','2014-11-05 18:21:58','???','cxyh236'),(5,'2014-11-05 18:18:54','0','2014-11-11','??1','2014-11-05 18:21:59','???','cxyh266'),(6,'2014-11-05 18:18:54','1','2014-11-11','??1','2014-11-05 18:21:59','???','cxyh267'),(7,'2014-11-05 18:18:54','1','2014-11-11','??1','2014-11-05 18:21:59','???','hs59'),(8,'2014-11-05 18:18:55','0','2014-11-11','??1','2014-11-05 18:21:59','liyan','liyan'),(9,'2014-11-05 18:18:55','1','2014-11-11','??1','2014-11-05 18:21:59','yangbing1','yangbing1'),(10,'2014-11-05 18:18:55','1','2014-11-15','??1','2014-11-05 18:21:59','???','ZHEXIANGAIR'),(11,'2014-11-05 18:18:55','1','2014-11-15','??1','2014-11-05 18:21:59','zhou1','zhou1'),(12,'2014-11-05 18:18:55','0','2014-11-15','??1','2014-11-05 18:21:59','zhou11','zhou11'),(13,'2014-11-05 18:18:55','0','2014-11-18','??1','2014-11-05 18:21:59','SGC ??','SGC'),(14,'2014-11-05 18:18:55','0','2014-11-18','??1','2014-11-05 18:21:59','??? ','shunda'),(15,'2014-11-05 18:18:55','0','2014-11-18','??1','2014-11-05 18:21:59','???','cxyh270'),(16,'2014-11-05 18:18:55','0','2014-11-18','??1','2014-11-05 18:21:59','???','cxyh271'),(17,'2014-11-05 18:18:55','1','2014-11-18','??1','2014-11-05 18:21:59','???','cxyh272'),(18,'2014-11-05 18:18:55','0','2014-11-18','??1','2014-11-05 18:21:59','???','cxyh281'),(19,'2014-11-05 18:18:55','0','2014-11-19','??1','2014-11-05 18:21:59','ykh1046 ?????','ykh1046'),(20,'2014-11-05 18:18:55','1','2014-11-20','??1','2014-11-05 18:21:59','???','cxyh233'),(21,'2014-11-05 18:18:55','0','2014-11-20','??1','2014-11-05 18:21:59','??','PSWTKL3'),(22,'2014-11-05 18:18:55','1','2014-11-20','??1','2014-11-05 18:21:59','??','PSWTKL4'),(23,'2014-11-05 18:18:55','1','2014-11-20','??1','2014-11-05 18:21:59','liding ?????','liding'),(24,'2014-11-05 18:18:55','0','2014-11-21','??1','2014-11-05 18:21:59','??','TFPWS'),(25,'2014-11-05 18:18:55','0','2014-11-21','??1','2014-11-05 18:21:59','??? ','BNJY001'),(26,'2014-11-05 18:18:55','1','2014-11-22','??1','2014-11-05 18:21:59','cxyh193 ?????','cxyh193'),(27,'2014-11-05 18:18:55','0','2014-11-24','??1','2014-11-05 18:21:59','??','dcan05'),(28,'2014-11-05 18:18:55','1','2014-11-25','??1','2014-11-05 18:21:59','???','cxyh265'),(29,'2014-11-05 18:18:55','0','2014-11-27','??1','2014-11-05 18:22:00','zxin1','zxin1'),(30,'2014-11-05 18:18:55','0','2014-11-29','??1','2014-11-05 18:22:00','??','zyax'),(31,'2014-11-05 18:18:56','0','2014-11-30','??1','2014-11-05 18:22:00','ykh1006 A.????','ykh1006'),(32,'2014-11-05 18:18:56','0','2014-11-5','??1','2014-11-05 18:22:00','??? ','lum001'),(33,'2014-11-05 18:18:56','0','2014-11-6','??1','2014-11-05 18:22:00','??? ','CAN668'),(34,'2014-11-05 18:18:56','0','2014-11-6','??1','2014-11-05 18:22:00','?? ','ctu101'),(35,'2014-11-05 18:22:00','1','2014-12-01','??1','2014-11-05 18:22:00','???','cxyh400'),(36,'2014-11-05 18:22:00','0','2014-12-02','??1','2014-11-05 18:22:00','BJS002 ??','BJS002'),(37,'2014-11-05 18:22:00','0','2014-12-03','??1','2014-11-05 18:22:00','baikexier ????','baikexier'),(38,'2014-11-05 18:22:00','1','2014-12-03','??1','2014-11-05 18:22:00','???','CXYH288'),(39,'2014-11-05 18:22:00','1','2014-12-03','??1','2014-11-05 18:22:00','???','xi xing'),(40,'2014-11-05 18:22:00','0','2014-12-04','??1','2014-11-05 18:22:00','???','CXYH289'),(41,'2014-11-05 18:22:00','0','2014-12-04','??1','2014-11-05 18:22:00','???','CXYH290'),(42,'2014-11-05 18:22:00','1','2014-12-05','??1','2014-11-05 18:22:00','???','CXYH292'),(43,'2014-11-05 18:22:00','1','2014-12-06','??1','2014-11-05 18:22:00','???','CXYH291'),(44,'2014-11-05 18:22:00','0','2014-12-06','??1','2014-11-05 18:22:00','??? ','cxyh302'),(45,'2014-11-05 18:22:00','1','2014-12-1','??1','2014-11-05 18:22:00','??? ','xtd001'),(46,'2014-11-05 18:22:00','0','2014-12-10','??1','2014-11-05 18:22:00','szyh002 x???','szyh002'),(47,'2014-11-05 18:22:00','0','2014-12-10','??1','2014-11-05 18:22:00','?? ','liuli'),(48,'2014-11-05 18:22:00','1','2014-12-11','??1','2014-11-05 18:22:00','CXYH401','CXYH401'),(49,'2014-11-05 18:22:00','1','2014-12-11','??1','2014-11-05 18:22:00','??','PSWTKL03');
/*!40000 ALTER TABLE `vetechuser` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2014-11-05 18:55:20
浙公网安备 33010602011771号