X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/5ff9f2d21c82a9ebe06be748a37de764d0861514..0bc9ede6ffd81d4aa2237d066d64cdb5e901fec4:/db/migrate/053_add_map_bug_tables.rb
diff --git a/db/migrate/053_add_map_bug_tables.rb b/db/migrate/053_add_map_bug_tables.rb
index 8d444a49f..6ad3af0eb 100644
--- a/db/migrate/053_add_map_bug_tables.rb
+++ b/db/migrate/053_add_map_bug_tables.rb
@@ -1,21 +1,20 @@
-require 'lib/migrate'
-
-class AddMapBugTables < ActiveRecord::Migration
+class AddMapBugTables < ActiveRecord::Migration[4.2]
def self.up
- create_enumeration :map_bug_status_enum, ["open", "closed", "hidden"]
+ create_enumeration :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"