summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorKevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-04-11 07:24:03 +0000
committerKevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec>2008-04-11 07:24:03 +0000
commit50d90e80f9f70a2dd6939adc39f2eca29ae0a45f (patch)
treea0b1530df0e0534e894675e097dbec92d6308185 /sql-files/main.sql
parent3e2be49541f4f9e464fb7cac1c4bd6eff4df5572 (diff)
downloadhercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.gz
hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.bz2
hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.xz
hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.zip
New sql definitions for the quest code.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql11
1 files changed, 4 insertions, 7 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index dc733686b..6f59de4b5 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -570,13 +570,11 @@ CREATE TABLE `pet` (
--
DROP TABLE IF EXISTS `quest`;
-CREATE TABLE `quest` (
- `id` int(11) unsigned NOT NULL auto_increment,
- `name` varchar(255) NOT NULL default '',
+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 (`id`)
+ PRIMARY KEY USING BTREE (`char_id`,`quest_id`)
) ENGINE=MyISAM;
--
@@ -584,13 +582,12 @@ CREATE TABLE `quest` (
--
DROP TABLE IF EXISTS `quest_objective`;
-CREATE TABLE `quest_objective` (
- `id` int(11) unsigned NOT NULL auto_increment,
+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 (`id`)
+ PRIMARY KEY USING BTREE (`quest_id`,`num`)
) ENGINE=MyISAM;
--