From af63b6854165593087e517e99c665347cf635e49 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Mon, 23 Jul 2018 01:05:52 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 2 +- sql-files/item_db2.sql | 2 +- sql-files/item_db_re.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 45d712a6f..bfd6d20ba 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -29,7 +29,7 @@ DROP TABLE IF EXISTS `item_db`; CREATE TABLE `item_db` ( - `id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + `id` int(11) UNSIGNED NOT NULL DEFAULT '0', `name_english` varchar(50) NOT NULL DEFAULT '', `name_japanese` varchar(50) NOT NULL DEFAULT '', `type` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index 1957b0b8c..4df23a4d0 100644 --- a/sql-files/item_db2.sql +++ b/sql-files/item_db2.sql @@ -29,7 +29,7 @@ DROP TABLE IF EXISTS `item_db2`; CREATE TABLE `item_db2` ( - `id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + `id` int(11) UNSIGNED NOT NULL DEFAULT '0', `name_english` varchar(50) NOT NULL DEFAULT '', `name_japanese` varchar(50) NOT NULL DEFAULT '', `type` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 5763847dc..7bd8fba12 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -29,7 +29,7 @@ DROP TABLE IF EXISTS `item_db`; CREATE TABLE `item_db` ( - `id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + `id` int(11) UNSIGNED NOT NULL DEFAULT '0', `name_english` varchar(50) NOT NULL DEFAULT '', `name_japanese` varchar(50) NOT NULL DEFAULT '', `type` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', -- cgit v1.2.3-60-g2f50