-- Insert My Inspections modal
INSERT INTO ui_modals (name, config, tenant_id, branch_id, icon, aria_label, description)
SELECT 'My Inspections',
'{"title":"My Inspections","header":[{"type":"button","label":"Add Inspection","wizardId":3}],"body":[{"type":"table","options":{"tableName":"ohs_inspections","scope":"user","userField":"inspector_id","editFormLookup":{"table":"ohs_inspection_types","field":"inspection_type_id","valueColumn":"id","formColumn":"form_id"}}}],"footer":[{"type":"button","label":"Close","onClick":"closeModal"}]}' ,
NULL, NULL, 'fa-clipboard-check', 'My Inspections', 'My Inspections'
WHERE NOT EXISTS (SELECT 1 FROM ui_modals WHERE name = 'My Inspections');
