diff options
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; -- |