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 $$;