-- Migration: Add email and phone fields to customers table
-- Description: Adds contact information fields (email, phone) to customers table
-- Date: 2025-01-XX

-- Add email column
ALTER TABLE customers 
ADD COLUMN email VARCHAR(255) NULL AFTER customer_type,
ADD COLUMN phone VARCHAR(20) NULL AFTER email;

-- Add indexes for faster lookups
CREATE INDEX idx_customers_email ON customers(email);
CREATE INDEX idx_customers_phone ON customers(phone);

