diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-01-27 20:10:48 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-01-27 20:10:48 +0200 |
| commit | cb214d740a9a73b2953163d85b21a2ffcee377f0 (patch) | |
| tree | aaab8b5ca36c5bf6ea9589468e61c08c26d0c614 /internal/server/api/migrations/20250127154005_ping.sql | |
| parent | b2bd96e46b51b38a05e6cc6649058f8ad0a3b6e8 (diff) | |
Added pings to messages in frequencies
Diffstat (limited to 'internal/server/api/migrations/20250127154005_ping.sql')
| -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; |