Advertisement
badlogic

truncate registrar

Apr 7th, 2017
368
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 5.33 KB | None | 0 0
  1. truncate table dps_registrar_db.file_applicant_submitted_reqt_header_2016_2017;
  2. truncate table dps_registrar_db.file_assessment_data_2016_2017;
  3. truncate table dps_registrar_db.file_assessment_data_dues_history_2016_2017;
  4. truncate table dps_registrar_db.file_assessment_data_fees_2016_2017;
  5. truncate table dps_registrar_db.file_assessment_data_fees_history_2016_2017;
  6. truncate table dps_registrar_db.file_assessment_data_history_2016_2017;
  7. truncate table dps_registrar_db.file_assessment_data_incentive_2016_2017;
  8. truncate table dps_registrar_db.file_assessment_data_incentive_history_2016_2017;
  9. truncate table dps_registrar_db.file_assessment_data_incentive_history_2016_2017;
  10. truncate table dps_registrar_db.file_assessment_historyfrom_dues;
  11. truncate table dps_registrar_db.file_assessment_historyfrom_studinfo;
  12. truncate table dps_registrar_db.file_break_schedule_2016_2017;
  13. truncate table dps_registrar_db.file_class_schedule_details_2016_2017;
  14. truncate table dps_registrar_db.file_class_schedule_header_2016_2017;
  15. truncate table dps_registrar_db.file_class_setup_2016_2017;
  16. truncate table dps_registrar_db.file_collection_details;
  17. truncate table dps_registrar_db.file_exam_sched_header_2016_2017;
  18. truncate table dps_registrar_db.file_interview_sched_header_2016_2017;
  19. truncate table dps_registrar_db.file_payscheme_breakdown_details;
  20. truncate table dps_registrar_db.file_payscheme_breakdown_header;
  21. truncate table dps_registrar_db.file_permit_to_enroll_2016_2017;
  22. truncate table dps_registrar_db.file_sectioning_details_2016_2017;
  23. truncate table dps_registrar_db.file_sectioning_details_temp_2016_2017;
  24. truncate table dps_registrar_db.file_sectioning_header_2015_2016;
  25. truncate table dps_registrar_db.file_section_2016_2017;
  26. truncate table dps_registrar_db.file_stream_class_details_2016_2017;
  27. truncate table dps_registrar_db.student_applicant_information;
  28. truncate table dps_registrar_db.student_admission_info_2016_2017;
  29. truncate table dps_registrar_db.student_applicant_photo;
  30.  
  31. SET foreign_key_checks = 0;
  32. DROP TABLE `file_applicant_submitted_reqt_2010_2011`, `file_applicant_submitted_reqt_2011_2012`, `file_applicant_submitted_reqt_2012_2013`, `file_applicant_submitted_reqt_2013_2014`, `file_applicant_submitted_reqt_2014_2015`, `file_break_schedule_2010_2011`, `file_break_schedule_2011_2012`, `file_break_schedule_2012_2013`, `file_break_schedule_2013_2014`, `file_break_schedule_2014_2015`, `file_class_schedule_details_2010_2011`, `file_class_schedule_details_2011_2012`, `file_class_schedule_details_2012_2013`, `file_class_schedule_details_2013_2014`, `file_class_schedule_details_2014_2015`, `file_class_schedule_header_2010_2011`, `file_class_schedule_header_2011_2012`, `file_class_schedule_header_2012_2013`, `file_class_schedule_header_2013_2014`, `file_class_schedule_header_2014_2015`, `file_class_setup_2010_2011`, `file_class_setup_2011_2012`, `file_class_setup_2012_2013`, `file_class_setup_2013_2014`, `file_class_setup_2014_2015`, `file_exam_sched_header_2010_2011`, `file_exam_sched_header_2011_2012`, `file_exam_sched_header_2012_2013`, `file_exam_sched_header_2013_2014`, `file_exam_sched_header_2014_2015`, `file_interview_sched_header_2010_2011`, `file_interview_sched_header_2011_2012`, `file_interview_sched_header_2012_2013`, `file_interview_sched_header_2013_2014`, `file_interview_sched_header_2014_2015`, `file_permit_to_enroll_2010_2011`, `file_permit_to_enroll_2011_2012`, `file_permit_to_enroll_2012_2013`, `file_permit_to_enroll_2013_2014`, `file_permit_to_enroll_2014_2015`, `file_sectioning_details_2008_2009`, `file_sectioning_details_2009_2010`, `file_sectioning_details_2010_2011`, `file_sectioning_details_2011_2012`, `file_sectioning_details_2012_2013`, `file_sectioning_details_2013_2014`, `file_sectioning_details_2014_2015`, `file_sectioning_details_temp_2010_2011`, `file_sectioning_details_temp_2011_2012`, `file_sectioning_details_temp_2012_2013`, `file_sectioning_details_temp_2013_2014`, `file_sectioning_details_temp_2014_2015`, `file_sectioning_header_2010_2011`, `file_sectioning_header_2011_2012`, `file_sectioning_header_2012_2013`, `file_sectioning_header_2013_2014`, `file_section_2008_2009`, `file_section_2009_2010`, `file_section_2010_2011`, `file_section_2011_2012`, `file_section_2012_2013`, `file_section_2013_2014`, `file_section_2014_2015`, `file_stream_class_details_2010_2011`, `file_stream_class_details_2011_2012`, `file_stream_class_details_2012_2013`, `file_stream_class_details_2013_2014`, `file_stream_class_details_2014_2015`, `file_stream_class_header_2010_2011`, `file_stream_class_header_2011_2012`, `file_stream_class_header_2012_2013`, `file_stream_class_header_2013_2014`, `file_stream_class_header_2014_2015`, `stream_subject_2010_2011`, `stream_subject_2011_2012`, `stream_subject_2012_2013`, `stream_subject_2013_2014`, `stream_subject_2014_2015`, `stream_subject_assign_2010_2011`, `stream_subject_assign_2011_2012`, `stream_subject_assign_2012_2013`, `stream_subject_assign_2013_2014`, `stream_subject_assign_2014_2015`, `student_admission_exam_2012_2013`, `student_admission_exam_2013_2014`, `student_admission_exam_2014_2015`, `student_admission_info_2010_2011`, `student_admission_info_2011_2012`, `student_admission_info_2012_2013`, `student_admission_info_2013_2014`, `student_admission_info_2014_2015`, `student_admission_interview_2012_2013`, `student_admission_interview_2013_2014`, `student_admission_interview_2014_2015`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement