DO $$
DECLARE
    repair_type_id INT;
BEGIN
    --- creation Repair Type
    INSERT INTO loader_repairtype ("created_at", "updated_at", "name", "short_name")
    VALUES ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'Service provide', '')
    RETURNING id into repair_type_id;

    --- creation Measure
    INSERT INTO loader_measure ("created_at", "updated_at", "name", "short_name")
    VALUES ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'Unit', '');

    --- creation Sing Code
    INSERT
    INTO loader_signcode ("created_at", "updated_at", "name", "short_name")
    VALUES ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'SV9', 'Additional detail package'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'ELC4', 'Electrical and electronics work'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'BRK9', 'Brake system work'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'AIR7', 'Air conditioning or climate system work'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'SUS8', 'Suspension and chassis work'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'BDY3', 'Body repair and restoration'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'TUN6', 'Tuning and modifications'),
    ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', 'S5', 'Major or extended service package');

    --- creation Repair Type Mapping
    INSERT INTO loader_repairtypemapping ("created_at", "updated_at", "values", "instance_id")
    VALUES ('2025-01-11 14:41:09.319000 +00:00', '2025-01-11 14:41:09.319000 +00:00', '{Provision of services (repair works)}', repair_type_id);
END $$;