diff options
| author | Andrei Karas <akaras@inbox.ru> | 2019-11-18 20:21:25 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2019-11-18 22:53:48 +0300 |
| commit | 8312581eb96d1d497fbce59a7a33fc55a6c236b5 (patch) | |
| tree | 5284f9951c9e472f18e270ef0f1091335cc664c5 /sql-files | |
| parent | 05ea79929aa099d25b543f4a86db721f5f7e700e (diff) | |
| download | hercules-8312581eb96d1d497fbce59a7a33fc55a6c236b5.tar.gz hercules-8312581eb96d1d497fbce59a7a33fc55a6c236b5.tar.bz2 hercules-8312581eb96d1d497fbce59a7a33fc55a6c236b5.tar.xz hercules-8312581eb96d1d497fbce59a7a33fc55a6c236b5.zip | |
Fix syntax errors in sql scripts
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/upgrades/2017-03-15--14-29.sql | 8 | ||||
| -rw-r--r-- | 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 <http://www.gnu.org/licenses/>. -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); |