From c722ff3a68ed5e20a765d8055cb464dfaee55b6f Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Tue, 3 Sep 2024 00:52:11 +0000
Subject: TDB 1102.24091 - 2024/09/03

---
 .../characters/master/2024_05_11_00_characters.sql |  3 ---
 .../characters/master/2024_07_31_00_characters.sql |  5 -----
 .../characters/master/2024_08_04_00_characters.sql |  3 ---
 .../characters/master/2024_08_05_00_characters.sql | 23 ----------------------
 .../characters/master/2024_08_26_00_characters.sql |  3 ---
 .../characters/master/2024_09_03_00_characters.sql |  3 +++
 6 files changed, 3 insertions(+), 37 deletions(-)
 delete mode 100644 sql/updates/characters/master/2024_05_11_00_characters.sql
 delete mode 100644 sql/updates/characters/master/2024_07_31_00_characters.sql
 delete mode 100644 sql/updates/characters/master/2024_08_04_00_characters.sql
 delete mode 100644 sql/updates/characters/master/2024_08_05_00_characters.sql
 delete mode 100644 sql/updates/characters/master/2024_08_26_00_characters.sql
 create mode 100644 sql/updates/characters/master/2024_09_03_00_characters.sql

(limited to 'sql/updates/characters')

diff --git a/sql/updates/characters/master/2024_05_11_00_characters.sql b/sql/updates/characters/master/2024_05_11_00_characters.sql
deleted file mode 100644
index 105c3b99fff..00000000000
--- a/sql/updates/characters/master/2024_05_11_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- TDB 1027.24051 characters
-UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
-REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2024_07_31_00_characters.sql b/sql/updates/characters/master/2024_07_31_00_characters.sql
deleted file mode 100644
index 1411b4697dc..00000000000
--- a/sql/updates/characters/master/2024_07_31_00_characters.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE `groups` ADD `pingRestriction` tinyint AFTER `masterLooterGuid`;
-
-UPDATE `groups` SET `pingRestriction`=0;
-
-ALTER TABLE `groups` MODIFY `pingRestriction` tinyint NOT NULL;
diff --git a/sql/updates/characters/master/2024_08_04_00_characters.sql b/sql/updates/characters/master/2024_08_04_00_characters.sql
deleted file mode 100644
index 1a350bcf9a1..00000000000
--- a/sql/updates/characters/master/2024_08_04_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `character_trait_entry` WHERE `Rank`=0;
-
-ALTER TABLE `character_trait_entry` DROP `grantedRanks`;
diff --git a/sql/updates/characters/master/2024_08_05_00_characters.sql b/sql/updates/characters/master/2024_08_05_00_characters.sql
deleted file mode 100644
index cd0d2f167ea..00000000000
--- a/sql/updates/characters/master/2024_08_05_00_characters.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-DELETE
-  ctc,
-  cte,
-  ca
-FROM
-  character_trait_config AS ctc
-  LEFT JOIN (
-    SELECT
-      ctc2.guid AS guid,
-      MIN(ctc2.traitConfigId) AS traitConfigId
-    FROM
-      character_trait_config ctc2
-    WHERE
-      ctc2.type = 3
-    GROUP BY
-      ctc2.guid,
-      ctc2.traitSystemId
-  ) AS minctc ON ctc.guid = minctc.guid AND ctc.traitConfigId = minctc.traitConfigId
-  LEFT JOIN character_trait_entry AS cte ON ctc.guid = cte.guid AND ctc.traitConfigId = cte.traitConfigId
-  LEFT JOIN character_action AS ca ON ctc.guid = ca.guid AND ctc.traitConfigId = ca.traitConfigId
-WHERE
-  ctc.type = 3 AND
-  minctc.traitConfigId IS NULL;
diff --git a/sql/updates/characters/master/2024_08_26_00_characters.sql b/sql/updates/characters/master/2024_08_26_00_characters.sql
deleted file mode 100644
index dedde7070ec..00000000000
--- a/sql/updates/characters/master/2024_08_26_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `item_loot_items` ADD `item_type` tinyint NOT NULL DEFAULT 0 COMMENT 'item or currency' AFTER `container_id`;
-ALTER TABLE `item_loot_items` DROP PRIMARY KEY;
-ALTER TABLE `item_loot_items` ADD PRIMARY KEY (`container_id`,`item_type`,`item_id`);
diff --git a/sql/updates/characters/master/2024_09_03_00_characters.sql b/sql/updates/characters/master/2024_09_03_00_characters.sql
new file mode 100644
index 00000000000..223b65274d7
--- /dev/null
+++ b/sql/updates/characters/master/2024_09_03_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1102.24091 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED');
-- 
cgit v1.2.3