SHOW TABLES LIKE 'tp_tenant_domain' [ RunTime:0.001052s ]
SHOW FULL COLUMNS FROM `tp_tenant_domain` [ RunTime:0.000968s ]
SELECT * FROM `tp_tenant_domain` WHERE `domain` = '1.cpumax.cn' AND `status` = 1 LIMIT 1 [ RunTime:0.000535s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='delete_time' [ RunTime:0.001738s ]
SHOW FULL COLUMNS FROM `tp_user` [ RunTime:0.001466s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL [ RunTime:0.000659s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL AND `create_time` >= 1776873600 [ RunTime:0.000489s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_fighter' [ RunTime:0.001521s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_fighter` = 1 [ RunTime:0.000628s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_player' [ RunTime:0.001491s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_player` = 1 [ RunTime:0.000573s ]
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.001418s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `last_active_time` > 1776920016 [ RunTime:0.000542s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_order' [ RunTime:0.000496s ]
SHOW FULL COLUMNS FROM `tp_order` [ RunTime:0.001574s ]
SELECT COUNT(*) AS think_count FROM `tp_order` [ RunTime:0.000432s ]
SELECT COUNT(*) AS think_count FROM `tp_order` WHERE `create_time` >= 1776873600 [ RunTime:0.000451s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000504s ]
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.000502s ]
SHOW FULL COLUMNS FROM `tp_player_order` [ RunTime:0.001148s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` [ RunTime:0.000395s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` WHERE `create_time` >= 1776873600 [ RunTime:0.000404s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000470s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776873600 [ RunTime:0.000471s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_withdrawal' [ RunTime:0.000475s ]
SHOW FULL COLUMNS FROM `tp_withdrawal` [ RunTime:0.001005s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001115s ]
SHOW COLUMNS FROM `tp_admin_role` [ RunTime:0.000826s ]
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.021373s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001515s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001541s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001373s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001438s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001372s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001472s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001364s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001369s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001427s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001365s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001409s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001431s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001406s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001433s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001361s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001333s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001274s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001380s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001427s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001397s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001366s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001327s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001475s ]
SHOW COLUMNS FROM `tp_game` [ RunTime:0.000862s ]
SHOW COLUMNS FROM `tp_game_category` [ RunTime:0.000766s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001375s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001448s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001526s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001514s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001478s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001479s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001455s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001409s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001423s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000843s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000804s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000792s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000802s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000787s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000789s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000795s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000797s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000785s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000757s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000755s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000881s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000889s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000878s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000873s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000888s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000852s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000842s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000826s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000835s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000835s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000830s ]
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.013117s ]
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.006538s ]
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.007002s ]
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.006660s ]
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.006870s ]
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.007029s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.001022s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000835s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000804s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000795s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000767s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000771s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000766s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000787s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000770s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000763s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000749s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000767s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000763s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000758s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000760s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000744s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000742s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000780s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000767s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000756s ]
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.013010s ]
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.007368s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.001062s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000943s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000940s ]
SHOW TABLES LIKE 'tp_chat_session' [ RunTime:0.000932s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000885s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000828s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000811s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000822s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000809s ]
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.006776s ]
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.006988s ]
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.006772s ]
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.006859s ]
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.006907s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001041s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.000978s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.000907s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000953s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000907s ]
SHOW COLUMNS FROM `tp_config` [ RunTime:0.000741s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000914s ]
SHOW INDEX FROM `tp_config` [ RunTime:0.000534s ]
SHOW TABLES LIKE 'tp_tenant' [ RunTime:0.000788s ]
SHOW FULL COLUMNS FROM `tp_tenant` [ RunTime:0.001063s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000627s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000867s ]
SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000843s ]
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.000697s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000940s ]
SELECT `value`,`name` FROM `tp_config` WHERE `tenant_id` = 1 AND `name` IN ('player_enabled','fighter_enabled','merchant_enabled','manager_enabled') [ RunTime:0.000651s ]
SHOW TABLES LIKE 'tp_decorate' [ RunTime:0.000919s ]
SHOW FULL COLUMNS FROM `tp_decorate` [ RunTime:0.000959s ]
SELECT * FROM `tp_decorate` WHERE `tenant_id` = 1 AND `status` = 1 AND `type` = 'banner' ORDER BY `sort` DESC [ RunTime:0.000806s ]
SHOW TABLES LIKE 'tp_game' [ RunTime:0.001110s ]
SHOW FULL COLUMNS FROM `tp_game` [ RunTime:0.001043s ]
SHOW COLUMNS FROM `tp_game` LIKE 'delete_time' [ RunTime:0.000737s ]
SELECT * FROM `tp_game` WHERE `tenant_id` = 1 AND `status` = 1 AND `delete_time` IS NULL ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000632s ]
SHOW TABLES LIKE 'tp_service' [ RunTime:0.000924s ]
SHOW FULL COLUMNS FROM `tp_service` [ RunTime:0.001157s ]
SHOW COLUMNS FROM `tp_service` LIKE 'delete_time' [ RunTime:0.000987s ]
SELECT `s`.*,g.name as game_name FROM `tp_service` `s` LEFT JOIN `tp_game` `g` ON `s`.`game_id`=`g`.`id` WHERE `tenant_id` = '1' AND `s`.`status` = '1' AND `s`.`delete_time` IS NULL ORDER BY `s`.`sort` ASC LIMIT 6 [ RunTime:0.000859s ]
SHOW COLUMNS FROM `tp_service` LIKE 'delete_time' [ RunTime:0.000763s ]
