From 2d959502464f8aa609f175e32575c3bd3635b2ad Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Thu, 12 Aug 2021 23:52:44 -0300 Subject: UPDATE TABLE `player`. Breaks backward compatibility (all servers) --- main.sql | 23 ++++++++++++----------- 1 file changed, 12 insertions(+), 11 deletions(-) diff --git a/main.sql b/main.sql index e15b2f7..828a856 100644 --- a/main.sql +++ b/main.sql @@ -29,17 +29,18 @@ CREATE TABLE IF NOT EXISTS `login` ( ) ENGINE=MyISAM AUTO_INCREMENT=2000000; CREATE TABLE IF NOT EXISTS `player` ( - `userid` INT(11) UNSIGNED NOT NULL DEFAULT 0, - `status` INT(11) NOT NULL DEFAULT 0, - `quest` INT(11) UNSIGNED NOT NULL DEFAULT 0, - `gp` INT(11) UNSIGNED NOT NULL DEFAULT 0, - `crystals` INT(11) UNSIGNED NOT NULL DEFAULT 0, - `exp` INT(11) UNSIGNED NOT NULL DEFAULT 0, - `level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 1, - `ap` SMALLINT(11) UNSIGNED NOT NULL DEFAULT 8, - `max_ap` INT(11) NOT NULL DEFAULT 8, - `aptime` INT(11) NOT NULL DEFAULT 0, - `max_inv` INT(11) UNSIGNED NOT NULL DEFAULT 25, + `userid` INT UNSIGNED NOT NULL DEFAULT 0, + `status` TINYINT NOT NULL DEFAULT 0, + `quest` SMALLINT UNSIGNED NOT NULL DEFAULT 0, + `gp` INT UNSIGNED NOT NULL DEFAULT 0, + `crystals` INT UNSIGNED NOT NULL DEFAULT 0, + `exp` INT UNSIGNED NOT NULL DEFAULT 0, + `level` SMALLINT UNSIGNED NOT NULL DEFAULT 1, + `ap` SMALLINT UNSIGNED NOT NULL DEFAULT 8, + `max_ap` SMALLINT NOT NULL DEFAULT 8, + `aptime` INT NOT NULL DEFAULT 0, + `max_inv` SMALLINT UNSIGNED NOT NULL DEFAULT 25, + `max_sum` TINYINT NOT NULL DEFAULT 0, `lastlogin` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`userid`) ) ENGINE=MyISAM; -- cgit v1.2.3-70-g09d2