X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/5310c7000c232cd48f48fe473beeca7f4ff02b53..3d79f9fd88ab2784b292c8eafc46070472b2a4c9:/db/migrate/20160822153055_create_issues_and_reports.rb?ds=inline diff --git a/db/migrate/20160822153055_create_issues_and_reports.rb b/db/migrate/20160822153055_create_issues_and_reports.rb index aa308ef68..83a9d9171 100644 --- a/db/migrate/20160822153055_create_issues_and_reports.rb +++ b/db/migrate/20160822153055_create_issues_and_reports.rb @@ -1,10 +1,12 @@ class CreateIssuesAndReports < ActiveRecord::Migration[5.0] - def change + def up + create_enum :issue_status_enum, %w[open ignored resolved] + create_table :issues do |t| t.string :reportable_type, :null => false t.integer :reportable_id, :null => false t.integer :reported_user_id - t.integer :status + t.column :status, :issue_status_enum, :null => false, :default => "open" t.column :assigned_role, :user_role_enum, :null => false t.datetime :resolved_at t.integer :resolved_by @@ -17,9 +19,11 @@ class CreateIssuesAndReports < ActiveRecord::Migration[5.0] add_foreign_key :issues, :users, :column => :resolved_by, :name => "issues_resolved_by_fkey" add_foreign_key :issues, :users, :column => :updated_by, :name => "issues_updated_by_fkey" - add_index :issues, :reported_user_id add_index :issues, [:reportable_type, :reportable_id] - add_index :issues, :updated_by + add_index :issues, [:reported_user_id] + add_index :issues, [:status] + add_index :issues, [:assigned_role] + add_index :issues, [:updated_by] create_table :reports do |t| t.integer :issue_id, :null => false @@ -32,8 +36,8 @@ class CreateIssuesAndReports < ActiveRecord::Migration[5.0] add_foreign_key :reports, :issues, :name => "reports_issue_id_fkey" add_foreign_key :reports, :users, :column => :user_id, :name => "reports_user_id_fkey" - add_index :reports, :user_id add_index :reports, :issue_id + add_index :reports, :user_id create_table :issue_comments do |t| t.integer :issue_id, :null => false @@ -45,7 +49,14 @@ class CreateIssuesAndReports < ActiveRecord::Migration[5.0] add_foreign_key :issue_comments, :issues, :name => "issue_comments_issue_id_fkey" add_foreign_key :issue_comments, :users, :column => :user_id, :name => "issue_comments_user_id_fkey" - add_index :issue_comments, :user_id add_index :issue_comments, :issue_id + add_index :issue_comments, :user_id + end + + def down + drop_table :issue_comments + drop_table :reports + drop_table :issues + drop_enumeration :issue_status_enum end end