summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorInkfish <Inkfish@54d463be-8e91-2dee-dedb-b68131a5f0ec>2009-07-26 06:01:10 +0000
committerInkfish <Inkfish@54d463be-8e91-2dee-dedb-b68131a5f0ec>2009-07-26 06:01:10 +0000
commite9a090774cb956ebb122698374be2a5360dd8b00 (patch)
tree62ed879dcb9e50038240a5ef8897808abf26c510 /sql-files
parentf9c3a2a80b9981a3102661928f5c2469e47d360c (diff)
downloadhercules-e9a090774cb956ebb122698374be2a5360dd8b00.tar.gz
hercules-e9a090774cb956ebb122698374be2a5360dd8b00.tar.bz2
hercules-e9a090774cb956ebb122698374be2a5360dd8b00.tar.xz
hercules-e9a090774cb956ebb122698374be2a5360dd8b00.zip
* Some updates of Quest Log system
- renamed table 'questlog' to 'quest' to avoid misunderstanding - updated main.sql - fixed the server can't load more than 16 quests - removed the MAX_QUEST limit. tests show the client can handle more than 100 quests. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13963 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql24
-rw-r--r--sql-files/upgrade_svn_13963.sql1
2 files changed, 10 insertions, 15 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 3f7fcdbd2..595743d5f 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -556,21 +556,15 @@ CREATE TABLE IF NOT EXISTS `pet` (
CREATE TABLE IF NOT EXISTS `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`
---
-
-CREATE TABLE IF NOT EXISTS `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,
- `char_id` int(10) unsigned NOT NULL,
- PRIMARY KEY USING BTREE (`quest_id`,`num`,`char_id`)
+ `state` enum('0','1','2') 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 (`char_id`,`quest_id`)
) ENGINE=MyISAM;
--
diff --git a/sql-files/upgrade_svn_13963.sql b/sql-files/upgrade_svn_13963.sql
new file mode 100644
index 000000000..97211ba44
--- /dev/null
+++ b/sql-files/upgrade_svn_13963.sql
@@ -0,0 +1 @@
+RENAME TABLE `questlog` TO `quest`; \ No newline at end of file