From 97166dfb92d7cbdef8731771c38923cc219a4fc3 Mon Sep 17 00:00:00 2001
From: rud0lp20 <rud0lp20@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Tue, 11 Dec 2012 17:20:44 +0000
Subject: Happy Holidays and Happy 12/12/12 :) Update Elemental summon to its
 official behavior   - Fixed missing skill features of
 Ventus(bugreport:6792,bugreport:6723,bugreport:6511)   - Note:
 upgrade_svn17014.sql   - And other elemental skills are to follow :) Fixed
 bugreport:6889 updated const.txt where it cause error to some items. Fixed
 bugreport:6999 where matk damage deals miss atk to plant type targets. Fixed
 status calculation where it doesn't give accurate result or how official
 calculation does.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17014 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrades/upgrade_svn17014.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql-files/upgrades/upgrade_svn17014.sql

(limited to 'sql-files/upgrades/upgrade_svn17014.sql')

diff --git a/sql-files/upgrades/upgrade_svn17014.sql b/sql-files/upgrades/upgrade_svn17014.sql
new file mode 100644
index 000000000..68a279aa7
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn17014.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `elemental` CHANGE COLUMN `str` `atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `agi` `atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `vit` `matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `int` `aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `dex` `def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `luk` `mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `life_time` `flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ ADD COLUMN `hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0 AFTER `flee`,
+ ADD COLUMN `life_time` INT(11) NOT NULL DEFAULT 0 AFTER `hit`;
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

