UPDATE TABLE `player`.

Breaks backward compatibility (all servers)

1 files 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;