diff options
Diffstat (limited to 'sql-files/item_db2.sql')
| -rw-r--r-- | sql-files/item_db2.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index 2e519c52f..3b4f58219 100644 --- a/sql-files/item_db2.sql +++ b/sql-files/item_db2.sql @@ -1,7 +1,7 @@ -- This file is part of Hercules. -- http://herc.ws - http://github.com/HerculesWS/Hercules -- --- Copyright (C) 2013-2017 Hercules Dev Team +-- Copyright (C) 2013-2019 Hercules Dev Team -- -- Hercules is free software: you can redistribute it and/or modify -- it under the terms of the GNU General Public License as published by @@ -29,10 +29,11 @@ DROP TABLE IF EXISTS `item_db2`; CREATE TABLE `item_db2` ( - `id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', + `id` int(11) UNSIGNED NOT NULL DEFAULT '0', `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, @@ -49,7 +50,8 @@ CREATE TABLE `item_db2` ( `equip_level_min` smallint(5) UNSIGNED DEFAULT NULL, `equip_level_max` smallint(5) UNSIGNED DEFAULT NULL, `refineable` tinyint(1) UNSIGNED DEFAULT NULL, - `view` smallint(3) UNSIGNED DEFAULT NULL, + `disable_options` tinyint(1) 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, |