X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/fc9046ce6fcb3b4c4962285737767ea094b4cb00..676e624928b220fded59229738b8ae0cca744cef:/db/migrate/001_create_osm_db.rb diff --git a/db/migrate/001_create_osm_db.rb b/db/migrate/001_create_osm_db.rb index fdced3e1b..d952c0a07 100644 --- a/db/migrate/001_create_osm_db.rb +++ b/db/migrate/001_create_osm_db.rb @@ -1,4 +1,4 @@ -require 'lib/migrate' +require 'migrate' class CreateOsmDb < ActiveRecord::Migration def self.up @@ -50,7 +50,7 @@ class CreateOsmDb < ActiveRecord::Migration 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 @@ -78,11 +78,11 @@ class CreateOsmDb < ActiveRecord::Migration 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 @@ -199,7 +199,7 @@ class CreateOsmDb < ActiveRecord::Migration 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 @@ -221,7 +221,7 @@ class CreateOsmDb < ActiveRecord::Migration 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