From 8312581eb96d1d497fbce59a7a33fc55a6c236b5 Mon Sep 17 00:00:00 2001 From: Andrei Karas Date: Mon, 18 Nov 2019 20:21:25 +0300 Subject: Fix syntax errors in sql scripts --- sql-files/upgrades/2017-03-15--14-29.sql | 8 ++++---- sql-files/upgrades/2019-10-12--14-21.sql | 2 +- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/sql-files/upgrades/2017-03-15--14-29.sql b/sql-files/upgrades/2017-03-15--14-29.sql index 6e6044738..13306d73e 100644 --- a/sql-files/upgrades/2017-03-15--14-29.sql +++ b/sql-files/upgrades/2017-03-15--14-29.sql @@ -50,13 +50,13 @@ CREATE TABLE IF NOT EXISTS `rodex_items` ( CREATE TABLE IF NOT EXISTS `rodex_mail` ( `mail_id` BIGINT(20) NOT NULL AUTO_INCREMENT, - `sender_name` VARCHAR(30) NOT NULL COLLATE 'utf8_unicode_ci', + `sender_name` VARCHAR(30) COLLATE 'utf8_unicode_ci' NOT NULL, `sender_id` INT(11) NOT NULL, - `receiver_name` VARCHAR(30) NOT NULL COLLATE 'utf8_unicode_ci', + `receiver_name` VARCHAR(30) COLLATE 'utf8_unicode_ci' NOT NULL, `receiver_id` INT(11) NOT NULL, `receiver_accountid` INT(11) NOT NULL, - `title` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci', - `body` VARCHAR(510) NOT NULL COLLATE 'utf8_unicode_ci', + `title` VARCHAR(50) COLLATE 'utf8_unicode_ci' NOT NULL, + `body` VARCHAR(510) COLLATE 'utf8_unicode_ci' NOT NULL, `zeny` BIGINT(20) NOT NULL, `type` TINYINT(8) UNSIGNED NOT NULL, `is_read` TINYINT(8) NOT NULL, diff --git a/sql-files/upgrades/2019-10-12--14-21.sql b/sql-files/upgrades/2019-10-12--14-21.sql index bd885a874..7da66e9b8 100644 --- a/sql-files/upgrades/2019-10-12--14-21.sql +++ b/sql-files/upgrades/2019-10-12--14-21.sql @@ -19,5 +19,5 @@ -- along with this program. If not, see . -ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2', '3') NOT NULL DEFAULT 'P', +ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2', '3') NOT NULL DEFAULT 'P'; INSERT INTO `sql_updates` (`timestamp`) VALUES (1570870260); -- cgit v1.2.3-60-g2f50