keii.dev / osu-web
the browser-facing portion of osu!
fork atom
osu-web / database / migrations /
at master 380 files
.gitkeep
2015_01_01_133337_base_tables.php
2015_01_01_133337_chat_base_tables.php
2015_01_01_133337_multiplayer_base_tables.php
2015_01_01_133337_store_base_tables.php
2015_01_01_133337_updates_base_tables.php
2015_01_01_133338_create_beatmap_failtimes_table.php
2015_01_23_114030_extend_products_table.php
2015_01_29_013313_add_last_order_tracking_state.php
2015_02_03_051509_record_cost_and_shipping_in_order.php
2015_02_04_165733_record_cost_and_shipping_in_order_populate.php
2015_05_01_013313_add_item_family.php
2015_06_04_083548_infinite_stock_products.php
2015_06_04_093340_custom_product_implementations.php
2015_06_18_022845_order_transaction_id.php
2015_06_19_050528_add_order_paid_at_column.php
2015_07_08_042238_create_tournaments_tables.php
2015_07_09_084235_create_user_profile_customizations_table.php
2015_07_09_091745_add_tournament_description_text.php
2015_07_09_105144_create_tournaments_registrations_table.php
2015_08_10_083016_add_slug_to_achievements.php
2015_11_16_065319_create_topic_covers_table.php
2015_11_20_122003_add_unique_index_to_forum_topic_covers_forum_id.php
2015_12_07_061307_create_forum_covers_table.php
2016_01_12_074035_unique_user_customization_user_id.php
2016_01_26_194005_disable_products.php
2016_01_29_090810_add_description_to_achievements.php
2016_02_11_155642_add_extras_order_on_user_profile_customization.php
2016_02_23_094326_create_jobs_table.php
2016_02_25_072543_add_cover_updated_at_to_beatmapsets.php
2016_02_25_080550_create_failed_jobs_table.php
2016_02_27_103851_create_osu_slack_users_table.php
2016_02_29_052133_create_beatmapset_discussions.php
2016_02_29_060025_create_beatmap_discussions.php
2016_02_29_081309_create_beatmap_discussion_posts.php
2016_03_02_214730_change_primary_key_on_slack_users.php
2016_03_03_223651_osu_slack_user_make_slack_id_nullable.php
2016_03_09_083112_add_index_on_slack_id.php
2016_03_15_080726_add_default_topic_cover_to_forum_covers.php
2016_03_18_170000_create_oauth_scopes_table.php
2016_03_18_170001_create_oauth_grants_table.php
2016_03_18_170002_create_oauth_grant_scopes_table.php
2016_03_18_170003_create_oauth_clients_table.php
2016_03_18_170004_create_oauth_client_endpoints_table.php
2016_03_18_170005_create_oauth_client_scopes_table.php
2016_03_18_170006_create_oauth_client_grants_table.php
2016_03_18_170007_create_oauth_sessions_table.php
2016_03_18_170008_create_oauth_session_scopes_table.php
2016_03_18_170009_create_oauth_auth_codes_table.php
2016_03_18_170010_create_oauth_auth_code_scopes_table.php
2016_03_18_170011_create_oauth_access_tokens_table.php
2016_03_18_170012_create_oauth_access_token_scopes_table.php
2016_03_18_170013_create_oauth_refresh_tokens_table.php
2016_03_22_054843_create_beatmap_discussion_votes.php
2016_04_11_071007_use_user_id_for_resolving_issue.php
2016_04_12_111756_add_last_editor_id_to_beatmap_discussion_posts.php
2016_04_13_054710_add_system_to_beatmap_discussion_posts.php
2016_04_13_185417_add_moderated_flag_to_channel.php
2016_04_14_061643_create_user_zebras_table.php
2016_04_19_112407_create_store_notification_requests_table.php
2016_05_10_080557_update_achievements_table.php
2016_06_17_081023_create_beatmapset_events.php
2016_06_21_054206_create_poll_votes_table.php
2016_06_21_055139_create_poll_options_table.php
2016_06_21_134532_create_banchostats_table.php
2016_07_21_072328_create_artist_tables.php
2016_07_29_024320_create_contest_tables.php
2016_08_04_100929_add_length_to_artist_tracks.php
2016_08_16_101048_create_sessions_table.php
2016_08_25_031518_add_show_votes_to_contests.php
2016_08_25_055700_create_contest_vote_aggregates_view.php
2016_08_31_062640_add_visible_to_artists_table.php
2016_08_31_103716_add_exclusive_to_artist_tracks.php
2016_09_06_124728_add_soft_deletes_to_posts_topics_tables.php
2016_09_07_105853_add_visible_to_contests.php
2016_09_20_203638_contest_submissions.php
2016_09_30_064049_create_user_contest_entries_table.php
2016_10_05_061323_add_max_entries_to_contests.php
2016_10_24_062803_update_jobs_table.php
2016_10_28_000000_update_oauth_tables.php
2016_10_28_000001_create_passport_oauth_auth_codes_table.php
2016_10_28_000002_create_passport_oauth_access_tokens_table.php
2016_10_28_000003_create_passport_oauth_refresh_tokens_table.php
2016_10_28_000004_create_passport_oauth_clients_table.php
2016_10_28_000005_create_passport_oauth_personal_access_clients_table.php
2016_11_02_063649_add_user_id_to_contest_entries.php
2016_11_04_022225_add_extra_options_to_contests.php
2016_12_01_090638_add_soft_delete_to_beatmap_discussion_posts.php
2016_12_01_114033_add_additional_links_to_artists.php
2016_12_02_092104_add_soft_delete_to_beatmap_discussions.php
2016_12_07_063316_create_artist_albums_table.php
2016_12_07_065315_add_album_id_to_artist_tracks.php
2016_12_09_052957_add_more_fields_to_artist_tracks.php
2016_12_16_080558_update_kudos_exchange.php
2016_12_19_124550_add_kudosu_block_to_beatmap_discussions.php
2016_12_19_132350_add_kudosu_refresh_votes_to_beatmap_discussions.php
2017_01_13_062704_nullable_entry_url_on_contest_entries.php
2017_02_01_105338_drop_slack_users.php
2017_02_06_083745_nullable_cover_json_on_user_profile_customizations.php
2017_02_10_030227_contest_votes_change_weighting_to_float.php
2017_02_13_013536_delete_contest_vote_aggregates_view.php
2017_02_20_141012_allow_nulls_on_user_contest_entries.php
2017_02_21_084403_mb4_forum_last_topic.php
2017_02_22_061910_nullables_on_forum_covers.php
2017_03_10_080135_add_index_to_user_donations.php
2017_05_04_070936_add_index_on_osu_builds.php
2017_05_12_111922_add_build_propagation_history_table.php
2017_05_22_061803_add_allow_multiple_to_products.php
2017_05_22_073156_drop_order_id_product_id_from_order_items.php
2017_05_26_101854_add_extra_data_to_order_items_table.php
2017_05_31_042932_add_supporter_tag_to_products.php
2017_06_02_040908_CreateCountryStatisticsTables.php
2017_07_14_040809_add_action_field_to_chat_tables.php
2017_07_20_013337_create_osu_beatmappacks_table.php
2017_07_20_013338_create_osu_beatmappacks_items_table.php
2017_07_20_094844_add_playmode_to_osu_beatmappacks.php
2017_07_26_093948_add_more_type_to_beatmapset_events.php
2017_08_03_064207_unresolve_non_issue_beatmap_discussions.php
2017_08_04_104549_make_all_beatmap_discussion_general_as_suggestion.php
2017_08_28_075817_add_discussion_enabled_to_beatmapsets.php
2017_08_28_080125_add_deleted_at_to_beatmapsets.php
2017_08_28_090801_directly_use_beatmapset_id_for_beatmap_discussions.php
2017_08_28_110634_drop_beatmapset_discussions.php
2017_09_01_101541_create_osu_profile_banners.php
2017_09_04_064001_add_deleted_at_to_beatmaps.php
2017_09_06_050956_add_youtube_to_artists.php
2017_09_07_084729_better_forum_posts_index.php
2017_09_08_110651_simplify_forum_posts_index.php
2017_09_12_065003_fix_logs_table_encoding.php
2017_09_13_102556_create_user_channels_table.php
2017_09_20_055045_create_payments_table.php
2017_10_10_082642_add_ip_bans.php
2017_10_20_133251_add_beatmapset_watches.php
2017_10_25_054504_add_banner_to_tournaments.php
2017_11_17_074755_add_index_to_payments_transaction_id.php
2017_11_22_070257_update_discussion_type_by_mapper.php
2017_11_22_081837_remove_kudosu_refresh_votes_from_beatmap_discussions.php
2017_11_22_114135_add_even_more_type_to_beatmapset_events.php
2017_11_23_102444_add_index_to_kudosu_histories_kudosuable.php
2017_11_27_064736_fix_user_sig_encoding.php
2017_11_29_033957_add_nomination_reset_type_to_beatmapset_events.php
2017_12_13_083252_change_costs_to_decimal.php
2017_12_20_090905_add_new_rank_cache_columns.php
2018_01_03_082931_add_hype_to_beatmapsets.php
2018_01_09_063809_add_processing_type_to_order_status.php
2018_01_11_060632_add_nominations_to_beatmapsets.php
2018_03_06_114525_add_mail_to_topic_watches.php
2018_04_06_081112_unique_beatmapset_discussion_votes.php
2018_04_12_080404_add_index_to_achievements_name.php
2018_04_12_085114_add_spotify_and_osu_profile_to_artists.php
2018_04_20_100654_add_queue_time_to_beatmapsets.php
2018_05_09_083801_add_wiki_and_store_link_to_tournaments.php
2018_05_22_024629_create_changelogs.php
2018_06_06_091751_link_streams_to_changelog_entries.php
2018_06_22_132317_link_streams_to_repositories.php
2018_06_25_072709_update_beatmapset_datetimes_datatype.php
2018_07_03_101029_add_default_category_to_repositories.php
2018_07_03_103002_update_repositories_nullable_stream_id.php
2018_07_03_114909_link_changelog_entries_to_repositories.php
2018_07_03_115128_set_changelog_entries_repository_id.php
2018_07_03_115621_drop_repository_from_changelog_entries.php
2018_07_12_110501_add_build_on_tag_to_repositories.php
2018_07_13_073008_add_chat_channel_types.php
2018_07_26_110501_add_love_type_to_beatmapset_events.php
2018_07_26_211352_add_moderating_groups_to_forums.php
2018_07_31_073629_create_comments.php
2018_07_31_101323_create_news_posts.php
2018_08_02_073727_drop_comments_from_builds.php
2018_08_03_102238_add_reserved_to_order_items.php
2018_08_27_053717_add_country_code_to_payments.php
2018_09_26_082418_add_soft_delete_to_user_contest_entries.php
2018_10_12_045503_add_index_to_orders_updated_at.php
2018_10_15_102603_create_comment_votes.php
2018_10_16_012859_add_votes_count_to_comments.php
2018_11_29_050923_create_rooms.php
2018_11_29_081727_create_playlist_items.php
2018_12_06_094847_add_ruleset_id_to_multiplayer_playlist_items.php
2018_12_13_072418_create_multiplayer_scores.php
2018_12_13_121903_add_reportable_type_to_user_reports.php
2018_12_14_100020_add_chat_channel_id_to_multiplayer_room.php
2018_12_21_101924_create_multiplayer_scores_high.php
2018_12_21_101935_create_multiplayer_rooms_high.php
2018_12_25_090628_add_participation_index_to_multiplayer_scores.php
2018_12_26_114102_add_participation_count_to_multiplayer_rooms.php
2018_12_26_120639_change_multiplayer_scores_rank_to_enum.php
2019_01_17_051612_add_available_until_to_products.php
2019_01_17_065444_add_notifications.php
2019_01_23_031727_add_user_notifications.php
2019_02_15_062607_add_shopify_id_to_products.php
2019_04_01_202237_add_poll_hide_results_to_topics.php
2019_04_09_053403_add_allow_topic_covers_to_forums.php
2019_04_17_103403_add_discussion_locked_to_beatmapsets.php
2019_04_23_051152_add_discussion_locked_to_beatmapset_events.php
2019_05_22_041713_add_hidden_to_user_channels.php
2019_05_28_024814_create_follows.php
2019_06_25_083703_add_options_to_user_profile_customizations.php
2019_07_23_034016_add_score_process_queue.php
2019_07_25_082550_add_url_to_badges.php
2019_08_07_070216_add_last_post_at_to_beatmap_discussions.php
2019_08_07_103120_add_index_to_beatmap_discussion.php
2019_08_21_104727_add_index_to_beatmapset_events.php
2019_08_26_053354_add_expires_at_index_to_oauth_tables.php
2019_08_27_094035_add_client_id_index_to_oauth_access_tokens.php
2019_09_11_135102_add_beatmap_discussion_post_to_report_types.php
2019_09_18_074659_update_beatmapset_discussion_polymorphic_name.php
2019_10_21_075612_add_pinned_field_to_comments.php
2019_10_23_023102_add_hidden_to_beatmapset_packs.php
2019_10_23_100514_create_user_notification_options.php
2019_11_07_095402_add_parent_id_to_beatmap_discussions.php
2019_11_14_032004_add_new_index_to_scores_high.php
2019_11_27_084154_add_bpm_to_beatmaps.php
2019_12_04_015903_add_extra_columns_to_groups.php
2019_12_11_045755_add_show_in_client_to_user_contest_entries.php
2020_01_17_080543_update_multiplayer_mods.php
2020_01_20_031913_json_news_post_page.php
2020_01_23_083342_nullable_groups_display_order.php
2020_02_13_080406_add_country_acronym_to_scores_high.php
2020_03_09_095216_add_channel_type_index_to_channels.php
2020_03_09_100459_remove_multiplayer_rooms_high_accuracy_precision.php
2020_04_12_101236_add_genre_and_language_edit_to_beatmapset_events.php
2020_05_15_083037_sync_structure.php
2020_05_28_072624_add_multiplayer_scores_high_top_scores_index.php
2020_06_09_041029_add_user_stats_mania_4k7k.php
2020_06_12_112517_add_delivery_to_user_notifications.php
2020_06_12_112518_set_last_mail_notification_id_sent.php
2020_07_08_042634_add_category_to_multiplayer_rooms.php
2020_07_10_105258_add_ends_at_index_to_multiplayer_rooms.php
2020_07_13_055413_add_last_score_id_to_multiplayer_rooms_high.php
2020_07_17_021430_add_play_mode_variant_to_tournaments.php
2020_07_22_045416_add_timestamp_index_to_user_account_history.php
2020_07_22_054643_add_user_read_index_to_user_notifications.php
2020_08_27_202640_add_nsfw_flag_to_beatmapsets.php
2020_09_09_042555_update_comments_index.php
2020_09_13_081046_create_user_group_events.php
2020_09_25_092826_create_phpbb_banlist.php
2020_10_01_060127_add_has_playmodes_to_phpbb_groups.php
2020_10_01_065459_add_playmodes_to_phpbb_user_group.php
2020_10_06_010117_add_url_to_ranks.php
2020_10_13_064901_add_provider_reference_to_orders.php
2020_10_14_030317_add_remove_from_loved_type_to_beatmapset_events.php
2020_11_04_144136_add_index_to_user_id_on_comments.php
2020_11_13_025024_add_no_diff_reduction_to_beatmap_packs.php
2020_11_19_071006_add_forum_post_to_report_types.php
2020_11_26_055928_add_modding_and_user_to_follows.php
2020_12_03_075220_add_realtime_to_multiplayer_rooms.php
2020_12_09_052337_add_mapping_to_follows.php
2021_01_15_092749_add_nsfw_toggle_to_beatmapset_events.php
2021_01_25_050834_add_count_last_mail_user_notification_id_sent.php
2021_01_25_092927_create_beatmap_mode_stats.php
2021_02_02_073616_add_last_message_id_to_channels.php
2021_02_03_120003_add_max_attempts_to_playlist_items.php
2021_02_16_090310_add_provider_to_oauth_clients.php
2021_02_17_073637_add-expired-column-to-playlist-items.php
2021_03_19_065458_add_external_contest_type.php
2021_03_24_130818_create_solo_scores.php
2021_04_15_075328_add_thumbnail_url_to_contest_entries.php
2021_04_16_083901_rename_contest_shape_extra_option.php
2021_04_26_075454_add_beatmap_owner_change_to_beatmapset_events.php
2021_06_03_115603_create_chat_filters_table.php
2021_06_12_145807_add_multi_accounting_report.php
2021_06_28_084610_create_solo_score_tokens.php
2021_07_01_091316_add_in_room_to_multiplayer_rooms_high.php
2021_07_07_065618_add_password_to_multiplayer_rooms.php
2021_07_07_073634_create_beatmapset_nominations.php
2021_07_19_084446_add_nomination_reset_received_to_beatmapset_events.php
2021_08_03_090146_add_type_to_multiplayer_rooms.php
2021_08_17_194701_add_beatmapset_to_report_types.php
2021_08_30_153214_add_track_id_to_beatmapsets.php
2021_09_15_065842_create_new_score_tables.php
2021_10_05_064929_create_solo_scores_performance.php
2021_10_14_094706_add_build_id_to_solo_score_tokens.php
2021_11_01_194418_add_post_id_to_phpbb_log.php
2021_11_17_073841_add_queue_mode_to_multiplayer_rooms.php
2021_11_17_074221_add_owner_id_to_multiplayer_playlist_items.php
2021_12_03_102651_add_played_at_to_playlist_items.php
2022_01_17_104933_update_default_beatmaps_bpm.php
2022_01_22_110033_create_score_pins.php
2022_01_26_210000_add_announce_type_to_channels.php
2022_01_28_180000_add_playmode_changes_to_user_group_events.php
2022_03_18_125356_add_auto_start_duration_to_multiplayer_rooms.php
2022_04_12_142434_add_offset_edit_to_beatmapset_events.php
2022_04_30_152502_add_spotlight_to_beatmapsets.php
2022_05_16_114745_update_beatmapsets_approvedby_id_type.php
2022_05_23_052743_add_unique_index_to_groups_identifier.php
2022_05_23_072546_rename_builds_build_on_release.php
2022_05_25_081221_add_ruleset_id_to_score_pins.php
2022_05_27_094956_add_featured_artist_to_multiplayer_rooms_category.php
2022_06_08_065812_add_comment_locked_to_beatmapsets.php
2022_06_27_073817_create_solo_scores_legacy_id_map.php
2022_07_07_070707_add_solo_score_to_score_pins_score_type.php
2022_07_08_085310_add_allow_performance_to_osu_builds.php
2022_07_19_060203_set_compressed_row_format_on_solo_scores.php
2022_07_22_000000_create_beatmap_leaders.php
2022_08_04_220851_create_bss_process_queue.php
2022_08_05_103407_remove_deleted_at_from_solo_scores.php
2022_08_08_083336_add_solo_score_to_report_types.php
2022_08_15_074123_index_beatmap_id_on_solo_scores.php
2022_08_15_081810_index_user_ruleset_id_on_solo_scores.php
2022_08_16_195413_add_permanent_to_user_account_history.php
2022_08_18_110506_add_has_replay_to_solo_scores.php
2022_08_31_102024_add_auto_skip_to_multiplayer_rooms.php
2022_09_09_011035_upgrade_legacy_scoreids_to_bigint.php
2022_09_09_080211_create_osu_beatmap_performance_blacklist.php
2022_09_13_080115_index_news_posts_tumblr_id.php
2022_09_21_052117_create_osu_difficulty_attribs.php
2022_10_18_103120_create_osu_user_performance_rank_highest.php
2022_11_12_103015_index_user_id_on_beatmapset_nominations.php
2022_12_05_114748_add_rank_exp_to_user_statistics.php
2022_12_12_052806_create_user_performance_rank_exp.php
2023_01_05_022852_require_user_group_events_details_and_type.php
2023_01_30_080509_use_datetime_for_supporter_expiry.php
2023_02_03_151137_create_seasons_table.php
2023_02_03_151601_create_season_rooms_table.php
2023_02_22_103305_add_create_time_index_to_forum_topics.php
2023_03_13_100000_add_tags_edit_to_beatmapset_events.php
2023_03_22_000000_add_chat_message_to_report_types.php
2023_04_07_051227_create_user_ircauth.php
2023_06_15_090320_add_youtube_id_to_builds.php
2023_07_20_062848_create_user_country_history.php
2023_08_17_133006_sync_structure.php
2023_08_25_000000_create_multiplayer_score_links.php
2023_08_25_000001_add_score_link_id_to_multiplayer_scores_high.php
2023_08_25_000002_add_last_score_link_id_to_multiplayer_rooms_high.php
2023_09_06_070904_set_not_null_ruleset_id_on_playlist_items.php
2023_09_11_100621_add_lock_email_changes_to_users.php
2023_09_21_065339_add_max_combo_to_beatmaps.php
2023_09_25_230000_update_github_users.php
2023_10_12_065846_simplify_score_links.php
2023_10_12_071549_add_playlist_item_id_to_score_tokens.php
2023_10_24_122345_drop_id_from_user_profile_customizations.php
2023_10_25_093434_drop_unused_score_link_columns.php
2023_10_25_094633_drop_score_link_id_from_multiplayer_scores_high.php
2023_10_25_094642_drop_last_score_link_id_from_multiplayer_rooms_high.php
2023_10_26_000000_add_attempts_to_multiplayer_scores_high.php
2023_10_31_074205_create_score_table_aliases.php
2023_11_22_055714_change_multiplayer_scores_high_attempts_to_int.php
2023_11_27_173516_add_video_url_on_artists.php
2023_12_18_085034_update_scores_table.php
2023_12_18_104437_add_verified_column_to_oauth_access_tokens.php
2024_01_12_115738_update_scores_table_final.php
2024_01_31_000000_create_contest_judges_table.php
2024_01_31_000001_create_contest_judge_votes_table.php
2024_01_31_000002_create_contest_scoring_categories_table.php
2024_01_31_000003_create_contest_judge_scores_table.php
2024_01_31_181425_unview_scores.php
2024_02_12_000001_add_users_lazer_to_bancho_stats.php
2024_02_15_115214_add_new_score_id_to_score_pins.php
2024_02_20_081321_add_cover_columns_to_users.php
2024_02_27_134104_add_defaults_to_banchostats.php
2024_03_12_110401_create_user_cover_presets.php
2024_03_14_111139_remove_cover_json_from_user_profile_customizations.php
2024_04_04_063204_score_pins_new_index.php
2024_04_25_153450_add_block_and_whitespace_delimited_to_chat_filters.php
2024_05_09_082011_create_daily_challenge_queue.php
2024_05_17_000001_add_eligible_main_rulesets_to_beatmapsets.php
2024_05_31_062552_add_lookup_index_to_daily_challenge_queue.php
2024_06_09_091512_add_recent_score_index.php
2024_06_11_063126_drop_unique_user_reports.php
2024_06_14_093636_unique_score_pins_score_id.php
2024_06_14_105907_clean_up_score_pins.php
2024_07_02_000001_create_beatmap_owners.php
2024_07_09_074020_create_daily_challenge_user_stats.php
2024_07_26_100752_add_last_percentile_calculation_to_daily_challenge_user_stats.php
2024_08_06_071309_adjust_daily_challenge_user_stats_defaults.php
2024_09_24_000001_create_store_paypal_banned.php
2024_10_04_082317_create_score_replay_stats.php
2024_11_06_074123_create_tournament_banners.php
2024_11_19_130731_create_beatmap_versioning_tables.php
2024_11_22_092704_add_status_to_multiplayer_rooms.php
2024_11_26_093900_create_tags_table.php
2024_11_26_093901_create_beatmap_tags_table.php
2024_11_30_000000_create_teams.php
2024_11_30_000001_create_team_members.php
2024_12_03_102822_add_synthetic_pk_to_beatmapset_version_files.php
2025_01_06_000000_create_osu_logins.php
2025_01_16_000000_add_freestyle_to_multiplayer_playlist_items.php
2025_01_22_134746_add_unique_index_to_room_id_on_season_rooms.php
2025_01_22_172229_add_score_factors_on_seasons.php
2025_01_22_174650_add_group_indicator_on_season_rooms.php
2025_01_22_190453_create_user_season_score_aggregates_table.php