-- Add author bio fields to blog_posts table
ALTER TABLE `blog_posts` 
ADD COLUMN `post_author_name` VARCHAR(255) NULL AFTER `post_author`,
ADD COLUMN `post_author_bio` TEXT NULL AFTER `post_author_name`;
