-- Add redemption_lock column to user_coins table
-- This prevents ads from awarding coins during coin redemptions

ALTER TABLE user_coins 
ADD COLUMN redemption_lock BOOLEAN DEFAULT FALSE AFTER redeemed_coins;

-- Create index for faster queries on redemption_lock status
CREATE INDEX idx_redemption_lock ON user_coins(redemption_lock);