diff options
| author | navewindre <nw@moneybot.cc> | 2023-12-04 18:06:10 +0100 |
|---|---|---|
| committer | navewindre <nw@moneybot.cc> | 2023-12-04 18:06:10 +0100 |
| commit | aef0d1c1268ab7d4bc18996c9c6b4da16a40aadc (patch) | |
| tree | 43e766b51704f4ab8b383583bdc1871eeeb9c698 /sourcemod/scripting/gokz-localdb/db/create_tables.sp | |
| parent | 38f1140c11724da05a23a10385061200b907cf6e (diff) | |
bbbbbbbbwaaaaaaaaaaa
Diffstat (limited to 'sourcemod/scripting/gokz-localdb/db/create_tables.sp')
| -rw-r--r-- | sourcemod/scripting/gokz-localdb/db/create_tables.sp | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sourcemod/scripting/gokz-localdb/db/create_tables.sp b/sourcemod/scripting/gokz-localdb/db/create_tables.sp new file mode 100644 index 0000000..2138830 --- /dev/null +++ b/sourcemod/scripting/gokz-localdb/db/create_tables.sp @@ -0,0 +1,36 @@ +/* + Table creation and alteration. +*/ + + + +void DB_CreateTables() +{ + Transaction txn = SQL_CreateTransaction(); + + switch (g_DBType) + { + case DatabaseType_SQLite: + { + txn.AddQuery(sqlite_players_create); + txn.AddQuery(sqlite_maps_create); + txn.AddQuery(sqlite_mapcourses_create); + txn.AddQuery(sqlite_times_create); + txn.AddQuery(sqlite_jumpstats_create); + txn.AddQuery(sqlite_vbpos_create); + txn.AddQuery(sqlite_startpos_create); + } + case DatabaseType_MySQL: + { + txn.AddQuery(mysql_players_create); + txn.AddQuery(mysql_maps_create); + txn.AddQuery(mysql_mapcourses_create); + txn.AddQuery(mysql_times_create); + txn.AddQuery(mysql_jumpstats_create); + txn.AddQuery(mysql_vbpos_create); + txn.AddQuery(mysql_startpos_create); + } + } + + SQL_ExecuteTransaction(gH_DB, txn, _, DB_TxnFailure_Generic, _, DBPrio_High); +}
\ No newline at end of file |