agent_server/storage/sql/full/agent_full_20220101_01.sql

/*
 Navicat Premium Data Transfer

 Source Server         : local_mysql8
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : mysql:3306
 Source Schema         : sg_agent_tmp

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

 Date: 01/01/2022 23:15:26
*/

-- ----------------------------
-- Table structure for ag_agent
-- ----------------------------
DROP TABLE IF EXISTS `ag_agent`;
CREATE TABLE `ag_agent` (
                            `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                            `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'UID',
                            `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名,全小写化',
                            `nick` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
                            `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码，经过md5加密',
                            `salt` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '盐',
                            `otp_secret` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'otp密码',
                            `created_at` datetime DEFAULT NULL,
                            `updated_at` datetime DEFAULT NULL,
                            `agent_level` smallint NOT NULL DEFAULT '-999' COMMENT '代理级别，顶级是1，-999无任何代理',
                            `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额，单位元',
                            `note` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
                            `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=开放；2=冻结',
                            `frozen` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '冻结金额，单位元',
                            `withdraw_pwd` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提现密码，明文',
                            `parent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '父级UID',
                            `own_app_uids` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '拥有的APP UID结合，多个半角逗号分隔开',
                            `parent_uids` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '父级UID集合，多个半角逗号分割开',
                            `child_uids` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '子级UID集合，多个半角逗号分隔开',
                            `commission_ratio` smallint unsigned NOT NULL DEFAULT '0' COMMENT '分成比例，单位%',
                            `commission_diff_ratio` smallint unsigned NOT NULL DEFAULT '0' COMMENT '本代理上级计算分成比例，单位%',
                            `jdata` json DEFAULT NULL COMMENT 'json数据，包含各种规则，不单独占用root节点',
                            `last_login_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '上次登陆IP',
                            `last_login_at` datetime DEFAULT NULL COMMENT '上次登陆时间',
                            `deduction_switch` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '扣量开关：0=关闭; 1=开启',
                            PRIMARY KEY (`id`) USING BTREE,
                            UNIQUE KEY `UNQ_uid` (`uid`) USING BTREE,
                            UNIQUE KEY `UNQ_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3667 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代理用户';

-- ----------------------------
-- Table structure for ag_agent_attrs
-- ----------------------------
DROP TABLE IF EXISTS `ag_agent_attrs`;
CREATE TABLE `ag_agent_attrs` (
                                  `id` int unsigned NOT NULL AUTO_INCREMENT,
                                  `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '关联管理员uid',
                                  `created_at` datetime DEFAULT NULL,
                                  `updated_at` datetime DEFAULT NULL,
                                  `order_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计订单数',
                                  `order_success` int unsigned NOT NULL DEFAULT '0' COMMENT '累计成功订单数',
                                  `order_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '累计失败订单数',
                                  `order_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计订单金额',
                                  `order_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计成功金额',
                                  `dau_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计日活',
                                  `dau_android` int unsigned NOT NULL DEFAULT '0' COMMENT '累计android日活',
                                  `dau_ios` int unsigned NOT NULL DEFAULT '0' COMMENT '累加ios日活',
                                  `dau_h5` int unsigned NOT NULL DEFAULT '0' COMMENT '累加h5日活',
                                  `android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计android订单数',
                                  `android_success` int unsigned NOT NULL DEFAULT '0' COMMENT '累计android成功订单数',
                                  `android_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '累计android失败订单数',
                                  `android_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计android总金额',
                                  `android_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计android成功订单金额',
                                  `ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计ios订单数',
                                  `ios_success` int unsigned NOT NULL DEFAULT '0' COMMENT '累计ios成功订单数',
                                  `ios_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '累计ios失败订单数',
                                  `ios_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计ios总金额',
                                  `ios_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计ios成功订单金额',
                                  `h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计h5订单数',
                                  `h5_success` int unsigned NOT NULL DEFAULT '0' COMMENT '累计h5成功订单数',
                                  `h5_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '累计h5失败订单数',
                                  `h5_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计h5总金额',
                                  `h5_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计h5成功订单金额',
                                  `deduction_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计渠道扣量后的总订单数',
                                  `deduction_success` int unsigned NOT NULL DEFAULT '0' COMMENT '累计渠道扣量后的成功订单数',
                                  `deduction_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '累计渠道扣量后的失败单数',
                                  `deduction_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计渠道扣量后的总金额',
                                  `deduction_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计渠道扣量后的成功金额',
                                  `commission_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计代理提成金额',
                                  `withdraw_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '累计提现金额',
                                  `users_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计用户数量',
                                  `users_android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计android用户数量',
                                  `users_ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计ios用户数量',
                                  `users_h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '累计h5用户数量',
                                  `users_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '累计扣量用户数量',
                                  `users_android_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '累计扣量android用户数量',
                                  `users_ios_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '累计扣量ios用户数量',
                                  `users_h5_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '累计扣量h5用户数量',
                                  `td_date` date DEFAULT NULL COMMENT '今日日期Y-m-d',
                                  `td_order_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日订单数',
                                  `td_order_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日成功订单数',
                                  `td_order_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日失败订单数',
                                  `td_order_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日订单金额',
                                  `td_order_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日成功金额',
                                  `td_dau_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日日活',
                                  `td_dau_android` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android日活',
                                  `td_dau_ios` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios日活',
                                  `td_dau_h5` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5日活',
                                  `td_android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android订单数',
                                  `td_android_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android成功订单数',
                                  `td_android_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android失败订单数',
                                  `td_android_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日android总金额',
                                  `td_android_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日android成功订单金额',
                                  `td_ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios订单数',
                                  `td_ios_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios成功订单数',
                                  `td_ios_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios失败订单数',
                                  `td_ios_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日ios总金额',
                                  `td_ios_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日ios成功订单金额',
                                  `td_h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5订单数',
                                  `td_h5_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5成功订单数',
                                  `td_h5_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5失败订单数',
                                  `td_h5_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日h5总金额',
                                  `td_h5_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日h5成功订单金额',
                                  `td_deduction_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的总订单数',
                                  `td_deduction_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的成功订单数',
                                  `td_deduction_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的失败单数',
                                  `td_deduction_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日渠道扣量后的总金额',
                                  `td_deduction_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日渠道扣量后的成功金额',
                                  `td_commission_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日代理提成金额',
                                  `td_users_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日用户数量',
                                  `td_users_android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android用户数量',
                                  `td_users_ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios用户数量',
                                  `td_users_h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5用户数量',
                                  `td_users_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量用户数量',
                                  `td_users_android_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量android用户数量',
                                  `td_users_ios_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量ios用户数量',
                                  `td_users_h5_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量h5用户数量',
                                  PRIMARY KEY (`id`) USING BTREE,
                                  UNIQUE KEY `UNQ_uid` (`agent_uid`) USING BTREE COMMENT '唯一UID',
                                  KEY `INDX_TODAY` (`agent_uid`,`td_date`) USING BTREE COMMENT '某人今天的数据'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代理扩展属性';


-- ----------------------------
-- Table structure for ag_agent_attrs_day
-- ----------------------------
DROP TABLE IF EXISTS `ag_agent_attrs_day`;
CREATE TABLE `ag_agent_attrs_day` (
                                      `id` int unsigned NOT NULL AUTO_INCREMENT,
                                      `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '关联管理员uid',
                                      `created_at` datetime DEFAULT NULL,
                                      `updated_at` datetime DEFAULT NULL,
                                      `is_used` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否被每日计划任务使用过',
                                      `td_date` date DEFAULT NULL COMMENT '今日日期Y-m-d',
                                      `td_order_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日订单数',
                                      `td_order_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日成功订单数',
                                      `td_order_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日失败订单数',
                                      `td_order_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日订单金额',
                                      `td_order_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日成功金额',
                                      `td_dau_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日日活',
                                      `td_dau_android` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android日活',
                                      `td_dau_ios` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios日活',
                                      `td_dau_h5` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5日活',
                                      `td_android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android订单数',
                                      `td_android_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android成功订单数',
                                      `td_android_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android失败订单数',
                                      `td_android_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日android总金额',
                                      `td_android_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日android成功订单金额',
                                      `td_ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios订单数',
                                      `td_ios_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios成功订单数',
                                      `td_ios_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios失败订单数',
                                      `td_ios_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日ios总金额',
                                      `td_ios_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日ios成功订单金额',
                                      `td_h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5订单数',
                                      `td_h5_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5成功订单数',
                                      `td_h5_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5失败订单数',
                                      `td_h5_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日h5总金额',
                                      `td_h5_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日h5成功订单金额',
                                      `td_deduction_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的总订单数',
                                      `td_deduction_success` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的成功订单数',
                                      `td_deduction_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '今日渠道扣量后的失败单数',
                                      `td_deduction_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日渠道扣量后的总金额',
                                      `td_deduction_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日渠道扣量后的成功金额',
                                      `td_commission_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '今日代理提成金额',
                                      `td_users_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日用户数量',
                                      `td_users_android_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日android用户数量',
                                      `td_users_ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日ios用户数量',
                                      `td_users_h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT '今日h5用户数量',
                                      `td_users_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量用户数量',
                                      `td_users_android_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量android用户数量',
                                      `td_users_ios_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量ios用户数量',
                                      `td_users_h5_deduction` int unsigned NOT NULL DEFAULT '0' COMMENT '今日扣量h5用户数量',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `INDX_TODAY` (`agent_uid`,`td_date`) USING BTREE COMMENT '某人今天的数据'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代理扩展属性每日日志';


-- ----------------------------
-- Table structure for ag_agent_bank_info
-- ----------------------------
DROP TABLE IF EXISTS `ag_agent_bank_info`;
CREATE TABLE `ag_agent_bank_info` (
                                      `id` int unsigned NOT NULL AUTO_INCREMENT,
                                      `created_at` datetime DEFAULT NULL,
                                      `updated_at` datetime DEFAULT NULL,
                                      `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'hash唯一ID',
                                      `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '代理uid',
                                      `bank_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '卡号',
                                      `bank_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '持卡人姓名',
                                      `bank_mark` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '开户行',
                                      `type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1银行卡;2USTD;3支付宝',
                                      `ustd_network` char(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充币网络',
                                      `ustd_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充币地址',
                                      `alipay_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝账号',
                                      `alipay_username` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝姓名',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      UNIQUE KEY `uid` (`uid`) USING BTREE,
                                      KEY `user_bank_info_uid` (`uid`) USING BTREE COMMENT '替代自增ID，查询'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户提现绑定信息';


-- ----------------------------
-- Table structure for ag_agent_log
-- ----------------------------
DROP TABLE IF EXISTS `ag_agent_log`;
CREATE TABLE `ag_agent_log` (
                                `id` int unsigned NOT NULL AUTO_INCREMENT,
                                `created_at` datetime DEFAULT NULL,
                                `updated_at` datetime DEFAULT NULL,
                                `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '代理UID',
                                `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
                                `nick` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
                                `subject` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主题',
                                `module` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模块',
                                `action` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '动作',
                                `svalue` varchar(3600) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '关联操作值',
                                `db_data` json DEFAULT NULL COMMENT '前后数据对比',
                                `ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ipv4',
                                `ip_address` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ip地址解析名称',
                                `ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                                PRIMARY KEY (`id`) USING BTREE,
                                KEY `INDX_username` (`username`) USING BTREE,
                                KEY `INDX_module_action` (`module`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代理人员操作日志';

-- ----------------------------
-- Records of ag_agent_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_announce
-- ----------------------------
DROP TABLE IF EXISTS `ag_announce`;
CREATE TABLE `ag_announce` (
                               `id` int unsigned NOT NULL AUTO_INCREMENT,
                               `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '唯一UID',
                               `created_at` datetime DEFAULT NULL,
                               `updated_at` datetime DEFAULT NULL,
                               `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                               `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态,1=开放;2=隐藏',
                               `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '正文内容',
                               `type` smallint unsigned NOT NULL DEFAULT '1' COMMENT '类型,1=代理首页;2=提现',
                               PRIMARY KEY (`id`) USING BTREE,
                               UNIQUE KEY `UNQ_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站内公告';

-- ----------------------------
-- Records of ag_announce
-- ----------------------------

INSERT INTO `ag_announce` VALUES (1, '1', NULL, '2021-12-27 18:57:26', '提现公告', 1, '提现内容！@！#232\n请注意坐姿，否则会得肩周炎！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！', 2);
INSERT INTO `ag_announce` VALUES (2, '2', NULL, '2021-12-21 23:20:11', '代理中心首页广告', 1, '1.这里好好玩  这里是代理中心首页广告哦\n2.这个公告没有格式的吗', 1);
INSERT INTO `ag_announce` VALUES (3, 'yq2nqr', '2021-12-22 03:31:43', '2021-12-22 03:32:54', '代理公告2', 2, '代理公告2', 1);


-- ----------------------------
-- Table structure for ag_app
-- ----------------------------
DROP TABLE IF EXISTS `ag_app`;
CREATE TABLE `ag_app` (
                          `id` int unsigned NOT NULL AUTO_INCREMENT,
                          `uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'UID',
                          `name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名称',
                          `android_url` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'android下载地址、',
                          `ios_url` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ios下载地址',
                          `android_version` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'android版本',
                          `ios_version` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ios版本',
                          `android_enable` tinyint unsigned NOT NULL DEFAULT '1' COMMENT 'android是否启用,1=启用;0=禁用',
                          `ios_enable` tinyint unsigned NOT NULL DEFAULT '1' COMMENT 'ios是否启用，1=启用;0=禁用',
                          `squad` int NOT NULL DEFAULT '1000' COMMENT '排序，降序',
                          `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态,1=开放;2=隐藏',
                          `icon_url` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标icon',
                          `created_at` datetime DEFAULT NULL,
                          `updated_at` datetime DEFAULT NULL,
                          PRIMARY KEY (`id`) USING BTREE,
                          UNIQUE KEY `UNX_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='应用';

INSERT INTO `ag_app` VALUES (1, 'ObNRb5', '抖窥', 'https://www.google.com', '', '1.0.0', '1.0.0', 0, 0, 1000, 2, '//test-chituma.oss-cn-hangzhou.aliyuncs.com/files/local/535534/AI1zQW5O.png', '2022-01-02 03:49:56', '2022-01-02 03:49:56');

-- ----------------------------
-- Table structure for ag_app_deduction_rule
-- ----------------------------
DROP TABLE IF EXISTS `ag_app_deduction_rule`;
CREATE TABLE `ag_app_deduction_rule` (
                                         `id` int unsigned NOT NULL AUTO_INCREMENT,
                                         `deduction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '扣量类型:cps,cpa',
                                         `deduction_rule` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '扣量规则:1=订单扣量;2=价格扣量',
                                         `app_uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'app_uid',
                                         `deduction_price` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '扣量价格',
                                         `deduction_pro` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '扣量比例',
                                         `uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                                         `deduction_method` tinyint unsigned DEFAULT '0' COMMENT '扣量方式:1=首单扣量\n\n;2=回充扣量',
                                         `jdata` json DEFAULT NULL COMMENT 'cps扣量规则',
                                         `created_at` datetime DEFAULT NULL,
                                         `updated_at` datetime DEFAULT NULL,
                                         PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='扣量总规则表';

-- ----------------------------
-- Records of ag_app_deduction_rule
-- ----------------------------

INSERT INTO `ag_app_deduction_rule` VALUES (2, 'cpa', 0, 'eskhf', '', '20-1,20-2', 'Bq7dGJ', 1, NULL, '2021-12-03 03:51:25', '2021-12-03 03:51:25');
INSERT INTO `ag_app_deduction_rule` VALUES (4, 'cps', 2, 'lbQz8E', '8-1000', '3-1', 'Nb3mqR', 1, '{\"deduction_price\": [{\"max_price\": \"1000\", \"min_price\": \"8\"}], \"deduction_number\": [{\"number\": \"3\", \"deduction\": \"1\"}]}', '2021-12-22 21:07:39', '2021-12-29 02:43:37');
INSERT INTO `ag_app_deduction_rule` VALUES (5, 'cpa', 0, 'a809qX', '', '80', '2GY1GD', 1, NULL, '2021-12-22 21:30:34', '2021-12-22 21:31:04');
INSERT INTO `ag_app_deduction_rule` VALUES (6, 'cpa', 0, 'lbQz8E', '', '3-1', 'zbmabp', 1, NULL, '2021-12-22 21:31:17', '2021-12-29 18:36:54');
INSERT INTO `ag_app_deduction_rule` VALUES (7, 'cps', 2, 'lbQz8E', '20-222,333-44444', '2-2,5-1', 'Bqzpbg', 2, '{\"deduction_price\": [{\"max_price\": \"222\", \"min_price\": \"20\"}, {\"max_price\": \"44444\", \"min_price\": \"333\"}], \"deduction_number\": [{\"number\": \"2\", \"deduction\": \"2\"}, {\"number\": \"5\", \"deduction\": \"1\"}]}', '2021-12-28 01:00:56', '2021-12-31 03:18:18');


-- ----------------------------
-- Table structure for ag_balance_log
-- ----------------------------
DROP TABLE IF EXISTS `ag_balance_log`;
CREATE TABLE `ag_balance_log` (
                                  `id` int unsigned NOT NULL AUTO_INCREMENT,
                                  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
                                  `updated_at` datetime DEFAULT NULL,
                                  `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '代理UID',
                                  `curr_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '当前余额，单位元，可以允许为负数，方便排查问题',
                                  `prev_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '上次余额，单位元，可以允许为负数，方便排查问题',
                                  `diff_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '两次差额(当前减去上次)，单位元，可以为负数',
                                  `change_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '改变事件备注',
                                  `curr_frozen` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '当前冻结资金，单元元',
                                  `prev_frozen` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '上次冻结资金，单位元',
                                  PRIMARY KEY (`id`) USING BTREE,
                                  KEY `INDX_agent_uid` (`agent_uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='现金余额变动和冻结资金变动日志';

-- ----------------------------
-- Table structure for ag_cache
-- ----------------------------
DROP TABLE IF EXISTS `ag_cache`;
CREATE TABLE `ag_cache` (
                            `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                            `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                            `expiration` int NOT NULL,
                            UNIQUE KEY `ag_cache_key_unique` (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_cache
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_channel
-- ----------------------------
DROP TABLE IF EXISTS `ag_channel`;
CREATE TABLE `ag_channel` (
                              `id` int unsigned NOT NULL AUTO_INCREMENT,
                              `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'hash唯一ID',
                              `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '渠道名称',
                              `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '代理商',
                              `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '母包应用UID',
                              `android_url` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'android下载地址',
                              `ios_url` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ios下载地址',
                              `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
                              `created_at` datetime DEFAULT NULL,
                              `updated_at` datetime DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE,
                              UNIQUE KEY `UNQ_uid` (`uid`) USING BTREE,
                              KEY `INDX_agent_uid` (`agent_uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='渠道表';

-- ----------------------------
-- Table structure for ag_commission_log
-- ----------------------------
DROP TABLE IF EXISTS `ag_commission_log`;
CREATE TABLE `ag_commission_log` (
                                     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                     `created_at` datetime DEFAULT NULL,
                                     `updated_at` datetime DEFAULT NULL,
                                     `date` date DEFAULT NULL COMMENT '按Y-m-d日期记录',
                                     `channel_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户充钱的那个渠道UID',
                                     `root_agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_bin NOT NULL DEFAULT '' COMMENT '用户充钱那个渠道的代理UID',
                                     `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '每层抽成的代理UID',
                                     `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '母包应用UID',
                                     `order_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'APP应用内的订单编号',
                                     `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单实际金额',
                                     `commission_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提成金额',
                                     `commission_curr_ratio` smallint unsigned NOT NULL DEFAULT '0' COMMENT '当前agent_uid当时从order_money按此提成比例抽成',
                                     PRIMARY KEY (`id`) USING BTREE,
                                     KEY `INDX_date_agent` (`date`,`agent_uid`) USING BTREE COMMENT '计算某一个代理的单次提成金额'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='从渠道用户开始，每层代理的提成日志';

-- ----------------------------
-- Table structure for ag_config
-- ----------------------------
DROP TABLE IF EXISTS `ag_config`;
CREATE TABLE `ag_config` (
                             `id` int unsigned NOT NULL AUTO_INCREMENT,
                             `created_at` timestamp NULL DEFAULT NULL,
                             `updated_at` timestamp NULL DEFAULT NULL,
                             `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
                             `sgroup` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组',
                             `skey` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '键名',
                             `svalue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '键值',
                             `default_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '默认值',
                             `remark` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '提示备注',
                             `value_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string' COMMENT '值类型',
                             `tag_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'input' COMMENT '表单标签tag名，比如input, select, checkbox',
                             `tag_attr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表单标签扩展属性, mulit, readonly, disabled',
                             `tag_check` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表单标签检查，比如max:200|in:1,2,3',
                             `tag_vlist` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签值列表',
                             `squad` int NOT NULL DEFAULT '1000' COMMENT '排序',
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE KEY `IDX_group_key` (`sgroup`,`skey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统配置';

-- ----------------------------
-- Records of ag_config
-- ----------------------------

INSERT INTO `ag_config` VALUES (12, NULL, '2021-12-21 23:27:37', '后台名称', 'sys', 'web_name', '代理系统后台', '', '后台名称', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (13, NULL, '2021-12-27 01:50:07', '优惠订单（前几单不扣）', 'sys', 'preferential_order', '1', '', '优惠订单（前几单不扣）', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (14, NULL, '2021-12-22 16:17:26', '会员扣量设置开关', 'sys', 'user_deduction_switch', '1', '', '会员扣量设置开关', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (15, NULL, '2021-12-22 16:17:26', 'CPA扣量开关', 'sys', 'cpa_deduction_switch', '1', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (16, NULL, NULL, '提现最低金额', 'sys', 'withdraw_min_money', '1000', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (17, NULL, '2021-12-30 02:52:24', 'usdt汇率', 'sys', 'usdt_rate', '8.88', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (18, NULL, '2021-12-27 19:07:11', 'usdt地址', 'sys', 'usdt_address', 'ERC20,TRC20,BSC', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (19, NULL, '2021-12-24 21:56:20', '提现密码', 'sys', 'withdraw_pwd', '888888', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (20, '2021-12-09 22:12:09', '2021-12-09 22:12:09', 'servicese_link', 'sys', 'servicese_link', 'http://www.google.com', '', '', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (21, NULL, NULL, '优惠订单(前几单下载不扣)', 'sys', 'preferential_user', '1', '0', '优惠订单(前几单下载不扣)', 'string', 'input', '', '', '', 1000);
INSERT INTO `ag_config` VALUES (23, NULL, '2021-12-28 03:37:33', 'usdt提现最低U', 'sys', 'withdraw_min_usdt', '100', '', '', 'string', 'input', '', '', '', 1000);


-- ----------------------------
-- Table structure for ag_failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `ag_failed_jobs`;
CREATE TABLE `ag_failed_jobs` (
                                  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for ag_jobs
-- ----------------------------
DROP TABLE IF EXISTS `ag_jobs`;
CREATE TABLE `ag_jobs` (
                           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                           `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                           `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                           `attempts` tinyint unsigned NOT NULL,
                           `reserved_at` int unsigned DEFAULT NULL,
                           `available_at` int unsigned NOT NULL,
                           `created_at` int unsigned NOT NULL,
                           PRIMARY KEY (`id`) USING BTREE,
                           KEY `ag_jobs_queue_index` (`queue`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_jobs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_manager
-- ----------------------------
DROP TABLE IF EXISTS `ag_manager`;
CREATE TABLE `ag_manager` (
                              `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
                              `created_at` datetime DEFAULT NULL,
                              `updated_at` datetime DEFAULT NULL,
                              `manager_uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '管理员ID',
                              `username` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
                              `nick` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT ' 昵称',
                              `locked_at` datetime DEFAULT NULL,
                              `role_id` int NOT NULL DEFAULT '0' COMMENT '角色ID',
                              `role_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
                              `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
                              `salt` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '盐',
                              `email` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱',
                              `login_at` datetime DEFAULT NULL COMMENT '最近一次登录时间',
                              `otp_secret` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'OTP一次性密钥',
                              PRIMARY KEY (`id`) USING BTREE,
                              UNIQUE KEY `UNQ_manager_uid` (`manager_uid`) USING BTREE COMMENT '唯一UID'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员';

-- ----------------------------
-- Records of ag_manager
-- ----------------------------

INSERT INTO `ag_manager` VALUES (1, '2021-11-19 06:15:03', '2022-01-02 03:47:00', 'ObNRb5', 'adminboss', '超管admin', NULL, 1, '超管', 'ea453ae708f545acd9e95335b152f3ea', 'cTYcEH', '', NULL, 'MYSS54JCU3CCQM44');
INSERT INTO `ag_manager` VALUES (2, '2022-01-02 03:47:18', '2022-01-02 03:47:18', 'Bq7dGJ', 'sg_jim', 'sg_jim', NULL, 1, '超管', 'a4c4fa6ec7c62374c8619ddc3d5f01de', 'dDcybQ', '', NULL, 'JGOUTAJ2LSIR2WUD');
INSERT INTO `ag_manager` VALUES (3, '2022-01-02 03:47:31', '2022-01-02 03:47:31', 'yq2nqr', 'sg_jony', 'sg_jony', NULL, 1, '超管', 'b5b9fd0fbfa5a6d20c1fe3edeb4ac100', 'FrV264', '', NULL, 'G3AXUABO5O5K36CO');
INSERT INTO `ag_manager` VALUES (4, '2022-01-02 03:47:47', '2022-01-02 03:47:47', 'Nb3mqR', 'sg_peter', 'sg_peter', NULL, 1, '超管', '429056af5993cd437d37aa98be88d46b', '41JdJ4', '', NULL, '6JHXAS7GWR4IA6GF');
INSERT INTO `ag_manager` VALUES (5, '2022-01-02 03:48:02', '2022-01-02 03:48:02', '2GY1GD', 'sg_json', 'sg_json', NULL, 1, '超管', '00ff5bb6af4d8099a74e1d2f04600cc4', 'ERPOCy', '', NULL, '6VKK5MTULHEFTK2Y');
INSERT INTO `ag_manager` VALUES (6, '2022-01-02 03:48:13', '2022-01-02 03:48:13', 'zbmabp', 'sg_morry', 'sg_morry', NULL, 1, '超管', '090f86b816ecdb2aa14f3689d8019124', '90V64R', '', NULL, 'GHNA3EGOEENY5YOK');
INSERT INTO `ag_manager` VALUES (7, '2022-01-02 03:48:23', '2022-01-02 03:48:23', 'Bqzpbg', 'sg_bill', 'sg_bill', NULL, 1, '超管', '00047f68e86269d492604ae19f2173ba', 'EK55Qj', '', NULL, 'CS7I4CLY25B6A4PE');


-- ----------------------------
-- Table structure for ag_manager_log
-- ----------------------------
DROP TABLE IF EXISTS `ag_manager_log`;
CREATE TABLE `ag_manager_log` (
                                  `id` int unsigned NOT NULL AUTO_INCREMENT,
                                  `created_at` datetime DEFAULT NULL,
                                  `updated_at` datetime DEFAULT NULL,
                                  `manager_uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '管理员id',
                                  `username` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '账号',
                                  `nick` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
                                  `subject` varchar(700) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主题',
                                  `module` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模块',
                                  `action` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '动作',
                                  `svalue` varchar(3600) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '关联操作值',
                                  `db_data` json DEFAULT NULL COMMENT '前后数据对比',
                                  `ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ipv4',
                                  `ip_address` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ip地址解析名称',
                                  `ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                                  PRIMARY KEY (`id`) USING BTREE,
                                  KEY `INDX_username` (`username`) USING BTREE,
                                  KEY `INDX_module_action` (`module`,`action`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员操作日志';

-- ----------------------------
-- Table structure for ag_migrations
-- ----------------------------
DROP TABLE IF EXISTS `ag_migrations`;
CREATE TABLE `ag_migrations` (
                                 `id` int unsigned NOT NULL AUTO_INCREMENT,
                                 `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `batch` int NOT NULL,
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_migrations
-- ----------------------------

INSERT INTO `ag_migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `ag_migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `ag_migrations` VALUES (3, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `ag_migrations` VALUES (4, '2020_05_26_130058_create_jobs_table', 1);
INSERT INTO `ag_migrations` VALUES (5, '2020_05_26_130059_create_notifications_table', 1);
INSERT INTO `ag_migrations` VALUES (6, '2020_05_26_130100_create_sessions_table', 1);
INSERT INTO `ag_migrations` VALUES (7, '2020_05_26_130103_create_cache_table', 1);


-- ----------------------------
-- Table structure for ag_notifications
-- ----------------------------
DROP TABLE IF EXISTS `ag_notifications`;
CREATE TABLE `ag_notifications` (
                                    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `notifiable_id` bigint unsigned NOT NULL,
                                    `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                    `read_at` timestamp NULL DEFAULT NULL,
                                    `created_at` timestamp NULL DEFAULT NULL,
                                    `updated_at` timestamp NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`) USING BTREE,
                                    KEY `ag_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_notifications
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_password_resets
-- ----------------------------
DROP TABLE IF EXISTS `ag_password_resets`;
CREATE TABLE `ag_password_resets` (
                                      `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                      `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                                      `created_at` timestamp NULL DEFAULT NULL,
                                      KEY `ag_password_resets_email_index` (`email`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_password_resets
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_permission_resource
-- ----------------------------
DROP TABLE IF EXISTS `ag_permission_resource`;
CREATE TABLE `ag_permission_resource` (
                                          `id` int unsigned NOT NULL AUTO_INCREMENT,
                                          `parent_id` int unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
                                          `operate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作',
                                          `squad` int NOT NULL DEFAULT '1000' COMMENT '排序',
                                          `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
                                          PRIMARY KEY (`id`) USING BTREE,
                                          KEY `IDX_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限资源';

-- ----------------------------
-- Records of ag_permission_resource
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_permission_role
-- ----------------------------
DROP TABLE IF EXISTS `ag_permission_role`;
CREATE TABLE `ag_permission_role` (
                                      `id` smallint unsigned NOT NULL AUTO_INCREMENT,
                                      `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
                                      `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '权限资源',
                                      `squad` smallint NOT NULL DEFAULT '1000' COMMENT '排序',
                                      `created_at` datetime DEFAULT NULL,
                                      `updated_at` datetime DEFAULT NULL,
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限角色';

-- ----------------------------
-- Records of ag_permission_role
-- ----------------------------

INSERT INTO `ag_permission_role` VALUES (1, '超管', '-1', 1213, '2020-01-22 23:49:11', '2020-02-27 16:23:16');


-- ----------------------------
-- Table structure for ag_sessions
-- ----------------------------
DROP TABLE IF EXISTS `ag_sessions`;
CREATE TABLE `ag_sessions` (
                               `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                               `user_id` bigint unsigned DEFAULT NULL,
                               `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                               `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
                               `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                               `last_activity` int NOT NULL,
                               UNIQUE KEY `ag_sessions_id_unique` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of ag_sessions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ag_share_urls
-- ----------------------------
DROP TABLE IF EXISTS `ag_share_urls`;
CREATE TABLE `ag_share_urls` (
                                 `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                                 `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '母包应用uid',
                                 `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
                                 `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '落地页面',
                                 `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '封面',
                                 `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态.1=开放;2=隐藏',
                                 `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
                                 `created_at` datetime DEFAULT NULL COMMENT '创建时间',
                                 `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='代理分享url地址';


-- ----------------------------
-- Table structure for ag_statistics_active
-- ----------------------------
DROP TABLE IF EXISTS `ag_statistics_active`;
CREATE TABLE `ag_statistics_active` (
                                        `id` int unsigned NOT NULL AUTO_INCREMENT,
                                        `created_at` datetime DEFAULT NULL,
                                        `updated_at` datetime DEFAULT NULL,
                                        `date` date DEFAULT NULL COMMENT '日期,Y-m-d',
                                        `total` int unsigned NOT NULL DEFAULT '0' COMMENT '总计',
                                        `android` int unsigned NOT NULL DEFAULT '0' COMMENT 'android设备',
                                        `ios` int unsigned NOT NULL DEFAULT '0' COMMENT 'ios设备',
                                        `h5` int unsigned NOT NULL DEFAULT '0' COMMENT 'h5设备',
                                        `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '代理UID，空字符=官方',
                                        `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '母包UID',
                                        `channel_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '渠道UID',
                                        PRIMARY KEY (`id`) USING BTREE,
                                        KEY `IDX_agent` (`date`,`agent_uid`) USING BTREE COMMENT '根据代理是否为空字符串，查询所有或者特定某1个代理数据'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='统计用户日活-所有和渠道维度';

-- ----------------------------
-- Table structure for ag_statistics_new_users
-- ----------------------------
DROP TABLE IF EXISTS `ag_statistics_new_users`;
CREATE TABLE `ag_statistics_new_users` (
                                           `id` int unsigned NOT NULL AUTO_INCREMENT,
                                           `created_at` datetime DEFAULT NULL,
                                           `updated_at` datetime DEFAULT NULL,
                                           `date` date DEFAULT NULL COMMENT '日期,Y-m-d',
                                           `total` int unsigned NOT NULL DEFAULT '0' COMMENT '总计',
                                           `android` int unsigned NOT NULL DEFAULT '0' COMMENT 'android设备',
                                           `ios` int unsigned NOT NULL DEFAULT '0' COMMENT 'ios设备',
                                           `h5` int unsigned NOT NULL DEFAULT '0' COMMENT 'h5设备',
                                           `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '代理UID，空字符串=官方',
                                           `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '母包UID',
                                           `channel_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '渠道UID，空字符串=官方',
                                           `deduction_total` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的总计',
                                           `deduction_android` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的android设备',
                                           `deduction_ios` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的ios设备',
                                           `deduction_h5` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的h5设备',
                                           PRIMARY KEY (`id`) USING BTREE,
                                           KEY `IDX_agent` (`date`,`agent_uid`) USING BTREE COMMENT '根据代理是否为空字符串，查询所有或者特定某1个代理数据'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='统计新增用户, 记录所有以及渠道维度';

-- ----------------------------
-- Table structure for ag_statistics_pay
-- ----------------------------
DROP TABLE IF EXISTS `ag_statistics_pay`;
CREATE TABLE `ag_statistics_pay` (
                                     `id` int unsigned NOT NULL AUTO_INCREMENT,
                                     `created_at` datetime DEFAULT NULL,
                                     `updated_at` datetime DEFAULT NULL,
                                     `date` date NOT NULL COMMENT '日期,Y-m-d',
                                     `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '代理UID, 当空字符串=官方，null=所有',
                                     `mom_app_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '母包UID',
                                     `channel_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '渠道UID, 当空字符串=官方，null=所有',
                                     `order_total` int unsigned NOT NULL DEFAULT '0' COMMENT '订单总数量',
                                     `order_success` int unsigned NOT NULL DEFAULT '0' COMMENT '成功订单数',
                                     `order_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '失败订单数',
                                     `order_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总金额',
                                     `order_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单成功金额',
                                     `android_total` int unsigned NOT NULL DEFAULT '0' COMMENT 'android订单数',
                                     `android_success` int unsigned NOT NULL DEFAULT '0' COMMENT 'android成功订单数',
                                     `android_failed` int unsigned NOT NULL DEFAULT '0' COMMENT 'android失败订单数',
                                     `android_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'android总金额',
                                     `android_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'android成功订单金额',
                                     `ios_total` int unsigned NOT NULL DEFAULT '0' COMMENT 'ios订单数',
                                     `ios_success` int unsigned NOT NULL DEFAULT '0' COMMENT 'ios成功订单数',
                                     `ios_failed` int unsigned NOT NULL DEFAULT '0' COMMENT 'ios失败订单数',
                                     `ios_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'ios总金额',
                                     `ios_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'ios成功订单金额',
                                     `h5_total` int unsigned NOT NULL DEFAULT '0' COMMENT 'h5订单数',
                                     `h5_success` int unsigned NOT NULL DEFAULT '0' COMMENT 'h5成功订单数',
                                     `h5_failed` int unsigned NOT NULL DEFAULT '0' COMMENT 'h5失败订单数',
                                     `h5_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'h5总金额',
                                     `h5_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'h5成功订单金额',
                                     `deduction_total` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的总订单数',
                                     `deduction_success` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的成功订单数',
                                     `deduction_failed` int unsigned NOT NULL DEFAULT '0' COMMENT '渠道扣量后的失败单数',
                                     `deduction_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '渠道扣量后的总金额',
                                     `deduction_success_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '渠道扣量后的成功金额',
                                     PRIMARY KEY (`id`) USING BTREE,
                                     KEY `IDX_agent` (`date`,`agent_uid`) USING BTREE COMMENT '根据代理查询，查询所有或者某一个代理'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='统计支付相关，所有和渠道维度';

-- ----------------------------
-- Table structure for ag_withdrawal_log
-- ----------------------------
DROP TABLE IF EXISTS `ag_withdrawal_log`;
CREATE TABLE `ag_withdrawal_log` (
                                     `id` int unsigned NOT NULL AUTO_INCREMENT,
                                     `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'hash唯一ID',
                                     `created_at` datetime DEFAULT NULL,
                                     `updated_at` datetime DEFAULT NULL,
                                     `paid_at` datetime DEFAULT NULL COMMENT '打款时间',
                                     `status` tinyint unsigned NOT NULL DEFAULT '2' COMMENT '状态1=拒绝;2=申请中;3=已打款;4=拒接并扣除',
                                     `agent_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '关联代理uid',
                                     `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额(元)',
                                     `before_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现前余额(元)',
                                     `after_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现后余额(元)',
                                     `bank_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '卡号',
                                     `bank_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '持卡人姓名',
                                     `bank_mark` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '开户行',
                                     `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
                                     `type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1银行卡;2USTD;3支付宝',
                                     `ustd_network` char(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充币网络',
                                     `ustd_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '充币地址',
                                     `alipay_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝账号',
                                     `alipay_username` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付宝姓名',
                                     `usdt_rate` decimal(5,2) unsigned NOT NULL DEFAULT '1.00' COMMENT 'usdt汇率',
                                     PRIMARY KEY (`id`) USING BTREE,
                                     UNIQUE KEY `UNQ_uid` (`uid`) USING BTREE,
                                     KEY `INDX_agent_uid` (`agent_uid`) USING BTREE COMMENT '根据代理UID查'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='提现记录';