-- Migration to add view_count column to jobs table for tracking job views

USE bolsa_trabajo;

ALTER TABLE jobs ADD COLUMN view_count INT DEFAULT 0;

-- Add index for performance on view_count queries
CREATE INDEX idx_jobs_view_count ON jobs(view_count);