diff options
| author | Jesusaves <cpntb1@ymail.com> | 2018-10-16 19:44:16 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2018-10-16 19:44:16 -0300 |
| commit | 314f90b5af79150fbec0ec053a1b7687022aec1b (patch) | |
| tree | 991a07cf66cea162c45c020ef5f0b765dfae165c | |
| parent | 35bcb4acf8df0e2a749e1928e147301875f01666 (diff) | |
| download | serverdata-314f90b5af79150fbec0ec053a1b7687022aec1b.tar.gz serverdata-314f90b5af79150fbec0ec053a1b7687022aec1b.tar.bz2 serverdata-314f90b5af79150fbec0ec053a1b7687022aec1b.tar.xz serverdata-314f90b5af79150fbec0ec053a1b7687022aec1b.zip | |
This should fix SQL bug
| -rw-r--r-- | npc/003-3/malindou.txt | 2 | ||||
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrades/2018-08-03--11-37.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index a8789a065..de269886e 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -130,7 +130,7 @@ OnInit: // Current UPDATE value: Ter Out 16 17:17:20 -03 2018 // This is a hack because I'm too lazy to be bothered with standard SQL Upgrade system if ($UPDATE < 1539721040) { - query_sql("CREATE TABLE IF NOT EXISTS `discord` (`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',`discord_id` VARCHAR(255) NOT NULL DEFAULT '',`discord_name` VARCHAR(255) NOT NULL DEFAULT '',`verified` ENUM(0, 1) NOT NULL DEFAULT '0') ENGINE=MyISAM"); + query_sql("CREATE TABLE IF NOT EXISTS `discord` (`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',`discord_id` VARCHAR(255) NOT NULL DEFAULT '',`discord_name` VARCHAR(255) NOT NULL DEFAULT '',`verified` ENUM('0', '1') NOT NULL DEFAULT '0') ENGINE=MyISAM"); $UPDATE=1539721040; debugmes ""; debugmes "* SQL Upgrade (no effect on new installations)"; diff --git a/sql-files/main.sql b/sql-files/main.sql index bf95ca1ef..1d5df8ec7 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -285,7 +285,7 @@ CREATE TABLE IF NOT EXISTS `discord` ( `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `discord_id` VARCHAR(255) NOT NULL DEFAULT '', `discord_name` VARCHAR(255) NOT NULL DEFAULT '', - `verified` ENUM(0, 1) NOT NULL DEFAULT '0' + `verified` ENUM('0', '1') NOT NULL DEFAULT '0' ) ENGINE=MyISAM; -- diff --git a/sql-files/upgrades/2018-08-03--11-37.sql b/sql-files/upgrades/2018-08-03--11-37.sql index 90e82534a..53c7e6d61 100644 --- a/sql-files/upgrades/2018-08-03--11-37.sql +++ b/sql-files/upgrades/2018-08-03--11-37.sql @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `discord` ( `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `discord_id` VARCHAR(255) NOT NULL DEFAULT '', `discord_name` VARCHAR(255) NOT NULL DEFAULT '', - `verified` ENUM(0, 1) NOT NULL DEFAULT '0' + `verified` ENUM('0', '1') NOT NULL DEFAULT '0' ) ENGINE=MyISAM; |