diff options
Diffstat (limited to 'backend/database')
| -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) |