Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alexandru@alex-lap:~$ cd ~/.osm/rail_port/rails/
- alexandru@alex-lap:~/.osm/rail_port/rails$ sudo su prostgres
- [sudo] password for alexandru:
- Unknown id: prostgres
- alexandru@alex-lap:~/.osm/rail_port/rails$ sudo su postgres
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb openstreetmap
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb osm_test
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ dropdb osm
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap openstreetmap
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap osm_testpostgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ createdb -E UTF8 -O openstreetmap osm
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ psql -d openstreetmap < /usr/share/postgresql/8.4/contrib/btree_gist.sql
- SET
- NOTICE: type "gbtreekey4" is not yet defined
- DETAIL: Creating a shell type definition.
- CREATE FUNCTION
- NOTICE: argument type gbtreekey4 is only a shell
- CREATE FUNCTION
- CREATE TYPE
- NOTICE: type "gbtreekey8" is not yet defined
- DETAIL: Creating a shell type definition.
- CREATE FUNCTION
- NOTICE: argument type gbtreekey8 is only a shell
- CREATE FUNCTION
- CREATE TYPE
- NOTICE: type "gbtreekey16" is not yet defined
- DETAIL: Creating a shell type definition.
- CREATE FUNCTION
- NOTICE: argument type gbtreekey16 is only a shell
- CREATE FUNCTION
- CREATE TYPE
- NOTICE: type "gbtreekey32" is not yet defined
- DETAIL: Creating a shell type definition.
- CREATE FUNCTION
- NOTICE: argument type gbtreekey32 is only a shell
- CREATE FUNCTION
- CREATE TYPE
- NOTICE: type "gbtreekey_var" is not yet defined
- DETAIL: Creating a shell type definition.
- CREATE FUNCTION
- NOTICE: argument type gbtreekey_var is only a shell
- CREATE FUNCTION
- CREATE TYPE
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE OPERATOR CLASS
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE FUNCTION
- CREATE OPERATOR CLASS
- CREATE OPERATOR CLASS
- postgres@alex-lap:/home/alexandru/.osm/rail_port/rails$ exit
- exit
- alexandru@alex-lap:~/.osm/rail_port/rails$ rake gems:install
- WARNING: 'require 'rake/rdoctask'' is deprecated. Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
- at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
- Loaded suite /usr/bin/rake
- Started
- Finished in 0.00253 seconds.
- 0 tests, 0 assertions, 0 failures, 0 errors
- alexandru@alex-lap:~/.osm/rail_port/rails$ rake db:migrate
- WARNING: 'require 'rake/rdoctask'' is deprecated. Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
- at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
- == CreateOsmDb: migrating ====================================================
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0431s
- -- add_index("current_nodes", ["id"], {:name=>"current_nodes_id_idx"})
- -> 0.0557s
- -- add_index("current_nodes", ["latitude", "longitude"], {:name=>"current_nodes_lat_lon_idx"})
- -> 0.0847s
- -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
- -> 0.0625s
- -- change_column(:current_nodes, :id, :bigint_auto_64)
- -> 0.1914s
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0447s
- -- add_index("current_segments", ["id", "visible"], {:name=>"current_segments_id_visible_idx"})
- -> 0.0557s
- -- add_index("current_segments", ["node_a"], {:name=>"current_segments_a_idx"})
- -> 0.0448s
- -- add_index("current_segments", ["node_b"], {:name=>"current_segments_b_idx"})
- -> 0.0666s
- -- change_column(:current_segments, :id, :bigint_auto_64)
- -> 0.1802s
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_way_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0039s
- -- add_index("current_way_segments", ["segment_id"], {:name=>"current_way_segments_seg_idx"})
- -> 0.0380s
- -- add_index("current_way_segments", ["id"], {:name=>"current_way_segments_id_idx"})
- -> 0.1140s
- -- myisam_table()
- -> 0.0000s
- -- create_table("current_way_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0563s
- -- add_index("current_way_tags", ["id"], {:name=>"current_way_tags_id_idx"})
- -> 0.0516s
- -- add_fulltext_index("current_way_tags", "v")
- -> 0.0489s
- -- myisam_table()
- -> 0.0000s
- -- create_table("current_ways", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_ways_id_seq" for serial column "current_ways.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_ways_pkey" for table "current_ways"
- -> 0.0585s
- -- myisam_table()
- -> 0.0001s
- -- create_table("diary_entries", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "diary_entries_id_seq" for serial column "diary_entries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "diary_entries_pkey" for table "diary_entries"
- -> 0.1010s
- -- myisam_table()
- -> 0.0001s
- -- create_table("friends", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "friends_id_seq" for serial column "friends.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "friends_pkey" for table "friends"
- -> 0.0559s
- -- add_index("friends", ["friend_user_id"], {:name=>"user_id_idx"})
- -> 0.0446s
- -- myisam_table()
- -> 0.0000s
- -- create_table("gps_points", {:options=>"", :force=>true, :id=>false})
- -> 0.0059s
- -- add_index("gps_points", ["latitude", "longitude", "user_id"], {:name=>"points_idx"})
- -> 0.0497s
- -- add_index("gps_points", ["user_id"], {:name=>"points_uid_idx"})
- -> 0.0560s
- -- add_index("gps_points", ["gpx_id"], {:name=>"points_gpxid_idx"})
- -> 0.0558s
- -- myisam_table()
- -> 0.0000s
- -- create_table("gpx_file_tags", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "gpx_file_tags_id_seq" for serial column "gpx_file_tags.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gpx_file_tags_pkey" for table "gpx_file_tags"
- -> 0.0560s
- -- add_index("gpx_file_tags", ["gpx_id"], {:name=>"gpx_file_tags_gpxid_idx"})
- -> 0.0558s
- -- myisam_table()
- -> 0.0000s
- -- create_table("gpx_files", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "gpx_files_id_seq" for serial column "gpx_files.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gpx_files_pkey" for table "gpx_files"
- -> 0.1127s
- -- add_index("gpx_files", ["timestamp"], {:name=>"gpx_files_timestamp_idx"})
- -> 0.0444s
- -- add_index("gpx_files", ["visible", "public"], {:name=>"gpx_files_visible_public_idx"})
- -> 0.0448s
- -- myisam_table()
- -> 0.0000s
- -- create_table("gpx_pending_files", {:options=>"", :force=>true, :id=>false})
- -> 0.0450s
- -- myisam_table()
- -> 0.0001s
- -- create_table("messages", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
- -> 0.1231s
- -- add_index("messages", ["from_display_name"], {:name=>"from_name_idx"})
- -> 0.0465s
- -- myisam_table()
- -> 0.0000s
- -- create_table("meta_areas", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "meta_areas_id_seq" for serial column "meta_areas.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "meta_areas_pkey" for table "meta_areas"
- -> 0.0561s
- -- myisam_table()
- -> 0.0001s
- -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0706s
- -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
- -> 0.0524s
- -- add_index("nodes", ["latitude", "longitude"], {:name=>"nodes_latlon_idx"})
- -> 0.0447s
- -- myisam_table()
- -> 0.0000s
- -- create_table("segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0561s
- -- add_index("segments", ["node_a"], {:name=>"street_segments_nodea_idx"})
- -> 0.0558s
- -- add_index("segments", ["node_b"], {:name=>"street_segments_nodeb_idx"})
- -> 0.0560s
- -- add_index("segments", ["id"], {:name=>"street_segment_uid_idx"})
- -> 0.0448s
- -- innodb_table()
- -> 0.0000s
- -- create_table("users", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
- -> 0.1012s
- -- add_index("users", ["email"], {:name=>"users_email_idx"})
- -> 0.0547s
- -- add_index("users", ["display_name"], {:name=>"users_display_name_idx"})
- -> 0.0460s
- -- myisam_table()
- -> 0.0000s
- -- create_table("way_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0061s
- -- add_primary_key("way_segments", ["id", "version", "sequence_id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_segments_pkey" for table "way_segments"
- -> 0.0495s
- -- change_column("way_segments", "sequence_id", :bigint_auto_11)
- -> 0.0449s
- -- myisam_table()
- -> 0.0000s
- -- create_table("way_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0450s
- -- add_index("way_tags", ["id", "version"], {:name=>"way_tags_id_version_idx"})
- -> 0.0518s
- -- myisam_table()
- -> 0.0000s
- -- create_table("ways", {:options=>"", :force=>true, :id=>false})
- -> 0.0056s
- -- add_primary_key("ways", ["id", "version"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ways_pkey" for table "ways"
- -> 0.0541s
- -- add_index("ways", ["id"], {:name=>"ways_id_version_idx"})
- -> 0.0446s
- -- change_column("ways", "version", :bigint_auto_20)
- -> 0.1031s
- == CreateOsmDb: migrated (3.1531s) ===========================================
- == CleanupOsmDb: migrating ===================================================
- -- change_column("current_nodes", "latitude", :double, {:null=>false})
- -> 0.1858s
- -- change_column("current_nodes", "longitude", :double, {:null=>false})
- -> 0.1683s
- -- change_column("current_nodes", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.1687s
- -- change_column("current_nodes", "visible", :boolean, {:null=>false})
- -> 0.1574s
- -- change_column("current_nodes", "timestamp", :datetime, {:null=>false})
- -> 0.1949s
- -- add_primary_key("current_nodes", ["id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_nodes_pkey" for table "current_nodes"
- -> 0.0418s
- -- remove_index("current_nodes", {:name=>"current_nodes_id_idx"})
- -> 0.0072s
- -- change_column("current_segments", "node_a", :bigint, {:limit=>64, :null=>false})
- -> 0.1729s
- -- change_column("current_segments", "node_b", :bigint, {:limit=>64, :null=>false})
- -> 0.1913s
- -- change_column("current_segments", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.1800s
- -- change_column("current_segments", "visible", :boolean, {:null=>false})
- -> 0.1464s
- -- change_column("current_segments", "timestamp", :datetime, {:null=>false})
- -> 0.1717s
- -- add_primary_key("current_segments", ["id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_segments_pkey" for table "current_segments"
- -> 0.0427s
- -- remove_index("current_segments", {:name=>"current_segments_id_visible_idx"})
- -> 0.0057s
- -- change_column("current_way_segments", "id", :bigint, {:limit=>64, :null=>false})
- -> 0.0960s
- -- change_column("current_way_segments", "segment_id", :bigint, {:limit=>64, :null=>false})
- -> 0.1129s
- -- change_column("current_way_segments", "sequence_id", :bigint, {:limit=>11, :null=>false})
- -> 0.1000s
- -- add_primary_key("current_way_segments", ["id", "sequence_id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_segments_pkey" for table "current_way_segments"
- -> 0.0439s
- -- remove_index("current_way_segments", {:name=>"current_way_segments_id_idx"})
- -> 0.0054s
- -- change_column("current_way_tags", "id", :bigint, {:limit=>64, :null=>false})
- -> 0.1639s
- -- change_column("current_ways", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.0447s
- -- change_column("current_ways", "timestamp", :datetime, {:null=>false})
- -> 0.0559s
- -- change_column("current_ways", "visible", :boolean, {:null=>false})
- -> 0.0573s
- -- change_engine("current_ways", "InnoDB")
- -> 0.0002s
- -- change_column("diary_entries", "title", :string, {:null=>false})
- -> 0.0996s
- -- change_column("diary_entries", "body", :text, {:null=>false})
- -> 0.1028s
- -- change_column("diary_entries", "created_at", :datetime, {:null=>false})
- -> 0.0788s
- -- change_column("diary_entries", "updated_at", :datetime, {:null=>false})
- -> 0.1121s
- -- add_index("friends", ["user_id"], {:name=>"friends_user_id_idx"})
- -> 0.0558s
- -- remove_index("gps_points", {:name=>"points_uid_idx"})
- -> 0.0061s
- -- remove_index("gps_points", {:name=>"points_idx"})
- -> 0.0075s
- -- remove_column("gps_points", "user_id")
- -> 0.0015s
- -- add_index("gps_points", ["latitude", "longitude"], {:name=>"points_idx"})
- -> 0.0506s
- -- change_column("gps_points", "trackid", :integer, {:null=>false})
- -> 0.1017s
- -- change_column("gps_points", "latitude", :integer, {:null=>false})
- -> 0.1122s
- -- change_column("gps_points", "longitude", :integer, {:null=>false})
- -> 0.1012s
- -- change_column("gps_points", "gpx_id", :bigint, {:limit=>64, :null=>false})
- -> 0.0898s
- -- change_column("gpx_file_tags", "tag", :string, {:null=>false})
- -> 0.0787s
- -- change_column("gpx_files", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.1706s
- -- change_column("gpx_files", "timestamp", :datetime, {:null=>false})
- -> 0.1696s
- -- change_column("gpx_files", "description", :string, {:null=>false, :default=>""})
- -> 0.1818s
- -- change_column("gpx_files", "inserted", :boolean, {:null=>false})
- -> 0.1878s
- -- drop_table("gpx_pending_files")
- -> 0.0024s
- -- remove_index("messages", {:name=>"from_name_idx"})
- -> 0.0044s
- -- remove_column("messages", "user_id")
- -> 0.0014s
- -- remove_column("messages", "from_display_name")
- -> 0.0018s
- -- change_column("messages", "title", :string, {:null=>false})
- -> 0.0983s
- -- change_column("messages", "body", :text, {:null=>false})
- -> 0.0820s
- -- change_column("messages", "sent_on", :datetime, {:null=>false})
- -> 0.0788s
- -- change_column("messages", "message_read", :boolean, {:null=>false, :default=>false})
- -> 0.0945s
- -- add_index("messages", ["to_user_id"], {:name=>"messages_to_user_id_idx"})
- -> 0.0411s
- -- drop_table("meta_areas")
- -> 0.0029s
- -- change_column("nodes", "id", :bigint, {:limit=>64, :null=>false})
- -> 0.1674s
- -- change_column("nodes", "latitude", :double, {:null=>false})
- -> 0.1340s
- -- change_column("nodes", "longitude", :double, {:null=>false})
- -> 0.1350s
- -- change_column("nodes", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.1242s
- -- change_column("nodes", "visible", :boolean, {:null=>false})
- -> 0.1236s
- -- change_column("nodes", "timestamp", :datetime, {:null=>false})
- -> 0.1148s
- -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
- -> 0.0436s
- -- change_column("segments", "id", :bigint, {:limit=>64, :null=>false})
- -> 0.1699s
- -- change_column("segments", "node_a", :bigint, {:limit=>64, :null=>false})
- -> 0.1797s
- -- change_column("segments", "node_b", :bigint, {:limit=>64, :null=>false})
- -> 0.1690s
- -- change_column("segments", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.1626s
- -- change_column("segments", "visible", :boolean, {:null=>false})
- -> 0.1432s
- -- change_column("segments", "timestamp", :datetime, {:null=>false})
- -> 0.1688s
- -- add_index("segments", ["timestamp"], {:name=>"segments_timestamp_idx"})
- -> 0.0438s
- -- remove_column("users", "preferences")
- -> 0.0018s
- -- change_column("users", "email", :string, {:null=>false})
- -> 0.1902s
- -- change_column("users", "pass_crypt", :string, {:null=>false})
- -> 0.1576s
- -- change_column("users", "creation_time", :datetime, {:null=>false})
- -> 0.1486s
- -- change_column("users", "display_name", :string, {:null=>false, :default=>""})
- -> 0.1830s
- -- change_column("users", "data_public", :boolean, {:null=>false, :default=>false})
- -> 0.1905s
- -- change_column("users", "home_lat", :double, {:default=>nil})
- -> 0.1884s
- -- change_column("users", "home_lon", :double, {:default=>nil})
- -> 0.1464s
- -- remove_index("users", {:name=>"users_email_idx"})
- -> 0.0054s
- -- add_index("users", ["email"], {:unique=>true, :name=>"users_email_idx"})
- -> 0.0538s
- -- remove_index("users", {:name=>"users_display_name_idx"})
- -> 0.0049s
- -- add_index("users", ["display_name"], {:unique=>true, :name=>"users_display_name_idx"})
- -> 0.0459s
- -- change_column("way_segments", "segment_id", :bigint, {:limit=>64, :null=>false})
- -> 0.0795s
- -- change_column("way_tags", "k", :string, {:null=>false})
- -> 0.1148s
- -- change_column("way_tags", "v", :string, {:null=>false})
- -> 0.1002s
- -- change_column("way_tags", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.1888s
- -- change_column("ways", "user_id", :bigint, {:limit=>20, :null=>false})
- -> 0.0805s
- -- change_column("ways", "timestamp", :datetime, {:null=>false})
- -> 0.0895s
- -- change_column("ways", "visible", :boolean, {:null=>false, :default=>true})
- -> 0.1036s
- -- remove_index("ways", {:name=>"ways_id_version_idx"})
- -> 0.0050s
- -- add_index("ways", ["timestamp"], {:name=>"ways_timestamp_idx"})
- -> 0.0360s
- == CleanupOsmDb: migrated (8.6391s) ==========================================
- == SqlSessionStoreSetup: migrating ===========================================
- -- innodb_option()
- -> 0.0001s
- -- create_table("sessions", {:options=>""})
- NOTICE: CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
- -> 0.1655s
- -- add_index("sessions", ["session_id"], {:unique=>true, :name=>"sessions_session_id_idx"})
- -> 0.0690s
- == SqlSessionStoreSetup: migrated (0.2350s) ==================================
- == UserEnhancements: migrating ===============================================
- -- add_column("diary_entries", "latitude", :double)
- -> 0.0017s
- -- add_column("diary_entries", "longitude", :double)
- -> 0.0014s
- -- add_column("diary_entries", "language", :string, {:limit=>3})
- -> 0.0013s
- -- innodb_table()
- -> 0.0000s
- -- create_table("user_preferences", {:options=>"", :force=>true, :id=>false})
- -> 0.0640s
- -- add_primary_key("user_preferences", ["user_id", "k"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_preferences_pkey" for table "user_preferences"
- -> 0.0446s
- -- innodb_table()
- -> 0.0000s
- -- create_table("user_tokens", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "user_tokens_id_seq" for serial column "user_tokens.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_tokens_pkey" for table "user_tokens"
- -> 0.0449s
- -- add_index("user_tokens", ["token"], {:unique=>true, :name=>"user_tokens_token_idx"})
- -> 0.0448s
- -- add_index("user_tokens", ["user_id"], {:name=>"user_tokens_user_id_idx"})
- -> 0.0336s
- -- remove_column("users", "token")
- -> 0.0016s
- -- remove_column("users", "timeout")
- -> 0.0016s
- -- remove_column("users", "within_lon")
- -> 0.0023s
- -- remove_column("users", "within_lat")
- -> 0.0017s
- -- add_column("users", "nearby", :integer, {:default=>50})
- -> 0.0026s
- -- add_column("users", "pass_salt", :string)
- -> 0.0013s
- == UserEnhancements: migrated (0.2541s) ======================================
- == TileTracepoints: migrating ================================================
- -- add_column("gps_points", "tile", :four_byte_unsigned)
- -> 0.0021s
- -- add_index("gps_points", ["tile"], {:name=>"points_tile_idx"})
- -> 0.0461s
- -- remove_index("gps_points", {:name=>"points_idx"})
- -> 0.0066s
- == TileTracepoints: migrated (0.0710s) =======================================
- == TileNodes: migrating ======================================================
- -- remove_index("current_nodes", {:name=>"current_nodes_timestamp_idx"})
- -> 0.0053s
- -- rename_table("current_nodes", "current_nodes_v5")
- -> 0.0015s
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_nodes_id_seq" for serial column "current_nodes.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_nodes_pkey1" for table "current_nodes"
- -> 0.0980s
- -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
- -> 0.0334s
- -- add_index("current_nodes", ["tile"], {:name=>"current_nodes_tile_idx"})
- -> 0.0449s
- -- change_column("current_nodes", "tile", :four_byte_unsigned)
- -> 0.1465s
- -- execute(" INSERT INTO current_nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n user_id, visible, tags, timestamp, 0\n FROM current_nodes_v5\n")
- -> 0.0025s
- -- drop_table("current_nodes_v5")
- -> 0.0056s
- -- remove_index("nodes", {:name=>"nodes_uid_idx"})
- -> 0.0063s
- -- remove_index("nodes", {:name=>"nodes_timestamp_idx"})
- -> 0.0059s
- -- rename_table("nodes", "nodes_v5")
- -> 0.0015s
- -- myisam_table()
- -> 0.0001s
- -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0404s
- -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
- -> 0.0334s
- -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
- -> 0.0336s
- -- add_index("nodes", ["tile"], {:name=>"nodes_tile_idx"})
- -> 0.0467s
- -- change_column("nodes", "tile", :four_byte_unsigned)
- -> 0.1577s
- -- execute(" INSERT INTO nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n user_id, visible, tags, timestamp, 0\n FROM nodes_v5\n")
- -> 0.0019s
- -- drop_table("nodes_v5")
- -> 0.0034s
- == TileNodes: migrated (0.8175s) =============================================
- == AddRelations: migrating ===================================================
- -- create_enumeration(:nwr_enum, ["Node", "Way", "Relation"])
- -> 0.0026s
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_relation_members", {:options=>"", :force=>true, :id=>false})
- -> 0.0056s
- -- add_primary_key("current_relation_members", ["id", "member_type", "member_id", "member_role"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
- -> 0.0498s
- -- add_index("current_relation_members", ["member_type", "member_id"], {:name=>"current_relation_members_member_idx"})
- -> 0.0335s
- -- myisam_table()
- -> 0.0001s
- -- create_table("current_relation_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0450s
- -- add_index("current_relation_tags", ["id"], {:name=>"current_relation_tags_id_idx"})
- -> 0.0445s
- -- add_fulltext_index("current_relation_tags", "v")
- -> 0.0338s
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_relations", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_relations_id_seq" for serial column "current_relations.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_relations_pkey" for table "current_relations"
- -> 0.0523s
- -- myisam_table()
- -> 0.0001s
- -- create_table("relation_members", {:options=>"", :force=>true, :id=>false})
- -> 0.0063s
- -- add_primary_key("relation_members", ["id", "version", "member_type", "member_id", "member_role"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
- -> 0.0313s
- -- add_index("relation_members", ["member_type", "member_id"], {:name=>"relation_members_member_idx"})
- -> 0.0445s
- -- myisam_table()
- -> 0.0000s
- -- create_table("relation_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0450s
- -- add_index("relation_tags", ["id", "version"], {:name=>"relation_tags_id_version_idx"})
- -> 0.0446s
- -- myisam_table()
- -> 0.0001s
- -- create_table("relations", {:options=>"", :force=>true, :id=>false})
- -> 0.0061s
- -- add_primary_key("relations", ["id", "version"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relations_pkey" for table "relations"
- -> 0.0545s
- -- add_index("relations", ["timestamp"], {:name=>"relations_timestamp_idx"})
- -> 0.0399s
- -- change_column("relations", "version", :bigint_auto_20)
- -> 0.0808s
- == AddRelations: migrated (0.6241s) ==========================================
- == RemoveSegments: migrating =================================================
- -- select_value("SELECT count(*) FROM current_segments")
- -> 0.0027s
- -- drop_table(:segments)
- -> 0.0050s
- -- drop_table(:way_segments)
- -> 0.0031s
- -- myisam_table()
- -> 0.0000s
- -- create_table(:way_nodes, {:options=>"", :force=>true, :id=>false})
- -> 0.0051s
- -- add_primary_key(:way_nodes, [:id, :version, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_nodes_pkey" for table "way_nodes"
- -> 0.0575s
- -- drop_table(:current_segments)
- -> 0.0044s
- -- drop_table(:current_way_segments)
- -> 0.0026s
- -- innodb_table()
- -> 0.0000s
- -- create_table(:current_way_nodes, {:options=>"", :force=>true, :id=>false})
- -> 0.0044s
- -- add_primary_key(:current_way_nodes, [:id, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_nodes_pkey" for table "current_way_nodes"
- -> 0.0433s
- -- add_index(:current_way_nodes, [:node_id], {:name=>"current_way_nodes_node_idx"})
- -> 0.0337s
- -- execute("TRUNCATE way_tags")
- -> 0.0680s
- -- execute("TRUNCATE ways")
- -> 0.0896s
- -- execute("TRUNCATE current_way_tags")
- -> 0.1015s
- -- execute("TRUNCATE current_ways")
- -> 0.0338s
- == RemoveSegments: migrated (0.4572s) ========================================
- == WayNodesNodeIdx: migrating ================================================
- -- add_index("way_nodes", ["node_id"], {:name=>"way_nodes_node_idx"})
- -> 0.0809s
- == WayNodesNodeIdx: migrated (0.0811s) =======================================
- == DiaryComments: migrating ==================================================
- -- myisam_table()
- -> 0.0001s
- -- create_table("diary_comments", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "diary_comments_id_seq" for serial column "diary_comments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "diary_comments_pkey" for table "diary_comments"
- -> 0.1065s
- -- add_index("diary_comments", ["diary_entry_id", "id"], {:unique=>true, :name=>"diary_comments_entry_id_idx"})
- -> 0.0334s
- == DiaryComments: migrated (0.1406s) =========================================
- == AddUserImage: migrating ===================================================
- -- add_column("users", "image", :text)
- -> 0.0020s
- == AddUserImage: migrated (0.0022s) ==========================================
- == AddAdminFlag: migrating ===================================================
- -- add_column("users", "administrator", :boolean, {:null=>false, :default=>false})
- -> 0.0057s
- == AddAdminFlag: migrated (0.0059s) ==========================================
- == AddEmailValid: migrating ==================================================
- -- add_column("users", "email_valid", :boolean, {:null=>false, :default=>false})
- -> 0.0060s
- == AddEmailValid: migrated (0.0088s) =========================================
- == AddNewEmail: migrating ====================================================
- -- add_column("users", "new_email", :string)
- -> 0.0021s
- == AddNewEmail: migrated (0.0023s) ===========================================
- == AddUserVisible: migrating =================================================
- -- add_column("users", "visible", :boolean, {:null=>false, :default=>true})
- -> 0.0057s
- == AddUserVisible: migrated (0.0074s) ========================================
- == AddCreationIp: migrating ==================================================
- -- add_column("users", "creation_ip", :string)
- -> 0.0019s
- == AddCreationIp: migrated (0.0021s) =========================================
- == AddGpxIndexes: migrating ==================================================
- -- add_index("gpx_files", ["user_id"], {:name=>"gpx_files_user_id_idx"})
- -> 0.0394s
- -- add_index("gpx_file_tags", ["tag"], {:name=>"gpx_file_tags_tag_idx"})
- -> 0.0337s
- == AddGpxIndexes: migrated (0.0735s) =========================================
- == CreateAcls: migrating =====================================================
- -- myisam_table()
- -> 0.0001s
- -- create_table("acls", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "acls_id_seq" for serial column "acls.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "acls_pkey" for table "acls"
- -> 0.1034s
- -- add_index("acls", ["k"], {:name=>"acls_k_idx"})
- -> 0.0337s
- == CreateAcls: migrated (0.1378s) ============================================
- == AddTimestampIndexes: migrating ============================================
- -- add_index(:current_ways, :timestamp, {:name=>:current_ways_timestamp_idx})
- -> 0.0413s
- -- add_index(:current_relations, :timestamp, {:name=>:current_relations_timestamp_idx})
- -> 0.0447s
- == AddTimestampIndexes: migrated (0.0864s) ===================================
- == PopulateNodeTagsAndRemove: migrating ======================================
- -- select_value("SELECT count(*) FROM current_nodes")
- -> 0.0017s
- -- execute("TRUNCATE nodes")
- -> 0.1383s
- -- remove_column(:nodes, :tags)
- -> 0.0017s
- -- remove_column(:current_nodes, :tags)
- -> 0.0015s
- -- add_column(:nodes, :version, :bigint, {:limit=>20, :null=>false})
- -> 0.0023s
- -- innodb_table()
- -> 0.0000s
- -- create_table(:current_node_tags, {:options=>"", :force=>true, :id=>false})
- -> 0.0389s
- -- innodb_table()
- -> 0.0001s
- -- create_table(:node_tags, {:options=>"", :force=>true, :id=>false})
- -> 0.0448s
- == PopulateNodeTagsAndRemove: migrated (0.2308s) =============================
- == MoveToInnodb: migrating ===================================================
- -- remove_index(:current_way_tags, {:name=>:current_way_tags_v_idx})
- -> 0.0065s
- -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_v_idx})
- -> 0.0061s
- -- change_column("nodes", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.1109s
- -- change_column("ways", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.0790s
- -- change_column("relations", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.0807s
- -- change_engine("nodes", "InnoDB")
- -> 0.0002s
- -- change_engine("ways", "InnoDB")
- -> 0.0001s
- -- change_engine("way_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("way_nodes", "InnoDB")
- -> 0.0001s
- -- change_engine("current_way_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("relation_members", "InnoDB")
- -> 0.0001s
- -- change_engine("relations", "InnoDB")
- -> 0.0001s
- -- change_engine("relation_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("current_relation_tags", "InnoDB")
- -> 0.0003s
- -- add_column("current_nodes", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.0022s
- -- add_column("current_ways", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.0169s
- -- add_column("current_relations", "version", :bigint, {:limit=>20, :null=>false})
- -> 0.0087s
- == MoveToInnodb: migrated (0.4061s) ==========================================
- == KeyConstraints: migrating =================================================
- -- add_primary_key(:current_node_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_node_tags_pkey" for table "current_node_tags"
- -> 0.0665s
- -- add_primary_key(:current_way_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_tags_pkey" for table "current_way_tags"
- -> 0.0685s
- -- add_primary_key(:current_relation_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_tags_pkey" for table "current_relation_tags"
- -> 0.0448s
- -- add_primary_key(:node_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "node_tags_pkey" for table "node_tags"
- -> 0.0561s
- -- add_primary_key(:way_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_tags_pkey" for table "way_tags"
- -> 0.0337s
- -- add_primary_key(:relation_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_tags_pkey" for table "relation_tags"
- -> 0.0339s
- -- add_primary_key(:nodes, [:id, :version])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
- -> 0.0561s
- -- remove_index(:current_way_tags, {:name=>:current_way_tags_id_idx})
- -> 0.0048s
- -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_id_idx})
- -> 0.0044s
- -- remove_index(:way_tags, {:name=>:way_tags_id_version_idx})
- -> 0.0071s
- -- remove_index(:relation_tags, {:name=>:relation_tags_id_version_idx})
- -> 0.0067s
- -- remove_index(:nodes, {:name=>:nodes_uid_idx})
- -> 0.0119s
- -- add_foreign_key(:current_node_tags, [:id], :current_nodes)
- -> 0.0055s
- -- add_foreign_key(:node_tags, [:id, :version], :nodes)
- -> 0.0042s
- -- add_foreign_key(:current_way_tags, [:id], :current_ways)
- -> 0.0037s
- -- add_foreign_key(:current_way_nodes, [:id], :current_ways)
- -> 0.0036s
- -- add_foreign_key(:way_tags, [:id, :version], :ways)
- -> 0.0044s
- -- add_foreign_key(:way_nodes, [:id, :version], :ways)
- -> 0.0040s
- -- add_foreign_key(:current_relation_tags, [:id], :current_relations)
- -> 0.0037s
- -- add_foreign_key(:current_relation_members, [:id], :current_relations)
- -> 0.0040s
- -- add_foreign_key(:relation_tags, [:id, :version], :relations)
- -> 0.0053s
- -- add_foreign_key(:relation_members, [:id, :version], :relations)
- -> 0.0070s
- -- add_foreign_key(:current_way_nodes, [:node_id], :current_nodes, [:id])
- -> 0.0043s
- == KeyConstraints: migrated (0.4482s) ========================================
- == AddChangesets: migrating ==================================================
- -- innodb_table()
- -> 0.0001s
- -- create_table("changesets", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "changesets_id_seq" for serial column "changesets.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "changesets_pkey" for table "changesets"
- -> 0.0568s
- -- innodb_table()
- -> 0.0001s
- -- create_table("changeset_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0449s
- -- add_index("changeset_tags", ["id"], {:name=>"changeset_tags_id_idx"})
- -> 0.0333s
- -- execute("INSERT INTO changesets (id, user_id, created_at, open)SELECT id, id, creation_time, false from users;")
- -> 0.0013s
- -- rename_column("current_nodes", :user_id, :changeset_id)
- -> 0.0017s
- -- add_foreign_key("current_nodes", [:changeset_id], :changesets, [:id])
- -> 0.0041s
- -- rename_column("current_relations", :user_id, :changeset_id)
- -> 0.0013s
- -- add_foreign_key("current_relations", [:changeset_id], :changesets, [:id])
- -> 0.0035s
- -- rename_column("current_ways", :user_id, :changeset_id)
- -> 0.0017s
- -- add_foreign_key("current_ways", [:changeset_id], :changesets, [:id])
- -> 0.0044s
- -- rename_column("nodes", :user_id, :changeset_id)
- -> 0.0015s
- -- add_foreign_key("nodes", [:changeset_id], :changesets, [:id])
- -> 0.0039s
- -- rename_column("relations", :user_id, :changeset_id)
- -> 0.0016s
- -- add_foreign_key("relations", [:changeset_id], :changesets, [:id])
- -> 0.0041s
- -- rename_column("ways", :user_id, :changeset_id)
- -> 0.0014s
- -- add_foreign_key("ways", [:changeset_id], :changesets, [:id])
- -> 0.0041s
- == AddChangesets: migrated (0.1726s) =========================================
- == OrderRelationMembers: migrating ===========================================
- -- add_column(:relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
- -> 0.0060s
- -- execute("update relation_members set sequence_id = mod(member_id, 16384)")
- -> 0.0011s
- -- alter_primary_key("relation_members", [:id, :version, :member_type, :member_id, :member_role, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
- -> 0.0563s
- -- add_column(:current_relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
- -> 0.0102s
- -- execute("update current_relation_members set sequence_id = mod(member_id, 16384)")
- -> 0.0009s
- -- alter_primary_key("current_relation_members", [:id, :member_type, :member_id, :member_role, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
- -> 0.0667s
- == OrderRelationMembers: migrated (0.1422s) ==================================
- == AddEndTimeToChangesets: migrating =========================================
- -- add_column(:changesets, :closed_at, :datetime, {:null=>false})
- -> 0.0037s
- -- interval_constant("1 hour")
- -> 0.0002s
- -- execute("update changesets set closed_at=(now()-'1 hour'::interval) where open=(1=0)")
- -> 0.0022s
- -- interval_constant("1 hour")
- -> 0.0007s
- -- execute("update changesets set closed_at=(now()+'1 hour'::interval) where open=(1=1)")
- -> 0.0010s
- -- remove_column(:changesets, :open)
- -> 0.0020s
- -- add_column(:changesets, :num_changes, :integer, {:null=>false, :default=>0})
- -> 0.0057s
- == AddEndTimeToChangesets: migrated (0.0167s) ================================
- == AddChangesetUserIndex: migrating ==========================================
- -- add_index("changesets", ["user_id"], {:name=>"changesets_user_id_idx"})
- -> 0.0597s
- == AddChangesetUserIndex: migrated (0.0599s) =================================
- == AddChangesetIndexes: migrating ============================================
- -- add_index("nodes", ["changeset_id"], {:name=>"nodes_changeset_id_idx"})
- -> 0.0596s
- -- add_index("ways", ["changeset_id"], {:name=>"ways_changeset_id_idx"})
- -> 0.0449s
- -- add_index("relations", ["changeset_id"], {:name=>"relations_changeset_id_idx"})
- -> 0.0448s
- == AddChangesetIndexes: migrated (0.1498s) ===================================
- == AddMoreChangesetIndexes: migrating ========================================
- -- add_index("changesets", ["created_at"], {:name=>"changesets_created_at_idx"})
- -> 0.0463s
- -- add_index("changesets", ["closed_at"], {:name=>"changesets_closed_at_idx"})
- -> 0.0449s
- -- add_index("changesets", ["min_lat", "max_lat", "min_lon", "max_lon"], {:method=>"GIST", :name=>"changesets_bbox_idx"})
- -> 0.0038s
- == AddMoreChangesetIndexes: migrated (0.0956s) ===============================
- == AddUserForeignKeys: migrating =============================================
- -- add_foreign_key(:changesets, [:user_id], :users, [:id])
- -> 0.0045s
- -- add_foreign_key(:diary_comments, [:user_id], :users, [:id])
- -> 0.0040s
- -- add_foreign_key(:diary_entries, [:user_id], :users, [:id])
- -> 0.0042s
- -- add_foreign_key(:friends, [:user_id], :users, [:id])
- -> 0.0052s
- -- add_foreign_key(:friends, [:friend_user_id], :users, [:id])
- -> 0.0060s
- -- add_foreign_key(:gpx_files, [:user_id], :users, [:id])
- -> 0.0053s
- -- add_foreign_key(:messages, [:from_user_id], :users, [:id])
- -> 0.0048s
- -- add_foreign_key(:messages, [:to_user_id], :users, [:id])
- -> 0.0041s
- -- add_foreign_key(:user_preferences, [:user_id], :users, [:id])
- -> 0.0042s
- -- add_foreign_key(:user_tokens, [:user_id], :users, [:id])
- -> 0.0049s
- == AddUserForeignKeys: migrated (0.0489s) ====================================
- == AddForeignKeys: migrating =================================================
- -- add_foreign_key(:changeset_tags, [:id], :changesets)
- -> 0.0045s
- -- add_foreign_key(:diary_comments, [:diary_entry_id], :diary_entries, [:id])
- -> 0.0040s
- -- add_foreign_key(:gps_points, [:gpx_id], :gpx_files, [:id])
- -> 0.0047s
- -- add_foreign_key(:gpx_file_tags, [:gpx_id], :gpx_files, [:id])
- -> 0.0040s
- == AddForeignKeys: migrated (0.0179s) ========================================
- == CreateCountries: migrating ================================================
- -- innodb_table()
- -> 0.0001s
- -- create_table(:countries, {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "countries_id_seq" for serial column "countries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "countries_pkey" for table "countries"
- -> 0.0434s
- -- add_index(:countries, [:code], {:unique=>true, :name=>"countries_code_idx"})
- -> 0.0348s
- == CreateCountries: migrated (9.7120s) =======================================
- == AddUserLocale: migrating ==================================================
- -- add_column("users", "locale", :string)
- -> 0.0024s
- == AddUserLocale: migrated (0.0026s) =========================================
- == ChangeDiaryEntriesLanguage: migrating =====================================
- -- remove_column("diary_entries", "language")
- -> 0.0018s
- -- add_column("diary_entries", "language_code", :string, {:null=>false, :default=>"en"})
- -> 0.0056s
- == ChangeDiaryEntriesLanguage: migrated (0.0078s) ============================
- == CreateLanguages: migrating ================================================
- -- innodb_table()
- -> 0.0001s
- -- create_table(:languages, {:options=>"", :force=>true, :id=>false})
- -> 0.0499s
- -- add_primary_key(:languages, [:code])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "languages_pkey" for table "languages"
- -> 0.0445s
- -- add_foreign_key(:users, [:locale], :languages, [:code])
- -> 0.0041s
- -- add_foreign_key(:diary_entries, [:language_code], :languages, [:code])
- -> 0.0033s
- == CreateLanguages: migrated (1.2910s) =======================================
- == ChangeUserLocale: migrating ===============================================
- -- remove_foreign_key(:users, [:locale], :languages, [:code])
- -> 0.0029s
- -- rename_column(:users, :locale, :languages)
- -> 0.0014s
- == ChangeUserLocale: migrated (0.0046s) ======================================
- == AddVisibleToMessage: migrating ============================================
- -- add_column(:messages, :visible, :boolean, {:null=>false, :default=>true})
- -> 0.0060s
- == AddVisibleToMessage: migrated (0.0062s) ===================================
- == AddSenderVisibleToMessage: migrating ======================================
- -- rename_column(:messages, :visible, :to_user_visible)
- -> 0.0015s
- -- add_column(:messages, :from_user_visible, :boolean, {:null=>false, :default=>true})
- -> 0.0054s
- == AddSenderVisibleToMessage: migrated (0.0073s) =============================
- == AddMessageSenderIndex: migrating ==========================================
- -- add_index(:messages, [:from_user_id], {:name=>"messages_from_user_id_idx"})
- -> 0.0491s
- == AddMessageSenderIndex: migrated (0.0493s) =================================
- == AddMoreControlsToGpxFiles: migrating ======================================
- -- create_enumeration(:gpx_visibility_enum, ["private", "public", "trackable", "identifiable"])
- -> 0.0018s
- -- add_column(:gpx_files, :visibility, :gpx_visibility_enum, {:null=>false, :default=>"public"})
- -> 0.0056s
- -- add_index(:gpx_files, [:visible, :visibility], {:name=>"gpx_files_visible_visibility_idx"})
- -> 0.0508s
- -- remove_index(:gpx_files, {:name=>"gpx_files_visible_public_idx"})
- -> 0.0075s
- -- remove_column(:gpx_files, :public)
- -> 0.0022s
- == AddMoreControlsToGpxFiles: migrated (0.0887s) =============================
- == CreateOauthTables: migrating ==============================================
- -- create_table(:client_applications)
- NOTICE: CREATE TABLE will create implicit sequence "client_applications_id_seq" for serial column "client_applications.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "client_applications_pkey" for table "client_applications"
- -> 0.1168s
- -- add_index(:client_applications, :key, {:unique=>true})
- -> 0.0447s
- -- create_table(:oauth_tokens)
- NOTICE: CREATE TABLE will create implicit sequence "oauth_tokens_id_seq" for serial column "oauth_tokens.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "oauth_tokens_pkey" for table "oauth_tokens"
- -> 0.0563s
- -- add_index(:oauth_tokens, :token, {:unique=>true})
- -> 0.0466s
- -- create_table(:oauth_nonces)
- NOTICE: CREATE TABLE will create implicit sequence "oauth_nonces_id_seq" for serial column "oauth_nonces.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "oauth_nonces_pkey" for table "oauth_nonces"
- -> 0.0675s
- -- add_index(:oauth_nonces, [:nonce, :timestamp], {:unique=>true})
- -> 0.0559s
- == CreateOauthTables: migrated (0.3887s) =====================================
- == AddFineOAuthPermissions: migrating ========================================
- -- add_column(:oauth_tokens, :allow_read_prefs, :boolean, {:null=>false, :default=>false})
- -> 0.0061s
- -- add_column(:client_applications, :allow_read_prefs, :boolean, {:null=>false, :default=>false})
- -> 0.0050s
- -- add_column(:oauth_tokens, :allow_write_prefs, :boolean, {:null=>false, :default=>false})
- -> 0.0226s
- -- add_column(:client_applications, :allow_write_prefs, :boolean, {:null=>false, :default=>false})
- -> 0.0051s
- -- add_column(:oauth_tokens, :allow_write_diary, :boolean, {:null=>false, :default=>false})
- -> 0.0050s
- -- add_column(:client_applications, :allow_write_diary, :boolean, {:null=>false, :default=>false})
- -> 0.0054s
- -- add_column(:oauth_tokens, :allow_write_api, :boolean, {:null=>false, :default=>false})
- -> 0.0050s
- -- add_column(:client_applications, :allow_write_api, :boolean, {:null=>false, :default=>false})
- -> 0.0052s
- -- add_column(:oauth_tokens, :allow_read_gpx, :boolean, {:null=>false, :default=>false})
- -> 0.0053s
- -- add_column(:client_applications, :allow_read_gpx, :boolean, {:null=>false, :default=>false})
- -> 0.0054s
- -- add_column(:oauth_tokens, :allow_write_gpx, :boolean, {:null=>false, :default=>false})
- -> 0.0052s
- -- add_column(:client_applications, :allow_write_gpx, :boolean, {:null=>false, :default=>false})
- -> 0.0051s
- == AddFineOAuthPermissions: migrated (0.1915s) ===============================
- == AddForeignKeysToOauthTables: migrating ====================================
- -- add_foreign_key(:oauth_tokens, [:user_id], :users, [:id])
- -> 0.0056s
- -- add_foreign_key(:oauth_tokens, [:client_application_id], :client_applications, [:id])
- -> 0.0043s
- -- add_foreign_key(:client_applications, [:user_id], :users, [:id])
- -> 0.0041s
- == AddForeignKeysToOauthTables: migrated (0.0145s) ===========================
- == AddRefererToUserToken: migrating ==========================================
- -- add_column(:user_tokens, :referer, :text)
- -> 0.0621s
- == AddRefererToUserToken: migrated (0.0623s) =================================
- == CreateUserRoles: migrating ================================================
- -- create_enumeration(:user_role_enum, ["administrator", "moderator"])
- -> 0.0016s
- -- create_table(:user_roles)
- NOTICE: CREATE TABLE will create implicit sequence "user_roles_id_seq" for serial column "user_roles.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_roles_pkey" for table "user_roles"
- -> 0.0450s
- -- add_column(:user_roles, :role, :user_role_enum, {:null=>false})
- -> 0.0028s
- -- remove_column(:users, :administrator)
- -> 0.0021s
- -- add_foreign_key(:user_roles, [:user_id], :users, [:id])
- -> 0.0043s
- == CreateUserRoles: migrated (0.0592s) =======================================
- == CreateUserBlocks: migrating ===============================================
- -- create_table(:user_blocks)
- NOTICE: CREATE TABLE will create implicit sequence "user_blocks_id_seq" for serial column "user_blocks.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_blocks_pkey" for table "user_blocks"
- -> 0.1059s
- -- add_foreign_key(:user_blocks, [:user_id], :users, [:id])
- -> 0.0045s
- -- add_foreign_key(:user_blocks, [:moderator_id], :users, [:id])
- -> 0.0043s
- -- add_foreign_key(:user_blocks, [:revoker_id], :users, [:id])
- -> 0.0045s
- -- add_index(:user_blocks, [:user_id])
- -> 0.0421s
- == CreateUserBlocks: migrated (0.1622s) ======================================
- == AlterUserRolesAndBlocks: migrating ========================================
- -- add_column(:user_roles, :granter_id, :bigint)
- -> 0.0018s
- -- change_column(:user_roles, :granter_id, :bigint, {:null=>false})
- -> 0.0533s
- -- add_foreign_key(:user_roles, [:granter_id], :users, [:id])
- -> 0.0042s
- -- add_index(:user_roles, [:user_id, :role], {:unique=>true, :name=>"user_roles_id_role_unique"})
- -> 0.0554s
- -- rename_column(:user_blocks, :moderator_id, :creator_id)
- -> 0.0015s
- -- rename_column(:user_blocks, :end_at, :ends_at)
- -> 0.0013s
- == AlterUserRolesAndBlocks: migrated (0.1260s) ===============================
- == AddVisibleToDiaries: migrating ============================================
- -- add_column(:diary_entries, :visible, :boolean, {:null=>false, :default=>true})
- -> 0.0060s
- -- add_column(:diary_comments, :visible, :boolean, {:null=>false, :default=>true})
- -> 0.0054s
- == AddVisibleToDiaries: migrated (0.0117s) ===================================
- == AddDiaryCreationIndexes: migrating ========================================
- -- add_index(:diary_entries, [:created_at], {:name=>"diary_entry_created_at_index"})
- -> 0.0464s
- -- add_index(:diary_entries, [:user_id, :created_at], {:name=>"diary_entry_user_id_created_at_index"})
- -> 0.0448s
- -- add_index(:diary_entries, [:language_code, :created_at], {:name=>"diary_entry_language_code_created_at_index"})
- -> 0.0450s
- == AddDiaryCreationIndexes: migrated (0.1367s) ===============================
- == ImproveChangesetUserIndex: migrating ======================================
- -- add_index(:changesets, [:user_id, :id], {:name=>"changesets_user_id_id_idx"})
- -> 0.0478s
- -- remove_index(:changesets, {:name=>"changesets_user_id_idx"})
- -> 0.0082s
- == ImproveChangesetUserIndex: migrated (0.0563s) =============================
- == AddUserIndexToDiaryComments: migrating ====================================
- -- add_index(:diary_comments, [:user_id, :created_at], {:name=>"diary_comment_user_id_created_at_index"})
- -> 0.0479s
- == AddUserIndexToDiaryComments: migrated (0.0481s) ===========================
- == AddStatusToUser: migrating ================================================
- -- create_enumeration(:user_status_enum, ["pending", "active", "confirmed", "suspended", "deleted"])
- -> 0.0020s
- -- add_column(:users, :status, :user_status_enum, {:null=>false, :default=>"pending"})
- -> 0.0059s
- -- remove_column(:users, :active)
- -> 0.0041s
- -- remove_column(:users, :visible)
- -> 0.0023s
- == AddStatusToUser: migrated (0.0197s) =======================================
- == AddContributorTermsToUser: migrating ======================================
- -- add_column(:users, :terms_agreed, :datetime)
- -> 0.0047s
- -- add_column(:users, :consider_pd, :boolean, {:null=>false, :default=>false})
- -> 0.0069s
- == AddContributorTermsToUser: migrated (0.0120s) =============================
- == AddUserDateIndexToChangeset: migrating ====================================
- -- add_index(:changesets, [:user_id, :created_at], {:name=>"changesets_user_id_created_at_idx"})
- -> 0.0485s
- == AddUserDateIndexToChangeset: migrated (0.0487s) ===========================
- == AddOpenId: migrating ======================================================
- -- add_column(:users, :openid_url, :string)
- -> 0.0020s
- -- add_index(:users, [:openid_url], {:unique=>true, :name=>"user_openid_url_idx"})
- -> 0.0482s
- == AddOpenId: migrated (0.0506s) =============================================
- == AddCallbackToOauthTokens: migrating =======================================
- -- add_column(:oauth_tokens, :callback_url, :string)
- -> 0.0022s
- -- add_column(:oauth_tokens, :verifier, :string, {:limit=>20})
- -> 0.0015s
- == AddCallbackToOauthTokens: migrated (0.0041s) ==============================
- == AddEditorPreferenceToUser: migrating ======================================
- -- add_column(:users, :preferred_editor, :string)
- -> 0.0021s
- == AddEditorPreferenceToUser: migrated (0.0023s) =============================
- == AddTermsSeenToUser: migrating =============================================
- -- add_column(:users, :terms_seen, :boolean, {:null=>false, :default=>false})
- -> 0.0059s
- == AddTermsSeenToUser: migrated (0.0074s) ====================================
- Loaded suite /usr/bin/rake
- Started
- Finished in 0.000269 seconds.
- 0 tests, 0 assertions, 0 failures, 0 errors
- alexandru@alex-lap:~/.osm/rail_port/rails$ echo here we go....
- here we go....
- alexandru@alex-lap:~/.osm/rail_port/rails$ env RAILS_ENV=production rake db:migrate
- WARNING: 'require 'rake/rdoctask'' is deprecated. Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
- at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
- == CreateOsmDb: migrating ====================================================
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0386s
- -- add_index("current_nodes", ["id"], {:name=>"current_nodes_id_idx"})
- -> 0.0616s
- -- add_index("current_nodes", ["latitude", "longitude"], {:name=>"current_nodes_lat_lon_idx"})
- -> 0.0609s
- -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
- -> 0.0560s
- -- change_column(:current_nodes, :id, :bigint_auto_64)
- -> 0.1911s
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0468s
- -- add_index("current_segments", ["id", "visible"], {:name=>"current_segments_id_visible_idx"})
- -> 0.0556s
- -- add_index("current_segments", ["node_a"], {:name=>"current_segments_a_idx"})
- -> 0.0669s
- -- add_index("current_segments", ["node_b"], {:name=>"current_segments_b_idx"})
- -> 0.0561s
- -- change_column(:current_segments, :id, :bigint_auto_64)
- -> 0.1772s
- -- innodb_table()
- -> 0.0000s
- -- create_table("current_way_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0037s
- -- add_index("current_way_segments", ["segment_id"], {:name=>"current_way_segments_seg_idx"})
- -> 0.0323s
- -- add_index("current_way_segments", ["id"], {:name=>"current_way_segments_id_idx"})
- -> 0.0559s
- -- myisam_table()
- -> 0.0001s
- -- create_table("current_way_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0560s
- -- add_index("current_way_tags", ["id"], {:name=>"current_way_tags_id_idx"})
- -> 0.0556s
- -- add_fulltext_index("current_way_tags", "v")
- -> 0.0561s
- -- myisam_table()
- -> 0.0001s
- -- create_table("current_ways", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_ways_id_seq" for serial column "current_ways.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_ways_pkey" for table "current_ways"
- -> 0.0674s
- -- myisam_table()
- -> 0.0001s
- -- create_table("diary_entries", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "diary_entries_id_seq" for serial column "diary_entries.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "diary_entries_pkey" for table "diary_entries"
- -> 0.1276s
- -- myisam_table()
- -> 0.0001s
- -- create_table("friends", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "friends_id_seq" for serial column "friends.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "friends_pkey" for table "friends"
- -> 0.0515s
- -- add_index("friends", ["friend_user_id"], {:name=>"user_id_idx"})
- -> 0.0668s
- -- myisam_table()
- -> 0.0001s
- -- create_table("gps_points", {:options=>"", :force=>true, :id=>false})
- -> 0.0053s
- -- add_index("gps_points", ["latitude", "longitude", "user_id"], {:name=>"points_idx"})
- -> 0.0525s
- -- add_index("gps_points", ["user_id"], {:name=>"points_uid_idx"})
- -> 0.0676s
- -- add_index("gps_points", ["gpx_id"], {:name=>"points_gpxid_idx"})
- -> 0.0551s
- -- myisam_table()
- -> 0.0001s
- -- create_table("gpx_file_tags", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "gpx_file_tags_id_seq" for serial column "gpx_file_tags.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gpx_file_tags_pkey" for table "gpx_file_tags"
- -> 0.0561s
- -- add_index("gpx_file_tags", ["gpx_id"], {:name=>"gpx_file_tags_gpxid_idx"})
- -> 0.0668s
- -- myisam_table()
- -> 0.0001s
- -- create_table("gpx_files", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "gpx_files_id_seq" for serial column "gpx_files.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gpx_files_pkey" for table "gpx_files"
- -> 0.1456s
- -- add_index("gpx_files", ["timestamp"], {:name=>"gpx_files_timestamp_idx"})
- -> 0.0446s
- -- add_index("gpx_files", ["visible", "public"], {:name=>"gpx_files_visible_public_idx"})
- -> 0.0448s
- -- myisam_table()
- -> 0.0001s
- -- create_table("gpx_pending_files", {:options=>"", :force=>true, :id=>false})
- -> 0.0449s
- -- myisam_table()
- -> 0.0001s
- -- create_table("messages", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
- -> 0.1119s
- -- add_index("messages", ["from_display_name"], {:name=>"from_name_idx"})
- -> 0.0445s
- -- myisam_table()
- -> 0.0001s
- -- create_table("meta_areas", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "meta_areas_id_seq" for serial column "meta_areas.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "meta_areas_pkey" for table "meta_areas"
- -> 0.0564s
- -- myisam_table()
- -> 0.0001s
- -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0672s
- -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
- -> 0.0334s
- -- add_index("nodes", ["latitude", "longitude"], {:name=>"nodes_latlon_idx"})
- -> 0.0559s
- -- myisam_table()
- -> 0.0001s
- -- create_table("segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0559s
- -- add_index("segments", ["node_a"], {:name=>"street_segments_nodea_idx"})
- -> 0.0723s
- -- add_index("segments", ["node_b"], {:name=>"street_segments_nodeb_idx"})
- -> 0.0412s
- -- add_index("segments", ["id"], {:name=>"street_segment_uid_idx"})
- -> 0.0559s
- -- innodb_table()
- -> 0.0001s
- -- create_table("users", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
- -> 0.1124s
- -- add_index("users", ["email"], {:name=>"users_email_idx"})
- -> 0.0556s
- -- add_index("users", ["display_name"], {:name=>"users_display_name_idx"})
- -> 0.0449s
- -- myisam_table()
- -> 0.0001s
- -- create_table("way_segments", {:options=>"", :force=>true, :id=>false})
- -> 0.0055s
- -- add_primary_key("way_segments", ["id", "version", "sequence_id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_segments_pkey" for table "way_segments"
- -> 0.0612s
- -- change_column("way_segments", "sequence_id", :bigint_auto_11)
- -> 0.0779s
- -- myisam_table()
- -> 0.0000s
- -- create_table("way_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0568s
- -- add_index("way_tags", ["id", "version"], {:name=>"way_tags_id_version_idx"})
- -> 0.0441s
- -- myisam_table()
- -> 0.0001s
- -- create_table("ways", {:options=>"", :force=>true, :id=>false})
- -> 0.0054s
- -- add_primary_key("ways", ["id", "version"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ways_pkey" for table "ways"
- -> 0.0502s
- -- add_index("ways", ["id"], {:name=>"ways_id_version_idx"})
- -> 0.0448s
- -- change_column("ways", "version", :bigint_auto_20)
- -> 0.1010s
- == CreateOsmDb: migrated (3.2350s) ===========================================
- == CleanupOsmDb: migrating ===================================================
- -- change_column("current_nodes", "latitude", :double, {:null=>false})
- -> 0.2069s
- -- change_column("current_nodes", "longitude", :double, {:null=>false})
- -> 0.1688s
- -- change_column("current_nodes", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.1686s
- -- change_column("current_nodes", "visible", :boolean, {:null=>false})
- -> 0.1575s
- -- change_column("current_nodes", "timestamp", :datetime, {:null=>false})
- -> 0.1800s
- -- add_primary_key("current_nodes", ["id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_nodes_pkey" for table "current_nodes"
- -> 0.0440s
- -- remove_index("current_nodes", {:name=>"current_nodes_id_idx"})
- -> 0.0071s
- -- change_column("current_segments", "node_a", :bigint, {:null=>false, :limit=>64})
- -> 0.2085s
- -- change_column("current_segments", "node_b", :bigint, {:null=>false, :limit=>64})
- -> 0.1685s
- -- change_column("current_segments", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.1568s
- -- change_column("current_segments", "visible", :boolean, {:null=>false})
- -> 0.1583s
- -- change_column("current_segments", "timestamp", :datetime, {:null=>false})
- -> 0.1687s
- -- add_primary_key("current_segments", ["id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_segments_pkey" for table "current_segments"
- -> 0.0440s
- -- remove_index("current_segments", {:name=>"current_segments_id_visible_idx"})
- -> 0.0063s
- -- change_column("current_way_segments", "id", :bigint, {:null=>false, :limit=>64})
- -> 0.1174s
- -- change_column("current_way_segments", "segment_id", :bigint, {:null=>false, :limit=>64})
- -> 0.1269s
- -- change_column("current_way_segments", "sequence_id", :bigint, {:null=>false, :limit=>11})
- -> 0.1015s
- -- add_primary_key("current_way_segments", ["id", "sequence_id"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_segments_pkey" for table "current_way_segments"
- -> 0.0430s
- -- remove_index("current_way_segments", {:name=>"current_way_segments_id_idx"})
- -> 0.0054s
- -- change_column("current_way_tags", "id", :bigint, {:null=>false, :limit=>64})
- -> 0.1526s
- -- change_column("current_ways", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.0449s
- -- change_column("current_ways", "timestamp", :datetime, {:null=>false})
- -> 0.0561s
- -- change_column("current_ways", "visible", :boolean, {:null=>false})
- -> 0.0557s
- -- change_engine("current_ways", "InnoDB")
- -> 0.0002s
- -- change_column("diary_entries", "title", :string, {:null=>false})
- -> 0.1008s
- -- change_column("diary_entries", "body", :text, {:null=>false})
- -> 0.1009s
- -- change_column("diary_entries", "created_at", :datetime, {:null=>false})
- -> 0.1068s
- -- change_column("diary_entries", "updated_at", :datetime, {:null=>false})
- -> 0.0862s
- -- add_index("friends", ["user_id"], {:name=>"friends_user_id_idx"})
- -> 0.0327s
- -- remove_index("gps_points", {:name=>"points_uid_idx"})
- -> 0.0063s
- -- remove_index("gps_points", {:name=>"points_idx"})
- -> 0.0047s
- -- remove_column("gps_points", "user_id")
- -> 0.0012s
- -- add_index("gps_points", ["latitude", "longitude"], {:name=>"points_idx"})
- -> 0.0430s
- -- change_column("gps_points", "trackid", :integer, {:null=>false})
- -> 0.0907s
- -- change_column("gps_points", "latitude", :integer, {:null=>false})
- -> 0.0789s
- -- change_column("gps_points", "longitude", :integer, {:null=>false})
- -> 0.0900s
- -- change_column("gps_points", "gpx_id", :bigint, {:null=>false, :limit=>64})
- -> 0.0912s
- -- change_column("gpx_file_tags", "tag", :string, {:null=>false})
- -> 0.0994s
- -- change_column("gpx_files", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.1798s
- -- change_column("gpx_files", "timestamp", :datetime, {:null=>false})
- -> 0.1820s
- -- change_column("gpx_files", "description", :string, {:null=>false, :default=>""})
- -> 0.1491s
- -- change_column("gpx_files", "inserted", :boolean, {:null=>false})
- -> 0.1666s
- -- drop_table("gpx_pending_files")
- -> 0.0022s
- -- remove_index("messages", {:name=>"from_name_idx"})
- -> 0.0047s
- -- remove_column("messages", "user_id")
- -> 0.0012s
- -- remove_column("messages", "from_display_name")
- -> 0.0013s
- -- change_column("messages", "title", :string, {:null=>false})
- -> 0.0904s
- -- change_column("messages", "body", :text, {:null=>false})
- -> 0.1008s
- -- change_column("messages", "sent_on", :datetime, {:null=>false})
- -> 0.0990s
- -- change_column("messages", "message_read", :boolean, {:null=>false, :default=>false})
- -> 0.0728s
- -- add_index("messages", ["to_user_id"], {:name=>"messages_to_user_id_idx"})
- -> 0.0408s
- -- drop_table("meta_areas")
- -> 0.0049s
- -- change_column("nodes", "id", :bigint, {:null=>false, :limit=>64})
- -> 0.1260s
- -- change_column("nodes", "latitude", :double, {:null=>false})
- -> 0.1079s
- -- change_column("nodes", "longitude", :double, {:null=>false})
- -> 0.1017s
- -- change_column("nodes", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.1238s
- -- change_column("nodes", "visible", :boolean, {:null=>false})
- -> 0.1117s
- -- change_column("nodes", "timestamp", :datetime, {:null=>false})
- -> 0.1245s
- -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
- -> 0.0439s
- -- change_column("segments", "id", :bigint, {:null=>false, :limit=>64})
- -> 0.1603s
- -- change_column("segments", "node_a", :bigint, {:null=>false, :limit=>64})
- -> 0.1578s
- -- change_column("segments", "node_b", :bigint, {:null=>false, :limit=>64})
- -> 0.2024s
- -- change_column("segments", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.1464s
- -- change_column("segments", "visible", :boolean, {:null=>false})
- -> 0.1802s
- -- change_column("segments", "timestamp", :datetime, {:null=>false})
- -> 0.1625s
- -- add_index("segments", ["timestamp"], {:name=>"segments_timestamp_idx"})
- -> 0.0295s
- -- remove_column("users", "preferences")
- -> 0.0013s
- -- change_column("users", "email", :string, {:null=>false})
- -> 0.1461s
- -- change_column("users", "pass_crypt", :string, {:null=>false})
- -> 0.1462s
- -- change_column("users", "creation_time", :datetime, {:null=>false})
- -> 0.1688s
- -- change_column("users", "display_name", :string, {:null=>false, :default=>""})
- -> 0.1630s
- -- change_column("users", "data_public", :boolean, {:null=>false, :default=>false})
- -> 0.1562s
- -- change_column("users", "home_lat", :double, {:default=>nil})
- -> 0.1556s
- -- change_column("users", "home_lon", :double, {:default=>nil})
- -> 0.1567s
- -- remove_index("users", {:name=>"users_email_idx"})
- -> 0.0051s
- -- add_index("users", ["email"], {:name=>"users_email_idx", :unique=>true})
- -> 0.0390s
- -- remove_index("users", {:name=>"users_display_name_idx"})
- -> 0.0055s
- -- add_index("users", ["display_name"], {:name=>"users_display_name_idx", :unique=>true})
- -> 0.0391s
- -- change_column("way_segments", "segment_id", :bigint, {:null=>false, :limit=>64})
- -> 0.0457s
- -- change_column("way_tags", "k", :string, {:null=>false})
- -> 0.0865s
- -- change_column("way_tags", "v", :string, {:null=>false})
- -> 0.0934s
- -- change_column("way_tags", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0807s
- -- change_column("ways", "user_id", :bigint, {:null=>false, :limit=>20})
- -> 0.0787s
- -- change_column("ways", "timestamp", :datetime, {:null=>false})
- -> 0.0676s
- -- change_column("ways", "visible", :boolean, {:null=>false, :default=>true})
- -> 0.0700s
- -- remove_index("ways", {:name=>"ways_id_version_idx"})
- -> 0.0051s
- -- add_index("ways", ["timestamp"], {:name=>"ways_timestamp_idx"})
- -> 0.0362s
- == CleanupOsmDb: migrated (8.1178s) ==========================================
- == SqlSessionStoreSetup: migrating ===========================================
- -- innodb_option()
- -> 0.0000s
- -- create_table("sessions", {:options=>""})
- NOTICE: CREATE TABLE will create implicit sequence "sessions_id_seq" for serial column "sessions.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions"
- -> 0.0973s
- -- add_index("sessions", ["session_id"], {:name=>"sessions_session_id_idx", :unique=>true})
- -> 0.0335s
- == SqlSessionStoreSetup: migrated (0.1313s) ==================================
- == UserEnhancements: migrating ===============================================
- -- add_column("diary_entries", "latitude", :double)
- -> 0.0022s
- -- add_column("diary_entries", "longitude", :double)
- -> 0.0013s
- -- add_column("diary_entries", "language", :string, {:limit=>3})
- -> 0.0012s
- -- innodb_table()
- -> 0.0000s
- -- create_table("user_preferences", {:options=>"", :force=>true, :id=>false})
- -> 0.0505s
- -- add_primary_key("user_preferences", ["user_id", "k"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "user_preferences_pkey" for table "user_preferences"
- -> 0.0445s
- -- innodb_table()
- -> 0.0000s
- -- create_table("user_tokens", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "user_tokens_id_seq" for serial column "user_tokens.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_tokens_pkey" for table "user_tokens"
- -> 0.0449s
- -- add_index("user_tokens", ["token"], {:name=>"user_tokens_token_idx", :unique=>true})
- -> 0.0445s
- -- add_index("user_tokens", ["user_id"], {:name=>"user_tokens_user_id_idx"})
- -> 0.0579s
- -- remove_column("users", "token")
- -> 0.0015s
- -- remove_column("users", "timeout")
- -> 0.0013s
- -- remove_column("users", "within_lon")
- -> 0.0012s
- -- remove_column("users", "within_lat")
- -> 0.0014s
- -- add_column("users", "nearby", :integer, {:default=>50})
- -> 0.0026s
- -- add_column("users", "pass_salt", :string)
- -> 0.0014s
- == UserEnhancements: migrated (0.2637s) ======================================
- == TileTracepoints: migrating ================================================
- -- add_column("gps_points", "tile", :four_byte_unsigned)
- -> 0.0014s
- -- add_index("gps_points", ["tile"], {:name=>"points_tile_idx"})
- -> 0.0326s
- -- remove_index("gps_points", {:name=>"points_idx"})
- -> 0.0075s
- == TileTracepoints: migrated (0.2084s) =======================================
- == TileNodes: migrating ======================================================
- -- remove_index("current_nodes", {:name=>"current_nodes_timestamp_idx"})
- -> 0.0055s
- -- rename_table("current_nodes", "current_nodes_v5")
- -> 0.0013s
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_nodes", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_nodes_id_seq" for serial column "current_nodes.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_nodes_pkey1" for table "current_nodes"
- -> 0.0743s
- -- add_index("current_nodes", ["timestamp"], {:name=>"current_nodes_timestamp_idx"})
- -> 0.0445s
- -- add_index("current_nodes", ["tile"], {:name=>"current_nodes_tile_idx"})
- -> 0.0336s
- -- change_column("current_nodes", "tile", :four_byte_unsigned)
- -> 0.1591s
- -- execute(" INSERT INTO current_nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n user_id, visible, tags, timestamp, 0\n FROM current_nodes_v5\n")
- -> 0.0024s
- -- drop_table("current_nodes_v5")
- -> 0.0035s
- -- remove_index("nodes", {:name=>"nodes_uid_idx"})
- -> 0.0067s
- -- remove_index("nodes", {:name=>"nodes_timestamp_idx"})
- -> 0.0051s
- -- rename_table("nodes", "nodes_v5")
- -> 0.0012s
- -- myisam_table()
- -> 0.0000s
- -- create_table("nodes", {:options=>"", :force=>true, :id=>false})
- -> 0.0514s
- -- add_index("nodes", ["id"], {:name=>"nodes_uid_idx"})
- -> 0.0446s
- -- add_index("nodes", ["timestamp"], {:name=>"nodes_timestamp_idx"})
- -> 0.0336s
- -- add_index("nodes", ["tile"], {:name=>"nodes_tile_idx"})
- -> 0.0554s
- -- change_column("nodes", "tile", :four_byte_unsigned)
- -> 0.1693s
- -- execute(" INSERT INTO nodes (id, latitude, longitude, user_id, visible, tags, timestamp, tile)\n SELECT id, ROUND(latitude * 10000000), ROUND(longitude * 10000000),\n user_id, visible, tags, timestamp, 0\n FROM nodes_v5\n")
- -> 0.0014s
- -- drop_table("nodes_v5")
- -> 0.0031s
- == TileNodes: migrated (0.7218s) =============================================
- == AddRelations: migrating ===================================================
- -- create_enumeration(:nwr_enum, ["Node", "Way", "Relation"])
- -> 0.0025s
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_relation_members", {:options=>"", :force=>true, :id=>false})
- -> 0.0055s
- -- add_primary_key("current_relation_members", ["id", "member_type", "member_id", "member_role"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
- -> 0.0482s
- -- add_index("current_relation_members", ["member_type", "member_id"], {:name=>"current_relation_members_member_idx"})
- -> 0.0336s
- -- myisam_table()
- -> 0.0001s
- -- create_table("current_relation_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0338s
- -- add_index("current_relation_tags", ["id"], {:name=>"current_relation_tags_id_idx"})
- -> 0.0334s
- -- add_fulltext_index("current_relation_tags", "v")
- -> 0.0484s
- -- innodb_table()
- -> 0.0001s
- -- create_table("current_relations", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "current_relations_id_seq" for serial column "current_relations.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "current_relations_pkey" for table "current_relations"
- -> 0.0412s
- -- myisam_table()
- -> 0.0001s
- -- create_table("relation_members", {:options=>"", :force=>true, :id=>false})
- -> 0.0059s
- -- add_primary_key("relation_members", ["id", "version", "member_type", "member_id", "member_role"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
- -> 0.0385s
- -- add_index("relation_members", ["member_type", "member_id"], {:name=>"relation_members_member_idx"})
- -> 0.0336s
- -- myisam_table()
- -> 0.0001s
- -- create_table("relation_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0452s
- -- add_index("relation_tags", ["id", "version"], {:name=>"relation_tags_id_version_idx"})
- -> 0.0443s
- -- myisam_table()
- -> 0.0001s
- -- create_table("relations", {:options=>"", :force=>true, :id=>false})
- -> 0.0058s
- -- add_primary_key("relations", ["id", "version"])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relations_pkey" for table "relations"
- -> 0.0388s
- -- add_index("relations", ["timestamp"], {:name=>"relations_timestamp_idx"})
- -> 0.0337s
- -- change_column("relations", "version", :bigint_auto_20)
- -> 0.0900s
- == AddRelations: migrated (0.5873s) ==========================================
- == RemoveSegments: migrating =================================================
- -- select_value("SELECT count(*) FROM current_segments")
- -> 0.0020s
- -- drop_table(:segments)
- -> 0.0052s
- -- drop_table(:way_segments)
- -> 0.0032s
- -- myisam_table()
- -> 0.0001s
- -- create_table(:way_nodes, {:options=>"", :force=>true, :id=>false})
- -> 0.0056s
- -- add_primary_key(:way_nodes, [:id, :version, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_nodes_pkey" for table "way_nodes"
- -> 0.0529s
- -- drop_table(:current_segments)
- -> 0.0038s
- -- drop_table(:current_way_segments)
- -> 0.0025s
- -- innodb_table()
- -> 0.0000s
- -- create_table(:current_way_nodes, {:options=>"", :force=>true, :id=>false})
- -> 0.0046s
- -- add_primary_key(:current_way_nodes, [:id, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_nodes_pkey" for table "current_way_nodes"
- -> 0.0667s
- -- add_index(:current_way_nodes, [:node_id], {:name=>"current_way_nodes_node_idx"})
- -> 0.0337s
- -- execute("TRUNCATE way_tags")
- -> 0.0920s
- -- execute("TRUNCATE ways")
- -> 0.0899s
- -- execute("TRUNCATE current_way_tags")
- -> 0.1460s
- -- execute("TRUNCATE current_ways")
- -> 0.0561s
- == RemoveSegments: migrated (0.5672s) ========================================
- == WayNodesNodeIdx: migrating ================================================
- -- add_index("way_nodes", ["node_id"], {:name=>"way_nodes_node_idx"})
- -> 0.0490s
- == WayNodesNodeIdx: migrated (0.0492s) =======================================
- == DiaryComments: migrating ==================================================
- -- myisam_table()
- -> 0.0001s
- -- create_table("diary_comments", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "diary_comments_id_seq" for serial column "diary_comments.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "diary_comments_pkey" for table "diary_comments"
- -> 0.0982s
- -- add_index("diary_comments", ["diary_entry_id", "id"], {:name=>"diary_comments_entry_id_idx", :unique=>true})
- -> 0.0445s
- == DiaryComments: migrated (0.1434s) =========================================
- == AddUserImage: migrating ===================================================
- -- add_column("users", "image", :text)
- -> 0.0017s
- == AddUserImage: migrated (0.0019s) ==========================================
- == AddAdminFlag: migrating ===================================================
- -- add_column("users", "administrator", :boolean, {:null=>false, :default=>false})
- -> 0.0051s
- == AddAdminFlag: migrated (0.0053s) ==========================================
- == AddEmailValid: migrating ==================================================
- -- add_column("users", "email_valid", :boolean, {:null=>false, :default=>false})
- -> 0.0041s
- == AddEmailValid: migrated (0.0055s) =========================================
- == AddNewEmail: migrating ====================================================
- -- add_column("users", "new_email", :string)
- -> 0.0015s
- == AddNewEmail: migrated (0.0018s) ===========================================
- == AddUserVisible: migrating =================================================
- -- add_column("users", "visible", :boolean, {:null=>false, :default=>true})
- -> 0.0043s
- == AddUserVisible: migrated (0.0056s) ========================================
- == AddCreationIp: migrating ==================================================
- -- add_column("users", "creation_ip", :string)
- -> 0.0016s
- == AddCreationIp: migrated (0.0018s) =========================================
- == AddGpxIndexes: migrating ==================================================
- -- add_index("gpx_files", ["user_id"], {:name=>"gpx_files_user_id_idx"})
- -> 0.0670s
- -- add_index("gpx_file_tags", ["tag"], {:name=>"gpx_file_tags_tag_idx"})
- -> 0.0561s
- == AddGpxIndexes: migrated (0.1235s) =========================================
- == CreateAcls: migrating =====================================================
- -- myisam_table()
- -> 0.0001s
- -- create_table("acls", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "acls_id_seq" for serial column "acls.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "acls_pkey" for table "acls"
- -> 0.0895s
- -- add_index("acls", ["k"], {:name=>"acls_k_idx"})
- -> 0.0516s
- == CreateAcls: migrated (0.1417s) ============================================
- == AddTimestampIndexes: migrating ============================================
- -- add_index(:current_ways, :timestamp, {:name=>:current_ways_timestamp_idx})
- -> 0.0600s
- -- add_index(:current_relations, :timestamp, {:name=>:current_relations_timestamp_idx})
- -> 0.0336s
- == AddTimestampIndexes: migrated (0.0941s) ===================================
- == PopulateNodeTagsAndRemove: migrating ======================================
- -- select_value("SELECT count(*) FROM current_nodes")
- -> 0.0015s
- -- execute("TRUNCATE nodes")
- -> 0.1375s
- -- remove_column(:nodes, :tags)
- -> 0.0014s
- -- remove_column(:current_nodes, :tags)
- -> 0.0014s
- -- add_column(:nodes, :version, :bigint, {:null=>false, :limit=>20})
- -> 0.0017s
- -- innodb_table()
- -> 0.0000s
- -- create_table(:current_node_tags, {:options=>"", :force=>true, :id=>false})
- -> 0.0401s
- -- innodb_table()
- -> 0.0001s
- -- create_table(:node_tags, {:options=>"", :force=>true, :id=>false})
- -> 0.0448s
- == PopulateNodeTagsAndRemove: migrated (0.2298s) =============================
- == MoveToInnodb: migrating ===================================================
- -- remove_index(:current_way_tags, {:name=>:current_way_tags_v_idx})
- -> 0.0054s
- -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_v_idx})
- -> 0.0046s
- -- change_column("nodes", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.1131s
- -- change_column("ways", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0993s
- -- change_column("relations", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0916s
- -- change_engine("nodes", "InnoDB")
- -> 0.0002s
- -- change_engine("ways", "InnoDB")
- -> 0.0001s
- -- change_engine("way_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("way_nodes", "InnoDB")
- -> 0.0001s
- -- change_engine("current_way_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("relation_members", "InnoDB")
- -> 0.0001s
- -- change_engine("relations", "InnoDB")
- -> 0.0001s
- -- change_engine("relation_tags", "InnoDB")
- -> 0.0001s
- -- change_engine("current_relation_tags", "InnoDB")
- -> 0.0001s
- -- add_column("current_nodes", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0018s
- -- add_column("current_ways", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0022s
- -- add_column("current_relations", "version", :bigint, {:null=>false, :limit=>20})
- -> 0.0021s
- == MoveToInnodb: migrated (0.3582s) ==========================================
- == KeyConstraints: migrating =================================================
- -- add_primary_key(:current_node_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_node_tags_pkey" for table "current_node_tags"
- -> 0.0558s
- -- add_primary_key(:current_way_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_way_tags_pkey" for table "current_way_tags"
- -> 0.0375s
- -- add_primary_key(:current_relation_tags, [:id, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_tags_pkey" for table "current_relation_tags"
- -> 0.0356s
- -- add_primary_key(:node_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "node_tags_pkey" for table "node_tags"
- -> 0.0337s
- -- add_primary_key(:way_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "way_tags_pkey" for table "way_tags"
- -> 0.0337s
- -- add_primary_key(:relation_tags, [:id, :version, :k])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_tags_pkey" for table "relation_tags"
- -> 0.0448s
- -- add_primary_key(:nodes, [:id, :version])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
- -> 0.0472s
- -- remove_index(:current_way_tags, {:name=>:current_way_tags_id_idx})
- -> 0.0045s
- -- remove_index(:current_relation_tags, {:name=>:current_relation_tags_id_idx})
- -> 0.0046s
- -- remove_index(:way_tags, {:name=>:way_tags_id_version_idx})
- -> 0.0098s
- -- remove_index(:relation_tags, {:name=>:relation_tags_id_version_idx})
- -> 0.0047s
- -- remove_index(:nodes, {:name=>:nodes_uid_idx})
- -> 0.0057s
- -- add_foreign_key(:current_node_tags, [:id], :current_nodes)
- -> 0.0046s
- -- add_foreign_key(:node_tags, [:id, :version], :nodes)
- -> 0.0040s
- -- add_foreign_key(:current_way_tags, [:id], :current_ways)
- -> 0.0039s
- -- add_foreign_key(:current_way_nodes, [:id], :current_ways)
- -> 0.0084s
- -- add_foreign_key(:way_tags, [:id, :version], :ways)
- -> 0.0040s
- -- add_foreign_key(:way_nodes, [:id, :version], :ways)
- -> 0.0077s
- -- add_foreign_key(:current_relation_tags, [:id], :current_relations)
- -> 0.0037s
- -- add_foreign_key(:current_relation_members, [:id], :current_relations)
- -> 0.0042s
- -- add_foreign_key(:relation_tags, [:id, :version], :relations)
- -> 0.0058s
- -- add_foreign_key(:relation_members, [:id, :version], :relations)
- -> 0.0039s
- -- add_foreign_key(:current_way_nodes, [:node_id], :current_nodes, [:id])
- -> 0.0092s
- == KeyConstraints: migrated (0.3814s) ========================================
- == AddChangesets: migrating ==================================================
- -- innodb_table()
- -> 0.0001s
- -- create_table("changesets", {:options=>"", :force=>true, :id=>false})
- NOTICE: CREATE TABLE will create implicit sequence "changesets_id_seq" for serial column "changesets.id"
- NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "changesets_pkey" for table "changesets"
- -> 0.0513s
- -- innodb_table()
- -> 0.0001s
- -- create_table("changeset_tags", {:options=>"", :force=>true, :id=>false})
- -> 0.0576s
- -- add_index("changeset_tags", ["id"], {:name=>"changeset_tags_id_idx"})
- -> 0.0429s
- -- execute("INSERT INTO changesets (id, user_id, created_at, open)SELECT id, id, creation_time, false from users;")
- -> 0.0014s
- -- rename_column("current_nodes", :user_id, :changeset_id)
- -> 0.0012s
- -- add_foreign_key("current_nodes", [:changeset_id], :changesets, [:id])
- -> 0.0036s
- -- rename_column("current_relations", :user_id, :changeset_id)
- -> 0.0011s
- -- add_foreign_key("current_relations", [:changeset_id], :changesets, [:id])
- -> 0.0035s
- -- rename_column("current_ways", :user_id, :changeset_id)
- -> 0.0035s
- -- add_foreign_key("current_ways", [:changeset_id], :changesets, [:id])
- -> 0.0043s
- -- rename_column("nodes", :user_id, :changeset_id)
- -> 0.0012s
- -- add_foreign_key("nodes", [:changeset_id], :changesets, [:id])
- -> 0.0036s
- -- rename_column("relations", :user_id, :changeset_id)
- -> 0.0014s
- -- add_foreign_key("relations", [:changeset_id], :changesets, [:id])
- -> 0.0050s
- -- rename_column("ways", :user_id, :changeset_id)
- -> 0.0012s
- -- add_foreign_key("ways", [:changeset_id], :changesets, [:id])
- -> 0.0079s
- == AddChangesets: migrated (0.1942s) =========================================
- == OrderRelationMembers: migrating ===========================================
- -- add_column(:relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
- -> 0.0046s
- -- execute("update relation_members set sequence_id = mod(member_id, 16384)")
- -> 0.0010s
- -- alter_primary_key("relation_members", [:id, :version, :member_type, :member_id, :member_role, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "relation_members_pkey" for table "relation_members"
- -> 0.0440s
- -- add_column(:current_relation_members, :sequence_id, :integer, {:null=>false, :default=>0})
- -> 0.0044s
- -- execute("update current_relation_members set sequence_id = mod(member_id, 16384)")
- -> 0.0008s
- -- alter_primary_key("current_relation_members", [:id, :member_type, :member_id, :member_role, :sequence_id])
- NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "current_relation_members_pkey" for table "current_relation_members"
- -> 0.0623s
- == OrderRelationMembers: migrated (0.1184s) ==================================
- == AddEndTimeToChangesets: migrating =========================================
- -- add_column(:changesets, :closed_at, :datetime, {:null=>false})
- -> 0.0024s
- -- interval_constant("1 hour")
- -> 0.0002s
- -- execute("update changesets set closed_at=(now()-'1 hour'::interval) where open=(1=0)")
- -> 0.0014s
- -- interval_constant("1 hour")
- -> 0.0002s
- -- execute("update changesets set closed_at=(now()+'1 hour'::interval) where open=(1=1)")
- -> 0.0008s
- -- remove_column(:changesets, :open)
- -> 0.0018s
- -- add_column(:changesets, :num_changes, :integer, {:null=>false, :default=>0})
- -> 0.0045s
- == AddEndTimeToChangesets: migrated (0.0122s) ================================
- == AddChangesetUserIndex: migrating ==========================================
- -- add_index("changesets", ["user_id"], {:name=>"changesets_user_id_idx"})
- -> 0.0429s
- == AddChangesetUserIndex: migrated (0.0431s) =================================
- == AddChangesetIndexes: migrating ============================================
- -- add_index("nodes", ["changeset_id"], {:name=>"nodes_changeset_id_idx"})
- -> 0.0434s
- -- add_index("ways", ["changeset_id"], {:name=>"ways_changeset_id_idx"})
- -> 0.0337s
- -- add_index("relations", ["changeset_id"], {:name=>"relations_changeset_id_idx"})
- -> 0.0338s
- == AddChangesetIndexes: migrated (0.1116s) ===================================
- == AddMoreChangesetIndexes: migrating ========================================
- -- add_index("changesets", ["created_at"], {:name=>"changesets_created_at_idx"})
- -> 0.0330s
- -- add_index("changesets", ["closed_at"], {:name=>"changesets_closed_at_idx"})
- -> 0.0337s
- -- add_index("changesets", ["min_lat", "max_lat", "min_lon", "max_lon"], {:method=>"GIST", :name=>"changesets_bbox_idx"})
- rake aborted!
- An error has occurred, this and all later migrations canceled:
- PGError: ERROR: data type integer has no default operator class for access method "gist"
- HINT: You must specify an operator class for the index or define a default operator class for the data type.
- : CREATE INDEX "changesets_bbox_idx" ON "changesets" USING GIST ("min_lat", "max_lat", "min_lon", "max_lon")
- Tasks: TOP => db:migrate
- (See full trace by running task with --trace)
- alexandru@alex-lap:~/.osm/rail_port/rails$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement