drop database pushmarketing;
create database pushmarketing;
use pushmarketing;
--
-- Table structure for table `Admin`
--
DROP TABLE IF EXISTS `Admin`;
CREATE TABLE `Admin` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`department` varchar(255) DEFAULT NULL,
`email` varchar(255) NOT NULL,
`isAccountEnabled` bit(1) NOT NULL,
`isAccountExpired` bit(1) NOT NULL,
`isAccountLocked` bit(1) NOT NULL,
`isCredentialsExpired` bit(1) NOT NULL,
`lockedDate` datetime DEFAULT NULL,
`loginDate` datetime DEFAULT NULL,
`loginFailureCount` int(11) NOT NULL,
`loginIp` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Admin`
--
LOCK TABLES `Admin` WRITE;
INSERT INTO `Admin` VALUES ('402881862bec2a21012bec2bd8de0003','2010-10-10 00:00:00','2012-08-15 10:31:46','技术部','pushmaster@lenovo.com','','\0','\0','\0',NULL,'2012-08-15 10:31:46',0,'192.168.2.155','管理员','124bd1296bec0d9d93c7b52a71ad8d5b','admin'),('8ae4162938eff5760138f002a38e0003','2012-08-04 13:01:41','2012-08-04 16:55:59','','yinzj@lenovo.com','','\0','\0','\0',NULL,'2012-08-04 16:55:59',0,'127.0.0.1','','e10adc3949ba59abbe56e057f20f883e','pushtongji'),('8ae4162938eff5760138f0276b400009','2012-08-04 13:41:51','2012-08-05 17:13:17','','yinzj@lenovo.com','','\0','\0','\0',NULL,'2012-08-05 17:13:17',0,'127.0.0.1','','e10adc3949ba59abbe56e057f20f883e','pushpush'),('8ae4162938eff5760138f0357735000a','2012-08-04 13:57:12','2012-08-14 12:16:09','','yinzj@lenovo.com','','\0','\0','\0',NULL,'2012-08-14 12:16:09',0,'127.0.0.1','','e10adc3949ba59abbe56e057f20f883e','pushadmin'),('8ae4162938f0965d0138f09b1a2b0002','2012-08-04 15:48:12','2012-08-04 16:06:21','','lestore@lenovo.com','','\0','\0','\0',NULL,'2012-08-04 16:06:21',0,'127.0.0.1','','e10adc3949ba59abbe56e057f20f883e','lestore');
UNLOCK TABLES;
DROP TABLE IF EXISTS `Role`;
CREATE TABLE `Role` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`description` text,
`isSystem` bit(1) NOT NULL,
`name` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `value` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Role`
--
LOCK TABLES `Role` WRITE;
INSERT INTO `Role` VALUES ('402881862bec2a21012bec2b70510002','2010-10-27 13:31:31','2010-10-27 13:31:31','拥有最高后台管理权限','','超级管理员','ROLE_ADMIN'),('8ae4162938eff5760138f000c7520002','2012-08-04 12:59:39','2012-08-04 13:34:34','拥有Push统计信息模块查看权限','\0','Push统计信息管理员','ROLE_statistics'),('8ae4162938eff5760138f00c9cc60006','2012-08-04 13:12:34','2012-08-04 13:35:10','拥有Push多维度推送模块操作权限','\0','Push多维度推送操作员','ROLE_pushmuitidimenadmin'),('8ae4162938eff5760138f0234b6c0008','2012-08-04 13:37:21','2012-08-04 13:38:12','拥有Push统计信息、多维度推送模块权限','\0','Push总管理员','ROLE_pushadmin'),('8ae4162938f0965d0138f099db790001','2012-08-04 15:46:51','2012-08-04 15:47:37','拥有为乐商店服务push消息权限','\0','乐商店专用','ROLE_lestoreoperator');
UNLOCK TABLES;
--
-- Table structure for table `Admin_Role`
--
DROP TABLE IF EXISTS `Admin_Role`;
CREATE TABLE `Admin_Role` (
`adminSet_id` varchar(32) NOT NULL,
`roleSet_id` varchar(32) NOT NULL,
PRIMARY KEY (`adminSet_id`,`roleSet_id`),
KEY `FK9FC63FA6BED5452D` (`adminSet_id`),
KEY `FK9FC63FA617BBCBED` (`roleSet_id`),
KEY `FK9FC63FA64A8C1749` (`adminSet_id`),
KEY `FK9FC63FA677144651` (`roleSet_id`),
CONSTRAINT `FK9FC63FA677144651` FOREIGN KEY (`roleSet_id`) REFERENCES `Role` (`id`),
CONSTRAINT `FK9FC63FA64A8C1749` FOREIGN KEY (`adminSet_id`) REFERENCES `Admin` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Admin_Role`
--
LOCK TABLES `Admin_Role` WRITE;
INSERT INTO `Admin_Role` VALUES ('402881862bec2a21012bec2bd8de0003','402881862bec2a21012bec2b70510002'),('8ae4162938eff5760138f002a38e0003','8ae4162938eff5760138f000c7520002'),('8ae4162938eff5760138f0276b400009','8ae4162938eff5760138f00c9cc60006'),('8ae4162938eff5760138f0357735000a','8ae4162938eff5760138f0234b6c0008'),('8ae4162938f0965d0138f09b1a2b0002','8ae4162938f0965d0138f099db790001');
UNLOCK TABLES;
--
-- Table structure for table `Area`
--
DROP TABLE IF EXISTS `Area`;
CREATE TABLE `Area` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`name` varchar(255) NOT NULL,
`path` text,
`parent_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`parent_id`),
KEY `FK1F44ADB4D9BB21` (`parent_id`),
KEY `FK1F44AD643BB52A` (`parent_id`),
CONSTRAINT `FK1F44AD643BB52A` FOREIGN KEY (`parent_id`) REFERENCES `Area` (`id`),
CONSTRAINT `FK1F44ADE3C3E8B1` FOREIGN KEY (`parent_id`) REFERENCES `Area` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Area`
--
LOCK TABLES `Area` WRITE;
INSERT INTO `Area` VALUES ('402881882ba8753a012ba8bf474d001c','2010-10-14 11:18:49','2010-10-14 11:18:49','北京','402881882ba8753a012ba8bf474d001c',NULL),('402881882ba8753a012ba8bfacfd001d','2010-10-14 11:19:15','2010-10-14 11:19:15','东城区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8bfacfd001d','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8bff6f6001e','2010-10-14 11:19:34','2010-10-14 11:19:34','西城区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8bff6f6001e','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c02f9a001f','2010-10-14 11:19:48','2010-10-14 11:19:48','崇文区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c02f9a001f','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c061970020','2010-10-14 11:20:01','2010-10-14 11:20:01','宣武区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c061970020','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c088690021','2010-10-14 11:20:11','2010-10-14 11:20:11','朝阳区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c088690021','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c0ade20022','2010-10-14 11:20:21','2010-10-14 11:20:21','丰台区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c0ade20022','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c0d34c0023','2010-10-14 11:20:30','2010-10-14 11:20:30','石景山区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c0d34c0023','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c0fb850024','2010-10-14 11:20:41','2010-10-14 11:20:41','海淀区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c0fb850024','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c121f90025','2010-10-14 11:20:50','2010-10-14 11:20:50','门头沟区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c121f90025','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c1463a0026','2010-10-14 11:21:00','2010-10-14 11:21:00','房山区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c1463a0026','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c16f8c0027','2010-10-14 11:21:10','2010-10-14 11:21:10','通州区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c16f8c0027','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c19cb70028','2010-10-14 11:21:22','2010-10-14 11:21:22','顺义区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c19cb70028','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c1bf720029','2010-10-14 11:21:31','2010-10-14 11:21:31','昌平区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c1bf720029','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c1dec1002a','2010-10-14 11:21:39','2010-10-14 11:21:39','大兴区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c1dec1002a','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c200e0002b','2010-10-14 11:21:48','2010-10-14 11:21:48','怀柔区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c200e0002b','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c2164c002c','2010-10-14 11:21:53','2010-10-14 11:21:53','平谷区','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c2164c002c','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c27285002d','2010-10-14 11:22:17','2010-10-14 11:22:17','密云县','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c27285002d','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c28be9002e','2010-10-14 11:22:23','2010-10-14 11:22:23','延庆县','402881882ba8753a012ba8bf474d001c,402881882ba8753a012ba8c28be9002e','402881882ba8753a012ba8bf474d001c'),('402881882ba8753a012ba8c389a2002f','2010-10-14 11:23:28','2010-10-14 11:23:28','天津','402881882ba8753a012ba8c389a2002f',NULL),('402881882ba8753a012ba8c3bcc80030','2010-10-14 11:23:41','2010-10-14 11:23:41','和平区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c3bcc80030','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c3e4460031','2010-10-14 11:23:51','2010-10-14 11:23:51','河东区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c3e4460031','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c409df0032','2010-10-14 11:24:01','2010-10-14 11:24:01','河西区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c409df0032','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c42e5e0033','2010-10-14 11:24:10','2010-10-14 11:24:10','南开区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c42e5e0033','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c454450034','2010-10-14 11:24:20','2010-10-14 11:24:20','河北区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c454450034','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c479040035','2010-10-14 11:24:29','2010-10-14 11:24:29','红桥区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c479040035','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c49db20036','2010-10-14 11:24:39','2010-10-14 11:24:39','塘沽区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c49db20036','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c4c2610037','2010-10-14 11:24:48','2010-10-14 11:24:48','汉沽区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c4c2610037','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c4e5790038','2010-10-14 11:24:57','2010-10-14 11:24:57','大港区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c4e5790038','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c50c890039','2010-10-14 11:25:07','2010-10-14 11:25:07','东丽区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c50c890039','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c53109003a','2010-10-14 11:25:16','2010-10-14 11:25:16','西青区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c53109003a','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c55838003b','2010-10-14 11:25:26','2010-10-14 11:25:26','津南区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c55838003b','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c57e00003c','2010-10-14 11:25:36','2010-10-14 11:25:36','北辰区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c57e00003c','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c5a2de003d','2010-10-14 11:25:46','2010-10-14 11:25:46','武清区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c5a2de003d','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c5c829003e','2010-10-14 11:25:55','2010-10-14 11:25:55','宝坻区','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c5c829003e','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c5eac4003f','2010-10-14 11:26:04','2010-10-14 11:26:04','宁河县','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c5eac4003f','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c60e980040','2010-10-14 11:26:13','2010-10-14 11:26:13','静海县','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c60e980040','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c626270041','2010-10-14 11:26:19','2010-10-14 11:26:19','蓟县','402881882ba8753a012ba8c389a2002f,402881882ba8753a012ba8c626270041','402881882ba8753a012ba8c389a2002f'),('402881882ba8753a012ba8c689d30042','2010-10-14 11:26:45','2010-10-14 11:26:45','河北省','402881882ba8753a012ba8c689d30042',NULL),('402881882ba8753a012ba8c6da830043','2010-10-14 11:27:05','2010-10-14 11:27:05','石家庄市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c6da830043','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c7122d0044','2010-10-14 11:27:20','2010-10-14 11:27:20','唐山市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c7122d0044','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c73d920045','2010-10-14 11:27:31','2010-10-14 11:27:31','秦皇岛市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c73d920045','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c7656d0046','2010-10-14 11:27:41','2010-10-14 11:27:41','邯郸市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c7656d0046','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c78fc90047','2010-10-14 11:27:52','2010-10-14 11:27:52','邢台市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c78fc90047','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c7bb5d0048','2010-10-14 11:28:03','2010-10-14 11:28:03','保定市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c7bb5d0048','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c7e50d0049','2010-10-14 11:28:14','2010-10-14 11:28:14','张家口市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c7e50d0049','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c80c4c004a','2010-10-14 11:28:24','2010-10-14 11:28:24','承德市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c80c4c004a','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c8404d004b','2010-10-14 11:28:37','2010-10-14 11:28:37','沧州市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c8404d004b','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c898fc004c','2010-10-14 11:29:00','2010-10-14 11:29:00','廊坊市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c898fc004c','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c8bc62004d','2010-10-14 11:29:09','2010-10-14 11:29:09','衡水市','402881882ba8753a012ba8c689d30042,402881882ba8753a012ba8c8bc62004d','402881882ba8753a012ba8c689d30042'),('402881882ba8753a012ba8c8f0b1004e','2010-10-14 11:29:22','2010-10-14 11:29:22','山西省','402881882ba8753a012ba8c8f0b1004e',NULL),('402881882ba8753a012ba8c93924004f','2010-10-14 11:29:41','2010-10-14 11:29:41','太原市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8c93924004f','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8c963fd0050','2010-10-14 11:29:52','2010-10-14 11:29:52','大同市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8c963fd0050','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8c98d3f0051','2010-10-14 11:30:02','2010-10-14 11:30:02','阳泉市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8c98d3f0051','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8c9b72d0052','2010-10-14 11:30:13','2010-10-14 11:30:13','长治市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8c9b72d0052','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8c9e15a0053','2010-10-14 11:30:24','2010-10-14 11:30:24','晋城市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8c9e15a0053','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8ca0e460054','2010-10-14 11:30:35','2010-10-14 11:30:35','朔州市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8ca0e460054','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8ca392f0055','2010-10-14 11:30:46','2010-10-14 11:30:46','晋中市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8ca392f0055','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8ca67240056','2010-10-14 11:30:58','2010-10-14 11:30:58','运城市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8ca67240056','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8ca91ed0057','2010-10-14 11:31:09','2010-10-14 11:31:09','忻州市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8ca91ed0057','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8cabae20058','2010-10-14 11:31:19','2010-10-14 11:31:19','临汾市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8cabae20058','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8cae26f0059','2010-10-14 11:31:30','2010-10-14 11:31:30','吕梁市','402881882ba8753a012ba8c8f0b1004e,402881882ba8753a012ba8cae26f0059','402881882ba8753a012ba8c8f0b1004e'),('402881882ba8753a012ba8cb1bbf005a','2010-10-14 11:31:44','2010-10-14 11:31:44','内蒙古自治区','402881882ba8753a012ba8cb1bbf005a',NULL),('402881882ba8753a012ba8cb58c8005b','2010-10-14 11:32:00','2010-10-14 11:32:00','呼和浩特市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cb58c8005b','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cb84c9005c','2010-10-14 11:32:11','2010-10-14 11:32:11','包头市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cb84c9005c','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cbb7a1005d','2010-10-14 11:32:24','2010-10-14 11:32:24','乌海市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cbb7a1005d','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cbdf3e005e','2010-10-14 11:32:34','2010-10-14 11:32:34','赤峰市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cbdf3e005e','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cc0ad2005f','2010-10-14 11:32:45','2010-10-14 11:32:45','通辽市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cc0ad2005f','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cc3a1f0060','2010-10-14 11:32:58','2010-10-14 11:32:58','鄂尔多斯市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cc3a1f0060','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cc62870061','2010-10-14 11:33:08','2010-10-14 11:33:08','呼伦贝尔市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cc62870061','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cc90ea0062','2010-10-14 11:33:20','2010-10-14 11:33:20','巴彦淖尔市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cc90ea0062','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8ccb71f0063','2010-10-14 11:33:30','2010-10-14 11:33:30','乌兰察布市','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8ccb71f0063','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cce2c30064','2010-10-14 11:33:41','2010-10-14 11:33:41','兴安盟','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cce2c30064','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cd105b0065','2010-10-14 11:33:52','2010-10-14 11:33:52','锡林郭勒盟','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cd105b0065','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cd35d50066','2010-10-14 11:34:02','2010-10-14 11:34:02','阿拉善盟','402881882ba8753a012ba8cb1bbf005a,402881882ba8753a012ba8cd35d50066','402881882ba8753a012ba8cb1bbf005a'),('402881882ba8753a012ba8cd6a230067','2010-10-14 11:34:15','2010-10-14 11:34:15','辽宁省','402881882ba8753a012ba8cd6a230067',NULL),('402881882ba8753a012ba8cde3890068','2010-10-14 11:34:46','2010-10-14 11:34:46','沈阳市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cde3890068','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8ce0ceb0069','2010-10-14 11:34:57','2010-10-14 11:34:57','大连市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8ce0ceb0069','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8ce32a3006a','2010-10-14 11:35:07','2010-10-14 11:35:07','鞍山市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8ce32a3006a','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8ce5b2a006b','2010-10-14 11:35:17','2010-10-14 11:35:17','抚顺市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8ce5b2a006b','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8ce7c10006c','2010-10-14 11:35:25','2010-10-14 11:35:25','本溪市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8ce7c10006c','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cea18a006d','2010-10-14 11:35:35','2010-10-14 11:35:35','丹东市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cea18a006d','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cec85c006e','2010-10-14 11:35:45','2010-10-14 11:35:45','锦州市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cec85c006e','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cef5b5006f','2010-10-14 11:35:57','2010-10-14 11:35:57','营口市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cef5b5006f','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cf1cc50070','2010-10-14 11:36:07','2010-10-14 11:36:07','阜新市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cf1cc50070','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cf427d0071','2010-10-14 11:36:16','2010-10-14 11:36:16','辽阳市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cf427d0071','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cf6ae50072','2010-10-14 11:36:27','2010-10-14 11:36:27','盘锦市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cf6ae50072','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cf90dc0073','2010-10-14 11:36:36','2010-10-14 11:36:36','铁岭市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cf90dc0073','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cfb6750074','2010-10-14 11:36:46','2010-10-14 11:36:46','朝阳市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cfb6750074','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8cfdb710075','2010-10-14 11:36:55','2010-10-14 11:36:55','葫芦岛市','402881882ba8753a012ba8cd6a230067,402881882ba8753a012ba8cfdb710075','402881882ba8753a012ba8cd6a230067'),('402881882ba8753a012ba8d010f90076','2010-10-14 11:37:09','2010-10-14 11:37:09','吉林省','402881882ba8753a012ba8d010f90076',NULL),('402881882ba8753a012ba8d03d870077','2010-10-14 11:37:21','2010-10-14 11:37:21','长春市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d03d870077','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d065c00078','2010-10-14 11:37:31','2010-10-14 11:37:31','吉林市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d065c00078','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d08acc0079','2010-10-14 11:37:40','2010-10-14 11:37:40','四平市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d08acc0079','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d0b046007a','2010-10-14 11:37:50','2010-10-14 11:37:50','辽源市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d0b046007a','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d0d7a4007b','2010-10-14 11:38:00','2010-10-14 11:38:00','通化市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d0d7a4007b','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d0fe95007c','2010-10-14 11:38:10','2010-10-14 11:38:10','白山市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d0fe95007c','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d120b3007d','2010-10-14 11:38:19','2010-10-14 11:38:19','松原市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d120b3007d','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d14d8f007e','2010-10-14 11:38:30','2010-10-14 11:38:30','白城市','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d14d8f007e','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d17a4d007f','2010-10-14 11:38:42','2010-10-14 11:38:42','延边朝鲜族自治州','402881882ba8753a012ba8d010f90076,402881882ba8753a012ba8d17a4d007f','402881882ba8753a012ba8d010f90076'),('402881882ba8753a012ba8d1b0310080','2010-10-14 11:38:55','2010-10-14 11:38:55','黑龙江省','402881882ba8753a012ba8d1b0310080',NULL),('402881882ba8753a012ba8d1e4320081','2010-10-14 11:39:09','2010-10-14 11:39:09','哈尔滨市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d1e4320081','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d212850082','2010-10-14 11:39:21','2010-10-14 11:39:21','齐齐哈尔市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d212850082','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d239090083','2010-10-14 11:39:30','2010-10-14 11:39:30','鸡西市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d239090083','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d264db0084','2010-10-14 11:39:42','2010-10-14 11:39:42','鹤岗市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d264db0084','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d28a360085','2010-10-14 11:39:51','2010-10-14 11:39:51','双鸭山市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d28a360085','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d2b2cd0086','2010-10-14 11:40:02','2010-10-14 11:40:02','大庆市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d2b2cd0086','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d2daa80087','2010-10-14 11:40:12','2010-10-14 11:40:12','伊春市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d2daa80087','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d300cd0088','2010-10-14 11:40:22','2010-10-14 11:40:22','佳木斯市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d300cd0088','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d327be0089','2010-10-14 11:40:32','2010-10-14 11:40:32','七台河市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d327be0089','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d34d47008a','2010-10-14 11:40:41','2010-10-14 11:40:41','牡丹江市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d34d47008a','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d372c1008b','2010-10-14 11:40:51','2010-10-14 11:40:51','黑河市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d372c1008b','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d398c8008c','2010-10-14 11:41:01','2010-10-14 11:41:01','绥化市','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d398c8008c','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d3c97c008d','2010-10-14 11:41:13','2010-10-14 11:41:13','大兴安岭地区','402881882ba8753a012ba8d1b0310080,402881882ba8753a012ba8d3c97c008d','402881882ba8753a012ba8d1b0310080'),('402881882ba8753a012ba8d3f4f1008e','2010-10-14 11:41:24','2010-10-14 11:41:24','上海市','402881882ba8753a012ba8d3f4f1008e',NULL),('402881882ba8753a012ba8d45968008f','2010-10-14 11:41:50','2010-10-14 11:41:50','黄浦区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d45968008f','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d47e550090','2010-10-14 11:41:59','2010-10-14 11:41:59','卢湾区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d47e550090','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d4a0f10091','2010-10-14 11:42:08','2010-10-14 11:42:08','徐汇区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d4a0f10091','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d4c63b0092','2010-10-14 11:42:18','2010-10-14 11:42:18','长宁区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d4c63b0092','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d4ee260093','2010-10-14 11:42:28','2010-10-14 11:42:28','静安区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d4ee260093','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d50f5a0094','2010-10-14 11:42:36','2010-10-14 11:42:36','普陀区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d50f5a0094','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d5366a0095','2010-10-14 11:42:46','2010-10-14 11:42:46','闸北区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d5366a0095','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d55b190096','2010-10-14 11:42:56','2010-10-14 11:42:56','虹口区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d55b190096','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d57b430097','2010-10-14 11:43:04','2010-10-14 11:43:04','杨浦区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d57b430097','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d59fb30098','2010-10-14 11:43:13','2010-10-14 11:43:13','闵行区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d59fb30098','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d5c54c0099','2010-10-14 11:43:23','2010-10-14 11:43:23','宝山区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d5c54c0099','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d5ea2a009a','2010-10-14 11:43:32','2010-10-14 11:43:32','嘉定区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d5ea2a009a','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d61a04009b','2010-10-14 11:43:45','2010-10-14 11:43:45','浦东新区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d61a04009b','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d6420e009c','2010-10-14 11:43:55','2010-10-14 11:43:55','金山区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d6420e009c','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d6bcdb009d','2010-10-14 11:44:26','2010-10-14 11:44:26','松江区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d6bcdb009d','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d6e330009e','2010-10-14 11:44:36','2010-10-14 11:44:36','青浦区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d6e330009e','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d70abd009f','2010-10-14 11:44:46','2010-10-14 11:44:46','南汇区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d70abd009f','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d72b2600a0','2010-10-14 11:44:55','2010-10-14 11:44:55','奉贤区','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d72b2600a0','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d745d200a1','2010-10-14 11:45:01','2010-10-14 11:45:01','崇明县','402881882ba8753a012ba8d3f4f1008e,402881882ba8753a012ba8d745d200a1','402881882ba8753a012ba8d3f4f1008e'),('402881882ba8753a012ba8d780a800a2','2010-10-14 11:45:16','2010-10-14 11:45:16','江苏省','402881882ba8753a012ba8d780a800a2',NULL),('402881882ba8753a012ba8d82d2500a3','2010-10-14 11:46:01','2010-10-14 11:46:01','南京市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d82d2500a3','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d8605a00a4','2010-10-14 11:46:14','2010-10-14 11:46:14','无锡市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d8605a00a4','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d88b1300a5','2010-10-14 11:46:25','2010-10-14 11:46:25','徐州市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d88b1300a5','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d8b1e500a6','2010-10-14 11:46:35','2010-10-14 11:46:35','常州市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d8b1e500a6','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d8e08600a7','2010-10-14 11:46:47','2010-10-14 11:46:47','苏州市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d8e08600a7','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d907b600a8','2010-10-14 11:46:57','2010-10-14 11:46:57','南通市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d907b600a8','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d9317500a9','2010-10-14 11:47:07','2010-10-14 11:47:07','连云港市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d9317500a9','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d956df00aa','2010-10-14 11:47:17','2010-10-14 11:47:17','淮安市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d956df00aa','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d97d6300ab','2010-10-14 11:47:27','2010-10-14 11:47:27','盐城市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d97d6300ab','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d9a2fc00ac','2010-10-14 11:47:36','2010-10-14 11:47:36','扬州市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d9a2fc00ac','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d9ca4a00ad','2010-10-14 11:47:46','2010-10-14 11:47:46','镇江市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d9ca4a00ad','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8d9eef900ae','2010-10-14 11:47:56','2010-10-14 11:47:56','泰州市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8d9eef900ae','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8da172200af','2010-10-14 11:48:06','2010-10-14 11:48:06','宿迁市','402881882ba8753a012ba8d780a800a2,402881882ba8753a012ba8da172200af','402881882ba8753a012ba8d780a800a2'),('402881882ba8753a012ba8da48e000b0','2010-10-14 11:48:19','2010-10-14 11:48:19','浙江省','402881882ba8753a012ba8da48e000b0',NULL),('402881882ba8753a012ba8da7d2f00b1','2010-10-14 11:48:32','2010-10-14 11:48:32','杭州市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8da7d2f00b1','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8daa35500b2','2010-10-14 11:48:42','2010-10-14 11:48:42','宁波市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8daa35500b2','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8dacb3000b3','2010-10-14 11:48:52','2010-10-14 11:48:52','温州市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8dacb3000b3','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8daf15500b4','2010-10-14 11:49:02','2010-10-14 11:49:02','嘉兴市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8daf15500b4','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8db14db00b5','2010-10-14 11:49:11','2010-10-14 11:49:11','湖州市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8db14db00b5','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8db3e9b00b6','2010-10-14 11:49:22','2010-10-14 11:49:22','绍兴市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8db3e9b00b6','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8db6a8d00b7','2010-10-14 11:49:33','2010-10-14 11:49:33','金华市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8db6a8d00b7','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8db978800b8','2010-10-14 11:49:44','2010-10-14 11:49:44','衢州市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8db978800b8','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8dbcc7300b9','2010-10-14 11:49:58','2010-10-14 11:49:58','舟山市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8dbcc7300b9','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8dbf33500ba','2010-10-14 11:50:08','2010-10-14 11:50:08','台州市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8dbf33500ba','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8dc1c9700bb','2010-10-14 11:50:19','2010-10-14 11:50:19','丽水市','402881882ba8753a012ba8da48e000b0,402881882ba8753a012ba8dc1c9700bb','402881882ba8753a012ba8da48e000b0'),('402881882ba8753a012ba8dc469500bc','2010-10-14 11:50:29','2010-10-14 11:50:29','安徽省','402881882ba8753a012ba8dc469500bc',NULL),('402881882ba8753a012ba8dc8c3900bd','2010-10-14 11:50:47','2010-10-14 11:50:47','合肥市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dc8c3900bd','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dcb25f00be','2010-10-14 11:50:57','2010-10-14 11:50:57','芜湖市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dcb25f00be','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dd667c00bf','2010-10-14 11:51:43','2010-10-14 11:51:43','蚌埠市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dd667c00bf','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dd925e00c0','2010-10-14 11:51:54','2010-10-14 11:51:54','淮南市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dd925e00c0','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8ddb58600c1','2010-10-14 11:52:03','2010-10-14 11:52:03','马鞍山市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8ddb58600c1','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8ddd98900c2','2010-10-14 11:52:12','2010-10-14 11:52:12','淮北市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8ddd98900c2','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8ddfa9e00c3','2010-10-14 11:52:21','2010-10-14 11:52:21','铜陵市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8ddfa9e00c3','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8de1e8100c4','2010-10-14 11:52:30','2010-10-14 11:52:30','安庆市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8de1e8100c4','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8de4dde00c5','2010-10-14 11:52:42','2010-10-14 11:52:42','黄山市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8de4dde00c5','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8de730a00c6','2010-10-14 11:52:52','2010-10-14 11:52:52','滁州市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8de730a00c6','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8de9ad500c7','2010-10-14 11:53:02','2010-10-14 11:53:02','阜阳市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8de9ad500c7','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8df216b00c8','2010-10-14 11:53:36','2010-10-14 11:53:36','宿州市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8df216b00c8','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8df585900c9','2010-10-14 11:53:50','2010-10-14 11:53:50','巢湖市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8df585900c9','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8df7d5600ca','2010-10-14 11:54:00','2010-10-14 11:54:00','六安市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8df7d5600ca','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dfa8cb00cb','2010-10-14 11:54:11','2010-10-14 11:54:11','亳州市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dfa8cb00cb','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dfcf1f00cc','2010-10-14 11:54:21','2010-10-14 11:54:21','池州市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dfcf1f00cc','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8dff4f700cd','2010-10-14 11:54:31','2010-10-14 11:54:31','宣城市','402881882ba8753a012ba8dc469500bc,402881882ba8753a012ba8dff4f700cd','402881882ba8753a012ba8dc469500bc'),('402881882ba8753a012ba8e0243500ce','2010-10-14 11:54:43','2010-10-14 11:54:43','福建省','402881882ba8753a012ba8e0243500ce',NULL),('402881882ba8753a012ba8e1b06200cf','2010-10-14 11:56:24','2010-10-14 11:56:24','福州市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e1b06200cf','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e1f17300d0','2010-10-14 11:56:41','2010-10-14 11:56:41','厦门市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e1f17300d0','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e21c5b00d1','2010-10-14 11:56:52','2010-10-14 11:56:52','莆田市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e21c5b00d1','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e2480f00d2','2010-10-14 11:57:03','2010-10-14 11:57:03','三明市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e2480f00d2','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e26c9e00d3','2010-10-14 11:57:12','2010-10-14 11:57:12','泉州市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e26c9e00d3','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e29b4f00d4','2010-10-14 11:57:24','2010-10-14 11:57:24','漳州市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e29b4f00d4','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e2c9b200d5','2010-10-14 11:57:36','2010-10-14 11:57:36','南平市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e2c9b200d5','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e2f48b00d6','2010-10-14 11:57:47','2010-10-14 11:57:47','龙岩市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e2f48b00d6','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e31be900d7','2010-10-14 11:57:57','2010-10-14 11:57:57','宁德市','402881882ba8753a012ba8e0243500ce,402881882ba8753a012ba8e31be900d7','402881882ba8753a012ba8e0243500ce'),('402881882ba8753a012ba8e362b600d8','2010-10-14 11:58:15','2010-10-14 11:58:15','江西省','402881882ba8753a012ba8e362b600d8',NULL),('402881882ba8753a012ba8e3b49f00d9','2010-10-14 11:58:36','2010-10-14 11:58:36','南昌市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e3b49f00d9','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e433f000da','2010-10-14 11:59:09','2010-10-14 11:59:09','景德镇市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e433f000da','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e45ca600db','2010-10-14 11:59:19','2010-10-14 11:59:19','萍乡市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e45ca600db','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e4808a00dc','2010-10-14 11:59:28','2010-10-14 11:59:28','九江市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e4808a00dc','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e4a74c00dd','2010-10-14 11:59:38','2010-10-14 11:59:38','新余市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e4a74c00dd','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e4cdb000de','2010-10-14 11:59:48','2010-10-14 11:59:48','鹰潭市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e4cdb000de','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e4ef4200df','2010-10-14 11:59:57','2010-10-14 11:59:57','赣州市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e4ef4200df','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e53fb300e0','2010-10-14 12:00:17','2010-10-14 12:00:17','吉安市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e53fb300e0','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e56d0d00e1','2010-10-14 12:00:29','2010-10-14 12:00:29','宜春市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e56d0d00e1','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e5921900e2','2010-10-14 12:00:38','2010-10-14 12:00:38','抚州市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e5921900e2','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e5c22200e3','2010-10-14 12:00:51','2010-10-14 12:00:51','上饶市','402881882ba8753a012ba8e362b600d8,402881882ba8753a012ba8e5c22200e3','402881882ba8753a012ba8e362b600d8'),('402881882ba8753a012ba8e5f7d800e4','2010-10-14 12:01:04','2010-10-14 12:01:04','山东省','402881882ba8753a012ba8e5f7d800e4',NULL),('402881882ba8753a012ba928e9c800e5','2010-10-14 13:14:12','2010-10-14 13:14:12','济南市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba928e9c800e5','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929137800e6','2010-10-14 13:14:22','2010-10-14 13:14:22','青岛市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929137800e6','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929374c00e7','2010-10-14 13:14:32','2010-10-14 13:14:32','淄博市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929374c00e7','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba9295d4300e8','2010-10-14 13:14:41','2010-10-14 13:14:41','枣庄市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba9295d4300e8','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929884b00e9','2010-10-14 13:14:52','2010-10-14 13:14:52','东营市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929884b00e9','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929ac2e00ea','2010-10-14 13:15:02','2010-10-14 13:15:02','烟台市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929ac2e00ea','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929cfe300eb','2010-10-14 13:15:11','2010-10-14 13:15:11','潍坊市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929cfe300eb','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba929f68500ec','2010-10-14 13:15:21','2010-10-14 13:15:21','济宁市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba929f68500ec','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92a1a4a00ed','2010-10-14 13:15:30','2010-10-14 13:15:30','泰安市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92a1a4a00ed','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92a5f0300ee','2010-10-14 13:15:47','2010-10-14 13:15:47','威海市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92a5f0300ee','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92a825a00ef','2010-10-14 13:15:56','2010-10-14 13:15:56','日照市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92a825a00ef','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92aa99900f0','2010-10-14 13:16:06','2010-10-14 13:16:06','莱芜市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92aa99900f0','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92acd4e00f1','2010-10-14 13:16:16','2010-10-14 13:16:16','临沂市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92acd4e00f1','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92af27900f2','2010-10-14 13:16:25','2010-10-14 13:16:25','德州市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92af27900f2','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92b154400f3','2010-10-14 13:16:34','2010-10-14 13:16:34','聊城市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92b154400f3','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92b3a6000f4','2010-10-14 13:16:44','2010-10-14 13:16:44','滨州市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92b3a6000f4','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92b688400f5','2010-10-14 13:16:55','2010-10-14 13:16:55','荷泽市','402881882ba8753a012ba8e5f7d800e4,402881882ba8753a012ba92b688400f5','402881882ba8753a012ba8e5f7d800e4'),('402881882ba8753a012ba92ba9c300f6','2010-10-14 13:17:12','2010-10-14 13:17:12','河南省','402881882ba8753a012ba92ba9c300f6',NULL),('402881882ba8753a012ba92bd8a300f7','2010-10-14 13:17:24','2010-10-14 13:17:24','郑州市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92bd8a300f7','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92bfab200f8','2010-10-14 13:17:33','2010-10-14 13:17:33','开封市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92bfab200f8','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92c1afc00f9','2010-10-14 13:17:41','2010-10-14 13:17:41','洛阳市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92c1afc00f9','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92c42c700fa','2010-10-14 13:17:51','2010-10-14 13:17:51','平顶山市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92c42c700fa','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92c66f900fb','2010-10-14 13:18:00','2010-10-14 13:18:00','安阳市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92c66f900fb','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92c898400fc','2010-10-14 13:18:09','2010-10-14 13:18:09','鹤壁市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92c898400fc','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92cac2f00fd','2010-10-14 13:18:18','2010-10-14 13:18:18','新乡市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92cac2f00fd','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92ccce600fe','2010-10-14 13:18:27','2010-10-14 13:18:27','焦作市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92ccce600fe','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92cef0500ff','2010-10-14 13:18:35','2010-10-14 13:18:35','濮阳市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92cef0500ff','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92d13f20100','2010-10-14 13:18:45','2010-10-14 13:18:45','许昌市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92d13f20100','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92d35360101','2010-10-14 13:18:53','2010-10-14 13:18:53','漯河市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92d35360101','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92d57d10102','2010-10-14 13:19:02','2010-10-14 13:19:02','三门峡市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92d57d10102','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92d7ba50103','2010-10-14 13:19:11','2010-10-14 13:19:11','南阳市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92d7ba50103','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92da1ab0104','2010-10-14 13:19:21','2010-10-14 13:19:21','商丘市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92da1ab0104','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92dc7b20105','2010-10-14 13:19:31','2010-10-14 13:19:31','信阳市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92dc7b20105','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92de8780106','2010-10-14 13:19:39','2010-10-14 13:19:39','周口市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92de8780106','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92e0bee0107','2010-10-14 13:19:48','2010-10-14 13:19:48','驻马店市','402881882ba8753a012ba92ba9c300f6,402881882ba8753a012ba92e0bee0107','402881882ba8753a012ba92ba9c300f6'),('402881882ba8753a012ba92e37a20108','2010-10-14 13:19:59','2010-10-14 13:19:59','湖北省','402881882ba8753a012ba92e37a20108',NULL),('402881882ba8753a012ba92e68660109','2010-10-14 13:20:12','2010-10-14 13:20:12','武汉市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92e68660109','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92e94d5010a','2010-10-14 13:20:23','2010-10-14 13:20:23','黄石市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92e94d5010a','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92eb82c010b','2010-10-14 13:20:32','2010-10-14 13:20:32','十堰市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92eb82c010b','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92edfe8010c','2010-10-14 13:20:42','2010-10-14 13:20:42','宜昌市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92edfe8010c','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92f21a4010d','2010-10-14 13:20:59','2010-10-14 13:20:59','襄樊市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92f21a4010d','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92f4ab8010e','2010-10-14 13:21:10','2010-10-14 13:21:10','鄂州市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92f4ab8010e','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92f6ca7010f','2010-10-14 13:21:19','2010-10-14 13:21:19','荆门市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92f6ca7010f','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92f8dfa0110','2010-10-14 13:21:27','2010-10-14 13:21:27','孝感市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92f8dfa0110','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92fb0480111','2010-10-14 13:21:36','2010-10-14 13:21:36','荆州市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92fb0480111','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92fd6bb0112','2010-10-14 13:21:46','2010-10-14 13:21:46','黄冈市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92fd6bb0112','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba92ff9280113','2010-10-14 13:21:54','2010-10-14 13:21:55','咸宁市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba92ff9280113','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba9301be30114','2010-10-14 13:22:03','2010-10-14 13:22:03','随州市','402881882ba8753a012ba92e37a20108,402881882ba8753a012ba9301be30114','402881882ba8753a012ba92e37a20108'),('402881882ba8753a012ba930d6690115','2010-10-14 13:22:51','2010-10-14 13:22:51','湖南省','402881882ba8753a012ba930d6690115',NULL),('402881882ba8753a012ba93101120116','2010-10-14 13:23:02','2010-10-14 13:23:02','长沙市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba93101120116','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba93125f00117','2010-10-14 13:23:11','2010-10-14 13:23:11','株洲市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba93125f00117','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba93147a10118','2010-10-14 13:23:20','2010-10-14 13:23:20','湘潭市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba93147a10118','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba9316a7b0119','2010-10-14 13:23:29','2010-10-14 13:23:29','衡阳市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba9316a7b0119','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba9318e2f011a','2010-10-14 13:23:38','2010-10-14 13:23:38','邵阳市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba9318e2f011a','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba931b5ad011b','2010-10-14 13:23:48','2010-10-14 13:23:48','岳阳市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba931b5ad011b','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba931dac9011c','2010-10-14 13:23:58','2010-10-14 13:23:58','常德市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba931dac9011c','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba931fe6e011d','2010-10-14 13:24:07','2010-10-14 13:24:07','张家界市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba931fe6e011d','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba93222ce011e','2010-10-14 13:24:16','2010-10-14 13:24:16','益阳市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba93222ce011e','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba932fe59011f','2010-10-14 13:25:12','2010-10-14 13:25:12','郴州市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba932fe59011f','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba933275d0120','2010-10-14 13:25:23','2010-10-14 13:25:23','永州市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba933275d0120','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba9334cd70121','2010-10-14 13:25:33','2010-10-14 13:25:33','怀化市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba9334cd70121','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba9337b880122','2010-10-14 13:25:44','2010-10-14 13:25:44','娄底市','402881882ba8753a012ba930d6690115,402881882ba8753a012ba9337b880122','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba93401620123','2010-10-14 13:26:19','2010-10-14 13:26:19','湘西土家族苗族自治州','402881882ba8753a012ba930d6690115,402881882ba8753a012ba93401620123','402881882ba8753a012ba930d6690115'),('402881882ba8753a012ba9342b210124','2010-10-14 13:26:29','2010-10-14 13:26:29','广东省','402881882ba8753a012ba9342b210124',NULL),('402881882ba8753a012ba9345e950125','2010-10-14 13:26:43','2010-10-14 13:26:43','广州市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9345e950125','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba93483e00126','2010-10-14 13:26:52','2010-10-14 13:26:52','韶关市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba93483e00126','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba934ac770127','2010-10-14 13:27:03','2010-10-14 13:27:03','深圳市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba934ac770127','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba934d02b0128','2010-10-14 13:27:12','2010-10-14 13:27:12','珠海市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba934d02b0128','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba934eeb00129','2010-10-14 13:27:19','2010-10-14 13:27:19','汕头市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba934eeb00129','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9351207012a','2010-10-14 13:27:29','2010-10-14 13:27:29','佛山市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9351207012a','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9353406012b','2010-10-14 13:27:37','2010-10-14 13:27:37','江门市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9353406012b','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9355672012c','2010-10-14 13:27:46','2010-10-14 13:27:46','湛江市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9355672012c','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9357843012d','2010-10-14 13:27:55','2010-10-14 13:27:55','茂名市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9357843012d','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba935980f012e','2010-10-14 13:28:03','2010-10-14 13:28:03','肇庆市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba935980f012e','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba935c26b012f','2010-10-14 13:28:14','2010-10-14 13:28:14','惠州市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba935c26b012f','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba935e5e10130','2010-10-14 13:28:23','2010-10-14 13:28:23','梅州市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba935e5e10130','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba93609960131','2010-10-14 13:28:32','2010-10-14 13:28:32','汕尾市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba93609960131','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba93638c40132','2010-10-14 13:28:44','2010-10-14 13:28:44','河源市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba93638c40132','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba936593c0133','2010-10-14 13:28:52','2010-10-14 13:28:52','阳江市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba936593c0133','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9367d9d0134','2010-10-14 13:29:02','2010-10-14 13:29:02','清远市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9367d9d0134','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9369b760135','2010-10-14 13:29:09','2010-10-14 13:29:09','东莞市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba9369b760135','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba936c5350136','2010-10-14 13:29:20','2010-10-14 13:29:20','中山市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba936c5350136','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba936eb0d0137','2010-10-14 13:29:30','2010-10-14 13:29:30','潮州市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba936eb0d0137','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba93716720138','2010-10-14 13:29:41','2010-10-14 13:29:41','揭阳市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba93716720138','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba93738ee0139','2010-10-14 13:29:50','2010-10-14 13:29:50','云浮市','402881882ba8753a012ba9342b210124,402881882ba8753a012ba93738ee0139','402881882ba8753a012ba9342b210124'),('402881882ba8753a012ba9376770013a','2010-10-14 13:30:01','2010-10-14 13:30:01','广西壮族自治区','402881882ba8753a012ba9376770013a',NULL),('402881882ba8753a012ba9379c4c013b','2010-10-14 13:30:15','2010-10-14 13:30:15','南宁市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba9379c4c013b','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba937bf06013c','2010-10-14 13:30:24','2010-10-14 13:30:24','柳州市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba937bf06013c','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba937e192013d','2010-10-14 13:30:33','2010-10-14 13:30:33','桂林市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba937e192013d','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba9380789013e','2010-10-14 13:30:42','2010-10-14 13:30:42','梧州市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba9380789013e','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93827f2013f','2010-10-14 13:30:51','2010-10-14 13:30:51','北海市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93827f2013f','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93851150140','2010-10-14 13:31:01','2010-10-14 13:31:01','防城港市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93851150140','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93872490141','2010-10-14 13:31:10','2010-10-14 13:31:10','钦州市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93872490141','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93899780142','2010-10-14 13:31:20','2010-10-14 13:31:20','贵港市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93899780142','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba938badb0143','2010-10-14 13:31:28','2010-10-14 13:31:28','玉林市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba938badb0143','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba938db820144','2010-10-14 13:31:37','2010-10-14 13:31:37','百色市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba938db820144','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba938fd530145','2010-10-14 13:31:45','2010-10-14 13:31:45','贺州市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba938fd530145','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93921360146','2010-10-14 13:31:55','2010-10-14 13:31:55','河池市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93921360146','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93943d10147','2010-10-14 13:32:03','2010-10-14 13:32:03','来宾市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93943d10147','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba93965c10148','2010-10-14 13:32:12','2010-10-14 13:32:12','崇左市','402881882ba8753a012ba9376770013a,402881882ba8753a012ba93965c10148','402881882ba8753a012ba9376770013a'),('402881882ba8753a012ba939ac010149','2010-10-14 13:32:30','2010-10-14 13:32:30','海南省','402881882ba8753a012ba939ac010149',NULL),('402881882ba8753a012ba939da07014a','2010-10-14 13:32:42','2010-10-14 13:32:42','海口市','402881882ba8753a012ba939ac010149,402881882ba8753a012ba939da07014a','402881882ba8753a012ba939ac010149'),('402881882ba8753a012ba939f8ca014b','2010-10-14 13:32:50','2010-10-14 13:32:50','三亚市','402881882ba8753a012ba939ac010149,402881882ba8753a012ba939f8ca014b','402881882ba8753a012ba939ac010149'),('402881882ba8753a012ba93a6743014c','2010-10-14 13:33:18','2010-10-14 13:33:18','重庆市','402881882ba8753a012ba93a6743014c',NULL),('402881882ba8753a012ba93b13fe014d','2010-10-14 13:34:02','2010-10-14 13:34:02','万州区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93b13fe014d','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93b34d4014e','2010-10-14 13:34:11','2010-10-14 13:34:11','涪陵区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93b34d4014e','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93b5898014f','2010-10-14 13:34:20','2010-10-14 13:34:20','渝中区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93b5898014f','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93b7a970150','2010-10-14 13:34:29','2010-10-14 13:34:29','大渡口区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93b7a970150','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93b9a930151','2010-10-14 13:34:37','2010-10-14 13:34:37','江北区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93b9a930151','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93bbb980152','2010-10-14 13:34:45','2010-10-14 13:34:45','沙坪坝区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93bbb980152','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93bdab90153','2010-10-14 13:34:53','2010-10-14 13:34:53','九龙坡区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93bdab90153','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93bfd150154','2010-10-14 13:35:02','2010-10-14 13:35:02','南岸区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93bfd150154','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93c1b4c0155','2010-10-14 13:35:10','2010-10-14 13:35:10','北碚区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93c1b4c0155','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93c3c800156','2010-10-14 13:35:18','2010-10-14 13:35:18','万盛区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93c3c800156','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93c5a970157','2010-10-14 13:35:26','2010-10-14 13:35:26','双桥区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93c5a970157','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93c793b0158','2010-10-14 13:35:34','2010-10-14 13:35:34','渝北区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93c793b0158','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93c93790159','2010-10-14 13:35:40','2010-10-14 13:35:40','巴南区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93c93790159','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93cacaf015a','2010-10-14 13:35:47','2010-10-14 13:35:47','黔江区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93cacaf015a','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93cbc7d015b','2010-10-14 13:35:51','2010-10-14 13:35:51','长寿区','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93cbc7d015b','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93d1d3b015c','2010-10-14 13:36:16','2010-10-14 13:36:16','江津市','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93d1d3b015c','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93d3a0a015d','2010-10-14 13:36:23','2010-10-14 13:36:23','合川市','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93d3a0a015d','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93d53ad015e','2010-10-14 13:36:30','2010-10-14 13:36:30','永川市','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93d53ad015e','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93d6689015f','2010-10-14 13:36:34','2010-10-14 13:36:34','南川市','402881882ba8753a012ba93a6743014c,402881882ba8753a012ba93d6689015f','402881882ba8753a012ba93a6743014c'),('402881882ba8753a012ba93d95780160','2010-10-14 13:36:46','2010-10-14 13:36:46','四川省','402881882ba8753a012ba93d95780160',NULL),('402881882ba8753a012ba93dc8110161','2010-10-14 13:36:59','2010-10-14 13:36:59','成都市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93dc8110161','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93df0d70162','2010-10-14 13:37:10','2010-10-14 13:37:10','自贡市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93df0d70162','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93e12980163','2010-10-14 13:37:19','2010-10-14 13:37:19','攀枝花市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93e12980163','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93e30ce0164','2010-10-14 13:37:26','2010-10-14 13:37:26','泸州市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93e30ce0164','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93e54a20165','2010-10-14 13:37:35','2010-10-14 13:37:35','德阳市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93e54a20165','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93e83820166','2010-10-14 13:37:47','2010-10-14 13:37:47','绵阳市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93e83820166','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93ea6d90167','2010-10-14 13:37:56','2010-10-14 13:37:56','广元市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93ea6d90167','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93ecaad0168','2010-10-14 13:38:06','2010-10-14 13:38:06','遂宁市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93ecaad0168','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93eeab80169','2010-10-14 13:38:14','2010-10-14 13:38:14','内江市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93eeab80169','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93f0c69016a','2010-10-14 13:38:22','2010-10-14 13:38:22','乐山市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93f0c69016a','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93f2d6e016b','2010-10-14 13:38:31','2010-10-14 13:38:31','南充市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93f2d6e016b','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93f551a016c','2010-10-14 13:38:41','2010-10-14 13:38:41','眉山市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93f551a016c','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93f7cf5016d','2010-10-14 13:38:51','2010-10-14 13:38:51','宜宾市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93f7cf5016d','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba93fec3a016e','2010-10-14 13:39:20','2010-10-14 13:39:20','广安市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba93fec3a016e','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba94017ed016f','2010-10-14 13:39:31','2010-10-14 13:39:31','达州市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba94017ed016f','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba94044e90170','2010-10-14 13:39:42','2010-10-14 13:39:42','雅安市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba94044e90170','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba94072810171','2010-10-14 13:39:54','2010-10-14 13:39:54','巴中市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba94072810171','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba94098d50172','2010-10-14 13:40:04','2010-10-14 13:40:04','资阳市','402881882ba8753a012ba93d95780160,402881882ba8753a012ba94098d50172','402881882ba8753a012ba93d95780160'),('402881882ba8753a012ba940dad00173','2010-10-14 13:40:21','2010-10-14 13:40:21','贵州省','402881882ba8753a012ba940dad00173',NULL),('402881882ba8753a012ba9410a9a0174','2010-10-14 13:40:33','2010-10-14 13:40:33','贵阳市','402881882ba8753a012ba940dad00173,402881882ba8753a012ba9410a9a0174','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba94135f00175','2010-10-14 13:40:44','2010-10-14 13:40:44','六盘水市','402881882ba8753a012ba940dad00173,402881882ba8753a012ba94135f00175','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba94157240176','2010-10-14 13:40:53','2010-10-14 13:40:53','遵义市','402881882ba8753a012ba940dad00173,402881882ba8753a012ba94157240176','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba9418ece0177','2010-10-14 13:41:07','2010-10-14 13:41:07','安顺市','402881882ba8753a012ba940dad00173,402881882ba8753a012ba9418ece0177','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba941c0ea0178','2010-10-14 13:41:20','2010-10-14 13:41:20','铜仁地区','402881882ba8753a012ba940dad00173,402881882ba8753a012ba941c0ea0178','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba942a5200179','2010-10-14 13:42:18','2010-10-14 13:42:18','毕节地区','402881882ba8753a012ba940dad00173,402881882ba8753a012ba942a5200179','402881882ba8753a012ba940dad00173'),('402881882ba8753a012ba942d1dd017a','2010-10-14 13:42:30','2010-10-14 13:42:30','云南省','402881882ba8753a012ba942d1dd017a',NULL),('402881882ba8753a012ba9430c46017b','2010-10-14 13:42:45','2010-10-14 13:42:45','昆明市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba9430c46017b','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba943446d017c','2010-10-14 13:42:59','2010-10-14 13:42:59','曲靖市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba943446d017c','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba9435797017d','2010-10-14 13:43:04','2010-10-14 13:43:04','玉溪市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba9435797017d','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba9438109017e','2010-10-14 13:43:14','2010-10-14 13:43:14','保山市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba9438109017e','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba943a0b6017f','2010-10-14 13:43:23','2010-10-14 13:43:23','昭通市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba943a0b6017f','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba943c5070180','2010-10-14 13:43:32','2010-10-14 13:43:32','丽江市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba943c5070180','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba943e39b0181','2010-10-14 13:43:40','2010-10-14 13:43:40','思茅市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba943e39b0181','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba94406360182','2010-10-14 13:43:49','2010-10-14 13:43:49','临沧市','402881882ba8753a012ba942d1dd017a,402881882ba8753a012ba94406360182','402881882ba8753a012ba942d1dd017a'),('402881882ba8753a012ba94474040183','2010-10-14 13:44:17','2010-10-14 13:44:17','西藏自治区','402881882ba8753a012ba94474040183',NULL),('402881882ba8753a012ba9449a490184','2010-10-14 13:44:26','2010-10-14 13:44:26','拉萨市','402881882ba8753a012ba94474040183,402881882ba8753a012ba9449a490184','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba944b7180185','2010-10-14 13:44:34','2010-10-14 13:44:34','昌都地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba944b7180185','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba944ea9b0186','2010-10-14 13:44:47','2010-10-14 13:44:47','山南地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba944ea9b0186','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba94510440187','2010-10-14 13:44:57','2010-10-14 13:44:57','日喀则地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba94510440187','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba94535210188','2010-10-14 13:45:06','2010-10-14 13:45:06','那曲地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba94535210188','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba94554130189','2010-10-14 13:45:14','2010-10-14 13:45:14','阿里地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba94554130189','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba945741e018a','2010-10-14 13:45:22','2010-10-14 13:45:22','林芝地区','402881882ba8753a012ba94474040183,402881882ba8753a012ba945741e018a','402881882ba8753a012ba94474040183'),('402881882ba8753a012ba945a63a018b','2010-10-14 13:45:35','2010-10-14 13:45:35','陕西省','402881882ba8753a012ba945a63a018b',NULL),('402881882ba8753a012ba945dc2f018c','2010-10-14 13:45:49','2010-10-14 13:45:49','西安市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba945dc2f018c','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba945fb7f018d','2010-10-14 13:45:57','2010-10-14 13:45:57','铜川市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba945fb7f018d','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba9461a80018e','2010-10-14 13:46:05','2010-10-14 13:46:05','宝鸡市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba9461a80018e','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba9463674018f','2010-10-14 13:46:12','2010-10-14 13:46:12','咸阳市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba9463674018f','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba94653240190','2010-10-14 13:46:19','2010-10-14 13:46:19','渭南市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba94653240190','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba9466f760191','2010-10-14 13:46:27','2010-10-14 13:46:27','延安市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba9466f760191','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba9468dbc0192','2010-10-14 13:46:34','2010-10-14 13:46:34','汉中市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba9468dbc0192','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba946a6f10193','2010-10-14 13:46:41','2010-10-14 13:46:41','榆林市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba946a6f10193','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba946c48b0194','2010-10-14 13:46:48','2010-10-14 13:46:48','安康市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba946c48b0194','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba946de8c0195','2010-10-14 13:46:55','2010-10-14 13:46:55','商洛市','402881882ba8753a012ba945a63a018b,402881882ba8753a012ba946de8c0195','402881882ba8753a012ba945a63a018b'),('402881882ba8753a012ba94704c10196','2010-10-14 13:47:05','2010-10-14 13:47:05','甘肃省','402881882ba8753a012ba94704c10196',NULL),('402881882ba8753a012ba94731dc0197','2010-10-14 13:47:16','2010-10-14 13:47:16','兰州市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba94731dc0197','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba9475b2e0198','2010-10-14 13:47:27','2010-10-14 13:47:27','嘉峪关市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba9475b2e0198','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba94777fd0199','2010-10-14 13:47:34','2010-10-14 13:47:34','金昌市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba94777fd0199','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba947b94c019a','2010-10-14 13:47:51','2010-10-14 13:47:51','白银市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba947b94c019a','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba947deb6019b','2010-10-14 13:48:01','2010-10-14 13:48:01','天水市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba947deb6019b','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba947fc8e019c','2010-10-14 13:48:08','2010-10-14 13:48:08','武威市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba947fc8e019c','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba9481825019d','2010-10-14 13:48:15','2010-10-14 13:48:15','张掖市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba9481825019d','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba9483726019e','2010-10-14 13:48:23','2010-10-14 13:48:23','平凉市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba9483726019e','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba94852ad019f','2010-10-14 13:48:30','2010-10-14 13:48:30','酒泉市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba94852ad019f','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba94872c801a0','2010-10-14 13:48:38','2010-10-14 13:48:38','庆阳市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba94872c801a0','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba9488fc601a1','2010-10-14 13:48:46','2010-10-14 13:48:46','定西市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba9488fc601a1','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba948ba7f01a2','2010-10-14 13:48:57','2010-10-14 13:48:57','陇南市','402881882ba8753a012ba94704c10196,402881882ba8753a012ba948ba7f01a2','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba948f8ff01a3','2010-10-14 13:49:13','2010-10-14 13:49:13','临夏回族自治州','402881882ba8753a012ba94704c10196,402881882ba8753a012ba948f8ff01a3','402881882ba8753a012ba94704c10196'),('402881882ba8753a012ba949336801a4','2010-10-14 13:49:28','2010-10-14 13:49:28','青海省','402881882ba8753a012ba949336801a4',NULL),('402881882ba8753a012ba9495b0501a5','2010-10-14 13:49:38','2010-10-14 13:49:38','西宁市','402881882ba8753a012ba949336801a4,402881882ba8753a012ba9495b0501a5','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba94980ae01a6','2010-10-14 13:49:48','2010-10-14 13:49:48','海东地区','402881882ba8753a012ba949336801a4,402881882ba8753a012ba94980ae01a6','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba949c59601a7','2010-10-14 13:50:05','2010-10-14 13:50:05','海北藏族自治州','402881882ba8753a012ba949336801a4,402881882ba8753a012ba949c59601a7','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba949e5c101a8','2010-10-14 13:50:13','2010-10-14 13:50:13','黄南藏族自治州','402881882ba8753a012ba949336801a4,402881882ba8753a012ba949e5c101a8','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba94a097501a9','2010-10-14 13:50:23','2010-10-14 13:50:23','海南藏族自治州','402881882ba8753a012ba949336801a4,402881882ba8753a012ba94a097501a9','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba94a2df501aa','2010-10-14 13:50:32','2010-10-14 13:50:32','果洛藏族自治州','402881882ba8753a012ba949336801a4,402881882ba8753a012ba94a2df501aa','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba94a52b301ab','2010-10-14 13:50:41','2010-10-14 13:50:41','玉树藏族自治州','402881882ba8753a012ba949336801a4,402881882ba8753a012ba94a52b301ab','402881882ba8753a012ba949336801a4'),('402881882ba8753a012ba94a847201ac','2010-10-14 13:50:54','2010-10-14 13:50:54','宁夏回族自治区','402881882ba8753a012ba94a847201ac',NULL),('402881882ba8753a012ba94aaf2b01ad','2010-10-14 13:51:05','2010-10-14 13:51:05','银川市','402881882ba8753a012ba94a847201ac,402881882ba8753a012ba94aaf2b01ad','402881882ba8753a012ba94a847201ac'),('402881882ba8753a012ba94ad22401ae','2010-10-14 13:51:14','2010-10-14 13:51:14','石嘴山市','402881882ba8753a012ba94a847201ac,402881882ba8753a012ba94ad22401ae','402881882ba8753a012ba94a847201ac'),('402881882ba8753a012ba94af62701af','2010-10-14 13:51:23','2010-10-14 13:51:23','吴忠市','402881882ba8753a012ba94a847201ac,402881882ba8753a012ba94af62701af','402881882ba8753a012ba94a847201ac'),('402881882ba8753a012ba94b13c101b0','2010-10-14 13:51:31','2010-10-14 13:51:31','固原市','402881882ba8753a012ba94a847201ac,402881882ba8753a012ba94b13c101b0','402881882ba8753a012ba94a847201ac'),('402881882ba8753a012ba94b2f4801b1','2010-10-14 13:51:38','2010-10-14 13:51:38','中卫市','402881882ba8753a012ba94a847201ac,402881882ba8753a012ba94b2f4801b1','402881882ba8753a012ba94a847201ac'),('402881882ba8753a012ba94b61c201b2','2010-10-14 13:51:51','2010-10-14 13:51:51','新疆维吾尔自治区','402881882ba8753a012ba94b61c201b2',NULL),('402881882ba8753a012ba94b8e5001b3','2010-10-14 13:52:02','2010-10-14 13:52:02','乌鲁木齐市','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94b8e5001b3','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94bafb301b4','2010-10-14 13:52:11','2010-10-14 13:52:11','克拉玛依市','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94bafb301b4','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94bced401b5','2010-10-14 13:52:19','2010-10-14 13:52:19','吐鲁番地区','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94bced401b5','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94bf62201b6','2010-10-14 13:52:29','2010-10-14 13:52:29','哈密地区','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94bf62201b6','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94c14b601b7','2010-10-14 13:52:37','2010-10-14 13:52:37','昌吉回族自治州','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94c14b601b7','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94c3ffd01b8','2010-10-14 13:52:48','2010-10-14 13:52:48','博尔塔拉蒙古自治州','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94c3ffd01b8','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94cfd4201b9','2010-10-14 13:53:36','2010-10-14 13:53:36','喀什地区','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94cfd4201b9','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94d207901ba','2010-10-14 13:53:45','2010-10-14 13:53:45','和田地区','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94d207901ba','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94d427801bb','2010-10-14 13:53:54','2010-10-14 13:53:54','伊犁哈萨克自治州','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94d427801bb','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94d76b701bc','2010-10-14 13:54:07','2010-10-14 13:54:07','克孜勒苏柯尔克孜自治州','402881882ba8753a012ba94b61c201b2,402881882ba8753a012ba94d76b701bc','402881882ba8753a012ba94b61c201b2'),('402881882ba8753a012ba94dc00501bd','2010-10-14 13:54:26','2010-10-14 13:54:26','台湾省','402881882ba8753a012ba94dc00501bd',NULL),('402881882ba8753a012ba94de66901be','2010-10-14 13:54:36','2010-10-14 13:54:36','香港特别行政区','402881882ba8753a012ba94de66901be',NULL),('402881882ba8753a012ba94e039601bf','2010-10-14 13:54:43','2010-10-14 13:54:43','澳门特别行政区','402881882ba8753a012ba94e039601bf',NULL);
UNLOCK TABLES;
--
-- Table structure for table `Log`
--
DROP TABLE IF EXISTS `Log`;
CREATE TABLE `Log` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`actionClassName` varchar(255) NOT NULL,
`actionMethodName` varchar(255) NOT NULL,
`info` text,
`ip` varchar(255) NOT NULL,
`operationName` varchar(255) NOT NULL,
`operator` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Log`
--
LOCK TABLES `Log` WRITE;
INSERT INTO `Log` VALUES ('8ae416293923538f0139235b42170003','2012-08-14 12:19:06','2012-08-14 12:19:06','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'127.0.0.1','单个设备定向推送','admin'),('8ae416293923538f0139235bd4360004','2012-08-14 12:19:44','2012-08-14 12:19:44','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'127.0.0.1','单个设备定向推送','admin'),('8ae4162939236b3d0139236e407c0001','2012-08-14 12:39:51','2012-08-14 12:39:51','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'127.0.0.1','单个设备定向推送','admin'),('8ae4162939236b3d01392370f6200002','2012-08-14 12:42:49','2012-08-14 12:42:49','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'127.0.0.1','单个设备定向推送','admin'),('8ae41629392377490139237867070001','2012-08-14 12:50:56','2012-08-14 12:50:56','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'127.0.0.1','单个设备定向推送','admin'),('8ae416293923f493013923fb258b0001','2012-08-14 15:13:45','2012-08-14 15:13:45','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush',NULL,'10.100.149.142','单个设备定向推送','admin');
UNLOCK TABLES;
--
-- Table structure for table `LogConfig`
--
DROP TABLE IF EXISTS `LogConfig`;
CREATE TABLE `LogConfig` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`actionClassName` varchar(255) NOT NULL,
`actionMethodName` varchar(255) NOT NULL,
`description` text,
`operationName` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `operationName` (`operationName`),
UNIQUE KEY `actionClassName` (`actionClassName`,`actionMethodName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `LogConfig`
--
LOCK TABLES `LogConfig` WRITE;
INSERT INTO `LogConfig` VALUES ('8ae416293923538f0139235ae71f0002','2012-08-14 12:18:43','2012-08-14 12:18:43','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','ajaxDevicePush','单个设备定向推送调用','单个设备定向推送'),('8ae416293923538f0139235eb6550005','2012-08-14 12:22:53','2012-08-14 12:22:53','com.lenovo.lps.psb.pushmarketing.action.admin.MultidimenpushAction','save','多维度推送-创建Push任务保存方法调用','多维度推送-创建Push任务');
UNLOCK TABLES;
--
-- Table structure for table `Resource`
--
DROP TABLE IF EXISTS `Resource`;
CREATE TABLE `Resource` (
`id` varchar(32) NOT NULL,
`createDate` datetime DEFAULT NULL,
`modifyDate` datetime DEFAULT NULL,
`description` text,
`isSystem` bit(1) NOT NULL,
`name` varchar(255) NOT NULL,
`orderList` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `value` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Resource`
--
LOCK TABLES `Resource` WRITE;
INSERT INTO `Resource` VALUES ('402881862bec2a21012bec2aff470001','2010-10-27 13:31:02','2010-10-27 13:31:02','后台管理所有资源','','后台管理资源',100,'/admin/*'),('8ae4162938eff5760138effe9a550001','2012-08-04 12:57:16','2012-08-04 15:52:53','访问统计模块的资源','\0','Push营销-统计信息',20,'/admin/statistics*'),('8ae4162938eff5760138f006cf000004','2012-08-04 13:06:14','2012-08-04 13:32:36','访问后台系统首页','\0','后台系统首页',1,'/admin/admin!main.action'),('8ae4162938eff5760138f007785f0005','2012-08-04 13:06:57','2012-08-04 14:31:02','访问后台系统左侧二级菜单','\0','后台系统左侧二级菜单',3,'/admin/menu*'),('8ae4162938eff5760138f016e4c40007','2012-08-04 13:23:48','2012-08-04 15:52:37','访问多维度推送模块资源','\0','Push营销-多维度推送',30,'/admin/multidimenpush*'),('8ae4162938f041be0138f052f03f0001','2012-08-04 14:29:23','2012-08-04 14:31:09','访问后台系统头部一级菜单页面','\0','后台系统头部一级菜单',2,'/admin/admin!header.action'),('8ae4162938f041be0138f0592e640002','2012-08-04 14:36:12','2012-08-04 14:36:27','访问后台系统首页index页面','\0','后台系统中部index页面',4,'/admin/admin!index.action'),('8ae4162938f081740138f08486a90001','2012-08-04 15:23:33','2012-08-04 15:29:44','访问后台系统中部split页面','\0','后台系统中部split页面',5,'/admin/admin!middle.action'),('8ae4162938f0965d0138f09cbcac0003','2012-08-04 15:50:00','2012-08-04 15:52:45','乐商店Push推荐信息专用','\0','乐商店专用',21,'/admin/multidimenpush!appstore.action');
UNLOCK TABLES;
--
-- Table structure for table `Role`
--
--
-- Table structure for table `Role_Resource`
--
DROP TABLE IF EXISTS `Role_Resource`;
CREATE TABLE `Role_Resource` (
`roleSet_id` varchar(32) NOT NULL,
`resourceSet_id` varchar(32) NOT NULL,
PRIMARY KEY (`roleSet_id`,`resourceSet_id`),
KEY `FKE25F2DB7C7B24C48` (`roleSet_id`),
KEY `FKE25F2DB75BD93F78` (`resourceSet_id`),
KEY `FKE25F2DB777144651` (`roleSet_id`),
KEY `FKE25F2DB7362D0D01` (`resourceSet_id`),
CONSTRAINT `FKE25F2DB7362D0D01` FOREIGN KEY (`resourceSet_id`) REFERENCES `Resource` (`id`),
CONSTRAINT `FKE25F2DB777144651` FOREIGN KEY (`roleSet_id`) REFERENCES `Role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Role_Resource`
--
LOCK TABLES `Role_Resource` WRITE;
INSERT INTO `Role_Resource` VALUES ('402881862bec2a21012bec2b70510002','402881862bec2a21012bec2aff470001'),('402881862bec2a21012bec2b70510002','8ae4162938eff5760138effe9a550001'),('402881862bec2a21012bec2b70510002','8ae4162938eff5760138f006cf000004'),('402881862bec2a21012bec2b70510002','8ae4162938eff5760138f007785f0005'),('402881862bec2a21012bec2b70510002','8ae4162938eff5760138f016e4c40007'),('402881862bec2a21012bec2b70510002','8ae4162938f041be0138f052f03f0001'),('402881862bec2a21012bec2b70510002','8ae4162938f041be0138f0592e640002'),('402881862bec2a21012bec2b70510002','8ae4162938f081740138f08486a90001'),('402881862bec2a21012bec2b70510002','8ae4162938f0965d0138f09cbcac0003'),('8ae4162938eff5760138f000c7520002','8ae4162938eff5760138effe9a550001'),('8ae4162938eff5760138f000c7520002','8ae4162938eff5760138f006cf000004'),('8ae4162938eff5760138f000c7520002','8ae4162938eff5760138f007785f0005'),('8ae4162938eff5760138f000c7520002','8ae4162938f041be0138f052f03f0001'),('8ae4162938eff5760138f000c7520002','8ae4162938f041be0138f0592e640002'),('8ae4162938eff5760138f000c7520002','8ae4162938f081740138f08486a90001'),('8ae4162938eff5760138f00c9cc60006','8ae4162938eff5760138f006cf000004'),('8ae4162938eff5760138f00c9cc60006','8ae4162938eff5760138f007785f0005'),('8ae4162938eff5760138f00c9cc60006','8ae4162938eff5760138f016e4c40007'),('8ae4162938eff5760138f00c9cc60006','8ae4162938f041be0138f052f03f0001'),('8ae4162938eff5760138f00c9cc60006','8ae4162938f041be0138f0592e640002'),('8ae4162938eff5760138f00c9cc60006','8ae4162938f081740138f08486a90001'),('8ae4162938eff5760138f00c9cc60006','8ae4162938f0965d0138f09cbcac0003'),('8ae4162938eff5760138f0234b6c0008','8ae4162938eff5760138effe9a550001'),('8ae4162938eff5760138f0234b6c0008','8ae4162938eff5760138f006cf000004'),('8ae4162938eff5760138f0234b6c0008','8ae4162938eff5760138f007785f0005'),('8ae4162938eff5760138f0234b6c0008','8ae4162938eff5760138f016e4c40007'),('8ae4162938eff5760138f0234b6c0008','8ae4162938f041be0138f052f03f0001'),('8ae4162938eff5760138f0234b6c0008','8ae4162938f041be0138f0592e640002'),('8ae4162938eff5760138f0234b6c0008','8ae4162938f081740138f08486a90001'),('8ae4162938eff5760138f0234b6c0008','8ae4162938f0965d0138f09cbcac0003'),('8ae4162938f0965d0138f099db790001','8ae4162938eff5760138f006cf000004'),('8ae4162938f0965d0138f099db790001','8ae4162938eff5760138f007785f0005'),('8ae4162938f0965d0138f099db790001','8ae4162938f041be0138f052f03f0001'),('8ae4162938f0965d0138f099db790001','8ae4162938f041be0138f0592e640002'),('8ae4162938f0965d0138f099db790001','8ae4162938f081740138f08486a90001'),('8ae4162938f0965d0138f099db790001','8ae4162938f0965d0138f09cbcac0003');
UNLOCK TABLES;
--
-- Table structure for table `push_device_info`
--
DROP TABLE IF EXISTS `push_device_info`;
CREATE TABLE `push_device_info` (
`pid` bigint(64) NOT NULL,
`device_model` varchar(100) DEFAULT NULL,
`deviceid_type` varchar(10) DEFAULT NULL,
`deviceid` varchar(50) DEFAULT NULL,
`device_imsi` varchar(100) DEFAULT NULL,
`os_version` varchar(200) DEFAULT NULL,
`cust_version` varchar(100) DEFAULT NULL,
`pe_version` varchar(100) DEFAULT NULL,
`pe_vercode` varchar(100) DEFAULT NULL,
`pe_pkgname` varchar(100) DEFAULT NULL,
`netaccess_type` varchar(10) DEFAULT NULL,
`ip` varchar(64) DEFAULT NULL,
`operation_type` varchar(10) DEFAULT NULL,
`country_code` varchar(32) DEFAULT NULL,
`city_name` varchar(64) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`modifydate` datetime DEFAULT NULL,
`charge_status` varchar(10) DEFAULT NULL,
`apn` varchar(32) DEFAULT NULL,
`operator_code` varchar(32) DEFAULT NULL,
`sysid` varchar(32) DEFAULT NULL,
`locid` varchar(32) DEFAULT NULL,
`cellid` varchar(32) DEFAULT NULL,
`latitude` varchar(32) DEFAULT NULL,
`longitude` varchar(32) DEFAULT NULL,
`pepollversion` varchar(10) DEFAULT NULL,
`channelname` varchar(100) DEFAULT null,
`accessnum` int(11) DEFAULT 0,
PRIMARY KEY (`pid`),
KEY `idx_device_model` (`device_model`),
KEY `idx_city_name` (`city_name`),
KEY `idx_modifydate` (`modifydate`),
KEY `idx_pe_version` (`pe_version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `device_dimen_info`
--
DROP TABLE IF EXISTS `device_dimen_info`;
CREATE TABLE `device_dimen_info` (
`id` varchar(32) NOT NULL,
`dimen_key` varchar(20) DEFAULT NULL,
`dimen_value` varchar(100) DEFAULT NULL,
`all_devicenum` int(32) DEFAULT NULL,
`act_devicenum` int(32) DEFAULT NULL,
`p_htmlfilepath` varchar(255) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`modifydate` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `push_task_feedback`;
CREATE TABLE `push_task_feedback` (
`id` varchar(32) NOT NULL,
`task_id` varchar(32) NOT NULL,
`topids` text,
`arrived_cnt` int(32) DEFAULT NULL,
`displayed_cnt` int(32) DEFAULT NULL,
`clicked_cnt` int(32) DEFAULT NULL,
`app_name` varchar(100) DEFAULT NULL,
`curr_version` varchar(64) DEFAULT NULL,
`target_version` varchar(64) DEFAULT NULL,
`install_result` varchar(32) DEFAULT NULL,
`install_errcode` varchar(32) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`modifydate` datetime DEFAULT NULL,
`pushtaskinfo_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK7985589A4DA511A7` (`pushtaskinfo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `push_task_info`;
CREATE TABLE `push_task_info` (
`id` varchar(32) NOT NULL,
`task_name` varchar(64) DEFAULT NULL,
`task_exe_type` varchar(10) NOT NULL,
`task_biz_type` varchar(64) NOT NULL,
`task_status` varchar(10) DEFAULT NULL,
`task_source_sid` varchar(100) DEFAULT NULL,
`task_source_trust` varchar(10) DEFAULT NULL,
`task_priority` varchar(10) DEFAULT NULL,
`task_condition` text,
`task_pushcontent` text,
`task_keywords` varchar(100) DEFAULT NULL,
`task_description` text,
`task_startdate` datetime DEFAULT NULL,
`task_enddate` datetime DEFAULT NULL,
`assignuser_type` int(10) NOT NULL,
`assignuser_list` text,
`blacklist_type` int(10) NOT NULL,
`blacklist_content` text,
`pepollversion` varchar(10) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`modifydate` datetime DEFAULT NULL,
`task_pushurl` varchar(300) DEFAULT NULL,
`task_pushtitle` varchar(50) default NULL,
`task_appaction` varchar(100) default NULL,
`task_ad_type` varchar(10) default NULL,
`task_adbiz_type` varchar(10) default NULL,
`task_msg_ttl` int(10) default 2,
`task_actdevice_cnt` int(32) default 0,
`test_diviceids` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*==============================================================*/
/*ADD BY YINZJ4 2012-07-18
/* Table: psb_push_indicator */
/* indicator_type--1:日报 7：周报 10：sid接受有效消息分布统计 11：sid到达消息分布统计*/
/*==============================================================*/
drop table if exists psb_push_indicator;
create table psb_push_indicator
(
id bigint not null auto_increment,
indicator_type int,
commit_time bigint not null,
devices_allcnt bigint,
devices_newcnt bigint,
devices_activitycnt bigint,
receivedmsgs_allcnt bigint,
dealmsgs_allcnt bigint,
arrivedmsgs_allcnt bigint,
tianqi_msgs_cnt bigint,
neirong_msgs_cnt bigint,
qiyeyoujian_msgs_cnt bigint,
gexinghuapush_msgs_cnt bigint,
leshangdian_msgs_cnt bigint,
gerenyoujian_msgs_cnt bigint,
rsys001_msgs_cnt bigint,
qita_msgs_cnt bigint,
singlepoll_devices_cnt bigint,
primary key (id),
KEY `idx_commit_time` (`commit_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS pushmarketing_QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_TRIGGER_LISTENERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_FIRED_TRIGGERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_SCHEDULER_STATE;
DROP TABLE IF EXISTS pushmarketing_QRTZ_LOCKS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_SIMPLE_TRIGGERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_CRON_TRIGGERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_BLOB_TRIGGERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_TRIGGERS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_JOB_DETAILS;
DROP TABLE IF EXISTS pushmarketing_QRTZ_CALENDARS;
CREATE TABLE pushmarketing_QRTZ_JOB_DETAILS
(
JOB_NAME VARCHAR(100) NOT NULL,
JOB_GROUP VARCHAR(100) NOT NULL,
DESCRIPTION VARCHAR(250) NULL,
JOB_CLASS_NAME VARCHAR(250) NOT NULL,
IS_DURABLE VARCHAR(1) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
IS_STATEFUL VARCHAR(1) NOT NULL,
REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (JOB_NAME,JOB_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_JOB_LISTENERS
(
JOB_NAME VARCHAR(100) NOT NULL,
JOB_GROUP VARCHAR(100) NOT NULL,
JOB_LISTENER VARCHAR(100) NOT NULL,
PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES pushmarketing_QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_TRIGGERS
(
TRIGGER_NAME VARCHAR(100) NOT NULL,
TRIGGER_GROUP VARCHAR(100) NOT NULL,
JOB_NAME VARCHAR(100) NOT NULL,
JOB_GROUP VARCHAR(100) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
DESCRIPTION VARCHAR(250) NULL,
NEXT_FIRE_TIME BIGINT(13) NULL,
PREV_FIRE_TIME BIGINT(13) NULL,
PRIORITY INTEGER NULL,
TRIGGER_STATE VARCHAR(16) NOT NULL,
TRIGGER_TYPE VARCHAR(8) NOT NULL,
START_TIME BIGINT(13) NOT NULL,
END_TIME BIGINT(13) NULL,
CALENDAR_NAME VARCHAR(200) NULL,
MISFIRE_INSTR SMALLINT(2) NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES pushmarketing_QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_SIMPLE_TRIGGERS
(
TRIGGER_NAME VARCHAR(100) NOT NULL,
TRIGGER_GROUP VARCHAR(100) NOT NULL,
REPEAT_COUNT BIGINT(7) NOT NULL,
REPEAT_INTERVAL BIGINT(12) NOT NULL,
TIMES_TRIGGERED BIGINT(7) NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES pushmarketing_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_CRON_TRIGGERS
(
TRIGGER_NAME VARCHAR(100) NOT NULL,
TRIGGER_GROUP VARCHAR(100) NOT NULL,
CRON_EXPRESSION VARCHAR(200) NOT NULL,
TIME_ZONE_ID VARCHAR(80),
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES pushmarketing_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_BLOB_TRIGGERS
(
TRIGGER_NAME VARCHAR(100) NOT NULL,
TRIGGER_GROUP VARCHAR(100) NOT NULL,
BLOB_DATA BLOB NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES pushmarketing_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_TRIGGER_LISTENERS
(
TRIGGER_NAME VARCHAR(100) NOT NULL,
TRIGGER_GROUP VARCHAR(100) NOT NULL,
TRIGGER_LISTENER VARCHAR(100) NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES pushmarketing_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_CALENDARS
(
CALENDAR_NAME VARCHAR(100) NOT NULL,
CALENDAR BLOB NOT NULL,
PRIMARY KEY (CALENDAR_NAME)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_PAUSED_TRIGGER_GRPS
(
TRIGGER_GROUP VARCHAR(100) NOT NULL,
PRIMARY KEY (TRIGGER_GROUP)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_FIRED_TRIGGERS
(
ENTRY_ID VARCHAR(95) NOT NULL,
TRIGGER_NAME VARCHAR(200) NOT NULL,
TRIGGER_GROUP VARCHAR(200) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
INSTANCE_NAME VARCHAR(200) NOT NULL,
FIRED_TIME BIGINT(13) NOT NULL,
PRIORITY INTEGER NOT NULL,
STATE VARCHAR(16) NOT NULL,
JOB_NAME VARCHAR(200) NULL,
JOB_GROUP VARCHAR(200) NULL,
IS_STATEFUL VARCHAR(1) NULL,
REQUESTS_RECOVERY VARCHAR(1) NULL,
PRIMARY KEY (ENTRY_ID)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_SCHEDULER_STATE
(
INSTANCE_NAME VARCHAR(100) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
PRIMARY KEY (INSTANCE_NAME)
)ENGINE=InnoDB;
CREATE TABLE pushmarketing_QRTZ_LOCKS
(
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (LOCK_NAME)
)ENGINE=InnoDB;
INSERT INTO pushmarketing_QRTZ_LOCKS values('TRIGGER_ACCESS');
INSERT INTO pushmarketing_QRTZ_LOCKS values('JOB_ACCESS');
INSERT INTO pushmarketing_QRTZ_LOCKS values('CALENDAR_ACCESS');
INSERT INTO pushmarketing_QRTZ_LOCKS values('STATE_ACCESS');
INSERT INTO pushmarketing_QRTZ_LOCKS values('MISFIRE_ACCESS');
扫一扫
2285
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
