rename table GROUPING_ATTENDS to _GROUPING_ATTENDS_;
create table GROUPING_ATTENDS (KEY_GROUPING int(11) not null, KEY_ATTENDS int(11) not null,  primary key (KEY_GROUPING, KEY_ATTENDS), key(KEY_GROUPING), key(KEY_ATTENDS)) type=InnoDB;
insert into GROUPING_ATTENDS (KEY_GROUPING, KEY_ATTENDS) select KEY_GROUPING, KEY_ATTENDS from _GROUPING_ATTENDS_;
drop table _GROUPING_ATTENDS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT int(11) not null, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null,  primary key (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE)) type=InnoDB;
insert into ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE) select KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE from _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table UNIT_NAME_UNIT_NAME_PART to _UNIT_NAME_UNIT_NAME_PART_;
create table UNIT_NAME_UNIT_NAME_PART (KEY_UNIT_NAME_PART int(11) not null, KEY_UNIT_NAME int(11) not null,  primary key (KEY_UNIT_NAME_PART, KEY_UNIT_NAME), key(KEY_UNIT_NAME_PART), key(KEY_UNIT_NAME)) type=InnoDB;
insert into UNIT_NAME_UNIT_NAME_PART (KEY_UNIT_NAME_PART, KEY_UNIT_NAME) select KEY_UNIT_NAME_PART, KEY_UNIT_NAME from _UNIT_NAME_UNIT_NAME_PART_;
drop table _UNIT_NAME_UNIT_NAME_PART_;
rename table EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null, KEY_EXTERNAL_ENROLMENT int(11) not null,  primary key (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_EXTERNAL_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_EXTERNAL_ENROLMENT)) type=InnoDB;
insert into EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_EXTERNAL_ENROLMENT) select KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_EXTERNAL_ENROLMENT from _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null, KEY_ENROLMENT int(11) not null,  primary key (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_ENROLMENT)) type=InnoDB;
insert into ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_ENROLMENT) select KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE, KEY_ENROLMENT from _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table PROPOSAL_BRANCH to _PROPOSAL_BRANCH_;
create table PROPOSAL_BRANCH (KEY_BRANCH int(11) not null, KEY_PROPOSAL int(11) not null,  primary key (KEY_BRANCH, KEY_PROPOSAL), key(KEY_BRANCH), key(KEY_PROPOSAL)) type=InnoDB;
insert into PROPOSAL_BRANCH (KEY_BRANCH, KEY_PROPOSAL) select KEY_BRANCH, KEY_PROPOSAL from _PROPOSAL_BRANCH_;
drop table _PROPOSAL_BRANCH_;
rename table VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR to _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
create table VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR (KEY_CURRICULAR_YEAR int(11) not null, KEY_VALUATION_CURRICULAR_COURSE int(11) not null,  primary key (KEY_CURRICULAR_YEAR, KEY_VALUATION_CURRICULAR_COURSE), key(KEY_CURRICULAR_YEAR), key(KEY_VALUATION_CURRICULAR_COURSE)) type=InnoDB;
insert into VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR (KEY_CURRICULAR_YEAR, KEY_VALUATION_CURRICULAR_COURSE) select KEY_CURRICULAR_YEAR, KEY_VALUATION_CURRICULAR_COURSE from _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
drop table _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
rename table PERSON_ADVISORY to _PERSON_ADVISORY_;
create table PERSON_ADVISORY (KEY_ADVISORY int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_ADVISORY, KEY_PERSON), key(KEY_ADVISORY), key(KEY_PERSON)) type=InnoDB;
insert into PERSON_ADVISORY (KEY_ADVISORY, KEY_PERSON) select KEY_ADVISORY, KEY_PERSON from _PERSON_ADVISORY_;
drop table _PERSON_ADVISORY_;
rename table COURSE_EQUIVALENCY_THEME to _COURSE_EQUIVALENCY_THEME_;
create table COURSE_EQUIVALENCY_THEME (KEY_COURSE_EQUIVALENCY int(11) not null, KEY_THEME int(11) not null,  primary key (KEY_COURSE_EQUIVALENCY, KEY_THEME), key(KEY_COURSE_EQUIVALENCY), key(KEY_THEME)) type=InnoDB;
insert into COURSE_EQUIVALENCY_THEME (KEY_COURSE_EQUIVALENCY, KEY_THEME) select KEY_COURSE_EQUIVALENCY, KEY_THEME from _COURSE_EQUIVALENCY_THEME_;
drop table _COURSE_EQUIVALENCY_THEME_;
rename table PUBLICATION_COLLABORATORS to _PUBLICATION_COLLABORATORS_;
create table PUBLICATION_COLLABORATORS (KEY_RESEARCH_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_RESEARCH_UNIT, KEY_PERSON), key(KEY_RESEARCH_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into PUBLICATION_COLLABORATORS (KEY_RESEARCH_UNIT, KEY_PERSON) select KEY_RESEARCH_UNIT, KEY_PERSON from _PUBLICATION_COLLABORATORS_;
drop table _PUBLICATION_COLLABORATORS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table ANNOUNCEMENT_BOARD_BOOKMARK to _ANNOUNCEMENT_BOARD_BOOKMARK_;
create table ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON), key(KEY_ANNOUNCEMENT_BOARD), key(KEY_PERSON)) type=InnoDB;
insert into ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON) select KEY_ANNOUNCEMENT_BOARD, KEY_PERSON from _ANNOUNCEMENT_BOARD_BOOKMARK_;
drop table _ANNOUNCEMENT_BOARD_BOOKMARK_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table MASTER_DEGREE_PROOF_VERSION_JURY to _MASTER_DEGREE_PROOF_VERSION_JURY_;
create table MASTER_DEGREE_PROOF_VERSION_JURY (KEY_TEACHER int(11) not null, KEY_MASTER_DEGREE_PROOF_VERSION int(11) not null,  primary key (KEY_TEACHER, KEY_MASTER_DEGREE_PROOF_VERSION), key(KEY_TEACHER), key(KEY_MASTER_DEGREE_PROOF_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_PROOF_VERSION_JURY (KEY_TEACHER, KEY_MASTER_DEGREE_PROOF_VERSION) select KEY_TEACHER, KEY_MASTER_DEGREE_PROOF_VERSION from _MASTER_DEGREE_PROOF_VERSION_JURY_;
drop table _MASTER_DEGREE_PROOF_VERSION_JURY_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER (KEY_TEACHER int(11) not null, KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null,  primary key (KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_TEACHER), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER (KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION) select KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION from _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER (KEY_TEACHER int(11) not null, KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null,  primary key (KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_TEACHER), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER (KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION) select KEY_TEACHER, KEY_MASTER_DEGREE_THESIS_DATA_VERSION from _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
rename table COURSE_EQUIVALENCY_THEME to _COURSE_EQUIVALENCY_THEME_;
create table COURSE_EQUIVALENCY_THEME (KEY_THEME int(11) not null, KEY_COURSE_EQUIVALENCY int(11) not null,  primary key (KEY_THEME, KEY_COURSE_EQUIVALENCY), key(KEY_THEME), key(KEY_COURSE_EQUIVALENCY)) type=InnoDB;
insert into COURSE_EQUIVALENCY_THEME (KEY_THEME, KEY_COURSE_EQUIVALENCY) select KEY_THEME, KEY_COURSE_EQUIVALENCY from _COURSE_EQUIVALENCY_THEME_;
drop table _COURSE_EQUIVALENCY_THEME_;
rename table PERSON_NAME_PERSON_NAME_PART to _PERSON_NAME_PERSON_NAME_PART_;
create table PERSON_NAME_PERSON_NAME_PART (KEY_PERSON_NAME_PART int(11) not null, KEY_PERSON_NAME int(11) not null,  primary key (KEY_PERSON_NAME_PART, KEY_PERSON_NAME), key(KEY_PERSON_NAME_PART), key(KEY_PERSON_NAME)) type=InnoDB;
insert into PERSON_NAME_PERSON_NAME_PART (KEY_PERSON_NAME_PART, KEY_PERSON_NAME) select KEY_PERSON_NAME_PART, KEY_PERSON_NAME from _PERSON_NAME_PERSON_NAME_PART_;
drop table _PERSON_NAME_PERSON_NAME_PART_;
rename table STUDENT_GROUP_ATTEND to _STUDENT_GROUP_ATTEND_;
create table STUDENT_GROUP_ATTEND (KEY_ATTENDS int(11) not null, KEY_STUDENT_GROUP int(11) not null,  primary key (KEY_ATTENDS, KEY_STUDENT_GROUP), key(KEY_ATTENDS), key(KEY_STUDENT_GROUP)) type=InnoDB;
insert into STUDENT_GROUP_ATTEND (KEY_ATTENDS, KEY_STUDENT_GROUP) select KEY_ATTENDS, KEY_STUDENT_GROUP from _STUDENT_GROUP_ATTEND_;
drop table _STUDENT_GROUP_ATTEND_;
rename table GROUPING_ATTENDS to _GROUPING_ATTENDS_;
create table GROUPING_ATTENDS (KEY_ATTENDS int(11) not null, KEY_GROUPING int(11) not null,  primary key (KEY_ATTENDS, KEY_GROUPING), key(KEY_ATTENDS), key(KEY_GROUPING)) type=InnoDB;
insert into GROUPING_ATTENDS (KEY_ATTENDS, KEY_GROUPING) select KEY_ATTENDS, KEY_GROUPING from _GROUPING_ATTENDS_;
drop table _GROUPING_ATTENDS_;
rename table WRITTEN_EVALUATION_CONTEXT to _WRITTEN_EVALUATION_CONTEXT_;
create table WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CONTEXT int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CONTEXT), key(KEY_WRITTEN_EVALUATION), key(KEY_CONTEXT)) type=InnoDB;
insert into WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION, KEY_CONTEXT) select KEY_WRITTEN_EVALUATION, KEY_CONTEXT from _WRITTEN_EVALUATION_CONTEXT_;
drop table _WRITTEN_EVALUATION_CONTEXT_;
rename table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION to _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
create table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION int(11) not null, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION), key(KEY_WRITTEN_EVALUATION), key(KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION) select KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION from _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
drop table _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
rename table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE to _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
create table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CURRICULAR_COURSE_SCOPE int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE), key(KEY_WRITTEN_EVALUATION), key(KEY_CURRICULAR_COURSE_SCOPE)) type=InnoDB;
insert into WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE) select KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE from _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
drop table _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD to _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
create table TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD (KEY_TEACHER_SERVICE_DISTRIBUTION int(11) not null, KEY_EXECUTION_PERIOD int(11) not null,  primary key (KEY_TEACHER_SERVICE_DISTRIBUTION, KEY_EXECUTION_PERIOD), key(KEY_TEACHER_SERVICE_DISTRIBUTION), key(KEY_EXECUTION_PERIOD)) type=InnoDB;
insert into TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD (KEY_TEACHER_SERVICE_DISTRIBUTION, KEY_EXECUTION_PERIOD) select KEY_TEACHER_SERVICE_DISTRIBUTION, KEY_EXECUTION_PERIOD from _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
drop table _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
rename table ANNOUNCEMENT_BOARD_BOOKMARK to _ANNOUNCEMENT_BOARD_BOOKMARK_;
create table ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON), key(KEY_ANNOUNCEMENT_BOARD), key(KEY_PERSON)) type=InnoDB;
insert into ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON) select KEY_ANNOUNCEMENT_BOARD, KEY_PERSON from _ANNOUNCEMENT_BOARD_BOOKMARK_;
drop table _ANNOUNCEMENT_BOARD_BOOKMARK_;
rename table ANNOUNCEMENT_BOARD_BOOKMARK to _ANNOUNCEMENT_BOARD_BOOKMARK_;
create table ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON), key(KEY_ANNOUNCEMENT_BOARD), key(KEY_PERSON)) type=InnoDB;
insert into ANNOUNCEMENT_BOARD_BOOKMARK (KEY_ANNOUNCEMENT_BOARD, KEY_PERSON) select KEY_ANNOUNCEMENT_BOARD, KEY_PERSON from _ANNOUNCEMENT_BOARD_BOOKMARK_;
drop table _ANNOUNCEMENT_BOARD_BOOKMARK_;
rename table MASTER_DEGREE_PROOF_VERSION_JURY to _MASTER_DEGREE_PROOF_VERSION_JURY_;
create table MASTER_DEGREE_PROOF_VERSION_JURY (KEY_MASTER_DEGREE_PROOF_VERSION int(11) not null, KEY_TEACHER int(11) not null,  primary key (KEY_MASTER_DEGREE_PROOF_VERSION, KEY_TEACHER), key(KEY_MASTER_DEGREE_PROOF_VERSION), key(KEY_TEACHER)) type=InnoDB;
insert into MASTER_DEGREE_PROOF_VERSION_JURY (KEY_MASTER_DEGREE_PROOF_VERSION, KEY_TEACHER) select KEY_MASTER_DEGREE_PROOF_VERSION, KEY_TEACHER from _MASTER_DEGREE_PROOF_VERSION_JURY_;
drop table _MASTER_DEGREE_PROOF_VERSION_JURY_;
rename table MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY to _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
create table MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY (KEY_MASTER_DEGREE_PROOF_VERSION int(11) not null, KEY_EXTERNAL_CONTRACT int(11) not null,  primary key (KEY_MASTER_DEGREE_PROOF_VERSION, KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_PROOF_VERSION), key(KEY_EXTERNAL_CONTRACT)) type=InnoDB;
insert into MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY (KEY_MASTER_DEGREE_PROOF_VERSION, KEY_EXTERNAL_CONTRACT) select KEY_MASTER_DEGREE_PROOF_VERSION, KEY_EXTERNAL_CONTRACT from _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
drop table _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table NON_AFFILIATED_TEACHER_EXECUTION_COURSE to _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
create table NON_AFFILIATED_TEACHER_EXECUTION_COURSE (KEY_NON_AFFILIATED_TEACHER int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_NON_AFFILIATED_TEACHER, KEY_EXECUTION_COURSE), key(KEY_NON_AFFILIATED_TEACHER), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into NON_AFFILIATED_TEACHER_EXECUTION_COURSE (KEY_NON_AFFILIATED_TEACHER, KEY_EXECUTION_COURSE) select KEY_NON_AFFILIATED_TEACHER, KEY_EXECUTION_COURSE from _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
drop table _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
rename table COMPETENCE_COURSE_DEPARTMENT to _COMPETENCE_COURSE_DEPARTMENT_;
create table COMPETENCE_COURSE_DEPARTMENT (KEY_DEPARTMENT int(11) not null, KEY_COMPETENCE_COURSE int(11) not null,  primary key (KEY_DEPARTMENT, KEY_COMPETENCE_COURSE), key(KEY_DEPARTMENT), key(KEY_COMPETENCE_COURSE)) type=InnoDB;
insert into COMPETENCE_COURSE_DEPARTMENT (KEY_DEPARTMENT, KEY_COMPETENCE_COURSE) select KEY_DEPARTMENT, KEY_COMPETENCE_COURSE from _COMPETENCE_COURSE_DEPARTMENT_;
drop table _COMPETENCE_COURSE_DEPARTMENT_;
rename table DEPARTMENT_DEGREE to _DEPARTMENT_DEGREE_;
create table DEPARTMENT_DEGREE (KEY_DEPARTMENT int(11) not null, KEY_DEGREE int(11) not null,  primary key (KEY_DEPARTMENT, KEY_DEGREE), key(KEY_DEPARTMENT), key(KEY_DEGREE)) type=InnoDB;
insert into DEPARTMENT_DEGREE (KEY_DEPARTMENT, KEY_DEGREE) select KEY_DEPARTMENT, KEY_DEGREE from _DEPARTMENT_DEGREE_;
drop table _DEPARTMENT_DEGREE_;
rename table PERSON_DEPARTMENT to _PERSON_DEPARTMENT_;
create table PERSON_DEPARTMENT (KEY_DEPARTMENT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_DEPARTMENT, KEY_PERSON), key(KEY_DEPARTMENT), key(KEY_PERSON)) type=InnoDB;
insert into PERSON_DEPARTMENT (KEY_DEPARTMENT, KEY_PERSON) select KEY_DEPARTMENT, KEY_PERSON from _PERSON_DEPARTMENT_;
drop table _PERSON_DEPARTMENT_;
rename table EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP to _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
create table EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP (KEY_VIGILANT_GROUP int(11) not null, KEY_EXAM_COORDINATOR int(11) not null,  primary key (KEY_VIGILANT_GROUP, KEY_EXAM_COORDINATOR), key(KEY_VIGILANT_GROUP), key(KEY_EXAM_COORDINATOR)) type=InnoDB;
insert into EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP (KEY_VIGILANT_GROUP, KEY_EXAM_COORDINATOR) select KEY_VIGILANT_GROUP, KEY_EXAM_COORDINATOR from _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
drop table _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
rename table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION to _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
create table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION int(11) not null, KEY_WRITTEN_EVALUATION int(11) not null,  primary key (KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION, KEY_WRITTEN_EVALUATION), key(KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION), key(KEY_WRITTEN_EVALUATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION, KEY_WRITTEN_EVALUATION) select KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION, KEY_WRITTEN_EVALUATION from _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
drop table _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table RECEIPT_ENTRY to _RECEIPT_ENTRY_;
create table RECEIPT_ENTRY (KEY_ENTRY int(11) not null, KEY_RECEIPT int(11) not null,  primary key (KEY_ENTRY, KEY_RECEIPT), key(KEY_ENTRY), key(KEY_RECEIPT)) type=InnoDB;
insert into RECEIPT_ENTRY (KEY_ENTRY, KEY_RECEIPT) select KEY_ENTRY, KEY_RECEIPT from _RECEIPT_ENTRY_;
drop table _RECEIPT_ENTRY_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table WRITTEN_EVALUATION_CONTEXT to _WRITTEN_EVALUATION_CONTEXT_;
create table WRITTEN_EVALUATION_CONTEXT (KEY_CONTEXT int(11) not null, KEY_WRITTEN_EVALUATION int(11) not null,  primary key (KEY_CONTEXT, KEY_WRITTEN_EVALUATION), key(KEY_CONTEXT), key(KEY_WRITTEN_EVALUATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_CONTEXT (KEY_CONTEXT, KEY_WRITTEN_EVALUATION) select KEY_CONTEXT, KEY_WRITTEN_EVALUATION from _WRITTEN_EVALUATION_CONTEXT_;
drop table _WRITTEN_EVALUATION_CONTEXT_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_FUNCTIONALITY_PRINTERS int(11) not null, KEY_UNIT int(11) not null,  primary key (KEY_FUNCTIONALITY_PRINTERS, KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_FUNCTIONALITY_PRINTERS, KEY_UNIT) select KEY_FUNCTIONALITY_PRINTERS, KEY_UNIT from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_EXTERNAL_ENROLMENT int(11) not null, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null,  primary key (KEY_EXTERNAL_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_EXTERNAL_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE)) type=InnoDB;
insert into EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_EXTERNAL_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE) select KEY_EXTERNAL_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE from _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _EXTERNAL_ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table WRITTEN_EVALUATION_CONTEXT to _WRITTEN_EVALUATION_CONTEXT_;
create table WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CONTEXT int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CONTEXT), key(KEY_WRITTEN_EVALUATION), key(KEY_CONTEXT)) type=InnoDB;
insert into WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION, KEY_CONTEXT) select KEY_WRITTEN_EVALUATION, KEY_CONTEXT from _WRITTEN_EVALUATION_CONTEXT_;
drop table _WRITTEN_EVALUATION_CONTEXT_;
rename table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION to _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
create table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION int(11) not null, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION), key(KEY_WRITTEN_EVALUATION), key(KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION) select KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION from _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
drop table _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
rename table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE to _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
create table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CURRICULAR_COURSE_SCOPE int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE), key(KEY_WRITTEN_EVALUATION), key(KEY_CURRICULAR_COURSE_SCOPE)) type=InnoDB;
insert into WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE) select KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE from _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
drop table _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE to _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
create table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE_EQUIVALENCE int(11) not null, KEY_CURRICULAR_COURSE int(11) not null,  primary key (KEY_CURRICULAR_COURSE_EQUIVALENCE, KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_EQUIVALENCE), key(KEY_CURRICULAR_COURSE)) type=InnoDB;
insert into OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE_EQUIVALENCE, KEY_CURRICULAR_COURSE) select KEY_CURRICULAR_COURSE_EQUIVALENCE, KEY_CURRICULAR_COURSE from _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
drop table _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
rename table TEST_PERSON to _TEST_PERSON_;
create table TEST_PERSON (KEY_NEW_TEST int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_NEW_TEST, KEY_PERSON), key(KEY_NEW_TEST), key(KEY_PERSON)) type=InnoDB;
insert into TEST_PERSON (KEY_NEW_TEST, KEY_PERSON) select KEY_NEW_TEST, KEY_PERSON from _TEST_PERSON_;
drop table _TEST_PERSON_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table RECEIPT_ENTRY to _RECEIPT_ENTRY_;
create table RECEIPT_ENTRY (KEY_RECEIPT int(11) not null, KEY_ENTRY int(11) not null,  primary key (KEY_RECEIPT, KEY_ENTRY), key(KEY_RECEIPT), key(KEY_ENTRY)) type=InnoDB;
insert into RECEIPT_ENTRY (KEY_RECEIPT, KEY_ENTRY) select KEY_RECEIPT, KEY_ENTRY from _RECEIPT_ENTRY_;
drop table _RECEIPT_ENTRY_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null, KEY_TEACHER int(11) not null,  primary key (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_TEACHER)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER) select KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER from _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_ASSISTENT_GUIDER_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null, KEY_EXTERNAL_CONTRACT int(11) not null,  primary key (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_EXTERNAL_CONTRACT)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT) select KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT from _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null, KEY_TEACHER int(11) not null,  primary key (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_TEACHER)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER) select KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_TEACHER from _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_GUIDER_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null, KEY_EXTERNAL_CONTRACT int(11) not null,  primary key (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_EXTERNAL_CONTRACT)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER (KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT) select KEY_MASTER_DEGREE_THESIS_DATA_VERSION, KEY_EXTERNAL_CONTRACT from _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
rename table STUDENT_GROUP_ATTEND to _STUDENT_GROUP_ATTEND_;
create table STUDENT_GROUP_ATTEND (KEY_STUDENT_GROUP int(11) not null, KEY_ATTENDS int(11) not null,  primary key (KEY_STUDENT_GROUP, KEY_ATTENDS), key(KEY_STUDENT_GROUP), key(KEY_ATTENDS)) type=InnoDB;
insert into STUDENT_GROUP_ATTEND (KEY_STUDENT_GROUP, KEY_ATTENDS) select KEY_STUDENT_GROUP, KEY_ATTENDS from _STUDENT_GROUP_ATTEND_;
drop table _STUDENT_GROUP_ATTEND_;
rename table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT int(11) not null, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null,  primary key (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE)) type=InnoDB;
insert into ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE) select KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE from _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD to _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
create table TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD (KEY_EXECUTION_PERIOD int(11) not null, KEY_TEACHER_SERVICE_DISTRIBUTION int(11) not null,  primary key (KEY_EXECUTION_PERIOD, KEY_TEACHER_SERVICE_DISTRIBUTION), key(KEY_EXECUTION_PERIOD), key(KEY_TEACHER_SERVICE_DISTRIBUTION)) type=InnoDB;
insert into TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD (KEY_EXECUTION_PERIOD, KEY_TEACHER_SERVICE_DISTRIBUTION) select KEY_EXECUTION_PERIOD, KEY_TEACHER_SERVICE_DISTRIBUTION from _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
drop table _TEACHER_SERVICE_DISTRIBUTION_EXECUTION_PERIOD_;
rename table VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING to _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
create table VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING (KEY_VALUATION_COMPETENCE_COURSE int(11) not null, KEY_VALUATION_GROUPING int(11) not null,  primary key (KEY_VALUATION_COMPETENCE_COURSE, KEY_VALUATION_GROUPING), key(KEY_VALUATION_COMPETENCE_COURSE), key(KEY_VALUATION_GROUPING)) type=InnoDB;
insert into VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING (KEY_VALUATION_COMPETENCE_COURSE, KEY_VALUATION_GROUPING) select KEY_VALUATION_COMPETENCE_COURSE, KEY_VALUATION_GROUPING from _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
drop table _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE to _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
create table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE int(11) not null, KEY_CURRICULAR_COURSE_EQUIVALENCE int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE), key(KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_EQUIVALENCE)) type=InnoDB;
insert into OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE) select KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE from _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
drop table _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
rename table CURRICULAR_COURSE_EXECUTION_COURSE to _CURRICULAR_COURSE_EXECUTION_COURSE_;
create table CURRICULAR_COURSE_EXECUTION_COURSE (KEY_CURRICULAR_COURSE int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE), key(KEY_CURRICULAR_COURSE), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into CURRICULAR_COURSE_EXECUTION_COURSE (KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE) select KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE from _CURRICULAR_COURSE_EXECUTION_COURSE_;
drop table _CURRICULAR_COURSE_EXECUTION_COURSE_;
rename table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP to _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
create table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE int(11) not null, KEY_CURRICULAR_COURSE_GROUP int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP), key(KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_GROUP)) type=InnoDB;
insert into CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP) select KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP from _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
drop table _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
rename table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES to _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
create table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CURRICULAR_COURSE int(11) not null, KEY_CREDITS_DISMISSAL int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL), key(KEY_CURRICULAR_COURSE), key(KEY_CREDITS_DISMISSAL)) type=InnoDB;
insert into CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL) select KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL from _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
drop table _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP to _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
create table EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP (KEY_EXAM_COORDINATOR int(11) not null, KEY_VIGILANT_GROUP int(11) not null,  primary key (KEY_EXAM_COORDINATOR, KEY_VIGILANT_GROUP), key(KEY_EXAM_COORDINATOR), key(KEY_VIGILANT_GROUP)) type=InnoDB;
insert into EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP (KEY_EXAM_COORDINATOR, KEY_VIGILANT_GROUP) select KEY_EXAM_COORDINATOR, KEY_VIGILANT_GROUP from _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
drop table _EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP_;
rename table FILE_TAGGING to _FILE_TAGGING_;
create table FILE_TAGGING (KEY_UNIT_FILE_TAG int(11) not null, KEY_UNIT_FILE int(11) not null,  primary key (KEY_UNIT_FILE_TAG, KEY_UNIT_FILE), key(KEY_UNIT_FILE_TAG), key(KEY_UNIT_FILE)) type=InnoDB;
insert into FILE_TAGGING (KEY_UNIT_FILE_TAG, KEY_UNIT_FILE) select KEY_UNIT_FILE_TAG, KEY_UNIT_FILE from _FILE_TAGGING_;
drop table _FILE_TAGGING_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EXECUTION_COURSE int(11) not null, KEY_EVALUATION int(11) not null,  primary key (KEY_EXECUTION_COURSE, KEY_EVALUATION), key(KEY_EXECUTION_COURSE), key(KEY_EVALUATION)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EXECUTION_COURSE, KEY_EVALUATION) select KEY_EXECUTION_COURSE, KEY_EVALUATION from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table CURRICULAR_COURSE_EXECUTION_COURSE to _CURRICULAR_COURSE_EXECUTION_COURSE_;
create table CURRICULAR_COURSE_EXECUTION_COURSE (KEY_EXECUTION_COURSE int(11) not null, KEY_CURRICULAR_COURSE int(11) not null,  primary key (KEY_EXECUTION_COURSE, KEY_CURRICULAR_COURSE), key(KEY_EXECUTION_COURSE), key(KEY_CURRICULAR_COURSE)) type=InnoDB;
insert into CURRICULAR_COURSE_EXECUTION_COURSE (KEY_EXECUTION_COURSE, KEY_CURRICULAR_COURSE) select KEY_EXECUTION_COURSE, KEY_CURRICULAR_COURSE from _CURRICULAR_COURSE_EXECUTION_COURSE_;
drop table _CURRICULAR_COURSE_EXECUTION_COURSE_;
rename table NON_AFFILIATED_TEACHER_EXECUTION_COURSE to _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
create table NON_AFFILIATED_TEACHER_EXECUTION_COURSE (KEY_EXECUTION_COURSE int(11) not null, KEY_NON_AFFILIATED_TEACHER int(11) not null,  primary key (KEY_EXECUTION_COURSE, KEY_NON_AFFILIATED_TEACHER), key(KEY_EXECUTION_COURSE), key(KEY_NON_AFFILIATED_TEACHER)) type=InnoDB;
insert into NON_AFFILIATED_TEACHER_EXECUTION_COURSE (KEY_EXECUTION_COURSE, KEY_NON_AFFILIATED_TEACHER) select KEY_EXECUTION_COURSE, KEY_NON_AFFILIATED_TEACHER from _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
drop table _NON_AFFILIATED_TEACHER_EXECUTION_COURSE_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PERSISTENT_GROUP_MEMBERS_PERSON to _PERSISTENT_GROUP_MEMBERS_PERSON_;
create table PERSISTENT_GROUP_MEMBERS_PERSON (KEY_PERSISTENT_GROUP_MEMBERS int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_PERSISTENT_GROUP_MEMBERS, KEY_PERSON), key(KEY_PERSISTENT_GROUP_MEMBERS), key(KEY_PERSON)) type=InnoDB;
insert into PERSISTENT_GROUP_MEMBERS_PERSON (KEY_PERSISTENT_GROUP_MEMBERS, KEY_PERSON) select KEY_PERSISTENT_GROUP_MEMBERS, KEY_PERSON from _PERSISTENT_GROUP_MEMBERS_PERSON_;
drop table _PERSISTENT_GROUP_MEMBERS_PERSON_;
rename table VALUATION_TEACHER_VALUATION_GROUPING to _VALUATION_TEACHER_VALUATION_GROUPING_;
create table VALUATION_TEACHER_VALUATION_GROUPING (KEY_VALUATION_TEACHER int(11) not null, KEY_VALUATION_GROUPING int(11) not null,  primary key (KEY_VALUATION_TEACHER, KEY_VALUATION_GROUPING), key(KEY_VALUATION_TEACHER), key(KEY_VALUATION_GROUPING)) type=InnoDB;
insert into VALUATION_TEACHER_VALUATION_GROUPING (KEY_VALUATION_TEACHER, KEY_VALUATION_GROUPING) select KEY_VALUATION_TEACHER, KEY_VALUATION_GROUPING from _VALUATION_TEACHER_VALUATION_GROUPING_;
drop table _VALUATION_TEACHER_VALUATION_GROUPING_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_PROTOCOL int(11) not null, KEY_UNIT int(11) not null,  primary key (KEY_PROTOCOL, KEY_UNIT), key(KEY_PROTOCOL), key(KEY_UNIT)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_PROTOCOL, KEY_UNIT) select KEY_PROTOCOL, KEY_UNIT from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_PROTOCOL int(11) not null, KEY_UNIT int(11) not null,  primary key (KEY_PROTOCOL, KEY_UNIT), key(KEY_PROTOCOL), key(KEY_UNIT)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_PROTOCOL, KEY_UNIT) select KEY_PROTOCOL, KEY_UNIT from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table PROTOCOL_RESPONSIBLE to _PROTOCOL_RESPONSIBLE_;
create table PROTOCOL_RESPONSIBLE (KEY_PROTOCOL int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_PROTOCOL, KEY_PERSON), key(KEY_PROTOCOL), key(KEY_PERSON)) type=InnoDB;
insert into PROTOCOL_RESPONSIBLE (KEY_PROTOCOL, KEY_PERSON) select KEY_PROTOCOL, KEY_PERSON from _PROTOCOL_RESPONSIBLE_;
drop table _PROTOCOL_RESPONSIBLE_;
rename table PROTOCOL_RESPONSIBLE_PARTNER to _PROTOCOL_RESPONSIBLE_PARTNER_;
create table PROTOCOL_RESPONSIBLE_PARTNER (KEY_PROTOCOL int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_PROTOCOL, KEY_PERSON), key(KEY_PROTOCOL), key(KEY_PERSON)) type=InnoDB;
insert into PROTOCOL_RESPONSIBLE_PARTNER (KEY_PROTOCOL, KEY_PERSON) select KEY_PROTOCOL, KEY_PERSON from _PROTOCOL_RESPONSIBLE_PARTNER_;
drop table _PROTOCOL_RESPONSIBLE_PARTNER_;
rename table COURSE_LOAD_SHIFT to _COURSE_LOAD_SHIFT_;
create table COURSE_LOAD_SHIFT (KEY_COURSE_LOAD int(11) not null, KEY_SHIFT int(11) not null,  primary key (KEY_COURSE_LOAD, KEY_SHIFT), key(KEY_COURSE_LOAD), key(KEY_SHIFT)) type=InnoDB;
insert into COURSE_LOAD_SHIFT (KEY_COURSE_LOAD, KEY_SHIFT) select KEY_COURSE_LOAD, KEY_SHIFT from _COURSE_LOAD_SHIFT_;
drop table _COURSE_LOAD_SHIFT_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table SCHEDULE_WORK_SCHEDULE to _SCHEDULE_WORK_SCHEDULE_;
create table SCHEDULE_WORK_SCHEDULE (KEY_WORK_SCHEDULE int(11) not null, KEY_SCHEDULE int(11) not null,  primary key (KEY_WORK_SCHEDULE, KEY_SCHEDULE), key(KEY_WORK_SCHEDULE), key(KEY_SCHEDULE)) type=InnoDB;
insert into SCHEDULE_WORK_SCHEDULE (KEY_WORK_SCHEDULE, KEY_SCHEDULE) select KEY_WORK_SCHEDULE, KEY_SCHEDULE from _SCHEDULE_WORK_SCHEDULE_;
drop table _SCHEDULE_WORK_SCHEDULE_;
rename table SCHEDULE_WORK_SCHEDULE to _SCHEDULE_WORK_SCHEDULE_;
create table SCHEDULE_WORK_SCHEDULE (KEY_SCHEDULE int(11) not null, KEY_WORK_SCHEDULE int(11) not null,  primary key (KEY_SCHEDULE, KEY_WORK_SCHEDULE), key(KEY_SCHEDULE), key(KEY_WORK_SCHEDULE)) type=InnoDB;
insert into SCHEDULE_WORK_SCHEDULE (KEY_SCHEDULE, KEY_WORK_SCHEDULE) select KEY_SCHEDULE, KEY_WORK_SCHEDULE from _SCHEDULE_WORK_SCHEDULE_;
drop table _SCHEDULE_WORK_SCHEDULE_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE to _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
create table OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE int(11) not null, KEY_CURRICULAR_COURSE_EQUIVALENCE int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE), key(KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_EQUIVALENCE)) type=InnoDB;
insert into OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE) select KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_EQUIVALENCE from _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
drop table _OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE_;
rename table CURRICULAR_COURSE_EXECUTION_COURSE to _CURRICULAR_COURSE_EXECUTION_COURSE_;
create table CURRICULAR_COURSE_EXECUTION_COURSE (KEY_CURRICULAR_COURSE int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE), key(KEY_CURRICULAR_COURSE), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into CURRICULAR_COURSE_EXECUTION_COURSE (KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE) select KEY_CURRICULAR_COURSE, KEY_EXECUTION_COURSE from _CURRICULAR_COURSE_EXECUTION_COURSE_;
drop table _CURRICULAR_COURSE_EXECUTION_COURSE_;
rename table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP to _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
create table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE int(11) not null, KEY_CURRICULAR_COURSE_GROUP int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP), key(KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_GROUP)) type=InnoDB;
insert into CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP) select KEY_CURRICULAR_COURSE, KEY_CURRICULAR_COURSE_GROUP from _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
drop table _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
rename table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES to _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
create table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CURRICULAR_COURSE int(11) not null, KEY_CREDITS_DISMISSAL int(11) not null,  primary key (KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL), key(KEY_CURRICULAR_COURSE), key(KEY_CREDITS_DISMISSAL)) type=InnoDB;
insert into CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL) select KEY_CURRICULAR_COURSE, KEY_CREDITS_DISMISSAL from _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
drop table _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table PERSON_NAME_PERSON_NAME_PART to _PERSON_NAME_PERSON_NAME_PART_;
create table PERSON_NAME_PERSON_NAME_PART (KEY_PERSON_NAME int(11) not null, KEY_PERSON_NAME_PART int(11) not null,  primary key (KEY_PERSON_NAME, KEY_PERSON_NAME_PART), key(KEY_PERSON_NAME), key(KEY_PERSON_NAME_PART)) type=InnoDB;
insert into PERSON_NAME_PERSON_NAME_PART (KEY_PERSON_NAME, KEY_PERSON_NAME_PART) select KEY_PERSON_NAME, KEY_PERSON_NAME_PART from _PERSON_NAME_PERSON_NAME_PART_;
drop table _PERSON_NAME_PERSON_NAME_PART_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP to _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
create table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_SCIENTIFIC_AREA int(11) not null, KEY_CURRICULAR_COURSE_GROUP int(11) not null,  primary key (KEY_SCIENTIFIC_AREA, KEY_CURRICULAR_COURSE_GROUP), key(KEY_SCIENTIFIC_AREA), key(KEY_CURRICULAR_COURSE_GROUP)) type=InnoDB;
insert into SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_SCIENTIFIC_AREA, KEY_CURRICULAR_COURSE_GROUP) select KEY_SCIENTIFIC_AREA, KEY_CURRICULAR_COURSE_GROUP from _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
drop table _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
rename table COMPETENCE_COURSE_DEPARTMENT to _COMPETENCE_COURSE_DEPARTMENT_;
create table COMPETENCE_COURSE_DEPARTMENT (KEY_COMPETENCE_COURSE int(11) not null, KEY_DEPARTMENT int(11) not null,  primary key (KEY_COMPETENCE_COURSE, KEY_DEPARTMENT), key(KEY_COMPETENCE_COURSE), key(KEY_DEPARTMENT)) type=InnoDB;
insert into COMPETENCE_COURSE_DEPARTMENT (KEY_COMPETENCE_COURSE, KEY_DEPARTMENT) select KEY_COMPETENCE_COURSE, KEY_DEPARTMENT from _COMPETENCE_COURSE_DEPARTMENT_;
drop table _COMPETENCE_COURSE_DEPARTMENT_;
rename table SHIFT_STUDENT to _SHIFT_STUDENT_;
create table SHIFT_STUDENT (KEY_REGISTRATION int(11) not null, KEY_SHIFT int(11) not null,  primary key (KEY_REGISTRATION, KEY_SHIFT), key(KEY_REGISTRATION), key(KEY_SHIFT)) type=InnoDB;
insert into SHIFT_STUDENT (KEY_REGISTRATION, KEY_SHIFT) select KEY_REGISTRATION, KEY_SHIFT from _SHIFT_STUDENT_;
drop table _SHIFT_STUDENT_;
rename table ANNOUNCEMENT_BOARD_BOOKMARK to _ANNOUNCEMENT_BOARD_BOOKMARK_;
create table ANNOUNCEMENT_BOARD_BOOKMARK (KEY_PERSON int(11) not null, KEY_ANNOUNCEMENT_BOARD int(11) not null,  primary key (KEY_PERSON, KEY_ANNOUNCEMENT_BOARD), key(KEY_PERSON), key(KEY_ANNOUNCEMENT_BOARD)) type=InnoDB;
insert into ANNOUNCEMENT_BOARD_BOOKMARK (KEY_PERSON, KEY_ANNOUNCEMENT_BOARD) select KEY_PERSON, KEY_ANNOUNCEMENT_BOARD from _ANNOUNCEMENT_BOARD_BOOKMARK_;
drop table _ANNOUNCEMENT_BOARD_BOOKMARK_;
rename table TEST_PERSON to _TEST_PERSON_;
create table TEST_PERSON (KEY_PERSON int(11) not null, KEY_NEW_TEST int(11) not null,  primary key (KEY_PERSON, KEY_NEW_TEST), key(KEY_PERSON), key(KEY_NEW_TEST)) type=InnoDB;
insert into TEST_PERSON (KEY_PERSON, KEY_NEW_TEST) select KEY_PERSON, KEY_NEW_TEST from _TEST_PERSON_;
drop table _TEST_PERSON_;
rename table PERSON_ROLE to _PERSON_ROLE_;
create table PERSON_ROLE (KEY_PERSON int(11) not null, KEY_ROLE int(11) not null,  primary key (KEY_PERSON, KEY_ROLE), key(KEY_PERSON), key(KEY_ROLE)) type=InnoDB;
insert into PERSON_ROLE (KEY_PERSON, KEY_ROLE) select KEY_PERSON, KEY_ROLE from _PERSON_ROLE_;
drop table _PERSON_ROLE_;
rename table PERSON_ADVISORY to _PERSON_ADVISORY_;
create table PERSON_ADVISORY (KEY_PERSON int(11) not null, KEY_ADVISORY int(11) not null,  primary key (KEY_PERSON, KEY_ADVISORY), key(KEY_PERSON), key(KEY_ADVISORY)) type=InnoDB;
insert into PERSON_ADVISORY (KEY_PERSON, KEY_ADVISORY) select KEY_PERSON, KEY_ADVISORY from _PERSON_ADVISORY_;
drop table _PERSON_ADVISORY_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_PERSON int(11) not null, KEY_UNIT_SITE int(11) not null,  primary key (KEY_PERSON, KEY_UNIT_SITE), key(KEY_PERSON), key(KEY_UNIT_SITE)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_PERSON, KEY_UNIT_SITE) select KEY_PERSON, KEY_UNIT_SITE from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table PROTOCOL_RESPONSIBLE to _PROTOCOL_RESPONSIBLE_;
create table PROTOCOL_RESPONSIBLE (KEY_PERSON int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_PERSON, KEY_PROTOCOL), key(KEY_PERSON), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_RESPONSIBLE (KEY_PERSON, KEY_PROTOCOL) select KEY_PERSON, KEY_PROTOCOL from _PROTOCOL_RESPONSIBLE_;
drop table _PROTOCOL_RESPONSIBLE_;
rename table PUBLICATION_COLLABORATORS to _PUBLICATION_COLLABORATORS_;
create table PUBLICATION_COLLABORATORS (KEY_PERSON int(11) not null, KEY_RESEARCH_UNIT int(11) not null,  primary key (KEY_PERSON, KEY_RESEARCH_UNIT), key(KEY_PERSON), key(KEY_RESEARCH_UNIT)) type=InnoDB;
insert into PUBLICATION_COLLABORATORS (KEY_PERSON, KEY_RESEARCH_UNIT) select KEY_PERSON, KEY_RESEARCH_UNIT from _PUBLICATION_COLLABORATORS_;
drop table _PUBLICATION_COLLABORATORS_;
rename table PERSON_DEPARTMENT to _PERSON_DEPARTMENT_;
create table PERSON_DEPARTMENT (KEY_PERSON int(11) not null, KEY_DEPARTMENT int(11) not null,  primary key (KEY_PERSON, KEY_DEPARTMENT), key(KEY_PERSON), key(KEY_DEPARTMENT)) type=InnoDB;
insert into PERSON_DEPARTMENT (KEY_PERSON, KEY_DEPARTMENT) select KEY_PERSON, KEY_DEPARTMENT from _PERSON_DEPARTMENT_;
drop table _PERSON_DEPARTMENT_;
rename table PERSISTENT_GROUP_MEMBERS_PERSON to _PERSISTENT_GROUP_MEMBERS_PERSON_;
create table PERSISTENT_GROUP_MEMBERS_PERSON (KEY_PERSON int(11) not null, KEY_PERSISTENT_GROUP_MEMBERS int(11) not null,  primary key (KEY_PERSON, KEY_PERSISTENT_GROUP_MEMBERS), key(KEY_PERSON), key(KEY_PERSISTENT_GROUP_MEMBERS)) type=InnoDB;
insert into PERSISTENT_GROUP_MEMBERS_PERSON (KEY_PERSON, KEY_PERSISTENT_GROUP_MEMBERS) select KEY_PERSON, KEY_PERSISTENT_GROUP_MEMBERS from _PERSISTENT_GROUP_MEMBERS_PERSON_;
drop table _PERSISTENT_GROUP_MEMBERS_PERSON_;
rename table PROTOCOL_RESPONSIBLE_PARTNER to _PROTOCOL_RESPONSIBLE_PARTNER_;
create table PROTOCOL_RESPONSIBLE_PARTNER (KEY_PERSON int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_PERSON, KEY_PROTOCOL), key(KEY_PERSON), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_RESPONSIBLE_PARTNER (KEY_PERSON, KEY_PROTOCOL) select KEY_PERSON, KEY_PROTOCOL from _PROTOCOL_RESPONSIBLE_PARTNER_;
drop table _PROTOCOL_RESPONSIBLE_PARTNER_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_PERSON int(11) not null, KEY_UNIT int(11) not null,  primary key (KEY_PERSON, KEY_UNIT), key(KEY_PERSON), key(KEY_UNIT)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_PERSON, KEY_UNIT) select KEY_PERSON, KEY_UNIT from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table SHIFT_SCHOOL_CLASS to _SHIFT_SCHOOL_CLASS_;
create table SHIFT_SCHOOL_CLASS (KEY_SCHOOL_CLASS int(11) not null, KEY_SHIFT int(11) not null,  primary key (KEY_SCHOOL_CLASS, KEY_SHIFT), key(KEY_SCHOOL_CLASS), key(KEY_SHIFT)) type=InnoDB;
insert into SHIFT_SCHOOL_CLASS (KEY_SCHOOL_CLASS, KEY_SHIFT) select KEY_SCHOOL_CLASS, KEY_SHIFT from _SHIFT_SCHOOL_CLASS_;
drop table _SHIFT_SCHOOL_CLASS_;
rename table AFFINITY_CYCLE_COURSE_GROUP to _AFFINITY_CYCLE_COURSE_GROUP_;
create table AFFINITY_CYCLE_COURSE_GROUP (KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES int(11) not null, KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES int(11) not null,  primary key (KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES, KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES), key(KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES), key(KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES)) type=InnoDB;
insert into AFFINITY_CYCLE_COURSE_GROUP (KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES, KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES) select KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES, KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES from _AFFINITY_CYCLE_COURSE_GROUP_;
drop table _AFFINITY_CYCLE_COURSE_GROUP_;
rename table AFFINITY_CYCLE_COURSE_GROUP to _AFFINITY_CYCLE_COURSE_GROUP_;
create table AFFINITY_CYCLE_COURSE_GROUP (KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES int(11) not null, KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES int(11) not null,  primary key (KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES, KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES), key(KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES), key(KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES)) type=InnoDB;
insert into AFFINITY_CYCLE_COURSE_GROUP (KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES, KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES) select KEY_CYCLE_COURSE_GROUP_DESTINATION_AFFINITIES, KEY_CYCLE_COURSE_GROUP_SOURCE_AFFINITIES from _AFFINITY_CYCLE_COURSE_GROUP_;
drop table _AFFINITY_CYCLE_COURSE_GROUP_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE to _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
create table STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE (KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null, KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN int(11) not null,  primary key (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN), key(KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN)) type=InnoDB;
insert into STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN) select KEY_EQUIVALENCE_PLAN_ENTRY, KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN from _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
drop table _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null, KEY_DEGREE_MODULE int(11) not null,  primary key (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE) select KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null, KEY_DEGREE_MODULE int(11) not null,  primary key (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE) select KEY_EQUIVALENCE_PLAN_ENTRY, KEY_DEGREE_MODULE from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP to _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
create table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP int(11) not null, KEY_SCIENTIFIC_AREA int(11) not null,  primary key (KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA), key(KEY_CURRICULAR_COURSE_GROUP), key(KEY_SCIENTIFIC_AREA)) type=InnoDB;
insert into SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA) select KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA from _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
drop table _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
rename table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP to _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
create table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP int(11) not null, KEY_CURRICULAR_COURSE int(11) not null,  primary key (KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_GROUP), key(KEY_CURRICULAR_COURSE)) type=InnoDB;
insert into CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE) select KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE from _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
drop table _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
rename table PROPOSAL_BRANCH to _PROPOSAL_BRANCH_;
create table PROPOSAL_BRANCH (KEY_PROPOSAL int(11) not null, KEY_BRANCH int(11) not null,  primary key (KEY_PROPOSAL, KEY_BRANCH), key(KEY_PROPOSAL), key(KEY_BRANCH)) type=InnoDB;
insert into PROPOSAL_BRANCH (KEY_PROPOSAL, KEY_BRANCH) select KEY_PROPOSAL, KEY_BRANCH from _PROPOSAL_BRANCH_;
drop table _PROPOSAL_BRANCH_;
rename table MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY to _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
create table MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY (KEY_EXTERNAL_CONTRACT int(11) not null, KEY_MASTER_DEGREE_PROOF_VERSION int(11) not null,  primary key (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_PROOF_VERSION), key(KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_PROOF_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_PROOF_VERSION) select KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_PROOF_VERSION from _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
drop table _MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER (KEY_EXTERNAL_CONTRACT int(11) not null, KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null,  primary key (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION) select KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION from _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER_;
rename table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER to _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
create table MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER (KEY_EXTERNAL_CONTRACT int(11) not null, KEY_MASTER_DEGREE_THESIS_DATA_VERSION int(11) not null,  primary key (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION), key(KEY_EXTERNAL_CONTRACT), key(KEY_MASTER_DEGREE_THESIS_DATA_VERSION)) type=InnoDB;
insert into MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER (KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION) select KEY_EXTERNAL_CONTRACT, KEY_MASTER_DEGREE_THESIS_DATA_VERSION from _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
drop table _MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER_;
rename table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT int(11) not null, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null,  primary key (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE)) type=InnoDB;
insert into ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE) select KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE from _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table WRITTEN_EVALUATION_CONTEXT to _WRITTEN_EVALUATION_CONTEXT_;
create table WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CONTEXT int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CONTEXT), key(KEY_WRITTEN_EVALUATION), key(KEY_CONTEXT)) type=InnoDB;
insert into WRITTEN_EVALUATION_CONTEXT (KEY_WRITTEN_EVALUATION, KEY_CONTEXT) select KEY_WRITTEN_EVALUATION, KEY_CONTEXT from _WRITTEN_EVALUATION_CONTEXT_;
drop table _WRITTEN_EVALUATION_CONTEXT_;
rename table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION to _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
create table WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION int(11) not null, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION), key(KEY_WRITTEN_EVALUATION), key(KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION (KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION) select KEY_WRITTEN_EVALUATION, KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION from _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
drop table _WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION_;
rename table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE to _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
create table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION int(11) not null, KEY_CURRICULAR_COURSE_SCOPE int(11) not null,  primary key (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE), key(KEY_WRITTEN_EVALUATION), key(KEY_CURRICULAR_COURSE_SCOPE)) type=InnoDB;
insert into WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE) select KEY_WRITTEN_EVALUATION, KEY_CURRICULAR_COURSE_SCOPE from _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
drop table _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
rename table EVALUATION_EXECUTION_COURSE to _EVALUATION_EXECUTION_COURSE_;
create table EVALUATION_EXECUTION_COURSE (KEY_EVALUATION int(11) not null, KEY_EXECUTION_COURSE int(11) not null,  primary key (KEY_EVALUATION, KEY_EXECUTION_COURSE), key(KEY_EVALUATION), key(KEY_EXECUTION_COURSE)) type=InnoDB;
insert into EVALUATION_EXECUTION_COURSE (KEY_EVALUATION, KEY_EXECUTION_COURSE) select KEY_EVALUATION, KEY_EXECUTION_COURSE from _EVALUATION_EXECUTION_COURSE_;
drop table _EVALUATION_EXECUTION_COURSE_;
rename table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP to _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
create table SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP int(11) not null, KEY_SCIENTIFIC_AREA int(11) not null,  primary key (KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA), key(KEY_CURRICULAR_COURSE_GROUP), key(KEY_SCIENTIFIC_AREA)) type=InnoDB;
insert into SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA) select KEY_CURRICULAR_COURSE_GROUP, KEY_SCIENTIFIC_AREA from _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
drop table _SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP_;
rename table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP to _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
create table CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP int(11) not null, KEY_CURRICULAR_COURSE int(11) not null,  primary key (KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE), key(KEY_CURRICULAR_COURSE_GROUP), key(KEY_CURRICULAR_COURSE)) type=InnoDB;
insert into CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP (KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE) select KEY_CURRICULAR_COURSE_GROUP, KEY_CURRICULAR_COURSE from _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
drop table _CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP_;
rename table UNIT_NAME_UNIT_NAME_PART to _UNIT_NAME_UNIT_NAME_PART_;
create table UNIT_NAME_UNIT_NAME_PART (KEY_UNIT_NAME int(11) not null, KEY_UNIT_NAME_PART int(11) not null,  primary key (KEY_UNIT_NAME, KEY_UNIT_NAME_PART), key(KEY_UNIT_NAME), key(KEY_UNIT_NAME_PART)) type=InnoDB;
insert into UNIT_NAME_UNIT_NAME_PART (KEY_UNIT_NAME, KEY_UNIT_NAME_PART) select KEY_UNIT_NAME, KEY_UNIT_NAME_PART from _UNIT_NAME_UNIT_NAME_PART_;
drop table _UNIT_NAME_UNIT_NAME_PART_;
rename table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE_;
rename table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE to _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
create table EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_DEGREE_MODULE), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE (KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_DEGREE_MODULE, KEY_EQUIVALENCE_PLAN_ENTRY from _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
drop table _EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE_;
rename table STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE to _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
create table STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE (KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN int(11) not null, KEY_EQUIVALENCE_PLAN_ENTRY int(11) not null,  primary key (KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN, KEY_EQUIVALENCE_PLAN_ENTRY), key(KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN), key(KEY_EQUIVALENCE_PLAN_ENTRY)) type=InnoDB;
insert into STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE (KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN, KEY_EQUIVALENCE_PLAN_ENTRY) select KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN, KEY_EQUIVALENCE_PLAN_ENTRY from _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
drop table _STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE_;
rename table FILE_TAGGING to _FILE_TAGGING_;
create table FILE_TAGGING (KEY_UNIT_FILE int(11) not null, KEY_UNIT_FILE_TAG int(11) not null,  primary key (KEY_UNIT_FILE, KEY_UNIT_FILE_TAG), key(KEY_UNIT_FILE), key(KEY_UNIT_FILE_TAG)) type=InnoDB;
insert into FILE_TAGGING (KEY_UNIT_FILE, KEY_UNIT_FILE_TAG) select KEY_UNIT_FILE, KEY_UNIT_FILE_TAG from _FILE_TAGGING_;
drop table _FILE_TAGGING_;
rename table VALUATION_TEACHER_VALUATION_GROUPING to _VALUATION_TEACHER_VALUATION_GROUPING_;
create table VALUATION_TEACHER_VALUATION_GROUPING (KEY_VALUATION_GROUPING int(11) not null, KEY_VALUATION_TEACHER int(11) not null,  primary key (KEY_VALUATION_GROUPING, KEY_VALUATION_TEACHER), key(KEY_VALUATION_GROUPING), key(KEY_VALUATION_TEACHER)) type=InnoDB;
insert into VALUATION_TEACHER_VALUATION_GROUPING (KEY_VALUATION_GROUPING, KEY_VALUATION_TEACHER) select KEY_VALUATION_GROUPING, KEY_VALUATION_TEACHER from _VALUATION_TEACHER_VALUATION_GROUPING_;
drop table _VALUATION_TEACHER_VALUATION_GROUPING_;
rename table VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING to _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
create table VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING (KEY_VALUATION_GROUPING int(11) not null, KEY_VALUATION_COMPETENCE_COURSE int(11) not null,  primary key (KEY_VALUATION_GROUPING, KEY_VALUATION_COMPETENCE_COURSE), key(KEY_VALUATION_GROUPING), key(KEY_VALUATION_COMPETENCE_COURSE)) type=InnoDB;
insert into VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING (KEY_VALUATION_GROUPING, KEY_VALUATION_COMPETENCE_COURSE) select KEY_VALUATION_GROUPING, KEY_VALUATION_COMPETENCE_COURSE from _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
drop table _VALUATION_COMPETENCE_COURSE_VALUATION_GROUPING_;
rename table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE to _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
create table ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT int(11) not null, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE int(11) not null,  primary key (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE), key(KEY_ENROLMENT), key(KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE)) type=InnoDB;
insert into ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE (KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE) select KEY_ENROLMENT, KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE from _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
drop table _ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE_;
rename table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES to _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
create table CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CREDITS_DISMISSAL int(11) not null, KEY_CURRICULAR_COURSE int(11) not null,  primary key (KEY_CREDITS_DISMISSAL, KEY_CURRICULAR_COURSE), key(KEY_CREDITS_DISMISSAL), key(KEY_CURRICULAR_COURSE)) type=InnoDB;
insert into CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES (KEY_CREDITS_DISMISSAL, KEY_CURRICULAR_COURSE) select KEY_CREDITS_DISMISSAL, KEY_CURRICULAR_COURSE from _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
drop table _CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES_;
rename table SHIFT_SCHOOL_CLASS to _SHIFT_SCHOOL_CLASS_;
create table SHIFT_SCHOOL_CLASS (KEY_SHIFT int(11) not null, KEY_SCHOOL_CLASS int(11) not null,  primary key (KEY_SHIFT, KEY_SCHOOL_CLASS), key(KEY_SHIFT), key(KEY_SCHOOL_CLASS)) type=InnoDB;
insert into SHIFT_SCHOOL_CLASS (KEY_SHIFT, KEY_SCHOOL_CLASS) select KEY_SHIFT, KEY_SCHOOL_CLASS from _SHIFT_SCHOOL_CLASS_;
drop table _SHIFT_SCHOOL_CLASS_;
rename table SHIFT_STUDENT to _SHIFT_STUDENT_;
create table SHIFT_STUDENT (KEY_SHIFT int(11) not null, KEY_REGISTRATION int(11) not null,  primary key (KEY_SHIFT, KEY_REGISTRATION), key(KEY_SHIFT), key(KEY_REGISTRATION)) type=InnoDB;
insert into SHIFT_STUDENT (KEY_SHIFT, KEY_REGISTRATION) select KEY_SHIFT, KEY_REGISTRATION from _SHIFT_STUDENT_;
drop table _SHIFT_STUDENT_;
rename table COURSE_LOAD_SHIFT to _COURSE_LOAD_SHIFT_;
create table COURSE_LOAD_SHIFT (KEY_SHIFT int(11) not null, KEY_COURSE_LOAD int(11) not null,  primary key (KEY_SHIFT, KEY_COURSE_LOAD), key(KEY_SHIFT), key(KEY_COURSE_LOAD)) type=InnoDB;
insert into COURSE_LOAD_SHIFT (KEY_SHIFT, KEY_COURSE_LOAD) select KEY_SHIFT, KEY_COURSE_LOAD from _COURSE_LOAD_SHIFT_;
drop table _COURSE_LOAD_SHIFT_;
rename table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE to _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
create table WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_CURRICULAR_COURSE_SCOPE int(11) not null, KEY_WRITTEN_EVALUATION int(11) not null,  primary key (KEY_CURRICULAR_COURSE_SCOPE, KEY_WRITTEN_EVALUATION), key(KEY_CURRICULAR_COURSE_SCOPE), key(KEY_WRITTEN_EVALUATION)) type=InnoDB;
insert into WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE (KEY_CURRICULAR_COURSE_SCOPE, KEY_WRITTEN_EVALUATION) select KEY_CURRICULAR_COURSE_SCOPE, KEY_WRITTEN_EVALUATION from _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
drop table _WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE_;
rename table DEPARTMENT_DEGREE to _DEPARTMENT_DEGREE_;
create table DEPARTMENT_DEGREE (KEY_DEGREE int(11) not null, KEY_DEPARTMENT int(11) not null,  primary key (KEY_DEGREE, KEY_DEPARTMENT), key(KEY_DEGREE), key(KEY_DEPARTMENT)) type=InnoDB;
insert into DEPARTMENT_DEGREE (KEY_DEGREE, KEY_DEPARTMENT) select KEY_DEGREE, KEY_DEPARTMENT from _DEPARTMENT_DEGREE_;
drop table _DEPARTMENT_DEGREE_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PRIZE int(11) not null, KEY_PARTY int(11) not null,  primary key (KEY_PRIZE, KEY_PARTY), key(KEY_PRIZE), key(KEY_PARTY)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PRIZE, KEY_PARTY) select KEY_PRIZE, KEY_PARTY from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;
rename table PERSON_ROLE to _PERSON_ROLE_;
create table PERSON_ROLE (KEY_ROLE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_ROLE, KEY_PERSON), key(KEY_ROLE), key(KEY_PERSON)) type=InnoDB;
insert into PERSON_ROLE (KEY_ROLE, KEY_PERSON) select KEY_ROLE, KEY_PERSON from _PERSON_ROLE_;
drop table _PERSON_ROLE_;
rename table VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR to _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
create table VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR (KEY_VALUATION_CURRICULAR_COURSE int(11) not null, KEY_CURRICULAR_YEAR int(11) not null,  primary key (KEY_VALUATION_CURRICULAR_COURSE, KEY_CURRICULAR_YEAR), key(KEY_VALUATION_CURRICULAR_COURSE), key(KEY_CURRICULAR_YEAR)) type=InnoDB;
insert into VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR (KEY_VALUATION_CURRICULAR_COURSE, KEY_CURRICULAR_YEAR) select KEY_VALUATION_CURRICULAR_COURSE, KEY_CURRICULAR_YEAR from _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
drop table _VALUATION_CURRICULAR_COURSE_CURRICULAR_YEAR_;
rename table UNIT_SITE_MANAGERS to _UNIT_SITE_MANAGERS_;
create table UNIT_SITE_MANAGERS (KEY_UNIT_SITE int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT_SITE, KEY_PERSON), key(KEY_UNIT_SITE), key(KEY_PERSON)) type=InnoDB;
insert into UNIT_SITE_MANAGERS (KEY_UNIT_SITE, KEY_PERSON) select KEY_UNIT_SITE, KEY_PERSON from _UNIT_SITE_MANAGERS_;
drop table _UNIT_SITE_MANAGERS_;
rename table PROTOCOL_UNIT to _PROTOCOL_UNIT_;
create table PROTOCOL_UNIT (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_UNIT (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_UNIT_;
drop table _PROTOCOL_UNIT_;
rename table PROTOCOL_PARTNER to _PROTOCOL_PARTNER_;
create table PROTOCOL_PARTNER (KEY_UNIT int(11) not null, KEY_PROTOCOL int(11) not null,  primary key (KEY_UNIT, KEY_PROTOCOL), key(KEY_UNIT), key(KEY_PROTOCOL)) type=InnoDB;
insert into PROTOCOL_PARTNER (KEY_UNIT, KEY_PROTOCOL) select KEY_UNIT, KEY_PROTOCOL from _PROTOCOL_PARTNER_;
drop table _PROTOCOL_PARTNER_;
rename table UNIT_FUNCTIONALITY_PRINTERS to _UNIT_FUNCTIONALITY_PRINTERS_;
create table UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT int(11) not null, KEY_FUNCTIONALITY_PRINTERS int(11) not null,  primary key (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS), key(KEY_UNIT), key(KEY_FUNCTIONALITY_PRINTERS)) type=InnoDB;
insert into UNIT_FUNCTIONALITY_PRINTERS (KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS) select KEY_UNIT, KEY_FUNCTIONALITY_PRINTERS from _UNIT_FUNCTIONALITY_PRINTERS_;
drop table _UNIT_FUNCTIONALITY_PRINTERS_;
rename table ALLOWED_TO_UPLOAD_IN_UNIT to _ALLOWED_TO_UPLOAD_IN_UNIT_;
create table ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT int(11) not null, KEY_PERSON int(11) not null,  primary key (KEY_UNIT, KEY_PERSON), key(KEY_UNIT), key(KEY_PERSON)) type=InnoDB;
insert into ALLOWED_TO_UPLOAD_IN_UNIT (KEY_UNIT, KEY_PERSON) select KEY_UNIT, KEY_PERSON from _ALLOWED_TO_UPLOAD_IN_UNIT_;
drop table _ALLOWED_TO_UPLOAD_IN_UNIT_;
rename table PRIZE_WINNERS to _PRIZE_WINNERS_;
create table PRIZE_WINNERS (KEY_PARTY int(11) not null, KEY_PRIZE int(11) not null,  primary key (KEY_PARTY, KEY_PRIZE), key(KEY_PARTY), key(KEY_PRIZE)) type=InnoDB;
insert into PRIZE_WINNERS (KEY_PARTY, KEY_PRIZE) select KEY_PARTY, KEY_PRIZE from _PRIZE_WINNERS_;
drop table _PRIZE_WINNERS_;

alter table ROLE drop column ACK_OPT_LOCK;
alter table MONITORED_SERVICE drop column ACK_OPT_LOCK;
alter table MONITORED_USER drop column ACK_OPT_LOCK;