diff options
| author | Kevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-11 07:24:03 +0000 |
|---|---|---|
| committer | Kevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-11 07:24:03 +0000 |
| commit | 50d90e80f9f70a2dd6939adc39f2eca29ae0a45f (patch) | |
| tree | a0b1530df0e0534e894675e097dbec92d6308185 /sql-files/main.sql | |
| parent | 3e2be49541f4f9e464fb7cac1c4bd6eff4df5572 (diff) | |
| download | hercules-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.sql | 11 |
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; -- |