From cb214d740a9a73b2953163d85b21a2ffcee377f0 Mon Sep 17 00:00:00 2001
From: Kyren223 <Kyren223@proton.me>
Date: Mon, 27 Jan 2025 20:10:48 +0200
Subject: Added pings to messages in frequencies

---
 internal/server/api/migrations/20250127154005_ping.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 internal/server/api/migrations/20250127154005_ping.sql

(limited to 'internal/server/api/migrations/20250127154005_ping.sql')

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;
-- 
cgit v1.3.1