Issue Information
-
#008273
-
0 - None Assigned
-
Working as Intended
Issue Confirmations
-
Yes (0)No (0)
0
Missing necessary SQL updates to update to latest version.
Posted by jTynne on 20 July 2014 - 06:02 AM
Hi all,
The sql-files updates folder (https://github.com/H...-files/upgrades) does not seem to have any of the necessary updates to bring the item database to the newest version for older users.
I haven't updated Hercules in about a month or two, so here is my current item database sql structure,
https://raw.githubus.../item_db_re.sql
The sql-files updates folder (https://github.com/H...-files/upgrades) does not seem to have any of the necessary updates to bring the item database to the newest version for older users.
I haven't updated Hercules in about a month or two, so here is my current item database sql structure,
CREATE TABLE IF NOT EXISTS `item_db_re` ( `id` smallint(5) 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', `price_buy` mediumint(10) DEFAULT NULL, `price_sell` mediumint(10) DEFAULT NULL, `weight` smallint(5) unsigned DEFAULT NULL, `atk` smallint(5) unsigned DEFAULT NULL, `matk` smallint(5) unsigned DEFAULT NULL, `defence` smallint(5) unsigned DEFAULT NULL, `range` tinyint(2) unsigned DEFAULT NULL, `slots` tinyint(2) unsigned DEFAULT NULL, `equip_jobs` int(12) unsigned DEFAULT NULL, `equip_upper` tinyint(8) unsigned DEFAULT NULL, `equip_genders` tinyint(2) unsigned DEFAULT NULL, `equip_locations` smallint(4) 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, `bindonequip` tinyint(1) unsigned DEFAULT NULL, `script` text, `equip_script` text, `unequip_script` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;And here's the latest structure,
CREATE TABLE `item_db_re` ( `id` smallint(5) 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', `price_buy` mediumint(10) DEFAULT NULL, `price_sell` mediumint(10) DEFAULT NULL, `weight` smallint(5) UNSIGNED DEFAULT NULL, `atk` smallint(5) UNSIGNED DEFAULT NULL, `matk` smallint(5) UNSIGNED DEFAULT NULL, `defence` smallint(5) UNSIGNED DEFAULT NULL, `range` tinyint(2) UNSIGNED DEFAULT NULL, `slots` tinyint(2) UNSIGNED DEFAULT NULL, `equip_jobs` int(12) UNSIGNED DEFAULT NULL, `equip_upper` tinyint(8) UNSIGNED DEFAULT NULL, `equip_genders` tinyint(2) UNSIGNED DEFAULT NULL, `equip_locations` smallint(4) 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, `bindonequip` tinyint(1) UNSIGNED DEFAULT NULL, `buyingstore` tinyint(1) UNSIGNED DEFAULT NULL, `delay` mediumint(9) UNSIGNED DEFAULT NULL, `trade_flag` smallint(4) UNSIGNED DEFAULT NULL, `trade_group` smallint(3) UNSIGNED DEFAULT NULL, `nouse_flag` smallint(4) UNSIGNED DEFAULT NULL, `nouse_group` smallint(4) UNSIGNED DEFAULT NULL, `stack_amount` mediumint(6) UNSIGNED DEFAULT NULL, `stack_flag` tinyint(2) UNSIGNED DEFAULT NULL, `sprite` mediumint(6) UNSIGNED DEFAULT NULL, `script` text, `equip_script` text, `unequip_script` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
https://raw.githubus.../item_db_re.sql
