Updated 'allison_blog' database by adding the 'author_id' column and dropping the 'author' column.