16.lua

main 10 lines · 616 bytes Raw

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

1function onUpdateDatabase()

2 print("> Updating database to version 17 (fixing primary key in account ban history)")

3 db.query("ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1`")

4 db.query("ALTER TABLE `account_ban_history` DROP PRIMARY KEY")

5 db.query("ALTER TABLE `account_ban_history` ADD `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST")

6 db.query("ALTER TABLE `account_ban_history` ADD INDEX (`account_id`)")

	db.query("ALTER TABLE `account_ban_history` ADD FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE")

8 return true

9end