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/upgrade_svn15885_log.sql | |
| 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/upgrade_svn15885_log.sql')
| -rw-r--r-- | sql-files/upgrade_svn15885_log.sql | 26 |
1 files changed, 26 insertions, 0 deletions
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 |