hmsb/hippo_social1.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : hippo_social

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2019-04-12 17:48:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for hippo_action
-- ----------------------------
DROP TABLE IF EXISTS `hippo_action`;
CREATE TABLE `hippo_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id 0系统管理员',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '行为说明',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '行为描述',
  `create_timestamp` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统行为表';

-- ----------------------------
-- Records of hippo_action
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_ad
-- ----------------------------
DROP TABLE IF EXISTS `hippo_ad`;
CREATE TABLE `hippo_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `place_id` int(11) DEFAULT NULL COMMENT '广告位ID',
  `title` varchar(150) DEFAULT NULL COMMENT '广告名称',
  `cover_url` varchar(150) DEFAULT NULL COMMENT '广告图片',
  `photolist` varchar(20) NOT NULL COMMENT '辅助图片',
  `url` varchar(150) DEFAULT NULL COMMENT '广告链接',
  `listurl` varchar(255) DEFAULT NULL COMMENT '辅助链接',
  `background` varchar(150) DEFAULT NULL COMMENT '广告背景',
  `content` text COMMENT '广告描述',
  `sort` int(11) DEFAULT NULL COMMENT '排序 从小到大',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '广告位状态',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告表';

-- ----------------------------
-- Records of hippo_ad
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_article
-- ----------------------------
DROP TABLE IF EXISTS `hippo_article`;
CREATE TABLE `hippo_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '名臣',
  `description` text COMMENT '内容描述',
  `content` text COMMENT '内容',
  `status` int(2) NOT NULL DEFAULT '1' COMMENT '数据状态',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='test';

-- ----------------------------
-- Records of hippo_article
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `hippo_auth_group`;
CREATE TABLE `hippo_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
  `type` varchar(10) NOT NULL DEFAULT '' COMMENT '组类型',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_auth_group
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `hippo_auth_group_access`;
CREATE TABLE `hippo_auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `group_id` (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_auth_group_access
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `hippo_auth_rule`;
CREATE TABLE `hippo_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `group` char(20) NOT NULL DEFAULT '' COMMENT '权限节点分组',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`name`,`status`,`type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_auth_rule
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_config
-- ----------------------------
DROP TABLE IF EXISTS `hippo_config`;
CREATE TABLE `hippo_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` varchar(10) NOT NULL DEFAULT 'text' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `group1` varchar(30) NOT NULL DEFAULT '' COMMENT '配置分组1',
  `group2` varchar(30) NOT NULL DEFAULT '' COMMENT '配置分组2',
  `value` varchar(255) DEFAULT NULL COMMENT '配置值',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `type` (`type`) USING BTREE,
  KEY `group` (`group1`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='配置详情表';

-- ----------------------------
-- Records of hippo_config
-- ----------------------------
INSERT INTO `hippo_config` VALUES ('1', 'pension', 'text', '养老', 'social', 'farmer', '0.19', '0.08', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('2', 'health', 'text', '医疗', 'social', 'farmer', '0.1', '0.02', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('3', 'unemployment', 'text', '失业', 'social', 'farmer', '0.008', '0.002', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('4', 'injury', 'text', '工伤', 'social', 'farmer', '0.004', '0', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('5', 'birth', 'text', '生育', 'social', 'farmer', '0.008', '0', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('6', 'largeMedic', 'text', '大额医疗', 'social', 'farmer', '3', '', '个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('7', 'fund', 'text', '公积金', 'fund', 'farmer', '0.12', '0.12', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('8', 'monthly', 'text', '月付', 'service', 'farmer', '100', '150', '月付：%d元/月', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('9', 'seasonal', 'text', '季付', 'service', 'farmer', '270', '405', '季付：%d元/季', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('10', 'halfYearly', 'text', '半年付', 'service', 'farmer', '480', '720', '半年付：%d元/半年', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('11', 'yearly', 'text', '年付', 'service', 'farmer', '600', '900', '年付：%d元/年', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('12', 'pension', 'text', '社保', 'basic', 'farmer', '3387', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('13', ' health', 'text', '社保', 'basic', 'farmer', '3387', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('14', 'unemployment', 'text', '社保', 'basic', 'farmer', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('15', 'injury', 'text', '社保', 'basic', 'farmer', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('16', 'birth', 'text', '社保', 'basic', 'farmer', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('17', 'fund', 'text', '公积金', 'basic', 'farmer', '2273', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('18', 'pension', 'text', '养老', 'social', 'town', '0.19', '0.08', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('19', 'health', 'text', '医疗', 'social', 'town', '0.1', '0.02', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('20', 'unemployment', 'text', '失业', 'social', 'town', '0.008', '0.002', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('21', 'injury', 'text', '工伤', 'social', 'town', '0.004', '0', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('22', 'birth', 'text', '生育', 'social', 'town', '0.008', '0', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('23', 'largeMedic', 'text', '大额医疗', 'social', 'town', '3', '', '个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('24', 'fund', 'text', '公积金', 'fund', 'town', '0.12', '0.12', '企业/个人', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('25', 'monthly', 'text', '月付', 'service', 'town', '100', '150', '月付：%d元/月', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('26', 'seasonal', 'text', '季付', 'service', 'town', '270', '405', '季付：%d元/季', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('27', 'halfYearly', 'text', '半年付', 'service', 'town', '480', '720', '半年付：%d元/半年', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('28', 'yearly', 'text', '年付', 'service', 'town', '600', '900', '年付：%d元/年', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('29', 'pension', 'text', '社保', 'basic', 'town', '3387', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('30', 'health', 'text', '社保', 'basic', 'town', '3387', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('31', 'unemployment', 'text', '社保', 'basic', 'town', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('32', 'injury', 'text', '社保', 'basic', 'town', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('33', 'birth', 'text', '社保', 'basic', 'town', '5080', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('34', 'fund', 'text', '公积金', 'basic', 'town', '2273', '25401', '缴费基数', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('35', 'ohers', 'text', '手续费', 'others', 'farmer', '0', '0', '其他费用', '2019-03-05 19:49:08', '2019-03-05 19:49:04');
INSERT INTO `hippo_config` VALUES ('36', 'ohers', 'text', '手续费', 'others', 'town', '0', '0', '其他费用', '2019-03-05 19:49:08', '2019-03-05 19:49:04');

-- ----------------------------
-- Table structure for hippo_coupon
-- ----------------------------
DROP TABLE IF EXISTS `hippo_coupon`;
CREATE TABLE `hippo_coupon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '优惠券ID 自增',
  `name` varchar(60) NOT NULL COMMENT '优惠券名称',
  `type` tinyint(2) NOT NULL COMMENT '优惠券类型,1为折扣券,2抵扣券',
  `money` decimal(12,2) unsigned NOT NULL COMMENT '优惠金额,0为全额抵扣',
  `number` int(11) unsigned NOT NULL COMMENT '优惠券发放数量',
  `period` int(11) unsigned NOT NULL COMMENT '优惠券有效时间间隔',
  `status` tinyint(2) NOT NULL COMMENT '状态，0已冻结，1正常使用',
  `remarks` varchar(128) NOT NULL COMMENT '优惠券的使用说明',
  `coupon_start_time` datetime NOT NULL COMMENT '优惠券发放开始时间',
  `coupon_end_time` datetime NOT NULL COMMENT '优惠券发放结束时间',
  `create_timestamp` datetime NOT NULL COMMENT '优惠券创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_coupon
-- ----------------------------
INSERT INTO `hippo_coupon` VALUES ('1', '半价优惠券', '1', '0.50', '100', '0', '1', '前100名半价优惠券，总发放100个，失效自动补充', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '2019-03-06 21:34:36');
INSERT INTO `hippo_coupon` VALUES ('2', '社保服务费抵扣券', '2', '0.00', '0', '30', '1', '按服务费套餐量减一发放', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon` VALUES ('3', '社保公积金服务费抵扣券', '2', '0.00', '0', '30', '1', '按服务费套餐量减一发放', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '2019-03-06 21:36:06');

-- ----------------------------
-- Table structure for hippo_coupon_receive
-- ----------------------------
DROP TABLE IF EXISTS `hippo_coupon_receive`;
CREATE TABLE `hippo_coupon_receive` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID自增',
  `uid` int(10) unsigned DEFAULT NULL COMMENT '用户ID',
  `coupon_id` int(10) unsigned DEFAULT NULL COMMENT '优惠券ID',
  `order_id` int(10) unsigned DEFAULT NULL COMMENT '订单Id',
  `coupon_type` tinyint(2) unsigned DEFAULT NULL COMMENT '优惠券类型,1为折扣券,2抵扣券',
  `status` tinyint(2) unsigned DEFAULT '1' COMMENT '状态 0失效  1正常 2锁定 3已使用',
  `end_timestamp` datetime DEFAULT NULL COMMENT '优惠券失效时间',
  `create_timestamp` datetime NOT NULL COMMENT '优惠券创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_coupon_receive
-- ----------------------------
INSERT INTO `hippo_coupon_receive` VALUES ('34', '1', '1', null, '1', '2', '2019-03-06 21:36:06', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon_receive` VALUES ('35', '1', '2', '21', null, '1', '2019-03-06 21:36:06', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon_receive` VALUES ('36', '1', '2', '21', null, '1', '2019-03-06 21:36:06', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon_receive` VALUES ('37', '1', '2', '21', null, '1', '2019-03-06 21:36:06', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon_receive` VALUES ('38', '1', '1', null, '1', '2', '2019-03-06 21:36:06', '2019-03-06 21:36:06');
INSERT INTO `hippo_coupon_receive` VALUES ('39', '1', '1', null, '1', '2', '2019-03-06 21:36:06', '2019-03-06 21:36:06');

-- ----------------------------
-- Table structure for hippo_invite_relation
-- ----------------------------
DROP TABLE IF EXISTS `hippo_invite_relation`;
CREATE TABLE `hippo_invite_relation` (
  `uid` int(11) NOT NULL COMMENT '用户id',
  `inviter` int(11) NOT NULL COMMENT '邀请人id',
  `status` tinyint(4) NOT NULL COMMENT '邀请状态 1已绑定 2邀请成功 3已发放',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_invite_relation
-- ----------------------------
INSERT INTO `hippo_invite_relation` VALUES ('2', '1', '1', null, '2019-04-04 15:11:26');

-- ----------------------------
-- Table structure for hippo_log_login
-- ----------------------------
DROP TABLE IF EXISTS `hippo_log_login`;
CREATE TABLE `hippo_log_login` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `login_type` varchar(255) NOT NULL,
  `login_ip` varchar(15) NOT NULL,
  `create_timestamp` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_log_login
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_menu
-- ----------------------------
DROP TABLE IF EXISTS `hippo_menu`;
CREATE TABLE `hippo_menu` (
  `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `type` varchar(10) NOT NULL DEFAULT 'admin' COMMENT '菜单类别（admin后台，user会员中心）',
  `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '分类图标',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of hippo_menu
-- ----------------------------
INSERT INTO `hippo_menu` VALUES ('1', '首页', 'admin', 'home', '0', '0', 'admin/index/index', '0', '导航', '0', '1');
INSERT INTO `hippo_menu` VALUES ('2', '订单', 'admin', 'publice', '0', '1', 'admin/order/index', '0', '导航', '0', '1');
INSERT INTO `hippo_menu` VALUES ('3', '系统设置', 'admin', 'publice', '0', '1', 'admin/order/index', '0', '导航', '0', '1');
INSERT INTO `hippo_menu` VALUES ('4', '管理员', 'admin', 'system', '0', '3', 'admin/user/index', '0', '导航', '0', '0');
INSERT INTO `hippo_menu` VALUES ('5', '应用中心', 'admin', 'mini-list', '1', '0', 'admin/index/index', '0', '首页', '0', '0');
INSERT INTO `hippo_menu` VALUES ('6', '更新缓存', 'admin', 'refresh', '1', '0', 'admin/index/clear', '0', '首页', '0', '0');
INSERT INTO `hippo_menu` VALUES ('11', '用户列表', 'admin', 'user', '4', '0', 'admin/user/index', '0', '系统管理', '0', '0');
INSERT INTO `hippo_menu` VALUES ('12', '用户组表', 'admin', 'users', '4', '0', 'admin/group/index', '0', '系统管理', '0', '0');
INSERT INTO `hippo_menu` VALUES ('13', '菜单列表', 'admin', 'th-list', '4', '0', 'admin/menu/index', '0', '系统管理', '0', '0');
INSERT INTO `hippo_menu` VALUES ('14', '权限列表', 'admin', 'paw', '4', '0', 'admin/group/access', '0', '系统管理', '0', '0');

-- ----------------------------
-- Table structure for hippo_orders
-- ----------------------------
DROP TABLE IF EXISTS `hippo_orders`;
CREATE TABLE `hippo_orders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `order_sn` char(24) NOT NULL,
  `payment` decimal(10,2) NOT NULL COMMENT '支付金额',
  `service_type` tinyint(1) NOT NULL COMMENT '服务费类型 1月付 2季付 3 半年付 4 年付',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '订单状态 0 已取消 1 未付款 2 已付款 3 代缴中 4 交易成功 5 交易关闭',
  `pay_timestamp` datetime DEFAULT NULL COMMENT '支付时间',
  `send_timestamp` datetime DEFAULT NULL COMMENT '发货时间',
  `end_timestamp` datetime DEFAULT NULL COMMENT '完成时间',
  `close_timestamp` datetime DEFAULT NULL COMMENT '结束时间',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_orders
-- ----------------------------
INSERT INTO `hippo_orders` VALUES ('43', '1', '201904081235302513625396', '2303.97', '0', '1', null, null, null, '2019-04-08 13:05:30', '2019-04-08 12:35:30', '2019-04-08 12:35:30');

-- ----------------------------
-- Table structure for hippo_order_info
-- ----------------------------
DROP TABLE IF EXISTS `hippo_order_info`;
CREATE TABLE `hippo_order_info` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `order_sn` char(24) NOT NULL,
  `social_basic` mediumint(8) unsigned DEFAULT NULL COMMENT '社保基数',
  `fund_basic` mediumint(8) unsigned DEFAULT '0' COMMENT '公积金基数',
  `charge_details` text NOT NULL COMMENT '缴费明细',
  `service_charge` decimal(8,2) unsigned NOT NULL COMMENT '服务费',
  `total_charge` decimal(10,2) unsigned NOT NULL COMMENT '总计',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_order_info
-- ----------------------------
INSERT INTO `hippo_order_info` VALUES ('43', '1', '201904081235302513625396', '3387', '2273', '{\"social\":{\"pension\":[\"914.49\",\"\\u517b\\u8001\"],\"health\":[\"406.44\",\"\\u533b\\u7597\"],\"unemployment\":[\"33.87\",\"\\u5931\\u4e1a\"],\"injury\":[\"13.55\",\"\\u5de5\\u4f24\"],\"birth\":[\"27.10\",\"\\u751f\\u80b2\"],\"largeMedic\":[\"3.00\",\"\\u5927\\u989d\\u533b\\u7597\"]},\"service_type\":\"halfYearly\",\"service\":\"360.00\",\"subtotal\":\"1398.45\",\"fund\":\"545.52\",\"coupon\":0,\"discounts\":true,\"total\":\"2303.97\"}', '905.52', '2303.97', '2019-04-08 12:35:30', '2019-04-08 12:35:30');

-- ----------------------------
-- Table structure for hippo_pay_info
-- ----------------------------
DROP TABLE IF EXISTS `hippo_pay_info`;
CREATE TABLE `hippo_pay_info` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `order_sn` char(24) NOT NULL COMMENT '订单号',
  `coupon` int(11) DEFAULT NULL COMMENT '优惠券id',
  `pay_platform` tinyint(4) NOT NULL COMMENT '支付平台 1 微信 2 支付宝 3 银行卡',
  `pay_no` varchar(255) DEFAULT NULL COMMENT '支付流水号',
  `pay_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付状态 0 未支付 1 已支付 2 已退款',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_pay_info
-- ----------------------------
INSERT INTO `hippo_pay_info` VALUES ('1', '1', '201903161654266184365196', '37', '0', null, '0', '2019-03-16 16:54:58', '2019-03-16 16:54:58');
INSERT INTO `hippo_pay_info` VALUES ('2', '1', '201903161703463517475896', null, '0', null, '0', '2019-03-16 17:03:49', '2019-03-16 17:03:49');
INSERT INTO `hippo_pay_info` VALUES ('3', '1', '201903161704341623461696', null, '0', null, '0', '2019-03-16 17:04:39', '2019-03-16 17:04:39');
INSERT INTO `hippo_pay_info` VALUES ('4', '1', '201904011915264099690196', null, '0', null, '0', '2019-04-01 19:15:26', '2019-04-01 19:15:26');
INSERT INTO `hippo_pay_info` VALUES ('5', '1', '201904021551264524908696', null, '0', null, '0', '2019-04-02 15:51:26', '2019-04-02 15:51:26');
INSERT INTO `hippo_pay_info` VALUES ('6', '1', '201904021610253985359396', null, '0', null, '0', '2019-04-02 16:10:25', '2019-04-02 16:10:25');
INSERT INTO `hippo_pay_info` VALUES ('7', '1', '201904021707455759668096', null, '0', null, '0', '2019-04-02 17:07:46', '2019-04-02 17:07:46');
INSERT INTO `hippo_pay_info` VALUES ('8', '1', '201904021718468431608696', null, '0', null, '0', '2019-04-02 17:18:46', '2019-04-02 17:18:46');
INSERT INTO `hippo_pay_info` VALUES ('9', '1', '201904021719446599386196', null, '0', null, '0', '2019-04-02 17:19:44', '2019-04-02 17:19:44');
INSERT INTO `hippo_pay_info` VALUES ('10', '1', '201904021720594460293996', null, '0', null, '0', '2019-04-02 17:20:59', '2019-04-02 17:20:59');
INSERT INTO `hippo_pay_info` VALUES ('11', '1', '201904021721391251285196', null, '0', null, '0', '2019-04-02 17:21:40', '2019-04-02 17:21:40');
INSERT INTO `hippo_pay_info` VALUES ('12', '1', '201904021722569129420396', null, '0', null, '0', '2019-04-02 17:22:56', '2019-04-02 17:22:56');
INSERT INTO `hippo_pay_info` VALUES ('13', '1', '201904021723254649103996', null, '0', null, '0', '2019-04-02 17:23:25', '2019-04-02 17:23:25');
INSERT INTO `hippo_pay_info` VALUES ('14', '1', '201904021724332398976496', null, '0', null, '0', '2019-04-02 17:24:33', '2019-04-02 17:24:33');
INSERT INTO `hippo_pay_info` VALUES ('15', '1', '201904021725435247287096', null, '0', null, '0', '2019-04-02 17:25:43', '2019-04-02 17:25:43');
INSERT INTO `hippo_pay_info` VALUES ('16', '1', '201904021726304105217296', null, '0', null, '0', '2019-04-02 17:26:30', '2019-04-02 17:26:30');
INSERT INTO `hippo_pay_info` VALUES ('17', '1', '201904021810235852906696', null, '0', null, '0', '2019-04-02 18:10:23', '2019-04-02 18:10:23');
INSERT INTO `hippo_pay_info` VALUES ('18', '1', '201904021840284695996296', null, '0', null, '0', '2019-04-02 18:40:28', '2019-04-02 18:40:28');
INSERT INTO `hippo_pay_info` VALUES ('19', '1', '201904021851401982204696', null, '0', null, '0', '2019-04-02 18:51:40', '2019-04-02 18:51:40');
INSERT INTO `hippo_pay_info` VALUES ('20', '1', '201904021929043976756096', null, '0', null, '0', '2019-04-02 19:29:04', '2019-04-02 19:29:04');
INSERT INTO `hippo_pay_info` VALUES ('21', '1', '201904022045125099651996', null, '0', null, '0', '2019-04-02 20:45:12', '2019-04-02 20:45:12');
INSERT INTO `hippo_pay_info` VALUES ('22', '1', '201904081227437076735596', null, '0', null, '0', '2019-04-08 12:27:43', '2019-04-08 12:27:43');
INSERT INTO `hippo_pay_info` VALUES ('23', '1', '201904081235302513625396', null, '0', null, '0', '2019-04-08 12:35:30', '2019-04-08 12:35:30');

-- ----------------------------
-- Table structure for hippo_sys_admin
-- ----------------------------
DROP TABLE IF EXISTS `hippo_sys_admin`;
CREATE TABLE `hippo_sys_admin` (
  `sid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '用户密码',
  `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵称',
  `avator` varchar(150) NOT NULL DEFAULT '' COMMENT '头像',
  `email` char(100) DEFAULT NULL COMMENT '邮箱地址',
  `mobile` char(20) DEFAULT NULL COMMENT '手机号码',
  `salt` char(8) NOT NULL DEFAULT '' COMMENT '密码盐值',
  `login` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '账号状态',
  `create_timestamp` datetime NOT NULL COMMENT '注册时间',
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统用户表';

-- ----------------------------
-- Records of hippo_sys_admin
-- ----------------------------
INSERT INTO `hippo_sys_admin` VALUES ('1', 'admin', 'ae60dccc071c71dc5e9e3b40d7eb3afb', '超级管理员', '/static/images/avatar-1.jpg', '578322713@qq.com', '18535318830', 'Zzayqe', '1', '1', '2018-12-14 19:04:11');

-- ----------------------------
-- Table structure for hippo_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `hippo_sys_menu`;
CREATE TABLE `hippo_sys_menu` (
  `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `type` varchar(10) NOT NULL DEFAULT 'admin' COMMENT '菜单类别（admin后台，user会员中心）',
  `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '分类图标',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`nid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of hippo_sys_menu
-- ----------------------------

-- ----------------------------
-- Table structure for hippo_user
-- ----------------------------
DROP TABLE IF EXISTS `hippo_user`;
CREATE TABLE `hippo_user` (
  `uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nickname` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL,
  `realname` varchar(32) DEFAULT NULL COMMENT '真实姓名',
  `gender` tinyint(4) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL COMMENT '登录凭据',
  `mobile` char(11) DEFAULT NULL COMMENT '手机号',
  `email` varchar(100) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL COMMENT '联系地址',
  `free_times` tinyint(4) NOT NULL DEFAULT '0' COMMENT '免费次数，根据服务费付费方式获得',
  `inviter_code` char(6) DEFAULT NULL COMMENT '邀请码',
  `id_card` char(18) DEFAULT NULL COMMENT '身份证号码',
  `credit_card` varchar(24) DEFAULT NULL COMMENT '银行卡号',
  `social_type` tinyint(4) DEFAULT NULL COMMENT '社保户别',
  `social_city` mediumint(8) DEFAULT NULL COMMENT '参保城市',
  `last_social_basic` mediumint(8) DEFAULT NULL COMMENT '上次缴纳社保基数',
  `last_fund_basic` mediumint(8) DEFAULT NULL COMMENT '上次缴纳公积金基数',
  `update_timestamp` datetime DEFAULT NULL COMMENT '更新时间',
  `create_timestamp` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_user
-- ----------------------------
INSERT INTO `hippo_user` VALUES ('1', '赵十四氏', '紫罗兰', '1', 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKUOC0ftZuklEBhfKc90VVlfdOSdy4fF92qtITzhaMQATCjAqRpFbNP8JibD74DkxfNvVMicL1aKcnw/0', '15532154466', '', '', '0', 'PTtbJF', '140321199105278033', null, '0', '0', null, null, '2019-04-04 15:12:28', '2019-03-14 14:25:55');
INSERT INTO `hippo_user` VALUES ('2', 'hm_UaTJRNpH', null, '1', 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKUOC0ftZuklEBhfKc90VVlfdOSdy4fF92qtITzhaMQATCjAqRpFbNP8JibD74DkxfNvVMicL1aKcnw/0', '15512346698', null, null, '0', 'GBZXDd', null, null, null, null, null, null, '2019-03-16 16:30:22', '2019-03-16 16:30:22');

-- ----------------------------
-- Table structure for hippo_user_auths
-- ----------------------------
DROP TABLE IF EXISTS `hippo_user_auths`;
CREATE TABLE `hippo_user_auths` (
  `uid` int(11) unsigned NOT NULL,
  `salt` char(6) NOT NULL COMMENT '密码盐值',
  `identity_type` char(8) NOT NULL COMMENT '登录类型 username,email,phone,weixin,qq,weibo,alipay,facebook,twitter,line,google',
  `identifier` varchar(255) NOT NULL COMMENT '登录凭据',
  `credential` varchar(11) DEFAULT NULL COMMENT '密码凭证'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hippo_user_auths
-- ----------------------------
INSERT INTO `hippo_user_auths` VALUES ('1', 'bhvtMJ', 'weixin', 'obqBt0f4y25Ugt8OVLIfolt9pWy4', '');
INSERT INTO `hippo_user_auths` VALUES ('2', 'qGDRLV', 'mobile', '15512346698', '1234');