Files
ubicloud/migrate/20250116_fix_usage_alert_unique_index.rb
Jeremy Evans eb36f8a7c4 Fix unique index for usage_alert
It should include user_id, since each user manages their usage
alerts separately.
2025-01-16 14:31:53 -08:00

16 lines
638 B
Ruby

# frozen_string_literal: true
Sequel.migration do
no_transaction
up do
add_index :usage_alert, [:project_id, :user_id, :name], name: :usage_alert_project_id_user_id_name_uidx, unique: true, concurrently: true
drop_index :usage_alert, [:project_id, :name], name: :usage_alert_project_id_name_uidx, unique: true, concurrently: true
end
down do
add_index :usage_alert, [:project_id, :name], name: :usage_alert_project_id_name_uidx, unique: true, concurrently: true
drop_index :usage_alert, [:project_id, :user_id, :name], name: :usage_alert_project_id_user_id_name_uidx, unique: true, concurrently: true
end
end