chore(DB): import pending files

Referenced commit(s): 11debfe63c70abf6ae1da4ca8fb868c3aae20106

2 files changed, 52 insertions, 0 deletions

diff --git a/data/sql/updates/pending_db_world/rev_1640754933928340200.sql b/data/sql/updates/db_world/2022_01_04_04.sql
index a2c55a4fb2..117354a243 100644
--- a/data/sql/updates/pending_db_world/rev_1640754933928340200.sql
+++ b/data/sql/updates/db_world/2022_01_04_04.sql
@@ -1,3 +1,19 @@
+-- DB update 2022_01_04_03 -> 2022_01_04_04
+DROP PROCEDURE IF EXISTS `updateDb`;
+DELIMITER //
+CREATE PROCEDURE updateDb ()
+proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE';
+SELECT COUNT(*) INTO @COLEXISTS
+FROM information_schema.COLUMNS
+WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2022_01_04_03';
+IF @COLEXISTS = 0 THEN LEAVE proc; END IF;
+START TRANSACTION;
+ALTER TABLE version_db_world CHANGE COLUMN 2022_01_04_03 2022_01_04_04 bit;
+SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1640754933928340200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF;
+--
+-- START UPDATING QUERIES
+--
+
 INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1640754933928340200');
 /* Shadowglen Creature Table improvements */
 DELETE FROM `creature` WHERE `guid` IN (46573, 46586, 46715, 46714, 46462, 46461, 46449, 46459, 46438, 47905, 47907, 47922, 47883, 47925, 47660, 47880, 47921, 47900, 47928, 47915, 47926, 47752, 47863, 47911, 47876, 49612, 49617, 49622, 49613, 49614, 49615, 49616, 49621, 49569, 49564, 49611, 49568, 49623, 49570, 49562, 49572, 49561, 49571, 49560, 49563, 49567, 46935, 46928, 46931, 46934, 46926, 46927, 46936, 46920, 46933, 46917, 46916, 46919, 46915, 46932, 46918, 46924, 46912, 46913, 46922, 46921, 49647, 49635, 49627, 49629, 49632, 49630, 49631, 49634, 49637, 49644, 49642, 49638, 49641, 46939, 46944, 46943, 46941, 46938, 46937, 46940, 46957, 46942, 46949, 46955, 46947, 46948, 49566, 46923, 49610, 46929, 46930, 49565, 46925, 49620, 49628, 49648, 46945, 49633, 46952, 49636, 49646, 49626, 46953, 49640, 46954, 49643, 46946, 49639, 49645, 46951, 46950, 47266, 47018, 47021, 47023, 47038, 47062, 47054, 47055, 47010, 47012, 47208, 47037, 47249, 47061, 47060, 47016, 47003, 47017, 47002, 47001, 47262, 47000, 47263, 47057, 46999, 46998, 47056, 47268, 47269, 46997, 46958, 46981, 47271, 47006, 47270, 47053, 46974, 47004, 47029, 47009, 46971, 46972, 47008, 47052, 47039, 47030, 47031, 47267, 47350, 47283, 47290, 47312, 47288, 47289, 47286, 47284, 47281, 47287, 47282, 47285, 47310, 47280, 47342, 47334, 47344, 47314, 47346, 47336, 47329, 47322, 47343, 47338, 47341, 47335, 47345, 47339, 47319, 47340, 47330, 47316, 47315, 47331, 47326, 47321, 47337, 47332, 47333, 47324, 47320, 47325, 47327, 47317, 47328);
@@ -261,3 +277,13 @@ DELETE FROM `waypoint_data` WHERE `id`=@PATH;
 INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
 (@PATH,1,10273.941,963.12164,1340.2665,0,13000,0,0,100,0),
 (@PATH,2,10271.291,964.8906,1340.8572,0,25000,0,0,100,0);
+
+--
+-- END UPDATING QUERIES
+--
+UPDATE version_db_world SET date = '2022_01_04_04' WHERE sql_rev = '1640754933928340200';
+COMMIT;
+END //
+DELIMITER ;
+CALL updateDb();
+DROP PROCEDURE IF EXISTS `updateDb`;
diff --git a/data/sql/updates/pending_db_world/rev_1640901414425887700.sql b/data/sql/updates/db_world/2022_01_04_05.sql
index 948ff05b6b..435dd99972 100644
--- a/data/sql/updates/pending_db_world/rev_1640901414425887700.sql
+++ b/data/sql/updates/db_world/2022_01_04_05.sql
@@ -1,3 +1,19 @@
+-- DB update 2022_01_04_04 -> 2022_01_04_05
+DROP PROCEDURE IF EXISTS `updateDb`;
+DELIMITER //
+CREATE PROCEDURE updateDb ()
+proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE';
+SELECT COUNT(*) INTO @COLEXISTS
+FROM information_schema.COLUMNS
+WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2022_01_04_04';
+IF @COLEXISTS = 0 THEN LEAVE proc; END IF;
+START TRANSACTION;
+ALTER TABLE version_db_world CHANGE COLUMN 2022_01_04_04 2022_01_04_05 bit;
+SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1640901414425887700'; IF OK <> 'FALSE' THEN LEAVE proc; END IF;
+--
+-- START UPDATING QUERIES
+--
+
 INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1640901414425887700');
 -- Pathing for 49855 Ancient Protector Entry: 2041
 -- 0x2044EC002001FE4000001F00004B281D .go xyz 9740.571 930.2613 1295.0767
@@ -134,3 +150,13 @@ INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `p
 (47916, 721, 1, 0, 0, 1, 1, 0, 0, 9766.002, 1003.5132, 1298.7433, 3.922023296356201171, 420, 2.229228, 0, 1, 0, 1, 0, 0, 0, '', 0), -- .go xyz 9766.002 1003.5132 1298.7433
 (47913, 721, 1, 0, 0, 1, 1, 0, 0, 9663.498, 996.78253, 1290.7375, 2.356194496154785156, 420, 2.236296, 0, 1, 0, 1, 0, 0, 0, '', 0), -- .go xyz 9663.498 996.78253 1290.7375
 (47931, 721, 1, 0, 0, 1, 1, 0, 0, 9747.966, 879.4171, 1296.1412, 3.358324289321899414, 420, 2.812372, 0, 1, 0, 1, 0, 0, 0, '', 0); -- .go xyz 9747.966 879.4171 1296.1412
+
+--
+-- END UPDATING QUERIES
+--
+UPDATE version_db_world SET date = '2022_01_04_05' WHERE sql_rev = '1640901414425887700';
+COMMIT;
+END //
+DELIMITER ;
+CALL updateDb();
+DROP PROCEDURE IF EXISTS `updateDb`;