sql-files folder redesign as discussed with other developers, all upgrade files prior to rathena were removed (if you need them you can use the trac or download a earlier version of the folder).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16750 54d463be-8e91-2dee-dedb-b68131a5f0ec

13 files changed, 50 insertions, 0 deletions

diff --git a/sql-files/upgrades/upgrade_svn15003.sql b/sql-files/upgrades/upgrade_svn15003.sql
new file mode 100644
index 000000000..e30a3b0fd
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15003.sql
@@ -0,0 +1 @@
+ALTER TABLE `global_reg_value` MODIFY `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '3';
diff --git a/sql-files/upgrades/upgrade_svn15420_log.sql b/sql-files/upgrades/upgrade_svn15420_log.sql
new file mode 100644
index 000000000..580dce9a2
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15420_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'I' and 'X' to `type` in `picklog` table
+
+ALTER TABLE `picklog` MODIFY `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X') NOT NULL DEFAULT 'P';
diff --git a/sql-files/upgrades/upgrade_svn15519_log.sql b/sql-files/upgrades/upgrade_svn15519_log.sql
new file mode 100644
index 000000000..623b022b8
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15519_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'D' and 'U' to `type` in `picklog` table
+
+ALTER TABLE `picklog` MODIFY `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL DEFAULT 'P';
diff --git a/sql-files/upgrades/upgrade_svn15531_db.sql b/sql-files/upgrades/upgrade_svn15531_db.sql
new file mode 100644
index 000000000..ce0e56302
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15531_db.sql
@@ -0,0 +1,4 @@
+-- `ExpPer` column removed from `mob_db` and `mob_db2` tables
+
+ALTER TABLE `mob_db` DROP COLUMN `ExpPer`;
+ALTER TABLE `mob_db2` DROP COLUMN `ExpPer`;
diff --git a/sql-files/upgrades/upgrade_svn15572.sql b/sql-files/upgrades/upgrade_svn15572.sql
new file mode 100644
index 000000000..821bb79d6
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15572.sql
@@ -0,0 +1,3 @@
+-- Rename `level` column to `group_id` in `login` table
+
+ALTER TABLE `login` CHANGE COLUMN `level` `group_id` TINYINT(3) NOT NULL DEFAULT '0';
\ No newline at end of file
diff --git a/sql-files/upgrades/upgrade_svn15818_log.sql b/sql-files/upgrades/upgrade_svn15818_log.sql
new file mode 100644
index 000000000..b61f71f53
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15818_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'I' to `type` in `zenylog`
+
+ALTER TABLE `zenylog` MODIFY `type` ENUM('M','T','V','S','N','A','E','B','I') NOT NULL DEFAULT 'S';
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;
diff --git a/sql-files/upgrades/upgrade_svn15926_log.sql b/sql-files/upgrades/upgrade_svn15926_log.sql
new file mode 100644
index 000000000..099ee6faa
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn15926_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'D' to `type` in `zenylog`
+
+ALTER TABLE `zenylog` MODIFY `type` ENUM('M','T','V','S','N','A','E','B','I','D') NOT NULL DEFAULT 'S';
diff --git a/sql-files/upgrades/upgrade_svn16490.sql b/sql-files/upgrades/upgrade_svn16490.sql
new file mode 100644
index 000000000..b38445c46
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn16490.sql
@@ -0,0 +1 @@
+ALTER TABLE `char` ADD CONSTRAINT `name_key` UNIQUE (`name`);
diff --git a/sql-files/upgrades/upgrade_svn16518.sql b/sql-files/upgrades/upgrade_svn16518.sql
new file mode 100644
index 000000000..1c142c65f
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn16518.sql
@@ -0,0 +1 @@
+ALTER TABLE `inventory`  ADD COLUMN `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`;
diff --git a/sql-files/upgrades/upgrade_svn16639.sql b/sql-files/upgrades/upgrade_svn16639.sql
new file mode 100644
index 000000000..0da4b91d1
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn16639.sql
@@ -0,0 +1 @@
+ALTER TABLE `item_db_re` CHANGE `equip_level` `equip_level` VARCHAR(10) DEFAULT '';
diff --git a/sql-files/upgrades/upgrade_svn16645.sql b/sql-files/upgrades/upgrade_svn16645.sql
new file mode 100644
index 000000000..9a3237ad8
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn16645.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `item_db_re` MODIFY COLUMN `atk:matk` VARCHAR(11) DEFAULT '';
+ALTER TABLE `item_db_re` MODIFY COLUMN `defence` SMALLINT(5) UNSIGNED DEFAULT NULL;
\ No newline at end of file
diff --git a/sql-files/upgrades/upgrade_svn16663.sql b/sql-files/upgrades/upgrade_svn16663.sql
new file mode 100644
index 000000000..8883a108b
--- /dev/null
+++ b/sql-files/upgrades/upgrade_svn16663.sql
@@ -0,0 +1 @@
+ALTER TABLE  `homunculus` ADD  `prev_class` MEDIUMINT( 9 ) NOT NULL AFTER  `class`