Discourse/discourse
Discourse/discourse
0
0
Fork 0
mirror of https://gh.wpcy.net/https://github.com/discourse/discourse.git synced 2026-05-26 23:09:13 +08:00
Code Packages Activity Actions
discourse/db/migrate
History
Exact
Alan Guo Xiang Tan 2cc3ac34e7
PERF: Daily rollups for top countries and top referrers reports (#40285) 
Pre-aggregates the top countries and top referrers admin-dashboard
reports into two daily rollup tables. Both cards currently scan
`browser_pageview_events` and `GROUP BY` the relevant dimension on every
cold cache miss. At a few million events across 90 days that takes
hundreds of milliseconds, and on larger instances it crosses into
multi-second territory and can time out.

## New tables

### `browser_pageview_country_daily_rollups`

| Column | Type | Constraint |
|---|---|---|
| `id` | `bigint` | primary key |
| `date` | `date` | not null |
| `country_code` | `varchar(2)` | nullable (preserves NULL-country rows
for the denominator) |
| `count` | `bigint` | not null, total pageviews |
| `logged_in_count` | `bigint` | not null, pageviews where `user_id IS
NOT NULL` |

Unique index on `(date, country_code) NULLS NOT DISTINCT` for `ON
CONFLICT` idempotency including the null-country row.

### `browser_pageview_referrer_daily_rollups`

| Column | Type | Constraint |
|---|---|---|
| `id` | `bigint` | primary key |
| `date` | `date` | not null |
| `normalized_referrer` | `varchar(2000)` | nullable (direct visits) |
| `count` | `bigint` | not null |
| `logged_in_count` | `bigint` | not null |

Unique index on `(date, normalized_referrer) NULLS NOT DISTINCT`. Stores
every `normalized_referrer` value, including internal-host rows and
direct visits.

## Key technical decisions

- **Two count columns per row: `count` (total) and `logged_in_count`
(`user_id IS NOT NULL`).** The `login_required` site setting can be
toggled at any time. Selecting one or the other at read time produces
equivalent numbers without re-aggregating, matching the previous `AND
user_id IS NOT NULL` filter the reports applied at query time.

- **All referrers are stored in the rollup; internal-host exclusion is
applied at read time.** Aggregating away internal-navigation rows would
make the rollup lossy: a hostname change, misconfigured host, or future
change to the matching rule would silently corrupt historical reports
with no way to rebuild. Storing them keeps the rollup reversible at the
cost of a few extra rows per day. The read query applies the same-host
exclusion against the current `Discourse.current_hostname` so report
semantics match the previous event-scan behavior.

- **Scheduled job re-aggregates yesterday and today every 30 minutes.**
Cadence sits under the existing 35-minute report cache TTL. After each
run the job calls `Report.clear_cache` for both report types so any
previously-cached payload (including the empty payload an admin may have
loaded before the first run) is evicted, and the next dashboard load
picks up the fresh aggregate.

- **First scheduled run backfills automatically when rollups are
empty.** The job aggregates from the earliest available browser pageview
event through today, then switches to the incremental
yesterday-and-today window on later runs. No manual action required on
deploy.

## Benchmark

Local dataset: 3,000,000 `browser_pageview_events` rows across 90 days.
Default 30-day window, `LIMIT 5`.

### top_countries

**OLD query (event scan), `Execution Time: 391.752 ms`**

```sql
WITH ranked AS (
  SELECT
    country_code,
    COUNT(*) AS count,
    SUM(COUNT(*)) OVER () AS total
  FROM browser_pageview_events
  WHERE created_at >= NOW() - INTERVAL '90 days'
    AND created_at < NOW() + INTERVAL '1 day'
  GROUP BY country_code
)
SELECT country_code, count,
       CASE WHEN total = 0 THEN 0
            ELSE ROUND((count::numeric / total) * 100)::integer END AS percent
FROM ranked
WHERE country_code IS NOT NULL
  AND country_code NOT IN ('ZZ','T1','A1','A2','O1','XX','EU','AP')
ORDER BY count DESC, country_code ASC
LIMIT 5;
```

```
Limit  (cost=102139.99..102139.99 rows=2 width=15) (actual time=378.507..382.429 rows=5 loops=1)
  ->  Sort  (cost=102139.99..102139.99 rows=2 width=15) (actual time=373.538..377.460 rows=5 loops=1)
        Sort Key: ranked.count DESC, ranked.country_code
        Sort Method: quicksort  Memory: 25kB
        ->  Subquery Scan on ranked  (cost=102137.09..102139.98 rows=2 width=15) (actual time=373.521..377.447 rows=10 loops=1)
              Filter: ((ranked.country_code IS NOT NULL) AND ((ranked.country_code)::text <> ALL ('{ZZ,T1,A1,A2,O1,XX,EU,AP}'::text[])))
              Rows Removed by Filter: 1
              ->  WindowAgg  (cost=102137.09..102139.75 rows=10 width=43) (actual time=373.514..377.437 rows=11 loops=1)
                    ->  Finalize GroupAggregate  (cost=102137.09..102139.62 rows=10 width=11) (actual time=373.501..377.426 rows=11 loops=1)
                          Group Key: browser_pageview_events.country_code
                          ->  Gather Merge  (cost=102137.09..102139.42 rows=20 width=11) (actual time=373.493..377.417 rows=33 loops=1)
                                Workers Planned: 2
                                Workers Launched: 2
                                ->  Sort  (cost=101137.07..101137.09 rows=10 width=11) (actual time=366.783..366.784 rows=11 loops=3)
                                      Sort Key: browser_pageview_events.country_code
                                      Sort Method: quicksort  Memory: 25kB
                                      ->  Partial HashAggregate  (cost=101136.80..101136.90 rows=10 width=11) (actual time=366.768..366.768 rows=11 loops=3)
                                            Group Key: browser_pageview_events.country_code
                                            ->  Parallel Seq Scan on browser_pageview_events  (cost=0.00..94886.64 rows=1250033 width=3) (actual time=2.349..294.932 rows=999978 loops=3)
                                                  Filter: ((created_at >= (now() - '90 days'::interval)) AND (created_at < (now() + '1 day'::interval)))
                                                  Rows Removed by Filter: 22
 Planning Time: 0.446 ms
 JIT:
   Functions: 31
   Timing: Generation 0.887 ms, Inlining 0.000 ms, Optimization 0.572 ms, Emission 11.441 ms, Total 12.900 ms
 Execution Time: 391.752 ms
```

**NEW query (rollup), `Execution Time: 0.408 ms`**

```sql
WITH ranked AS (
  SELECT
    country_code,
    SUM(count) AS count,
    SUM(SUM(count)) OVER () AS total
  FROM browser_pageview_country_daily_rollups
  WHERE date >= (NOW() - INTERVAL '90 days')::date
    AND date < (NOW() + INTERVAL '1 day')::date
  GROUP BY country_code
  HAVING SUM(count) > 0
)
SELECT country_code, count,
       CASE WHEN total = 0 THEN 0
            ELSE ROUND((count::numeric / total) * 100)::integer END AS percent
FROM ranked
WHERE country_code IS NOT NULL
  AND country_code NOT IN ('ZZ','T1','A1','A2','O1','XX','EU','AP')
ORDER BY count DESC, country_code ASC
LIMIT 5;
```

```
Limit  (cost=43.25..43.26 rows=1 width=39) (actual time=0.352..0.353 rows=5 loops=1)
  ->  Sort  (cost=43.25..43.26 rows=1 width=39) (actual time=0.351..0.352 rows=5 loops=1)
        Sort Key: ranked.count DESC, ranked.country_code
        Sort Method: quicksort  Memory: 25kB
        ->  Subquery Scan on ranked  (cost=42.98..43.24 rows=1 width=39) (actual time=0.330..0.334 rows=10 loops=1)
              Filter: ((ranked.country_code IS NOT NULL) AND ((ranked.country_code)::text <> ALL ('{ZZ,T1,A1,A2,O1,XX,EU,AP}'::text[])))
              Rows Removed by Filter: 1
              ->  WindowAgg  (cost=42.98..43.17 rows=3 width=67) (actual time=0.326..0.327 rows=11 loops=1)
                    ->  HashAggregate  (cost=42.98..43.13 rows=3 width=35) (actual time=0.311..0.313 rows=11 loops=1)
                          Group Key: browser_pageview_country_daily_rollups.country_code
                          Filter: (sum(browser_pageview_country_daily_rollups.count) > '0'::numeric)
                          Batches: 1  Memory Usage: 24kB
                          ->  Seq Scan on browser_pageview_country_daily_rollups  (cost=0.00..38.03 rows=990 width=11) (actual time=0.007..0.237 rows=990 loops=1)
                                Filter: ((date >= ((now() - '90 days'::interval))::date) AND (date < ((now() + '1 day'::interval))::date))
                                Rows Removed by Filter: 11
 Planning Time: 0.446 ms
 Execution Time: 0.408 ms
```

### top_referrers

**OLD query (event scan), `Execution Time: 361.565 ms`**

```sql
WITH ranked AS (
  SELECT
    normalized_referrer,
    COUNT(*) AS count,
    SUM(COUNT(*)) OVER () AS total
  FROM browser_pageview_events
  WHERE created_at >= NOW() - INTERVAL '90 days'
    AND created_at < NOW() + INTERVAL '1 day'
    AND (
      normalized_referrer IS NULL
      OR (
        normalized_referrer <> 'forum.example.com'
        AND normalized_referrer NOT LIKE 'forum.example.com/%' ESCAPE '\'
        AND normalized_referrer NOT LIKE 'forum.example.com?%' ESCAPE '\'
      )
    )
  GROUP BY normalized_referrer
)
SELECT normalized_referrer, count,
       CASE WHEN total = 0 THEN 0
            ELSE ROUND((count::numeric / total) * 100)::integer END AS percent
FROM ranked
WHERE normalized_referrer IS NOT NULL
ORDER BY count DESC, normalized_referrer ASC
LIMIT 5;
```

```
Limit  (cost=108521.27..108521.28 rows=5 width=32) (actual time=356.291..361.113 rows=5 loops=1)
  ->  Sort  (cost=108521.27..108521.53 rows=106 width=32) (actual time=351.128..355.949 rows=5 loops=1)
        Sort Key: ranked.count DESC, ranked.normalized_referrer
        Sort Method: quicksort  Memory: 25kB
        ->  Subquery Scan on ranked  (cost=108488.40..108519.51 rows=106 width=32) (actual time=351.121..355.944 rows=6 loops=1)
              Filter: (ranked.normalized_referrer IS NOT NULL)
              Rows Removed by Filter: 1
              ->  WindowAgg  (cost=108488.40..108516.85 rows=107 width=60) (actual time=351.117..355.939 rows=7 loops=1)
                    ->  Finalize GroupAggregate  (cost=108488.40..108515.51 rows=107 width=28) (actual time=351.107..355.931 rows=7 loops=1)
                          Group Key: browser_pageview_events.normalized_referrer
                          ->  Gather Merge  (cost=108488.40..108513.37 rows=214 width=28) (actual time=351.102..355.925 rows=21 loops=1)
                                Workers Planned: 2
                                Workers Launched: 2
                                ->  Sort  (cost=107488.38..107488.65 rows=107 width=28) (actual time=341.058..341.059 rows=7 loops=3)
                                      Sort Key: browser_pageview_events.normalized_referrer
                                      ->  Partial HashAggregate  (cost=107483.70..107484.77 rows=107 width=28) (actual time=341.044..341.045 rows=7 loops=3)
                                            Group Key: browser_pageview_events.normalized_referrer
                                            ->  Parallel Seq Scan on browser_pageview_events  (cost=0.00..104262.13 rows=644315 width=20) (actual time=2.982..281.076 rows=846138 loops=3)
                                                  Filter: ((created_at >= (now() - '90 days'::interval)) AND (created_at < (now() + '1 day'::interval)) AND ((normalized_referrer IS NULL) OR (((normalized_referrer)::text <> 'forum.example.com'::text) AND ((normalized_referrer)::text !~~ 'forum.example.com/%'::text) AND ((normalized_referrer)::text !~~ 'forum.example.com?%'::text))))
                                                  Rows Removed by Filter: 153862
 Planning Time: 0.134 ms
 JIT:
   Functions: 31
   Timing: Generation 1.277 ms, Inlining 0.000 ms, Optimization 0.674 ms, Emission 13.385 ms, Total 15.336 ms
 Execution Time: 361.565 ms
```

**NEW query (rollup), `Execution Time: 1.131 ms`**

```sql
WITH ranked AS (
  SELECT
    normalized_referrer,
    SUM(count) AS count,
    SUM(SUM(count)) OVER () AS total
  FROM browser_pageview_referrer_daily_rollups
  WHERE date >= (NOW() - INTERVAL '90 days')::date
    AND date < (NOW() + INTERVAL '1 day')::date
    AND (
      normalized_referrer IS NULL
      OR (
        normalized_referrer <> 'forum.example.com'
        AND normalized_referrer NOT LIKE 'forum.example.com/%' ESCAPE '\'
        AND normalized_referrer NOT LIKE 'forum.example.com?%' ESCAPE '\'
      )
    )
  GROUP BY normalized_referrer
  HAVING SUM(count) > 0
)
SELECT normalized_referrer, count,
       CASE WHEN total = 0 THEN 0
            ELSE ROUND((count::numeric / total) * 100)::integer END AS percent
FROM ranked
WHERE normalized_referrer IS NOT NULL
ORDER BY count DESC, normalized_referrer ASC
LIMIT 5;
```

```
Limit  (cost=486.29..486.31 rows=5 width=64) (actual time=0.984..0.985 rows=5 loops=1)
  ->  Sort  (cost=486.29..486.38 rows=36 width=64) (actual time=0.984..0.984 rows=5 loops=1)
        Sort Key: ranked.count DESC, ranked.normalized_referrer
        Sort Method: quicksort  Memory: 25kB
        ->  Subquery Scan on ranked  (cost=482.83..485.69 rows=36 width=64) (actual time=0.928..0.930 rows=6 loops=1)
              Filter: (ranked.normalized_referrer IS NOT NULL)
              Rows Removed by Filter: 1
              ->  WindowAgg  (cost=482.83..484.88 rows=36 width=92) (actual time=0.916..0.917 rows=7 loops=1)
                    ->  HashAggregate  (cost=482.83..484.43 rows=36 width=60) (actual time=0.887..0.888 rows=7 loops=1)
                          Group Key: browser_pageview_referrer_daily_rollups.normalized_referrer
                          Filter: (sum(browser_pageview_referrer_daily_rollups.count) > '0'::numeric)
                          Batches: 1  Memory Usage: 24kB
                          ->  Seq Scan on browser_pageview_referrer_daily_rollups  (cost=0.00..478.55 rows=856 width=36) (actual time=0.005..0.835 rows=630 loops=1)
                                Filter: (((normalized_referrer IS NULL) OR (((normalized_referrer)::text <> 'forum.example.com'::text) AND ((normalized_referrer)::text !~~ 'forum.example.com/%'::text) AND ((normalized_referrer)::text !~~ 'forum.example.com?%'::text))) AND (date >= ((now() - '90 days'::interval))::date) AND (date < ((now() + '1 day'::interval))::date))
                                Rows Removed by Filter: 9198
 Planning Time: 0.544 ms
 Execution Time: 1.131 ms
```

~960x speedup on top_countries (391.752 ms → 0.408 ms) and ~320x on
top_referrers (361.565 ms → 1.131 ms). The new path's query plan does
not touch `browser_pageview_events` at all, so its latency is
structurally independent of event volume.
2026-05-26 14:35:20 +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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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
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 DEV: Fix Lint/BooleanSymbol (#24747) 2023-12-06 13:19:09 +01:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20150713203955_enlarge_users_email_field.rb DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20150729150523_migrate_auto_close_posts.rb resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20150730154830_add_position_to_user_fields.rb
20150731225331_migrate_old_moved_posts.rb resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Fix Lint/BooleanSymbol (#24747) 2023-12-06 13:19:09 +01:00
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 DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
20180207163946_create_category_tag_stats.rb
20180221215641_add_suppress_from_latest_to_categories.rb DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 DEV: Update to lastest rubocop-discourse 2024-05-27 18:06:14 +02:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
20180917034056_remove_superfluous_tables.rb DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
20180920023559_add_external_details_to_user_fields.rb
20180920042415_create_user_uploads.rb
20180927135248_create_javascript_caches.rb
20180928105835_add_index_to_tags.rb DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 DEV: Bump rubocop_discourse (#29608) 2024-11-06 06:27:49 +08:00
20181031165343_add_flag_stats_to_user.rb DEV: move post flags into database (#27125) 2024-05-23 12:19:07 +10:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Bump rubocop_discourse (#29608) 2024-11-06 06:27:49 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20190508135348_rename_site_setting_default_topics.rb
20190508141327_create_reviewable_claimed_topics.rb
20190508141824_drop_claimed_by_id.rb resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20190508193900_add_missing_uploads_ignored_index_to_post_custom_fields.rb
20190513143015_add_theme_id_to_javascript_cache.rb DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
20200417183143_add_created_at_to_badge_user.rb
20200424032633_remove_canonical_email_from_user_emails.rb DEV: lint against Layout/EmptyLineBetweenDefs (#24914) 2023-12-15 23:46:04 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 FIX: Inline deprecated settings in migration file (#22737) 2023-07-21 12:22:00 +08:00
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 FIX: Inline deprecated settings in migration file (#22737) 2023-07-21 12:22:00 +08:00
20200728000854_duplicate_allowed_paths_from_path_whitelist.rb
20200728004302_drop_path_whitelist_from_embeddable_hosts.rb DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Bump rubocop_discourse (#29608) 2024-11-06 06:27:49 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Fix Lint/BooleanSymbol (#24747) 2023-12-06 13:19:09 +01:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
20220214233625_add_bounce_error_code_to_email_log.rb
20220215015538_drop_user_stat_count_constraints.rb DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
20220220234155_conform_bounce_error_code.rb DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
20220302163246_update_avatar_service_domain.rb
20220302171443_rebake_old_avatar_service_urls.rb DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
20220519190829_create_user_statuses.rb
20220526203356_copy_user_uploads_to_upload_references.rb
20220606061813_add_smtp_transaction_response_to_email_logs.rb DEV: Move migration to the correct directory (#22309) 2023-06-27 23:01:39 +02:00
20220607150432_disallow_null_emoji_on_user_status.rb
20220617151846_rename_default_categories_regular_setting.rb DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
20220621164914_drop_flair_url_from_groups.rb DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 DEV: Promote historic post_deploy migrations 2023-07-26 10:36:37 +02:00
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 DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
20230105153520_trigger_post_rebake_local_onebox_xss.rb DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
20230111223803_delete_misconfigured_embeddable_hosts.rb
20230113002617_reindex_invalid_indexes.rb DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
20230115233416_create_sidebar_sections.rb
20230117002110_create_sidebar_url.rb
20230117143451_drop_invalid_drafts.rb DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
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 DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
20230119091939_drop_orphaned_reviewable_flagged_posts.rb DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
20230227050147_update_badge_icons.rb
20230228105851_drop_badge_granted_title_column.rb DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
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 resolve Rails/ReversibleMigrationMethodDefinition errors (#29412) 2024-10-25 15:13:06 +08:00
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 DEV: Promote historic post_deploy migrations (#25329) 2024-01-19 13:59:20 +00:00
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 FEATURE: Separated 'trusted users can edit others' setting for trust level 3 & 4 (#21493) 2023-07-07 10:48:14 -05:00
20230515103515_create_watched_word_groups.rb FEATURE: Allow watched words to be created as a group (#26632) 2024-04-29 15:50:55 +05:30
20230515131111_add_watched_word_group_id_to_watched_words.rb FEATURE: Allow watched words to be created as a group (#26632) 2024-04-29 15:50:55 +05:30
20230523073109_delete_old_personal_message_settings.rb
20230528134326_enable_experimental_hashtag_autocomplete_true_for_all_sites.rb
20230602034711_rename_everything_to_topics_link.rb FIX: rename everything link to topics (#22076) 2023-06-15 11:36:38 +10:00
20230608163854_create_summary_sections_table.rb DEV: Cache summarization strategy results. (#22230) 2023-06-27 11:44:34 -03:00
20230614011312_rename_default_sidebar_categories_setting.rb FIX: Update sidebar to be navigation menu (#22101) 2023-06-15 09:31:28 +10:00
20230614011419_rename_default_sidebar_tags_setting.rb FIX: Update sidebar to be navigation menu (#22101) 2023-06-15 09:31:28 +10:00
20230618041001_add_sidebar_link_to_filtered_list_to_user_option.rb FEATURE: Split navigation preference for count and behavior of sidebar links (#22203) 2023-06-22 19:04:13 +03:00
20230618041123_add_sidebar_show_count_of_new_items_to_user_option.rb FEATURE: Split navigation preference for count and behavior of sidebar links (#22203) 2023-06-22 19:04:13 +03:00
20230620050614_remove_default_sidebar_list_destination_setting.rb FEATURE: Split navigation preference for count and behavior of sidebar links (#22203) 2023-06-22 19:04:13 +03:00
20230627060104_remove_new_edit_sidebar_categories_tags_interface_groups_site_setting.rb UX: Use modals to edit categories and tags that appear in sidebar (#22295) 2023-06-28 07:20:31 +08:00
20230628062236_add_watched_precedence_over_muted_to_user_options.rb FEATURE: allow user to override watched_precedence_over_muted setting (#22340) 2023-07-04 15:08:29 +10:00
20230703035052_add_status_to_translation_overrides.rb FEATURE: Warn about outdated translation overrides in admin dashboard (#22384) 2023-07-10 10:06:40 +08:00
20230707031122_add_watched_precedence_over_muted_index_to_user_options.rb FIX: more performance improvement for PostAlert job (#22487) 2023-07-13 09:02:23 +10:00
20230708011310_fix_reviewable_queued_posts_target_created_by_id.rb FIX: Keep ReviewableQueuedPosts even with user delete reviewable actions (#22501) 2023-07-18 11:50:31 +00:00
20230712011946_add_topic_id_notification_level_index_to_topic_users.rb FIX: more performance improvement for PostAlert job (#22487) 2023-07-13 09:02:23 +10:00
20230712013248_add_category_id_notification_level_index_to_category_users.rb FIX: more performance improvement for PostAlert job (#22487) 2023-07-13 09:02:23 +10:00
20230727015030_add_index_topic_id_created_at_on_posts.rb PERF: Add index on topic_id and created_at to posts table (#22818) 2023-07-27 10:55:10 +08:00
20230727015254_change_category_setting_num_auto_bump_daily_default.rb FIX: Account for empty string setting values when migrating category settings (#22979) 2023-08-04 20:57:48 +08:00
20230728055813_delete_orphaned_draft_upload_references.rb DEV: Delete upload references upon deleting draft (#22851) 2023-07-31 10:16:23 +08:00
20230807033021_add_group_to_web_hook_event_type.rb FEATURE: granular webhooks (#23070) 2023-10-09 03:35:31 +00:00
20230807040058_move_web_hooks_to_new_event_ids.rb FEATURE: granular webhooks (#23070) 2023-10-09 03:35:31 +00:00
20230816211907_increase_size_of_sidebar_urls.rb FIX: increase sidebar URL limit to 1000 (#23120) 2023-08-17 14:46:24 +10:00
20230817174049_ensure_javascript_cache_is_unique_per_theme.rb FIX: Ensure javascript caches are unique per theme/theme_field (#23126) 2023-08-17 13:57:04 -05:00
20230823095931_add_limit_to_user_second_factor_name.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20230823100627_add_limit_to_user_security_key_name.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20230831153649_delete_unused_site_settings.rb DEV: Delete unused site settings (#23353) 2023-08-31 18:19:55 -06:00
20230906030920_change_auto_silence_fast_typers_setting_to_enum_type.rb DEV: Change fast typer trust level setting to enum type (#23429) 2023-09-06 17:35:11 +08:00
20230907225057_create_theme_settings_migrations.rb FEATURE: Theme settings migrations (#24071) 2023-11-02 08:10:15 +03:00
20230910021213_update_category_setting_approval_values.rb DEV: Switch over category settings to new table - Part 3 (#20657) 2023-09-12 09:51:49 +08:00
20230913194832_rename_revoke_api_keys_settings.rb FEATURE: site settings to revoke api keys older than a number of days (#23595) 2023-09-15 16:31:29 -03:00
20230926165821_drop_post_uploads_table.rb DEV: Remove logical OR assignment of constants (#29201) 2024-10-16 10:09:07 +08:00
20231004020328_migrate_legacy_navigation_menu_site_setting.rb FEATURE: Remove support for legacy navigation menu (#23752) 2023-10-09 07:24:10 +08:00
20231017044708_remove_enable_experimental_hashtag_autocomplete_setting.rb DEV: Remove hashtag autocomplete experimental setting (#23954) 2023-10-17 15:05:58 +10:00
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 FIX: Typo in migration (#24089) 2023-10-25 12:54:25 +10:00
20231103060018_fix_invalid_topic_user_bookmarked_data.rb FIX: Deleting/recovering a post in topics caused bookmark side effects (#24226) 2023-11-07 12:54:05 +10:00
20231107014123_migrate_shared_drafts_min_trust_level_to_group.rb DEV: Move shared_drafts_min_trust_level to group setting (#24257) 2023-11-07 14:03:25 +10:00
20231107055903_migrate_min_trust_level_for_here_mention_to_group.rb DEV: Add conflict resolution to migration min trust level for here mention to group (#25667) 2024-02-13 17:19:17 -08:00
20231111201253_rename_experimental_passkeys_site_setting.rb DEV: Rename experimental_passkeys to enable_passkeys (#24349) 2023-11-13 15:04:15 -05:00
20231117182638_fill_approve_unless_allowed_groups_based_on_deprecated_settings.rb DEV: Convert approve_unless_trust_level to groups (#24357) 2023-11-21 11:31:42 -07:00
20231120190818_trigger_post_rebake_category_style_quotes.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20231122043756_increase_size_of_tag_descriptions.rb FEATURE: increase tag description limit to 1000 (#24561) 2023-11-28 08:45:40 +11:00
20231122152552_fill_new_topics_unless_allowed_groups_based_on_deprecated_settings.rb DEV: Convert approve_new_topics_unless_trust_level to groups (#24504) 2023-11-22 10:44:59 -07:00
20231122212122_fill_email_in_allowed_groups_based_on_deprecated_settings.rb DEV: Convert email_in_min_trust to groups (#24515) 2023-11-22 18:03:28 -07:00
20231127165331_trigger_auto_linking_for_videos_since_placeholder.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20231205013029_fill_uploaded_avatars_allowed_groups_based_on_deprecated_settings.rb DEV: Convert allow_uploaded_avatars to groups (#24810) 2023-12-13 10:53:19 +11:00
20231206041353_fill_create_topic_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_create_topic to groups (#24740) 2023-12-13 14:50:13 +11:00
20231207011238_fill_edit_wiki_post_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_edit_wiki_post to groups (#24766) 2023-12-12 15:20:37 +11:00
20231212044856_fill_edit_post_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_edit_post to groups (#24840) 2023-12-13 13:25:13 +08:00
20231213060822_fill_flag_post_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_flag_posts setting to groups (#24864) 2023-12-13 17:18:42 +08:00
20231213103248_fill_delete_all_posts_and_topics_allowed_groups_based_on_deprecated_settings.rb DEV: Convert tl4_delete_posts_and_topics to groups (#24866) 2023-12-14 09:56:42 +08:00
20231214020814_fill_user_card_background_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_level_to_allow_user_card_background to groups (#24891) 2023-12-14 10:57:58 +08:00
20231214023728_fill_invite_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_level_to_allow_invite to groups (#24893) 2023-12-18 12:07:36 +08:00
20231214031754_fill_ignore_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_level_to_allow_ignore to groups (#24894) 2023-12-18 13:04:37 +08:00
20231214061615_fill_create_tag_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_level_to_create_tag to groups (#24899) 2024-01-05 10:19:43 +08:00
20231218081901_fill_send_email_messages_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_send_email_messages to groups (#24942) 2024-01-09 09:47:06 +08:00
20231222030024_fill_self_wiki_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_allow_self_wiki to groups (#25009) 2023-12-27 09:21:39 +08:00
20240104155715_add_embed_content_cache_to_topic_embed.rb FEATURE: Cache embed contents in the database (#25133) 2024-01-05 10:09:31 -03:00
20240108022138_change_enable_admin_sidebar_to_group_post_migration.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20240110040813_fill_skip_review_media_groups_based_on_deprecated_setting.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20240112021335_set_max_clean_orphan_uploads_grace_period_hours.rb FIX: Enforce proper max for clean_orphan_uploads_grace_period_hours (#25235) 2024-01-15 10:32:07 +08:00
20240112043325_fill_embedded_media_post_allowed_groups_based_on_deprecated_setting.rb DEV: Promote historic post_deploy migrations (#28127) 2024-07-30 00:49:21 +08:00
20240112073149_fill_tag_topic_allowed_groups_based_on_deprecated_settings.rb DEV: Update min trust level to tag topics migration to groups (#25527) 2024-02-05 09:49:54 -07:00
20240116043702_create_topic_hot_scores.rb FEATURE: experiment with hot sort order (#25274) 2024-01-17 13:01:04 +11:00
20240116182229_migrate_lazy_load_categories_to_groups.rb DEV: Make lazy_load_categories setting use groups (#25282) 2024-01-17 20:26:51 +02:00
20240117090801_fill_post_links_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_to_post_links to groups (#25298) 2024-01-18 14:08:40 +08:00
20240117093148_fill_user_api_key_allowed_groups_based_on_deprecated_settings.rb DEV: Convert min_trust_level_for_user_api_key to groups (#25299) 2024-01-19 11:25:24 +08:00
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 DEV: Introduce experimental type: objects theme setting (#25538) 2024-02-08 10:20:59 +08:00
20240202052058_drop_badge_image_column.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240202204030_fix_here_mention_allowed_groups_setting.rb DEV: Correct some tl to group site setting changes (#25550) 2024-02-05 09:50:46 -07:00
20240204204532_add_user_to_permalink.rb FEATURE: Permalinks for users (#25552) 2024-02-05 17:31:31 +01:00
20240212034010_drop_deprecated_columns.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240216073624_fill_profile_background_allowed_groups_based_on_deprecated_setting.rb DEV: Change min_trust_level_to_allow_profile_background to trust level setting (#25721) 2024-02-19 10:47:47 +10:00
20240219012001_remove_enable_experimental_admin_ui_groups_site_settings.rb DEV: Make more group-based settings client: false (#25735) 2024-02-19 13:25:59 +11:00
20240223052820_create_problem_check_trackers.rb DEV: Add DB backed problem checks to support perform_every config (#25834) 2024-02-27 11:17:39 +08:00
20240301033753_delete_old_bookmark_reminder_setting.rb DEV: Delete old enable_bookmarks_with_reminders setting (#25982) 2024-03-04 13:48:04 +10:00
20240304030429_topic_id_on_incoming_email_index.rb DEV: Fix migration that adds index to incoming_emails topic_id (#26007) 2024-03-04 16:52:20 +08:00
20240306063428_add_indexes_to_notifications.rb PERF: Add indexes to speed up notifications queries by user menu (#26048) 2024-03-06 16:52:19 +08:00
20240307231053_add_topics_unread_when_closed_to_user_options.rb FEATURE: Silence Close Notifications User Setting (#26072) 2024-03-08 15:14:46 -07:00
20240311015942_create_admin_notices.rb DEV: Database backed admin notices (#26192) 2024-05-23 09:29:08 +08:00
20240326200232_add_custom_homepage_theme_modifiers.rb DEV: allow themes to render their own custom homepage (#26291) 2024-04-02 11:05:08 -04:00
20240327000440_replace_post_reply_index.rb PERF: Replace posts reply_to_post_number index (#26385) 2024-03-27 09:56:29 +08:00
20240327043323_disable_admin_sidebar_for_existing_sites.rb FEATURE: enable new admin sidebar by default (#26391) 2024-04-08 09:57:27 +10:00
20240401054228_add_details_to_problem_check_trackers.rb DEV: Database backed admin notices (#26192) 2024-05-23 09:29:08 +08:00
20240404034232_remove_experimental_objects_type_for_theme_settings.rb DEV: Remove experimental_objects_type_for_theme_settings site setting (#26507) 2024-04-04 12:01:31 +08:00
20240422015830_remove_admin_guide_tooltip_from_seen_popups.rb FEATURE: after wizard admin is redirected to the guide page (#26696) 2024-04-23 10:04:15 +10:00
20240423013808_add_visibility_reason_id_to_topics.rb FIX: Better tracking of topic visibility changes (#26709) 2024-04-29 10:34:46 +10:00
20240423054323_create_flags.rb DEV: move post flags into database (#27125) 2024-05-23 12:19:07 +10:00
20240430051551_add_user_id_to_embeddable_hosts.rb FEATURE: Extend embeddable hosts with Individual tags and author assignments (#26868) 2024-05-16 15:47:01 -04:00
20240430052017_create_embeddable_host_tags.rb FEATURE: Extend embeddable hosts with Individual tags and author assignments (#26868) 2024-05-16 15:47:01 -04:00
20240430185434_fix_watched_words_without_action.rb FIX: Watched Words (+ Groups) with missing action (#26826) 2024-04-30 15:36:02 -04:00
20240506035024_clear_orphaned_draft_upload_references.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240506125839_add_html_to_watched_words.rb FEATURE: add HTML replacements 2024-05-14 10:41:27 +02:00
20240510073417_increase_external_avatar_url_limit.rb DEV: Increase external avatar url limit (#26966) 2024-05-10 16:19:23 +08:00
20240517014119_add_target_to_problem_check_trackers.rb DEV: Database backed admin notices (#26192) 2024-05-23 09:29:08 +08:00
20240517051933_disambiguate_problem_check_tracker_uniqueness.rb DEV: Database backed admin notices (#26192) 2024-05-23 09:29:08 +08:00
20240520060901_add_requirement_to_user_fields.rb FEATURE: Implement new required options in admin user fields UI (#27079) 2024-05-23 19:18:25 +08:00
20240527015009_add_topic_view_stats.rb FEATURE: topic_view_stats table with daily fidelity (#27197) 2024-05-27 15:25:32 +10:00
20240527055057_add_score_type_to_flags.rb FEATURE: admin can disable flags (#27171) 2024-05-29 14:39:58 +10:00
20240531053226_create_user_required_fields_version.rb FEATURE: User fields required for existing users - Part 2 (#27172) 2024-06-25 19:32:18 +08:00
20240603234529_create_user_passwords.rb FEATURE: Allow site admin to mark a user's password as expired (#27314) 2024-06-04 15:42:53 +08:00
20240606003822_reorder_flags.rb FIX: move something else flag to the bottom (#27366) 2024-06-06 15:45:30 +10:00
20240610150449_limit_tag_group_name_length.rb SECURITY: Fixes for main (#28137) 2024-07-30 14:19:01 +08:00
20240612063735_add_field_type_enum_to_user_fields.rb DEV: Change UserField#field_type to an ActiveRecord enum (#27444) 2024-06-12 15:30:13 +08:00
20240612073116_swap_field_type_with_field_type_enum_on_user_fields.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240619123052_create_web_hook_events_daily_aggregates.rb FEATURE: Add WebHookEventsDailyAggregate (#27542) 2024-06-25 13:56:47 -03:00
20240620024938_add_back_field_type_enum_to_user_fields.rb FIX: Prevent field type migration from poisoning AR cache (#27549) 2024-06-20 16:24:48 +08:00
20240627125112_remove_invalid_csp_script_src_site_setting_values.rb DEV: Remove invalid content_security_policy_script_src site setting values from DB (#27588) 2024-06-27 22:17:56 +08:00
20240627155730_create_redelivering_webhook_events.rb FEATURE: Add Mechanism to redeliver all failed webhook events (#27609) 2024-07-08 15:43:16 -05:00
20240705134114_clear_orphaned_draft_upload_references2.rb FIX: Destroy Drafts when increasing sequences (#27739) 2024-07-10 10:43:11 +03:00
20240705153533_add_user_agent_to_search_logs.rb DEV: Add user_agent column to search_logs (#27742) 2024-07-05 14:05:00 -05:00
20240709010639_remove_cross_origin_unsafe_none_referrers_setting.rb FEATURE: Use group based setting for unsafe-none COOP (#27783) 2024-07-09 11:25:49 -05:00
20240709015048_remove_logging_provider_site_setting.rb DEV: Drop logging_provider site setting (#27785) 2024-07-09 10:00:44 +08:00
20240711123755_drop_compiled_js_from_translation_overrides.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240712050324_default_github_onebox_token.rb FEATURE: Allow for multiple GitHub onebox tokens (#27887) 2024-07-15 13:07:36 +10:00
20240714231226_duplicate_flags_custom_type_to_require_message.rb DEV: drop readonly from flags custom type (#27960) 2024-07-18 11:45:08 +10:00
20240714231516_drop_custom_type_from_flags.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240715073605_add_smtp_ssl_mode_to_groups.rb UX: Use a dropdown for SSL mode for group SMTP (#27932) 2024-07-18 10:33:14 +10:00
20240717053710_drop_groups_smtp_ssl.rb DEV: Promote historic post_deploy migrations (#30959) 2025-01-24 10:57:12 -03:00
20240717171840_rename_chat_preferred_mobile_index_setting.rb DEV: rename chat preferred mobile index to chat preferred index (#27953) 2024-07-30 10:25:22 -03:00
20240722025822_add_user_id_to_custom_emojis.rb FEATURE: Add creator and logging for CustomEmoji (#28004) 2024-07-22 14:44:49 +08:00
20240723030506_add_post_id_index_to_user_histories.rb FEATURE: Clean up previously logged information after permanently deleting posts (#28033) 2024-07-23 15:27:11 +08:00
20240724021732_add_login_method_to_user_auth_tokens.rb FIX: store information about the login method in the database. (#28054) 2024-07-24 17:19:58 +10:00
20240725042522_remove_experimental_flags_admin_page_site_setting.rb DEV: show admin moderation flags UI (#28071) 2024-07-25 15:24:17 +10:00
20240729084803_create_user_api_key_clients.rb Add dedicated user_api_key_clients table to allow for 1:many use cases (#28119) 2024-11-08 12:05:03 -05:00
20240731143458_remove_chat_default_channel_id.rb FIX: Remove chat default channel setting (#28170) 2024-07-31 14:12:10 -03:00
20240731190511_update_invalid_allowed_iframe_values.rb DEV: Add validation for allowed iframes setting (#28178) 2024-08-01 06:51:02 -06:00
20240807024301_update_delete_merged_stub_topics_after_days_setting.rb FEATURE: Add option to immediately delete stub topics upon merge (#28228) 2024-08-07 10:05:40 -03:00
20240815234500_remove_glimmer_header_mode_setting.rb DEV: Remove the old header widgets code (#28390) 2024-09-04 14:50:53 -03:00
20240818113758_remove_all_but_most_recent_user_password.rb DEV: make UserPassword 1:1 to User (#28528) 2024-09-03 11:09:33 +08:00
20240819130737_update_unique_index_on_user_passwords.rb DEV: make UserPassword 1:1 to User (#28528) 2024-09-03 11:09:33 +08:00
20240820123401_alter_notifications_id_sequence_to_bigint.rb DEV: Migrate notifications#id to bigint (#28444) 2024-08-26 09:35:12 +08:00
20240820123402_add_big_int_notifications_id.rb DEV: Migrate notifications#id to bigint (#28444) 2024-08-26 09:35:12 +08:00
20240820123403_copy_notifications_id_values.rb DEV: Migrate notifications#id to bigint (#28444) 2024-08-26 09:35:12 +08:00
20240820123404_copy_notifications_id_indexes.rb DEV: Fix bigint notifications id migration to deal with public schema (#28538) 2024-08-26 10:25:13 +08:00
20240820123405_swap_big_int_notifications_id.rb DEV: Migrate notifications#id to bigint (#28444) 2024-08-26 09:35:12 +08:00
20240820123406_drop_old_notification_id_indexes.rb DEV: Fix bigint notifications id migration to deal with public schema (#28538) 2024-08-26 10:25:13 +08:00
20240826121501_add_big_int_shelved_notifications_notification_id.rb DEV: Migrate shelved_notifications#notification_id to bigint (#28549) 2024-08-27 10:56:00 +08:00
20240826121502_copy_shelved_notifications_notification_id_values.rb DEV: Migrate shelved_notifications#notification_id to bigint (#28549) 2024-08-27 10:56:00 +08:00
20240826121503_copy_shelved_notifications_notification_id_indexes.rb DEV: Migrate shelved_notifications#notification_id to bigint (#28549) 2024-08-27 10:56:00 +08:00
20240826121504_swap_big_int_shelved_notifications_notification_id.rb DEV: Migrate shelved_notifications#notification_id to bigint (#28549) 2024-08-27 10:56:00 +08:00
20240826121505_add_big_int_user_badges_notification_id.rb DEV: Migrate user_badges#notification_id to bigint (#28546) 2024-08-27 11:46:48 +08:00
20240826121506_copy_user_badges_notification_id_values.rb DEV: Migrate user_badges#notification_id to bigint (#28546) 2024-08-27 11:46:48 +08:00
20240826121507_swap_big_int_user_badges_notification_id.rb DEV: Migrate user_badges#notification_id to bigint (#28546) 2024-08-27 11:46:48 +08:00
20240827063715_add_new_seen_notification_id_to_users.rb DEV: Migrate User#seen_notification_id to bigint (#28572) 2024-08-27 14:32:55 +03:00
20240827063908_copy_users_seen_notification_id_values.rb DEV: Migrate User#seen_notification_id to bigint (#28572) 2024-08-27 14:32:55 +03:00
20240827064121_swap_seen_notification_id_with_seen_notification_id_on_users.rb DEV: Migrate User#seen_notification_id to bigint (#28572) 2024-08-27 14:32:55 +03:00
20240828191047_create_category_moderation_groups.rb FEATURE: Support designating multiple groups as mods on category (#28655) 2024-09-04 04:38:46 +03:00
20240829083823_ensure_unique_tag_user_notification_level.rb DEV: Ensure unique notification level per tag user (#28638) 2024-09-03 15:43:02 +08:00
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 DEV: make UserPassword 1:1 to User (#28528) 2024-09-03 11:09:33 +08:00
20240903024211_add_trigger_to_users_to_sync_user_passwords.rb DEV: Migrate user passwords data to UserPassword table (#28746) 2024-10-10 09:23:06 +08:00
20240903024311_backfill_user_passwords_from_users.rb DEV: Migrate user passwords data to UserPassword table (#28746) 2024-10-10 09:23:06 +08:00
20240906233304_remove_limits_from_form_templates.rb FIX: Form template limit validation (#28791) 2024-09-10 08:11:44 -07:00
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 PERF: Drop user_search_similar_results site setting (#28874) 2024-09-13 09:04:02 +08:00
20240912061806_drop_trgm_indexes_on_users.rb PERF: Update migration to drop index concurrently. (#28955) 2024-09-18 10:20:24 +08:00
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 DEV: Increases external avatar url limit (#28893) 2024-09-13 01:08:01 +02:00
20241011033602_add_post_badges_to_theme_modifiers.rb FEATURE: theme_modifiers can depend on theme settings (plus serialize_post_user_badges) (#29227) 2024-10-17 15:16:16 +01:00
20241011054348_fix_unique_constraint_on_problem_check_trackers.rb DEV: Fix problem check tracker unique index not respecting NULLs (#29169) 2024-10-14 13:55:35 +08:00
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 FIX: Make problem check tracker unique constraint work on PG13 (#29272) 2024-10-21 10:45:09 +08:00
20241022022326_remove_nulls_not_distinct_from_problem_check_trackers.rb DEV: Remove NULLS NOT DISTINCT from problem check trackers (#29327) 2024-10-22 10:47:24 +08:00
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 DEV: Delete plugin specific webhook event types (#29374) 2024-10-24 11:02:58 -05:00
20241024102733_remove_experimental_redesigned_about_page_groups_setting.rb FEATURE: Enable the new /about page for everyone (#29390) 2024-10-29 18:40:11 +03:00
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 FEATURE: Add user preference to disable smart lists (#29434) 2024-10-28 14:18:15 +10:00
20241030210727_split_hide_profile_and_presence.rb UX: Split hide_profile_and_presence user option (#29632) 2024-11-12 22:22:58 -03:00
20241101141701_alter_bookmarks_ids_to_bigint.rb Dev fix some types (#29547) 2024-11-01 19:19:25 +02:00
20241104132424_rename_full_page_site_setting.rb DEV: Remove the experimental_ prefix for fullpage login (#29546) 2024-11-26 11:08:27 -03:00
20241108154026_create_moved_posts.rb DEV: Create permanent version of moved_posts table from PostMover class (#29664) 2024-11-12 14:35:20 -06:00
20241112124552_create_user_api_key_client_scopes.rb Require permitted scopes when registering a client (#29718) 2024-11-19 15:28:04 -05:00
20241112145744_anonymize_normalized_email_column.rb FIX: Ensure normalized_email gets anonymized (#29719) 2024-11-12 14:36:17 -03:00
20241121000131_add_post_header_to_badge.rb FEATURE: Show when a badge has been granted for a post (#29696) 2024-12-03 13:43:27 +11:00
20241127034553_add_potentially_illegal_to_reviewables.rb DEV: Add "delete user" options to illegal flag review (#29956) 2024-11-27 17:23:57 +08:00
20241127072350_remap_fa5_icon_names_to_fa6.rb DEV: update fa6 icons to drop fa prefix (#30100) 2024-12-05 10:00:41 +08:00
20241204085540_remap_to_fa6_icon_names.rb DEV: update fa6 icons to drop fa prefix (#30100) 2024-12-05 10:00:41 +08:00
20241205035402_change_default_for_badges_icon.rb DEV: update more deprecated font awesome icon names (#30123) 2024-12-05 15:20:02 +08:00
20241205162117_add_columns_to_moved_posts.rb DEV: Add user_id and post_user_id to MovedPost records (#30130) 2024-12-05 17:10:32 -06:00
20241206002425_drop_experimental_topics_filter_site_setting.rb DEV: Drop experimental_topics_filter site setting take 2 (#30142) 2024-12-06 08:10:38 -05:00
20241206121401_delete_categories_only_optimized_site_setting.rb DEV: Remove references to categories_only_optimized (#30151) 2024-12-06 17:39:22 +02:00
20241211030039_remove_glimmer_post_menu_groups_setting.rb DEV: Switch the glimmer post menu to auto and unsilence deprecations (#30161) 2024-12-12 18:27:02 -03:00
20241211222608_add_full_move_to_moved_post_records.rb DEV: add full_move to MovedPost record small_action modifier (#30236) 2024-12-12 11:47:14 -06:00
20241224191732_change_full_name_required_setting.rb FIX: ChangeFullNameRequiredSetting could fail if setting was already in DB (#30605) 2025-01-07 13:08:36 +10:00
20250115031117_remove_user_profile_from_overridden_robots.rb FIX: Remove /u/ from robots (#30782) 2025-01-15 13:42:08 +08:00
20250116024516_update_font_site_settings_type.rb FIX: Add a DB migration to update font site settings types (#30813) 2025-01-16 13:53:58 +10:00
20250117065027_set_default_font_for_existing_sites.rb FEATURE: Improve wizard font selection and set Inter as default font for new sites (#30974) 2025-01-27 11:29:55 +10:00
20250119222805_fill_fast_typing_threshold_based_on_deprecated_setting.rb FEATURE: new fast_typing_threshold site setting (#30865) 2025-01-28 09:53:03 +11:00
20250120115539_add_dark_hex_to_color_scheme_color.rb DEV: Backend support for light/dark mode in color palettes (#30893) 2025-01-23 15:54:49 +03:00
20250121180125_create_theme_color_scheme.rb DEV: Introduce theme-owned color palettes (#30915) 2025-01-22 12:03:37 +03:00
20250124062108_remap_deprecated_icon_names_for_seeded_badges.rb DEV: add migration to remap from deprecated icon names for badges (#30983) 2025-01-24 15:26:39 +08:00
20250130205841_fix_incorrect_fast_typing_threshold_setting.rb FIX: change off to disabled for fast_typing_threshold setting (#31077) 2025-01-31 08:25:31 +11:00
20250205174221_add_serialize_topic_op_likes_data_theme_modifier.rb FEATURE: add first post likes data serializer (#31216) 2025-02-06 20:50:30 +05:30
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 FEATURE: display process information on flag modal (#31300) 2025-02-14 11:26:20 +11:00
20250212045125_add_type_source_to_reviewable.rb FIX: Ensure the reviewable.type_source migration is run post-deploy. (#31663) 2025-03-06 12:12:46 +11:00
20250217003916_x_summary_large_image_based_on_deprecated_setting.rb FEATURE: rebranded admin logos settings (#31554) 2025-03-04 12:51:27 +11:00
20250220045740_add_context_to_reviewable_scores.rb FEATURE: Display the Watched Words that caused a post to be flagged. (#31435) 2025-03-04 17:22:12 +11:00
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 FEATURE: Store composer version and device info on post stat (#31600) 2025-03-05 12:48:32 +10:00
20250304054720_add_scope_mode_to_api_keys.rb DEV: Store selected API key scope mode in the database table (#31601) 2025-03-04 16:41:43 +08:00
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
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: Skip backfill INSERTs in old migrations on fresh installs (#39976) 2026-05-13 13:59:28 +01: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
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