/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50525
Source Host : localhost:3306
Source Database : pethome
Target Server Type : MYSQL
Target Server Version : 50525
File Encoding : 65001
Date: 2020-10-26 11:10:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_department`
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`sn` varchar(255) DEFAULT NULL COMMENT '部门编号',
`name` varchar(255) DEFAULT NULL COMMENT '部门名称',
`dirPath` varchar(255) DEFAULT NULL COMMENT '部门的上级分类层级id',
`state` int(20) DEFAULT NULL COMMENT '部门状态,0正常,1禁用',
`manager_id` bigint(20) DEFAULT NULL COMMENT '部门管理员,关联Employee表id',
`parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门',
PRIMARY KEY (`id`),
KEY `manager_id` (`manager_id`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_department
-- ----------------------------
INSERT INTO `t_department` VALUES ('1', 'dept1', '部门1', '/1', '0', '324', null);
INSERT INTO `t_department` VALUES ('2', 'dept2', '部门2', '/2', '0', '324', null);
INSERT INTO `t_department` VALUES ('5', 'dept5', '部门5', '/2/5', '0', '324', '27');
INSERT INTO `t_department` VALUES ('7', 'dept7', '部门7', '/2/7', '0', '324', '2');
INSERT INTO `t_department` VALUES ('8', 'dept8', '部门8', '/2/5/8', '-1', '324', '5');
INSERT INTO `t_department` VALUES ('10', 'dept10', '部门10', '/2/5/10', '-1', '324', '5');
INSERT INTO `t_department` VALUES ('11', 'dept11', '部门11', '/1', '0', '324', '2');
INSERT INTO `t_department` VALUES ('12', 'dept12', '部门12', '/1', '-1', '324', '7');
INSERT INTO `t_department` VALUES ('17', 'dept17', '部门17', '/1/12/16', '0', '324', '16');
INSERT INTO `t_department` VALUES ('27', 'gg-jj', '鼓励师部门', '/1/12', '-1', '324', null);
INSERT INTO `t_department` VALUES ('34', '11', '1', '11', '-1', '324', null);
INSERT INTO `t_department` VALUES ('35', '2', '2', '2', '0', '324', null);
INSERT INTO `t_department` VALUES ('36', '1', '1', '', '0', '324', null);
INSERT INTO `t_department` VALUES ('37', '3', '3', '3', '0', '324', null);
INSERT INTO `t_department` VALUES ('38', '1', '1', '1', '0', '324', null);
INSERT INTO `t_department` VALUES ('39', '56', '5', '5', '0', '324', null);
INSERT INTO `t_department` VALUES ('40', '5', '66677777', '/2/7/40', '0', '324', '11');
INSERT INTO `t_department` VALUES ('41', '123', '111', '123', '0', '324', '2');
INSERT INTO `t_department` VALUES ('42', '3', '1', '3', '0', '324', null);
INSERT INTO `t_department` VALUES ('43', 'dept1', '部门1', '/1', '0', '324', null);
INSERT INTO `t_department` VALUES ('44', 'dept1', '部门1', '/1', '0', '324', null);
INSERT INTO `t_department` VALUES ('45', 'dept1', '部门1', '/1', '0', '324', null);
-- ----------------------------
-- Table structure for `t_employee`
-- ----------------------------
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE `t_employee` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`salt` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`state` int(1) DEFAULT NULL,
`department_id` bigint(20) DEFAULT NULL,
`logininfo_id` bigint(20) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK4AFD4ACE851EFECF` (`department_id`)
) ENGINE=InnoDB AUTO_INCREMENT=330 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_employee
-- ----------------------------
INSERT INTO `t_employee` VALUES ('324', 'yhptest', 'yhp@itsource.cn', '13330964748', null, '06b0f2f41d8f67a2bb21fa3f19d67e85', null, '1', null, '307', '27');
INSERT INTO `t_employee` VALUES ('325', 't', 't', '13330964749', null, 'deaa08a7e7555d44aff7aa9332ef72c2', null, '1', null, '308', null);
INSERT INTO `t_employee` VALUES ('326', 'f', 'f', '13330964785', null, 'b694e94f7118c446df4e703421784834', null, '1', null, '309', null);
INSERT INTO `t_employee` VALUES ('327', 'yhpjsjjy2', 'yhpjsjjy2@163.com', '18054784130', null, 'b46f9f4ab5530ce2757c1f65ed011c98', null, '1', null, '321', '35');
INSERT INTO `t_employee` VALUES ('328', 'yhptest1', 'yhptest1@itsource.cn', '13330964750', null, '06b0f2f41d8f67a2bb21fa3f19d67e85', null, '1', null, '322', '27');
INSERT INTO `t_employee` VALUES ('329', 'yhptest11', 'yhp@itsource.cn', '13330964748', '9ad15a2f-a25e-485d-897d-8a50cd68dea6', 'c483dbf590337fece8c130f8fd1511f6', '18', '1', '1', '323', null);
-- ----------------------------
-- Table structure for `t_employee_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_employee_role`;
CREATE TABLE `t_employee_role` (
`employee_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL,
PRIMARY KEY (`employee_id`,`role_id`),
KEY `FK87184F674D26E00F` (`role_id`),
KEY `FK87184F6710B1828F` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_employee_role
-- ----------------------------
INSERT INTO `t_employee_role` VALUES ('1', '1');
INSERT INTO `t_employee_role` VALUES ('2', '2');
INSERT INTO `t_employee_role` VALUES ('3', '4');
-- ----------------------------
-- Table structure for `t_logininfo`
-- ----------------------------
DROP TABLE IF EXISTS `t_logininfo`;
CREATE TABLE `t_logininfo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`salt` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`type` bit(1) DEFAULT NULL COMMENT '0 代表管理员 1 用户',
`disable` bit(1) DEFAULT NULL COMMENT '0 不可以用 1 可用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_logininfo
-- ----------------------------
INSERT INTO `t_logininfo` VALUES ('307', 'yhptest', '13330964748', 'yhp@itsource.cn', '7c09e8c2-07dd-4c25-ab62-d0cf0c154493', '06b0f2f41d8f67a2bb21fa3f19d67e85', '', '');
INSERT INTO `t_logininfo` VALUES ('320', '13330964748', '13330964748', '13330964748', '8f95ed7e-83cd-45e9-9b2d-35d6b45f547b', '0ab5cd275ff93cb382f08c11f4975b7f', '', '');
INSERT INTO `t_logininfo` VALUES ('321', 'yhpjsjjy2', '18054784130', 'yhpjsjjy2@163.com', 'd78effcc-1048-4187-b6b8-9388efe1d497', 'b46f9f4ab5530ce2757c1f65ed011c98', '', '');
INSERT INTO `t_logininfo` VALUES ('322', 'yhptest1', '13330964750', 'yhptest1@itsource.cn', '7c09e8c2-07dd-4c25-ab62-d0cf0c154493', '06b0f2f41d8f67a2bb21fa3f19d67e85', '', '');
INSERT INTO `t_logininfo` VALUES ('323', 'yhptest11', '13330964748', 'yhp@itsource.cn', '9ad15a2f-a25e-485d-897d-8a50cd68dea6', 'c483dbf590337fece8c130f8fd1511f6', '', '');
INSERT INTO `t_logininfo` VALUES ('324', '13330964750', '13330964750', null, '834a8f7e-b973-4987-a5a4-c91f72a0fe7f', '4a8925ac2a3e92fba9b16fb3f743e5c1', '', '');
-- ----------------------------
-- Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`icon` varchar(255) DEFAULT NULL,
`index` int(11) DEFAULT NULL,
`parent_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK24897F76799044` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES ('18', '员工管理', '/employee', null, '1', '19');
INSERT INTO `t_menu` VALUES ('19', '组织机构', null, null, '1', null);
INSERT INTO `t_menu` VALUES ('20', '部门管理', '/departemnt', null, '3', '19');
INSERT INTO `t_menu` VALUES ('21', '门店管理', '/shop', null, '2', '19');
-- ----------------------------
-- Table structure for `t_order_address`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_address`;
CREATE TABLE `t_order_address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`createTime` datetime DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`orderSn` varchar(255) DEFAULT NULL COMMENT '订单唯一标识',
`contacts` varchar(200) DEFAULT NULL COMMENT '收货人',
`areaCode` varchar(200) NOT NULL COMMENT '区域',
`address` varchar(200) DEFAULT NULL COMMENT '详细地址',
`fullAddress` varchar(200) DEFAULT NULL COMMENT '全地址',
`phone` char(11) NOT NULL COMMENT '手机号码',
`phoneBack` varchar(11) DEFAULT NULL COMMENT '备用手机号',
`tel` varchar(11) DEFAULT NULL COMMENT '固定电话',
`postCode` varchar(6) DEFAULT NULL COMMENT '邮编',
`email` varchar(30) DEFAULT NULL COMMENT '电子邮件',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='订单地址';
-- ----------------------------
-- Records of t_order_address
-- ----------------------------
INSERT INTO `t_order_address` VALUES ('37', '2020-06-12 15:05:31', null, '70', '9042496634', '艾迪 ', '湖北省 武汉市 洪山区', '雄楚大道666号(中南财经政法大学)', '成都市高新区府城大道西段399号天府新谷1号楼6F', '15888888888', '15888888888', null, '637500', 'yhptest@itsource.cn');
INSERT INTO `t_order_address` VALUES ('38', '2020-06-12 15:05:31', null, '71', '9047509741', '艾迪 ', '湖北省 武汉市 洪山区', '雄楚大道666号(中南财经政法大学)', '成都市高新区府城大道西段399号天府新谷1号楼6F', '15888888888', '15888888888', null, '637500', 'yhptest@itsource.cn');
INSERT INTO `t_order_address` VALUES ('39', '2020-06-12 15:05:31', null, '72', '9047507727', '艾迪 ', '湖北省 武汉市 洪山区', '雄楚大道666号(中南财经政法大学)', '成都市高新区府城大道西段399号天府新谷1号楼6F', '15888888888', '15888888888', null, '637500', 'yhptest@itsource.cn');
-- ----------------------------
-- Table structure for `t_order_adopt`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_adopt`;
CREATE TABLE `t_order_adopt` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`state` int(11) DEFAULT NULL COMMENT '待支付 已完成',
`price` decimal(10,0) DEFAULT NULL,
`orderSn` varchar(255) DEFAULT NULL,
`paySn` varchar(255) DEFAULT NULL,
`lastPayTime` datetime DEFAULT NULL,
`lastConfirmTime` datetime DEFAULT NULL,
`pet_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
`address_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_adopt
-- ----------------------------
INSERT INTO `t_order_adopt` VALUES ('18', '基础版洗澡', '0', '1', '20201589006361776', null, null, null, '8', '25', null, null);
INSERT INTO `t_order_adopt` VALUES ('19', '基础版洗澡', '0', '1', '20201589006565438', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_adopt` VALUES ('20', '基础版洗澡', '0', '20', '20201589008910966', null, null, null, '8', '0', null, null);
INSERT INTO `t_order_adopt` VALUES ('24', '基础版洗澡', '0', '30', '20201589251196292', null, null, null, '8', '23', null, null);
INSERT INTO `t_order_adopt` VALUES ('25', '基础版洗澡', '2', '30', '20201589251468624', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_adopt` VALUES ('26', '基础版洗澡', '2', '30', '20201589255035118', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_adopt` VALUES ('27', '高级洗澡', '2', '1000', '20201589255052276', null, null, null, '12', '25', null, null);
-- ----------------------------
-- Table structure for `t_order_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_goods`;
CREATE TABLE `t_order_goods` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`state` int(11) DEFAULT NULL COMMENT '待支付 已完成',
`price` decimal(10,0) DEFAULT NULL,
`orderSn` varchar(255) DEFAULT NULL,
`paySn` varchar(255) DEFAULT NULL,
`lastPayTime` datetime DEFAULT NULL,
`lastConfirmTime` datetime DEFAULT NULL,
`goods_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
`address_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_goods
-- ----------------------------
INSERT INTO `t_order_goods` VALUES ('18', '基础版洗澡', '0', '1', '20201589006361776', null, null, null, '8', '25', null, null);
INSERT INTO `t_order_goods` VALUES ('19', '基础版洗澡', '0', '1', '20201589006565438', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_goods` VALUES ('20', '基础版洗澡', '0', '20', '20201589008910966', null, null, null, '8', '0', null, null);
INSERT INTO `t_order_goods` VALUES ('24', '基础版洗澡', '0', '30', '20201589251196292', null, null, null, '8', '23', null, null);
INSERT INTO `t_order_goods` VALUES ('25', '基础版洗澡', '2', '30', '20201589251468624', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_goods` VALUES ('26', '基础版洗澡', '2', '30', '20201589255035118', null, null, null, '8', '24', null, null);
INSERT INTO `t_order_goods` VALUES ('27', '高级洗澡', '2', '1000', '20201589255052276', null, null, null, '12', '25', null, null);
-- ----------------------------
-- Table structure for `t_order_goods_detail`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_goods_detail`;
CREATE TABLE `t_order_goods_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`state` int(11) DEFAULT NULL COMMENT '待支付 已完成',
`price` decimal(10,0) DEFAULT NULL,
`orderSn` varchar(255) DEFAULT NULL,
`paySn` varchar(255) DEFAULT NULL,
`lastPayTime` datetime DEFAULT NULL,
`lastConfirmTime` datetime DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
`goods_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_goods_detail
-- ----------------------------
INSERT INTO `t_order_goods_detail` VALUES ('18', '基础版洗澡', '0', '1', '20201589006361776', null, null, null, null, '8', '25');
INSERT INTO `t_order_goods_detail` VALUES ('19', '基础版洗澡', '0', '1', '20201589006565438', null, null, null, null, '8', '24');
INSERT INTO `t_order_goods_detail` VALUES ('20', '基础版洗澡', '0', '20', '20201589008910966', null, null, null, null, '8', '0');
INSERT INTO `t_order_goods_detail` VALUES ('24', '基础版洗澡', '0', '30', '20201589251196292', null, null, null, null, '8', '23');
INSERT INTO `t_order_goods_detail` VALUES ('25', '基础版洗澡', '2', '30', '20201589251468624', null, null, null, null, '8', '24');
INSERT INTO `t_order_goods_detail` VALUES ('26', '基础版洗澡', '2', '30', '20201589255035118', null, null, null, null, '8', '24');
INSERT INTO `t_order_goods_detail` VALUES ('27', '高级洗澡', '2', '1000', '20201589255052276', null, null, null, null, '12', '25');
-- ----------------------------
-- Table structure for `t_order_pet_acquisition`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_pet_acquisition`;
CREATE TABLE `t_order_pet_acquisition` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`orderSn` varchar(255) DEFAULT NULL COMMENT '订单唯一编号',
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`lastcomfirmtime` datetime DEFAULT NULL,
`state` int(11) DEFAULT NULL COMMENT '待支付 待报账 待打款 已完成 已取消',
`price` decimal(10,0) DEFAULT NULL,
`paytype` int(11) DEFAULT '0' COMMENT '0垫付 1余额 2银行转账',
`paySn` varchar(255) DEFAULT NULL,
`pet_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL COMMENT '收购宠物的地址',
`emp_id` bigint(20) DEFAULT NULL COMMENT '店员id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_pet_acquisition
-- ----------------------------
INSERT INTO `t_order_pet_acquisition` VALUES ('30', '9040222925', '[摘要]对旺财87号收购订单!', null, '0', '100', '0', null, '63', '39', '27', '四川省成都市龙泉驿区蒲草路', '324');
INSERT INTO `t_order_pet_acquisition` VALUES ('31', '9040102999', '[摘要]对旺财11号收购订单!', null, '0', '0', '0', null, '64', '39', '27', '四川省成都市龙泉驿区蒲草路', '328');
INSERT INTO `t_order_pet_acquisition` VALUES ('32', '9042881488', '[摘要]对你收购订单!', null, '0', '10', '0', null, '65', '39', '27', '成都市武侯区成都菜单制作公司(高新店)', '324');
-- ----------------------------
-- Table structure for `t_order_product`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_product`;
CREATE TABLE `t_order_product` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`state` int(11) DEFAULT NULL COMMENT '待支付0 待消费1 待确认2 完成3 取消-1',
`price` decimal(10,0) DEFAULT NULL,
`orderSn` varchar(255) DEFAULT NULL,
`paySn` varchar(255) DEFAULT NULL,
`lastPayTime` datetime DEFAULT NULL,
`lastConfirmTime` datetime DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_product
-- ----------------------------
INSERT INTO `t_order_product` VALUES ('70', '[服务订单]购买1次精品洗澡折扣套餐服务!', '1', '99', '9042496634', null, '2020-09-18 17:17:46', null, '66', '39', '27');
INSERT INTO `t_order_product` VALUES ('71', '[服务订单]购买1次基础版洗澡服务!', '1', '30', '9047509741', '200920033110839', '2020-09-20 16:01:52', null, '8', '39', '27');
INSERT INTO `t_order_product` VALUES ('72', '[服务订单]购买1次基础版洗澡服务!', '-1', '30', '9047507727', '200920033915963', '2020-09-20 15:42:36', null, '8', '39', '27');
-- ----------------------------
-- Table structure for `t_order_product_detail`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_product_detail`;
CREATE TABLE `t_order_product_detail` (
`id` bigint(2) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '服务名称',
`resources` varchar(255) DEFAULT NULL COMMENT '存放fastdfs地址,多个资源使用,分割',
`saleprice` decimal(19,2) DEFAULT NULL,
`offsaletime` datetime DEFAULT NULL,
`onsaletime` datetime DEFAULT NULL,
`state` bigint(2) DEFAULT NULL COMMENT '状态:0下架 1上架',
`costprice` varchar(255) DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
`salecount` bigint(20) DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_product_detail
-- ----------------------------
INSERT INTO `t_order_product_detail` VALUES ('204', '精品洗澡折扣套餐', '/group1/M00/00/0C/rBEABV9bOveACZIYAABxhrXPkn0151.jpg,/group1/M00/00/0C/rBEABV9bOv2AIU4kAAD2Tqb_qxw712.jpg,/group1/M00/00/0C/rBEABV9bOwKAKXUHAAEBcx0BWYs849.jpg', '99.00', '2020-09-11 00:00:00', '2020-09-11 00:00:00', '1', '199', '2020-05-18 00:00:00', '10', '66', '70');
INSERT INTO `t_order_product_detail` VALUES ('205', '基础版洗澡', '/group1/M00/00/09/rBEABV9a40eAP_DeAAEBcx0BWYs661.jpg,/group1/M00/00/09/rBEABV9a40mATlmDAABxhrXPkn0117.jpg', '30.00', '2020-09-11 00:00:00', '2020-09-11 00:00:00', '1', '50', '2020-05-05 00:00:00', '10', '8', '71');
INSERT INTO `t_order_product_detail` VALUES ('206', '基础版洗澡', '/group1/M00/00/09/rBEABV9a40eAP_DeAAEBcx0BWYs661.jpg,/group1/M00/00/09/rBEABV9a40mATlmDAABxhrXPkn0117.jpg', '30.00', '2020-09-11 00:00:00', '2020-09-11 00:00:00', '1', '50', '2020-05-05 00:00:00', '10', '8', '72');
-- ----------------------------
-- Table structure for `t_order_recharge`
-- ----------------------------
DROP TABLE IF EXISTS `t_order_recharge`;
CREATE TABLE `t_order_recharge` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(255) DEFAULT NULL COMMENT '摘要',
`state` int(11) DEFAULT NULL COMMENT '待支付 已完成',
`money` decimal(10,0) DEFAULT NULL,
`orderSn` varchar(255) DEFAULT NULL,
`paySn` varchar(255) DEFAULT NULL,
`lastPayTime` datetime DEFAULT NULL,
`lastConfirmTime` datetime DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order_recharge
-- ----------------------------
INSERT INTO `t_order_recharge` VALUES ('18', '基础版洗澡', '0', '1', '20201589006361776', null, null, null, '25');
INSERT INTO `t_order_recharge` VALUES ('19', '基础版洗澡', '0', '1', '20201589006565438', null, null, null, '24');
INSERT INTO `t_order_recharge` VALUES ('20', '基础版洗澡', '0', '20', '20201589008910966', null, null, null, '0');
INSERT INTO `t_order_recharge` VALUES ('24', '基础版洗澡', '0', '30', '20201589251196292', null, null, null, '23');
INSERT INTO `t_order_recharge` VALUES ('25', '基础版洗澡', '2', '30', '20201589251468624', null, null, null, '24');
INSERT INTO `t_order_recharge` VALUES ('26', '基础版洗澡', '2', '30', '20201589255035118', null, null, null, '24');
INSERT INTO `t_order_recharge` VALUES ('27', '高级洗澡', '2', '1000', '20201589255052276', null, null, null, '25');
-- ----------------------------
-- Table structure for `t_pay_account`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_account`;
CREATE TABLE `t_pay_account` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`createTime` datetime DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
`useableBalance` int(11) NOT NULL DEFAULT '0' COMMENT '可用金额',
`frozenBalance` int(11) NOT NULL DEFAULT '0' COMMENT '冻结金额',
`creditBanance` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
`salt` varchar(255) DEFAULT NULL,
`payPassword` varchar(32) NOT NULL COMMENT '支付密码 md5加密+加盐',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户账户';
-- ----------------------------
-- Records of t_pay_account
-- ----------------------------
-- ----------------------------
-- Table structure for `t_pay_account_flow`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_account_flow`;
CREATE TABLE `t_pay_account_flow` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`createTime` bigint(20) DEFAULT NULL,
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
`nickName` varchar(20) DEFAULT NULL COMMENT '用户姓名',
`money` decimal(11,2) NOT NULL COMMENT '金额',
`type` tinyint(4) NOT NULL COMMENT '支付方式',
`businessType` varchar(4) NOT NULL COMMENT '业务类型',
`businessName` varchar(20) NOT NULL COMMENT '业务名',
`businessKey` bigint(20) NOT NULL COMMENT '关联业务键',
`payChannel` tinyint(4) NOT NULL,
`payChannelName` varchar(20) NOT NULL,
`note` varchar(50) DEFAULT NULL COMMENT '备注',
`digest` varchar(100) DEFAULT NULL,
`unionPaySeq` char(15) DEFAULT NULL COMMENT '统一支付单号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户支付流水';
-- ----------------------------
-- Records of t_pay_account_flow
-- ----------------------------
-- ----------------------------
-- Table structure for `t_pay_alipay_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_alipay_info`;
CREATE TABLE `t_pay_alipay_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`shop_id` bigint(20) DEFAULT NULL,
`shopName` varchar(255) DEFAULT NULL,
`appid` varchar(255) DEFAULT NULL COMMENT '应用id',
`merchant_private_key` varchar(2500) DEFAULT NULL COMMENT '商家私钥',
`alipay_public_key` varchar(2500) DEFAULT NULL COMMENT '支付宝公钥',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pay_alipay_info
-- ----------------------------
INSERT INTO `t_pay_alipay_info` VALUES ('1', '27', 'dbl公司', '2016082100302609', 'MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCRRYg5mEQZ4oqx22iFSKNnEddIQ0s8r6mIj/6K5iqznX9uoLJ1RfeO4aTb3SPUN00Sct8IW9/e8AN6bKck3m8lBkq47y+7tSn4U1fHYsf3Feb1A+dY3m9T+AmiCamb5ser6Cvy/GtvSCQ+TUxjGGZPrwQg9B3hVkWrqtNx2YKxCLbTWKP1cWu9a6muMt5G5ZQtuZGW8aFSOEoz3kDwOPCu6+Zv9AbxXhASva9y3HHdn1W4kC5McXkoaZz99xyrdqwEySqzPWFRPdhJqlxIeX49dLd8/Czl/vka2Js9DneePpOGekZukpe2e80qV9MCEL4NJjU3Dfy0FiY3uBeWrvKRAgMBAAECggEAJQZCrOMo4CwDy0avQeD8fGVop+s2vrXKkJqadk4pLfQDKW/da9Q0Pv81ZC/dVNXvV7ddLqUzzn7/c/FDPDtQum/7FV0onj+S/c5H/fIoIso7PdEL4nN2jkEWO20ZBDnyQ9b9dIVu4ELTselDgbITSVXCyJ9PCkJRqWn1T/vuui2rFV1EJVon7H1n5s6sEnGNbbP8wIVtPC8ehDwP4yQcQhgdpRXC8qsXGoSe9T598UsXbJr7T2SagrZrm1Vzaqh1SpJve/6DM34hCgJhN9kTVWfYvcSvgJq9oTro2Isz9da8iP9VCVsNlecsdzBgbembkRUMk5B/FDlnc9721LzOEQKBgQDCVPo7LKZHskkPWSd6t9n54bhYE2fFBPJzmiRXdHZlhVL5rZVUpWKfzCHptAegozqtuqnfbE4gFx2MISUqhBEeWb88HSWkFVwZrX+sCaLjJ3/RA/cdHEwjsjCHQ6mQ0vUxLY92duNkJrnHuvbflG/v2CkzsDyateIc6C/3KCT7bQKBgQC/XwVDFjgEQvcCDy1W0hMB5pUWrxv4/8qd+okQeJ42pgc4DkLNNCYUpObheSpCmic3XIEjevAc1Eh1j+E3C5Sy4W/iMiH9XDsusPVhDKt9RKdsEK9lsGAU8B64UHLLhwbUlJnbWDmluuASLmV6Y8XH/TiCTnnrXpWzzKbQqVZZNQKBgQCFc/H73Se7qNW/coxIHCXXEomUAo+Kn2EYvkwiutnr0ekviWM5o/Hcp0TKx1VNnYrYb43k3u2v3+/soX5yegt/ekZ3s9R7oCeFgr5gmKWBtUhzc3OqTBqFkQL+gRrbV+QGB7GzuuVhi66dWOnclIVigmGZG3gjDrDfBRybcLgk6QKBgQCX+47iSLMUL1qceBE58nzF9apR6Z/9kKgJ7v8L5b9BB3qUOj8zWUck/hGe3+uAGY0rmnu1Ad3QB4fEVhA29yuRJRkGO2pjHOyjmEZIXReU1QFiAZ5K1Fh6SHkdSEbi/Mmf6qSGXvrpdBCgX9iX6sUYnzJRyqFpHCUoNlAFR3ccQQKBgDxVWS8fxqbJ0umm4zfbtml2shan4+K8xKnSK9MUltf2UgPDt6F/I0Ky3XliyTO6tnbFuVsM0ktf3oLY1Htf9/kj4w2J1hEfDpgsPdDqWOR4LUm+o6HbCaT/0uvbDYZ1bTx4CWxWuOEUnZ5ICd+eqAanN7T5kduE/OR8N/cRuMxe', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyGZj7CFzHOkv0JIYADbGmHyNY4KoehGPmDF+YqosUcKr+AZ/VezF1fhKXQJ7pkVDb3T7ZbDGf6iLxoNAft/FLlmpKxyt5uq1kqzQ4PSAdk4ogqKYtawJQx3lfv1Gz+/0OFTbOHyLm/MieXF7I2MvkWUAq7cECDmpcDLHB9x71BaLyQ8hbPqiq95d7EIWFBdKC9bsWC5k8HXd4kafrlfMhSeMwo9Oe/QQIjauBBMRUPMGwsVG0+HtLG2h1+GzU6gItmQDaoXcIkY0z3+3BXilPnx9AWVAujNNU4Xi8aNNHmR/LeedCmXTwEEBKe0dzzqd4NbeG+bl8TTMiyapJDtHLwIDAQAB');
-- ----------------------------
-- Table structure for `t_pay_bank_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_bank_info`;
CREATE TABLE `t_pay_bank_info` (
`merchant_private_key` varchar(2500) DEFAULT NULL,
`appid` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`alipay_public_key` varchar(2500) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
`shopName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pay_bank_info
-- ----------------------------
INSERT INTO `t_pay_bank_info` VALUES ('MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC2n7vVzFsIzAhS1hFM6f3UlQOAvkdKYfQgi1nNi73GWFHo6cWq+woivrZ30JPbwIRdhuo/oCHS4Ip6hFMpDoLaVX0dq1mYR7UNcQQz2nGFH4KTTmOMOaTv1Jmw1xh+p1cUesTLm266kQp+YApykhmrhl6cUV/ghEN160qN+Qx+KLPuuRDGIqfIPi7zo784ARp4LswujW/XV7w1OOu+1M7Mx5DbVdmTXlCrxjSjg4vjyK8xHxA3nqjJgeuc+nrIhmkWCSNcmCfee/fqDcNOOa3gv2gBy+Bh9Xa7Uew8z/5j502Wx9vVLgykANgid+H8bgZExs1qEtZRiANKLQi1ur91AgMBAAECggEAC/zkSZ6Gg0dRbI6cyB28Cc5WUocrCtjvO4uqM3Hu3SxDBDUEQrsD6U/3jlnkutIiXjlS+yY50ivnKy+wfct0D3z5H4917CcY3W8DxZubRA/TdHP62OOXzh54kEEuXHIDp1Z/wJXNaPXIaI9JYEfy422InF5DGuvTudPeKv+kMEvDMpInPsOb+4CIxCDsYm3rbjJb7V7no97+zkAPD492SMbIRWG10AukgGxUqwKRQAyaLwwuiWUxGhApzd7RLCn8dFlj1SqeKgtfmN0CGWUKGCFSEOuUoVrFlnyboy4+o4cNl5mJmsmR59SxtN+pkH2FyNDPGuuuaY5MdZXdhUwpgQKBgQDs5BoDBLuh92jvWcYdww8A6fW822t+SKr/MtUmIka3q6n4Ol3gR1kMbhB7wlOZGY90IliJEgoZRwLVS0uzZWkiDdYcqThIU5I+LJpZ4Beu2r6JkzTlQEeUzD8I1oqPZupHLK3A0a3fX3TH6o/s2kgNqWDVFdbxW6fdCyyZTvQiZQKBgQDFWv6iHKK5OS2KimmPpKcClC+mfTbUeL0Axf972GNfmE35BUyFoSX2hU6XPN+3mmN3ibIVCYJSYXRDx9O684dmyfbLR4VIl8tHeNzNI+tHq/G+C7W2pIL7NYTHFi55eZ1jzUry4vCarXttyhfk8DdzK/csHcwt9jC4pAaO3v/P0QKBgGKXnOvcsGr8mcPkTTxdzoTG2uu7NsXcYK7N7UBty5jt7VPOlvudNkaiGGIpwrlZlgbztH138JQMpfU33U3QyyzNLWvIUhBoF9mgnq0BQ1oW2G5RwhYX5rLbPvDiudBtONxekAJMQl1RUT1TNouRXaOx9wc4i7jwOLEa0XkNDzaxAoGAK82gira0X0wTkZZbC6jN8MKXOOq9yrbprExGAmTq2YLie4zziQ1Vcbvwz5yRQx0fSp7jScwMguBif9DQa8Q1n1jgUAoVySD322s2BsocJJJDW50ZveoRsFQWnmGL+yZFCqu8IODB6nLq3FloqEWw6P0vJTmP4fusoK63Teqs+KECgYBMx6wLaDzzC5wC7dpVjBpKh7AptoIf+F3lji+b720Hs9BuZmkYME7EUg2ImK+B42PBm84qIWvzf68Et0DA5wb8dn+SGPh+8pzIEcKH7DEEnKHCljpOJEEcCq3EMrsePzCtSZq1VtQv8pSWggpZA0a2qdkGKejdPD0EF87/pkWSog==', '2016102800775134', '1', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyGZj7CFzHOkv0JIYADbGmHyNY4KoehGPmDF+YqosUcKr+AZ/VezF1fhKXQJ7pkVDb3T7ZbDGf6iLxoNAft/FLlmpKxyt5uq1kqzQ4PSAdk4ogqKYtawJQx3lfv1Gz+/0OFTbOHyLm/MieXF7I2MvkWUAq7cECDmpcDLHB9x71BaLyQ8hbPqiq95d7EIWFBdKC9bsWC5k8HXd4kafrlfMhSeMwo9Oe/QQIjauBBMRUPMGwsVG0+HtLG2h1+GzU6gItmQDaoXcIkY0z3+3BXilPnx9AWVAujNNU4Xi8aNNHmR/LeedCmXTwEEBKe0dzzqd4NbeGMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjvfo55mGqxaitkXSi2tO/eB6cyCf62hpg15g55GIdQ3kHf7RxLtbyppHF8VMMKGV8vQO9vEImEaHevIjNBcawv2wfUA/etXWSpwThozibrclTfAjR7vs0kuS0KeGHxTwLzIJvsTxUxr3NLV2WF0NmmShSUoTpwq1qrOKByhH8dA15StjNtLtsRIl+gfkqaciyXSfPAlOamL7+ba/WsHGXK+Dtq7e3HV6h8zMpGfqnXgOvxlDFxD0va4WCpOzsDs3f9Ejn9JUnP2vMZNyl1dsVYRiLwWo5p91yzmqWFEQdnaPxvMgbLrTgbWKw6xLN033R+nTXNtabAGJsR3WKMsm1QIDAQAB', '27', 'dbl公司');
-- ----------------------------
-- Table structure for `t_pay_bill`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_bill`;
CREATE TABLE `t_pay_bill` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`digest` varchar(100) DEFAULT NULL COMMENT '交易摘要',
`money` decimal(11,2) NOT NULL COMMENT '金额',
`state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '支付状态 0待支付1 已支付-1 取消',
`lastPayTime` datetime DEFAULT NULL,
`payChannel` tinyint(4) NOT NULL COMMENT '支付方式 余额 三方支付(支付宝,微信,银联)',
`createTime` datetime DEFAULT NULL,
`updateTime` datetime DEFAULT NULL,
`unionPaySn` char(15) DEFAULT NULL COMMENT '统一支付单号',
`businessType` varchar(255) NOT NULL COMMENT '业务类型',
`businessKey` bigint(20) NOT NULL COMMENT '关联业务键',
`user_id` bigint(20) DEFAULT NULL,
`nickName` varchar(255) DEFAULT '',
`shopName` varchar(255) DEFAULT NULL,
`shop_id` bigint(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='支付单';
-- ----------------------------
-- Records of t_pay_bill
-- ----------------------------
INSERT INTO `t_pay_bill` VALUES ('27', '[服务订单]购买1次精品洗澡折扣套餐服务!', '99.00', '1', '2020-09-18 17:17:46', '1', '2020-09-18 16:47:46', null, '200918044747371', 'business_type_product_order', '70', '39', null, null, '27');
INSERT INTO `t_pay_bill` VALUES ('28', '[服务订单]购买1次基础版洗澡服务!', '30.00', '1', '2020-09-20 16:01:52', '1', '2020-09-20 15:31:52', null, '200920033110839', 'business_type_product_order', '71', '39', null, null, '27');
INSERT INTO `t_pay_bill` VALUES ('29', '[服务订单]购买1次基础版洗澡服务!', '30.00', '-1', '2020-09-20 16:09:37', '1', '2020-09-20 15:39:37', null, '200920033915963', 'business_type_product_order', '72', '39', null, null, '27');
-- ----------------------------
-- Table structure for `t_pay_wechat_info`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_wechat_info`;
CREATE TABLE `t_pay_wechat_info` (
`merchant_private_key` varchar(2500) DEFAULT NULL,
`appid` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`alipay_public_key` varchar(2500) DEFAULT NULL,
`shop_id` bigint(20) DEFAULT NULL,
`shopName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_pay_wechat_info
-- ----------------------------
INSERT INTO `t_pay_wechat_info` VALUES ('MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC2n7vVzFsIzAhS1hFM6f3UlQOAvkdKYfQgi1nNi73GWFHo6cWq+woivrZ30JPbwIRdhuo/oCHS4Ip6hFMpDoLaVX0dq1mYR7UNcQQz2nGFH4KTTmOMOaTv1Jmw1xh+p1cUesTLm266kQp+YApykhmrhl6cUV/ghEN160qN+Qx+KLPuuRDGIqfIPi7zo784ARp4LswujW/XV7w1OOu+1M7Mx5DbVdmTXlCrxjSjg4vjyK8xHxA3nqjJgeuc+nrIhmkWCSNcmCfee/fqDcNOOa3gv2gBy+Bh9Xa7Uew8z/5j502Wx9vVLgykANgid+H8bgZExs1qEtZRiANKLQi1ur91AgMBAAECggEAC/zkSZ6Gg0dRbI6cyB28Cc5WUocrCtjvO4uqM3Hu3SxDBDUEQrsD6U/3jlnkutIiXjlS+yY50ivnKy+wfct0D3z5H4917CcY3W8DxZubRA/TdHP62OOXzh54kEEuXHIDp1Z/wJXNaPXIaI9JYEfy422InF5DGuvTudPeKv+kMEvDMpInPsOb+4CIxCDsYm3rbjJb7V7no97+zkAPD492SMbIRWG10AukgGxUqwKRQAyaLwwuiWUxGhApzd7RLCn8dFlj1SqeKgtfmN0CGWUKGCFSEOuUoVrFlnyboy4+o4cNl5mJmsmR59SxtN+pkH2FyNDPGuuuaY5MdZXdhUwpgQKBgQDs5BoDBLuh92jvWcYdww8A6fW822t+SKr/MtUmIka3q6n4Ol3gR1kMbhB7wlOZGY90IliJEgoZRwLVS0uzZWkiDdYcqThIU5I+LJpZ4Beu2r6JkzTlQEeUzD8I1oqPZupHLK3A0a3fX3TH6o/s2kgNqWDVFdbxW6fdCyyZTvQiZQKBgQDFWv6iHKK5OS2KimmPpKcClC+mfTbUeL0Axf972GNfmE35BUyFoSX2hU6XPN+3mmN3ibIVCYJSYXRDx9O684dmyfbLR4VIl8tHeNzNI+tHq/G+C7W2pIL7NYTHFi55eZ1jzUry4vCarXttyhfk8DdzK/csHcwt9jC4pAaO3v/P0QKBgGKXnOvcsGr8mcPkTTxdzoTG2uu7NsXcYK7N7UBty5jt7VPOlvudNkaiGGIpwrlZlgbztH138JQMpfU33U3QyyzNLWvIUhBoF9mgnq0BQ1oW2G5RwhYX5rLbPvDiudBtONxekAJMQl1RUT1TNouRXaOx9wc4i7jwOLEa0XkNDzaxAoGAK82gira0X0wTkZZbC6jN8MKXOOq9yrbprExGAmTq2YLie4zziQ1Vcbvwz5yRQx0fSp7jScwMguBif9DQa8Q1n1jgUAoVySD322s2BsocJJJDW50ZveoRsFQWnmGL+yZFCqu8IODB6nLq3FloqEWw6P0vJTmP4fusoK63Teqs+KECgYBMx6wLaDzzC5wC7dpVjBpKh7AptoIf+F3lji+b720Hs9BuZmkYME7EUg2ImK+B42PBm84qIWvzf68Et0DA5wb8dn+SGPh+8pzIEcKH7DEEnKHCljpOJEEcCq3EMrsePzCtSZq1VtQv8pSWggpZA0a2qdkGKejdPD0EF87/pkWSog==', '2016102800775134', '1', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyGZj7CFzHOkv0JIYADbGmHyNY4KoehGPmDF+YqosUcKr+AZ/VezF1fhKXQJ7pkVDb3T7ZbDGf6iLxoNAft/FLlmpKxyt5uq1kqzQ4PSAdk4ogqKYtawJQx3lfv1Gz+/0OFTbOHyLm/MieXF7I2MvkWUAq7cECDmpcDLHB9x71BaLyQ8hbPqiq95d7EIWFBdKC9bsWC5k8HXd4kafrlfMhSeMwo9Oe/QQIjauBBMRUPMGwsVG0+HtLG2h1+GzU6gItmQDaoXcIkY0z3+3BXilPnx9AWVAujNNU4Xi8aNNHmR/LeedCmXTwEEBKe0dzzqd4NbeGMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjvfo55mGqxaitkXSi2tO/eB6cyCf62hpg15g55GIdQ3kHf7RxLtbyppHF8VMMKGV8vQO9vEImEaHevIjNBcawv2wfUA/etXWSpwThozibrclTfAjR7vs0kuS0KeGHxTwLzIJvsTxUxr3NLV2WF0NmmShSUoTpwq1qrOKByhH8dA15StjNtLtsRIl+gfkqaciyXSfPAlOamL7+ba/WsHGXK+Dtq7e3HV6h8zMpGfqnXgOvxlDFxD0va4WCpOzsDs3f9Ejn9JUnP2vMZNyl1dsVYRiLwWo5p91yzmqWFEQdnaPxvMgbLrTgbWKw6xLN033R+nTXNtabAGJsR3WKMsm1QIDAQAB', '27', 'dbl公司');
-- ----------------------------
-- Table structure for `t_permission`
-- ----------------------------
DROP TABLE IF EXISTS &#