-- Align Prefix Item / Unit Master category names with master list

UPDATE prefix_masters
SET name = 'Badge-Patch', updated_at = CURRENT_TIMESTAMP
WHERE name = 'Badge/Patch' AND deleted_at IS NULL;

UPDATE prefix_masters
SET name = 'Lace-Elastic', updated_at = CURRENT_TIMESTAMP
WHERE name IN ('Lace, Elastic', 'Lace, Elastice') AND deleted_at IS NULL;

UPDATE unit_masters
SET item_category = 'Badge-Patch', updated_at = CURRENT_TIMESTAMP
WHERE item_category = 'Badge/Patch' AND deleted_at IS NULL;

UPDATE unit_masters
SET item_category = 'Lace-Elastic', updated_at = CURRENT_TIMESTAMP
WHERE item_category IN ('Lace, Elastic', 'Lace, Elastice') AND deleted_at IS NULL;