ratkosrb
22 lines
1.6 KiB
SQL
22 lines
1.6 KiB
SQL
DROP PROCEDURE IF EXISTS add_migration;
|
|
delimiter ??
|
|
CREATE PROCEDURE `add_migration`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20240123220218');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20240123220218');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Don't interrupt spell casting to enrage.
|
|
UPDATE `creature_ai_events` SET `event_flags`=(`event_flags` | 4) WHERE `id` IN (265001, 261902, 264301, 279101, 829703, 897903, 960503, 977901, 246404, 111801, 69801, 859801, 69902, 1534103, 139302, 43202, 58703, 59701, 69401, 70101, 1188001, 224901, 372701, 876101, 467201, 467301, 467504, 201402, 201301, 201201, 201102, 1174702, 184103, 180202, 178201, 651301, 169603, 921602, 925901, 926801, 971602, 1149605, 1432204, 1432505, 1609801, 1624403, 1644703, 732701, 732901, 733201, 526702, 75101, 69704, 1135204, 1184002, 1194603, 1212101, 1212201, 1476205, 1476305, 1476405, 1476505, 1477205, 1477305, 1477605, 1477705, 1538703, 1468202, 382501, 393201, 429502, 430306, 438501, 467002, 467102, 467403, 472602, 485101, 485502, 525802, 529501, 529601, 534602, 546501, 547001, 70201, 632905, 58801, 67102, 539901, 717502, 732002, 732801, 773001, 780801, 820102, 821602, 887701, 895601, 895702, 895802, 904202, 945402, 991601, 1037303, 1040504, 1048803, 1139103, 1144203, 1145104, 1146903, 1204603, 1234701, 1237902, 1257902, 1280202, 1280305, 1422501, 1434401, 1523302, 1525204, 1553703, 1144401, 127392, 1554201, 1482101, 1449101, 1080701, 745401, 745101, 744901, 743301, 329605, 1430404, 595304, 1020002, 59501, 1562301, 712001);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|