diff options
| author | Andrei Karas <akaras@inbox.ru> | 2016-03-06 21:43:17 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2016-03-06 21:43:17 +0300 |
| commit | 89e73fc1053d1e02e13901e6722bdb45e6fa91e2 (patch) | |
| tree | 958b030d3a6161ca2b03d4b0f721b8189818bd9c /sql-files | |
| parent | e4cf73ff1579a3eed594b41c6c6ba517f8e37e77 (diff) | |
| parent | 1d405de7e48649498702ae31d71751dc70ff5b45 (diff) | |
| download | hercules-89e73fc1053d1e02e13901e6722bdb45e6fa91e2.tar.gz hercules-89e73fc1053d1e02e13901e6722bdb45e6fa91e2.tar.bz2 hercules-89e73fc1053d1e02e13901e6722bdb45e6fa91e2.tar.xz hercules-89e73fc1053d1e02e13901e6722bdb45e6fa91e2.zip | |
Merge pull request #1187 from HerculesWS/itemdb_jobfix
Various fixes for the "Job" itemdb field
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, |