summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2013-11-16 21:19:56 +0100
committerjaBote <jaBote@users.noreply.github.com>2013-11-16 21:19:56 +0100
commitbe6440dfb609b4ce28ca973a8987ab434774c8ed (patch)
tree7954c16c493648f959749189a04fba1746d81861 /sql-files/upgrades
parent42a7aa3362807a00f08263d8ead9eb5019051b21 (diff)
downloadhercules-be6440dfb609b4ce28ca973a8987ab434774c8ed.tar.gz
hercules-be6440dfb609b4ce28ca973a8987ab434774c8ed.tar.bz2
hercules-be6440dfb609b4ce28ca973a8987ab434774c8ed.tar.xz
hercules-be6440dfb609b4ce28ca973a8987ab434774c8ed.zip
Update rAthena-main-upgrade.sql
Follow-up aee2f6317e1c927847993801b5973d7e2e27a418
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/rAthena-main-upgrade.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql
index d91ca09fe..19f6d55ec 100644
--- a/sql-files/upgrades/rAthena-main-upgrade.sql
+++ b/sql-files/upgrades/rAthena-main-upgrade.sql
@@ -4,7 +4,6 @@
-- Remember to make a backup before applying.
-- We are not liable for any data loss this may cause.
-- Apply in the same database you applied your main.sql
--- Last revision: November 10, 2013, 19:00
-- Drop table contents from ´sc_data´ since we use a different status order than rAthena
-- /!\ WARNING /!\ This will remove _ALL_ of the status effects active on the server
@@ -22,6 +21,7 @@ ALTER TABLE `cart_inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default
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';
+ ADD `unban_time` int(11) unsigned NOT NULL default '0';
-- Upgrades for table `guild_storage`
ALTER TABLE `guild_storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
@@ -57,6 +57,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1384545461);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1384588175);
-- Updates to table `storage`
ALTER TABLE `storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';