-- Optional daily reminders after locker expiry. Import after 16-push-notification-settings.sql.
ALTER TABLE `push_notification_settings`
    ADD COLUMN IF NOT EXISTS `send_after_expiry_daily` TINYINT(1) NOT NULL DEFAULT 0 AFTER `is_enabled`,
    ADD COLUMN IF NOT EXISTS `expired_max_days` INT UNSIGNED NOT NULL DEFAULT 30 AFTER `send_after_expiry_daily`;
SELECT * FROM `push_notification_settings`;