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/main.sql | 14 ++++++++------
 1 file changed, 8 insertions(+), 6 deletions(-)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index 3c4a2f2c4..198376017 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -146,12 +146,14 @@ CREATE TABLE IF NOT EXISTS `elemental` (
   `sp` int(12) NOT NULL default '1',
   `max_hp` mediumint(8) unsigned NOT NULL default '0',
   `max_sp` mediumint(6) unsigned NOT NULL default '0',
-  `str` smallint(4) unsigned NOT NULL default '0',
-  `agi` smallint(4) unsigned NOT NULL default '0',
-  `vit` smallint(4) unsigned NOT NULL default '0',
-  `int` smallint(4) unsigned NOT NULL default '0',
-  `dex` smallint(4) unsigned NOT NULL default '0',
-  `luk` smallint(4) unsigned NOT NULL default '0',
+  `atk` MEDIUMINT(6) unsigned NOT NULL default '0',
+  `atk2` MEDIUMINT(6) unsigned NOT NULL default '0',
+  `matk` MEDIUMINT(6) unsigned NOT NULL default '0',
+  `aspd` smallint(4) unsigned NOT NULL default '0',
+  `def` smallint(4) unsigned NOT NULL default '0',
+  `mdef` smallint(4) unsigned NOT NULL default '0',
+  `flee` smallint(4) unsigned NOT NULL default '0',
+  `hit` smallint(4) unsigned NOT NULL default '0',
   `life_time` int(11) NOT NULL default '0',
   PRIMARY KEY  (`ele_id`)
 ) ENGINE=MyISAM;
-- 
cgit v1.2.3-60-g2f50

