repos / pico

20221108_add_expires_at_to_posts.sql

1ALTER TABLE posts ADD expires_at timestamp without time zone;
2
3UPDATE posts SET expires_at = NOW() + INTERVAL '7 day' WHERE cur_space='pastes';