diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-12-22 12:22:14 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-12-22 12:22:14 +0300 |
| commit | 7f56ba240f71c1f6800d1d51ba278b8d5a968ab3 (patch) | |
| tree | f19a3febf0be9111584d601b5adf254e1df2c9de /backend/database/init.sql | |
| parent | fix: set db connection limits (#140) (diff) | |
| download | lphub-7f56ba240f71c1f6800d1d51ba278b8d5a968ab3.tar.gz lphub-7f56ba240f71c1f6800d1d51ba278b8d5a968ab3.tar.bz2 lphub-7f56ba240f71c1f6800d1d51ba278b8d5a968ab3.zip | |
fix: discussions logic cleanup, docs title changes (#142)
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 9851ad7..54867ca 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -91,6 +91,7 @@ CREATE TABLE map_discussions ( | |||
| 91 | content TEXT NOT NULL, | 91 | content TEXT NOT NULL, |
| 92 | created_at TIMESTAMP NOT NULL DEFAULT now(), | 92 | created_at TIMESTAMP NOT NULL DEFAULT now(), |
| 93 | updated_at TIMESTAMP NOT NULL DEFAULT now(), | 93 | updated_at TIMESTAMP NOT NULL DEFAULT now(), |
| 94 | is_deleted BOOLEAN NOT NULL DEFAULT false, | ||
| 94 | PRIMARY KEY (id), | 95 | PRIMARY KEY (id), |
| 95 | FOREIGN KEY (map_id) REFERENCES maps(id), | 96 | FOREIGN KEY (map_id) REFERENCES maps(id), |
| 96 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | 97 | FOREIGN KEY (user_id) REFERENCES users(steam_id) |