Inicio Explorar Axuda
Rexistro Iniciar sesión
puge
/
ActivationCodeManage
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Rama: main
Ramas Etiquetas
ActivationCodeM...
/
postgreSQL
/
Menu.sql

Menu.sql 28 KB
Permalink Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136 
  1. /*
    2. 

  2.  Navicat Premium Dump SQL
    3. 

  3. 

  4.  Source Server         : postgreSQL
    5. 

  5.  Source Server Type    : PostgreSQL
    6. 

  6.  Source Server Version : 160003 (160003)
    7. 

  7.  Source Host           : localhost:5432
    8. 

  8.  Source Catalog        : vue3-admin
    9. 

  9.  Source Schema         : public
    10. 

  10. 

  11.  Target Server Type    : PostgreSQL
    12. 

  12.  Target Server Version : 160003 (160003)
    13. 

  13.  File Encoding         : 65001
    14. 

  14. 

  15.  Date: 31/10/2024 10:17:01
    16. 

  16. */
    17. 

  17. 

  18. 

  19. -- ----------------------------
    20. 

  20. -- Table structure for Menu
    21. 

  21. -- ----------------------------
    22. 

  22. DROP TABLE IF EXISTS "public"."Menu";
    23. 

  23. CREATE TABLE "public"."Menu" (
    24. 

  24.   "id" text COLLATE "pg_catalog"."default" NOT NULL,
    25. 

  25.   "title" text COLLATE "pg_catalog"."default" NOT NULL,
    26. 

  26.   "type" "public"."MenuType" NOT NULL DEFAULT 'MENU'::"MenuType",
    27. 

  27.   "parentId" text COLLATE "pg_catalog"."default",
    28. 

  28.   "name" text COLLATE "pg_catalog"."default",
    29. 

  29.   "path" text COLLATE "pg_catalog"."default",
    30. 

  30.   "component" text COLLATE "pg_catalog"."default",
    31. 

  31.   "meta" jsonb,
    32. 

  32.   "sort" int4 NOT NULL,
    33. 

  33.   "permission" text COLLATE "pg_catalog"."default",
    34. 

  34.   "createdAt" timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    35. 

  35.   "updatedAt" timestamp(3) NOT NULL,
    36. 

  36.   "props" jsonb
    37. 

  37. )
    38. 

  38. ;
    39. 

  39. 

  40. -- ----------------------------
    41. 

  41. -- Records of Menu
    42. 

  42. -- ----------------------------
    43. 

  43. INSERT INTO "public"."Menu" VALUES ('dea4e038-592f-4532-ac86-c7de25a3416c', '组织管理', 'MENU', '03404a66-50aa-4b21-8c93-9dcddaeffdb7', 'administrative_organization', '/administrative/organization', 'view.administrative_organization', '{"icon": "ri:exchange-2-line", "order": 0, "title": "administrative_organization", "i18nKey": "route.administrative_organization", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 1, NULL, '2024-08-20 06:18:01.518', '2024-08-20 06:18:08.978', NULL);
    44. 

  44. INSERT INTO "public"."Menu" VALUES ('8be52db9-1856-4f14-8b2f-12c51ba45a3e', '新增', 'BUTTON', 'dea4e038-592f-4532-ac86-c7de25a3416c', NULL, NULL, NULL, NULL, 1, 'administrative:organization:add', '2024-08-22 08:13:01.987', '2024-08-22 08:13:01.987', NULL);
    45. 

  45. INSERT INTO "public"."Menu" VALUES ('4fc642f4-18bb-4b18-980b-7e41e804720c', '个人中心', 'MENU', NULL, 'user-center', '/user-center', 'layout.base$view.user-center', '{"icon": "ri:id-card-line", "order": 3, "title": "user-center", "i18nKey": "route.user-center", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 3, NULL, '2024-08-20 09:53:42.835', '2024-09-04 02:17:05.549', NULL);
    46. 

  46. INSERT INTO "public"."Menu" VALUES ('4d238c00-d8c0-4ed2-a803-41caf772820e', '关于', 'MENU', NULL, 'about', '/about', 'layout.base$view.about', '{"icon": "fluent:book-information-24-regular", "order": 6, "title": "about", "i18nKey": "route.about", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 5, NULL, '2024-08-20 06:31:49.783', '2024-09-10 02:16:34.961', '{}');
    47. 

  47. INSERT INTO "public"."Menu" VALUES ('8f16a2cd-b613-4419-bfa5-996f16beaa6a', '首页', 'MENU', NULL, 'home', '/home', 'layout.base$view.home', '{"icon": "mdi:monitor-dashboard", "order": 1, "title": "home", "i18nKey": "route.home", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 1, NULL, '2024-08-19 09:05:42.591', '2024-08-20 06:30:37.079', NULL);
    48. 

  48. INSERT INTO "public"."Menu" VALUES ('1ee566d9-d5ef-456a-8009-d67bb026b4b0', '用户管理', 'MENU', '572c5097-d28f-48b4-899d-3aaf46b8d668', 'system-manage_user-manage', '/system-manage/user-manage', 'view.system-manage_user-manage', '{"icon": "ri:user-settings-line", "order": 0, "title": "system-manage_user-manage", "i18nKey": "route.system-manage_user-manage", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 1, NULL, '2024-08-20 06:24:54.605', '2024-09-04 02:17:37.394', NULL);
    49. 

  49. INSERT INTO "public"."Menu" VALUES ('03404a66-50aa-4b21-8c93-9dcddaeffdb7', '智能行政', 'DIRECTORY', NULL, 'administrative', '/administrative', 'layout.base', '{"icon": "ri:quill-pen-line", "order": 2, "title": "administrative", "i18nKey": "route.administrative", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 2, NULL, '2024-08-20 06:11:55.369', '2024-08-20 06:20:20.263', NULL);
    50. 

  50. INSERT INTO "public"."Menu" VALUES ('d4d48216-c56d-4620-98b3-4ff8ce8fbc3b', '登录页', 'DIRECTORY', NULL, 'login', '/login', 'layout.blank$view.login', '{"order": 0, "title": "login", "i18nKey": "route.login", "constant": true, "multiTab": false, "keepAlive": false, "hideInMenu": true}', 6, NULL, '2024-08-20 07:06:39.93', '2024-09-10 02:17:16.492', '{}');
    51. 

  51. INSERT INTO "public"."Menu" VALUES ('3f27c671-cfe4-48d2-a240-9f152c9a0c3a', '500', 'MENU', NULL, '500', '/500', 'layout.blank$view.500', '{"order": 0, "title": "500", "i18nKey": "route.500", "constant": true, "multiTab": false, "keepAlive": false, "hideInMenu": true}', 9, NULL, '2024-08-20 06:38:08.365', '2024-09-10 02:18:09.676', '{}');
    52. 

  52. INSERT INTO "public"."Menu" VALUES ('c4bb98dd-e417-438b-8fe5-7b27e2921e72', '编辑', 'BUTTON', 'dea4e038-592f-4532-ac86-c7de25a3416c', NULL, NULL, NULL, NULL, 1, 'administrative:organization:edit', '2024-08-22 08:13:36.151', '2024-08-22 08:13:36.151', NULL);
    53. 

  53. INSERT INTO "public"."Menu" VALUES ('76402592-28e6-4575-9454-b38133652fa8', '删除', 'BUTTON', 'dea4e038-592f-4532-ac86-c7de25a3416c', NULL, NULL, NULL, NULL, 1, 'administrative:organization:delete', '2024-08-22 08:13:56.316', '2024-08-22 08:13:56.316', NULL);
    54. 

  54. INSERT INTO "public"."Menu" VALUES ('0916a1b8-bf6f-4732-9c3c-c0b834c9e1cc', '新增', 'BUTTON', '5dc9be35-dfad-493e-99c4-fdca4ddff1f5', NULL, NULL, NULL, NULL, 1, 'administrative:post-manage:add', '2024-08-22 08:17:31.509', '2024-08-22 08:17:31.509', NULL);
    55. 

  55. INSERT INTO "public"."Menu" VALUES ('db9d9316-ad43-41f2-9060-f6f55a6d0fd2', '编辑', 'BUTTON', '5dc9be35-dfad-493e-99c4-fdca4ddff1f5', NULL, NULL, NULL, NULL, 1, 'administrative:post-manage:edit', '2024-08-22 08:17:59.364', '2024-08-22 08:17:59.364', NULL);
    56. 

  56. INSERT INTO "public"."Menu" VALUES ('4918cc69-4050-4929-9113-e5cb7e67b848', '删除', 'BUTTON', '5dc9be35-dfad-493e-99c4-fdca4ddff1f5', NULL, NULL, NULL, NULL, 1, 'administrative:post-manage:delete', '2024-08-22 08:18:28.673', '2024-08-22 08:18:28.673', NULL);
    57. 

  57. INSERT INTO "public"."Menu" VALUES ('ea793941-1ca1-4e23-ac0e-784d3a95743a', '新增', 'BUTTON', '1ee566d9-d5ef-456a-8009-d67bb026b4b0', NULL, NULL, NULL, NULL, 1, 'system-manage:user-manage:add', '2024-08-22 08:19:02.046', '2024-08-22 08:19:02.046', NULL);
    58. 

  58. INSERT INTO "public"."Menu" VALUES ('acfd4d4c-4b12-46b9-9a11-e85c2fc8e667', '编辑', 'BUTTON', '1ee566d9-d5ef-456a-8009-d67bb026b4b0', NULL, NULL, NULL, NULL, 1, 'system-manage:user-manage:edit', '2024-08-22 08:19:27.088', '2024-08-22 08:19:27.088', NULL);
    59. 

  59. INSERT INTO "public"."Menu" VALUES ('a66a0e69-cd75-4460-b766-1ad52a82ac10', '删除', 'BUTTON', '1ee566d9-d5ef-456a-8009-d67bb026b4b0', NULL, NULL, NULL, NULL, 1, 'system-manage:user-manage:delete', '2024-08-22 08:19:46.595', '2024-08-22 08:19:46.595', NULL);
    60. 

  60. INSERT INTO "public"."Menu" VALUES ('61da313d-4b5f-40b4-9bc3-55b57ebf18d1', '新增', 'BUTTON', '28a745e9-ff3a-49c2-bebc-e269146652e6', NULL, NULL, NULL, NULL, 1, 'system-manage:menu-manage:add', '2024-08-22 08:20:26.409', '2024-08-22 08:20:26.409', NULL);
    61. 

  61. INSERT INTO "public"."Menu" VALUES ('572c5097-d28f-48b4-899d-3aaf46b8d668', '系统管理', 'DIRECTORY', NULL, 'system-manage', '/system-manage', 'layout.base', '{"icon": "ri:settings-2-line", "order": 5, "title": "system-manage", "i18nKey": "route.system-manage", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 4, NULL, '2024-08-20 06:24:04.955', '2024-09-10 02:16:16.165', '{}');
    62. 

  62. INSERT INTO "public"."Menu" VALUES ('5dc9be35-dfad-493e-99c4-fdca4ddff1f5', '岗位管理', 'MENU', '03404a66-50aa-4b21-8c93-9dcddaeffdb7', 'administrative_post-manage', '/administrative/post-manage', 'view.administrative_post-manage', '{"icon": "ri:contacts-book-3-line", "order": 0, "title": "administrative_post-manage", "i18nKey": "route.administrative_post-manage", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 2, NULL, '2024-08-20 06:19:52.117', '2024-09-04 02:16:54.951', NULL);
    63. 

  63. INSERT INTO "public"."Menu" VALUES ('28a745e9-ff3a-49c2-bebc-e269146652e6', '菜单管理', 'MENU', '572c5097-d28f-48b4-899d-3aaf46b8d668', 'system-manage_menu-manage', '/system-manage/menu-manage', 'view.system-manage_menu-manage', '{"icon": "ri:route-fill", "order": 0, "title": "system-manage_menu-manage", "i18nKey": "route.system-manage_menu-manage", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 2, NULL, '2024-08-20 06:26:36.083', '2024-09-04 02:17:49.85', NULL);
    64. 

  64. INSERT INTO "public"."Menu" VALUES ('aaf9caab-e4cc-491c-bf9c-d5fe81b9d867', '国际化', 'MENU', '572c5097-d28f-48b4-899d-3aaf46b8d668', 'system-manage_internalization', '/system-manage/internalization', 'view.system-manage_internalization', '{"icon": "ri:global-line", "order": 0, "title": "system-manage_internalization", "i18nKey": "route.system-manage_internalization", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 3, NULL, '2024-08-20 06:29:01.881', '2024-09-04 02:18:14.03', NULL);
    65. 

  65. INSERT INTO "public"."Menu" VALUES ('5f504e9d-7e9e-4474-9747-cce41b41599f', '403', 'MENU', NULL, '403', '/403', 'layout.blank$view.403', '{"order": 0, "title": "403", "i18nKey": "route.403", "constant": true, "multiTab": false, "keepAlive": false, "hideInMenu": true}', 7, NULL, '2024-08-20 06:36:06.285', '2024-09-10 02:17:34.406', '{}');
    66. 

  66. INSERT INTO "public"."Menu" VALUES ('7db840cf-4d26-497f-9821-227dca0787d9', '404', 'MENU', NULL, '404', '/404', 'layout.blank$view.404', '{"order": 0, "title": "404", "i18nKey": "route.404", "constant": true, "multiTab": false, "keepAlive": false, "hideInMenu": true}', 8, NULL, '2024-08-20 06:37:27.573', '2024-09-10 02:17:55.262', '{}');
    67. 

  67. INSERT INTO "public"."Menu" VALUES ('75323ec9-1a06-4159-b850-6360fb868f29', 'iframe-page', 'MENU', NULL, 'iframe-page', '/iframe-page/:url', 'layout.base$view.iframe-page', '{"order": 0, "title": "iframe-page", "i18nKey": "route.iframe-page", "constant": true, "multiTab": false, "keepAlive": true, "hideInMenu": true}', 10, NULL, '2024-08-20 07:05:43.315', '2024-09-10 02:18:22.708', '{}');
    68. 

  68. INSERT INTO "public"."Menu" VALUES ('e3f98b23-30a9-4b6b-b15c-fe08b13baf5f', '新增', 'BUTTON', 'aaf9caab-e4cc-491c-bf9c-d5fe81b9d867', NULL, NULL, NULL, NULL, 1, 'system-manage:internalization:add', '2024-08-22 08:21:52.645', '2024-08-22 08:21:52.645', NULL);
    69. 

  69. INSERT INTO "public"."Menu" VALUES ('f309088f-e63d-48a1-8dce-1b9409dfe0b0', '批量删除', 'BUTTON', '596eba6b-6b80-495a-bf9d-f90fdfb9e49d', NULL, NULL, NULL, NULL, 1, 'system-manage:operation-log:batch-delete', '2024-08-22 08:23:58.717', '2024-08-22 08:23:58.717', NULL);
    70. 

  70. INSERT INTO "public"."Menu" VALUES ('7abbee43-cd32-4633-9702-2511eda28357', '新增', 'BUTTON', '2e7aa93e-978c-42e3-aef3-49ec2c7fa183', NULL, NULL, NULL, NULL, 1, 'system-manage:role-manage:add', '2024-08-22 08:31:12.317', '2024-08-22 08:31:12.317', NULL);
    71. 

  71. INSERT INTO "public"."Menu" VALUES ('37191c9a-19b7-43aa-9ad5-369100f1407c', '编辑', 'BUTTON', '28a745e9-ff3a-49c2-bebc-e269146652e6', NULL, NULL, NULL, NULL, 1, 'system-manage:menu-manage:edit', '2024-08-22 08:20:52.452', '2024-08-22 08:20:52.452', NULL);
    72. 

  72. INSERT INTO "public"."Menu" VALUES ('596eba6b-6b80-495a-bf9d-f90fdfb9e49d', '操作日志', 'MENU', '572c5097-d28f-48b4-899d-3aaf46b8d668', 'system-manage_operation-log', '/system-manage/operation-log', 'view.system-manage_operation-log', '{"icon": "ri:draft-line", "order": 0, "title": "system-manage_operation-log", "i18nKey": "route.system-manage_operation-log", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 4, NULL, '2024-08-20 06:30:11.766', '2024-09-04 02:18:26.169', NULL);
    73. 

  73. INSERT INTO "public"."Menu" VALUES ('4bcb5d6b-f876-4e95-8e13-e847bcb18d5d', '编辑', 'BUTTON', 'aaf9caab-e4cc-491c-bf9c-d5fe81b9d867', NULL, NULL, NULL, NULL, 1, 'system-manage:internalization:edit', '2024-08-22 08:22:10.661', '2024-08-22 08:22:10.661', NULL);
    74. 

  74. INSERT INTO "public"."Menu" VALUES ('7131adbe-2b2b-4233-ab50-e9ee1859b09b', '删除', 'BUTTON', 'aaf9caab-e4cc-491c-bf9c-d5fe81b9d867', NULL, NULL, NULL, NULL, 1, 'system-manage:internalization:delete', '2024-08-22 08:22:23.636', '2024-08-22 08:22:23.636', NULL);
    75. 

  75. INSERT INTO "public"."Menu" VALUES ('848a03e4-25db-41f8-97bf-c154fa160c64', '删除', 'BUTTON', '596eba6b-6b80-495a-bf9d-f90fdfb9e49d', NULL, NULL, NULL, NULL, 1, 'system-manage:operation-log:delete', '2024-08-22 08:23:32.366', '2024-08-22 08:23:32.366', NULL);
    76. 

  76. INSERT INTO "public"."Menu" VALUES ('a8304bfd-0b75-4203-aa30-24c0ee98d4f5', '编辑', 'BUTTON', '2e7aa93e-978c-42e3-aef3-49ec2c7fa183', NULL, NULL, NULL, NULL, 1, 'system-manage:role-manage:edit', '2024-08-22 08:31:27.964', '2024-08-22 08:31:27.964', NULL);
    77. 

  77. INSERT INTO "public"."Menu" VALUES ('3064dd2b-38d6-46ba-965e-21a101da688c', '删除', 'BUTTON', '2e7aa93e-978c-42e3-aef3-49ec2c7fa183', NULL, NULL, NULL, NULL, 1, 'system-manage:role-manage:delete', '2024-08-22 08:31:43.239', '2024-08-22 08:31:43.239', NULL);
    78. 

  78. INSERT INTO "public"."Menu" VALUES ('9e378453-357b-4395-a342-d53f98d6db46', '删除', 'BUTTON', '28a745e9-ff3a-49c2-bebc-e269146652e6', NULL, NULL, NULL, NULL, 1, 'system-manage:menu-manage:delete', '2024-08-22 08:21:07.695', '2024-08-22 08:21:07.695', NULL);
    79. 

  79. INSERT INTO "public"."Menu" VALUES ('fd9ac9a5-be38-426c-b38a-8bda75420ffc', '查看', 'BUTTON', 'dea4e038-592f-4532-ac86-c7de25a3416c', NULL, NULL, NULL, NULL, 1, 'administrative:organization:view', '2024-08-23 05:37:09.583', '2024-08-23 05:37:09.583', NULL);
    80. 

  80. INSERT INTO "public"."Menu" VALUES ('48d6f0b5-5b11-422c-bee9-d1caa8447966', '查看', 'BUTTON', '5dc9be35-dfad-493e-99c4-fdca4ddff1f5', NULL, NULL, NULL, NULL, 1, 'administrative:post-manage:view', '2024-08-23 05:50:11.134', '2024-08-23 05:50:11.134', NULL);
    81. 

  81. INSERT INTO "public"."Menu" VALUES ('e1b37b30-e000-4c24-8976-8c9fa78042b0', '查看', 'BUTTON', '1ee566d9-d5ef-456a-8009-d67bb026b4b0', NULL, NULL, NULL, NULL, 1, 'system-manage:user-manage:view', '2024-08-23 05:51:07.705', '2024-08-23 05:51:07.705', NULL);
    82. 

  82. INSERT INTO "public"."Menu" VALUES ('0c437ad9-c18e-46df-b2c1-c1330601ac3c', '查看', 'BUTTON', '28a745e9-ff3a-49c2-bebc-e269146652e6', NULL, NULL, NULL, NULL, 1, 'system-manage:menu-manage:view', '2024-08-23 05:52:04.806', '2024-08-23 05:52:04.806', NULL);
    83. 

  83. INSERT INTO "public"."Menu" VALUES ('9ff718db-c9f9-4fd4-8cc2-d6212b74c336', '查看', 'BUTTON', '2e7aa93e-978c-42e3-aef3-49ec2c7fa183', NULL, NULL, NULL, NULL, 1, 'system-manage:role-manage:view', '2024-08-23 05:52:38.264', '2024-08-23 05:52:38.264', NULL);
    84. 

  84. INSERT INTO "public"."Menu" VALUES ('6b52bc0a-f2b6-4422-8ef8-dde0c5b81f96', '查看', 'BUTTON', 'aaf9caab-e4cc-491c-bf9c-d5fe81b9d867', NULL, NULL, NULL, NULL, 1, 'system-manage:internalization:view', '2024-08-23 05:53:11.889', '2024-08-23 05:53:11.889', NULL);
    85. 

  85. INSERT INTO "public"."Menu" VALUES ('52ff7472-67da-4f9b-ba90-ec5468492f32', '查看', 'BUTTON', '596eba6b-6b80-495a-bf9d-f90fdfb9e49d', NULL, NULL, NULL, NULL, 1, 'system-manage:operation-log:view', '2024-08-23 05:53:46.945', '2024-08-23 05:53:46.945', NULL);
    86. 

  86. INSERT INTO "public"."Menu" VALUES ('e02f4271-4f9b-47e5-a76f-040db8404bd2', '新增', 'BUTTON', '74ca9688-7700-4322-b36f-e1180c5b996b', NULL, NULL, NULL, NULL, 1, 'administrative:message:add', '2024-09-02 09:03:35.181', '2024-09-02 09:03:35.181', NULL);
    87. 

  87. INSERT INTO "public"."Menu" VALUES ('ad167628-1055-470c-90ba-f401c4edc621', '编辑', 'BUTTON', '74ca9688-7700-4322-b36f-e1180c5b996b', NULL, NULL, NULL, NULL, 1, 'administrative:message:edit', '2024-09-02 09:03:52.305', '2024-09-02 09:03:52.305', NULL);
    88. 

  88. INSERT INTO "public"."Menu" VALUES ('db837491-6a97-412d-8668-32de8e286390', '删除', 'BUTTON', '74ca9688-7700-4322-b36f-e1180c5b996b', NULL, NULL, NULL, NULL, 1, 'administrative:message:delete', '2024-09-02 09:04:05.842', '2024-09-02 09:04:05.842', NULL);
    89. 

  89. INSERT INTO "public"."Menu" VALUES ('45d1f4ea-a1e5-4e48-b6a7-141e1fa63b67', '查看', 'BUTTON', '74ca9688-7700-4322-b36f-e1180c5b996b', NULL, NULL, NULL, NULL, 1, 'administrative:message:view', '2024-09-02 09:04:20.88', '2024-09-02 09:04:20.88', NULL);
    90. 

  90. INSERT INTO "public"."Menu" VALUES ('18cf7039-a676-4510-8364-033fa086fdfd', '消息公告详情', 'MENU', '03404a66-50aa-4b21-8c93-9dcddaeffdb7', 'administrative_message-detail', '/administrative/message-detail/:id', 'view.administrative_message-detail', '{"order": 0, "title": "administrative_message-detail", "i18nKey": "route.administrative_message-detail", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": true}', 1, NULL, '2024-09-03 09:32:36.508', '2024-09-04 01:50:07.801', NULL);
    91. 

  91. INSERT INTO "public"."Menu" VALUES ('74ca9688-7700-4322-b36f-e1180c5b996b', '消息公告', 'MENU', '03404a66-50aa-4b21-8c93-9dcddaeffdb7', 'administrative_message', '/administrative/message', 'view.administrative_message', '{"icon": "ri:notification-line", "order": 0, "title": "administrative_message", "i18nKey": "route.administrative_message", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 1, NULL, '2024-09-02 08:38:37.368', '2024-09-04 02:16:34.082', NULL);
    92. 

  92. INSERT INTO "public"."Menu" VALUES ('2e7aa93e-978c-42e3-aef3-49ec2c7fa183', '角色管理', 'MENU', '572c5097-d28f-48b4-899d-3aaf46b8d668', 'system-manage_role-manage', '/system-manage/role-manage', 'view.system-manage_role-manage', '{"icon": "carbon:user-role", "order": 0, "title": "system-manage_role-manage", "i18nKey": "route.system-manage_role-manage", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 3, NULL, '2024-08-22 08:30:20.282', '2024-09-04 02:18:02.508', NULL);
    93. 

  93. INSERT INTO "public"."Menu" VALUES ('881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', '功能页', 'DIRECTORY', NULL, 'features', '/features', 'layout.base', '{"icon": "ri:flower-line", "order": 4, "title": "features", "i18nKey": "route.features", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 4, NULL, '2024-09-10 02:24:51.734', '2024-09-10 02:24:51.734', '{"url": ""}');
    94. 

  94. INSERT INTO "public"."Menu" VALUES ('df07b7c5-a08e-4404-809f-0e4315859c9e', 'Nest.js', 'MENU', '3024936c-5e4f-4b0a-a5a8-6360d8294987', 'document_nest', '/document/nest', 'view.iframe-page', '{"href": "https://nestjs.com/", "icon": "logos:nestjs", "order": 1, "title": "document_nest", "i18nKey": "route.document_nest", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 2, NULL, '2024-09-09 08:45:56.931', '2024-09-09 08:46:52.274', NULL);
    95. 

  95. INSERT INTO "public"."Menu" VALUES ('6df447b0-d2c2-47a2-afd0-db418db85e76', 'Ant Design Vue', 'MENU', '3024936c-5e4f-4b0a-a5a8-6360d8294987', 'document_antd', '/document/antd', 'view.iframe-page', '{"href": "https://www.antdv.com/", "icon": "logos:ant-design", "order": 2, "title": "document_antd", "i18nKey": "route.document_antd", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 3, NULL, '2024-09-09 08:50:47.598', '2024-09-09 08:50:47.598', NULL);
    96. 

  96. INSERT INTO "public"."Menu" VALUES ('86714c51-fce0-498d-9b4f-32fd00ea26a0', 'UnoCSS', 'MENU', '3024936c-5e4f-4b0a-a5a8-6360d8294987', 'document_unocss', '/document/unocss', 'view.iframe-page', '{"href": "https://unocss.dev/", "icon": "logos:unocss", "order": 3, "title": "document_unocss", "i18nKey": "route.document_unocss", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 4, NULL, '2024-09-09 08:51:59.957', '2024-09-09 08:51:59.957', NULL);
    97. 

  97. INSERT INTO "public"."Menu" VALUES ('e38ca869-3931-427b-9f19-724416354d24', 'SoybeanAdmin', 'MENU', '3024936c-5e4f-4b0a-a5a8-6360d8294987', 'document_soybean', '/document/soybean', 'view.iframe-page', '{"order": 0, "title": "document_soybean", "i18nKey": "route.document_soybean", "constant": false, "multiTab": false, "keepAlive": false, "localIcon": "soybean", "hideInMenu": false}', 1, NULL, '2024-09-09 09:39:31.997', '2024-09-09 09:40:40.345', '{"url": "https://docs.soybeanjs.cn/zh"}');
    98. 

  98. INSERT INTO "public"."Menu" VALUES ('63183e8c-0c27-4642-b783-53290cc7e957', 'Vue3', 'MENU', '3024936c-5e4f-4b0a-a5a8-6360d8294987', 'document_vue', '/document/vue', 'view.iframe-page', '{"href": "https://cn.vuejs.org/", "icon": "logos:vue", "order": 0, "title": "document_vue", "i18nKey": "route.document_vue", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 1, NULL, '2024-09-09 08:34:54.629', '2024-09-09 09:27:10.771', '{"url": ""}');
    99. 

  99. INSERT INTO "public"."Menu" VALUES ('3024936c-5e4f-4b0a-a5a8-6360d8294987', '技术文档', 'DIRECTORY', NULL, 'document', '/document', 'layout.base', '{"icon": "mdi:file-document-multiple-outline", "order": 4, "title": "document", "i18nKey": "route.document", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 4, NULL, '2024-09-09 08:29:29.561', '2024-09-10 02:16:01.623', '{}');
    100. 

  100. INSERT INTO "public"."Menu" VALUES ('3bceaa2a-4444-4593-8cf1-acf55ee208bf', '验证码', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_captcha', '/features/captcha', 'view.features_captcha', '{"icon": "ri:terminal-box-line", "order": 0, "title": "features_captcha", "i18nKey": "route.features_captcha", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 1, NULL, '2024-09-10 02:28:31.168', '2024-09-10 02:28:31.168', '{"url": ""}');
    101. 

  101. INSERT INTO "public"."Menu" VALUES ('d62fde7d-061a-4134-a1a5-88d084299852', '组织架构', 'MENU', '03404a66-50aa-4b21-8c93-9dcddaeffdb7', 'administrative_framework', '/administrative/framework', 'view.administrative_framework', '{"icon": "ri:organization-chart", "order": 1, "title": "administrative_framework", "i18nKey": "route.administrative_framework", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 1, NULL, '2024-09-14 03:36:16.8', '2024-09-14 03:38:34.886', '{"url": ""}');
    102. 

  102. INSERT INTO "public"."Menu" VALUES ('ca0a8df9-7daa-4abf-b9dc-9e3f15bed7c4', '打印', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_print', '/features/print', 'view.features_print', '{"icon": "ri:printer-line", "order": 1, "title": "features_print", "i18nKey": "route.features_print", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 2, NULL, '2024-09-14 09:45:34.084', '2024-09-14 09:57:00.156', '{"url": ""}');
    103. 

  103. INSERT INTO "public"."Menu" VALUES ('e648628c-e4f3-4abe-a3d6-452b10dd308f', '拾色器', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_pickr', '/features/pickr', 'view.features_pickr', '{"icon": "ri:color-filter-line", "order": 2, "title": "features_pickr", "i18nKey": "route.features_pickr", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 3, NULL, '2024-09-19 01:12:43.102', '2024-09-19 01:12:43.102', '{"url": ""}');
    104. 

  104. INSERT INTO "public"."Menu" VALUES ('f7650658-054e-4dca-8fba-92ffa2421f9d', '甘特图', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_gantt', '/features/gantt', 'view.features_gantt', '{"icon": "fa6-solid:chart-gantt", "order": 3, "title": "features_gantt", "i18nKey": "route.features_gantt", "constant": false, "multiTab": false, "keepAlive": true, "hideInMenu": false}', 4, NULL, '2024-09-19 06:52:16.933', '2024-09-19 06:52:16.933', '{"url": ""}');
    105. 

  105. INSERT INTO "public"."Menu" VALUES ('fa772008-e045-479b-9d7e-09c04b584277', '图片预览', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_viewer', '/features/viewer', 'view.features_viewer', '{"icon": "ri:image-line", "order": 4, "title": "features_viewer", "i18nKey": "route.features_viewer", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 5, NULL, '2024-09-19 08:30:24.502', '2024-09-19 08:30:24.502', '{"url": ""}');
    106. 

  106. INSERT INTO "public"."Menu" VALUES ('c6d8811b-1f1d-46dd-9b29-da46b2278a48', '自定义Vue指令', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_vue-directive', '/features/vue-directive', 'view.features_vue-directive', '{"icon": "ri:command-line", "order": 5, "title": "features_vue-directive", "i18nKey": "route.features_vue-directive", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 6, NULL, '2024-09-19 10:12:57.26', '2024-09-19 10:12:57.26', '{"url": ""}');
    107. 

  107. INSERT INTO "public"."Menu" VALUES ('0f6fcc34-8913-47a7-8b28-0c526a22b947', '懒加载', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_lazyload', '/features/lazyload', 'view.features_lazyload', '{"icon": "ri:image-add-line", "order": 6, "title": "features_lazyload", "i18nKey": "route.features_lazyload", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 7, NULL, '2024-09-20 07:25:06.294', '2024-09-20 07:25:06.294', '{"url": ""}');
    108. 

  108. INSERT INTO "public"."Menu" VALUES ('a9a40b3f-a86a-4d47-be45-fda5e5bcfaf8', '图片取色盘', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_colorthief', '/features/colorthief', 'view.features_colorthief', '{"icon": "ri:palette-line", "order": 7, "title": "features_colorthief", "i18nKey": "route.features_colorthief", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 8, NULL, '2024-09-20 09:28:35.305', '2024-09-20 09:28:35.305', '{"url": ""}');
    109. 

  109. INSERT INTO "public"."Menu" VALUES ('891b01b1-bd1b-4caf-93b2-f7dadd7d2b4b', '系统级取色器', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_eye-dropper', '/features/eye-dropper', 'view.features_eye-dropper', '{"icon": "ri:dropper-line", "order": 8, "title": "features_eye-dropper", "i18nKey": "route.features_eye-dropper", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 9, NULL, '2024-09-23 06:06:37.493', '2024-09-23 06:06:37.493', '{"url": ""}');
    110. 

  110. INSERT INTO "public"."Menu" VALUES ('8d3e24e9-fcac-42a8-b1b8-d26d71d06985', '文件预览', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_vue-office', '/features/vue-office', 'view.features_vue-office', '{"icon": "ri:file-excel-2-line", "order": 9, "title": "features_vue-office", "i18nKey": "route.features_vue-office", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 10, NULL, '2024-09-23 07:41:29.012', '2024-09-23 07:41:29.012', '{"url": ""}');
    111. 

  111. INSERT INTO "public"."Menu" VALUES ('2a784982-3f4e-4fea-a44e-ab9f7aa302f3', '流程图', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_flow', '/features/flow', 'view.features_flow', '{"icon": "ri:flow-chart", "order": 10, "title": "features_flow", "i18nKey": "route.features_flow", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 11, NULL, '2024-09-25 01:35:16.337', '2024-09-25 01:35:16.337', '{"url": ""}');
    112. 

  112. INSERT INTO "public"."Menu" VALUES ('240ed870-775b-42d4-abb3-5d915df5c57f', '瀑布流', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_waterfall', '/features/waterfall', 'view.features_waterfall', '{"icon": "icon-park-outline:waterfalls-h", "order": 11, "title": "features_waterfall", "i18nKey": "route.features_waterfall", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 12, NULL, '2024-09-26 05:43:14.15', '2024-09-26 05:43:14.15', '{"url": ""}');
    113. 

  113. INSERT INTO "public"."Menu" VALUES ('7e88d5a1-0517-49ac-b476-f8da0dfa1ef7', 'Swiper', 'MENU', '881a0e88-22e8-49ea-813c-4eaa4e3d6aaa', 'features_swiper', '/features/swiper', 'view.features_swiper', '{"icon": "simple-icons:swiper", "order": 12, "title": "features_swiper", "i18nKey": "route.features_swiper", "constant": false, "multiTab": false, "keepAlive": false, "hideInMenu": false}', 13, NULL, '2024-09-26 12:10:27.649', '2024-09-26 12:10:27.649', '{"url": ""}');
    114. 

  114. 

  115. -- ----------------------------
    116. 

  116. -- Indexes structure for table Menu
    117. 

  117. -- ----------------------------
    118. 

  118. CREATE UNIQUE INDEX "Menu_name_key" ON "public"."Menu" USING btree (
    119. 

  119.   "name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    120. 

  120. );
    121. 

  121. CREATE UNIQUE INDEX "Menu_path_key" ON "public"."Menu" USING btree (
    122. 

  122.   "path" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    123. 

  123. );
    124. 

  124. CREATE UNIQUE INDEX "Menu_permission_key" ON "public"."Menu" USING btree (
    125. 

  125.   "permission" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
    126. 

  126. );
    127. 

  127. 

  128. -- ----------------------------
    129. 

  129. -- Primary Key structure for table Menu
    130. 

  130. -- ----------------------------
    131. 

  131. ALTER TABLE "public"."Menu" ADD CONSTRAINT "Menu_pkey" PRIMARY KEY ("id");
    132. 

  132. 

  133. -- ----------------------------
    134. 

  134. -- Foreign Keys structure for table Menu
    135. 

  135. -- ----------------------------
    136. 

  136. ALTER TABLE "public"."Menu" ADD CONSTRAINT "Menu_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "public"."Menu" ("id") ON DELETE SET NULL ON UPDATE CASCADE;
    137.