diff options
| author | Haru <haru@dotalux.com> | 2019-11-18 21:02:01 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-11-18 21:02:01 +0100 |
| commit | 5e61cd4f23492fded25d48a4d6609603d916c5e5 (patch) | |
| tree | fae5542ba5319753087129d92b6f8032b9a09147 /sql-files | |
| parent | fac2eef6c66b1da34c68963732f8afece3a5289f (diff) | |
| parent | 8312581eb96d1d497fbce59a7a33fc55a6c236b5 (diff) | |
| download | hercules-5e61cd4f23492fded25d48a4d6609603d916c5e5.tar.gz hercules-5e61cd4f23492fded25d48a4d6609603d916c5e5.tar.bz2 hercules-5e61cd4f23492fded25d48a4d6609603d916c5e5.tar.xz hercules-5e61cd4f23492fded25d48a4d6609603d916c5e5.zip | |
Merge pull request #2582 from 4144/sqlvalidation
Add script for sql files syntax validation
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); |