/* 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='提现记录';