Tolan/backend/migrations/add_ab_subtitle_settings_table.sql

/*
  A/B 组实验：字幕开关配置表
  group_key: A / B
  subtitle_on: 0=关, 1=开
  执行前请备份。MySQL 5.7+ / 8.0+
*/

SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS `ab_subtitle_settings` (
  `group_key` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '实验分组：A / B',
  `subtitle_on` tinyint(1) NOT NULL DEFAULT '0' COMMENT '字幕开关：0=关，1=开',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`group_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='A/B组字幕开关配置表';

INSERT INTO `ab_subtitle_settings` (`group_key`, `subtitle_on`) VALUES
('A', 0),
('B', 1)
ON DUPLICATE KEY UPDATE `group_key` = VALUES(`group_key`);