From d0d0f51f325e4ae42c9bef7606fed4f4c00c98d6 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 27 Sep 2020 00:51:52 +0200 Subject: Core/Auction House: Eliminate blocking db queries for account permissions when expiring auctions that have offline bidders --- sql/base/characters_database.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql/base/characters_database.sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0a03202302e..eb084c1256c 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -246,6 +246,7 @@ CREATE TABLE `auctionhouse` ( `lastbid` int(10) unsigned NOT NULL DEFAULT '0', `startbid` int(10) unsigned NOT NULL DEFAULT '0', `deposit` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `item_guid` (`itemguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -2651,7 +2652,8 @@ INSERT INTO `updates` VALUES ('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0), ('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0), ('2020_09_02_00_characters.sql','627F320D58A42F401AB10ABA927F2B37C1981576','ARCHIVED','2020-09-02 17:41:04',0), -('2020_09_15_00_characters.sql','1B650E8C815E29AE261238B010BC9EB35BD49A25','ARCHIVED','2020-09-15 19:35:18',0); +('2020_09_15_00_characters.sql','1B650E8C815E29AE261238B010BC9EB35BD49A25','ARCHIVED','2020-09-15 19:35:18',0), +('2020_09_27_00_characters.sql','441A0E8717165067D13B206F6925EEEA774262F3','RELEASED','2020-09-27 00:27:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3