diff options
| author | jaBote <jaBote@users.noreply.github.com> | 2013-11-16 21:19:56 +0100 |
|---|---|---|
| committer | jaBote <jaBote@users.noreply.github.com> | 2013-11-16 21:19:56 +0100 |
| commit | be6440dfb609b4ce28ca973a8987ab434774c8ed (patch) | |
| tree | 7954c16c493648f959749189a04fba1746d81861 /sql-files | |
| parent | 42a7aa3362807a00f08263d8ead9eb5019051b21 (diff) | |
| download | hercules-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')
| -rw-r--r-- | sql-files/upgrades/rAthena-main-upgrade.sql | 3 |
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'; |