DROP TABLE #__js_job_ages;
DROP TABLE #__js_job_careerlevels;
DROP TABLE #__js_job_experiences;
DROP TABLE #__js_job_departments;
DROP TABLE #__js_job_shortlistcandidates;
DROP TABLE #__js_job_employerpackages;
DROP TABLE #__js_job_employerpaymenthistory;
DROP TABLE #__js_job_jobseekerpackages;
DROP TABLE #__js_job_jobseekerpaymenthistory;
DROP TABLE #__js_job_salaryrangetypes;
DROP TABLE #__js_job_categories;
DROP TABLE #__js_job_salaryrange;
DROP TABLE #__js_job_jobs;
DROP TABLE #__js_job_jobapply;
DROP TABLE #__js_job_resume;
DROP TABLE #__js_job_countries;
DROP TABLE #__js_job_states;
DROP TABLE #__js_job_counties;
DROP TABLE #__js_job_cities;
DROP TABLE #__js_job_zips;
DROP TABLE #__js_job_config;
DROP TABLE #__js_job_companies;
DROP TABLE #__js_job_jobsearches;
DROP TABLE #__js_job_jobstatus;
DROP TABLE #__js_job_jobtypes;
DROP TABLE #__js_job_shifts;
DROP TABLE #__js_job_coverletters;
DROP TABLE #__js_job_emailtemplates;
DROP TABLE #__js_job_fieldsordering;
DROP TABLE #__js_job_filters;
DROP TABLE #__js_job_heighesteducation;
DROP TABLE #__js_job_resumesearches;
DROP TABLE #__js_job_roles;
DROP TABLE #__js_job_userfields;
DROP TABLE #__js_job_userfieldvalues;
DROP TABLE #__js_job_userfield_data;
DROP TABLE #__js_job_userroles;
DROP TABLE #__js_job_subcategories;

DROP VIEW IF EXiSTS `view_resumes`; 
DROP VIEW IF EXiSTS `exportresume`;