diff options
| author | shennetsind <ind@henn.et> | 2013-11-15 18:03:07 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-11-15 18:03:07 -0200 |
| commit | e6ddf9748ffdf94d4d8260dc3867ccbfaaecce77 (patch) | |
| tree | 16fd3c10c77309286a877e561730145d4ddfbce5 /sql-files/upgrades/rAthena-main-upgrade.sql | |
| parent | 40262e063a7d503104667a4135c564d996bc49c6 (diff) | |
| parent | 044332d0420e1c8d477f07be7b31358bb133fd17 (diff) | |
| download | hercules-e6ddf9748ffdf94d4d8260dc3867ccbfaaecce77.tar.gz hercules-e6ddf9748ffdf94d4d8260dc3867ccbfaaecce77.tar.bz2 hercules-e6ddf9748ffdf94d4d8260dc3867ccbfaaecce77.tar.xz hercules-e6ddf9748ffdf94d4d8260dc3867ccbfaaecce77.zip | |
Merge branch 'master' of https://github.com/HerculesWS/Hercules
Diffstat (limited to 'sql-files/upgrades/rAthena-main-upgrade.sql')
| -rw-r--r-- | sql-files/upgrades/rAthena-main-upgrade.sql | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql index 6d543918f..ac9f90342 100644 --- a/sql-files/upgrades/rAthena-main-upgrade.sql +++ b/sql-files/upgrades/rAthena-main-upgrade.sql @@ -16,22 +16,20 @@ TRUNCATE TABLE `sc_data`; DROP TABLE IF EXISTS `skillcooldown`; -- Upgrades for table `cart_inventory` -ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', - MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; +ALTER TABLE `cart_inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; -- Upgrades for table `char` -ALTER TABLE `char` DROP COLUMN `moves`, - ADD `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0', +ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0', ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0', ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0'; -- Upgrades for table `guild_storage` -ALTER TABLE `guild_storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', - MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; +ALTER TABLE `guild_storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; -- Upgrades for table `inventory` -ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', - MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; +ALTER TABLE `inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; + +-- Bank vault is saved later since we need to make a table rAthena doesn't have first -- -- Table structure for table `sql_updates` @@ -60,8 +58,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740); INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424); -- Updates to table `storage` -ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', - MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; +ALTER TABLE `storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0'; -- -- Table structure for table `account_data` @@ -83,3 +80,6 @@ INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `ba -- Dropping bank_vault column from login table ALTER TABLE `login` DROP COLUMN `bank_vault`; + +-- Drop table `bonus_script` since it's not used in Hercules +DROP TABLE IF EXISTS `bonus_script`; |