diff options
| -rw-r--r-- | data/sql/updates/db_world/2021_09_27_01.sql | 45 | ||||
| -rw-r--r-- | data/sql/updates/pending_db_world/rev_1632235858441614200.sql | 19 |
2 files changed, 45 insertions, 19 deletions
diff --git a/data/sql/updates/db_world/2021_09_27_01.sql b/data/sql/updates/db_world/2021_09_27_01.sql new file mode 100644 index 0000000000..ae1cc822d2 --- /dev/null +++ b/data/sql/updates/db_world/2021_09_27_01.sql @@ -0,0 +1,45 @@ +-- DB update 2021_09_27_00 -> 2021_09_27_01 +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 = '2021_09_27_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_09_27_00 2021_09_27_01 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1632235858441614200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + +INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1632235858441614200'); + +UPDATE + `creature_loot_template` +SET + `Chance` = + (CASE + WHEN `Entry` = 7438 THEN 7 + WHEN `Entry` = 7439 THEN 7 + WHEN `Entry` = 7440 THEN 8 + WHEN `Entry` = 7441 THEN 8 + WHEN `Entry` = 7442 THEN 8 + WHEN `Entry` = 10199 THEN 7 + WHEN `Entry` = 10916 THEN 6 + END) +WHERE + `Item` = 12820 +AND + `Entry` IN (7438, 7439, 7440, 7441, 7442, 10199, 10916); + +-- +-- END UPDATING QUERIES +-- +UPDATE version_db_world SET date = '2021_09_27_01' WHERE sql_rev = '1632235858441614200'; +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1632235858441614200.sql b/data/sql/updates/pending_db_world/rev_1632235858441614200.sql deleted file mode 100644 index e9bd2c6e1f..0000000000 --- a/data/sql/updates/pending_db_world/rev_1632235858441614200.sql +++ /dev/null @@ -1,19 +0,0 @@ -INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1632235858441614200'); - -UPDATE - `creature_loot_template` -SET - `Chance` = - (CASE - WHEN `Entry` = 7438 THEN 7 - WHEN `Entry` = 7439 THEN 7 - WHEN `Entry` = 7440 THEN 8 - WHEN `Entry` = 7441 THEN 8 - WHEN `Entry` = 7442 THEN 8 - WHEN `Entry` = 10199 THEN 7 - WHEN `Entry` = 10916 THEN 6 - END) -WHERE - `Item` = 12820 -AND - `Entry` IN (7438, 7439, 7440, 7441, 7442, 10199, 10916); |