diff options
| author | Haru <haru@dotalux.com> | 2017-09-17 23:52:02 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-09-17 23:52:02 +0200 |
| commit | d4723731ed75151e0194a0a082db0a906d06502c (patch) | |
| tree | 2c134cba7d9c55a5940a136c710396e8ff5de404 /sql-files/item_db2.sql | |
| parent | 74d54ad2c3e7a5bff9f0d35c3fb94bc0b77fd7e2 (diff) | |
| parent | 5e23e5019a54fe30762471c18272bbc322c442b6 (diff) | |
| download | hercules-d4723731ed75151e0194a0a082db0a906d06502c.tar.gz hercules-d4723731ed75151e0194a0a082db0a906d06502c.tar.bz2 hercules-d4723731ed75151e0194a0a082db0a906d06502c.tar.xz hercules-d4723731ed75151e0194a0a082db0a906d06502c.zip | |
Merge pull request #1828 from HerculesWS/item_viewid
Item DB: replace numbers with constants and split View into Subtype and ViewSprite
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, |