Issue information

Issue ID
#8273
Status
Working as Intended
Severity
None
Started
Eiphes
Jul 20, 2014 6:02
Last Post
Haru
May 1, 2016 13:35
Confirmation
N/A

Eiphes - Jul 20, 2014 6:02

Hi all,

The sql-files updates folder ([url="https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades"]https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades[/url]) 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,[code=auto:0] 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;[/code]
And here's the latest structure,[code=auto:0] 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; [/code]

[url="https://raw.githubusercontent.com/HerculesWS/Hercules/master/sql-files/item_db_re.sql"]https://raw.githubusercontent.com/HerculesWS/Hercules/master/sql-files/item_db_re.sql[/url]

This post has been edited by Eiphes on Jul 20, 2014 6:02

Haru - May 1, 2016 13:35

Closing this - sql databases aren't meant to be updated, but deleted and recreated