被微信fiddler 拦截请求用什么来解决？他就是几个字。发放失败此请求存在风险已被
点击联系发帖人
时间：2016-12-16 16:25
/ managment
项目语言:None
权限:read-only(如需更高权限请先加入项目)
managment/
Index: sql.sql
===================================================================
--- sql.sql (revision 0)
+++ sql.sql (revision 3)
@@ -0,0 +1,385 @@
+SQLyog Ultimate v11.24 (32 bit)
+MySQL - 5.6.11 : Database - cancel
+*********************************************************************
+/*!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*/`cancel` /*!40100 DEFAULT CHARACTER SET utf8 */;
+USE `cancel`;
+/*Table structure for table `m_act` */
+DROP TABLE IF EXISTS `m_act`;
+CREATE TABLE `m_act` (
`id` int(10) NOT NULL COMMENT '活动id-主键',
`name` varchar(255) NOT NULL COMMENT '活动名称',
`dayWeek` int(2) NOT NULL COMMENT '星期几1-7',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`startTime` datetime NOT NULL COMMENT '活动开始时间',
`endTime` datetime NOT NULL COMMENT '活动结束时间',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_act` */
into `m_act`(`id`,`name`,`dayWeek`,`remark`,`startTime`,`endTime`) values (11,'会员日',4,'会员日',' 00:00:00',' 00:00:00'),(21,'4月会员日',2,'2',' 00:00:00',' 00:00:00');
+/*Table structure for table `m_act_property` */
+DROP TABLE IF EXISTS `m_act_property`;
+CREATE TABLE `m_act_property` (
`id` int(10) NOT NULL COMMENT '主键',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`price` int(10) NOT NULL COMMENT '红包的额度，元为单位',
`proportion` double NOT NULL COMMENT '占比，同一个活动类型加起来为1',
`num` int(10) DEFAULT NULL COMMENT '数量',
`isDefault` int(2) NOT NULL COMMENT '是否默认',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_act_property` */
into `m_act_property`(`id`,`actType`,`price`,`proportion`,`num`,`isDefault`) values (73,11,200,0.96,19176,1),(83,11,300,0.02,399,0),(93,11,300,0.01,197,0),(94,11,600,0.004,80,0),(95,11,800,0.003,60,0),(96,11,,60,0);
+/*Table structure for table `m_folio_record` */
+DROP TABLE IF EXISTS `m_folio_record`;
+CREATE TABLE `m_folio_record` (
`otaFolioId` varchar(50) NOT NULL COMMENT 'ota订单号-主键',
`folioId` varchar(50) DEFAULT NULL COMMENT '集团订单号',
`memberName` varchar(50) NOT NULL COMMENT '会员名称',
`memberId` int(10) NOT NULL COMMENT '会员id',
`phone` varchar(100) NOT NULL COMMENT '电话号码',
`STATUS` int(3) NOT NULL COMMENT '订单状态',
`hotelName` varchar(255) NOT NULL COMMENT '酒店名称',
`openId` varchar(255) NOT NULL COMMENT '微信openId',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`updateTime` datetime DEFAULT NULL COMMENT '更新时间',
`beginTime` datetime DEFAULT NULL COMMENT '订单开始时间',
`endTime` datetime DEFAULT NULL COMMENT '订单结束时间',
`checkInTime` datetime DEFAULT NULL COMMENT '入住时间',
`ip` varchar(255) DEFAULT NULL COMMENT '用户ip',
PRIMARY KEY (`otaFolioId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_folio_record` */
into `m_folio_record`(`otaFolioId`,`folioId`,`memberName`,`memberId`,`phone`,`STATUS`,`hotelName`,`openId`,`actType`,`createTime`,`updateTime`,`beginTime`,`endTime`,`checkInTime`,`ip`) values ('',NULL,'许佳',,'',1,'7天广州琶洲店','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,' 12:04:05',NULL,' 18:00:00',' 18:00:00',' 14:39:54','14.23.48.235'),('',NULL,'郑楚彬',,'',1,'7天长沙定王台店','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',11,' 11:47:33',NULL,' 18:00:00',' 14:00:00',NULL,'10.100.31.92');
+/*Table structure for table `m_redpack_record` */
+DROP TABLE IF EXISTS `m_redpack_record`;
+CREATE TABLE `m_redpack_record` (
`return_code` varchar(100) DEFAULT NULL COMMENT '通信标识',
`return_msg` varchar(255) DEFAULT NULL COMMENT '返回信息',
`result_code` varchar(100) DEFAULT NULL COMMENT 'SUCCESS/FAIL',
`err_code` varchar(255) DEFAULT NULL COMMENT '错误码信息',
`err_code_des` varchar(255) DEFAULT NULL COMMENT '结果信息描述',
`mch_billno` varchar(255) NOT NULL DEFAULT '' COMMENT '商户订单号',
`mch_id` varchar(255) DEFAULT NULL COMMENT '微信支付分配的商户号',
`wxappid` varchar(100) DEFAULT NULL COMMENT '商户appid',
`re_openid` varchar(100) DEFAULT NULL COMMENT 'openid',
`total_amount` int(10) DEFAULT NULL COMMENT '付款金额单位分',
`send_listid` varchar(100) DEFAULT NULL COMMENT '红包订单的微信单号',
`send_time` varchar(255) DEFAULT NULL COMMENT '红包发送时间',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`mch_billno`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_redpack_record` */
into `m_redpack_record`(`return_code`,`return_msg`,`result_code`,`err_code`,`err_code_des`,`mch_billno`,`mch_id`,`wxappid`,`re_openid`,`total_amount`,`send_listid`,`send_time`,`createTime`) values ('FAIL','参数错误:只能发放1.00块到200块钱的红包.','FAIL','MONEY_LIMIT','参数错误:只能发放1.00块到200块钱的红包.','5524','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',2,NULL,'0',NULL),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'7580','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',300,'9895','-',NULL),('FAIL','签名错误','FAIL','SIGN_ERROR','签名错误','6846','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',NULL),('FAIL','签名错误','FAIL','SIGN_ERROR','签名错误','4314','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',300,NULL,'0',NULL),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'5613','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'7672','-',NULL),('SUCCESS','openid和appid不匹配','FAIL','OPENID_ERROR','openid和appid不匹配','0787','','wx56daa115de20b2e1','oQqvKt-mQh7D5yQch-S3zSXmMCmg',200,NULL,'0',NULL),('SUCCESS','openid和appid不匹配','FAIL','OPENID_ERROR','openid和appid不匹配','0397','','wx56daa115de20b2e1','oQqvKt-mQh7D5yQch-S3zSXmMCmg',200,NULL,'0',NULL),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','1209','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',NULL),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','4525','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',' 16:19:28'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','7702','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:25:04'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','1044','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:26:41'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','0432','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:27:44'),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','6303','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',' 18:32:13'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'8864','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'7590','-',' 18:32:03'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','6439','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 10:50:23'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','2625','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 10:51:01'),('SUCCESS','超过频率限制,请稍后再试','FAIL','FREQ_LIMIT','超过频率限制,请稍后再试','5683','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',300,NULL,'0',' 10:51:03'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'3890','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'5070','-',' 10:53:32'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1351','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'4725','-',' 11:02:42'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','3204','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 11:16:15'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'6332','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'0425','-',' 11:17:10'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'4448','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'4367','-',' 11:17:36'),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','1642','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,NULL,'0',' 14:11:54'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1975','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'9416','-',' 14:20:00'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'2884','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'2101','-',' 14:21:03'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'6178','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'8630','-',' 14:24:20'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'3613','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',300,'3497','-',' 14:31:17'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'7551','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'6088','-',' 14:33:24'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1008','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'2373','-',' 14:40:00');
+/*Table structure for table `m_send_lot` */
+DROP TABLE IF EXISTS `m_send_lot`;
+CREATE TABLE `m_send_lot` (
`id` varchar(16) NOT NULL COMMENT '标识符',
`appid` varchar(32) NOT NULL COMMENT '公众号appid',
`sendTime` datetime DEFAULT NULL COMMENT '发送时间',
`source` varchar(255) NOT NULL COMMENT 'TXT文件名',
`totalCount` int(11) DEFAULT NULL COMMENT '红包总数',
`totalAmount` int(11) DEFAULT NULL COMMENT '红包总金额(单位:分)',
`status` tinyint(4) DEFAULT NULL COMMENT '状态码(成功 2，发送中 1,，失败0)',
`sentCount` int(11) DEFAULT NULL COMMENT '已发出红包数',
`sentAmount` int(11) DEFAULT NULL COMMENT '已发出红包金额',
`wishing` varchar(128) DEFAULT NULL COMMENT '红包祝福语',
`actName` varchar(32) DEFAULT NULL COMMENT '活动名称',
`remark` varchar(256) DEFAULT NULL COMMENT '备注'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_lot` */
+/*Table structure for table `m_send_record` */
+DROP TABLE IF EXISTS `m_send_record`;
+CREATE TABLE `m_send_record` (
`otaFolioId` varchar(50) NOT NULL COMMENT 'ota订单号-主键',
`memberName` varchar(50) NOT NULL COMMENT '会员名称',
`memberId` int(10) NOT NULL COMMENT '会员id',
`phone` varchar(100) NOT NULL COMMENT '电话号码',
`openId` varchar(255) NOT NULL COMMENT '微信openId',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`STATUS` int(3) NOT NULL COMMENT '发红包状态',
`sendTime` datetime DEFAULT NULL COMMENT '发红包时间',
`resendTime` datetime DEFAULT NULL COMMENT '退款时间',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`updateTime` datetime DEFAULT NULL COMMENT '更新时间',
`mch_billno` varchar(255) DEFAULT NULL COMMENT '商户订单号',
`ip` varchar(255) DEFAULT NULL COMMENT '用户ip',
`folioId` varchar(50) DEFAULT NULL COMMENT '集团订单号',
PRIMARY KEY (`otaFolioId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_record` */
into `m_send_record`(`otaFolioId`,`memberName`,`memberId`,`phone`,`openId`,`actType`,`STATUS`,`sendTime`,`resendTime`,`createTime`,`updateTime`,`mch_billno`,`ip`,`folioId`) values ('','许佳',,'','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,1,' 14:40:00',NULL,' 14:40:00',NULL,'1008','14.23.48.235',NULL),('','郑楚彬',,'','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,1,' 11:17:36',NULL,' 12:05:43',NULL,'4448','10.100.31.92',NULL);
+/*Table structure for table `m_send_redpack_record` */
+DROP TABLE IF EXISTS `m_send_redpack_record`;
+CREATE TABLE `m_send_redpack_record` (
`id` varchar(16) NOT NULL COMMENT '标识符',
`sendTime` varchar(14) DEFAULT NULL COMMENT '发送时间',
`sendType` varchar(10) DEFAULT NULL COMMENT '发送类型',
`sendLotId` varchar(16) NOT NULL COMMENT '批次ID',
`openid` varchar(32) DEFAULT NULL COMMENT '微信用户openid',
`amount` int(11) DEFAULT NULL COMMENT '红包总金额(单位:分)',
`status` varchar(16) DEFAULT NULL COMMENT '状态码',
`appid` varchar(50) DEFAULT NULL COMMENT 'appid',
`returnCode` varchar(16) DEFAULT NULL COMMENT '返回状态码,通信标识',
`returnMsg` varchar(128) DEFAULT NULL COMMENT '返回信息，如非空，为错误原因',
`resultCode` varchar(16) DEFAULT NULL COMMENT '业务结果，SUCCESS/FAIL',
`errCode` varchar(32) DEFAULT NULL COMMENT '错误码',
`errCodeDes` varchar(128) DEFAULT NULL COMMENT '错误代码描述',
`mchBillno` varchar(28) DEFAULT NULL COMMENT '商户订单号',
`mchId` varchar(32) DEFAULT NULL COMMENT '商户号',
`sendListid` varchar(32) DEFAULT NULL COMMENT '微信单号',
`refundTime` varchar(32) DEFAULT NULL COMMENT '红包退款时间',
`rcvTime` varchar(32) DEFAULT NULL COMMENT '红包领取时间',
`hbType` varchar(32) DEFAULT NULL COMMENT '红包类型'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_redpack_record` */
+/*Table structure for table `sys_app_user` */
+DROP TABLE IF EXISTS `sys_app_user`;
+CREATE TABLE `sys_app_user` (
`USER_ID` varchar(100) NOT NULL,
`USERNAME` varchar(255) DEFAULT NULL,
`PASSWORD` varchar(255) DEFAULT NULL,
`NAME` varchar(255) DEFAULT NULL,
`RIGHTS` varchar(255) DEFAULT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`LAST_LOGIN` varchar(255) DEFAULT NULL,
`IP` varchar(100) DEFAULT NULL,
`STATUS` varchar(32) DEFAULT NULL,
`BZ` varchar(255) DEFAULT NULL,
`PHONE` varchar(100) DEFAULT NULL,
`SFID` varchar(100) DEFAULT NULL,
`START_TIME` varchar(100) DEFAULT NULL,
`END_TIME` varchar(100) DEFAULT NULL,
`YEARS` int(10) DEFAULT NULL,
`NUMBER` varchar(100) DEFAULT NULL,
`EMAIL` varchar(32) DEFAULT NULL,
PRIMARY KEY (`USER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_app_user` */
into `sys_app_user`(`USER_ID`,`USERNAME`,`PASSWORD`,`NAME`,`RIGHTS`,`ROLE_ID`,`LAST_LOGIN`,`IP`,`STATUS`,`BZ`,`PHONE`,`SFID`,`START_TIME`,`END_TIME`,`YEARS`,`NUMBER`,`EMAIL`) values ('b00c2e2412','dsfsd','202cb962ac152d234b70','w','','c5a4e29ff6','','','1','','','','','',0,'001',''),('3faac8fe5cf9ea6f2d5870','dsfsdf','fd0b1ceab27f4e77c0c5d68','wewe','','68f23fc0caee475bae8d52244dea8444','','','1','','','','','',0,'wqwe','');
+/*Table structure for table `sys_dictionaries` */
+DROP TABLE IF EXISTS `sys_dictionaries`;
+CREATE TABLE `sys_dictionaries` (
`ZD_ID` varchar(100) NOT NULL,
`NAME` varchar(100) DEFAULT NULL,
`BIANMA` varchar(100) DEFAULT NULL,
`ORDY_BY` int(10) DEFAULT NULL,
`PARENT_ID` varchar(100) DEFAULT NULL,
`JB` int(10) DEFAULT NULL,
`P_BM` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`ZD_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_dictionaries` */
into `sys_dictionaries`(`ZD_ID`,`NAME`,`BIANMA`,`ORDY_BY`,`PARENT_ID`,`JB`,`P_BM`) values ('212a6765fddce1ec8c8e6c','人事部','001',1,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_001'),('3cec73a7cc8a4cb79e3f6ccc7fc8858c','行政部','002',2,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_002'),('41deb5ef01ac51a89c34','北京','dq001',1,'cdba0b5ef20e4fc0aae246a',2,'DQ_dq001'),('5a1547632cca449db378fbb9a042b336','研发部','004',4,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_004'),('7f9cd74e60a140b0aea5095faa95cda3','财务部','003',3,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_003'),('b861bd1c3aba4934acdbc6e','科技不','kj',7,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_kj'),('c067fdaf51a141aeaa56ed26b70de863','部门','BM',1,'0',1,'BM'),('cdba0b5ef20e4fc0aae246a','地区','DQ',2,'0',1,'DQ'),('f184bff71a1bd57599ed','上海','SH',2,'cdba0b5ef20e4fc0aae246a',2,'DQ_SH'),('f30bf95e216d4ebb30b8f','客服部','006',6,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_006');
+/*Table structure for table `sys_gl_qx` */
+DROP TABLE IF EXISTS `sys_gl_qx`;
+CREATE TABLE `sys_gl_qx` (
`GL_ID` varchar(100) NOT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`FX_QX` int(10) DEFAULT NULL,
`FW_QX` int(10) DEFAULT NULL,
`QX1` int(10) DEFAULT NULL,
`QX2` int(10) DEFAULT NULL,
`QX3` int(10) DEFAULT NULL,
`QX4` int(10) DEFAULT NULL,
PRIMARY KEY (`GL_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_gl_qx` */
into `sys_gl_qx`(`GL_ID`,`ROLE_ID`,`FX_QX`,`FW_QX`,`QX1`,`QX2`,`QX3`,`QX4`) values ('1','2',1,1,1,1,1,1),('2','1',0,1,1,0,1,1),('c5a4e29ff6','7',0,0,1,0,0,0),('68f23fc0caee475bae8d52244dea8444','7',0,0,1,1,0,0),('7dfd8d1f7bb7e63eec9b2','1',1,1,1,1,0,0),('ac66961adaac72ffeec117','1',1,0,1,1,0,0),('b0c77c29dfa140dc9b14a29c056f824f','7',1,0,1,1,0,0),('dea07a90ef','1',0,0,0,0,0,0),('e74fbd7fc','6',1,1,1,1,0,0),('f944a9dfbbcb8cb73b0c9b86','7',1,1,1,1,0,0);
+/*Table structure for table `sys_menu` */
+DROP TABLE IF EXISTS `sys_menu`;
+CREATE TABLE `sys_menu` (
`MENU_ID` int(11) NOT NULL,
`MENU_NAME` varchar(255) DEFAULT NULL,
`MENU_URL` varchar(255) DEFAULT NULL,
`PARENT_ID` varchar(100) DEFAULT NULL,
`MENU_ORDER` varchar(100) DEFAULT NULL,
`MENU_ICON` varchar(30) DEFAULT NULL,
`MENU_TYPE` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MENU_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_menu` */
into `sys_menu`(`MENU_ID`,`MENU_NAME`,`MENU_URL`,`PARENT_ID`,`MENU_ORDER`,`MENU_ICON`,`MENU_TYPE`) values (1,'系统管理','#','0','1','icon-desktop','1'),(2,'组织管理','role.do','1','2',NULL,'1'),(4,'会员管理','happuser/listUsers.do','1','4',NULL,'1'),(5,'系统用户','user/listUsers.do','1','3',NULL,'1'),(6,'信息管理','#','0','4','icon-list-alt','2'),(7,'图片管理','pictures/list.do','6','1',NULL,'2'),(8,'性能监控','druid/index.html','9','1',NULL,'1'),(9,'系统工具','#','0','3','icon-th','1'),(10,'接口测试','tool/interfaceTest.do','9','2',NULL,'1'),(11,'发送邮件','tool/goSendEmail.do','9','3',NULL,'1'),(12,'置二维码','tool/goTwoDimensionCode.do','9','4',NULL,'1'),(13,'多级别树','tool/ztree.do','9','5',NULL,'1'),(14,'地图工具','tool/map.do','9','6',NULL,'1'),(15,'微信管理','#','0','2','icon-list','2'),(20,'在线管理','onlinemanager/list.do','1','5',NULL,'1'),(22,'微信菜单','weinxinmenu/list.do','15','5',NULL,'2'),(23,'报表1','/redis.do','15','2',NULL,'2'),(24,'tghtrhrt','#','0','5',NULL,'1');
+/*Table structure for table `sys_permission` */
+DROP TABLE IF EXISTS `sys_permission`;
+CREATE TABLE `sys_permission` (
`ROLE_ID` int(10) unsigned NOT NULL,
`RESOURCE_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`ROLE_ID`,`RESOURCE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_permission` */
+/*Table structure for table `sys_resource` */
+DROP TABLE IF EXISTS `sys_resource`;
+CREATE TABLE `sys_resource` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SN` varchar(50) NOT NULL,
`TITLE` varchar(100) DEFAULT NULL,
`REMARK` varchar(200) DEFAULT NULL,
`PID` int(10) unsigned DEFAULT NULL,
`LFT` int(10) unsigned DEFAULT NULL,
`RGT` int(10) unsigned DEFAULT NULL,
`LEVEL` int(2) unsigned DEFAULT NULL,
`INSERT_DATE` datetime NOT NULL,
`UPDATE_DATE` datetime NOT NULL,
PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_resource` */
+/*Table structure for table `sys_role` */
+DROP TABLE IF EXISTS `sys_role`;
+CREATE TABLE `sys_role` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SN` varchar(50) DEFAULT NULL,
`NAME` varchar(50) NOT NULL,
`REMARK` varchar(200) DEFAULT NULL,
`STATUS` enum('ACTIVE','INACTIVE') NOT NULL,
`INSERT_DATE` datetime NOT NULL,
`UPDATE_DATE` datetime NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ROLE_SN` (`SN`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+/*Data for the table `sys_role` */
into `sys_role`(`ID`,`SN`,`NAME`,`REMARK`,`STATUS`,`INSERT_DATE`,`UPDATE_DATE`) values (1,'manager','管理员',NULL,'ACTIVE',' 19:15:51',' 19:15:53'),(2,'reader','用户',NULL,'ACTIVE',' 19:16:26',' 19:16:29'),(3,'author','作者',NULL,'ACTIVE',' 19:16:48',' 19:16:52');
+/*Table structure for table `sys_user` */
+DROP TABLE IF EXISTS `sys_user`;
+CREATE TABLE `sys_user` (
`id` int(10) unsigned NOT NULL COMMENT '用户ID，主键',
`account` varchar(45) DEFAULT NULL COMMENT '账号',
`password` varchar(255) NOT NULL COMMENT '密码',
`salt` varchar(255) NOT NULL COMMENT '密码加盐',
`name` varchar(45) NOT NULL COMMENT '用户名',
`type` tinyint(4) DEFAULT '2' COMMENT '用户类型 1 超级管理员用户 2 普通用户',
`email` varchar(500) DEFAULT NULL COMMENT '绑定邮箱',
`create_at` datetime DEFAULT NULL COMMENT '创建时间',
`status` tinyint(4) DEFAULT '1' COMMENT '状态',
`login_at` datetime DEFAULT NULL COMMENT '登陆时间',
`role_id` int(11) DEFAULT NULL COMMENT '角色ID',
`locked` tinyint(4) DEFAULT '0' COMMENT '0 未锁定 1锁定',
`change_password_time` datetime DEFAULT NULL COMMENT '密码修改时间',
`last_password` varchar(255) DEFAULT NULL COMMENT '上次使用的密码',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user` */
into `sys_user`(`id`,`account`,`password`,`salt`,`name`,`type`,`email`,`create_at`,`status`,`login_at`,`role_id`,`locked`,`change_password_time`,`last_password`) values (1,'xianwanadmin','F7B0E3F648F','c10-4ce5-8168-fe4f364c6fbb','我是站长',1,NULL,' 14:31:21',1,' 17:17:47',2,0,NULL,NULL),(42,'admin','0762F2CDF7E3C44BECA96B58DA;,'--8a40-7','超级管理员',1,'',' 10:18:54',1,' 14:12:33',52,0,NULL,NULL);
+/*Table structure for table `sys_user_qx` */
+DROP TABLE IF EXISTS `sys_user_qx`;
+CREATE TABLE `sys_user_qx` (
`U_ID` varchar(100) NOT NULL,
`C1` int(10) DEFAULT NULL,
`C2` int(10) DEFAULT NULL,
`C3` int(10) DEFAULT NULL,
`C4` int(10) DEFAULT NULL,
`Q1` int(10) DEFAULT NULL,
`Q2` int(10) DEFAULT NULL,
`Q3` int(10) DEFAULT NULL,
`Q4` int(10) DEFAULT NULL,
PRIMARY KEY (`U_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user_qx` */
into `sys_user_qx`(`U_ID`,`C1`,`C2`,`C3`,`C4`,`Q1`,`Q2`,`Q3`,`Q4`) values ('1',1,0,0,0,0,0,0,0),('2',1,1,1,1,1,1,1,1),('c5a4e29ff6',0,0,0,0,0,0,0,0),('68f23fc0caee475bae8d52244dea,0,0,0,0,0,0,0),('7dfd8d1f7bb7e63eec9b2',0,0,0,0,0,0,0,0),('ac66961adaac72ffeec117',0,0,0,0,0,0,0,0),('b0c77c29dfa140dc9b14a29c056f824f',0,0,0,0,0,0,0,0),('dea07a90ef',0,0,0,0,0,0,0,0),('e74fbd7fc',0,0,0,0,0,0,0,0),('f944a9dfbbcb8cb73b0c9b86',0,0,0,0,0,0,0,0);
+/*Table structure for table `sys_user_role` */
+DROP TABLE IF EXISTS `sys_user_role`;
+CREATE TABLE `sys_user_role` (
`USER_ID` int(10) unsigned NOT NULL,
`ROLE_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`USER_ID`,`ROLE_ID`),
KEY `FK_sys_user_role` (`ROLE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user_role` */
+/*!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 */;
(C)&&2013&&Alibaba&&Inc.&&All&&rights&&resvered.
Powered by}
项目语言:None
权限:read-only(如需更高权限请先加入项目)
managment/
Index: sql.sql
===================================================================
--- sql.sql (revision 0)
+++ sql.sql (revision 3)
@@ -0,0 +1,385 @@
+SQLyog Ultimate v11.24 (32 bit)
+MySQL - 5.6.11 : Database - cancel
+*********************************************************************
+/*!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*/`cancel` /*!40100 DEFAULT CHARACTER SET utf8 */;
+USE `cancel`;
+/*Table structure for table `m_act` */
+DROP TABLE IF EXISTS `m_act`;
+CREATE TABLE `m_act` (
`id` int(10) NOT NULL COMMENT '活动id-主键',
`name` varchar(255) NOT NULL COMMENT '活动名称',
`dayWeek` int(2) NOT NULL COMMENT '星期几1-7',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`startTime` datetime NOT NULL COMMENT '活动开始时间',
`endTime` datetime NOT NULL COMMENT '活动结束时间',
PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_act` */
into `m_act`(`id`,`name`,`dayWeek`,`remark`,`startTime`,`endTime`) values (11,'会员日',4,'会员日',' 00:00:00',' 00:00:00'),(21,'4月会员日',2,'2',' 00:00:00',' 00:00:00');
+/*Table structure for table `m_act_property` */
+DROP TABLE IF EXISTS `m_act_property`;
+CREATE TABLE `m_act_property` (
`id` int(10) NOT NULL COMMENT '主键',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`price` int(10) NOT NULL COMMENT '红包的额度，元为单位',
`proportion` double NOT NULL COMMENT '占比，同一个活动类型加起来为1',
`num` int(10) DEFAULT NULL COMMENT '数量',
`isDefault` int(2) NOT NULL COMMENT '是否默认',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_act_property` */
into `m_act_property`(`id`,`actType`,`price`,`proportion`,`num`,`isDefault`) values (73,11,200,0.96,19176,1),(83,11,300,0.02,399,0),(93,11,300,0.01,197,0),(94,11,600,0.004,80,0),(95,11,800,0.003,60,0),(96,11,,60,0);
+/*Table structure for table `m_folio_record` */
+DROP TABLE IF EXISTS `m_folio_record`;
+CREATE TABLE `m_folio_record` (
`otaFolioId` varchar(50) NOT NULL COMMENT 'ota订单号-主键',
`folioId` varchar(50) DEFAULT NULL COMMENT '集团订单号',
`memberName` varchar(50) NOT NULL COMMENT '会员名称',
`memberId` int(10) NOT NULL COMMENT '会员id',
`phone` varchar(100) NOT NULL COMMENT '电话号码',
`STATUS` int(3) NOT NULL COMMENT '订单状态',
`hotelName` varchar(255) NOT NULL COMMENT '酒店名称',
`openId` varchar(255) NOT NULL COMMENT '微信openId',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`updateTime` datetime DEFAULT NULL COMMENT '更新时间',
`beginTime` datetime DEFAULT NULL COMMENT '订单开始时间',
`endTime` datetime DEFAULT NULL COMMENT '订单结束时间',
`checkInTime` datetime DEFAULT NULL COMMENT '入住时间',
`ip` varchar(255) DEFAULT NULL COMMENT '用户ip',
PRIMARY KEY (`otaFolioId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_folio_record` */
into `m_folio_record`(`otaFolioId`,`folioId`,`memberName`,`memberId`,`phone`,`STATUS`,`hotelName`,`openId`,`actType`,`createTime`,`updateTime`,`beginTime`,`endTime`,`checkInTime`,`ip`) values ('',NULL,'许佳',,'',1,'7天广州琶洲店','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,' 12:04:05',NULL,' 18:00:00',' 18:00:00',' 14:39:54','14.23.48.235'),('',NULL,'郑楚彬',,'',1,'7天长沙定王台店','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',11,' 11:47:33',NULL,' 18:00:00',' 14:00:00',NULL,'10.100.31.92');
+/*Table structure for table `m_redpack_record` */
+DROP TABLE IF EXISTS `m_redpack_record`;
+CREATE TABLE `m_redpack_record` (
`return_code` varchar(100) DEFAULT NULL COMMENT '通信标识',
`return_msg` varchar(255) DEFAULT NULL COMMENT '返回信息',
`result_code` varchar(100) DEFAULT NULL COMMENT 'SUCCESS/FAIL',
`err_code` varchar(255) DEFAULT NULL COMMENT '错误码信息',
`err_code_des` varchar(255) DEFAULT NULL COMMENT '结果信息描述',
`mch_billno` varchar(255) NOT NULL DEFAULT '' COMMENT '商户订单号',
`mch_id` varchar(255) DEFAULT NULL COMMENT '微信支付分配的商户号',
`wxappid` varchar(100) DEFAULT NULL COMMENT '商户appid',
`re_openid` varchar(100) DEFAULT NULL COMMENT 'openid',
`total_amount` int(10) DEFAULT NULL COMMENT '付款金额单位分',
`send_listid` varchar(100) DEFAULT NULL COMMENT '红包订单的微信单号',
`send_time` varchar(255) DEFAULT NULL COMMENT '红包发送时间',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`mch_billno`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_redpack_record` */
into `m_redpack_record`(`return_code`,`return_msg`,`result_code`,`err_code`,`err_code_des`,`mch_billno`,`mch_id`,`wxappid`,`re_openid`,`total_amount`,`send_listid`,`send_time`,`createTime`) values ('FAIL','参数错误:只能发放1.00块到200块钱的红包.','FAIL','MONEY_LIMIT','参数错误:只能发放1.00块到200块钱的红包.','5524','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',2,NULL,'0',NULL),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'7580','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',300,'9895','-',NULL),('FAIL','签名错误','FAIL','SIGN_ERROR','签名错误','6846','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',NULL),('FAIL','签名错误','FAIL','SIGN_ERROR','签名错误','4314','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',300,NULL,'0',NULL),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'5613','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'7672','-',NULL),('SUCCESS','openid和appid不匹配','FAIL','OPENID_ERROR','openid和appid不匹配','0787','','wx56daa115de20b2e1','oQqvKt-mQh7D5yQch-S3zSXmMCmg',200,NULL,'0',NULL),('SUCCESS','openid和appid不匹配','FAIL','OPENID_ERROR','openid和appid不匹配','0397','','wx56daa115de20b2e1','oQqvKt-mQh7D5yQch-S3zSXmMCmg',200,NULL,'0',NULL),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','1209','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',NULL),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','4525','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',' 16:19:28'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','7702','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:25:04'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','1044','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:26:41'),('SUCCESS','参数错误:re_openid字段不正确,请检查是否合法','FAIL','PARAM_ERROR','参数错误:re_openid字段不正确,请检查是否合法','0432','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw\n',200,NULL,'0',' 18:27:44'),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','6303','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,NULL,'0',' 18:32:13'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'8864','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'7590','-',' 18:32:03'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','6439','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 10:50:23'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','2625','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 10:51:01'),('SUCCESS','超过频率限制,请稍后再试','FAIL','FREQ_LIMIT','超过频率限制,请稍后再试','5683','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',300,NULL,'0',' 10:51:03'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'3890','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'5070','-',' 10:53:32'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1351','','wx56daa115de20b2e1','oDMTPjrtPZP6_-5Tm-IcUPoFMdLs',200,'4725','-',' 11:02:42'),('SUCCESS','发放失败，此请求可能存在风险，已被微信拦截','FAIL','NO_AUTH','发放失败，此请求可能存在风险，已被微信拦截','3204','','wx56daa115de20b2e1','oDMTPjpRsK-TL6PFzHDkvxI1OvZo',200,NULL,'0',' 11:16:15'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'6332','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'0425','-',' 11:17:10'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'4448','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'4367','-',' 11:17:36'),('SUCCESS','签名错误','FAIL','SIGN_ERROR','签名错误','1642','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,NULL,'0',' 14:11:54'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1975','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'9416','-',' 14:20:00'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'2884','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'2101','-',' 14:21:03'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'6178','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'8630','-',' 14:24:20'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'3613','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',300,'3497','-',' 14:31:17'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'7551','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'6088','-',' 14:33:24'),('SUCCESS','发放成功','SUCCESS',NULL,NULL,'1008','','wx56daa115de20b2e1','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',200,'2373','-',' 14:40:00');
+/*Table structure for table `m_send_lot` */
+DROP TABLE IF EXISTS `m_send_lot`;
+CREATE TABLE `m_send_lot` (
`id` varchar(16) NOT NULL COMMENT '标识符',
`appid` varchar(32) NOT NULL COMMENT '公众号appid',
`sendTime` datetime DEFAULT NULL COMMENT '发送时间',
`source` varchar(255) NOT NULL COMMENT 'TXT文件名',
`totalCount` int(11) DEFAULT NULL COMMENT '红包总数',
`totalAmount` int(11) DEFAULT NULL COMMENT '红包总金额(单位:分)',
`status` tinyint(4) DEFAULT NULL COMMENT '状态码(成功 2，发送中 1,，失败0)',
`sentCount` int(11) DEFAULT NULL COMMENT '已发出红包数',
`sentAmount` int(11) DEFAULT NULL COMMENT '已发出红包金额',
`wishing` varchar(128) DEFAULT NULL COMMENT '红包祝福语',
`actName` varchar(32) DEFAULT NULL COMMENT '活动名称',
`remark` varchar(256) DEFAULT NULL COMMENT '备注'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_lot` */
+/*Table structure for table `m_send_record` */
+DROP TABLE IF EXISTS `m_send_record`;
+CREATE TABLE `m_send_record` (
`otaFolioId` varchar(50) NOT NULL COMMENT 'ota订单号-主键',
`memberName` varchar(50) NOT NULL COMMENT '会员名称',
`memberId` int(10) NOT NULL COMMENT '会员id',
`phone` varchar(100) NOT NULL COMMENT '电话号码',
`openId` varchar(255) NOT NULL COMMENT '微信openId',
`actType` int(3) NOT NULL COMMENT '活动类型Id',
`STATUS` int(3) NOT NULL COMMENT '发红包状态',
`sendTime` datetime DEFAULT NULL COMMENT '发红包时间',
`resendTime` datetime DEFAULT NULL COMMENT '退款时间',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`updateTime` datetime DEFAULT NULL COMMENT '更新时间',
`mch_billno` varchar(255) DEFAULT NULL COMMENT '商户订单号',
`ip` varchar(255) DEFAULT NULL COMMENT '用户ip',
`folioId` varchar(50) DEFAULT NULL COMMENT '集团订单号',
PRIMARY KEY (`otaFolioId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_record` */
into `m_send_record`(`otaFolioId`,`memberName`,`memberId`,`phone`,`openId`,`actType`,`STATUS`,`sendTime`,`resendTime`,`createTime`,`updateTime`,`mch_billno`,`ip`,`folioId`) values ('','许佳',,'','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,1,' 14:40:00',NULL,' 14:40:00',NULL,'1008','14.23.48.235',NULL),('','郑楚彬',,'','oDMTPjtqGsPwtqgEUPET1Ph5DcUw',11,1,' 11:17:36',NULL,' 12:05:43',NULL,'4448','10.100.31.92',NULL);
+/*Table structure for table `m_send_redpack_record` */
+DROP TABLE IF EXISTS `m_send_redpack_record`;
+CREATE TABLE `m_send_redpack_record` (
`id` varchar(16) NOT NULL COMMENT '标识符',
`sendTime` varchar(14) DEFAULT NULL COMMENT '发送时间',
`sendType` varchar(10) DEFAULT NULL COMMENT '发送类型',
`sendLotId` varchar(16) NOT NULL COMMENT '批次ID',
`openid` varchar(32) DEFAULT NULL COMMENT '微信用户openid',
`amount` int(11) DEFAULT NULL COMMENT '红包总金额(单位:分)',
`status` varchar(16) DEFAULT NULL COMMENT '状态码',
`appid` varchar(50) DEFAULT NULL COMMENT 'appid',
`returnCode` varchar(16) DEFAULT NULL COMMENT '返回状态码,通信标识',
`returnMsg` varchar(128) DEFAULT NULL COMMENT '返回信息，如非空，为错误原因',
`resultCode` varchar(16) DEFAULT NULL COMMENT '业务结果，SUCCESS/FAIL',
`errCode` varchar(32) DEFAULT NULL COMMENT '错误码',
`errCodeDes` varchar(128) DEFAULT NULL COMMENT '错误代码描述',
`mchBillno` varchar(28) DEFAULT NULL COMMENT '商户订单号',
`mchId` varchar(32) DEFAULT NULL COMMENT '商户号',
`sendListid` varchar(32) DEFAULT NULL COMMENT '微信单号',
`refundTime` varchar(32) DEFAULT NULL COMMENT '红包退款时间',
`rcvTime` varchar(32) DEFAULT NULL COMMENT '红包领取时间',
`hbType` varchar(32) DEFAULT NULL COMMENT '红包类型'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*Data for the table `m_send_redpack_record` */
+/*Table structure for table `sys_app_user` */
+DROP TABLE IF EXISTS `sys_app_user`;
+CREATE TABLE `sys_app_user` (
`USER_ID` varchar(100) NOT NULL,
`USERNAME` varchar(255) DEFAULT NULL,
`PASSWORD` varchar(255) DEFAULT NULL,
`NAME` varchar(255) DEFAULT NULL,
`RIGHTS` varchar(255) DEFAULT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`LAST_LOGIN` varchar(255) DEFAULT NULL,
`IP` varchar(100) DEFAULT NULL,
`STATUS` varchar(32) DEFAULT NULL,
`BZ` varchar(255) DEFAULT NULL,
`PHONE` varchar(100) DEFAULT NULL,
`SFID` varchar(100) DEFAULT NULL,
`START_TIME` varchar(100) DEFAULT NULL,
`END_TIME` varchar(100) DEFAULT NULL,
`YEARS` int(10) DEFAULT NULL,
`NUMBER` varchar(100) DEFAULT NULL,
`EMAIL` varchar(32) DEFAULT NULL,
PRIMARY KEY (`USER_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_app_user` */
into `sys_app_user`(`USER_ID`,`USERNAME`,`PASSWORD`,`NAME`,`RIGHTS`,`ROLE_ID`,`LAST_LOGIN`,`IP`,`STATUS`,`BZ`,`PHONE`,`SFID`,`START_TIME`,`END_TIME`,`YEARS`,`NUMBER`,`EMAIL`) values ('b00c2e2412','dsfsd','202cb962ac152d234b70','w','','c5a4e29ff6','','','1','','','','','',0,'001',''),('3faac8fe5cf9ea6f2d5870','dsfsdf','fd0b1ceab27f4e77c0c5d68','wewe','','68f23fc0caee475bae8d52244dea8444','','','1','','','','','',0,'wqwe','');
+/*Table structure for table `sys_dictionaries` */
+DROP TABLE IF EXISTS `sys_dictionaries`;
+CREATE TABLE `sys_dictionaries` (
`ZD_ID` varchar(100) NOT NULL,
`NAME` varchar(100) DEFAULT NULL,
`BIANMA` varchar(100) DEFAULT NULL,
`ORDY_BY` int(10) DEFAULT NULL,
`PARENT_ID` varchar(100) DEFAULT NULL,
`JB` int(10) DEFAULT NULL,
`P_BM` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`ZD_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_dictionaries` */
into `sys_dictionaries`(`ZD_ID`,`NAME`,`BIANMA`,`ORDY_BY`,`PARENT_ID`,`JB`,`P_BM`) values ('212a6765fddce1ec8c8e6c','人事部','001',1,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_001'),('3cec73a7cc8a4cb79e3f6ccc7fc8858c','行政部','002',2,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_002'),('41deb5ef01ac51a89c34','北京','dq001',1,'cdba0b5ef20e4fc0aae246a',2,'DQ_dq001'),('5a1547632cca449db378fbb9a042b336','研发部','004',4,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_004'),('7f9cd74e60a140b0aea5095faa95cda3','财务部','003',3,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_003'),('b861bd1c3aba4934acdbc6e','科技不','kj',7,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_kj'),('c067fdaf51a141aeaa56ed26b70de863','部门','BM',1,'0',1,'BM'),('cdba0b5ef20e4fc0aae246a','地区','DQ',2,'0',1,'DQ'),('f184bff71a1bd57599ed','上海','SH',2,'cdba0b5ef20e4fc0aae246a',2,'DQ_SH'),('f30bf95e216d4ebb30b8f','客服部','006',6,'c067fdaf51a141aeaa56ed26b70de863',2,'BM_006');
+/*Table structure for table `sys_gl_qx` */
+DROP TABLE IF EXISTS `sys_gl_qx`;
+CREATE TABLE `sys_gl_qx` (
`GL_ID` varchar(100) NOT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`FX_QX` int(10) DEFAULT NULL,
`FW_QX` int(10) DEFAULT NULL,
`QX1` int(10) DEFAULT NULL,
`QX2` int(10) DEFAULT NULL,
`QX3` int(10) DEFAULT NULL,
`QX4` int(10) DEFAULT NULL,
PRIMARY KEY (`GL_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_gl_qx` */
into `sys_gl_qx`(`GL_ID`,`ROLE_ID`,`FX_QX`,`FW_QX`,`QX1`,`QX2`,`QX3`,`QX4`) values ('1','2',1,1,1,1,1,1),('2','1',0,1,1,0,1,1),('c5a4e29ff6','7',0,0,1,0,0,0),('68f23fc0caee475bae8d52244dea8444','7',0,0,1,1,0,0),('7dfd8d1f7bb7e63eec9b2','1',1,1,1,1,0,0),('ac66961adaac72ffeec117','1',1,0,1,1,0,0),('b0c77c29dfa140dc9b14a29c056f824f','7',1,0,1,1,0,0),('dea07a90ef','1',0,0,0,0,0,0),('e74fbd7fc','6',1,1,1,1,0,0),('f944a9dfbbcb8cb73b0c9b86','7',1,1,1,1,0,0);
+/*Table structure for table `sys_menu` */
+DROP TABLE IF EXISTS `sys_menu`;
+CREATE TABLE `sys_menu` (
`MENU_ID` int(11) NOT NULL,
`MENU_NAME` varchar(255) DEFAULT NULL,
`MENU_URL` varchar(255) DEFAULT NULL,
`PARENT_ID` varchar(100) DEFAULT NULL,
`MENU_ORDER` varchar(100) DEFAULT NULL,
`MENU_ICON` varchar(30) DEFAULT NULL,
`MENU_TYPE` varchar(10) DEFAULT NULL,
PRIMARY KEY (`MENU_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_menu` */
into `sys_menu`(`MENU_ID`,`MENU_NAME`,`MENU_URL`,`PARENT_ID`,`MENU_ORDER`,`MENU_ICON`,`MENU_TYPE`) values (1,'系统管理','#','0','1','icon-desktop','1'),(2,'组织管理','role.do','1','2',NULL,'1'),(4,'会员管理','happuser/listUsers.do','1','4',NULL,'1'),(5,'系统用户','user/listUsers.do','1','3',NULL,'1'),(6,'信息管理','#','0','4','icon-list-alt','2'),(7,'图片管理','pictures/list.do','6','1',NULL,'2'),(8,'性能监控','druid/index.html','9','1',NULL,'1'),(9,'系统工具','#','0','3','icon-th','1'),(10,'接口测试','tool/interfaceTest.do','9','2',NULL,'1'),(11,'发送邮件','tool/goSendEmail.do','9','3',NULL,'1'),(12,'置二维码','tool/goTwoDimensionCode.do','9','4',NULL,'1'),(13,'多级别树','tool/ztree.do','9','5',NULL,'1'),(14,'地图工具','tool/map.do','9','6',NULL,'1'),(15,'微信管理','#','0','2','icon-list','2'),(20,'在线管理','onlinemanager/list.do','1','5',NULL,'1'),(22,'微信菜单','weinxinmenu/list.do','15','5',NULL,'2'),(23,'报表1','/redis.do','15','2',NULL,'2'),(24,'tghtrhrt','#','0','5',NULL,'1');
+/*Table structure for table `sys_permission` */
+DROP TABLE IF EXISTS `sys_permission`;
+CREATE TABLE `sys_permission` (
`ROLE_ID` int(10) unsigned NOT NULL,
`RESOURCE_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`ROLE_ID`,`RESOURCE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_permission` */
+/*Table structure for table `sys_resource` */
+DROP TABLE IF EXISTS `sys_resource`;
+CREATE TABLE `sys_resource` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SN` varchar(50) NOT NULL,
`TITLE` varchar(100) DEFAULT NULL,
`REMARK` varchar(200) DEFAULT NULL,
`PID` int(10) unsigned DEFAULT NULL,
`LFT` int(10) unsigned DEFAULT NULL,
`RGT` int(10) unsigned DEFAULT NULL,
`LEVEL` int(2) unsigned DEFAULT NULL,
`INSERT_DATE` datetime NOT NULL,
`UPDATE_DATE` datetime NOT NULL,
PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_resource` */
+/*Table structure for table `sys_role` */
+DROP TABLE IF EXISTS `sys_role`;
+CREATE TABLE `sys_role` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`SN` varchar(50) DEFAULT NULL,
`NAME` varchar(50) NOT NULL,
`REMARK` varchar(200) DEFAULT NULL,
`STATUS` enum('ACTIVE','INACTIVE') NOT NULL,
`INSERT_DATE` datetime NOT NULL,
`UPDATE_DATE` datetime NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ROLE_SN` (`SN`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+/*Data for the table `sys_role` */
into `sys_role`(`ID`,`SN`,`NAME`,`REMARK`,`STATUS`,`INSERT_DATE`,`UPDATE_DATE`) values (1,'manager','管理员',NULL,'ACTIVE',' 19:15:51',' 19:15:53'),(2,'reader','用户',NULL,'ACTIVE',' 19:16:26',' 19:16:29'),(3,'author','作者',NULL,'ACTIVE',' 19:16:48',' 19:16:52');
+/*Table structure for table `sys_user` */
+DROP TABLE IF EXISTS `sys_user`;
+CREATE TABLE `sys_user` (
`id` int(10) unsigned NOT NULL COMMENT '用户ID，主键',
`account` varchar(45) DEFAULT NULL COMMENT '账号',
`password` varchar(255) NOT NULL COMMENT '密码',
`salt` varchar(255) NOT NULL COMMENT '密码加盐',
`name` varchar(45) NOT NULL COMMENT '用户名',
`type` tinyint(4) DEFAULT '2' COMMENT '用户类型 1 超级管理员用户 2 普通用户',
`email` varchar(500) DEFAULT NULL COMMENT '绑定邮箱',
`create_at` datetime DEFAULT NULL COMMENT '创建时间',
`status` tinyint(4) DEFAULT '1' COMMENT '状态',
`login_at` datetime DEFAULT NULL COMMENT '登陆时间',
`role_id` int(11) DEFAULT NULL COMMENT '角色ID',
`locked` tinyint(4) DEFAULT '0' COMMENT '0 未锁定 1锁定',
`change_password_time` datetime DEFAULT NULL COMMENT '密码修改时间',
`last_password` varchar(255) DEFAULT NULL COMMENT '上次使用的密码',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user` */
into `sys_user`(`id`,`account`,`password`,`salt`,`name`,`type`,`email`,`create_at`,`status`,`login_at`,`role_id`,`locked`,`change_password_time`,`last_password`) values (1,'xianwanadmin','F7B0E3F648F','c10-4ce5-8168-fe4f364c6fbb','我是站长',1,NULL,' 14:31:21',1,' 17:17:47',2,0,NULL,NULL),(42,'admin','0762F2CDF7E3C44BECA96B58DA;,'--8a40-7','超级管理员',1,'',' 10:18:54',1,' 14:12:33',52,0,NULL,NULL);
+/*Table structure for table `sys_user_qx` */
+DROP TABLE IF EXISTS `sys_user_qx`;
+CREATE TABLE `sys_user_qx` (
`U_ID` varchar(100) NOT NULL,
`C1` int(10) DEFAULT NULL,
`C2` int(10) DEFAULT NULL,
`C3` int(10) DEFAULT NULL,
`C4` int(10) DEFAULT NULL,
`Q1` int(10) DEFAULT NULL,
`Q2` int(10) DEFAULT NULL,
`Q3` int(10) DEFAULT NULL,
`Q4` int(10) DEFAULT NULL,
PRIMARY KEY (`U_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user_qx` */
into `sys_user_qx`(`U_ID`,`C1`,`C2`,`C3`,`C4`,`Q1`,`Q2`,`Q3`,`Q4`) values ('1',1,0,0,0,0,0,0,0),('2',1,1,1,1,1,1,1,1),('c5a4e29ff6',0,0,0,0,0,0,0,0),('68f23fc0caee475bae8d52244dea,0,0,0,0,0,0,0),('7dfd8d1f7bb7e63eec9b2',0,0,0,0,0,0,0,0),('ac66961adaac72ffeec117',0,0,0,0,0,0,0,0),('b0c77c29dfa140dc9b14a29c056f824f',0,0,0,0,0,0,0,0),('dea07a90ef',0,0,0,0,0,0,0,0),('e74fbd7fc',0,0,0,0,0,0,0,0),('f944a9dfbbcb8cb73b0c9b86',0,0,0,0,0,0,0,0);
+/*Table structure for table `sys_user_role` */
+DROP TABLE IF EXISTS `sys_user_role`;
+CREATE TABLE `sys_user_role` (
`USER_ID` int(10) unsigned NOT NULL,
`ROLE_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`USER_ID`,`ROLE_ID`),
KEY `FK_sys_user_role` (`ROLE_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*Data for the table `sys_user_role` */
+/*!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 */;
(C)&&2013&&Alibaba&&Inc.&&All&&rights&&resvered.
Powered by}
我要回帖
更多推荐
- ·linux下如何chown修改文件所有者档的所有者
- ·目前帝伯朗显眼锅是否适合珐琅锅可以用钢丝球刷吗洗？内壁的涂层是铁还是珐琅？
- ·漫商汇电商具体是做什么的系统服务包括哪些？
- ·最适合人体适应的最佳湿度环境是多少健康的空气湿度是多少?医学
- ·台州市前十名私立高中最好的高中排名
- ·数位板可以插在笔记本电脑网线插口上吗？
- ·哪里可以玩手机qq积分斗地主斗地主能兑换积分
- ·主板技嘉b85 处理器 intel q9505 技嘉i5 4570 显卡技嘉gtx960， 内存金士顿8g硬盘希捷1tb 电源航嘉450w。值多少钱？
- ·奇兔刷机大师机型无法识别机型识别的时候无法显示
- ·CPU 是 i5-i5 6200u核显和940mx ，显卡是英伟达940m能带什么好一点的单机游戏呢
- ·如何判断一个点在ps如何做圆角矩形形内
- ·微信个人公众号自定义菜单单设置好了，也发布了，请问是永久的吗？
- ·《龙之谷二龙之谷精灵王座停播》电影资源谁有？不要用手机录的！
- ·华为手机如何苹果手机设置透明头像像
- ·希捷硬盘可以用多久久
- ·游戏不能魔兽3全屏两侧黑边，两侧有黑边。设置注册表不好使，显卡设置也不好使。先前游戏没有这样的情况，变了改不回去
- ·红米note4一键root软件怎么root
- ·apple pay 支付宝使用支付时需要额外收费吗
- ·苹果手机丢了，苹果7丢了关机能找回吗来吗
- ·享优享商城充话费骗局揭秘是真的吗
- ·被微信fiddler 拦截请求用什么来解决？他就是几个字。发放失败此请求存在风险已被
- ·我的手机不能运行圣安地列斯鼠标不能用怎么办
- ·请教，飞思卡尔单片机教程的四核和全志的四核对比
- ·渣打信用卡申请进度银行申请通过,多长时间到帐
- ·棕榈油进口关税牛油果油需要交多少关税
- ·个税税率表，上海个税计算器2016最简单计算及查询方法
- ·周大生监管码查询09018196773065268009麻烦查一下
- ·活动板房和住人集装箱活动板房哪个好?tie1.net
- ·什么叫万能险五类险
- ·关于汰换合同 模拟这个东西不能汰换么
- ·靠谱的微信社群管理工具工具有吗？
- ·全国外资保险企业企业保险公司有哪些
- ·有没有好的上海个税计算器2016，查询软件推荐？
- ·我国《企业破产法试行》规定的整顿申请人是谁
- ·77年出生今年多大开店铺店门朝哪开好
- ·我货了3万专员办直接支付却告诉我二万八我又多付二千，但是还款还是三万的本
