SHOW TABLES LIKE 'tp_tenant_domain' [ RunTime:0.001063s ]
SHOW FULL COLUMNS FROM `tp_tenant_domain` [ RunTime:0.000939s ]
SELECT * FROM `tp_tenant_domain` WHERE `domain` = 'saas.cpumax.cn' AND `status` = 1 LIMIT 1 [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `tp_tenant` [ RunTime:0.000960s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 AND `status` > 0 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000546s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='delete_time' [ RunTime:0.001633s ]
SHOW FULL COLUMNS FROM `tp_user` [ RunTime:0.001391s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL [ RunTime:0.000499s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL AND `create_time` >= 1776787200 [ RunTime:0.000500s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_fighter' [ RunTime:0.001429s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_fighter` = 1 [ RunTime:0.000543s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_player' [ RunTime:0.001441s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_player` = 1 [ RunTime:0.000542s ]
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.001395s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `last_active_time` > 1776850439 [ RunTime:0.000524s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_order' [ RunTime:0.000520s ]
SHOW FULL COLUMNS FROM `tp_order` [ RunTime:0.001594s ]
SELECT COUNT(*) AS think_count FROM `tp_order` [ RunTime:0.000423s ]
SELECT COUNT(*) AS think_count FROM `tp_order` WHERE `create_time` >= 1776787200 [ RunTime:0.000459s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000518s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776787200 [ RunTime:0.000481s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_player_order' [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `tp_player_order` [ RunTime:0.001131s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` [ RunTime:0.000410s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` WHERE `create_time` >= 1776787200 [ RunTime:0.000396s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000459s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776787200 [ RunTime:0.000468s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_withdrawal' [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `tp_withdrawal` [ RunTime:0.000965s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001169s ]
SHOW COLUMNS FROM `tp_admin_role` [ RunTime:0.000805s ]
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.013488s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001483s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001334s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001284s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001310s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001276s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001306s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001273s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001277s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001272s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001263s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001272s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001257s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001307s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001259s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001250s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001284s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001253s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001267s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001260s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001263s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001253s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001251s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001392s ]
SHOW COLUMNS FROM `tp_game` [ RunTime:0.000846s ]
SHOW COLUMNS FROM `tp_game_category` [ RunTime:0.000764s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001369s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001415s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001409s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001409s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001389s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001388s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001376s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001375s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001375s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000843s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000793s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000790s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000812s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000785s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000774s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000756s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000769s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000780s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000879s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000851s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000879s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000877s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000873s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000837s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000825s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000820s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000827s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000829s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000807s ]
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.006561s ]
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.018496s ]
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.007031s ]
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.006754s ]
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.006768s ]
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.006613s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.001006s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000815s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000808s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000795s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000777s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000777s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000777s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000755s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000745s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000782s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000758s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000773s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000772s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000768s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000748s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000748s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000762s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000754s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000760s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000768s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000744s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000744s ]
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.006681s ]
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.006840s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.001138s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000936s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000851s ]
SHOW TABLES LIKE 'tp_chat_session' [ RunTime:0.000828s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000881s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000842s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000819s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000797s ]
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.006873s ]
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.006495s ]
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.006618s ]
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.006907s ]
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.007788s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001287s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.001110s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.000944s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000897s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000881s ]
SHOW COLUMNS FROM `tp_config` [ RunTime:0.000755s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000811s ]
SHOW INDEX FROM `tp_config` [ RunTime:0.000469s ]
SHOW TABLES LIKE 'tp_tenant' [ RunTime:0.000753s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000542s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000817s ]
SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000839s ]
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.000674s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000807s ]
SELECT `value`,`name` FROM `tp_config` WHERE `tenant_id` = 1 AND `name` IN ('player_enabled','fighter_enabled','merchant_enabled','manager_enabled') [ RunTime:0.000559s ]
SHOW FULL COLUMNS FROM `tp_help_category` [ RunTime:0.000940s ]
SHOW FULL COLUMNS FROM `tp_help_faq` [ RunTime:0.000801s ]
