/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `ep_admin`
--
DROP TABLE IF EXISTS `ep_admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ep_admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`salt` varchar(30) NOT NULL DEFAULT '' COMMENT '密码盐',
`avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '电子邮箱',
`loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
`logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
`createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`token` varchar(59) NOT NULL DEFAULT '' COMMENT 'Session标识',
`status` varchar(30) NOT NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ep_admin`
--
LOCK TABLES `ep_admin` WRITE;
/*!40000 ALTER TABLE `ep_admin` DISABLE KEYS */;
INSERT INTO `ep_admin` VALUES (1,'admin','Admin','3c4d2f2e8c2f1581424248844af64cce','5043d8','/assets/img/avatar.png','123456@qq.co',0,1557842996,1492186163,1557842996,'29643df3-7b17-4e55-b962-23d6dddec5a2','normal'),(2,'yunying','运营','de28f6a06b16c2a17b6a25c822ad0bc5','8ZybhN','/assets/img/avatar.png','yunying@qq.com',0,1557457731,1556192246,1557457731,'6a1289a1-b264-444a-8a89-8bcc5affa0cf','normal');
/*!40000 ALTER TABLE `ep_admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ep_admin_log`
--
DROP TABLE IF EXISTS `ep_admin_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ep_admin_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
`username` varchar(30) NOT NULL DEFAULT '' COMMENT '管理员名字',
`url` varchar(1500) NOT NULL DEFAULT '' COMMENT '操作页面',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '日志标题',
`content` text NOT NULL COMMENT '内容',
`ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP',
`useragent` varchar(255) NOT NULL DEFAULT '' COMMENT 'User-Agent',
`createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
PRIMARY KEY (`id`),
KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员日志表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ep_api_account`
--
DROP TABLE IF EXISTS `ep_api_account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ep_api_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT '' COMMENT '名称',
`api_upstream_id` int(11) NOT NULL DEFAULT '0' COMMENT '上游类型',
`params` text NOT NULL COMMENT '接口参数',
`ifrepay` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否代付:0=否,1=是',
`ifrecharge` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否内充通道:0=否,1=是',
`domain` varchar(255) NOT NULL DEFAULT '' COMMENT '接口域名',
`createtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
`updatetime` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='接口账户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ep_api_account`
--
LOCK TABLES `ep_api_account` WRITE;
/*!40000 ALTER TABLE `ep_api_account` DISABLE KEYS */;
INSERT INTO `ep_api_account` VALUES (1,'支付猫',1,'{\"mch_id\":\"1535171311\",\"key\":\"gJYXNUcaw9qYtByVR4dJSeyXs9k5h9v0\"}','0','0','',1557803117,1557803117);
/*!40000 ALTER TABLE `ep_api_account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ep_api_channel`
--
DROP TABLE IF EXISTS `ep_api_channel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ep_api_channel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api_account_id` int(11) NOT NULL DEFAULT '0' COMMENT '接口账户id',
`api_type_id` int(11) NOT NULL DEFAULT '0' COMMENT '接口类型id',
`upstream_rate` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '上游费率',
`rate` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '费率',
`minmoney` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最低金额',
`maxmoney` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最大金额',
`daymoney` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '每天限额',
`todaymoney` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '当天交易量',
`today` varchar(24) NOT NULL DEFAULT '' COMMENT '当天日期',
`ifjump` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否跳转:0=否,1=是',
`status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '是否开启:0=否,1=是',
PRIMARY KEY (`id`),
KEY `idx_type_account` (`api_type_id`,`api_account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='接口账户和接口类型关联表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ep_api_channel`
--
LOCK TABLES `ep_api_channel` WRITE;
/*!40000 ALTER TABLE `ep_api_channel` DISABLE KEYS */;
INSERT INTO `ep_api_channel` VALUES (1,1,8,0.38,3.00,10.00,5000.00,50000.00,20.00,'2019-05-15',0,'1'),(2,1,6,0.38,2.50,1.00,5000.00,50000.00,3631.00,'2019-05-14',0,'1');
/*!40000 ALTER TABLE `ep_api_channel` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ep_api_log`
--
DROP TABLE IF EXISTS `ep_api_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ep_api_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`merchant_id` int(11) NOT NULL DEFAULT '0' COMMENT '商户号',
`http` varchar(255) NOT NULL DEFAULT '' COMMENT '来源',
`content` text NOT NULL COMMENT '参数',
`result` text NOT NULL COMMENT '提交结果',
`status` enum('0','1') NOT NULL DEFAULT '0' COMMENT '状态:0=失败,1=成功',
`orderno` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
`total_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单金额',
`channel` varchar(32) NOT NULL DEFAULT '' COMMENT '支付方式',
`ip` varchar(24) NOT NULL DEFAULT '' COMMENT '来源ip',
`createtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `idx_merchantid` (`merchant_id`,`createtime`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='接口日志表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ep_api_log`
--
LOCK TABLES `ep_api_log` WRITE;
/*!40000 ALTER TABLE `ep_api_log` DISABLE KEYS */;
INSERT INTO `ep_api_log` VALUES (1,2019051,'','
评论1