shebao-server/docs/sql/db/shebao_data20151005_new.sql

/*
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 ('010000000099201510163287',1000001,11,'330322197709013638',201510,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'2015092100001000320069193588',2,20151003,'2015-09-21 16:55:33'),('020000000099201510',1000001,1,'330322197709013638',201510,1,2,1,1,0.01,0.00,0.00,888.00,59.00,0.00,0,'',1,20151003,'2015-09-24 16:19:01'),('020000000099201511',1000001,1,'330322197709013638',201511,1,2,1,1,0.01,0.00,0.00,369.00,59.00,0.00,0,'',1,20151003,'2015-09-24 17:40:58'),('020000000099201512',1000001,1,'330322197709013638',201512,1,2,1,1,0.01,0.00,0.00,369.00,59.00,0.00,0,'',1,20151003,'2015-09-24 17:40:25'),('020000000099201601',1000001,11,'330322197709013638',201601,1,2,1,1,0.01,0.00,59.00,200.00,0.00,0.00,0,'2015092200001000320069230805',2,20151003,'2015-09-22 17:12:17'),('020000000099201602',1000001,1,'330322197709013638',201602,1,2,1,1,0.01,0.00,59.00,560.00,0.00,0.00,0,'1001000382201509220959173039',2,20151003,'2015-09-22 17:49:30'),('020000000099201603',1000001,11,'330322197709013638',201603,1,2,1,1,0.01,0.00,59.00,2555.00,0.00,0.00,0,'2015092200001000320069232314',2,20151003,'2015-09-22 17:52:27'),('020000000100201510',1000001,11,'441900199112130735',201510,3,2,1,1,0.01,0.00,59.00,200.00,0.00,0.00,0,'2015092200001000320069226538',2,20151003,'2015-09-22 15:15:39'),('020000000100201511',1000001,11,'441900199112130735',201511,3,2,1,1,0.01,0.00,59.00,200.00,0.00,0.00,0,'',1,20151003,'2015-09-22 15:16:18'),('020000000100201512',1000001,1,'441900199112130735',201512,1,2,1,1,0.01,0.00,0.00,369.00,59.00,0.00,0,'',1,20151003,'2015-09-22 20:04:01'),('020000000101201510',1000001,1,'372324199209294438',201510,1,2,1,1,0.01,0.00,59.00,1234.00,0.00,0.00,0,'1001000382201509220959261015',2,20151003,'2015-09-22 17:55:38'),('020000000101201511',1000001,1,'372324199209294438',201511,1,2,1,1,0.01,0.00,0.00,958.00,59.00,0.00,0,'',1,20151003,'2015-09-24 16:16:37'),('020000000102201510',1000001,11,'440682199001018888',201510,1,2,1,1,0.01,0.00,0.00,300.00,59.00,0.00,0,'2015092800001000980062501419',2,20151003,'2015-09-28 11:51:20'),('020000000103201510',1000001,1,'425344333543223433',201510,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'',1,20151003,'2015-09-28 10:31:43'),('020000000104201510',1000001,11,'440682199001018889',201510,1,2,1,1,0.01,0.00,0.00,301.00,59.00,0.00,0,'2015092800001000980062507672',2,20151003,'2015-09-28 15:11:03'),('020000000104201511',1000001,11,'440682199001018889',201511,1,2,1,1,0.01,0.00,0.00,302.00,59.00,0.00,0,'2015092800001000980062507762',2,20151003,'2015-09-28 15:14:03'),('020000000106201510',1000001,1,'111111111188888888',201510,1,2,1,1,0.01,0.00,0.00,799.00,59.00,0.00,0,'',1,20151003,'2015-09-29 14:05:23'),('020000000106201511',1000001,11,'111111111188888888',201511,2,2,1,1,0.01,0.00,0.00,799.00,59.00,0.00,0,'2015092900001000980062533454',2,20151003,'2015-09-29 11:41:23'),('020000000106201601',1000001,11,'111111111188888888',201601,1,2,1,4,0.01,0.00,0.00,402.00,59.00,0.00,0,'2015092900001000980062534001',2,20151003,'2015-09-29 11:58:06'),('030000000099201501',1000001,11,'330322197709013638',201501,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-28 10:14:09'),('030000000099201509',1000001,1,'330322197709013638',20159,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-28 10:18:06'),('030000000099201511',1000001,11,'330322197709013638',201511,1,3,1,3,0.01,990.30,59.00,303.00,40.00,0.00,0,'',1,20151003,'2015-09-24 15:40:16'),('030000000099201512',1000001,1,'330322197709013638',201512,1,3,1,1,0.01,990.30,40.00,3000.00,59.00,0.00,0,'',1,20151003,'2015-09-24 14:22:36'),('030000000100201509',1000001,1,'441900199112130735',20159,2,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-28 10:34:59'),('030000000100201510',1000001,11,'441900199112130735',201510,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'2015092400001000980062379660',2,20151003,'2015-09-24 17:50:45'),('030000000100201512',1000001,1,'441900199112130735',201512,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-28 10:38:41'),('030000000100201603',1000001,1,'441900199112130735',201603,1,3,1,1,0.01,990.30,99.00,399.00,0.00,0.00,0,'1001000382201509220958091788',2,20151003,'2015-09-22 15:58:09'),('030000000101201510',1000001,11,'372324199209294438',201510,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-29 14:55:31'),('030000000101201601',1000001,1,'372324199209294438',201601,3,3,1,1,0.01,990.30,40.00,399.00,59.00,0.00,0,'1001000382201509230967120587',2,20151003,'2015-09-23 14:41:17'),('030000000102201510',1000001,11,'440682199001018888',201510,1,3,1,3,0.01,942.14,59.00,0.00,40.00,0.00,0,'2015092800001000980062499663',2,20151003,'2015-09-28 10:51:41'),('030000000102201511',1000001,11,'440682199001018888',201511,2,3,1,1,0.01,990.30,59.00,300.00,40.00,0.00,0,'2015092800001000980062501251',2,20151003,'2015-09-28 11:45:22'),('030000000102201601',1000001,11,'440682199001018888',201601,1,3,4,1,0.01,861.49,59.00,0.00,31.00,0.00,0,'2015092800001000980062506914',2,20151003,'2015-09-28 14:49:11'),('030000000103201510',1000001,1,'425344333543223433',201510,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-28 10:41:09'),('030000000104201510',1000001,11,'440682199001018889',201510,1,3,1,2,0.01,977.42,59.00,0.00,40.00,0.00,0,'2015092800001000980062507117',2,20151003,'2015-09-28 14:55:35'),('030000000104201511',1000001,11,'440682199001018889',201511,2,3,1,4,0.01,990.30,59.00,308.00,40.00,0.00,0,'2015092800001000980062508029',2,20151003,'2015-09-28 15:23:41'),('030000000105201510',1000001,11,'444444444455555555',201510,2,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'2015092900001000980062532928',2,20151003,'2015-09-29 11:24:38'),('030000000105201601',1000001,11,'444444444455555555',201601,1,3,1,3,0.01,5508.54,59.00,400.00,40.00,0.00,0,'2015092900001000980062533959',2,20151003,'2015-09-29 11:57:00'),('030000000106201510',1000001,11,'111111111188888888',201510,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-29 15:11:36'),('030000000106201602',1000001,11,'111111111188888888',201602,1,3,1,2,0.01,977.42,40.00,408.00,59.00,0.00,0,'2015092900001000980062534127',2,20151003,'2015-09-29 12:01:52'),('B010000000100201510',1000001,1,'441900199112130735',201510,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-09-30 15:46:04'),('B010000000100201511',1000001,1,'441900199112130735',201511,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-09-30 15:44:02'),('B010000000101201511',1000001,1,'372324199209294438',201511,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-09-30 16:53:17'),('B010000000105201602',1000001,11,'444444444455555555',201602,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-01 10:30:13'),('B010000000109201510',1000001,11,'44068219910103258x',201510,1,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-02 09:57:45'),('B010000000109201512',1000001,11,'44068219910103258x',201512,2,1,1,2,0.01,977.42,59.00,0.00,0.00,0.00,0,'2015093000001000980062581425',2,20151003,'2015-09-30 18:04:58'),('B010000000110201510',1000001,1,'44444444444444444',201510,1,1,1,3,0.01,5508.54,59.00,0.00,0.00,0.00,0,'1004080382201510011051262400',2,20151003,'2015-10-01 10:09:49'),('B010000000110201511',1000001,11,'44444444444444444',201511,1,1,4,3,0.01,861.49,59.00,0.00,0.00,0.00,0,'2015100100001000980062618514',2,20151003,'2015-10-01 17:14:19'),('B010000000110201602',1000001,11,'44444444444444444',201602,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'2015100200001000980062647415',2,20151003,'2015-10-02 14:31:21'),('B010000000111201510',1000001,11,'444444444444444444',201510,2,1,1,1,0.01,990.30,59.00,0.00,0.00,0.00,0,'2015100100001000980062603284',2,20151003,'2015-10-01 10:18:43'),('B010000000112201511',1000001,11,'555555555555555555',201511,1,1,8,1,0.01,840.09,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-02 14:59:52'),('B010000000113201510',1000004,11,'440682199001015678',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'2015100200001000980062650092',2,20151003,'2015-10-02 16:05:31'),('B010000000113201602',1000004,11,'440682199001015678',201602,1,1,11,2,0.01,783.33,59.00,0.00,0.00,0.00,0,'2015100200001000980062651570',2,20151003,'2015-10-02 16:50:51'),('B010000000115201510',1000001,11,'46996346794673467',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-02 22:23:10'),('B010000000117201510',1000001,11,'123456789012345678',201510,1,1,6,2,0.01,626.54,59.00,0.00,0.00,0.00,0,'2015100300001000980062681412',2,20151003,'2015-10-03 16:06:14'),('B010000000119201510',1000001,11,'111111111111111111',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-03 16:45:57'),('B010000000120201510',1000001,11,'1111111112222222',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-03 16:48:13'),('B010000000121201510',1000001,11,'1111111111222222',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151003,'2015-10-03 16:49:51'),('B010000000122201510',1000001,11,'222222222222222222',201510,2,1,4,2,0.01,856.75,59.00,0.00,0.00,0.00,0,'2015100300001000980062691457',2,20151003,'2015-10-03 22:03:58'),('B010000000124201510',1000002,11,'342546425542453385',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,10.00,1,'',1,20151004,'2015-10-04 16:56:08'),('B010000000127201510',1000006,1,'440222198404060315',201510,1,1,1,1,0.01,1035.67,59.00,0.00,0.00,0.00,0,'',1,20151004,'2015-10-04 16:03:05'),('B010000000128201510',1000001,1,'5555555555555555',201510,1,1,6,1,0.01,626.54,59.00,0.00,0.00,0.00,0,'1004080382201510041086673308',2,20151004,'2015-10-04 16:07:31'),('B010000000129201510',1000001,1,'130425199306283453',201510,2,1,14,1,0.01,849.64,59.00,0.00,0.00,0.00,0,'1004080382201510041088840149',2,20151004,'2015-10-04 19:12:30'),('B020000000099201510',1000001,11,'330322197709013638',201510,1,2,1,1,0.01,0.00,0.00,1235.00,59.00,0.00,0,'',1,20151004,'2015-10-04 11:05:13'),('B020000000099201512',1000001,11,'330322197709013638',201512,1,2,1,1,0.01,0.00,0.00,50.00,59.00,0.00,0,'2015093000001000980062575495',2,20151003,'2015-09-30 15:19:49'),('B020000000101201511',1000001,11,'372324199209294438',201511,1,2,1,1,0.01,0.00,0.00,333.00,59.00,0.00,0,'',1,20151003,'2015-09-30 16:54:13'),('B020000000101201512',1000001,1,'372324199209294438',201512,1,2,1,1,0.01,0.00,0.00,333.00,59.00,0.00,0,'1004260382201509301044319643',2,20151003,'2015-09-30 16:22:57'),('B020000000104201601',1000001,1,'440682199001018889',201601,1,2,1,1,0.01,0.00,0.00,399.00,59.00,0.00,0,'',1,20151003,'2015-09-30 10:10:42'),('B020000000108201510',1000001,11,'440682199001015678',201510,1,2,1,1,0.01,0.00,0.00,333.00,59.00,0.00,0,'',1,20151003,'2015-10-03 16:02:34'),('B020000000109201512',1000001,11,'44068219910103258x',201512,2,2,1,1,0.01,0.00,0.00,50.00,59.00,0.00,0,'2015093000001000980062584000',2,20151003,'2015-09-30 19:16:39'),('B020000000112201512',1000001,1,'555555555555555555',201512,1,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'',1,20151003,'2015-10-02 16:16:12'),('B020000000112201602',1000001,1,'555555555555555555',201602,1,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'',1,20151003,'2015-10-02 16:15:16'),('B020000000113201601',1000004,11,'440682199001015678',201601,1,2,10,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100200001000980062651115',2,20151003,'2015-10-02 16:39:45'),('B020000000113201603',1000004,11,'440682199001015678',201603,1,2,11,1,0.01,0.00,0.00,300.00,59.00,0.00,0,'2015100200001000980062651591',2,20151003,'2015-10-02 16:53:50'),('B020000000114201510',1000001,11,'334235796320642254',201510,1,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'',1,20151003,'2015-10-02 16:44:05'),('B020000000114201511',1000001,11,'334235796320642254',201511,1,2,4,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100200001000980062653060',2,20151003,'2015-10-02 17:40:12'),('B020000000114201512',1000001,11,'334235796320642254',201512,1,2,16,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100300001000980062673971',2,20151003,'2015-10-03 11:39:24'),('B020000000114201601',1000001,1,'334235796320642254',201601,1,2,9,1,0.01,0.00,0.00,2000.00,59.00,0.00,0,'',1,20151003,'2015-10-03 10:09:43'),('B020000000115201510',1000001,11,'46996346794673467',201510,1,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100300001000680061841062',2,20151003,'2015-10-03 10:37:06'),('B020000000115201512',1000001,11,'46996346794673467',201512,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'',1,20151003,'2015-10-03 11:17:07'),('B020000000116201512',1000001,11,'123456789123456789',201512,1,2,1,1,0.01,0.00,0.00,1000.00,59.00,0.00,0,'2015100300001000680061845329',2,20151003,'2015-10-03 11:18:35'),('B020000000116201602',1000001,11,'123456789123456789',201602,2,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100300001000680061863557',2,20151003,'2015-10-03 15:24:26'),('B020000000117201601',1000001,11,'123456789012345678',201601,1,2,8,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100300001000980062681559',2,20151003,'2015-10-03 16:11:40'),('B020000000117201603',1000001,11,'123456789012345678',201603,3,2,8,1,0.01,0.00,0.00,400.00,59.00,0.00,0,'2015100300001000980062681937',2,20151003,'2015-10-03 16:25:28'),('B020000000122201511',1000001,11,'222222222222222222',201511,1,2,4,1,0.01,0.00,0.00,300.00,59.00,0.00,0,'2015100300001000980062691522',2,20151003,'2015-10-03 22:06:09'),('B020000000123201510',1000001,11,'123456789011111122',201510,2,2,1,1,0.01,0.00,0.00,250.00,59.00,0.00,0,'2015100400001000980062701372',2,20151004,'2015-10-04 10:25:52'),('B020000000124201510',1000002,11,'342546425542453385',201510,2,2,1,1,0.01,0.00,0.00,189.50,59.00,0.00,0,'2015100400001000680061901090',2,20151004,'2015-10-04 10:53:53'),('B020000000125201510',1000002,11,'342564286438524583',201510,1,2,1,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'',1,20151004,'2015-10-04 11:27:22'),('B020000000125201601',1000002,11,'342564286438524583',201601,2,2,1,1,0.01,0.00,0.00,250.00,59.00,0.00,0,'',1,20151004,'2015-10-04 11:03:50'),('B020000000128201510',1000001,11,'5555555555555555',201510,2,2,6,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100400001000980062710748',2,20151004,'2015-10-04 16:00:14'),('B020000000128201512',1000001,11,'5555555555555555',201512,1,2,6,1,0.01,0.00,0.00,200.00,59.00,0.00,0,'2015100400001000980062711005',2,20151004,'2015-10-04 16:09:41'),('B020000000128201601',1000001,11,'5555555555555555',201601,1,2,6,1,0.01,0.00,0.00,300.00,59.00,0.00,0,'',1,20151004,'2015-10-04 16:11:14'),('B020000000129201510',1000001,11,'130425199306283453',201510,2,2,17,1,0.01,0.00,0.00,168.00,59.00,0.00,0,'2015100400001000980062716174',2,20151004,'2015-10-04 19:17:53'),('B030000000099201511',1000001,11,'330322197709013638',201511,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'2015093000001000980062573391',2,20151003,'2015-09-30 14:19:47'),('B030000000099201512',1000001,11,'330322197709013638',201512,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'2015093000001000980062574944',2,20151003,'2015-09-30 15:04:09'),('B030000000100201610',1000001,1,'441900199112130735',201610,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-29 18:33:28'),('B030000000101201511',1000001,11,'372324199209294438',201511,1,3,1,1,0.01,990.30,40.00,333.00,59.00,0.00,0,'',1,20151003,'2015-09-30 16:59:56'),('B030000000103201510',1000001,11,'425344333543223433',201510,1,3,1,1,0.01,990.30,59.00,45.00,40.00,0.00,0,'',1,20151003,'2015-09-30 11:52:35'),('B030000000106201510',1000001,11,'111111111188888888',201510,1,3,1,1,0.01,990.30,59.00,0.00,40.00,0.00,0,'',1,20151003,'2015-09-30 10:27:25'),('B030000000108201512',1000001,11,'440682199001015678',201512,2,3,1,1,0.01,990.30,59.00,50.00,40.00,0.00,0,'2015093000001000980062580371',2,20151003,'2015-09-30 17:38:18'),('B030000000109201510',1000001,11,'44068219910103258x',201510,1,3,1,1,0.01,990.30,40.00,444.00,59.00,0.00,0,'',1,20151003,'2015-10-02 09:56:48'),('B030000000109201603',1000001,11,'44068219910103258x',201603,1,3,1,1,0.01,1035.67,59.00,500.00,40.00,0.00,0,'2015100400001000980062701316',2,20151004,'2015-10-04 10:23:12'),('B030000000110201601',1000001,11,'44444444444444444',201601,1,3,1,2,0.01,977.42,59.00,90.00,40.00,0.00,0,'2015100100001000980062618720',2,20151003,'2015-10-01 17:20:22'),('B030000000112201510',1000001,11,'555555555555555555',201510,1,3,8,2,0.01,840.09,59.00,206.00,40.00,0.00,0,'2015100200001000980062647939',2,20151003,'2015-10-02 14:50:56'),('B030000000112201511',1000001,11,'555555555555555555',201511,1,3,8,1,0.01,840.09,59.00,206.00,40.00,0.00,0,'2015100200001000980062648497',2,20151003,'2015-10-02 15:11:01'),('B030000000113201511',1000004,11,'440682199001015678',201511,1,3,6,1,0.01,626.54,59.00,200.00,40.00,0.00,0,'2015100200001000980062650836',2,20151003,'2015-10-02 16:30:29'),('B030000000113201512',1000004,11,'440682199001015678',201512,1,3,16,1,0.01,783.23,40.00,200.00,59.00,0.00,0,'2015100200001000980062651028',2,20151003,'2015-10-02 16:36:47'),('B030000000114201510',1000001,11,'334235796320642254',201510,1,3,4,1,0.01,856.75,59.00,240.00,40.00,0.00,0,'2015100200001000980062652058',2,20151003,'2015-10-02 17:08:36'),('B030000000114201602',1000001,11,'334235796320642254',201602,1,3,11,1,0.01,783.33,40.00,300.00,59.00,0.00,0,'2015100300001000980062674267',2,20151003,'2015-10-03 11:50:25'),('B030000000117201511',1000001,11,'123456789012345678',201511,2,3,4,3,0.01,856.75,59.00,480.00,40.00,0.00,0,'2015100300001000980062681483',2,20151003,'2015-10-03 16:09:03'),('B030000000117201602',1000001,11,'123456789012345678',201602,1,3,8,1,0.01,840.09,40.00,300.00,59.00,0.00,0,'2015100300001000980062681756',2,20151003,'2015-10-03 16:18:35'),('B030000000118201510',1000001,11,'123456789011111111',201510,2,3,8,1,0.01,840.09,40.00,200.00,59.00,0.00,0,'2015100300001000980062682118',2,20151003,'2015-10-03 16:31:42'),('B030000000118201512',1000001,11,'123456789011111111',201512,2,3,8,1,0.01,840.09,59.00,480.00,40.00,0.00,0,'2015100300001000980062682169',2,20151003,'2015-10-03 16:33:45'),('B030000000118201603',1000001,11,'123456789011111111',201603,3,3,1,1,0.01,1035.67,59.00,540.00,40.00,0.00,0,'2015100400001000980062701230',2,20151004,'2015-10-04 10:20:18'),('B030000000122201601',1000001,11,'222222222222222222',201601,2,3,8,1,0.01,840.09,59.00,240.00,40.00,0.00,0,'2015100300001000980062691713',2,20151003,'2015-10-03 22:14:39'),('B030000000122201604',1000001,11,'222222222222222222',201604,4,3,8,1,0.01,840.09,40.00,165.00,59.00,0.00,0,'2015100300001000980062691874',2,20151003,'2015-10-03 22:20:58'),('B030000000123201512',1000001,11,'123456789011111122',201512,2,3,6,1,0.01,626.54,59.00,960.00,40.00,0.00,0,'2015100400001000980062710282',2,20151004,'2015-10-04 15:43:30'),('B030000000125201510',1000002,11,'342564286438524583',201510,1,3,1,1,0.01,1035.67,40.00,1000.00,59.00,0.00,0,'2015100400001000680061912038',2,20151004,'2015-10-04 14:36:00'),('B030000000125201512',1000002,11,'342564286438524583',201512,3,3,1,1,0.01,1035.67,40.00,2000.00,59.00,0.00,0,'2015100400001000680061913773',2,20151004,'2015-10-04 15:37:46'),('B030000000126201510',1000002,11,'134254679976438645',201510,4,3,1,1,0.01,1035.67,40.00,250.00,59.00,0.00,0,'2015100400001000680061912263',2,20151004,'2015-10-04 14:43:22'),('B030000000126201602',1000002,11,'134254679976438645',201602,2,3,1,1,0.01,1035.67,40.00,2000.00,59.00,0.00,0,'2015100400001000680061915379',2,20151004,'2015-10-04 16:36:28'),('B030000000127201510',1000006,1,'440222198404060315',201510,2,3,1,1,0.01,1035.67,59.00,201.00,40.00,0.00,0,'',1,20151004,'2015-10-04 16:32:41'),('B030000000128201601',1000001,11,'5555555555555555',201601,2,3,1,1,0.01,1035.67,59.00,480.00,40.00,10.00,1,'2015100400001000980062712944',2,20151004,'2015-10-04 17:21:16'),('B030000000129201512',1000001,11,'130425199306283453',201512,2,3,17,2,0.01,1069.08,59.00,168.00,40.00,0.00,0,'2015100400001000980062716129',2,20151004,'2015-10-04 19:16:05'),('B030000000129201602',1000001,11,'130425199306283453',201602,2,3,17,4,0.01,1069.08,40.00,168.00,59.00,0.00,0,'2015100400001000980062716228',2,20151004,'2015-10-04 19:20:02');

/*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 ('010000000099201510','010000000099201510163287',1000001,'330322197709013638',1001,1,201510,990.30,0.00,0.00,59.00,0.00,0,0,2,'2015-09-21 16:55:44'),('010000000109201512','B010000000109201512',1000001,'44068219910103258x',1001,1,201512,977.42,59.00,0.00,0.00,0.00,1,0,2,'2015-09-30 18:05:08'),('010000000109201601','B010000000109201512',1000001,'44068219910103258x',1001,1,201601,977.42,59.00,0.00,0.00,0.00,0,0,2,'2015-09-30 18:05:08'),('010000000110201510','B010000000110201510',1000001,'44444444444444444',1001,1,201510,5508.54,59.00,0.00,0.00,0.00,0,0,2,'2015-10-01 10:10:06'),('010000000110201511','B010000000110201511',1000001,'44444444444444444',1002,1,201511,861.49,59.00,0.00,0.00,0.00,0,0,2,'2015-10-01 17:14:37'),('010000000110201602','B010000000110201602',1000001,'44444444444444444',1001,1,201602,1035.67,59.00,0.00,0.00,0.00,0,0,2,'2015-10-02 14:33:08'),('010000000111201510','B010000000111201510',1000001,'444444444444444444',1001,1,201510,990.30,59.00,0.00,0.00,0.00,0,0,2,'2015-10-01 10:20:51'),('010000000111201511','B010000000111201510',1000001,'444444444444444444',1001,1,201511,990.30,59.00,0.00,0.00,0.00,0,0,2,'2015-10-01 10:20:51'),('010000000113201510','B010000000113201510',1000004,'440682199001015678',1001,1,201510,1035.67,59.00,0.00,0.00,0.00,0,0,2,'2015-10-02 16:05:47'),('010000000113201602','B010000000113201602',1000004,'440682199001015678',1008,1,201602,783.33,59.00,0.00,0.00,0.00,0,0,2,'2015-10-02 16:52:57'),('010000000117201510','B010000000117201510',1000001,'123456789012345678',1003,1,201510,626.54,59.00,0.00,0.00,0.00,0,0,2,'2015-10-03 16:06:29'),('010000000122201510','B010000000122201510',1000001,'222222222222222222',1002,1,201510,856.75,59.00,0.00,0.00,0.00,0,0,2,'2015-10-03 22:04:12'),('010000000122201511','B010000000122201510',1000001,'222222222222222222',1002,1,201511,856.75,59.00,0.00,0.00,0.00,0,0,2,'2015-10-03 22:04:12'),('010000000128201510','B010000000128201510',1000001,'5555555555555555',1003,1,201510,626.54,59.00,0.00,0.00,0.00,0,0,2,'2015-10-04 16:08:06'),('010000000129201510','B010000000129201510',1000001,'130425199306283453',1011,1,201510,849.64,59.00,0.00,0.00,0.00,0,0,2,'2015-10-04 19:12:40'),('010000000129201511','B010000000129201510',1000001,'130425199306283453',1011,1,201511,849.64,59.00,0.00,0.00,0.00,0,0,2,'2015-10-04 19:12:40'),('020000000099201512','B020000000099201512',1000001,'330322197709013638',1001,2,201512,0.00,0.00,50.00,59.00,0.00,0,0,2,'2015-09-30 15:20:00'),('020000000099201601','020000000099201601',1000001,'330322197709013638',1001,2,201601,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-09-22 17:12:23'),('020000000099201602','020000000099201602',1000001,'330322197709013638',1001,2,201602,0.00,0.00,560.00,59.00,0.00,0,0,2,'2015-09-22 17:49:39'),('020000000099201603','020000000099201603',1000001,'330322197709013638',1001,2,201603,0.00,0.00,2555.00,59.00,0.00,0,0,2,'2015-09-22 17:52:33'),('020000000100201510','020000000100201510',1000001,'441900199112130735',1001,2,201510,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-09-22 16:10:54'),('020000000100201511','020000000100201510',1000001,'441900199112130735',1001,2,201511,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-09-22 16:10:54'),('020000000100201512','020000000100201510',1000001,'441900199112130735',1001,2,201512,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-09-22 16:10:54'),('020000000101201510','020000000101201510',1000001,'372324199209294438',1001,2,201510,0.00,0.00,1234.00,59.00,0.00,0,0,2,'2015-09-22 17:55:46'),('020000000101201512','B020000000101201512',1000001,'372324199209294438',1001,2,201512,0.00,0.00,333.00,59.00,0.00,0,0,2,'2015-09-30 16:40:19'),('020000000102201510','020000000102201510',1000001,'440682199001018888',1001,2,201510,0.00,0.00,300.00,59.00,0.00,0,0,2,'2015-09-28 11:51:32'),('020000000104201510','020000000104201510',1000001,'440682199001018889',1001,2,201510,0.00,0.00,301.00,59.00,0.00,0,0,2,'2015-09-28 15:11:46'),('020000000104201511','020000000104201511',1000001,'440682199001018889',1001,2,201511,0.00,0.00,302.00,59.00,0.00,0,0,2,'2015-09-28 15:14:50'),('020000000106201511','020000000106201511',1000001,'111111111188888888',1001,2,201511,0.00,0.00,799.00,59.00,0.00,0,0,2,'2015-09-29 11:41:35'),('020000000106201512','020000000106201511',1000001,'111111111188888888',1001,2,201512,0.00,0.00,799.00,59.00,0.00,0,0,2,'2015-09-29 11:41:35'),('020000000106201601','020000000106201601',1000001,'111111111188888888',1001,2,201601,0.00,0.00,402.00,59.00,0.00,0,0,2,'2015-09-29 11:58:23'),('020000000109201512','B020000000109201512',1000001,'44068219910103258x',1001,2,201512,0.00,0.00,50.00,59.00,0.00,0,0,2,'2015-09-30 19:17:09'),('020000000109201601','B020000000109201512',1000001,'44068219910103258x',1001,2,201601,0.00,0.00,50.00,59.00,0.00,0,0,2,'2015-09-30 19:17:09'),('020000000113201601','B020000000113201601',1000004,'440682199001015678',1007,2,201601,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-02 16:39:57'),('020000000113201603','B020000000113201603',1000004,'440682199001015678',1008,2,201603,0.00,0.00,300.00,59.00,0.00,0,0,2,'2015-10-02 16:54:02'),('020000000114201511','B020000000114201511',1000001,'334235796320642254',1002,2,201511,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-02 17:40:22'),('020000000114201512','B020000000114201512',1000001,'334235796320642254',1013,2,201512,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-03 11:39:56'),('020000000115201510','B020000000115201510',1000001,'46996346794673467',1001,2,201510,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-03 10:37:14'),('020000000116201512','B020000000116201512',1000001,'123456789123456789',1001,2,201512,0.00,0.00,1000.00,59.00,0.00,0,0,2,'2015-10-03 11:18:53'),('020000000116201602','B020000000116201602',1000001,'123456789123456789',1001,2,201602,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-03 15:24:35'),('020000000116201603','B020000000116201602',1000001,'123456789123456789',1001,2,201603,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-03 15:24:35'),('020000000117201601','B020000000117201601',1000001,'123456789012345678',1004,2,201601,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-03 16:11:50'),('020000000117201603','B020000000117201603',1000001,'123456789012345678',1004,2,201603,0.00,0.00,400.00,59.00,0.00,0,0,2,'2015-10-03 16:25:38'),('020000000117201604','B020000000117201603',1000001,'123456789012345678',1004,2,201604,0.00,0.00,400.00,59.00,0.00,0,0,2,'2015-10-03 16:25:38'),('020000000117201605','B020000000117201603',1000001,'123456789012345678',1004,2,201605,0.00,0.00,400.00,59.00,0.00,0,0,2,'2015-10-03 16:25:38'),('020000000122201511','B020000000122201511',1000001,'222222222222222222',1002,2,201511,0.00,0.00,300.00,59.00,0.00,0,0,2,'2015-10-03 22:06:20'),('020000000123201510','B020000000123201510',1000001,'123456789011111122',1001,2,201510,0.00,0.00,250.00,59.00,0.00,0,0,2,'2015-10-04 10:26:05'),('020000000123201511','B020000000123201510',1000001,'123456789011111122',1001,2,201511,0.00,0.00,250.00,59.00,0.00,0,0,2,'2015-10-04 10:26:05'),('020000000124201510','B020000000124201510',1000002,'342546425542453385',1001,2,201510,0.00,0.00,189.50,59.00,0.00,0,0,2,'2015-10-04 10:54:11'),('020000000124201511','B020000000124201510',1000002,'342546425542453385',1001,2,201511,0.00,0.00,189.50,59.00,0.00,0,0,2,'2015-10-04 10:54:11'),('020000000128201510','B020000000128201510',1000001,'5555555555555555',1003,2,201510,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-04 16:00:36'),('020000000128201511','B020000000128201510',1000001,'5555555555555555',1003,2,201511,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-04 16:00:36'),('020000000128201512','B020000000128201512',1000001,'5555555555555555',1003,2,201512,0.00,0.00,200.00,59.00,0.00,0,0,2,'2015-10-04 16:09:59'),('020000000129201510','B020000000129201510',1000001,'130425199306283453',1301,2,201510,0.00,0.00,168.00,59.00,0.00,0,0,2,'2015-10-04 19:18:09'),('020000000129201511','B020000000129201510',1000001,'130425199306283453',1301,2,201511,0.00,0.00,168.00,59.00,0.00,0,0,2,'2015-10-04 19:18:09'),('030000000099201511','B030000000099201511',1000001,'330322197709013638',1001,3,201511,990.30,59.00,0.00,40.00,0.00,0,0,2,'2015-09-30 14:20:21'),('030000000099201512','B030000000099201512',1000001,'330322197709013638',1001,3,201508,990.30,59.00,0.00,40.00,0.00,0,0,2,'2015-07-30 15:04:23'),('030000000100201510','030000000100201510',1000001,'441900199112130735',1001,3,201508,990.30,59.00,0.00,40.00,0.00,0,0,2,'2015-07-24 17:51:53'),('030000000100201603','030000000100201603',1000001,'441900199112130735',1001,3,201509,990.30,0.00,399.00,99.00,0.00,0,0,2,'2015-08-22 15:58:18'),('030000000101201601','030000000101201601',1000001,'372324199209294438',1001,3,201509,990.30,40.00,399.00,59.00,0.00,0,0,2,'2015-08-23 14:41:25'),('030000000101201602','030000000101201601',1000001,'372324199209294438',1001,3,201602,990.30,40.00,399.00,59.00,0.00,0,0,2,'2015-09-23 14:41:25'),('030000000101201603','030000000101201601',1000001,'372324199209294438',1001,3,201603,990.30,40.00,399.00,59.00,0.00,0,0,2,'2015-09-23 14:41:25'),('030000000102201510','030000000102201510',1000001,'440682199001018888',1001,3,201510,942.14,59.00,0.00,40.00,0.00,0,0,2,'2015-09-28 10:52:15'),('030000000102201511','030000000102201511',1000001,'440682199001018888',1001,3,201511,990.30,59.00,300.00,40.00,0.00,0,0,2,'2015-09-28 11:45:39'),('030000000102201512','030000000102201511',1000001,'440682199001018888',1001,3,201512,990.30,59.00,300.00,40.00,0.00,0,0,2,'2015-09-28 11:45:39'),('030000000102201601','030000000102201601',1000001,'440682199001018888',1002,3,201601,861.49,59.00,0.00,31.00,0.00,0,0,2,'2015-09-28 14:49:29'),('030000000104201510','030000000104201510',1000001,'440682199001018889',1001,3,201510,977.42,59.00,0.00,40.00,0.00,0,0,2,'2015-09-28 14:55:47'),('030000000104201511','030000000104201511',1000001,'440682199001018889',1001,3,201511,990.30,59.00,308.00,40.00,0.00,0,0,2,'2015-09-28 15:23:52'),('030000000104201512','030000000104201511',1000001,'440682199001018889',1001,3,201512,990.30,59.00,308.00,40.00,0.00,0,0,2,'2015-09-28 15:23:52'),('030000000105201510','030000000105201510',1000001,'444444444455555556',1001,3,201510,990.30,59.00,0.00,40.00,0.00,0,0,2,'2015-09-29 11:24:55'),('030000000105201511','030000000105201510',1000001,'444444444455555556',1001,3,201511,990.30,59.00,0.00,40.00,0.00,0,0,2,'2015-09-29 11:24:55'),('030000000105201601','030000000105201601',1000001,'444444444455555555',1001,3,201601,5508.54,59.00,400.00,40.00,0.00,0,0,2,'2015-09-29 11:57:16'),('030000000106201602','030000000106201602',1000001,'211111111188888888',1001,3,201602,977.42,40.00,408.00,59.00,0.00,0,0,2,'2015-09-29 12:02:02'),('030000000108201512','B030000000108201512',1000001,'440682199001015678',1001,3,201512,990.30,59.00,50.00,40.00,0.00,0,0,2,'2015-09-30 17:38:38'),('030000000108201601','B030000000108201512',1000001,'440682199001015678',1001,3,201601,990.30,59.00,50.00,40.00,0.00,0,0,2,'2015-09-30 17:38:38'),('030000000109201603','B030000000109201603',1000001,'44068219910103258x',1001,3,201603,1035.67,59.00,500.00,40.00,0.00,0,0,2,'2015-10-04 10:23:56'),('030000000110201601','B030000000110201601',1000001,'44444444444444444',1001,3,201601,977.42,59.00,90.00,40.00,0.00,0,0,2,'2015-10-01 17:20:34'),('030000000112201510','B030000000112201510',1000001,'555555555555555555',1004,3,201510,840.09,59.00,206.00,40.00,0.00,0,0,2,'2015-10-02 14:51:13'),('030000000112201511','B030000000112201511',1000001,'555555555555555555',1004,3,201511,840.09,59.00,206.00,40.00,0.00,0,0,2,'2015-10-02 15:11:12'),('030000000113201511','B030000000113201511',1000004,'440682199001015678',1003,3,201511,626.54,59.00,200.00,40.00,0.00,0,0,2,'2015-10-02 16:30:45'),('030000000113201512','B030000000113201512',1000004,'440682199001015678',1013,3,201512,783.23,40.00,200.00,59.00,0.00,0,0,2,'2015-10-02 16:36:59'),('030000000114201510','B030000000114201510',1000001,'334235796320642254',1002,3,201510,856.75,59.00,240.00,40.00,0.00,0,0,2,'2015-10-02 17:09:27'),('030000000114201602','B030000000114201602',1000001,'334235796320642254',1008,3,201602,783.33,40.00,300.00,59.00,0.00,0,0,2,'2015-10-03 11:50:41'),('030000000117201511','B030000000117201511',1000001,'123456789012345678',1002,3,201511,856.75,59.00,480.00,40.00,0.00,0,0,2,'2015-10-03 16:09:15'),('030000000117201512','B030000000117201511',1000001,'123456789012345678',1002,3,201512,856.75,59.00,480.00,40.00,0.00,0,0,2,'2015-10-03 16:09:15'),('030000000117201602','B030000000117201602',1000001,'123456789012345678',1004,3,201602,840.09,40.00,300.00,59.00,0.00,0,0,2,'2015-10-03 16:18:44'),('030000000118201510','B030000000118201510',1000001,'123456789011111111',1004,3,201510,840.09,40.00,200.00,59.00,0.00,0,0,2,'2015-10-03 16:31:52'),('030000000118201511','B030000000118201510',1000001,'123456789011111111',1004,3,201511,840.09,40.00,200.00,59.00,0.00,0,0,2,'2015-10-03 16:31:52'),('030000000118201512','B030000000118201512',1000001,'123456789011111111',1004,3,201512,840.09,59.00,480.00,40.00,0.00,0,0,2,'2015-10-03 16:33:55'),('030000000118201601','B030000000118201512',1000001,'123456789011111111',1004,3,201601,840.09,59.00,480.00,40.00,0.00,0,0,2,'2015-10-03 16:33:55'),('030000000118201603','B030000000118201603',1000001,'123456789011111111',1001,3,201603,1035.67,59.00,540.00,40.00,0.00,0,0,2,'2015-10-04 10:20:29'),('030000000118201604','B030000000118201603',1000001,'123456789011111111',1001,3,201604,1035.67,59.00,540.00,40.00,0.00,0,0,2,'2015-10-04 10:20:29'),('030000000118201605','B030000000118201603',1000001,'123456789011111111',1001,3,201605,1035.67,59.00,540.00,40.00,0.00,0,0,2,'2015-10-04 10:20:29'),('030000000122201601','B030000000122201601',1000001,'222222222222222222',1004,3,201601,840.09,59.00,240.00,40.00,0.00,0,0,2,'2015-10-03 22:14:57'),('030000000122201602','B030000000122201601',1000001,'222222222222222222',1004,3,201602,840.09,59.00,240.00,40.00,0.00,0,0,2,'2015-10-03 22:14:57'),('030000000122201604','B030000000122201604',1000001,'222222222222222222',1004,3,201604,840.09,40.00,165.00,59.00,0.00,0,0,2,'2015-10-03 22:21:07'),('030000000122201605','B030000000122201604',1000001,'222222222222222222',1004,3,201605,840.09,40.00,165.00,59.00,0.00,0,0,2,'2015-10-03 22:21:07'),('030000000122201606','B030000000122201604',1000001,'222222222222222222',1004,3,201606,840.09,40.00,165.00,59.00,0.00,0,0,2,'2015-10-03 22:21:07'),('030000000122201607','B030000000122201604',1000001,'222222222222222222',1004,3,201607,840.09,40.00,165.00,59.00,0.00,0,0,2,'2015-10-03 22:21:07'),('030000000123201512','B030000000123201512',1000001,'123456789011111122',1003,3,201512,626.54,59.00,960.00,40.00,0.00,0,0,2,'2015-10-04 15:43:44'),('030000000123201601','B030000000123201512',1000001,'123456789011111122',1003,3,201601,626.54,59.00,960.00,40.00,0.00,0,0,2,'2015-10-04 15:43:44'),('030000000125201510','B030000000125201510',1000002,'342564286438524583',1001,3,201510,1035.67,40.00,1000.00,59.00,0.00,0,0,2,'2015-10-04 14:36:10'),('030000000125201512','B030000000125201512',1000002,'342564286438524583',1001,3,201512,1035.67,40.00,2000.00,59.00,0.00,0,0,2,'2015-10-04 15:37:57'),('030000000125201601','B030000000125201512',1000002,'342564286438524583',1001,3,201601,1035.67,40.00,2000.00,59.00,0.00,0,0,2,'2015-10-04 15:37:57'),('030000000125201602','B030000000125201512',1000002,'342564286438524583',1001,3,201602,1035.67,40.00,2000.00,59.00,0.00,0,0,2,'2015-10-04 15:37:57'),('030000000126201510','B030000000126201510',1000002,'134254679976438645',1001,3,201510,1035.67,40.00,250.00,59.00,0.00,0,0,2,'2015-10-04 14:43:29'),('030000000126201511','B030000000126201510',1000002,'134254679976438645',1001,3,201511,1035.67,40.00,250.00,59.00,0.00,0,0,2,'2015-10-04 14:43:29'),('030000000126201512','B030000000126201510',1000002,'134254679976438645',1001,3,201512,1035.67,40.00,250.00,59.00,0.00,0,0,2,'2015-10-04 14:43:29'),('030000000126201601','B030000000126201510',1000002,'134254679976438645',1001,3,201601,1035.67,40.00,250.00,59.00,0.00,0,0,2,'2015-10-04 14:43:29'),('030000000126201602','B030000000126201602',1000002,'134254679976438645',1001,3,201602,1035.67,40.00,2000.00,59.00,0.00,0,0,2,'2015-10-04 16:36:37'),('030000000126201603','B030000000126201602',1000002,'134254679976438645',1001,3,201603,1035.67,40.00,2000.00,59.00,0.00,0,0,2,'2015-10-04 16:36:37'),('030000000128201601','B030000000128201601',1000001,'5555555555555555',1001,3,201601,1035.67,59.00,480.00,40.00,10.00,1,0,2,'2015-10-04 17:21:27'),('030000000128201602','B030000000128201601',1000001,'5555555555555555',1001,3,201602,1035.67,59.00,480.00,40.00,10.00,0,0,2,'2015-10-04 17:21:27'),('030000000129201512','B030000000129201512',1000001,'130425199306283453',1301,3,201512,1069.08,59.00,168.00,40.00,0.00,0,0,2,'2015-10-04 19:16:26'),('030000000129201601','B030000000129201512',1000001,'130425199306283453',1301,3,201601,1069.08,59.00,168.00,40.00,0.00,0,0,2,'2015-10-04 19:16:26'),('030000000129201602','B030000000129201602',1000001,'130425199306283453',1301,3,201602,1069.08,40.00,168.00,59.00,0.00,0,0,2,'2015-10-04 19:20:14'),('030000000129201603','B030000000129201602',1000001,'130425199306283453',1301,3,201603,1069.08,40.00,168.00,59.00,0.00,0,0,2,'2015-10-04 19:20:14');

/*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 ('010000000099201510163287','330322197709013638','倪建勋','汉',1,'13928550878',NULL,0),('020000000099201601','330322197709013638','倪建勋','汉',1,'13928550878',NULL,0),('020000000099201602','330322197709013638','倪建勋','汉',1,'13928550878',NULL,0),('020000000099201603','330322197709013638','倪建勋','汉',1,'13928550878',NULL,0),('020000000100201510','441900199112130735','涂冠杰','汉',1,'18665285417',NULL,0),('020000000101201510','372324199209294438','田厚超','汉',1,'13584549827',NULL,0),('020000000102201510','440682199001018888','周小姐','傣族',0,'18664850868',NULL,0),('020000000104201510','440682199001018889','周小姐','汉',0,'18664850868',NULL,0),('020000000104201511','440682199001018889','周小姐2','汉',0,'18664850868',NULL,0),('020000000106201511','111111111188888888','公积金','大韩',1,'18664850868','2015-09-30 11:16:16',0),('020000000106201601','111111111188888888','公积金','大韩',0,'18664850868',NULL,0),('030000000100201510','441900199112130735','涂冠杰','彝族',1,'18665285417',NULL,0),('030000000100201603','441900199112130735','涂冠杰','汉',1,'18665285417',NULL,0),('030000000101201601','372324199209294438','田厚超','汉',1,'13584549827',NULL,0),('030000000102201510','440682199001018888','周小姐','汉',0,'18664850868',NULL,0),('030000000102201511','440682199001018888','周小姐','汉',0,'18664850868',NULL,0),('030000000102201601','440682199001018888','周小姐','傣族',0,'18664850868',NULL,0),('030000000104201510','440682199001018889','周小姐','汉',0,'18664850868',NULL,0),('030000000104201511','440682199001018889','周小姐2','汉',1,'18664850868','2015-09-30 11:16:36',0),('030000000105201510','444444444455555556','社保订单1','汉zu',1,'13544449998','2015-09-29 11:28:46',0),('030000000105201601','444444444455555555','社保订单','汉',1,'13544449999',NULL,0),('030000000106201602','211111111188888888','公积金1','大韩',1,'18664850869','2015-09-30 11:15:53',0),('B010000000109201512','44068219910103258x','社保订单身份证更新','汉',0,'13544449999',NULL,0),('B010000000110201510','44444444444444444','安卓测试x','汉',0,'18664850868','2015-10-02 09:33:23',0),('B010000000110201511','44444444444444444','安卓测试X','汉',0,'18664850868','2015-10-02 10:29:53',0),('B010000000110201602','44444444444444444','安卓测试','汉',0,'18664850868',NULL,0),('B010000000111201510','444444444444444444','安卓测试L','汉',0,'18664850868','2015-10-02 10:29:19',0),('B010000000113201510','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B010000000113201602','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B010000000117201510','123456789012345678','服务端价格','汉',1,'18664850868',NULL,0),('B010000000122201510','222222222222222222','增员测试','大和',0,'18664850868',NULL,0),('B010000000128201510','5555555555555555','八十','汉',1,'18664850868',NULL,0),('B010000000129201510','130425199306283453','增员二','汉',1,'18664850868',NULL,0),('B020000000099201512','330322197709013638','倪建勋','汉',1,'13928550878','2015-09-30 15:21:06',0),('B020000000101201512','372324199209294438','田厚超','汉',1,'13584549827',NULL,0),('B020000000109201512','44068219910103258x','社保订单身份证更新','汉',0,'13544449999',NULL,0),('B020000000113201601','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B020000000113201603','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B020000000114201511','334235796320642254','乔峰','贵族',1,'13256428456',NULL,0),('B020000000114201512','334235796320642254','乔峰','贵族',1,'13256428456',NULL,0),('B020000000115201510','46996346794673467','你干嘛','搞笑',0,'15696346497',NULL,0),('B020000000116201512','123456789123456789','小米','小米',0,'13582467589',NULL,0),('B020000000116201602','123456789123456789','小米','小米',0,'13582467589',NULL,0),('B020000000117201601','123456789012345678','服务端价格','汉',1,'18664850868',NULL,0),('B020000000117201603','123456789012345678','服务端价格','汉',1,'18664850868',NULL,0),('B020000000122201511','222222222222222222','增员测试','大和',0,'18664850868',NULL,0),('B020000000123201510','123456789011111122','服务端价格三','汉',0,'18664850868',NULL,0),('B020000000124201510','342546425542453385','茶叶','汉语',0,'13452854286',NULL,0),('B020000000128201510','5555555555555555','八十','汉',1,'18664850868',NULL,0),('B020000000128201512','5555555555555555','八十','汉',1,'18664850868',NULL,0),('B020000000129201510','130425199306283453','增员二','汉',1,'18664850868',NULL,0),('B030000000099201511','330322197709013638','倪建勋','汉',1,'13928550878','2015-09-30 14:31:53',0),('B030000000099201512','330322197709013638','倪建勋','汉',1,'13928550878',NULL,0),('B030000000108201512','440682199001015678','逻辑判断','韩',1,'18664850868',NULL,0),('B030000000109201603','44068219910103258x','社保订单身份证更新','汉',0,'13544449999',NULL,0),('B030000000110201601','44444444444444444','安卓测试x','汉',0,'18664850868','2015-10-02 10:35:32',0),('B030000000112201510','555555555555555555','社保和公积金安卓','维族',1,'18664850868',NULL,0),('B030000000112201511','555555555555555555','社保和公积金安卓','维族',1,'18664850868',NULL,0),('B030000000113201511','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B030000000113201512','440682199001015678','参保人1','汉',1,'18664850868',NULL,0),('B030000000114201510','334235796320642254','乔峰','贵族',1,'13256428456',NULL,0),('B030000000114201602','334235796320642254','乔峰','贵族',1,'13256428456',NULL,0),('B030000000117201511','123456789012345678','服务端价格','汉',1,'18664850868',NULL,0),('B030000000117201602','123456789012345678','服务端价格','汉',1,'18664850868',NULL,0),('B030000000118201510','123456789011111111','服务端价格二','汉',1,'18664850868',NULL,0),('B030000000118201512','123456789011111111','服务端价格二','汉',1,'18664850868',NULL,0),('B030000000118201603','123456789011111111','服务端价格二','汉',1,'18664850868',NULL,0),('B030000000122201601','222222222222222222','增员测试','大和',0,'18664850868',NULL,0),('B030000000122201604','222222222222222222','增员测试','大和',0,'18664850868',NULL,0),('B030000000123201512','123456789011111122','服务端价格三','汉',0,'18664850868',NULL,0),('B030000000125201510','342564286438524583','喝酒','毫无',0,'13894675894',NULL,0),('B030000000125201512','342564286438524583','喝酒','毫无',0,'13894675894',NULL,0),('B030000000126201510','134254679976438645','柚子','哈姆',0,'18765432109',NULL,0),('B030000000126201602','134254679976438645','柚子','哈姆',0,'18765432109',NULL,0),('B030000000128201601','5555555555555555','八十','汉',1,'18664850868',NULL,0),('B030000000129201512','130425199306283453','增员二','汉',1,'18664850868',NULL,0),('B030000000129201602','130425199306283453','增员二','汉',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=18 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,10.00,59.00,99.00,0,'2015-10-02 16:16:27'),(4,1002,'标准',1,59.00,10.00,59.00,99.00,15,'2015-10-02 18:17:40'),(6,1003,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 12:52:19'),(7,1101,'标准',0,59.00,0.00,59.00,99.00,0,'2015-10-02 12:37:01'),(8,1004,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 12:58:32'),(9,1005,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 12:59:40'),(10,1007,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:01:12'),(11,1008,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:02:35'),(12,1009,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:03:50'),(13,1010,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:05:38'),(14,1011,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-04 18:57:43'),(15,1012,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-04 19:00:54'),(16,1013,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:08:39'),(17,1301,'标准',0,59.00,10.00,59.00,99.00,0,'2015-10-02 13:09:52');

/*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=68 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,NULL),(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,NULL),(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,NULL),(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,NULL),(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\":1510.0,\"max\":22135.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\":22135.0,\"max\":22135.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\":1510.0,\"max\":22135.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\":1510.0,\"max\":22135.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\":1650.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\":1650.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\":1650.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\":1650.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\":3365.0,\"max\":3365.0,\"e\":0.2,\"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\":1360.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\":3365.0,\"max\":3365.0,\"e\":0.2,\"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\":1360.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\":3365.0,\"max\":3365.0,\"e\":0.2,\"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\":1360.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\":3365.0,\"max\":3365.0,\"e\":0.2,\"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\":1360.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,NULL),(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\":12452.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,NULL),(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\":12452.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,NULL),(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,NULL),(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}',30.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}',30.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}',30.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}',30.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\":1680.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\":1680.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\":1680.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\":1680.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 '消息类型',
  `platerform` 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 '生成时间-秒',
  `sended` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已发送',
  `send_time` datetime DEFAULT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `t_sb_msg` */

insert  into `t_sb_msg`(`id`,`u_id`,`msg_type`,`platerform`,`title`,`content`,`gen_sec`,`sended`,`send_time`) values (1,1000001,2,1,'这是测试','测试的内容，时间是估的。',1365656520,0,NULL),(2,1000001,3,1,'测试2','好久邹久',1365656621,0,NULL),(3,1000001,4,1,'第三条测试','这是第三条测试',1365675630,0,NULL);

/*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=130 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',NULL,'/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',NULL,'/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');

/*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=1000007 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');

/*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 (1000004,'1',1,0,'2015-10-04 13:16:11'),(1000005,'1',1,0,'2015-10-04 17:07:34'),(1000006,'1',1,0,'2015-10-04 16:41:49');

/*!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 */;