diff options
| author | Haru <haru@dotalux.com> | 2017-08-22 02:00:21 +0200 |
|---|---|---|
| committer | Haru <haru@dotalux.com> | 2017-09-17 17:48:11 +0200 |
| commit | 8843fa5ae4a301a87bb2fa91ff8ba2224a7c8f65 (patch) | |
| tree | 3bac09d88c6de0bf85dc07ce2906c2b199902f74 /sql-files/item_db2.sql | |
| parent | a98b2d93f3727d18d8add5cb5c35830cbb171114 (diff) | |
| download | hercules-8843fa5ae4a301a87bb2fa91ff8ba2224a7c8f65.tar.gz hercules-8843fa5ae4a301a87bb2fa91ff8ba2224a7c8f65.tar.bz2 hercules-8843fa5ae4a301a87bb2fa91ff8ba2224a7c8f65.tar.xz hercules-8843fa5ae4a301a87bb2fa91ff8ba2224a7c8f65.zip | |
Item DB SQL Update
Signed-off-by: Haru <haru@dotalux.com>
Diffstat (limited to 'sql-files/item_db2.sql')
| -rw-r--r-- | sql-files/item_db2.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index 9d6c1386f..4c7640e8f 100644 --- a/sql-files/item_db2.sql +++ b/sql-files/item_db2.sql @@ -33,6 +33,7 @@ CREATE TABLE `item_db2` ( `name_english` varchar(50) NOT NULL DEFAULT '', `name_japanese` varchar(50) NOT NULL DEFAULT '', `type` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', + `subtype` tinyint(2) UNSIGNED DEFAULT NULL, `price_buy` mediumint(10) DEFAULT NULL, `price_sell` mediumint(10) DEFAULT NULL, `weight` smallint(5) UNSIGNED DEFAULT NULL, @@ -50,7 +51,7 @@ CREATE TABLE `item_db2` ( `equip_level_max` smallint(5) UNSIGNED DEFAULT NULL, `refineable` tinyint(1) UNSIGNED DEFAULT NULL, `disable_options` tinyint(1) UNSIGNED DEFAULT NULL, - `view` smallint(3) UNSIGNED DEFAULT NULL, + `view_sprite` smallint(3) UNSIGNED DEFAULT NULL, `bindonequip` tinyint(1) UNSIGNED DEFAULT NULL, `forceserial` tinyint(1) UNSIGNED DEFAULT NULL, `buyingstore` tinyint(1) UNSIGNED DEFAULT NULL, |