-- Add type column to customers table
-- Run this SQL in your database

ALTER TABLE customers 
ADD COLUMN type ENUM('customer', 'inhouse') NOT NULL DEFAULT 'customer' 
AFTER status;

-- Optional: Add index for better query performance
CREATE INDEX idx_customers_type ON customers(type);
