summaryrefslogtreecommitdiffstats
path: root/server/migrations
AgeCommit message (Collapse)Author
2020-07-12Migration fixErnest
2020-07-12Add post title to comments view #948Ernest
2020-07-09Create new migration to add `creator_published` field to the `post_view` and ↵Filip785
`comment_view`
2020-07-08Add cake day display in user page & posts/comments #682Filip785
2020-07-07Remove materialized views. (#908)Dessalines
* One pass at materialized views, only about 30% faster, not good. * Before merging master to test out bans. * DB Rework working, still need more testing. * Fixing accidental addadmin bug from asonix async merge. * Fixing the comment delete trigger * Some more DB additions. - Adding a hot_rank desc, published desc index to post_aggregates_fast. - Removed WITH CTE queries in favor of direct selects (since CTEs cant use indexes) * Removing some unecessary indexes. * Some more DB optimizings - Changing the fast_id pkeys to just ids on the fast tables. - Removing the private_message_fast, since the view contains no aggregates. - Comment and post voting now no longer pull from the views, they update the counts directly. * Adding community_agg_view and post_agg_views Credit: eiknat. * Adding user and comment_view migrations. (comment_view still broken) * Adding more views. Credit Eiknat.
2020-06-29Revert "Remove mat views, no fast tables or caching added yet."Dessalines
This reverts commit 97e088dcbfb91bb16bd0190f8d956095755e8cb4.
2020-06-29Remove mat views, no fast tables or caching added yet.Dessalines
2020-06-26Some fixes to federation.Dessalines
- Advanced code migrations now disable then re-enable triggers. Brings run time down to < 15 seconds, no need to thread them. - Changing ap_ids and actor_ids in migrations to a fake url, so it doesn't break XsdAnyUri in activitystreams.
2020-05-05Federated private messages.Dessalines
2020-04-21Change local unique username constraints.Dessalines
2020-04-14Updating views to add apub actor_id and local columns.Dessalines
2020-04-07Removing community name unique constraint. Removing useless fedi_name column ↵Dessalines
from user_table.
2020-04-03Adding post and comment ap_id columns.Dessalines
2020-04-03Federation DB Changes.Dessalines
- Creating an activity table. - Adding some federation-related columns to the user_ and community tables. - Generating the actor_id and keys in code, updating the tables.
2020-03-07Iframely and pictshare backend mostly done.Dessalines
2020-02-08Change post sorting hot rank to use newest comment time. Fixes #517Dessalines
2020-02-07Add new comments views to main and community pages. Fixes #480Dessalines
2020-02-06Increasing post title length limit to 200. Fixes #515Dessalines
2020-02-01Adding username and email case insensitivity uniqueness. Fixes #341Dessalines
2020-01-28Adding a materialized view for reply_view. Fixes #466Dessalines
2020-01-22Adding private messaging, and matrix user ids.Dessalines
- Fixes #244
2020-01-13A first pass at using materialized views.Dessalines
2020-01-11Back to just indexes.Dessalines
2020-01-10Trying some DB indexes.Dessalines
2020-01-02Adding show_avatar user setting, and option to send notifications to inbox.Dessalines
- Fixes #254 - Fixes #394
2020-01-01Adding change password and email address from user settings.Dessalines
- Fixes #384 - Fixes #385
2019-12-29Adding user avatars / icons. Requires pictshare.Dessalines
- Fixes #188
2019-12-11Adding some site oriented settings.Dessalines
- Adding option to close registration. Fixes #350 - Adding option to disable showing NSFW buttons. Fixes #364 - Adding option to disable downvotes. Fixes #239
2019-12-09Adding custom language setting.Dessalines
- Fixes #319
2019-10-29Halfway done with email, not fully working yet.Dessalines
2019-10-20Adding default sort / filter into user settings.Dessalines
- Fixes #295
2019-10-19Adding username mentions / tagging from comments.Dessalines
- Fixes #293
2019-10-15Adding 8 different themes.Dessalines
- Fixes #276
2019-09-08Adding stickied posts.Dessalines
- Fixes #245
2019-09-05Adding ability to do mod action on post creatorDessalines
- Fixes #248 - Show banned on user comment and user overview. Fixes #264
2019-08-28Showing community count on main sidebarDessalines
- Fixes #232
2019-08-13Squashed commit of the following:Dessalines
commit ecd6c5a2f47cbbb2fc4bf482fadd78380303a904 Author: Dessalines <happydooby@gmail.com> Date: Tue Aug 13 19:49:38 2019 -0700 Adding some docs commit 3babd09affb1920da3d0a0ceb7e24c8aeeb9cf1a Author: Dessalines <happydooby@gmail.com> Date: Tue Aug 13 19:28:46 2019 -0700 Adding save user settings commit 6e8da9cc9e522d0da668bfa31944c3348cc79620 Merge: 3246d5d c148eef Author: Dessalines <happydooby@gmail.com> Date: Tue Aug 13 17:26:25 2019 -0700 Merge branch 'dev' into nsfw commit b3d4a5c4ce441bcc664704aba44cedb51d887599 Author: Dessalines <happydooby@gmail.com> Date: Sun Aug 11 20:55:09 2019 -0700 nsfw mostly done, except for settings page.
2019-06-01Removing the placeholder admin user.Dessalines
- Fixes #165
2019-05-01Reworking some UI. Adding proper trending communities with hot rank.Dessalines
- Breaking out subscribed and all into radios. Fixes #142
2019-04-29Adding proper deletes for Post, Community, and Comments.Dessalines
- Fixes #132 - Fixes #108
2019-04-21Community moderation fixes.Dessalines
- Don't show banned communities on main post list. Fixes #95 - Add back in community moderation and editing. Fixes #92
2019-04-21Fixing ranking algorithm.Dessalines
2019-04-20Adding negative score fixDessalines
- Fixes #84. - Fixing unit tests.
2019-04-20Mostly working, before mergeDessalines
2019-04-19Saving replies, the actual fixes will be in the merge to dev.Dessalines
2019-04-16Before big moderation mergeDessalines
2019-04-15Commiting before I lose everything. I'll do this properly in a mergeDessalines
2019-04-09Merge branch 'dev' into moderationDessalines
2019-04-07Adding user details / overview page.Dessalines
- Fixes #19
2019-04-06adding migrationsDessalines
generated by cgit v1.2.3 (git 2.25.1) at 2024-05-15 16:18:18 +0000