1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| CREATE TABLE IF NOT EXISTS `tcm_system_banner_config` (
| `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
| `banner_img` VARCHAR(512) NOT NULL COMMENT 'Banner图片',
| `title` VARCHAR(64) NOT NULL COMMENT 'Banner标题',
| `start_at` DATETIME NOT NULL COMMENT '展示开始时间',
| `end_at` DATETIME NOT NULL COMMENT '展示结束时间',
| `jump_type` VARCHAR(32) NOT NULL COMMENT '跳转类型',
| `target_id` BIGINT UNSIGNED DEFAULT NULL COMMENT '跳转目标ID',
| `target_name` VARCHAR(64) DEFAULT NULL COMMENT '跳转目标名称',
| `target_url` VARCHAR(512) DEFAULT NULL 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_system_banner_time` (`start_at`, `end_at`),
| KEY `idx_system_banner_jump_type` (`jump_type`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Banner配置表';
|
| INSERT IGNORE INTO `tcm_system_banner_config`
| (`id`, `banner_img`, `title`, `start_at`, `end_at`, `jump_type`, `target_id`, `target_name`, `target_url`, `publish_enabled`, `deleted`, `created_by`, `updated_by`)
| VALUES
| (1, 'https://example.com/banner/member-discount.png', '会员显示折扣', '2024-05-05 12:25:33', '2024-06-01 12:25:33', 'MEMBER', NULL, '会员', NULL, 1, 0, '系统初始化', '系统初始化'),
| (2, 'https://example.com/banner/health-course.png', '兑换商城优惠券更新', '2024-05-05 12:25:33', '2024-06-01 12:25:33', 'HEALTH_COURSE', 1, '养生课程1', NULL, 1, 0, '系统初始化', '系统初始化'),
| (3, 'https://example.com/banner/third-party.png', '标题标题题', '2024-05-05 12:25:33', '2024-06-01 12:25:33', 'THIRD_PARTY_URL', NULL, NULL, 'https://www.baidu.com', 0, 0, '系统初始化', '系统初始化');
|
| INSERT IGNORE INTO `sys_menu`
| (`id`, `parent_id`, `name`, `menu_code`, `type`, `path`, `component`, `icon`, `sort`, `status`, `visible`, `permission_key`, `remark`, `deleted`)
| VALUES
| (1300, 1000, '系统设置', 'system_setting_group', 'M', '/system/settings', NULL, NULL, 30, 1, 1, NULL, '系统设置目录', 0),
| (1314, 1300, 'Banner配置', 'system_banner_settings', 'C', '/system/settings/banner', 'System/BannerSettings', NULL, 12, 1, 1, 'system:banner:view', 'Banner配置菜单', 0),
| (1315, 1314, '新增Banner', 'system_banner_settings_add', 'B', NULL, NULL, NULL, 1, 1, 1, 'system:banner:add', 'Banner新增按钮', 0),
| (1316, 1314, '编辑Banner', 'system_banner_settings_edit', 'B', NULL, NULL, NULL, 2, 1, 1, 'system:banner:edit', 'Banner编辑按钮', 0),
| (1317, 1314, '查看Banner', 'system_banner_settings_detail', 'B', NULL, NULL, NULL, 3, 1, 1, 'system:banner:detail', 'Banner查看按钮', 0),
| (1318, 1314, '删除Banner', 'system_banner_settings_delete', 'B', NULL, NULL, NULL, 4, 1, 1, 'system:banner:delete', 'Banner删除按钮', 0),
| (1319, 1314, '批量删除Banner', 'system_banner_settings_batch_delete', 'B', NULL, NULL, NULL, 5, 1, 1, 'system:banner:batch-delete', 'Banner批量删除按钮', 0),
| (1320, 1314, '切换Banner上架状态', 'system_banner_settings_publish_status', 'B', NULL, NULL, NULL, 6, 1, 1, 'system:banner:publish-status', 'Banner上架状态按钮', 0);
|
| INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`)
| VALUES
| (1, 1300), (1, 1314), (1, 1315), (1, 1316), (1, 1317), (1, 1318), (1, 1319), (1, 1320);
|
|
