TDB 925.22071 - 2022/07/25TDB925.22071

5 files changed, 1 insertions, 53 deletions

diff --git a/sql/updates/characters/master/2022_03_11_00_characters_2021_07_18_00_characters.sql b/sql/updates/characters/master/2022_03_11_00_characters_2021_07_18_00_characters.sql
deleted file mode 100644
index e3ad3e1131b..00000000000
--- a/sql/updates/characters/master/2022_03_11_00_characters_2021_07_18_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
---
-ALTER TABLE `item_loot_items` ADD COLUMN `item_index` int(10) unsigned NOT NULL DEFAULT '0' AFTER `item_count`;
diff --git a/sql/updates/characters/master/2022_06_01_00_characters.sql b/sql/updates/characters/master/2022_06_01_00_characters.sql
deleted file mode 100644
index 4da2051ad0c..00000000000
--- a/sql/updates/characters/master/2022_06_01_00_characters.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-ALTER TABLE `gm_complaint`
-  ADD `reportType` int NOT NULL DEFAULT '0' AFTER `complaintType`,
-  ADD `reportMajorCategory` int NOT NULL DEFAULT '0' AFTER `reportType`,
-  ADD `reportMinorCategoryFlags` int NOT NULL DEFAULT '0' AFTER `reportMajorCategory`;
-
-UPDATE `gm_complaint` SET `reportType`=0,`reportMajorCategory`=0,`reportMinorCategoryFlags`=0x1 WHERE `complaintType`=2;
-UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=3,`reportMinorCategoryFlags`=0x800 WHERE `complaintType`=4;
-UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=2,`reportMinorCategoryFlags`=0x40 WHERE `complaintType`=15;
-UPDATE `gm_complaint` SET `reportType`=1,`reportMajorCategory`=3,`reportMinorCategoryFlags`=0x1000 WHERE `complaintType`=23;
-UPDATE `gm_complaint` SET `reportType`=0,`reportMajorCategory`=0,`reportMinorCategoryFlags`=0x4 WHERE `complaintType`=24;
-
-ALTER TABLE `gm_complaint` DROP `complaintType`;
diff --git a/sql/updates/characters/master/2022_07_03_00_characters.sql b/sql/updates/characters/master/2022_07_03_00_characters.sql
deleted file mode 100644
index 11ed0f7e42c..00000000000
--- a/sql/updates/characters/master/2022_07_03_00_characters.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE `character_queststatus_seasonal` ADD `completedTime` bigint NOT NULL DEFAULT '0' AFTER `event`;
-
-UPDATE `character_queststatus_seasonal` SET `completedTime` = UNIX_TIMESTAMP();
-
-DELETE FROM `worldstates` WHERE `entry` BETWEEN 1 AND 85;
diff --git a/sql/updates/characters/master/2022_07_14_00_characters.sql b/sql/updates/characters/master/2022_07_14_00_characters.sql
deleted file mode 100644
index 078ce489de8..00000000000
--- a/sql/updates/characters/master/2022_07_14_00_characters.sql
+++ /dev/null
@@ -1,33 +0,0 @@
---
--- Table structure for table `world_state_value`
---
-DROP TABLE IF EXISTS `world_state_value`;
-CREATE TABLE `world_state_value` (
-  `Id` int NOT NULL,
-  `Value` int NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-
---
--- Table structure for table `world_state_value`
---
-DROP TABLE IF EXISTS `world_variable`;
-CREATE TABLE `world_variable` (
-  `ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Value` int NOT NULL DEFAULT '0',
-  PRIMARY KEY (`ID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-
-INSERT INTO `world_state_value` SELECT `entry`, `value` FROM `worldstates` WHERE `entry` NOT BETWEEN 20001 AND 20009 AND `entry` <> 20050;
-
-INSERT INTO `world_variable` SELECT 'NextCurrencyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20001;
-INSERT INTO `world_variable` SELECT 'NextWeeklyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20002;
-INSERT INTO `world_variable` SELECT 'NextBGRandomDailyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20003;
-INSERT INTO `world_variable` SELECT 'PersistentCharacterCleanFlags', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20004;
-INSERT INTO `world_variable` SELECT 'NextGuildDailyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20006;
-INSERT INTO `world_variable` SELECT 'NextMonthlyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20007;
-INSERT INTO `world_variable` SELECT 'NextDailyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20008;
-INSERT INTO `world_variable` SELECT 'NextOldCalendarEventDeletionTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20009;
-INSERT INTO `world_variable` SELECT 'NextGuildWeeklyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20050;
-
-DROP TABLE `worldstates`;
diff --git a/sql/updates/characters/master/2022_03_06_00_characters.sql b/sql/updates/characters/master/2022_07_25_00_characters.sql
index 9af77726636..0c96a338dc2 100644
--- a/sql/updates/characters/master/2022_03_06_00_characters.sql
+++ b/sql/updates/characters/master/2022_07_25_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 920.22031 characters
+-- TDB 925.22071 characters
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED');