TRUNCATE TABLE `business`;
TRUNCATE TABLE `business_component`;
TRUNCATE TABLE `business_entity`;
TRUNCATE TABLE `business_field`;
TRUNCATE TABLE `business_index`;
TRUNCATE TABLE `business_table`;
TRUNCATE TABLE `business_operation`;
TRUNCATE TABLE `business_page`;
TRUNCATE TABLE `business_group`;


TRUNCATE TABLE assist_software_product;
TRUNCATE TABLE assist_software_product_version;
TRUNCATE TABLE contract;
TRUNCATE TABLE contract_approval;
TRUNCATE TABLE contract_approval_finance;
TRUNCATE TABLE contract_approval_media;
TRUNCATE TABLE contract_finance;
TRUNCATE TABLE contract_media;
TRUNCATE TABLE contract_payment_term;
TRUNCATE TABLE customer;
TRUNCATE TABLE customer_contact;
TRUNCATE TABLE customer_product;
TRUNCATE TABLE customer_sales;
TRUNCATE TABLE customer_support;
TRUNCATE TABLE project;
TRUNCATE TABLE project_payment_term;
TRUNCATE TABLE project_plan;
TRUNCATE TABLE project_plan_node;
TRUNCATE TABLE project_plan_template;
TRUNCATE TABLE project_plan_template_cat;
TRUNCATE TABLE project_plan_template_node;
TRUNCATE TABLE project_task;
TRUNCATE TABLE project_task_deliverable;
TRUNCATE TABLE project_task_notice;
TRUNCATE TABLE project_task_objective;
TRUNCATE TABLE project_task_report;
TRUNCATE TABLE project_task_step;
TRUNCATE TABLE project_task_template;
TRUNCATE TABLE project_task_template_node;
TRUNCATE TABLE project_team;
TRUNCATE TABLE support_order;
TRUNCATE TABLE support_order_media;

UPDATE project SET `project_plan_id` = 0; 

TRUNCATE TABLE `project_plan`;

TRUNCATE TABLE  `project_plan_node`;

TRUNCATE TABLE `project_plan_node_deliverable`;

TRUNCATE TABLE `project_plan_node_version`;

TRUNCATE TABLE `project_plan_version`;
