lemmy/migrations/2022-01-04-034553_add_hidden_column/up.sql

13 lines
401 B
MySQL
Raw Permalink Normal View History

ALTER TABLE community
ADD COLUMN hidden boolean DEFAULT FALSE;
CREATE TABLE mod_hide_community (
id serial PRIMARY KEY,
community_id int REFERENCES community ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
mod_person_id int REFERENCES person ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
when_ timestamp NOT NULL DEFAULT now(),
reason text,
hidden boolean DEFAULT FALSE
);