summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql14
-rw-r--r--sql-files/upgrades/upgrade_svn17014.sql9
2 files changed, 17 insertions, 6 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 3c4a2f2c4..198376017 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -146,12 +146,14 @@ CREATE TABLE IF NOT EXISTS `elemental` (
`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',
+ `atk` MEDIUMINT(6) unsigned NOT NULL default '0',
+ `atk2` MEDIUMINT(6) unsigned NOT NULL default '0',
+ `matk` MEDIUMINT(6) unsigned NOT NULL default '0',
+ `aspd` smallint(4) unsigned NOT NULL default '0',
+ `def` smallint(4) unsigned NOT NULL default '0',
+ `mdef` smallint(4) unsigned NOT NULL default '0',
+ `flee` smallint(4) unsigned NOT NULL default '0',
+ `hit` smallint(4) unsigned NOT NULL default '0',
`life_time` int(11) NOT NULL default '0',
PRIMARY KEY (`ele_id`)
) ENGINE=MyISAM;
diff --git a/sql-files/upgrades/upgrade_svn17014.sql b/sql-files/upgrades/upgrade_svn17014.sql
new file mode 100644
index 000000000..68a279aa7
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn17014.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `elemental` CHANGE COLUMN `str` `atk1` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `agi` `atk2` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `vit` `matk` MEDIUMINT(6) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `int` `aspd` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `dex` `def` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `luk` `mdef` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ CHANGE COLUMN `life_time` `flee` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
+ ADD COLUMN `hit` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0 AFTER `flee`,
+ ADD COLUMN `life_time` INT(11) NOT NULL DEFAULT 0 AFTER `hit`; \ No newline at end of file