-- Fix prices table unique key to include variant_id ALTER TABLE prices DROP INDEX branch_id; ALTER TABLE prices ADD UNIQUE KEY unique_price (branch_id, item_id, variant_id, service_id);