/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.6.26 : Database - shebao
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`shebao` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `shebao`;

/*Table structure for table `t_city_news` */

DROP TABLE IF EXISTS `t_city_news`;

CREATE TABLE `t_city_news` (
  `c_n_id` int(30) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(30) DEFAULT NULL,
  `nid` int(30) DEFAULT NULL,
  PRIMARY KEY (`c_n_id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8;

/*Data for the table `t_city_news` */

insert  into `t_city_news`(`c_n_id`,`cid`,`nid`) values (304,1001,220),(305,1001,222);

/*Table structure for table `t_news` */

DROP TABLE IF EXISTS `t_news`;

CREATE TABLE `t_news` (
  `nid` int(30) unsigned NOT NULL AUTO_INCREMENT COMMENT '标识ID',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `publish_time` datetime DEFAULT NULL,
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;

/*Data for the table `t_news` */

insert  into `t_news`(`nid`,`title`,`content`,`publish_time`) values (220,'test','test','2015-09-29 14:41:55'),(221,'test','','2015-10-04 11:20:52'),(222,'test','to guangzhou','2015-10-04 11:21:05');

/*Table structure for table `t_sb_buy` */

DROP TABLE IF EXISTS `t_sb_buy`;

CREATE TABLE `t_sb_buy` (
  `buy_no` varchar(32) NOT NULL DEFAULT '0' COMMENT '用于支付的订单号',
  `pay_uid` int(10) unsigned NOT NULL COMMENT '支付人ID',
  `pay_channel` tinyint(3) unsigned NOT NULL,
  `id_card` varchar(20) NOT NULL COMMENT '身份证',
  `start_month` mediumint(8) unsigned NOT NULL COMMENT '购买的月份',
  `month_num` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '月份数',
  `pay_for` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cid` int(10) unsigned NOT NULL COMMENT '社保数据ID',
  `hukou` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '户籍性质',
  `total_fee` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本单总金额',
  `shebaos` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月社保金额',
  `shebao_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月手续费',
  `funds` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月公积金金额',
  `fund_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月服务费',
  `card_charge` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '新办卡服务费',
  `new_card` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否办卡',
  `pay_no` varchar(128) NOT NULL DEFAULT '' COMMENT '第三方支付订单号',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态',
  `gen_date` int(10) unsigned NOT NULL COMMENT '购买日期',
  `gen_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`buy_no`),
  KEY `buy_month_idx` (`start_month`),
  KEY `buy_date_idx` (`gen_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付表';

/*Data for the table `t_sb_buy` */

insert  into `t_sb_buy`(`buy_no`,`pay_uid`,`pay_channel`,`id_card`,`start_month`,`month_num`,`pay_for`,`cid`,`hukou`,`total_fee`,`shebaos`,`shebao_charge`,`funds`,`fund_charge`,`card_charge`,`new_card`,`pay_no`,`status`,`gen_date`,`gen_time`) values ('B010000000107201510',1000004,11,'440682199001016789',201510,1,1,11,1,0.01,783.33,59.00,0.00,0.00,0.00,1,'2015101100001000980062896834',2,20151011,'2015-10-11 10:19:14'),('B010000000107201512',1000004,1,'440682199001016789',201512,2,1,10,1,0.01,900.56,59.00,0.00,0.00,0.00,0,'',1,20151010,'2015-10-10 10:40:04'),('B010000000107201604',1000004,1,'440682199001016789',201604,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151009,'2015-10-09 14:41:46'),('B010000000113201510',1000004,11,'440682199001015678',201510,1,1,7,3,0.01,1261.96,59.00,0.00,0.00,0.00,0,'',1,20151009,'2015-10-09 14:55:30'),('B010000000127201510',1000006,1,'440222198404060315',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151010,'2015-10-10 17:11:20'),('B010000000127201511',1000006,1,'440222198404060315',201511,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'1006930382201510091140585558',2,20151009,'2015-10-09 17:10:19'),('B010000000127201512',1000006,1,'440222198404060315',201512,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151009,'2015-10-09 17:21:43'),('B010000000127201601',1000006,1,'440222198404060315',201601,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151009,'2015-10-09 17:22:25'),('B010000000134201608',1000004,1,'440682198503083561',201608,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'t1444373150787',2,20160813,'2016-08-13 12:15:12'),('B010000000134201609',1000004,1,'440682198503083561',201609,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'t1444373215134',2,20160913,'2016-09-13 12:15:12'),('B010000000136201610',1000004,1,'440682198503083555',201610,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'t1444374402804',2,20161013,'2016-10-13 12:15:12'),('B010000000137201611',1000004,1,'440682198503083566',201611,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'t1444375328696',2,20161113,'2016-11-13 12:15:12'),('B010000000141201510',1000007,11,'430723198305296215',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151009,'2015-10-09 11:20:39'),('B010000000142201510',1000007,1,'43072319910929641X',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'1003610382201510091136812596',2,20151009,'2015-10-09 11:32:35'),('B010000000144201510',1000004,1,'360124198707251511',201510,2,1,9,4,0.01,804.57,59.00,0.00,0.00,10.00,1,'1004080382201510101150056347',2,20151010,'2015-10-10 15:07:26'),('B020000000101201510',1000001,11,'372324199209294438',201510,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:16:31'),('B020000000101201512',1000001,1,'372324199209294438',201512,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:13:40'),('B020000000101201602',1000001,1,'372324199209294438',201602,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:14:28'),('B020000000101201603',1000001,1,'372324199209294438',201603,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:14:15'),('B020000000107201510',1000004,11,'440682199001016789',201510,1,2,17,1,0.01,0.00,0.00,169.00,59.00,0.00,0,'2015101000001000980062876842',2,20151010,'2015-10-10 15:36:10'),('B020000000107201512',1000004,1,'440682199001016789',201512,1,2,10,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'',1,20151010,'2015-10-10 10:38:51'),('B020000000113201510',1000004,11,'440682199001015678',201510,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:03:20'),('B020000000125201510',1000002,11,'342564286438524583',201510,1,2,1,1,0.01,0.00,0.00,2000.00,59.00,0.00,0,'',1,20151009,'2015-10-09 11:27:36'),('B020000000127201510',1000006,1,'440222198404060315',201510,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'',1,20151009,'2015-10-09 20:48:50'),('B020000000134201609',1000004,1,'440682198503083561',201609,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'t1444373729894',2,20160913,'2016-09-13 12:15:12'),('B020000000134201610',1000004,1,'440682198503083561',201610,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'t1444373720463',2,20161013,'2016-10-13 12:15:12'),('B020000000136201611',1000004,1,'440682198503083555',201611,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'t1444374958441',2,20161113,'2016-11-13 12:15:12'),('B020000000137201610',1000004,1,'440682198503083566',201610,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'t1444375321797',2,20161013,'2016-10-13 12:15:12'),('B020000000143201510',1000009,1,'370303198803156013',201510,1,2,7,1,0.01,0.00,0.00,1234.00,59.00,0.00,0,'',1,20151009,'2015-10-09 17:21:08'),('B030000000107201510',1000004,11,'440682199001016789',201510,2,3,10,4,0.01,900.56,59.00,200.00,40.00,10.00,1,'',1,20151010,'2015-10-10 10:32:51'),('B030000000127201510',1000006,1,'440222198404060315',201510,1,3,1,1,0.01,1035.67,59.00,200.00,40.00,10.00,1,'',1,20151009,'2015-10-09 17:07:24'),('B030000000135201609',1000004,1,'440682198503083522',201609,1,3,1,1,0.01,990.30,40.00,1000.30,59.00,0.00,0,'t1444373990147',2,20160913,'2016-09-13 12:15:12'),('B030000000135201610',1000004,1,'440682198503083522',201610,1,3,1,1,0.01,990.30,40.00,1000.30,59.00,0.00,0,'t1444374003791',2,20161013,'2016-10-13 12:15:12'),('B030000000136201609',1000004,1,'440682198503083555',201609,1,3,1,1,0.01,990.30,40.00,1000.30,59.00,0.00,0,'t1444374387225',2,20160913,'2016-09-13 12:15:12'),('B030000000137201609',1000004,1,'440682198503083566',201609,1,3,1,1,0.01,990.30,40.00,1000.30,59.00,0.00,0,'t1444375313772',2,20160913,'2016-09-13 12:15:12'),('B030000000141201510',1000007,11,'430723198305296215',201510,1,3,1,1,0.01,1035.67,59.00,200.00,40.00,10.00,1,'',1,20151009,'2015-10-09 10:49:32'),('B030000000142201511',1000007,11,'43072319910929641X',201511,1,3,1,1,0.01,1035.67,59.00,200.00,40.00,0.00,0,'2015100900001000270003142566',2,20151009,'2015-10-09 12:05:11'),('B030000000144201510',1000004,1,'360124198707251511',201510,1,3,10,1,0.01,900.56,59.00,200.00,40.00,10.00,1,'',1,20151010,'2015-10-10 10:42:10'),('B030000000144201512',1000004,11,'360124198707251511',201512,2,3,11,2,0.01,783.33,59.00,300.00,40.00,10.00,1,'2015101000001000980062876493',2,20151010,'2015-10-10 15:21:18'),('B030000000144201602',1000004,11,'360124198707251511',201602,1,3,7,1,0.01,1261.96,40.00,500.00,59.00,0.00,0,'2015101000001000980062876615',2,20151010,'2015-10-10 15:27:15'),('B030000000144201603',1000004,1,'360124198707251511',201603,2,3,17,1,0.01,1069.08,40.00,169.00,59.00,0.00,0,'1004080382201510101150272340',2,20151010,'2015-10-10 15:29:42');

/*Table structure for table `t_sb_buy_order` */

DROP TABLE IF EXISTS `t_sb_buy_order`;

CREATE TABLE `t_sb_buy_order` (
  `order_no` varchar(32) NOT NULL COMMENT '子订单号',
  `buy_no` varchar(32) NOT NULL COMMENT '购买订单号',
  `pay_uid` int(10) unsigned NOT NULL COMMENT '支付人',
  `id_card` varchar(20) NOT NULL COMMENT '身份证',
  `city_code` smallint(6) NOT NULL COMMENT '城市代码',
  `pay_for` tinyint(1) NOT NULL COMMENT '对象(社保、公积金)',
  `for_month` int(10) unsigned NOT NULL COMMENT '月份201506',
  `shebaos` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本月参保社保',
  `shebao_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '社保服务费',
  `funds` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本月缴存公积金',
  `fund_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '服务费',
  `card_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '办卡服务费',
  `new_card` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否办卡',
  `isAuto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自动代扣生成',
  `status` tinyint(4) NOT NULL DEFAULT '2' COMMENT '状态(已支付成功)',
  `gen_time` datetime NOT NULL COMMENT '生成时间',
  PRIMARY KEY (`order_no`),
  KEY `buy_order_uid_idx` (`pay_uid`),
  KEY `buy_order_month_idx` (`for_month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付订单成功后的子订单';

/*Data for the table `t_sb_buy_order` */

insert  into `t_sb_buy_order`(`order_no`,`buy_no`,`pay_uid`,`id_card`,`city_code`,`pay_for`,`for_month`,`shebaos`,`shebao_charge`,`funds`,`fund_charge`,`card_charge`,`new_card`,`isAuto`,`status`,`gen_time`) values ('010000000107201510','B010000000107201510',1000004,'440682199001016789',1008,1,201510,783.33,59.00,0.00,0.00,0.00,1,0,2,'2015-10-11 10:19:27'),('010000000127201511','B010000000127201511',1000006,'440222198404060315',1001,1,201511,1035.67,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 17:10:36'),('010000000134201608','B010000000134201608',1000004,'440682198503083561',1001,1,201608,990.30,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 14:45:51'),('010000000134201609','B010000000134201609',1000004,'440682198503083561',1001,1,201609,990.30,59.00,0.00,0.00,0.00,0,0,4,'2015-10-09 14:46:55'),('010000000135201609','B030000000135201609',1000004,'440682198503083522',1001,1,201609,990.30,40.00,0.00,0.00,0.00,0,0,2,'2015-10-09 14:59:50'),('010000000135201610','B030000000135201610',1000004,'440682198503083522',1001,1,201610,990.30,40.00,0.00,0.00,0.00,0,0,2,'2015-10-09 15:00:04'),('010000000136201609','B030000000136201609',1000004,'440682198503083555',1001,1,201609,990.30,40.00,0.00,0.00,0.00,0,0,2,'2015-10-09 15:06:27'),('010000000136201610','B010000000136201610',1000004,'440682198503083555',1001,1,201610,990.30,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 15:06:43'),('010000000137201609','B030000000137201609',1000004,'440682198503083566',1001,1,201609,990.30,40.00,0.00,0.00,0.00,0,0,2,'2015-10-09 15:21:54'),('010000000137201611','B010000000137201611',1000004,'440682198503083566',1001,1,201611,990.30,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 15:22:09'),('010000000142201510','B010000000142201510',1000007,'43072319910929641X',1001,1,201510,1035.67,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 11:32:49'),('010000000142201511','B030000000142201511',1000007,'43072319910929641X',1001,1,201511,1035.67,59.00,0.00,0.00,0.00,0,0,2,'2015-10-09 12:05:19'),('010000000144201510','B010000000144201510',1000004,'360124198707251511',1005,1,201510,804.57,59.00,0.00,0.00,10.00,1,0,2,'2015-10-10 15:08:11'),('010000000144201511','B010000000144201510',1000004,'360124198707251511',1005,1,201511,804.57,59.00,0.00,0.00,0.00,0,0,2,'2015-10-10 15:08:11'),('010000000144201512','B030000000144201512',1000004,'360124198707251511',1008,1,201512,783.33,59.00,0.00,0.00,10.00,1,0,2,'2015-10-10 15:21:37'),('010000000144201601','B030000000144201512',1000004,'360124198707251511',1008,1,201601,783.33,59.00,0.00,0.00,0.00,0,0,2,'2015-10-10 15:21:37'),('010000000144201602','B030000000144201602',1000004,'360124198707251511',1101,1,201602,1261.96,40.00,0.00,0.00,0.00,0,0,2,'2015-10-10 15:27:29'),('010000000144201603','B030000000144201603',1000004,'360124198707251511',1301,1,201603,1069.08,40.00,0.00,0.00,0.00,0,0,2,'2015-10-10 15:29:49'),('010000000144201604','B030000000144201603',1000004,'360124198707251511',1301,1,201604,1069.08,40.00,0.00,0.00,0.00,0,0,2,'2015-10-10 15:29:49'),('020000000107201510','B020000000107201510',1000004,'440682199001016789',1301,2,201510,0.00,0.00,169.00,59.00,0.00,0,0,2,'2015-10-10 15:36:20'),('020000000134201609','B020000000134201609',1000004,'440682198503083561',1001,2,201609,0.00,0.00,1000.00,59.00,0.00,0,0,2,'2015-10-09 14:55:30'),('020000000134201610','B020000000134201610',1000004,'440682198503083561',1001,2,201610,0.00,0.00,1000.00,59.00,0.00,0,0,2,'2015-10-09 14:55:20'),('020000000135201609','B030000000135201609',1000004,'440682198503083522',1001,2,201609,0.00,0.00,1000.30,59.00,0.00,0,0,2,'2015-10-09 14:59:50'),('020000000135201610','B030000000135201610',1000004,'440682198503083522',1001,2,201610,0.00,0.00,1000.30,59.00,0.00,0,0,2,'2015-10-09 15:00:04'),('020000000136201609','B030000000136201609',1000004,'440682198503083555',1001,2,201609,0.00,0.00,1000.30,59.00,0.00,0,0,2,'2015-10-09 15:06:27'),('020000000136201611','B020000000136201611',1000004,'440682198503083555',1001,2,201611,0.00,0.00,1000.00,59.00,0.00,0,0,2,'2015-10-09 15:15:58'),('020000000137201609','B030000000137201609',1000004,'440682198503083566',1001,2,201609,0.00,0.00,1000.30,59.00,0.00,0,0,2,'2015-10-09 15:21:54'),('020000000137201610','B020000000137201610',1000004,'440682198503083566',1001,2,201610,0.00,0.00,1000.00,59.00,0.00,0,0,2,'2015-10-09 15:22:02'),('020000000142201511','B030000000142201511',1000007,'43072319910929641X',1001,2,201511,0.00,0.00,200.00,40.00,0.00,0,0,2,'2015-10-09 12:05:19'),('020000000144201512','B030000000144201512',1000004,'360124198707251511',1008,2,201512,0.00,0.00,300.00,40.00,0.00,0,0,2,'2015-10-10 15:21:37'),('020000000144201601','B030000000144201512',1000004,'360124198707251511',1008,2,201601,0.00,0.00,300.00,40.00,0.00,0,0,2,'2015-10-10 15:21:37'),('020000000144201602','B030000000144201602',1000004,'360124198707251511',1101,2,201602,0.00,0.00,500.00,59.00,0.00,0,0,2,'2015-10-10 15:27:29'),('020000000144201603','B030000000144201603',1000004,'360124198707251511',1301,2,201603,0.00,0.00,169.00,59.00,0.00,0,0,2,'2015-10-10 15:29:49'),('020000000144201604','B030000000144201603',1000004,'360124198707251511',1301,2,201604,0.00,0.00,169.00,59.00,0.00,0,0,2,'2015-10-10 15:29:49');

/*Table structure for table `t_sb_buy_payer` */

DROP TABLE IF EXISTS `t_sb_buy_payer`;

CREATE TABLE `t_sb_buy_payer` (
  `buy_no` varchar(32) NOT NULL,
  `pay_uid` int(10) unsigned NOT NULL,
  `pay_channel` varchar(32) NOT NULL,
  `buyer_id` varchar(32) DEFAULT NULL COMMENT '支付宝用户号/腾讯openID',
  `buyer_acc` varchar(32) DEFAULT NULL COMMENT '帐号、邮箱等',
  PRIMARY KEY (`buy_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付成功后的相关信息';

/*Data for the table `t_sb_buy_payer` */

/*Table structure for table `t_sb_buy_user` */

DROP TABLE IF EXISTS `t_sb_buy_user`;

CREATE TABLE `t_sb_buy_user` (
  `buy_no` varchar(32) NOT NULL COMMENT '购买订单号',
  `id_card` varchar(20) NOT NULL COMMENT '身份证',
  `user_name` varchar(32) NOT NULL COMMENT '订单受益人姓名',
  `nation` varchar(20) NOT NULL COMMENT '民族',
  `gender` tinyint(1) NOT NULL COMMENT '性别',
  `phone` varchar(16) NOT NULL COMMENT '联系方式',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `recon_result` tinyint(4) NOT NULL DEFAULT '0' COMMENT '核对结果',
  PRIMARY KEY (`buy_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='参保人资料';

/*Data for the table `t_sb_buy_user` */

insert  into `t_sb_buy_user`(`buy_no`,`id_card`,`user_name`,`nation`,`gender`,`phone`,`modify_time`,`recon_result`) values ('B010000000107201510','440682199001016789','周四','汉',0,'18664850868',NULL,0),('B010000000127201511','440222198404060315','赖先生','汉',1,'18818869897',NULL,0),('B010000000134201608','440682198503083561','ren3561','huan',1,'18664850868',NULL,0),('B010000000134201609','440682198503083561','ren3561','huan',1,'18664850868',NULL,0),('B010000000136201610','440682198503083555','ren3555','huan',1,'18664850868',NULL,0),('B010000000137201611','440682198503083566','ren3566','huan',1,'18664850868',NULL,0),('B010000000142201510','43072319910929641X','张三','汉',1,'13212345678',NULL,0),('B010000000144201510','360124198707251511','安卓最后的测试二','汉',1,'18664850868',NULL,0),('B020000000107201510','440682199001016789','周四','汉',0,'18664850868',NULL,0),('B020000000134201609','440682198503083561','ren3561','huan',1,'18664850868',NULL,0),('B020000000134201610','440682198503083561','ren3561','huan',1,'18664850868',NULL,0),('B020000000136201611','440682198503083555','ren3555','huan',1,'18664850868',NULL,0),('B020000000137201610','440682198503083566','ren3566','huan',1,'18664850868',NULL,0),('B030000000135201609','440682198503083522','ren3522','huan',1,'18664850868',NULL,0),('B030000000135201610','440682198503083522','ren3522','huan',1,'18664850868',NULL,0),('B030000000136201609','440682198503083555','ren3555','huan',1,'18664850868',NULL,0),('B030000000137201609','440682198503083566','ren3566','huan',1,'18664850868',NULL,0),('B030000000142201511','43072319910929641X','张三','汉',1,'13212345678',NULL,0),('B030000000144201512','360124198707251511','安卓最后的测试二','汉',1,'18664850868',NULL,0),('B030000000144201602','360124198707251511','安卓最后的测试二','汉',1,'18664850868',NULL,0),('B030000000144201603','360124198707251511','安卓最后的测试二','汉',1,'18664850868',NULL,0);

/*Table structure for table `t_sb_city` */

DROP TABLE IF EXISTS `t_sb_city`;

CREATE TABLE `t_sb_city` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `city_code` smallint(6) NOT NULL COMMENT '城市编码',
  `shebao_type` varchar(32) DEFAULT '' COMMENT '社保类型(标准、豪华等)',
  `proxy_type` tinyint(3) unsigned DEFAULT NULL COMMENT '代理员工增减员方式1~8',
  `shebao_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的社保服务费',
  `shebao_card_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的代办社保卡服务费',
  `fund_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的公积金服务费',
  `package_charge` decimal(6,2) DEFAULT NULL COMMENT '社保、公积金打包服务费',
  `end_date` tinyint(4) DEFAULT NULL COMMENT '月购买日期区分',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='各城市、户藉的社保数据--主表';

/*Data for the table `t_sb_city` */

insert  into `t_sb_city`(`id`,`city_code`,`shebao_type`,`proxy_type`,`shebao_charge`,`shebao_card_charge`,`fund_charge`,`package_charge`,`end_date`,`update_time`) values (1,1001,'标准',1,59.00,0.00,59.00,99.00,0,'2015-10-11 09:55:34'),(4,1002,'标准',1,59.00,0.00,59.00,99.00,15,'2015-10-11 09:55:55'),(6,1003,'标准',0,59.00,20.00,59.00,99.00,0,'2015-10-11 09:56:22'),(7,1101,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:56:33'),(8,1004,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:56:49'),(9,1005,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:57:02'),(10,1007,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:57:17'),(11,1008,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:57:40'),(12,1009,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:57:56'),(13,1010,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:58:10'),(14,1011,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:58:39'),(15,1012,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:58:56'),(16,1013,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:59:12'),(17,1301,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:59:26'),(18,1014,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-11 09:59:42');

/*Table structure for table `t_sb_city_data` */

DROP TABLE IF EXISTS `t_sb_city_data`;

CREATE TABLE `t_sb_city_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL COMMENT '见T_SB_CITY',
  `hukou_type` tinyint(4) NOT NULL COMMENT '户籍性质',
  `pension` varchar(64) DEFAULT NULL COMMENT '养老',
  `medical` varchar(64) DEFAULT NULL COMMENT '医疗',
  `lose_job` varchar(64) DEFAULT NULL COMMENT '失业保险',
  `birth` varchar(64) DEFAULT NULL COMMENT '生育保险',
  `injury` varchar(64) DEFAULT NULL COMMENT '工伤',
  `major` varchar(64) DEFAULT NULL COMMENT '住院/重大',
  `village` varchar(64) DEFAULT NULL COMMENT '农民工医疗',
  `supplement` decimal(8,2) DEFAULT NULL COMMENT '补充医疗',
  `disabled` decimal(8,2) DEFAULT NULL COMMENT '残保金',
  `fund` varchar(64) DEFAULT NULL COMMENT '公积金最低额度',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='各城市、户藉的社保数据(ID与各户籍性质的社保数据)';

/*Data for the table `t_sb_city_data` */

insert  into `t_sb_city_data`(`id`,`cid`,`hukou_type`,`pension`,`medical`,`lose_job`,`birth`,`injury`,`major`,`village`,`supplement`,`disabled`,`fund`) values (8,1,1,'{\"min\":2408.0,\"max\":24080.0,\"e\":14.0,\"p\":8.0}','{\"min\":3712.0,\"max\":37120.0,\"e\":8.0,\"p\":2.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":1.2,\"p\":0.5}','{\"min\":3712.0,\"max\":37120.0,\"e\":0.85,\"p\":0.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":0.5,\"p\":0.0}','{\"min\":6187.0,\"max\":9000.0,\"e\":0.26,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,45.37,'{\"min\":1895.0,\"max\":29040.0,\"e\":5.0,\"p\":5.0}'),(9,1,2,'{\"min\":2408.0,\"max\":24080.0,\"e\":14.0,\"p\":8.0}','{\"min\":3712.0,\"max\":37120.0,\"e\":8.0,\"p\":2.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":1.2,\"p\":0.5}','{\"min\":3712.0,\"max\":37120.0,\"e\":0.85,\"p\":0.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":0.5,\"p\":0.0}','{\"min\":6187.0,\"max\":5000.0,\"e\":0.26,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,45.37,'{\"min\":1895.0,\"max\":29040.0,\"e\":5.0,\"p\":5.0}'),(10,1,3,'{\"min\":2408.0,\"max\":24080.0,\"e\":14.0,\"p\":8.0}','{\"min\":3712.0,\"max\":37120.0,\"e\":8.0,\"p\":2.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":1.2,\"p\":0.5}','{\"min\":3712.0,\"max\":37120.0,\"e\":0.85,\"p\":0.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":0.5,\"p\":0.0}','{\"min\":6187.0,\"max\":9000.0,\"e\":0.26,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":10.0,\"p\":0.0}',0.00,45.37,'{\"min\":1895.0,\"max\":29040.0,\"e\":5.0,\"p\":5.0}'),(11,1,4,'{\"min\":2408.0,\"max\":24080.0,\"e\":14.0,\"p\":8.0}','{\"min\":3712.0,\"max\":37120.0,\"e\":8.0,\"p\":2.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":1.2,\"p\":0.5}','{\"min\":3712.0,\"max\":37120.0,\"e\":0.85,\"p\":0.0}','{\"min\":1895.0,\"max\":18950.0,\"e\":0.5,\"p\":0.0}','{\"min\":6187.0,\"max\":9000.0,\"e\":0.26,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,45.37,'{\"min\":1895.0,\"max\":29040.0,\"e\":5.0,\"p\":5.0}'),(12,4,1,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":24080.0,\"e\":6.5,\"p\":2.0}','{\"min\":2408.0,\"max\":24080.0,\"e\":1.0,\"p\":0.5}','{\"min\":2408.0,\"max\":24080.0,\"e\":1.0,\"p\":0.0}','{\"min\":2408.0,\"max\":24080.0,\"e\":0.5,\"p\":0.0}','{\"min\":2248.0,\"max\":22480.0,\"e\":0.6,\"p\":0.6}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,47.17,'{\"min\":1010.0,\"max\":18580.0,\"e\":8.0,\"p\":8.0}'),(13,4,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.5,\"p\":0.0}','{\"min\":2248.0,\"max\":2248.0,\"e\":0.6,\"p\":0.6}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,47.17,'{\"min\":1010.0,\"max\":18580.0,\"e\":8.0,\"p\":8.0}'),(14,4,3,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.5,\"p\":0.0}','{\"min\":2248.0,\"max\":2248.0,\"e\":0.6,\"p\":0.6}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,47.17,'{\"min\":1010.0,\"max\":18580.0,\"e\":8.0,\"p\":8.0}'),(15,4,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.5,\"p\":0.0}','{\"min\":2248.0,\"max\":2248.0,\"e\":0.6,\"p\":0.6}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,47.17,'{\"min\":1010.0,\"max\":18580.0,\"e\":8.0,\"p\":8.0}'),(20,7,1,'{\"min\":2585.0,\"max\":2585.0,\"e\":20.0,\"p\":8.0}','{\"min\":3878.0,\"max\":3878.0,\"e\":10.0,\"p\":2.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":1.0,\"p\":0.2}','{\"min\":3878.0,\"max\":3878.0,\"e\":0.8,\"p\":0.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',3.00,0.00,'{\"min\":4120.0,\"max\":46530.0,\"e\":5.0,\"p\":5.0}'),(21,7,2,'{\"min\":2585.0,\"max\":2585.0,\"e\":20.0,\"p\":8.0}','{\"min\":3878.0,\"max\":3878.0,\"e\":10.0,\"p\":2.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":1.0,\"p\":0.2}','{\"min\":3878.0,\"max\":3878.0,\"e\":0.8,\"p\":0.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',3.00,0.00,'{\"min\":4120.0,\"max\":46530.0,\"e\":5.0,\"p\":5.0}'),(22,7,3,'{\"min\":2585.0,\"max\":2585.0,\"e\":20.0,\"p\":8.0}','{\"min\":3878.0,\"max\":3878.0,\"e\":10.0,\"p\":2.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":1.0,\"p\":0.2}','{\"min\":3878.0,\"max\":3878.0,\"e\":0.8,\"p\":0.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',3.00,0.00,'{\"min\":4120.0,\"max\":46530.0,\"e\":5.0,\"p\":5.0}'),(23,7,4,'{\"min\":2585.0,\"max\":2585.0,\"e\":20.0,\"p\":8.0}','{\"min\":3878.0,\"max\":3878.0,\"e\":10.0,\"p\":2.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":1.0,\"p\":0.2}','{\"min\":3878.0,\"max\":3878.0,\"e\":0.8,\"p\":0.0}','{\"min\":2585.0,\"max\":2585.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',3.00,0.00,'{\"min\":4120.0,\"max\":46530.0,\"e\":5.0,\"p\":5.0}'),(24,6,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2450.0,\"max\":2450.0,\"e\":2.0,\"p\":0.5}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.41,'{\"min\":1520.0,\"max\":88540.0,\"e\":5.0,\"p\":5.0}'),(25,6,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2450.0,\"max\":2450.0,\"e\":2.0,\"p\":0.5}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.41,'{\"min\":1520.0,\"max\":88540.0,\"e\":5.0,\"p\":5.0}'),(26,6,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2450.0,\"max\":2450.0,\"e\":2.0,\"p\":0.5}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.41,'{\"min\":1520.0,\"max\":88540.0,\"e\":5.0,\"p\":5.0}'),(27,6,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2450.0,\"max\":2450.0,\"e\":2.0,\"p\":0.5}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":1510.0,\"max\":1510.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.41,'{\"min\":1520.0,\"max\":88540.0,\"e\":5.0,\"p\":5.0}'),(28,8,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":3136.0,\"max\":3136.0,\"e\":6.0,\"p\":2.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.8,\"p\":0.2}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.7,\"p\":0.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.4,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,48.88,'{\"min\":1660.0,\"max\":22705.0,\"e\":5.0,\"p\":5.0}'),(29,8,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":3136.0,\"max\":3136.0,\"e\":6.0,\"p\":2.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.8,\"p\":0.2}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.7,\"p\":0.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.4,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,48.88,'{\"min\":1660.0,\"max\":22705.0,\"e\":5.0,\"p\":5.0}'),(30,8,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":3136.0,\"max\":3136.0,\"e\":6.0,\"p\":2.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.8,\"p\":0.2}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.7,\"p\":0.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.4,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,48.88,'{\"min\":1660.0,\"max\":22705.0,\"e\":5.0,\"p\":5.0}'),(31,8,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":3136.0,\"max\":3136.0,\"e\":6.0,\"p\":2.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.8,\"p\":0.2}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.7,\"p\":0.0}','{\"min\":1650.0,\"max\":1650.0,\"e\":0.4,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,48.88,'{\"min\":1660.0,\"max\":22705.0,\"e\":5.0,\"p\":5.0}'),(32,9,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.5,\"p\":0.5}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.8,\"p\":0.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,38.03,'{\"min\":1350.0,\"max\":22249.15,\"e\":5.0,\"p\":5.0}'),(33,9,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.5,\"p\":0.5}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.8,\"p\":0.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,38.03,'{\"min\":1350.0,\"max\":22249.15,\"e\":5.0,\"p\":5.0}'),(34,9,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.5,\"p\":0.5}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.8,\"p\":0.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,38.03,'{\"min\":1350.0,\"max\":22249.15,\"e\":5.0,\"p\":5.0}'),(35,9,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.5,\"p\":0.5}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.8,\"p\":0.0}','{\"min\":1375.0,\"max\":1375.0,\"e\":1.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,38.03,'{\"min\":1350.0,\"max\":22249.15,\"e\":5.0,\"p\":5.0}'),(36,10,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2998.0,\"max\":2998.0,\"e\":6.2,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":3378.0,\"max\":3378.0,\"e\":0.5,\"p\":0.0}','{\"min\":2249.0,\"max\":2249.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',8.00,40.54,'{\"min\":1020.0,\"max\":23580.0,\"e\":5.0,\"p\":5.0}'),(37,10,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2998.0,\"max\":2998.0,\"e\":6.2,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":3378.0,\"max\":3378.0,\"e\":0.5,\"p\":0.0}','{\"min\":2249.0,\"max\":2249.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',8.00,40.54,'{\"min\":1020.0,\"max\":23580.0,\"e\":5.0,\"p\":5.0}'),(38,10,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2998.0,\"max\":2998.0,\"e\":6.2,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":3378.0,\"max\":3378.0,\"e\":0.5,\"p\":0.0}','{\"min\":2249.0,\"max\":2249.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',8.00,40.54,'{\"min\":1020.0,\"max\":23580.0,\"e\":5.0,\"p\":5.0}'),(39,10,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2998.0,\"max\":2998.0,\"e\":6.2,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":3378.0,\"max\":3378.0,\"e\":0.5,\"p\":0.0}','{\"min\":2249.0,\"max\":2249.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',8.00,40.54,'{\"min\":1020.0,\"max\":23580.0,\"e\":5.0,\"p\":5.0}'),(40,11,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":6.0,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2246.0,\"max\":2246.0,\"e\":1.0,\"p\":0.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,40.08,'{\"min\":1210.0,\"max\":31015.0,\"e\":10.0,\"p\":10.0}'),(41,11,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":6.0,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2246.0,\"max\":2246.0,\"e\":1.0,\"p\":0.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,40.08,'{\"min\":1210.0,\"max\":31015.0,\"e\":10.0,\"p\":10.0}'),(42,11,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":6.0,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2246.0,\"max\":2246.0,\"e\":1.0,\"p\":0.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,40.08,'{\"min\":1210.0,\"max\":31015.0,\"e\":10.0,\"p\":10.0}'),(43,11,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":6.0,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2246.0,\"max\":2246.0,\"e\":1.0,\"p\":0.0}','{\"min\":2246.0,\"max\":2246.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,40.08,'{\"min\":1210.0,\"max\":31015.0,\"e\":10.0,\"p\":10.0}'),(44,12,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.8,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',13.00,42.89,'{\"min\":1210.0,\"max\":22677.0,\"e\":8.0,\"p\":8.0}'),(45,12,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.8,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',13.00,42.89,'{\"min\":1210.0,\"max\":22677.0,\"e\":8.0,\"p\":8.0}'),(46,12,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.8,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',13.00,42.89,'{\"min\":1210.0,\"max\":22677.0,\"e\":8.0,\"p\":8.0}'),(47,12,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.8,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',13.00,42.89,'{\"min\":1210.0,\"max\":22677.0,\"e\":8.0,\"p\":8.0}'),(48,13,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":5.0,\"p\":1.5}','{\"min\":2265.0,\"max\":2265.0,\"e\":0.5,\"p\":0.25}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.7,\"p\":0.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',17.00,40.38,'{\"min\":1360.0,\"max\":30000.0,\"e\":5.0,\"p\":5.0}'),(49,13,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":5.0,\"p\":1.5}','{\"min\":2265.0,\"max\":2265.0,\"e\":0.5,\"p\":0.25}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.7,\"p\":0.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',17.00,40.38,'{\"min\":1360.0,\"max\":30000.0,\"e\":5.0,\"p\":5.0}'),(50,13,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":5.0,\"p\":1.5}','{\"min\":2265.0,\"max\":2265.0,\"e\":0.5,\"p\":0.25}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.7,\"p\":0.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',17.00,40.38,'{\"min\":1360.0,\"max\":30000.0,\"e\":5.0,\"p\":5.0}'),(51,13,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":5.0,\"p\":1.5}','{\"min\":2265.0,\"max\":2265.0,\"e\":0.5,\"p\":0.25}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.7,\"p\":0.0}','{\"min\":3776.0,\"max\":3776.0,\"e\":0.3,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',17.00,40.38,'{\"min\":1360.0,\"max\":30000.0,\"e\":5.0,\"p\":5.0}'),(52,14,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":6.3,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":1.5,\"p\":0.5}','{\"min\":2452.0,\"max\":2452.0,\"e\":1.0,\"p\":0.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,28.50,'{\"min\":0.0,\"max\":0.0,\"e\":5.0,\"p\":5.0}'),(53,14,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":6.3,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":1.5,\"p\":0.5}','{\"min\":2452.0,\"max\":2452.0,\"e\":1.0,\"p\":0.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,28.50,'{\"min\":0.0,\"max\":0.0,\"e\":5.0,\"p\":5.0}'),(54,14,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":6.3,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":1.5,\"p\":0.5}','{\"min\":2452.0,\"max\":2452.0,\"e\":1.0,\"p\":0.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,28.50,'{\"min\":0.0,\"max\":0.0,\"e\":5.0,\"p\":5.0}'),(55,14,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":6.3,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":1.5,\"p\":0.5}','{\"min\":2452.0,\"max\":2452.0,\"e\":1.0,\"p\":0.0}','{\"min\":2452.0,\"max\":2452.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,28.50,'{\"min\":0.0,\"max\":0.0,\"e\":5.0,\"p\":5.0}'),(56,15,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',66.00,44.90,'{\"min\":1210.0,\"max\":20440.0,\"e\":5.0,\"p\":5.0}'),(57,15,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',66.00,44.90,'{\"min\":1210.0,\"max\":20440.0,\"e\":5.0,\"p\":5.0}'),(58,15,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',66.00,44.90,'{\"min\":1210.0,\"max\":20440.0,\"e\":5.0,\"p\":5.0}'),(59,15,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":15.0,\"p\":8.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":6.5,\"p\":2.0}','{\"min\":1210.0,\"max\":1210.0,\"e\":1.5,\"p\":0.5}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":2453.0,\"max\":2453.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',66.00,44.90,'{\"min\":1210.0,\"max\":20440.0,\"e\":5.0,\"p\":5.0}'),(60,16,1,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2356.0,\"max\":2356.0,\"e\":6.5,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.5,\"p\":0.5}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.6,\"p\":0.0}','{\"min\":3927.0,\"max\":3927.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.70,'{\"min\":1360.0,\"max\":25240.0,\"e\":5.0,\"p\":5.0}'),(61,16,2,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2356.0,\"max\":2356.0,\"e\":6.5,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.5,\"p\":0.5}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.6,\"p\":0.0}','{\"min\":3927.0,\"max\":3927.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.70,'{\"min\":1360.0,\"max\":25240.0,\"e\":5.0,\"p\":5.0}'),(62,16,3,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2356.0,\"max\":2356.0,\"e\":6.5,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.5,\"p\":0.5}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.6,\"p\":0.0}','{\"min\":3927.0,\"max\":3927.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.70,'{\"min\":1360.0,\"max\":25240.0,\"e\":5.0,\"p\":5.0}'),(63,16,4,'{\"min\":2408.0,\"max\":2408.0,\"e\":13.0,\"p\":8.0}','{\"min\":2356.0,\"max\":2356.0,\"e\":6.5,\"p\":2.0}','{\"min\":1350.0,\"max\":1350.0,\"e\":0.5,\"p\":0.5}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":2408.0,\"max\":2408.0,\"e\":0.6,\"p\":0.0}','{\"min\":3927.0,\"max\":3927.0,\"e\":0.5,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,29.70,'{\"min\":1360.0,\"max\":25240.0,\"e\":5.0,\"p\":5.0}'),(64,17,1,'{\"min\":2342.3,\"max\":2342.3,\"e\":20.0,\"p\":8.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":8.0,\"p\":2.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.5,\"p\":0.5}','{\"min\":2342.3,\"max\":2342.3,\"e\":0.8,\"p\":0.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',90.00,0.00,'{\"min\":1680.0,\"max\":1690.0,\"e\":5.0,\"p\":5.0}'),(65,17,2,'{\"min\":2342.3,\"max\":2342.3,\"e\":20.0,\"p\":8.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":8.0,\"p\":2.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.5,\"p\":0.5}','{\"min\":2342.3,\"max\":2342.3,\"e\":0.8,\"p\":0.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',90.00,0.00,'{\"min\":1680.0,\"max\":1690.0,\"e\":5.0,\"p\":5.0}'),(66,17,3,'{\"min\":2342.3,\"max\":2342.3,\"e\":20.0,\"p\":8.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":8.0,\"p\":2.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.5,\"p\":0.5}','{\"min\":2342.3,\"max\":2342.3,\"e\":0.8,\"p\":0.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',90.00,0.00,'{\"min\":1680.0,\"max\":1690.0,\"e\":5.0,\"p\":5.0}'),(67,17,4,'{\"min\":2342.3,\"max\":2342.3,\"e\":20.0,\"p\":8.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":8.0,\"p\":2.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.5,\"p\":0.5}','{\"min\":2342.3,\"max\":2342.3,\"e\":0.8,\"p\":0.0}','{\"min\":2342.3,\"max\":2342.3,\"e\":1.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',90.00,0.00,'{\"min\":1680.0,\"max\":1690.0,\"e\":5.0,\"p\":5.0}'),(68,18,1,'{\"min\":2030.0,\"max\":2030.0,\"e\":14.0,\"p\":8.0}','{\"min\":3632.0,\"max\":3632.0,\"e\":6.2,\"p\":2.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.8,\"p\":1.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.0,\"p\":0.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":0.2,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,18.17,'{\"min\":2030.0,\"max\":22980.0,\"e\":5.0,\"p\":5.0}'),(69,18,2,'{\"min\":2030.0,\"max\":2030.0,\"e\":14.0,\"p\":8.0}','{\"min\":3632.0,\"max\":3632.0,\"e\":6.2,\"p\":2.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.8,\"p\":1.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.0,\"p\":0.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":0.2,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,18.17,'{\"min\":2030.0,\"max\":22980.0,\"e\":5.0,\"p\":5.0}'),(70,18,3,'{\"min\":2030.0,\"max\":2030.0,\"e\":14.0,\"p\":8.0}','{\"min\":3632.0,\"max\":3632.0,\"e\":6.2,\"p\":2.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.8,\"p\":1.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.0,\"p\":0.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":0.2,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,18.17,'{\"min\":2030.0,\"max\":22980.0,\"e\":5.0,\"p\":5.0}'),(71,18,4,'{\"min\":2030.0,\"max\":2030.0,\"e\":14.0,\"p\":8.0}','{\"min\":3632.0,\"max\":3632.0,\"e\":6.2,\"p\":2.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.8,\"p\":1.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":1.0,\"p\":0.0}','{\"min\":2030.0,\"max\":2030.0,\"e\":0.2,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,18.17,'{\"min\":2030.0,\"max\":22980.0,\"e\":5.0,\"p\":5.0}');

/*Table structure for table `t_sb_msg` */

DROP TABLE IF EXISTS `t_sb_msg`;

CREATE TABLE `t_sb_msg` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `u_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户标识',
  `msg_type` tinyint(3) unsigned NOT NULL COMMENT '消息类型',
  `platform` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '消息接收平台',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(512) NOT NULL COMMENT '内容',
  `gen_sec` int(10) unsigned NOT NULL COMMENT '生成时间-秒',
  `counts` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sended` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已发送',
  `send_time` datetime DEFAULT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

/*Data for the table `t_sb_msg` */

insert  into `t_sb_msg`(`id`,`u_id`,`msg_type`,`platform`,`title`,`content`,`gen_sec`,`counts`,`sended`,`send_time`) values (1,1000001,2,1,'这是测试','测试的内容，时间是估的。',1365656520,0,1,'2015-10-05 18:10:11'),(2,1000001,3,1,'测试2','好久邹久',1365656621,0,1,'2015-10-05 18:10:11'),(3,1000001,4,1,'第三条测试','这是第三条测试',1365675630,0,1,'2015-10-05 18:10:12'),(4,1000001,2,0,'【我的社保】 201512参保成功','【我的社保】感谢使用“我的社保”。恭喜您201512成功参保，参保人倪建勋，参保城市广州。',1444119259,0,1,'2015-10-08 15:02:10'),(5,1000001,2,0,'【我的社保】 201601参保成功','【我的社保】感谢使用“我的社保”。恭喜您201601成功参保，参保人倪建勋，参保城市珠海。',1444119614,0,1,'2015-10-08 15:02:10'),(6,1000001,2,0,'【我的社保】 201511参保成功','【我的社保】感谢使用“我的社保”。恭喜您201511成功参保，参保人倪建勋，参保城市广州。',1444122653,0,1,'2015-10-08 11:16:11'),(7,1000001,2,0,'【我的社保】 201511参保成功','【我的社保】感谢使用“我的社保”。恭喜您201511成功参保，参保人服务端价格，参保城市清远。',1444123101,0,1,'2015-10-08 11:16:11'),(8,1000001,4,0,'【我的社保】 201512参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201512,我们会有专人跟您沟通退款事宜。请耐心等待。',1444123283,0,1,'2015-10-08 11:16:12'),(9,1000001,4,0,'【我的社保】 201510参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201510,我们会有专人跟您沟通退款事宜。请耐心等待。',1444124581,0,1,'2015-10-08 11:16:12'),(10,1000001,4,0,'【我的社保】 201510参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201510,我们会有专人跟您沟通退款事宜。请耐心等待。',1444124666,0,1,'2015-10-08 11:16:12'),(11,1000001,4,0,'【我的社保】 201510参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201510,我们会有专人跟您沟通退款事宜。请耐心等待。',1444125851,0,1,'2015-10-08 11:16:12'),(12,1000001,4,0,'【我的社保】 201510参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201510,我们会有专人跟您沟通退款事宜。请耐心等待。',1444126035,0,1,'2015-10-08 11:16:12'),(13,1000001,4,0,'【我的社保】 201510参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201510,我们会有专人跟您沟通退款事宜。请耐心等待。',1444126074,0,1,'2015-10-08 11:16:13'),(14,1000002,2,0,'【我的社保】 201601参保成功','【我的社保】感谢使用“我的社保”。恭喜您201601成功参保，参保人八十，参保城市广州。',1444201647,0,1,'2015-10-08 18:24:10'),(15,1000004,4,0,'【我的社保】 201601参保失败','【我的社保】很遗憾，您的社保申请没有通过审批，原因是 201601,我们会有专人跟您沟通退款事宜。请耐心等待。',1444201791,0,1,'2015-10-08 19:14:10'),(16,1000001,2,0,'【我的社保】 201601参保成功','【我的社保】感谢使用“我的社保”。恭喜您201601成功参保，参保人服务端价格，参保城市珠海。',1444202285,0,1,'2015-10-08 15:48:10'),(17,1000006,2,0,'test08','test00008',1444201791,5,1,'2015-10-08 15:10:20'),(18,1000001,4,0,'22222222222222','test88888888888888888888',1444201791,0,1,'2015-10-08 15:56:30'),(19,1000004,2,0,'【我的社保】 201609参保成功','【我的社保】感谢使用“我的社保”。恭喜您201609成功参保，参保人ren3561，参保城市广州。',1444373696,0,1,'2015-10-09 14:56:10');

/*Table structure for table `t_sb_msg_city` */

DROP TABLE IF EXISTS `t_sb_msg_city`;

CREATE TABLE `t_sb_msg_city` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `citys` varchar(256) NOT NULL,
  `title` varchar(128) NOT NULL,
  `content` varchar(256) NOT NULL,
  `counts` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `sended` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `send_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='城市级消息';

/*Data for the table `t_sb_msg_city` */

insert  into `t_sb_msg_city`(`id`,`citys`,`title`,`content`,`counts`,`sended`,`send_time`) values (4,'1014,1001','测试城市消息推送测试城市消息推送','测试城市消息推送测试城市消息推送测试城市消息推送测试城市消息推送',0,1,'2015-10-05 17:10:41'),(5,'1101,1008,1009,1010,1007','测试信息001','测试测试。。。。。。。',0,1,'2015-10-09 16:10:11');

/*Table structure for table `t_sb_user` */

DROP TABLE IF EXISTS `t_sb_user`;

CREATE TABLE `t_sb_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `u_id` int(10) unsigned NOT NULL COMMENT '用户标识',
  `id_card` varchar(20) NOT NULL COMMENT '身份证号码',
  `user_name` varchar(12) NOT NULL COMMENT '姓名',
  `nation` varchar(16) DEFAULT NULL COMMENT '民族',
  `gender` tinyint(4) DEFAULT NULL COMMENT '性别',
  `phone` varchar(12) DEFAULT NULL COMMENT '联系电话',
  `shebao_card` varchar(24) DEFAULT NULL COMMENT '社保卡号',
  `id_card_img` varchar(256) DEFAULT NULL COMMENT '正反面身份证图片链接',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sb_user_uniq` (`u_id`,`id_card`),
  KEY `sb_user_uid` (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 COMMENT='参保人身份数据(一个用户标识可对应多个参保人信息)';

/*Data for the table `t_sb_user` */

insert  into `t_sb_user`(`id`,`u_id`,`id_card`,`user_name`,`nation`,`gender`,`phone`,`shebao_card`,`id_card_img`) values (99,1000001,'330322197709013638','倪建勋','汉',1,'13928550878',NULL,'/upload/card/1/10000010320136380.jpg#/upload/card/1/10000010320136381.jpg'),(100,1000001,'441900199112130735','涂冠杰','汉',1,'18665285417',NULL,'/upload/card/1/10000011901307350.jpg#/upload/card/1/10000011901307351.jpg'),(101,1000001,'372324199209294438','田厚超','汉',1,'13584549827',NULL,'/upload/card/1/10000012322944380.jpg#/upload/card/1/10000012322944381.jpg'),(102,1000001,'440682199001018888','周小姐','傣族',0,'18664850868',NULL,'/upload/card/1/10000010680188880.jpg#/upload/card/1/10000010680188881.jpg'),(103,1000001,'425344333543223433','不说句','汉族',1,'13952874571',NULL,'/upload/card/1/10000015342234330.jpg#/upload/card/1/10000015342234331.jpg'),(104,1000001,'440682199001018889','周小姐2','汉',0,'18664850868',NULL,'/upload/card/1/10000010680188880.jpg#/upload/card/1/10000010680188891.jpg'),(105,1000001,'444444444455555555','社保订单','汉',1,'13544449999','89000000','/upload/card/1/10000014445555550.jpg#/upload/card/1/10000014445555551.jpg'),(106,1000001,'111111111188888888','公积金','大韩',0,'18664850868',NULL,'/upload/card/1/10000011118888880.jpg#/upload/card/1/10000011118888881.jpg'),(107,1000004,'440682199001016789','周四','汉',0,'18664850868',NULL,'/upload/card/4/10000040680167890.jpg#/upload/card/4/10000040680167891.jpg'),(108,1000001,'440682199001015678','逻辑判断','韩',1,'18664850868',NULL,'/upload/card/1/10000010680156780.jpg#/upload/card/1/10000010680156781.jpg'),(109,1000001,'44068219910103258x','社保订单身份证更新','汉',0,'13544449999',NULL,'/upload/card/1/10000014445555550.jpg#/upload/card/1/10000014445555551.jpg'),(110,1000001,'44444444444444444','安卓测试','汉',0,'18664850868',NULL,'/upload/card/1/1000001444444440.jpg#/upload/card/1/1000001444444441.jpg'),(111,1000001,'444444444444444444','安卓测试','汉',0,'18664850868','0002980044566','/upload/card/1/10000014444444441.jpg#/upload/card/1/10000014444444441.jpg'),(112,1000001,'555555555555555555','社保和公积金安卓','维族',1,'18664850868',NULL,'/upload/card/1/10000015555555550.jpg#/upload/card/1/10000015555555551.jpg'),(113,1000004,'440682199001015678','参保人1','汉',1,'18664850868',NULL,'/upload/card/4/10000040680156780.jpg#/upload/card/4/10000040680156781.jpg'),(114,1000001,'334235796320642254','乔峰','贵族',1,'13256428456',NULL,'/upload/card/1/10000014236422540.jpg#/upload/card/1/10000014236422541.jpg'),(115,1000001,'46996346794673467','你干嘛','搞笑',0,'15696346497',NULL,'/upload/card/1/1000001996734671.jpg#/upload/card/1/1000001996734671.jpg'),(116,1000001,'123456789123456789','小米','小米',0,'13582467589',NULL,'/upload/card/1/10000013454567890.jpg#/upload/card/1/10000013454567891.jpg'),(117,1000001,'123456789012345678','服务端价格','汉',1,'18664850868',NULL,'/upload/card/1/10000013453456781.jpg#/upload/card/1/10000013453456781.jpg'),(118,1000001,'123456789011111111','服务端价格二','汉',1,'18664850868',NULL,'/upload/card/1/10000013453456781.jpg#/upload/card/1/10000013453456781.jpg'),(119,1000001,'111111111111111111','照片问题','汉',1,'18664850868',NULL,'/upload/card/1/10000011111111111.jpg#/upload/card/1/10000011111111111.jpg'),(120,1000001,'1111111112222222','霸气','汉',0,'18664850868',NULL,'/upload/card/1/100000111122221.jpg#/upload/card/1/100000111122221.jpg'),(121,1000001,'1111111111222222','啊','汉',0,'18664850868',NULL,'/upload/card/1/100000111122221.jpg#/upload/card/1/100000111122221.jpg'),(122,1000001,'222222222222222222','增员测试','大和',0,'18664850868',NULL,'/upload/card/1/10000012222222221.jpg#/upload/card/1/10000012222222221.jpg'),(123,1000001,'123456789011111122','服务端价格三','汉',0,'18664850868',NULL,'/upload/card/1/10000013453456781.jpg#/upload/card/1/10000013453456781.jpg'),(124,1000002,'342546425542453385','茶叶','汉语',0,'13452854286',NULL,'/upload/card/2/10000022544533850.jpg#/upload/card/2/10000022544533851.jpg'),(125,1000002,'342564286438524583','喝酒','毫无',0,'13894675894',NULL,'/upload/card/2/10000022565245830.jpg#/upload/card/2/10000022565245831.jpg'),(126,1000002,'134254679976438645','柚子','哈姆',0,'18765432109',NULL,'/upload/card/2/10000024254386450.jpg#/upload/card/2/10000024254386451.jpg'),(127,1000006,'440222198404060315','赖先生','汉',1,'18818869897',NULL,'/upload/card/6/10000060220603150.jpg#/upload/card/6/10000060220603151.jpg'),(128,1000001,'5555555555555555','八十','汉',1,'18664850868','点击编辑','/upload/card/1/100000155555550.jpg#/upload/card/1/100000155555551.jpg'),(129,1000001,'130425199306283453','增员二','汉',1,'18664850868',NULL,'/upload/card/1/10000010422834530.jpg#/upload/card/1/10000010422834531.jpg'),(130,1000002,'441900199112130735','涂冠杰','汉',1,'15634649764',NULL,'/upload/card/2/10000021901307350.jpg#/upload/card/2/10000021901307351.jpg'),(131,1000001,'372925198706090510','一年','汉',1,'18664850868',NULL,'/upload/card/1/10000012920905100.jpg#/upload/card/1/10000012920905101.jpg'),(132,1000002,'121212121212121212','乔峰','小贝',1,'13521212121',NULL,'/upload/card/2/10000021211212120.jpg#/upload/card/2/10000021211212121.jpg'),(133,1000001,'440682199909099999','安卓打包购','汉',1,'18664850868',NULL,'/upload/card/1/10000010680999990.jpg#/upload/card/1/10000010680999991.jpg'),(134,1000004,'440682198503083561','ren3561','huan',1,'18664850868','点击编辑','/upload/card/4/10000040680156780.jpg#/upload/card/4/10000040680156781.jpg'),(135,1000004,'440682198503083522','ren3522','huan',1,'18664850868',NULL,'/upload/card/4/10000040680156780.jpg#/upload/card/4/10000040680156781.jpg'),(136,1000004,'440682198503083555','ren3555','huan',1,'18664850868',NULL,'/upload/card/4/10000040680156780.jpg#/upload/card/4/10000040680156781.jpg'),(137,1000004,'440682198503083566','ren3566','huan',1,'18664850868',NULL,'/upload/card/4/10000040680156780.jpg#/upload/card/4/10000040680156781.jpg'),(138,1000001,'440682199501015678','增员成败','苗',1,'18664850867',NULL,'/upload/card/1/10000010680156780.jpg#/upload/card/1/10000010680156781.jpg'),(139,1000004,'440223198606063019','最后的苹果','汉',1,'18664850868',NULL,'/upload/card/4/10000040220630190.jpg#/upload/card/4/10000040220630191.jpg'),(140,1000004,'888888888888888888','最后的安卓','汉',0,'18664850868',NULL,'/upload/card/4/10000048888888880.jpg#/upload/card/4/10000048888888881.jpg'),(141,1000007,'430723198305296215','张三','汉',1,'13212345678',NULL,'/upload/card/7/10000070722962150.jpg#/upload/card/7/10000070722962151.jpg'),(142,1000007,'43072319910929641X','张三','汉',1,'13212345678',NULL,'/upload/card/7/10000070722962150.jpg#/upload/card/7/10000070722962151.jpg'),(143,1000009,'370303198803156013','韩星祥','汉',1,'13926332871',NULL,'/upload/card/9/10000090301560130.jpg#/upload/card/9/10000090301560131.jpg'),(144,1000004,'360124198707251511','安卓最后的测试二','汉',1,'18664850868',NULL,'/upload/card/4/10000040680167890.jpg#/upload/card/4/10000040680167891.jpg');

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `u_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '本系统的用户标识',
  `user_id` varchar(32) DEFAULT NULL COMMENT '兼容性用户ID',
  `phone` varchar(13) DEFAULT NULL COMMENT '手机号码',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `nick_name` varchar(20) DEFAULT NULL COMMENT '昵称',
  `head_img` varchar(64) NOT NULL DEFAULT '' COMMENT '头像图片链接',
  `reg_channel` varchar(12) NOT NULL DEFAULT '0' COMMENT '注册来源(手机注册、闪聘帐号、微信账号)',
  `reg_time` datetime DEFAULT NULL COMMENT '注册时间',
  `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  PRIMARY KEY (`u_id`),
  UNIQUE KEY `user_phone_idx` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=1000010 DEFAULT CHARSET=utf8 COMMENT='用户基本信息表';

/*Data for the table `t_user` */

insert  into `t_user`(`u_id`,`user_id`,`phone`,`password`,`nick_name`,`head_img`,`reg_channel`,`reg_time`,`login_time`) values (1000001,NULL,'15521109963','e10adc3949ba59abbe56e057f20f883e','18666507203','/upload/head/1/1000001.jpg','0','2015-09-15 20:11:20','2015-09-15 20:11:20'),(1000002,NULL,'13760659709','e10adc3949ba59abbe56e057f20f883e','18666507203','/upload/head/2/1000002.jpg','0','2015-09-23 17:51:38','2015-09-23 17:51:38'),(1000003,NULL,'15206643833','e10adc3949ba59abbe56e057f20f883e','15206643833','','0','2015-09-24 17:44:05','2015-09-24 17:44:05'),(1000004,NULL,'18664850868','e10adc3949ba59abbe56e057f20f883e','18664850868','','0','2015-09-29 14:59:23','2015-09-29 14:59:23'),(1000005,NULL,'13710785046','99d14adccd3b1dc99a6bff4e94c1d469','13710785046','/upload/head/5/1000005.jpg','0','2015-09-30 16:58:16','2015-09-30 16:58:16'),(1000006,NULL,'18818869897','e807f1fcf82d132f9bb018ca6738a19f','18818869897','','0','2015-09-30 17:25:10','2015-09-30 17:25:10'),(1000007,NULL,'18665689272','3b9ec2ad5ad1bdf19ca1b32023cff90d','18665689272','','0','2015-10-09 10:32:28','2015-10-09 10:32:28'),(1000008,NULL,'18702019482','e10adc3949ba59abbe56e057f20f883e','18702019482','','0','2015-10-09 16:47:55','2015-10-09 16:47:55'),(1000009,NULL,'18666507203','e10adc3949ba59abbe56e057f20f883e','18666507203','','0','2015-10-09 17:08:00','2015-10-09 17:08:00');

/*Table structure for table `t_user_flag` */

DROP TABLE IF EXISTS `t_user_flag`;

CREATE TABLE `t_user_flag` (
  `u_id` int(10) unsigned NOT NULL,
  `version` varchar(12) DEFAULT '1' COMMENT 'app版本',
  `platform` tinyint(1) unsigned DEFAULT NULL COMMENT 'app系统平台',
  `msg_read_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消息读取时间',
  `login_time` datetime NOT NULL COMMENT '登录时间',
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户标记表';

/*Data for the table `t_user_flag` */

insert  into `t_user_flag`(`u_id`,`version`,`platform`,`msg_read_time`,`login_time`) values (1000001,'1',1,1444267225,'2015-10-09 17:27:44'),(1000002,'1',2,1444299872,'2015-10-12 10:14:14'),(1000004,'1',1,1444373762,'2015-10-12 09:10:37'),(1000005,'1',1,0,'2015-10-06 19:58:45'),(1000006,'1',1,1444290179,'2015-10-10 17:10:47'),(1000007,'1',1,0,'2015-10-09 16:44:51'),(1000008,'1',1,0,'2015-10-09 16:47:55'),(1000009,'1',1,0,'2015-10-09 17:21:06');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
