From 92a2413a3beede5063e05f85f53f99a70fb676d6 Mon Sep 17 00:00:00 2001 From: “mitao” <“2763622819@qq.com”> Date: 星期四, 26 三月 2026 19:32:28 +0800 Subject: [PATCH] feat:系统与安全-系统设置-平台资质 --- backend/sql/init.sql | 31 ++++++++++++++++++++++++++++++- 1 files changed, 30 insertions(+), 1 deletions(-) diff --git a/backend/sql/init.sql b/backend/sql/init.sql index da38d93..068ff50 100644 --- a/backend/sql/init.sql +++ b/backend/sql/init.sql @@ -118,6 +118,12 @@ (1321, 1300, '活动通知', 'system_activity_notice', 'C', '/system/settings/activity-notice', 'System/ActivityNotice', NULL, 13, 1, 1, 'system:activity-notice:view', '活动通知菜单', 0), (1322, 1321, '新增活动通知', 'system_activity_notice_add', 'B', NULL, NULL, NULL, 1, 1, 1, 'system:activity-notice:add', '活动通知新增按钮', 0), (1323, 1321, '删除活动通知', 'system_activity_notice_delete', 'B', NULL, NULL, NULL, 2, 1, 1, 'system:activity-notice:delete', '活动通知删除按钮', 0), +(1324, 1300, '平台资质', 'system_platform_qualification', 'C', '/system/settings/platform-qualification', 'System/PlatformQualification', NULL, 14, 1, 1, 'system:platform-qualification:view', '平台资质菜单', 0), +(1325, 1324, '新增平台资质', 'system_platform_qualification_add', 'B', NULL, NULL, NULL, 1, 1, 1, 'system:platform-qualification:add', '平台资质新增按钮', 0), +(1326, 1324, '查看平台资质', 'system_platform_qualification_detail', 'B', NULL, NULL, NULL, 2, 1, 1, 'system:platform-qualification:detail', '平台资质详情按钮', 0), +(1327, 1324, '编辑平台资质', 'system_platform_qualification_edit', 'B', NULL, NULL, NULL, 3, 1, 1, 'system:platform-qualification:edit', '平台资质编辑按钮', 0), +(1328, 1324, '删除平台资质', 'system_platform_qualification_delete', 'B', NULL, NULL, NULL, 4, 1, 1, 'system:platform-qualification:delete', '平台资质删除按钮', 0), +(1329, 1324, '切换平台资质上架状态', 'system_platform_qualification_publish_status', 'B', NULL, NULL, NULL, 5, 1, 1, 'system:platform-qualification:publish-status', '平台资质上架状态按钮', 0), (1310, 1300, '积分设置', 'system_points_settings', 'C', '/system/settings/points', 'System/PointsSettings', NULL, 10, 1, 1, 'system:points-settings:view', '积分设置菜单', 0), (1311, 1310, '编辑积分设置', 'system_points_settings_edit', 'B', NULL, NULL, NULL, 1, 1, 1, 'system:points-settings:edit', '积分设置编辑按钮', 0), (2000, 0, '用户与会员', 'member_root', 'M', '/member', NULL, 'team', 200, 1, 1, NULL, '用户与会员模块', 0), @@ -203,7 +209,7 @@ INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1000), (1, 1100), (1, 1101), (1, 1102), (1, 1103), (1, 1104), (1, 1105), -(1, 1200), (1, 1201), (1, 1202), (1, 1203), (1, 1204), (1, 1300), (1, 1305), (1, 1306), (1, 1307), (1, 1308), (1, 1309), (1, 1310), (1, 1311), (1, 1312), (1, 1313), (1, 1314), (1, 1315), (1, 1316), (1, 1317), (1, 1318), (1, 1319), (1, 1320), (1, 1321), (1, 1322), (1, 1323), +(1, 1200), (1, 1201), (1, 1202), (1, 1203), (1, 1204), (1, 1300), (1, 1305), (1, 1306), (1, 1307), (1, 1308), (1, 1309), (1, 1310), (1, 1311), (1, 1312), (1, 1313), (1, 1314), (1, 1315), (1, 1316), (1, 1317), (1, 1318), (1, 1319), (1, 1320), (1, 1321), (1, 1322), (1, 1323), (1, 1324), (1, 1325), (1, 1326), (1, 1327), (1, 1328), (1, 1329), (1, 2000), (1, 2100), (1, 2110), (1, 2111), (1, 2112), (1, 2113), (1, 2114), (1, 2115), (1, 2116), (1, 2117), (1, 2118), (1, 2119), (1, 2200), (1, 2210), (1, 2211), (1, 2220), (1, 2221), (1, 3000), (1, 3050), (1, 3060), (1, 3061), (1, 3062), (1, 3063), @@ -916,6 +922,29 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='活动通知表'; -- ---------------------------- +-- 平台资质 +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `tcm_platform_qualification` ( + `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, + `qualification_name` VARCHAR(64) NOT NULL COMMENT '资质名称', + `qualification_type` VARCHAR(16) NOT NULL COMMENT '资质类型：RICH_TEXT/LINK', + `record_number` VARCHAR(64) NOT NULL COMMENT '备案号', + `content_html` LONGTEXT DEFAULT NULL COMMENT '资质内容富文本', + `link_url` VARCHAR(512) DEFAULT NULL COMMENT '跳转链接', + `sort` INT NOT NULL DEFAULT 0 COMMENT '排序', + `publish_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否上架：1是 0否', + `deleted` TINYINT(1) NOT NULL DEFAULT 0, + `created_by` VARCHAR(64) NOT NULL DEFAULT '系统初始化' COMMENT '创建人', + `updated_by` VARCHAR(64) NOT NULL DEFAULT '系统初始化' COMMENT '更新人', + `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`id`), + KEY `idx_platform_qualification_created_at` (`created_at`), + KEY `idx_platform_qualification_publish_enabled` (`publish_enabled`), + KEY `idx_platform_qualification_type` (`qualification_type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='平台资质表'; + +-- ---------------------------- -- 积分设置 -- ---------------------------- CREATE TABLE IF NOT EXISTS `tcm_points_config` ( -- Gitblit v1.7.1