-- ============================================================
-- Migration: Add phone field to orders table
-- Run this SQL if you already have an existing orders table
-- ============================================================

-- Add phone column to orders table if it doesn't exist
ALTER TABLE orders 
ADD COLUMN phone VARCHAR(30) DEFAULT NULL 
AFTER address;

-- Optional: Update description
-- This adds a phone field to capture customer contact number for each order
