X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/7f598ab412674ce5a78da98c54aa2fe2e4a05792..353431363d84ff6386d06fd9216907cdc8307d26:/db/migrate/053_add_map_bug_tables.rb?ds=sidebyside diff --git a/db/migrate/053_add_map_bug_tables.rb b/db/migrate/053_add_map_bug_tables.rb index b3a1acee6..682a736d0 100644 --- a/db/migrate/053_add_map_bug_tables.rb +++ b/db/migrate/053_add_map_bug_tables.rb @@ -1,21 +1,20 @@ -require 'migrate' - -class AddMapBugTables < ActiveRecord::Migration +class AddMapBugTables < ActiveRecord::Migration[4.2] def self.up - create_enumeration :map_bug_status_enum, ["open", "closed", "hidden"] + create_enum :map_bug_status_enum, %w[open closed hidden] create_table :map_bugs do |t| - t.column :id, :bigint, :null => false - t.integer :latitude, :null => false - t.integer :longitude, :null => false + t.integer :latitude, :null => false + t.integer :longitude, :null => false t.column :tile, :bigint, :null => false t.datetime :last_changed, :null => false - t.datetime :date_created, :null => false - t.string :nearby_place + t.datetime :date_created, :null => false + t.string :nearby_place t.string :text t.column :status, :map_bug_status_enum, :null => false end + change_column :map_bugs, :id, :bigint + add_index :map_bugs, [:tile, :status], :name => "map_bugs_tile_idx" add_index :map_bugs, [:last_changed], :name => "map_bugs_changed_idx" add_index :map_bugs, [:date_created], :name => "map_bugs_created_idx"