diff options
Diffstat (limited to 'db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb')
-rw-r--r-- | db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb b/db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb index 7732728..e1d3062 100644 --- a/db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb +++ b/db/migrate/20230325024534_add_index_spanning_users_and_addresses.rb @@ -1,7 +1,11 @@ class AddIndexSpanningUsersAndAddresses < ActiveRecord::Migration[7.0] def change + remove_foreign_key(:user_account_addresses, :user_accounts) + remove_foreign_key(:user_account_addresses, :addresses) remove_index(:user_account_addresses, :user_account_id) remove_index(:user_account_addresses, :address_id) + add_foreign_key(:user_account_addresses, :user_accounts) + add_foreign_key(:user_account_addresses, :addresses) add_index(:user_account_addresses, :user_account_id) add_index(:user_account_addresses, :address_id) add_index(:user_account_addresses, [:address_id, :user_account_id], unique: true) |