mirror of
https://github.com/LemmyNet/lemmy
synced 2024-11-10 06:54:12 +00:00
99d585b7be
* Change defaults on user vote display mode to upvotes + downvotes * Forgot to regenerate the rows. * Drop and re-add columns instead.
14 lines
520 B
SQL
14 lines
520 B
SQL
-- Based on a poll, update the local_user_vote_display_mode defaults to:
|
|
-- Upvotes + Downvotes
|
|
-- Rather than
|
|
-- Score + upvote_percentage
|
|
ALTER TABLE local_user_vote_display_mode
|
|
DROP COLUMN score,
|
|
ADD COLUMN score boolean DEFAULT FALSE NOT NULL,
|
|
DROP COLUMN upvotes,
|
|
ADD COLUMN upvotes boolean DEFAULT TRUE NOT NULL,
|
|
DROP COLUMN downvotes,
|
|
ADD COLUMN downvotes boolean DEFAULT TRUE NOT NULL,
|
|
DROP COLUMN upvote_percentage,
|
|
ADD COLUMN upvote_percentage boolean DEFAULT FALSE NOT NULL;
|
|
|