1 files changed, 17 insertions, 0 deletions
diff --git a/internal/server/api/migrations/20250109142125_trusted_and_blocked_users.sql b/internal/server/api/migrations/20250109142125_trusted_and_blocked_users.sql
new file mode 100644
index 0000000..8916378
--- /dev/null
+++ b/internal/server/api/migrations/20250109142125_trusted_and_blocked_users.sql
@@ -0,0 +1,17 @@
+-- +goose Up
+CREATE TABLE IF NOT EXISTS trusted_users (
+  trusting_user_id INT NOT NULL REFERENCES users (id),
+  trusted_user_id INT NOT NULL REFERENCES users (id),
+  trusted_public_key BLOB NOT NULL,
+  PRIMARY KEY (trusting_user_id, trusted_user_id)
+);
+
+CREATE TABLE IF NOT EXISTS blocked_users (
+  blocking_user_id INT NOT NULL REFERENCES users (id),
+  blocked_user_id INT NOT NULL REFERENCES users (id),
+  PRIMARY KEY (blocking_user_id, blocked_user_id)
+);
+
+-- +goose Down
+DROP TABLE IF EXISTS trusted_users;
+DROP TABLE IF EXISTS blocked_users;