7 lines
354 B
SQL
Executable File
7 lines
354 B
SQL
Executable File
-- 为活动表添加下单奖励配置字段
|
|
ALTER TABLE livestream_activities
|
|
ADD COLUMN order_reward_type VARCHAR(32) DEFAULT '' COMMENT '下单奖励类型: flip_card/minesweeper' AFTER douyin_product_id;
|
|
|
|
ALTER TABLE livestream_activities
|
|
ADD COLUMN order_reward_quantity INT DEFAULT 1 COMMENT '下单奖励数量: 1-100' AFTER order_reward_type;
|