注册 - ces

基本文件流程错误 SQL 调试

/www/wwwroot/saas.cpumax.cn/public/index.php ( 0.27 KB )
/www/wwwroot/saas.cpumax.cn/vendor/autoload.php ( 0.73 KB )
/www/wwwroot/saas.cpumax.cn/vendor/composer/autoload_real.php ( 1.63 KB )
/www/wwwroot/saas.cpumax.cn/vendor/composer/platform_check.php ( 0.90 KB )
/www/wwwroot/saas.cpumax.cn/vendor/composer/ClassLoader.php ( 15.99 KB )
/www/wwwroot/saas.cpumax.cn/vendor/composer/autoload_static.php ( 3.44 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-captcha/src/helper.php ( 1.37 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/App.php ( 15.00 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-container/src/Container.php ( 15.62 KB )
/www/wwwroot/saas.cpumax.cn/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/www/wwwroot/saas.cpumax.cn/app/provider.php ( 0.23 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
/www/wwwroot/saas.cpumax.cn/app/common.php ( 109.42 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/helper.php ( 18.78 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
/www/wwwroot/saas.cpumax.cn/config/app.php ( 1.09 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/www/wwwroot/saas.cpumax.cn/config/cache.php ( 1.19 KB )
/www/wwwroot/saas.cpumax.cn/config/common.php ( 0.92 KB )
/www/wwwroot/saas.cpumax.cn/config/console.php ( 0.18 KB )
/www/wwwroot/saas.cpumax.cn/config/cookie.php ( 0.00 KB )
/www/wwwroot/saas.cpumax.cn/config/database.php ( 2.29 KB )
/www/wwwroot/saas.cpumax.cn/config/license.php ( 1.03 KB )
/www/wwwroot/saas.cpumax.cn/config/license.version.php ( 0.05 KB )
/www/wwwroot/saas.cpumax.cn/config/log.php ( 1.19 KB )
/www/wwwroot/saas.cpumax.cn/config/middleware.php ( 0.64 KB )
/www/wwwroot/saas.cpumax.cn/config/miniprogram.php ( 0.57 KB )
/www/wwwroot/saas.cpumax.cn/config/session.php ( 0.51 KB )
/www/wwwroot/saas.cpumax.cn/config/trace.php ( 0.18 KB )
/www/wwwroot/saas.cpumax.cn/config/view.php ( 0.71 KB )
/www/wwwroot/saas.cpumax.cn/config/wechat.php ( 0.42 KB )
/www/wwwroot/saas.cpumax.cn/app/event.php ( 0.28 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/wwwroot/saas.cpumax.cn/vendor/services.php ( 0.21 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 1.75 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.52 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-multi-app/src/Service.php ( 1.05 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.71 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/Model.php ( 26.86 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 19.19 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.44 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.58 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.69 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteId.php ( 1.44 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.85 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.33 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
/www/wwwroot/saas.cpumax.cn/vendor/psr/log/src/LoggerInterface.php ( 2.68 KB )
/www/wwwroot/saas.cpumax.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
/www/wwwroot/saas.cpumax.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Console.php ( 22.81 KB )
/www/wwwroot/saas.cpumax.cn/app/Request.php ( 0.26 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Request.php ( 55.74 KB )
/www/wwwroot/saas.cpumax.cn/app/middleware.php ( 0.52 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 1.94 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/session/driver/File.php ( 6.27 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/session/Store.php ( 7.12 KB )
/www/wwwroot/saas.cpumax.cn/app/middleware/TenantDomainPortalMiddleware.php ( 5.49 KB )
/www/wwwroot/saas.cpumax.cn/app/common/TenantContext.php ( 8.28 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.33 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 51.60 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.81 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.86 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.56 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/Builder.php ( 22.26 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.29 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.21 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 41.60 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 19.29 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.98 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 18.79 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.96 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.46 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 6.19 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.88 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/www/wwwroot/saas.cpumax.cn/app/middleware/TenantMiddleware.php ( 11.98 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/facade/Session.php ( 1.79 KB )
/www/wwwroot/saas.cpumax.cn/app/middleware/CheckLicense.php ( 5.19 KB )
/www/wwwroot/saas.cpumax.cn/app/common/License.php ( 54.22 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/exception/PDOException.php ( 1.50 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-orm/src/db/exception/DbException.php ( 1.38 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.06 KB )
/www/wwwroot/saas.cpumax.cn/app/index/middleware.php ( 0.23 KB )
/www/wwwroot/saas.cpumax.cn/app/middleware/SessionBridge.php ( 0.93 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Route.php ( 23.56 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.34 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/Domain.php ( 1.25 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 20.45 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/Rule.php ( 26.35 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 3.75 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.54 KB )
/www/wwwroot/saas.cpumax.cn/app/index/controller/Login.php ( 15.59 KB )
/www/wwwroot/saas.cpumax.cn/app/index/controller/Base.php ( 8.77 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-view/src/Think.php ( 8.00 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-template/src/template/taglib/Cx.php ( 24.23 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-template/src/template/TagLib.php ( 12.11 KB )
/www/wwwroot/saas.cpumax.cn/runtime/index/temp/a8f72be881503c4f9e846a7e8a989188.php ( 7.86 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
/www/wwwroot/saas.cpumax.cn/vendor/topthink/think-trace/src/Html.php ( 4.64 KB )

CONNECT:[ UseTime:0.000771s ] mysql:host=127.0.0.1;port=3306;dbname=saashuhang;charset=utf8mb4
SHOW TABLES LIKE 'tp_tenant_domain' [ RunTime:0.000965s ]
SHOW FULL COLUMNS FROM `tp_tenant_domain` [ RunTime:0.000904s ]
SELECT * FROM `tp_tenant_domain` WHERE `domain` = 'saas.cpumax.cn' AND `status` = 1 LIMIT 1 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `tp_tenant` [ RunTime:0.000969s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 AND `status` > 0 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000537s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='delete_time' [ RunTime:0.001629s ]
SHOW FULL COLUMNS FROM `tp_user` [ RunTime:0.001404s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL [ RunTime:0.000442s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `delete_time` IS NULL AND `create_time` >= 1776787200 [ RunTime:0.000442s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_fighter' [ RunTime:0.001382s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_fighter` = 1 [ RunTime:0.000506s ]
SELECT COUNT(*) as c FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_user' AND COLUMN_NAME='is_player' [ RunTime:0.001370s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `is_player` = 1 [ RunTime:0.000486s ]
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.001358s ]
SELECT COUNT(*) AS think_count FROM `tp_user` WHERE `tenant_id` = 1 AND `delete_time` IS NULL AND `last_active_time` > 1776850500 [ RunTime:0.000463s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_order' [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `tp_order` [ RunTime:0.001524s ]
SELECT COUNT(*) AS think_count FROM `tp_order` [ RunTime:0.000371s ]
SELECT COUNT(*) AS think_count FROM `tp_order` WHERE `create_time` >= 1776787200 [ RunTime:0.000450s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000489s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776787200 [ RunTime:0.000508s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_player_order' [ RunTime:0.000521s ]
SHOW FULL COLUMNS FROM `tp_player_order` [ RunTime:0.001107s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` [ RunTime:0.000407s ]
SELECT COUNT(*) AS think_count FROM `tp_player_order` WHERE `create_time` >= 1776787200 [ RunTime:0.000409s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 [ RunTime:0.000466s ]
SELECT SUM(`amount`) AS think_sum FROM `tp_player_order` WHERE `status` >= 1 AND `status` <> 4 AND `create_time` >= 1776787200 [ RunTime:0.000489s ]
SELECT COUNT(*) as c FROM information_schema.TABLES WHERE TABLE_SCHEMA='saashuhang' AND TABLE_NAME='tp_withdrawal' [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `tp_withdrawal` [ RunTime:0.000994s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.001167s ]
SHOW COLUMNS FROM `tp_admin_role` [ RunTime:0.000834s ]
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.014339s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001547s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001429s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001370s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001318s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001303s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001318s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001293s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001284s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001298s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001292s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001300s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001296s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001292s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001274s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001312s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001294s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001279s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001283s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001386s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001351s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001288s ]
SHOW COLUMNS FROM `tp_user` [ RunTime:0.001283s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001429s ]
SHOW COLUMNS FROM `tp_game` [ RunTime:0.000841s ]
SHOW COLUMNS FROM `tp_game_category` [ RunTime:0.000784s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001406s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001421s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001426s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001437s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001418s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001423s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001385s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001412s ]
SHOW COLUMNS FROM `tp_order` [ RunTime:0.001413s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000865s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000827s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000808s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000803s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000814s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000801s ]
SHOW COLUMNS FROM `tp_recharge_order` [ RunTime:0.000814s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000806s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000807s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000803s ]
SHOW COLUMNS FROM `tp_gift_record` [ RunTime:0.000804s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000890s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000894s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000878s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000872s ]
SHOW COLUMNS FROM `tp_merchant` [ RunTime:0.000891s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000851s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000845s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000846s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000860s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000853s ]
SHOW COLUMNS FROM `tp_merchant_staff` [ RunTime:0.000844s ]
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.007500s ]
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.007470s ]
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.008168s ]
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.007524s ]
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.007783s ]
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.007710s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.001038s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000855s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000827s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000820s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000808s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000803s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000813s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000781s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000782s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000784s ]
SHOW COLUMNS FROM `tp_manager` [ RunTime:0.000790s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000792s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000789s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000785s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000793s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000772s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000776s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000774s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000785s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000777s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000790s ]
SHOW COLUMNS FROM `tp_manager_verify` [ RunTime:0.000789s ]
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.007433s ]
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.007540s ]
CREATE TABLE IF NOT EXISTS `tp_admin_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID', `admin_id` int(10) unsigned DEFAULT 0 COMMENT '管理员ID', `module` varchar(50) DEFAULT '' COMMENT '操作模块', `action` varchar(50) DEFAULT '' COMMENT '操作动作', `content` varchar(500) DEFAULT '' COMMENT '操作内容', `url` varchar(255) DEFAULT '' COMMENT '请求URL', `method` varchar(10) DEFAULT '' COMMENT '请求方法', `params` text COMMENT '请求参数', `ip` varchar(50) DEFAULT '' COMMENT 'IP地址', `user_agent` varchar(500) DEFAULT '' COMMENT '浏览器UA', `create_time` int(10) unsigned DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_admin_id` (`admin_id`), KEY `idx_create_time` (`create_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志表' [ RunTime:0.007537s ]
CREATE TABLE IF NOT EXISTS `tp_apply_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '' COMMENT '标签名称', `type` varchar(20) NOT NULL DEFAULT 'all' COMMENT '适用类型：all=通用 fighter=打手 player=陪玩', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序(越大越前)', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0=禁用 1=启用', `create_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_type_status` (`type`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入驻申请标签表' [ RunTime:0.007766s ]
CREATE TABLE IF NOT EXISTS `tp_coupon` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `type` tinyint(1) NOT NULL DEFAULT 1, `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `min_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `total` int(11) NOT NULL DEFAULT 0, `used` int(11) NOT NULL DEFAULT 0, `start_time` int(11) unsigned NOT NULL DEFAULT 0, `end_time` int(11) unsigned NOT NULL DEFAULT 0, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠券表' [ RunTime:0.007439s ]
CREATE TABLE IF NOT EXISTS `tp_coupon_receive` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `coupon_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '状态:0未使用1已使用2已过期', `use_time` int(10) unsigned DEFAULT NULL, `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='优惠券领取表' [ RunTime:0.007241s ]
CREATE TABLE IF NOT EXISTS `tp_user_coupon` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `coupon_id` int(11) unsigned NOT NULL DEFAULT 0, `status` tinyint(1) NOT NULL DEFAULT 0, `use_time` int(11) unsigned NOT NULL DEFAULT 0, `order_id` int(11) unsigned NOT NULL DEFAULT 0, `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uk_user_coupon` (`user_id`,`coupon_id`), KEY `idx_coupon_id` (`coupon_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户优惠券表' [ RunTime:0.007395s ]
SHOW TABLES LIKE 'tp_coupon_receive' [ RunTime:0.000954s ]
SHOW TABLES LIKE 'tp_user_coupon' [ RunTime:0.000773s ]
SELECT COUNT(*) AS cnt FROM `tp_user_coupon` [ RunTime:0.000394s ]
CREATE TABLE IF NOT EXISTS `tp_card_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `sort` int(11) NOT NULL DEFAULT 0, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='卡密分类表' [ RunTime:0.007387s ]
CREATE TABLE IF NOT EXISTS `tp_card` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `category_id` int(11) unsigned NOT NULL DEFAULT 0, `code` varchar(100) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT 0, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `use_time` int(11) unsigned NOT NULL DEFAULT 0, `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uk_code` (`code`), KEY `idx_category_id` (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='卡密表' [ RunTime:0.007913s ]
CREATE TABLE IF NOT EXISTS `tp_withdrawal` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `withdraw_no` varchar(64) NOT NULL DEFAULT '', `user_id` int(11) unsigned NOT NULL DEFAULT 0, `role` varchar(20) NOT NULL DEFAULT 'user', `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `bank_type` tinyint(1) NOT NULL DEFAULT 1, `account_name` varchar(100) NOT NULL DEFAULT '', `account_no` varchar(100) NOT NULL DEFAULT '', `bank_name` varchar(255) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT 0, `remark` varchar(500) NOT NULL DEFAULT '', `audit_remark` varchar(500) NOT NULL DEFAULT '', `audit_admin_id` int(11) unsigned NOT NULL DEFAULT 0, `audit_time` int(11) unsigned NOT NULL DEFAULT 0, `pay_order_no` 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`), KEY `idx_user_id` (`user_id`), KEY `idx_status` (`status`), KEY `idx_withdraw_no` (`withdraw_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='提现记录表' [ RunTime:0.007237s ]
SHOW TABLES LIKE 'tp_withdraw' [ RunTime:0.000922s ]
SHOW TABLES LIKE 'tp_withdrawal' [ RunTime:0.000790s ]
SELECT COUNT(*) AS cnt FROM `tp_withdrawal` [ RunTime:0.000385s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000933s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000887s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000857s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000844s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000832s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000842s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000840s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000828s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000824s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000832s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000827s ]
SHOW COLUMNS FROM `tp_withdrawal` [ RunTime:0.000812s ]
CREATE TABLE IF NOT EXISTS `tp_lottery_prize` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `icon` varchar(500) NOT NULL DEFAULT '', `type` tinyint(1) unsigned NOT NULL DEFAULT 1, `value` decimal(10,2) NOT NULL DEFAULT 0, `probability` decimal(10,6) NOT NULL DEFAULT 0, `stock` int(11) NOT NULL DEFAULT -1, `daily_limit` int(11) NOT NULL DEFAULT -1, `color` varchar(20) NOT NULL DEFAULT '#ff4d6a', `sort` int(11) NOT NULL DEFAULT 0, `status` tinyint(1) unsigned NOT NULL DEFAULT 1, `delete_time` int(11) unsigned DEFAULT NULL, `create_time` int(11) unsigned NOT NULL DEFAULT 0, `update_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='轮盘抽奖奖品表' [ RunTime:0.010144s ]
CREATE TABLE IF NOT EXISTS `tp_lottery_record` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `prize_id` int(11) unsigned NOT NULL DEFAULT 0, `prize_name` varchar(100) NOT NULL DEFAULT '', `prize_type` tinyint(1) unsigned NOT NULL DEFAULT 1, `prize_value` decimal(10,2) NOT NULL DEFAULT 0, `is_free` tinyint(1) unsigned NOT NULL DEFAULT 0, `cost` decimal(10,2) NOT NULL DEFAULT 0, `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='轮盘抽奖记录表' [ RunTime:0.010646s ]
CREATE TABLE IF NOT EXISTS `tp_lottery_activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL DEFAULT '', `description` text, `cover` varchar(500) NOT NULL DEFAULT '', `play_type` tinyint(1) unsigned NOT NULL DEFAULT 1, `trigger_type` tinyint(1) unsigned NOT NULL DEFAULT 1, `trigger_value` decimal(10,2) NOT NULL DEFAULT 0, `trigger_service_id` int(11) NOT NULL DEFAULT 0, `free_times` int(11) NOT NULL DEFAULT 1, `daily_limit` int(11) NOT NULL DEFAULT 0, `total_limit` int(11) NOT NULL DEFAULT 0, `start_time` int(11) unsigned NOT NULL DEFAULT 0, `end_time` int(11) unsigned NOT NULL DEFAULT 0, `member_level_min` int(11) NOT NULL DEFAULT 0, `vip_only` tinyint(1) NOT NULL DEFAULT 0, `sort` int(11) NOT NULL DEFAULT 0, `status` tinyint(1) NOT NULL DEFAULT 1, `create_time` int(11) unsigned NOT NULL DEFAULT 0, `update_time` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抽奖活动表' [ RunTime:0.010597s ]
CREATE TABLE IF NOT EXISTS `tp_lottery_activity_prize` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `activity_id` int(11) unsigned NOT NULL DEFAULT 0, `name` varchar(100) NOT NULL DEFAULT '', `icon` varchar(500) NOT NULL DEFAULT '', `type` tinyint(1) unsigned NOT NULL DEFAULT 1, `value` decimal(10,2) NOT NULL DEFAULT 0, `service_id` int(11) unsigned NOT NULL DEFAULT 0, `service_spec_id` int(11) unsigned NOT NULL DEFAULT 0, `coupon_id` int(11) unsigned NOT NULL DEFAULT 0, `probability` decimal(10,6) NOT NULL DEFAULT 0, `stock` int(11) NOT NULL DEFAULT -1, `daily_limit` int(11) NOT NULL DEFAULT -1, `color` varchar(20) NOT NULL DEFAULT '#ff4d6a', `sort` int(11) NOT NULL DEFAULT 0, `status` tinyint(1) unsigned 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`), KEY `idx_activity` (`activity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抽奖活动奖品表' [ RunTime:0.008877s ]
CREATE TABLE IF NOT EXISTS `tp_lottery_activity_record` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `activity_id` int(11) unsigned NOT NULL DEFAULT 0, `prize_id` int(11) unsigned NOT NULL DEFAULT 0, `prize_name` varchar(100) NOT NULL DEFAULT '', `prize_type` tinyint(1) unsigned NOT NULL DEFAULT 1, `prize_value` decimal(10,2) NOT NULL DEFAULT 0, `cost` decimal(10,2) NOT NULL DEFAULT 0, `is_free` tinyint(1) unsigned NOT NULL DEFAULT 0, `deliver_status` tinyint(1) unsigned NOT NULL DEFAULT 0, `deliver_time` int(11) unsigned NOT NULL DEFAULT 0, `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_activity` (`activity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抽奖活动记录表' [ RunTime:0.010021s ]
CREATE TABLE IF NOT EXISTS `tp_gift_record` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `master_id` int(11) unsigned NOT NULL DEFAULT 0, `order_id` int(11) unsigned NOT NULL DEFAULT 0, `gift_id` int(11) unsigned NOT NULL DEFAULT 0, `gift_name` varchar(50) NOT NULL DEFAULT '', `gift_icon` varchar(255) NOT NULL DEFAULT '', `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_master_id` (`master_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='礼物打赏记录表' [ RunTime:0.009814s ]
SHOW TABLES LIKE 'tp_gift_log' [ RunTime:0.000896s ]
SHOW TABLES LIKE 'tp_gift_record' [ RunTime:0.000797s ]
SELECT COUNT(*) AS cnt FROM `tp_gift_record` [ RunTime:0.000425s ]
CREATE TABLE IF NOT EXISTS `tp_user_transaction` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0, `type` tinyint(1) NOT NULL DEFAULT 1, `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `title` varchar(100) NOT NULL DEFAULT '', `remark` varchar(255) NOT NULL DEFAULT '', `create_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户交易流水表' [ RunTime:0.007282s ]
CREATE TABLE IF NOT EXISTS `tp_decorate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(20) NOT NULL DEFAULT 'banner', `title` varchar(100) NOT NULL DEFAULT '', `description` varchar(500) DEFAULT '' COMMENT '描述', `image` varchar(255) NOT NULL DEFAULT '', `link` varchar(255) NOT NULL DEFAULT '', `sort` int(10) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, `delete_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='首页装修表' [ RunTime:0.007560s ]
CREATE TABLE IF NOT EXISTS `tp_feedback` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型:1建议 2问题 3投诉', `content` text NOT NULL COMMENT '反馈内容', `images` varchar(1000) DEFAULT '' COMMENT '图片(逗号分隔)', `contact` varchar(100) DEFAULT '' COMMENT '联系方式', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态:0待处理 1处理中 2已处理', `source` tinyint(1) NOT NULL DEFAULT 1 COMMENT '来源:1H5 2小程序', `reply` text COMMENT '回复内容', `reply_time` int(10) DEFAULT NULL COMMENT '回复时间', `admin_id` int(10) DEFAULT NULL COMMENT '处理人', `create_time` int(10) DEFAULT NULL COMMENT '创建时间', `update_time` int(10) DEFAULT NULL COMMENT '更新时间', `delete_time` int(10) DEFAULT NULL COMMENT '软删除时间', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='意见反馈表' [ RunTime:0.007572s ]
CREATE TABLE IF NOT EXISTS `tp_evaluate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(10) unsigned NOT NULL DEFAULT 0, `order_no` varchar(32) NOT NULL DEFAULT '', `from_user_id` int(10) unsigned NOT NULL DEFAULT 0, `to_user_id` int(10) unsigned NOT NULL DEFAULT 0, `score` tinyint(3) unsigned NOT NULL DEFAULT 5, `content` text, `images` text, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, `delete_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评价表' [ RunTime:0.007707s ]
CREATE TABLE IF NOT EXISTS `tp_help_faq` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question` varchar(500) NOT NULL DEFAULT '' COMMENT '问题', `answer` text COMMENT '答案', `sort` int(10) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='常见问题表' [ RunTime:0.007427s ]
CREATE TABLE IF NOT EXISTS `tp_help_feedback` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID', `content` text COMMENT '反馈内容', `reply` text COMMENT '回复内容', `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '状态:0待处理1已回复', `reply_time` int(10) unsigned DEFAULT NULL, `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户反馈表' [ RunTime:0.007435s ]
CREATE TABLE IF NOT EXISTS `tp_master` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '关联用户ID', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号', `order_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '接单数', `good_rate` decimal(5,2) NOT NULL DEFAULT 100.00 COMMENT '好评率', `status` tinyint(3) unsigned NOT NULL DEFAULT 1 COMMENT '状态', `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打手表' [ RunTime:0.007475s ]
CREATE TABLE IF NOT EXISTS `tp_master_verify` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '申请用户ID', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号', `real_name` varchar(50) NOT NULL DEFAULT '' COMMENT '真实姓名', `gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别：0=未设置 1=男 2=女', `tags` varchar(500) NOT NULL DEFAULT '' COMMENT '选择的标签(JSON数组)', `voice_url` varchar(500) NOT NULL DEFAULT '' COMMENT '语音介绍文件URL', `voice_duration` int(11) NOT NULL DEFAULT 0 COMMENT '语音时长(秒)', `id_card` varchar(18) NOT NULL DEFAULT '' COMMENT '身份证号', `agree_protocol` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否同意协议：1=已同意', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT '申请说明', `verify_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '审核状态:0待审核1通过2拒绝', `reject_reason` varchar(255) NOT NULL DEFAULT '' COMMENT '拒绝原因', `verify_time` int(10) unsigned DEFAULT NULL COMMENT '审核时间', `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打手认证申请表' [ RunTime:0.008196s ]
SHOW COLUMNS FROM `tp_decorate` [ RunTime:0.000895s ]
SHOW COLUMNS FROM `tp_master` [ RunTime:0.000760s ]
SHOW COLUMNS FROM `tp_master_verify` [ RunTime:0.000796s ]
CREATE TABLE IF NOT EXISTS `tp_member_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `level` int(11) NOT NULL DEFAULT 0 COMMENT '等级（1~10）', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '等级名称（如青铜会员）', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '等级图标', `bg_color` varchar(30) NOT NULL DEFAULT '#666666' COMMENT '等级背景色', `need_exp` int(11) NOT NULL DEFAULT 0 COMMENT '升到该级所需累计经验值', `discount` decimal(3,1) NOT NULL DEFAULT 10.0 COMMENT '购物折扣（10=无折扣，9.5=95折）', `lottery_extra` int(11) NOT NULL DEFAULT 0 COMMENT '每日额外免费抽奖次数', `privilege_desc` varchar(500) NOT NULL DEFAULT '' COMMENT '等级特权描述', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0=禁用 1=启用', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uniq_level` (`level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员等级配置表' [ RunTime:0.009811s ]
CREATE TABLE IF NOT EXISTS `tp_miniapp_component` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '' COMMENT '组件名称', `type` varchar(50) NOT NULL DEFAULT '' COMMENT '组件类型', `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '组件图标', `category` varchar(30) NOT NULL DEFAULT 'basic' COMMENT '分类', `default_config` text COMMENT '默认配置JSON', `schema` text COMMENT '配置表单schema', `sort` int(10) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序组件库表' [ RunTime:0.008486s ]
CREATE TABLE IF NOT EXISTS `tp_miniapp_style` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `style_key` varchar(50) NOT NULL DEFAULT '', `style_name` varchar(50) NOT NULL DEFAULT '', `style_value` text COMMENT '样式值', `category` varchar(30) NOT NULL DEFAULT 'color', `sort` int(10) unsigned NOT NULL DEFAULT 0, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_style_key` (`style_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序全局样式表' [ RunTime:0.007986s ]
CREATE TABLE IF NOT EXISTS `tp_miniapp_theme` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `config` longtext COMMENT '主题配置JSON', `preview` varchar(255) NOT NULL DEFAULT '', `is_default` tinyint(3) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序主题表' [ RunTime:0.007865s ]
CREATE TABLE IF NOT EXISTS `tp_miniapp_page` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `page_key` varchar(50) NOT NULL DEFAULT '' COMMENT '页面标识', `page_name` varchar(50) NOT NULL DEFAULT '' COMMENT '页面名称', `components` longtext COMMENT '组件配置JSON', `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_page_key` (`page_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小程序页面配置表' [ RunTime:0.007156s ]
SHOW COLUMNS FROM `tp_miniapp_component` [ RunTime:0.000930s ]
SHOW COLUMNS FROM `tp_miniapp_style` [ RunTime:0.000847s ]
SHOW COLUMNS FROM `tp_miniapp_theme` [ RunTime:0.000763s ]
SHOW COLUMNS FROM `tp_miniapp_page` [ RunTime:0.000746s ]
SHOW TABLES LIKE 'tp_miniapp_page' [ RunTime:0.000816s ]
SHOW INDEX FROM `tp_miniapp_page` [ RunTime:0.000478s ]
SHOW TABLES LIKE 'tp_miniapp_style' [ RunTime:0.000753s ]
SHOW INDEX FROM `tp_miniapp_style` [ RunTime:0.000439s ]
CREATE TABLE IF NOT EXISTS `tp_reset_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `admin_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '操作人', `type` varchar(20) NOT NULL DEFAULT '' COMMENT '重置类型', `content` varchar(500) NOT NULL DEFAULT '' COMMENT '重置内容', `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP地址', `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='重置记录表' [ RunTime:0.007406s ]
CREATE TABLE IF NOT EXISTS `tp_recharge_package` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '' COMMENT '套餐名称', `amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '充值金额', `give_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '赠送金额', `sort` int(10) unsigned NOT NULL DEFAULT 0, `status` tinyint(3) unsigned NOT NULL DEFAULT 1, `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值套餐表' [ RunTime:0.007343s ]
CREATE TABLE IF NOT EXISTS `tp_recharge_record` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID', `order_no` varchar(50) NOT NULL COMMENT '订单号', `pay_order_no` varchar(100) DEFAULT NULL COMMENT '支付订单号', `amount` decimal(10,2) NOT NULL COMMENT '充值金额', `gift_amount` decimal(10,2) DEFAULT 0.00 COMMENT '赠送金额', `pay_type` varchar(50) DEFAULT '' COMMENT '支付类型', `status` tinyint(3) unsigned DEFAULT 0 COMMENT '状态:0待支付,1已支付,2已取消', `pay_time` int(10) unsigned DEFAULT NULL COMMENT '支付时间', `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_order_no` (`order_no`), KEY `idx_user_id` (`user_id`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值记录表' [ RunTime:0.007377s ]
CREATE TABLE IF NOT EXISTS `tp_reward` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `from_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '打赏者', `to_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '接收者', `gift_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '礼物ID', `num` int(10) unsigned NOT NULL DEFAULT 1 COMMENT '数量', `amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '金额', `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打赏记录表' [ RunTime:0.007268s ]
CREATE TABLE IF NOT EXISTS `tp_service_extra` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `service_id` int(10) unsigned NOT NULL DEFAULT 0, `name` varchar(100) NOT NULL DEFAULT '', `price` decimal(10,2) NOT NULL DEFAULT 0.00, `sort` int(10) unsigned NOT NULL DEFAULT 0, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, `delete_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_service_id` (`service_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务增值服务表' [ RunTime:0.008604s ]
CREATE TABLE IF NOT EXISTS `tp_system_config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(50) NOT NULL COMMENT '配置分组', `key_name` varchar(100) NOT NULL COMMENT '配置键名', `value` text COMMENT '配置值', `type` varchar(20) DEFAULT 'text' COMMENT '类型:text,textarea,number,radio,checkbox,image', `title` varchar(100) DEFAULT '' COMMENT '配置标题', `description` varchar(255) DEFAULT '' COMMENT '配置说明', `sort` int(10) unsigned DEFAULT 0 COMMENT '排序', `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_group_key` (`group_name`,`key_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统配置表' [ RunTime:0.009848s ]
CREATE TABLE IF NOT EXISTS `tp_upgrade_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `platform` varchar(20) NOT NULL DEFAULT '' COMMENT '平台:android/ios', `version` varchar(20) NOT NULL DEFAULT '' COMMENT '版本号', `device_info` varchar(500) NOT NULL DEFAULT '' COMMENT '设备信息', `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP地址', `create_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='APP升级记录表' [ RunTime:0.008654s ]
CREATE TABLE IF NOT EXISTS `tp_user_cancel` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `reason` text, `status` tinyint(3) unsigned NOT NULL DEFAULT 0, `remark` varchar(500) NOT NULL DEFAULT '', `reject_reason` varchar(255) DEFAULT NULL COMMENT '拒绝原因', `admin_id` int(10) unsigned DEFAULT NULL, `audit_time` int(11) DEFAULT NULL COMMENT '审核时间', `handle_time` int(10) unsigned DEFAULT NULL, `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(11) DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户注销申请表' [ RunTime:0.009026s ]
CREATE TABLE IF NOT EXISTS `tp_user_exp_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID', `type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '来源类型：1=签到 2=在线时长 3=消费 4=下单 5=系统调整 6=VIP购买', `exp` int(11) NOT NULL DEFAULT 0 COMMENT '经验值变动（正=获得，负=扣除）', `total_exp` int(11) NOT NULL DEFAULT 0 COMMENT '变动后的总经验', `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注', `create_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_type` (`type`), KEY `idx_create_time` (`create_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='经验值变动记录表' [ RunTime:0.009727s ]
CREATE TABLE IF NOT EXISTS `tp_user_sign_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID', `exp` int(11) NOT NULL DEFAULT 0 COMMENT '本次获得经验', `sign_date` date NOT NULL COMMENT '签到日期', `consecutive_days` int(11) NOT NULL DEFAULT 1 COMMENT '当前连续签到天数', `create_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uniq_user_sign` (`user_id`,`sign_date`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='签到记录表' [ RunTime:0.009099s ]
CREATE TABLE IF NOT EXISTS `tp_vip_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '' COMMENT '套餐名称（月卡/季卡/年卡）', `duration` int(11) NOT NULL DEFAULT 30 COMMENT '有效天数', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '价格（元）', `original_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '原价', `exp_multiplier` decimal(3,1) NOT NULL DEFAULT 2.0 COMMENT '经验倍率', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '套餐图标', `privilege_desc` varchar(500) NOT NULL DEFAULT '' COMMENT '特权说明', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='VIP套餐配置表' [ RunTime:0.009165s ]
CREATE TABLE IF NOT EXISTS `tp_player_rating` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `score` tinyint(1) DEFAULT 5, `content` varchar(500) DEFAULT '', `create_time` int(11) DEFAULT 0, PRIMARY KEY (`id`), KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='陪玩评分表' [ RunTime:0.007231s ]
CREATE TABLE IF NOT EXISTS `tp_player_verify` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '申请用户ID', `nickname` varchar(100) NOT NULL DEFAULT '' COMMENT '昵称', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号', `remark` varchar(500) NOT NULL DEFAULT '' COMMENT '申请说明', `verify_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0待审核 1已通过 2已拒绝', `reject_reason` varchar(255) NOT NULL DEFAULT '' COMMENT '拒绝原因', `verify_time` int(11) NOT NULL DEFAULT 0 COMMENT '审核时间', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间', `real_name` varchar(50) NOT NULL DEFAULT '' COMMENT '真实姓名', `gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别 0未设置 1男 2女', `tags` varchar(500) NOT NULL DEFAULT '' COMMENT '标签JSON数组', `voice_url` varchar(500) NOT NULL DEFAULT '' COMMENT '语音介绍URL', `voice_duration` int(11) NOT NULL DEFAULT 0 COMMENT '语音时长秒', `id_card` varchar(18) NOT NULL DEFAULT '' COMMENT '身份证号', `agree_protocol` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否同意协议', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_verify_status` (`verify_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='陪玩认证审核表' [ RunTime:0.007776s ]
CREATE TABLE IF NOT EXISTS `tp_user_fighter_info` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL COMMENT '关联用户ID', `level` int(10) unsigned DEFAULT 1 COMMENT '打手等级', `skill` varchar(255) DEFAULT '' COMMENT '擅长技能', `price` decimal(10,2) DEFAULT 0.00 COMMENT '接单价格', `order_count` int(10) unsigned DEFAULT 0 COMMENT '接单数', `score` decimal(3,2) DEFAULT 5.00 COMMENT '评分', `cert_images` text COMMENT '认证图片JSON', `create_time` int(10) unsigned DEFAULT NULL, `update_time` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='打手扩展信息表' [ RunTime:0.007816s ]
CREATE TABLE IF NOT EXISTS `tp_user_withdraw` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '用户ID', `amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现金额', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态：0待审核 1已通过 2已拒绝 3已打款', `remark` varchar(255) DEFAULT '' COMMENT '备注/拒绝原因', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '申请时间', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户提现记录表' [ RunTime:0.008292s ]
CREATE TABLE IF NOT EXISTS `tp_chat_intervention` ( `id` int(11) NOT NULL AUTO_INCREMENT, `session_id` int(11) NOT NULL COMMENT '聊天会话ID', `requester_type` tinyint(1) NOT NULL COMMENT '请求者类型: 1用户 2陪玩/打手', `requester_id` int(11) NOT NULL COMMENT '请求者ID', `reason` varchar(500) DEFAULT '' COMMENT '介入原因', `status` tinyint(1) DEFAULT 0 COMMENT '状态: 0待处理 1处理中 2已解决 3已关闭', `admin_id` int(11) DEFAULT 0 COMMENT '处理客服ID', `admin_name` varchar(50) DEFAULT '' COMMENT '处理客服名称', `result` varchar(500) DEFAULT '' COMMENT '处理结果', `create_time` int(11) DEFAULT NULL COMMENT '创建时间', `accept_time` int(11) DEFAULT NULL COMMENT '接入时间', `close_time` int(11) DEFAULT NULL COMMENT '关闭时间', `update_time` int(11) DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_session_id` (`session_id`), KEY `idx_status` (`status`), KEY `idx_admin_id` (`admin_id`), KEY `idx_create_time` (`create_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客服介入请求表' [ RunTime:0.010331s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.001157s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000894s ]
SHOW COLUMNS FROM `tp_chat_session` [ RunTime:0.000858s ]
SHOW TABLES LIKE 'tp_chat_session' [ RunTime:0.000808s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000896s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000852s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000820s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000804s ]
SHOW COLUMNS FROM `tp_chat_message` [ RunTime:0.000801s ]
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.010563s ]
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.010103s ]
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.010501s ]
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.009819s ]
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.007290s ]
SHOW COLUMNS FROM `tp_admin` [ RunTime:0.000955s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.000928s ]
SHOW COLUMNS FROM `tp_tenant` [ RunTime:0.000897s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000912s ]
SHOW COLUMNS FROM `tp_tenant_bill` [ RunTime:0.000882s ]
SHOW COLUMNS FROM `tp_config` [ RunTime:0.000739s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000812s ]
SHOW INDEX FROM `tp_config` [ RunTime:0.000464s ]
SHOW TABLES LIKE 'tp_tenant' [ RunTime:0.000776s ]
SELECT * FROM `tp_tenant` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000575s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000826s ]
SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000846s ]
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.000678s ]
SHOW TABLES LIKE 'tp_config' [ RunTime:0.000809s ]
SELECT `value`,`name` FROM `tp_config` WHERE `tenant_id` = 1 AND `name` IN ('player_enabled','fighter_enabled','merchant_enabled','manager_enabled') [ RunTime:0.000555s ]

创建账号