From 1d405de7e48649498702ae31d71751dc70ff5b45 Mon Sep 17 00:00:00 2001 From: Haru Date: Sun, 6 Mar 2016 16:49:21 +0100 Subject: Added support for the textual "Job" field to the itemdb2sql converter Signed-off-by: Haru --- sql-files/item_db2.sql | 2 +- sql-files/item_db_re.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index 3819d0fdf..de2c541e3 100644 --- a/sql-files/item_db2.sql +++ b/sql-files/item_db2.sql @@ -39,7 +39,7 @@ CREATE TABLE `item_db2` ( `defence` smallint(5) UNSIGNED DEFAULT NULL, `range` tinyint(2) UNSIGNED DEFAULT NULL, `slots` tinyint(2) UNSIGNED DEFAULT NULL, - `equip_jobs` int(12) UNSIGNED DEFAULT NULL, + `equip_jobs` bigint(20) UNSIGNED DEFAULT NULL, `equip_upper` tinyint(8) UNSIGNED DEFAULT NULL, `equip_genders` tinyint(2) UNSIGNED DEFAULT NULL, `equip_locations` smallint(4) UNSIGNED DEFAULT NULL, diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index c0cb02f8b..2e2929c69 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -39,7 +39,7 @@ CREATE TABLE `item_db` ( `defence` smallint(5) UNSIGNED DEFAULT NULL, `range` tinyint(2) UNSIGNED DEFAULT NULL, `slots` tinyint(2) UNSIGNED DEFAULT NULL, - `equip_jobs` int(12) UNSIGNED DEFAULT NULL, + `equip_jobs` bigint(20) UNSIGNED DEFAULT NULL, `equip_upper` tinyint(8) UNSIGNED DEFAULT NULL, `equip_genders` tinyint(2) UNSIGNED DEFAULT NULL, `equip_locations` smallint(4) UNSIGNED DEFAULT NULL, -- cgit v1.2.3-60-g2f50