summaryrefslogtreecommitdiff
path: root/internal/server/api/migrations/20250127154005_ping.sql
blob: 54f207a4799c6699222581b5522eaa92b54640a7 (plain)
1
2
3
4
5
6
7
8
-- +goose Up
ALTER TABLE messages ADD ping INTEGER DEFAULT NULL;
-- Must be null if freuqencyId is null
-- 0 - @ping:everyone, 1 - @ping:admins, otherwise references userId


-- +goose Down
ALTER TABLE messages DROP ping;