diff options
Diffstat (limited to 'migrations/20241026174345_init.sql')
| -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 ( |