create schema code;
alter table code_gb.academic_levels set schema code;
alter table code_gb.compatriot_types set schema code;
alter table code_gb.countries set schema code;
alter table code_gb.degree_levels set schema code;
alter table code_gb.degrees set schema code;
alter table code_gb.discipline_categories set schema code;
alter table code_gb.divisions set schema code;
alter table code_gb.duty_grades set schema code;
alter table code_gb.duty_types set schema code;
alter table code_gb.education_degrees set schema code;
alter table code_gb.education_results set schema code;
alter table code_gb.employ_types set schema code;
alter table code_gb.family_relationships set schema code;
alter table code_gb.genders set schema code;
alter table code_gb.health_statuses set schema code;
alter table code_gb.id_types set schema code;
alter table code_gb.job_statuses set schema code;
alter table code_gb.language_abilities set schema code;
alter table code_gb.languages set schema code;
alter table code_gb.marital_statuses set schema code;
alter table code_gb.nations set schema code;
alter table code_gb.political_statuses set schema code;
alter table code_gb.post_grades set schema code;
alter table code_gb.post_types set schema code;
alter table code_gb.professional_grades set schema code;
alter table code_gb.professional_titles set schema code;
alter table code_gb.religions set schema code;
alter table code_gb.study_types set schema code;
alter table code_hb.activity_types set schema code;
alter table code_hb.admission_types set schema code;
alter table code_hb.blood_types set schema code;
alter table code_hb.book_categories set schema code;
alter table code_hb.building_types set schema code;
alter table code_hb.classroom_types set schema code;
alter table code_hb.course_take_types set schema code;
alter table code_hb.day_parts set schema code;
alter table code_hb.difficulty_causes set schema code;
alter table code_hb.difficulty_degrees set schema code;
alter table code_hb.discipline_catalogs set schema code;
alter table code_hb.disciplines set schema code;
alter table code_hb.edu_categories set schema code;
alter table code_hb.education_levels set schema code;
alter table code_hb.education_modes set schema code;
alter table code_hb.election_modes set schema code;
alter table code_hb.enroll_modes set schema code;
alter table code_hb.exam_forms set schema code;
alter table code_hb.exam_modes set schema code;
alter table code_hb.exam_statuses set schema code;
alter table code_hb.exam_types set schema code;
alter table code_hb.family_categories set schema code;
alter table code_hb.fee_origins set schema code;
alter table code_hb.grade_types set schema code;
alter table code_hb.grading_modes set schema code;
alter table code_hb.household_types set schema code;
alter table code_hb.hsk_levels set schema code;
alter table code_hb.institutions set schema code;
alter table code_hb.passport_types set schema code;
alter table code_hb.press_grades set schema code;
alter table code_hb.presses set schema code;
alter table code_hb.publication_grades set schema code;
alter table code_hb.publications set schema code;
alter table code_hb.railway_stations set schema code;
alter table code_hb.room_types set schema code;
alter table code_hb.social_unit_types set schema code;
alter table code_hb.staff_source_types set schema code;
alter table code_hb.staff_types set schema code;
alter table code_hb.std_alter_reasons set schema code;
alter table code_hb.std_alter_types set schema code;
alter table code_hb.student_statuses set schema code;
alter table code_hb.teach_lang_types set schema code;
alter table code_hb.tutor_types set schema code;
alter table code_hb.uee_subject_types set schema code;
alter table code_hb.std_punishment_types set schema code;
alter table code_hb.student_punishment_types set schema code;
alter table code_hb.uncheckin_reasons set schema code;
alter table code_hb.unregistered_reasons set schema code;
alter table code_hb.visa_types set schema code;
alter table code_hb.work_statuses set schema code;

alter table edu_base.book_award_types set schema base;
alter table edu_base.book_types set schema base;
alter table edu_base.calendar_stages set schema base;
alter table edu_base.calendars set schema base;
alter table edu_base.classrooms set schema base;
alter table edu_base.classrooms_departs set schema base;
alter table edu_base.classrooms_projects set schema base;
alter table edu_base.course_ability_rates set schema base;
alter table edu_base.course_categories set schema base;
alter table edu_base.course_hour_types set schema base;
alter table edu_base.course_hours set schema base;
alter table edu_base.course_types set schema base;
alter table edu_base.course_units set schema base;
alter table edu_base.courses set schema base;
alter table edu_base.courses_ability_rates set schema base;
alter table edu_base.courses_grading_modes set schema base;
alter table edu_base.courses_levels set schema base;
alter table edu_base.courses_majors set schema base;
alter table edu_base.courses_teachers set schema base;
alter table edu_base.courses_textbooks set schema base;
alter table edu_base.courses_xmajors set schema base;
alter table edu_base.direction_journals set schema base;
alter table edu_base.directions set schema base;
alter table edu_base.instructors set schema base;
alter table edu_base.major_disciplines set schema base;
alter table edu_base.major_journals set schema base;
alter table edu_base.majors set schema base;
alter table edu_base.project_codes set schema base;
alter table edu_base.projects set schema base;
alter table edu_base.projects_calendars set schema base;
alter table edu_base.projects_campuses set schema base;
alter table edu_base.projects_departments set schema base;
alter table edu_base.projects_levels set schema base;
alter table edu_base.projects_properties set schema base;
alter table edu_base.projects_std_labels set schema base;
alter table edu_base.projects_std_types set schema base;
alter table edu_base.school_lengths set schema base;
alter table edu_base.semester_stages set schema base;
alter table edu_base.semesters set schema base;
alter table edu_base.squads set schema base;
alter table edu_base.std_label_types set schema base;
alter table edu_base.std_labels set schema base;
alter table edu_base.std_types set schema base;
alter table edu_base.student_states set schema base;
alter table edu_base.students set schema base;
alter table edu_base.students_labels set schema base;
alter table edu_base.teacher_types set schema base;
alter table edu_base.teachers set schema base;
alter table edu_base.teachers_projects set schema base;
alter table edu_base.teaching_groups set schema base;
alter table edu_base.teaching_groups_members set schema base;
alter table edu_base.textbooks set schema base;
alter table edu_base.time_settings set schema base;
create schema edu;
alter table edu_clazz.clazz_groups set schema edu;
alter table edu_clazz.clazz_tags set schema edu;
alter table edu_clazz.clazzes set schema edu;
alter table edu_clazz.clazzes_ability_rates set schema edu;
alter table edu_clazz.clazzes_tags set schema edu;
alter table edu_clazz.clazzes_teachers set schema edu;
alter table edu_clazz.course_takers set schema edu;
alter table edu_clazz.restriction_items set schema edu;
alter table edu_clazz.restrictions set schema edu;
alter table edu_clazz.sessions set schema edu;
alter table edu_clazz.sessions_rooms set schema edu;
alter table edu_clazz.sessions_teachers set schema edu;
alter table edu_clazz.std_course_abilities set schema edu;

alter table edu_course.course_profiles set schema edu;
alter table edu_course.syllabus_files set schema edu;
alter table edu_course.syllabuses set schema edu;

alter table edu_evaluation.clazz_eval_stats set schema edu;
alter table edu_evaluation.clazz_option_stats set schema edu;
alter table edu_evaluation.clazz_question_stats set schema edu;
alter table edu_evaluation.clazz_question_type_stats set schema edu;
alter table edu_evaluation.course_eval_stats set schema edu;
alter table edu_evaluation.course_option_stats set schema edu;
alter table edu_evaluation.course_question_stats set schema edu;
alter table edu_evaluation.course_question_type_stats set schema edu;
alter table edu_evaluation.depart_eval_stats set schema edu;
alter table edu_evaluation.depart_option_stats set schema edu;
alter table edu_evaluation.depart_question_stats set schema edu;
alter table edu_evaluation.depart_question_type_stats set schema edu;
alter table edu_evaluation.evaluate_results set schema edu;
alter table edu_evaluation.evaluation_criteria_items set schema edu;
alter table edu_evaluation.evaluation_criterias set schema edu;
alter table edu_evaluation.final_teacher_scores set schema edu;
alter table edu_evaluation.option_groups set schema edu;
alter table edu_evaluation.options set schema edu;
alter table edu_evaluation.question_results set schema edu;
alter table edu_evaluation.question_types set schema edu;
alter table edu_evaluation.questionnaire_clazzes set schema edu;
alter table edu_evaluation.questionnaires set schema edu;
alter table edu_evaluation.questionnaires_questions set schema edu;
alter table edu_evaluation.questions set schema edu;
alter table edu_evaluation.school_eval_stats set schema edu;
alter table edu_evaluation.school_option_stats set schema edu;
alter table edu_evaluation.school_question_stats set schema edu;
alter table edu_evaluation.school_question_type_stats set schema edu;
alter table edu_evaluation.teacher_eval_stats set schema edu;
alter table edu_evaluation.teacher_option_stats set schema edu;
alter table edu_evaluation.teacher_question_stats set schema edu;
alter table edu_evaluation.teacher_question_type_stats set schema edu;
alter table edu_evaluation.teacher_remessages set schema edu;
alter table edu_evaluation.teacher_remessages_students set schema edu;
alter table edu_evaluation.text_evaluations set schema edu;

alter table edu_exam.exam_activities set schema edu;
alter table edu_exam.exam_activities_rooms set schema edu;
alter table edu_exam.exam_groups set schema edu;
alter table edu_exam.exam_groups_rooms set schema edu;
alter table edu_exam.exam_rooms set schema edu;
alter table edu_exam.exam_rooms_activities set schema edu;
alter table edu_exam.exam_takers set schema edu;
alter table edu_exam.exam_tasks set schema edu;
alter table edu_exam.exam_tasks_rooms set schema edu;
alter table edu_exam.exam_turns set schema edu;
alter table edu_exam.final_makeup_courses set schema edu;
alter table edu_exam.final_makeup_courses_squads set schema edu;
alter table edu_exam.final_makeup_takers set schema edu;
alter table edu_exam.invigilation_clazz_quotas set schema edu;
alter table edu_exam.invigilation_quota_details set schema edu;
alter table edu_exam.invigilation_quotas set schema edu;
alter table edu_exam.invigilation_quotas_excludes set schema edu;
alter table edu_exam.invigilations set schema edu;
alter table edu_exam.room_alloc_settings set schema edu;
alter table edu_exam.room_groups set schema edu;
alter table edu_exam.room_groups_rooms set schema edu;

alter table edu_extern.certificate_categories set schema edu;
alter table edu_extern.certificate_grades set schema edu;
alter table edu_extern.certificate_grades_courses set schema edu;
alter table edu_extern.certificate_subjects set schema edu;
alter table edu_extern.exchange_grades set schema edu;
alter table edu_extern.exchange_grades_courses set schema edu;
alter table edu_extern.exchange_schools set schema edu;
alter table edu_extern.exchange_students set schema edu;
alter table edu_extern.exemption_credits set schema edu;

alter table edu_grade.course_audit_results set schema edu;
alter table edu_grade.course_grade_states set schema edu;
alter table edu_grade.course_grades set schema edu;
alter table edu_grade.exam_grade_states set schema edu;
alter table edu_grade.exam_grades set schema edu;
alter table edu_grade.ga_grade_states set schema edu;
alter table edu_grade.ga_grades set schema edu;
alter table edu_grade.grade_rate_configs set schema edu;
alter table edu_grade.grade_rate_items set schema edu;
alter table edu_grade.group_audit_results set schema edu;
alter table edu_grade.moral_grades set schema edu;
alter table edu_grade.plan_audit_results set schema edu;
alter table edu_grade.std_gpas set schema edu;
alter table edu_grade.std_semester_gpas set schema edu;
alter table edu_grade.std_year_gpas set schema edu;

create schema std;
alter table edu_graduation.degree_applies set schema std;
alter table edu_graduation.degree_audit_items set schema std;
alter table edu_graduation.degree_results set schema std;
alter table edu_graduation.graduate_audit_items set schema std;
alter table edu_graduation.graduate_results set schema std;
alter table edu_graduation.graduate_sessions set schema std;

alter table edu_lesson.lecture_plans set schema edu;
alter table edu_lesson.lessons set schema edu;
alter table edu_lesson.lessons_rooms set schema edu;
alter table edu_lesson.lessons_teachers set schema edu;

alter table edu_program.execution_course_groups set schema edu;
alter table edu_program.execution_plan_courses set schema edu;
alter table edu_program.execution_plans set schema edu;
alter table edu_program.major_alt_courses set schema edu;
alter table edu_program.major_alt_courses_news set schema edu;
alter table edu_program.major_alt_courses_olds set schema edu;
alter table edu_program.major_course_groups set schema edu;
alter table edu_program.major_plan_courses set schema edu;
alter table edu_program.major_plans set schema edu;
alter table edu_program.program_doc_metas set schema edu;
alter table edu_program.program_doc_sections set schema edu;
alter table edu_program.program_doc_templates set schema edu;
alter table edu_program.program_doc_templates_types set schema edu;
alter table edu_program.program_docs set schema edu;
alter table edu_program.programs set schema edu;
alter table edu_program.share_course_groups set schema edu;
alter table edu_program.share_plan_courses set schema edu;
alter table edu_program.share_plans set schema edu;
alter table edu_program.std_alt_courses set schema edu;
alter table edu_program.std_alt_courses_news set schema edu;
alter table edu_program.std_alt_courses_olds set schema edu;
alter table edu_program.std_course_groups set schema edu;
alter table edu_program.std_plan_courses set schema edu;
alter table edu_program.std_plans set schema edu;
alter table edu_program.term_campuses set schema edu;

alter table edu_room.apply_depart_checks set schema edu;
alter table edu_room.apply_final_checks set schema edu;
alter table edu_room.available_times set schema edu;
alter table edu_room.occupancies set schema edu;
alter table edu_room.room_applies set schema edu;
alter table edu_room.room_applies_times set schema edu;
alter table edu_room.user_apps set schema edu;

alter table edu_textbook.clazz_book_stats set schema edu;
alter table edu_textbook.materials set schema edu;
alter table edu_textbook.materials_books set schema edu;
alter table edu_textbook.std_book_orders set schema edu;

alter table edu_workload.capacity_factors set schema edu;
alter table edu_workload.factor_segments set schema edu;
alter table edu_workload.teaching_loads set schema edu;
alter table edu_workload.teaching_loads_clazz_tags set schema edu;

create schema hr;
alter table hr_base.duty_infoes set schema hr;
alter table hr_base.education_infoes set schema hr;
alter table hr_base.family_members set schema hr;
alter table hr_base.healths set schema hr;
alter table hr_base.post_infoes set schema hr;
alter table hr_base.staff_states set schema hr;
alter table hr_base.staffs set schema hr;
alter table hr_base.title_infoes set schema hr;
alter table hr_base.tutor_infoes set schema hr;
alter table hr_base.work_infoes set schema hr;
alter table hr_contact.addresses set schema hr;
alter table hr_contact.contacts set schema hr;
alter table hr_contact.emails set schema hr;
alter table hr_contact.geos set schema hr;
alter table hr_contact.impps set schema hr;
alter table hr_contact.nicknames set schema hr;
alter table hr_contact.notes set schema hr;
alter table hr_contact.orgs set schema hr;
alter table hr_contact.photos set schema hr;
alter table hr_contact.relateds set schema hr;
alter table hr_contact.roles set schema hr;
alter table hr_contact.telephones set schema hr;
alter table hr_contact.timezones set schema hr;
alter table hr_contact.titles set schema hr;
alter table hr_contact.urls set schema hr;
alter table hr_contact.xtendeds set schema hr;

alter table hr_profile.teacher_blogs set schema hr;
alter table hr.teacher_blogs rename to teacher_profiles;

create schema prac;
alter table prac_innovation.batches set schema prac;
alter table prac_innovation.closure_review_details set schema prac;
alter table prac_innovation.closure_review_groups set schema prac;
alter table prac_innovation.closure_review_groups_experts set schema prac;
alter table prac_innovation.closure_reviews set schema prac;
alter table prac_innovation.closures set schema prac;
alter table prac_innovation.experts set schema prac;
alter table prac_innovation.init_review_details set schema prac;
alter table prac_innovation.init_review_groups set schema prac;
alter table prac_innovation.init_review_groups_experts set schema prac;
alter table prac_innovation.init_reviews set schema prac;
alter table prac_innovation.introes set schema prac;
alter table prac_innovation.level_jounals set schema prac;
alter table prac_innovation.materials set schema prac;
alter table prac_innovation.members set schema prac;
alter table prac_innovation.project_categories set schema prac;
alter table prac_innovation.project_levels set schema prac;
alter table prac_innovation.project_states set schema prac;
alter table prac_innovation.projects set schema prac;
alter table prac_innovation.projects_instructors set schema prac;
alter table prac_innovation.stage_types set schema prac;
alter table prac_innovation.stages set schema prac;
create schema sin;
alter table sin_harvest.assume_roles set schema sin;
alter table sin_harvest.harvest_types set schema sin;
alter table sin_harvest.literature_members set schema sin;
alter table sin_harvest.literatures set schema sin;
alter table sin_harvest.published_ranges set schema sin;
alter table sin_harvest.published_situations set schema sin;
alter table sin_harvest.researchers set schema sin;
alter table sin_harvest.thesis_harvests set schema sin;

alter table std_alter.std_alteration_items set schema std;
alter table std_alter.std_alterations set schema std;
alter table std_fee.bills set schema std;
alter table std_fee.fee_types set schema std;
alter table std_fee.orders set schema std;
alter table std_fee.tuition_configs set schema std;
alter table std_info.admissions set schema std;
alter table std_info.contacts set schema std;
alter table std_info.education_records set schema std;
alter table std_info.examinees set schema std;
alter table std_info.examinees_scores set schema std;
alter table std_info.graduations set schema std;
alter table std_info.homes set schema std;
alter table std_info.social_relations set schema std;
alter table std_register.registers set schema std;
alter table std_transfer.transfer_applies set schema std;
alter table std_transfer.transfer_options set schema std;
alter table std_transfer.transfer_schemes set schema std;
alter table std_transfer.transfer_scopes set schema std;
alter table std_transfer.transfer_scopes_grades set schema std;
alter table std_transfer.transfer_scopes_majors set schema std;
create schema stu;
alter table stu_award.honor_categories set schema stu;
alter table stu_award.honor_levels set schema stu;
alter table stu_award.honor_types set schema stu;
alter table stu_award.scholarship_awards set schema stu;
alter table stu_award.scholarship_categories set schema stu;
alter table stu_award.scholarship_levels set schema stu;
alter table stu_award.scholarship_types set schema stu;
alter table stu_award.std_honor_awards set schema stu;
alter table stu_award.stipend_awards set schema stu;
alter table stu_award.stipend_categories set schema stu;
alter table stu_award.stipend_levels set schema stu;
alter table stu_award.subsidy_awards set schema stu;
alter table stu_award.subsidy_categories set schema stu;
alter table stu_award.subsidy_levels set schema stu;
alter table stu_job.employment_statuses set schema stu;
alter table stu_job.graduate_sessions set schema stu;
alter table stu_job.graduates set schema stu;
alter table stu_job.std_employments set schema stu;
