From 569b5d6f04548cd874cc161cb67a62dcad792fb0 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
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

(cherry picked from commit d0d0f51f325e4ae42c9bef7606fed4f4c00c98d6)
---
 sql/base/characters_database.sql                                      | 4 +++-
 .../master/2022_02_28_00_characters_2020_09_27_00_characters.sql      | 1 +
 2 files changed, 4 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql

(limited to 'sql')

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index bdaa46253e0..191899bb165 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -223,6 +223,7 @@ CREATE TABLE `auctionhouse` (
   `bidAmount` bigint unsigned NOT NULL DEFAULT '0',
   `startTime` bigint NOT NULL DEFAULT '0',
   `endTime` bigint NOT NULL DEFAULT '0',
+  `serverFlags` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3662,7 +3663,8 @@ INSERT INTO `updates` VALUES
 ('2022_01_15_00_characters.sql','884EFB6592DC8A765E0C0BF8BF907B4E4733BB0C','ARCHIVED','2022-01-15 23:24:58',0),
 ('2022_01_31_00_characters.sql','19551474AA6079F0616B565F254914C5DD9ED1A1','RELEASED','2022-01-31 14:32:49',0),
 ('2022_01_31_01_characters.sql','E0A1FA670F4621AEB594D7ACBA4921CB298F54FF','RELEASED','2022-01-31 20:47:59',0),
-('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','RELEASED','2022-01-31 21:43:38',0);
+('2022_01_31_02_characters.sql','6E3A3F02276287DD540BC4C17E246DFB850260D8','RELEASED','2022-01-31 21:43:38',0),
+('2022_02_28_00_characters_2020_09_27_00_characters.sql','2292A1ED0E7F46DEC41384F75FA6D9461464EEB8','RELEASED','2022-02-28 12:43:58',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql b/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql
new file mode 100644
index 00000000000..fb648b58528
--- /dev/null
+++ b/sql/updates/characters/master/2022_02_28_00_characters_2020_09_27_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `auctionhouse` ADD `serverFlags` tinyint unsigned NOT NULL DEFAULT '0' AFTER `endTime`;
-- 
cgit v1.2.3