-- Migration: Add default org_id to employee_shifts table
-- Date: 2025-11-18
-- Purpose: Set default org_id for employee_shifts to Cybex PTE LTD org_id to prevent null constraint violations

-- Add default value for org_id column
ALTER TABLE employee_shifts 
  ALTER COLUMN org_id SET DEFAULT '0194a8b2-1234-7123-8123-123456789abc'::uuid;

-- Update any existing NULL org_id values to Cybex PTE LTD org_id
UPDATE employee_shifts 
SET org_id = '0194a8b2-1234-7123-8123-123456789abc'::uuid 
WHERE org_id IS NULL;
