mirror/lemmy
1
0
Fork 0
mirror of https://github.com/LemmyNet/lemmy.git synced 2025-12-29 01:39:52 -06:00
Code Issues Packages Projects Releases Wiki Activity
Files
main
lemmy/migrations
History
Nutomic 30666417ad Separate struct for PublicOAuthProvider (#6231) 
* Separate struct for PublicOAuthProvider

* plugin hash check

* change error message
2025-12-10 11:17:46 -05:00
..
2019-02-26-002946_create_user
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-02-27-170003_create_community
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-03-03-163336_create_post
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-03-05-233828_create_comment
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-03-30-212058_create_post_view
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-04-03-155205_create_community_view
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-04-03-155309_create_comment_view
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-04-07-003142_create_moderation_logs
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-04-08-015947_create_user_view
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-04-11-144915_create_mod_views
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-04-29-175834_add_delete_columns
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-05-02-051656_community_view_hot_rank
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-06-01-222649_remove_admin
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-08-11-000918_add_nsfw_columns
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-08-29-040006_add_community_count
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-09-05-230317_add_mod_ban_views
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-09-09-042010_add_stickied_posts
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2019-10-15-181630_add_themes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-10-19-052737_create_user_mention
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-10-21-011237_add_default_sorts
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-10-24-002614_create_password_reset_request
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-12-09-060754_add_lang
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-12-11-181820_add_site_fields
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2019-12-29-164820_add_avatar
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2020-01-01-200418_add_email_to_user_view
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-01-02-172755_add_show_avatar_and_email_notifications_to_user
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-01-11-012452_add_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-01-13-025151_create_materialized_views
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2020-01-21-001001_create_private_message
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-01-29-011901_create_reply_materialized_view
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-01-29-030825_create_user_mention_materialized_view
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-02-02-004806_add_case_insensitive_usernames
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-02-06-165953_change_post_title_length
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-02-07-210055_add_comment_subscribed
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-02-08-145624_add_post_newest_activity_time
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-03-06-202329_add_post_iframely_data
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-03-26-192410_add_activitypub_tables
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-04-03-194936_add_activitypub_for_posts_and_comments
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-04-07-135912_add_user_community_apub_constraints
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2020-04-14-163701_update_views_for_activitypub
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-04-21-123957_remove_unique_user_constraints
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-05-05-210233_add_activitypub_for_private_messages
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-06-30-135809_remove_mat_views
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-07-08-202609_add_creator_published
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2020-07-12-100442_add_post_title_to_comments_view
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-07-18-234519_add_unique_community_user_actor_ids
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-08-03-000110_add_preferred_usernames_banners_and_icons
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-08-06-205355_update_community_post_count
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-08-25-132005_add_unique_ap_ids
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-09-07-231141_add_migration_utils
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-10-07-234221_fix_fast_triggers
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-10-10-035723_fix_fast_triggers_2
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-10-13-212240_create_report_tables
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-10-23-115011_activity_ap_id_column
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-11-05-152724_activity_remove_user_id
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2020-11-10-150835_community_follower_pending
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-11-26-134531_delete_user
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-12-02-152437_create_site_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-12-03-035643_create_user_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-12-04-183345_create_community_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-12-10-152350_create_post_aggregates
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-12-14-020038_create_comment_aggregates
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2020-12-17-030456_create_alias_views
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2020-12-17-031053_remove_fast_tables_and_views
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-01-05-200932_add_hot_rank_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-01-26-173850_default_actor_id
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-01-27-202728_active_users_monthly
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-01-31-050334_add_forum_sort_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-02-02-153240_apub_columns
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-02-10-164051_add_new_comments_sort_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-02-13-210612_set_correct_aggregates_time_columns
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-02-25-112959_remove-categories
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2021-02-28-162616_clean_empty_post_urls
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-04-040229_clean_icon_urls
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-09-171136_split_user_table_2
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2021-03-19-014144_add_col_local_user_validator_time
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-20-185321_move_matrix_id_to_person
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-31-103917_add_show_score_setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-31-105915_add_bot_account
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-03-31-144349_add_site_short_description
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-04-01-173552_rename_preferred_username_to_display_name
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-04-01-181826_add_community_agg_active_monthly_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-04-02-021422_remove_community_creator
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-04-20-155001_limit-admins-create-community
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-04-24-174047_add_show_read_post_setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-07-19-130929_add_show_new_post_notifs_setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-07-20-102033_actor_name_length
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-08-02-002342_comment_count_fixes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-08-04-223559_create_user_community_block
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-08-16-004209_fix_remove_bots_from_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-08-17-210508_create_mod_transfer_community
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-09-20-112945_jwt-secret
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2021-10-01-141650_create_admin_purge
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-11-22-135324_add_activity_ap_id_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-11-22-143904_add_required_public_key
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-11-23-031528_add_report_published_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-11-23-132840_email_verification
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-11-23-153753_add_invite_only_columns
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-12-09-225529_add_published_to_email_verification
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2021-12-14-181537_add_temporary_bans
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-01-04-034553_add_hidden_column
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-01-20-160328_remove_site_creator
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-01-28-104106_instance-actor
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2022-02-01-154240_add_community_title_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-02-18-210946_default_theme
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-04-183652_update_community_aggregates_on_soft_delete
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-11-210137_fix_unique_changeme
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-12-114352_default_post_listing_type
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-12-185205_change_default_listing_type_to_local
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-19-111004_default_require_application
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-04-26-105145_only_mod_can_post
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-05-19-153931_legal-information
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-05-20-135341_embed-url
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2022-06-12-012121_add_site_hide_modlog_names
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-06-13-124806_post_report_name_length
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-06-21-123144_language-tags
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-07-07-182650_comment_ltrees
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2022-08-04-150644_add_application_email_admins
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-08-04-214722_add_distinguished_comment
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-08-05-203502_add_person_post_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-08-22-193848_comment-language-tags
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-09-07-113813_drop_ccnew_indexes_function
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-09-07-114618_pm-reports
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-09-08-102358_site-and-community-languages
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-09-24-161829_remove_table_aliases
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-10-06-183632_move_blocklist_to_db
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2022-11-13-181529_create_taglines
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-11-20-032430_sticky_local
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2022-11-21-143249_remove-federation-settings
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-11-21-204256_user-following
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2022-12-05-110642_registration_mode
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-01-17-165819_cleanup_post_aggregates_indexes
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-02-01-012747_fix_active_index
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-05-102549_drop-site-federation-debug
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-02-07-030958_community-collections
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-11-173347_custom_emojis
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-13-172528_add_report_email_admins
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-13-221303_add_instance_software_and_version
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-15-212546_add_post_comment_saved_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-02-16-194139_add_totp_secret
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-04-14-175955_add_listingtype_sorttype_enums
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-04-23-164732_add_person_details_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-05-10-095739_force_enable_undetermined_language
Create actions structs (#5482)
2025-03-12 11:51:34 -04:00
2023-06-06-104440_index_post_url
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-07-105918_add_hot_rank_columns
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-17-175955_add_listingtype_sorttype_hour_enums
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-06-19-055530_add_retry_worker_setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-19-120700_no_double_deletion
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-20-191145_add_listingtype_sorttype_3_6_9_months_enums
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-06-21-153242_add_captcha
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-22-051755_fix_local_communities_marked_non_local
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-22-101245_increase_user_theme_column_size
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-24-072904_add_open_links_in_new_tab_setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-24-185942_aggegates_published_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-06-27-065106_add_ui_settings
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-04-153335_add_optimized_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-05-000058_person-admin
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-06-151124_hot-rank-future
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-08-101154_fix_soft_delete_aggregates
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-10-075550_add-infinite-scroll-setting
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-11-084714_receive_activity_table
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-07-14-154840_add_optimized_indexes_published
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-14-215339_aggregates_nonzero_indexes
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-18-082614_post_aggregates_community_id
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-19-163511_comment_sort_hot_rank_then_score
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-24-232635_trigram-index
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-07-26-000217_create_controversial_indexes
Add endpoint to get Liked / Disliked comments and posts. (#5616)
2025-06-02 11:15:27 +02:00
2023-07-26-222023_site-aggregates-one
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-07-27-134652_remove-expensive-broken-trigger
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00
2023-08-01-101826_admin_flag_local_user
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-08-01-115243_persistent-activity-queue
Persistent, performant, reliable federation queue (#3605)
2023-09-09 12:25:03 -04:00
2023-08-02-144930_password-reset-token
Fixing broken SQL migration formatting. (#3800)
2023-08-03 11:07:35 +02:00
2023-08-02-174444_fix-timezones
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-08-08-163911_add_post_listing_mode_setting
Adding a post_view mode. Fixes #3730 (#3731)
2023-08-31 09:01:08 -04:00
2023-08-09-101305_user_instance_block
User can block instances (fixes #2397) (#3869)
2023-09-20 11:56:13 +02:00
2023-08-23-182533_scaled_rank
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-08-29-183053_add_listing_type_moderator_view
update moderator view (#3820)
2023-08-31 13:07:45 +02:00
2023-08-31-205559_add_image_upload
Add logging for pictrs uploads (#3927)
2023-09-06 09:13:30 -04:00
2023-09-01-112158_auto_resolve_report
Auto resolve reports trigger (#3871)
2023-09-05 05:35:10 -04:00
2023-09-07-215546_post-queries-efficient
Fix Posts List Performance + cursor-based pagination (#3872)
2023-09-18 15:44:48 +02:00
2023-09-11-110040_rework-2fa-setup
Rework the way 2FA is enabled/disabled (fixes #3309) (#3959)
2023-09-20 10:49:54 -04:00
2023-09-12-194850_add_federation_worker_index
Fixing high CPU usage on federation worker recheck. Fixes #3958
2023-09-12 15:54:49 -04:00
2023-09-18-141700_login-token
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-09-20-110614_drop-show-new-post-notifs
Implement user data import/export (#3976)
2023-10-11 16:47:22 +02:00
2023-09-28-084231_import_user_settings_rate_limit
Implement user data import/export (#3976)
2023-10-11 16:47:22 +02:00
2023-10-02-145002_community_followers_count_federated
Read community follower count from home instance (fixes #1440) (#4013)
2023-10-17 10:34:38 -04:00
2023-10-06-133405_add_keyboard_navigation_setting
add keyboard navigation setting (#3569)
2023-10-10 12:17:27 +02:00
2023-10-13-175712_allow_animated_avatars
Enable animated avatars setting (#4040)
2023-10-17 10:52:34 -04:00
2023-10-17-181800_drop_remove_community_expires
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2023-10-23-184941_hot_rank_greatest_fix
Fix hot_rank algorithm pushing downvoted content off the feed. (#4085)
2023-10-30 10:47:57 +01:00
2023-10-24-030352_change_primary_keys_and_remove_some_id_columns
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2023-10-24-131607_proxy_links
Rewrite images to use local proxy (#4035)
2024-01-25 09:22:11 -05:00
2023-10-24-183747_autocollapse_bot_comments
Add UI setting for collapsing bot comments. Fixes #3838 (#4098)
2023-11-06 16:09:12 -05:00
2023-10-27-142514_post_url_content_type
Rewrite images to use local proxy (#4035)
2024-01-25 09:22:11 -05:00
2023-11-01-223740_federation-published
add federation queue state to get_federated_instances api (#4104)
2023-11-06 16:07:04 -05:00
2023-11-02-120140_apub-signed-fetch
Support signed fetch for federation (fixes #868) (#4125)
2023-11-06 16:02:01 -05:00
2023-11-07-135409_inbox_unique
Merge /site_inbox into /inbox, remove unique constraint for inboxes (#4138)
2023-11-16 14:22:40 +01:00
2023-11-22-194806_low_rank_defaults
Setting rank column defaults to a small number. Fixes #4178 (#4191)
2023-11-23 20:39:46 -05:00
2023-12-06-180359_edit_active_users
Add voters to active users (#4235)
2023-12-11 09:38:17 -05:00
2023-12-19-210053_tolerable-batch-insert-speed
Better query plan viewing experience (#4285)
2024-01-24 10:22:33 -05:00
2023-12-22-040137_make-mixed-sorting-directions-work-with-tuple-comparison
Post view: move cursor pagination to separate library, add backward pagination to PostQuery (#4320)
2024-01-24 10:50:11 -05:00
2024-01-02-094916_site-name-not-unique
Drop unique constraint for site.name (fixes #4329) (#4342)
2024-01-03 12:47:39 -05:00
2024-01-05-213000_community_aggregates_add_local_subscribers
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2024-01-15-100133_local-only-community
Local only community (#4350)
2024-01-25 11:04:25 -05:00
2024-01-22-105746_lemmynsfw-changes
Add site.content_warning, local_site.default_post_listing_mode (#4393)
2024-02-16 07:24:35 -05:00
2024-01-25-151400_remove_auto_resolve_report_trigger
Auto resolve reports on removing a comment or post. Fixes #4390 (#4402)
2024-02-15 08:52:04 -05:00
2024-02-12-211114_add_vote_display_mode_setting
Add a vote_display_mode local_user setting. (#4450)
2024-03-13 12:10:58 -04:00
2024-02-15-171358_default_instance_sort_type
Adding an instance-level default_sort_type (#4454)
2024-02-16 09:36:46 -05:00
2024-02-24-034523_replaceable-schema
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2024-02-27-204628_add_post_alt_text
Add alt_text for posts. Fixes #1086 (#4477)
2024-03-05 11:34:57 +01:00
2024-02-28-144211_hide_posts
Adding ability to hide posts. (#4480)
2024-02-29 10:42:34 -05:00
2024-03-06-104706_local_image_user_opt
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2024-03-06-201637_url_blocklist
Add a blocklist for URLs. (#4515)
2024-03-15 07:03:29 -04:00
2024-04-05-153647_alter_vote_display_mode_defaults
Change defaults on user vote display mode to upvotes + downvotes (#4599)
2024-04-10 10:47:05 +02:00
2024-04-15-105932_community_followers_url_optional
Testing for federation with NodeBB, make community.followers_url optional (#4629)
2024-04-29 12:34:11 +02:00
2024-04-23-020604_add_post_id_index
Adding post_id desc to all post_aggregates indexes. Fixes #4618 (#4662)
2024-04-25 18:19:02 -04:00
2024-05-04-140749_separate_triggers
Optimize stuff in attempt to fix high amount of locks, and fix comment_aggregates.child_count (#4696)
2024-05-09 08:18:55 -04:00
2024-05-05-162540_add_image_detail_table
Adding an image_details table to store image dimensions. (#4704)
2024-06-20 12:44:06 +02:00
2024-06-17-160323_fix_post_aggregates_featured_local
Fix not-equals check in post aggregates update trigger (#4837)
2024-06-17 15:25:54 -04:00
2024-06-24-000000_ap_id_triggers
Use trigger to generate apub URL in insert instead of update, and fix query planner options not being set when TLS is disabled (#4797)
2024-07-02 11:23:21 -04:00
2024-07-01-014711_exponential_controversy
Optimize migrations (#5301)
2025-01-13 23:10:31 -05:00
2024-08-03-155932_increase_post_url_max_length
Run analyze after changing post.url type (ref #4983) (#5148)
2024-11-04 14:16:54 +01:00
2024-11-12-090437_move-triggers
Improve migration diff check and fix old migrations (#5204)
2025-06-16 11:35:41 -04:00
2025-01-10-135505_donation-dialog
Donation dialog changes (#5552)
2025-03-28 09:10:54 -04:00
2025-02-11-131045_ban-remove-content-pm
Also remove private messages when banning user with "remove content" (#5414)
2025-02-12 07:45:07 -05:00
2025-02-24-173152_search-alt-text-of-posts
Include image alt text in post search (#5449)
2025-02-25 13:28:15 -05:00
2025-03-07-094522_enable_english_for_all
Upgrading pg_format to 5.8 (#6141)
2025-11-10 10:29:09 +01:00
2025-04-07-100344_registration-rate-limit
Increase registration rate limit to 10 per hour (ref #5548) (#5600)
2025-04-07 14:31:20 -04:00
2025-05-15-154113_missing_post_indexes
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-07-29-152742_add_indexes_for_aggregates_activity
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-07-29-152743_post-aggregates-creator-community-indexes
[main] Adding creator and community indexes for post_aggregates. (#6026)
2025-10-03 05:03:14 +08:00
2025-08-01-000000_enable_private_messages
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000002_error_if_code_migrations_needed
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000003_remove_show_scores_column
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000004_custom_emoji_tagline_changes
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000005_drop-enable-nsfw
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000006_default_comment_sort_type
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000007_schedule-post
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000008_create_oauth_provider
Separate struct for PublicOAuthProvider (#6231)
2025-12-10 11:17:46 -05:00
2025-08-01-000009_add_federation_vote_rejection
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000010_remove_auto_expand
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000011_add_short_community_description
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000012_no-individual-inboxes
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000013_comment-vote-remote-postid
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000014_private-community
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000015_add_mark_fetched_posts_as_read
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000016_smoosh-tables-together
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000017_forbid_diesel_cli
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000018_custom_migration_runner
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000019_add_report_count
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000020_oauth_pkce
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000021_add_blurhash_to_image_details
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000022_instance-block-mod-log
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000023_add_report_combined_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000024_add_person_content_combined_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000025_add_modlog_combined_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000026_add_inbox_combined_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000027_add_search_combined_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000028_add_index_on_person_id_read_for_read_only_post_actions
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000029_community-post-tags
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000030_optimize_get_random_community
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000031_update-replaceable-schema
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000032_community_report
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000033_add_post_keyword_block_table
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000034_no-image-token
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000035_media_filter
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000036_interactions_per_month_schema
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000037_report_to_admins
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000038_ap_id
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000039_remove_post_sort_type_enums
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000040_block_nsfw
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000041_remove-aggregate-tables
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000042_community-hidden-visibility
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000043_community-local-removed
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000044_post_comment_pending
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000045_site_person_ban
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000047_disable-email-notifications
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000048_cursor_pagination_indexes
Shrink things that are rewritten in slow migrations (#5874)
2025-10-17 03:22:34 +08:00
2025-08-01-000049_add_liked_combined
Shrink things that are rewritten in slow migrations (#5874)
2025-10-17 03:22:34 +08:00
2025-08-01-000050_show_downvotes_for_others_only
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000051_local_image_person
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000052_lock_reason
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000053_remove_hide_modlog_names
Separate struct for PublicOAuthProvider (#6231)
2025-12-10 11:17:46 -05:00
2025-08-01-000054_mod-change-community-vis
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000055_rename_timestamp_add_at
Shrink things that are rewritten in slow migrations (#5874)
2025-10-17 03:22:34 +08:00
2025-08-01-000056_person_note
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000057_multi-community
Change multi_community_user to system_account (#6133)
2025-11-07 23:12:56 +08:00
2025-08-01-000058_instance_block_communities_persons
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000059_person_votes
Shrink things that are rewritten in slow migrations (#5874)
2025-10-17 03:22:34 +08:00
2025-08-01-000060_rename-rate-limit-columns
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000061_drop-person-ban
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000062_username-instance-unique
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000063_post-or-comment-notification
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-08-01-000064_add_missing_foreign_key_indexes
Change multi_community_user to system_account (#6133)
2025-11-07 23:12:56 +08:00
2025-08-01-000065_group-follow
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000066_modlog-rename
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000067_add_default_items_per_page
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-01-000068_local_user_trigger
[main] Fixing active counts slow queries. (#5907) (#5917)
2025-08-09 21:57:38 +02:00
2025-08-06-170325_add_indexes_for_aggregates_activity_new
Shrink things that are rewritten in slow migrations (#5874)
2025-10-17 03:22:34 +08:00
2025-08-20-000000_comment-lock
Comment lock (#5916)
2025-09-03 06:42:24 -04:00
2025-09-01-141127_local-community-collections
Add urls for moderators and featured collections on local communities (#5939)
2025-09-05 15:28:31 -04:00
2025-09-08-000001_add-video-dimensions
Saving video width and height alongside embed_video_url (#5965)
2025-09-11 07:02:24 -04:00
2025-09-08-140711_remove-actor-name-max-length
Restrict max length of community title (#5958)
2025-09-12 11:32:04 +02:00
2025-09-12-093537_mod-reason-mandatory
Proper null check for mod-reason-mandatory (fixes #6021) (#6022)
2025-09-26 21:18:06 +08:00
2025-09-15-090401_remove-keyboard-nav
Remove local_user.enable_keyboard_navigation (fixes #5988) (#5992)
2025-09-15 09:34:37 -04:00
2025-09-19-090047_notify-mod-action
Notify mod actions (#5981)
2025-10-01 15:23:39 +02:00
2025-09-19-132648-0000_theme-instance-default
Correct name for instance default theme (#6008)
2025-09-22 17:03:07 +08:00
2025-10-08-084508-0000_multi-comm-index-lower
Multi-community fixes (#6046)
2025-10-10 00:46:24 +08:00
2025-10-09-101527-0000_community-follower-denied
Private community fixes (#6003)
2025-10-14 18:17:34 +08:00
2025-10-15-114811-0000_merge-modlog-tables
Upgrade to postgres v18. (#6087)
2025-12-02 10:27:18 +01:00
2025-11-05-181519-0000_add_registration_application_updated_at
Adding a last_application_duration_seconds field to GetSite. (#6126)
2025-11-07 10:06:35 +01:00
2025-11-08-123111-0000_add_multi_community_subscribers_community_count
Adding multi-community counts, and full querying to list_multi_communities (#6140)
2025-11-12 10:26:14 +01:00
00000000000000_diesel_initial_setup
Adding SQL format checking via pg_format / pgFormatter (#3740)
2023-08-02 12:44:51 -04:00