diff options
author | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-04-20 18:05:14 +0000 |
---|---|---|
committer | shennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-04-20 18:05:14 +0000 |
commit | 92249d9f8e219916670589ba6c5f9fce47808ed8 (patch) | |
tree | 0d1b0aa06c3490b3dbf7140bebd8bda126bfd65e /sql-files | |
parent | 1b3bd9ff1725a68d66fd4015c60d6fe28e4b2334 (diff) | |
download | hercules-92249d9f8e219916670589ba6c5f9fce47808ed8.tar.gz hercules-92249d9f8e219916670589ba6c5f9fce47808ed8.tar.bz2 hercules-92249d9f8e219916670589ba6c5f9fce47808ed8.tar.xz hercules-92249d9f8e219916670589ba6c5f9fce47808ed8.zip |
Initial support for Genetic, Sorcerer and Elemental Summons. Special Thanks to 3CeAM for the base.
Notice this revision onwards requires you to update your char sql table and add the elemental sql table (check sql-files/upgrade_svn15885_log.sql)
If you step by any bugs, let us know at http://rathena.org/board/tracker/ Thank you very much.
ARRIBA ARRIBA.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15885 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/main.sql | 24 | ||||
-rw-r--r-- | sql-files/upgrade_svn15885_log.sql | 26 |
2 files changed, 50 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index c000a3892..9c8551e3a 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -80,6 +80,7 @@ CREATE TABLE IF NOT EXISTS `char` ( `guild_id` int(11) unsigned NOT NULL default '0', `pet_id` int(11) unsigned NOT NULL default '0', `homun_id` int(11) unsigned NOT NULL default '0', + `elemental_id` int(11) unsigned NOT NULL default '0' `hair` tinyint(4) unsigned NOT NULL default '0', `hair_color` smallint(5) unsigned NOT NULL default '0', `clothes_color` smallint(5) unsigned NOT NULL default '0', @@ -132,6 +133,29 @@ CREATE TABLE IF NOT EXISTS `charlog` ( ) ENGINE=MyISAM; -- +-- Table structure for table `elemental` +-- + +CREATE TABLE IF NOT EXISTS `elemental` ( + `ele_id` int(11) unsigned NOT NULL auto_increment, + `char_id` int(11) NOT NULL, + `class` mediumint(9) unsigned NOT NULL default '0', + `mode` int(11) unsigned NOT NULL default '1', + `hp` int(12) NOT NULL default '1', + `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', + `life_time` int(11) NOT NULL default '0', + PRIMARY KEY (`ele_id`) +) ENGINE=MyISAM; + +-- -- Table structure for table `friends` -- diff --git a/sql-files/upgrade_svn15885_log.sql b/sql-files/upgrade_svn15885_log.sql new file mode 100644 index 000000000..5ab9fc2fa --- /dev/null +++ b/sql-files/upgrade_svn15885_log.sql @@ -0,0 +1,26 @@ +-- Adds 'I' to `type` in `zenylog` + +ALTER TABLE `char` ADD COLUMN `elemental_id` int(11) unsigned NOT NULL default '0'; + +-- +-- Table structure for table `elemental` +-- + +CREATE TABLE IF NOT EXISTS `elemental` ( + `ele_id` int(11) unsigned NOT NULL auto_increment, + `char_id` int(11) NOT NULL, + `class` mediumint(9) unsigned NOT NULL default '0', + `mode` int(11) unsigned NOT NULL default '1', + `hp` int(12) NOT NULL default '1', + `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', + `life_time` int(11) NOT NULL default '0', + PRIMARY KEY (`ele_id`) +) ENGINE=MyISAM;
\ No newline at end of file |