-- Migration: Add date_start and date_end columns to llx_planning_job
-- ETAP 3.2a: Support for scheduled job time slots

ALTER TABLE llx_planning_job
  ADD COLUMN date_start DATETIME NULL AFTER sort_order,
  ADD COLUMN date_end DATETIME NULL AFTER date_start;

-- Add index for date range queries
ALTER TABLE llx_planning_job
  ADD KEY idx_planning_job_dates (entity, fk_workstation, date_start, date_end);
