diff options
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/logs.sql | 1 | ||||
-rw-r--r-- | sql-files/mob_db.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn11106.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn11388.sql | 1 | ||||
-rw-r--r-- | sql-files/upgrade_svn12294.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn12368.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn12581.sql | 4 | ||||
-rw-r--r-- | sql-files/upgrade_svn13117_char.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn13390.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn13583.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn13960_questlog.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn13963.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn14036.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn14085.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn14242.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrade_svn15420_log.sql | 2 |
16 files changed, 15 insertions, 17 deletions
diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 411708d73..b031c566c 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -125,4 +125,3 @@ CREATE TABLE `loginlog` ( `log` varchar(255) NOT NULL default '', INDEX (`ip`) ) ENGINE=MyISAM ; - diff --git a/sql-files/mob_db.sql b/sql-files/mob_db.sql index cf9e74181..fa324c81f 100644 --- a/sql-files/mob_db.sql +++ b/sql-files/mob_db.sql @@ -1300,4 +1300,4 @@ REPLACE INTO mob_db VALUES(2240, "B_ALPHOCCIO", "Minstel Alphoccio", "Minstrel A REPLACE INTO mob_db VALUES(2241, "B_TRENTINI", "Gypsy Trentini", "Gypsy Trentini", 1, 60, 1, 27, 20, 1, 8, 9, 2, 5, 6, 1, 1, 0, 6, 5, 10, 12, 1, 3, 21, 0x83, 400, 1872, 672, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO mob_db VALUES(2242, "MD_DESERT_WOLF", "Desert Wolf", "Desert Wolf", 1, 60, 1, 27, 20, 1, 8, 9, 2, 5, 6, 1, 1, 0, 6, 5, 10, 12, 1, 3, 21, 0x83, 400, 1872, 672, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO mob_db VALUES(2243, "MD_DESERT_WOLF_B", "Baby Desert Wolf", "Baby Desert Wolf", 1, 60, 1, 27, 20, 1, 8, 9, 2, 5, 6, 1, 1, 0, 6, 5, 10, 12, 1, 3, 21, 0x83, 400, 1872, 672, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); -REPLACE INTO mob_db VALUES(2244, "QUEST_CHEN", "Champion Chen", "Champion Chen", 1, 60, 1, 27, 20, 1, 8, 9, 2, 5, 6, 1, 1, 0, 6, 5, 10, 12, 1, 3, 21, 0x83, 400, 1872, 672, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file +REPLACE INTO mob_db VALUES(2244, "QUEST_CHEN", "Champion Chen", "Champion Chen", 1, 60, 1, 27, 20, 1, 8, 9, 2, 5, 6, 1, 1, 0, 6, 5, 10, 12, 1, 3, 21, 0x83, 400, 1872, 672, 480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); diff --git a/sql-files/upgrade_svn11106.sql b/sql-files/upgrade_svn11106.sql index 30220352e..52ed0c95e 100644 --- a/sql-files/upgrade_svn11106.sql +++ b/sql-files/upgrade_svn11106.sql @@ -1 +1 @@ -UPDATE `item_db` SET `script` = 'getitem 5267,1; ' WHERE `item_db`.`id` =12949 LIMIT 1 ;
\ No newline at end of file +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 index 8ca4d0fbb..d15c01006 100644 --- a/sql-files/upgrade_svn11388.sql +++ b/sql-files/upgrade_svn11388.sql @@ -2,4 +2,3 @@ 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; -
\ No newline at end of file diff --git a/sql-files/upgrade_svn12294.sql b/sql-files/upgrade_svn12294.sql index 710b4b7c2..707d49cfe 100644 --- a/sql-files/upgrade_svn12294.sql +++ b/sql-files/upgrade_svn12294.sql @@ -23,4 +23,4 @@ CREATE TABLE `auction` ( `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', PRIMARY KEY (`auction_id`) -) ENGINE=MyISAM;
\ No newline at end of file +) ENGINE=MyISAM; diff --git a/sql-files/upgrade_svn12368.sql b/sql-files/upgrade_svn12368.sql index 62429a19b..bc717edaf 100644 --- a/sql-files/upgrade_svn12368.sql +++ b/sql-files/upgrade_svn12368.sql @@ -1 +1 @@ -UPDATE `item_db` SET `refineable` = '0' WHERE `item_db`.`id` = '5255';
\ No newline at end of file +UPDATE `item_db` SET `refineable` = '0' WHERE `item_db`.`id` = '5255'; diff --git a/sql-files/upgrade_svn12581.sql b/sql-files/upgrade_svn12581.sql index 9b487d5e1..8953b02a2 100644 --- a/sql-files/upgrade_svn12581.sql +++ b/sql-files/upgrade_svn12581.sql @@ -1,3 +1,3 @@ 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`);
\ No newline at end of file + DROP PRIMARY KEY, + ADD PRIMARY KEY USING BTREE(`quest_id`, `num`, `char_id`); diff --git a/sql-files/upgrade_svn13117_char.sql b/sql-files/upgrade_svn13117_char.sql index 99fea2086..c3f2da56d 100644 --- a/sql-files/upgrade_svn13117_char.sql +++ b/sql-files/upgrade_svn13117_char.sql @@ -1 +1 @@ -ALTER TABLE `char` ADD COLUMN `mer_id` INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER `homun_id`;
\ No newline at end of file +ALTER TABLE `char` ADD COLUMN `mer_id` INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER `homun_id`; diff --git a/sql-files/upgrade_svn13390.sql b/sql-files/upgrade_svn13390.sql index 220701e1a..7bbe4cf64 100644 --- a/sql-files/upgrade_svn13390.sql +++ b/sql-files/upgrade_svn13390.sql @@ -1 +1 @@ -UPDATE `item_db` SET `script` = 'getitem 12213,10; ' WHERE `item_db`.`id` =12911 OR `item_db`.`id` =14167 ;
\ No newline at end of file +UPDATE `item_db` SET `script` = 'getitem 12213,10; ' WHERE `item_db`.`id` =12911 OR `item_db`.`id` =14167 ; diff --git a/sql-files/upgrade_svn13583.sql b/sql-files/upgrade_svn13583.sql index b16579cd9..277979384 100644 --- a/sql-files/upgrade_svn13583.sql +++ b/sql-files/upgrade_svn13583.sql @@ -1 +1 @@ -ALTER TABLE `char` CHANGE `manner` `manner` SMALLINT ( 6 ) NOT NULL DEFAULT '0';
\ No newline at end of file +ALTER TABLE `char` CHANGE `manner` `manner` SMALLINT ( 6 ) NOT NULL DEFAULT '0'; diff --git a/sql-files/upgrade_svn13960_questlog.sql b/sql-files/upgrade_svn13960_questlog.sql index f176c5a6e..ec307682d 100644 --- a/sql-files/upgrade_svn13960_questlog.sql +++ b/sql-files/upgrade_svn13960_questlog.sql @@ -17,4 +17,4 @@ CREATE TABLE IF NOT EXISTS `questlog` ( ) ENGINE=MyISAM; DROP TABLE `quest_objective`; -DROP TABLE `quest`;
\ No newline at end of file +DROP TABLE `quest`; diff --git a/sql-files/upgrade_svn13963.sql b/sql-files/upgrade_svn13963.sql index 97211ba44..a9acd7118 100644 --- a/sql-files/upgrade_svn13963.sql +++ b/sql-files/upgrade_svn13963.sql @@ -1 +1 @@ -RENAME TABLE `questlog` TO `quest`;
\ No newline at end of file +RENAME TABLE `questlog` TO `quest`; diff --git a/sql-files/upgrade_svn14036.sql b/sql-files/upgrade_svn14036.sql index a90da2cc5..d2fa304e2 100644 --- a/sql-files/upgrade_svn14036.sql +++ b/sql-files/upgrade_svn14036.sql @@ -1,3 +1,3 @@ ALTER TABLE `quest` DROP `mob1`; ALTER TABLE `quest` DROP `mob2`; -ALTER TABLE `quest` DROP `mob3`;
\ No newline at end of file +ALTER TABLE `quest` DROP `mob3`; diff --git a/sql-files/upgrade_svn14085.sql b/sql-files/upgrade_svn14085.sql index 3d0ed00f4..5e988841e 100644 --- a/sql-files/upgrade_svn14085.sql +++ b/sql-files/upgrade_svn14085.sql @@ -1 +1 @@ -ALTER TABLE `char` ADD `rename` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
\ No newline at end of file +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 index 2c1b9c5f7..5f818a3d7 100644 --- a/sql-files/upgrade_svn14242.sql +++ b/sql-files/upgrade_svn14242.sql @@ -1 +1 @@ -ALTER TABLE `guild` MODIFY COLUMN `exp` bigint(20) unsigned NOT NULL default '0';
\ No newline at end of file +ALTER TABLE `guild` MODIFY COLUMN `exp` bigint(20) unsigned NOT NULL default '0'; diff --git a/sql-files/upgrade_svn15420_log.sql b/sql-files/upgrade_svn15420_log.sql index 5e6e3c9e9..580dce9a2 100644 --- a/sql-files/upgrade_svn15420_log.sql +++ b/sql-files/upgrade_svn15420_log.sql @@ -1,3 +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';
\ No newline at end of file +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'; |