From 4c06d1cb241020f2407a6be01b584c508a06ffe9 Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Mon, 5 Jun 2017 13:24:00 +0200 Subject: Fix #3550 - Add all missing foreign keys (#3562) * Fix #3550 - Add all missing foreign keys * Add missing foreign keys --- ...20170604144747_add_foreign_keys_for_accounts.rb | 41 ++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 db/migrate/20170604144747_add_foreign_keys_for_accounts.rb (limited to 'db/migrate/20170604144747_add_foreign_keys_for_accounts.rb') diff --git a/db/migrate/20170604144747_add_foreign_keys_for_accounts.rb b/db/migrate/20170604144747_add_foreign_keys_for_accounts.rb new file mode 100644 index 000000000..76a836ca0 --- /dev/null +++ b/db/migrate/20170604144747_add_foreign_keys_for_accounts.rb @@ -0,0 +1,41 @@ +class AddForeignKeysForAccounts < ActiveRecord::Migration[5.1] + def change + add_foreign_key :statuses, :accounts, on_delete: :cascade + add_foreign_key :statuses, :accounts, column: :in_reply_to_account_id, on_delete: :nullify + add_foreign_key :statuses, :statuses, column: :in_reply_to_id, on_delete: :nullify + add_foreign_key :account_domain_blocks, :accounts, on_delete: :cascade + add_foreign_key :conversation_mutes, :accounts, on_delete: :cascade + add_foreign_key :conversation_mutes, :conversations, on_delete: :cascade + add_foreign_key :favourites, :accounts, on_delete: :cascade + add_foreign_key :favourites, :statuses, on_delete: :cascade + add_foreign_key :blocks, :accounts, on_delete: :cascade + add_foreign_key :blocks, :accounts, column: :target_account_id, on_delete: :cascade + add_foreign_key :follow_requests, :accounts, on_delete: :cascade + add_foreign_key :follow_requests, :accounts, column: :target_account_id, on_delete: :cascade + add_foreign_key :follows, :accounts, on_delete: :cascade + add_foreign_key :follows, :accounts, column: :target_account_id, on_delete: :cascade + add_foreign_key :mutes, :accounts, on_delete: :cascade + add_foreign_key :mutes, :accounts, column: :target_account_id, on_delete: :cascade + add_foreign_key :imports, :accounts, on_delete: :cascade + add_foreign_key :media_attachments, :accounts, on_delete: :nullify + add_foreign_key :media_attachments, :statuses, on_delete: :nullify + add_foreign_key :mentions, :accounts, on_delete: :cascade + add_foreign_key :mentions, :statuses, on_delete: :cascade + add_foreign_key :notifications, :accounts, on_delete: :cascade + add_foreign_key :notifications, :accounts, column: :from_account_id, on_delete: :cascade + add_foreign_key :preview_cards, :statuses, on_delete: :cascade + add_foreign_key :reports, :accounts, on_delete: :cascade + add_foreign_key :reports, :accounts, column: :target_account_id, on_delete: :cascade + add_foreign_key :reports, :accounts, column: :action_taken_by_account_id, on_delete: :nullify + add_foreign_key :statuses_tags, :statuses, on_delete: :cascade + add_foreign_key :statuses_tags, :tags, on_delete: :cascade + add_foreign_key :stream_entries, :accounts, on_delete: :cascade + add_foreign_key :subscriptions, :accounts, on_delete: :cascade + add_foreign_key :users, :accounts, on_delete: :cascade + add_foreign_key :web_settings, :users, on_delete: :cascade + add_foreign_key :oauth_access_grants, :users, column: :resource_owner_id, on_delete: :cascade + add_foreign_key :oauth_access_grants, :oauth_applications, column: :application_id, on_delete: :cascade + add_foreign_key :oauth_access_tokens, :users, column: :resource_owner_id, on_delete: :cascade + add_foreign_key :oauth_access_tokens, :oauth_applications, column: :application_id, on_delete: :cascade + end +end -- cgit