-- Add address fields to customers table
ALTER TABLE customers 
ADD COLUMN address VARCHAR(255) DEFAULT NULL,
ADD COLUMN city VARCHAR(100) DEFAULT NULL,
ADD COLUMN state VARCHAR(100) DEFAULT NULL,
ADD COLUMN postal_code VARCHAR(20) DEFAULT NULL,
ADD COLUMN country VARCHAR(2) DEFAULT 'AU';