From e3014f7b20b5df2843e3448c5327dda2641ddbdc Mon Sep 17 00:00:00 2001 From: shennetsind Date: Thu, 6 Sep 2012 19:58:51 +0000 Subject: 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 --- sql-files/convert_engine_innodb.sql | 42 -------------------------- sql-files/convert_engine_myisam.sql | 42 -------------------------- sql-files/convert_passwords.sql | 3 -- sql-files/tools/convert_engine_innodb.sql | 42 ++++++++++++++++++++++++++ sql-files/tools/convert_engine_myisam.sql | 42 ++++++++++++++++++++++++++ sql-files/tools/convert_passwords.sql | 3 ++ sql-files/upgrade_svn10575_db.sql | 11 ------- sql-files/upgrade_svn10575_log.sql | 11 ------- sql-files/upgrade_svn10580.sql | 1 - sql-files/upgrade_svn11018.sql | 10 ------ sql-files/upgrade_svn11106.sql | 1 - sql-files/upgrade_svn11388.sql | 4 --- sql-files/upgrade_svn11548.sql | 29 ------------------ sql-files/upgrade_svn11582.sql | 1 - sql-files/upgrade_svn11721_log.sql | 1 - sql-files/upgrade_svn11895.sql | 12 -------- sql-files/upgrade_svn11915.sql | 9 ------ sql-files/upgrade_svn12043.sql | 5 --- sql-files/upgrade_svn12278.sql | 1 - sql-files/upgrade_svn12294.sql | 26 ---------------- sql-files/upgrade_svn12368.sql | 1 - sql-files/upgrade_svn12464.sql | 2 -- sql-files/upgrade_svn12559.sql | 24 --------------- sql-files/upgrade_svn12561.sql | 2 -- sql-files/upgrade_svn12581.sql | 3 -- sql-files/upgrade_svn12725.sql | 1 - sql-files/upgrade_svn12975.sql | 24 --------------- sql-files/upgrade_svn12975_log.sql | 20 ------------ sql-files/upgrade_svn12975_view.sql | 17 ----------- sql-files/upgrade_svn13025_log.sql | 5 --- sql-files/upgrade_svn13115_mercenary.sql | 14 --------- sql-files/upgrade_svn13117_char.sql | 1 - sql-files/upgrade_svn13166_mercenary_owner.sql | 21 ------------- sql-files/upgrade_svn13370_inventory.sql | 6 ---- sql-files/upgrade_svn13390.sql | 1 - sql-files/upgrade_svn13541.sql | 2 -- sql-files/upgrade_svn13583.sql | 1 - sql-files/upgrade_svn13719.sql | 1 - sql-files/upgrade_svn13881.sql | 1 - sql-files/upgrade_svn13890.sql | 1 - sql-files/upgrade_svn13960_questlog.sql | 20 ------------ sql-files/upgrade_svn13963.sql | 1 - sql-files/upgrade_svn14036.sql | 3 -- sql-files/upgrade_svn14085.sql | 1 - sql-files/upgrade_svn14242.sql | 1 - sql-files/upgrade_svn14507.sql | 1 - sql-files/upgrade_svn14579.sql | 1 - sql-files/upgrade_svn14672.sql | 1 - sql-files/upgrade_svn14700.sql | 1 - sql-files/upgrade_svn14713_log.sql | 4 --- sql-files/upgrade_svn14759.sql | 4 --- sql-files/upgrade_svn14796.sql | 1 - sql-files/upgrade_svn14797.sql | 1 - sql-files/upgrade_svn15003.sql | 1 - sql-files/upgrade_svn15420_log.sql | 3 -- sql-files/upgrade_svn15519_log.sql | 3 -- sql-files/upgrade_svn15531_db.sql | 4 --- sql-files/upgrade_svn15572.sql | 3 -- sql-files/upgrade_svn15818_log.sql | 3 -- sql-files/upgrade_svn15885.sql | 24 --------------- sql-files/upgrade_svn15926_log.sql | 3 -- sql-files/upgrade_svn16490.sql | 1 - sql-files/upgrade_svn16518.sql | 1 - sql-files/upgrade_svn16639.sql | 1 - sql-files/upgrade_svn16645.sql | 2 -- sql-files/upgrade_svn16663.sql | 1 - sql-files/upgrades/upgrade_svn15003.sql | 1 + sql-files/upgrades/upgrade_svn15420_log.sql | 3 ++ sql-files/upgrades/upgrade_svn15519_log.sql | 3 ++ sql-files/upgrades/upgrade_svn15531_db.sql | 4 +++ sql-files/upgrades/upgrade_svn15572.sql | 3 ++ sql-files/upgrades/upgrade_svn15818_log.sql | 3 ++ sql-files/upgrades/upgrade_svn15885.sql | 24 +++++++++++++++ sql-files/upgrades/upgrade_svn15926_log.sql | 3 ++ sql-files/upgrades/upgrade_svn16490.sql | 1 + sql-files/upgrades/upgrade_svn16518.sql | 1 + sql-files/upgrades/upgrade_svn16639.sql | 1 + sql-files/upgrades/upgrade_svn16645.sql | 2 ++ sql-files/upgrades/upgrade_svn16663.sql | 1 + 79 files changed, 137 insertions(+), 447 deletions(-) delete mode 100644 sql-files/convert_engine_innodb.sql delete mode 100644 sql-files/convert_engine_myisam.sql delete mode 100644 sql-files/convert_passwords.sql create mode 100644 sql-files/tools/convert_engine_innodb.sql create mode 100644 sql-files/tools/convert_engine_myisam.sql create mode 100644 sql-files/tools/convert_passwords.sql delete mode 100644 sql-files/upgrade_svn10575_db.sql delete mode 100644 sql-files/upgrade_svn10575_log.sql delete mode 100644 sql-files/upgrade_svn10580.sql delete mode 100644 sql-files/upgrade_svn11018.sql delete mode 100644 sql-files/upgrade_svn11106.sql delete mode 100644 sql-files/upgrade_svn11388.sql delete mode 100644 sql-files/upgrade_svn11548.sql delete mode 100644 sql-files/upgrade_svn11582.sql delete mode 100644 sql-files/upgrade_svn11721_log.sql delete mode 100644 sql-files/upgrade_svn11895.sql delete mode 100644 sql-files/upgrade_svn11915.sql delete mode 100644 sql-files/upgrade_svn12043.sql delete mode 100644 sql-files/upgrade_svn12278.sql delete mode 100644 sql-files/upgrade_svn12294.sql delete mode 100644 sql-files/upgrade_svn12368.sql delete mode 100644 sql-files/upgrade_svn12464.sql delete mode 100644 sql-files/upgrade_svn12559.sql delete mode 100644 sql-files/upgrade_svn12561.sql delete mode 100644 sql-files/upgrade_svn12581.sql delete mode 100644 sql-files/upgrade_svn12725.sql delete mode 100644 sql-files/upgrade_svn12975.sql delete mode 100644 sql-files/upgrade_svn12975_log.sql delete mode 100644 sql-files/upgrade_svn12975_view.sql delete mode 100644 sql-files/upgrade_svn13025_log.sql delete mode 100644 sql-files/upgrade_svn13115_mercenary.sql delete mode 100644 sql-files/upgrade_svn13117_char.sql delete mode 100644 sql-files/upgrade_svn13166_mercenary_owner.sql delete mode 100644 sql-files/upgrade_svn13370_inventory.sql delete mode 100644 sql-files/upgrade_svn13390.sql delete mode 100644 sql-files/upgrade_svn13541.sql delete mode 100644 sql-files/upgrade_svn13583.sql delete mode 100644 sql-files/upgrade_svn13719.sql delete mode 100644 sql-files/upgrade_svn13881.sql delete mode 100644 sql-files/upgrade_svn13890.sql delete mode 100644 sql-files/upgrade_svn13960_questlog.sql delete mode 100644 sql-files/upgrade_svn13963.sql delete mode 100644 sql-files/upgrade_svn14036.sql delete mode 100644 sql-files/upgrade_svn14085.sql delete mode 100644 sql-files/upgrade_svn14242.sql delete mode 100644 sql-files/upgrade_svn14507.sql delete mode 100644 sql-files/upgrade_svn14579.sql delete mode 100644 sql-files/upgrade_svn14672.sql delete mode 100644 sql-files/upgrade_svn14700.sql delete mode 100644 sql-files/upgrade_svn14713_log.sql delete mode 100644 sql-files/upgrade_svn14759.sql delete mode 100644 sql-files/upgrade_svn14796.sql delete mode 100644 sql-files/upgrade_svn14797.sql delete mode 100644 sql-files/upgrade_svn15003.sql delete mode 100644 sql-files/upgrade_svn15420_log.sql delete mode 100644 sql-files/upgrade_svn15519_log.sql delete mode 100644 sql-files/upgrade_svn15531_db.sql delete mode 100644 sql-files/upgrade_svn15572.sql delete mode 100644 sql-files/upgrade_svn15818_log.sql delete mode 100644 sql-files/upgrade_svn15885.sql delete mode 100644 sql-files/upgrade_svn15926_log.sql delete mode 100644 sql-files/upgrade_svn16490.sql delete mode 100644 sql-files/upgrade_svn16518.sql delete mode 100644 sql-files/upgrade_svn16639.sql delete mode 100644 sql-files/upgrade_svn16645.sql delete mode 100644 sql-files/upgrade_svn16663.sql create mode 100644 sql-files/upgrades/upgrade_svn15003.sql create mode 100644 sql-files/upgrades/upgrade_svn15420_log.sql create mode 100644 sql-files/upgrades/upgrade_svn15519_log.sql create mode 100644 sql-files/upgrades/upgrade_svn15531_db.sql create mode 100644 sql-files/upgrades/upgrade_svn15572.sql create mode 100644 sql-files/upgrades/upgrade_svn15818_log.sql create mode 100644 sql-files/upgrades/upgrade_svn15885.sql create mode 100644 sql-files/upgrades/upgrade_svn15926_log.sql create mode 100644 sql-files/upgrades/upgrade_svn16490.sql create mode 100644 sql-files/upgrades/upgrade_svn16518.sql create mode 100644 sql-files/upgrades/upgrade_svn16639.sql create mode 100644 sql-files/upgrades/upgrade_svn16645.sql create mode 100644 sql-files/upgrades/upgrade_svn16663.sql (limited to 'sql-files') diff --git a/sql-files/convert_engine_innodb.sql b/sql-files/convert_engine_innodb.sql deleted file mode 100644 index fcb240bb1..000000000 --- a/sql-files/convert_engine_innodb.sql +++ /dev/null @@ -1,42 +0,0 @@ --- --- rAthena Database Converter ( MyISAM -> InnoDB ) --- - -ALTER TABLE `auction` ENGINE = InnoDB; -ALTER TABLE `cart_inventory` ENGINE = InnoDB; -ALTER TABLE `char` ENGINE = InnoDB; -ALTER TABLE `charlog` ENGINE = InnoDB; -ALTER TABLE `friends` ENGINE = InnoDB; -ALTER TABLE `global_reg_value` ENGINE = InnoDB; -ALTER TABLE `guild` ENGINE = InnoDB; -ALTER TABLE `guild_alliance` ENGINE = InnoDB; -ALTER TABLE `guild_castle` ENGINE = InnoDB; -ALTER TABLE `guild_expulsion` ENGINE = InnoDB; -ALTER TABLE `guild_member` ENGINE = InnoDB; -ALTER TABLE `guild_position` ENGINE = InnoDB; -ALTER TABLE `guild_skill` ENGINE = InnoDB; -ALTER TABLE `guild_storage` ENGINE = InnoDB; -ALTER TABLE `homunculus` ENGINE = InnoDB; -ALTER TABLE `hotkey` ENGINE = InnoDB; -ALTER TABLE `interlog` ENGINE = InnoDB; -ALTER TABLE `inventory` ENGINE = InnoDB; -ALTER TABLE `ipbanlist` ENGINE = InnoDB; -#ALTER TABLE `item_db` ENGINE = InnoDB; -#ALTER TABLE `item_db2` ENGINE = InnoDB; -ALTER TABLE `login` ENGINE = InnoDB; -ALTER TABLE `mail` ENGINE = InnoDB; -ALTER TABLE `mapreg` ENGINE = InnoDB; -ALTER TABLE `memo` ENGINE = InnoDB; -ALTER TABLE `mercenary` ENGINE = InnoDB; -ALTER TABLE `mercenary_owner` ENGINE = InnoDB; -#ALTER TABLE `mob_db` ENGINE = InnoDB; -#ALTER TABLE `mob_db2` ENGINE = InnoDB; -ALTER TABLE `party` ENGINE = InnoDB; -ALTER TABLE `pet` ENGINE = InnoDB; -ALTER TABLE `quest` ENGINE = InnoDB; -ALTER TABLE `ragsrvinfo` ENGINE = InnoDB; -ALTER TABLE `sc_data` ENGINE = InnoDB; -ALTER TABLE `skill` ENGINE = InnoDB; -ALTER TABLE `skill_homunculus` ENGINE = InnoDB; -ALTER TABLE `sstatus` ENGINE = InnoDB; -ALTER TABLE `storage` ENGINE = InnoDB; diff --git a/sql-files/convert_engine_myisam.sql b/sql-files/convert_engine_myisam.sql deleted file mode 100644 index 5af878f65..000000000 --- a/sql-files/convert_engine_myisam.sql +++ /dev/null @@ -1,42 +0,0 @@ --- --- rAthena Database Converter ( InnoDB -> MyISAM ) --- - -ALTER TABLE `auction` ENGINE = MyISAM; -ALTER TABLE `cart_inventory` ENGINE = MyISAM; -ALTER TABLE `char` ENGINE = MyISAM; -ALTER TABLE `charlog` ENGINE = MyISAM; -ALTER TABLE `friends` ENGINE = MyISAM; -ALTER TABLE `global_reg_value` ENGINE = MyISAM; -ALTER TABLE `guild` ENGINE = MyISAM; -ALTER TABLE `guild_alliance` ENGINE = MyISAM; -ALTER TABLE `guild_castle` ENGINE = MyISAM; -ALTER TABLE `guild_expulsion` ENGINE = MyISAM; -ALTER TABLE `guild_member` ENGINE = MyISAM; -ALTER TABLE `guild_position` ENGINE = MyISAM; -ALTER TABLE `guild_skill` ENGINE = MyISAM; -ALTER TABLE `guild_storage` ENGINE = MyISAM; -ALTER TABLE `homunculus` ENGINE = MyISAM; -ALTER TABLE `hotkey` ENGINE = MyISAM; -ALTER TABLE `interlog` ENGINE = MyISAM; -ALTER TABLE `inventory` ENGINE = MyISAM; -ALTER TABLE `ipbanlist` ENGINE = MyISAM; -#ALTER TABLE `item_db` ENGINE = MyISAM; -#ALTER TABLE `item_db2` ENGINE = MyISAM; -ALTER TABLE `login` ENGINE = MyISAM; -ALTER TABLE `mail` ENGINE = MyISAM; -ALTER TABLE `mapreg` ENGINE = MyISAM; -ALTER TABLE `memo` ENGINE = MyISAM; -ALTER TABLE `mercenary` ENGINE = MyISAM; -ALTER TABLE `mercenary_owner` ENGINE = MyISAM; -#ALTER TABLE `mob_db` ENGINE = MyISAM; -#ALTER TABLE `mob_db2` ENGINE = MyISAM; -ALTER TABLE `party` ENGINE = MyISAM; -ALTER TABLE `pet` ENGINE = MyISAM; -ALTER TABLE `quest` ENGINE = MyISAM; -ALTER TABLE `ragsrvinfo` ENGINE = MyISAM; -ALTER TABLE `sc_data` ENGINE = MyISAM; -ALTER TABLE `skill` ENGINE = MyISAM; -ALTER TABLE `skill_homunculus` ENGINE = MyISAM; -ALTER TABLE `sstatus` ENGINE = MyISAM; -ALTER TABLE `storage` ENGINE = MyISAM; diff --git a/sql-files/convert_passwords.sql b/sql-files/convert_passwords.sql deleted file mode 100644 index 86e4c5b08..000000000 --- a/sql-files/convert_passwords.sql +++ /dev/null @@ -1,3 +0,0 @@ -# Convert passwords to MD5 hashes - -UPDATE `login` SET `user_pass`=MD5(`user_pass`); diff --git a/sql-files/tools/convert_engine_innodb.sql b/sql-files/tools/convert_engine_innodb.sql new file mode 100644 index 000000000..fcb240bb1 --- /dev/null +++ b/sql-files/tools/convert_engine_innodb.sql @@ -0,0 +1,42 @@ +-- +-- rAthena Database Converter ( MyISAM -> InnoDB ) +-- + +ALTER TABLE `auction` ENGINE = InnoDB; +ALTER TABLE `cart_inventory` ENGINE = InnoDB; +ALTER TABLE `char` ENGINE = InnoDB; +ALTER TABLE `charlog` ENGINE = InnoDB; +ALTER TABLE `friends` ENGINE = InnoDB; +ALTER TABLE `global_reg_value` ENGINE = InnoDB; +ALTER TABLE `guild` ENGINE = InnoDB; +ALTER TABLE `guild_alliance` ENGINE = InnoDB; +ALTER TABLE `guild_castle` ENGINE = InnoDB; +ALTER TABLE `guild_expulsion` ENGINE = InnoDB; +ALTER TABLE `guild_member` ENGINE = InnoDB; +ALTER TABLE `guild_position` ENGINE = InnoDB; +ALTER TABLE `guild_skill` ENGINE = InnoDB; +ALTER TABLE `guild_storage` ENGINE = InnoDB; +ALTER TABLE `homunculus` ENGINE = InnoDB; +ALTER TABLE `hotkey` ENGINE = InnoDB; +ALTER TABLE `interlog` ENGINE = InnoDB; +ALTER TABLE `inventory` ENGINE = InnoDB; +ALTER TABLE `ipbanlist` ENGINE = InnoDB; +#ALTER TABLE `item_db` ENGINE = InnoDB; +#ALTER TABLE `item_db2` ENGINE = InnoDB; +ALTER TABLE `login` ENGINE = InnoDB; +ALTER TABLE `mail` ENGINE = InnoDB; +ALTER TABLE `mapreg` ENGINE = InnoDB; +ALTER TABLE `memo` ENGINE = InnoDB; +ALTER TABLE `mercenary` ENGINE = InnoDB; +ALTER TABLE `mercenary_owner` ENGINE = InnoDB; +#ALTER TABLE `mob_db` ENGINE = InnoDB; +#ALTER TABLE `mob_db2` ENGINE = InnoDB; +ALTER TABLE `party` ENGINE = InnoDB; +ALTER TABLE `pet` ENGINE = InnoDB; +ALTER TABLE `quest` ENGINE = InnoDB; +ALTER TABLE `ragsrvinfo` ENGINE = InnoDB; +ALTER TABLE `sc_data` ENGINE = InnoDB; +ALTER TABLE `skill` ENGINE = InnoDB; +ALTER TABLE `skill_homunculus` ENGINE = InnoDB; +ALTER TABLE `sstatus` ENGINE = InnoDB; +ALTER TABLE `storage` ENGINE = InnoDB; diff --git a/sql-files/tools/convert_engine_myisam.sql b/sql-files/tools/convert_engine_myisam.sql new file mode 100644 index 000000000..5af878f65 --- /dev/null +++ b/sql-files/tools/convert_engine_myisam.sql @@ -0,0 +1,42 @@ +-- +-- rAthena Database Converter ( InnoDB -> MyISAM ) +-- + +ALTER TABLE `auction` ENGINE = MyISAM; +ALTER TABLE `cart_inventory` ENGINE = MyISAM; +ALTER TABLE `char` ENGINE = MyISAM; +ALTER TABLE `charlog` ENGINE = MyISAM; +ALTER TABLE `friends` ENGINE = MyISAM; +ALTER TABLE `global_reg_value` ENGINE = MyISAM; +ALTER TABLE `guild` ENGINE = MyISAM; +ALTER TABLE `guild_alliance` ENGINE = MyISAM; +ALTER TABLE `guild_castle` ENGINE = MyISAM; +ALTER TABLE `guild_expulsion` ENGINE = MyISAM; +ALTER TABLE `guild_member` ENGINE = MyISAM; +ALTER TABLE `guild_position` ENGINE = MyISAM; +ALTER TABLE `guild_skill` ENGINE = MyISAM; +ALTER TABLE `guild_storage` ENGINE = MyISAM; +ALTER TABLE `homunculus` ENGINE = MyISAM; +ALTER TABLE `hotkey` ENGINE = MyISAM; +ALTER TABLE `interlog` ENGINE = MyISAM; +ALTER TABLE `inventory` ENGINE = MyISAM; +ALTER TABLE `ipbanlist` ENGINE = MyISAM; +#ALTER TABLE `item_db` ENGINE = MyISAM; +#ALTER TABLE `item_db2` ENGINE = MyISAM; +ALTER TABLE `login` ENGINE = MyISAM; +ALTER TABLE `mail` ENGINE = MyISAM; +ALTER TABLE `mapreg` ENGINE = MyISAM; +ALTER TABLE `memo` ENGINE = MyISAM; +ALTER TABLE `mercenary` ENGINE = MyISAM; +ALTER TABLE `mercenary_owner` ENGINE = MyISAM; +#ALTER TABLE `mob_db` ENGINE = MyISAM; +#ALTER TABLE `mob_db2` ENGINE = MyISAM; +ALTER TABLE `party` ENGINE = MyISAM; +ALTER TABLE `pet` ENGINE = MyISAM; +ALTER TABLE `quest` ENGINE = MyISAM; +ALTER TABLE `ragsrvinfo` ENGINE = MyISAM; +ALTER TABLE `sc_data` ENGINE = MyISAM; +ALTER TABLE `skill` ENGINE = MyISAM; +ALTER TABLE `skill_homunculus` ENGINE = MyISAM; +ALTER TABLE `sstatus` ENGINE = MyISAM; +ALTER TABLE `storage` ENGINE = MyISAM; diff --git a/sql-files/tools/convert_passwords.sql b/sql-files/tools/convert_passwords.sql new file mode 100644 index 000000000..86e4c5b08 --- /dev/null +++ b/sql-files/tools/convert_passwords.sql @@ -0,0 +1,3 @@ +# Convert passwords to MD5 hashes + +UPDATE `login` SET `user_pass`=MD5(`user_pass`); 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/upgrade_svn15003.sql deleted file mode 100644 index e30a3b0fd..000000000 --- a/sql-files/upgrade_svn15003.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `global_reg_value` MODIFY `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '3'; diff --git a/sql-files/upgrade_svn15420_log.sql b/sql-files/upgrade_svn15420_log.sql deleted file mode 100644 index 580dce9a2..000000000 --- a/sql-files/upgrade_svn15420_log.sql +++ /dev/null @@ -1,3 +0,0 @@ --- 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/upgrade_svn15519_log.sql b/sql-files/upgrade_svn15519_log.sql deleted file mode 100644 index 623b022b8..000000000 --- a/sql-files/upgrade_svn15519_log.sql +++ /dev/null @@ -1,3 +0,0 @@ --- 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/upgrade_svn15531_db.sql b/sql-files/upgrade_svn15531_db.sql deleted file mode 100644 index ce0e56302..000000000 --- a/sql-files/upgrade_svn15531_db.sql +++ /dev/null @@ -1,4 +0,0 @@ --- `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/upgrade_svn15572.sql b/sql-files/upgrade_svn15572.sql deleted file mode 100644 index 821bb79d6..000000000 --- a/sql-files/upgrade_svn15572.sql +++ /dev/null @@ -1,3 +0,0 @@ --- 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/upgrade_svn15818_log.sql b/sql-files/upgrade_svn15818_log.sql deleted file mode 100644 index b61f71f53..000000000 --- a/sql-files/upgrade_svn15818_log.sql +++ /dev/null @@ -1,3 +0,0 @@ --- 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/upgrade_svn15885.sql b/sql-files/upgrade_svn15885.sql deleted file mode 100644 index 48b25b5a7..000000000 --- a/sql-files/upgrade_svn15885.sql +++ /dev/null @@ -1,24 +0,0 @@ -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/upgrade_svn15926_log.sql b/sql-files/upgrade_svn15926_log.sql deleted file mode 100644 index 099ee6faa..000000000 --- a/sql-files/upgrade_svn15926_log.sql +++ /dev/null @@ -1,3 +0,0 @@ --- 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/upgrade_svn16490.sql b/sql-files/upgrade_svn16490.sql deleted file mode 100644 index b38445c46..000000000 --- a/sql-files/upgrade_svn16490.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `char` ADD CONSTRAINT `name_key` UNIQUE (`name`); diff --git a/sql-files/upgrade_svn16518.sql b/sql-files/upgrade_svn16518.sql deleted file mode 100644 index 1c142c65f..000000000 --- a/sql-files/upgrade_svn16518.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `inventory` ADD COLUMN `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`; diff --git a/sql-files/upgrade_svn16639.sql b/sql-files/upgrade_svn16639.sql deleted file mode 100644 index 0da4b91d1..000000000 --- a/sql-files/upgrade_svn16639.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `item_db_re` CHANGE `equip_level` `equip_level` VARCHAR(10) DEFAULT ''; diff --git a/sql-files/upgrade_svn16645.sql b/sql-files/upgrade_svn16645.sql deleted file mode 100644 index 9a3237ad8..000000000 --- a/sql-files/upgrade_svn16645.sql +++ /dev/null @@ -1,2 +0,0 @@ -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/upgrade_svn16663.sql b/sql-files/upgrade_svn16663.sql deleted file mode 100644 index 8883a108b..000000000 --- a/sql-files/upgrade_svn16663.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `homunculus` ADD `prev_class` MEDIUMINT( 9 ) NOT NULL AFTER `class` 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` -- cgit v1.2.3-60-g2f50