diff options
Diffstat (limited to 'internal/server/api/migrations')
| -rw-r--r-- | internal/server/api/migrations/20250127154005_ping.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/internal/server/api/migrations/20250127154005_ping.sql b/internal/server/api/migrations/20250127154005_ping.sql new file mode 100644 index 0000000..54f207a --- /dev/null +++ b/internal/server/api/migrations/20250127154005_ping.sql @@ -0,0 +1,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; |