CREATE TABLE IF NOT EXISTS `tcm_app_user_notification_setting` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT 'APP用户ID',
  `order_status_update_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '订单状态更新通知开关',
  `activity_notice_enabled` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '活动通知开关',
  `course_update_enabled` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '课程更新通知开关',
  `live_reservation_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '直播预约通知开关',
  `advance_notice_minutes` INT NOT NULL DEFAULT 60 COMMENT '直播提醒提前分钟数',
  `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_app_user_notification_setting_user_deleted` (`app_user_id`, `deleted`),
  KEY `idx_app_user_notification_setting_user` (`app_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='APP用户通知设置表';