Use model relations when creating objects from factories

[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..52d1904246528870444c2225f3424072344145d5 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
   def self.up
 
 class AddMapBugTables < ActiveRecord::Migration
   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|
 
     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.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.string :text

-         t.column :status, :map_bug_status_enum, :null => false
-         
+      t.column :status, :map_bug_status_enum, :null => false

     end
 
     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"
   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_table :map_bugs

-       drop_enumeration :map_bug_status_enum
+
+    drop_enumeration :map_bug_status_enum

   end
 end
   end
 end