SHOW TABLES LIKE 'tp_tenant_domain' [ RunTime:0.000930s ]
SHOW FULL COLUMNS FROM `tp_tenant_domain` [ RunTime:0.000936s ]
SELECT * FROM `tp_tenant_domain` WHERE `domain` = '1.cpumax.cn' AND `status` = 1 LIMIT 1 [ RunTime:0.000555s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='delete_time' [ RunTime:0.001623s ]
SHOW FULL COLUMNS FROM `tp_user` [ RunTime:0.001433s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL [ RunTime:0.000493s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL AND `create_time` >= 1776873600 [ RunTime:0.000471s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_fighter' [ RunTime:0.001405s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_fighter` = 1 [ RunTime:0.000544s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_player' [ RunTime:0.001356s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_player` = 1 [ RunTime:0.000532s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='last_active_time' [ RunTime:0.001340s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `last_active_time` > 1776924399 [ RunTime:0.000498s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_order' [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `tp_order` [ RunTime:0.001564s ]
SELECT COUNT(*) AS think_count FROM `tp_order` [ RunTime:0.000421s ]
SELECT COUNT(*) AS think_count FROM `tp_order` WHERE `create_time` >= 1776873600 [ RunTime:0.000435s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000534s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776873600 [ RunTime:0.000481s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_player_order' [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `tp_player_order` [ RunTime:0.001098s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` [ RunTime:0.000383s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` WHERE `create_time` >= 1776873600 [ RunTime:0.000412s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000460s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776873600 [ RunTime:0.000473s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_withdrawal' [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `tp_withdrawal` [ RunTime:0.000920s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001124s ]
SHOW COLUMNS FROM `tp_admin_role` [ RunTime:0.000825s ]
CREATE TABLE IF NOT EXISTS `tp_admin_domain` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`admin_id` int(11) unsigned NOT NULL DEFAULT 0,
`domain` varchar(190) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT 1,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_admin_domain` (`admin_id`,`domain`),
KEY `idx_domain` (`domain`),
KEY `idx_admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员绑定域名'; [ RunTime:0.015217s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001606s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001553s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001407s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001412s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001422s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001416s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001428s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001425s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001398s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001393s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001383s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001401s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001327s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001353s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001396s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001389s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001412s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001412s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001317s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001372s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001396s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001419s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001538s ]
SHOW COLUMNS FROM `tp_game` [ RunTime:0.000895s ]
SHOW COLUMNS FROM `tp_game_category` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001453s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001521s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001516s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001540s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001541s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001512s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001538s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001470s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001463s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000914s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000809s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000795s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000775s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000783s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000799s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000776s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000775s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000771s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000749s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000871s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000861s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000857s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000864s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000872s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000835s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000823s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000828s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000865s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000839s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000841s ]
CREATE TABLE IF NOT EXISTS `tp_merchant` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(100) NOT NULL DEFAULT '',
`merchant_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`invite_code` varchar(20) NOT NULL DEFAULT '',
`balance` decimal(10,2) NOT NULL DEFAULT 0.00,
`status` tinyint(1) NOT NULL DEFAULT 1,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_id` (`user_id`),
UNIQUE KEY `uk_username` (`username`),
KEY `idx_phone` (`phone`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家账号表' [ RunTime:0.011381s ]
CREATE TABLE IF NOT EXISTS `tp_merchant_verify` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(100) NOT NULL DEFAULT '',
`merchant_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`verify_status` tinyint(3) unsigned NOT NULL DEFAULT 0,
`reject_reason` varchar(255) NOT NULL DEFAULT '',
`verify_time` int(10) unsigned NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_username` (`username`),
KEY `idx_verify_status` (`verify_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家开通申请表' [ RunTime:0.006409s ]
CREATE TABLE IF NOT EXISTS `tp_merchant_staff` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(11) unsigned NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(100) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`openid` varchar(100) NOT NULL DEFAULT '',
`unionid` varchar(100) NOT NULL DEFAULT '',
`avatar` varchar(500) NOT NULL DEFAULT '',
`wx_nickname` varchar(100) NOT NULL DEFAULT '',
`profit_share_enabled` tinyint(1) NOT NULL DEFAULT 0,
`profit_share_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
`can_create_order` tinyint(1) NOT NULL DEFAULT 1,
`can_withdraw` tinyint(1) NOT NULL DEFAULT 1,
`status` tinyint(1) NOT NULL DEFAULT 1,
`last_login_time` int(11) unsigned NOT NULL DEFAULT 0,
`last_login_ip` varchar(64) NOT NULL DEFAULT '',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_merchant_username` (`merchant_id`,`username`),
KEY `idx_merchant_id` (`merchant_id`),
KEY `idx_openid` (`openid`),
KEY `idx_unionid` (`unionid`),
KEY `idx_phone` (`phone`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家客服账号表' [ RunTime:0.006716s ]
CREATE TABLE IF NOT EXISTS `tp_merchant_staff_token` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`staff_id` int(11) unsigned NOT NULL DEFAULT 0,
`token` varchar(128) NOT NULL DEFAULT '',
`session_key` varchar(100) NOT NULL DEFAULT '',
`expire_time` int(11) unsigned NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_token` (`token`),
KEY `idx_staff_id` (`staff_id`),
KEY `idx_expire_time` (`expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家客服小程序登录Token表' [ RunTime:0.007210s ]
CREATE TABLE IF NOT EXISTS `tp_manager` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(100) NOT NULL DEFAULT '',
`manager_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`invite_code` varchar(20) NOT NULL DEFAULT '',
`balance` decimal(10,2) NOT NULL DEFAULT 0.00,
`status` tinyint(1) NOT NULL DEFAULT 1,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_id` (`user_id`),
UNIQUE KEY `uk_username` (`username`),
UNIQUE KEY `uk_invite_code` (`invite_code`),
KEY `idx_phone` (`phone`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管事账号表' [ RunTime:0.007034s ]
CREATE TABLE IF NOT EXISTS `tp_manager_verify` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`phone` varchar(20) NOT NULL DEFAULT '',
`nickname` varchar(100) NOT NULL DEFAULT '',
`manager_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`verify_status` tinyint(3) unsigned NOT NULL DEFAULT 0,
`reject_reason` varchar(255) NOT NULL DEFAULT '',
`verify_time` int(10) unsigned NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_username` (`username`),
KEY `idx_verify_status` (`verify_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管事开通申请表' [ RunTime:0.009752s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.001008s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000842s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000806s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000788s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000782s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000779s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000756s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000772s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000768s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000774s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000769s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000749s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000747s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000755s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000774s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000755s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000748s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000769s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000765s ]
CREATE TABLE IF NOT EXISTS `tp_user_token` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`token` varchar(128) NOT NULL DEFAULT '',
`session_key` varchar(100) NOT NULL DEFAULT '',
`expire_time` int(11) unsigned NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_token` (`token`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户登录Token表' [ RunTime:0.009943s ]
CREATE TABLE IF NOT EXISTS `tp_h5_subscribe_grant` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT 0,
`role` varchar(20) NOT NULL DEFAULT '' COMMENT '角色:fighter/player',
`template_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'H5一次性订阅模板ID',
`scene` varchar(32) NOT NULL DEFAULT '' COMMENT '一次性订阅scene',
`grant_token` varchar(64) NOT NULL DEFAULT '' COMMENT '授权记录token',
`status` varchar(20) NOT NULL DEFAULT 'created' COMMENT '状态:created/returned/used/failed/cleared',
`return_url` varchar(500) NOT NULL DEFAULT '' COMMENT '授权返回页',
`detail` text COMMENT '调试详情',
`used_time` int(11) unsigned NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_grant_token` (`grant_token`),
KEY `idx_user_role_status` (`user_id`,`role`,`status`),
KEY `idx_scene` (`scene`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='H5一次性订阅授权记录表' [ RunTime:0.006855s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.001200s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000998s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000902s ]
SHOW TABLES LIKE 'tp_chat_session' [ RunTime:0.000844s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000915s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000863s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000835s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000832s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000863s ]
CREATE TABLE IF NOT EXISTS `tp_tenant` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '租户ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '租户名称',
`code` varchar(50) NOT NULL DEFAULT '' COMMENT '租户编码',
`contact_name` varchar(50) NOT NULL DEFAULT '' COMMENT '联系人',
`contact_phone` varchar(20) NOT NULL DEFAULT '' COMMENT '联系电话',
`contact_email` varchar(100) NOT NULL DEFAULT '' COMMENT '联系邮箱',
`logo` varchar(500) NOT NULL DEFAULT '' COMMENT 'Logo',
`expire_time` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '到期时间',
`max_users` int(11) NOT NULL DEFAULT 0 COMMENT '最大用户数',
`max_fighters` int(11) NOT NULL DEFAULT 0 COMMENT '最大打手数',
`max_players` int(11) NOT NULL DEFAULT 0 COMMENT '最大陪玩数',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态:0禁用1正常2试用',
`remark` varchar(500) NOT NULL DEFAULT '' COMMENT '备注',
`config` text COMMENT '个性化配置JSON',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
`delete_time` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_code` (`code`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='租户主表' [ RunTime:0.007005s ]
CREATE TABLE IF NOT EXISTS `tp_tenant_domain` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '租户ID',
`domain` varchar(255) NOT NULL DEFAULT '' COMMENT '域名',
`is_primary` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否主域名',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_domain` (`domain`),
KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='租户域名映射表' [ RunTime:0.006413s ]
CREATE TABLE IF NOT EXISTS `tp_saas_partner` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '上级渠道ID',
`partner_type` tinyint(1) NOT NULL DEFAULT 3 COMMENT '3授权商 2代理商',
`username` varchar(50) NOT NULL DEFAULT '' COMMENT '登录账号',
`password` varchar(255) NOT NULL DEFAULT '' COMMENT '登录密码哈希',
`nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '显示名称',
`phone` varchar(20) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`balance` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '账户余额',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 1正常 0禁用',
`remark` varchar(500) NOT NULL DEFAULT '',
`last_login_time` int(11) unsigned NOT NULL DEFAULT 0,
`last_login_ip` varchar(50) NOT NULL DEFAULT '',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
`delete_time` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_partner_username` (`username`),
KEY `idx_partner_type` (`partner_type`),
KEY `idx_parent_id` (`parent_id`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='SaaS渠道账号(授权商/代理商)' [ RunTime:0.006510s ]
CREATE TABLE IF NOT EXISTS `tp_saas_partner_price` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`partner_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '渠道ID',
`package_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '套餐ID',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '渠道价',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_partner_package` (`partner_id`,`package_id`),
KEY `idx_package_id` (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='渠道套餐定价' [ RunTime:0.006867s ]
CREATE TABLE IF NOT EXISTS `tp_saas_partner_balance_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`partner_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '渠道ID',
`change_value` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '变动金额',
`before_balance` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '变动前余额',
`after_balance` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '变动后余额',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1充值 2扣减 3下级充值扣减 4下级入账',
`related_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '关联ID',
`remark` varchar(500) NOT NULL DEFAULT '',
`operator_id` int(11) unsigned NOT NULL DEFAULT 0,
`operator_type` varchar(20) NOT NULL DEFAULT 'admin',
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `idx_partner_id` (`partner_id`),
KEY `idx_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='渠道余额流水' [ RunTime:0.006614s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001303s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.001105s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.001002s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.001058s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.001004s ]
SHOW COLUMNS FROM `tp_config` [ RunTime:0.000814s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000957s ]
SHOW INDEX FROM `tp_config` [ RunTime:0.000543s ]
SHOW TABLES LIKE 'tp_tenant' [ RunTime:0.000901s ]
SHOW FULL COLUMNS FROM `tp_tenant` [ RunTime:0.001075s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000580s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.001143s ]
SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000965s ]
SELECT `value`,`name` FROM `tp_config` WHERE `tenant_id` = 1 AND `name` IN ('site_name','site_logo','site_favicon','site_notice','icp_number','contact_phone','contact_email') [ RunTime:0.000717s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000935s ]
SELECT `value`,`name` FROM `tp_config` WHERE `tenant_id` = 1 AND `name` IN ('player_enabled','fighter_enabled','merchant_enabled','manager_enabled') [ RunTime:0.000650s ]
SHOW FULL COLUMNS FROM `tp_gift_record` [ RunTime:0.000951s ]
SELECT gr.user_id, u.nickname as user_name, SUM(gr.amount) as total_amount, COUNT(*) as gift_count FROM `tp_gift_record` `gr` LEFT JOIN `tp_user` `u` ON `gr`.`user_id`=`u`.`id` WHERE `tenant_id` = '1' GROUP BY `gr`.`user_id`,`u`.`nickname` ORDER BY `total_amount` DESC LIMIT 10 [ RunTime:0.000983s ]
SELECT gr.master_id, m.nickname as master_name, SUM(gr.amount) as total_amount, COUNT(*) as gift_count FROM `tp_gift_record` `gr` LEFT JOIN `tp_user` `m` ON `gr`.`master_id`=`m`.`id` WHERE `tenant_id` = '1' AND `gr`.`master_id` > '0' GROUP BY `gr`.`master_id`,`m`.`nickname` ORDER BY `total_amount` DESC LIMIT 10 [ RunTime:0.001137s ]
