Home Explore Help
Register Sign In
shebao
/
shebao-server
Watch 4
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: oa/invoice-ocr
Branches Tags
shebao-server
/
docs
/
sql
/
db
/
shebao_data20151012_new.sql

shebao_data20151012_new.sql 66 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303 
  1. /*
    2. 

  2. SQLyog Ultimate v11.11 (64 bit)
    3. 

  3. MySQL - 5.6.26 : Database - shebao
    4. 

  4. *********************************************************************
    5. 

  5. */
    6. 

  6. 

  7. /*!40101 SET NAMES utf8 */;
    8. 

  8. 

  9. /*!40101 SET SQL_MODE=''*/;
    10. 

  10. 

  11. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    12. 

  12. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    13. 

  13. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    14. 

  14. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    15. 

  15. CREATE DATABASE /*!32312 IF NOT EXISTS*/`shebao` /*!40100 DEFAULT CHARACTER SET utf8 */;
    16. 

  16. 

  17. USE `shebao`;
    18. 

  18. 

  19. /*Table structure for table `t_city_news` */
    20. 

  20. 

  21. DROP TABLE IF EXISTS `t_city_news`;
    22. 

  22. 

  23. CREATE TABLE `t_city_news` (
    24. 

  24.   `c_n_id` int(30) unsigned NOT NULL AUTO_INCREMENT,
    25. 

  25.   `cid` int(30) DEFAULT NULL,
    26. 

  26.   `nid` int(30) DEFAULT NULL,
    27. 

  27.   PRIMARY KEY (`c_n_id`)
    28. 

  28. ) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8;
    29. 

  29. 

  30. /*Data for the table `t_city_news` */
    31. 

  31. 

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

  33. 

  34. /*Table structure for table `t_news` */
    35. 

  35. 

  36. DROP TABLE IF EXISTS `t_news`;
    37. 

  37. 

  38. CREATE TABLE `t_news` (
    39. 

  39.   `nid` int(30) unsigned NOT NULL AUTO_INCREMENT COMMENT '标识ID',
    40. 

  40.   `title` varchar(255) DEFAULT NULL COMMENT '标题',
    41. 

  41.   `content` text COMMENT '内容',
    42. 

  42.   `publish_time` datetime DEFAULT NULL,
    43. 

  43.   PRIMARY KEY (`nid`)
    44. 

  44. ) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;
    45. 

  45. 

  46. /*Data for the table `t_news` */
    47. 

  47. 

  48. 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');
    49. 

  49. 

  50. /*Table structure for table `t_sb_buy` */
    51. 

  51. 

  52. DROP TABLE IF EXISTS `t_sb_buy`;
    53. 

  53. 

  54. CREATE TABLE `t_sb_buy` (
    55. 

  55.   `buy_no` varchar(32) NOT NULL DEFAULT '0' COMMENT '用于支付的订单号',
    56. 

  56.   `pay_uid` int(10) unsigned NOT NULL COMMENT '支付人ID',
    57. 

  57.   `pay_channel` tinyint(3) unsigned NOT NULL,
    58. 

  58.   `id_card` varchar(20) NOT NULL COMMENT '身份证',
    59. 

  59.   `start_month` mediumint(8) unsigned NOT NULL COMMENT '购买的月份',
    60. 

  60.   `month_num` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '月份数',
    61. 

  61.   `pay_for` tinyint(1) unsigned NOT NULL DEFAULT '0',
    62. 

  62.   `cid` int(10) unsigned NOT NULL COMMENT '社保数据ID',
    63. 

  63.   `hukou` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '户籍性质',
    64. 

  64.   `total_fee` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本单总金额',
    65. 

  65.   `shebaos` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月社保金额',
    66. 

  66.   `shebao_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月手续费',
    67. 

  67.   `funds` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月公积金金额',
    68. 

  68.   `fund_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '单月服务费',
    69. 

  69.   `card_charge` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '新办卡服务费',
    70. 

  70.   `new_card` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否办卡',
    71. 

  71.   `pay_no` varchar(128) NOT NULL DEFAULT '' COMMENT '第三方支付订单号',
    72. 

  72.   `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态',
    73. 

  73.   `gen_date` int(10) unsigned NOT NULL COMMENT '购买日期',
    74. 

  74.   `gen_time` datetime NOT NULL COMMENT '创建时间',
    75. 

  75.   PRIMARY KEY (`buy_no`),
    76. 

  76.   KEY `buy_month_idx` (`start_month`),
    77. 

  77.   KEY `buy_date_idx` (`gen_date`)
    78. 

  78. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付表';
    79. 

  79. 

  80. /*Data for the table `t_sb_buy` */
    81. 

  81. 

  82. 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');
    83. 

  83. 

  84. /*Table structure for table `t_sb_buy_order` */
    85. 

  85. 

  86. DROP TABLE IF EXISTS `t_sb_buy_order`;
    87. 

  87. 

  88. CREATE TABLE `t_sb_buy_order` (
    89. 

  89.   `order_no` varchar(32) NOT NULL COMMENT '子订单号',
    90. 

  90.   `buy_no` varchar(32) NOT NULL COMMENT '购买订单号',
    91. 

  91.   `pay_uid` int(10) unsigned NOT NULL COMMENT '支付人',
    92. 

  92.   `id_card` varchar(20) NOT NULL COMMENT '身份证',
    93. 

  93.   `city_code` smallint(6) NOT NULL COMMENT '城市代码',
    94. 

  94.   `pay_for` tinyint(1) NOT NULL COMMENT '对象(社保、公积金)',
    95. 

  95.   `for_month` int(10) unsigned NOT NULL COMMENT '月份201506',
    96. 

  96.   `shebaos` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本月参保社保',
    97. 

  97.   `shebao_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '社保服务费',
    98. 

  98.   `funds` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '本月缴存公积金',
    99. 

  99.   `fund_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '服务费',
    100. 

  100.   `card_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '办卡服务费',
    101. 

  101.   `new_card` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否办卡',
    102. 

  102.   `isAuto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自动代扣生成',
    103. 

  103.   `status` tinyint(4) NOT NULL DEFAULT '2' COMMENT '状态(已支付成功)',
    104. 

  104.   `gen_time` datetime NOT NULL COMMENT '生成时间',
    105. 

  105.   PRIMARY KEY (`order_no`),
    106. 

  106.   KEY `buy_order_uid_idx` (`pay_uid`),
    107. 

  107.   KEY `buy_order_month_idx` (`for_month`)
    108. 

  108. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付订单成功后的子订单';
    109. 

  109. 

  110. /*Data for the table `t_sb_buy_order` */
    111. 

  111. 

  112. 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');
    113. 

  113. 

  114. /*Table structure for table `t_sb_buy_payer` */
    115. 

  115. 

  116. DROP TABLE IF EXISTS `t_sb_buy_payer`;
    117. 

  117. 

  118. CREATE TABLE `t_sb_buy_payer` (
    119. 

  119.   `buy_no` varchar(32) NOT NULL,
    120. 

  120.   `pay_uid` int(10) unsigned NOT NULL,
    121. 

  121.   `pay_channel` varchar(32) NOT NULL,
    122. 

  122.   `buyer_id` varchar(32) DEFAULT NULL COMMENT '支付宝用户号/腾讯openID',
    123. 

  123.   `buyer_acc` varchar(32) DEFAULT NULL COMMENT '帐号、邮箱等',
    124. 

  124.   PRIMARY KEY (`buy_no`)
    125. 

  125. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付成功后的相关信息';
    126. 

  126. 

  127. /*Data for the table `t_sb_buy_payer` */
    128. 

  128. 

  129. /*Table structure for table `t_sb_buy_user` */
    130. 

  130. 

  131. DROP TABLE IF EXISTS `t_sb_buy_user`;
    132. 

  132. 

  133. CREATE TABLE `t_sb_buy_user` (
    134. 

  134.   `buy_no` varchar(32) NOT NULL COMMENT '购买订单号',
    135. 

  135.   `id_card` varchar(20) NOT NULL COMMENT '身份证',
    136. 

  136.   `user_name` varchar(32) NOT NULL COMMENT '订单受益人姓名',
    137. 

  137.   `nation` varchar(20) NOT NULL COMMENT '民族',
    138. 

  138.   `gender` tinyint(1) NOT NULL COMMENT '性别',
    139. 

  139.   `phone` varchar(16) NOT NULL COMMENT '联系方式',
    140. 

  140.   `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
    141. 

  141.   `recon_result` tinyint(4) NOT NULL DEFAULT '0' COMMENT '核对结果',
    142. 

  142.   PRIMARY KEY (`buy_no`)
    143. 

  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='参保人资料';
    144. 

  144. 

  145. /*Data for the table `t_sb_buy_user` */
    146. 

  146. 

  147. 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);
    148. 

  148. 

  149. /*Table structure for table `t_sb_city` */
    150. 

  150. 

  151. DROP TABLE IF EXISTS `t_sb_city`;
    152. 

  152. 

  153. CREATE TABLE `t_sb_city` (
    154. 

  154.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    155. 

  155.   `city_code` smallint(6) NOT NULL COMMENT '城市编码',
    156. 

  156.   `shebao_type` varchar(32) DEFAULT '' COMMENT '社保类型(标准、豪华等)',
    157. 

  157.   `proxy_type` tinyint(3) unsigned DEFAULT NULL COMMENT '代理员工增减员方式1~8',
    158. 

  158.   `shebao_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的社保服务费',
    159. 

  159.   `shebao_card_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的代办社保卡服务费',
    160. 

  160.   `fund_charge` decimal(6,2) DEFAULT NULL COMMENT '本城市的公积金服务费',
    161. 

  161.   `package_charge` decimal(6,2) DEFAULT NULL COMMENT '社保、公积金打包服务费',
    162. 

  162.   `end_date` tinyint(4) DEFAULT NULL COMMENT '月购买日期区分',
    163. 

  163.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    164. 

  164.   PRIMARY KEY (`id`)
    165. 

  165. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='各城市、户藉的社保数据--主表';
    166. 

  166. 

  167. /*Data for the table `t_sb_city` */
    168. 

  168. 

  169. 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');
    170. 

  170. 

  171. /*Table structure for table `t_sb_city_data` */
    172. 

  172. 

  173. DROP TABLE IF EXISTS `t_sb_city_data`;
    174. 

  174. 

  175. CREATE TABLE `t_sb_city_data` (
    176. 

  176.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    177. 

  177.   `cid` int(10) unsigned NOT NULL COMMENT '见T_SB_CITY',
    178. 

  178.   `hukou_type` tinyint(4) NOT NULL COMMENT '户籍性质',
    179. 

  179.   `pension` varchar(64) DEFAULT NULL COMMENT '养老',
    180. 

  180.   `medical` varchar(64) DEFAULT NULL COMMENT '医疗',
    181. 

  181.   `lose_job` varchar(64) DEFAULT NULL COMMENT '失业保险',
    182. 

  182.   `birth` varchar(64) DEFAULT NULL COMMENT '生育保险',
    183. 

  183.   `injury` varchar(64) DEFAULT NULL COMMENT '工伤',
    184. 

  184.   `major` varchar(64) DEFAULT NULL COMMENT '住院/重大',
    185. 

  185.   `village` varchar(64) DEFAULT NULL COMMENT '农民工医疗',
    186. 

  186.   `supplement` decimal(8,2) DEFAULT NULL COMMENT '补充医疗',
    187. 

  187.   `disabled` decimal(8,2) DEFAULT NULL COMMENT '残保金',
    188. 

  188.   `fund` varchar(64) DEFAULT NULL COMMENT '公积金最低额度',
    189. 

  189.   PRIMARY KEY (`id`)
    190. 

  190. ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='各城市、户藉的社保数据(ID与各户籍性质的社保数据)';
    191. 

  191. 

  192. /*Data for the table `t_sb_city_data` */
    193. 

  193. 

  194. 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}');
    195. 

  195. 

  196. /*Table structure for table `t_sb_msg` */
    197. 

  197. 

  198. DROP TABLE IF EXISTS `t_sb_msg`;
    199. 

  199. 

  200. CREATE TABLE `t_sb_msg` (
    201. 

  201.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    202. 

  202.   `u_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户标识',
    203. 

  203.   `msg_type` tinyint(3) unsigned NOT NULL COMMENT '消息类型',
    204. 

  204.   `platform` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '消息接收平台',
    205. 

  205.   `title` varchar(128) NOT NULL DEFAULT '' COMMENT '标题',
    206. 

  206.   `content` varchar(512) NOT NULL COMMENT '内容',
    207. 

  207.   `gen_sec` int(10) unsigned NOT NULL COMMENT '生成时间-秒',
    208. 

  208.   `counts` tinyint(1) unsigned NOT NULL DEFAULT '0',
    209. 

  209.   `sended` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已发送',
    210. 

  210.   `send_time` datetime DEFAULT NULL COMMENT '发送时间',
    211. 

  211.   PRIMARY KEY (`id`)
    212. 

  212. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
    213. 

  213. 

  214. /*Data for the table `t_sb_msg` */
    215. 

  215. 

  216. 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');
    217. 

  217. 

  218. /*Table structure for table `t_sb_msg_city` */
    219. 

  219. 

  220. DROP TABLE IF EXISTS `t_sb_msg_city`;
    221. 

  221. 

  222. CREATE TABLE `t_sb_msg_city` (
    223. 

  223.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    224. 

  224.   `citys` varchar(256) NOT NULL,
    225. 

  225.   `title` varchar(128) NOT NULL,
    226. 

  226.   `content` varchar(256) NOT NULL,
    227. 

  227.   `counts` tinyint(3) unsigned NOT NULL DEFAULT '0',
    228. 

  228.   `sended` tinyint(1) unsigned NOT NULL DEFAULT '0',
    229. 

  229.   `send_time` datetime DEFAULT NULL,
    230. 

  230.   PRIMARY KEY (`id`)
    231. 

  231. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='城市级消息';
    232. 

  232. 

  233. /*Data for the table `t_sb_msg_city` */
    234. 

  234. 

  235. 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');
    236. 

  236. 

  237. /*Table structure for table `t_sb_user` */
    238. 

  238. 

  239. DROP TABLE IF EXISTS `t_sb_user`;
    240. 

  240. 

  241. CREATE TABLE `t_sb_user` (
    242. 

  242.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    243. 

  243.   `u_id` int(10) unsigned NOT NULL COMMENT '用户标识',
    244. 

  244.   `id_card` varchar(20) NOT NULL COMMENT '身份证号码',
    245. 

  245.   `user_name` varchar(12) NOT NULL COMMENT '姓名',
    246. 

  246.   `nation` varchar(16) DEFAULT NULL COMMENT '民族',
    247. 

  247.   `gender` tinyint(4) DEFAULT NULL COMMENT '性别',
    248. 

  248.   `phone` varchar(12) DEFAULT NULL COMMENT '联系电话',
    249. 

  249.   `shebao_card` varchar(24) DEFAULT NULL COMMENT '社保卡号',
    250. 

  250.   `id_card_img` varchar(256) DEFAULT NULL COMMENT '正反面身份证图片链接',
    251. 

  251.   PRIMARY KEY (`id`),
    252. 

  252.   UNIQUE KEY `sb_user_uniq` (`u_id`,`id_card`),
    253. 

  253.   KEY `sb_user_uid` (`u_id`)
    254. 

  254. ) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 COMMENT='参保人身份数据(一个用户标识可对应多个参保人信息)';
    255. 

  255. 

  256. /*Data for the table `t_sb_user` */
    257. 

  257. 

  258. 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');
    259. 

  259. 

  260. /*Table structure for table `t_user` */
    261. 

  261. 

  262. DROP TABLE IF EXISTS `t_user`;
    263. 

  263. 

  264. CREATE TABLE `t_user` (
    265. 

  265.   `u_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '本系统的用户标识',
    266. 

  266.   `user_id` varchar(32) DEFAULT NULL COMMENT '兼容性用户ID',
    267. 

  267.   `phone` varchar(13) DEFAULT NULL COMMENT '手机号码',
    268. 

  268.   `password` varchar(32) DEFAULT NULL COMMENT '密码',
    269. 

  269.   `nick_name` varchar(20) DEFAULT NULL COMMENT '昵称',
    270. 

  270.   `head_img` varchar(64) NOT NULL DEFAULT '' COMMENT '头像图片链接',
    271. 

  271.   `reg_channel` varchar(12) NOT NULL DEFAULT '0' COMMENT '注册来源(手机注册、闪聘帐号、微信账号)',
    272. 

  272.   `reg_time` datetime DEFAULT NULL COMMENT '注册时间',
    273. 

  273.   `login_time` datetime DEFAULT NULL COMMENT '登录时间',
    274. 

  274.   PRIMARY KEY (`u_id`),
    275. 

  275.   UNIQUE KEY `user_phone_idx` (`phone`)
    276. 

  276. ) ENGINE=InnoDB AUTO_INCREMENT=1000010 DEFAULT CHARSET=utf8 COMMENT='用户基本信息表';
    277. 

  277. 

  278. /*Data for the table `t_user` */
    279. 

  279. 

  280. 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');
    281. 

  281. 

  282. /*Table structure for table `t_user_flag` */
    283. 

  283. 

  284. DROP TABLE IF EXISTS `t_user_flag`;
    285. 

  285. 

  286. CREATE TABLE `t_user_flag` (
    287. 

  287.   `u_id` int(10) unsigned NOT NULL,
    288. 

  288.   `version` varchar(12) DEFAULT '1' COMMENT 'app版本',
    289. 

  289.   `platform` tinyint(1) unsigned DEFAULT NULL COMMENT 'app系统平台',
    290. 

  290.   `msg_read_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消息读取时间',
    291. 

  291.   `login_time` datetime NOT NULL COMMENT '登录时间',
    292. 

  292.   PRIMARY KEY (`u_id`)
    293. 

  293. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户标记表';
    294. 

  294. 

  295. /*Data for the table `t_user_flag` */
    296. 

  296. 

  297. 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');
    298. 

  298. 

  299. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    300. 

  300. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    301. 

  301. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    302. 

  302. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    303. 

  303.