/*
  # Add paid status and price fields to posts

  1. Changes
    - Add is_paid (boolean) field to posts table with default false
    - Add price (decimal) field to posts table with default 0
  
  2. Security
    - Posts table already has RLS policies from previous migrations
*/

-- Add new columns to posts table
ALTER TABLE posts 
ADD COLUMN IF NOT EXISTS is_paid BOOLEAN DEFAULT false,
ADD COLUMN IF NOT EXISTS price DECIMAL(10,2) DEFAULT 0.00;