-- Update Vehicle Reports modal to include authorized users table
UPDATE ui_modals
SET config = '{"title":"Vehicle Reports","header":[{"type":"button","label":"Add Report","formName":"Vehicle Issue Report"}],"body":[{"type":"table","id":"vehicleReports","options":{"tableName":"vehicle_reports","showGlobalSearch":false,"addButton":false,"filters":{"status":"open"},"apiRowActions":[{"buttonText":"Accept","apiUrl":"../api/vehicle_reports/{id}/assign"}]}},{"type":"html","html":"<h4 class=\"mt-4\">Authorized Users</h4>"},{"type":"table","id":"vrAuthUsers","options":{"tableName":"users","tableUrl":"../api/vehicle_reports/authorized_users","showGlobalSearch":false,"addButton":false,"columnsToShow":["full_name"]}}],"footer":[{"type":"button","label":"Close","onClick":"closeModal"}]}'
WHERE name = 'Vehicle Reports';
