-- Migration: Add employee_id column to users table for lead tracking
-- Run this SQL to add the employee_id column

ALTER TABLE users 
ADD COLUMN employee_id INT NULL,
ADD INDEX idx_employee_id (employee_id);

-- Optional: Add foreign key constraint (uncomment if you want referential integrity)
-- ALTER TABLE users 
-- ADD CONSTRAINT fk_user_employee 
-- FOREIGN KEY (employee_id) REFERENCES employees(employee_id) 
-- ON DELETE SET NULL;

