diff options
Diffstat (limited to 'sql-files/item_db2.sql')
| -rw-r--r-- | sql-files/item_db2.sql | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index de2c541e3..ed77f2812 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-2016 Hercules Dev Team +-- Copyright (C) 2013-2020 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 @@ -21,16 +21,19 @@ -- please consider modifying the corresponding .conf file inside -- the db folder, and then re-run the db2sql plugin. +-- GENERATED FILE DO NOT EDIT -- + -- -- Table structure for table `item_db2` -- 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, @@ -42,12 +45,13 @@ CREATE TABLE `item_db2` ( `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, + `equip_locations` mediumint(8) UNSIGNED DEFAULT NULL, `weapon_level` tinyint(2) UNSIGNED DEFAULT NULL, `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, |