db.sql

/*
 Navicat Premium Data Transfer

 Source Server         : x-rv.com
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : 127.0.0.1:3306
 Source Schema         : fxpay

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 16/12/2020 06:59:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fx_admin
-- ----------------------------
DROP TABLE IF EXISTS `fx_admin`;
CREATE TABLE `fx_admin`  (
  `adminid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `adminname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员账号',
  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员密码',
  `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员真实姓名',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员Email',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0启用 1禁用',
  `savecode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '安全码',
  `lastip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '最后一次登录IP',
  `powerid` int(10) NULL DEFAULT 0 COMMENT '权限id',
  `google_secret` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`adminid`) USING BTREE,
  UNIQUE INDEX `adminname`(`adminname`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_admin
-- ----------------------------
INSERT INTO `fx_admin` VALUES (1, 'admin', 'a66abb5684c45962d887564f08346e8d', 'admin', '18888888888', '88888@88.com', 0, 0, '}h5i!,\\0ziS:OTX', '', 1, '');

-- ----------------------------
-- Table structure for fx_bank
-- ----------------------------
DROP TABLE IF EXISTS `fx_bank`;
CREATE TABLE `fx_bank`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `bankname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '银行名称',
  `bankcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编码',
  `icon` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0正常 1取消',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `orderid` int(10) NOT NULL DEFAULT 99 COMMENT '排序',
  `pzid` int(11) NOT NULL DEFAULT 0 COMMENT '配置id 默认0系统配置',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `bankcode`(`bankcode`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '银行表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_bank
-- ----------------------------
INSERT INTO `fx_bank` VALUES (1, '中国银行', 'BOC', '/Public/index/pay/boc.png', 0, 1523020554, 99, 0);
INSERT INTO `fx_bank` VALUES (2, '中国工商银行', 'ICBC', '/Public/index/pay/icbc.png', 0, 1523022485, 99, 0);
INSERT INTO `fx_bank` VALUES (3, '中国建设银行', 'CCB', '/Public/index/pay/ccb.png', 0, 1523022549, 99, 0);
INSERT INTO `fx_bank` VALUES (4, '中国农业银行', 'ABC', '/Public/index/pay/abc.png', 0, 1523022635, 99, 0);
INSERT INTO `fx_bank` VALUES (5, '中国邮政银行', 'PSBC', '/Public/index/pay/psbc.png', 0, 1523022670, 99, 0);
INSERT INTO `fx_bank` VALUES (6, '交通银行', 'BCM', '/Public/index/pay/bcm.png', 0, 1523022704, 99, 0);
INSERT INTO `fx_bank` VALUES (7, '招商银行', 'CMB', '/Public/index/pay/cmb.png', 0, 1523022725, 99, 0);
INSERT INTO `fx_bank` VALUES (8, '光大银行', 'CEB', '/Public/index/pay/ceb.png', 0, 1523022754, 99, 0);
INSERT INTO `fx_bank` VALUES (9, '兴业银行', 'CIB', '/Public/index/pay/cib.png', 0, 1523022774, 99, 0);
INSERT INTO `fx_bank` VALUES (10, '华夏银行', 'HXB', '/Public/index/pay/hxb.png', 0, 1523022794, 99, 0);
INSERT INTO `fx_bank` VALUES (11, '广发银行', 'GDB', '/Public/index/pay/gdb.png', 0, 1523022821, 99, 0);
INSERT INTO `fx_bank` VALUES (12, '浦发银行', 'SPDB', '/Public/index/pay/spdb.png', 0, 1523022841, 99, 0);
INSERT INTO `fx_bank` VALUES (13, '平安银行', 'SZPAB', '/Public/index/pay/szpab.png', 0, 1523022873, 99, 0);
INSERT INTO `fx_bank` VALUES (14, '中国民生银行', 'CMBC', '/Public/index/pay/cmbc.png', 0, 1523022923, 99, 0);

-- ----------------------------
-- Table structure for fx_daili
-- ----------------------------
DROP TABLE IF EXISTS `fx_daili`;
CREATE TABLE `fx_daili`  (
  `dlid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `dlname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代理名称',
  `money` decimal(10, 2) NOT NULL COMMENT '每日交易额',
  `fl` decimal(10, 2) NOT NULL COMMENT '代理费率 1% 这里填1',
  PRIMARY KEY (`dlid`) USING BTREE,
  UNIQUE INDEX `money`(`money`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理等级表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_dingdan
-- ----------------------------
DROP TABLE IF EXISTS `fx_dingdan`;
CREATE TABLE `fx_dingdan`  (
  `ddid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `ddstyle` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单类型 默认0普通订单 1充值',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 默认0未支付 1已支付 2扣量订单',
  `ordernum` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `ordermd5` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单16位编号',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `totalmoney` decimal(10, 2) NOT NULL COMMENT '总金额',
  `havemoney` decimal(10, 2) NOT NULL COMMENT '获得金额',
  `dailimoney` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '代理金额',
  `tz` tinyint(1) NOT NULL DEFAULT 0 COMMENT '通知 默认0未通知 1通知失败 2通知成功',
  `syflmoney` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '上游扣费',
  `preordernum` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '渠道订单',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  `zjid` int(11) NOT NULL COMMENT '配置中间表id',
  `pzid` int(11) NOT NULL DEFAULT 0 COMMENT '接口配置表id',
  `fl` decimal(10, 2) NOT NULL COMMENT '费率',
  `jkstyle` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付通道 wxwap zfbwap',
  `paytime` int(10) NOT NULL COMMENT '支付时间',
  `fj` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '附加信息',
  `truemoney` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '真实金额',
  PRIMARY KEY (`ddid`) USING BTREE,
  UNIQUE INDEX `ordernum`(`ordernum`) USING BTREE,
  INDEX `userid`(`userid`) USING BTREE,
  INDEX `jkstyle`(`jkstyle`) USING BTREE,
  INDEX `ordermd5`(`ordermd5`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_dingdan_agent
-- ----------------------------
DROP TABLE IF EXISTS `fx_dingdan_agent`;
CREATE TABLE `fx_dingdan_agent`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `ddid` int(11) NOT NULL COMMENT '订单id',
  `ddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `level` int(5) NOT NULL DEFAULT 1 COMMENT '当前级别',
  `syslevel` int(5) NOT NULL DEFAULT 1 COMMENT '系统级别',
  `agent` int(11) NOT NULL COMMENT '代理id',
  `agentmoney` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '代理金额',
  `fl` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '当前费率',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `agent`(`agent`) USING BTREE,
  INDEX `ddh`(`ddh`) USING BTREE,
  INDEX `ddid`(`ddid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理订单从表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_dingdan_notify
-- ----------------------------
DROP TABLE IF EXISTS `fx_dingdan_notify`;
CREATE TABLE `fx_dingdan_notify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `ddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `function` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口名称',
  `sendstyle` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据发送方式',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '传输数据',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `hits` int(10) NOT NULL COMMENT '发送次数',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '默认 0待补单，1已补单 2补单异常 3删除',
  `reback` int(10) NOT NULL DEFAULT 0 COMMENT '补单次数',
  `errorstr` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '补单异常信息',
  `timedata` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '临时订单',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ddh`(`ddh`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单回调表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_dingdan_pay
-- ----------------------------
DROP TABLE IF EXISTS `fx_dingdan_pay`;
CREATE TABLE `fx_dingdan_pay`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `userid` int(11) NOT NULL COMMENT '商户id',
  `http` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '来源',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数',
  `result` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '提交结果',
  `status` tinyint(1) NOT NULL COMMENT '状态 0失败 1成功',
  `fxddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `fxfee` decimal(10, 2) NOT NULL COMMENT '金额',
  `fxpay` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付方式',
  `ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '来源ip',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '支付日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_fandian
-- ----------------------------
DROP TABLE IF EXISTS `fx_fandian`;
CREATE TABLE `fx_fandian`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `totalmoney` decimal(10, 2) NOT NULL COMMENT '总金额 每日交易额',
  `fl` decimal(10, 2) NOT NULL COMMENT '代理费率 1% 这里填1',
  `havemoney` decimal(10, 2) NOT NULL COMMENT '获得金额',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 默认0未申请 1申请 2通过 3冻结',
  `userid` int(11) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代理等级表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_http
-- ----------------------------
DROP TABLE IF EXISTS `fx_http`;
CREATE TABLE `fx_http`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `httpname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网址名称',
  `http` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网址带http',
  `ifdefault` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认',
  `hiddenhttp` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '隐藏跳转地址',
  `ifdefaulthidden` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否隐藏跳转默认',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `locked` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否锁定 默认0不锁定 1锁定',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '域名表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_http
-- ----------------------------
INSERT INTO `fx_http` VALUES (1, '支付地址', 'httP://localhost.com', 1, '', 0, 1521613248, 0);

-- ----------------------------
-- Table structure for fx_jiekou
-- ----------------------------
DROP TABLE IF EXISTS `fx_jiekou`;
CREATE TABLE `fx_jiekou`  (
  `jkid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `jkname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口名称',
  `jkstyle` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口类型 字母关键字 识别接口 例如wxwap zfbwap',
  `ifround` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启轮询 默认0不开启 1开启',
  `list` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '轮询id列表及权重 数组数列化id,power',
  `ifopen` tinyint(1) NOT NULL DEFAULT 1 COMMENT '通道开关默认1开启 0关闭',
  `ifuseropen` tinyint(1) NOT NULL DEFAULT 1 COMMENT '用户默认开关 默认1开启 0关闭',
  `httpid` int(11) NOT NULL DEFAULT 0 COMMENT '轮询域名id 为0则使用默认',
  `roundhttpid` int(11) NOT NULL DEFAULT 0 COMMENT '接口轮询时使用的轮询域名id 为0则使用默认',
  PRIMARY KEY (`jkid`) USING BTREE,
  UNIQUE INDEX `jkstyle`(`jkstyle`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_jiekou
-- ----------------------------
INSERT INTO `fx_jiekou` VALUES (1, '支付宝扫码', 'alipay_scan', 1, 'a:2:{i:16;a:2:{s:6:\"ifopen\";i:1;s:5:\"power\";s:1:\"6\";}i:14;a:2:{s:6:\"ifopen\";i:1;s:5:\"power\";s:1:\"6\";}}', 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (2, '支付宝wap', 'alipay_wap', 1, 'a:2:{i:17;a:2:{s:6:\"ifopen\";i:1;s:5:\"power\";s:1:\"6\";}i:15;a:2:{s:6:\"ifopen\";i:1;s:5:\"power\";s:0:\"\";}}', 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (3, '微信扫码', 'wechat_scan', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (4, '微信H5', 'wechat_h5', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (5, '银联扫码', 'UnionPay_scan', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (6, '微信公众号', 'wechat_gzh', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (7, 'QQ钱包', 'qq_wap', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (8, 'QQ扫码', 'qq_scan', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (9, '网银网关', 'bank', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (10, '银联云闪付', 'yunshanfu', 0, NULL, 1, 1, 0, 0);
INSERT INTO `fx_jiekou` VALUES (11, '银联快捷', 'kauijie', 0, NULL, 1, 1, 0, 0);

-- ----------------------------
-- Table structure for fx_jiekou_user
-- ----------------------------
DROP TABLE IF EXISTS `fx_jiekou_user`;
CREATE TABLE `fx_jiekou_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `jkid` int(11) NOT NULL COMMENT '接口id',
  `fl` decimal(10, 2) NOT NULL COMMENT '接口费率',
  `ifopen` tinyint(1) NOT NULL DEFAULT 0 COMMENT ' 是否开启 默认0不开启 1开启',
  `pzid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '接口配置表id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userid`(`userid`) USING BTREE,
  INDEX `jkid`(`jkid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户接口中间表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_jiekou_user
-- ----------------------------
INSERT INTO `fx_jiekou_user` VALUES (1, 2019100, 1, 0.00, 1, '4');
INSERT INTO `fx_jiekou_user` VALUES (2, 2019100, 2, 0.00, 1, '4');
INSERT INTO `fx_jiekou_user` VALUES (3, 2019101, 1, 0.00, 1, '0');
INSERT INTO `fx_jiekou_user` VALUES (4, 2019101, 2, 0.00, 1, '0');
INSERT INTO `fx_jiekou_user` VALUES (5, 2019102, 1, 0.00, 1, '6');
INSERT INTO `fx_jiekou_user` VALUES (6, 2019102, 2, 0.00, 1, '6');
INSERT INTO `fx_jiekou_user` VALUES (7, 2019103, 1, 0.00, 1, '0');
INSERT INTO `fx_jiekou_user` VALUES (8, 2019103, 2, 0.00, 1, '0');
INSERT INTO `fx_jiekou_user` VALUES (9, 2019100, 3, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (10, 2019100, 4, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (11, 2019100, 5, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (12, 2019100, 6, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (13, 2019100, 7, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (14, 2019100, 8, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (15, 2019100, 9, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (16, 2019100, 10, 0.00, 0, '0');
INSERT INTO `fx_jiekou_user` VALUES (17, 2019100, 11, 0.00, 0, '0');

-- ----------------------------
-- Table structure for fx_jiekoupeizhi
-- ----------------------------
DROP TABLE IF EXISTS `fx_jiekoupeizhi`;
CREATE TABLE `fx_jiekoupeizhi`  (
  `pzid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `pzname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置名称',
  `style` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号类型 支付宝alipay wechat',
  `params` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数 序列化数据',
  `ifrepay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启代付 默认0不开启 1开启',
  `httpid` int(11) NOT NULL DEFAULT 0 COMMENT '轮询域名id 为0则使用默认',
  PRIMARY KEY (`pzid`) USING BTREE,
  UNIQUE INDEX `pzname`(`pzname`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_jiekoupeizhi
-- ----------------------------
INSERT INTO `fx_jiekoupeizhi` VALUES (1, '支付宝转卡免签模式账户2', 'card', 'a:4:{s:7:\"card_id\";s:19:\"6212261408030321354\";s:9:\"card_name\";s:9:\"杜碧云\";s:9:\"card_type\";s:23:\"中国工商银行|ICBC\";s:8:\"card_kid\";s:19:\"1905231219885650302\";}', 0, 0);
INSERT INTO `fx_jiekoupeizhi` VALUES (2, '支付宝转卡免签模式账户1', 'card', 'a:4:{s:7:\"card_id\";s:13:\"621559***4644\";s:9:\"card_name\";s:9:\"邱群英\";s:9:\"card_type\";s:23:\"中国工商银行|ICBC\";s:8:\"card_kid\";s:19:\"1905051159279409534\";}', 0, 0);
INSERT INTO `fx_jiekoupeizhi` VALUES (3, '支付宝转账免签模式账户2', 'single', 'a:2:{s:9:\"single_id\";s:16:\"2088602074264193\";s:10:\"single_key\";s:8:\"99999999\";}', 0, 0);
INSERT INTO `fx_jiekoupeizhi` VALUES (4, '支付宝转帐免签模式账户1', 'single', 'a:2:{s:9:\"single_id\";s:16:\"2088532025019513\";s:10:\"single_key\";s:6:\"888888\";}', 0, 0);

-- ----------------------------
-- Table structure for fx_jiekoustyle
-- ----------------------------
DROP TABLE IF EXISTS `fx_jiekoustyle`;
CREATE TABLE `fx_jiekoustyle`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `stylename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户类型名称',
  `en` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '英文名字',
  `params` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户参数 序列化数据',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口账户类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_jiekoustyle
-- ----------------------------
INSERT INTO `fx_jiekoustyle` VALUES (1, '支付宝转账码', 'single', 'a:2:{i:0;a:4:{s:5:\"title\";s:12:\"支付宝pid\";s:2:\"en\";s:2:\"id\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:1;a:4:{s:5:\"title\";s:12:\"监控秘钥\";s:2:\"en\";s:3:\"key\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}}', 1548256881);
INSERT INTO `fx_jiekoustyle` VALUES (2, '支付宝银行卡', 'card', 'a:4:{i:0;a:4:{s:5:\"title\";s:6:\"卡号\";s:2:\"en\";s:2:\"id\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:1;a:4:{s:5:\"title\";s:9:\"收款人\";s:2:\"en\";s:4:\"name\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:2;a:4:{s:5:\"title\";s:6:\"银行\";s:2:\"en\";s:4:\"type\";s:5:\"input\";s:6:\"select\";s:5:\"value\";s:453:\"网商银行|ANTBANK,中国工商银行|ICBC,中国农业银行|ABC,中国建设银行|CCB,招商银行|CMB,中国银行|BOC,中国邮政储蓄银行|PSBC,交通银行|COMM,中信银行|CITIC,中国民生银行|CMBC,中国光大银行|CEB,兴业银行|CIB,浦发银行|SPDB,广发银行|GDB,平安银行|SPABANK,华夏银行|HXBANK,北京银行|BJBANK,上海银行|SHBANK,江苏银行|JSBANK,北京农商行|BJRCB,江苏省农村信用社联合社|JSRCU\";}i:3;a:4:{s:5:\"title\";s:5:\"卡id\";s:2:\"en\";s:3:\"kid\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}}', 1548256917);
INSERT INTO `fx_jiekoustyle` VALUES (3, '微信', 'wechat', 'a:4:{i:0;a:4:{s:5:\"title\";s:5:\"APPID\";s:2:\"en\";s:5:\"appid\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:1;a:4:{s:5:\"title\";s:8:\"商户id\";s:2:\"en\";s:5:\"mchid\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:2;a:4:{s:5:\"title\";s:9:\"api秘钥\";s:2:\"en\";s:3:\"key\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:3;a:4:{s:5:\"title\";s:9:\"APPSECRET\";s:2:\"en\";s:9:\"appsecret\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}}', 1563860847);
INSERT INTO `fx_jiekoustyle` VALUES (4, '银联云闪付', 'yunshanfu', 'a:4:{i:0;a:4:{s:5:\"title\";s:6:\"编号\";s:2:\"en\";s:2:\"id\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:1;a:4:{s:5:\"title\";s:18:\"云闪付二维码\";s:2:\"en\";s:3:\"ewm\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:2;a:4:{s:5:\"title\";s:12:\"绑定手机\";s:2:\"en\";s:5:\"phone\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}i:3;a:4:{s:5:\"title\";s:6:\"秘钥\";s:2:\"en\";s:3:\"key\";s:5:\"input\";s:4:\"text\";s:5:\"value\";s:0:\"\";}}', 1563860948);

-- ----------------------------
-- Table structure for fx_jiekouzj
-- ----------------------------
DROP TABLE IF EXISTS `fx_jiekouzj`;
CREATE TABLE `fx_jiekouzj`  (
  `zjid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `jkid` int(11) NOT NULL COMMENT '接口id',
  `pzid` int(11) NOT NULL COMMENT '配置id',
  `fl` decimal(10, 2) NOT NULL COMMENT '接口费率',
  `ifopen` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否开启 默认1开启  0关闭',
  `changetime` int(10) NOT NULL DEFAULT 0 COMMENT '当前切换开始时间 用户自动切换的记时',
  `ifchoose` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否使用当前接口 默认0不是 1是 ，同一接口类型只能有一个是1',
  `je` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '最低支付金额 默认0不限制',
  `jemax` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '默认0不限制',
  `jetotal` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '每日限额 默认0 不限额',
  `jetoday` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '已用额度 默认0',
  `today` int(10) NOT NULL DEFAULT 0 COMMENT '当前日期',
  `ifjump` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否转入 0不跳转',
  `syfl` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '上游费率',
  `money` int(10) NULL DEFAULT 0 COMMENT '金额浮动',
  `moneytimes` int(10) NULL DEFAULT 0 COMMENT '金额时间',
  `moneyauto` tinyint(1) NULL DEFAULT 0 COMMENT '浮动方向 0上下 1小于 2大于',
  PRIMARY KEY (`zjid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口配置中间表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_jiekouzj
-- ----------------------------
INSERT INTO `fx_jiekouzj` VALUES (14, 1, 2, 3.00, 1, 1563792673, 1, 1.00, 30000.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);
INSERT INTO `fx_jiekouzj` VALUES (15, 2, 2, 3.00, 1, 1563793236, 1, 1.00, 20000.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);
INSERT INTO `fx_jiekouzj` VALUES (16, 1, 1, 2.00, 1, 0, 0, 1.00, 10000.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);
INSERT INTO `fx_jiekouzj` VALUES (17, 2, 1, 2.00, 1, 0, 0, 0.00, 10000.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);
INSERT INTO `fx_jiekouzj` VALUES (18, 1, 4, 1.00, 1, 0, 0, 0.00, 0.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);
INSERT INTO `fx_jiekouzj` VALUES (19, 2, 4, 1.00, 1, 0, 0, 0.00, 0.00, 0.00, 0.00, 0, '0', 0.00, 0, 0, 0);

-- ----------------------------
-- Table structure for fx_ka
-- ----------------------------
DROP TABLE IF EXISTS `fx_ka`;
CREATE TABLE `fx_ka`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收款人',
  `ka` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '卡号',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开户地址',
  `ifcheck` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '审核 默认0未通过 1通过',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `checktime` int(10) NOT NULL DEFAULT 0 COMMENT '审核时间',
  `zhihang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支行',
  `sheng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '省',
  `shi` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '市',
  `lhh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userid`(`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '银行卡表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_log_error
-- ----------------------------
DROP TABLE IF EXISTS `fx_log_error`;
CREATE TABLE `fx_log_error`  (
  `ErrorID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `Url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求地址',
  `Params` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求参数',
  `Description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
  `SqlContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Sql语句',
  `AddTime` int(10) NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`ErrorID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '错误日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_log_sms
-- ----------------------------
DROP TABLE IF EXISTS `fx_log_sms`;
CREATE TABLE `fx_log_sms`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '验证码',
  `addtime` int(10) NOT NULL COMMENT '时间',
  `userid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `style` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `ifcheck` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否验证过 默认0没有验证',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_money
-- ----------------------------
DROP TABLE IF EXISTS `fx_money`;
CREATE TABLE `fx_money`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `pzid` int(11) NOT NULL COMMENT '接口配置id',
  `money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `lasttime` int(10) NOT NULL DEFAULT 0 COMMENT '失效时间',
  `ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `addtime` int(10) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `zjid`(`pzid`, `money`, `lasttime`) USING BTREE,
  INDEX `ddh`(`ddh`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '金额表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_pay
-- ----------------------------
DROP TABLE IF EXISTS `fx_pay`;
CREATE TABLE `fx_pay`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `money` decimal(10, 2) UNSIGNED NOT NULL COMMENT '提现金额',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态   默认0申请提现 1已支付 2冻结 3取消',
  `realname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提现用户真实姓名',
  `ka` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '卡号',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `ddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `daifustatus` tinyint(1) NULL DEFAULT 0 COMMENT '代付状态 0未提交 1已提交 2失败 3成功',
  `zhihang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支行',
  `sheng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '省',
  `shi` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '市',
  `lhh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
  `dffl` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '手续费',
  `tz` tinyint(1) NOT NULL DEFAULT 0 COMMENT '异步通知状态 默认0未通知，1通知失败 2通知成功 ，仅当订单成功或失败时才触发通知',
  `notifyurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '代付异步通知地址',
  `fj` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '存储序列化数据',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ddh`(`ddh`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '支付表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_pay_dingdan
-- ----------------------------
DROP TABLE IF EXISTS `fx_pay_dingdan`;
CREATE TABLE `fx_pay_dingdan`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `payid` int(11) NOT NULL COMMENT 'pay表id',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0发起支付 1支付成功 2支付失败',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  `ddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
  `pzid` int(10) NOT NULL COMMENT '账号配置表id',
  `paybank` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付银行',
  `outddh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '远端订单号',
  `outdesc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '远端说明',
  `paytime` int(10) NOT NULL DEFAULT 0 COMMENT '代付时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ddh`(`ddh`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代付记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_pay_log
-- ----------------------------
DROP TABLE IF EXISTS `fx_pay_log`;
CREATE TABLE `fx_pay_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `userid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `leavemoney` decimal(10, 2) UNSIGNED NULL DEFAULT NULL COMMENT '剩余金额',
  `changemoney` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动金额',
  `addtime` int(10) NULL DEFAULT NULL COMMENT '添加时间',
  `desc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `style` tinyint(1) NULL DEFAULT 0 COMMENT '类型 1充值 2提现 3代理佣金',
  `ddh` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '订单号 唯一标识',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ddh`(`ddh`) USING BTREE,
  INDEX `userddh`(`userid`, `style`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资金变动表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_peizhi
-- ----------------------------
DROP TABLE IF EXISTS `fx_peizhi`;
CREATE TABLE `fx_peizhi`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `sitename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站名称',
  `closeweb` tinyint(1) NOT NULL DEFAULT 0 COMMENT '关闭网站 默认0不关闭  1关闭',
  `bindIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `klvalue` int(11) NOT NULL COMMENT '扣量初始值',
  `klzijian` int(11) NOT NULL COMMENT '扣量自减值',
  `klinitmoney` decimal(10, 2) NOT NULL COMMENT '起扣金额',
  `ifkl` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否扣量 默认0不扣 1扣',
  `ifregcheck` tinyint(1) NOT NULL DEFAULT 0 COMMENT '注册审核 默认0不审核  1审核',
  `ifcheckka` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否审核提现账户 0不审核 1审核',
  `minpay` int(11) NOT NULL DEFAULT 100 COMMENT '最小提现金额 默认100',
  `xieyi` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `baozhengjin` decimal(10, 2) NOT NULL COMMENT '保证金',
  `bzjuserid` int(11) NOT NULL COMMENT '保证金收款用户id',
  `changeapitime` int(10) NOT NULL DEFAULT 0 COMMENT '单位分钟 api接口切换时间 默认0不切换',
  `ifagent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '开启代理 默认0开启 1不开启',
  `notice` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公告',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话',
  `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'qq',
  `beian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站备案号',
  `balancestyle` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结算周期类型T或D',
  `balancetime` int(11) NOT NULL COMMENT '结算周期间隔',
  `paytest` decimal(10, 2) NOT NULL DEFAULT 1.00 COMMENT '支付体验默认金额',
  `minrecharge` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '最小充值金额',
  `ddhlength` int(10) NOT NULL DEFAULT 22 COMMENT '订单号长度',
  `ifpaylog` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付日志开启 默认0不开启 1开启',
  `ifnotifylog` tinyint(1) NOT NULL DEFAULT 0 COMMENT '回调日志开启  默认0不开启 1开启',
  `dffl` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '代付费率 单笔或比例',
  `iffl` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否使用费率 默认0使用单笔 1使用费率',
  `logopath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'logo路径',
  `httpstyle` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'http' COMMENT 'http类型 默认http',
  `ifopenuserhttp` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启商户域名审核 默认0不开启 1开启',
  `txpaytime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '提现时间段 格式6:00-14:00',
  `ifdlmoney` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有代理收益 默认0有 1没有',
  `ifdaifuauto` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启代付 默认0不开启 1开启',
  `daifuid` int(11) NOT NULL DEFAULT 0 COMMENT '代付id',
  `daifubank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '代付银行',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_peizhi
-- ----------------------------
INSERT INTO `fx_peizhi` VALUES (1, 'FXpay', 0, '', 10, 10, 10.00, 0, 1, 0, 1, 'error', 0.00, 2019100, 0, 0, '测试服务器:\r\n本系统可以作为独立四方支付系统使用，对接其它通道，也可以用支付宝免签自己做通道，欢迎大家学习交流', 'QQ:3261634304', '3261634304', '', 'D', 0, 1.00, 1.00, 22, 1, 1, 5.00, 0, '/Public/index/night/logo.png', 'http', 1, '00:00-24:00', 0, 0, 0, '');

-- ----------------------------
-- Table structure for fx_power_admin
-- ----------------------------
DROP TABLE IF EXISTS `fx_power_admin`;
CREATE TABLE `fx_power_admin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `powername` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `listid` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ifdefault` tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `powername`(`powername`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_power_admin
-- ----------------------------
INSERT INTO `fx_power_admin` VALUES (1, '超级管理员', 'all', 0);

-- ----------------------------
-- Table structure for fx_power_admin_list
-- ----------------------------
DROP TABLE IF EXISTS `fx_power_admin_list`;
CREATE TABLE `fx_power_admin_list`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `powername` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `powertag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标记',
  `orderid` int(10) NULL DEFAULT 99 COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `powername`(`powername`, `powertag`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 114 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_power_admin_list
-- ----------------------------
INSERT INTO `fx_power_admin_list` VALUES (1, '查看参数配置', 'Param/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (2, '保存参数配置', 'Param/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (3, '查看权限管理', 'Powerlist/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (4, '添加权限管理', 'Powerlist/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (5, '编辑权限管理', 'Powerlist/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (6, '保存权限管理', 'Powerlist/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (7, '查看管理组管理', 'Power/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (8, '添加管理组管理', 'Power/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (9, '编辑管理组管理', 'Power/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (10, '保存管理组管理', 'Power/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (11, '查看管理员管理', 'Admin/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (12, '添加管理员管理', 'Admin/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (13, '编辑管理员管理', 'Admin/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (14, '保存管理员管理', 'Admin/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (15, '删除权限管理', 'Powerlist/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (16, '删除管理组', 'Power/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (17, '删除管理员', 'Admin/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (18, '查看系统日志', 'Log/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (26, '删除系统日志', 'Log/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (27, '查看接口域名', 'Http/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (28, '添加接口域名', 'Http/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (29, '编辑接口域名', 'Http/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (30, '保存接口域名', 'Http/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (31, '删除接口域名', 'Http/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (32, '查看接口类型', 'Api/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (33, '添加接口类型', 'Api/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (34, '编辑接口类型', 'Api/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (35, '保存接口类型', 'Api/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (36, '删除接口类型', 'Api/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (37, '配置接口轮询', 'Api/round', 99);
INSERT INTO `fx_power_admin_list` VALUES (38, '查看上游类型', 'Apistyle/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (39, '添加上游类型', 'Apistyle/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (40, '编辑上游类型', 'Apistyle/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (41, '保存上游类型', 'Apistyle/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (42, '删除上游类型', 'Apistyle/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (43, '查看接口账户', 'Api/user', 99);
INSERT INTO `fx_power_admin_list` VALUES (44, '添加接口账户', 'Api/adduser', 99);
INSERT INTO `fx_power_admin_list` VALUES (45, '编辑接口账户', 'Api/edituser', 99);
INSERT INTO `fx_power_admin_list` VALUES (46, '保存接口账户', 'Api/saveuser', 99);
INSERT INTO `fx_power_admin_list` VALUES (47, '删除接口账户', 'Api/deleteuser', 99);
INSERT INTO `fx_power_admin_list` VALUES (48, '查看接口检测', 'Api/check', 99);
INSERT INTO `fx_power_admin_list` VALUES (49, '接口检测页开关', 'Api/userchangeopen', 99);
INSERT INTO `fx_power_admin_list` VALUES (50, '接口应用', 'Api/userchangechoose', 99);
INSERT INTO `fx_power_admin_list` VALUES (51, '查看银行', 'Bank/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (52, '添加银行', 'Bank/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (53, '编辑银行', 'Bank/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (54, '保存银行', 'Bank/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (55, '删除银行', 'Bank/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (56, '查看代理等级', 'Agent/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (57, '添加代理等级', 'Agent/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (58, '编辑代理等级', 'Agent/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (59, '保存代理等级', 'Agent/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (60, '删除代理等级', 'Agent/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (61, '查询成功订单', 'Dingdan/success', 99);
INSERT INTO `fx_power_admin_list` VALUES (62, '查询扣量订单', 'Dingdan/kou', 99);
INSERT INTO `fx_power_admin_list` VALUES (63, '查询未支付订单', 'Dingdan/wei', 99);
INSERT INTO `fx_power_admin_list` VALUES (64, '批量补单', 'Dingdan/editall', 99);
INSERT INTO `fx_power_admin_list` VALUES (65, '查看补单/撤单/通知', 'Dingdan/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (66, '提交补单/撤单/通知', 'Dingdan/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (67, '跳过补单', 'Dingdan/savezt', 99);
INSERT INTO `fx_power_admin_list` VALUES (68, '删除订单', 'Dingdan/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (69, '查看对账记录', 'Dingdan/dingdancheck', 99);
INSERT INTO `fx_power_admin_list` VALUES (70, '接口日志列表', 'Dingdan/pay', 99);
INSERT INTO `fx_power_admin_list` VALUES (71, '接口日志详情', 'Dingdan/payedit', 99);
INSERT INTO `fx_power_admin_list` VALUES (72, '删除接口日志', 'Dingdan/paydelete', 99);
INSERT INTO `fx_power_admin_list` VALUES (73, '异步日志列表', 'Dingdan/notify', 99);
INSERT INTO `fx_power_admin_list` VALUES (74, '异步日志补单', 'Dingdan/notifyedit', 99);
INSERT INTO `fx_power_admin_list` VALUES (75, '删除异步日志', 'Dingdan/notifydelete', 99);
INSERT INTO `fx_power_admin_list` VALUES (76, '未支付账单', 'Pay/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (77, '已支付账单', 'Pay/yzf', 99);
INSERT INTO `fx_power_admin_list` VALUES (78, '代付异步重发', 'Pay/dingdancf', 99);
INSERT INTO `fx_power_admin_list` VALUES (79, '删除代付提交订单', 'Pay/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (80, '改变支付账单状态', 'Pay/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (81, '订单详情（代付）', 'Pay/dingdan', 99);
INSERT INTO `fx_power_admin_list` VALUES (82, '代付获取银行', 'Pay/dingdanbank', 99);
INSERT INTO `fx_power_admin_list` VALUES (83, '代付提交', 'Pay/dingdansave', 99);
INSERT INTO `fx_power_admin_list` VALUES (84, '代付查询订单', 'Pay/dingdanselect', 99);
INSERT INTO `fx_power_admin_list` VALUES (85, '代付订单列表', 'Pay/dingdanall', 99);
INSERT INTO `fx_power_admin_list` VALUES (86, '查看资金变动', 'Pay/moneylog', 99);
INSERT INTO `fx_power_admin_list` VALUES (87, '删除资金变动', 'Pay/moneylogdelete', 99);
INSERT INTO `fx_power_admin_list` VALUES (88, '查看代理账单', 'Agent/fandian', 99);
INSERT INTO `fx_power_admin_list` VALUES (89, '更改代理账单状态', 'Agent/status', 99);
INSERT INTO `fx_power_admin_list` VALUES (90, '查看用户列表', 'User/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (91, '添加用户', 'User/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (92, '编辑用户', 'User/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (93, '保存用户', 'User/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (94, '删除用户', 'User/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (95, '用户费率', 'User/fl', 99);
INSERT INTO `fx_power_admin_list` VALUES (96, '用户结算', 'User/sendmoney', 99);
INSERT INTO `fx_power_admin_list` VALUES (97, '用户认证', 'User/info', 99);
INSERT INTO `fx_power_admin_list` VALUES (98, '查看域名审核', 'Userhttp/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (99, '添加域名审核', 'Userhttp/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (100, '编辑域名审核', 'Userhttp/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (101, '保存域名审核', 'Userhttp/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (102, '删除域名审核', 'Userhttp/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (103, '查看扣量列表', 'Kou/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (104, '添加扣量列表', 'Kou/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (105, '编辑扣量列表', 'Kou/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (106, '保存扣量列表', 'Kou/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (107, '删除扣量列表', 'Kou/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (108, '查看银行卡', 'Ka/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (109, '添加银行卡', 'Ka/add', 99);
INSERT INTO `fx_power_admin_list` VALUES (110, '编辑银行卡', 'Ka/edit', 99);
INSERT INTO `fx_power_admin_list` VALUES (111, '保存银行卡', 'Ka/save', 99);
INSERT INTO `fx_power_admin_list` VALUES (112, '删除银行卡', 'Ka/delete', 99);
INSERT INTO `fx_power_admin_list` VALUES (113, '通道统计', 'Tj/index', 99);
INSERT INTO `fx_power_admin_list` VALUES (114, '查询所有订单', 'Dingdan/index', 99);

-- ----------------------------
-- Table structure for fx_rizhi
-- ----------------------------
DROP TABLE IF EXISTS `fx_rizhi`;
CREATE TABLE `fx_rizhi`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块名称',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `addtime` int(11) NOT NULL COMMENT '添加时间',
  `ifadmin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是管理员 默认0不是 1是',
  `userid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ip',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `module`(`module`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_rizhi
-- ----------------------------
INSERT INTO `fx_rizhi` VALUES (1, '管理员登录', '管理员【admin】登录系统', 1573897394, 1, '0', '114.94.173.29');
INSERT INTO `fx_rizhi` VALUES (2, '用户登录', '用户【myaccount】登录系统', 1575555245, 0, '2019100', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (3, '管理员登录', '管理员【admin】登录系统', 1575556358, 1, 'myaccount', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (4, '用户登录', '用户【myaccount】登录系统', 1575612816, 0, '2019100', '58.247.83.94');
INSERT INTO `fx_rizhi` VALUES (5, '用户登录', '用户【myaccount】登录系统', 1575612963, 0, '2019100', '58.247.83.94');
INSERT INTO `fx_rizhi` VALUES (6, '管理员登录', '管理员【admin】登录系统', 1575613124, 1, 'myaccount', '58.247.83.94');
INSERT INTO `fx_rizhi` VALUES (7, '管理员登录', '管理员【admin】登录系统', 1575617094, 1, 'admin', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (8, '用户登录', '用户【myaccount】登录系统', 1575617152, 0, '2019100', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (9, '管理员登录', '管理员【admin】登录系统', 1575617205, 1, 'myaccount', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (10, '参数', '修改配置参数数据', 1575617258, 1, 'admin', '124.78.138.147');
INSERT INTO `fx_rizhi` VALUES (11, '用户登录', '用户【myaccount】登录系统', 1575688807, 0, '2019100', '180.152.126.136');
INSERT INTO `fx_rizhi` VALUES (12, '管理员登录', '管理员【admin】登录系统', 1575688856, 1, '0', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (13, '用户登录', '用户【myaccount】登录系统', 1575688859, 0, '2019100', '180.152.126.136');
INSERT INTO `fx_rizhi` VALUES (14, '用户登录', '用户【myaccount】登录系统', 1575688920, 0, '2019100', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (15, '管理员登录', '管理员【admin】登录系统', 1575690560, 1, '0', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (16, '用户登录', '用户【myaccount】登录系统', 1575690575, 0, '2019100', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (17, '管理员登录', '管理员【admin】登录系统', 1575692048, 1, 'myaccount', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (18, '用户登录', '用户【myaccount】登录系统', 1575716801, 0, '2019100', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (19, '管理员登录', '管理员【admin】登录系统', 1575717028, 1, 'myaccount', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (20, '用户登录', '用户【myaccount】登录系统', 1575717492, 0, '2019100', '159.138.241.234');
INSERT INTO `fx_rizhi` VALUES (21, '用户登录', '用户【myaccount】登录系统', 1575945501, 0, '2019100', '45.33.106.126');
INSERT INTO `fx_rizhi` VALUES (22, '管理员登录', '管理员【admin】登录系统', 1575949344, 1, '0', '45.79.106.194');
INSERT INTO `fx_rizhi` VALUES (23, '用户登录', '用户【myaccount】登录系统', 1575949532, 0, '2019100', '45.79.106.194');
INSERT INTO `fx_rizhi` VALUES (24, '管理员登录', '管理员【admin】登录系统', 1575951940, 1, 'myaccount', '45.79.106.194');
INSERT INTO `fx_rizhi` VALUES (25, '管理员登录', '管理员【admin】登录系统', 1576047554, 1, '0', '219.133.177.191');
INSERT INTO `fx_rizhi` VALUES (26, '管理员登录', '管理员【admin】登录系统', 1576048162, 1, '0', '121.34.51.75');
INSERT INTO `fx_rizhi` VALUES (27, '管理员登录', '管理员【admin】登录系统', 1576050767, 1, 'admin', '121.34.51.75');

-- ----------------------------
-- Table structure for fx_url
-- ----------------------------
DROP TABLE IF EXISTS `fx_url`;
CREATE TABLE `fx_url`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `md` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单识别号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `md`(`md`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_user
-- ----------------------------
DROP TABLE IF EXISTS `fx_user`;
CREATE TABLE `fx_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账户',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
  `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'qq号',
  `tx` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '提现金额',
  `money` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '账户余额',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 默认0正常  1锁定',
  `miyao` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '秘钥',
  `savecode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '安全码',
  `lastip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '最后一次登录ip',
  `logintimes` int(11) NOT NULL DEFAULT 0 COMMENT '登录次数',
  `addtime` int(10) NOT NULL COMMENT '注册时间',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
  `txpassword` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '提现密码',
  `ifagent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是代理 默认0 不是 1是',
  `agent` int(11) NULL DEFAULT NULL COMMENT '代理id',
  `ifdlmoney` tinyint(1) NOT NULL DEFAULT -1 COMMENT '是否有代理收益 默认-1 按照系统配置 0开启 1关闭',
  `regmoney` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '注册金',
  `dffl` decimal(10, 2) NOT NULL DEFAULT -1.00 COMMENT '代付费率 单笔或比例',
  `iffl` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否使用费率 默认0使用单笔 1使用费率',
  `httpid` int(11) NOT NULL DEFAULT 0 COMMENT '轮询域名id 为0则使用默认',
  `ifopenuserhttp` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否审核用户域名 默认0审核 1不审核',
  `ifcheckphone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否验证手机号 默认0未验证 1已验证',
  `ifusercheck` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商户认证表 默认0未认证 1申请认证 2认证通过 3认证失败',
  `balancestyle` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '默认0 可为D或T',
  `balancetime` int(5) NOT NULL DEFAULT 0 COMMENT '默认0 数字0-7',
  `ifkl` tinyint(1) NOT NULL DEFAULT -1 COMMENT '是否扣量默认-1 按照系统配置 0不扣量 1扣量',
  `ifagentopenuser` tinyint(1) NOT NULL DEFAULT -1 COMMENT '允许代理开商户号 默认-1按照系统配置 0关闭 1开启',
  `ifdaifuauto` tinyint(1) NOT NULL DEFAULT -1 COMMENT '自动代付 默认-1按照系统配置 0关闭 1开启',
  `daifuid` int(11) NOT NULL DEFAULT 0 COMMENT '代付配置id',
  `daifubank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '代付银行',
  `frozenmoney` decimal(10, 2) NOT NULL DEFAULT 0.00,
  `google_secret` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `bindIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `userid`(`userid`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fx_user
-- ----------------------------
INSERT INTO `fx_user` VALUES (1, 2019100, 'myaccount', '94f19819f76d6e548205233005f592c1', '', 0.00, 22.85, 0, 'qspwhAlieoKvFLbUtrZJxQblBtDSdmMf', 'jgVyDP', '45.79.106.194', 17, 1555470349, '', '', 'edcdef724d41bc249370a2fb2d84def8', 0, 0, -1, 0.00, -1.00, 0, 0, 0, 0, 0, '0', 0, -1, -1, 0, 0, '', 1.00, NULL, '');

-- ----------------------------
-- Table structure for fx_user_http
-- ----------------------------
DROP TABLE IF EXISTS `fx_user_http`;
CREATE TABLE `fx_user_http`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `sitename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站名称',
  `sitestyle` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网站类型',
  `beian` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备案',
  `siteadmin` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员',
  `sitephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `siteqq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'qq',
  `http` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网址',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `checktime` int(10) NOT NULL DEFAULT 0 COMMENT '审核时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 默认0待审核 1审核通过 2审核失败',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userid`(`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户域名表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_usercheck
-- ----------------------------
DROP TABLE IF EXISTS `fx_usercheck`;
CREATE TABLE `fx_usercheck`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户userid',
  `myname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公司或个人名称',
  `myid` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公司编号或个人身份证号',
  `phone` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `photos` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '验证图片集合',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 默认0待审核 1审核通过 2审核失败',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `checktime` int(10) NOT NULL DEFAULT 0 COMMENT '审核时间',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通讯地址',
  `editionname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
  `editionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司编号',
  `checkstyle` tinyint(1) NOT NULL DEFAULT 0 COMMENT '验证类型 默认0个人 1公司',
  `msg` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核说明',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `userid`(`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户资质表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for fx_zijian
-- ----------------------------
DROP TABLE IF EXISTS `fx_zijian`;
CREATE TABLE `fx_zijian`  (
  `zjid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `userid` int(11) NOT NULL COMMENT '用户id',
  `zijian` int(11) NOT NULL DEFAULT 10 COMMENT '自减值',
  `initval` int(11) NOT NULL DEFAULT 10 COMMENT '初始值',
  PRIMARY KEY (`zjid`) USING BTREE,
  UNIQUE INDEX `userid`(`userid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户扣量自减表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;