10 lines
362 B
SQL
Executable File
10 lines
362 B
SQL
Executable File
-- 回滚：删除 livestream_prizes 表的奖励配置字段
|
|
-- 原因：简化设计，将奖励配置移到活动级别
|
|
|
|
-- 删除奖励配置字段
|
|
ALTER TABLE livestream_prizes DROP COLUMN IF EXISTS reward_type;
|
|
ALTER TABLE livestream_prizes DROP COLUMN IF EXISTS reward_quantity;
|
|
|
|
-- 删除索引
|
|
DROP INDEX IF EXISTS idx_reward_type ON livestream_prizes;
|