upvote and downvote comments

[ingawei]

When you like/dislike a comment it calculates the like to dislike ratio (only if you have 10 dislikes or more so you don't get your comment hidden with just 1:5 likes to dislikes). If you have more than 80% dislikes your comment is hidden automatically. Open to tweaking these number.

Also ran this for reference:

ALTER

TABLE
 public.contract_comments
ADD

COLUMN
 dislikes int4 
NULL

DEFAULT

0
;

ALTER

TABLE
 public.contract_comments
DROP

COLUMN
 upvotes,
DROP

COLUMN
 downvotes;

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

3 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **dev** | ⬜️ Ignored ([Inspect](https://vercel.com/mantic/dev/9jFnLUmTxa8YjK8KtevZGqvRNbQ7)) | [Visit Preview](https://dev-git-ingawei-man-1497-updown-votes-on-comments-mantic.vercel.app) | | Nov 13, 2024 9:16pm | | **docs** | ⬜️ Ignored ([Inspect](https://vercel.com/mantic/docs/9B1vgHFC47mVizfXQjVUcDoAAWyQ)) | [Visit Preview](https://docs-git-ingawei-man-1497-updown-votes-on-comments-mantic.vercel.app) | | Nov 13, 2024 9:16pm | | **prod** | ⬜️ Ignored ([Inspect](https://vercel.com/mantic/prod/DKpWkHfryb9cyze7KUpzcTq5JRZc)) | [Visit Preview](https://prod-git-ingawei-man-1497-updown-votes-on-comments-mantic.vercel.app) | | Nov 13, 2024 9:16pm |

[linear[bot]]

MAN-1497 Up/down votes on comments