-require 'lib/migrate'
+require 'migrate'
class CreateOsmDb < ActiveRecord::Migration
def self.up
end
add_index "current_way_tags", ["id"], :name => "current_way_tags_id_idx"
- execute "CREATE FULLTEXT INDEX `current_way_tags_v_idx` ON `current_way_tags` (`v`)"
+ add_fulltext_index "current_way_tags", "v"
create_table "current_ways", myisam_table do |t|
t.column "id", :bigint_pk_64, :null => false
create_table "gps_points", myisam_table do |t|
t.column "altitude", :float
- t.column "user_id", :integer, :limit => 20
+ t.column "user_id", :integer
t.column "trackid", :integer
t.column "latitude", :integer
t.column "longitude", :integer
- t.column "gpx_id", :integer, :limit => 20
+ t.column "gpx_id", :integer
t.column "timestamp", :datetime
end
add_primary_key "way_segments", ["id", "version", "sequence_id"]
- change_column "way_segments", "sequence_id", :bigint, :limit => 11, :null => false, :options => "AUTO_INCREMENT"
+ change_column "way_segments", "sequence_id", :bigint_auto_11
create_table "way_tags", myisam_table do |t|
t.column "id", :bigint, :limit => 64, :default => 0, :null => false
add_primary_key "ways", ["id", "version"]
add_index "ways", ["id"], :name => "ways_id_version_idx"
- change_column "ways", "version", :bigint, :limit => 20, :null => false, :options => "AUTO_INCREMENT"
+ change_column "ways", "version", :bigint_auto_20
end
def self.down