Add pure SQL version of xid_to_int4.

[rails.git] / 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 2d3b7348bd3d62bc953a51f1dc0ba935b667f488..e8e01ec0724687e0c5ee37cc6de002c6b63b93e3 100644 (file)
--- a/db/migrate/053_add_map_bug_tables.rb
+++ b/db/migrate/053_add_map_bug_tables.rb
@@ -1,33 +1,34 @@
-require 'lib/migrate'
+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_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
-         
+      t.column :status, :map_bug_status_enum, :null => false
     end
 
-    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"
+    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"
   end
 
   def self.down
     remove_index :map_bugs, :name => "map_bugs_tile_idx"
-       remove_index :map_bugs, :name => "map_bugs_changed_idx"
-       remove_index :map_bugs, :name => "map_bugs_created_idx"
+    remove_index :map_bugs, :name => "map_bugs_changed_idx"
+    remove_index :map_bugs, :name => "map_bugs_created_idx"
+
     drop_table :map_bugs
-       drop_enumeration :map_bug_status_enum
+
+    drop_enumeration :map_bug_status_enum
   end
 end