-- Migration: Update Payroll module columns to use hours
-- Date: 2025-10-08
-- Description: Updates the Payroll module config to display hour columns instead of minute columns

UPDATE modules 
SET config = jsonb_set(
    jsonb_set(
        config,
        '{body,0,tabs,0,elements,0,options,columnsToShow}',
        '["name", "start_date", "end_date", "total_net_hours", "total_overtime_hours", "total_regular_hours", "total_payable_hours", "total_days_worked"]'::jsonb
    ),
    '{body,0,tabs,1,elements,0,options,columnsToShow}',
    '["user_name", "org_name", "gross_pay", "net_pay", "start_date", "end_date"]'::jsonb
)
WHERE module_id = '018e3f0a-12d3-7c45-b89a-2f3c4e1d5b6c'::uuid;
