diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-31 22:54:28 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-31 22:54:28 +0300 |
| commit | 69e15976e42ef404f5b0857e0ca2ea3bb8e6159b (patch) | |
| tree | 7f17f86b19f25a4e3e47a8edf5104ec3ab5256a4 /backend/database/insert/categories.sql | |
| parent | backend: add rate limiting (diff) | |
| download | lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.gz lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.bz2 lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.zip | |
database: organize sql files
Diffstat (limited to 'backend/database/insert/categories.sql')
| -rw-r--r-- | backend/database/insert/categories.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/backend/database/insert/categories.sql b/backend/database/insert/categories.sql new file mode 100644 index 0000000..6bbf9b0 --- /dev/null +++ b/backend/database/insert/categories.sql | |||
| @@ -0,0 +1,15 @@ | |||
| 1 | INSERT INTO categories(id, name) VALUES | ||
| 2 | (1, 'CM'), | ||
| 3 | (2, 'No SLA'), | ||
| 4 | (3, 'Inbounds SLA'), | ||
| 5 | (4, 'Any%'), | ||
| 6 | (5, 'All Courses'); | ||
| 7 | |||
| 8 | INSERT INTO game_categories(id, game_id, category_id) VALUES | ||
| 9 | (1, 1, 1), | ||
| 10 | (2, 1, 2), | ||
| 11 | (3, 1, 3), | ||
| 12 | (4, 1, 4), | ||
| 13 | (5, 2, 1), | ||
| 14 | (6, 2, 4), | ||
| 15 | (7, 2, 5); \ No newline at end of file | ||