mirror of
https://github.com/LemmyNet/lemmy.git
synced 2024-12-22 09:18:15 +00:00
ba3d574d92
* Add report_counts to post and comment aggregate tables. - This adds a report_count and unresolved_report_count to the post and comment aggregate tables. - Useful for front-ends wishing to show report links. - Fixes #4163 * Updating the historical counts. * Switching from bigint to smallint. * Using dullbananas create_trigger function.
9 lines
203 B
SQL
9 lines
203 B
SQL
ALTER TABLE post_aggregates
|
|
DROP COLUMN report_count,
|
|
DROP COLUMN unresolved_report_count;
|
|
|
|
ALTER TABLE comment_aggregates
|
|
DROP COLUMN report_count,
|
|
DROP COLUMN unresolved_report_count;
|
|
|