-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- 主机： bdqr_mysql
-- 生成日期： 2025-12-30 09:58:52
-- 服务器版本： 8.0.34
-- PHP 版本： 8.2.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */
;
/*!40101 SET NAMES utf8mb4 */
;

--
-- 数据库： `bdqr`
--

-- --------------------------------------------------------

--
-- 表的结构 `admin_api`
--

CREATE TABLE `admin_api` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `api_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '接口名称',
    `api_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '接口编码',
    `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求方法：GET、POST等',
    `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '接口URL',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '接口描述'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接口表';

--
-- 转存表中的数据 `admin_api`
--

INSERT INTO
    `admin_api` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_name`,
        `api_code`,
        `method`,
        `url`,
        `status`,
        `description`
    )
VALUES (
        '0049c594-e08c-40b0-a974-95ea0b3ee92c',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-link-列表',
        'get__api_v1_admin_agent_agent-link_list',
        'GET',
        '/api/v1/admin/agent/agent-link/list',
        1,
        '查询agent-link-列表'
    ),
    (
        '014ae5fc-cd0e-44d5-9eeb-797fbb695019',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '通知管理-列表',
        'get__api_v1_admin_notification_list',
        'GET',
        '/api/v1/admin/notification/list',
        1,
        '查询通知管理-列表'
    ),
    (
        '02cefbdc-dbc6-4173-8478-38a494a60a01',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_role_delete',
        'DELETE',
        '/api/v1/admin/role/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '02f687f7-5840-443c-976f-5ba5bf7769a2',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_order_update',
        'PUT',
        '/api/v1/admin/order/update/:id',
        1,
        '更新update-:id'
    ),
    (
        '04c6c7f4-d929-4757-a307-f5fb4ad552a1',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-列表',
        'get__api_v1_admin_role_api_list',
        'GET',
        '/api/v1/admin/role/:role_id/api/list',
        1,
        '查询api-列表'
    ),
    (
        '051985e7-4fe6-4f26-b24c-c7d8954fec85',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '产品管理-创建',
        'post__api_v1_admin_product_create',
        'POST',
        '/api/v1/admin/product/create',
        1,
        '创建产品管理-创建'
    ),
    (
        '0ac38277-18a8-47bf-ae91-534bd6cc886f',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_product_update',
        'PUT',
        '/api/v1/admin/product/update/:id',
        1,
        '更新update-:id'
    ),
    (
        '0f9781fe-f7aa-4cbe-a3c4-c502838e92d6',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_menu_update',
        'PUT',
        '/api/v1/admin/menu/update/:id',
        1,
        '更新update-:id'
    ),
    (
        '0fc0708c-adc3-4e12-ad62-2e099e303ff5',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'product_config-列表',
        'get__api_v1_admin_agent_product_config_list',
        'GET',
        '/api/v1/admin/agent/product_config/list',
        1,
        '查询product_config-列表'
    ),
    (
        '0fc981be-b3c5-4964-bbef-ac1cb410a63f',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-remove',
        'post__api_v1_admin_role_api_remove',
        'POST',
        '/api/v1/admin/role/api/remove',
        1,
        '创建api-remove'
    ),
    (
        '11603b40-789c-4f71-816d-95ec03ab0de4',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-更新',
        'put__api_v1_admin_role_api_update',
        'PUT',
        '/api/v1/admin/role/api/update',
        1,
        '更新api-更新'
    ),
    (
        '18733bdb-ff4f-4088-bfce-ac8cf66513fd',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '平台用户-列表',
        'get__api_v1_admin_platform_user_list',
        'GET',
        '/api/v1/admin/platform_user/list',
        1,
        '查询平台用户-列表'
    ),
    (
        '1a366316-5291-41c3-9410-a9a80b7be416',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '平台用户-创建',
        'post__api_v1_admin_platform_user_create',
        'POST',
        '/api/v1/admin/platform_user/create',
        1,
        '创建平台用户-创建'
    ),
    (
        '1e6ff909-406a-4622-92a1-a8f96b4452fa',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_promotion_link_update',
        'PUT',
        '/api/v1/admin/promotion/link/update/:id',
        1,
        '更新update-:id'
    ),
    (
        '25031ae7-aca3-489e-84dd-99d2ae6bfa9e',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'rebate-列表',
        'get__api_v1_admin_agent_rebate_list',
        'GET',
        '/api/v1/admin/agent/rebate/list',
        1,
        '查询rebate-列表'
    ),
    (
        '27f8a5af-5578-4891-b866-c7bad8114c3d',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'link-创建',
        'post__api_v1_admin_promotion_link_create',
        'POST',
        '/api/v1/admin/promotion/link/create',
        1,
        '创建link-创建'
    ),
    (
        '28c7d4b7-51cc-4ca7-a39a-a906857db9df',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_promotion_link_delete',
        'DELETE',
        '/api/v1/admin/promotion/link/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '292849f3-31d8-4cc2-99d1-9b6dcc51c050',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'refund-:id',
        'post__api_v1_admin_order_refund',
        'POST',
        '/api/v1/admin/order/refund/:id',
        1,
        '创建refund-:id'
    ),
    (
        '2943ed7e-35e5-45a3-8c59-b94dab7b082c',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_feature_delete',
        'DELETE',
        '/api/v1/admin/feature/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '2981b72e-878c-4a55-aa77-2cecdacc5e0b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_platform_user_detail',
        'GET',
        '/api/v1/admin/platform_user/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '32d4796a-3655-4140-8cd6-7d6de5e2e13b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-production-config-列表',
        'get__api_v1_admin_agent_agent-production-config_list',
        'GET',
        '/api/v1/admin/agent/agent-production-config/list',
        1,
        '查询agent-production-config-列表'
    ),
    (
        '34dac3bb-0983-49e8-840d-9d75dd3a083e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_feature_detail',
        'GET',
        '/api/v1/admin/feature/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '34e5486e-af8c-48cb-8862-693184812d11',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-reward-列表',
        'get__api_v1_admin_agent_agent-reward_list',
        'GET',
        '/api/v1/admin/agent/agent-reward/list',
        1,
        '查询agent-reward-列表'
    ),
    (
        '3c1b52a8-913d-4a82-a201-6ebee1dd4615',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '功能管理-config-example',
        'post__api_v1_admin_feature_config-example',
        'POST',
        '/api/v1/admin/feature/config-example',
        1,
        '创建功能管理-config-example'
    ),
    (
        '3d0bdb6d-356a-439a-bb99-c987fdf85604',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-assign',
        'post__api_v1_admin_role_api_assign',
        'POST',
        '/api/v1/admin/role/api/assign',
        1,
        '创建api-assign'
    ),
    (
        '3d5d7334-2976-4c27-aea2-53cd0e599478',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '订单管理-创建',
        'post__api_v1_admin_order_create',
        'POST',
        '/api/v1/admin/order/create',
        1,
        '创建订单管理-创建'
    ),
    (
        '3ec30907-acfa-4855-a1ca-9a480d0bbbf3',
        '2025-10-24 15:42:28',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'retry-agent-process-:id',
        'post__api_v1_admin_order_retry-agent-process',
        'POST',
        '/api/v1/admin/order/retry-agent-process/:id',
        1,
        '创建retry-agent-process-:id'
    ),
    (
        '442e53a2-5af6-4e6b-8996-e34748294381',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_user_detail',
        'GET',
        '/api/v1/admin/user/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '4efa5b1f-5412-40f5-8a5e-bec95a910054',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'link-列表',
        'get__api_v1_admin_agent_link_list',
        'GET',
        '/api/v1/admin/agent/link/list',
        1,
        '查询link-列表'
    ),
    (
        '5136e206-153a-4e0d-acff-09d48baeb133',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'health-check',
        'get__api_v1_health_check',
        'GET',
        '/api/v1/health/check',
        1,
        '查询health-check'
    ),
    (
        '51eb9576-786b-43d9-9558-e3f2371e2a82',
        '2025-12-01 16:21:00',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '/s/:shortCode',
        'get__s',
        'GET',
        '/s/:shortCode',
        1,
        '查询/s/:shortCode'
    ),
    (
        '55408cc1-6f7e-4011-a66f-e832e16e19de',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'real_name-列表',
        'get__api_v1_admin_agent_real_name_list',
        'GET',
        '/api/v1/admin/agent/real_name/list',
        1,
        '查询real_name-列表'
    ),
    (
        '55c67553-73ef-406c-b167-a27b9651421e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'reset-password-:id',
        'put__api_v1_admin_user_reset-password',
        'PUT',
        '/api/v1/admin/user/reset-password/:id',
        1,
        '更新reset-password-:id'
    ),
    (
        '56444111-6297-40a0-be9f-5ce5508dfb45',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-commission-deduction-列表',
        'get__api_v1_admin_agent_agent-commission-deduction_list',
        'GET',
        '/api/v1/admin/agent/agent-commission-deduction/list',
        1,
        '查询agent-commission-deduction-列表'
    ),
    (
        '576f8cef-7d29-46db-b525-c944a8eb1016',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'link-列表',
        'get__api_v1_admin_promotion_link_list',
        'GET',
        '/api/v1/admin/promotion/link/list',
        1,
        '查询link-列表'
    ),
    (
        '5a4be769-13da-45d5-932c-bfbb43ba7108',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '产品管理-列表',
        'get__api_v1_admin_product_list',
        'GET',
        '/api/v1/admin/product/list',
        1,
        '查询产品管理-列表'
    ),
    (
        '5cd92b66-0ae2-4f89-904a-5330094a5585',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'invite_code-列表',
        'get__api_v1_admin_agent_invite_code_list',
        'GET',
        '/api/v1/admin/agent/invite_code/list',
        1,
        '查询invite_code-列表'
    ),
    (
        '5e6bd2ba-a681-4c99-b222-2078d4436172',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-列表',
        'get__api_v1_admin_api_list',
        'GET',
        '/api/v1/admin/api/list',
        1,
        '查询api-列表'
    ),
    (
        '613e8b71-bd27-4c73-93d6-737cc4fa2fd0',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_product_delete',
        'DELETE',
        '/api/v1/admin/product/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '623db129-f1e9-4123-a2a1-36cb03f140d4',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '菜单管理-列表',
        'get__api_v1_admin_menu_list',
        'GET',
        '/api/v1/admin/menu/list',
        1,
        '查询菜单管理-列表'
    ),
    (
        '6ba67191-6abe-4b5f-b502-289db04e7d6e',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-commission-列表',
        'get__api_v1_admin_agent_agent-commission_list',
        'GET',
        '/api/v1/admin/agent/agent-commission/list',
        1,
        '查询agent-commission-列表'
    ),
    (
        '6bfb8815-b6df-4e7c-b23d-be662ba33168',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '角色管理-创建',
        'post__api_v1_admin_role_create',
        'POST',
        '/api/v1/admin/role/create',
        1,
        '创建角色管理-创建'
    ),
    (
        '6d0ea2c2-830d-4aa6-80f2-542508471281',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'withdrawal-audit',
        'post__api_v1_admin_agent_withdrawal_audit',
        'POST',
        '/api/v1/admin/agent/withdrawal/audit',
        1,
        '创建withdrawal-audit'
    ),
    (
        '721c0530-5091-4df0-bbcb-bd2ab6b38355',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'example-:feature_id',
        'get__api_v1_admin_feature_example',
        'GET',
        '/api/v1/admin/feature/example/:feature_id',
        1,
        '查询example-:feature_id'
    ),
    (
        '72b72deb-3799-4666-affd-cee0875862f2',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '功能管理-创建',
        'post__api_v1_admin_feature_create',
        'POST',
        '/api/v1/admin/feature/create',
        1,
        '创建功能管理-创建'
    ),
    (
        '79b79424-2cac-4c67-93f7-7f97af2b4ab1',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-platform-deduction-列表',
        'get__api_v1_admin_agent_agent-platform-deduction_list',
        'GET',
        '/api/v1/admin/agent/agent-platform-deduction/list',
        1,
        '查询agent-platform-deduction-列表'
    ),
    (
        '7b428368-7faf-4b42-8379-a097f812d72e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:product_id',
        'put__api_v1_admin_product_feature_update',
        'PUT',
        '/api/v1/admin/product/feature/update/:product_id',
        1,
        '更新update-:product_id'
    ),
    (
        '7ebd833e-daf7-46a2-b43d-5c8d745a9cf9',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '菜单管理-all',
        'get__api_v1_admin_menu_all',
        'GET',
        '/api/v1/admin/menu/all',
        1,
        '查询菜单管理-all'
    ),
    (
        '8090f044-a8a7-42f5-95c8-7d751359a5db',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '代理管理-配置',
        'get__api_v1_admin_agent_config',
        'GET',
        '/api/v1/admin/agent/config',
        1,
        '查询代理管理-配置'
    ),
    (
        '853ab285-97f6-47dd-9cbc-4a1bd2d0ff36',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_promotion_link_detail',
        'GET',
        '/api/v1/admin/promotion/link/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '89620aef-7bb3-4f50-a8e1-954e82afcc59',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '角色管理-列表',
        'get__api_v1_admin_role_list',
        'GET',
        '/api/v1/admin/role/list',
        1,
        '查询角色管理-列表'
    ),
    (
        '922f692d-263c-4709-b4fd-868194039d17',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_user_delete',
        'DELETE',
        '/api/v1/admin/user/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '934edf8a-c17a-436a-9454-de011da272ca',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_notification_delete',
        'DELETE',
        '/api/v1/admin/notification/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '946a84e8-8a3d-4a3c-99c2-37969a5bc3ca',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_role_detail',
        'GET',
        '/api/v1/admin/role/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '952325a3-0107-40ff-bd12-25cf9fa8becb',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-all',
        'get__api_v1_admin_api_all',
        'GET',
        '/api/v1/admin/api/all',
        1,
        '查询api-all'
    ),
    (
        '95fb06fd-0522-4f7a-92b3-f9dfacaafb7e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_menu_delete',
        'DELETE',
        '/api/v1/admin/menu/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '9bb88e73-b682-4fca-8455-833e639eb67e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:order_id',
        'get__api_v1_admin_query_detail',
        'GET',
        '/api/v1/admin/query/detail/:order_id',
        1,
        '查询detail-:order_id'
    ),
    (
        '9c90e879-2f35-497b-b311-b2e21714f5e0',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_order_delete',
        'DELETE',
        '/api/v1/admin/order/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        '9cc7290d-bbf7-4842-9155-6166780841d8',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'cleanup-configs',
        'get__api_v1_admin_query_cleanup_configs',
        'GET',
        '/api/v1/admin/query/cleanup/configs',
        1,
        '查询cleanup-configs'
    ),
    (
        '9da2a0b9-eb68-40c2-b835-2e030042425b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_order_detail',
        'GET',
        '/api/v1/admin/order/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        '9f862d08-6751-4fab-a1b5-fc00a31c8190',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'product_config-更新',
        'post__api_v1_admin_agent_product_config_update',
        'POST',
        '/api/v1/admin/agent/product_config/update',
        1,
        '创建product_config-更新'
    ),
    (
        'a3002c91-cd99-4b99-b5bc-6440e6a9e4c5',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '代理管理-列表',
        'get__api_v1_admin_agent_list',
        'GET',
        '/api/v1/admin/agent/list',
        1,
        '查询代理管理-列表'
    ),
    (
        'a41e3af6-e846-4675-8bf0-3aaa6d78a05a',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'withdrawal-列表',
        'get__api_v1_admin_agent_withdrawal_list',
        'GET',
        '/api/v1/admin/agent/withdrawal/list',
        1,
        '查询withdrawal-列表'
    ),
    (
        'a49fae63-7b05-47ea-9246-ac96d016e88e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_platform_user_delete',
        'DELETE',
        '/api/v1/admin/platform_user/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        'a6bfa982-8170-447c-91fb-40a1808019eb',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-membership-config-更新',
        'post__api_v1_admin_agent_agent-membership-config_update',
        'POST',
        '/api/v1/admin/agent/agent-membership-config/update',
        1,
        '创建agent-membership-config-更新'
    ),
    (
        'b307281a-a7a2-4bf9-bbd6-497b66ffdf66',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'cleanup-配置',
        'put__api_v1_admin_query_cleanup_config',
        'PUT',
        '/api/v1/admin/query/cleanup/config',
        1,
        '更新cleanup-配置'
    ),
    (
        'b6955079-3030-429c-bec8-f64eff389335',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '用户管理-列表',
        'get__api_v1_admin_user_list',
        'GET',
        '/api/v1/admin/user/list',
        1,
        '查询用户管理-列表'
    ),
    (
        'bb4ffbf5-eb16-4481-a3d7-a5d3f2443923',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '通知管理-创建',
        'post__api_v1_admin_notification_create',
        'POST',
        '/api/v1/admin/notification/create',
        1,
        '创建通知管理-创建'
    ),
    (
        'bb914a84-90f7-4739-a514-f4604cad4927',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'list-:product_id',
        'get__api_v1_admin_product_feature_list',
        'GET',
        '/api/v1/admin/product/feature/list/:product_id',
        1,
        '查询list-:product_id'
    ),
    (
        'bc502f9e-3f0a-4e48-ba45-0f4849d3a159',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-production-config-更新',
        'post__api_v1_admin_agent_agent-production-config_update',
        'POST',
        '/api/v1/admin/agent/agent-production-config/update',
        1,
        '创建agent-production-config-更新'
    ),
    (
        'be7212bd-fb70-48a2-927b-6fa36fef2f73',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '代理管理-audit',
        'post__api_v1_admin_agent_audit',
        'POST',
        '/api/v1/admin/agent/audit',
        1,
        '创建代理管理-audit'
    ),
    (
        'c2b0c6e1-5866-483f-b9a6-3e0634329d58',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'upgrade-列表',
        'get__api_v1_admin_agent_upgrade_list',
        'GET',
        '/api/v1/admin/agent/upgrade/list',
        1,
        '查询upgrade-列表'
    ),
    (
        'c3793fbe-c0ff-4f3c-b476-b826dc527d30',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'details-:log_id',
        'get__api_v1_admin_query_cleanup_details',
        'GET',
        '/api/v1/admin/query/cleanup/details/:log_id',
        1,
        '查询details-:log_id'
    ),
    (
        'c3db7059-d8bc-43f2-9251-eb00b6a4d4b5',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'commission-列表',
        'get__api_v1_admin_agent_commission_list',
        'GET',
        '/api/v1/admin/agent/commission/list',
        1,
        '查询commission-列表'
    ),
    (
        'c5b69231-7864-4698-abe3-a7c980d13996',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_product_detail',
        'GET',
        '/api/v1/admin/product/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        'c6bb604b-1bb7-4c39-90e0-5fcf62ed8aa7',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-membership-recharge-order-列表',
        'get__api_v1_admin_agent_agent-membership-recharge-order_list',
        'GET',
        '/api/v1/admin/agent/agent-membership-recharge-order/list',
        1,
        '查询agent-membership-recharge-order-列表'
    ),
    (
        'c7be4ca9-8a85-4c45-90eb-4df247748f64',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'stats-history',
        'get__api_v1_admin_promotion_stats_history',
        'GET',
        '/api/v1/admin/promotion/stats/history',
        1,
        '查询stats-history'
    ),
    (
        'c9f32092-59ea-4b1d-aa74-587608e61be3',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_notification_update',
        'PUT',
        '/api/v1/admin/notification/update/:id',
        1,
        '更新update-:id'
    ),
    (
        'cd6271c0-33ac-44f8-a6ba-1cd90cd93599',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '功能管理-列表',
        'get__api_v1_admin_feature_list',
        'GET',
        '/api/v1/admin/feature/list',
        1,
        '查询功能管理-列表'
    ),
    (
        'cdf6de3b-8ef7-4378-8ce1-ea1200e9520a',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_role_update',
        'PUT',
        '/api/v1/admin/role/update/:id',
        1,
        '更新update-:id'
    ),
    (
        'ce0e10ad-b96d-4843-a221-d440cdec9a8b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_api_detail',
        'GET',
        '/api/v1/admin/api/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        'ce4984ad-861a-49cd-958d-806a1fc59af9',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'config-更新',
        'post__api_v1_admin_agent_config_update',
        'POST',
        '/api/v1/admin/agent/config/update',
        1,
        '创建config-更新'
    ),
    (
        'd14cd985-cfb8-44d0-8efb-4701a995970c',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-batch-update-status',
        'put__api_v1_admin_api_batch-update-status',
        'PUT',
        '/api/v1/admin/api/batch-update-status',
        1,
        '更新api-batch-update-status'
    ),
    (
        'd1a7de7c-bcf1-4bbd-8e5e-5dc21f900a5d',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '订单管理-列表',
        'get__api_v1_admin_agent_order_list',
        'GET',
        '/api/v1/admin/agent/order/list',
        1,
        '查询订单管理-列表'
    ),
    (
        'd1db6abc-af82-4b1a-b374-acb831970d1b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_platform_user_update',
        'PUT',
        '/api/v1/admin/platform_user/update/:id',
        1,
        '更新update-:id'
    ),
    (
        'd43288d3-5bfe-4ac4-8bf3-2fc16586c06c',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'record-:path',
        'get__api_v1_admin_promotion_link_record',
        'GET',
        '/api/v1/admin/promotion/link/record/:path',
        1,
        '查询record-:path'
    ),
    (
        'd85363e9-f601-44a5-a857-e92df7148d1b',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'delete-:id',
        'delete__api_v1_admin_api_delete',
        'DELETE',
        '/api/v1/admin/api/delete/:id',
        1,
        '删除delete-:id'
    ),
    (
        'db435bd3-44f9-4bc1-948f-35f724bea0e0',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'cleanup-logs',
        'get__api_v1_admin_query_cleanup_logs',
        'GET',
        '/api/v1/admin/query/cleanup/logs',
        1,
        '查询cleanup-logs'
    ),
    (
        'db8d5560-2ac8-47c9-bf6a-8d1ab9100409',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_menu_detail',
        'GET',
        '/api/v1/admin/menu/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        'de2d063f-1bac-44dd-9cfa-2b1f8732d7fe',
        '2025-11-27 12:56:55',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'diamond-generate',
        'post__api_v1_admin_agent_invite_code_diamond_generate',
        'POST',
        '/api/v1/admin/agent/invite_code/diamond/generate',
        1,
        '创建diamond-generate'
    ),
    (
        'de7bde21-3b8d-48af-aa48-00b5f6043765',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_user_update',
        'PUT',
        '/api/v1/admin/user/update/:id',
        1,
        '更新update-:id'
    ),
    (
        'e12d5ec4-2ec5-4db4-be88-713defc54b6e',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'detail-:id',
        'get__api_v1_admin_notification_detail',
        'GET',
        '/api/v1/admin/notification/detail/:id',
        1,
        '查询detail-:id'
    ),
    (
        'e65c94e9-279d-4291-9a1c-56d6f750290c',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '用户管理-创建',
        'post__api_v1_admin_user_create',
        'POST',
        '/api/v1/admin/user/create',
        1,
        '创建用户管理-创建'
    ),
    (
        'e861ec85-5420-45a3-a8a6-b71a6f281fd5',
        '2025-09-30 17:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-membership-config-列表',
        'get__api_v1_admin_agent_agent-membership-config_list',
        'GET',
        '/api/v1/admin/agent/agent-membership-config/list',
        1,
        '查询agent-membership-config-列表'
    ),
    (
        'eca9b634-cad8-4617-a61b-bb7d83386fd0',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'api-创建',
        'post__api_v1_admin_api_create',
        'POST',
        '/api/v1/admin/api/create',
        1,
        '创建api-创建'
    ),
    (
        'ef403ac3-be87-415b-b16f-402d0a7279d8',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'agent-withdrawal-列表',
        'get__api_v1_admin_agent_agent-withdrawal_list',
        'GET',
        '/api/v1/admin/agent/agent-withdrawal/list',
        1,
        '查询agent-withdrawal-列表'
    ),
    (
        'f0994586-1778-4cc6-bf8b-ab7972d62191',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '菜单管理-创建',
        'post__api_v1_admin_menu_create',
        'POST',
        '/api/v1/admin/menu/create',
        1,
        '创建菜单管理-创建'
    ),
    (
        'f25cd690-bb3f-45e6-9646-cc408c2ff059',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '用户管理-info',
        'get__api_v1_admin_user_info',
        'GET',
        '/api/v1/admin/user/info',
        1,
        '查询用户管理-info'
    ),
    (
        'f4d2422f-5e55-4fbb-939b-a777984b86bb',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '订单管理-列表',
        'get__api_v1_admin_order_list',
        'GET',
        '/api/v1/admin/order/list',
        1,
        '查询订单管理-列表'
    ),
    (
        'f6645bbd-32a8-4386-a289-0c9b1f529a92',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'stats-total',
        'get__api_v1_admin_promotion_stats_total',
        'GET',
        '/api/v1/admin/promotion/stats/total',
        1,
        '查询stats-total'
    ),
    (
        'f78bf038-2423-4b9c-b3fa-17a6f1201ade',
        '2025-10-24 16:36:51',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'wechat-getSignature',
        'post__api_v1_wechat_getSignature',
        'POST',
        '/api/v1/wechat/getSignature',
        1,
        '创建wechat-getSignature'
    ),
    (
        'f8cfeca5-b2ee-4203-952e-1840193f829f',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_api_update',
        'PUT',
        '/api/v1/admin/api/update/:id',
        1,
        '更新update-:id'
    ),
    (
        'fe55b736-7053-4b5e-826d-90a1550b2bbe',
        '2025-09-30 17:52:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'update-:id',
        'put__api_v1_admin_feature_update',
        'PUT',
        '/api/v1/admin/feature/update/:id',
        1,
        '更新update-:id'
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_dict_data`
--

CREATE TABLE `admin_dict_data` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `dict_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型编码',
    `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典标签',
    `dict_value` tinyint NOT NULL COMMENT '字典键值',
    `dict_sort` int NOT NULL DEFAULT '0' COMMENT '字典排序',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表';

--
-- 转存表中的数据 `admin_dict_data`
--

INSERT INTO
    `admin_dict_data` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `dict_type`,
        `dict_label`,
        `dict_value`,
        `dict_sort`,
        `status`,
        `remark`
    )
VALUES (
        '41f8885f-807c-4101-9d35-cbcb57923976',
        '2025-04-29 13:28:38',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'admin_menu_type',
        'action',
        2,
        3,
        1,
        '按钮'
    ),
    (
        '54c91fdc-fa52-49aa-a07b-f2d46f948590',
        '2025-04-29 13:28:38',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'admin_menu_type',
        'menu',
        1,
        2,
        1,
        '菜单'
    ),
    (
        'ae0a0624-9311-46b1-9b56-6f69b9bd61dd',
        '2025-04-29 13:28:38',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'admin_menu_type',
        'catalog',
        0,
        1,
        1,
        '目录'
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_dict_type`
--

CREATE TABLE `admin_dict_type` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `dict_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型编码',
    `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型名称',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表';

--
-- 转存表中的数据 `admin_dict_type`
--

INSERT INTO
    `admin_dict_type` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `dict_type`,
        `dict_name`,
        `status`,
        `remark`
    )
VALUES (
        'fc9a558a-e5be-40ed-8d8e-79f4d2b9000d',
        '2025-04-29 13:28:38',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'admin_menu_type',
        '菜单类型',
        1,
        '系统菜单类型'
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_menu`
--

CREATE TABLE `admin_menu` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `pid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父菜单ID',
    `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由名称',
    `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由路径',
    `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组件路径',
    `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '重定向路径',
    `meta` json NOT NULL COMMENT '路由元数据配置',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态: 0-禁用, 1-启用',
    `type` tinyint NOT NULL DEFAULT '0',
    `sort` int NOT NULL DEFAULT '0' COMMENT '排序号'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表';

--
-- 转存表中的数据 `admin_menu`
--

INSERT INTO
    `admin_menu` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `pid`,
        `name`,
        `path`,
        `component`,
        `redirect`,
        `meta`,
        `status`,
        `type`,
        `sort`
    )
VALUES (
        '0353dd42-0f58-4dcd-aa89-802c8f16df3a',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        '2025-11-28 13:27:44',
        1,
        1,
        '0',
        'Demos',
        '/demos',
        '',
        NULL,
        '{\"icon\": \"ic:baseline-view-in-ar\", \"order\": 1000, \"title\": \"demos.title\", \"keepAlive\": true}',
        1,
        0,
        0
    ),
    (
        '04f8511a-2cc4-4cf5-9419-0ccd4d4b5567',
        '2025-04-27 20:19:01',
        '2025-12-08 12:53:44',
        '2025-11-28 17:31:41',
        1,
        1,
        '0',
        'VbenDocument',
        '/vben-admin/document',
        'IFrameView',
        NULL,
        '{\"icon\": \"lucide:book-open-text\", \"link\": \"https://doc.vben.admin\", \"title\": \"demos.vben.document\"}',
        1,
        0,
        0
    ),
    (
        '1c5a0f08-0017-44cd-9afa-17bccced460d',
        '2025-04-29 21:40:22',
        '2025-12-08 12:54:23',
        NULL,
        0,
        0,
        '74bad303-9df4-4895-be54-80f54e5ba8c2',
        'SystemUser',
        '/system/user',
        '/system/user/list',
        NULL,
        '{\"icon\": \"carbon:user-filled\", \"title\": \"用户管理\"}',
        1,
        1,
        0
    ),
    (
        '1d2f484e-e567-4d32-a791-2376a3768abf',
        '2025-11-28 14:05:04',
        '2025-12-08 12:54:41',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentConfig',
        '/agent-manage/config',
        '/agent/agent-config/list',
        NULL,
        '{\"icon\": \"carbon:document-configuration\", \"title\": \"代理系统配置\"}',
        1,
        1,
        0
    ),
    (
        '204def63-f43a-4508-8412-d30569666624',
        '2025-05-15 23:14:04',
        '2025-12-08 12:55:29',
        NULL,
        0,
        0,
        '48d0e129-a141-4a74-b519-7adc38d22d27',
        'productList',
        '/product-manage/product',
        '/product-manage/product/list',
        NULL,
        '{\"icon\": \"carbon:store\", \"title\": \"产品列表\"}',
        1,
        1,
        0
    ),
    (
        '2c87d42b-ea99-46bb-8275-075a85fe8855',
        '2025-04-28 18:12:21',
        '2025-12-08 12:55:38',
        NULL,
        0,
        0,
        '74bad303-9df4-4895-be54-80f54e5ba8c2',
        'SystemDept',
        '/system/dept',
        '/system/dept/list',
        NULL,
        '{\"icon\": \"charm:organisation\", \"title\": \"system.dept.title\"}',
        0,
        1,
        0
    ),
    (
        '31d8a7a4-d026-42e0-a07f-fdfc06d4e915',
        '2025-11-28 13:51:45',
        '2025-12-08 12:55:46',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentUpgrade',
        '/agent-manage/upgrade',
        '/agent/agent-upgrade/list',
        NULL,
        '{\"icon\": \"carbon:intent-request-upgrade\", \"title\": \"代理升级记录\"}',
        1,
        1,
        0
    ),
    (
        '333a8221-2071-4279-a8a6-332fd3fea2e0',
        '2025-11-28 14:03:33',
        '2025-12-08 12:57:21',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentOrder',
        '/agent-manage/order',
        '/agent/agent-order/list',
        NULL,
        '{\"icon\": \"carbon:follow-up-work-order\", \"title\": \"订单记录\"}',
        1,
        1,
        0
    ),
    (
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        '2025-06-06 21:43:48',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'AgentManage',
        '/agent-manage',
        '',
        NULL,
        '{\"icon\": \"carbon:airline-manage-gates\", \"title\": \"代理系统\"}',
        1,
        0,
        0
    ),
    (
        '48d0e129-a141-4a74-b519-7adc38d22d27',
        '2025-05-15 22:56:11',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'productManage',
        '/product-manage',
        '',
        NULL,
        '{\"icon\": \"carbon:box\", \"title\": \"产品管理\"}',
        1,
        0,
        0
    ),
    (
        '4e4dc1e0-43a8-414b-868f-7384cc4ed8ac',
        '2025-05-08 16:12:22',
        '2025-12-06 18:23:29',
        '2025-11-28 17:31:09',
        1,
        1,
        '0',
        'Promotion',
        '/promotion',
        '',
        NULL,
        '{\"icon\": \"carbon:carbon\", \"title\": \"推广\"}',
        1,
        0,
        0
    ),
    (
        '4e5e365f-4578-4499-95fd-0fe14e0a409e',
        '2025-05-08 16:20:19',
        '2025-12-08 12:53:44',
        '2025-11-28 17:31:06',
        1,
        1,
        '0',
        'PromotionLink',
        '/promotion/link',
        '/promotion/link/index',
        NULL,
        '{\"icon\": \"carbon:link\", \"title\": \"推广链接管理\"}',
        1,
        1,
        0
    ),
    (
        '4f60f7a8-9b9c-4dc0-a8bf-ac156afd8d85',
        '2025-06-07 23:40:35',
        '2025-12-08 12:53:44',
        '2025-11-28 13:47:50',
        1,
        1,
        '0',
        'AgentMembershipConfig',
        '/agent-manage/agent-membership-config',
        '/agent/agent-membership-config/list',
        NULL,
        '{\"icon\": \"carbon:document-configuration\", \"title\": \"代理会员配置\"}',
        1,
        1,
        0
    ),
    (
        '596e01ca-98ac-412f-83b5-af94166a812d',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'Dashboard',
        '/dashboard',
        '',
        NULL,
        '{\"icon\": \"lucide:layout-dashboard\", \"order\": -1, \"title\": \"page.dashboard.title\"}',
        1,
        0,
        0
    ),
    (
        '60804dbd-e70c-4c24-ac1e-57ff386169fb',
        '2025-06-07 21:17:02',
        '2025-12-08 12:53:44',
        '2025-11-28 13:47:53',
        1,
        1,
        '0',
        'AgentMembershipRechargeOrder',
        '/agent-manage/agent-membership-recharge-order',
        '/agent/agent-membership-recharge-order/list',
        NULL,
        '{\"icon\": \"carbon:feature-membership\", \"title\": \"会员充值订单\"}',
        1,
        1,
        0
    ),
    (
        '64d27362-8542-4226-a1bf-e92e5672d6c3',
        '2025-11-28 14:04:32',
        '2025-12-08 12:58:09',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentInviteCode',
        '/agent-manage/invite-code',
        '/agent/agent-invite-code/list',
        NULL,
        '{\"icon\": \"carbon:barcode\", \"title\": \"邀请码管理\"}',
        1,
        1,
        0
    ),
    (
        '67da0e84-1eb6-4cf8-9ca6-7938df17d67e',
        '2025-04-27 20:19:01',
        '2025-12-08 12:53:44',
        NULL,
        0,
        0,
        '0',
        'Workspace',
        '/workspace',
        '/dashboard/workspace/index',
        NULL,
        '{\"icon\": \"carbon:workspace\", \"title\": \"page.dashboard.workspace\"}',
        1,
        0,
        0
    ),
    (
        '6fa1f67e-9555-45c4-bdf5-c427ffcb4471',
        '2025-05-29 16:15:36',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'Order',
        '/order',
        '',
        NULL,
        '{\"icon\": \"lucide:shopping-cart\", \"title\": \"订单管理\"}',
        1,
        0,
        0
    ),
    (
        '7268c3f0-064c-4595-abb5-9928c3cd1ee8',
        '2025-11-28 13:50:23',
        '2025-12-08 12:58:17',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentRebate',
        '/agent-manage/rebate',
        '/agent/agent-rebate/list',
        NULL,
        '{\"icon\": \"carbon:bottom-panel-open\", \"title\": \"返佣记录\"}',
        1,
        1,
        0
    ),
    (
        '74bad303-9df4-4895-be54-80f54e5ba8c2',
        '2025-04-28 18:12:21',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'System',
        '/system',
        '',
        NULL,
        '{\"icon\": \"ion:settings-outline\", \"order\": 9997, \"title\": \"system.title\"}',
        1,
        0,
        9997
    ),
    (
        '75db2df6-b2d9-452d-abfc-a81d59251d84',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        '2025-11-28 17:31:44',
        1,
        1,
        '0',
        'VbenAbout',
        '/vben-admin/about',
        '/_core/about/index',
        NULL,
        '{\"icon\": \"lucide:copyright\", \"order\": 9999, \"title\": \"demos.vben.about\"}',
        1,
        0,
        0
    ),
    (
        '76a0c4a9-b37a-49f9-a78e-0d04adc24a74',
        '2025-05-14 01:05:54',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'notification',
        '/notification',
        '/notification/list',
        NULL,
        '{\"icon\": \"carbon:notification\", \"title\": \"通知管理\"}',
        1,
        1,
        0
    ),
    (
        '76c1177f-bed8-42cc-83c0-cd1312aead90',
        '2025-06-07 11:40:47',
        '2025-12-08 12:58:26',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentCommission',
        '/agent-manage/agent-commission',
        '/agent/agent-commission/list',
        NULL,
        '{\"icon\": \"carbon:money\", \"title\": \"佣金记录\"}',
        1,
        1,
        0
    ),
    (
        '7ef2b1d3-4578-4884-a735-915f60c87e13',
        '2025-05-16 00:15:01',
        '2025-12-08 12:58:37',
        NULL,
        0,
        0,
        '48d0e129-a141-4a74-b519-7adc38d22d27',
        'feature',
        '/product-manage/feature',
        '/product-manage/feature/list',
        NULL,
        '{\"icon\": \"carbon:web-services-container\", \"title\": \"模块列表\"}',
        1,
        1,
        0
    ),
    (
        '7fb98125-fe79-4bb1-b095-137c98f4f5e6',
        '2025-06-07 12:14:15',
        '2025-12-08 12:53:44',
        '2025-11-28 13:48:12',
        1,
        1,
        '0',
        'AgentReward',
        '/agent-manage/agent-reward',
        '/agent/agent-reward/list',
        NULL,
        '{\"icon\": \"carbon:store\", \"title\": \"平台奖励\"}',
        1,
        1,
        0
    ),
    (
        '93b76eed-65c5-4ed8-9fbb-c44159988a23',
        '2025-05-13 20:29:52',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '0',
        'platformUser',
        '/platform-user',
        '/platform-user/list',
        NULL,
        '{\"icon\": \"carbon:user-profile\", \"title\": \"平台用户管理\", \"activeIcon\": \"\"}',
        1,
        1,
        0
    ),
    (
        '94acb1a3-abab-42fc-8fca-35944bd7f555',
        '2025-06-06 18:24:53',
        '2025-12-08 12:58:57',
        NULL,
        0,
        0,
        '6fa1f67e-9555-45c4-bdf5-c427ffcb4471',
        'queryCleanup',
        '/order/query/query-cleanup-manage',
        '/order/query-cleanup/query-cleanup-log',
        NULL,
        '{\"icon\": \"carbon:clean\", \"title\": \"查询数据管理\", \"activeIcon\": \"\"}',
        1,
        1,
        0
    ),
    (
        '9beb8960-dd6b-497b-b580-11dfeeaf09aa',
        '2025-06-07 12:15:12',
        '2025-12-08 12:59:02',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentWithdrawal',
        '/agent-manage/withdrawal',
        '/agent/agent-withdrawal/list',
        NULL,
        '{\"icon\": \"carbon:piggy-bank\", \"title\": \"提现记录\"}',
        1,
        1,
        0
    ),
    (
        'b146fe78-f357-44a7-ac54-be56471a84a1',
        '2025-06-07 16:28:52',
        '2025-12-08 12:53:44',
        '2025-11-28 13:48:02',
        1,
        1,
        '0',
        'AgentPlatformDeduction',
        '/agent-manage/agent-platform-deduction',
        '/agent/agent-platform-deduction/list',
        NULL,
        '{\"icon\": \"carbon:ibm-openshift-container-platform-on-vpc-for-regulated-industries\", \"title\": \"平台抽佣记录\"}',
        1,
        1,
        0
    ),
    (
        'b3f25a1d-15d2-4e81-92be-81cb923ed80e',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        '2025-11-28 17:31:46',
        1,
        1,
        '0',
        'VbenProject',
        '/vben-admin',
        '',
        NULL,
        '{\"icon\": \"carbon:apps\", \"order\": 9998, \"title\": \"demos.vben.title\", \"badgeType\": \"dot\"}',
        1,
        0,
        0
    ),
    (
        'b9935509-4a5b-48d7-b97b-524b214fb32a',
        '2025-06-07 16:46:18',
        '2025-12-08 12:59:08',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentProductConfig',
        '/agent-manage/agent-product-config',
        '/agent/agent-product-config/list',
        NULL,
        '{\"icon\": \"carbon:cloud-satellite-config\", \"title\": \"代理产品配置\"}',
        1,
        1,
        0
    ),
    (
        'b9ef58ed-3622-4799-ba6f-1788a35efeb7',
        '2025-06-07 11:39:25',
        '2025-12-08 12:59:16',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentLinks',
        '/agent-manage/agent-links',
        '/agent/agent-links/list',
        NULL,
        '{\"icon\": \"carbon:link\", \"title\": \"推广链接\"}',
        1,
        1,
        0
    ),
    (
        'bbdbd778-61e3-49d5-a886-3bd2ebbc1910',
        '2025-04-27 20:19:01',
        '2025-12-08 12:57:34',
        NULL,
        0,
        0,
        '6fa1f67e-9555-45c4-bdf5-c427ffcb4471',
        'OrderManage',
        '/order',
        '/order/order/index',
        NULL,
        '{\"icon\": \"lucide:shopping-cart\", \"order\": 1000, \"title\": \"订单管理\"}',
        1,
        1,
        0
    ),
    (
        'c2b3d01f-fd81-4ef3-a3ec-d767540dfd08',
        '2025-06-06 21:44:27',
        '2025-12-08 12:59:21',
        NULL,
        0,
        0,
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543',
        'AgentList',
        '/agent-manage/agent-list',
        '/agent/agent-list/list',
        NULL,
        '{\"icon\": \"carbon:list\", \"title\": \"代理列表\"}',
        1,
        1,
        0
    ),
    (
        'c4e86171-16ca-4008-9a08-4fad4cd502a0',
        '2025-04-28 18:12:21',
        '2025-12-08 12:59:48',
        NULL,
        0,
        0,
        '74bad303-9df4-4895-be54-80f54e5ba8c2',
        'SystemMenu',
        '/system/menu',
        '/system/menu/list',
        NULL,
        '{\"icon\": \"mdi:menu\", \"title\": \"system.menu.title\"}',
        1,
        1,
        0
    ),
    (
        'c88c4e65-1335-4751-ac0c-06ea75a57eef',
        '2025-05-29 16:04:53',
        '2025-12-08 12:59:33',
        NULL,
        0,
        0,
        '6fa1f67e-9555-45c4-bdf5-c427ffcb4471',
        'OrderQueryDetail',
        '/order/query/:id',
        '/order/query/query-details',
        NULL,
        '{\"icon\": \"carbon:report\", \"title\": \"查询结果\", \"hideInMenu\": true}',
        1,
        1,
        0
    ),
    (
        'c94e711e-d1d3-474a-8cc7-ede90b9e115d',
        '2025-05-08 16:21:41',
        '2025-12-08 12:53:44',
        '2025-11-28 17:31:04',
        1,
        1,
        '0',
        'PromotionAnalytics',
        '/promotion/analytics',
        '/promotion/analytics/index',
        NULL,
        '{\"icon\": \"carbon:analytics\", \"title\": \"推广数据分析\"}',
        1,
        1,
        0
    ),
    (
        'd4c7fb58-87ac-4d60-b77a-d1363f7438fe',
        '2025-06-07 13:44:27',
        '2025-12-08 12:53:44',
        '2025-11-28 13:48:05',
        1,
        1,
        '0',
        'AgentCommissionDeduction',
        '/agent-manage/agent-commission-deduction',
        '/agent/agent-commission-deduction/list',
        NULL,
        '{\"icon\": \"carbon:collapse-categories\", \"title\": \"上级抽佣记录\"}',
        1,
        1,
        0
    ),
    (
        'dbfc5eb8-e6d3-4188-8fda-7d810e87c2b1',
        '2025-04-28 18:12:21',
        '2025-12-08 12:59:43',
        NULL,
        0,
        0,
        '74bad303-9df4-4895-be54-80f54e5ba8c2',
        'SystemRole',
        '/system/role',
        '/system/role/list',
        NULL,
        '{\"icon\": \"mdi:account-group\", \"title\": \"system.role.title\"}',
        1,
        1,
        0
    ),
    (
        'e082f171-233f-4318-818e-00cbf545dba0',
        '2025-04-27 20:19:01',
        '2025-12-08 12:53:44',
        '2025-11-28 13:27:42',
        1,
        1,
        '0',
        'AntDesignDemos',
        '/demos/ant-design',
        '/demos/antd/index',
        NULL,
        '{\"title\": \"demos.antd\"}',
        1,
        0,
        0
    ),
    (
        'e4131f11-9804-4536-b677-6bd32c6d83aa',
        '2025-04-27 20:19:01',
        '2025-12-08 12:58:02',
        NULL,
        0,
        0,
        '596e01ca-98ac-412f-83b5-af94166a812d',
        'Analytics',
        '/analytics',
        '/dashboard/analytics/index',
        NULL,
        '{\"icon\": \"lucide:area-chart\", \"title\": \"page.dashboard.analytics\", \"affixTab\": true}',
        1,
        0,
        0
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_role`
--

CREATE TABLE `admin_role` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
    `role_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色编码',
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色描述',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
    `sort` int NOT NULL DEFAULT '0' COMMENT '排序'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表';

--
-- 转存表中的数据 `admin_role`
--

INSERT INTO
    `admin_role` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `role_name`,
        `role_code`,
        `description`,
        `status`,
        `sort`
    )
VALUES (
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '超级管理员',
        'SUPER',
        '系统超级管理员，拥有所有权限',
        1,
        0
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_role_api`
--

CREATE TABLE `admin_role_api` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `api_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色接口关联表';

--
-- 转存表中的数据 `admin_role_api`
--

INSERT INTO
    `admin_role_api` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `role_id`,
        `api_id`
    )
VALUES (
        '03b637a6-7381-4d9b-8a5d-757014688cd4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'b307281a-a7a2-4bf9-bbd6-497b66ffdf66'
    ),
    (
        '065a31e4-22a8-4348-9e19-f70e41561069',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '56444111-6297-40a0-be9f-5ce5508dfb45'
    ),
    (
        '0b25cc0c-a49d-4e7e-af52-ed16bd52f89f',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '292849f3-31d8-4cc2-99d1-9b6dcc51c050'
    ),
    (
        '0ccbbacf-313f-414a-a50b-5105f3f31d97',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f6645bbd-32a8-4386-a289-0c9b1f529a92'
    ),
    (
        '0d872189-9b31-4ea4-9be2-3fb710ebbc7c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'cd6271c0-33ac-44f8-a6ba-1cd90cd93599'
    ),
    (
        '1073829c-6d31-4b43-bdca-3d4d8b97b98c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '11603b40-789c-4f71-816d-95ec03ab0de4'
    ),
    (
        '14276ac5-8692-4395-8a0b-6801984ad4e4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9c90e879-2f35-497b-b311-b2e21714f5e0'
    ),
    (
        '15132f83-39fb-4a57-97b6-8355f72efacb',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'd85363e9-f601-44a5-a857-e92df7148d1b'
    ),
    (
        '16abf4ae-629d-4adb-80f4-dc7d936c8df6',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '0ac38277-18a8-47bf-ae91-534bd6cc886f'
    ),
    (
        '175a958e-5a40-4925-954a-63fb05e993b9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'a3002c91-cd99-4b99-b5bc-6440e6a9e4c5'
    ),
    (
        '183ea100-2b5d-4028-99a8-47140734eb57',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '51eb9576-786b-43d9-9558-e3f2371e2a82'
    ),
    (
        '188588fc-c233-445f-b7f4-ab6e2388b366',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f8cfeca5-b2ee-4203-952e-1840193f829f'
    ),
    (
        '22569a90-d8b0-45a7-8ff2-7088ba41330c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '72b72deb-3799-4666-affd-cee0875862f2'
    ),
    (
        '27226f8c-506d-42fe-b7e2-1fb461886327',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '2981b72e-878c-4a55-aa77-2cecdacc5e0b'
    ),
    (
        '2ad07e0e-a36c-4e6c-8563-9efa33853efd',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '18733bdb-ff4f-4088-bfce-ac8cf66513fd'
    ),
    (
        '2b190d08-a358-4ee6-b1ff-1cd41695d294',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'd1db6abc-af82-4b1a-b374-acb831970d1b'
    ),
    (
        '2cefc060-e9c7-42bc-9151-c603583e57a7',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '0fc981be-b3c5-4964-bbef-ac1cb410a63f'
    ),
    (
        '2dd9c4f0-2202-48b7-9c54-0717ca4059d6',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '922f692d-263c-4709-b4fd-868194039d17'
    ),
    (
        '33ce9b01-2c4d-4c6b-8552-48c7d791f9e4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '5e6bd2ba-a681-4c99-b222-2078d4436172'
    ),
    (
        '33ef7ff8-f2db-4d46-adfb-b3f90564daa2',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'e65c94e9-279d-4291-9a1c-56d6f750290c'
    ),
    (
        '38f5cae5-3de8-47a1-b5c3-16478eb663eb',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'd43288d3-5bfe-4ac4-8bf3-2fc16586c06c'
    ),
    (
        '39948f3a-8b61-4292-87a6-e47e38c78ac0',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c3db7059-d8bc-43f2-9251-eb00b6a4d4b5'
    ),
    (
        '3ed84d2c-76ef-463b-be97-a4fc6e232e30',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '853ab285-97f6-47dd-9cbc-4a1bd2d0ff36'
    ),
    (
        '4214a7da-ebeb-44ef-8030-ac30968c9fbc',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '5136e206-153a-4e0d-acff-09d48baeb133'
    ),
    (
        '43e75574-ab36-4430-b972-a68f7a377b05',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '6ba67191-6abe-4b5f-b502-289db04e7d6e'
    ),
    (
        '47953e86-86e4-429c-a128-de502b11a25d',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f4d2422f-5e55-4fbb-939b-a777984b86bb'
    ),
    (
        '48c97919-42ba-4894-9124-bb0134e7cc2b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '442e53a2-5af6-4e6b-8996-e34748294381'
    ),
    (
        '4c5cac43-0e81-4c30-9234-265a94559fa9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '6d0ea2c2-830d-4aa6-80f2-542508471281'
    ),
    (
        '4e3d6c99-91c3-4874-b7e1-f27b5b1f266d',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '7b428368-7faf-4b42-8379-a097f812d72e'
    ),
    (
        '4e58bb02-790b-479f-871e-05d934987398',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'e12d5ec4-2ec5-4db4-be88-713defc54b6e'
    ),
    (
        '524b3e1f-2a2d-4c35-85ad-25fb666306ae',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '04c6c7f4-d929-4757-a307-f5fb4ad552a1'
    ),
    (
        '56afe81d-5ab2-455f-81bc-04852fa67f5b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '0f9781fe-f7aa-4cbe-a3c4-c502838e92d6'
    ),
    (
        '58c8ab7c-1ef5-41db-bf9b-7e458e5d0c40',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'b6955079-3030-429c-bec8-f64eff389335'
    ),
    (
        '5b45206f-2e0e-40aa-abab-c2eb5a8a5e1c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c6bb604b-1bb7-4c39-90e0-5fcf62ed8aa7'
    ),
    (
        '5eb1584f-1de5-44bf-a641-badc62aa948c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'db435bd3-44f9-4bc1-948f-35f724bea0e0'
    ),
    (
        '6096f34c-0f51-428e-94eb-39a62821eca7',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '3d0bdb6d-356a-439a-bb99-c987fdf85604'
    ),
    (
        '63ccad7b-6c0f-499b-83a3-82385cbcf013',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c5b69231-7864-4698-abe3-a7c980d13996'
    ),
    (
        '63efd0e6-d490-4f4d-899f-59bb73d84fa8',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'ef403ac3-be87-415b-b16f-402d0a7279d8'
    ),
    (
        '661502a0-4aeb-4688-ae8c-28839b2d2d43',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c7be4ca9-8a85-4c45-90eb-4df247748f64'
    ),
    (
        '6636a620-5a4d-4676-9142-21020da7c810',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'be7212bd-fb70-48a2-927b-6fa36fef2f73'
    ),
    (
        '6696dd9b-1665-47ab-a0f7-590759966db1',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '28c7d4b7-51cc-4ca7-a39a-a906857db9df'
    ),
    (
        '6732beb1-e531-49c3-8710-2b2512725927',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'ce4984ad-861a-49cd-958d-806a1fc59af9'
    ),
    (
        '67a2fcb7-b37c-46b3-a804-b577c82351d5',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9cc7290d-bbf7-4842-9155-6166780841d8'
    ),
    (
        '67d72bed-e979-4006-87de-1ece6b584fbe',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'a49fae63-7b05-47ea-9246-ac96d016e88e'
    ),
    (
        '6c2909f3-07d0-4432-bdb2-c7a2ab8cdaa4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'cdf6de3b-8ef7-4378-8ce1-ea1200e9520a'
    ),
    (
        '6d42fd5e-9287-4e0f-8378-a2023762ff62',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '1a366316-5291-41c3-9410-a9a80b7be416'
    ),
    (
        '6e7dce7a-09cb-4773-937e-f4996125cd53',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'a41e3af6-e846-4675-8bf0-3aaa6d78a05a'
    ),
    (
        '6e9cb03a-bb19-4848-a541-3be2e54b7124',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'fe55b736-7053-4b5e-826d-90a1550b2bbe'
    ),
    (
        '6f256da8-9d3c-4e37-966c-684cd09b994b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f78bf038-2423-4b9c-b3fa-17a6f1201ade'
    ),
    (
        '6fb6c5f2-1af1-48ed-ad01-81b06793e499',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c9f32092-59ea-4b1d-aa74-587608e61be3'
    ),
    (
        '7865e8e4-ddd2-45c6-b3db-f608b4c71320',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9da2a0b9-eb68-40c2-b835-2e030042425b'
    ),
    (
        '7f765c36-22d8-470e-8175-75ac80ccff7b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '946a84e8-8a3d-4a3c-99c2-37969a5bc3ca'
    ),
    (
        '81714e7a-37a1-4395-84b6-b6716edd4c0c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '32d4796a-3655-4140-8cd6-7d6de5e2e13b'
    ),
    (
        '82f94f59-854a-45f9-8dbb-6cb2a542c467',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '79b79424-2cac-4c67-93f7-7f97af2b4ab1'
    ),
    (
        '8303f0b5-e394-43ea-bc87-54ea4b3b84f4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '0049c594-e08c-40b0-a974-95ea0b3ee92c'
    ),
    (
        '836c82cc-33a9-41c7-83bf-32aa84d956e1',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'de2d063f-1bac-44dd-9cfa-2b1f8732d7fe'
    ),
    (
        '86262311-4cc9-4585-9da3-fe64dfaade83',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '89620aef-7bb3-4f50-a8e1-954e82afcc59'
    ),
    (
        '89f8c670-b1d7-4212-ac3d-798216b37fd7',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c3793fbe-c0ff-4f3c-b476-b826dc527d30'
    ),
    (
        '8f3f35a7-af1c-43ed-b6fd-0eb5e18c2634',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'e861ec85-5420-45a3-a8a6-b71a6f281fd5'
    ),
    (
        '94ef8431-75ee-4f68-b62b-c49f2424fc8c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f25cd690-bb3f-45e6-9646-cc408c2ff059'
    ),
    (
        '9780bce7-9c6a-48c4-85d5-d9d78e2102b5',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '1e6ff909-406a-4622-92a1-a8f96b4452fa'
    ),
    (
        '9a89a2dc-7c93-496b-b4dd-9fd7a577a486',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '27f8a5af-5578-4891-b866-c7bad8114c3d'
    ),
    (
        '9a9631ba-cf51-4bcb-a5f8-580ec84dbb4c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'bb4ffbf5-eb16-4481-a3d7-a5d3f2443923'
    ),
    (
        '9b6bce84-2829-43fc-b850-e6f375ef8ed9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '623db129-f1e9-4123-a2a1-36cb03f140d4'
    ),
    (
        '9caab192-5f79-4a56-aed6-de67c8421dac',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '7ebd833e-daf7-46a2-b43d-5c8d745a9cf9'
    ),
    (
        '9d04a060-9912-47a0-8600-3c1d9373d06c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '3d5d7334-2976-4c27-aea2-53cd0e599478'
    ),
    (
        '9e1c6ed9-596e-4e13-8d77-6af96b6bfd05',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '0fc0708c-adc3-4e12-ad62-2e099e303ff5'
    ),
    (
        'a08ac864-fc49-4adc-adbb-cd125ac8ce06',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'bb914a84-90f7-4739-a514-f4604cad4927'
    ),
    (
        'a0d52063-efbf-4063-8298-9b6e95edc61d',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'bc502f9e-3f0a-4e48-ba45-0f4849d3a159'
    ),
    (
        'a3b964a4-f649-4cca-a832-c66f915a7563',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '3c1b52a8-913d-4a82-a201-6ebee1dd4615'
    ),
    (
        'a88cb1b5-de61-4802-b0a6-26fdfc163d7f',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'a6bfa982-8170-447c-91fb-40a1808019eb'
    ),
    (
        'a90d7248-51b5-4992-ae9c-62d819e9b82d',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c2b0c6e1-5866-483f-b9a6-3e0634329d58'
    ),
    (
        'ac10f79a-7f79-445c-b934-2d73384cad75',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9f862d08-6751-4fab-a1b5-fc00a31c8190'
    ),
    (
        'b49b3732-31c9-4a94-b15c-2560b5add0d8',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '2943ed7e-35e5-45a3-8c59-b94dab7b082c'
    ),
    (
        'b72f8cac-3a53-421f-94db-b06ad16ea3f7',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '25031ae7-aca3-489e-84dd-99d2ae6bfa9e'
    ),
    (
        'b87cb025-f37b-41c8-a155-a047e013794f',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '95fb06fd-0522-4f7a-92b3-f9dfacaafb7e'
    ),
    (
        'b895cdfe-421a-43cc-896e-a3f7169b9861',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'de7bde21-3b8d-48af-aa48-00b5f6043765'
    ),
    (
        'b9459a79-cfc3-4e53-a016-3a2dc1ebe9f3',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '02cefbdc-dbc6-4173-8478-38a494a60a01'
    ),
    (
        'b9f837db-d801-4730-87c2-7981d96861fd',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '952325a3-0107-40ff-bd12-25cf9fa8becb'
    ),
    (
        'c80353b6-574c-4d9b-89bf-9bd6cbb84c26',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '613e8b71-bd27-4c73-93d6-737cc4fa2fd0'
    ),
    (
        'c8c777e5-1259-49a6-a83c-9d0b5f38cf69',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'ce0e10ad-b96d-4843-a221-d440cdec9a8b'
    ),
    (
        'ca38dccd-33b1-495b-8066-7a42a94334d3',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '8090f044-a8a7-42f5-95c8-7d751359a5db'
    ),
    (
        'ccb2b226-bf04-4540-bb32-2d421d0dedc6',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '55c67553-73ef-406c-b167-a27b9651421e'
    ),
    (
        'd1434f34-ee34-41ab-93ef-9a1086573ee4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'd1a7de7c-bcf1-4bbd-8e5e-5dc21f900a5d'
    ),
    (
        'd89ef06c-e896-4cc6-852b-79c0337cb9b0',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '051985e7-4fe6-4f26-b24c-c7d8954fec85'
    ),
    (
        'da5da912-f811-4bf4-9d42-9f4fb57457a4',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'eca9b634-cad8-4617-a61b-bb7d83386fd0'
    ),
    (
        'dc55539f-4c3b-40a7-b9d0-8b13e3256935',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '934edf8a-c17a-436a-9454-de011da272ca'
    ),
    (
        'dca0c959-e571-4cc6-89e3-88dc78dadf90',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '34dac3bb-0983-49e8-840d-9d75dd3a083e'
    ),
    (
        'dcb89c50-ba5b-4309-8950-22e5f40ee3f8',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '5cd92b66-0ae2-4f89-904a-5330094a5585'
    ),
    (
        'ddf5b248-b20a-4649-8c09-2c135a69af92',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9bb88e73-b682-4fca-8455-833e639eb67e'
    ),
    (
        'de05890b-8252-48cd-95bf-c93769f7bcfc',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '5a4be769-13da-45d5-932c-bfbb43ba7108'
    ),
    (
        'de64f5ae-b00a-45f4-895b-b947a12c14b3',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '4efa5b1f-5412-40f5-8a5e-bec95a910054'
    ),
    (
        'e4d43bdc-2f3c-45cb-a308-d9e3770281e9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '3ec30907-acfa-4855-a1ca-9a480d0bbbf3'
    ),
    (
        'e882033e-8f69-4ef4-b217-a2e1f00524a6',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '55408cc1-6f7e-4011-a66f-e832e16e19de'
    ),
    (
        'ed2bf9f4-9b71-4057-9519-24565865c54e',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'f0994586-1778-4cc6-bf8b-ab7972d62191'
    ),
    (
        'ef67c4dd-e51b-4d95-9b3c-b7b7f35b3792',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '02f687f7-5840-443c-976f-5ba5bf7769a2'
    ),
    (
        'efd0fbaa-1d2f-4c84-b3be-7f114fa619e9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'd14cd985-cfb8-44d0-8efb-4701a995970c'
    ),
    (
        'f032e4b2-7763-47e9-87ab-131bfb2d7e7e',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'db8d5560-2ac8-47c9-bf6a-8d1ab9100409'
    ),
    (
        'f35b575c-d079-480d-afc3-a5673d522ce9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '014ae5fc-cd0e-44d5-9eeb-797fbb695019'
    ),
    (
        'f845d187-b001-47d8-98d8-140d3a7d9857',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '576f8cef-7d29-46db-b525-c944a8eb1016'
    ),
    (
        'f871b842-452f-491c-9f1f-372d06b97ccf',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '721c0530-5091-4df0-bbcb-bd2ab6b38355'
    ),
    (
        'fa4d8ce2-1550-47c3-88eb-a0aa23af0dae',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '6bfb8815-b6df-4e7c-b23d-be662ba33168'
    ),
    (
        'fd115d42-97d3-4433-8ce3-38652967a873',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:12',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '34e5486e-af8c-48cb-8862-693184812d11'
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_role_menu`
--

CREATE TABLE `admin_role_menu` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `menu_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色菜单关联表';

--
-- 转存表中的数据 `admin_role_menu`
--

INSERT INTO
    `admin_role_menu` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `role_id`,
        `menu_id`
    )
VALUES (
        '14dab9af-9c05-43f6-8ab0-95cf55da81c0',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c4e86171-16ca-4008-9a08-4fad4cd502a0'
    ),
    (
        '180bfbdd-c4e8-4911-8d03-361b4dcd36bf',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'bbdbd778-61e3-49d5-a886-3bd2ebbc1910'
    ),
    (
        '1c8dfd50-1e46-4970-8860-d3b9f72c255c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '93b76eed-65c5-4ed8-9fbb-c44159988a23'
    ),
    (
        '1f0c8b16-32ca-4d35-8245-a6188cfbb218',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'b9935509-4a5b-48d7-b97b-524b214fb32a'
    ),
    (
        '2a94aa08-915c-4675-849f-5ea8cdbf3342',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'dbfc5eb8-e6d3-4188-8fda-7d810e87c2b1'
    ),
    (
        '368424c4-a44d-4efa-b748-ccaca19b7193',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c88c4e65-1335-4751-ac0c-06ea75a57eef'
    ),
    (
        '3adae928-8bca-4ee7-993f-24fbec56c034',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '48d0e129-a141-4a74-b519-7adc38d22d27'
    ),
    (
        '3e8515ca-0a0c-467b-accb-9e36e34d977a',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '596e01ca-98ac-412f-83b5-af94166a812d'
    ),
    (
        '4c06fdaf-a38e-443c-92b6-3732108d0cbd',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '333a8221-2071-4279-a8a6-332fd3fea2e0'
    ),
    (
        '5126f794-065f-4389-bd6e-ab6109336206',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '76a0c4a9-b37a-49f9-a78e-0d04adc24a74'
    ),
    (
        '5b776596-a72f-460e-9d55-0140a60cd21c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '204def63-f43a-4508-8412-d30569666624'
    ),
    (
        '7335872d-a9e3-4b9d-93c5-82d4008d20eb',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '7268c3f0-064c-4595-abb5-9928c3cd1ee8'
    ),
    (
        '758b2f2a-2be5-4c8d-a8f5-3a68f957b72b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '3e36f0ef-59a9-4594-83ac-cc729f4b0543'
    ),
    (
        '7e5627eb-f8f6-4607-b606-4b889b1f304b',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '67da0e84-1eb6-4cf8-9ca6-7938df17d67e'
    ),
    (
        '839c1769-e665-433e-b335-0c78cc6ecd12',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '94acb1a3-abab-42fc-8fca-35944bd7f555'
    ),
    (
        '9a749fc6-79e4-41ce-866b-93e40a2994a7',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'b9ef58ed-3622-4799-ba6f-1788a35efeb7'
    ),
    (
        '9abc4605-a7e3-425b-8eae-874875c91db2',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '1d2f484e-e567-4d32-a791-2376a3768abf'
    ),
    (
        'a4cc917d-ccef-4380-988a-4117798537ed',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '74bad303-9df4-4895-be54-80f54e5ba8c2'
    ),
    (
        'a860f658-f72f-4f3d-b609-0e9a8f3e2ff1',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '31d8a7a4-d026-42e0-a07f-fdfc06d4e915'
    ),
    (
        'acd29485-e2b9-466f-aba3-f34807430ca0',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '2c87d42b-ea99-46bb-8275-075a85fe8855'
    ),
    (
        'af7a3050-6dc9-4826-b7b4-1ac885b245b0',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '64d27362-8542-4226-a1bf-e92e5672d6c3'
    ),
    (
        'd426e624-331e-48f9-b8e0-fdaaac623d9d',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '7ef2b1d3-4578-4884-a735-915f60c87e13'
    ),
    (
        'd9e8d350-b581-4ecc-a54b-c15d8ba146c3',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '1c5a0f08-0017-44cd-9afa-17bccced460d'
    ),
    (
        'e90d307e-8def-439e-b353-87e4452b6b46',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '6fa1f67e-9555-45c4-bdf5-c427ffcb4471'
    ),
    (
        'ed410a81-2746-427f-b278-67ecb0f1f0b9',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '9beb8960-dd6b-497b-b580-11dfeeaf09aa'
    ),
    (
        'eee80e1d-b64a-4998-a193-785cdf55bf0c',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        '76c1177f-bed8-42cc-83c0-cd1312aead90'
    ),
    (
        'fa36985f-b5c2-4f0d-8cbb-173de79bd6fe',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'e4131f11-9804-4536-b677-6bd32c6d83aa'
    ),
    (
        'ff944eec-57be-45c2-a5d6-e0d9e9fae998',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef',
        'c2b3d01f-fd81-4ef3-a3ec-d767540dfd08'
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_user`
--

CREATE TABLE `admin_user` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
    `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员用户表';

--
-- 转存表中的数据 `admin_user`
--

INSERT INTO
    `admin_user` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `username`,
        `password`,
        `real_name`,
        `status`
    )
VALUES (
        '8854488e-72bf-4c24-8116-648409d8f979',
        '2025-04-27 20:19:01',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'admin',
        '$2a$10$b6Bl7rTPDpWgJKnjUvpONe1zQFQcWVpmpl.TF1jXhL3wcPV8.p.XC',
        '',
        1
    );

-- --------------------------------------------------------

--
-- 表的结构 `admin_user_role`
--

CREATE TABLE `admin_user_role` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户角色关联表';

--
-- 转存表中的数据 `admin_user_role`
--

INSERT INTO
    `admin_user_role` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `user_id`,
        `role_id`
    )
VALUES (
        '3195d14b-a236-4e9c-b601-fc4d9f092216',
        '2025-12-06 19:56:33',
        '2025-12-08 12:38:13',
        NULL,
        0,
        0,
        '8854488e-72bf-4c24-8116-648409d8f979',
        '741b7a39-a95d-4b9d-8dc0-84ee664d5fef'
    );

-- --------------------------------------------------------

--
-- 表的结构 `agent`
--

CREATE TABLE `agent` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_code` bigint NOT NULL COMMENT '代理编码（从16800开始递增）',
    `level` tinyint NOT NULL DEFAULT '1' COMMENT '代理等级：1=白银，2=黄金，3=钻石',
    `region` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区域（可选）',
    `mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号（加密）',
    `wechat_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信号',
    `team_leader_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `invite_code_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理基本信息表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_commission`
--

CREATE TABLE `agent_commission` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `amount` decimal(10, 2) NOT NULL COMMENT '佣金金额',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=已发放，2=已冻结，3=已取消',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理佣金记录表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_config`
--

CREATE TABLE `agent_config` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置键',
    `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置值',
    `config_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置类型：price=价格，bonus=等级加成，upgrade=升级费用，rebate=返佣，tax=税费',
    `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置描述',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理系统配置表';

--
-- 转存表中的数据 `agent_config`
--

INSERT INTO
    `agent_config` (
        `id`,
        `config_key`,
        `config_value`,
        `config_type`,
        `description`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`
    )
VALUES (
        '0fc67524-e00e-42b8-9e98-7bf6ef3d914a',
        'level_2_bonus',
        '3',
        'bonus',
        '黄金代理等级加成（3元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        '1bea4e3e-59ed-44dc-9d52-fcd86b434ef8',
        'gold_max_uplift_amount',
        '20',
        'price',
        '黄金代理最高价上调金额（元，默认0）',
        '2025-12-09 17:16:30',
        '2025-12-09 17:58:09',
        NULL,
        0,
        1
    ),
    (
        '734f5a07-44de-47f4-abf6-69ef0e5cb053',
        'commission_freeze_ratio',
        '0.1',
        'rebate',
        '佣金冻结比例（例如：0.1表示10%）',
        '2025-12-01 13:52:26',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        '760d4420-6316-4444-b9a2-6fe2551ce7fb',
        'diamond_max_uplift_amount',
        '50',
        'price',
        '钻石代理最高价上调金额（元，默认0）',
        '2025-12-09 17:16:30',
        '2025-12-09 17:58:09',
        NULL,
        0,
        1
    ),
    (
        '7b1429cf-3dc3-42ac-9251-4d1ad84f53af',
        'level_1_bonus',
        '6',
        'bonus',
        '白银代理等级加成（6元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        5
    ),
    (
        '7e1f83ec-347e-40a4-a61f-170bb2a54c8c',
        'tax_rate',
        '0.06',
        'tax',
        '提现税率（6%）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        '84966559-c623-4040-ab3c-24fa9ebc090a',
        'max_gold_rebate_amount',
        '3',
        'rebate',
        '黄金代理最大返佣金额（3元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        '9580b614-142e-4a6f-94ea-fe6576714ce8',
        'commission_freeze_days',
        '30',
        'rebate',
        '佣金冻结解冻天数（单位：天，例如：30表示30天后解冻）',
        '2025-12-01 14:09:34',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        '99bbe2ed-b15c-4916-9265-5a3b86dc8d9f',
        'direct_parent_amount_gold',
        '3',
        'rebate',
        '直接上级是黄金的返佣金额（3元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'b91e4b7e-d25b-437c-90c5-c7d665f07295',
        'commission_freeze_threshold',
        '100',
        'rebate',
        '佣金冻结阈值（订单单价达到此金额才触发冻结，单位：元）',
        '2025-12-01 14:05:33',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'cf0fb0f6-d4b7-49c6-912b-99f8c5a924e5',
        'tax_exemption_amount',
        '0',
        'tax',
        '提现免税额度（元，默认0）',
        '2025-11-28 16:54:40',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'e9cdfa6d-5764-4788-8763-fb9442e13d57',
        'direct_parent_amount_diamond',
        '6',
        'rebate',
        '直接上级是钻石的返佣金额（6元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'edaa4656-1f71-48c1-b4da-4f53d0365eb0',
        'upgrade_to_diamond_fee',
        '980',
        'upgrade',
        '升级为钻石费用',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'ef70ea86-2dfa-4916-81c1-0053e57a5718',
        'level_3_bonus',
        '0',
        'bonus',
        '钻石代理等级加成（0元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'f01201c6-0cf3-40d9-a23d-3ec3efb8a952',
        'upgrade_to_gold_rebate',
        '139',
        'upgrade',
        '白银→黄金返佣金额',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'f48d68ba-5bf0-4496-b30b-a3a50b4339b9',
        'upgrade_to_diamond_rebate',
        '680',
        'upgrade',
        '升级为钻石返佣金额',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'f6fdffa8-ecc2-4a2f-8ffb-f98b499d4f09',
        'upgrade_to_gold_fee',
        '198',
        'upgrade',
        '白银→黄金升级费用',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    ),
    (
        'f8340671-6fb6-4b85-8f25-5d050610b5cc',
        'direct_parent_amount_normal',
        '2',
        'rebate',
        '直接上级是白银的返佣金额（2元）',
        '2025-11-26 13:45:27',
        '2025-12-09 17:58:09',
        NULL,
        0,
        4
    );

-- --------------------------------------------------------

--
-- 表的结构 `agent_freeze_task`
--

CREATE TABLE `agent_freeze_task` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `commission_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `freeze_amount` decimal(10, 2) NOT NULL COMMENT '冻结金额',
    `order_price` decimal(10, 2) NOT NULL COMMENT '订单单价',
    `freeze_ratio` decimal(5, 4) NOT NULL DEFAULT '0.1000' COMMENT '冻结比例（例如：0.1000表示10%）',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=待解冻，2=已解冻，3=已取消',
    `freeze_time` datetime NOT NULL COMMENT '冻结时间',
    `unfreeze_time` datetime NOT NULL COMMENT '解冻时间（冻结时间+1个月）',
    `actual_unfreeze_time` datetime DEFAULT NULL COMMENT '实际解冻时间',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理佣金冻结任务表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_invite_code`
--

CREATE TABLE `agent_invite_code` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邀请码（唯一）',
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `target_level` tinyint NOT NULL DEFAULT '1' COMMENT '目标等级：1=白银，2=黄金，3=钻石',
    `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态：0=未使用，1=已使用，2=已失效（所有邀请码只能使用一次，使用后立即失效）',
    `used_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `used_agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `used_time` datetime DEFAULT NULL COMMENT '使用时间',
    `expire_time` datetime DEFAULT NULL COMMENT '过期时间（可选）',
    `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理邀请码表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_invite_code_usage`
--

CREATE TABLE `agent_invite_code_usage` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `invite_code_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邀请码（冗余字段，便于查询）',
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_level` tinyint NOT NULL COMMENT '代理等级：1=白银，2=黄金，3=钻石',
    `used_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '使用时间',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '邀请码使用历史表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_link`
--

CREATE TABLE `agent_link` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `link_identifier` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '推广链接标识（加密）',
    `set_price` decimal(10, 2) NOT NULL COMMENT '代理设定价格',
    `actual_base_price` decimal(10, 2) NOT NULL COMMENT '实际底价（基础底价+等级加成）',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理推广链接表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_order`
--

CREATE TABLE `agent_order` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_amount` decimal(10, 2) NOT NULL COMMENT '订单金额（用户实际支付金额，冗余字段）',
    `set_price` decimal(10, 2) NOT NULL COMMENT '代理设定价格',
    `actual_base_price` decimal(10, 2) NOT NULL COMMENT '实际底价（基础底价+等级加成）',
    `price_cost` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '提价成本（(设定价格-提价标准阈值)×提价手续费比例）',
    `agent_profit` decimal(10, 2) NOT NULL COMMENT '代理收益（设定价格-实际底价-提价成本）',
    `process_status` tinyint NOT NULL DEFAULT '0' COMMENT '处理状态：0=待处理，1=处理成功，2=处理失败',
    `process_time` datetime DEFAULT NULL COMMENT '处理时间',
    `process_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理订单关联表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_product_config`
--

CREATE TABLE `agent_product_config` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `base_price` decimal(10, 2) NOT NULL COMMENT '基础底价（BasePrice）',
    `system_max_price` decimal(10, 2) NOT NULL COMMENT '系统价格上限（SystemMaxPrice）',
    `price_threshold` decimal(10, 2) DEFAULT NULL COMMENT '提价标准阈值（PriceThreshold）',
    `price_fee_rate` decimal(5, 4) DEFAULT NULL COMMENT '提价手续费比例（PriceFeeRate）',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理产品配置表';

--
-- 转存表中的数据 `agent_product_config`
--

INSERT INTO
    `agent_product_config` (
        `id`,
        `product_id`,
        `base_price`,
        `system_max_price`,
        `price_threshold`,
        `price_fee_rate`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`
    )
VALUES (
        '02195d0e-aafc-43bd-8343-732effa667dc',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        4.00,
        200.00,
        39.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:54:49',
        NULL,
        0,
        1
    ),
    (
        '1c0f2b33-606b-420d-ab97-67a69e75d576',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        3.00,
        200.00,
        39.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:52:02',
        NULL,
        0,
        1
    ),
    (
        '4e894f8b-958c-4041-ba0b-f42f4084292d',
        '763bd813-d3d8-4441-b845-a4714737ef31',
        3.00,
        200.00,
        39.80,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:51:59',
        NULL,
        0,
        1
    ),
    (
        '57fd8be4-148c-4164-963c-a1da07e7786c',
        'f33dee46-2f63-4aa0-a2f0-8a0a9cd8c97f',
        5.00,
        200.00,
        88.80,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-08 15:02:19',
        NULL,
        0,
        0
    ),
    (
        '5c1a98bb-3c67-4c4d-aafc-444d10e21620',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        3.00,
        200.00,
        49.80,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:48:35',
        NULL,
        0,
        1
    ),
    (
        '90f9a9ab-822b-455c-af08-1505e19411a6',
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        5.00,
        200.00,
        69.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-08 15:02:19',
        NULL,
        0,
        0
    ),
    (
        'b8792f5c-ea3f-448d-a565-156dbdda9327',
        '3163adbc-410b-4813-a059-e2a0863ed136',
        3.00,
        200.00,
        39.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:48:30',
        NULL,
        0,
        1
    ),
    (
        'cc266713-7898-4f39-8ef4-22ada75efcd0',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        5.00,
        200.00,
        69.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-08 15:02:19',
        NULL,
        0,
        0
    ),
    (
        'ee8847cb-1b28-47d3-9ec5-4182b3f7a649',
        '2081c647-a1e6-4ec4-ba4c-b5d29285d397',
        3.00,
        200.00,
        39.90,
        0.1000,
        '2025-12-08 15:01:56',
        '2025-12-23 18:48:46',
        NULL,
        0,
        2
    );

-- --------------------------------------------------------

--
-- 表的结构 `agent_real_name`
--

CREATE TABLE `agent_real_name` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '真实姓名',
    `id_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号（加密）',
    `mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号（加密）',
    `verify_time` datetime DEFAULT NULL COMMENT '验证时间（三要素验证通过时间，NULL表示未验证）',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理实名认证表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_rebate`
--

CREATE TABLE `agent_rebate` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `source_agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `rebate_type` tinyint NOT NULL COMMENT '返佣类型：1=直接上级返佣，2=钻石上级返佣，3=黄金上级返佣',
    `level_bonus` decimal(10, 2) NOT NULL COMMENT '等级加成金额（来源代理的等级加成）',
    `rebate_amount` decimal(10, 2) NOT NULL COMMENT '返佣金额',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=已发放，2=已冻结，3=已取消',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理返佣记录表（等级加成返佣）';

-- --------------------------------------------------------

--
-- 表的结构 `agent_relation`
--

CREATE TABLE `agent_relation` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `parent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `child_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `relation_type` tinyint NOT NULL DEFAULT '1' COMMENT '关系类型：1=直接关系，2=已脱离（历史记录）',
    `detach_reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '脱离原因：upgrade=升级脱离',
    `detach_time` datetime DEFAULT NULL COMMENT '脱离时间',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理上下级关系表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_short_link`
--

CREATE TABLE `agent_short_link` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `type` tinyint NOT NULL COMMENT '类型：1=推广报告(promotion)，2=邀请好友(invite)',
    `link_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `invite_code_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `link_identifier` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '推广链接标识（加密，仅推广报告类型使用）',
    `invite_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邀请码（仅邀请好友类型使用）',
    `short_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '短链标识（6位随机字符串）',
    `target_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '目标地址（前端传入，如：/agent/promotionInquire/xxx 或 /register?invite_code=xxx）',
    `promotion_domain` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '推广域名（生成短链时使用的域名）',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理短链表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_upgrade`
--

CREATE TABLE `agent_upgrade` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `from_level` tinyint NOT NULL COMMENT '原等级：1=白银，2=黄金，3=钻石',
    `to_level` tinyint NOT NULL COMMENT '目标等级：1=白银，2=黄金，3=钻石',
    `upgrade_type` tinyint NOT NULL COMMENT '升级类型：1=自主付费，2=钻石升级下级',
    `upgrade_fee` decimal(10, 2) DEFAULT '0.00' COMMENT '升级费用',
    `rebate_amount` decimal(10, 2) DEFAULT '0.00' COMMENT '返佣金额（给原直接上级）',
    `rebate_agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `operator_agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付订单号（如果是自主付费）',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=待处理，2=已完成，3=已失败',
    `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理升级记录表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_wallet`
--

CREATE TABLE `agent_wallet` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `balance` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '可用余额',
    `frozen_balance` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '冻结余额',
    `total_earnings` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '累计收益',
    `withdrawn_amount` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '累计提现金额',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理钱包表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_withdrawal`
--

CREATE TABLE `agent_withdrawal` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `withdraw_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提现单号',
    `payee_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款账户',
    `payee_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款人姓名',
    `amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
    `actual_amount` decimal(10, 2) NOT NULL COMMENT '实际到账金额（扣除税费后）',
    `tax_amount` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '税费金额',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1=处理中，2=成功，3=失败',
    `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理提现表';

-- --------------------------------------------------------

--
-- 表的结构 `agent_withdrawal_tax`
--

CREATE TABLE `agent_withdrawal_tax` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `agent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `withdrawal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `year_month` int NOT NULL COMMENT '年月（格式：YYYYMM）',
    `withdrawal_amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
    `taxable_amount` decimal(10, 2) NOT NULL COMMENT '应税金额',
    `tax_rate` decimal(5, 4) NOT NULL COMMENT '税率',
    `tax_amount` decimal(10, 2) NOT NULL COMMENT '税费金额',
    `actual_amount` decimal(10, 2) NOT NULL COMMENT '实际到账金额',
    `tax_status` tinyint NOT NULL DEFAULT '1' COMMENT '扣税状态：1=待扣税，2=已扣税，3=扣税失败',
    `tax_time` datetime DEFAULT NULL COMMENT '扣税时间',
    `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0=未删除，1=已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号（乐观锁）'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理提现扣税记录表';

-- --------------------------------------------------------

--
-- 表的结构 `authorization_document`
--

CREATE TABLE `authorization_document` (
    `id` char(36) NOT NULL,
    `user_id` char(36) NOT NULL,
    `order_id` char(36) NOT NULL,
    `query_id` char(36) NOT NULL,
    `file_name` varchar(255) NOT NULL COMMENT '文件名',
    `file_path` varchar(500) NOT NULL COMMENT '文件路径',
    `file_url` varchar(500) NOT NULL COMMENT '文件访问URL',
    `file_size` bigint NOT NULL DEFAULT '0' COMMENT '文件大小(字节)',
    `file_type` varchar(50) NOT NULL COMMENT '文件类型',
    `status` varchar(20) NOT NULL DEFAULT 'active' COMMENT '状态(active/expired/deleted)',
    `expire_time` datetime DEFAULT NULL COMMENT '过期时间(永久保留设为NULL)',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '授权文档表';

-- --------------------------------------------------------

--
-- 表的结构 `example`
--

CREATE TABLE `example` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `api_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'API标识',
    `feature_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
    `product_id_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `feature_id_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '示例表' ROW_FORMAT = DYNAMIC;

--
-- 转存表中的数据 `example`
--

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '0f4af1f1-55d6-40d2-8bf7-3562f15c949a',
        '2025-04-21 21:17:09',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'FLXG0V4B',
        'a336869b-bb2f-4035-8dc3-8d5e79cb1db9',
        '[encoded data, 27800 characters]',
        NULL,
        NULL
    ),
    (
        '156d0371-8e39-46de-a4b7-ff3cda85219d',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G27BJ05',
        '2',
        '[encoded data, 21548 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '1c49a83f-c7d5-4d60-a36b-5415c40e2e1f',
        '2025-11-06 22:13:55',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'YYSY7D3E',
        'fe05b1f5-23fe-4b28-83af-daa4a6c44375',
        'sxnZzlJ3dH9u/ol9gNbfKsVKW1CJLc0tcBMx45fbqH80diKUGhmck5/4iKRLiUBLi1IVjidBGJ6PtmRItmjDittN32fD9ECOc8odKVGEK4m7Dip2/sb8CTeSo8LlfNY1rVj3zfgYifHCPRqrK+4L9y7wzSjEnqDpAAgKFCVVLfWmBeDYeOlvS5P6gbc4ST8pIeA/kzkF08S+ylqY6oegIJabOunde+Vu2MGe1MwqljJXkGe9lNvPogcH6VIJ4tlba3F84Hm/3xMZL9IGbE068bjSwfgx5HCt0GB81dt2uMNPWIpnVv2DC2rG1r6WKRHafOoqVYecBcqrAxcEADlWm6qF+LF1yNRyfzTXtoSh/qyvW9dBbYegoFfNI+6WFrnRKoZUYg791JKgVNtx6Vvz+A==',
        NULL,
        NULL
    ),
    (
        '3016c2d2-9605-481f-9f55-3f107061fcef',
        '2025-11-09 22:34:18',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'IVYZ3P9M',
        'ff07b601-0108-491b-b56e-344ef5ff74c0',
        'U3t8ZI5I2DSi1A6eIrukjUBOfSdzCqfzTdxo8OwFjVLXuDlnyTmcT+1A0ELCMMAbJZ/aEos0ZZIpx/2HCJe0/VP6Izi+qseh4GYbav1BcO1UtE0xD4wgvu2uZaVpen9zKwdIFuV6XYFlH7aeQ7H+wC03DDnJVJmENp7h5zvS5TAg6QTlXF1M31SxHwbkbwT2VdiIAuqBeiS39GuCB+9Kp6GJ7inCaKRmD0Q0ic/Sihc95iEknEZUyWL/+AZSM+7XzZR248sKEnyHpg8XI5M8CaV64uAl+rbaJAadqCR3uG+03CQG94zme5okPvhkH9ViMa9mO/TH1o/dTRc1g9nfRerLswpU8ozDwG3s2PphTJPw3lI2s9jIJ9bYgUwRYoDOm5p8u0PXTwoFoFvKLpcAR9Oix53wJ6PZgeHr0cZzTZ5dOneDztOuwVlxuHOT4jN6x3JzN41z/Qu5KTGENt5nsoIV5LJdq05Mb6XgPI7peU8tutjTavEyAi7HX8v5JVqYySOu3z7Tkng9Vbk3LfzCTMbmD1U64r71AaLEV7Cog2ldzVX9KwwtQElfSf/XzF5dUM75h32YO4gfuPf0D2zrIb6zNZcH8gaA6OSxmK/HnqwC8aZHV1H9ukoYsUcg2dCP894WtpzKrbyvN7Ma5TnBIWbeDHkyCuv/EvkeP0IoJv5fjRQuX0WCV44MLDyUHhRDXx3hjoiyldtQUG/0AHC+Oo5dK439NA8/shVW7nnZxbihwsJ/OMDzgqYiXpm1tEB4nuFpv89UMyk0U4rTqrfDq8jXAcmJH+IsIImYfnDYLDaiSrGoB/UIrUKYzX8oaxVFa44nNoVFneI3yEl1ofW9lr8NZTqxnqIIvwryDnU0ZYmEyk0G8d+HWlv03+fJwzo6L9vUjXRZJqP7vJpwlk/cU7O6GFsLYVITar320THRpd9v9Ufu10Nv9GzoA9bGbShWo2deovNQ3qh/CxitVCogxs4w40PjpmjFfZEkGovzkxISs4z9rqUi7QGm+M6gPTuxh2ECtF+SJarlobNSF4Ouia2Yu/m0vSMrw9Dy5hAu5LeyTah0q+IDTVI3jUvWTt/qsHfkPlBliKSan3CADj4B1sOtMWsvLAbnwi8PCGXmH3JyGKW3C9oyk/uKAoOL98gfWTdXDFJ1TkKi1QIf/S+rtA==',
        NULL,
        NULL
    ),
    (
        '328e4148-8a57-47d9-8cc7-e72050e83748',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'CAR061',
        '49',
        'EKmy3bXJDgGCYEPp0wBstziW/Bm4sY2727Om7a4XUyBmqHyX1OBISkRVZ8Ed4JlxwQsS/6s5rL9BKIQdVYV7fbVNPYmDo+Jk7imF2ITr258lIHen0uB3qCeuJLlOTDAYDXwsf9IzWBDdbUWoc9soRn5TO2tXgSsRKyjIWphMu7s95H1Fbui4TnJdU3p246TUQ1mDkqm4X/iRA8WtkLO8TprviNAbqGc4soDLxrPZEcM=',
        NULL,
        NULL
    ),
    (
        '4944dc14-8ae9-4a03-835c-530253b29f51',
        '2025-11-06 22:14:18',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'FLXG7E8F',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '[encoded data, 29848 characters]',
        NULL,
        NULL
    ),
    (
        '4a8786fe-5901-4d27-b4b3-b17afb98f046',
        '2025-09-15 22:45:09',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'JRZQ4B6C',
        '60e727ae-ad11-4eca-a378-5e8c23af840c',
        'qIw0D0X6DGRI0kC8c+RxEKlAlQKDcg5F9iAB1BZRVrjgnFcOfs9dsGK4nqPzy2wM85V2TptNfzRGXKWS9ZpoyXka/tjfnS0Tj0R8L8baccdJzrl2xElu8znK6fHk4BbCTXUI2qlWkFQ7SvBeg1GZNwtxHY1+zAYDkjuEiehhyepHU9RmJegxU5GFCz8sNDeVMbG/OLkaWYkR6pZCmxUR7lecw4VmWXmbiUtztjCAQ6YrfjjNEgIOFhq4rYX+y5eWjiSP1OIae3FZ8bgc+8fVHuGm2O+K8PaZeZATjwfPAY7HdvzGC9gqidQb0gL3oaGId3XQOG5ogyYTj1IzSpAdVV58d5YYKn5dpn7RH0wz1wc4pwO0NTFaa8gTWRzVSTztlyLZWWuUjOYyzMzsIsjysLa82il2mn6a4qkc/oRenf/bm7uH6simzl5PiEMe2WK8sQuhh3lk2dDtrWFsrNEXan3tb6d65PgRr8dO6aQWIElRxZrN/WUXchGK15p4rA7hxUm4XzDgTGmZ5hh3MFd26qE5RsMYOsIK9u0VibV4m4mXtebxXZTQ68krjz94NXnAc+p7u1NjcchdN/L+py0aZ/Xf11ci3yULrRLlDBvOitFlxa+rwkuRoYZsdi24W6QqOxOA7RFx1sKBemspkEyuSO0sWxMjitVVYi4DrqdcqCfDdHZwli84ms5uiaMapOip',
        NULL,
        NULL
    ),
    (
        '4aac486f-0c6a-44c7-9ec0-86e11d22f12d',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G26BJ05',
        '4',
        '[encoded data, 9816 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '508ed950-adda-4469-bca6-928bb38a7c35',
        '2025-09-17 20:32:33',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'DWBG6A2C',
        '56d08129-f784-4691-a08f-3fd32d72640d',
        '[encoded data, 23040 characters]',
        NULL,
        NULL
    ),
    (
        '5609791d-1453-4b8f-bfc0-4c7e5ca57e7e',
        '2025-10-18 14:45:51',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'IVYZ81NC',
        '3c459f05-c619-42a8-abef-71a51041f268',
        'NqH/2/mBEFq1BuA/qGgg+1cLcfloIiiwKeBSDunSEMStn7Cpq45C+xb+GtdJS2G6m4zOTiocxdfb3dQvfpC5H7yxEOyzaG/HpBxIXjrJHEVeQ9z5dJ+bgZNlgQrvBD/N4WuvL6UIFLlo70aIxWjdX/65kATr4qVYwPa3tZQR1rZgvHpU3RD30EV2+RDIvY0kcwyjjtr0b2gHBZiJrtYfxlFJsXe/BR6ns2b0TSSGo0QImJAlT8idq/dh5hVA3qMGUUw738nz7SFVbzjpghbIv+y41vOuUobcac0P/RoWhizUCPqGwtrPco4kDnuhBLS9tSbS/qSf0h8XTJlq84kGAVWNlK/fK9RCODGl39agI5t1d6JczX6T/xpjppEaKm9xi1hB+dNFLWUWkjS1jHzMqA==',
        NULL,
        NULL
    ),
    (
        '587952e1-bb92-4557-b001-72f908a6c513',
        '2025-11-06 22:14:27',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'JRZQ8A2D',
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '6mn5MLawIqV5dLzV7M6VdJKUKXGdtW5ngVQM5ILnVRPze6ZCQSBv6UYoNTXcG+uPAf41UcLnwci9ZK4h7PRapx+PkuCxzh015NZdE7xU9PEnVhuENmkKSHroooiiwWrpViH6ESMgWmUMOGDYyxp2Hb5uLK355UwJIXlkSSgsIya2aeAXMaDOcxxEE2OgHzwI4e9cx18O7okB14GD8xeqo5lpwNDs0beu18NFGUN22AYpQqfoLZKjPZgFhgsdWSc9bbl8sz8/xvlpvrFK5kHdF0y8O77MV57aCrBDqZn35V4t919m/Rn8a/WaoX+kDTDuJCKs8GNuQyy3GBP+ZKW29dnEQ/sk6Gi6dJWJW0BuZ5587Hho5vkhAZRPkcILbm+U7zNzoZapOXzj01NIWsjHgl1DSUbMA+bLZOQkgW6k5g42Sf4JeV+smAE1UITTnEfCiWWFBPLerJhVpKvHqhvVg56PqElyCoedKk51HtkIj60=',
        NULL,
        NULL
    ),
    (
        '5bbe6d07-ab8c-47e9-b6e3-809789aa8999',
        '2025-11-06 22:14:08',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'JRZQ7F1A',
        '5107c449-d6e0-4780-b8d8-3fca933e334b',
        '9YXKqheBidQjNKe7enEPJxc0LQasLehKGnOroXPyWIomHZsRGxSWP2KUFRWTqzHEpf8tPDqWnHXGZQZOyNkT0ZKCISKFXLDN1KxHm/jCr6/rBc9ZoIhm0ASFk0BhEG0REkOfvjLBU/njxgtnjMXh6Hq/zjGVhnLleAbs+RHXlQzguyqsTlRcPf0BqwiM+xY2BqLwaJ/ei63RlMPr+rdIrIkJjHu7btCD3Bm2i4q9fYH9vzXjzaFPNgJKo31ACDsXogOWxEznxxJkAGRjfgGXD/zz03qf8cyNueV/qXpLqguE/nQRB+4RHkFShex1ttTlFYgCjT7vOJR5A5YucbjGj1tDi3mZX5f63BqxcjotHgwFKT29Kp1CG8CHlxSJrIkTaiyg/wb+R8PS045d4lu9kQ//8mB+G+trtna4Hn5VvBD+Uq2yK1CNJZGJ7gtDu5mZYgoo8t6V496sXACy1YGj7UHKZieoKJdOWAeEiK17/K1D3z6HiEwTXRCuf1xW5dPXpzBkR+deXJgfck1IgC1R6j6V59T9NuPHDcna0AVp5E+64HhLC4jmYsl6E1SROZ/GpOYEjzNaj/UBAtaaI1eHV5RDqHNg+bDYr+9plX2pddE7Jf+pyan53gB8vKJjF79VQC4mVs4Fnwo+s1ryNBVyfuCOe1hz9208iXNv2pCZtQlASZutnUgn1wo3SMf8FcpcIDQjOOYzbVgGQ/nV63Q9LmEv0CB2OUJsyzbZhTYskYTeyN8AamhtrFgakrjQ9vz6XMa3x2K04KRChOkAqwRqE3tSTgwUKPDX5VNwUlZ7t+d0y5YiqsZ1c09En8Qm9NCS72X3ZB2bLZrAvC7GNye9Uuf1/DzKrEVLp3coj1ixBz0vlKVcrzT5OZNbv0qu1dptzcKSgrP1HPjMfmCmu716M/3ZD9DEUlqm/FB5xejAMtiYhn6nGo5HVlIgQjDvC2LpgFO4rzzT4s+SRRSuuUEFygX/oXumW3ny0xW0pusDyjBJYWFuaVCadWg/P27K+E5vWxN8X4Vwg6yO/2g7w89sMqkQ8g1pVvPAFFNuXTzZ0f3aX4lNGSOoMCkCu+ql1M71IxSxn0KBCauqR6St0yv9S6ojI8eQQi+1aj6n2iRVTC799DjQS4YWO9cv6V0kQg+foa6D35QOo5hDAWYv2vJ1n2Ca2QY+zPJpugblBJf4CK4oKXkvuHTOWgMD8ySCNPQtg9Jd3CNKi/2LrmTEkNtI5dbhDNteWeNGvua6ZzW8MoaJfG2TPYFKxq0Kb+IHUVfRj76FcoCsuBRMml3lVXo8qlPv3jmSXUhgGoyjTeq+6FBh6o7YQbYYG5SHjCYVZ22txIaeJZTg1ogvDSd9DISG9ROH7Ob3kNDLff8nNOFP1tHpYcUMdnsfLQIwJZATN+sMwQERWUrWLrHmwB+FfbG4btoO14TP+h/HYcemKvaEc3M0NcmEPWOocHRLQCptT4EZpLIHUS7nx6Zkw/bIJAZkIgjIfZEZ1jqtBto8i/yGpSjeTe+bE35Iiw1H1SN1JQb5Yk7Q5yhSdo7iAkgxSF2epKm2e5Gj/9/NIaJyCcdogr8v/sheeE2NP9A9hPs1qZQOpk4XI1v6kWs1BNvRCos2mHWdbfhAyr1g1/t8ztP6uGAoLpOrk87w2S4OaH03fcgcYnYmD0R0AmMHH7X16Lwt1CN3WsNd0SLL6Idphzd/wHdx6OuSP/XKFmhtSIV/vNMz7P4KswQfC+6FZ/rRjRI4HAS7lPZkkajj59Ua6Aani4XhIUNiTIR7S1iAxXmRf3TIXAI668nEopGWrf/sMvQPQYkDS3EZjoWG4CPMjF9DeBJrLQZ8lwlLScDTalJPl2zbyCHNexNGUkI/8WFiBq7t4SFR9ifmqONhHWrJ0Kbl7WdopfWVXqeJHduWX0NXItdvTOz0bABjsAwjXKaT5jqrAOKp6VEg803xim93ERMvIsHBfKC8wu0uItRSOx3cn+g9pldrzRfOZuMe/3aI2XUcStY6x9MWPMmHUnw+0kGu11pMknrcC2o3MkoN+Hr6opHz5hXricvHSqCoGJnlU+Fok4z7KxKZUfr982GWR1Ca9JEa2w20ahgtLCgdJqh0IyOvPtdPMxPxh/T8w0T1sCV8IXw1Y0PcVnghuX4YQ8hBZcVLGgNQusAyPutbZhOdL4DAbqhetmO3+Q0VhxPj37/8rQV0qi7YJ7c/nd7GBjFdhLZxbXfs+gUHn3/jzO4ZAE62R+s4UcRBAj9Tc2oROVwb4ntFrCt/8Iesjhew9/iU1YCwffSILHsoa9qufrh9sY/7Uv56FQksBibEuhw9xjgIh735tJ0QombFd8YNOeih7xsZn059ju9F9Y/FCKoFNS5jrMl/YRODniwgoU63CwMWpxKMhQCM5RiGVG7aDPMblnAabwxqL5cVVELa2YDBk5PF/2+9OGVjdGuH0agwqofQXclRQAcjWP8DTXkPwmBUYS6+B+heGdGqBgTkzFmXF4xy2tqvQCBzMn70zmGzVpWk9hxwA4EJ9AEynum/j1UdCVGzwKM6Fg5MFapCmBCYja9J48WFq6Tov8ykA6j5ZmGV5xEamKTQHYk0lsSosXYPEgvifvkg1OdlLE01ElwYbpf78y+aTeYMsbhSfWg20JtU9w50sDd2WAk7nw1Ng1UNN0NdYajkI7EvoNwZ+moUAf8z+mr2YeUual3GMxMKEa8omMDJJkbFQXqFiVAYQ7jXSstlLybmG6V34uB7tWYIb5pR60VHP2fLyxWduX7AGaYPn81lNEebau4UwwY95XCchtNb2zMdX98kH8Lzr3cITaK1OnLwBGCa+aUBUc5dPkj880CcTKXzx5hZ/Hii1oIqqaQUCwgIy8M/tnbmtWzYS8vVqBMW+8I8Mf6YdgOX1t1F1gj83W9WxIUaU5Y8cMvrs6e/Z5kRzTBn05LA+5v9p3lGym8/ETVuiHbF5u1wVlfmbbZWlFl4kc4QRj3/9Wo+62Y=',
        NULL,
        NULL
    ),
    (
        '6f68893e-80e9-4c01-99e8-28b06b5164f0',
        '2025-09-18 20:32:51',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'JRZQ5E9F',
        '97e6a6fc-94a8-4f56-be0c-f6886f22400e',
        '[encoded data, 13932 characters]',
        NULL,
        NULL
    ),
    (
        '7a45370f-c088-440a-ac72-cc9e2b922585',
        '2025-09-17 18:20:31',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'JRZQ09J8',
        'fd18332c-c798-487f-a028-086a5f6e0474',
        'fnzxyJ/OiwJaWhuRCxHPJFQod4xr6oFpkujFLNWXxiMTDXOp1EoQF0C4i8FVEbmuXdsNapKkYh8wHZhcR21R7TfTb5HaRKL6Q53/RxeWJwHZSwVzTbbOjcXNBII9ijB2swwuTKOfI1FTxaPYBfBwcpUz7Vksu1xX30G1J1YYy73DlMNMbhPW5wBtelAvryHWvcAm7N8dXUdmPM+QCNZQQg==',
        NULL,
        NULL
    ),
    (
        '7a7f6754-d48d-4fce-ad46-24ea4af93195',
        '2025-10-28 22:09:59',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'IVYZ7F3A',
        '0e237905-661a-4128-b879-e214d2050f2b',
        'nbft302GLyaG+PiCfirKy3w/dRz0rkZN71OI5iZ1yl0np8+maB+1pJNZXb/W4GIMjh5xu+GOcB5ZsiPOgqKXvMxf3GB6OLzWHQeRoJAewuYLuIS/goHWeny+X6FY6lcV7T6m4GO/qVeSQhmnFarGLXM1LB3deYzPGXZoP1VhgmXlD6u1tWhXgLCF1ljpgkJmoagPO6t+G1QOG4BLrpWPcRSKc0Tg005EsqZh211aSBzbhIGAaZjfO/RjtLs5WYP/lBUz69firMgSjEpBTZxN5mq2COlswdlPVbLYolilvCTz7LMuRviSPFn55XFiJ/uPJwNG06l4Z9IZGcPNtDnd9hm0PqCS5V8PNkAgJxP4hwakOJYV09iztTSEujaP/x8JI6XTcvhZYS6JgfbFKItMOgFy6cXgSHMfQzVWld4QloJh3TFjCNp9PCG5m+lO/AwQRYoYYdZ0ipu0gtc+JcT1qNXsH6s8zPfLLHaleyVrrZUmyA71g5dqeY+TuK7p58Vh4C5kSlWA+sMjALPHUxfSrvR2xZimY/e9k7o0xwGmz9mYJybu2EFE29ZiJnk03efvLF2CELuTY52Hyl1gj55l/Q==',
        NULL,
        NULL
    ),
    (
        '85bba6d0-741e-4276-852f-37f4959e63ca',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G03HZ01',
        '43',
        'dErEVrB1NfkA4+V8VLkwU5n4XibnrxtcykECh4Wec/AcPQwh8GgQWOTOmDYHFK6QKONrqJIIru7ZcHRby/DEMu430fR3KOcbfnjsHSdHAzannZvsAXMBdBzRHxI+aPoFk/s1j+nBr0vMTOjzh0GWLqLh4wn/KYDR1lEq0SvzfTqGqkU/8eZ73NSwrUzq7XZwTt7W/U7JlXiAyeXfVOxRxMbm1iE4a3mhDr0VdOPvOEIi9Lt5vz4iVd7VuJMzl7ei',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '92ea7756-5e94-44b9-9640-b503def31cb0',
        '2025-12-17 17:46:05',
        '2025-12-17 17:46:05',
        NULL,
        0,
        0,
        'JRZQ6F2A',
        'bb36f549-3d95-4513-bc91-ed0a0caad7b8',
        '[encoded data, 16128 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '94a3ebd3-4e0d-4ed7-a744-794656dd3464',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G05HZ01',
        '7',
        '[encoded data, 38764 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '984b70f4-4bb0-4bf8-8045-ced5d652fc84',
        '2025-11-06 22:14:36',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'DWBG7F3A',
        'e19513e2-fb4e-4a66-ab17-07a8227d4edf',
        '[encoded data, 20268 characters]',
        NULL,
        NULL
    ),
    (
        'ada09588-ba0e-48c5-a381-1eaa25d5ae26',
        '2025-12-17 19:51:05',
        '2025-12-17 19:52:08',
        NULL,
        0,
        0,
        'JRZQ3C9R',
        'a1e2a04a-ca97-4356-a7b0-5f5663d4303a',
        '[encoded data, 26328 characters]',
        NULL,
        NULL
    ),
    (
        'af4674f7-69af-485b-a448-904c2fd950d4',
        '2025-11-06 22:38:57',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'FLXGDEA9',
        '4e5fe454-cfea-4e5e-a214-3b316a3b3418',
        'YUC8sJNdjm6oE+8jLchTpnW77492jadVIuwqUl+VnIQs/5dhMBOBOC9Qn++QQXMcoiDl5Yzs9P0pmp0P1fiiFJ3yyMR3s1SWzoV3YsIDYVVP9TOutTTw6QkWan8K7MxgrqpotUnfBXq93grILnt5ELpcLFz69nxHpK14dq2lwzMy7eFzbi8I4kI9aG1iqubc',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        'b3dde64e-f3f7-4790-815e-2581b8af2e78',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G35SC01',
        '6',
        '[encoded data, 14208 characters]',
        NULL,
        NULL
    ),
    (
        'b6e576a5-a92c-4d60-aca8-875e1a474b1a',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G09XM02',
        '1',
        'nq0R7zEm3/VfLE8iqd8hW0WgjpdmqclukG3eUYhxxnGvk9Lrg4X8wjFee9KvMsfPusaXe3pncTHPHQ5SWCgSKZqRnKW+Vfate2U1xZYbA+MBSw1c8g0SMQ1o75VXpVsFHATn0YZaAySsez5QhjKiHSxQA6Qkjk/UWWEmR8B+DDERIMuCxFL8Mh7GaFE0cGQ/TDrT0R8Yix7eivM5OwfJHshOhuTBhTmFDdy7HsTGv98=',
        NULL,
        NULL
    ),
    (
        'badc810d-de62-437d-ac15-7374416b6130',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G34BJ03',
        '5',
        'srkzTl2LGnChDzlzfar9u4Yjg6AXUOP0heVUBs7WEr0czOtP3Kgeey1+nquI3TqMdNLoUwjNFaut1NQvT0wi1RRX0ZnXbNBvWpcDNp8PuWLWBN2s1zq6+IZGmNrpCZErhb1od5hqyun0OzIj8F/BDl8l1tMJTxXGjDaAsgr0/Cae2uLSAlGH/r0OdR/R9dTCmeSnC5Dqe1AoeJw/scOjGAltnOvKvO3+nuNF9IGLSoWhzaEkl6/oaMEbjLZq5SFa',
        NULL,
        NULL
    ),
    (
        'cca740d4-6f70-43af-b561-f34ad0a5d89d',
        '2025-10-28 22:06:57',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'QCXG9P1C',
        'fec397a7-4fc2-40fc-b1c6-fbc8c2979253',
        'bGfP5JrgFYAO735YdC8AvuwQgeDhRK+JXji7QeM1ITN5z/x0HkDd0OKH4FimlNBssh7AALWdkHXJAa41uBzJMUtxdh1Dn0i5UUfdAtlZ+YEccl/AZjMLvj+Rd47I/ssWiyrpGeu/WbhDHcJir5CqjoOh/c5sH/oECYFpw7o1PWK8rw8rRsqFpcuxp9LCl1Fa+wqkz3XmXOe/fVL1IoQs4tkkzzyJwYiyB08ddK8ZAStJuRnT0wOfgVCkSu9vB6fEL5vDahJ09NEidk/0m0s/IkB7IySvsCWtKA0zha7RvyztNdr5BIgwDLiewToACY+q9kfxzx9/nqmA4VIwQwLjX0gRqCE9VZfMFY7jFfxtMbEggNBIIlVNWNRXIgkDZcHEt02/zF1jwN+9pGMh2C/iNGgIIb3Dy/KhHrpkcMGGD2Y4I+f48V4Xh6JO87A0zjhuDaYQS7qUOafHBzL979kgSouCKAZ/NZp0VW61BqehS8wm1MWeWFww1PLaFZZxNzZPz2Jt4vdlutDOjFWJtjWjKZaLpABWcwzYcDV3C3VE0EWgFZ8e5yqFThP234ABrF1GoVcwcsYNbz3kFAuujHrCo3NXvMlcWyMb0vnI1LGaao0=',
        NULL,
        NULL
    ),
    (
        'd93501e5-94fd-4ef5-9304-9c0d071b2ccd',
        '2025-04-25 02:54:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G11BJ06',
        '65',
        'AxifcoWQsBewzDEd6xAhkM3qUNWTHJY9LIRfpFJgDtzgpVU7z1hqBIiqIDDwrsg/QtLpukjEUXOQ01ONxTy1W4gK/a0P3n/248pKXDGlWZfIpNhEoqSX1OfYxWp7kODKaGEB7j12fDvjmaZhvA8pxMpw1MfUzW2YKXgixf3BJ4k82DHSyJ7e92+unqUF+IoPD+eLt3n3YSeOs7DyKp/PuqDxHJ+TM9r6lEV5wqT5pdBg3N1/NCllPBDoCOFjWgodHH6xZjTqCZqGiInWwxELxg15i/aTktw0a6OLD3PwCwSS7OtMocvBnwcdyHr9ytAWs3LK0RBaxHDP3flrr9GonXsJronXtGAVnkM3k5a8JMhlcjdu3+OlIFBdsfsSx2GjoHQVEeaIc49hlPYClBB1F+IVrGcr8LE/JDqjTU0RDMQu/SMe2Rhs3Nrbh4lyVGN6S5PHQRKah04/V3pr7BUw7lBoWCR6QjPTWZO/EW5uxcxcQgJjVCa7eK9V4tvuJylZxHxABlZbJK3hwMgE6noReCHXNUL0pZ96BVx3Es7zzcWe09CTliZGaXgHi7mz7jMvW/D/bcmgdZyKtn4w9NPTgZlQ4CzrJawBIohUfvMQyZFtmrEkyWOgyidjQv75H1P//4W97IM0Ir0fl1gXb6IpM95FHNHz9Jx3ATP5IBNSPMs5K435KYVkOosUd5Iha3M2miprG5sncZxpNm1/BW/VqLmtHieRKPiB2NCsNLc0xZFY0a8O08NOaudtalkobxdJuwbIWSh6+2tqkn4H6LI82UFdl6RTaLP2cS4PtfYLj3saYGygzvTOuqTwnHb0cOrb1snHLpKRgn+SFWhd0yIEJUQnbJoUJ+DDMHQPLamBOD69Pj1jKNiqFhh5lyLjQyyWkOK6nfBjP4/mUtrfmObzRgHs4E4H6bTak6DCrxm7Qd9vu/DFwU4acQ6q3wEBmEMay/zO1L6JTayqnvJhQ6Pdi+OlWVtpdksKaGMpL+YyFgffkIp7gotB7mkbLNpEAg5BHbZ5fHm/IEHpmuu5Gy3YtHIWIaNL52/A2Ugl4sbtIZTi3bJwSoFos60KDbOMNVPIg3zahFAlRC4ZGmjXuJP9Tgdf66l6vm/BJixPo/224ZCzJwKRi8WUdtdieYa9funR',
        NULL,
        NULL
    ),
    (
        'db6801d5-7465-4e2f-8d45-f9a8943cbbf7',
        '2025-11-06 22:14:49',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'IVYZ8I9J',
        '4a182451-523f-40fc-ad07-3cfa236312d0',
        '7sadp6JHEgMo46V+ZkcriiK3aZJ0j2jVoIJmKuX1DCF88wHVD3vKqFt44+bFp4qIaNwqj1wqjyjw24p0a33mWr+mI8yrQe+7ZH3hEJnsfTllfoRy+fV79Obwnw/+hSjWlq3pigRMr+zgZWzSUI7LimbRYvyoQkfypjwgr+YjSwjRArs1RB3C6o8rDkkvwPiSx9G354NNNGIUu4OXH74aanxxtt5CMhS5ge19tZv4NBBPeL0EiNITjO3QrWfisrhQF6rLni8GXcyO/LidKsdyiwQvP4Qpgkv4h4EEdC8F+IaLcXqccVrjmC3v/ocOiLKm/3NiPhIUHP7nilAZXEdRWKduhXdyLdJL3uS0vkTdFgffKB5ikNGvRGYvm25nBSO1',
        NULL,
        NULL
    ),
    (
        'e053f19d-3b1e-4fa9-92a8-f0ae57b105e6',
        '2025-04-21 21:17:09',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'BehaviorRiskScan',
        'cd048d9a-d862-4b4e-94d2-6f5b37ab73f9',
        'MOW8C5bkWO2tfAkGRmvdCLJFYZZyNYdw/2WRvJY1dQDGifRFSTilK1N9V00h2KEha3/KWI7GWAsicV1CRMTHD2VMQhUYyKlDFBrpudyG2diy9cYfH1UH/fYgdVHafP01ikhGr4EyswcNfjLZxg3OLTDiCcjs+m6XNEwgOkzZ2h31Aa255ILUqaXnXQ8U+k0pTR3deaAGF5wj1PcJAeYCDE73NWsIaS0wC0vt/E/0PyUcU2iZ3gboa1ahI5/6fX7Ktp6F7ScNp+MIuK4nqRd+f0u8rsyQs3SYkZquqZP62RyFhICh48+RV5EgoJ2KtgwDgGQJEwh28tVvUpBFxw9Yr4t/f9QRSocLn95NuMdgwWf7E3W91WLn1718aT2my4ldixHYinnW+xSCgeh7zO4nNGmuGybY62D8J0kYsdldA4U2fYVT7rqt7AE9dqccK4QkeQAUh6krfBM3ARtPDy6gMwrPVG6Ua2WVKVuzyD1GyXhfOySnUCFjjGHifEHSi68J5tFOvSrWKpfRU4qFJDO6pDhsFga/AObDzDss/jkYyhR2//ot+xwVl2UunJYg1D3h6g+GkCXAOBcOf49tqM8V3svfvo46xl9aePrqjsgLvz6wVG4gpNLzJRbAtVNxRQ5+rjP2qQVVGuM6VP9yo2/juSCchmrE1sEfrrB+sXO2dihCIrSDJdfVurNGMF65svPLjVjH2ZrGDbN/DNyFlHPMr8pWhvNd5OnNq5CzvC8zoIFUHys4IPf4FMHkPhRSODT0sFO0v9jlXOIntP4EtuUq+HAdhT6s4LZYlqVEB35HXrsL1NiihpX2Y1P4Oowvj/twMxQ1F/1yc+cjjuzQl9dV3R1HAU8xEjGdyPlVwImWw6IiiSnR4s7Cl/ky3LRiTbBhjOQBjnuIigKkPv0ywpA2Hq1FyZxM0kMBADuRTxuIzf+4pwQzJojgljcALkGWGXpCt0mtI7aeMF556IUg9oGG4xErYC7XEAOp8JUPyW5ge+WPbzj3lKMMhgnHPE2e2mFYudSC/OcBoqq1S1WV//p9flZV+xPmSJ1TlbnIYNy8Mr6fc5uVCVzqcMDWsxhsmQQsT4PAPb+570L5gNxVUYCgiOwzQ0eSg1qkcgH+vBjiXJMrQ3Eg/Xp27oK2vt8b49tTWSaDhKt+cVI4VxO3FFVOT72CHeXMryMo550/Y86zMHn0BgD+5lefym5bpzUiKgPiTc+2kxW0C8hBg0H+PJXeQrkP4h70mXHRvOsrNGK8hTg=',
        NULL,
        NULL
    ),
    (
        'e0884f3f-5f22-46b0-98c6-49821fe9a4ee',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'IDV044',
        '58',
        'j8cVPMfn53GgvT8daX+VMCTHUG/ym1YyZumOKBqcthaXTzwpFosSu8IVIfkO2hY7MbvdF3v174YIq+kxjXL2zx/nhGr9iW7GhBFdQ5fwJ0oU2OFcvAZA9YGt5hPUFbNM/onqFKxMXt0fPG3rynWwDhr2nr1rZzr0ctoHtbfz9SlgmzJTzvn3N2LpDEEoY5xe6pFRYXjdc4mM8qAazYemTbmExIvGR+aR19PyA005wpU=',
        NULL,
        NULL
    ),
    (
        'e5d6214e-e425-43db-97a4-6dde56b83e02',
        '2025-04-25 02:54:13',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G29BJ05',
        '66',
        'lrrUW2Nlnx+v197MZ8P3R2lYBdfz61tNxL3cu4t26h7nozPAV4YT/axUmGF6gIjfp7fB/z2Rx5KhztYAPOKUW3LUWj/gnkZBpoE1vop9vTZ2EFZBzHh8HURRl5xdIg9K',
        NULL,
        NULL
    ),
    (
        'e9b6c8f7-9eab-4e5b-a4f2-e8bf882302f0',
        '2025-04-21 21:17:09',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'G28BJ05',
        '3',
        '[encoded data, 7896 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        'eabcc7cf-ff30-4e4c-a9f5-a70a06e7f456',
        '2025-09-15 22:45:09',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'DWBG8B4D',
        'c26935d8-96b1-4883-b395-e3fdca84efc9',
        '[encoded data, 29784 characters]',
        NULL,
        NULL
    ),
    (
        'f3418f1c-11a8-444d-89c8-05d4c3c03a5a',
        '2025-11-06 22:13:40',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'YYSY8B1C',
        '249532c9-bad2-4c94-8158-154ff05ce956',
        '1muazqNRa//LiJ5am97li/axfS+n/3MgAfL0371TaMiIz1toNCNbT3DEze96NtL00ZO1lARv+BDCDAvtncVAEfExeZAGt9fGoHwABrl49aUrdK/SWD0PiHT3Nj557NiKpegV7cznSVIL9guEOt/5PGUoAAss7mmwd1ti1URBFMb946SZXuZGwrGAnuFpGcMKn/DK868Xif98ynfS/5kKtjfdxI/HY4B7RLZo9PYKjXc=',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        'fbfabe0f-92eb-40b2-be2f-0541ddb42ff6',
        '2025-09-21 02:45:12',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'QYGL3F8E',
        'b174bf2e-5991-4673-9ce6-c48a318ec200',
        '[encoded data, 476141 characters]',
        NULL,
        NULL
    );

INSERT INTO
    `example` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `feature_id`,
        `content`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        'fc03f7e0-8257-4728-9592-69cb190ca78d',
        '2025-10-28 22:03:30',
        '2025-12-09 20:18:42',
        NULL,
        0,
        0,
        'QCXG7A2B',
        '28250d79-0759-4e98-89c4-6db0f468b5aa',
        '7NLhryd2y3AZhisMRHa0Sr/skszIb7qmT7Jbdo8vxNA=',
        NULL,
        NULL
    );

-- --------------------------------------------------------

--
-- 表的结构 `feature`
--

CREATE TABLE `feature` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `api_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'API标识',
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '功能表' ROW_FORMAT = DYNAMIC;

--
-- 转存表中的数据 `feature`
--

INSERT INTO
    `feature` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `api_id`,
        `name`
    )
VALUES (
        '0e237905-661a-4128-b879-e214d2050f2b',
        '2025-10-28 21:28:54',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'IVYZ7F3A',
        '学历信息'
    ),
    (
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '2025-11-06 21:52:12',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'JRZQ8A2D',
        '违约失信'
    ),
    (
        '249532c9-bad2-4c94-8158-154ff05ce956',
        '2025-11-06 21:50:14',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'YYSY8B1C',
        '手机在网时长'
    ),
    (
        '28250d79-0759-4e98-89c4-6db0f468b5aa',
        '2025-10-28 21:25:16',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'QCXG7A2B',
        '名下车辆'
    ),
    (
        '3c459f05-c619-42a8-abef-71a51041f268',
        '2025-10-18 14:44:47',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'IVYZ81NC',
        '婚姻状况'
    ),
    (
        '4a182451-523f-40fc-ad07-3cfa236312d0',
        '2025-11-06 21:51:36',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'IVYZ8I9J',
        '网络社交异常检测'
    ),
    (
        '4e5fe454-cfea-4e5e-a214-3b316a3b3418',
        '2025-10-23 15:48:22',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'FLXGDEA9',
        '本人不良'
    ),
    (
        '5107c449-d6e0-4780-b8d8-3fca933e334b',
        '2025-11-06 21:53:41',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'JRZQ7F1A',
        '全景雷达'
    ),
    (
        '56d08129-f784-4691-a08f-3fd32d72640d',
        '2025-09-21 20:01:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'DWBG6A2C',
        '司南报告服务'
    ),
    (
        '60e727ae-ad11-4eca-a378-5e8c23af840c',
        '2025-09-21 20:02:26',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'JRZQ4B6C',
        '借贷表现'
    ),
    (
        '97e6a6fc-94a8-4f56-be0c-f6886f22400e',
        '2025-09-21 20:02:26',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'JRZQ5E9F',
        '借选指数评估'
    ),
    (
        'a1e2a04a-ca97-4356-a7b0-5f5663d4303a',
        '2025-12-17 19:50:30',
        '2025-12-18 19:11:22',
        NULL,
        0,
        1,
        'JRZQ3C9R',
        '支付表现'
    ),
    (
        'a336869b-bb2f-4035-8dc3-8d5e79cb1db9',
        '2025-03-07 16:10:43',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'FLXG0V4B',
        '司法涉诉'
    ),
    (
        'ae4ac6bf-a16c-48d0-bfce-1a73c5eed3b8',
        '2025-10-23 15:49:02',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'IVYZ6G7H',
        '婚姻状态查询补证版'
    ),
    (
        'b174bf2e-5991-4673-9ce6-c48a318ec200',
        '2025-04-21 14:54:53',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'QYGL3F8E',
        '人企关系加强版'
    ),
    (
        'bb36f549-3d95-4513-bc91-ed0a0caad7b8',
        '2025-12-16 19:05:19',
        '2025-12-16 19:05:19',
        NULL,
        0,
        0,
        'JRZQ6F2A',
        '借贷申请'
    ),
    (
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-11-06 21:51:11',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'FLXG7E8F',
        '司法涉诉'
    ),
    (
        'c26935d8-96b1-4883-b395-e3fdca84efc9',
        '2025-09-21 20:01:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'DWBG8B4D',
        '谛听多维报告'
    ),
    (
        'cd048d9a-d862-4b4e-94d2-6f5b37ab73f9',
        '2025-04-21 14:54:53',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'BehaviorRiskScan',
        '风险行为扫描'
    ),
    (
        'e19513e2-fb4e-4a66-ab17-07a8227d4edf',
        '2025-11-06 21:48:46',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'DWBG7F3A',
        '多头借贷'
    ),
    (
        'f40b8f76-ca07-422c-851e-e0767b0ae747',
        '2025-10-23 15:49:38',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'IVYZ3A7F',
        '学历信息查询'
    ),
    (
        'fd18332c-c798-487f-a028-086a5f6e0474',
        '2025-09-21 20:02:26',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'JRZQ09J8',
        '收入评估'
    ),
    (
        'fe05b1f5-23fe-4b28-83af-daa4a6c44375',
        '2025-10-23 15:49:49',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'YYSY7D3E',
        '携号转网查询'
    ),
    (
        'fec397a7-4fc2-40fc-b1c6-fbc8c2979253',
        '2025-10-28 22:05:42',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'QCXG9P1C',
        '名下车辆'
    ),
    (
        'ff07b601-0108-491b-b56e-344ef5ff74c0',
        '2025-11-09 22:33:22',
        '2025-12-06 18:23:29',
        NULL,
        0,
        1,
        'IVYZ3P9M',
        '学历信息'
    );

-- --------------------------------------------------------

--
-- 表的结构 `global_notifications`
--

CREATE TABLE `global_notifications` (
    `id` char(36) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    `notification_page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    `start_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `start_time` time DEFAULT '00:00:00',
    `end_time` time DEFAULT '02:30:00',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `status` tinyint NOT NULL DEFAULT '1',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `order`
--

CREATE TABLE `order` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '自生成的订单号',
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `payment_platform` enum(
        'alipay',
        'wechat',
        'appleiap',
        'other',
        'test'
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付平台（支付宝、微信、苹果内购、其他）',
    `payment_scene` enum(
        'app',
        'h5',
        'mini_program',
        'public_account',
        'test'
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付场景（App、H5、微信小程序、公众号）',
    `platform_order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付平台订单号',
    `amount` decimal(10, 2) NOT NULL COMMENT '支付金额',
    `status` enum(
        'pending',
        'paid',
        'failed',
        'refunded',
        'closed',
        'refunding'
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending' COMMENT '支付状态',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
    `refund_time` datetime DEFAULT NULL COMMENT '退款时间',
    `close_time` datetime DEFAULT NULL COMMENT '订单关闭时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `order_refund`
--

CREATE TABLE `order_refund` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `refund_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '退款单号',
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `platform_refund_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付平台退款单号',
    `refund_amount` decimal(10, 2) NOT NULL COMMENT '退款金额',
    `refund_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '退款原因',
    `status` enum(
        'pending',
        'success',
        'failed',
        'closed'
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending' COMMENT '退款状态',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `refund_time` datetime DEFAULT NULL COMMENT '退款成功时间',
    `close_time` datetime DEFAULT NULL COMMENT '退款关闭时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '退款记录表';

-- --------------------------------------------------------

--
-- 表的结构 `product`
--

CREATE TABLE `product` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '服务名',
    `product_en` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '英文名',
    `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述',
    `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
    `cost_price` decimal(10, 2) NOT NULL DEFAULT '1.00' COMMENT '成本',
    `sell_price` decimal(10, 2) NOT NULL DEFAULT '1.00' COMMENT '售价'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品表' ROW_FORMAT = DYNAMIC;

--
-- 转存表中的数据 `product`
--

INSERT INTO
    `product` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `product_name`,
        `product_en`,
        `description`,
        `notes`,
        `cost_price`,
        `sell_price`
    )
VALUES (
        '2081c647-a1e6-4ec4-ba4c-b5d29285d397',
        '2025-11-06 16:12:25',
        '2025-12-23 18:53:08',
        NULL,
        0,
        0,
        '消金报告',
        'consumerFinanceReport',
        '<p>消金报告</p>',
        NULL,
        1.00,
        39.90
    ),
    (
        '3163adbc-410b-4813-a059-e2a0863ed136',
        '2025-09-21 20:03:32',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '个人大数据',
        'personalData',
        '<p>【人生风险雷达】——您的智能风险导航仪 在瞬息万变的时代，未知风险可能潜伏在每一次投资、职业跃迁或社交关系中。天远数据个人风险报告，通过AI大数据技术为您的信用画像、生活轨迹与决策路径进行360度扫描，像贴身导航仪一样提前预警风险盲区，助您掌控人生方向盘。</p>',
        NULL,
        1.00,
        39.90
    ),
    (
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        '2024-11-04 16:25:19',
        '2025-12-08 15:00:50',
        '2025-11-06 21:54:48',
        0,
        0,
        '个人风险',
        'riskassessment',
        '<p>【人生风险雷达】——您的智能风险导航仪 在瞬息万变的时代，未知风险可能潜伏在每一次投资、职业跃迁或社交关系中。天远数据个人风险报告，通过AI大数据技术为您的信用画像、生活轨迹与决策路径进行360度扫描，像贴身导航仪一样提前预警风险盲区，助您掌控人生方向盘。</p>',
        NULL,
        1.00,
        49.80
    ),
    (
        '763bd813-d3d8-4441-b845-a4714737ef31',
        '2024-11-04 16:25:19',
        '2025-12-08 15:00:54',
        '2025-11-06 21:57:58',
        0,
        0,
        '租赁风险',
        'rentalinfo',
        '<p>【租赁避雷针】——租客信用防火墙 当您交出门钥押金时，是否想过对方可能是「失信老赖」？ ⚠️ 表面光鲜的租客实为被法院执行的职业「租金能欠者」 ⚠️ 号称「房东直租」的二房东竟有非法集资前科 ⚠️ 隐瞒的群租集底让租客面临被清退风险无门 天远数据租赁风险报告依托大数据技术连通权威数据库，为房东构建多维防御体系，精准扫描高危租客，让资产安全从源头可控。</p>',
        NULL,
        1.00,
        39.80
    ),
    (
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        '2024-11-04 16:25:19',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '婚恋风险',
        'marriage',
        '<p>【婚姻照妖镜】——婚恋防骗预警系统 面对杀猪盘、重婚骗局等新型婚恋陷阱，仅查婚姻状态还不够！天远数据婚恋风险报告，深度融合全国司法大数据与民政婚姻档案，7x24小时扫描对方隐藏的「黑历史」与「风险关系链」，为您的感情与财产筑起法律屏障火墙。</p>',
        NULL,
        1.00,
        39.90
    ),
    (
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        '2024-11-04 16:25:19',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '小微企业',
        'companyinfo',
        '<p>【企业风险CT机】——司法级全息商业决策系统 当您评估一个企业的价值时，账面上的数据可能只是真相的冰山一角。企业风险报告依托大数据技术直连权威数据库，通过司法穿透、财务验真、关联网络三重扫描，为企业主构建「决策安全舱」，让投资并购不再盲人摸象。</p>',
        NULL,
        1.00,
        69.90
    ),
    (
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        '2024-11-04 16:25:19',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '家政风险',
        'homeservice',
        '<p>【家庭安全警报器】——家政人员风险防火墙 当您把家门钥匙交给陌生人的瞬间，是否担忧过这些隐患？ ⚠️ 自称「金牌月嫂」却遭前雇主控诉偷窃金饰 ⚠️ 持假健康证上岗的护工将传染病带入母婴室 ⚠️ 被法院列为老赖的保洁员卷走客户预付工资 家政风险报告依托大数据技术深度打通司法权威数据库，用司法级风控手段为您的家庭筑起三重防护网。</p>',
        NULL,
        1.00,
        39.90
    ),
    (
        'f33dee46-2f63-4aa0-a2f0-8a0a9cd8c97f',
        '2024-11-04 16:25:19',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '贷前风险',
        'preloanbackgroundcheck',
        '<p>【信贷安全盾牌】——贷前风险诊断系统 当您审批贷一笔贷款时，未知的借款人司法炸弹可能正在侵蚀资产安全。贷前风险报告依托大数据技术深度融合司法等权威数据库，为金融机构构建多维防御网，实现风险层层递进从「经验判断」到「司法等级」的质升级。 法律声明： 本产品仅提供个人信用大数据检测，不提供放款和修复征信服务，不查央行征信，无任何爬虫数据</p>',
        NULL,
        1.00,
        88.80
    ),
    (
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        '2024-11-04 16:25:19',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        '入职背调',
        'backgroundcheck',
        '<p>【职场X光探测器】——司法级人才风险防御系统 当您向候选人发放offer时，是否透视过这些暗雷？ ⚡ 光鲜简历背后承接的竞业协议与商业壁垒前科 ⚡ 高管候选人关联的境外敏感行业投资版图 ⚡ 核心技术岗员工的学术论文抄袭黑历史 入职风险报告依托大数据技术连通国家权威数据库，为企业构建多维防御体系，让人力资源决策穿透信息迷雾。 法律声明： 本产品不提供背景调查服务，不涉及个人信息采集</p>',
        NULL,
        1.00,
        69.90
    );

-- --------------------------------------------------------

--
-- 表的结构 `product_feature`
--

CREATE TABLE `product_feature` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `feature_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `sort` int NOT NULL DEFAULT '0',
    `is_important` tinyint(1) NOT NULL DEFAULT '0',
    `enable` tinyint(1) NOT NULL DEFAULT '1',
    `product_id_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `feature_id_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品与功能关联表' ROW_FORMAT = DYNAMIC;

--
-- 转存表中的数据 `product_feature`
--

INSERT INTO
    `product_feature` (
        `id`,
        `product_id`,
        `feature_id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `sort`,
        `is_important`,
        `enable`,
        `product_id_uuid`,
        `feature_id_uuid`
    )
VALUES (
        '03bd752c-43e2-4eaf-be56-b82b611f4cb5',
        '2081c647-a1e6-4ec4-ba4c-b5d29285d397',
        '5107c449-d6e0-4780-b8d8-3fca933e334b',
        '2025-12-17 19:53:22',
        '2025-12-17 19:53:22',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '07f33bc4-fa76-4f21-bc7a-b1fff02c5ef6',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        'ff07b601-0108-491b-b56e-344ef5ff74c0',
        '2025-12-08 14:52:16',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '0c9a39c1-e0a1-4a42-905a-62087c81664a',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '2025-12-09 19:11:20',
        '2025-12-09 19:11:20',
        NULL,
        0,
        0,
        3,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '12bc142d-7820-4d0c-b557-dc914b45bf3b',
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        '5107c449-d6e0-4780-b8d8-3fca933e334b',
        '2025-12-09 19:12:14',
        '2025-12-09 19:14:14',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '2b0cc54f-0110-4da0-835e-ab2177b03fbb',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-12-09 19:13:03',
        '2025-12-09 19:13:03',
        NULL,
        0,
        0,
        4,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '2f93348a-d847-4c9f-9fd4-35a9b620105a',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        'e19513e2-fb4e-4a66-ab17-07a8227d4edf',
        '2025-12-09 19:11:20',
        '2025-12-09 19:11:20',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '389c0460-0e36-4118-bbb3-6c47873e4e59',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        'e19513e2-fb4e-4a66-ab17-07a8227d4edf',
        '2025-12-09 19:13:03',
        '2025-12-09 19:13:03',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '38c80a68-cdbd-4b16-9b5b-4f7a05d643cc',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        '4e5fe454-cfea-4e5e-a214-3b316a3b3418',
        '2025-12-09 19:13:45',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        5,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '3fc4133d-3e04-40a3-a785-aa74cc7a97ec',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        '4a182451-523f-40fc-ad07-3cfa236312d0',
        '2025-12-09 19:13:03',
        '2025-12-09 19:13:03',
        NULL,
        0,
        0,
        5,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '4ac8c25b-f79b-46f9-9407-46567a705d87',
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        'b174bf2e-5991-4673-9ce6-c48a318ec200',
        '2025-12-09 19:12:14',
        '2025-12-09 19:14:14',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '57aa0fdf-a795-42dc-a963-735b71d734ca',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        '3c459f05-c619-42a8-abef-71a51041f268',
        '2025-12-09 19:13:45',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '58efb5a0-8c24-4e7d-a047-19cd2934b48c',
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-12-09 19:12:14',
        '2025-12-09 19:14:14',
        NULL,
        0,
        0,
        4,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '5b9a41e3-fceb-4d43-be1e-eceaab51fa18',
        'f33dee46-2f63-4aa0-a2f0-8a0a9cd8c97f',
        'ff07b601-0108-491b-b56e-344ef5ff74c0',
        '2025-12-08 14:52:19',
        '2025-12-08 14:52:19',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '5f4a727e-9171-4a6e-8f10-d6b0ffff02da',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        'fd18332c-c798-487f-a028-086a5f6e0474',
        '2025-12-09 19:13:45',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        3,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '6063003b-9eea-4fcf-937b-50a18bac40c2',
        '2081c647-a1e6-4ec4-ba4c-b5d29285d397',
        'a1e2a04a-ca97-4356-a7b0-5f5663d4303a',
        '2025-12-17 19:53:22',
        '2025-12-17 19:53:22',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '65a6ca18-f60c-42c1-b9de-6a0fb6c2e549',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        '4e5fe454-cfea-4e5e-a214-3b316a3b3418',
        '2025-12-09 19:11:20',
        '2025-12-09 19:11:20',
        NULL,
        0,
        0,
        4,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '72493c2f-b2fa-46e6-a7ea-f62884b2ea2f',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-12-09 19:13:45',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        6,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '90b63f44-d176-4fd8-a170-7b93a111e4c8',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        '249532c9-bad2-4c94-8158-154ff05ce956',
        '2025-12-09 19:10:16',
        '2025-12-09 19:10:16',
        NULL,
        0,
        0,
        3,
        0,
        1,
        NULL,
        NULL
    ),
    (
        '9728d84e-798e-4b53-9d48-aa7b1c5645a6',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-12-09 19:11:20',
        '2025-12-09 19:11:20',
        NULL,
        0,
        0,
        5,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'a365b3aa-3415-4be6-a8a7-7a83b9748611',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        'bb36f549-3d95-4513-bc91-ed0a0caad7b8',
        '2025-12-16 19:06:12',
        '2025-12-16 19:06:12',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'a9a80f35-1b2b-4913-8f85-2d36ed637ff6',
        'f5f4f653-f022-491d-8d3e-fbae36f48698',
        '5107c449-d6e0-4780-b8d8-3fca933e334b',
        '2025-12-09 19:13:45',
        '2025-12-09 19:13:45',
        NULL,
        0,
        0,
        4,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'ae0d19f5-3840-4970-96b5-f679a57ff8c3',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '2025-12-09 19:13:03',
        '2025-12-09 19:13:03',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'af661256-6150-47b2-b8aa-4ca2faffff82',
        'a18568b9-b1fe-4064-b212-a0d5708f85f9',
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '2025-12-09 19:12:14',
        '2025-12-09 19:14:14',
        NULL,
        0,
        0,
        3,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'b18e98e1-4a44-4a34-888a-5e231f59f9f1',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        '23c92bbd-94b2-4a7e-9e0d-dee93278e4dd',
        '2025-12-09 19:10:16',
        '2025-12-09 19:10:16',
        NULL,
        0,
        0,
        2,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'bec930db-292e-4613-b5b6-1123e3b50565',
        '9e65776d-3903-4f69-9017-7f5d2fa30fbb',
        '3c459f05-c619-42a8-abef-71a51041f268',
        '2025-12-09 19:11:20',
        '2025-12-09 19:11:20',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'c57bc8d6-70f9-48bf-9f0b-2b4b8250ee5d',
        'aa1a4405-16ff-49d5-acdb-d0b39a16f3fc',
        '4e5fe454-cfea-4e5e-a214-3b316a3b3418',
        '2025-12-09 19:13:03',
        '2025-12-09 19:13:03',
        NULL,
        0,
        0,
        3,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'c65f2047-bdec-4537-a64b-56ffafae8794',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        'fe05b1f5-23fe-4b28-83af-daa4a6c44375',
        '2025-12-09 19:10:16',
        '2025-12-09 19:10:16',
        NULL,
        0,
        0,
        4,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'e26210f4-c3ac-496c-9c97-f199472d832d',
        '3163adbc-410b-4813-a059-e2a0863ed136',
        'ff07b601-0108-491b-b56e-344ef5ff74c0',
        '2025-12-08 14:52:25',
        '2025-12-08 14:52:25',
        NULL,
        0,
        0,
        1,
        0,
        1,
        NULL,
        NULL
    ),
    (
        'fdc553ea-2670-4a58-86a5-fb33d1f8da85',
        '4b26d305-0a9f-4ac9-9a3a-c1cfede72e39',
        'bda12220-cea3-439d-986a-c71bc39723fa',
        '2025-12-09 19:10:16',
        '2025-12-09 19:10:16',
        NULL,
        0,
        0,
        5,
        0,
        1,
        NULL,
        NULL
    );

-- --------------------------------------------------------

--
-- 表的结构 `query`
--

CREATE TABLE `query` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `query_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '查询params数据',
    `query_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '查询结果数据',
    `query_state` enum(
        'pending',
        'success',
        'failed'
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending' COMMENT '查询状态',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '查询结果表，存储关联订单的查询数据' ROW_FORMAT = DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `query_cleanup_config`
--

CREATE TABLE `query_cleanup_config` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0-未删除，1-已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `config_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置键',
    `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置值',
    `config_desc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置说明',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1-启用，2-禁用'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '查询数据清理配置表';

--
-- 转存表中的数据 `query_cleanup_config`
--

INSERT INTO
    `query_cleanup_config` (
        `id`,
        `create_time`,
        `update_time`,
        `delete_time`,
        `del_state`,
        `version`,
        `config_key`,
        `config_value`,
        `config_desc`,
        `status`
    )
VALUES (
        '5ec211cf-10d9-4723-9ed0-0998be097187',
        '2025-06-06 16:27:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'retention_days',
        '15',
        '数据保留天数',
        1
    ),
    (
        '7cdfcecc-8774-4b0a-9977-497f4523ea3d',
        '2025-06-06 16:27:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'cleanup_cron',
        '0 3 * * *',
        '清理任务执行时间（cron表达式）',
        1
    ),
    (
        'b81c1832-67cc-432c-a006-1fbef018bbf6',
        '2025-06-06 16:27:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'enable_cleanup',
        '1',
        '是否启用清理：1-启用，2-禁用',
        1
    ),
    (
        'bc237ac2-6d7c-4a6c-b4b1-1e37e8030ffd',
        '2025-06-06 16:27:50',
        '2025-12-06 18:23:29',
        NULL,
        0,
        0,
        'batch_size',
        '100',
        '每次清理的批次大小',
        1
    );

-- --------------------------------------------------------

--
-- 表的结构 `query_cleanup_detail`
--

CREATE TABLE `query_cleanup_detail` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0-未删除，1-已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `cleanup_log_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `query_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `order_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `product_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `query_state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '查询状态',
    `create_time_old` datetime NOT NULL COMMENT '原记录创建时间'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '查询数据清理明细表';

-- --------------------------------------------------------

--
-- 表的结构 `query_cleanup_log`
--

CREATE TABLE `query_cleanup_log` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0' COMMENT '删除状态：0-未删除，1-已删除',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `cleanup_time` datetime NOT NULL COMMENT '清理执行时间',
    `cleanup_before` datetime NOT NULL COMMENT '清理截止时间',
    `affected_rows` int NOT NULL DEFAULT '0' COMMENT '影响行数',
    `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态：1-成功，2-失败',
    `error_msg` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '错误信息',
    `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注说明'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '查询数据清理日志表';

-- --------------------------------------------------------

--
-- 表的结构 `user`
--

CREATE TABLE `user` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    `inside` tinyint NOT NULL DEFAULT '0'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `user_auth`
--

CREATE TABLE `user_auth` (
    `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL COMMENT '删除时间',
    `del_state` tinyint NOT NULL DEFAULT '0',
    `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号',
    `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `auth_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台唯一id',
    `auth_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台类型'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户授权表' ROW_FORMAT = DYNAMIC;

--
-- 转储表的索引
--

--
-- 表的索引 `admin_api`
--
ALTER TABLE `admin_api`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_api_code` (`api_code`),
ADD KEY `idx_url_method` (`url`, `method`) COMMENT '优化接口查询';

--
-- 表的索引 `admin_dict_data`
--
ALTER TABLE `admin_dict_data`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_type_value` (`dict_type`, `dict_value`),
ADD UNIQUE KEY `uk_type_label` (`dict_type`, `dict_label`),
ADD KEY `idx_dict_type` (`dict_type`);

--
-- 表的索引 `admin_dict_type`
--
ALTER TABLE `admin_dict_type`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_dict_type` (`dict_type`);

--
-- 表的索引 `admin_menu`
--
ALTER TABLE `admin_menu`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_name_path` (`name`, `path`),
ADD KEY `idx_pid` (`pid`) USING BTREE COMMENT '优化层级查询';

--
-- 表的索引 `admin_role`
--
ALTER TABLE `admin_role`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_role_code` (`role_code`);

--
-- 表的索引 `admin_role_api`
--
ALTER TABLE `admin_role_api`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_role_api` (`role_id`, `api_id`),
ADD KEY `idx_role_id` (`role_id`) COMMENT '优化角色查询',
ADD KEY `idx_api_id` (`api_id`) COMMENT '优化接口查询';

--
-- 表的索引 `admin_role_menu`
--
ALTER TABLE `admin_role_menu`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_role_menu` (`role_id`, `menu_id`),
ADD KEY `idx_role_id` (`role_id`) COMMENT '优化角色查询',
ADD KEY `idx_menu_id` (`menu_id`) COMMENT '优化菜单查询';

--
-- 表的索引 `admin_user`
--
ALTER TABLE `admin_user`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_username` (`username`),
ADD UNIQUE KEY `uk_real_name` (`real_name`);

--
-- 表的索引 `admin_user_role`
--
ALTER TABLE `admin_user_role`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_user_role` (`user_id`, `role_id`),
ADD KEY `idx_user_id` (`user_id`) COMMENT '优化用户查询',
ADD KEY `idx_role_id` (`role_id`) COMMENT '优化角色查询';

--
-- 表的索引 `agent`
--
ALTER TABLE `agent`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_user_id` (`user_id`),
ADD UNIQUE KEY `uk_agent_code` (`agent_code`),
ADD KEY `idx_mobile` (`mobile`),
ADD KEY `idx_level` (`level`),
ADD KEY `idx_team_leader_id` (`team_leader_id`),
ADD KEY `idx_create_time` (`create_time`),
ADD KEY `idx_invite_code_id` (`invite_code_id`) COMMENT '邀请码ID索引';

--
-- 表的索引 `agent_commission`
--
ALTER TABLE `agent_commission`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_order_id` (`order_id`),
ADD KEY `idx_product_id` (`product_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_agent_status` (`agent_id`, `status`) COMMENT '复合索引：查询代理的佣金记录',
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_config`
--
ALTER TABLE `agent_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_config_key` (`config_key`),
ADD KEY `idx_config_type` (`config_type`);

--
-- 表的索引 `agent_freeze_task`
--
ALTER TABLE `agent_freeze_task`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_order_id` (`order_id`),
ADD KEY `idx_commission_id` (`commission_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_unfreeze_time` (`unfreeze_time`),
ADD KEY `idx_agent_status` (`agent_id`, `status`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_invite_code`
--
ALTER TABLE `agent_invite_code`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_code` (`code`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_target_level` (`target_level`),
ADD KEY `idx_used_user_id` (`used_user_id`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_invite_code_usage`
--
ALTER TABLE `agent_invite_code_usage`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_invite_code_id` (`invite_code_id`) COMMENT '关联邀请码ID',
ADD KEY `idx_code` (`code`) COMMENT '邀请码索引',
ADD KEY `idx_user_id` (`user_id`) COMMENT '用户ID索引',
ADD KEY `idx_agent_id` (`agent_id`) COMMENT '代理ID索引',
ADD KEY `idx_used_time` (`used_time`) COMMENT '使用时间索引',
ADD KEY `idx_create_time` (`create_time`) COMMENT '创建时间索引',
ADD KEY `idx_code_time` (`code`, `used_time`) COMMENT '邀请码和使用时间复合索引';

--
-- 表的索引 `agent_link`
--
ALTER TABLE `agent_link`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_link_identifier` (`link_identifier`),
ADD UNIQUE KEY `uk_agent_product_price` (
    `agent_id`,
    `product_id`,
    `set_price`,
    `del_state`
) COMMENT '唯一约束：同一代理、同一产品、同一价格只能有一个有效链接',
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_user_id` (`user_id`),
ADD KEY `idx_product_id` (`product_id`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_order`
--
ALTER TABLE `agent_order`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_order_id` (`order_id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_product_id` (`product_id`),
ADD KEY `idx_process_status` (`process_status`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_product_config`
--
ALTER TABLE `agent_product_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_product_id` (`product_id`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_real_name`
--
ALTER TABLE `agent_real_name`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_agent_id` (`agent_id`),
ADD KEY `idx_verify_time` (`verify_time`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_rebate`
--
ALTER TABLE `agent_rebate`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_source_agent_id` (`source_agent_id`),
ADD KEY `idx_order_id` (`order_id`),
ADD KEY `idx_product_id` (`product_id`),
ADD KEY `idx_rebate_type` (`rebate_type`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_order_rebate_type` (`order_id`, `rebate_type`) COMMENT '复合索引：查询订单的返佣明细',
ADD KEY `idx_agent_status` (`agent_id`, `status`) COMMENT '复合索引：查询代理的返佣记录',
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_relation`
--
ALTER TABLE `agent_relation`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_parent_child_type` (
    `parent_id`,
    `child_id`,
    `relation_type`
),
ADD KEY `idx_parent_id` (`parent_id`),
ADD KEY `idx_child_id` (`child_id`),
ADD KEY `idx_relation_type` (`relation_type`),
ADD KEY `idx_parent_relation` (`parent_id`, `relation_type`) COMMENT '复合索引：查询有效下级',
ADD KEY `idx_child_relation` (`child_id`, `relation_type`) COMMENT '复合索引：查询有效上级',
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_short_link`
--
ALTER TABLE `agent_short_link`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_short_code` (`short_code`, `del_state`) COMMENT '短链标识唯一索引',
ADD UNIQUE KEY `uk_link_id_type` (
    `link_id`,
    `type`,
    `del_state`
) COMMENT '同一推广链接同一类型只能有一个有效短链',
ADD UNIQUE KEY `uk_invite_code_id_type` (
    `invite_code_id`,
    `type`,
    `del_state`
) COMMENT '同一邀请码同一类型只能有一个有效短链',
ADD KEY `idx_link_identifier` (`link_identifier`) COMMENT '推广链接标识索引',
ADD KEY `idx_invite_code` (`invite_code`) COMMENT '邀请码索引',
ADD KEY `idx_type` (`type`) COMMENT '类型索引',
ADD KEY `idx_create_time` (`create_time`) COMMENT '创建时间索引';

--
-- 表的索引 `agent_upgrade`
--
ALTER TABLE `agent_upgrade`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_rebate_agent_id` (`rebate_agent_id`),
ADD KEY `idx_operator_agent_id` (`operator_agent_id`),
ADD KEY `idx_upgrade_type` (`upgrade_type`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_agent_status` (`agent_id`, `status`) COMMENT '复合索引：查询代理的升级记录',
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_wallet`
--
ALTER TABLE `agent_wallet`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_agent_id` (`agent_id`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_withdrawal`
--
ALTER TABLE `agent_withdrawal`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uk_withdraw_no` (`withdraw_no`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_agent_status` (`agent_id`, `status`) COMMENT '复合索引：查询代理的提现记录',
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `agent_withdrawal_tax`
--
ALTER TABLE `agent_withdrawal_tax`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_agent_id` (`agent_id`),
ADD KEY `idx_withdrawal_id` (`withdrawal_id`),
ADD KEY `idx_year_month` (`year_month`),
ADD KEY `idx_tax_status` (`tax_status`),
ADD KEY `idx_agent_year_month` (`agent_id`, `year_month`) COMMENT '复合索引：查询代理的月度扣税记录';

--
-- 表的索引 `authorization_document`
--
ALTER TABLE `authorization_document`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_user_id` (`user_id`),
ADD KEY `idx_order_id` (`order_id`),
ADD KEY `idx_query_id` (`query_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_del_state` (`del_state`),
ADD KEY `idx_create_time` (`create_time`);

--
-- 表的索引 `example`
--
ALTER TABLE `example`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unique_api_id` (`api_id`) USING BTREE,
ADD UNIQUE KEY `unique_feature_id` (`feature_id`) USING BTREE;

--
-- 表的索引 `feature`
--
ALTER TABLE `feature`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_api_id` (`api_id`) USING BTREE;

--
-- 表的索引 `global_notifications`
--
ALTER TABLE `global_notifications`
ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `order`
--
ALTER TABLE `order`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_order_no` (`order_no`) USING BTREE,
ADD KEY `idx_user_id` (`user_id`) USING BTREE,
ADD KEY `idx_product_id` (`product_id`) USING BTREE,
ADD KEY `idx_payment_platform` (`payment_platform`) USING BTREE,
ADD KEY `idx_payment_scene` (`payment_scene`) USING BTREE;

--
-- 表的索引 `order_refund`
--
ALTER TABLE `order_refund`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unique_refund_no` (`refund_no`),
ADD UNIQUE KEY `unique_platform_refund_id` (`platform_refund_id`),
ADD KEY `idx_user_id` (`user_id`),
ADD KEY `idx_product_id` (`product_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_order_id` (`order_id`);

--
-- 表的索引 `product`
--
ALTER TABLE `product`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_product_en` (`product_en`) USING BTREE;

--
-- 表的索引 `product_feature`
--
ALTER TABLE `product_feature` ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `query`
--
ALTER TABLE `query`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_order_id` (`order_id`) USING BTREE,
ADD KEY `idx_user_id` (`user_id`) USING BTREE,
ADD KEY `idx_product_id` (`product_id`) USING BTREE;

--
-- 表的索引 `query_cleanup_config`
--
ALTER TABLE `query_cleanup_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `unique_config_key` (`config_key`) COMMENT '配置键唯一索引';

--
-- 表的索引 `query_cleanup_detail`
--
ALTER TABLE `query_cleanup_detail`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_cleanup_log_id` (`cleanup_log_id`) COMMENT '优化按清理日志查询',
ADD KEY `idx_query_id` (`query_id`) COMMENT '优化按查询ID查询',
ADD KEY `idx_order_id` (`order_id`) COMMENT '优化按订单ID查询',
ADD KEY `idx_user_id` (`user_id`) COMMENT '优化按用户ID查询';

--
-- 表的索引 `query_cleanup_log`
--
ALTER TABLE `query_cleanup_log`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_cleanup_time` (`cleanup_time`) COMMENT '优化按清理时间查询',
ADD KEY `idx_cleanup_before` (`cleanup_before`) COMMENT '优化按清理截止时间查询',
ADD KEY `idx_status` (`status`) COMMENT '优化按状态查询';

--
-- 表的索引 `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_mobile` (`mobile`) USING BTREE;

--
-- 表的索引 `user_auth`
--
ALTER TABLE `user_auth`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_type_key` (`auth_type`, `auth_key`) USING BTREE,
ADD UNIQUE KEY `unique_userId_key` (`user_id`, `auth_type`) USING BTREE;

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `agent`
--
ALTER TABLE `agent`
MODIFY `agent_code` bigint NOT NULL AUTO_INCREMENT COMMENT '代理编码（从16800开始递增）';

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */
;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
;