summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql11
-rw-r--r--sql-files/upgrade_svn12559.sql (renamed from sql-files/upgrade_svn12545.sql)13
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;