# MySQL dump of database 'CRM Development' on host 'localhost'
# Backup Date and Time: 2018-06-28 06:18 pm
# Module name : Extended CRM
# Module Author : Kvvaradha
# http://www.kvcodes.com
# Company: CRM Development
# User : Administrator
# Compatibility: 2.4.1

SET SQL_MODE='';

# Table Backups CRM Kvcodes

#------------------------------------------------------------------------------------
DROP TABLE IF EXISTS `0_custom_fields`;
DROP TABLE IF EXISTS `0_custom_headers`;
DROP TABLE IF EXISTS `0_kv_crm_activities`;
DROP TABLE IF EXISTS `0_email_log`;
DROP TABLE IF EXISTS `0_kv_crm_attachments`;
DROP TABLE IF EXISTS `0_kv_crm_comments`;
DROP TABLE IF EXISTS `0_kv_crm_country`;
DROP TABLE IF EXISTS `0_kv_crm_email_templates`;
DROP TABLE IF EXISTS `0_kv_crm_leads`;
DROP TABLE IF EXISTS `0_kv_crm_opportunities`;
DROP TABLE IF EXISTS `0_kv_crm_option`;
DROP TABLE IF EXISTS `0_kv_crm_picklist`;
DROP TABLE IF EXISTS `0_kv_crm_picklist_values`;
DROP TABLE IF EXISTS `0_kv_crm_sales_order_details`;
DROP TABLE IF EXISTS `0_kv_crm_roles`;
DROP TABLE IF EXISTS `0_kv_crm_projects`;
DROP TABLE IF EXISTS `0_kv_crm_projectmembers`;
DROP TABLE IF EXISTS `0_kv_crm_sales_orders`;
DROP TABLE IF EXISTS `0_kv_crm_status`;
DROP TABLE IF EXISTS `0_kv_crm_status_types`;
DROP TABLE IF EXISTS `0_kv_crm_tasks`;
DROP TABLE IF EXISTS `0_kv_crm_taskstimers`;

DROP TABLE IF EXISTS `0_kv_crm_tickets`;
DROP TABLE IF EXISTS `0_kv_crm_tickets_replies`;

DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 33;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 34;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 36;