-- Simple SQL to add referred_by column
-- Copy and paste this directly into phpMyAdmin SQL tab

USE dextragr_will_software_demo;

ALTER TABLE clients ADD COLUMN referred_by BIGINT UNSIGNED NULL AFTER assigned_staff_id;

ALTER TABLE clients ADD CONSTRAINT clients_referred_by_foreign FOREIGN KEY (referred_by) REFERENCES users(id) ON DELETE SET NULL ON UPDATE CASCADE;

-- Verify column was added
SHOW COLUMNS FROM clients LIKE 'referred_by';