17 lines
686 B
SQL
17 lines
686 B
SQL
SET @current_schema := DATABASE();
|
|
|
|
SET @add_voice_room_rocket_preview_url_sql := IF(
|
|
NOT EXISTS (
|
|
SELECT 1
|
|
FROM information_schema.columns
|
|
WHERE table_schema = @current_schema
|
|
AND table_name = 'voice_room_rocket_level_config'
|
|
AND column_name = 'preview_rocket_url'
|
|
),
|
|
'ALTER TABLE `voice_room_rocket_level_config` ADD COLUMN `preview_rocket_url` varchar(512) DEFAULT NULL COMMENT ''预览火箭资源URL'' AFTER `shake_threshold_percent`',
|
|
'SELECT 1'
|
|
);
|
|
PREPARE add_voice_room_rocket_preview_url_stmt FROM @add_voice_room_rocket_preview_url_sql;
|
|
EXECUTE add_voice_room_rocket_preview_url_stmt;
|
|
DEALLOCATE PREPARE add_voice_room_rocket_preview_url_stmt;
|