diff options
| author | shennetsind <notind@gmail.com> | 2013-05-17 11:08:38 -0700 |
|---|---|---|
| committer | shennetsind <notind@gmail.com> | 2013-05-17 11:08:38 -0700 |
| commit | 080f7a22740225df70a488849587b462a5d6b1a3 (patch) | |
| tree | 0c1dc751af9f06e1ce3729d271de301f78a4e611 /sql-files/upgrades/upgrade_svn15885.sql | |
| parent | 754af15505f32237f8063e51ae9a1cb90788dff4 (diff) | |
| parent | 25e848f1a0f9317d63106cae048a1ef838411cb2 (diff) | |
| download | hercules-080f7a22740225df70a488849587b462a5d6b1a3.tar.gz hercules-080f7a22740225df70a488849587b462a5d6b1a3.tar.bz2 hercules-080f7a22740225df70a488849587b462a5d6b1a3.tar.xz hercules-080f7a22740225df70a488849587b462a5d6b1a3.zip | |
Merge pull request #1 from Earisu/master
updating, with earisu's
Diffstat (limited to 'sql-files/upgrades/upgrade_svn15885.sql')
| -rw-r--r-- | sql-files/upgrades/upgrade_svn15885.sql | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/sql-files/upgrades/upgrade_svn15885.sql b/sql-files/upgrades/upgrade_svn15885.sql deleted file mode 100644 index 48b25b5a7..000000000 --- a/sql-files/upgrades/upgrade_svn15885.sql +++ /dev/null @@ -1,24 +0,0 @@ -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; |