Migration from PowerDNS to PowerDNS REST module

SET @powerdnsrest = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.powerdns_rest.php'),
@powerdns = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.powerdns.php'),
@server_group = (SELECT `id` FROM hb_server_groups WHERE module = IF(@powerdnsrest IS NOT NULL, @powerdnsrest, @powerdns)),
@serv = (SELECT `id` FROM hb_servers WHERE group_id = @server_group AND `default` = 1);
UPDATE hb_accounts a LEFT JOIN hb_products_modules pm ON (a.product_id = pm.product_id)
SET a.server_id = @serv WHERE pm.module = @powerdns;
UPDATE hb_server_groups g, hb_servers s, hb_products_modules p
SET g.`module` = IF(@powerdnsrest IS NOT NULL, @powerdnsrest, @powerdns),
s.`default_module` = IF(@powerdnsrest IS NOT NULL, @powerdnsrest, @powerdns),
p.`module` = IF(@powerdnsrest IS NOT NULL, @powerdnsrest, @powerdns),
p.`server` = @serv
WHERE g.`module` = @powerdns AND s.`default_module` = @powerdns AND p.`module` = @powerdns;

mysql;

use {$database_name};