28.lua

main 11 lines · 717 bytes Raw

Alex Commit Server upload 18/10/2026 23:38

1function onUpdateDatabase()

2 print("> Updating database to version 28 (data type mismatch 2)")

3 db.query("ALTER TABLE `market_history` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

4 db.query("ALTER TABLE `market_offers` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

5 db.query("ALTER TABLE `player_depotitems` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

6 db.query("ALTER TABLE `player_inboxitems` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

7 db.query("ALTER TABLE `player_storeinboxitems` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

8 db.query("ALTER TABLE `player_items` CHANGE `itemtype` `itemtype` smallint unsigned NOT NULL");

9 return true

10end