fixup_blacklistref
CREATE PROCEDURE fixup_blacklistref( )
BEGIN
DECLARE bl_id int; SELECT MIN(ipblacklist_id) INTO bl_id FROM ipblacklist WHERE ipblacklistref_id = 0 OR ipblacklistref_id IS NULL ; WHILE bl_id IS NOT NULL DO INSERT INTO ipblacklistref () VALUES () ; UPDATE ipblacklist SET ipblacklistref_id = LAST_INSERT_ID() WHERE ipblacklist_id = bl_id ; SELECT MIN(ipblacklist_id) INTO bl_id FROM ipblacklist WHERE ipblacklistref_id = 0 OR ipblacklistref_id IS NULL ; END WHILE; SELECT MIN(ipblacklistrange_id) INTO bl_id FROM ipblacklistrange WHERE ipblacklistref_id = 0 OR ipblacklistref_id IS NULL ; WHILE bl_id IS NOT NULL DO INSERT INTO ipblacklistref () VALUES () ; UPDATE ipblacklistrange SET ipblacklistref_id = LAST_INSERT_ID() WHERE ipblacklistrange_id = bl_id ; SELECT MIN(ipblacklistrange_id) INTO bl_id FROM ipblacklistrange WHERE ipblacklistref_id = 0 OR ipblacklistref_id IS NULL ; END WHILE;END