-- Fix staff table by adding department_id column
-- Run this in phpMyAdmin or MySQL command line

USE autonomous_college;

-- Add department_id column to staff table
ALTER TABLE staff ADD COLUMN department_id INT NULL;

-- Add foreign key constraint
ALTER TABLE staff ADD CONSTRAINT fk_staff_department 
FOREIGN KEY (department_id) REFERENCES departments(department_id);

-- Add index for better performance
ALTER TABLE staff ADD INDEX idx_staff_department_id (department_id);

-- Verify the changes
DESCRIBE staff;