diff options
Diffstat (limited to 'sql-files/upgrades/2017-03-15--14-29.sql')
| -rw-r--r-- | sql-files/upgrades/2017-03-15--14-29.sql | 10 |
1 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..c3acc6ac4 100644 --- a/sql-files/upgrades/2017-03-15--14-29.sql +++ b/sql-files/upgrades/2017-03-15--14-29.sql @@ -3,7 +3,7 @@ -- This file is part of Hercules. -- http://herc.ws - http://github.com/HerculesWS/Hercules -- --- Copyright (C) 2017 Hercules Dev Team +-- Copyright (C) 2017-2020 Hercules Dev Team -- -- Hercules is free software: you can redistribute it and/or modify -- it under the terms of the GNU General Public License as published by @@ -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, |