summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authorshennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-09-06 19:58:51 +0000
committershennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-09-06 19:58:51 +0000
commite3014f7b20b5df2843e3448c5327dda2641ddbdc (patch)
tree7b051a2217aeb27a77f35f2a632034df12477b87 /sql-files/upgrades
parentbd62cbc13d98a977008f42ea6583a33c99516c6b (diff)
downloadhercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.gz
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.bz2
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.xz
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.zip
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
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/upgrade_svn15003.sql1
-rw-r--r--sql-files/upgrades/upgrade_svn15420_log.sql3
-rw-r--r--sql-files/upgrades/upgrade_svn15519_log.sql3
-rw-r--r--sql-files/upgrades/upgrade_svn15531_db.sql4
-rw-r--r--sql-files/upgrades/upgrade_svn15572.sql3
-rw-r--r--sql-files/upgrades/upgrade_svn15818_log.sql3
-rw-r--r--sql-files/upgrades/upgrade_svn15885.sql24
-rw-r--r--sql-files/upgrades/upgrade_svn15926_log.sql3
-rw-r--r--sql-files/upgrades/upgrade_svn16490.sql1
-rw-r--r--sql-files/upgrades/upgrade_svn16518.sql1
-rw-r--r--sql-files/upgrades/upgrade_svn16639.sql1
-rw-r--r--sql-files/upgrades/upgrade_svn16645.sql2
-rw-r--r--sql-files/upgrades/upgrade_svn16663.sql1
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`