fediseer/sql_statements/0.16.0.txt

5 lines
325 B
Plaintext

CREATE TYPE listvisibility AS ENUM ('OPEN','ENDORSED','PRIVATE');
ALTER TABLE instances ADD COLUMN visibility_endorsements listvisibility default 'OPEN';
ALTER TABLE instances ADD COLUMN visibility_censures listvisibility default 'OPEN';
ALTER TABLE instances ADD COLUMN visibility_hesitations listvisibility default 'OPEN';