-- Add delivery_method column to notifications table
-- Migration: 006_add_delivery_method_to_notifications.sql
-- Date: 2024-01-18
-- Purpose: Add delivery_method column to notifications table for email/SMS delivery preferences

ALTER TABLE notifications ADD COLUMN delivery_method VARCHAR(10) NOT NULL DEFAULT 'email';