Content Comparison

- Uppdatera skfab.damage_categories från den tillfälliga matchning.categories_crossref
alter table skfab.damage_categories add column generic integer; 
-- alter table skfab.damage_categories drop column generic; 
update skfab.damage_categories set generic=generic_category_id from  matchning.categories_crossref
where  skfab.damage_categories.damage_category_id = matchning.categories_crossref.damage_category_id;

-- Uppdatera skfab.damage_categories från den tillfälliga matchning.categories_crossref
alter table skfab.damage_types add column generic integer;
-- alter table skfab.damage_types drop column generic;
update skfab.damage_types set generic=generic_type_id from  matchning.types_crossref
where  skfab.damage_types.damage_type_id = matchning.types_crossref.damage_type_id ;

-- Uppdatera skfab.operation_types
alter table skfab.operation_types add column generic integer;
-- alter table skfab.operation_types drop column generic;
update skfab.operation_types set generic=matchning.operation_types_crossref.generic_operation_typetypes_id from  matchning.operation_types_crossref
where  skfab.operation_types.operation_type_id = matchning.operation_types_crossref.operation_type_id;