diff options
| author | Trojal <trojal@gmail.com> | 2013-01-10 20:09:39 -0800 |
|---|---|---|
| committer | Trojal <trojal@gmail.com> | 2013-01-10 20:32:02 -0800 |
| commit | 83e7a4954437c13aec639b0b512252cc20a8f36c (patch) | |
| tree | b7f6d11b2058248d026f2d9944e8f4b6ac288d50 /sql-files/upgrades/upgrade_svn15885.sql | |
| parent | 51bfeb38eb139e97e0e1c096c85c15fba234f35b (diff) | |
| parent | 38e583df21eccd9e4f31d38acaae32579c6f0d27 (diff) | |
| download | hercules-83e7a4954437c13aec639b0b512252cc20a8f36c.tar.gz hercules-83e7a4954437c13aec639b0b512252cc20a8f36c.tar.bz2 hercules-83e7a4954437c13aec639b0b512252cc20a8f36c.tar.xz hercules-83e7a4954437c13aec639b0b512252cc20a8f36c.zip | |
Merge rathena repository to form Hercules initial commit.
Diffstat (limited to 'sql-files/upgrades/upgrade_svn15885.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn15885.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql-files/upgrades/upgrade_svn15885.sql b/sql-files/upgrades/upgrade_svn15885.sql new file mode 100644 index 000000000..48b25b5a7 --- /dev/null +++ b/sql-files/upgrades/upgrade_svn15885.sql @@ -0,0 +1,24 @@ +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; |