17 lines
696 B
SQL
17 lines
696 B
SQL
SET @current_schema := DATABASE();
|
|
|
|
SET @add_voice_room_rocket_reward_copies_sql := IF(
|
|
NOT EXISTS (
|
|
SELECT 1
|
|
FROM information_schema.columns
|
|
WHERE table_schema = @current_schema
|
|
AND table_name = 'voice_room_rocket_reward_config'
|
|
AND column_name = 'reward_copies'
|
|
),
|
|
'ALTER TABLE `voice_room_rocket_reward_config` ADD COLUMN `reward_copies` int NOT NULL DEFAULT 1 COMMENT ''IN_ROOM 本奖励每次发射可发放份数'' AFTER `expire_days`',
|
|
'SELECT 1'
|
|
);
|
|
PREPARE add_voice_room_rocket_reward_copies_stmt FROM @add_voice_room_rocket_reward_copies_sql;
|
|
EXECUTE add_voice_room_rocket_reward_copies_stmt;
|
|
DEALLOCATE PREPARE add_voice_room_rocket_reward_copies_stmt;
|