38929-vm/db/migrations/04_fix_prices_key.sql
2026-03-02 10:30:11 +00:00

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