From 813f7f0a5d421304fab04de9c7b5dc8b852ebfe1 Mon Sep 17 00:00:00 2001 From: shennetsind Date: Fri, 20 Apr 2012 19:56:28 +0000 Subject: follow up r15885. Renamed upgrade_svn15885_log.sql to upgrade_svn15885.sql and removed a leftover from the original file git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15888 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/upgrade_svn15885.sql | 24 ++++++++++++++++++++++++ sql-files/upgrade_svn15885_log.sql | 26 -------------------------- 2 files changed, 24 insertions(+), 26 deletions(-) create mode 100644 sql-files/upgrade_svn15885.sql delete mode 100644 sql-files/upgrade_svn15885_log.sql diff --git a/sql-files/upgrade_svn15885.sql b/sql-files/upgrade_svn15885.sql new file mode 100644 index 000000000..7f1666c79 --- /dev/null +++ b/sql-files/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; \ No newline at end of file diff --git a/sql-files/upgrade_svn15885_log.sql b/sql-files/upgrade_svn15885_log.sql deleted file mode 100644 index 5ab9fc2fa..000000000 --- a/sql-files/upgrade_svn15885_log.sql +++ /dev/null @@ -1,26 +0,0 @@ --- 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 -- cgit v1.2.3-60-g2f50