From aef0d1c1268ab7d4bc18996c9c6b4da16a40aadc Mon Sep 17 00:00:00 2001 From: navewindre Date: Mon, 4 Dec 2023 18:06:10 +0100 Subject: bbbbbbbbwaaaaaaaaaaa --- .../scripting/gokz-localranks/db/create_tables.sp | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 sourcemod/scripting/gokz-localranks/db/create_tables.sp (limited to 'sourcemod/scripting/gokz-localranks/db/create_tables.sp') diff --git a/sourcemod/scripting/gokz-localranks/db/create_tables.sp b/sourcemod/scripting/gokz-localranks/db/create_tables.sp new file mode 100644 index 0000000..a15f67c --- /dev/null +++ b/sourcemod/scripting/gokz-localranks/db/create_tables.sp @@ -0,0 +1,27 @@ +/* + Table creation and alteration. +*/ + + + +void DB_CreateTables() +{ + Transaction txn = SQL_CreateTransaction(); + + // Create/alter database tables + switch (g_DBType) + { + case DatabaseType_SQLite: + { + txn.AddQuery(sqlite_maps_alter1); + } + case DatabaseType_MySQL: + { + txn.AddQuery(mysql_maps_alter1); + } + } + + // No error logs for this transaction as it will always throw an error + // if the column already exists, which is more annoying than helpful. + SQL_ExecuteTransaction(gH_DB, txn, _, _, _, DBPrio_High); +} \ No newline at end of file -- cgit v1.2.3