Replace the country table with a static XML countries file

[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..6851a20b4d4f8c5e8efaa0235c81d961694510a4 100644 (file)
--- a/db/migrate/053_add_map_bug_tables.rb
+++ b/db/migrate/053_add_map_bug_tables.rb
@@ -1,12 +1,10 @@
-require 'lib/migrate'
+require 'migrate'
 
 class AddMapBugTables < ActiveRecord::Migration
   def self.up
-
-       create_enumeration :map_bug_status_enum, ["open", "closed","hidden"]
+    create_enumeration :map_bug_status_enum, ["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.column :tile, :bigint, :null => false
@@ -14,20 +12,23 @@ class AddMapBugTables < ActiveRecord::Migration
       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