aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index a85383bc7fd..ad33354aaf7 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -743,7 +743,8 @@ CREATE TABLE `character_pet` (
`resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
`abdata` text,
PRIMARY KEY (`id`),
- KEY `owner` (`owner`)
+ KEY `owner` (`owner`),
+ KEY `idx_slot` (`slot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
/*!40101 SET character_set_client = @saved_cs_client */;