/* 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=304 DEFAULT CHARSET=utf8; /*Data for the table `t_city_news` */ insert into `t_city_news`(`c_n_id`,`cid`,`nid`) values (1,1001,96),(2,1000,97),(3,1200,98),(4,1201,99),(5,1201,100),(6,1001,101),(7,1001,103),(8,1000,104),(9,1200,105),(10,1201,106),(11,1201,107),(12,1001,108),(13,1001,109),(14,1000,110),(15,1003,111),(16,1001,112),(17,1001,113),(18,1001,114),(19,1001,115),(20,1000,116),(21,1001,117),(22,1000,118),(23,1001,119),(24,1001,120),(25,1001,121),(26,1001,122),(27,1001,123),(28,1001,124),(29,1001,125),(30,1001,126),(31,1001,127),(32,1001,128),(33,3,129),(34,1,129),(35,2,129),(36,3,130),(37,1,130),(38,2,130),(39,3,131),(40,2,131),(41,1,131),(42,2,132),(43,1,132),(44,3,132),(45,3,133),(46,2,133),(47,1,133),(48,2,134),(49,1,134),(50,3,134),(51,2,135),(52,1,135),(53,3,135),(54,2,136),(55,3,136),(56,1,136),(57,3,137),(58,1,137),(59,2,137),(60,3,138),(61,1,138),(62,2,138),(63,3,139),(64,1,139),(65,2,139),(66,3,140),(67,2,140),(68,1,140),(69,3,141),(70,2,141),(71,1,141),(72,3,142),(73,1,142),(74,2,142),(75,3,143),(76,1,143),(77,2,143),(78,2,144),(79,1,144),(80,3,144),(81,3,145),(82,1,145),(83,2,145),(84,3,146),(85,2,146),(86,1,146),(87,2,147),(88,1,147),(89,3,147),(90,1,148),(91,2,148),(92,3,148),(93,2,149),(94,3,149),(95,1,149),(96,3,150),(97,2,150),(98,1,150),(99,3,151),(100,1,151),(101,2,151),(102,2,152),(103,1,152),(104,3,152),(105,1,153),(106,2,153),(107,3,153),(108,1,154),(109,3,154),(110,2,154),(111,2,155),(112,3,155),(113,1,155),(114,3,156),(115,2,156),(116,1,156),(117,3,157),(118,2,157),(119,1,157),(120,2,158),(121,1,158),(122,3,158),(123,3,159),(124,1,159),(125,2,159),(126,2,160),(127,1,160),(128,3,160),(129,1,161),(130,3,161),(131,2,161),(132,2,162),(133,3,162),(134,1,162),(135,1,163),(136,3,163),(137,2,163),(138,1,164),(139,2,164),(140,3,164),(141,3,165),(142,2,165),(143,1,165),(144,3,166),(145,1,166),(146,2,166),(147,3,167),(148,2,167),(149,1,167),(150,3,168),(151,1,168),(152,2,168),(153,3,169),(154,1,169),(155,2,169),(156,3,170),(157,2,170),(158,1,170),(159,2,171),(160,1,171),(161,3,171),(162,3,172),(163,1,172),(164,2,172),(165,3,173),(166,2,173),(167,1,173),(168,2,174),(169,1,174),(170,3,174),(171,2,175),(172,3,175),(173,1,175),(174,2,176),(175,1,176),(176,3,176),(177,1,177),(178,2,177),(179,3,177),(180,1,178),(181,2,178),(182,3,178),(183,3,179),(184,2,179),(185,1,179),(186,2,180),(187,3,180),(188,1,180),(189,3,181),(190,2,181),(191,1,181),(192,1,182),(193,3,182),(194,2,182),(195,1,183),(196,3,183),(197,2,183),(198,3,184),(199,1,184),(200,2,184),(201,3,185),(202,1,185),(203,2,185),(204,2,186),(205,3,186),(206,1,186),(207,2,187),(208,1,187),(209,3,187),(210,3,188),(211,1,188),(212,2,188),(213,3,189),(214,1,189),(215,2,189),(216,2,190),(217,3,190),(218,1,190),(219,1,191),(220,3,191),(221,2,191),(222,3,192),(223,1,192),(224,2,192),(225,1,193),(226,3,193),(227,2,193),(228,1,194),(229,2,194),(230,3,194),(231,2,195),(232,3,195),(233,1,195),(234,3,196),(235,2,196),(236,1,196),(237,3,197),(238,2,197),(239,1,197),(240,1,198),(241,3,198),(242,2,198),(243,2,199),(244,3,199),(245,1,199),(246,2,200),(247,1,200),(248,3,200),(249,1,201),(250,2,201),(251,3,201),(252,2,202),(253,1,202),(254,3,202),(255,2,203),(256,3,203),(257,1,203),(258,3,204),(259,2,204),(260,1,204),(261,1,205),(262,2,205),(263,3,205),(264,3,206),(265,1,206),(266,2,206),(267,1,207),(268,2,207),(269,3,207),(270,2,208),(271,3,208),(272,1,208),(273,2,209),(274,3,209),(275,1,209),(276,1,210),(277,3,210),(278,2,210),(279,1,211),(280,3,211),(281,2,211),(282,2,212),(283,3,212),(284,1,212),(285,2,213),(286,1,213),(287,3,213),(291,3,215),(292,2,215),(293,1,215),(294,3,216),(295,1,216),(296,2,216),(297,2,217),(298,1,217),(299,3,217),(300,3,218),(301,2,218),(302,1,218),(303,1001,219); /*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=220 DEFAULT CHARSET=utf8; /*Data for the table `t_news` */ insert into `t_news`(`nid`,`title`,`content`,`publish_time`) values (96,'社会上存在一些暂时待业的劳动者','社会上存在一些暂时待业的劳动者，或者公司没有按照正常法律法规给员工购买社保产品的劳动者，他们没有很好的途径自己缴纳社保和公积金。但是要取得买房、买车、小孩上学等资格，他们必须要连续缴满一定年限的社保或公积金，所以这一部分人需要找到相关资格的公司挂靠社保和公积金。','2015-08-27 17:35:48'),(97,'实现客户端买社保，买公积金','实现客户端买社保，买公积金，查询在我们平台的购买历史等基本功能','2015-08-27 17:36:05'),(98,'APP的默认首页','“首页”为APP的默认首页，顶部banner主要用于品牌宣传和促销活动，由研发配置文件决定，后台不提供自由配置功能。\r\nBanner下面展示社保和公积金2个产品，点击可以查看产品详细内容，或者直接点击购买，进入购买流程。\r\n','2015-08-27 17:36:25'),(99,'详情页面底部按钮包含“我要咨询”和“我要购买”','3. 详情页面底部按钮包含“我要咨询”和“我要购买”\r\na) 点击我要咨讯，弹出400电话\r\nb) 点击我要购买\r\ni. 如果没有登录，提示登录；\r\nii. 如果已经登录，弹框提示：您是否确定选择xx地区xx（户籍性质）的标准社保套餐。点击确定，进入第4步；点击重新选择，返回社保详情页\r\n','2015-08-27 17:36:48'),(100,'写“参保人信息”','写“参保人信息”\r\na) 该用户的参保人列表信息为空，填写以下字段，成功购买后自动保存信息到担保人列表\r\ni. 拍摄身份证正反面\r\nii. 姓名 （可以从拍摄的照片获取则从照片获取并自动填写）\r\niii. 身份证号（可以从拍摄的照片获取则从照片获取并自动填写）\r\niv. 民族（可以从拍摄的照片获取则从照片获取并自动填写）\r\nv. 手机号\r\nb) 该用户的参保人列表信息为非空，默认展示可以参保的最新参保人信息，参保人信息可以被修改，修改购买成功后保存修改后的信息。 如果参保人正在参保，其不可以重复购买参保时段的社保。\r\n','2015-08-27 17:37:13'),(101,'社保和公积金购买历史记录查询','只能登录状态下使用，提供该注册用户的关联参保人的社保和公积金购买历史记录查询。','2015-08-28 15:12:35'),(102,'用户个人信息，登录模块，消息，版本更新等功能','用户个人信息，登录模块，消息，版本更新等功能','2015-08-28 15:12:51'),(103,'所在城市目前支持15个','2. 选择所在城市，所属户籍，查看该属地该户籍的社保详情。\r\na) 所在城市目前支持15个，具体城市列表参看附录\r\nb) 所属户籍：本市城镇、本市农村、外地城镇、外地农村\r\n','2015-08-28 15:13:29'),(104,'填写“参保信息”','5. 填写“参保信息”，包括：\r\na) 开始时间：系统判断最早的开始时间，规则是：每月的14号（包含）前，开始时间最早可以为当月，最晚为当月开始算起6个月；每月的15号（包含）后，开始时间最早可以为次月，最晚为当月开始算起6个月。\r\nb) 是否办社保卡：可以选择是或否\r\nc) 是否打包购公积金\r\ni. 选择是，展示缴存金额供客户选择 （提示上下限），并展示小计金额（缴存金额+服务费），如果超出上下限弹框提示\r\nii. 选择否，不展示缴存金额\r\n','2015-08-28 15:14:41'),(105,'购买社保为单月购买形式','6. 点击下一步，进入支付页面。页面展示订单支付页面：包括金额，产品，参保姓名，参保时间，参保城市。选择支付方式，支持支付宝和微信支付。\r\n7. 跳转支付页面，支付完成，跳转“我的社保”的支付完成分享页。\r\n8. 购买社保为单月购买形式，购买成功后，以后每月采取划扣形式，划口时间为每月10-14日。\r\n','2015-08-28 15:15:56'),(106,'支持登录状态下查询','1. 支持登录状态下查询，非登录状态直接跳转登录框。\r\n2. 查询支持社保和公积金查询。\r\n3. 登录状态下，如果没有任何购买记录，则提示无购买记录\r\n4. 登录状态下，如果有购买记录，用户可以选择参保人。选择“社保查询”或者“公积金查询”。\r\n5. 该页面提供“申请停保”/“取消公积金”选项，点击选项，弹框选择停保/取消公积金月份。停保/取消的时间规则为：当月购买的（订单已生成并付款完成）不可以取消；每月的9号（含）前，停止时间最早可以为当月，最晚为当月开始算起6个月；每月的10号（含）后，停止时间最早可以为次月，最晚为当月开始算起6个月。\r\n','2015-08-28 15:16:30'),(107,'查询状态包括（以社保为例，公积金类似）','6. 查询状态包括（以社保为例，公积金类似）：\r\na) 未购买\r\ni. 没有申请买保险\r\nii. 账户余额不足扣款不成功 （每月10号-14号检查账户余额）\r\niii. 停保成功\r\nb) 已付款：已经付钱给我的社保平台，但是还没有打款到社保局：\r\ni. 需要增员：增员成功前\r\nii. 无需增员： \r\nc) 已上保\r\ni. 已经成功打款到社保局 ：后台操作增员成功，后台操作在保人员核对\r\nd) 待停保\r\ni. 已经申请停保，但是还没减员成功。减员成功后改为“未购买”状态\r\n如果已经有待停保记录，用户重复提交停保记录的，系统提示“亲，你已经提交了x年x月的停保操作，如果要更改停保月份，请先到x年x月的查询记录下取消停保后再操作。”\r\ne) 待付款\r\ni. 只是一个状态，没有对应的订单。但是提示付款时间为当月10-14日。\r\n','2015-08-28 15:18:28'),(108,'我的消息：登录后可看','1. 注册：\r\n注册：手机号码注册，须输入手机号码、密码和验证码\r\n2. 登录\r\n手机号码+登录密码登录。登录页面提供“注册”和“忘记密码”选项。注册见本小节1注册； “忘记密码”见本小节“修改密码”内容。\r\n用户登录成功后，“我的”界面顶部展示用户电话，点击进去可以修改手机，修改密码和退出登录。\r\n修改手机：需要输入新的手机号码和验证码。\r\n修改密码：需要输入手机号码，验证码和新密码。\r\n参保人信息：登录后可看，当购买社保或者公积金成功后，自动保存参保人信息\r\n3. 我的消息：登录后可看。消息模板见附录3.2\r\n4. 分享：非登录功能，分享客户端下载二维码。支持分享微信好友、微信朋友圈、QQ、QQ空间和新浪微博。\r\n','2015-08-28 15:25:42'),(109,'我的社保运营后台','2 我的社保运营后台\r\n2.1 业务概述\r\n现状和问题：\r\n要实现我的社保客户端，需要建立一个相对完整的后台运营系统，管理订单数据，同时部分后台操作，反馈数据到客户端。\r\n业务目标：\r\n实现用户管理，订单管理，增减员管理和在保员工管理等功能。\r\n','2015-08-29 15:19:36'),(110,'我的社保后台系统菜单栏','我的社保后台系统菜单栏为：用户管理、订单管理、员工管理和参数调整 4部分。\r\n用户管理：展示所有平台上的用户\r\n订单管理：所有通过客户端购买社保、公积金产品的订单，所有自动生成的订单。\r\n员工管理：历史月份的增减员名单和在保人员名单。\r\n','2015-08-29 15:20:13'),(111,'用户管理展示在平台注册的用户','1． 用户管理展示在平台注册的用户。列表包含用户ID、联系电话和注册时间，按照注册时间由近到远排列。注册时间精确到秒。\r\n \r\n2． 可按照用户ID，联系电话和注册时间进行查询\r\n3． 每一页展示10行\r\n4． 支持选择批量导出功能。\r\n','2015-08-29 15:21:12'),(112,'订单有两种形式','1． 订单有两种形式：\r\na) 首次通过客户端购买社保产品和公积金产品，付款成功会产生订单。\r\nb) 首月购买订单成功付款后，以后每月代扣订单系统定时生成（自动生成订单），直到减员月份。并于每月10号~14号定时扣款（具体每天扣款时间点研发评估），每天检查一次账户余额，扣款成功后第二天不会请求扣款。扣款成功和不成功都推送相应的信息到客户端和手机短信。如果14号的扣款仍未成功，则做自动做减员操作。（这里需求设计是先产生订单，再扣款；具体顺序（先订单还是先代扣）需要配合支付宝的接口技术，请研发评估并反馈，谢谢！）\r\n','2015-08-29 15:23:42'),(113,'订单信息包含的内容','2． 订单信息生成后除了参保人信息可以被修改，其他都项目一旦生成不再改变。订单信息包含的内容：\r\na) 订单头信息 \r\n订单号：系统自动生成\r\n登录账号：购买社保/公积金时登录“我的社保”的账号（手机号码）\r\n订单状态：参看“订单状态“\r\n\r\nb) 参保人信息 （生成以后只允许后台修改，修改后不影响参保人表格。自动生成的订单参保人信息从上个月的订单信息获取）\r\n购买人：参保人姓名/购买公积金人的姓名 \r\n身份证号：参保人姓名/购买公积金人的身份证号码\r\n民族：参保人姓名/购买公积金人的民族\r\n性别：参保人姓名/购买公积金人的性别，从身份证号码判断\r\n购买城市：参保人姓名/购买公积金人的城市\r\n户籍性质：参保人姓名/购买公积金人的户籍性质 （本市城镇、本市农村、外地城镇、外地农村）\r\n参保人联系电话：参保人姓名/购买公积金人的联系电话\r\n\r\nc) 订单信息 （查询配置表产生金额，不允许修改）\r\n购买类型：社保、公积金、社保&公积金\r\n保险/公积金扣款月份：用户上社保的月份\r\n社保卡：选择需要、不需要；首次购买看用户选择，次月自动订单统一为“不需要“\r\n订单金额：订单总金额\r\n社保金额：社保金额\r\n公积金金额：公积金金额\r\n服务费：总的服务费 （如果两个产品，则为总的服务费用，暂定一个产品服务费59元，两个产品打包购服务费为99元）\r\n社保卡费用：配置表数据\r\n\r\nd) 支付信息\r\n流水号：付款后由支付宝/微信返回的号\r\n下单时间：订单生成时间\r\n支付方式：微信、支付宝\r\n支付帐号：支付宝或者微信的账号\r\n修改时间：\r\ne) 其他\r\n备注：可以修改，弹框文本输入，主要用于后台记录一些备忘录，例如退款x元。\r\n操作：修改，点击修改进入修改页。修改页面列出订单说有内容\r\n','2015-08-29 15:27:39'),(114,'订单的状态','3． 订单的状态：\r\na) 已完成 ：支付成功。如首次购买完成付款；自动生成的订单扣款成功\r\nb) 未完成 ：未完成支付。自动生成订单的初始状态为未完成，扣款成功状态更新为已完成\r\nc) 无效：自动生成的订单14号仍然未完成支付，则设为无效\r\n','2015-08-29 15:43:49'),(115,'增员表按月展示','1． 增员表按月展示。每个月的增员表记录了当月首次购买的参保人信息。购买者在平台购买产品付款成功，则将其信息记到相应月份的增员表里。增员表包括：\r\n订单号：增员订单编号\r\n购买城市：参保人/购买公积金所在的城市\r\n姓名：参保人/购买公积金人的姓名\r\n身份证号码：参保人/购买公积金人的身份证号码\r\n性别：参保人/购买公积金人的性别\r\n民族：参保人/购买公积金人的民族\r\n户籍类型：参保人/购买公积金人的户籍类型（本地城镇、本地农村、外地城镇、外地农村）\r\n购买类型：社保、公积金、社保&公积金\r\n社保费：\r\n公积金金额：\r\n缴费金额：\r\n状态：未知、失败、成功。默认状态为未知；后台人员操作改变其状态。可以逐个修改或者批量导入修改状态。失败需要填写失败原因。状态更新为成功后则该参保人在客户端查询到的状态更新为“已上保“。批量导入修改状态的表的格式为：\r\n \r\n\r\n社保卡号：可以手动输入或者批量导入，输入完毕后给该用户（登录手机号）发短信和客户端消息。批量导入格式未：\r\n \r\n失败原因：文本。\r\n','2015-08-29 15:45:45'),(116,'减员表按月展示','1． 减员表按月展示。每个月的减员表记录了申请当月停保的参保人信息。\r\n购买城市：参保人/购买公积金所在的城市\r\n姓名：参保人/购买公积金人的姓名\r\n身份证号码：参保人/购买公积金人的身份证号码\r\n性别：参保人/购买公积金人的性别\r\n民族：参保人/购买公积金人的民族\r\n户籍类型：参保人/购买公积金人的户籍类型（本地城镇、本地农村、外地城镇、外地农村）\r\n购买类型：社保、公积金、社保&公积金\r\n状态：未知、失败、成功。默认状态为未知；后台人员操作改变其状态。可以逐个修改或者批量导入修改状态。失败需要填写失败原因。状态更新为成功后则该参保人在客户端查询到的状态更新为“未购买“。批量导入修改状态的表的格式为：\r\n \r\n失败原因：文本。\r\n减员表格：\r\n \r\n2． 可以按照订单号，城市，姓名，身份证号，购买类型，户籍类型，社保金额，公积金金额查询\r\n3． 提供批量导出、批量修改为成功、批量修改为失败（弹框输入失败理由）、批量导入修改状态，批量修改社保号操作。\r\n','2015-09-02 10:44:33'),(117,'代理员工表按月展示','1． 代理员工表按月展示。每个月记录了当月在保人员的信息。当月在保人员来源于：上个月的所有人员，除去当月申请减员成功的，除去当月扣费失败的，加上当月增员成功的。\r\n2． 代理员工表格内容包括：\r\n订单号：该参保人员对应该月的扣费订单号\r\n购买城市：参保人/购买公积金所在的城市\r\n姓名：参保人/购买公积金人的姓名\r\n身份证号码：参保人/购买公积金人的身份证号码\r\n性别：参保人/购买公积金人的性别\r\n民族：参保人/购买公积金人的民族\r\n户籍类型：参保人/购买公积金人的户籍类型（本地城镇、本地农村、外地城镇、外地农村）\r\n购买类型：社保、公积金、社保&公积金\r\n','2015-09-02 10:47:50'),(118,'核对结果','核对结果：默认为空。后台人员可以上传地税系统数据，进行匹配，并判断核对结果是否一致。线下操作人员在地税缴费后会从地税得到一份缴费明细，通过地税系统的缴费明细与我们系统的在保人员缴费明细核对，可以进一步确保对账。当上传核对完，核对列不为空，则表示在地税缴费成功，更新在报人员在客户端的查询状态 （“已付款“改成”已上保“）。本月新增员由于在增员表更新状态时已经更新过客户端状态，可不用这个结果作为”已上保“标志。\r\n核对表格格式如下，只有社保非和公积金都一直，核对结果为“一致“，否则为”不一致“\r\n \r\n','2015-09-02 11:08:07'),(119,'支持后台群发消息','1． 支持后台群发消息，群发消息包括：\r\n消息标题、消息内容、群发城市。确定群发后该消息的内容会被发到有购买相关城市产品的用户客户端和短信。\r\n2． 曾经群发的消息保留在列表，包括标题，时间，可以进行删除操作。点击每一条消息可以查看内容。\r\n','2015-09-02 11:11:46'),(120,'购买成功（保单生效）','1． 购买成功（保单生效）\r\n触发：订单付款成功\r\n消息模板：【我的社保】谢谢您使用“我的社保”产品。您已成功购买2015年7月社保，我们将会有专人为您办理社保事宜，并将及时跟进并通知您上保情况！\r\n','2015-09-02 11:25:12'),(121,'增员成功（保单生效）:','2． 增员成功（保单生效）:\r\n触发：后台提交增员成功\r\n消息模板：【我的社保】您的社保申请已经成功审批，申请的首次上保月份为2015年x月。\r\n','2015-09-02 11:26:00'),(122,'增员失败（购买失败）:','3． 增员失败（购买失败）:\r\n触发：后台提交增员失败\r\n消息模板：【我的社保】很遗憾，您的社保申请审批失败，失败原因是xxx。我们将会有专人跟您联系，沟通退款事宜。请耐心等待。\r\n','2015-09-02 11:26:34'),(123,'代扣成功 ','4． 代扣成功 \r\n触发：月代扣订单付款成功\r\n消息模板：【我的社保】2015年7月份的社保费用已经成功扣费。\r\n','2015-09-02 11:26:55'),(124,'代扣失败 ','5． 代扣失败 \r\n触发：月代扣订单付款失败\r\n消息模板：【我的社保】2015年7月份的社保费用扣除失败，请及时检查余额，于本月14日前把足够存款存到您的划扣账户，否则按停保处理。谢谢配合！\r\n','2015-09-02 11:27:09'),(125,'停保申请','6． 停保申请\r\n触发：客户提交减员成功\r\n消息模板：【我的社保】您的停保申请已经成功提交，申请停保月份为2015年x月。我们将会及时通知您审批结果。请耐心等待。\r\n','2015-09-02 11:27:19'),(126,'减员成功 （停保成功）','7． 减员成功 （停保成功）\r\n触发：后台提交减员成功\r\n消息模板：【我的社保】您的停保申请已经成功审批，停保月份为2015年x月。从2015年x月以后，“我的社保”平台将不再代理您的社保。\r\n','2015-09-02 11:27:32'),(127,'减员失败 （停保失败）','8． 减员失败 （停保失败）\r\n触发：后台提交减员成功\r\n消息模板：【我的社保】很遗憾，您的停保申请失败，失败原因是xxx。\r\n','2015-09-02 11:27:45'),(128,'缴费基数调整通知 （社保）','9． 缴费基数调整通知 （社保）\r\n触发：后台编辑\r\n消息模板：后台编辑\r\n','2015-09-02 11:27:56'),(129,'title 10','content 10','2015-09-08 15:24:07'),(130,'title 11','content 11','2015-09-08 15:24:07'),(131,'title 12','content 12','2015-09-08 15:24:08'),(132,'title 13','content 13','2015-09-08 15:24:08'),(133,'title 14','content 14','2015-09-08 15:24:08'),(134,'title 15','content 15','2015-09-08 15:24:08'),(135,'title 16','content 16','2015-09-08 15:24:08'),(136,'title 17','content 17','2015-09-08 15:24:09'),(137,'title 18','content 18','2015-09-08 15:24:09'),(138,'title 19','content 19','2015-09-08 15:24:09'),(139,'title 20','content 20','2015-09-08 15:24:09'),(140,'title 21','content 21','2015-09-08 15:24:09'),(141,'title 22','content 22','2015-09-08 15:24:09'),(142,'title 23','content 23','2015-09-08 15:24:10'),(143,'title 24','content 24','2015-09-08 15:24:10'),(144,'title 25','content 25','2015-09-08 15:24:10'),(145,'title 26','content 26','2015-09-08 15:24:10'),(146,'title 27','content 27','2015-09-08 15:24:10'),(147,'title 28','content 28','2015-09-08 15:24:10'),(148,'title 29','content 29','2015-09-08 15:24:10'),(149,'title 30','content 30','2015-09-08 15:24:11'),(150,'title 31','content 31','2015-09-08 15:24:11'),(151,'title 32','content 32','2015-09-08 15:24:11'),(152,'title 33','content 33','2015-09-08 15:24:11'),(153,'title 34','content 34','2015-09-08 15:24:11'),(154,'title 35','content 35','2015-09-08 15:24:11'),(155,'title 36','content 36','2015-09-08 15:24:11'),(156,'title 37','content 37','2015-09-08 15:24:12'),(157,'title 38','content 38','2015-09-08 15:24:12'),(158,'title 39','content 39','2015-09-08 15:24:12'),(159,'title 40','content 40','2015-09-08 15:24:12'),(160,'title 41','content 41','2015-09-08 15:24:12'),(161,'title 42','content 42','2015-09-08 15:24:12'),(162,'title 43','content 43','2015-09-08 15:24:12'),(163,'title 44','content 44','2015-09-08 15:24:13'),(164,'title 45','content 45','2015-09-08 15:24:13'),(165,'title 46','content 46','2015-09-08 15:24:13'),(166,'title 47','content 47','2015-09-08 15:24:13'),(167,'title 48','content 48','2015-09-08 15:24:13'),(168,'title 49','content 49','2015-09-08 15:24:13'),(169,'title 50','content 50','2015-09-08 15:24:14'),(170,'title 51','content 51','2015-09-08 15:24:14'),(171,'title 52','content 52','2015-09-08 15:24:14'),(172,'title 53','content 53','2015-09-08 15:24:14'),(173,'title 54','content 54','2015-09-08 15:24:14'),(174,'title 55','content 55','2015-09-08 15:24:14'),(175,'title 56','content 56','2015-09-08 15:24:15'),(176,'title 57','content 57','2015-09-08 15:24:15'),(177,'title 58','content 58','2015-09-08 15:24:15'),(178,'title 59','content 59','2015-09-08 15:24:16'),(179,'title 60','content 60','2015-09-08 15:24:16'),(180,'title 61','content 61','2015-09-08 15:24:16'),(181,'title 62','content 62','2015-09-08 15:24:16'),(182,'title 63','content 63','2015-09-08 15:24:17'),(183,'title 64','content 64','2015-09-08 15:24:17'),(184,'title 65','content 65','2015-09-08 15:24:17'),(185,'title 66','content 66','2015-09-08 15:24:17'),(186,'title 67','content 67','2015-09-08 15:24:18'),(187,'title 68','content 68','2015-09-08 15:24:18'),(188,'title 69','content 69','2015-09-08 15:24:19'),(189,'title 70','content 70','2015-09-08 15:24:19'),(190,'title 71','content 71','2015-09-08 15:24:19'),(191,'title 72','content 72','2015-09-08 15:24:19'),(192,'title 73','content 73','2015-09-08 15:24:19'),(193,'title 74','content 74','2015-09-08 15:24:19'),(194,'title 75','content 75','2015-09-08 15:24:20'),(195,'title 76','content 76','2015-09-08 15:24:20'),(196,'title 77','content 77','2015-09-08 15:24:20'),(197,'title 78','content 78','2015-09-08 15:24:20'),(198,'title 79','content 79','2015-09-08 15:24:21'),(199,'title 80','content 80','2015-09-08 15:24:21'),(200,'title 81','content 81','2015-09-08 15:24:21'),(201,'title 82','content 82','2015-09-08 15:24:21'),(202,'title 83','content 83','2015-09-08 15:24:22'),(203,'title 84','content 84','2015-09-08 15:24:22'),(204,'title 85','content 85','2015-09-08 15:24:22'),(205,'title 86','content 86','2015-09-08 15:24:22'),(206,'title 87','content 87','2015-09-08 15:24:22'),(207,'title 88','content 88','2015-09-08 15:24:22'),(208,'title 89','content 89','2015-09-08 15:24:22'),(209,'title 90','content 90','2015-09-08 15:24:23'),(210,'title 91','content 91','2015-09-08 15:24:23'),(211,'title 92','content 92','2015-09-08 15:24:23'),(212,'title 93','content 93','2015-09-08 15:24:23'),(213,'title 94','content 94','2015-09-08 15:24:23'),(215,'title 96','content 96','2015-09-08 15:24:24'),(216,'title 97','content 97','2015-09-08 15:24:24'),(217,'title 98','content 98','2015-09-08 15:24:24'),(218,'title 99','content 99','2015-09-08 15:24:24'),(219,'ds','dsjkl','2015-09-08 19:25:57'); /*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 '新办卡服务费', `pay_no` varchar(128) NOT NULL DEFAULT '' COMMENT '第三方支付订单号', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态', `gen_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`buy_no`), KEY `buy_month_idx` (`start_month`) ) 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`,`pay_no`,`status`,`gen_time`) values ('0200000000012015253',1,0,'330322197709013613',201509,1,2,1,1,259.00,0.00,59.00,200.00,0.00,0.00,'testok0001',2,'2015-09-13 18:18:23'),('0300000000012015253',1,0,'330322197709013613',201510,1,3,1,1,1318.00,1000.00,99.00,200.00,0.00,0.00,'testok0002',2,'2015-09-16 18:18:23'); /*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 '办卡服务费', `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`,`isAuto`,`status`,`gen_time`) values ('030000000001201510','0300000000012015253',1,'330322197709013613',1001,3,201510,1000.00,0.00,259.00,99.00,0.00,0,2,'2015-09-16 14:23:58'); /*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 ('0200000000012015253','330322197709013613','倪建勋','汉',1,'13928559875',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=7 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,20.00,59.00,99.00,0,'2015-09-08 16:28:40'),(4,1002,'标准',1,59.00,10.00,59.00,90.00,15,'2015-08-21 14:43:27'),(5,1201,'标准',1,59.00,20.00,59.00,90.00,15,'2015-08-21 15:05:42'),(6,1003,'标准',0,2.00,2.00,2.00,2.00,0,'2015-09-08 19:55:24'); /*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=20 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,0.00,'{\"min\":200.0,\"max\":5331.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\":1234.0,\"max\":5000.0,\"e\":0.26,\"p\":0.0}','{\"min\":0.0,\"max\":0.0,\"e\":0.0,\"p\":0.0}',0.00,0.00,'{\"min\":300.0,\"max\":5300.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\":0.0,\"p\":0.0}',0.00,0.00,'{\"min\":303.0,\"max\":5303.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,0.00,'{\"min\":308.0,\"max\":5308.0,\"e\":5.0,\"p\":5.0}'),(12,4,1,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":3712.0,\"max\":3712.0,\"e\":5.0,\"p\":2.0}','{\"min\":1510.0,\"max\":13920.0,\"e\":0.5,\"p\":0.5}','{\"min\":3480.0,\"max\":3920.0,\"e\":0.9,\"p\":0.0}','{\"min\":2784.0,\"max\":13920.0,\"e\":0.45,\"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,37.02,NULL),(13,4,2,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":3712.0,\"max\":3712.0,\"e\":5.0,\"p\":2.0}','{\"min\":1510.0,\"max\":13920.0,\"e\":0.5,\"p\":0.5}','{\"min\":3480.0,\"max\":3920.0,\"e\":0.9,\"p\":0.0}','{\"min\":2784.0,\"max\":13920.0,\"e\":0.45,\"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,37.02,NULL),(14,4,3,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":3712.0,\"max\":3712.0,\"e\":5.0,\"p\":2.0}','{\"min\":1510.0,\"max\":13920.0,\"e\":0.5,\"p\":0.5}','{\"min\":3480.0,\"max\":3920.0,\"e\":0.9,\"p\":0.0}','{\"min\":2784.0,\"max\":13920.0,\"e\":0.45,\"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,37.02,NULL),(15,4,4,'{\"min\":2408.0,\"max\":14958.0,\"e\":13.0,\"p\":8.0}','{\"min\":3712.0,\"max\":3712.0,\"e\":5.0,\"p\":2.0}','{\"min\":1510.0,\"max\":13920.0,\"e\":0.5,\"p\":0.5}','{\"min\":3480.0,\"max\":3920.0,\"e\":0.9,\"p\":0.0}','{\"min\":2784.0,\"max\":13920.0,\"e\":0.45,\"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,37.02,NULL),(16,5,1,'{\"min\":2415.0,\"max\":12075.0,\"e\":20.0,\"p\":8.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":8.0,\"p\":2.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":2.0,\"p\":1.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":0.7,\"p\":0.0}','{\"min\":2415.0,\"max\":12075.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}',90.00,0.00,NULL),(17,5,2,'{\"min\":2415.0,\"max\":12075.0,\"e\":20.0,\"p\":8.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":8.0,\"p\":2.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":2.0,\"p\":1.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":0.7,\"p\":0.0}','{\"min\":2415.0,\"max\":12075.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}',90.00,0.00,NULL),(18,5,3,'{\"min\":2415.0,\"max\":12075.0,\"e\":20.0,\"p\":8.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":8.0,\"p\":2.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":2.0,\"p\":1.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":0.7,\"p\":0.0}','{\"min\":2415.0,\"max\":12075.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}',90.00,0.00,NULL),(19,5,4,'{\"min\":2415.0,\"max\":12075.0,\"e\":20.0,\"p\":8.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":8.0,\"p\":2.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":2.0,\"p\":1.0}','{\"min\":2415.0,\"max\":12075.0,\"e\":0.7,\"p\":0.0}','{\"min\":2415.0,\"max\":12075.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}',90.00,0.00,NULL); /*Table structure for table `t_sb_order` */ DROP TABLE IF EXISTS `t_sb_order`; CREATE TABLE `t_sb_order` ( `order_no` varchar(32) NOT NULL COMMENT '订单号', `u_id` int(10) unsigned NOT NULL COMMENT '用户ID', `id_card` varchar(20) NOT NULL COMMENT '身份证', `cid` int(10) unsigned NOT NULL COMMENT '社保数据编号', `user_name` varchar(32) NOT NULL COMMENT '订单受益人姓名', `hukou` tinyint(4) NOT NULL COMMENT '户口性质', `nation` varchar(20) DEFAULT NULL COMMENT '民族', `gender` tinyint(4) DEFAULT NULL COMMENT ' 性别', `phone` varchar(16) DEFAULT NULL COMMENT '联系方式', `gen_time` datetime DEFAULT NULL, `modify_time` datetime DEFAULT NULL COMMENT '修改时间', `recon_result` tinyint(4) DEFAULT '0' COMMENT '核对结果', PRIMARY KEY (`order_no`), KEY `order-u-id-idx` (`u_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单信息'; /*Data for the table `t_sb_order` */ insert into `t_sb_order`(`order_no`,`u_id`,`id_card`,`cid`,`user_name`,`hukou`,`nation`,`gender`,`phone`,`gen_time`,`modify_time`,`recon_result`) values ('0100000001020000000007201509',102,'345217634765433226',1,'鹅儿',1,'广泛',0,'13928556887','2015-09-04 10:12:49',NULL,0),('0200000000010000000001201509',1,'330322197709013613',1,'倪建勋',1,'汉',1,'13928559875','2015-09-07 10:44:20',NULL,0),('0200000000010000000002201509',1,'330322197709013638',1,'倪建勋',1,'汉',1,'13928559875','2015-09-07 11:13:15',NULL,0),('0200000000010000000003201509',1,'370303198803156013',1,'韩呈祥',1,'汉',1,'13928660978','2015-09-07 11:15:46',NULL,0),('0200000000010000000008201509',1,'370303198803156014',1,'韩呈祥',1,'汉',1,'13928556522','2015-09-03 20:12:35',NULL,0),('0200000001020000000007201509',102,'345217634765433226',1,'鹅儿',1,'广泛',0,'13928556887','2015-09-03 20:09:45',NULL,0),('0300000000010000000001201509',1,'330322197709013613',1,'倪建勋',2,'汉',1,'13928559875','2015-09-04 11:43:53',NULL,0),('0300000000010000000008201509',1,'370303198803156014',1,'韩呈祥',3,'汉',1,'13928556522','2015-09-08 12:01:19',NULL,0),('100010',10,'37000000000000010',1001,'zhang10',1,'',1,'13000000010','2015-09-01 13:06:00',NULL,1),('100011',11,'37000000000000011',1001,'zhang11',1,'',1,'13000000011','2015-09-01 13:06:01',NULL,0),('100012',12,'37000000000000012',1001,'zhang12',1,'',1,'13000000012','2015-09-01 13:06:01',NULL,0),('100013',13,'37000000000000013',1001,'zhang13',1,'',1,'13000000013','2015-09-01 13:06:01',NULL,0),('100014',14,'37000000000000014',1001,'zhang14',1,'',1,'13000000014','2015-09-01 13:06:01',NULL,0),('100015',15,'37000000000000015',1001,'zhang15',1,'',1,'13000000015','2015-09-01 13:06:01',NULL,0),('100016',16,'37000000000000016',1001,'zhang16',1,'',1,'13000000016','2015-09-01 13:06:01',NULL,0),('100017',17,'37000000000000017',1001,'zhang17',1,'',1,'13000000017','2015-09-01 13:06:01',NULL,0),('100018',18,'37000000000000018',1001,'zhang18',1,'',1,'13000000018','2015-09-01 13:06:01',NULL,0),('100019',19,'37000000000000019',1001,'zhang19',1,'',1,'13000000019','2015-09-01 13:06:01',NULL,0),('100020',20,'37000000000000020',1001,'zhang20',1,'',1,'13000000020','2015-09-01 13:06:01',NULL,1),('100021',21,'37000000000000021',1001,'zhang21',1,'',1,'13000000021','2015-09-01 13:06:01',NULL,0),('100022',22,'37000000000000022',1001,'zhang22',1,'',1,'13000000022','2015-09-01 13:06:01',NULL,0),('100023',23,'37000000000000023',1001,'zhang23',1,'',1,'13000000023','2015-09-01 13:06:01',NULL,0),('100024',24,'37000000000000024',1001,'zhang24',1,'',1,'13000000024','2015-09-01 13:06:01',NULL,0),('100025',25,'37000000000000025',1001,'zhang25',1,'',1,'13000000025','2015-09-01 13:06:01',NULL,0),('100026',26,'37000000000000026',1001,'zhang26',1,'',1,'13000000026','2015-09-01 13:06:01',NULL,0),('100027',27,'37000000000000027',1001,'zhang27',1,'',1,'13000000027','2015-09-01 13:06:02',NULL,0),('100028',28,'37000000000000028',1001,'zhang28',1,'',1,'13000000028','2015-09-01 13:06:02',NULL,0),('100029',29,'37000000000000029',1001,'zhang29',1,'',1,'13000000029','2015-09-01 13:06:02',NULL,0),('100030',30,'37000000000000030',1001,'zhang30',1,'',1,'13000000030','2015-09-01 13:06:02',NULL,1),('100031',31,'37000000000000031',1001,'zhang31',1,'',1,'13000000031','2015-09-01 13:06:02',NULL,0),('100032',32,'37000000000000032',1001,'zhang32',1,'',1,'13000000032','2015-09-01 13:06:02',NULL,0),('100033',33,'37000000000000033',1001,'zhang33',1,'',1,'13000000033','2015-09-01 13:06:02',NULL,0),('100034',34,'37000000000000034',1001,'zhang34',1,'',1,'13000000034','2015-09-01 13:06:02',NULL,0),('100035',35,'37000000000000035',1001,'zhang35',1,'',1,'13000000035','2015-09-01 13:06:02',NULL,0),('100036',36,'37000000000000036',1001,'zhang36',1,'',1,'13000000036','2015-09-01 13:06:02',NULL,0),('100037',37,'37000000000000037',1001,'zhang37',1,'',1,'13000000037','2015-09-01 13:06:02',NULL,0),('100038',38,'37000000000000038',1001,'zhang38',1,'',1,'13000000038','2015-09-01 13:06:02',NULL,0),('100039',39,'37000000000000039',1001,'zhang39',1,'',1,'13000000039','2015-09-01 13:06:02',NULL,0),('100040',40,'37000000000000040',1001,'zhang40',1,'',1,'13000000040','2015-09-01 13:06:02',NULL,2),('100041',41,'37000000000000041',1001,'zhang41',1,'',1,'13000000041','2015-09-01 13:06:02',NULL,0),('100042',42,'37000000000000042',1001,'zhang42',1,'',1,'13000000042','2015-09-01 13:06:02',NULL,0),('100043',43,'37000000000000043',1001,'zhang43',1,'',1,'13000000043','2015-09-01 13:06:02',NULL,0),('100044',44,'37000000000000044',1001,'zhang44',1,'',1,'13000000044','2015-09-01 13:06:02',NULL,0),('100045',45,'37000000000000045',1001,'zhang45',1,'',1,'13000000045','2015-09-01 13:06:02',NULL,0),('100046',46,'37000000000000046',1001,'zhang46',1,'',1,'13000000046','2015-09-01 13:06:02',NULL,0),('100047',47,'37000000000000047',1001,'zhang47',1,'',1,'13000000047','2015-09-01 13:06:02',NULL,0),('100048',48,'37000000000000048',1001,'zhang48',1,'',1,'13000000048','2015-09-01 13:06:02',NULL,0),('100049',49,'37000000000000049',1001,'zhang49',1,'',1,'13000000049','2015-09-01 13:06:02',NULL,0),('100050',50,'37000000000000050',1001,'zhang50',1,'',1,'13000000050','2015-09-01 13:06:02',NULL,1),('100051',51,'37000000000000051',1001,'zhang51',1,'',1,'13000000051','2015-09-01 13:06:02',NULL,0),('100052',52,'37000000000000052',1001,'zhang52',1,'',1,'13000000052','2015-09-01 13:06:02',NULL,0),('100053',53,'37000000000000053',1001,'zhang53',1,'',1,'13000000053','2015-09-01 13:06:02',NULL,0),('100054',54,'37000000000000054',1001,'zhang54',1,'',1,'13000000054','2015-09-01 13:06:02',NULL,0),('100055',55,'37000000000000055',1001,'zhang55',1,'',1,'13000000055','2015-09-01 13:06:02',NULL,0),('100056',56,'37000000000000056',1001,'zhang56',1,'',1,'13000000056','2015-09-01 13:06:02',NULL,0),('100057',57,'37000000000000057',1001,'zhang57',1,'',1,'13000000057','2015-09-01 13:06:03',NULL,0),('100058',58,'37000000000000058',1001,'zhang58',1,'',1,'13000000058','2015-09-01 13:06:03',NULL,0),('100059',59,'37000000000000059',1001,'zhang59',1,'',1,'13000000059','2015-09-01 13:06:03',NULL,0),('100060',60,'37000000000000060',1001,'zhang60',1,'',1,'13000000060','2015-09-01 13:06:03',NULL,2),('100061',61,'37000000000000061',1001,'zhang61',1,'',1,'13000000061','2015-09-01 13:06:03',NULL,0),('100062',62,'37000000000000062',1001,'zhang62',1,'',1,'13000000062','2015-09-01 13:06:03',NULL,0),('100063',63,'37000000000000063',1001,'zhang63',1,'',1,'13000000063','2015-09-01 13:06:03',NULL,0),('100064',64,'37000000000000064',1001,'zhang64',1,'',1,'13000000064','2015-09-01 13:06:03',NULL,0),('100065',65,'37000000000000065',1001,'zhang65',1,'',1,'13000000065','2015-09-01 13:06:03',NULL,0),('100066',66,'37000000000000066',1001,'zhang66',1,'',1,'13000000066','2015-09-01 13:06:03',NULL,0),('100067',67,'37000000000000067',1001,'zhang67',1,'',1,'13000000067','2015-09-01 13:06:03',NULL,0),('100068',68,'37000000000000068',1001,'zhang68',1,'',1,'13000000068','2015-09-01 13:06:03',NULL,0),('100069',69,'37000000000000069',1001,'zhang69',1,'',1,'13000000069','2015-09-01 13:06:03',NULL,0),('100070',70,'37000000000000070',1001,'zhang70',1,'',1,'13000000070','2015-09-01 13:06:03',NULL,1),('100071',71,'37000000000000071',1001,'zhang71',1,'',1,'13000000071','2015-09-01 13:06:03',NULL,0),('100072',72,'37000000000000072',1001,'zhang72',1,'',1,'13000000072','2015-09-01 13:06:03',NULL,0),('100073',73,'37000000000000073',1001,'zhang73',1,'',1,'13000000073','2015-09-01 13:06:03',NULL,0),('100074',74,'37000000000000074',1001,'zhang74',1,'',1,'13000000074','2015-09-01 13:06:03',NULL,0),('100075',75,'37000000000000075',1001,'zhang75',1,'',1,'13000000075','2015-09-01 13:06:03',NULL,1),('100076',76,'37000000000000076',1001,'zhang76',1,'',1,'13000000076','2015-09-01 13:06:03',NULL,0),('100077',77,'37000000000000077',1001,'zhang77',1,'',1,'13000000077','2015-09-01 13:06:03',NULL,2),('100078',78,'37000000000000078',1001,'zhang78',1,'',1,'13000000078','2015-09-01 13:06:03',NULL,2),('100079',79,'37000000000000079',1001,'zhang79',1,'',1,'13000000079','2015-09-01 13:06:03',NULL,2),('100080',80,'37000000000000080',1001,'zhang80',1,'',1,'13000000080','2015-09-01 13:06:03',NULL,1),('100081',81,'37000000000000081',1001,'zhang81',1,'',1,'13000000081','2015-09-01 13:06:03',NULL,2),('100082',82,'37000000000000082',1001,'zhang82',1,'',1,'13000000082','2015-09-01 13:06:03',NULL,2),('100083',83,'37000000000000083',1001,'zhang83',1,'',1,'13000000083','2015-09-01 13:06:03',NULL,2),('100084',84,'37000000000000084',1001,'zhang84',1,'',1,'13000000084','2015-09-01 13:06:03',NULL,2),('100085',85,'37000000000000085',1001,'zhang85',1,'',1,'13000000085','2015-09-01 13:06:04',NULL,2),('100086',86,'37000000000000086',1001,'zhang86',1,'',1,'13000000086','2015-09-01 13:06:04',NULL,0),('100087',87,'37000000000000087',1001,'zhang87',1,'',1,'13000000087','2015-09-01 13:06:04',NULL,0),('100088',88,'37000000000000088',1001,'zhang88',1,'',1,'13000000088','2015-09-01 13:06:04',NULL,0),('100089',89,'37000000000000089',1001,'zhang89',1,'',1,'13000000089','2015-09-01 13:06:04',NULL,0),('100090',90,'37000000000000090',1001,'zhang90',1,'',1,'13000000090','2015-09-01 13:06:04',NULL,1),('100091',91,'37000000000000091',1001,'zhang91',1,'',1,'13000000091','2015-09-01 13:06:04',NULL,0),('100092',92,'37000000000000092',1001,'zhang92',1,'',1,'13000000092','2015-09-01 13:06:04',NULL,0),('100093',93,'37000000000000093',1001,'zhang93',1,'',1,'13000000093','2015-09-01 13:06:04',NULL,0),('100094',94,'37000000000000094',1001,'zhang94',1,'',1,'13000000094','2015-09-01 13:06:04',NULL,0),('100095',95,'37000000000000095',1001,'zhang95',1,'',1,'13000000095','2015-09-01 13:06:04',NULL,0),('100096',96,'37000000000000096',1001,'zhang96',1,'',1,'13000000096','2015-09-01 13:06:04',NULL,0),('100097',97,'37000000000000097',1001,'zhang97',1,'',1,'13000000097','2015-09-01 13:06:04',NULL,0),('100098',98,'37082600000000098',1002,'张某某',4,'回族',1,'13100000098','2015-09-01 13:06:04',NULL,0),('100099',99,'37000000000000099',1001,'李女士',4,'壮族',1,'13000000099','2015-09-01 13:06:04','2015-09-02 13:55:09',0); /*Table structure for table `t_sb_order_auto` */ DROP TABLE IF EXISTS `t_sb_order_auto`; CREATE TABLE `t_sb_order_auto` ( `order_no` varchar(32) NOT NULL, `pay_uid` int(10) unsigned NOT NULL, `id_card` varchar(20) NOT NULL, `pay_for` tinyint(4) NOT NULL, `start_month` int(11) NOT NULL, `counts` smallint(6) DEFAULT '0', `totals` smallint(6) DEFAULT '0', `status` tinyint(4) DEFAULT '0' COMMENT '状态', `auto_time` datetime DEFAULT NULL, PRIMARY KEY (`order_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `t_sb_order_auto` */ /*Table structure for table `t_sb_order_pay` */ DROP TABLE IF EXISTS `t_sb_order_pay`; CREATE TABLE `t_sb_order_pay` ( `order_no` varchar(32) NOT NULL, `pay_uid` int(10) unsigned NOT NULL, `id_card` varchar(20) NOT NULL, `city_code` smallint(6) unsigned NOT NULL, `pay_for` tinyint(4) NOT NULL COMMENT '打包、公积金、社保', `for_month` int(11) NOT NULL, `prices` decimal(8,2) NOT NULL COMMENT '总金额', `funds` decimal(8,2) NOT NULL COMMENT '公积金金额', `new_card` tinyint(1) DEFAULT '0', `channels` tinyint(4) NOT NULL COMMENT '支付渠道', `pay_no` varchar(128) DEFAULT NULL COMMENT '支付流水号', `pay_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '支付状态OrderConst', `isAuto` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自动代扣', `pay_time` datetime DEFAULT NULL, PRIMARY KEY (`order_no`), KEY `oder-pay-uid-idx` (`pay_uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `t_sb_order_pay` */ insert into `t_sb_order_pay`(`order_no`,`pay_uid`,`id_card`,`city_code`,`pay_for`,`for_month`,`prices`,`funds`,`new_card`,`channels`,`pay_no`,`pay_status`,`isAuto`,`pay_time`) values ('0100000001020000000007201509',102,'345217634765433226',1001,1,201509,1049.30,0.00,0,11,NULL,1,0,NULL),('0200000000010000000001201509',1,'330322197709013613',1001,2,201509,90.00,31.00,0,11,NULL,1,0,NULL),('0200000000010000000002201509',1,'330322197709013638',1001,2,201509,90.00,31.00,0,11,NULL,1,0,NULL),('0200000000010000000003201509',1,'370303198803156013',1001,2,201509,90.00,31.00,0,1,NULL,1,0,NULL),('0200000000010000000008201509',1,'370303198803156014',1001,2,201509,90.00,31.00,0,11,NULL,1,0,NULL),('0200000001020000000007201509',102,'345217634765433226',1001,2,201509,90.00,31.00,0,11,NULL,1,0,NULL),('0300000000010000000001201509',1,'330322197709013613',1001,3,201509,1376.42,31.00,0,11,NULL,1,0,NULL),('0300000000010000000008201509',1,'370303198803156014',1001,3,201510,1412.30,31.00,1,11,NULL,1,0,NULL),('100010',10,'',0,0,201509,3510.25,1510.25,0,0,'100010',2,0,'2015-09-01 13:06:13'),('100011',11,'',0,1,201509,3511.25,1511.25,0,1,'100011',3,0,'2015-09-01 13:06:14'),('100012',12,'',0,2,201509,3512.25,1512.25,0,0,'100012',0,0,'2015-09-01 13:06:14'),('100013',13,'',0,1,201509,3513.25,1513.25,0,1,'100013',1,0,'2015-09-01 13:06:14'),('100014',14,'',0,0,201509,3514.25,1514.25,0,0,'100014',2,0,'2015-09-01 13:06:14'),('100015',15,'',0,2,201509,3515.25,1515.25,0,1,'100015',3,0,'2015-09-01 13:06:14'),('100016',16,'',0,0,201509,3516.25,1516.25,0,0,'100016',0,0,'2015-09-01 13:06:15'),('100017',17,'',0,1,201509,3517.25,1517.25,0,1,'100017',1,0,'2015-09-01 13:06:15'),('100018',18,'',0,2,201509,3518.25,1518.25,0,0,'100018',2,0,'2015-09-01 13:06:15'),('100019',19,'',0,1,201509,3519.25,1519.25,0,1,'100019',3,0,'2015-09-01 13:06:15'),('100020',20,'',0,0,201509,3520.25,1520.25,0,0,'100020',0,0,'2015-09-01 13:06:15'),('100021',21,'',0,2,201509,3521.25,1521.25,0,1,'100021',1,0,'2015-09-01 13:06:15'),('100022',22,'',0,0,201509,3522.25,1522.25,0,0,'100022',2,0,'2015-09-01 13:06:15'),('100023',23,'',0,1,201509,3523.25,1523.25,0,1,'100023',3,0,'2015-09-01 13:06:15'),('100024',24,'',0,2,201509,3524.25,1524.25,0,0,'100024',0,0,'2015-09-01 13:06:15'),('100025',25,'',0,1,201509,3525.25,1525.25,0,1,'100025',1,0,'2015-09-01 13:06:15'),('100026',26,'',0,0,201509,3526.25,1526.25,0,0,'100026',2,0,'2015-09-01 13:06:15'),('100027',27,'',0,2,201509,3527.25,1527.25,0,1,'100027',3,0,'2015-09-01 13:06:15'),('100028',28,'',0,0,201509,3528.25,1528.25,0,0,'100028',0,0,'2015-09-01 13:06:15'),('100029',29,'',0,1,201509,3529.25,1529.25,0,1,'100029',1,0,'2015-09-01 13:06:15'),('100030',30,'',0,2,201509,3530.25,1530.25,0,0,'100030',2,0,'2015-09-01 13:06:15'),('100031',31,'',0,1,201509,3531.25,1531.25,0,1,'100031',3,0,'2015-09-01 13:06:15'),('100032',32,'',0,0,201509,3532.25,1532.25,0,0,'100032',0,0,'2015-09-01 13:06:15'),('100033',33,'',0,2,201509,3533.25,1533.25,0,1,'100033',1,0,'2015-09-01 13:06:15'),('100034',34,'',0,0,201509,3534.25,1534.25,0,0,'100034',2,0,'2015-09-01 13:06:15'),('100035',35,'',0,1,201509,3535.25,1535.25,0,1,'100035',3,0,'2015-09-01 13:06:15'),('100036',36,'',0,2,201509,3536.25,1536.25,0,0,'100036',0,0,'2015-09-01 13:06:15'),('100037',37,'',0,1,201509,3537.25,1537.25,0,1,'100037',1,0,'2015-09-01 13:06:15'),('100038',38,'',0,0,201509,3538.25,1538.25,0,0,'100038',2,0,'2015-09-01 13:06:15'),('100039',39,'',0,2,201509,3539.25,1539.25,0,1,'100039',3,0,'2015-09-01 13:06:15'),('100040',40,'',0,0,201509,3540.25,1540.25,0,0,'100040',0,0,'2015-09-01 13:06:15'),('100041',41,'',0,1,201509,3541.25,1541.25,0,1,'100041',1,0,'2015-09-01 13:06:15'),('100042',42,'',0,2,201509,3542.25,1542.25,0,0,'100042',2,0,'2015-09-01 13:06:15'),('100043',43,'',0,1,201509,3543.25,1543.25,0,1,'100043',3,0,'2015-09-01 13:06:16'),('100044',44,'',0,0,201509,3544.25,1544.25,0,0,'100044',0,0,'2015-09-01 13:06:16'),('100045',45,'',0,2,201509,3545.25,1545.25,0,1,'100045',1,0,'2015-09-01 13:06:16'),('100046',46,'',0,0,201509,3546.25,1546.25,0,0,'100046',2,0,'2015-09-01 13:06:16'),('100047',47,'',0,1,201509,3547.25,1547.25,0,1,'100047',3,0,'2015-09-01 13:06:16'),('100048',48,'',0,2,201509,3548.25,1548.25,0,0,'100048',0,0,'2015-09-01 13:06:16'),('100049',49,'',0,1,201509,3549.25,1549.25,0,1,'100049',1,0,'2015-09-01 13:06:16'),('100050',0,'',0,0,201509,3550.25,1550.25,0,0,'100050',2,0,'2015-09-01 13:06:16'),('100051',1,'',0,2,201509,3551.25,1551.25,0,1,'100051',3,0,'2015-09-01 13:06:16'),('100052',2,'',0,0,201509,3552.25,1552.25,0,0,'100052',0,0,'2015-09-01 13:06:16'),('100053',3,'',0,1,201509,3553.25,1553.25,0,1,'100053',1,0,'2015-09-01 13:06:16'),('100054',4,'',0,2,201509,3554.25,1554.25,0,0,'100054',2,0,'2015-09-01 13:06:16'),('100055',5,'',0,1,201509,3555.25,1555.25,0,1,'100055',3,0,'2015-09-01 13:06:16'),('100056',6,'',0,0,201509,3556.25,1556.25,0,0,'100056',0,0,'2015-09-01 13:06:16'),('100057',7,'',0,2,201509,3557.25,1557.25,0,1,'100057',1,0,'2015-09-01 13:06:16'),('100058',8,'',0,0,201509,3558.25,1558.25,0,0,'100058',2,0,'2015-09-01 13:06:16'),('100059',9,'',0,1,201509,3559.25,1559.25,0,1,'100059',3,0,'2015-09-01 13:06:16'),('100060',10,'',0,2,201509,3560.25,1560.25,0,0,'100060',0,0,'2015-09-01 13:06:16'),('100061',11,'',0,1,201509,3561.25,1561.25,0,1,'100061',1,0,'2015-09-01 13:06:16'),('100062',12,'',0,0,201509,3562.25,1562.25,0,0,'100062',2,0,'2015-09-01 13:06:16'),('100063',13,'',0,2,201509,3563.25,1563.25,0,1,'100063',3,0,'2015-09-01 13:06:16'),('100064',14,'',0,0,201509,3564.25,1564.25,0,0,'100064',0,0,'2015-09-01 13:06:16'),('100065',15,'',0,1,201509,3565.25,1565.25,0,1,'100065',1,0,'2015-09-01 13:06:16'),('100066',16,'',0,2,201509,3566.25,1566.25,0,0,'100066',2,0,'2015-09-01 13:06:16'),('100067',17,'',0,1,201509,3567.25,1567.25,0,1,'100067',3,0,'2015-09-01 13:06:16'),('100068',18,'',0,0,201509,3568.25,1568.25,0,0,'100068',0,0,'2015-09-01 13:06:16'),('100069',19,'',0,2,201509,3569.25,1569.25,0,1,'100069',1,0,'2015-09-01 13:06:16'),('100070',20,'',0,0,201509,3570.25,1570.25,0,0,'100070',2,0,'2015-09-01 13:06:16'),('100071',21,'',0,1,201509,3571.25,1571.25,0,1,'100071',3,0,'2015-09-01 13:06:16'),('100072',22,'',0,2,201509,3572.25,1572.25,0,0,'100072',0,0,'2015-09-01 13:06:17'),('100073',23,'',0,1,201509,3573.25,1573.25,0,1,'100073',1,0,'2015-09-01 13:06:17'),('100074',24,'',0,0,201509,3574.25,1574.25,0,0,'100074',2,0,'2015-09-01 13:06:17'),('100075',25,'',0,2,201509,3575.25,1575.25,0,1,'100075',3,0,'2015-09-01 13:06:17'),('100076',26,'',0,0,201509,3576.25,1576.25,0,0,'100076',0,0,'2015-09-01 13:06:17'),('100077',27,'',0,1,201509,3577.25,1577.25,0,1,'100077',1,0,'2015-09-01 13:06:17'),('100078',28,'',0,2,201509,3578.25,1578.25,0,0,'100078',2,0,'2015-09-01 13:06:17'),('100079',29,'',0,1,201509,3579.25,1579.25,0,1,'100079',3,0,'2015-09-01 13:06:17'),('100080',30,'',0,0,201509,3580.25,1580.25,0,0,'100080',0,0,'2015-09-01 13:06:17'),('100081',31,'',0,2,201509,3581.25,1581.25,0,1,'100081',1,0,'2015-09-01 13:06:17'),('100082',32,'',0,0,201509,3582.25,1582.25,0,0,'100082',2,0,'2015-09-01 13:06:17'),('100083',33,'',0,1,201509,3583.25,1583.25,0,1,'100083',3,0,'2015-09-01 13:06:17'),('100084',34,'',0,2,201509,3584.25,1584.25,0,0,'100084',0,0,'2015-09-01 13:06:17'),('100085',35,'',0,1,201509,3585.25,1585.25,0,1,'100085',1,0,'2015-09-01 13:06:17'),('100086',36,'',0,0,201509,3586.25,1586.25,0,0,'100086',2,0,'2015-09-01 13:06:17'),('100087',37,'',0,2,201509,3587.25,1587.25,0,1,'100087',3,0,'2015-09-01 13:06:17'),('100088',38,'',0,0,201509,3588.25,1588.25,0,0,'100088',0,0,'2015-09-01 13:06:17'),('100089',39,'',0,1,201509,3589.25,1589.25,0,1,'100089',1,0,'2015-09-01 13:06:17'),('100090',40,'',0,2,201509,3590.25,1590.25,0,0,'100090',2,0,'2015-09-01 13:06:17'),('100091',41,'',0,1,201509,3591.25,1591.25,0,1,'100091',3,0,'2015-09-01 13:06:17'),('100092',42,'',0,0,201509,3592.25,1592.25,0,0,'100092',0,0,'2015-09-01 13:06:17'),('100093',43,'',0,2,201509,3593.25,1593.25,0,1,'100093',1,0,'2015-09-01 13:06:17'),('100094',44,'',0,0,201509,3594.25,1594.25,0,0,'100094',2,0,'2015-09-01 13:06:17'),('100095',45,'',0,1,201509,3595.25,1595.25,0,1,'100095',3,0,'2015-09-01 13:06:17'),('100096',46,'',0,2,201509,3596.25,1596.25,0,0,'100096',0,0,'2015-09-01 13:06:17'),('100097',47,'',0,1,201509,3597.25,1597.25,0,1,'100097',1,0,'2015-09-01 13:06:18'),('100098',48,'',0,0,201509,3598.25,1598.25,0,0,'100098',2,0,'2015-09-01 13:06:18'),('100099',49,'',0,2,201509,3599.25,1599.25,0,1,'100099',3,0,'2015-09-01 13:06:18'); /*Table structure for table `t_sb_order_stop` */ DROP TABLE IF EXISTS `t_sb_order_stop`; CREATE TABLE `t_sb_order_stop` ( `u_id` int(10) unsigned NOT NULL, `id_card` varchar(20) NOT NULL, `stop_for` tinyint(1) NOT NULL COMMENT '停对象标识见PayFor', `stop_month` int(11) NOT NULL COMMENT '停保月份 201509', `order_no` varchar(32) DEFAULT NULL COMMENT '对应自动代扣的订单号', `status` tinyint(4) DEFAULT '0', `gen_time` datetime NOT NULL, KEY `sb_stop_uid_idx` (`u_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `t_sb_order_stop` */ /*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(32) 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=99 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 (1,1,'330322197709013613','倪建勋','汉',1,'13928559875',NULL,'/upload/card/1/10320136130.jpg#/upload/card/1/10320136131.jpg'),(2,1,'330322197709013638','倪建勋','汉',1,'13928550985',NULL,'/upload/card/1/10320136380.jpg#/upload/card/1/10320136381.jpg'),(3,1,'370303198803156013','韩呈祥','汉',1,'13928660978',NULL,'/upload/card/1/10301560130.jpg#/upload/card/1/10301560131.jpg'),(4,1,'444444444444444444','Ffh','Ghg',0,'13928550988',NULL,'/upload/card/1/14444444440.jpg#/upload/card/1/14444444441.jpg'),(5,101,'370303198803156013','韩呈祥','汉',1,'13928550999',NULL,'/upload/card/101/1010301560130.jpg#/upload/card/101/1010301560131.jpg'),(6,102,'440875322143244236','气温','你',1,'13928550852',NULL,'/upload/card/102/1020872442360.jpg#/upload/card/102/1020872442361.jpg'),(7,102,'345217634765433226','鹅儿','广泛',0,'13928556887',NULL,'/upload/card/102/1025214332260.jpg#/upload/card/102/1025214332261.jpg'),(8,1,'370303198803156014','韩呈祥','汉',1,'13928556522',NULL,'/upload/card/1/10301560140.jpg#/upload/card/1/10301560141.jpg'),(9,10,'37000000000000010','zhang10',NULL,1,'13000000010',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(10,11,'37000000000000011','zhang11',NULL,1,'13000000011',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(11,12,'37000000000000012','zhang12',NULL,1,'13000000012',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(12,13,'37000000000000013','zhang13',NULL,1,'13000000013',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(13,14,'37000000000000014','zhang14',NULL,1,'13000000014',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(14,15,'37000000000000015','zhang15',NULL,1,'13000000015',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(15,16,'37000000000000016','zhang16',NULL,1,'13000000016',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(16,17,'37000000000000017','zhang17',NULL,1,'13000000017',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(17,18,'37000000000000018','zhang18',NULL,1,'13000000018',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(18,19,'37000000000000019','zhang19',NULL,1,'13000000019',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(19,20,'37000000000000020','zhang20',NULL,1,'13000000020',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(20,21,'37000000000000021','zhang21',NULL,1,'13000000021',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(21,22,'37000000000000022','zhang22',NULL,1,'13000000022',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(22,23,'37000000000000023','zhang23',NULL,1,'13000000023',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(23,24,'37000000000000024','zhang24',NULL,1,'13000000024',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(24,25,'37000000000000025','zhang25',NULL,1,'13000000025',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(25,26,'37000000000000026','zhang26',NULL,1,'13000000026',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(26,27,'37000000000000027','zhang27',NULL,1,'13000000027',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(27,28,'37000000000000028','zhang28',NULL,1,'13000000028',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(28,29,'37000000000000029','zhang29',NULL,1,'13000000029',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(29,30,'37000000000000030','zhang30',NULL,1,'13000000030',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(30,31,'37000000000000031','zhang31',NULL,1,'13000000031',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(31,32,'37000000000000032','zhang32',NULL,1,'13000000032',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(32,33,'37000000000000033','zhang33',NULL,1,'13000000033',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(33,34,'37000000000000034','zhang34',NULL,1,'13000000034',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(34,35,'37000000000000035','zhang35',NULL,1,'13000000035',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(35,36,'37000000000000036','zhang36',NULL,1,'13000000036',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(36,37,'37000000000000037','zhang37',NULL,1,'13000000037',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(37,38,'37000000000000038','zhang38',NULL,1,'13000000038',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(38,39,'37000000000000039','zhang39',NULL,1,'13000000039',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(39,40,'37000000000000040','zhang40',NULL,1,'13000000040',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(40,41,'37000000000000041','zhang41',NULL,1,'13000000041',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(41,42,'37000000000000042','zhang42',NULL,1,'13000000042',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(42,43,'37000000000000043','zhang43',NULL,1,'13000000043',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(43,44,'37000000000000044','zhang44',NULL,1,'13000000044',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(44,45,'37000000000000045','zhang45',NULL,1,'13000000045',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(45,46,'37000000000000046','zhang46',NULL,1,'13000000046',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(46,47,'37000000000000047','zhang47',NULL,1,'13000000047',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(47,48,'37000000000000048','zhang48',NULL,1,'13000000048',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(48,49,'37000000000000049','zhang49',NULL,1,'13000000049',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(49,50,'37000000000000050','zhang50',NULL,1,'13000000050',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(50,51,'37000000000000051','zhang51',NULL,1,'13000000051',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(51,52,'37000000000000052','zhang52',NULL,1,'13000000052',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(52,53,'37000000000000053','zhang53',NULL,1,'13000000053',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(53,54,'37000000000000054','zhang54',NULL,1,'13000000054',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(54,55,'37000000000000055','zhang55',NULL,1,'13000000055',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(55,56,'37000000000000056','zhang56',NULL,1,'13000000056',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(56,57,'37000000000000057','zhang57',NULL,1,'13000000057',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(57,58,'37000000000000058','zhang58',NULL,1,'13000000058',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(58,59,'37000000000000059','zhang59',NULL,1,'13000000059',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(59,60,'37000000000000060','zhang60',NULL,1,'13000000060',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(60,61,'37000000000000061','zhang61',NULL,1,'13000000061',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(61,62,'37000000000000062','zhang62',NULL,1,'13000000062',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(62,63,'37000000000000063','zhang63',NULL,1,'13000000063',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(63,64,'37000000000000064','zhang64',NULL,1,'13000000064',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(64,65,'37000000000000065','zhang65',NULL,1,'13000000065',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(65,66,'37000000000000066','zhang66',NULL,1,'13000000066',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(66,67,'37000000000000067','zhang67',NULL,1,'13000000067',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(67,68,'37000000000000068','zhang68',NULL,1,'13000000068',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(68,69,'37000000000000069','zhang69',NULL,1,'13000000069',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(69,70,'37000000000000070','zhang70',NULL,1,'13000000070',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(70,71,'37000000000000071','zhang71',NULL,1,'13000000071',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(71,72,'37000000000000072','zhang72',NULL,1,'13000000072',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(72,73,'37000000000000073','zhang73',NULL,1,'13000000073',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(73,74,'37000000000000074','zhang74',NULL,1,'13000000074',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(74,75,'37000000000000075','zhang75',NULL,1,'13000000075',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(75,76,'37000000000000076','zhang76',NULL,1,'13000000076',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(76,77,'37000000000000077','zhang77',NULL,1,'13000000077',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(77,78,'37000000000000078','zhang78',NULL,1,'13000000078',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(78,79,'37000000000000079','zhang79',NULL,1,'13000000079',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(79,80,'37000000000000080','zhang80',NULL,1,'13000000080',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(80,81,'37000000000000081','zhang81',NULL,1,'13000000081',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(81,82,'37000000000000082','zhang82',NULL,1,'13000000082',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(82,83,'37000000000000083','zhang83',NULL,1,'13000000083',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(83,84,'37000000000000084','zhang84',NULL,1,'13000000084',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(84,85,'37000000000000085','zhang85',NULL,1,'13000000085',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(85,86,'37000000000000086','zhang86',NULL,1,'13000000086',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(86,87,'37000000000000087','zhang87',NULL,1,'13000000087',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(87,88,'37000000000000088','zhang88',NULL,1,'13000000088',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(88,89,'37000000000000089','zhang89',NULL,1,'13000000089',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(89,90,'37000000000000090','zhang90',NULL,1,'13000000090',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(90,91,'37000000000000091','zhang91',NULL,1,'13000000091',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(91,92,'37000000000000092','zhang92',NULL,1,'13000000092',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(92,93,'37000000000000093','zhang93',NULL,1,'13000000093',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(93,94,'37000000000000094','zhang94',NULL,1,'13000000094',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(94,95,'37000000000000095','zhang95',NULL,1,'13000000095',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(95,96,'37000000000000096','zhang96',NULL,1,'13000000096',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(96,97,'37000000000000097','zhang97',NULL,1,'13000000097',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(97,98,'37000000000000098','zhang98',NULL,1,'13000000098',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'),(98,99,'37000000000000099','zhang99',NULL,1,'13000000099',NULL,'upload/card/1/10320136380.jpg#upload/card/1/10320136381.jpg#null'); /*Table structure for table `t_sys_log` */ DROP TABLE IF EXISTS `t_sys_log`; CREATE TABLE `t_sys_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL, `error_msg` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统执行过程中的异常'; /*Data for the table `t_sys_log` */ /*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=107 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 (1,NULL,'18666507203','e10adc3949ba59abbe56e057f20f883e','18666507203','/upload/head/1/1.jpg','0','2015-08-21 14:33:48','2015-08-21 14:33:48'),(2,NULL,'13760659709','fd028a68a9b177e8b6d4dd48a043f3d5','13760659709','','0','2015-08-21 15:15:17','2015-08-21 15:15:17'),(3,NULL,'15206643833','a8c27bec41fd5038069e28c80f427d88','15206643833','','0','2015-08-21 15:33:08','2015-08-21 15:33:08'),(4,NULL,'18865273452','699a2ceeabffdadd6ec3688ce2b70b45','18865273452','','0','2015-08-21 15:36:54','2015-08-21 15:36:54'),(5,NULL,'13631409050','827ccb0eea8a706c4c34a16891f84e7b','13631409050','','0','2015-08-21 16:31:54','2015-08-21 16:31:54'),(6,NULL,'13250258039','827ccb0eea8a706c4c34a16891f84e7b','13250258039','','0','2015-08-21 16:38:06','2015-08-21 16:38:06'),(7,NULL,'15014012875','827ccb0eea8a706c4c34a16891f84e7b','15014012875','','0','2015-08-21 16:43:10','2015-08-21 16:43:10'),(8,NULL,'13288607899','25f9e794323b453885f5181f1b624d0b','13288607899','','0','2015-08-27 00:34:22','2015-08-27 00:34:22'),(9,NULL,'15206643834','e10adc3949ba59abbe56e057f20f883e','15206643834','upload/head/9/9.jpg','0','2015-08-27 01:18:16','2015-08-27 01:18:16'),(10,NULL,'13888888888','123456','13888888888','','0','2015-08-26 17:42:32','2015-08-26 17:42:32'),(11,NULL,'13000000010','123456','13000000010','','0','2015-08-26 17:42:45','2015-08-26 17:42:45'),(12,NULL,'13000000011','123456','13000000011','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(13,NULL,'13000000012','123456','13000000012','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(14,NULL,'13000000013','123456','13000000013','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(15,NULL,'13000000014','123456','13000000014','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(16,NULL,'13000000015','123456','13000000015','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(17,NULL,'13000000016','123456','13000000016','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(18,NULL,'13000000017','123456','13000000017','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(19,NULL,'13000000018','123456','13000000018','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(20,NULL,'13000000019','123456','13000000019','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(21,NULL,'13000000020','123456','13000000020','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(22,NULL,'13000000021','123456','13000000021','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(23,NULL,'13000000022','123456','13000000022','','0','2015-08-26 17:42:46','2015-08-26 17:42:46'),(24,NULL,'13000000023','123456','13000000023','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(25,NULL,'13000000024','123456','13000000024','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(26,NULL,'13000000025','123456','13000000025','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(27,NULL,'13000000026','123456','13000000026','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(28,NULL,'13000000027','123456','13000000027','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(29,NULL,'13000000028','123456','13000000028','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(30,NULL,'13000000029','123456','13000000029','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(31,NULL,'13000000030','123456','13000000030','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(32,NULL,'13000000031','123456','13000000031','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(33,NULL,'13000000032','123456','13000000032','','0','2015-08-26 17:42:47','2015-08-26 17:42:47'),(34,NULL,'13000000033','123456','13000000033','','0','2015-08-26 17:42:48','2015-08-26 17:42:48'),(35,NULL,'13000000034','123456','13000000034','','0','2015-08-26 17:42:48','2015-08-26 17:42:48'),(36,NULL,'13000000035','123456','13000000035','','0','2015-08-26 17:42:48','2015-08-26 17:42:48'),(37,NULL,'13000000036','123456','13000000036','','0','2015-08-26 17:42:48','2015-08-26 17:42:48'),(38,NULL,'13000000037','123456','13000000037','','0','2015-08-26 17:42:49','2015-08-26 17:42:49'),(39,NULL,'13000000038','123456','13000000038','','0','2015-08-26 17:42:49','2015-08-26 17:42:49'),(40,NULL,'13000000039','123456','13000000039','','0','2015-08-26 17:42:49','2015-08-26 17:42:49'),(41,NULL,'13000000040','123456','13000000040','','0','2015-08-26 17:42:49','2015-08-26 17:42:49'),(42,NULL,'13000000041','123456','13000000041','','0','2015-08-26 17:42:49','2015-08-26 17:42:49'),(43,NULL,'13000000042','123456','13000000042','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(44,NULL,'13000000043','123456','13000000043','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(45,NULL,'13000000044','123456','13000000044','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(46,NULL,'13000000045','123456','13000000045','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(47,NULL,'13000000046','123456','13000000046','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(48,NULL,'13000000047','123456','13000000047','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(49,NULL,'13000000048','123456','13000000048','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(50,NULL,'13000000049','123456','13000000049','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(51,NULL,'13000000050','123456','13000000050','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(52,NULL,'13000000051','123456','13000000051','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(53,NULL,'13000000052','123456','13000000052','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(54,NULL,'13000000053','123456','13000000053','','0','2015-08-26 17:42:50','2015-08-26 17:42:50'),(55,NULL,'13000000054','123456','13000000054','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(56,NULL,'13000000055','123456','13000000055','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(57,NULL,'13000000056','123456','13000000056','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(58,NULL,'13000000057','123456','13000000057','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(59,NULL,'13000000058','123456','13000000058','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(60,NULL,'13000000059','123456','13000000059','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(61,NULL,'13000000060','123456','13000000060','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(62,NULL,'13000000061','123456','13000000061','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(63,NULL,'13000000062','123456','13000000062','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(64,NULL,'13000000063','123456','13000000063','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(65,NULL,'13000000064','123456','13000000064','','0','2015-08-26 17:42:51','2015-08-26 17:42:51'),(66,NULL,'13000000065','123456','13000000065','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(67,NULL,'13000000066','123456','13000000066','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(68,NULL,'13000000067','123456','13000000067','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(69,NULL,'13000000068','123456','13000000068','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(70,NULL,'13000000069','123456','13000000069','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(71,NULL,'13000000070','123456','13000000070','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(72,NULL,'13000000071','123456','13000000071','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(73,NULL,'13000000072','123456','13000000072','','0','2015-08-26 17:42:52','2015-08-26 17:42:52'),(74,NULL,'13000000073','123456','13000000073','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(75,NULL,'13000000074','123456','13000000074','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(76,NULL,'13000000075','123456','13000000075','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(77,NULL,'13000000076','123456','13000000076','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(78,NULL,'13000000077','123456','13000000077','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(79,NULL,'13000000078','123456','13000000078','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(80,NULL,'13000000079','123456','13000000079','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(81,NULL,'13000000080','123456','13000000080','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(82,NULL,'13000000081','123456','13000000081','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(83,NULL,'13000000082','123456','13000000082','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(84,NULL,'13000000083','123456','13000000083','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(85,NULL,'13000000084','123456','13000000084','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(86,NULL,'13000000085','123456','13000000085','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(87,NULL,'13000000086','123456','13000000086','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(88,NULL,'13000000087','123456','13000000087','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(89,NULL,'13000000088','123456','13000000088','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(90,NULL,'13000000089','123456','13000000089','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(91,NULL,'13000000090','123456','13000000090','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(92,NULL,'13000000091','123456','13000000091','','0','2015-08-26 17:42:53','2015-08-26 17:42:53'),(93,NULL,'13000000092','123456','13000000092','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(94,NULL,'13000000093','123456','13000000093','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(95,NULL,'13000000094','123456','13000000094','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(96,NULL,'13000000095','123456','13000000095','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(97,NULL,'13000000096','123456','13000000096','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(98,NULL,'13000000097','123456','13000000097','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(99,NULL,'13000000098','123456','13000000098','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(100,NULL,'13000000099','123456','13000000099','','0','2015-08-26 17:42:54','2015-08-26 17:42:54'),(101,NULL,'18666507202','e10adc3949ba59abbe56e057f20f883e','18666507202','upload/head/101/101.jpg','0','2015-09-03 14:38:15','2015-09-03 14:38:15'),(102,NULL,'18666507201','e10adc3949ba59abbe56e057f20f883e','18666507201','upload/head/102/102.jpg','0','2015-09-03 19:55:32','2015-09-03 19:55:32'),(103,NULL,'15206643835','202cb962ac59075b964b07152d234b70','15206643835','','0','2015-09-10 11:32:44','2015-09-10 11:32:44'),(104,NULL,'15206643836','c4ca4238a0b923820dcc509a6f75849b','15206643836','','0','2015-09-10 13:06:15','2015-09-10 13:06:15'),(105,NULL,'15206643800','c4ca4238a0b923820dcc509a6f75849b','15206643800','','0','2015-09-10 16:43:57','2015-09-10 16:43:57'),(106,NULL,'15206643801','c4ca4238a0b923820dcc509a6f75849b','15206643801','','0','2015-09-10 16:58:45','2015-09-10 16:58:45'); /*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, `msg_read_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消息读取时间', PRIMARY KEY (`u_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户标记表'; /*Data for the table `t_user_flag` */ /*!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 */;