-- Add metadata field to generated_posts table
-- This field stores additional information like LinkedIn post URLs, auto-posting status, etc.

ALTER TABLE generated_posts
ADD COLUMN IF NOT EXISTS metadata JSONB DEFAULT '{}'::JSONB;

-- Add comment
COMMENT ON COLUMN generated_posts.metadata IS 'Additional metadata (LinkedIn post URL, auto-posting status, etc.)';