diff options
| -rw-r--r-- | data/sql/updates/db_world/2017_05_01_06.sql (renamed from data/sql/updates/pending_db_world/rev_1492282283733328800.sql) | 24 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2017_05_01_07.sql (renamed from data/sql/updates/pending_db_world/rev_1492287920969760300.sql) | 24 |
2 files changed, 48 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1492282283733328800.sql b/data/sql/updates/db_world/2017_05_01_06.sql index c00d222217..407cbbd5ee 100644 --- a/data/sql/updates/pending_db_world/rev_1492282283733328800.sql +++ b/data/sql/updates/db_world/2017_05_01_06.sql @@ -1,3 +1,18 @@ +-- DB update 2017_05_01_05 -> 2017_05_01_06 +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 = '2017_05_01_05'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_05_01_05 2017_05_01_06 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1492282283733328800'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- INSERT INTO version_db_world (`sql_rev`) VALUES ('1492282283733328800'); INSERT INTO version_db_world (`sql_rev`) VALUES ('1492260484544486500'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=56578 AND `ElseGroup`=1; @@ -13,3 +28,12 @@ INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_ DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=30337 AND `SourceEntry`=43671; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (18, 30337, 43671, 0, 0, 9, 0, 13069, 0, 0, 0, 0, 0, '', "Spellclick requires Active (taken) quest Shoot 'Em Up."); +-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; diff --git a/data/sql/updates/pending_db_world/rev_1492287920969760300.sql b/data/sql/updates/db_world/2017_05_01_07.sql index 65bca40325..3b6406b963 100644 --- a/data/sql/updates/pending_db_world/rev_1492287920969760300.sql +++ b/data/sql/updates/db_world/2017_05_01_07.sql @@ -1,3 +1,18 @@ +-- DB update 2017_05_01_06 -> 2017_05_01_07 +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 = '2017_05_01_06'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2017_05_01_06 2017_05_01_07 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1492287920969760300'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- INSERT INTO version_db_world (`sql_rev`) VALUES ('1492287920969760300'); -- Burning Skeleton SAI SET @ENTRY := 31048; @@ -9,3 +24,12 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (@ENTRY,0,2,3,31,0,100,0,58593,0,0,0,86,58599,2,23,0,0,0,1,0,0,0,0,0,0,0,"Burning Skeleton - On Target Spellhit 'Skeleton Check' - Cross Cast 'Abom Credit'"), (@ENTRY,0,3,4,61,0,100,0,58593,0,0,0,28,58594,0,0,0,0,0,1,0,0,0,0,0,0,0,"Burning Skeleton - On Target Spellhit 'Skeleton Check' - Remove Aura 'Skeleton Check Master'"), (@ENTRY,0,4,0,61,0,100,0,58593,0,0,0,11,58596,0,0,0,0,0,1,0,0,0,0,0,0,0,"Burning Skeleton - On Target Spellhit 'Skeleton Check' - Cast 'Abomination Explosion'"); +-- +-- END UPDATING QUERIES +-- +COMMIT; +END; +// +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; |