0
0
Fork 0
mirror of https://github.com/discourse/discourse.git synced 2026-08-05 18:46:18 +08:00
discourse/db/migrate
Krzysztof Kotlarek bf8d011bdd
FEATURE: Reclassify likely crawlers in site traffic reporting (#42199)
Previously, CrawlerScorer wrote a score to every browser pageview event,
but nothing consumed it, so the site traffic chart still counted
automated sessions as logged-in or anonymous humans and overstated
community traffic.

Classify events scoring above CrawlerScorer::BOT_SCORE_THRESHOLD, as
likely crawlers. Their daily counts are rolled up per logged-in state
into a new browser_pageview_crawler_daily_rollups table, subtracted from
the logged-in and anonymous series, and shown as their own "Likely
crawlers" series ahead of the known-crawler one.

All of this sits behind the new improved_crawler_detection upcoming
change, which also replaces experimental_detect_crawler_pageviews as the
gate on scoring. The rollup job backfills all existing history on its
first run, then refreshes yesterday and today. Disabling the change
restores the original counters and hides the series while leaving the
rollups in place, so re-enabling takes effect without a backfill.

<img width="993" height="755" alt="Screenshot 2026-07-31 at 12 22 13 pm"
src="https://github.com/user-attachments/assets/6163b731-c2ba-4e53-8cc7-4eba78f4190d"
/>
2026-08-04 10:08:53 +08:00
..
20000225050318_add_schema_migration_details.rb
20120311163914_create_forum_threads.rb
20120311164326_create_posts.rb
20120311170118_create_users.rb
20120311201341_create_forums.rb
20120311210245_create_sites.rb
20120416201606_add_reply_to_to_posts.rb
20120420183447_add_views_to_forum_threads.rb
20120423140906_add_posts_count_to_forum_threads.rb
20120423142820_fix_post_indices.rb
20120423151548_remove_last_post_id.rb
20120425145456_add_display_username_to_users.rb
20120427150624_add_user_id_index_to_posts.rb
20120427151452_cooked_migration.rb
20120427154330_create_vestal_versions.rb
20120427172031_add_version_to_posts.rb
20120502183240_add_created_by_to_forum_threads.rb
20120502192121_add_last_post_user_id_to_forum_threads.rb
20120503205521_add_site_id_to_users.rb
20120507144132_create_expressions.rb
20120507144222_create_expression_types.rb
20120514144549_add_reply_count_to_posts.rb
20120514173920_add_flag_to_expression_types.rb
20120514204934_add_description_to_expression_types.rb
20120517200130_add_quoteless_to_post.rb
20120518200115_create_read_posts.rb
20120519182212_create_last_read_posts.rb
20120523180723_create_views.rb
20120523184307_add_replies_to_forum_threads.rb
20120523201329_add_featured_to_forum_threads.rb
20120525194845_add_avg_time_to_forum_threads.rb
20120529175956_create_uploads.rb
20120529202707_create_stars.rb
20120530150726_create_forum_thread_user.rb
20120530160745_migrate_posted.rb
20120530200724_add_index_to_forum_threads.rb
20120530212912_create_forum_thread_links.rb
20120614190726_add_tags_to_forum_threads.rb
20120614202024_add_quote_count_to_posts.rb
20120615180517_create_bookmarks.rb
20120618152946_add_reply_below_to_posts.rb
20120618212349_create_post_timings.rb
20120618214856_create_message_bus.rb
20120619150807_fix_post_timings.rb
20120619153349_drop_read_posts.rb
20120619172714_add_post_number_to_bookmarks.rb
20120621155351_add_seen_post_count_to_forum_thread_users.rb
20120621190310_add_deleted_at_to_forum_threads.rb
20120622200242_create_notifications.rb
20120625145714_add_seen_notification_id_to_users.rb
20120625162318_add_deleted_at_to_posts.rb
20120625174544_add_highest_post_number_to_forum_threads.rb
20120625195326_add_image_url_to_forum_threads.rb
20120629143908_rename_expression_type_id.rb
20120629150253_denormalize_expressions.rb
20120629151243_make_expressions_less_generic.rb
20120629182637_create_incoming_links.rb
20120702211427_create_replies.rb
20120703184734_add_reflection_to_forum_thread_links.rb
20120703201312_add_incoming_link_count_to_posts.rb
20120703203623_add_incoming_link_count_to_forum_threads.rb
20120703210004_add_bookmark_count_to_posts.rb
20120704160659_add_avg_time_to_posts.rb
20120704201743_add_view_count_to_posts.rb
20120705181724_add_user_to_versions.rb
20120708210305_add_last_posted_at_to_users.rb
20120712150500_create_categories.rb
20120712151934_add_category_id_to_forum_threads.rb
20120713201324_create_category_featured_threads.rb
20120716020835_create_site_settings.rb
20120716173544_add_stats_to_categories.rb
20120718044955_create_user_open_ids.rb
20120719004636_add_email_hashed_password_name_salt_to_users.rb
20120720013733_add_username_lower_to_users.rb
20120720044246_add_auth_token_to_users.rb
20120720162422_add_forum_id_to_categories.rb
20120723051512_add_not_nulls_to_user_open_ids.rb
20120724234502_add_last_seen_at_to_users.rb
20120724234711_add_website_to_users.rb
20120725183347_add_excerpt_to_categories.rb
20120726201830_add_invisible_to_forum_thread.rb
20120726235129_add_user_id_to_categories.rb
20120727005556_remove_excerpt_from_categories.rb
20120727150428_rename_invisible.rb
20120727213543_add_thread_counts_to_categories.rb
20120802151210_add_icon_to_expression_types.rb
20120803191426_add_admin_flag_to_users.rb
20120806030641_add_new_password_new_salt_email_token_to_users.rb
20120806062617_remove_new_password_stuff_from_user.rb
20120807223020_create_actions.rb
20120809020415_remove_site_id.rb
20120809030647_remove_forum_id.rb
20120809053414_correct_indexing_on_posts.rb
20120809154750_remove_index_for_now.rb
20120809174649_create_post_actions.rb
20120809175110_create_post_action_types.rb
20120809201855_migrate_bookmarks_to_post_actions.rb
20120810064839_rename_actions_to_user_actions.rb
20120812235417_retire_expressions.rb
20120813004347_rename_expression_columns_in_forum_thread.rb
20120813042912_rename_expression_columns_in_posts.rb
20120813201426_create_forum_thread_link_clicks.rb
20120815004411_add_unique_index_to_forum_thread_links.rb
20120815180106_add_post_type_to_posts.rb
20120815204733_add_moderator_posts_count_to_forum_threads.rb
20120816050526_add_unique_constraint_to_user_actions.rb
20120816205537_add_forum_thread_states.rb
20120816205538_add_starred_at_to_forum_thread_user.rb
20120820191804_add_search_indices.rb
20120821191616_add_bumped_at_to_forum_threads.rb
20120823205956_add_slug_to_categories.rb
20120824171908_create_category_featured_users.rb
20120828204209_create_onebox_renders.rb
20120828204624_create_post_onebox_renders.rb
20120830182736_add_preview_to_onebox_renders.rb
20120910171504_remove_description_from_site_settings.rb
20120918152319_rename_views_to_reads.rb
20120918205931_add_sub_tag_to_forum_threads.rb
20120919152846_add_has_best_of_to_forum_threads.rb
20120921055428_add_twitter_user_info.rb
20120921155050_create_archetypes.rb
20120921162512_add_meta_data_to_forum_threads.rb
20120921163606_create_archetype_options.rb
20120924182000_add_hstore_extension.rb
20120924182031_add_vote_count_to_posts.rb
20120925171620_remove_english_from_post_action_types.rb
20120925190802_add_sequence_to_post_action_types.rb
20120928170023_add_sort_order_to_posts.rb
20121009161116_add_email_stuff_to_users.rb
20121011155904_create_email_logs.rb
20121017162924_convert_archetypes.rb
20121018103721_rename_forum_thread_tables.rb
20121018133039_create_topic_allowed_users.rb
20121018182709_fix_notification_data.rb
20121106015500_drop_avatar_url_from_users.rb
20121108193516_add_post_action_id_to_notifications.rb
20121109164630_create_trust_levels.rb
20121113200844_bio_markdown_support.rb
20121113200845_create_facebook_user_infos.rb
20121115172544_rename_sticky_to_pinned.rb
20121116212424_add_more_email_settings_to_user.rb
20121119190529_add_email_settings_to_users.rb
20121119200843_add_email_direct_to_users.rb
20121121202035_create_invites.rb
20121121205215_create_topic_invites.rb
20121122033316_add_muted_at_to_topic_user.rb
20121123054127_make_post_number_distinct.rb
20121123063630_create_user_visits.rb
20121129160035_create_email_tokens.rb
20121129184948_remove_email_token_from_users.rb
20121130010400_create_drafts.rb
20121130191818_add_link_post_id_to_topic_links.rb
20121202225421_add_visited_at_to_topic_user.rb
20121203181719_rename_seen_notificaiton_id.rb
20121204183855_fix_link_post_id.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20121204193747_add_another_featured_user_to_topics.rb
20121205162143_add_approved_to_users.rb
20121207000741_add_notifications_to_topic_users.rb
20121211233131_create_site_customizations.rb
20121216230719_add_override_default_style_to_site_customization.rb
20121218205642_add_topics_entered_to_users.rb
20121224072204_add_last_editor_id_to_posts.rb
20121224095139_create_draft_sequence.rb
20121224100650_add_sequence_to_drafts.rb
20121228192219_add_deleted_at_to_invites.rb
20130107165207_add_digest_after_days_to_users.rb
20130108195847_add_previous_visit_at_to_users.rb
20130115012140_merge_mute_options_on_topic_users.rb
20130115021937_correct_default_on_notification_level.rb
20130115043603_oops_unwatch_a_boat_of_watched_stuff.rb
20130116151829_remove_sub_tag_from_topics.rb
20130120222728_fix_search.rb
20130121231352_add_tracking_to_topic_users.rb
20130122051134_add_auto_track_topics_to_user.rb
20130122232825_add_auto_track_after_seconds_and_banning_and_dob_to_user.rb
20130123070909_auto_track_all_topics_replied_to.rb
20130125002652_add_hidden_to_posts.rb
20130125030305_add_fields_to_post_action.rb
20130125031122_correct_index_on_post_action.rb
20130127213646_remove_trust_levels.rb
20130128182013_trust_level_default_null.rb
20130129010625_remove_pm_reflections.rb
20130129163244_add_time_read_to_users.rb
20130129174845_add_days_visited_to_users.rb
20130130154611_remove_index_from_views.rb
20130131055710_add_custom_flag_count_to_topics.rb
20130201000828_add_column_summaries_to_posts_and_topics.rb
20130201023409_add_position_to_post_action_type.rb
20130203204338_add_last_version_at_to_posts.rb
20130204000159_add_ip_address_to_users.rb
20130205021905_alter_facebook_user_id.rb
20130207200019_add_user_deleted_to_posts.rb
20130208220635_remove_reply_below_post_number_from_posts.rb
20130213021450_remove_topic_response_actions.rb
20130213203300_add_new_topic_duration_minutes_to_users.rb
20130221215017_add_description_to_categories.rb
20130226015336_add_github_user_info.rb
20130306180148_add_cleared_pinned_to_topic_users.rb
20130311181327_remove_extra_spam_record.rb
20130313004922_add_external_links_in_new_tab_an_disable_quoting_to_user.rb
20130314093434_add_foreground_color_to_categories.rb
20130315180637_enable_trigram_support.rb
20130319122248_add_reply_to_user_id_to_post.rb
20130320012100_add_user_indexes_to_posts_and_topics.rb
20130320024345_add_moderator_to_user.rb
20130321154905_remove_oneboxes_from_db.rb
20130322183614_add_percent_rank_to_posts.rb
20130326210101_add_hotness_to_category.rb
20130327185852_update_site_settings_for_hot.rb
20130328162943_create_hot_topics.rb
20130328182433_add_score_to_topics.rb
20130402210723_add_values_to_hot_topics.rb
20130404143437_create_site_contents.rb
20130404232558_add_user_extras.rb
20130411205132_create_admin_logs.rb
20130412015502_correct_counts_on_posts.rb
20130412020156_correct_counts_on_topics.rb
20130416004607_create_groups.rb
20130416004933_group_users.rb
20130416170855_add_subtype_to_topics.rb
20130419195746_increase_data_length_on_notifications.rb
20130422050626_add_related_post_id_to_post_actions.rb
20130424015746_add_slug_to_topics.rb
20130424055025_add_user_id_to_incoming_links.rb
20130426044914_allow_nulls_in_incoming_links.rb
20130426052257_add_incoming_ip_current_user_id_to_incoming_links.rb
20130428194335_add_unstarred_at_to_topic_users.rb
20130429000101_add_security_to_categories.rb
20130430052751_add_topic_allowed_groups.rb
20130501105651_fix_topic_allowed_groups.rb
20130506020935_add_automatic_to_groups.rb
20130506185042_add_auto_close_at_to_topics.rb
20130508040235_add_user_count_to_groups.rb
20130509040248_update_sequence_for_groups.rb
20130509041351_add_unique_name_to_groups.rb
20130515193551_add_auto_close_days_to_categories.rb
20130521210140_create_cas_user_infos.rb
20130522193615_rename_search_tables.rb
20130527152648_add_like_score_to_posts.rb
20130528174147_add_rank_to_category_featured_topics.rb
20130531210816_add_staff_took_action_to_post_actions.rb
20130603192412_add_blocked_to_users.rb
20130606190601_add_auto_close_started_at_to_topics.rb
20130610201033_add_reply_key_to_email_logs.rb
20130612200846_create_post_upload_join_table.rb
20130613211700_drop_posts_uploads.rb
20130613212230_create_post_uploads.rb
20130615064344_add_dynamic_favicon_preference_to_user.rb
20130615073305_remove_topic_id_from_uploads.rb
20130615075557_add_sha_to_uploads.rb
20130616082327_create_optimized_images.rb
20130617014127_rename_sha_and_ext_columns.rb
20130617180009_rename_sha_column.rb
20130617181804_add_post_id_to_email_logs.rb
20130619063902_add_defer_to_post_actions.rb
20130621042855_change_supress_to_suppress.rb
20130622110348_add_url_index_to_uploads.rb
20130624203206_change_ip_to_inet_in_topic_link_clicks.rb
20130625022454_change_ip_to_inet_in_views.rb
20130625170842_remove_access_password.rb DEV: Enable Style/RedundantParentheses rubocop rule (#40095) 2026-05-19 15:48:09 +02:00
20130625201113_add_title_to_users.rb
20130709184941_add_deleted_by_id_to_posts.rb
20130710201248_add_nuked_user_to_posts.rb
20130712041133_add_permission_type_to_category_groups.rb
20130712163509_add_missing_id_columns.rb
20130723212758_rename_admin_log.rb
20130724201552_create_blocked_emails.rb
20130725213613_add_more_to_staff_action_log.rb
20130728172550_add_url_to_optimized_images.rb
20130731163035_add_report_index_to_incoming_links.rb
20130807202516_add_last_match_index_to_blocked_emails.rb
20130809160751_fix_seen_notification_ids.rb
20130809204732_add_filter_indexes_to_staff_action_logs.rb
20130809211409_add_avatar_to_users.rb
20130813204212_create_screened_urls.rb
20130813224817_rename_blocked_emails_to_screened_emails.rb
20130816024250_create_oauth2_user_infos.rb
20130819192358_add_value_columns_to_staff_action_logs.rb
20130820174431_add_subject_index_to_staff_action_logs.rb
20130822213513_add_ip_address_to_screening_tables.rb
20130823201420_drop_defaults_on_email_digest_columns_of_users.rb
20130826011521_create_plugin_store_rows.rb
20130828192526_fix_optimized_images_urls.rb
20130903154323_allow_null_user_id_on_posts.rb
20130904181208_allow_null_user_id_on_topics.rb
20130906081326_rename_system_username.rb
20130906171631_add_index_to_uploads.rb
20130910040235_index_topics_for_front_page.rb
20130910220317_rename_staff_action_logs_to_user_history.rb
20130911182437_create_user_stats.rb
20130912185218_acting_user_null.rb
20130913210454_add_mobile_to_site_customizations.rb
20130917174738_add_topic_id_to_user_histories.rb
20131001060630_add_email_always_to_users.rb
20131002070347_add_user_id_parent_type_index_on_views.rb
20131003061137_move_columns_to_user_stats.rb
20131014203951_backfill_post_upload_reverse_index.rb
20131015131652_create_post_details.rb
20131017014509_add_post_count_to_categories.rb
20131017030605_add_latest_to_categories.rb
20131017205954_create_screened_ip_addresses.rb
20131018050738_add_position_to_categories.rb
20131022045114_add_uncategorized_category.rb DEV: Skip Uncategorized insert in add_uncategorized_category on fresh installs (#39971) 2026-05-13 12:13:05 +01:00
20131022151218_create_api_keys.rb
20131023163509_add_parent_category_id_to_categories.rb
20131105101051_add_origin_to_uploads.rb DEV: enable frozen string literal on all files 2019-05-13 09:31:32 +08:00
20131107154900_rename_banned_to_suspended.rb
20131114185225_add_participant_count_to_topics.rb
20131115165105_add_edit_reason_to_posts.rb
20131118173159_rename_best_of_to_summary.rb
20131120055018_move_emoji_to_new_location.rb
20131122064921_increase_twitter_user_id_length.rb
20131206200009_rename_auto_close_days_to_hours.rb
20131209091702_create_post_revisions.rb
20131209091742_create_topic_revisions.rb
20131210163702_add_word_count_to_posts.rb
20131210181901_migrate_word_counts.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20131210234530_rename_version_column.rb
20131212225511_add_post_count_stats_columns_to_categories.rb
20131216164557_make_position_nullable_in_categories.rb
20131217174004_create_topic_embeds.rb
20131219203905_add_cook_method_to_posts.rb
20131223171005_create_top_topics.rb DEV: Enable some minor rubocop rules (#40094) 2026-05-19 15:29:38 +02:00
20131227164338_add_scores_to_top_topics.rb DEV: Enable some minor rubocop rules (#40094) 2026-05-19 15:29:38 +02:00
20131229221725_add_watch_new_topics_to_users.rb
20131230010239_add_last_emailed_post_number_to_topic_user.rb
20140101235747_add_category_users.rb
20140102104229_add_alias_level_to_groups.rb
20140102194802_remove_default_from_external_links_in_new_tab.rb
20140107220141_remove_enable_wide_category_list.rb
20140109205940_rename_favorites_to_starred.rb
20140116170655_drop_hot_topics.rb
20140120155706_add_lounge_category.rb
20140121204628_add_invalidated_at_to_invites.rb
20140122043508_add_meta_category.rb
20140124202427_add_posts_read_to_user_visits.rb
20140129164541_remove_category_hotness.rb
20140206044818_add_locale_to_user.rb
20140206195001_add_defaults_to_category_posts_and_topics_fields.rb
20140206215029_add_mailing_list_mode_to_users.rb
20140210194146_add_primary_group_id_to_users.rb
20140211230222_move_cas_settings.rb
20140211234523_add_targets_topic_to_post_actions.rb
20140214151255_add_skipped_to_email_logs.rb
20140220160510_rename_site_settings.rb
20140220163213_rename_delete_user_max_age.rb
20140224232712_add_profile_background_to_user.rb
20140224232913_add_single_sign_on_records.rb
20140227104930_add_custom_email_in_to_categories.rb
20140227201005_add_staff_category.rb
20140228005443_add_external_username_to_single_sign_on_record.rb
20140228173431_add_external_email_and_external_name_to_single_sign_on_record.rb
20140228205743_add_admin_only_to_user_histories.rb
20140303185354_add_new_since_to_user_stats.rb
20140304200606_create_badge_types.rb
20140304201403_create_badges.rb
20140305100909_create_user_badges.rb
20140306223522_move_topic_revisions_to_post_revisions.rb
20140318150412_add_excerpt_to_topics.rb
20140318203559_add_created_at_index_to_posts.rb
20140320042653_facebook_user_infos_username_can_be_nil.rb
20140402201432_make_content_sha1_nullable.rb
20140404143501_add_title_to_topic_links.rb
20140407055830_add_pinned_globally_to_topics.rb
20140407202158_site_setting_comma_to_pipe.rb
20140408061512_add_wiki_to_posts.rb
20140408152401_add_default_value_to_top_topic_scores.rb DEV: Enable some minor rubocop rules (#40094) 2026-05-19 15:29:38 +02:00
20140415054717_allow_longer_usernames.rb
20140416202746_create_color_schemes.rb
20140416202801_create_color_scheme_colors.rb
20140416235757_remove_color_hexcode_from_badge_types.rb
20140421235646_add_user_custom_fields.rb
20140422195623_add_visibile_to_groups.rb
20140425125742_add_custom_fields.rb
20140425135354_add_topic_custom_fields.rb
20140425172618_add_titleable_to_badges.rb
20140429175951_add_registration_ip_address_to_users.rb
20140504174212_increment_reserved_trust_level_badge_ids.rb
20140505145918_add_last_redirected_to_top_at_to_users.rb
20140506200235_remove_seed_color_scheme.rb
20140507173327_remove_opacity_from_color_scheme_colors.rb
20140508053815_add_invited_groups.rb
20140515220111_init_fixed_category_positions_value.rb
20140520062826_add_multiple_award_to_badges.rb
20140520063859_remove_has_custom_avatar_from_user_stats.rb
20140521192142_create_google_user_infos.rb
20140521220115_google_openid_default_has_changed.rb
20140522003151_add_user_avatars.rb
20140525233953_remove_uploaded_avatar_template_from_users.rb
20140526185749_change_category_uniquness_contstraint.rb
20140526201939_add_disable_jump_reply_to_users.rb
20140527163207_create_user_profiles.rb
20140527233225_add_system_savatar_version_to_user_avatars.rb
20140528015354_add_baked_at_to_posts.rb
20140529045508_remove_use_uploaded_avatar_from_user.rb
20140530002535_remove_system_avatars_from_user_avatars.rb DEV: fix a large amount of typos (#37428) 2026-02-02 16:31:58 +11:00
20140530043913_add_baked_version_to_post.rb
20140604145431_disable_external_auths_by_default.rb
20140607035234_add_website_to_user_profiles.rb
20140610012414_add_post_id_to_user_badges.rb
20140610012833_add_icon_to_badges.rb
20140610034314_move_bio_to_user_profiles.rb
20140612010718_move_profile_background_to_user_profiles.rb
20140617053829_add_notification_id_to_user_badge.rb
20140617080955_rename_registered_users.rb
20140617193351_add_post_id_index_on_topic_links.rb
20140618001820_dont_auto_muto_topics.rb
20140618163511_add_dismissed_banner_key_to_user_profile.rb
20140620184031_add_hidden_at_to_posts.rb
20140623195618_fix_categories_constraint.rb
20140624044600_add_raw_data_to_search.rb
20140627193814_add_images_to_categories.rb
20140703022838_add_fields_to_badges.rb
20140705081453_index_user_badges.rb
20140707071913_add_self_edits_to_posts.rb
20140710005023_add_badge_posts_and_topics_view.rb
20140710224658_add_is_quote_to_topic_links.rb
20140711063215_add_read_faq_to_user_stats.rb
20140711143146_remove_not_null_from_email.rb
20140711193923_remove_email_in_address_setting.rb
20140711233329_badges_only_on_public_categories.rb
20140714060646_add_enabled_to_badges.rb
20140715013018_correct_post_number_index.rb
20140715051412_add_auto_revoke_to_badges.rb
20140715055242_add_quoted_posts.rb
20140715160720_update_users_case_insensitive_emails.rb
20140715190552_remove_uncategorized_parents.rb DEV: Skip Uncategorized insert in add_uncategorized_category on fresh installs (#39971) 2026-05-13 12:13:05 +01:00
20140716063802_add_badge_groupings.rb
20140717024528_description_optional_in_badge_grouping.rb
20140718041445_set_default_badge_grouping.rb
20140721063820_add_trigger_to_badges.rb
20140721161249_add_agreed_at_and_agreed_by_id_to_post_action.rb
20140721162307_rename_defer_columns_on_post_action.rb
20140723011456_add_show_posts_to_badges.rb
20140725050636_remove_invalid_incoming_links.rb
20140725172830_remove_message_from_post_action.rb
20140727030954_add_edit_history_public_to_users.rb
20140728120708_fix_index_on_post_action.rb
20140728144308_add_first_post_created_at_to_user_stat.rb
20140728152804_add_post_and_topic_counts_to_user_stat.rb
20140729092525_remove_unique_constraint_from_invites_index.rb
20140730203029_add_disagreed_at_and_disagreed_by_id_to_post_action.rb
20140731011328_add_reply_quoted_to_posts.rb
20140801052028_fix_incoming_links.rb
20140801170444_create_post_timings_user_index.rb
20140804010803_incoming_link_normalization.rb
20140804030041_remove_url_from_incoming_referer.rb
20140804060439_drop_topic_id_from_incoming_links.rb
20140804072504_views_to_topic_views.rb
20140804075613_normalize_topic_view_data_and_index.rb
20140805061612_add_bio_cooked_version_to_user_profile.rb
20140806003116_fixup_badge_ids.rb
20140807033123_add_index_on_last_seen_to_users.rb
20140808051823_create_topic_search_index.rb
20140809224243_add_user_badge_unique_index.rb
20140811094300_rename_defered_columns_on_post_action.rb
20140813175357_add_default_to_active.rb
20140815183851_fix_index_on_post_actions.rb
20140815191556_fix_post_actions_index_again.rb
20140815215618_add_name_lower_to_categories.rb
20140817011612_add_external_avatar_url_to_single_sign_on_record.rb
20140818023700_index_email_tokens.rb
20140826234625_rename_settings_pop3s_to_pop3.rb
20140827044811_remove_nullable_dates.rb
20140828172407_create_permalinks.rb
20140828200231_make_url_col_bigger_in_permalinks.rb
20140831191346_remove_category_groups_orphaned_by_removing_category_or_group.rb
20140904055702_correct_post_action_index.rb
20140904160015_add_via_email_to_posts.rb
20140904215629_rename_trust_level_settings.rb
20140905055251_rename_trust_level_badges.rb
20140905171733_create_warnings.rb
20140908165716_migrate_warning_topic_subtypes.rb
20140908191429_trim_profile_length.rb
20140910130155_create_topic_user_index.rb
20140911065449_private_messages_have_no_category_id.rb
20140913192733_add_trust_level_locked_column.rb
20140923042349_add_retain_hours_to_uploads.rb
20140924192418_rename_content_type.rb
20140925173220_create_user_fields.rb
20140929181930_add_editable_to_user_fields.rb
20140929204155_migrate_tos_setting.rb
20141001101041_add_post_id_to_user_histories.rb
20141002181613_add_description_to_user_fields.rb
20141007224814_add_badge_granted_title_to_user_profile.rb
20141008152953_add_exernal_url_to_permalinks.rb
20141008181228_add_required_signup_to_user_fields.rb
20141008192525_add_auto_close_based_on_last_post_and_auto_close_hours_to_topics.rb
20141008192526_add_auto_close_based_on_last_post_to_categories.rb
20141014032859_add_hidden_to_post_revision.rb
20141014191645_fix_tos_name.rb
20141015060145_add_raw_email_to_posts.rb
20141016183307_add_expansion_background_to_user_profiles.rb
20141020153415_add_public_version_to_posts.rb
20141020154935_rename_expansion_to_card.rb
20141020164816_add_image_to_badges.rb
20141020174120_add_card_image_to_user_profiles.rb
20141030222425_rename_seen_post_count.rb
20141110150304_add_footer_to_site_customization.rb
20141118011735_correct_username_search.rb
20141120035016_add_allowed_ips_to_api_keys.rb
20141120043401_add_hidden_to_api_keys.rb
20141211114517_fix_emoji_path.rb
20141222051622_remove_override_default_styles_from_site_customizations.rb
20141222224220_fix_emoji_path_take2.rb
20141222230707_amend_site_customization.rb
20141223145058_create_csv_export_logs.rb
20141228151019_rename_csv_export_logs_to_user_exports.rb
20150102113309_clean_up_user_history.rb
20150106215342_remove_stars.rb
20150108002354_add_liked_and_bookmarked_to_topic_user.rb
20150108202057_create_bookmark_actions.rb
20150108211557_index_topic_custom_field_values.rb
20150108221703_group_managers.rb
20150112172258_add_new_site_customization_types.rb
20150112172259_migrate_site_text_to_site_customization.rb
20150114093325_add_top_to_site_customization.rb
20150115172310_rename_user_export_column.rb
20150119192813_add_posts_index_including_deleted.rb
20150123145128_add_automatic_membership_to_group.rb
20150129204520_add_show_on_profile_to_user_fields.rb
20150203041207_add_application_requests.rb
20150205032808_reset_application_requests.rb
20150205172051_add_custom_type_to_user_histories.rb
20150206004143_flush_application_requests.rb
20150213174159_create_digest_unsubscribe_keys.rb
20150224004420_add_pinned_indexes.rb
20150227043622_add_long_description_to_badges.rb
20150301224250_create_suggested_for_index.rb
20150306050437_add_all_time_and_op_likes_to_top_topics.rb
20150318143915_create_directory_items.rb
20150323034933_add_allow_private_messages_to_user_profile.rb
20150323062322_remove_allow_private_messages_from_user_profile.rb
20150323234856_add_muted_users.rb
20150324184222_add_more_to_directory_items.rb
20150325183400_fix_group_user_count.rb
20150325190959_create_queued_posts.rb
20150410002033_add_primary_group_to_groups.rb
20150410002551_add_title_to_groups.rb
20150421085850_increase_url_length_on_topic_embed.rb
20150421190714_add_queued_post_id_to_user_actions.rb
20150422160235_add_link_post_id_index_on_topic_links.rb
20150505044154_add_stylesheet_cache.rb
20150513094042_add_index_on_post_actions.rb
20150514023016_add_unread_notifications_index.rb
20150514043155_add_user_actions_all_index.rb
20150525151759_set_default_s3_region.rb
20150609163211_migrate_embeddable_host.rb
20150617080349_add_index_on_post_notifications.rb
20150617233018_add_index_target_post_id_on_user_actions.rb
20150617234511_add_staff_index_to_users.rb
20150702201926_add_topic_template_to_categories.rb
20150706215111_add_mobile_to_user_visits.rb
20150707163251_add_reports_index_to_user_visits.rb
20150709021818_add_like_count_to_post_menu.rb
20150713203955_enlarge_users_email_field.rb
20150724165259_add_index_to_post_custom_fields.rb
20150724182342_add_action_code_to_post.rb
20150727193414_create_user_field_options.rb
20150727210019_add_pinned_until_to_topics.rb
20150727210748_add_quarterly_to_top_topics.rb
20150727230537_add_example_column_comments.rb
20150728004647_correct_custom_fields_migration.rb
20150728210202_migrate_old_moderator_posts.rb
20150729150523_migrate_auto_close_posts.rb
20150730154830_add_position_to_user_fields.rb
20150731225331_migrate_old_moved_posts.rb
20150802233112_add_post_stats.rb
20150806210727_add_embedded_css_to_site_customizations.rb
20150818190757_create_embeddable_hosts.rb DEV: Skip Uncategorized insert in add_uncategorized_category on fresh installs (#39971) 2026-05-13 12:13:05 +01:00
20150822141540_fix_migrated_hosts.rb
20150828155137_add_suppress_from_homepage_to_category.rb
20150901192313_add_grant_trust_level_to_groups.rb
20150914021445_create_user_profile_views.rb
20150914034541_add_views_to_user_profile.rb
20150917071017_add_category_id_to_user_histories.rb
20150918004206_add_user_id_group_id_index_to_group_users.rb
20150924022040_add_fancy_title_to_topic.rb
20150925000915_exclude_whispers_from_badges.rb
20151103233815_add_lower_title_index_on_topics.rb
20151105181635_add_staged_to_user.rb
20151107041044_fix_incorrect_topic_creator_after_move.rb
20151107042241_add_owner_to_group_users.rb
20151109124147_drop_group_managers.rb
20151113205046_create_translation_overrides.rb
20151117165756_add_automatically_unpin_topics_to_users.rb
20151124172631_add_is_support_to_categories.rb
20151124192339_rename_ninja_edit.rb
20151125194322_remove_site_text.rb
20151126173356_rename_is_support_to_contains_messages.rb
20151126233623_add_baked_head_and_body_to_site_customizations.rb
20151127011837_add_header_and_footer_baked_to_site_customizations.rb
20151201035631_add_group_mentions.rb
20151201161726_add_incoming_email_to_groups.rb
20151214165852_add_notification_level_to_group_users.rb
20151218232200_add_unique_index_to_category_users.rb
20151219045559_add_has_messages_to_groups.rb
20151220232725_add_user_archived_messages_group_archived_messages.rb
20160108051129_fix_incorrect_user_history.rb
20160110053003_archive_system_messages_with_no_replies.rb
20160112025852_remove_users_from_topic_allowed_users.rb
20160112101818_remove_contains_message_on_category.rb
20160112104733_add_contains_messages_back_to_categories.rb
20160113160742_create_incoming_emails.rb
20160118174335_rebake_html_customizations.rb
20160118233631_backfill_incoming_emails.rb
20160127105314_change_default_notification_level_on_groups.rb
20160127222802_migrate_uncategorized_description_setting.rb
20160201181320_fix_email_logs.rb
20160206210202_remove_invalid_websites.rb
20160215075528_add_unread_pm_index_to_notifications.rb
20160224033122_create_instagram_user_infos.rb
20160225050317_add_user_options.rb
20160225050318_allow_defaults_on_users_table.rb
20160225050319_move_tracking_options_to_user_options.rb
20160225050320_add_email_previous_replies_to_user_options.rb
20160225095306_add_email_in_reply_to_to_user_options.rb
20160302063432_rebuild_directory_item_with_index.rb
20160302104253_add_like_notification_frequency_to_user_options.rb
20160302170230_rename_digest_after_days_to_digest_after_minutes.rb
20160303183607_clear_common_passwords_cache.rb
20160303234317_add_rejection_message_to_incoming_email.rb
20160307190919_create_email_change_requests.rb
20160308193142_rename_confirm_translation_key.rb
20160309073132_add_mailing_list_mode_frequency.rb
20160317174357_create_given_daily_likes.rb
20160317201955_add_include_tl0_in_digests_to_user_options.rb
20160326001747_add_user_first_visit.rb
20160329101122_remove_wiki_color.rb
20160405172827_create_user_firsts.rb
20160407160756_remove_user_firsts.rb
20160407180149_create_onceoff_logs.rb
20160408131959_add_show_on_user_card_to_user_fields.rb
20160408175727_add_compiled_js_to_translation_overrides.rb
20160418065403_add_bounce_key_to_email_log.rb
20160420172330_add_is_auto_generated_to_incoming_emails.rb
20160425141954_fix_incoming_emails_indices.rb
20160427202222_add_support_for_bounced_emails.rb
20160503205953_create_tags.rb
20160514100852_remove_invalid_topic_user.rb
20160520022627_shorten_topic_custom_fields_index.rb
20160527015355_correct_mailing_list_mode_frequency.rb
20160527191614_create_category_tags.rb
20160530003739_create_scheduler_stats.rb
20160530203810_add_message_id_to_email_logs.rb
20160602164008_create_tag_groups.rb
20160606204319_create_category_tag_groups.rb
20160607213656_add_tag_group_options.rb
20160609203508_remove_tag_count_from_tag_groups.rb
20160615024524_rename_digest_unsbscribe_keys.rb
20160615165447_rename_num_flags_to_block_new_user.rb
20160627104436_use_https_name_change_in_site_settings.rb
20160707195549_add_compiler_version_to_site_customizations.rb
20160716112354_remove_edit_history_public.rb
20160719002225_add_deleted_post_index_to_posts.rb
20160722071221_add_auth_token_created_at_to_users.rb
20160725015749_rename_auth_token_created_at.rb
20160727233044_create_developers_table.rb
20160815002002_add_user_api_keys.rb
20160815210156_add_flair_url_to_groups.rb
20160816052836_user_api_client_id_is_unique.rb
20160816063534_add_revoked_at_to_user_api_keys.rb
20160823171911_add_path_whitelist_to_embeddable_hosts.rb
20160826195018_add_flair_color_to_groups.rb
20160905082217_create_web_hook_event_types.rb
20160905082248_create_web_hooks.rb
20160905084502_create_web_hook_events.rb
20160905085445_create_join_table_web_hooks_web_hook_event_types.rb
20160905091958_create_join_table_web_hooks_groups.rb
20160905092148_create_join_table_web_hooks_categories.rb
20160906200439_add_via_wizard_to_color_schemes.rb
20160919003141_add_avatar_url_to_facebook_info.rb
20160919054014_add_fields_to_facebook_user_info.rb
20160920165833_add_moderator_to_invites.rb
20160930123330_add_notification_level_when_replying.rb
20161010230853_single_sign_on_increase_external_avatar_url.rb
20161013012136_add_scopes_to_user_api_keys.rb
20161014171034_add_directory_items_indexes.rb
20161025083648_fix_category_logo_and_background_urls.rb
20161029181306_add_image_url_to_posts.rb
20161031183811_add_sort_fields_to_categories.rb
20161102024700_add_post_uploads_indexes.rb
20161102024818_add_uploaded_avatar_id_index_to_users.rb
20161102024838_add_user_avatars_indexes.rb
20161102024900_add_user_profiles_indexes.rb
20161102024920_add_categories_indexes.rb
20161124020918_add_scores_indexes_to_top_topics.rb
20161202011139_add_whisper_support_to_topics.rb
20161202034856_add_uploads_to_categories.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20161205001727_add_topic_columns_back.rb
20161205065743_add_bio_to_groups.rb
20161207030057_add_public_to_groups.rb
20161208064834_create_group_histories.rb
20161212123649_add_allow_membership_requests_to_groups.rb
20161213073938_add_full_name_to_groups.rb
20161215201907_migrate_featured_link_fields.rb
20161216101352_add_all_topics_wiki_to_categories.rb
20170124181409_add_user_auth_tokens.rb
20170201085745_create_custom_emojis.rb
20170213180857_add_user_auth_token_log.rb
20170215151505_add_seen_at_to_user_auth_token.rb
20170221204204_add_show_subcategory_list_to_categories.rb DEV: Enable Style/RedundantParentheses rubocop rule (#40095) 2026-05-19 15:48:09 +02:00
20170222173036_make_user_auth_token_index_unique.rb
20170227211458_add_featured_topics_to_categories.rb
20170301215150_add_default_view_to_categories.rb
20170303070706_add_index_to_topic_view_items.rb
20170307181800_add_path_to_user_auth_token_log.rb
20170308201552_add_subcategory_list_style_to_categories.rb
20170313192741_add_themes.rb
20170322065911_create_topic_status_updates.rb
20170322155537_add_theme_to_stylesheet_cache.rb
20170322191305_add_default_top_period_to_categories.rb
20170324032913_move_auto_close_columns_to_topic_status_update.rb
20170324144456_amend_css_columns_in_theme.rb
20170328163918_break_up_themes_table.rb
20170328203122_add_compiler_version_to_theme_fields.rb
20170330041605_add_index_to_topic_status_updates.rb
20170403062717_add_category_id_to_topic_status_updates.rb
20170407154510_rename_theme_id.rb
20170410170923_add_theme_remote_fields.rb
20170413043152_rename_warnings.rb
20170417164715_add_theme_id_to_color_scheme.rb
20170419193714_add_error_to_theme_fields.rb
20170420163628_add_default_notification_level_to_group.rb
20170425083011_add_deleted_at_to_topic_embeds.rb
20170425172415_add_error_to_scheduler_stats.rb
20170501191912_add_upload_id_to_theme_fields.rb
20170505035229_migrate_mailing_list_daily_updates_users_to_daily_summary.rb
20170508183819_add_css_class_name_to_embeddable_hosts.rb
20170511071355_remove_convert_pasted_image_site_setting.rb
20170511080007_rename_convert_pasted_images_quality_site_setting.rb
20170511184842_rename_topic_status_updates_to_topic_timers.rb
20170512153318_add_theme_key_to_user_options.rb
20170512185227_create_topic_status_updates_again.rb
20170515152725_add_theme_key_seq_to_user_options.rb
20170515203721_add_public_type_to_topic_timers.rb
20170602132735_fix_group_allow_membership_requests.rb
20170605014820_remove_auto_close_columns_from_topics.rb
20170609115401_add_extension_to_topic_links.rb
20170628152322_create_watched_words.rb
20170630083540_add_custom_message_to_invite.rb
20170703115216_add_extension_to_uploads.rb
20170703144855_add_visibility_level_to_groups.rb
20170704142141_add_visible_back_to_groups.rb
20170713164357_create_search_logs.rb
20170717084947_create_user_emails.rb
20170725075535_correct_default_email_mailing_list_mode_frequency.rb
20170728012754_split_public_in_groups.rb
20170731075604_add_membership_request_template_to_groups.rb
20170803123704_add_version_to_search_data.rb
20170818191909_split_alias_levels.rb
20170823173427_create_tag_search_data.rb
20170824172615_add_slug_index_on_topic.rb
20170831180419_remove_whisper_topic_links.rb
20171003180951_rename_forgot_password_strict_setting.rb
20171006030028_add_allow_private_messages_to_user_options.rb
20171026014317_add_user_option_home.rb
20171110174413_rename_blocked_silence.rb
20171113175414_add_silenced_till_to_users.rb
20171113214725_add_time_read_to_user_visits.rb
20171115170858_add_mailinglist_mirror_to_categories.rb
20171123200157_add_trust_level_locks_to_users.rb
20171128172835_rename_clicked_topic_id_to_search_result_id.rb
20171213105921_replace_invite_mailer_translation_override.rb
20171214040346_add_email_to_twitter_user_info.rb
20171220181249_change_user_emails_primary_index.rb
20171228122834_replace_blocked_silence_translation.rb
20180109222722_create_user_second_factors.rb
20180111092141_add_indexes_to_email_logs.rb
20180118215249_create_theme_settings.rb
20180125185717_add_locked_by_to_posts.rb
20180127005644_remove_old_ga_site_settings.rb
20180131052859_rename_private_personal.rb
20180207161422_add_skipped_created_at_user_id_index_on_email_logs.rb
20180207163946_create_category_tag_stats.rb
20180221215641_add_suppress_from_latest_to_categories.rb
20180223041147_fix_google_oauth2_prompt_data_type.rb
20180223222415_remove_censored_pattern_site_setting.rb
20180308071922_drop_raise_read_only_function.rb
20180309014014_add_private_key_to_remote_theme.rb
20180316092939_add_external_profile_and_card_background_url_to_single_sign_on_record.rb
20180316165104_create_shared_drafts.rb
20180320190339_create_web_crawler_requests.rb
20180323154826_create_tag_group_permissions.rb
20180323161659_add_id_to_shared_drafts.rb
20180328180317_add_category_index_to_shared_drafts.rb
20180331125522_add_minimum_required_tags_to_categories.rb
20180419095326_add_upload_id_to_user_exports.rb
20180420141134_remove_staff_tags_setting.rb
20180425152503_drop_user_card_badge_columns.rb
20180425185749_create_push_subscription.rb
20180508142711_remove_invite_passthrough_hours.rb
20180514133440_add_pm_topic_count_to_tags.rb
20180519053933_delete_confirm_old_email_template_overrides.rb
20180521175611_change_indexes_topic_view_item.rb
20180521184439_allow_null_ip_search_log.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20180521190040_allow_null_ip_topic_link_click.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20180521191418_allow_null_ip_user_profile_view.rb
20180607095414_migrate_disable_emails.rb
20180621013807_add_index_topic_id_percent_rank_on_posts.rb
20180706054922_drop_key_column_from_themes.rb
20180710075119_add_index_topic_id_sort_order_on_posts.rb
20180710172959_disallow_multi_levels_theme_components.rb
20180716062012_add_index_user_id_on_user_second_factors.rb
20180716062405_add_navigate_to_first_post_after_read_to_categories.rb
20180716072125_alter_bounce_key_on_email_logs.rb
20180716140323_add_uniq_ip_or_user_id_topic_views.rb
20180716200103_add_theme_key_default.rb
20180717025038_drop_not_null_ip_address_on_topic_views.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20180717084758_alter_reply_key_on_email_logs.rb
20180718062728_create_post_reply_keys.rb
20180719103905_alter_indexes_on_email_logs.rb
20180720054856_create_skipped_email_logs.rb
20180724070554_drop_topic_id_on_email_logs.rb
20180727042448_drop_reply_key_skipped_skipped_reason_from_email_logs.rb
20180729092926_remove_track_external_right_clicks.rb
20180803085321_add_index_email_logs_on_bounced.rb
20180812150839_add_user_api_keys_last_used_at.rb
20180813074843_add_component_to_themes.rb
20180827053514_add_filesize_to_optimized_images.rb
20180828065005_change_bounce_score_to_float.rb
20180831182853_add_branch_to_remote_theme.rb
20180907075713_add_last_error_text_to_remote_themes.rb
20180913200027_remove_enforce_square_emoji.rb
20180916195601_migrate_s3_backup_site_settings.rb
20180917024729_remove_superfluous_columns.rb
20180917034056_remove_superfluous_tables.rb
20180920023559_add_external_details_to_user_fields.rb
20180920042415_create_user_uploads.rb
20180927135248_create_javascript_caches.rb
20180928105835_add_index_to_tags.rb
20181005084357_add_sso_provider_secrets_to_site_settings.rb
20181005144357_add_via_email_to_invites.rb
20181010150631_add_hide_profile_and_presence_to_user_options.rb
20181012123001_drop_group_locked_trust_level_from_user.rb
20181031165343_add_flag_stats_to_user.rb
20181108115009_create_user_associated_accounts.rb
20181112013117_migrate_url_site_settings.rb
20181120140552_migrate_corporate_site_settings.rb
20181128140547_migrate_facebook_user_info.rb
20181129094518_add_not_null_minimum_required_tags_on_categories.rb
20181204123042_add_uploaded_meta_id_to_categories.rb
20181204193426_create_join_table_web_hooks_tags.rb
20181207141900_migrate_twitter_user_info.rb
20181210122522_remove_not_null_user_associated_account_user.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20181218071253_add_etag_to_uploads.rb
20181220115844_add_smtp_and_imap_to_groups.rb
20181221121805_create_theme_translation_override.rb
20190103051737_add_version_to_optimized_images.rb
20190103060819_force_rebake_on_posts_with_images.rb
20190103065652_remove_uploaded_meta_id_from_category.rb
20190103160533_create_reviewables.rb
20190103185626_create_reviewable_users.rb
20190106041015_add_topic_id_index_to_user_histories.rb
20190108110630_add_text_size_key_to_user_options.rb
20190110201340_remove_google_plus_from_share_links_site_setting.rb
20190110212005_create_reviewable_histories.rb
20190111170824_migrate_reviewable_queued_posts.rb
20190111183409_add_imap_fields_to_incoming_emails.rb
20190117191606_create_group_requests.rb
20190121202656_remove_user_action_pending.rb
20190121203023_drop_queued_post_id_from_user_actions.rb
20190122132732_add_fields_to_remote_themes.rb
20190123171817_drop_queued_posts.rb
20190125103246_copy_login_required_welcome_message.rb
20190125153345_add_text_size_seq_to_user_option.rb
20190130013015_add_index_on_user_id_to_single_sign_on_records.rb
20190130163000_create_reviewable_scores.rb
20190130163001_migrate_reviewable_flagged_posts.rb
20190205104116_drop_unused_auth_tables.rb
20190208144706_drop_unused_auth_tables_again.rb
20190215204033_add_score_bonus_to_post_action_types.rb
20190225133654_add_ignored_users_table.rb
20190227150413_migrate_instagram_user_info.rb
20190227210035_add_missing_topic_id_site_settings.rb
20190304170931_migrate_uncategorized_category_name.rb
20190306154335_migrate_google_user_info.rb
20190306184409_add_reviewable_score_to_topics.rb
20190312181641_migrate_email_user_options.rb
20190312194528_drop_email_user_options_columns.rb
20190313134642_migrate_default_user_email_options.rb
20190313171338_add_indexes_to_reviewables.rb
20190313205652_rename_moderator_site_settings.rb
20190314082018_add_search_priority_to_categories.rb
20190314144755_add_summarized_at_column_to_ignored_users_table.rb
20190315170411_add_index_to_reviewable_histories.rb
20190315174428_migrate_flag_history.rb
20190320091323_add_index_post_action_type_id_disagreed_at_on_post_actions.rb
20190320104640_remove_s3_force_path_style.rb
20190321072029_add_index_method_enabled_on_user_second_factors.rb
20190322152347_force_rebake_on_posts_with_lightboxes.rb
20190325162154_make_site_settings_unique.rb
20190326123708_add_index_created_at_on_search_logs.rb
20190327090918_add_expiring_at_column_to_ignored_users_table.rb
20190327205525_require_reviewable_scores.rb
20190402024053_add_first_unread_at_to_user_stats.rb
20190402142223_disable_invite_only_sso.rb
20190403180142_add_allow_global_tags_to_categories.rb
20190403202001_fix_reviewable_users.rb
20190405044140_add_index_action_type_created_at_on_user_actions.rb
20190408072550_add_index_id_baked_version_on_posts.rb
20190408082101_add_search_data_indexes.rb
20190409054736_add_index_for_rebake_old_on_posts.rb
20190410055459_add_index_reply_id_on_post_replies.rb
20190410102915_remove_ignore_user_enabled_site_setting.rb
20190410122835_add_missing_uploads_index_to_post_custom_fields.rb
20190411121312_add_title_count_mode_to_user_options.rb
20190411144545_add_reason_to_reviewable_scores.rb
20190412161430_add_created_by_index_to_reviewables.rb
20190414162753_rename_post_notices.rb
20190417135049_migrate_native_app_banner_site_setting.rb
20190417203622_add_review_group_to_category.rb
20190418113814_add_unique_index_to_group_requests.rb
20190423112954_increase_theme_field_name_length.rb
20190424065841_add_post_image_indexes.rb
20190426011148_add_upload_foreign_keys_to_user_profiles.rb
20190426074404_add_missing_user_destroyer_indexes.rb
20190426123026_add_incoming_email_by_user_id_index.rb
20190426123658_add_index_on_user_auth_token_user.rb
20190427211829_add_name_to_user_second_factors.rb
20190430135846_migrate_english_locale.rb
20190502223613_add_bounce_key_index_on_email_logs.rb
20190503180839_remove_like_count_from_post_menu.rb
20190508135348_rename_site_setting_default_topics.rb
20190508141327_create_reviewable_claimed_topics.rb
20190508141824_drop_claimed_by_id.rb
20190508193900_add_missing_uploads_ignored_index_to_post_custom_fields.rb
20190513143015_add_theme_id_to_javascript_cache.rb
20190514055014_add_read_notification_index.rb
20190522194332_add_priority_to_post_action_types.rb
20190523093215_add_topic_id_to_user_exports.rb
20190529002752_add_unique_constraint_to_shadow_accounts.rb
20190531044744_add_enable_defer_to_user_options.rb
20190531101648_merge_remove_muted_tags_from_latest_site_settings.rb
20190603134013_change_theme_field_compiler_version.rb
20190621095105_remove_notification_level_from_category_user_indexes.rb
20190630165003_add_enabled_to_themes.rb
20190704133453_create_backup_metadata.rb
20190705173948_renumber_group_visibility_levels.rb
20190711154946_add_emailed_status_to_invite.rb
20190716014949_rename_deprecated_badge_icons.rb
20190716124050_remove_via_email_from_invite.rb
20190716173854_add_secure_to_uploads.rb
20190717133743_migrate_group_list_site_settings.rb
20190724162522_migrate_forwarded_emails_behaviour_site_settings.rb
20190731090219_rename_edit_notification_setting.rb
20190807194043_groups_publish_read_state.rb
20190812141433_add_members_visibility_level_to_groups.rb
20190820192341_create_topic_group_table.rb
20190903073730_add_last_used_at_to_api_key.rb
20190904104533_create_user_security_keys.rb
20190908233325_add_secure_identifier_column_to_users.rb
20190908234054_migrate_post_edit_time_limit.rb
20190917100006_add_enabled_index_to_user_security_key.rb
20191007140446_add_user_accuracy_bonus_to_reviewable_scores.rb
20191008124357_add_unique_index_categories_on_slug.rb
20191011131041_migrate_decompressed_file_max_size_mb.rb
20191016124059_fix_category_slugs_index.rb
20191017044811_add_draft_backup_tables.rb
20191022155215_add_index_to_oauth2_user_info.rb
20191022161944_add_index_on_group_to_category_groups.rb
20191025005204_amend_oauth2_user_info_index.rb
20191030112559_add_index_to_notifications.rb
20191030155530_add_required_tag_group_to_categories.rb
20191031042212_add_owner_to_drafts.rb
20191031052711_add_granted_title_badge_id_to_user_profile.rb
20191101001705_add_banner_index_to_topics.rb
20191101113230_add_revoked_at_to_api_key.rb DEV: Skip backfill INSERTs in old migrations on fresh installs (#39976) 2026-05-13 13:59:28 +01:00
20191107025041_add_last_seen_to_category_users.rb
20191107025140_add_index_to_last_seen_at_on_category_users.rb
20191107032231_change_notification_level.rb
20191107190330_remove_suppress_from_latest_from_category.rb
20191108000414_add_unique_index_to_drafts.rb
20191113193141_add_target_tag_id_to_tags.rb
20191120015344_add_timezone_to_user_options.rb
20191128222140_add_unique_index_to_developers.rb
20191129144706_drop_unused_google_instagram_auth_tables.rb
20191202202212_add_featured_topic_id_to_user_profiles.rb
20191205100434_create_standalone_bookmarks_table.rb
20191211152404_add_index_to_invites.rb
20191211170000_add_hashed_api_key.rb
20191217035630_populate_topic_id_on_bookmarks.rb
20191219112000_remove_key_from_api_keys.rb
20191220134101_add_distinct_badge_count_to_user_stats.rb
20191230055237_add_access_control_columns_to_upload.rb
20200107161405_add_featured_rank_to_user_badges.rb
20200109130028_update_user_profiles_indexes.rb
20200116092259_add_group_to_custom_emojis.rb
20200116140132_rename_reply_id_column.rb
20200117141138_update_post_reply_indexes.rb
20200117172135_add_trigger_to_sync_post_replies.rb
20200117174646_make_post_reply_id_column_read_only.rb
20200120131338_drop_unused_columns.rb
20200130115859_remove_bounce_score_threshold_deactivate_site_setting.rb
20200203061927_mark_bookmarks_topic_id_not_null.rb
20200227073837_add_reminder_last_sent_at_to_bookmarks.rb
20200302120829_add_theme_modifier_set.rb
20200306060737_add_reminder_set_at_to_bookmarks.rb
20200311135425_clear_approved_users_from_the_review_queue.rb
20200312122846_add_duration_to_topic_timers.rb
20200320193612_back_fill_topic_timer_durations.rb
20200327164420_add_imap_stats_to_group.rb
20200329222246_add_high_priority_column_to_notifications.rb
20200330233427_drop_old_unread_pm_notification_indices.rb
20200401172023_create_published_pages.rb
20200403100259_add_key_hash_to_user_api_key.rb
20200408121312_remove_key_from_user_api_key.rb
20200408121834_add_index_to_user_api_key_on_key_hash.rb
20200409033412_create_bookmarks_from_post_action_bookmarks.rb DEV: Check & resolve sequence issues during db:check_structure_dump (#40118) 2026-05-18 15:23:41 +01:00
20200415140830_drop_automatic_membership_retroactive_from_group.rb
20200417183143_add_created_at_to_badge_user.rb
20200424032633_remove_canonical_email_from_user_emails.rb
20200427222624_add_read_only_to_categories.rb
20200428014005_correct_topic_user_bookmarked_boolean.rb
20200428102014_add_bulk_invite_link_to_invites.rb
20200429045956_remove_bookmarks_with_reminder_post_menu_item.rb
20200429095034_add_topic_thumbnail_information.rb
20200429095035_migrate_image_url_to_image_upload_id.rb
20200430010528_remove_avg_time_from_topics_posts.rb
20200430072846_create_invited_users.rb
20200505060712_add_delete_when_reminder_sent_boolean_to_bookmarks.rb
20200506044956_migrate_at_desktop_bookmark_reminders.rb
20200507234409_ensure_bookmark_delete_when_reminder_sent_not_null.rb
20200508141209_allow_null_old_email_on_email_change_requests.rb
20200511043818_add_more_flair_columns_to_group.rb
20200512064023_change_draft_sequence_to_bigint.rb
20200513185052_drop_topic_reply_count.rb
20200517140915_fa4_renames.json
20200517140915_update_deprecated_icon_names.rb DEV: Enable Rails/FilePath rubocop rule (#40097) 2026-05-19 19:07:54 +02:00
20200520001619_remove_fks_from_bookmarks.rb
20200520124359_add_api_key_scopes.rb
20200522004855_remove_access_control_post_fk.rb
20200522204356_add_tag_to_permalink.rb
20200524181959_add_default_list_filter_to_categories.rb
20200525072638_remove_none_tags.rb
20200601111500_remove_image_url_from_post_and_topic.rb
20200601130900_correct_schema_discrepancies.rb
20200602153813_migrate_invite_redeemed_data_to_invited_users.rb
20200610150900_correct_posts_schema.rb
20200611104600_create_missing_badge_indexes.rb DEV: Enable some minor rubocop rules (#40094) 2026-05-19 15:29:38 +02:00
20200617144300_add_public_field_to_published_pages.rb
20200618175923_delete_tracking_state_for_staged_users.rb
20200706202436_rename_category_group_moderation_setting.rb
20200707154522_fix_topic_like_count.rb
20200707183007_add_animated_to_uploads.rb
20200708035330_fix_topic_user_bookmarked_sync_issues.rb
20200708051009_cap_bookmark_name_at_100_characters.rb
20200709032247_allowlist_and_blocklist_site_settings.rb
20200709094846_add_timestamps_to_optimized_images.rb
20200710013237_fix_topic_users_bookmarked_column_that_should_be_false.rb
20200713071305_add_bookmark_name_index.rb
20200714105026_delete_allow_animated_avatars_site_setting.rb
20200714105027_delete_allow_animated_thumbnails_site_setting.rb
20200715030908_remove_unneccessary_bookmark_name_index.rb
20200715044833_add_delete_option_to_bookmarks.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20200715045152_remove_bookmarks_delete_when_reminder_sent.rb
20200717193118_create_allowed_pm_users.rb
20200718154308_add_enable_allowed_pm_users_to_user_options.rb
20200724060632_remove_deprecated_allowlist_settings.rb
20200728000854_duplicate_allowed_paths_from_path_whitelist.rb
20200728004302_drop_path_whitelist_from_embeddable_hosts.rb
20200728022830_sync_topic_user_bookmarked_column_with_bookmarks.rb
20200728072038_add_imap_group_id_to_incoming_email.rb
20200730205554_create_group_default_tracking.rb
20200805151752_add_dark_scheme_id_to_user_options.rb
20200805163400_rename_post_image_site_settings.rb
20200810194943_change_selectable_avatars_site_setting.rb
20200810220841_rename_moderators_create_categories_setting.rb
20200811004537_add_verified_column_to_uploads.rb
20200813044955_create_imap_sync_log.rb
20200813051337_add_private_message_to_post_search_data.rb
20200814081437_add_skip_new_user_tips_to_user_options.rb
20200818084329_update_private_message_on_post_search_data.rb
20200819021210_add_user_selectable_column_to_color_schemes.rb
20200819030609_migrate_user_topic_timers_to_bookmark_reminders.rb
20200819203846_add_color_scheme_id_to_user_options.rb
20200820174703_add_partial_target_id_index_to_reviewables.rb
20200820232017_drop_idx_regular_post_search_data.rb
20200902054531_add_first_unread_pm_a_to_group_user.rb
20200902082203_add_first_unread_pm_at_to_user_stats.rb
20200903045539_add_index_topics_on_timestamps_private.rb
20200910020909_make_imap_sync_log_cols_not_null.rb
20200910051633_change_uploads_verified_to_integer.rb
20200911031738_add_index_to_uploads_verification_status.rb
20200916085541_create_user_ip_address_histories.rb
20200918095554_add_user_api_key_scopes.rb
20201005165544_add_topic_slow_mode_interval.rb
20201006021020_add_requested_by_to_email_change_request.rb
20201007124955_add_digest_attempted_at_to_user_stats.rb
20201008105539_add_allowed_parameters_to_user_api_key_scope.rb
20201009190955_add_last_posted_at_to_topic_user.rb
20201027110546_create_linked_topics.rb
20201102162044_add_auto_update_to_themes.rb
20201103103401_add_not_null_to_ignored_users.rb
20201105190351_move_post_notices_to_json.rb
20201109170951_migrate_github_user_infos.rb DEV: Check & resolve sequence issues during db:check_structure_dump (#40118) 2026-05-18 15:23:41 +01:00
20201110110952_drop_github_user_infos.rb
20201112142419_add_reviewables_force_review.rb
20201116132948_set_themes_auto_update_false.rb
20201117212328_set_category_slug_to_lower.rb
20201210151635_create_do_not_disturb_timings.rb
20201218000000_remove_flag_web_hooks.rb
20201218000001_remove_queued_post_web_hooks.rb
20201223071241_delete_stale_category_search_priorities_from_site_settings.rb
20201229031635_add_user_profile_indexes.rb
20210105165605_add_processed_to_notifications.rb
20210106181418_create_user_notification_schedules.rb
20210107005832_add_imap_missing_column_to_incoming_email.rb
20210111025920_add_reject_reason_to_reviewables.rb
20210119005647_add_created_via_to_incoming_email.rb
20210120125607_rename_english_locale.rb
20210121001720_change_incoming_email_created_at_null.rb
20210125100452_migrate_search_data_after_default_locale_rename.rb
20210126222142_create_shelved_notifications.rb
20210127013637_add_upload_security_log_columns.rb
20210127140730_undo_add_processed_to_notifications.rb
20210128021147_add_allow_unknown_sender_topic_replies_to_group.rb
20210131221311_create_dismissed_topic_users_table.rb
20210201034048_move_category_last_seen_at_to_new_table.rb
20210203031628_add_duration_minutes_to_topic_timer.rb
20210204135429_rename_sso_site_settings.rb
20210204195932_add_replacement_to_watched_words.rb
20210207232853_fix_topic_timer_duration_minutes.rb
20210215231312_fix_group_flair_avatar_upload_security_and_acls.rb DEV: Remove application code from old migration (#33007) 2025-06-02 09:35:15 +08:00
20210218022739_move_new_since_to_new_table_again.rb
20210218144656_add_is_favorite_to_user_badge.rb
20210219171329_drop_old_sso_site_settings.rb
20210224162050_remove_emoji_one_from_emoji_set_site_setting.rb
20210302164429_drop_flash_onebox_site_setting.rb
20210308010745_delete_orphan_post_actions.rb
20210308195916_add_unique_index_to_invited_groups.rb
20210311022303_drop_show_filter_by_tag_site_setting.rb
20210311070755_add_image_upload_id_to_badges.rb
20210315173137_set_disable_mailing_list_mode.rb
20210318020143_add_pinned_column_to_bookmarks.rb
20210323142518_update_invites_redemption_count.rb
20210324043327_delete_orphan_post_revisions.rb
20210328233843_fix_bookmarks_with_incorrect_topic_id.rb
20210406060434_fix_topic_user_bookmarked_sync_issues_again.rb
20210409142455_add_token_to_invites.rb
20210414013318_add_category_setting_allow_unlimited_owner_edits_op.rb
20210420015635_add_searchable_to_user_fields.rb
20210426193009_move_approved_queued_posts_topic_and_post_data.rb
20210513125608_remove_length_constrain_from_topic_excerpt.rb
20210517061815_add_dedicated_enable_imap_smtp_columns_for_group.rb
20210525112226_remove_length_constrain_from_topic_link_url.rb
20210526053611_add_error_count_to_push_subscriptions.rb
20210527114834_set_tagging_enabled.rb
20210527131318_create_directory_columns.rb DEV: Move automatic directory_columns rows from migration to seed fixture (#39970) 2026-05-13 12:12:56 +01:00
20210528003603_fix_badge_image_avatar_upload_security_and_acls.rb DEV: Remove application code from old migration (#33007) 2025-06-02 09:35:15 +08:00
20210528144647_migrate_watched_words_from_replace_to_link.rb
20210601002145_rename_trust_level_translations.rb
20210614232334_add_smtp_group_id_to_email_log.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20210617183010_add_automatic_column_directory_columns.rb
20210617202227_change_automatic_on_directory_columns_to_bool.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20210618135229_reintroduce_type_to_directory_columns.rb
20210621002201_add_columns_to_email_log_to_match_incoming_for_smtp_imap.rb
20210621103509_add_bannered_until.rb
20210621190335_migrate_pending_users_reminder_delay_setting.rb
20210621234939_backfill_email_log_topic_id.rb
20210624023831_remove_highest_seen_post_number_from_topic_users.rb
20210624080131_add_partial_index_pinned_until.rb
20210625203049_add_flair_group_id_to_users.rb
20210628035905_drop_duration_column_from_topic_timers.rb
20210701233509_delete_old_reminder_topic_timers.rb
20210702204007_add_default_auto_close_seconds_to_category.rb
20210706091905_drop_disable_jump_reply_column_from_user_options.rb
20210708035525_add_user_id_index_to_post_revisions.rb
20210708035538_add_post_edits_count_to_user_stats.rb
20210709042135_create_external_upload_stubs.rb
20210709053030_drop_uploads_verified.rb
20210713092503_set_users_flair_group_id.rb
20210720221817_add_draft_count_to_user_stat.rb
20210802131421_remove_post_processed_trigger_option.rb
20210812033033_add_multipart_and_size_columns_to_external_upload_stubs.rb
20210819152920_change_allow_uploaded_avatars.rb
20210824203421_remove_post_timings_summary_index.rb
20210909041448_make_topic_id_nullable_for_bookmarks.rb
20210913032326_add_for_topic_to_bookmarks.rb
20210914011037_change_uploads_filesize_to_bigint.rb
20210914152002_update_value_on_theme_setting_for_upload_type.rb
20210915142958_add_pending_posts_count_to_user_stats.rb
20210915215952_mark_reminder_type_as_readonly_for_bookmarks.rb
20210915222124_drop_reminder_type_index_for_bookmarks.rb
20210920044353_add_default_calendar_to_user_options.rb
20210922064213_alter_bumped_at_indexes_on_topics.rb
20210928161912_migrate_deprecated_html_setting_type.rb
20210929215543_add_token_hash_to_email_token.rb
20211005163152_add_scope_to_email_token.rb
20211013092406_add_normalized_email_to_user_email.rb
20211018234219_remove_enable_experimental_image_uploader_site_setting.rb
20211019092048_remove_crawl_images_site_setting.rb
20211019152356_populate_pending_posts_count_column.rb
20211106085344_create_associated_groups.rb
20211106085527_create_user_associated_groups.rb
20211106085605_create_group_associated_groups.rb
20211116225901_add_description_to_tags.rb
20211123033311_reset_first_unread_pm_at_on_user_stat.rb
20211123144714_add_recent_searches.rb
20211124161346_queue_internal_onebox_rebake.rb
20211201221028_migrate_email_to_normalized_email.rb
20211206160211_create_index_on_email_tokens_token_hash.rb
20211206160212_drop_token_from_email_tokens.rb
20211207130646_add_domain_to_invites.rb
20211213060445_email_tokens_token_to_nullable.rb DEV: Enable Style/RedundantBegin rubocop rule (#40096) 2026-05-19 18:44:54 +02:00
20211216191224_remove_advanced_editor_preview_site_setting.rb
20211220023034_remove_experimental_backup_uploader_setting.rb
20211221164540_remove_limit_for_fancy_title_in_topics.rb
20211224010204_drop_old_bookmark_columns.rb
20211224011511_delete_experimental_composer_upload_setting.rb
20211224111749_not_null_notification_level_in_category_users.rb
20220105024605_add_trigger_for_polymorphic_bookmark_columns_to_sync_data.rb
20220118065658_add_constraints_to_user_stat.rb
20220124003259_add_email_from_alias_to_groups.rb
20220125052845_fix_topic_like_count_including_whispers.rb
20220126052157_change_segment_cjk_site_setting.rb
20220130192155_set_use_email_for_username_and_name_suggestions_on_existing_sites.rb
20220202223955_migrate_selectable_avatars_enabled.rb
20220202225716_add_external_id_to_topics.rb
20220209210449_add_bookmark_auto_delete_preference_to_user_option.rb
20220214224506_reset_custom_emoji_post_bakes_version_secure_fix.rb
20220214233625_add_bounce_error_code_to_email_log.rb
20220215015538_drop_user_stat_count_constraints.rb
20220220234155_conform_bounce_error_code.rb
20220302163246_update_avatar_service_domain.rb
20220302171443_rebake_old_avatar_service_urls.rb
20220304162250_enable_unaccent_extension.rb
20220308201942_create_upload_references.rb
20220309132719_copy_post_uploads_to_upload_references.rb
20220309132720_copy_post_uploads_to_upload_references_for_sync.rb
20220316150247_reset_bookmarks_reminder_last_sent_at.rb
20220322024216_add_bookmark_polymorphic_columns.rb
20220323141645_remove_polling_site_settings.rb
20220325064954_make_some_bookmark_columns_nullable.rb
20220330160740_cleanup_selectable_avatars_data.rb
20220330160747_copy_site_settings_uploads_to_upload_references.rb
20220330160751_copy_badges_uploads_to_upload_references.rb
20220330160754_copy_groups_uploads_to_upload_references.rb
20220330160757_copy_user_exports_uploads_to_upload_references.rb
20220330164740_copy_theme_fields_uploads_to_upload_references.rb
20220331204447_create_sitemaps_table.rb
20220401130745_create_category_required_tag_groups.rb
20220401140745_drop_category_required_tag_group_columns.rb
20220404195635_copy_categories_uploads_to_upload_references.rb
20220404201949_copy_custom_emojis_uploads_to_upload_references.rb
20220404203356_copy_user_profiles_uploads_to_upload_references.rb
20220404204439_copy_user_avatars_uploads_to_upload_references.rb
20220404212716_copy_theme_settings_uploads_to_upload_references.rb
20220407195246_remove_category_required_tag_groups_without_tag_groups.rb
20220428025825_add_enable_experimental_sidebar_to_user_options.rb
20220428094026_create_post_hotlinked_media.rb
20220428094027_fix_post_hotlinked_media_index.rb
20220429164301_delete_hotlinked_image_custom_fields.rb
20220505133851_migrate_custom_group_deletion_logs.rb
20220505191131_add_last_seen_reviewable_id_to_user.rb
20220506221447_set_pm_tags_allowed_for_groups_default.rb
20220510131525_remove_allow_staff_to_tag_pms_site_setting.rb
20220512011522_backfill_polymorphic_bookmarks_and_make_default.rb
20220512011531_backfill_polymorphic_bookmarks.rb
20220519190829_create_user_statuses.rb
20220526203356_copy_user_uploads_to_upload_references.rb
20220606061813_add_smtp_transaction_response_to_email_logs.rb
20220607150432_disallow_null_emoji_on_user_status.rb
20220617151846_rename_default_categories_regular_setting.rb
20220621164914_drop_flair_url_from_groups.rb
20220628031850_create_sidebar_section_links.rb
20220712040959_add_case_sensitive_to_watched_words.rb
20220726164831_fix_delete_rejected_email_after_days_site_setting.rb
20220727040437_add_topic_timers_index.rb
20220727085001_create_index_on_reviewables_score_desc_created_at_desc.rb
20220801044610_add_outbound_message_id_to_post.rb
20220811170600_reset_flair_group_id_if_not_group_member.rb
20220818171849_move_tl_user_history_to_previous_and_new_value.rb
20220825005115_backfill_outbound_message_id.rb
20220825054405_fill_personal_message_enabled_groups_based_on_deprecated_settings.rb DEV: Skip backfill INSERTs in old migrations on fresh installs (#39976) 2026-05-13 13:59:28 +01:00
20220915132547_add_dominant_color_to_uploads.rb
20220920044310_enforce_user_profile_max_limits.rb
20220923212549_add_seen_popups_to_user_options.rb
20220927065328_set_secure_uploads_settings_based_on_secure_media_equivalent.rb
20220927171707_disable_allow_uncategorized_new_sites.rb
20221004122343_add_dark_mode_logo_to_categories.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20221013045158_add_sidebar_list_destination_to_user_option.rb
20221017223309_fix_general_category_id.rb
20221018100550_add_source_map_to_javascript_cache.rb
20221026035440_security_log_out_invite_redemption_invited_users.rb
20221101140632_rename_onboarding_popups_site_setting.rb
20221101181505_hide_all_user_tips_for_existent_users.rb
20221103051248_remove_invalid_topic_allowed_users_from_invites.rb
20221108032233_drop_old_bookmark_columns_v2.rb
20221110175456_populate_default_composer_category.rb DEV: Update rubocop-discourse to 3.13 and autofix issues (#35073) 2025-10-06 16:11:01 +02:00
20221114215902_hide_user_tips_3_to_5_for_existing_users.rb
20221125001635_add_bcc_addresses_to_email_log.rb
20221125173217_remove_enable_whispers_site_setting.rb
20221205225450_migrate_sidebar_site_settings.rb
20221211142629_remove_updated_translation_overrides.rb
20221212234948_drop_topic_allowed_users_backup_nov_2022.rb
20230103004613_make_experimental_hashtag_feature_default_for_new_sites.rb
20230104054425_rename_rate_limit_search_anon.rb
20230104054426_delete_old_rate_limit_search_anon.rb
20230105153520_trigger_post_rebake_local_onebox_xss.rb
20230111223803_delete_misconfigured_embeddable_hosts.rb
20230113002617_reindex_invalid_indexes.rb
20230115233416_create_sidebar_sections.rb
20230117002110_create_sidebar_url.rb
20230117143451_drop_invalid_drafts.rb
20230118020114_add_public_topic_count_to_tags.rb
20230118042740_add_sidebar_section_id_to_sidebar_section_links.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20230119000943_add_staff_topic_count_to_tags.rb
20230119024157_remove_topic_count_from_tags.rb
20230119091939_drop_orphaned_reviewable_flagged_posts.rb
20230119094939_remove_wildcard_from_email_domain_site_settings.rb
20230127173249_truncate_user_status_to_100_characters.rb
20230201192925_add_trigram_indexes_to_users.rb
20230202021414_remove_enable_new_user_profile_nav_groups_site_settings.rb
20230202173641_create_form_templates.rb
20230202204937_add_index_to_posts_where_not_deleted_or_empty.rb
20230206033907_add_icon_to_sidebar_urls.rb
20230207042719_add_limits_to_sidebar_sections_and_sidebar_urls.rb
20230207093514_create_category_settings.rb
20230208020404_populate_category_settings.rb
20230209222225_add_linkable_index_to_sidebar_section_links.rb
20230213234415_create_category_form_templates.rb
20230214044350_add_public_to_sidebar_sections.rb
20230224193734_create_theme_svg_sprite.rb
20230224225129_backfill_svg_sprites.rb
20230227050147_update_badge_icons.rb
20230228105851_drop_badge_granted_title_column.rb
20230301071240_add_auto_bump_cooldown_days_to_category_settings.rb
20230303015952_add_external_to_sidebar_urls.rb
20230307051200_add_position_to_sidebar_section_links.rb
20230308042434_backfill_auto_bump_cooldown_days_category_setting.rb
20230328034956_add_sidebar_section_id_index_to_sidebar_section_link.rb
20230403063113_drop_idx_post_custom_fields_akismet.rb
20230403094936_change_google_analytics_default.rb
20230404064728_system_user_for_public_sections.rb
20230405121453_add_password_algorithm_to_users.rb
20230405121454_update_password_algorithm_post_deploy.rb
20230411031428_add_segment_to_sidebar_urls.rb
20230411031520_add_section_type_to_sidebar_sections.rb
20230411032053_insert_community_to_sidebar_sections.rb DEV: Move Community sidebar section + links from migrations to seed fixture (#39973) 2026-05-13 12:13:12 +01:00
20230413121500_add_discourse_connect_allowed_redirect_domains_to_site_settings.rb
20230419001801_remove_enable_custom_sidebar_sections_setting.rb
20230501022508_rename_notify_about_flags_after_site_setting.rb
20230505113906_hide_user_tips_for_existing_users.rb
20230509214723_separate_trusted_users_can_edit_others_site_setting.rb
20230515103515_create_watched_word_groups.rb
20230515131111_add_watched_word_group_id_to_watched_words.rb
20230523073109_delete_old_personal_message_settings.rb
20230528134326_enable_experimental_hashtag_autocomplete_true_for_all_sites.rb
20230602034711_rename_everything_to_topics_link.rb
20230608163854_create_summary_sections_table.rb
20230614011312_rename_default_sidebar_categories_setting.rb
20230614011419_rename_default_sidebar_tags_setting.rb
20230618041001_add_sidebar_link_to_filtered_list_to_user_option.rb
20230618041123_add_sidebar_show_count_of_new_items_to_user_option.rb
20230620050614_remove_default_sidebar_list_destination_setting.rb
20230627060104_remove_new_edit_sidebar_categories_tags_interface_groups_site_setting.rb
20230628062236_add_watched_precedence_over_muted_to_user_options.rb
20230703035052_add_status_to_translation_overrides.rb
20230707031122_add_watched_precedence_over_muted_index_to_user_options.rb
20230708011310_fix_reviewable_queued_posts_target_created_by_id.rb
20230712011946_add_topic_id_notification_level_index_to_topic_users.rb
20230712013248_add_category_id_notification_level_index_to_category_users.rb
20230727015030_add_index_topic_id_created_at_on_posts.rb
20230727015254_change_category_setting_num_auto_bump_daily_default.rb
20230728055813_delete_orphaned_draft_upload_references.rb
20230807033021_add_group_to_web_hook_event_type.rb
20230807040058_move_web_hooks_to_new_event_ids.rb
20230816211907_increase_size_of_sidebar_urls.rb
20230817174049_ensure_javascript_cache_is_unique_per_theme.rb
20230823095931_add_limit_to_user_second_factor_name.rb
20230823100627_add_limit_to_user_security_key_name.rb
20230831153649_delete_unused_site_settings.rb
20230906030920_change_auto_silence_fast_typers_setting_to_enum_type.rb
20230907225057_create_theme_settings_migrations.rb
20230910021213_update_category_setting_approval_values.rb
20230913194832_rename_revoke_api_keys_settings.rb
20230926165821_drop_post_uploads_table.rb
20231004020328_migrate_legacy_navigation_menu_site_setting.rb
20231017044708_remove_enable_experimental_hashtag_autocomplete_setting.rb
20231018225833_add_dark_mode_background_to_categories.rb DEV: Remove invalid options from migrations (#34384) 2025-08-19 17:35:50 +02:00
20231024034031_migrate_tl_to_group_settings_anonymous_posting_min_tl.rb
20231103060018_fix_invalid_topic_user_bookmarked_data.rb
20231107014123_migrate_shared_drafts_min_trust_level_to_group.rb
20231107055903_migrate_min_trust_level_for_here_mention_to_group.rb
20231111201253_rename_experimental_passkeys_site_setting.rb
20231117182638_fill_approve_unless_allowed_groups_based_on_deprecated_settings.rb
20231120190818_trigger_post_rebake_category_style_quotes.rb
20231122043756_increase_size_of_tag_descriptions.rb
20231122152552_fill_new_topics_unless_allowed_groups_based_on_deprecated_settings.rb
20231122212122_fill_email_in_allowed_groups_based_on_deprecated_settings.rb
20231127165331_trigger_auto_linking_for_videos_since_placeholder.rb
20231205013029_fill_uploaded_avatars_allowed_groups_based_on_deprecated_settings.rb
20231206041353_fill_create_topic_allowed_groups_based_on_deprecated_settings.rb
20231207011238_fill_edit_wiki_post_allowed_groups_based_on_deprecated_settings.rb
20231212044856_fill_edit_post_allowed_groups_based_on_deprecated_settings.rb
20231213060822_fill_flag_post_allowed_groups_based_on_deprecated_settings.rb
20231213103248_fill_delete_all_posts_and_topics_allowed_groups_based_on_deprecated_settings.rb
20231214020814_fill_user_card_background_allowed_groups_based_on_deprecated_settings.rb
20231214023728_fill_invite_allowed_groups_based_on_deprecated_settings.rb
20231214031754_fill_ignore_allowed_groups_based_on_deprecated_settings.rb
20231214061615_fill_create_tag_allowed_groups_based_on_deprecated_settings.rb
20231218081901_fill_send_email_messages_allowed_groups_based_on_deprecated_settings.rb
20231222030024_fill_self_wiki_allowed_groups_based_on_deprecated_settings.rb
20240104155715_add_embed_content_cache_to_topic_embed.rb
20240108022138_change_enable_admin_sidebar_to_group_post_migration.rb
20240110040813_fill_skip_review_media_groups_based_on_deprecated_setting.rb
20240112021335_set_max_clean_orphan_uploads_grace_period_hours.rb
20240112043325_fill_embedded_media_post_allowed_groups_based_on_deprecated_setting.rb
20240112073149_fill_tag_topic_allowed_groups_based_on_deprecated_settings.rb
20240116043702_create_topic_hot_scores.rb
20240116182229_migrate_lazy_load_categories_to_groups.rb
20240117090801_fill_post_links_allowed_groups_based_on_deprecated_settings.rb
20240117093148_fill_user_api_key_allowed_groups_based_on_deprecated_settings.rb
20240201170412_fix_tag_topic_allowed_groups_setting.rb DEV: fix a large amount of typos (#37428) 2026-02-02 16:31:58 +11:00
20240202032242_add_json_value_to_theme_settings.rb
20240202052058_drop_badge_image_column.rb
20240202204030_fix_here_mention_allowed_groups_setting.rb
20240204204532_add_user_to_permalink.rb
20240212034010_drop_deprecated_columns.rb
20240216073624_fill_profile_background_allowed_groups_based_on_deprecated_setting.rb
20240219012001_remove_enable_experimental_admin_ui_groups_site_settings.rb
20240223052820_create_problem_check_trackers.rb
20240301033753_delete_old_bookmark_reminder_setting.rb
20240304030429_topic_id_on_incoming_email_index.rb
20240306063428_add_indexes_to_notifications.rb
20240307231053_add_topics_unread_when_closed_to_user_options.rb
20240311015942_create_admin_notices.rb
20240326200232_add_custom_homepage_theme_modifiers.rb
20240327000440_replace_post_reply_index.rb
20240327043323_disable_admin_sidebar_for_existing_sites.rb
20240401054228_add_details_to_problem_check_trackers.rb
20240404034232_remove_experimental_objects_type_for_theme_settings.rb
20240422015830_remove_admin_guide_tooltip_from_seen_popups.rb
20240423013808_add_visibility_reason_id_to_topics.rb
20240423054323_create_flags.rb
20240430051551_add_user_id_to_embeddable_hosts.rb
20240430052017_create_embeddable_host_tags.rb
20240430185434_fix_watched_words_without_action.rb
20240506035024_clear_orphaned_draft_upload_references.rb
20240506125839_add_html_to_watched_words.rb
20240510073417_increase_external_avatar_url_limit.rb
20240517014119_add_target_to_problem_check_trackers.rb
20240517051933_disambiguate_problem_check_tracker_uniqueness.rb
20240520060901_add_requirement_to_user_fields.rb
20240527015009_add_topic_view_stats.rb
20240527055057_add_score_type_to_flags.rb
20240531053226_create_user_required_fields_version.rb
20240603234529_create_user_passwords.rb
20240606003822_reorder_flags.rb
20240610150449_limit_tag_group_name_length.rb
20240612063735_add_field_type_enum_to_user_fields.rb
20240612073116_swap_field_type_with_field_type_enum_on_user_fields.rb
20240619123052_create_web_hook_events_daily_aggregates.rb
20240620024938_add_back_field_type_enum_to_user_fields.rb
20240627125112_remove_invalid_csp_script_src_site_setting_values.rb
20240627155730_create_redelivering_webhook_events.rb
20240705134114_clear_orphaned_draft_upload_references2.rb
20240705153533_add_user_agent_to_search_logs.rb
20240709010639_remove_cross_origin_unsafe_none_referrers_setting.rb
20240709015048_remove_logging_provider_site_setting.rb
20240711123755_drop_compiled_js_from_translation_overrides.rb
20240712050324_default_github_onebox_token.rb
20240714231226_duplicate_flags_custom_type_to_require_message.rb
20240714231516_drop_custom_type_from_flags.rb
20240715073605_add_smtp_ssl_mode_to_groups.rb
20240717053710_drop_groups_smtp_ssl.rb
20240717171840_rename_chat_preferred_mobile_index_setting.rb
20240722025822_add_user_id_to_custom_emojis.rb
20240723030506_add_post_id_index_to_user_histories.rb
20240724021732_add_login_method_to_user_auth_tokens.rb
20240725042522_remove_experimental_flags_admin_page_site_setting.rb
20240729084803_create_user_api_key_clients.rb
20240731143458_remove_chat_default_channel_id.rb
20240731190511_update_invalid_allowed_iframe_values.rb
20240807024301_update_delete_merged_stub_topics_after_days_setting.rb
20240815234500_remove_glimmer_header_mode_setting.rb
20240818113758_remove_all_but_most_recent_user_password.rb
20240819130737_update_unique_index_on_user_passwords.rb
20240820123401_alter_notifications_id_sequence_to_bigint.rb
20240820123402_add_big_int_notifications_id.rb
20240820123403_copy_notifications_id_values.rb
20240820123404_copy_notifications_id_indexes.rb
20240820123405_swap_big_int_notifications_id.rb
20240820123406_drop_old_notification_id_indexes.rb
20240826121501_add_big_int_shelved_notifications_notification_id.rb
20240826121502_copy_shelved_notifications_notification_id_values.rb
20240826121503_copy_shelved_notifications_notification_id_indexes.rb
20240826121504_swap_big_int_shelved_notifications_notification_id.rb
20240826121505_add_big_int_user_badges_notification_id.rb
20240826121506_copy_user_badges_notification_id_values.rb
20240826121507_swap_big_int_user_badges_notification_id.rb
20240827063715_add_new_seen_notification_id_to_users.rb
20240827063908_copy_users_seen_notification_id_values.rb
20240827064121_swap_seen_notification_id_with_seen_notification_id_on_users.rb
20240828191047_create_category_moderation_groups.rb
20240829083823_ensure_unique_tag_user_notification_level.rb
20240829140226_drop_old_notification_id_columns.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20240903024157_remove_user_passwords_indexes.rb
20240903024211_add_trigger_to_users_to_sync_user_passwords.rb
20240903024311_backfill_user_passwords_from_users.rb
20240906233304_remove_limits_from_form_templates.rb
20240909121255_rebake_user_onebox.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20240910090759_make_password_columns_from_users_read_only.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20240912061702_drop_user_search_similar_results_site_setting.rb
20240912061806_drop_trgm_indexes_on_users.rb
20240912210450_delete_anonymous_users_from_directory_items.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20240912212253_increase_external_avatar_url_limit_to2000.rb
20241011033602_add_post_badges_to_theme_modifiers.rb
20241011054348_fix_unique_constraint_on_problem_check_trackers.rb
20241011080517_drop_password_columns_from_users.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20241018031851_add_default_value_to_problem_check_trackers_target.rb
20241022022326_remove_nulls_not_distinct_from_problem_check_trackers.rb
20241023041126_clear_duplicate_admin_notices.rb DEV: Promote historic post_deploy migrations (#34273) 2025-08-13 14:10:50 +08:00
20241024093027_remove_category_experts_web_hook_event_types.rb
20241024102733_remove_experimental_redesigned_about_page_groups_setting.rb
20241025045928_add_invites_link_to_sidebar.rb DEV: Move Community sidebar section + links from migrations to seed fixture (#39973) 2026-05-13 12:13:12 +01:00
20241028021339_add_smart_list_user_preference.rb
20241030210727_split_hide_profile_and_presence.rb
20241101141701_alter_bookmarks_ids_to_bigint.rb
20241104132424_rename_full_page_site_setting.rb
20241108154026_create_moved_posts.rb
20241112124552_create_user_api_key_client_scopes.rb
20241112145744_anonymize_normalized_email_column.rb
20241121000131_add_post_header_to_badge.rb
20241127034553_add_potentially_illegal_to_reviewables.rb
20241127072350_remap_fa5_icon_names_to_fa6.rb
20241204085540_remap_to_fa6_icon_names.rb
20241205035402_change_default_for_badges_icon.rb
20241205162117_add_columns_to_moved_posts.rb
20241206002425_drop_experimental_topics_filter_site_setting.rb
20241206121401_delete_categories_only_optimized_site_setting.rb
20241211030039_remove_glimmer_post_menu_groups_setting.rb
20241211222608_add_full_move_to_moved_post_records.rb
20241224191732_change_full_name_required_setting.rb
20250115031117_remove_user_profile_from_overridden_robots.rb
20250116024516_update_font_site_settings_type.rb
20250117065027_set_default_font_for_existing_sites.rb
20250119222805_fill_fast_typing_threshold_based_on_deprecated_setting.rb
20250120115539_add_dark_hex_to_color_scheme_color.rb
20250121180125_create_theme_color_scheme.rb
20250124062108_remap_deprecated_icon_names_for_seeded_badges.rb
20250130205841_fix_incorrect_fast_typing_threshold_setting.rb
20250205174221_add_serialize_topic_op_likes_data_theme_modifier.rb
20250206010037_remove_glimmer_post_menu_mode_setting.rb DEV: Remove the legacy widget post menu code (#31211) 2025-04-01 16:03:58 +01:00
20250212044021_rename_allow_all_users_to_flag_illegal_content_site_setting.rb
20250212045125_add_type_source_to_reviewable.rb
20250217003916_x_summary_large_image_based_on_deprecated_setting.rb
20250220045740_add_context_to_reviewable_scores.rb
20250225131523_add_style_type_to_categories.rb FEATURE: add icons and emojis to category (#31795) 2025-03-26 09:46:17 +04:00
20250304034313_add_composer_columns_to_post_stat.rb
20250304054720_add_scope_mode_to_api_keys.rb
20250304074934_backfill_api_key_scope_modes.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250305233449_populate_type_source_in_reviewable.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250307034117_remove_old_admin_sidebar_enabled_groups_site_settings.rb FIX: remove admin_sidebar_enabled_groups setting (#31693) 2025-03-11 11:41:38 +11:00
20250311041851_add_index_to_post_stat_composer_columns.rb DEV: Rerun AddIndexToPostStatComposerColumns migration (#31765) 2025-03-12 11:49:51 +08:00
20250311073009_enable_welcome_banner_new_sites.rb FEATURE: Add welcome banner to core (#31516) 2025-03-17 12:18:08 +10:00
20250313000000_increase_uploads_origin_column_length.rb FIX: Increase uploads.origin column length to 2000 to accommodate longer S3 pre-signed URLs for user uploads. (#31803) 2025-03-20 09:05:35 +08:00
20250313044812_remove_unique_constraint_from_tag_users_indexes.rb DEV: Protection for migrations that creates index concurrently take 2 (#31792) 2025-03-17 08:25:30 +08:00
20250313045010_add_index_to_users_ip_address.rb DEV: Protection for migrations that creates index concurrently take 2 (#31792) 2025-03-17 08:25:30 +08:00
20250314102616_rename_allow_anonymous_posting_to_allow_anonymous_mode.rb UX: Improve naming for anonymous mode settings (#31832) 2025-03-21 04:54:06 +03:00
20250314110738_rename_allow_anonymous_likes_to_allow_likes_in_anonymous_mode.rb UX: Improve naming for anonymous mode settings (#31832) 2025-03-21 04:54:06 +03:00
20250319024514_add_automatic_to_reviewable_claimed_topic.rb FEATURE: Sync Reviewable Status (#31901) 2025-03-24 14:27:18 +11:00
20250321143553_add_serialize_topic_is_hot_theme_modifier.rb DEV: TopicListItemSerializer tells if topic is among the top 100 hottest topics (#31935) 2025-03-24 11:55:14 -05:00
20250407040934_remove_full_page_login_problem_check_trackers.rb DEV: Remove full_page_login setting (#32189) 2025-04-29 10:40:40 +02:00
20250407042814_delete_full_page_login_setting.rb DEV: Remove full_page_login setting (#32189) 2025-04-29 10:40:40 +02:00
20250409035119_add_theme_site_setting_table.rb FEATURE: Themeable site settings (#32233) 2025-07-16 11:00:21 +10:00
20250415224422_update_allowed_iframes_codepen_stricter_default.rb UX: add * mention to site setting description 2025-06-09 12:04:15 +08:00
20250416012407_remove_experimental_admin_search_enabled_groups_setting.rb FEATURE: Release admin search for all sites (#32327) 2025-04-16 16:26:53 +10:00
20250417043438_remove_old_reviewable_claimed_topics.rb FIX: Unclaim reviewables when finished. (#32346) 2025-04-17 16:28:27 +10:00
20250421074012_create_category_localization_table.rb FEATURE: Show translated category names from localizations table if they exist for the user locale (#32380) 2025-04-22 15:13:19 +08:00
20250424054312_create_topic_localizations.rb DEV: Create topic and post localization resources (#32440) 2025-04-28 12:16:14 +08:00
20250424054313_create_post_localizations.rb DEV: Create topic and post localization resources (#32440) 2025-04-28 12:16:14 +08:00
20250429083152_add_locale_to_post.rb DEV: Add locale to post table (#32526) 2025-04-30 16:35:32 +08:00
20250505050610_optimized_image_format_index.rb FIX: key optimized images on format (#32575) 2025-05-06 14:40:51 +10:00
20250507013646_remove_theme_download_screenshots_site_settings.rb DEV: remove theme_download_screenshots site setting (#32612) 2025-05-07 12:09:20 +08:00
20250507110205_add_locale_to_topic.rb DEV: Add locale for topics (#32619) 2025-05-07 22:25:58 +08:00
20250513161753_rename_by_id_group.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250521053324_add_excerpt_to_topic_localization.rb FEATURE: Also localize topic excerpts (#32839) 2025-05-21 17:49:27 +08:00
20250526063633_copy_add_groups_to_about_component_settings.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250526164734_copy_translation_target_languages_to_content_localization_supported_locales.rb DEV: Update allowed supported locales in translation editor (#32920) 2025-05-26 11:40:19 -07:00
20250527101351_remove_max_similar_results_site_setting.rb DEV: remove max similar results site setting (#32936) 2025-06-04 16:41:03 +10:00
20250528030212_add_locale_to_categories.rb DEV: Add locale column to categories (#32962) 2025-05-28 13:49:26 +08:00
20250603051201_create_reviewable_notes.rb DEV: Add a ReviewableNote model, and tie it into the Reviewable model. (#33047) 2025-06-04 09:33:02 +10:00
20250606170129_create_optimized_videos.rb FEATURE: Add support for aws MediaConvert (#33092) 2025-07-23 11:58:33 -06:00
20250609115711_remove_composer_tips_site_settings.rb DEV: remove redundant composer tips site settings (#33127) 2025-06-10 09:15:43 +04:00
20250614020437_add_description_to_invites.rb FEATURE: Add description to invites (#33207) 2025-06-16 11:31:07 +08:00
20250617064103_migrate_experimental_system_themes_site_setting_to_enum.rb DEV: change experimental_system_themes setting to list (#33230) 2025-06-17 15:41:19 +08:00
20250617085536_remove_experimental_from_content_localization_settings.rb DEV: Remove 'experimental' prefix from settings (#33233) 2025-06-19 12:23:42 +08:00
20250619140551_add_user_index_to_incoming_links.rb PERF: Add indexes to improve user merger performance (#33271) 2025-07-10 18:18:40 -03:00
20250619140739_add_index_to_posts.rb PERF: Add indexes to improve user merger performance (#33271) 2025-07-10 18:18:40 -03:00
20250619140809_add_index_to_post_actions.rb PERF: Add indexes to improve user merger performance (#33271) 2025-07-10 18:18:40 -03:00
20250619140858_add_jsonb_indexes_to_notifications.rb PERF: Add indexes to improve user merger performance (#33271) 2025-07-10 18:18:40 -03:00
20250620025548_add_index_to_post_actions_on_post_action_type_id.rb PERF: Avoid slow preloading in SiteSerializer (#33283) 2025-06-25 15:03:34 +08:00
20250620033435_add_index_reviewable_scores_on_reviewable_score_type.rb PERF: Avoid slow preloading in SiteSerializer (#33283) 2025-06-25 15:03:34 +08:00
20250626090725_add_my_messages_link_to_sidebar.rb DEV: Move Community sidebar section + links from migrations to seed fixture (#39973) 2026-05-13 12:13:12 +01:00
20250627022651_enable_horizon_for_existing_sites.rb FEATURE: Enable system Horizon (#33374) 2025-06-30 07:23:02 +08:00
20250702082232_deprecate_external_system_avatars_enabled.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250702133530_fix_capitalisation_in_sidebar_urls.rb FIX: Sidebar messages link updates (#33444) 2025-07-07 11:55:39 +08:00
20250704072726_nullify_blank_locales.rb FIX: Prevent saving empty string as a locale (#33481) 2025-07-04 17:20:42 +08:00
20250707084732_limit_category_localization_descriptions.rb DEV: Add limit on localized descriptions (#33492) 2025-07-08 10:37:51 +08:00
20250708031631_remove_flush_timings_secs_setting.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250709051949_disable_gravatar_enabled_if_unconfigured.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250710074447_clear_backup_frequency_if_disabled.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250714010001_backfill_themeable_site_settings.rb FEATURE: Themeable site settings (#32233) 2025-07-16 11:00:21 +10:00
20250714030525_remove_experimental_system_themes_site_setting.rb DEV: enable Foundation and stop Default (#33610) 2025-07-15 11:16:11 +08:00
20250715094001_update_javascript_cache.rb DEV: Extract theme script tags into their own JS files (#33647) 2025-07-16 17:17:36 +01:00
20250718035714_enable_rich_editor_for_all.rb FEATURE: Enable rich editor for all users (#33699) 2025-07-28 10:08:50 +10:00
20250718043910_add_composition_mode_user_option.rb FEATURE: Enable rich editor for all users (#33699) 2025-07-28 10:08:50 +10:00
20250721043317_add_filter_link_to_sidebar.rb DEV: Move Community sidebar section + links from migrations to seed fixture (#39973) 2026-05-13 12:13:12 +01:00
20250722074045_add_dark_color_scheme_id_to_themes.rb FEATURE: Add dark color scheme setting for themes (#33967) 2025-08-04 12:33:41 +08:00
20250723122719_add_interface_color_mode_to_user_options.rb FEATURE: Color mode preference (#33875) 2025-07-31 08:17:02 +03:00
20250724012518_drop_horizon_setting_field.rb DEV: Use themeable site settings for Horizon (#33645) 2025-07-24 12:20:34 +10:00
20250729044139_fill_in_dark_color_scheme_id.rb FEATURE: Add dark color scheme setting for themes (#33967) 2025-08-04 12:33:41 +08:00
20250804005557_enable_markdown_monospace_font_user_option.rb FEATURE: User preference for editor Markdown monospace font (#34051) 2025-08-04 14:56:21 +10:00
20250804021210_drop_enable_experimental_sidebar_user_option.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250808064354_remove_experimental_sidebar_messages_count_enabled_groups_site_setting.rb DEV: remove experimental_sidebar_messages_count_enabled_groups (#34167) 2025-08-11 12:38:50 +08:00
20250811070948_add_impersonated_user_fields_to_user_auth_token.rb DEV: Allow impersonation without session swapping (#34213) 2025-08-21 14:18:15 +08:00
20250812033430_replace_null_with_zero_in_backup_frequency.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250818063631_migrate_color_schemes_base_scheme_id_from_string_to_int.rb FIX: handle lower case dark (#34444) 2025-08-20 17:32:53 +02:00
20250821150220_remove_use_overhauled_theme_color_palette_setting.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250821155127_drop_dark_hex_from_color_scheme_color.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250821155615_drop_theme_color_scheme.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20250825094818_delete_use_polymorphic_bookmarks_setting.rb DEV: Delete old use_polymorphic_bookmarks site setting (#34514) 2025-08-25 20:42:30 +10:00
20250826012802_add_type_to_topic_timer.rb DEV: Use Single Table Inheritance in TopicTimer (#34530) 2025-09-01 11:13:22 +08:00
20250827065400_migrate_content_localization_anon_language_switcher_to_enum.rb FEATURE: Also allow language switcher to be shown when users are logged in (#34578) 2025-08-27 23:01:07 +08:00
20250828011415_add_index_created_at_on_web_hook_events.rb PERF: Add index_web_hook_events_on_created_at (#34594) 2025-08-29 15:15:39 +08:00
20250828181952_alter_web_hook_events_id_to_bigint.rb FIX: Make web_hook_events#id a bigint (#34620) 2025-09-04 22:20:34 +03:00
20250902014817_add_timerable_id_to_topic_timer.rb DEV: Remove unnecessary topic_timers_topic_id_trigger trigger (#34866) 2025-09-19 10:14:23 +08:00
20250902020536_add_show_on_signup_to_user_fields.rb FEATURE: Allow hiding user fields on signup form (#34672) 2025-09-15 10:42:07 +08:00
20250902072941_sync_timerable_id_topic_id.rb DEV: Fix incorrect SyncTimerableIdTopicId migration (#34837) 2025-09-17 13:54:29 +08:00
20250902221035_add_remote_copy_to_color_scheme.rb FEATURE: Allow editing theme-owned palettes (#34722) 2025-10-06 09:02:39 +03:00
20250916082012_mark_timerable_id_non_nullable.rb DEV: rename topic_id to timerable_id for BaseTimer (#34667) 2025-09-17 13:19:17 +08:00
20250919010400_remove_trigger_on_topic_timers.rb DEV: Remove unnecessary topic_timers_topic_id_trigger trigger (#34866) 2025-09-19 10:14:23 +08:00
20250919061654_remove_floatkit_autocomplete_site_settings.rb DEV: remove toggles for switching between jquery & floatkit autocomplete (#34867) 2025-09-19 14:50:04 +08:00
20250925061202_add_site_setting_groups.rb FEATURE: Upcoming changes part 1 (#34617) 2025-10-30 10:46:14 +10:00
20250925182715_add_index_to_posts_locale.rb PERF: optimize translation progress dashboard with batch query (#34861) 2025-09-29 13:32:40 +08:00
20251003120819_split_moderators_manage_categories_and_groups_setting.rb FEATURE: Split setting for allowing mods to manage categories and groups (#35174) 2025-10-06 10:43:42 +03:00
20251008050307_delete_post_localizations_with_links.rb FEATURE: Add oneboxes and lightboxes to localized posts (#34900) 2025-10-08 15:14:56 +08:00
20251013091641_add_notify_on_linked_posts_to_user_options.rb FEATURE: disable link notification user preference (#35352) 2025-10-14 10:53:05 +02:00
20251016013505_convert_watched_precedence_over_muted_to_default_pref.rb DEV: Partially move watched_precedence_over_muted migration to post-migration phase (#35755) 2025-11-03 16:04:14 +10:00
20251023042602_add_extra_index_topic_tags.rb FIX: Add extra tag_id, topic_id index to topic_tags (#35565) 2025-10-23 17:34:16 +10:00
20251024015907_populate_image_quality_setting.rb DEV: Stop overriding image_quality on new sites (#39930) 2026-05-13 10:07:44 +01:00
20251029072625_delete_old_watched_precedence_setting.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20251107123438_add_index_to_tag_groups.rb FIX: csv import not being casing aware for tag groups (#35837) 2025-11-10 11:34:23 -03:00
20251111073356_create_tag_localizations.rb DEV: Add tag localization tables (#35962) 2025-11-11 20:39:54 +08:00
20251111091231_add_locale_to_tags.rb DEV: Add locale to tags (#35979) 2025-11-12 13:12:43 +08:00
20251117002948_create_reviewable_action_logs.rb DEV: Add a new ReviewableActionLog model. (#36057) 2025-11-17 15:45:33 +11:00
20251118002306_add_bundle_to_reviewable_action_logs.rb DEV: Log Reviewable actions (#36076) 2025-11-20 13:41:40 +11:00
20251119033712_remove_widget_poststream_settings.rb DEV: Purge the widget rendering system (#36109) 2025-11-26 16:10:02 -03:00
20251125202538_rebake_posts_with_heading_anchors.rb A11Y: add aria-label to automatically generated heading anchor links in posts (#36232) 2025-11-25 18:29:20 -05:00
20251127001422_remove_orphaned_reviewable_claimed_topics.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20251202101647_remove_experimental_lightbox_site_setting.rb DEV: remove experimental lightbox site setting (#36377) 2025-12-03 15:54:10 +04:00
20251217030751_deprecate_reviewable_ui_refresh.rb DEV: Remove reviewable_ui_refresh feature flag and legacy code (#36752) 2026-02-23 10:45:36 +08:00
20251227224408_fix_null_targets_in_problem_check_trackers.rb FIX: Dismissing admin notices fails with 422 when tracker has NULL target (#36878) 2025-12-29 16:32:12 +01:00
20260106060807_add_slug_to_tags.rb DEV: Add slugs to tag model (#36985) 2026-01-08 11:03:01 +08:00
20260106060808_add_slug_indexes_to_tags.rb DEV: Add slugs to tag model (#36985) 2026-01-08 11:03:01 +08:00
20260108044513_drop_imap_sync_logs.rb DEV: Promote old post-deploy migrations to pre-deploy (#38595) 2026-03-13 19:09:30 +00:00
20260108060111_create_upcoming_change_events.rb FEATURE: Notify admins of upcoming changes and log events (#37003) 2026-01-21 12:45:54 +10:00
20260109041508_add_index_category_on_topics.rb PERF: Add index_topics_on_category_id (#37022) 2026-01-09 13:07:30 +08:00
20260112032646_drop_unused_top_topics_count_indexes.rb PERF: Drop unused indexes on top_topics table (#37053) 2026-01-12 12:55:28 +08:00
20260126204830_cleanup_unlisted_topic_hot_scores.rb FIX: Exclude unlisted topics from hot scores (#37312) 2026-01-27 13:46:57 +11:00
20260206000936_rename_experimental_auto_grid_images_setting.rb DEV: Rename experimental_ upcoming change settings (#37589) 2026-02-10 10:34:37 +10:00
20260206000937_rename_experimental_rename_faq_to_guidelines_setting.rb DEV: Rename experimental_ upcoming change settings (#37589) 2026-02-10 10:34:37 +10:00
20260206000938_rename_experimental_form_templates_setting.rb DEV: Rename experimental_ upcoming change settings (#37589) 2026-02-10 10:34:37 +10:00
20260206000939_rename_experimental_impersonation_setting.rb DEV: Rename experimental_ upcoming change settings (#37589) 2026-02-10 10:34:37 +10:00
20260209031949_add_index_to_tags_target_tag_id.rb FIX: Resolve tag synonyms in search and filter queries (#37628) 2026-02-09 15:57:52 +08:00
20260210223628_remove_bootstrap_mode_site_settings.rb UX: Remove Bootstrap Mode (#37694) 2026-02-17 16:46:32 -03:00
20260217064339_remove_force_old_reviewable_ui_site_setting.rb DEV: Remove reviewable_ui_refresh feature flag and legacy code (#36752) 2026-02-23 10:45:36 +08:00
20260306183220_add_topic_title_placeholder_to_categories.rb FEAT: category-specific topic title placeholder (#38593) 2026-03-16 10:23:57 -05:00
20260309032553_remove_enable_upcoming_changes_site_setting.rb DEV: Remove enable_upcoming_changes global setting gate (#38360) 2026-03-10 10:08:20 +10:00
20260310001245_remove_enable_category_type_setup_site_setting.rb DEV: Remove enable_category_type_setup hidden setting (#38396) 2026-03-10 09:27:33 +01:00
20260310072550_mark_category_approval_booleans_readonly.rb DEV: Move category approval settings to join table (#38523) 2026-03-16 10:20:26 +08:00
20260310072759_create_category_approval_groups.rb DEV: Move category approval settings to join table (#38523) 2026-03-16 10:20:26 +08:00
20260319054026_add_posting_review_modes_to_category_settings.rb FEATURE: Support group based category posting review modes (#38707) 2026-04-07 10:41:16 +08:00
20260323145627_add_limit_color_schemes_to_theme_modifier.rb FEATURE: add modifier to restrict theme color schemes (#38796) 2026-03-26 09:03:11 -04:00
20260325120000_create_nested_view_post_stats_in_core.rb FEATURE: First iteration of nested replies (#38888) 2026-04-16 08:06:44 -05:00
20260402023645_add_ignored_at_to_problem_check_trackers.rb FEATURE: Add problem checks page to admin panel and allow ignoring problem checks (#39103) 2026-04-23 08:28:33 +08:00
20260407093145_add_show_original_content_to_user_options.rb FEATURE: A dedicated 'show original' user preferences saved to user options (#39128) 2026-04-07 21:37:20 +08:00
20260409225129_add_og_image_upload_id_to_topics.rb FEATURE: generated OpenGraph images for topics (#39194) 2026-06-26 10:37:10 -04:00
20260415082426_add_reviewable_id_to_user_histories.rb FEATURE: Link staff action log entries to originating reviewable (#39519) 2026-04-30 09:15:45 +08:00
20260424004343_ensure_anonymous_and_logged_in_users_auto_groups.rb DEV: Rename anonymous group to anonymous_users (#40435) 2026-06-02 09:29:46 +10:00
20260428072232_add_index_on_reviewable_id_to_user_histories.rb FEATURE: Link staff action log entries to originating reviewable (#39519) 2026-04-30 09:15:45 +08:00
20260430142946_drop_powered_by_discourse_translation_override.rb UX: Don't include powered_by string in site text overrides (#39660) 2026-04-30 12:15:34 -04:00
20260504214551_remove_enable_custom_splash_screen_site_setting.rb DEV: make enable_custom_splash_screen permanent, remove upcoming change (#39720) 2026-05-05 11:55:25 -04:00
20260505161704_drop_splash_screen_site_setting.rb DEV: remove splash_screen site setting (#39758) 2026-05-06 10:22:33 -04:00
20260511044542_create_pageview_events.rb DEV: Add browser pageview events (#39878) 2026-05-12 11:27:27 +08:00
20260511080033_create_admin_dashboard_reports.rb DEV: Scaffold backend for the new admin dashboard Reports section (#40017) 2026-05-20 09:53:26 +03:00
20260513024004_add_browser_pageview_event_scores_and_asn.rb DEV: Add anonymous pageview crawler scoring job (#39954) 2026-05-14 12:46:08 +08:00
20260513055222_disable_horizon_high_context_topic_cards_for_existing_sites.rb FEATURE: Enable high context topic cards in Horizon by default (#39959) 2026-05-15 10:50:42 +10:00
20260513101242_mark_existing_sites_directory_columns_seeded.rb DEV: Move automatic directory_columns rows from migration to seed fixture (#39970) 2026-05-13 12:12:56 +01:00
20260513105516_mark_existing_sites_sidebar_seeded.rb DEV: Move Community sidebar section + links from migrations to seed fixture (#39973) 2026-05-13 12:13:12 +01:00
20260514043815_add_enable_upcoming_change_available_notifications_to_user_options.rb UX: Allow admins to opt out of upcoming change available notifications (#40020) 2026-05-18 12:10:18 +10:00
20260514055648_create_browser_pageview_event_scores.rb DEV: Persist per-heuristic crawler score breakdown (#40022) 2026-05-18 12:13:08 +08:00
20260518054805_fix_flags_id_seq_start.rb DEV: Persist flags_id_seq start value in structure.sql (#40109) 2026-05-18 17:13:40 +08:00
20260518072818_add_expires_at_to_user_api_keys.rb FEATURE: User API key device authorization flow (#40189) 2026-06-10 16:09:44 -04:00
20260518104900_fixup_id_sequences.rb DEV: Check & resolve sequence issues during db:check_structure_dump (#40118) 2026-05-18 15:23:41 +01:00
20260520090937_add_normalized_referrer_to_browser_pageview_events.rb FEATURE: Add top countries and top referrers cards to the admin dashboard (#40215) 2026-05-22 12:59:16 +08:00
20260522043337_add_country_and_referrer_indexes_to_browser_pageview_events.rb FEATURE: Add top countries and top referrers cards to the admin dashboard (#40215) 2026-05-22 12:59:16 +08:00
20260525105006_create_browser_pageview_country_daily_rollups.rb PERF: Daily rollups for top countries and top referrers reports (#40285) 2026-05-26 14:35:20 +08:00
20260525105009_create_browser_pageview_referrer_daily_rollups.rb PERF: Daily rollups for top countries and top referrers reports (#40285) 2026-05-26 14:35:20 +08:00
20260528074719_add_normalized_referrer_version_to_browser_pageview_events.rb FIX: Backfill normalized referrer for historical browser pageviews (#40357) 2026-06-09 09:04:57 +08:00
20260528074731_add_normalized_referrer_version_index_to_browser_pageview_events.rb FIX: Backfill normalized referrer for historical browser pageviews (#40357) 2026-06-09 09:04:57 +08:00
20260603115200_create_admin_dashboard_sections.rb DEV: Persist dashboard configuration in table and *not* on closure of the dialog (#40546) 2026-06-04 10:53:59 +08:00
20260608104742_add_compatibility_refs_to_remote_themes.rb FEATURE: Show theme d-compat/* refs in admin UI (#40649) 2026-06-17 22:13:45 +01:00
20260610064425_introduce_permission_acl_tables.rb FEATURE: Access control list UI and backend (#41009) 2026-06-29 09:44:58 +10:00
20260610205840_create_email_login_codes.rb FEATURE: Log in with a one-time email code (#40804) 2026-06-17 12:34:48 -07:00
20260615082047_add_source_to_browser_pageview_events.rb DEV: Track beacon browser pageviews behind dashboard_improvements (#40934) 2026-06-23 10:21:39 +08:00
20260615084100_remove_use_beacon_for_browser_page_views_site_setting.rb DEV: Track beacon browser pageviews behind dashboard_improvements (#40934) 2026-06-23 10:21:39 +08:00
20260616114637_add_external_plugin_imports_to_javascript_caches.rb DEV: Improve cross-plugin/theme import handling (#40939) 2026-06-30 16:11:38 +01:00
20260617053237_add_user_id_to_user_actions_action_type_created_at_index.rb PERF: Improve daily engaged users on new dashboard (#40968) 2026-06-17 15:32:29 +08:00
20260622140747_create_site_setting_localizations.rb FEATURE: Localizable /about page fields via its settings page (#41123) 2026-06-26 20:41:08 +08:00
20260623052745_create_browser_pageview_session_engagements.rb DEV: Track browser session engagement for crawler detection (#41215) 2026-07-01 09:17:48 +08:00
20260629210246_revoke_invalid_read_only_api_keys.rb FIX: Prevent read-only keys being created without scopes (#42280) 2026-08-03 15:45:48 -05:00
20260701073045_create_browser_pageview_session_engagement_daily_rollups.rb FEATURE: Show bounce rate and average session duration on the dashboard (#40936) 2026-07-03 10:49:32 +08:00
20260706050124_add_engagement_score_to_browser_pageview_event_scores.rb FEAT: Use session engagement in CrawlerScorer (#41693) 2026-07-27 11:37:34 +08:00
20260707013407_set_automatic_pseudogroups_visibility_to_logged_on_users.rb FIX: Make auto pseudogroups visible to logged on users (#41498) 2026-07-08 09:28:18 +10:00
20260707184146_add_push_notification_level_to_user_options.rb UX: Consolidate chat notifications into live notification preferences (#41538) 2026-07-14 08:32:48 +02:00
20260714152340_add_settings_to_admin_dashboard_sections.rb FEATURE: Persist "Activity by category" dashboard filter selection (#41758) 2026-07-17 10:54:28 +03:00
20260715113008_create_sidebar_localizations.rb FEATURE: Allow admins to localize custom sidebar section and links (#41795) 2026-07-21 21:45:50 +08:00
20260715134306_create_nested_hot_score_cache.rb FEATURE: Hot algorithm for nested replies (simple) (#41742) 2026-07-20 10:56:05 -05:00
20260715183411_add_admin_to_invites.rb FEATURE: Allow inviting new users directly as admins (#41748) 2026-07-16 14:59:24 -07:00
20260721110018_migrate_duplicate_topic_titles_settings.rb FIX: Scope duplicate topic title check to what the user can see (#41871) 2026-07-24 15:35:35 +02:00
20260723013754_create_user_visit_daily_rollups.rb PERF: Use daily rollups for DAU/MAU reports (#41958) 2026-07-24 09:52:40 +08:00
20260723183001_add_description_cooked_to_tags.rb FEATURE: Support markdown in tag descriptions (#41996) 2026-07-29 14:43:47 +01:00
20260727035337_create_category_activity_daily_rollups.rb PERF: Serve the activity_by_category report from daily rollups (#42046) 2026-07-28 12:53:29 +08:00
20260728033946_create_browser_pageview_crawler_daily_rollups.rb FEATURE: Reclassify likely crawlers in site traffic reporting (#42199) 2026-08-04 10:08:53 +08:00
20260728071552_add_ip_rotation_score_to_browser_pageview_event_scores.rb DEV: Score sessions that rotate IP addresses in CrawlerScorer (#42083) 2026-07-28 18:05:04 +08:00
20260728134532_add_content_language_preferences_to_user_options.rb FEATURE: Allow selection of multiple content languages when viewing topics and posts (#42128) 2026-07-30 12:19:44 +08:00
20260728162516_add_send_shortcut_to_user_options.rb FEATURE: Make the message send shortcut a core user option (#42105) 2026-07-28 13:58:12 -07:00
20260731055703_add_crawler_signals_to_browser_pageview_event_scores.rb FEATURE: Improve crawler detection of unengaged traffic (#42198) 2026-08-03 10:46:19 +08:00