diff options
author | Jesusaves <cpntb1@ymail.com> | 2020-10-23 12:27:14 -0300 |
---|---|---|
committer | Jesusaves <cpntb1@ymail.com> | 2020-10-23 12:27:14 -0300 |
commit | 8077efb70e0af1c54a84859f73c96de21c60107b (patch) | |
tree | 9d32d786837985bfdaef351cf55135229b8112a1 | |
parent | 5e721a17f201a9e0f1983ce41f0f3e14c58c86ce (diff) | |
download | serverdata-8077efb70e0af1c54a84859f73c96de21c60107b.tar.gz serverdata-8077efb70e0af1c54a84859f73c96de21c60107b.tar.bz2 serverdata-8077efb70e0af1c54a84859f73c96de21c60107b.tar.xz serverdata-8077efb70e0af1c54a84859f73c96de21c60107b.zip |
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.
-rw-r--r-- | sql-files/main.sql | 4 |
1 files 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; |