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;
|
