summaryrefslogtreecommitdiff
path: root/internal/server/api/migrations/20250127154005_ping.sql
blob: 90f0655f22b2e05e3e7b79c4b4f3b0c4c1dc0e77 (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 - @everyone, 1 - @admins, otherwise references userId


-- +goose Down
ALTER TABLE messages DROP ping;