diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-23 14:58:04 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-23 14:58:04 +0200 |
| commit | ae6362c91f2d5d51cc606c9baed9c76b50e7ddfe (patch) | |
| tree | dc77ad512e846602e9cffe77a2f2d84e37481364 | |
| parent | 02e7420fe029588685c4dc35e44a1d16d590f387 (diff) | |
Removed schema todos
| -rw-r--r-- | migrations/20241026174345_init.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/migrations/20241026174345_init.sql b/migrations/20241026174345_init.sql index 4d55e0d..c0056b3 100644 --- a/migrations/20241026174345_init.sql +++ b/migrations/20241026174345_init.sql @@ -40,7 +40,7 @@ CREATE TABLE frequencies ( hex_color TEXT, perms INT NOT NULL CHECK (perms IN (0, 1, 2)), -- 0 rw admin | 1 r all w admin | 2 rw all - position INT NOT NULL -- TODO: make this auto inc + position INT NOT NULL ); CREATE TABLE users_networks ( @@ -50,7 +50,6 @@ CREATE TABLE users_networks ( is_admin BOOLEAN NOT NULL CHECK (is_admin IN (0, 1)) DEFAULT 0, is_muted BOOLEAN NOT NULL CHECK (is_muted IN (0, 1)) DEFAULT 0, PRIMARY KEY (user_id, network_id) - -- TODO: In discord, if u get "kicked" then join does your "joined_at" show the oldest or latest? ); CREATE TABLE user_trusted_users ( |