4 lines
187 B
SQL
4 lines
187 B
SQL
-- 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);
|