Fix bug allowing created elements to reference deleted ones

[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 b3a1acee64ccdadc373f996b9b8e0de6f1fee75e..52d1904246528870444c2225f3424072344145d5 100644 (file)
--- a/db/migrate/053_add_map_bug_tables.rb
+++ b/db/migrate/053_add_map_bug_tables.rb
@@ -1,21 +1,22 @@
-require '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.column :status, :map_bug_status_enum, :null => false
     end
 
       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"
     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"