New sql definitions for the quest code.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec

2 files changed, 9 insertions, 15 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;
 
 --
diff --git a/sql-files/upgrade_svn12545.sql b/sql-files/upgrade_svn12559.sql
index a3eadacf0..66f36a468 100644
--- a/sql-files/upgrade_svn12545.sql
+++ b/sql-files/upgrade_svn12559.sql
@@ -3,13 +3,11 @@
 --

 

 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;

 

 --

@@ -17,11 +15,10 @@ 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`)

-) ENGINE=MyISAM;
\ No newline at end of file
+  PRIMARY KEY  USING BTREE (`quest_id`,`num`)

+) ENGINE=MyISAM;