-- Add author field to books table
-- This field will store the pen name of the author, which can change from book to book

ALTER TABLE books ADD COLUMN IF NOT EXISTS author TEXT;

-- Add index for author field for better query performance
CREATE INDEX IF NOT EXISTS idx_books_author ON books(author);

-- Add helpful comment
COMMENT ON COLUMN books.author IS 'Pen name of the author for this book. Can be different for each book to support pseudonyms.';