diff options
| author | shennetsind <ind@henn.et> | 2013-02-14 17:04:42 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-02-14 17:15:36 -0200 |
| commit | 810ba40b78087cc6aa7eb9ad3a3e46534393b9e8 (patch) | |
| tree | e205d88bc02194101fc2a7aa2d80e5d884fe8a9c /sql-files/upgrades/upgrade_svn15885.sql | |
| parent | 20abc4a94a4bd3a7428c042cc6d1c313272fbc28 (diff) | |
| download | hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.gz hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.bz2 hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.tar.xz hercules-810ba40b78087cc6aa7eb9ad3a3e46534393b9e8.zip | |
Introducing MySQL DB Update Checker
First version.
Signed-off-by: shennetsind <ind@henn.et>
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; |