-- Update Service Type form fields to use select-addable type
UPDATE form_elements
SET type_id = (SELECT id FROM element_types WHERE name = 'select-addable' LIMIT 1),
    options_table = 'vehicle_makes',
    options_label_column = 'name',
    options_value_column = 'id'
WHERE form_id = 31 AND field_name = 'make';

UPDATE form_elements
SET type_id = (SELECT id FROM element_types WHERE name = 'select-addable' LIMIT 1),
    options_table = 'vehicle_models',
    options_label_column = 'name',
    options_value_column = 'id'
WHERE form_id = 31 AND field_name = 'model';
