mirror of https://github.com/LemmyNet/lemmy.git
19 lines
606 B
MySQL
19 lines
606 B
MySQL
|
-- Create an extra table to hold local user vote display settings
|
||
|
|
-- Score and Upvote percentage are turned on by default.
|
||
|
|
CREATE TABLE local_user_vote_display_mode (
|
||
|
|
local_user_id int REFERENCES local_user ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
|
||
|
|
score boolean DEFAULT TRUE NOT NULL,
|
||
|
|
upvotes boolean DEFAULT FALSE NOT NULL,
|
||
|
|
downvotes boolean DEFAULT FALSE NOT NULL,
|
||
|
|
upvote_percentage boolean DEFAULT TRUE NOT NULL,
|
||
|
|
PRIMARY KEY (local_user_id)
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Insert rows for every local user
|
||
|
|
INSERT INTO local_user_vote_display_mode (local_user_id)
|
||
|
|
SELECT
|
||
|
|
id
|
||
|
|
FROM
|
||
|
|
local_user;
|
||
|
|
|