-- Add admin review fields to job_posts table
ALTER TABLE job_posts 
ADD COLUMN admin_remarks TEXT NULL,
ADD COLUMN reviewed_by_admin_id INT NULL,
ADD COLUMN reviewed_at DATETIME NULL;

-- Add index for better query performance
CREATE INDEX idx_job_posts_reviewed_by_admin ON job_posts(reviewed_by_admin_id);
CREATE INDEX idx_job_posts_reviewed_at ON job_posts(reviewed_at);