main pico / sql / migrations / 20220722_post_hidden.sql
Eric Bower  ·  2022-08-03
1ALTER TABLE posts ADD COLUMN hidden boolean NOT NULL DEFAULT FALSE;
2UPDATE posts SET hidden = TRUE WHERE filename LIKE E'\\_%';