From 86cea497593cd26369d86d184e38c192909d181c Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sat, 4 Aug 2018 00:24:03 -0300 Subject: Rewrite query, and fish a water bottle >.< --- sql-files/upgrades/2018-08-03--11-37.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sql-files') diff --git a/sql-files/upgrades/2018-08-03--11-37.sql b/sql-files/upgrades/2018-08-03--11-37.sql index e8908e899..1dde29fd6 100644 --- a/sql-files/upgrades/2018-08-03--11-37.sql +++ b/sql-files/upgrades/2018-08-03--11-37.sql @@ -18,7 +18,7 @@ -- You should have received a copy of the GNU General Public License -- along with this program. If not, see . -ALTER TABLE `quest` MODIFY `count1` INT(11) UNSIGNED NOT NULL DEFAULT '0'; -ALTER TABLE `quest` MODIFY `count2` INT(11) UNSIGNED NOT NULL DEFAULT '0'; -ALTER TABLE `quest` MODIFY `count3` INT(11) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `quest` CHANGE `count1` `count1` INT(11) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `quest` CHANGE `count2` `count2` INT(11) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `quest` CHANGE `count3` `count3` INT(11) UNSIGNED NOT NULL DEFAULT '0'; INSERT INTO `sql_updates` (`timestamp`) VALUES (1533307076); -- cgit v1.2.3-60-g2f50