X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/5cc0eba3f10da37a14e8f27f04c7695505b4c684..68213e381252addee172f329e3a52bc361a9499a:/db/migrate/20160822153055_create_issues_and_reports.rb diff --git a/db/migrate/20160822153055_create_issues_and_reports.rb b/db/migrate/20160822153055_create_issues_and_reports.rb index 1fce3d051..5a7020e6e 100644 --- a/db/migrate/20160822153055_create_issues_and_reports.rb +++ b/db/migrate/20160822153055_create_issues_and_reports.rb @@ -1,6 +1,4 @@ -require "migrate" - -class CreateIssuesAndReports < ActiveRecord::Migration +class CreateIssuesAndReports < ActiveRecord::Migration[5.0] def change create_table :issues do |t| t.string :reportable_type, :null => false @@ -10,14 +8,11 @@ class CreateIssuesAndReports < ActiveRecord::Migration t.string :issue_type t.datetime :resolved_at t.integer :resolved_by - t.datetime :created_at - t.datetime :updated_at t.integer :updated_by - - t.timestamps null: false + t.timestamps :null => false end - add_foreign_key :issues, :users, :column => :reported_user_id,:name => "issues_reported_user_id_fkey", on_delete: :cascade + 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] @@ -25,18 +20,14 @@ class CreateIssuesAndReports < ActiveRecord::Migration create_table :reports do |t| t.integer :issue_id t.integer :reporter_user_id - t.text :details - t.datetime :created_at - t.datetime :updated_at - - t.timestamps null: false + t.text :details, :null => false + t.timestamps :null => false end - 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_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 - end end