summaryrefslogtreecommitdiff
path: root/sql-files/item_db2.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/item_db2.sql')
-rw-r--r--sql-files/item_db2.sql3
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,