mirror of
https://github.com/LemmyNet/lemmy.git
synced 2025-09-03 03:33:50 +00:00
644a448aa9
* [0.19] Fixing active counts slow queries. (#5907) * Fixing active counts slow queries. * Simplify back to str tuple * Batch site and community updates * Using update from temp table * Making aggs temp table use interval name. * Make dev setup use optimized postgres. * Addressing PR comments. * Use ref * Removing system custom info from customPostgresql.conf * Forgot to remove old scheduled tasks. * Making sure migrations aren't missing anything from release/v0.19 Checked using git diff --diff-filter D --stat release/v0.19 migrations * Rename all migrations to come after release/v0.19 migrations * Add liked_at is not null check.
28 lines
1.3 KiB
SQL
28 lines
1.3 KiB
SQL
ALTER TABLE local_site_rate_limit RENAME COLUMN message_max_requests TO message;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN message_interval_seconds TO message_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN post_max_requests TO post;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN post_interval_seconds TO post_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN comment_max_requests TO comment;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN comment_interval_seconds TO comment_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN register_max_requests TO register;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN register_interval_seconds TO register_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN image_max_requests TO image;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN image_interval_seconds TO image_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN search_max_requests TO search;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN search_interval_seconds TO search_per_second;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN import_user_settings_max_requests TO import_user_settings;
|
|
|
|
ALTER TABLE local_site_rate_limit RENAME COLUMN import_user_settings_interval_seconds TO import_user_settings_per_second;
|
|
|