diff options
| author | Haru <haru@dotalux.com> | 2016-03-06 16:49:21 +0100 |
|---|---|---|
| committer | Haru <haru@dotalux.com> | 2016-03-06 19:17:12 +0100 |
| commit | 1d405de7e48649498702ae31d71751dc70ff5b45 (patch) | |
| tree | 958b030d3a6161ca2b03d4b0f721b8189818bd9c /sql-files | |
| parent | 560158cfa20c769fc2d92fa7285ca5aad8053cc9 (diff) | |
| download | hercules-1d405de7e48649498702ae31d71751dc70ff5b45.tar.gz hercules-1d405de7e48649498702ae31d71751dc70ff5b45.tar.bz2 hercules-1d405de7e48649498702ae31d71751dc70ff5b45.tar.xz hercules-1d405de7e48649498702ae31d71751dc70ff5b45.zip | |
Added support for the textual "Job" field to the itemdb2sql converter
Signed-off-by: Haru <haru@dotalux.com>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/item_db2.sql | 2 | ||||
| -rw-r--r-- | sql-files/item_db_re.sql | 2 |
2 files changed, 2 insertions, 2 deletions
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, |