From 8077efb70e0af1c54a84859f73c96de21c60107b Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Fri, 23 Oct 2020 12:27:14 -0300 Subject: main.sql should reflect OUR needs, not RO's needs. And in this case, quest.count2 and quest.count3 must be a signed integer. aka. INT(11) or INT SIGNED. --- sql-files/main.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql-files/main.sql b/sql-files/main.sql index 7aebd73f..271c5c7a 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -834,8 +834,8 @@ CREATE TABLE IF NOT EXISTS `quest` ( `state` ENUM('0','1','2') NOT NULL DEFAULT '0', `time` INT UNSIGNED NOT NULL DEFAULT '0', `count1` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', - `count2` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', - `count3` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', + `count2` INT SIGNED NOT NULL DEFAULT '0', + `count3` INT SIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`char_id`,`quest_id`) ) ENGINE=MyISAM; -- cgit v1.2.3-60-g2f50