SET FOREIGN_KEY_CHECKS =0;
TRUNCATE TABLE `academic_area`;
TRUNCATE TABLE `access_log`;
TRUNCATE TABLE `activity`;
TRUNCATE TABLE `activity_applied_criterias`;
TRUNCATE TABLE `activity_attachment`;
TRUNCATE TABLE `activity_policy_violations`;
TRUNCATE TABLE `activity_type`;
TRUNCATE TABLE `allowed_pages_by_process`;
TRUNCATE TABLE `article`;
TRUNCATE TABLE `attendance`;
TRUNCATE TABLE `author`;
TRUNCATE TABLE `authority`;
TRUNCATE TABLE `authority_charge`;
TRUNCATE TABLE `book`;
TRUNCATE TABLE `book_author`;
TRUNCATE TABLE `book_category`;
TRUNCATE TABLE `book_copy`;
TRUNCATE TABLE `bus`;
TRUNCATE TABLE `bus_driver`;
TRUNCATE TABLE `bus_shift_year`;
TRUNCATE TABLE `bus_year_user`;
TRUNCATE TABLE `cat_period`;
TRUNCATE TABLE `cat_subject`;
TRUNCATE TABLE `change_reason`;
TRUNCATE TABLE `class_group`;
TRUNCATE TABLE `classroom`;
TRUNCATE TABLE `country`;
TRUNCATE TABLE `course`;
TRUNCATE TABLE `course_director`;
TRUNCATE TABLE `credit_card`;
TRUNCATE TABLE `credits_detail`;
TRUNCATE TABLE `currency`;
TRUNCATE TABLE `current_deferred`;
TRUNCATE TABLE `degree`;
TRUNCATE TABLE `discipline`;
TRUNCATE TABLE `discount`;
TRUNCATE TABLE `discount_payment_concept`;
TRUNCATE TABLE `employee`;
TRUNCATE TABLE `employee_area`;
TRUNCATE TABLE `equipment`;
TRUNCATE TABLE `financial_institution`;
TRUNCATE TABLE `general_activity`;
TRUNCATE TABLE `general_activity_attendees`;
TRUNCATE TABLE `general_discipline_log`;
TRUNCATE TABLE `grade_change_log`;
TRUNCATE TABLE `grade_criteria`;
TRUNCATE TABLE `grade_score_change_log`;
TRUNCATE TABLE `grade_subject_score`;
TRUNCATE TABLE `group_hour`;
TRUNCATE TABLE `group_hour_level`;
TRUNCATE TABLE `group_optional_subject`;
TRUNCATE TABLE `guardian`;
TRUNCATE TABLE `guest`;
TRUNCATE TABLE `hour`;
TRUNCATE TABLE `hour_by_group`;
TRUNCATE TABLE `incident`;
TRUNCATE TABLE `income_stock`;
TRUNCATE TABLE `invoice`;
TRUNCATE TABLE `invoice_detail`;
TRUNCATE TABLE `item_category`;
TRUNCATE TABLE `language`;
TRUNCATE TABLE `level`;
TRUNCATE TABLE `level_optional_group`;
TRUNCATE TABLE `level_optional_group_detail`;
TRUNCATE TABLE `level_section_year`;
TRUNCATE TABLE `level_section_year_specialty`;
TRUNCATE TABLE `library_section`;
TRUNCATE TABLE `loan`;
TRUNCATE TABLE `loan_detail`;
TRUNCATE TABLE `maintenance_item`;
TRUNCATE TABLE `master_degree`;
TRUNCATE TABLE `medical_file`;
TRUNCATE TABLE `message`;
TRUNCATE TABLE `message_between_profiles`;
TRUNCATE TABLE `message_thread`;
TRUNCATE TABLE `message_thread_messages`;
TRUNCATE TABLE `ministry_resit_change_log`;
TRUNCATE TABLE `ministry_resit_student`;
TRUNCATE TABLE `ministry_subject`;
TRUNCATE TABLE `nationality`;
TRUNCATE TABLE `opt_activity`;
TRUNCATE TABLE `opt_activity_applied_criterias`;
TRUNCATE TABLE `opt_activity_attachment`;
TRUNCATE TABLE `opt_grade_change_log`;
TRUNCATE TABLE `opt_student_activity_attachment`;
TRUNCATE TABLE `opt_student_criteria_grade`;
TRUNCATE TABLE `opt_subject_period_activity_type`;
TRUNCATE TABLE `opt_subject_retest_change_log`;
TRUNCATE TABLE `opt_subject_year_activity_criteria_period`;
TRUNCATE TABLE `opt_subject_year_grade_criteria`;
TRUNCATE TABLE `optional_subject`;
TRUNCATE TABLE `optional_subject_level`;
TRUNCATE TABLE `optional_subject_period`;
TRUNCATE TABLE `optional_subject_retest`;
TRUNCATE TABLE `optional_subject_retest_student`;
TRUNCATE TABLE `payment_agreement_group`;
TRUNCATE TABLE `payment_concept`;
TRUNCATE TABLE `payment_detail`;
TRUNCATE TABLE `payment_method`;
TRUNCATE TABLE `period`;
TRUNCATE TABLE `period_group_year`;
TRUNCATE TABLE `pre_registration`;
TRUNCATE TABLE `pre_registration_period`;
TRUNCATE TABLE `pre_registration_required_documment`;
TRUNCATE TABLE `process`;
TRUNCATE TABLE `profile`;
TRUNCATE TABLE `profile_process`;
TRUNCATE TABLE `provider`;
TRUNCATE TABLE `psychological_file`;
TRUNCATE TABLE `qualifying_document`;
TRUNCATE TABLE `qualitative_equivalence`;
TRUNCATE TABLE `request_detail`;
TRUNCATE TABLE `resit_change_log`;
TRUNCATE TABLE `resit_student`;
TRUNCATE TABLE `route`;
TRUNCATE TABLE `schedule`;
TRUNCATE TABLE `school_setup`;
TRUNCATE TABLE `school_year`;
TRUNCATE TABLE `section`;
TRUNCATE TABLE `section_by_year`;
TRUNCATE TABLE `shift`;
TRUNCATE TABLE `special_grade_change_log`;
TRUNCATE TABLE `specialty`;
TRUNCATE TABLE `state`;
TRUNCATE TABLE `stock_request`;
TRUNCATE TABLE `student`;
TRUNCATE TABLE `student_activity_attachment`;
TRUNCATE TABLE `student_by_course`;
TRUNCATE TABLE `student_criteria_grade`;
TRUNCATE TABLE `student_guardian`;
TRUNCATE TABLE `student_optional_subject`;
TRUNCATE TABLE `student_subject_period_average`;
TRUNCATE TABLE `student_year`;
TRUNCATE TABLE `student_year_debts`;
TRUNCATE TABLE `student_year_discount`;
TRUNCATE TABLE `student_year_discount_values`;
TRUNCATE TABLE `student_year_document`;
TRUNCATE TABLE `student_year_special_grade`;
TRUNCATE TABLE `study_place`;
TRUNCATE TABLE `subject`;
TRUNCATE TABLE `subject_course`;
TRUNCATE TABLE `subject_course_period`;
TRUNCATE TABLE `subject_course_retest`;
TRUNCATE TABLE `subject_course_retest_student`;
TRUNCATE TABLE `subject_level_restriction`;
TRUNCATE TABLE `subject_ministry_equivalence`;
TRUNCATE TABLE `subject_period_activity_type`;
TRUNCATE TABLE `subject_retest_change_log`;
TRUNCATE TABLE `subject_year_activity_criteria_period`;
TRUNCATE TABLE `subject_year_grade_criteria`;
TRUNCATE TABLE `syllabus_files`;
TRUNCATE TABLE `syllabus_files_change_log`;
TRUNCATE TABLE `taxes`;
TRUNCATE TABLE `teacher_degree`;
TRUNCATE TABLE `teacher_hours_year`;
TRUNCATE TABLE `teacher_master_degree`;
TRUNCATE TABLE `teacher_specialty`;
TRUNCATE TABLE `university`;
TRUNCATE TABLE `use_destination`;
TRUNCATE TABLE `user`;
TRUNCATE TABLE `user_profile`;
TRUNCATE TABLE `visits_medical_center`;
TRUNCATE TABLE `web_pre_registration`;
TRUNCATE TABLE `web_user`;
TRUNCATE TABLE `year_concept_taxes`;
TRUNCATE TABLE `year_discount`;
TRUNCATE TABLE `year_grade_subject`;
TRUNCATE TABLE `year_level_specialty_payment_concept`;
TRUNCATE TABLE `year_pre_registration_document`;
TRUNCATE TABLE `year_qualifying_document`;
TRUNCATE TABLE `year_report_comment`;
TRUNCATE TABLE `year_resit_exam_ranges`;
TRUNCATE TABLE `year_special_grade`;
TRUNCATE TABLE `year_subject_classroom`;
TRUNCATE TABLE `autoschedule_process`;
TRUNCATE TABLE `autoschedule_process_results`;

SET FOREIGN_KEY_CHECKS =1;
