summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn1125.sql
diff options
context:
space:
mode:
authoramber <amber@54d463be-8e91-2dee-dedb-b68131a5f0ec>2005-04-07 18:00:13 +0000
committeramber <amber@54d463be-8e91-2dee-dedb-b68131a5f0ec>2005-04-07 18:00:13 +0000
commit1a348ede4934a1ba78f337ee1dffe11a699f4bef (patch)
tree883d4c1ae282fb67e1720f81c20f564499298ff4 /sql-files/upgrade_svn1125.sql
parent7cb0d361f1b4260b47ab1da99224332947320553 (diff)
parenta6cd6538e4271ea08dc86803e8b7e8c8f235960b (diff)
downloadhercules-1a348ede4934a1ba78f337ee1dffe11a699f4bef.tar.gz
hercules-1a348ede4934a1ba78f337ee1dffe11a699f4bef.tar.bz2
hercules-1a348ede4934a1ba78f337ee1dffe11a699f4bef.tar.xz
hercules-1a348ede4934a1ba78f337ee1dffe11a699f4bef.zip
branch for major stability breakage
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@1440 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn1125.sql')
-rw-r--r--sql-files/upgrade_svn1125.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn1125.sql b/sql-files/upgrade_svn1125.sql
new file mode 100644
index 000000000..b2de93c23
--- /dev/null
+++ b/sql-files/upgrade_svn1125.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `mob_db2` Add column `Drop9id` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db2` Add column `Drop9per` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db2` Add column `DropCardid` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db2` Add column `DropCardper` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db2` Drop column `Item1`;
+ALTER TABLE `mob_db2` Drop column `Item2`;
+ALTER TABLE `mob_db2` Change column `Drop7d` `Drop7id` mediumint(9) NOT NULL default '0';
+
+ALTER TABLE `mob_db` Add column `Drop9id` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db` Add column `Drop9per` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db` Add column `DropCardid` mediumint(9) NOT NULL default '0';
+ALTER TABLE `mob_db` Add column `DropCardper` mediumint(9) NOT NULL default '0';