diff options
| -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; |