Skip to content

CDB SQL snippets

craigmcchesney edited this page Jul 16, 2020 · 1 revision

Direct SQL for CDB database tables. Use at your own risk!! Highly recommended to not use these on a production system without testing on a mirror first!

delete cable catalog items (cable types):

delete from item_element_property where item_element_id in (select id from item_element where parent_item_id in (select id from item where domain_id = 7));

delete from item_element where parent_item_id in (select id from item where domain_id = 7);

delete from item_item_category where item_id in (select id from item where domain_id = 7);

delete from item where domain_id = 7;

delete cable designs:

delete from item_element_property where item_element_id in (select id from item_element where parent_item_id in (select id from item where domain_id = 9));

delete from item_element_relationship where second_item_element_id in (select id from item_element where parent_item_id in (select id from item where domain_id = 9));

delete from item_element where parent_item_id in (select id from item where domain_id = 9);

delete from item_item_category where item_id in (select id from item where domain_id = 9);

delete from item_item_project where item_id in (select id from item where domain_id = 9);

delete from item where domain_id = 9;

Clone this wiki locally