summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/tools/convert_engine_innodb.sql (renamed from sql-files/convert_engine_innodb.sql)0
-rw-r--r--sql-files/tools/convert_engine_myisam.sql (renamed from sql-files/convert_engine_myisam.sql)0
-rw-r--r--sql-files/tools/convert_passwords.sql (renamed from sql-files/convert_passwords.sql)0
-rw-r--r--sql-files/upgrade_svn10575_db.sql11
-rw-r--r--sql-files/upgrade_svn10575_log.sql11
-rw-r--r--sql-files/upgrade_svn10580.sql1
-rw-r--r--sql-files/upgrade_svn11018.sql10
-rw-r--r--sql-files/upgrade_svn11106.sql1
-rw-r--r--sql-files/upgrade_svn11388.sql4
-rw-r--r--sql-files/upgrade_svn11548.sql29
-rw-r--r--sql-files/upgrade_svn11582.sql1
-rw-r--r--sql-files/upgrade_svn11721_log.sql1
-rw-r--r--sql-files/upgrade_svn11895.sql12
-rw-r--r--sql-files/upgrade_svn11915.sql9
-rw-r--r--sql-files/upgrade_svn12043.sql5
-rw-r--r--sql-files/upgrade_svn12278.sql1
-rw-r--r--sql-files/upgrade_svn12294.sql26
-rw-r--r--sql-files/upgrade_svn12368.sql1
-rw-r--r--sql-files/upgrade_svn12464.sql2
-rw-r--r--sql-files/upgrade_svn12559.sql24
-rw-r--r--sql-files/upgrade_svn12561.sql2
-rw-r--r--sql-files/upgrade_svn12581.sql3
-rw-r--r--sql-files/upgrade_svn12725.sql1
-rw-r--r--sql-files/upgrade_svn12975.sql24
-rw-r--r--sql-files/upgrade_svn12975_log.sql20
-rw-r--r--sql-files/upgrade_svn12975_view.sql17
-rw-r--r--sql-files/upgrade_svn13025_log.sql5
-rw-r--r--sql-files/upgrade_svn13115_mercenary.sql14
-rw-r--r--sql-files/upgrade_svn13117_char.sql1
-rw-r--r--sql-files/upgrade_svn13166_mercenary_owner.sql21
-rw-r--r--sql-files/upgrade_svn13370_inventory.sql6
-rw-r--r--sql-files/upgrade_svn13390.sql1
-rw-r--r--sql-files/upgrade_svn13541.sql2
-rw-r--r--sql-files/upgrade_svn13583.sql1
-rw-r--r--sql-files/upgrade_svn13719.sql1
-rw-r--r--sql-files/upgrade_svn13881.sql1
-rw-r--r--sql-files/upgrade_svn13890.sql1
-rw-r--r--sql-files/upgrade_svn13960_questlog.sql20
-rw-r--r--sql-files/upgrade_svn13963.sql1
-rw-r--r--sql-files/upgrade_svn14036.sql3
-rw-r--r--sql-files/upgrade_svn14085.sql1
-rw-r--r--sql-files/upgrade_svn14242.sql1
-rw-r--r--sql-files/upgrade_svn14507.sql1
-rw-r--r--sql-files/upgrade_svn14579.sql1
-rw-r--r--sql-files/upgrade_svn14672.sql1
-rw-r--r--sql-files/upgrade_svn14700.sql1
-rw-r--r--sql-files/upgrade_svn14713_log.sql4
-rw-r--r--sql-files/upgrade_svn14759.sql4
-rw-r--r--sql-files/upgrade_svn14796.sql1
-rw-r--r--sql-files/upgrade_svn14797.sql1
-rw-r--r--sql-files/upgrades/upgrade_svn15003.sql (renamed from sql-files/upgrade_svn15003.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15420_log.sql (renamed from sql-files/upgrade_svn15420_log.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15519_log.sql (renamed from sql-files/upgrade_svn15519_log.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15531_db.sql (renamed from sql-files/upgrade_svn15531_db.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15572.sql (renamed from sql-files/upgrade_svn15572.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15818_log.sql (renamed from sql-files/upgrade_svn15818_log.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15885.sql (renamed from sql-files/upgrade_svn15885.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn15926_log.sql (renamed from sql-files/upgrade_svn15926_log.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn16490.sql (renamed from sql-files/upgrade_svn16490.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn16518.sql (renamed from sql-files/upgrade_svn16518.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn16639.sql (renamed from sql-files/upgrade_svn16639.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn16645.sql (renamed from sql-files/upgrade_svn16645.sql)0
-rw-r--r--sql-files/upgrades/upgrade_svn16663.sql (renamed from sql-files/upgrade_svn16663.sql)0
63 files changed, 0 insertions, 310 deletions
diff --git a/sql-files/convert_engine_innodb.sql b/sql-files/tools/convert_engine_innodb.sql
index fcb240bb1..fcb240bb1 100644
--- a/sql-files/convert_engine_innodb.sql
+++ b/sql-files/tools/convert_engine_innodb.sql
diff --git a/sql-files/convert_engine_myisam.sql b/sql-files/tools/convert_engine_myisam.sql
index 5af878f65..5af878f65 100644
--- a/sql-files/convert_engine_myisam.sql
+++ b/sql-files/tools/convert_engine_myisam.sql
diff --git a/sql-files/convert_passwords.sql b/sql-files/tools/convert_passwords.sql
index 86e4c5b08..86e4c5b08 100644
--- a/sql-files/convert_passwords.sql
+++ b/sql-files/tools/convert_passwords.sql
diff --git a/sql-files/upgrade_svn10575_db.sql b/sql-files/upgrade_svn10575_db.sql
deleted file mode 100644
index 90d8fb27a..000000000
--- a/sql-files/upgrade_svn10575_db.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-ALTER TABLE `login` CHANGE `email` `email` VARCHAR( 39 ) NOT NULL;
-ALTER TABLE `login` CHANGE `sex` `sex` ENUM( 'M', 'F', 'S' ) NOT NULL DEFAULT 'M';
-
-ALTER TABLE `char` CHANGE `last_map` `last_map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `char` CHANGE `save_map` `save_map` VARCHAR( 11 ) NOT NULL;
-
-ALTER TABLE `memo` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `memo` CHANGE `x` `x` SMALLINT( 4 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `memo` CHANGE `y` `y` SMALLINT( 4 ) UNSIGNED NOT NULL DEFAULT '0';
-
-ALTER TABLE `party` CHANGE `name` `name` VARCHAR( 24 ) NOT NULL;
diff --git a/sql-files/upgrade_svn10575_log.sql b/sql-files/upgrade_svn10575_log.sql
deleted file mode 100644
index d6b4dd680..000000000
--- a/sql-files/upgrade_svn10575_log.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-ALTER TABLE `picklog` CHANGE `type` `type` ENUM( 'M', 'P', 'L', 'T', 'V', 'S', 'N', 'C', 'A', 'R', 'G' ) NOT NULL DEFAULT 'P';
-ALTER TABLE `zenylog` CHANGE `type` `type` ENUM( 'M', 'T', 'V', 'S', 'N', 'A' ) NOT NULL DEFAULT 'S';
-ALTER TABLE `chatlog` CHANGE `type` `type` ENUM( 'W', 'P', 'G' ) NOT NULL DEFAULT 'W';
-
-ALTER TABLE `picklog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `zenylog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `branchlog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `mvplog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `atcommandlog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `npclog` CHANGE `map` `map` VARCHAR( 11 ) NOT NULL;
-ALTER TABLE `chatlog` CHANGE `src_map` `src_map` VARCHAR( 11 ) NOT NULL;
diff --git a/sql-files/upgrade_svn10580.sql b/sql-files/upgrade_svn10580.sql
deleted file mode 100644
index 65ba0709f..000000000
--- a/sql-files/upgrade_svn10580.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `chatlog` CHANGE `type` `type` ENUM( 'O', 'W', 'P', 'G', 'M' ) NOT NULL DEFAULT 'O';
diff --git a/sql-files/upgrade_svn11018.sql b/sql-files/upgrade_svn11018.sql
deleted file mode 100644
index 8c2a4c2d9..000000000
--- a/sql-files/upgrade_svn11018.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-DROP TABLE IF EXISTS `hotkey`;
-CREATE TABLE `hotkey` (
- `char_id` INT(11) NOT NULL,
- `hotkey` TINYINT(2) unsigned NOT NULL,
- `type` TINYINT(1) unsigned NOT NULL default '0',
- `itemskill_id` INT(11) unsigned NOT NULL default '0',
- `skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
- PRIMARY KEY (`char_id`,`hotkey`),
- INDEX (`char_id`)
-) ENGINE=MYISAM;
diff --git a/sql-files/upgrade_svn11106.sql b/sql-files/upgrade_svn11106.sql
deleted file mode 100644
index 52ed0c95e..000000000
--- a/sql-files/upgrade_svn11106.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `item_db` SET `script` = 'getitem 5267,1; ' WHERE `item_db`.`id` =12949 LIMIT 1 ;
diff --git a/sql-files/upgrade_svn11388.sql b/sql-files/upgrade_svn11388.sql
deleted file mode 100644
index d15c01006..000000000
--- a/sql-files/upgrade_svn11388.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `atcommandlog` CHANGE `command` `command` VARCHAR( 255 ) NOT NULL;
-ALTER TABLE `atcommandlog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
-ALTER TABLE `branchlog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
-ALTER TABLE `npclog` CHANGE `char_name` `char_name` VARCHAR( 25 ) NOT NULL;
diff --git a/sql-files/upgrade_svn11548.sql b/sql-files/upgrade_svn11548.sql
deleted file mode 100644
index 722806f12..000000000
--- a/sql-files/upgrade_svn11548.sql
+++ /dev/null
@@ -1,29 +0,0 @@
--- this will covert the old `mail` table to new format, convert columns and fill in default values --
-
--- change structure --
-ALTER TABLE `mail` CHANGE `message_id` `id` bigint(20) unsigned NOT NULL auto_increment;
-ALTER TABLE `mail` CHANGE `from_char_name` `send_name` varchar(30) NOT NULL default '' AFTER `id`;
-ALTER TABLE `mail` CHANGE `from_account_id` `send_id` int(11) unsigned NOT NULL default 0 AFTER `send_name`;
-ALTER TABLE `mail` CHANGE `to_char_name` `dest_name` varchar(30) NOT NULL default '' AFTER `send_id`;
-ALTER TABLE `mail` CHANGE `to_account_id` `dest_id` int(11) unsigned NOT NULL default 0 AFTER `dest_name`;
-ALTER TABLE `mail` ADD `title` varchar(45) NOT NULL default '' AFTER `dest_id`;
-ALTER TABLE `mail` CHANGE `message` `message` varchar(255) NOT NULL default '' AFTER `title`;
-ALTER TABLE `mail` ADD `time` int(11) unsigned NOT NULL default 0 AFTER `message`;
-ALTER TABLE `mail` CHANGE `read_flag` `read_flag` tinyint(1) NOT NULL default 0 AFTER `time`;
-ALTER TABLE `mail` ADD `zeny` int(11) unsigned NOT NULL default 0 AFTER `read_flag`;
-ALTER TABLE `mail` ADD `nameid` int(11) unsigned NOT NULL default 0 AFTER `zeny`;
-ALTER TABLE `mail` ADD `amount` int(11) unsigned NOT NULL default 0 AFTER `nameid`;
-ALTER TABLE `mail` ADD `refine` tinyint(3) unsigned NOT NULL default 0 AFTER `amount`;
-ALTER TABLE `mail` ADD `attribute` tinyint(4) unsigned NOT NULL default 0 AFTER `refine`;
-ALTER TABLE `mail` ADD `identify` smallint(6) NOT NULL default 0 AFTER `attribute`;
-ALTER TABLE `mail` ADD `card0` smallint(11) NOT NULL default 0 AFTER `identify`;
-ALTER TABLE `mail` ADD `card1` smallint(11) NOT NULL default 0 AFTER `card0`;
-ALTER TABLE `mail` ADD `card2` smallint(11) NOT NULL default 0 AFTER `card1`;
-ALTER TABLE `mail` ADD `card3` smallint(11) NOT NULL default 0 AFTER `card2`;
-ALTER TABLE `mail` DROP `priority`;
-ALTER TABLE `mail` DROP `check_flag`;
-
--- correct values in some columns --
-UPDATE `mail` SET `time` = UNIX_TIMESTAMP(NOW());
-UPDATE `mail` SET `send_id` = (SELECT `char_id` FROM `char` WHERE `name` = `send_name`);
-UPDATE `mail` SET `dest_id` = (SELECT `char_id` FROM `char` WHERE `name` = `dest_name`);
diff --git a/sql-files/upgrade_svn11582.sql b/sql-files/upgrade_svn11582.sql
deleted file mode 100644
index 484a993db..000000000
--- a/sql-files/upgrade_svn11582.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `mail` CHANGE `read_flag` `status` TINYINT(2) NOT NULL default 0;
diff --git a/sql-files/upgrade_svn11721_log.sql b/sql-files/upgrade_svn11721_log.sql
deleted file mode 100644
index ab2c312a8..000000000
--- a/sql-files/upgrade_svn11721_log.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `picklog` CHANGE `type` `type` ENUM( 'M', 'P', 'L', 'T', 'V', 'S', 'N', 'C', 'A', 'R', 'G', 'E' ) NOT NULL DEFAULT 'P';
diff --git a/sql-files/upgrade_svn11895.sql b/sql-files/upgrade_svn11895.sql
deleted file mode 100644
index e34af527f..000000000
--- a/sql-files/upgrade_svn11895.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-ALTER TABLE `guild_expulsion`
- DROP `acc`,
- DROP `rsv1`,
- DROP `rsv2`,
- DROP `rsv3`;
-
-ALTER TABLE `guild_expulsion`
- MODIFY `account_id` int(11) unsigned NOT NULL default '0' AFTER `guild_id`;
-
-ALTER TABLE `guild_member`
- DROP `rsv1`,
- DROP `rsv2`;
diff --git a/sql-files/upgrade_svn11915.sql b/sql-files/upgrade_svn11915.sql
deleted file mode 100644
index ddf06957d..000000000
--- a/sql-files/upgrade_svn11915.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-ALTER TABLE `guild_castle`
- DROP `gHP0`,
- DROP `gHP1`,
- DROP `gHP2`,
- DROP `gHP3`,
- DROP `gHP4`,
- DROP `gHP5`,
- DROP `gHP6`,
- DROP `gHP7`;
diff --git a/sql-files/upgrade_svn12043.sql b/sql-files/upgrade_svn12043.sql
deleted file mode 100644
index 7c3f0980b..000000000
--- a/sql-files/upgrade_svn12043.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE `login` MODIFY COLUMN `userid` VARCHAR(23) NOT NULL default '';
-ALTER TABLE `login` MODIFY COLUMN `user_pass` VARCHAR(32) NOT NULL default '';
-
-ALTER TABLE `loginlog` MODIFY COLUMN `user` VARCHAR(23) NOT NULL default '';
-ALTER TABLE `charlog` MODIFY COLUMN `name` VARCHAR(23) NOT NULL default '';
diff --git a/sql-files/upgrade_svn12278.sql b/sql-files/upgrade_svn12278.sql
deleted file mode 100644
index a54353a7b..000000000
--- a/sql-files/upgrade_svn12278.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `mail` WHERE `status` > 2;
diff --git a/sql-files/upgrade_svn12294.sql b/sql-files/upgrade_svn12294.sql
deleted file mode 100644
index 707d49cfe..000000000
--- a/sql-files/upgrade_svn12294.sql
+++ /dev/null
@@ -1,26 +0,0 @@
---
--- Table structure for table `auction`
---
-
-DROP TABLE IF EXISTS `auction`;
-CREATE TABLE `auction` (
- `auction_id` bigint(20) unsigned NOT NULL auto_increment,
- `seller_id` int(11) unsigned NOT NULL default '0',
- `seller_name` varchar(30) NOT NULL default '',
- `buyer_id` int(11) unsigned NOT NULL default '0',
- `buyer_name` varchar(30) NOT NULL default '',
- `price` int(11) unsigned NOT NULL default '0',
- `buynow` int(11) unsigned NOT NULL default '0',
- `hours` smallint(6) NOT NULL default '0',
- `timestamp` int(11) unsigned NOT NULL default '0',
- `nameid` int(11) unsigned NOT NULL default '0',
- `item_name` varchar(50) NOT NULL default '',
- `type` smallint(6) NOT NULL default '0',
- `refine` tinyint(3) unsigned NOT NULL default '0',
- `attribute` tinyint(4) unsigned NOT NULL default '0',
- `card0` smallint(11) NOT NULL default '0',
- `card1` smallint(11) NOT NULL default '0',
- `card2` smallint(11) NOT NULL default '0',
- `card3` smallint(11) NOT NULL default '0',
- PRIMARY KEY (`auction_id`)
-) ENGINE=MyISAM;
diff --git a/sql-files/upgrade_svn12368.sql b/sql-files/upgrade_svn12368.sql
deleted file mode 100644
index bc717edaf..000000000
--- a/sql-files/upgrade_svn12368.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `item_db` SET `refineable` = '0' WHERE `item_db`.`id` = '5255';
diff --git a/sql-files/upgrade_svn12464.sql b/sql-files/upgrade_svn12464.sql
deleted file mode 100644
index f50749092..000000000
--- a/sql-files/upgrade_svn12464.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `login` CHANGE `connect_until` `expiration_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` CHANGE `ban_until` `unban_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn12559.sql b/sql-files/upgrade_svn12559.sql
deleted file mode 100644
index 302493e1b..000000000
--- a/sql-files/upgrade_svn12559.sql
+++ /dev/null
@@ -1,24 +0,0 @@
---
--- Table structure for table `quest`
---
-
-DROP TABLE IF EXISTS `quest`;
-CREATE TABLE `quest` (
- `char_id` int(11) unsigned NOT NULL default '0',
- `quest_id` int(10) unsigned NOT NULL,
- `state` enum('1','0') NOT NULL default '0',
- PRIMARY KEY USING BTREE (`char_id`,`quest_id`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `quest_mob`
---
-
-DROP TABLE IF EXISTS `quest_objective`;
-CREATE TABLE `quest_objective` (
- `quest_id` int(11) unsigned NOT NULL,
- `count` mediumint(8) unsigned NOT NULL default '0',
- `name` varchar(255) NOT NULL default '',
- `num` tinyint(3) unsigned NOT NULL,
- PRIMARY KEY USING BTREE (`quest_id`,`num`)
-) ENGINE=MyISAM;
diff --git a/sql-files/upgrade_svn12561.sql b/sql-files/upgrade_svn12561.sql
deleted file mode 100644
index 7d9b0f592..000000000
--- a/sql-files/upgrade_svn12561.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `login` CHANGE `expiration_time` `connect_until` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` CHANGE `unban_time` `ban_until` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn12581.sql b/sql-files/upgrade_svn12581.sql
deleted file mode 100644
index 8953b02a2..000000000
--- a/sql-files/upgrade_svn12581.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `quest_objective` ADD COLUMN `char_id` INTEGER UNSIGNED NOT NULL AFTER `num`,
- DROP PRIMARY KEY,
- ADD PRIMARY KEY USING BTREE(`quest_id`, `num`, `char_id`);
diff --git a/sql-files/upgrade_svn12725.sql b/sql-files/upgrade_svn12725.sql
deleted file mode 100644
index bccdca61b..000000000
--- a/sql-files/upgrade_svn12725.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `chatlog` CHANGE `message` `message` VARCHAR( 255 ) NOT NULL
diff --git a/sql-files/upgrade_svn12975.sql b/sql-files/upgrade_svn12975.sql
deleted file mode 100644
index 26d78178e..000000000
--- a/sql-files/upgrade_svn12975.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-START TRANSACTION;
-
--- delete columns
-ALTER TABLE `login` DROP `error_message`;
-ALTER TABLE `login` DROP `memo`;
-
--- rename columns
-ALTER TABLE `login` CHANGE `connect_until` `expiration_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` CHANGE `ban_until` `unban_time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-
--- reorder columns
-ALTER TABLE `login` MODIFY `sex` enum('M','F','S') NOT NULL default 'M' AFTER `user_pass`;
-ALTER TABLE `login` MODIFY `email` varchar(39) NOT NULL default '' AFTER `sex`;
-ALTER TABLE `login` MODIFY `level` tinyint(3) NOT NULL default '0' AFTER `email`;
-ALTER TABLE `login` MODIFY `state` int(11) unsigned NOT NULL default '0' AFTER `level`;
-ALTER TABLE `login` MODIFY `unban_time` int(11) unsigned NOT NULL default '0' AFTER `state`;
-ALTER TABLE `login` MODIFY `expiration_time` int(11) unsigned NOT NULL default '0' AFTER `unban_time`;
-ALTER TABLE `login` MODIFY `logincount` mediumint(9) unsigned NOT NULL default '0' AFTER `expiration_time`;
-
--- change ip format
-ALTER TABLE `loginlog` CHANGE `ip` `ip` VARCHAR( 15 ) NOT NULL default '';
-UPDATE `loginlog` SET `ip` = inet_ntoa(`ip`);
-
-COMMIT;
diff --git a/sql-files/upgrade_svn12975_log.sql b/sql-files/upgrade_svn12975_log.sql
deleted file mode 100644
index 3c9aa5cff..000000000
--- a/sql-files/upgrade_svn12975_log.sql
+++ /dev/null
@@ -1,20 +0,0 @@
--- NOTE: change `ragnarok` and `log` to whatever your database names are.
-
-START TRANSACTION;
-
-CREATE TABLE `log`.`loginlog` (
- `time` datetime NOT NULL default '0000-00-00 00:00:00',
- `ip` varchar( 15 ) NOT NULL ,
- `user` varchar( 23 ) NOT NULL default '',
- `rcode` tinyint( 4 ) NOT NULL default '0',
- `log` varchar( 255 ) NOT NULL default '',
- KEY `ip` ( `ip` )
-) ENGINE = MYISAM;
-
-INSERT INTO `log`.`loginlog`
- SELECT *
- FROM `ragnarok`.`loginlog` ;
-
-DROP TABLE `ragnarok`.`loginlog` ;
-
-COMMIT;
diff --git a/sql-files/upgrade_svn12975_view.sql b/sql-files/upgrade_svn12975_view.sql
deleted file mode 100644
index 7f0cce743..000000000
--- a/sql-files/upgrade_svn12975_view.sql
+++ /dev/null
@@ -1,17 +0,0 @@
--- The statements below will create a 'view' (virtual table) that mimics
--- the previous `login` table layout. You can use this hack to make your db
--- compatible with older *Athena servers or control panels.
--- Note: also adjust the account.sql.account_db setting in login_athena.conf.
--- Note: if your CP does not have a config setting for the `login` table name
--- you'll have to either modify its code or do some table renaming.
-
-START TRANSACTION;
-
--- create dummy columns, needed to make the view insertable
-ALTER TABLE `login` ADD `error_message` SMALLINT UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `login` ADD `memo` SMALLINT UNSIGNED NOT NULL DEFAULT '0';
-
--- create the view
-CREATE VIEW `login_view` ( `account_id`, `userid`, `user_pass`, `lastlogin`, `sex`, `logincount`, `email`, `level`, `error_message`, `connect_until`, `last_ip`, `memo`, `ban_until`, `state` ) AS SELECT `account_id`, `userid`, `user_pass`, `lastlogin`, `sex`, `logincount`, `email`, `level`, `error_message`, `expiration_time`, `last_ip`, `memo`, `unban_time`, `state` FROM `login`;
-
-COMMIT;
diff --git a/sql-files/upgrade_svn13025_log.sql b/sql-files/upgrade_svn13025_log.sql
deleted file mode 100644
index 7d3084dd9..000000000
--- a/sql-files/upgrade_svn13025_log.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-START TRANSACTION;
-
-ALTER TABLE `zenylog` MODIFY COLUMN `type` enum('M','T','V','S','N','A','E') NOT NULL default 'S';
-
-COMMIT;
diff --git a/sql-files/upgrade_svn13115_mercenary.sql b/sql-files/upgrade_svn13115_mercenary.sql
deleted file mode 100644
index 70356b361..000000000
--- a/sql-files/upgrade_svn13115_mercenary.sql
+++ /dev/null
@@ -1,14 +0,0 @@
---
--- Table structure for table `mercenary`
---
-
-CREATE TABLE IF NOT EXISTS `mercenary` (
- `mer_id` int(11) unsigned NOT NULL auto_increment,
- `char_id` int(11) NOT NULL,
- `class` mediumint(9) unsigned NOT NULL default '0',
- `hp` int(12) NOT NULL default '1',
- `sp` int(12) NOT NULL default '1',
- `kill_counter` int(11) NOT NULL,
- `life_time` int(11) NOT NULL default '0',
- PRIMARY KEY (`mer_id`)
-) ENGINE=MyISAM;
diff --git a/sql-files/upgrade_svn13117_char.sql b/sql-files/upgrade_svn13117_char.sql
deleted file mode 100644
index c3f2da56d..000000000
--- a/sql-files/upgrade_svn13117_char.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` ADD COLUMN `mer_id` INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER `homun_id`;
diff --git a/sql-files/upgrade_svn13166_mercenary_owner.sql b/sql-files/upgrade_svn13166_mercenary_owner.sql
deleted file mode 100644
index 29ecf8bf2..000000000
--- a/sql-files/upgrade_svn13166_mercenary_owner.sql
+++ /dev/null
@@ -1,21 +0,0 @@
--- Removes mer_id from Char DB
-
-ALTER TABLE `char` DROP COLUMN `mer_id`;
-
--- Clean mercenary DB
-
-TRUNCATE TABLE `mercenary`;
-
--- Table structure for table `mercenary_owner`
-
-CREATE TABLE IF NOT EXISTS `mercenary_owner` (
- `char_id` int(11) NOT NULL,
- `merc_id` int(11) NOT NULL default '0',
- `arch_calls` int(11) NOT NULL default '0',
- `arch_faith` int(11) NOT NULL default '0',
- `spear_calls` int(11) NOT NULL default '0',
- `spear_faith` int(11) NOT NULL default '0',
- `sword_calls` int(11) NOT NULL default '0',
- `sword_faith` int(11) NOT NULL default '0',
- PRIMARY KEY (`char_id`)
-) ENGINE=MyISAM;
diff --git a/sql-files/upgrade_svn13370_inventory.sql b/sql-files/upgrade_svn13370_inventory.sql
deleted file mode 100644
index 6a118ca4d..000000000
--- a/sql-files/upgrade_svn13370_inventory.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- Creates expire_time column on Inventory
-
-ALTER TABLE `inventory` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `cart_inventory` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `storage` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `guild_storage` ADD COLUMN `expire_time` INT(11) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn13390.sql b/sql-files/upgrade_svn13390.sql
deleted file mode 100644
index 7bbe4cf64..000000000
--- a/sql-files/upgrade_svn13390.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `item_db` SET `script` = 'getitem 12213,10; ' WHERE `item_db`.`id` =12911 OR `item_db`.`id` =14167 ;
diff --git a/sql-files/upgrade_svn13541.sql b/sql-files/upgrade_svn13541.sql
deleted file mode 100644
index 1c770d074..000000000
--- a/sql-files/upgrade_svn13541.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `char` CHANGE `status_point` `status_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
-ALTER TABLE `char` CHANGE `skill_point` `skill_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn13583.sql b/sql-files/upgrade_svn13583.sql
deleted file mode 100644
index 277979384..000000000
--- a/sql-files/upgrade_svn13583.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` CHANGE `manner` `manner` SMALLINT ( 6 ) NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn13719.sql b/sql-files/upgrade_svn13719.sql
deleted file mode 100644
index 478bca321..000000000
--- a/sql-files/upgrade_svn13719.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `global_reg_value` SET `value` = (`value` - `account_id` - 1337) WHERE `str` = '#kafra_code';
diff --git a/sql-files/upgrade_svn13881.sql b/sql-files/upgrade_svn13881.sql
deleted file mode 100644
index aae8962d2..000000000
--- a/sql-files/upgrade_svn13881.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `global_reg_value` WHERE `str`='COOKING_ATTEMPT';
diff --git a/sql-files/upgrade_svn13890.sql b/sql-files/upgrade_svn13890.sql
deleted file mode 100644
index a7ca31f1e..000000000
--- a/sql-files/upgrade_svn13890.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `global_reg_value` WHERE str='question$' OR str='question2$' OR str='question3$';
diff --git a/sql-files/upgrade_svn13960_questlog.sql b/sql-files/upgrade_svn13960_questlog.sql
deleted file mode 100644
index ec307682d..000000000
--- a/sql-files/upgrade_svn13960_questlog.sql
+++ /dev/null
@@ -1,20 +0,0 @@
---
--- Table structure for table `questlog`
---
-
-CREATE TABLE IF NOT EXISTS `questlog` (
- `char_id` int(11) unsigned NOT NULL default '0',
- `quest_id` int(10) unsigned NOT NULL,
- `state` enum('2','1','0') NOT NULL default '0',
- `time` int(11) unsigned NOT NULL default '0',
- `mob1` mediumint(9) unsigned NOT NULL default '0',
- `count1` mediumint(8) unsigned NOT NULL default '0',
- `mob2` mediumint(9) unsigned NOT NULL default '0',
- `count2` mediumint(8) unsigned NOT NULL default '0',
- `mob3` mediumint(9) unsigned NOT NULL default '0',
- `count3` mediumint(8) unsigned NOT NULL default '0',
- PRIMARY KEY USING BTREE (`char_id`,`quest_id`)
-) ENGINE=MyISAM;
-
-DROP TABLE `quest_objective`;
-DROP TABLE `quest`;
diff --git a/sql-files/upgrade_svn13963.sql b/sql-files/upgrade_svn13963.sql
deleted file mode 100644
index a9acd7118..000000000
--- a/sql-files/upgrade_svn13963.sql
+++ /dev/null
@@ -1 +0,0 @@
-RENAME TABLE `questlog` TO `quest`;
diff --git a/sql-files/upgrade_svn14036.sql b/sql-files/upgrade_svn14036.sql
deleted file mode 100644
index d2fa304e2..000000000
--- a/sql-files/upgrade_svn14036.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `quest` DROP `mob1`;
-ALTER TABLE `quest` DROP `mob2`;
-ALTER TABLE `quest` DROP `mob3`;
diff --git a/sql-files/upgrade_svn14085.sql b/sql-files/upgrade_svn14085.sql
deleted file mode 100644
index 5e988841e..000000000
--- a/sql-files/upgrade_svn14085.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` ADD `rename` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn14242.sql b/sql-files/upgrade_svn14242.sql
deleted file mode 100644
index 5f818a3d7..000000000
--- a/sql-files/upgrade_svn14242.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `guild` MODIFY COLUMN `exp` bigint(20) unsigned NOT NULL default '0';
diff --git a/sql-files/upgrade_svn14507.sql b/sql-files/upgrade_svn14507.sql
deleted file mode 100644
index 823dee9d8..000000000
--- a/sql-files/upgrade_svn14507.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `global_reg_value` WHERE `str` = 'killedrid' OR `str` = 'killerrid';
diff --git a/sql-files/upgrade_svn14579.sql b/sql-files/upgrade_svn14579.sql
deleted file mode 100644
index ad407aa90..000000000
--- a/sql-files/upgrade_svn14579.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `ragsrvinfo` DROP `motd`;
diff --git a/sql-files/upgrade_svn14672.sql b/sql-files/upgrade_svn14672.sql
deleted file mode 100644
index f0658f40c..000000000
--- a/sql-files/upgrade_svn14672.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `login` ADD `birthdate` DATE NOT NULL DEFAULT '0000-00-00';
diff --git a/sql-files/upgrade_svn14700.sql b/sql-files/upgrade_svn14700.sql
deleted file mode 100644
index a1e3d8ddb..000000000
--- a/sql-files/upgrade_svn14700.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` ADD `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn14713_log.sql b/sql-files/upgrade_svn14713_log.sql
deleted file mode 100644
index be4059ebe..000000000
--- a/sql-files/upgrade_svn14713_log.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- Adds 'B' to `type` in `picklog` and `zenylog`
-
-ALTER TABLE `picklog` MODIFY `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B') NOT NULL DEFAULT 'P';
-ALTER TABLE `zenylog` MODIFY `type` ENUM('M','T','V','S','N','A','E','B') NOT NULL DEFAULT 'S';
diff --git a/sql-files/upgrade_svn14759.sql b/sql-files/upgrade_svn14759.sql
deleted file mode 100644
index 58d4bea17..000000000
--- a/sql-files/upgrade_svn14759.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `cart_inventory` MODIFY COLUMN `card0` SMALLINT(11) NOT NULL DEFAULT '0';
-ALTER TABLE `cart_inventory` MODIFY COLUMN `card1` SMALLINT(11) NOT NULL DEFAULT '0';
-ALTER TABLE `cart_inventory` MODIFY COLUMN `card2` SMALLINT(11) NOT NULL DEFAULT '0';
-ALTER TABLE `cart_inventory` MODIFY COLUMN `card3` SMALLINT(11) NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn14796.sql b/sql-files/upgrade_svn14796.sql
deleted file mode 100644
index 21c1bcd55..000000000
--- a/sql-files/upgrade_svn14796.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` MODIFY `weapon` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql-files/upgrade_svn14797.sql b/sql-files/upgrade_svn14797.sql
deleted file mode 100644
index acf6fb33d..000000000
--- a/sql-files/upgrade_svn14797.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `char` ADD `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0' AFTER `head_bottom`;
diff --git a/sql-files/upgrade_svn15003.sql b/sql-files/upgrades/upgrade_svn15003.sql
index e30a3b0fd..e30a3b0fd 100644
--- a/sql-files/upgrade_svn15003.sql
+++ b/sql-files/upgrades/upgrade_svn15003.sql
diff --git a/sql-files/upgrade_svn15420_log.sql b/sql-files/upgrades/upgrade_svn15420_log.sql
index 580dce9a2..580dce9a2 100644
--- a/sql-files/upgrade_svn15420_log.sql
+++ b/sql-files/upgrades/upgrade_svn15420_log.sql
diff --git a/sql-files/upgrade_svn15519_log.sql b/sql-files/upgrades/upgrade_svn15519_log.sql
index 623b022b8..623b022b8 100644
--- a/sql-files/upgrade_svn15519_log.sql
+++ b/sql-files/upgrades/upgrade_svn15519_log.sql
diff --git a/sql-files/upgrade_svn15531_db.sql b/sql-files/upgrades/upgrade_svn15531_db.sql
index ce0e56302..ce0e56302 100644
--- a/sql-files/upgrade_svn15531_db.sql
+++ b/sql-files/upgrades/upgrade_svn15531_db.sql
diff --git a/sql-files/upgrade_svn15572.sql b/sql-files/upgrades/upgrade_svn15572.sql
index 821bb79d6..821bb79d6 100644
--- a/sql-files/upgrade_svn15572.sql
+++ b/sql-files/upgrades/upgrade_svn15572.sql
diff --git a/sql-files/upgrade_svn15818_log.sql b/sql-files/upgrades/upgrade_svn15818_log.sql
index b61f71f53..b61f71f53 100644
--- a/sql-files/upgrade_svn15818_log.sql
+++ b/sql-files/upgrades/upgrade_svn15818_log.sql
diff --git a/sql-files/upgrade_svn15885.sql b/sql-files/upgrades/upgrade_svn15885.sql
index 48b25b5a7..48b25b5a7 100644
--- a/sql-files/upgrade_svn15885.sql
+++ b/sql-files/upgrades/upgrade_svn15885.sql
diff --git a/sql-files/upgrade_svn15926_log.sql b/sql-files/upgrades/upgrade_svn15926_log.sql
index 099ee6faa..099ee6faa 100644
--- a/sql-files/upgrade_svn15926_log.sql
+++ b/sql-files/upgrades/upgrade_svn15926_log.sql
diff --git a/sql-files/upgrade_svn16490.sql b/sql-files/upgrades/upgrade_svn16490.sql
index b38445c46..b38445c46 100644
--- a/sql-files/upgrade_svn16490.sql
+++ b/sql-files/upgrades/upgrade_svn16490.sql
diff --git a/sql-files/upgrade_svn16518.sql b/sql-files/upgrades/upgrade_svn16518.sql
index 1c142c65f..1c142c65f 100644
--- a/sql-files/upgrade_svn16518.sql
+++ b/sql-files/upgrades/upgrade_svn16518.sql
diff --git a/sql-files/upgrade_svn16639.sql b/sql-files/upgrades/upgrade_svn16639.sql
index 0da4b91d1..0da4b91d1 100644
--- a/sql-files/upgrade_svn16639.sql
+++ b/sql-files/upgrades/upgrade_svn16639.sql
diff --git a/sql-files/upgrade_svn16645.sql b/sql-files/upgrades/upgrade_svn16645.sql
index 9a3237ad8..9a3237ad8 100644
--- a/sql-files/upgrade_svn16645.sql
+++ b/sql-files/upgrades/upgrade_svn16645.sql
diff --git a/sql-files/upgrade_svn16663.sql b/sql-files/upgrades/upgrade_svn16663.sql
index 8883a108b..8883a108b 100644
--- a/sql-files/upgrade_svn16663.sql
+++ b/sql-files/upgrades/upgrade_svn16663.sql