-- Adds per-user email notification opt-out for assignments/announcements
-- (see api/messages.php). Run once via phpMyAdmin -> Import, or:
--   mysql -u user -p dbname < sql/migration_006_notifications.sql

ALTER TABLE users
    ADD COLUMN email_notifications TINYINT(1) NOT NULL DEFAULT 1 AFTER active;