From 50d90e80f9f70a2dd6939adc39f2eca29ae0a45f Mon Sep 17 00:00:00 2001
From: Kevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Fri, 11 Apr 2008 07:24:03 +0000
Subject: New sql definitions for the quest code.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/main.sql             | 11 ++++-------
 sql-files/upgrade_svn12545.sql | 27 ---------------------------
 sql-files/upgrade_svn12559.sql | 24 ++++++++++++++++++++++++
 3 files changed, 28 insertions(+), 34 deletions(-)
 delete mode 100644 sql-files/upgrade_svn12545.sql
 create mode 100644 sql-files/upgrade_svn12559.sql

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_svn12545.sql
deleted file mode 100644
index a3eadacf0..000000000
--- a/sql-files/upgrade_svn12545.sql
+++ /dev/null
@@ -1,27 +0,0 @@
---
--- Table structure for table `quest`
---
-
-DROP TABLE IF EXISTS `quest`;
-CREATE TABLE  `quest` (
-  `id` int(11) unsigned NOT NULL auto_increment,
-  `name` varchar(255) NOT NULL default '',
-  `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`)
-) ENGINE=MyISAM;
-
---
--- Table structure for table `quest_mob`
---
-
-DROP TABLE IF EXISTS `quest_objective`;
-CREATE TABLE  `quest_objective` (
-  `id` int(11) unsigned NOT NULL auto_increment,
-  `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
diff --git a/sql-files/upgrade_svn12559.sql b/sql-files/upgrade_svn12559.sql
new file mode 100644
index 000000000..66f36a468
--- /dev/null
+++ b/sql-files/upgrade_svn12559.sql
@@ -0,0 +1,24 @@
+--
+-- Table structure for table `quest`
+--
+
+DROP TABLE IF EXISTS `quest`;
+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  USING BTREE (`char_id`,`quest_id`)
+) ENGINE=MyISAM;
+
+--
+-- Table structure for table `quest_mob`
+--
+
+DROP TABLE IF EXISTS `quest_objective`;
+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  USING BTREE (`quest_id`,`num`)
+) ENGINE=MyISAM;
-- 
cgit v1.2.3-70-g09d2