# MySQL dump of database 'HRM Demo' on host 'localhost'
# Backup Date and Time: 2018-08-02 01:11 pm
# Module name : Extended HRM
# Module Author : Kvvaradha
# http://www.kvcodes.com
# Company: Kvcodes 
# User : Administrator
# Compatibility: 2.4.1

SET SQL_MODE='';

# Table  hrm_kvcodes

#------------------------------------------------------------------------------------

 DROP TABLE IF EXISTS 0_kv_empl_advance_payments;
 DROP TABLE IF EXISTS 0_kv_empl_allowance_advanced;
 DROP TABLE IF EXISTS 0_kv_empl_allowances;
 DROP TABLE IF EXISTS 0_kv_empl_attendance_settings;
 DROP TABLE IF EXISTS 0_kv_empl_allowances_coa;
 DROP TABLE IF EXISTS 0_kv_empl_appraisal;
 DROP TABLE IF EXISTS 0_kv_empl_attendancee;
 DROP TABLE IF EXISTS 0_kv_empl_attendance;
 DROP TABLE IF EXISTS 0_kv_empl_country;
 DROP TABLE IF EXISTS 0_kv_empl_cv;
 DROP TABLE IF EXISTS 0_kv_empl_candidates;
 DROP TABLE IF EXISTS 0_kv_empl_degree;
 DROP TABLE IF EXISTS 0_kv_empl_departments;
 DROP TABLE IF EXISTS 0_kv_empl_designation;
 DROP TABLE IF EXISTS 0_kv_empl_designation_group;
 DROP TABLE IF EXISTS 0_kv_empl_doc_type;
 DROP TABLE IF EXISTS 0_kv_empl_employment_types;
 DROP TABLE IF EXISTS 0_kv_empl_emails;
 DROP TABLE IF EXISTS 0_kv_empl_esb;
 DROP TABLE IF EXISTS 0_kv_empl_esic_pf;
 DROP TABLE IF EXISTS 0_kv_empl_experience;
 DROP TABLE IF EXISTS 0_kv_empl_gosi_settings;
 DROP TABLE IF EXISTS 0_kv_empl_history;
 DROP TABLE IF EXISTS 0_kv_empl_family;
 DROP TABLE IF EXISTS 0_kv_empl_gazetted_holidays;
 DROP TABLE IF EXISTS 0_kv_empl_grade;
 DROP TABLE IF EXISTS 0_kv_empl_info;
 DROP TABLE IF EXISTS 0_kv_empl_job;
 DROP TABLE IF EXISTS 0_kv_empl_leave_days;
 DROP TABLE IF EXISTS 0_kv_empl_leave_travel;
 DROP TABLE IF EXISTS 0_kv_empl_leave_types;
 DROP TABLE IF EXISTS 0_kv_empl_leave_applied;
 DROP TABLE IF EXISTS 0_kv_empl_leave_encashment;
 DROP TABLE IF EXISTS 0_kv_empl_license;
 DROP TABLE IF EXISTS 0_kv_empl_license_type;
 DROP TABLE IF EXISTS 0_kv_empl_lmra_fees;
 DROP TABLE IF EXISTS 0_kv_empl_loan;
 DROP TABLE IF EXISTS 0_kv_empl_loan_types;
 DROP TABLE IF EXISTS 0_kv_empl_loan_repayment;
 DROP TABLE IF EXISTS 0_kv_empl_medical_premium;
 DROP TABLE IF EXISTS 0_kv_empl_memo;
 DROP TABLE IF EXISTS 0_kv_empl_nationalities;
 DROP TABLE IF EXISTS 0_kv_empl_option;
 DROP TABLE IF EXISTS 0_kv_empl_petrol;
 DROP TABLE IF EXISTS 0_kv_empl_pick_type;
 DROP TABLE IF EXISTS 0_kv_empl_picklist;
 DROP TABLE IF EXISTS 0_kv_empl_salary;
 DROP TABLE IF EXISTS 0_kv_empl_salary_advance;
 DROP TABLE IF EXISTS 0_kv_empl_shifts;
 DROP TABLE IF EXISTS 0_kv_empl_status_types;
 DROP TABLE IF EXISTS 0_kv_empl_taxes;
 DROP TABLE IF EXISTS 0_kv_empl_skills;
 DROP TABLE IF EXISTS 0_kv_empl_allowance_advanced;
 DROP TABLE IF EXISTS 0_kv_empl_tax_types;
 DROP TABLE IF EXISTS 0_kv_empl_training;
 DROP TABLE IF EXISTS 0_kv_empl_travel;
 DROP TABLE IF EXISTS 0_kv_empl_visa_exp;
 DROP TABLE IF EXISTS 0_custom_fields;
 DROP TABLE IF EXISTS 0_custom_headers;
 
 
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 97;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 98;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 99;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 100;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 101;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 102;
DELETE FROM `0_reflines` WHERE `0_reflines`.`trans_type` = 103;


# -------------------------------------------------------------------------------------
