-- Add manual author name field to posts table
-- This allows storing custom author names for posts

ALTER TABLE posts ADD COLUMN manual_author_name VARCHAR(255) DEFAULT NULL;

-- Update existing posts to have manual_author_name as NULL (they use author_id)
-- New posts can use either author_id (for registered users) or manual_author_name (for custom names)