DELETE FROM service WHERE short_name='hudson';

DROP TABLE plugin_hudson_job;
DROP TABLE plugin_hudson_widget;

DELETE FROM reference_group 
WHERE reference_id IN (SELECT id FROM reference WHERE service_short_name='hudson');

DELETE FROM reference WHERE service_short_name='hudson';
DELETE FROM service WHERE short_name='hudson';

DELETE FROM layouts_contents WHERE name like 'plugin_hudson_%';
