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 ++ sql/world.sql | 8 ++++++-- 3 files changed, 10 insertions(+), 2 deletions(-) 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') 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`); diff --git a/sql/world.sql b/sql/world.sql index 8c8bf8b1ef1..bd299941180 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2093,11 +2093,13 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`; CREATE TABLE `game_event_npc_vendor` ( `event` mediumint(8) unsigned NOT NULL DEFAULT '0', `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `slot` smallint(6) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) NOT NULL DEFAULT '0', `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0', `incrtime` mediumint(8) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`item`) + PRIMARY KEY (`guid`,`item`), + INDEX (`slot`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3687,11 +3689,13 @@ DROP TABLE IF EXISTS `npc_vendor`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_vendor` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `slot` smallint(6) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0', `incrtime` int(10) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`entry`,`item`,`extendedCost`) + PRIMARY KEY (`entry`,`item`,`extendedCost`), + INDEX (`slot`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System'; /*!40101 SET character_set_client = @saved_cs_client */; -- cgit v1.2.3