From 3a616674921763c5cf3f3409dbd1fe06251ec9c2 Mon Sep 17 00:00:00 2001 From: click Date: Sat, 1 May 2010 08:10:14 +0200 Subject: Add support for sorting vendor itemlists --HG-- branch : trunk --- sql/updates/8057_world_game_event_npc_vendor.sql | 2 ++ sql/updates/8057_world_npc_vendor.sql | 2 ++ 2 files changed, 4 insertions(+) create mode 100644 sql/updates/8057_world_game_event_npc_vendor.sql create mode 100644 sql/updates/8057_world_npc_vendor.sql (limited to 'sql/updates') diff --git a/sql/updates/8057_world_game_event_npc_vendor.sql b/sql/updates/8057_world_game_event_npc_vendor.sql new file mode 100644 index 00000000000..92923390b31 --- /dev/null +++ b/sql/updates/8057_world_game_event_npc_vendor.sql @@ -0,0 +1,2 @@ +ALTER TABLE `game_event_npc_vendor` ADD `slot` SMALLINT(6) NOT NULL DEFAULT '0' AFTER `guid`; +ALTER TABLE `game_event_npc_vendor` ADD INDEX (`slot`); diff --git a/sql/updates/8057_world_npc_vendor.sql b/sql/updates/8057_world_npc_vendor.sql new file mode 100644 index 00000000000..7703e035790 --- /dev/null +++ b/sql/updates/8057_world_npc_vendor.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_vendor` ADD `slot` SMALLINT(6) NOT NULL DEFAULT '0' AFTER `entry`; +ALTER TABLE `npc_vendor` ADD INDEX (`slot`); -- cgit v1.2.3