summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorbrianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-01-11 20:56:08 +0000
committerbrianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-01-11 20:56:08 +0000
commita8db0b293ae542c5ebccb062b3459c0f74e917a0 (patch)
tree4d45ba635911325b9fde363bc593ce1d07cb9a91 /sql-files
parent2a315a7ab545dd95d19fff828cfc39dbb746466c (diff)
downloadhercules-a8db0b293ae542c5ebccb062b3459c0f74e917a0.tar.gz
hercules-a8db0b293ae542c5ebccb062b3459c0f74e917a0.tar.bz2
hercules-a8db0b293ae542c5ebccb062b3459c0f74e917a0.tar.xz
hercules-a8db0b293ae542c5ebccb062b3459c0f74e917a0.zip
- SVN Copied exp.txt, exp_guild.txt, exp_homun.txt to /db/pre-re/ and /db/re/
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15423 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/logs.sql1
-rw-r--r--sql-files/mob_db.sql2
-rw-r--r--sql-files/upgrade_svn11106.sql2
-rw-r--r--sql-files/upgrade_svn11388.sql1
-rw-r--r--sql-files/upgrade_svn12294.sql2
-rw-r--r--sql-files/upgrade_svn12368.sql2
-rw-r--r--sql-files/upgrade_svn12581.sql4
-rw-r--r--sql-files/upgrade_svn13117_char.sql2
-rw-r--r--sql-files/upgrade_svn13390.sql2
-rw-r--r--sql-files/upgrade_svn13583.sql2
-rw-r--r--sql-files/upgrade_svn13960_questlog.sql2
-rw-r--r--sql-files/upgrade_svn13963.sql2
-rw-r--r--sql-files/upgrade_svn14036.sql2
-rw-r--r--sql-files/upgrade_svn14085.sql2
-rw-r--r--sql-files/upgrade_svn14242.sql2
-rw-r--r--sql-files/upgrade_svn15420_log.sql2
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';