mailflare/drizzle/migrations/0002_add_message_read.sql

ALTER TABLE `messages` ADD `read` integer DEFAULT false NOT NULL;