-- Adminer 4.8.1 MySQL 8.0.40 dump

SET
time_zone = '+00:00';
SET
foreign_key_checks = 0;
SET
sql_mode = 'NO_AUTO_VALUE_ON_ZERO';


CREATE TABLE `menus`
(
    `id`          int                                     NOT NULL AUTO_INCREMENT,
    `name`        varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `description` varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `path`        varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `label`       varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `component`   varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `redirect`    varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `fullPath`    varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `alias`       varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `parentId`    int                                              DEFAULT NULL,
    `meta_id`     int                                              DEFAULT NULL,
    `created_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `IDX_a8bb3519a45e021a147bc87e49` (`name`),
    UNIQUE KEY `REL_1cbe34fd35ed3538b57f6c8842` (`meta_id`),
    KEY           `FK_8523e13f1ba719e16eb474657ec` (`parentId`),
    CONSTRAINT `FK_1cbe34fd35ed3538b57f6c88428` FOREIGN KEY (`meta_id`) REFERENCES `metas` (`id`),
    CONSTRAINT `FK_8523e13f1ba719e16eb474657ec` FOREIGN KEY (`parentId`) REFERENCES `menus` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单';


CREATE TABLE `metas`
(
    `id`       int NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `menu_id`  int NOT NULL COMMENT '菜单id',
    `title`    varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单标题',
    `icon`     varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单图标',
    `layout`   varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '布局类型',
    `order`    int                                     DEFAULT '100' COMMENT '菜单排序',
    `hidden`   tinyint                                 DEFAULT '0' COMMENT '是否隐藏',
    `disabled` tinyint                                 DEFAULT NULL COMMENT '是否禁用',
    `affix`    int                                     DEFAULT NULL COMMENT '是否固定',
    PRIMARY KEY (`id`),
    UNIQUE KEY `REL_0046eedd8af0f82d0c7210507f` (`menu_id`),
    CONSTRAINT `FK_0046eedd8af0f82d0c7210507ff` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单元数据';


CREATE TABLE `permissions`
(
    `id`          int                                     NOT NULL AUTO_INCREMENT,
    `name`        varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `action`      varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `description` varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `created_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `IDX_48ce552495d14eae9b187bb671` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='permission 权限表';


CREATE TABLE `policies`
(
    `id`          int                                     NOT NULL AUTO_INCREMENT,
    `type`        int                                     NOT NULL,
    `effect`      varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `action`      varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `subject`     varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `encode`      varchar(500) COLLATE utf8mb4_general_ci NOT NULL,
    `fields`      json                                             DEFAULT NULL,
    `conditions`  json                                             DEFAULT NULL,
    `args`        json                                             DEFAULT NULL,
    `description` varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `fields_data` varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `created_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `IDX_8adeb1d7cf9ebb870b44646a5c` (`encode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `policy_permissions`
(
    `id`            int       NOT NULL AUTO_INCREMENT,
    `created_at`    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `permission_id` int                DEFAULT NULL,
    `policy_id`     int                DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY             `FK_93b1ad08e509215eb23bad772a2` (`permission_id`),
    KEY             `FK_6195f79762779f3077ba093ad8d` (`policy_id`),
    CONSTRAINT `FK_6195f79762779f3077ba093ad8d` FOREIGN KEY (`policy_id`) REFERENCES `policies` (`id`) ON DELETE CASCADE,
    CONSTRAINT `FK_93b1ad08e509215eb23bad772a2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `role_menus`
(
    `id`         int       NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `menu_id`    int                DEFAULT NULL,
    `role_id`    int                DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY          `FK_4c7c7bd4eb8a33aece58434cbf5` (`menu_id`),
    KEY          `FK_cec0c62317111ac45c9c295d226` (`role_id`),
    CONSTRAINT `FK_4c7c7bd4eb8a33aece58434cbf5` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE,
    CONSTRAINT `FK_cec0c62317111ac45c9c295d226` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `role_permissions`
(
    `id`            int       NOT NULL AUTO_INCREMENT,
    `created_at`    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `permission_id` int                DEFAULT NULL,
    `role_id`       int                DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY             `FK_17022daf3f885f7d35423e9971e` (`permission_id`),
    KEY             `FK_178199805b901ccd220ab7740ec` (`role_id`),
    CONSTRAINT `FK_17022daf3f885f7d35423e9971e` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
    CONSTRAINT `FK_178199805b901ccd220ab7740ec` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `role_policies`
(
    `id`         int       NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `policy_id`  int                DEFAULT NULL,
    `role_id`    int                DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY          `FK_172c36e040c3f8233ce657d65a7` (`policy_id`),
    KEY          `FK_fb4e9cdfe54bbf9efd1bbd96d43` (`role_id`),
    CONSTRAINT `FK_172c36e040c3f8233ce657d65a7` FOREIGN KEY (`policy_id`) REFERENCES `policies` (`id`) ON DELETE CASCADE,
    CONSTRAINT `FK_fb4e9cdfe54bbf9efd1bbd96d43` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `roles`
(
    `id`          int                                     NOT NULL AUTO_INCREMENT,
    `name`        varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `code`        varchar(255) COLLATE utf8mb4_general_ci          DEFAULT NULL,
    `description` varchar(255) COLLATE utf8mb4_general_ci          DEFAULT '',
    `created_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `IDX_648e3f5447f725579d7d4ffdfb` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


CREATE TABLE `user_roles`
(
    `id`         int NOT NULL AUTO_INCREMENT,
    `created_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
    `updated_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
    `user_id`    int DEFAULT NULL,
    `role_id`    int DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY          `FK_87b8888186ca9769c960e926870` (`user_id`),
    KEY          `FK_b23c65e50a758245a33ee35fda1` (`role_id`),
    CONSTRAINT `FK_87b8888186ca9769c960e926870` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    CONSTRAINT `FK_b23c65e50a758245a33ee35fda1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


-- 2025-03-17 05:51:12


INSERT INTO `permissions` (`id`, `name`, `action`, `description`, `created_at`, `updated_at`)
VALUES (1, 'user:delete', 'delete', '用户删除操作权限', '2025-03-11 07:08:36', '2025-03-11 07:08:36'),
       (2, 'user:read', 'read', '', '2025-03-11 07:08:48', '2025-03-11 07:08:48'),
       (3, 'user:create', 'create', '', '2025-03-11 07:08:58', '2025-03-11 07:08:58'),
       (4, 'user:update', 'update', '', '2025-03-11 07:09:07', '2025-03-11 07:09:07'),
       (5, 'menu:delete', 'delete', '', '2025-03-11 07:08:36', '2025-03-11 07:08:36'),
       (6, 'menu:read', 'read', '', '2025-03-11 07:08:48', '2025-03-11 07:08:48'),
       (7, 'menu:create', 'create', '', '2025-03-11 07:08:58', '2025-03-11 07:08:58'),
       (8, 'menu:update', 'update', '', '2025-03-11 07:09:07', '2025-03-11 07:09:07'),
       (9, 'policy:delete', 'delete', '', '2025-03-11 07:08:36', '2025-03-11 07:08:36'),
       (10, 'policy:read', 'read', '', '2025-03-11 07:08:48', '2025-03-11 07:08:48'),
       (11, 'policy:create', 'create', '', '2025-03-11 07:08:58', '2025-03-11 07:08:58'),
       (12, 'policy:update', 'update', '', '2025-03-11 07:09:07', '2025-03-11 07:09:07'),
       (13, 'permission:delete', 'delete', '', '2025-03-11 07:08:36', '2025-03-11 07:08:36'),
       (14, 'permission:read', 'read', '', '2025-03-11 07:08:48', '2025-03-11 07:08:48'),
       (15, 'permission:create', 'create', '', '2025-03-11 07:08:58', '2025-03-11 07:08:58'),
       (16, 'permission:update', 'update', '', '2025-03-11 07:09:07', '2025-03-11 07:09:07'),
       (17, 'role:delete', 'delete', '', '2025-03-11 07:08:36', '2025-03-11 07:08:36'),
       (18, 'role:read', 'read', '', '2025-03-11 07:08:48', '2025-03-11 07:08:48'),
       (19, 'role:create', 'create', '', '2025-03-11 07:08:58', '2025-03-11 07:08:58'),
       (20, 'role:update', 'update', '', '2025-03-11 07:09:07', '2025-03-11 07:09:07'),
       (21, 'log:read', 'read', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (22, 'log:update', 'update', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (23, 'log:create', 'create', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (24, 'log:delete', 'delete', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (25, 'user:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (26, 'menu:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (27, 'policy:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (28, 'permission:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (29, 'role:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37'),
       (30, 'log:manage', 'manage', '', '2025-03-12 05:30:37', '2025-03-12 05:30:37');

INSERT INTO `policies` (`id`, `type`, `effect`, `action`, `subject`, `encode`, `fields`, `conditions`, `args`,
                        `description`, `fields_data`, `created_at`, `updated_at`)
VALUES (1, 2, 'can', 'manage', 'Permission',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (2, 1, 'can', 'manage', 'Permission',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (3, 0, 'can', 'manage', 'Permission',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (4, 2, 'can', 'manage', 'User',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (5, 1, 'can', 'manage', 'User',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (6, 0, 'can', 'manage', 'User',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (7, 2, 'can', 'manage', 'Role',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (8, 1, 'can', 'manage', 'Role',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (9, 0, 'can', 'manage', 'Role',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (10, 2, 'can', 'manage', 'Menu',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (11, 1, 'can', 'manage', 'Menu',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (12, 0, 'can', 'manage', 'Menu',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (13, 2, 'can', 'manage', 'Policy',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (14, 1, 'can', 'manage', 'Policy',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (15, 0, 'can', 'manage', 'Policy',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJtYW5hZ2UiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (16, 0, 'can', 'create', 'User',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (17, 0, 'can', 'update', 'User',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (18, 0, 'can', 'read', 'User',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlVzZXIiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (19, 0, 'can', 'delete', 'User',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (20, 1, 'can', 'create', 'User',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (21, 1, 'can', 'update', 'User',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (22, 1, 'can', 'delete', 'User',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (23, 1, 'can', 'read', 'User',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlVzZXIiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (24, 2, 'can', 'create', 'User',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (25, 2, 'can', 'update', 'User',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (26, 2, 'can', 'delete', 'User',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiVXNlciIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (27, 2, 'can', 'read', 'User',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlVzZXIiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (28, 0, 'can', 'create', 'Menu',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (29, 0, 'can', 'update', 'Menu',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (30, 0, 'can', 'read', 'Menu',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6Ik1lbnUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (31, 0, 'can', 'delete', 'Menu',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (32, 1, 'can', 'create', 'Menu',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (33, 1, 'can', 'update', 'Menu',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (34, 1, 'can', 'delete', 'Menu',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (35, 1, 'can', 'read', 'Menu',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6Ik1lbnUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (36, 2, 'can', 'create', 'Menu',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (37, 2, 'can', 'update', 'Menu',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (38, 2, 'can', 'delete', 'Menu',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiTWVudSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (39, 2, 'can', 'read', 'Menu',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6Ik1lbnUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (40, 0, 'can', 'create', 'Policy',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (41, 0, 'can', 'update', 'Policy',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (42, 0, 'can', 'read', 'Policy',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBvbGljeSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (43, 0, 'can', 'delete', 'Policy',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (44, 1, 'can', 'create', 'Policy',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (45, 1, 'can', 'update', 'Policy',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (46, 1, 'can', 'delete', 'Policy',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (47, 1, 'can', 'read', 'Policy',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBvbGljeSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (48, 2, 'can', 'create', 'Policy',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (49, 2, 'can', 'update', 'Policy',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (50, 2, 'can', 'delete', 'Policy',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUG9saWN5IiwiZWZmZWN0IjoiY2FuIn0=', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (51, 2, 'can', 'read', 'Policy',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBvbGljeSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (52, 0, 'can', 'create', 'Role',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (53, 0, 'can', 'update', 'Role',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (54, 0, 'can', 'read', 'Role',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlJvbGUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (55, 0, 'can', 'delete', 'Role',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (56, 1, 'can', 'create', 'Role',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (57, 1, 'can', 'update', 'Role',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (58, 1, 'can', 'delete', 'Role',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (59, 1, 'can', 'read', 'Role',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlJvbGUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (60, 2, 'can', 'create', 'Role',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (61, 2, 'can', 'update', 'Role',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (62, 2, 'can', 'delete', 'Role',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUm9sZSIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (63, 2, 'can', 'read', 'Role',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlJvbGUiLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]', NULL,
        NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (64, 0, 'can', 'create', 'Permission',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (65, 0, 'can', 'update', 'Permission',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (66, 0, 'can', 'read', 'Permission',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBlcm1pc3Npb24iLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (67, 0, 'can', 'delete', 'Permission',
        'eyJ0eXBlIjowLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (68, 1, 'can', 'create', 'Permission',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (69, 1, 'can', 'update', 'Permission',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (70, 1, 'can', 'delete', 'Permission',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (71, 1, 'can', 'read', 'Permission',
        'eyJ0eXBlIjoxLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBlcm1pc3Npb24iLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (72, 2, 'can', 'create', 'Permission',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJjcmVhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (73, 2, 'can', 'update', 'Permission',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJ1cGRhdGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (74, 2, 'can', 'delete', 'Permission',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJkZWxldGUiLCJzdWJqZWN0IjoiUGVybWlzc2lvbiIsImVmZmVjdCI6ImNhbiJ9', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30'),
       (75, 2, 'can', 'read', 'Permission',
        'eyJ0eXBlIjoyLCJhY3Rpb24iOiJyZWFkIiwic3ViamVjdCI6IlBlcm1pc3Npb24iLCJlZmZlY3QiOiJjYW4ifQ==', '[]', '[]', '[]',
        NULL, NULL, '2025-03-15 14:06:30', '2025-03-15 14:06:30');

INSERT INTO `roles` (`id`, `name`, `code`, `description`, `created_at`, `updated_at`)
VALUES (1, 'admin', 'admin', '超级管理员，拥有所有的权限', '2025-03-11 09:10:30', '2025-03-11 09:10:30'),
       (2, '平台用户', 'user', '普通用户，拥有基本的权限', '2025-03-11 09:10:30', '2025-03-11 09:10:30'),
       (3, '游客', 'guest', '部分查看功能', '2025-03-11 09:10:30', '2025-03-11 09:10:30');

INSERT INTO `user_roles` (`id`, `created_at`, `updated_at`, `user_id`, `role_id`)
VALUES (3, '2025-03-17 02:19:55.000000', '2025-03-17 02:19:55.000000', 1, 1),
       (4, '2025-03-17 05:37:38.000000', '2025-03-17 05:37:38.000000', 2, 3);

INSERT INTO `role_permissions` (`id`, `created_at`, `updated_at`, `permission_id`, `role_id`)
VALUES (1, '2025-03-11 07:10:05', '2025-03-11 07:10:05', 1, 1),
       (2, '2025-03-11 07:10:05', '2025-03-11 07:10:05', 2, 1),
       (3, '2025-03-11 07:10:05', '2025-03-11 07:10:05', 3, 1),
       (4, '2025-03-11 07:10:05', '2025-03-11 07:10:05', 4, 1),
       (5, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 5, 1),
       (6, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 6, 1),
       (7, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 7, 1),
       (8, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 8, 1),
       (9, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 9, 1),
       (10, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 10, 1),
       (11, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 11, 1),
       (12, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 12, 1),
       (13, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 13, 1),
       (14, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 14, 1),
       (15, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 15, 1),
       (16, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 16, 1),
       (17, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 17, 1),
       (18, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 18, 1),
       (19, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 19, 1),
       (20, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 20, 1),
       (21, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 21, 1),
       (22, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 22, 1),
       (23, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 23, 1),
       (24, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 24, 1),
       (25, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 25, 1),
       (26, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 26, 1),
       (27, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 27, 1),
       (28, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 28, 1),
       (29, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 29, 1),
       (30, '2025-03-11 07:10:00', '2025-03-11 07:10:00', 30, 1),
       (31, '2025-03-17 05:38:31', '2025-03-17 05:38:31', 2, 2),
       (32, '2025-03-17 05:38:43', '2025-03-17 05:38:43', 6, 2),
       (33, '2025-03-17 05:38:54', '2025-03-17 05:38:54', 10, 2),
       (34, '2025-03-17 05:39:14', '2025-03-17 05:39:14', 14, 2),
       (35, '2025-03-17 05:39:25', '2025-03-17 05:39:25', 18, 2),
       (36, '2025-03-17 05:39:42', '2025-03-17 05:39:42', 21, 2),
       (37, '2025-03-17 05:38:31', '2025-03-17 05:38:31', 2, 3),
       (38, '2025-03-17 05:38:43', '2025-03-17 05:38:43', 6, 3),
       (39, '2025-03-17 05:38:54', '2025-03-17 05:38:54', 10, 3),
       (40, '2025-03-17 05:39:14', '2025-03-17 05:39:14', 14, 3),
       (41, '2025-03-17 05:39:25', '2025-03-17 05:39:25', 18, 3),
       (42, '2025-03-17 05:39:42', '2025-03-17 05:39:42', 21, 3);

INSERT INTO `role_policies` (`id`, `created_at`, `updated_at`, `policy_id`, `role_id`)
VALUES (1, '2025-03-11 07:09:54', '2025-03-11 07:09:54', 1, 1),
       (2, '2025-03-11 07:10:05', '2025-03-11 07:10:05', 2, 1),
       (3, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 3, 1),
       (4, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 4, 1),
       (5, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 5, 1),
       (6, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 6, 1),
       (7, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 7, 1),
       (8, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 8, 1),
       (9, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 9, 1),
       (10, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 10, 1),
       (11, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 11, 1),
       (12, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 12, 1),
       (13, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 13, 1),
       (14, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 14, 1),
       (15, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 15, 1),
       (16, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 16, 1),
       (17, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 17, 1),
       (18, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 18, 1),
       (19, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 19, 1),
       (20, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 20, 1),
       (21, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 21, 1),
       (22, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 22, 1),
       (23, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 23, 1),
       (24, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 24, 1),
       (25, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 25, 1),
       (26, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 26, 1),
       (27, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 27, 1),
       (28, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 28, 1),
       (29, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 29, 1),
       (30, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 30, 1),
       (31, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 31, 1),
       (32, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 32, 1),
       (33, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 33, 1),
       (34, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 34, 1),
       (35, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 35, 1),
       (36, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 36, 1),
       (37, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 37, 1),
       (38, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 38, 1),
       (39, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 39, 1),
       (40, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 40, 1),
       (41, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 41, 1),
       (42, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 42, 1),
       (43, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 43, 1),
       (44, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 44, 1),
       (45, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 45, 1),
       (46, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 46, 1),
       (47, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 47, 1),
       (48, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 48, 1),
       (49, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 49, 1),
       (50, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 50, 1),
       (51, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 51, 1),
       (52, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 52, 1),
       (53, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 53, 1),
       (54, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 54, 1),
       (55, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 55, 1),
       (56, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 56, 1),
       (57, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 57, 1),
       (58, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 58, 1),
       (59, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 59, 1),
       (60, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 60, 1),
       (61, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 61, 1),
       (62, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 62, 1),
       (63, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 63, 1),
       (64, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 64, 1),
       (65, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 65, 1),
       (66, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 66, 1),
       (67, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 67, 1),
       (68, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 68, 1),
       (69, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 69, 1),
       (70, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 70, 1),
       (71, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 71, 1),
       (72, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 72, 1),
       (73, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 73, 1),
       (74, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 74, 1),
       (75, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 75, 1),
       (76, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 18, 2),
       (77, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 23, 2),
       (78, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 27, 2),
       (79, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 30, 2),
       (80, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 35, 2),
       (81, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 39, 2),
       (82, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 42, 2),
       (83, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 27, 2),
       (84, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 51, 2),
       (85, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 54, 2),
       (86, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 59, 2),
       (87, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 63, 2),
       (88, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 66, 2),
       (89, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 71, 2),
       (90, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 75, 2),
       (91, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 18, 3),
       (92, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 23, 3),
       (93, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 27, 3),
       (94, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 30, 3),
       (95, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 35, 3),
       (96, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 39, 3),
       (97, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 42, 3),
       (98, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 27, 3),
       (99, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 51, 3),
       (100, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 54, 3),
       (101, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 59, 3),
       (102, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 63, 3),
       (103, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 66, 3),
       (104, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 71, 3),
       (105, '2025-03-11 07:17:15', '2025-03-11 07:17:15', 75, 3);
