diff options
Diffstat (limited to 'sql-files')
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 |