X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/cf639202b802be9ce1a6f3f65e7d4f6292a2ad3a..b68b29b43c2e385af05d81815e347c2ab22ed269:/db/migrate/20150516073616_create_issues_and_reports.rb?ds=sidebyside diff --git a/db/migrate/20150516073616_create_issues_and_reports.rb b/db/migrate/20150516073616_create_issues_and_reports.rb index 709754dbf..1fce3d051 100644 --- a/db/migrate/20150516073616_create_issues_and_reports.rb +++ b/db/migrate/20150516073616_create_issues_and_reports.rb @@ -17,7 +17,7 @@ class CreateIssuesAndReports < ActiveRecord::Migration t.timestamps null: false end - add_foreign_key :issues, :users, :column => :reported_user_id,:name => "issues_reported_user_id_fkey" + add_foreign_key :issues, :users, :column => :reported_user_id,:name => "issues_reported_user_id_fkey", on_delete: :cascade add_index :issues, :reported_user_id add_index :issues, [:reportable_id, :reportable_type] @@ -32,8 +32,8 @@ class CreateIssuesAndReports < ActiveRecord::Migration t.timestamps null: false end - add_foreign_key :reports, :issues, :name => "reports_issue_id_fkey" - add_foreign_key :reports, :users,:column => :reporter_user_id, :name => "reports_reporter_user_id_fkey" + add_foreign_key :reports, :issues, :name => "reports_issue_id_fkey", on_delete: :cascade + add_foreign_key :reports, :users,:column => :reporter_user_id, :name => "reports_reporter_user_id_fkey", on_delete: :cascade add_index :reports, :reporter_user_id add_index :reports, :issue_id