You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
db-schema/db_scripts/diff/15038.down

9 lines
282 B

USE provisioning;
DELETE FROM xmlhostgroups
WHERE group_id IN (SELECT id FROM xmlgroups WHERE name = 'pbx')
AND host_id IN (SELECT id FROM xmlhosts WHERE description = 'Sems-PBX');
DELETE FROM xmlhosts WHERE description = 'Sems-PBX';
DELETE FROM xmlgroups WHERE name = 'pbx';