ratkosrb
25 lines
1.3 KiB
SQL
25 lines
1.3 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`='20250613132135');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250613132135');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Delete In Dreams texts (scripted in db years ago).
|
|
DELETE FROM `script_texts` WHERE `entry` IN (-1532000, -1532001, -1532002, -1532003, -1532004, -1532005, -1532006, -1532007, -1532008, -1532009, -1532010, -1532011, -1532012, -1532013, -1532014, -1532015, -1532016, -1532017, -1532018, -1532019, -1532020, -1532021, -1532022, -1532023, -1532024, -1532025, -1532026, -1532027, -1532028, -1532029, -1532030, -1532031, -1532032, -1532033);
|
|
|
|
-- Delete more unused texts.
|
|
DELETE FROM `script_texts` WHERE `entry` IN (-1999927, -1999919, -1900011, -1780312, -1000008, -1780225, -1780224, -1780223, -1780148, -1780147, -1780146, -1780145, -1780144, -1780143, -1780142, -1780141, -1780140, -1780130, -1780129, -1780128, -1780127, -1533158, -1533157, -1533156, -1469002, -1230000, -1189018, -1189017, -1189016, -1033015, -1001019, -1000510, -1000350, -1000349, -1000348, -1000200, -1000199, -1000198, -1000187, -1000175, -1000005);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|