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
| CREATE TABLE IF NOT EXISTS `tcm_message_push_config` (
| `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
| `notice_type_code` VARCHAR(64) NOT NULL COMMENT '通知类型编码',
| `notice_type_name` VARCHAR(64) NOT NULL COMMENT '通知类型名称',
| `push_enabled` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否开启PUSH推送：1是 0否',
| `sms_enabled` TINYINT(1) NOT NULL DEFAULT 0 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`),
| UNIQUE KEY `uk_message_push_notice_type_code` (`notice_type_code`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消息推送配置表';
|
| INSERT IGNORE INTO `tcm_message_push_config`
| (`id`, `notice_type_code`, `notice_type_name`, `push_enabled`, `sms_enabled`, `deleted`, `created_by`, `updated_by`)
| VALUES
| (1, 'MEMBER_EXPIRE_REMIND', '会员到期提醒', 1, 1, 0, '系统初始化', '系统初始化'),
| (2, 'LIVE_REMIND', '直播提醒', 1, 1, 0, '系统初始化', '系统初始化'),
| (3, 'ACTIVITY_NOTICE', '活动通知', 1, 0, 0, '系统初始化', '系统初始化'),
| (4, 'ORDER_STATUS_UPDATE', '订单状态更新', 1, 0, 0, '系统初始化', '系统初始化'),
| (5, 'COURSE_UPDATE_NOTICE', '课程更新通知', 1, 0, 0, '系统初始化', '系统初始化'),
| (6, 'STUDY_PROGRESS_REMIND', '学习进度提醒', 1, 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),
| (1312, 1300, '消息推送配置', 'system_message_push_settings', 'C', '/system/settings/message-push', 'System/MessagePushSettings', NULL, 20, 1, 1, 'system:message-push:view', '消息推送配置菜单', 0),
| (1313, 1312, '编辑消息推送配置', 'system_message_push_settings_edit', 'B', NULL, NULL, NULL, 1, 1, 1, 'system:message-push:edit', '消息推送配置编辑按钮', 0);
|
| INSERT IGNORE INTO `sys_role_menu` (`role_id`, `menu_id`)
| VALUES
| (1, 1300), (1, 1312), (1, 1313);
|
|
