<p>Migrations have been rewritten to reflect current state of the database structure.</p>
<hr>
<h4>You can view, comment on, or merge this pull request online at:</h4>
<p> <a href='https://github.com/openstreetmap/openstreetmap-website/pull/1229'>https://github.com/openstreetmap/openstreetmap-website/pull/1229</a></p>
<h4>Commit Summary</h4>
<ul>
<li>Modify migrations 1</li>
<li>Reduce Migrations</li>
<li>Reduce Migrations</li>
<li>Reduce Mitration</li>
<li>Compact Migrations</li>
<li>Compact Migrations</li>
</ul>
<h4>File Changes</h4>
<ul>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-0">db/migrate/001_create_osm_db.rb</a>
(308)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-1">db/migrate/002_cleanup_osm_db.rb</a>
(223)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-2">db/migrate/003_sql_session_store_setup.rb</a>
(17)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-3">db/migrate/004_user_enhancements.rb</a>
(57)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-4">db/migrate/005_tile_tracepoints.rb</a>
(27)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-5">db/migrate/006_tile_nodes.rb</a>
(126)
</li>
<li>
<strong>R</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-6">db/migrate/007_create_relations.rb</a>
(35)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-7">db/migrate/008_remove_segments.rb</a>
(86)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-8">db/migrate/008_remove_segments_helper.cc</a>
(691)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-9">db/migrate/009_way_nodes_node_idx.rb</a>
(9)
</li>
<li>
<strong>R</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-10">db/migrate/010_create_diary_comments.rb</a>
(8)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-11">db/migrate/011_add_user_image.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-12">db/migrate/012_add_admin_flag.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-13">db/migrate/013_add_email_valid.rb</a>
(10)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-14">db/migrate/014_add_new_email.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-15">db/migrate/015_add_user_visible.rb</a>
(10)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-16">db/migrate/016_add_creation_ip.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-17">db/migrate/017_add_gpx_indexes.rb</a>
(11)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-18">db/migrate/018_create_acls.rb</a>
(6)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-19">db/migrate/019_add_timestamp_indexes.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-20">db/migrate/020_populate_node_tags_and_remove.rb</a>
(63)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-21">db/migrate/020_populate_node_tags_and_remove_helper.c</a>
(241)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-22">db/migrate/021_move_to_innodb.rb</a>
(41)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-23">db/migrate/022_key_constraints.rb</a>
(52)
</li>
<li>
<strong>R</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-24">db/migrate/023_create_changesets.rb</a>
(26)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-25">db/migrate/024_order_relation_members.rb</a>
(35)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-26">db/migrate/025_add_end_time_to_changesets.rb</a>
(36)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-27">db/migrate/026_add_changeset_user_index.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-28">db/migrate/027_add_changeset_indexes.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-29">db/migrate/028_add_more_changeset_indexes.rb</a>
(15)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-30">db/migrate/029_add_user_foreign_keys.rb</a>
(16)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-31">db/migrate/030_add_foreign_keys.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-32">db/migrate/031_create_countries.rb</a>
(21)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-33">db/migrate/032_add_user_locale.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-34">db/migrate/033_change_diary_entries_language.rb</a>
(11)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-35">db/migrate/034_create_languages.rb</a>
(2)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-36">db/migrate/035_change_user_locale.rb</a>
(15)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-37">db/migrate/036_add_visible_to_message.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-38">db/migrate/037_add_sender_visible_to_message.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-39">db/migrate/038_add_message_sender_index.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-40">db/migrate/039_add_more_controls_to_gpx_files.rb</a>
(21)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-41">db/migrate/040_create_oauth_tables.rb</a>
(27)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-42">db/migrate/041_add_fine_o_auth_permissions.rb</a>
(23)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-43">db/migrate/042_add_foreign_keys_to_oauth_tables.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-44">db/migrate/043_add_referer_to_user_token.rb</a>
(9)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-45">db/migrate/044_create_user_roles.rb</a>
(21)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-46">db/migrate/045_create_user_blocks.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-47">db/migrate/046_alter_user_roles_and_blocks.rb</a>
(29)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-48">db/migrate/047_add_visible_to_diaries.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-49">db/migrate/048_add_diary_creation_indexes.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-50">db/migrate/049_improve_changeset_user_index.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-51">db/migrate/050_add_user_index_to_diary_comments.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-52">db/migrate/051_add_status_to_user.rb</a>
(29)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-53">db/migrate/052_add_contributor_terms_to_user.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-54">db/migrate/053_add_map_bug_tables.rb</a>
(34)
</li>
<li>
<strong>A</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-55">db/migrate/053_create_notes.rb</a>
(52)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-56">db/migrate/054_refactor_map_bug_tables.rb</a>
(35)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-57">db/migrate/055_change_map_bug_comment_type.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-58">db/migrate/056_add_date_closed.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-59">db/migrate/057_add_map_bug_comment_event.rb</a>
(15)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-60">db/migrate/20100513171259_add_user_date_index_to_changeset.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-61">db/migrate/20100516124737_add_open_id.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-62">db/migrate/20100910084426_add_callback_to_oauth_tokens.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-63">db/migrate/20101114011429_add_editor_preference_to_user.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-64">db/migrate/20110322001319_add_terms_seen_to_user.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-65">db/migrate/20110508145337_cleanup_bug_tables.rb</a>
(25)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-66">db/migrate/20110521142405_rename_bugs_to_notes.rb</a>
(31)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-67">db/migrate/20110925112722_rename_ids.rb</a>
(18)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-68">db/migrate/20111116184519_update_oauth.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-69">db/migrate/20111212183945_add_lowercase_user_indexes.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-70">db/migrate/20120123184321_switch_to_paperclip.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-71">db/migrate/20120208122334_merge_acl_address_and_mask.rb</a>
(45)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-72">db/migrate/20120208194454_add_domain_to_acl.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-73">db/migrate/20120214210114_add_text_format.rb</a>
(21)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-74">db/migrate/20120219161649_add_user_image_fingerprint.rb</a>
(16)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-75">db/migrate/20120318201948_create_redactions.rb</a>
(6)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-76">db/migrate/20120328090602_drop_session_table.rb</a>
(17)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-77">db/migrate/20120404205604_add_user_and_description_to_redaction.rb</a>
(10)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-78">db/migrate/20120808231205_add_counter_caches.rb</a>
(19)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-79">db/migrate/20121005195010_add_diary_entry_counter_caches.rb</a>
(13)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-80">db/migrate/20121012044047_add_image_use_gravatar_to_users.rb</a>
(14)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-81">db/migrate/20121119165817_drop_nearby_place_from_notes.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-82">db/migrate/20121202155309_remove_author_name_from_note_comment.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-83">db/migrate/20121203124841_change_note_address_to_inet.rb</a>
(9)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-84">db/migrate/20130328184137_add_write_notes_permission.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-85">db/migrate/20131212124700_add_created_at_index_to_note_comments.rb</a>
(5)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-86">db/migrate/20140115192822_add_text_index_to_note_comments.rb</a>
(11)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-87">db/migrate/20140117185510_drop_countries.rb</a>
(5)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-88">db/migrate/20140210003018_add_user_image_content_type.rb</a>
(5)
</li>
<li>
<strong>R</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-89">db/migrate/20140519141742_create_join_table_users_and_changesets.rb</a>
(2)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-90">db/migrate/20150110152606_change_default_formats.rb</a>
(17)
</li>
<li>
<strong>D</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-91">db/migrate/20150222101847_rename_openid_url.rb</a>
(11)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229/files#diff-92">db/structure.sql</a>
(243)
</li>
</ul>
<h4>Patch Links:</h4>
<ul>
<li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/1229.patch'>https://github.com/openstreetmap/openstreetmap-website/pull/1229.patch</a></li>
<li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/1229.diff'>https://github.com/openstreetmap/openstreetmap-website/pull/1229.diff</a></li>
</ul>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/pull/1229">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe/ABWnLZjfm2VlMf7LIYiTbd_5TGQFXFQ3ks5qIKbkgaJpZM4It8zt">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/ABWnLVGXkjXgTYBB5EYcQoKha1obr_65ks5qIKbkgaJpZM4It8zt.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/openstreetmap/openstreetmap-website/pull/1229"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>