diff options
| author | azazel <none@none> | 2010-12-15 14:08:12 +0600 |
|---|---|---|
| committer | azazel <none@none> | 2010-12-15 14:08:12 +0600 |
| commit | b39b8fdd0dd219b78cced60d746f2eb0d0cacdf7 (patch) | |
| tree | 0448fb375ecd1ca73de28b0bf610d6a8078dce61 /sql/base | |
| parent | 58a9b15443aea65e78169b7078b3c00ae9004ac5 (diff) | |
DB Schema/Characters: removed columns auctionhouse.item_template, character_inventory.item_template, guild_bank_item.item_entry and mail_items.item_template and created item_instance.itemEntry column instead of them.
As a side effect moved related queries to prepared statements.
As one more side effect fixed not shown and lost mail items in returned expired mail (patch by Quriq14).
--HG--
branch : trunk
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 3753593e694..11acfcc0ef7 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -184,7 +184,6 @@ CREATE TABLE `auctionhouse` ( `id` int(11) unsigned NOT NULL default '0', `auctioneerguid` int(11) unsigned NOT NULL default '0', `itemguid` int(11) unsigned NOT NULL default '0', - `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', `itemowner` int(11) unsigned NOT NULL default '0', `buyoutprice` int(11) NOT NULL default '0', `time` bigint(40) NOT NULL default '0', @@ -762,7 +761,6 @@ CREATE TABLE `character_inventory` ( `bag` int(11) unsigned NOT NULL default '0', `slot` tinyint(3) unsigned NOT NULL default '0', `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier', - `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', PRIMARY KEY (`item`), KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; @@ -1557,7 +1555,6 @@ CREATE TABLE `guild_bank_item` ( `TabId` tinyint(1) unsigned NOT NULL default '0', `SlotId` tinyint(3) unsigned NOT NULL default '0', `item_guid` int(11) unsigned NOT NULL default '0', - `item_entry` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guildid`,`tabid`,`slotid`), KEY `guildid_key` (`guildid`), INDEX `Idx_item_guid`(`item_guid`) @@ -1790,6 +1787,7 @@ DROP TABLE IF EXISTS `item_instance`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_instance` ( `guid` int(11) unsigned NOT NULL default '0', + `itemEntry` mediumint(8) unsigned NOT NULL default '0', `owner_guid` int(11) unsigned NOT NULL default '0', `creatorGuid` int(10) unsigned NOT NULL default '0', `giftCreatorGuid` int(10) unsigned NOT NULL default '0', @@ -1938,7 +1936,6 @@ DROP TABLE IF EXISTS `mail_items`; CREATE TABLE `mail_items` ( `mail_id` int(11) NOT NULL default '0', `item_guid` int(11) NOT NULL default '0', - `item_template` int(11) NOT NULL default '0', `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`mail_id`,`item_guid`), KEY `idx_receiver` (`receiver`) |