6 lines
315 B
SQL
6 lines
315 B
SQL
|
UPDATE campaigns SET type = 'TOKENS' WHERE type = 'COINS';
|
||
|
|
UPDATE campaign_rules SET reward_type = 'TOKENS' WHERE reward_type = 'COINS';
|
||
|
|
|
||
|
|
COMMENT ON COLUMN campaigns.type IS 'Type of campaign: REWARD, POINTS, TOKENS, MIXED';
|
||
|
|
COMMENT ON COLUMN campaign_rules.reward_type IS 'Type of reward: POINTS, TOKENS, REWARD';
|