diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-08-15 19:11:45 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-08-15 19:11:45 +0100 |
| commit | 1cca24440b545a9ba52272b5c9dc19146c6b9520 (patch) | |
| tree | 93a3064bb1e3d6345d5bb4248b4e53c713ef9d21 | |
| parent | a29a79e6d768e01d15c64ba82ea45e234b8a6f30 (diff) | |
DB/Schema: Remove a meaningless index in quest_poi, update PKs for npc_vendor tables
| -rw-r--r-- | sql/updates/world/2012_08_15_01_world_misc_434.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_15_01_world_misc_434.sql b/sql/updates/world/2012_08_15_01_world_misc_434.sql new file mode 100644 index 00000000000..dae8500479b --- /dev/null +++ b/sql/updates/world/2012_08_15_01_world_misc_434.sql @@ -0,0 +1,3 @@ +ALTER TABLE `quest_poi` DROP INDEX `idx`; +ALTER TABLE `game_event_npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`guid`, `item`, `ExtendedCost`, `type`); +ALTER TABLE `npc_vendor` DROP INDEX `PRIMARY`, ADD PRIMARY KEY (`entry`, `item`, `ExtendedCost`, `type`); |