SET @db_name = DATABASE();

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'student'
  ),
  'RENAME TABLE `student` TO `tcm_app_user`',
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'app_user'
    ),
    'RENAME TABLE `app_user` TO `tcm_app_user`',
    'SELECT 1'
  )
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'clinic'
  ),
  'RENAME TABLE `clinic` TO `tcm_clinic`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'expert'
  ),
  'RENAME TABLE `expert` TO `tcm_expert`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_course'
  ),
  'RENAME TABLE `live_course` TO `tcm_live_course`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_session'
  ),
  'RENAME TABLE `live_session` TO `tcm_live_session`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_session_question'
  ),
  'RENAME TABLE `live_session_question` TO `tcm_live_session_question`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_reserve'
  ),
  'RENAME TABLE `live_reserve` TO `tcm_live_reserve`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_watch_record'
  ),
  'RENAME TABLE `live_watch_record` TO `tcm_live_watch_record`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'live_session_quiz_record'
  ),
  'RENAME TABLE `live_session_quiz_record` TO `tcm_live_session_quiz_record`',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_reserve'
  ),
  'SELECT 1',
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_reserve', 'tcm_live_reserve') AND COLUMN_NAME = 'student_id'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_reserve'
    ),
    'ALTER TABLE `tcm_live_reserve` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID''',
    'ALTER TABLE `live_reserve` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID'''
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_reserve', 'tcm_live_reserve') AND INDEX_NAME = 'uk_session_student'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_reserve'
    ),
    'ALTER TABLE `tcm_live_reserve` DROP INDEX `uk_session_student`, ADD UNIQUE INDEX `uk_session_app_user` (`session_id`, `app_user_id`)',
    'ALTER TABLE `live_reserve` DROP INDEX `uk_session_student`, ADD UNIQUE INDEX `uk_session_app_user` (`session_id`, `app_user_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_reserve', 'tcm_live_reserve') AND INDEX_NAME = 'idx_student_reserve'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_reserve'
    ),
    'ALTER TABLE `tcm_live_reserve` DROP INDEX `idx_student_reserve`, ADD INDEX `idx_app_user_reserve` (`app_user_id`)',
    'ALTER TABLE `live_reserve` DROP INDEX `idx_student_reserve`, ADD INDEX `idx_app_user_reserve` (`app_user_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_watch_record', 'tcm_live_watch_record') AND COLUMN_NAME = 'student_id'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_watch_record'
    ),
    'ALTER TABLE `tcm_live_watch_record` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID''',
    'ALTER TABLE `live_watch_record` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID'''
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_watch_record', 'tcm_live_watch_record') AND INDEX_NAME = 'idx_student_watch'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_watch_record'
    ),
    'ALTER TABLE `tcm_live_watch_record` DROP INDEX `idx_student_watch`, ADD INDEX `idx_app_user_watch` (`app_user_id`)',
    'ALTER TABLE `live_watch_record` DROP INDEX `idx_student_watch`, ADD INDEX `idx_app_user_watch` (`app_user_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_session_quiz_record', 'tcm_live_session_quiz_record') AND COLUMN_NAME = 'student_id'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_session_quiz_record'
    ),
    'ALTER TABLE `tcm_live_session_quiz_record` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID''',
    'ALTER TABLE `live_session_quiz_record` CHANGE COLUMN `student_id` `app_user_id` BIGINT UNSIGNED NOT NULL COMMENT ''用户ID'''
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_session_quiz_record', 'tcm_live_session_quiz_record') AND INDEX_NAME = 'uk_session_student_question'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_session_quiz_record'
    ),
    'ALTER TABLE `tcm_live_session_quiz_record` DROP INDEX `uk_session_student_question`, ADD UNIQUE INDEX `uk_session_app_user_question` (`session_id`, `app_user_id`, `question_id`)',
    'ALTER TABLE `live_session_quiz_record` DROP INDEX `uk_session_student_question`, ADD UNIQUE INDEX `uk_session_app_user_question` (`session_id`, `app_user_id`, `question_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('live_session_quiz_record', 'tcm_live_session_quiz_record') AND INDEX_NAME = 'idx_student_quiz'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_live_session_quiz_record'
    ),
    'ALTER TABLE `tcm_live_session_quiz_record` DROP INDEX `idx_student_quiz`, ADD INDEX `idx_app_user_quiz` (`app_user_id`)',
    'ALTER TABLE `live_session_quiz_record` DROP INDEX `idx_student_quiz`, ADD INDEX `idx_app_user_quiz` (`app_user_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('app_user', 'tcm_app_user') AND INDEX_NAME = 'idx_student_phone'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_app_user'
    ),
    'ALTER TABLE `tcm_app_user` DROP INDEX `idx_student_phone`, ADD INDEX `idx_app_user_phone` (`phone`)',
    'ALTER TABLE `app_user` DROP INDEX `idx_student_phone`, ADD INDEX `idx_app_user_phone` (`phone`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('app_user', 'tcm_app_user') AND INDEX_NAME = 'idx_student_clinic'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_app_user'
    ),
    'ALTER TABLE `tcm_app_user` DROP INDEX `idx_student_clinic`, ADD INDEX `idx_app_user_clinic` (`clinic_id`)',
    'ALTER TABLE `app_user` DROP INDEX `idx_student_clinic`, ADD INDEX `idx_app_user_clinic` (`clinic_id`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql = IF(
  EXISTS (
    SELECT 1
    FROM information_schema.STATISTICS
    WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME IN ('app_user', 'tcm_app_user') AND INDEX_NAME = 'idx_student_status'
  ),
  IF(
    EXISTS (
      SELECT 1
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = @db_name AND TABLE_NAME = 'tcm_app_user'
    ),
    'ALTER TABLE `tcm_app_user` DROP INDEX `idx_student_status`, ADD INDEX `idx_app_user_status` (`status`)',
    'ALTER TABLE `app_user` DROP INDEX `idx_student_status`, ADD INDEX `idx_app_user_status` (`status`)'
  ),
  'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;