diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-24 12:13:15 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-09-24 12:13:15 +0300 |
| commit | 6f28f28ecd899fd7f90df42528ef178a94f6677d (patch) | |
| tree | fbb00e75a5074e63028d31e1c90475d2d7d2d7cc /backend/database/init.sql | |
| parent | fix: delete demo if parsing goes wrong (#90) (diff) | |
| download | lphub-6f28f28ecd899fd7f90df42528ef178a94f6677d.tar.gz lphub-6f28f28ecd899fd7f90df42528ef178a94f6677d.tar.bz2 lphub-6f28f28ecd899fd7f90df42528ef178a94f6677d.zip | |
feat: removing (by flag) records (#56)
Former-commit-id: cc1bed84ee7ff9133192e1278c8315afee73d23a
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 0f8196b..9d7b68c 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -130,6 +130,7 @@ CREATE TABLE records_sp ( | |||
| 130 | score_time INTEGER NOT NULL, | 130 | score_time INTEGER NOT NULL, |
| 131 | demo_id UUID NOT NULL, | 131 | demo_id UUID NOT NULL, |
| 132 | record_date TIMESTAMP NOT NULL DEFAULT now(), | 132 | record_date TIMESTAMP NOT NULL DEFAULT now(), |
| 133 | is_deleted BOOLEAN NOT NULL DEFAULT false, | ||
| 133 | PRIMARY KEY (id), | 134 | PRIMARY KEY (id), |
| 134 | FOREIGN KEY (map_id) REFERENCES maps(id), | 135 | FOREIGN KEY (map_id) REFERENCES maps(id), |
| 135 | FOREIGN KEY (user_id) REFERENCES users(steam_id), | 136 | FOREIGN KEY (user_id) REFERENCES users(steam_id), |
| @@ -146,6 +147,7 @@ CREATE TABLE records_mp ( | |||
| 146 | host_demo_id UUID NOT NULL, | 147 | host_demo_id UUID NOT NULL, |
| 147 | partner_demo_id UUID NOT NULL, | 148 | partner_demo_id UUID NOT NULL, |
| 148 | record_date TIMESTAMP NOT NULL DEFAULT now(), | 149 | record_date TIMESTAMP NOT NULL DEFAULT now(), |
| 150 | is_deleted BOOLEAN NOT NULL DEFAULT false, | ||
| 149 | PRIMARY KEY (id), | 151 | PRIMARY KEY (id), |
| 150 | FOREIGN KEY (map_id) REFERENCES maps(id), | 152 | FOREIGN KEY (map_id) REFERENCES maps(id), |
| 151 | FOREIGN KEY (host_id) REFERENCES users(steam_id), | 153 | FOREIGN KEY (host_id) REFERENCES users(steam_id), |