summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2024-11-28 18:00:50 +0200
committerKyren223 <Kyren223@proton.me>2024-11-28 18:00:50 +0200
commitd0356edef4dc0a14304b8890e8152911740ff87a (patch)
tree9f96b2e1b591d9d86970db9102abae04055a5ac7 /migrations
parentc3f8131caf597dc028c08c8dd9f2f65a213e580d (diff)
Added position to networks
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20241026174345_init.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/20241026174345_init.sql b/migrations/20241026174345_init.sql
index 02fdee8..6fa0b93 100644
--- a/migrations/20241026174345_init.sql
+++ b/migrations/20241026174345_init.sql
@@ -52,6 +52,7 @@ CREATE TABLE users_networks (
is_muted BOOLEAN NOT NULL CHECK (is_muted IN (false, true)) DEFAULT false,
is_banned BOOLEAN NOT NULL CHECK (is_banned IN (false, true)) DEFAULT false,
ban_reason TEXT,
+ position INT, -- null only if is_member = false
PRIMARY KEY (user_id, network_id)
);