alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table DELETE_FILE_LOG drop column ACK_OPT_LOCK;
alter table DELETE_FILE_LOG drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table COURSE_VALUATION drop column ACK_OPT_LOCK;
alter table COURSE_VALUATION drop column ack_opt_lock;
alter table INSURANCE_VALUE drop column ACK_OPT_LOCK;
alter table INSURANCE_VALUE drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table GROUPING drop column ACK_OPT_LOCK;
alter table GROUPING drop column ack_opt_lock;
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_;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table REIMBURSEMENT_GUIDE_ENTRY drop column ACK_OPT_LOCK;
alter table REIMBURSEMENT_GUIDE_ENTRY drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table EVENT_EDITION drop column ACK_OPT_LOCK;
alter table EVENT_EDITION drop column ack_opt_lock;
alter table FORUM drop column ACK_OPT_LOCK;
alter table FORUM drop column ack_opt_lock;
alter table PUNCTUAL_ROOMS_OCCUPATION_REQUEST drop column ACK_OPT_LOCK;
alter table PUNCTUAL_ROOMS_OCCUPATION_REQUEST drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 ATTRIBUTE drop column ACK_OPT_LOCK;
alter table ATTRIBUTE drop column ack_opt_lock;
alter table ACCOUNTING_TRANSACTION_DETAIL drop column ACK_OPT_LOCK;
alter table ACCOUNTING_TRANSACTION_DETAIL drop column ack_opt_lock;
alter table ANNOUNCEMENT_BOARD drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT_BOARD drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table EXEMPTION_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table EXEMPTION_JUSTIFICATION drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table REGISTRATION_NUMBER drop column ACK_OPT_LOCK;
alter table REGISTRATION_NUMBER drop column ack_opt_lock;
alter table DEGREE_INFO drop column ACK_OPT_LOCK;
alter table DEGREE_INFO drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table RESOURCE_RESPONSIBILITY drop column ACK_OPT_LOCK;
alter table RESOURCE_RESPONSIBILITY drop column ack_opt_lock;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table CREDITS drop column ACK_OPT_LOCK;
alter table CREDITS drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table STUDENT drop column ACK_OPT_LOCK;
alter table STUDENT drop column ack_opt_lock;
alter table GRATUITY_VALUES drop column ACK_OPT_LOCK;
alter table GRATUITY_VALUES drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
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_;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table CREDIT_LINE drop column ACK_OPT_LOCK;
alter table CREDIT_LINE drop column ack_opt_lock;
alter table METADATA drop column ACK_OPT_LOCK;
alter table METADATA drop column ack_opt_lock;
alter table UNIT_NAME_PART drop column ACK_OPT_LOCK;
alter table UNIT_NAME_PART drop column ack_opt_lock;
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_;
alter table TEACHER_INSTITUTION_WORK_TIME drop column ACK_OPT_LOCK;
alter table TEACHER_INSTITUTION_WORK_TIME drop column ack_opt_lock;
alter table PUBLICATIONS_NUMBER drop column ACK_OPT_LOCK;
alter table PUBLICATIONS_NUMBER drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table DISTRICT drop column ACK_OPT_LOCK;
alter table DISTRICT drop column ack_opt_lock;
alter table EXEMPTION_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table EXEMPTION_JUSTIFICATION drop column ack_opt_lock;
alter table CLOSED_MONTH_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table CLOSED_MONTH_JUSTIFICATION drop column ack_opt_lock;
alter table NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE drop column ACK_OPT_LOCK;
alter table NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE drop column ack_opt_lock;
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_;
alter table OLD_INQUIRIES_SUMMARY drop column ACK_OPT_LOCK;
alter table OLD_INQUIRIES_SUMMARY drop column ack_opt_lock;
alter table BRANCH drop column ACK_OPT_LOCK;
alter table BRANCH drop column ack_opt_lock;
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_;
alter table CREDITS_IN_SCIENTIFIC_AREA drop column ACK_OPT_LOCK;
alter table CREDITS_IN_SCIENTIFIC_AREA drop column ack_opt_lock;
alter table CREDIT_LINE drop column ACK_OPT_LOCK;
alter table CREDIT_LINE drop column ack_opt_lock;
alter table CURRICULAR_YEAR drop column ACK_OPT_LOCK;
alter table CURRICULAR_YEAR drop column ack_opt_lock;
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_;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table STUDENT_TEST_LOG drop column ACK_OPT_LOCK;
alter table STUDENT_TEST_LOG drop column ack_opt_lock;
alter table ACCOUNT drop column ACK_OPT_LOCK;
alter table ACCOUNT drop column ack_opt_lock;
alter table RESEARCH_INTEREST drop column ACK_OPT_LOCK;
alter table RESEARCH_INTEREST drop column ack_opt_lock;
alter table ADVISORY drop column ACK_OPT_LOCK;
alter table ADVISORY drop column ack_opt_lock;
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_;
alter table SPECIAL_SEASON_CODE drop column ACK_OPT_LOCK;
alter table SPECIAL_SEASON_CODE drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table ID_DOCUMENT_TYPE_OBJECT drop column ACK_OPT_LOCK;
alter table ID_DOCUMENT_TYPE_OBJECT drop column ack_opt_lock;
alter table GRANT_PAYMENT_ENTITY drop column ACK_OPT_LOCK;
alter table GRANT_PAYMENT_ENTITY drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table COURSE_EQUIVALENCY drop column ACK_OPT_LOCK;
alter table COURSE_EQUIVALENCY drop column ack_opt_lock;
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_;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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_;
alter table NEW_PRESENTATION_MATERIAL drop column ACK_OPT_LOCK;
alter table NEW_PRESENTATION_MATERIAL drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table ID_DOCUMENT drop column ACK_OPT_LOCK;
alter table ID_DOCUMENT drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table CAREER drop column ACK_OPT_LOCK;
alter table CAREER drop column ack_opt_lock;
alter table PERSONAL_GROUP drop column ACK_OPT_LOCK;
alter table PERSONAL_GROUP drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table PUBLICATION drop column ACK_OPT_LOCK;
alter table PUBLICATION drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 ASSIDUOUSNESS drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table ANNOUNCEMENT_BOARD drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT_BOARD drop column ack_opt_lock;
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_;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
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_;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table CREDITS drop column ACK_OPT_LOCK;
alter table CREDITS drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table F_A_Q_SECTION drop column ACK_OPT_LOCK;
alter table F_A_Q_SECTION drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table NEW_GROUP_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_GROUP_ELEMENT drop column ack_opt_lock;
alter table RESULT_PARTICIPATION drop column ACK_OPT_LOCK;
alter table RESULT_PARTICIPATION drop column ack_opt_lock;
alter table EXTERNAL_ACTIVITY drop column ACK_OPT_LOCK;
alter table EXTERNAL_ACTIVITY drop column ack_opt_lock;
alter table TEACHER drop column ACK_OPT_LOCK;
alter table TEACHER drop column ack_opt_lock;
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_;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table THEME drop column ACK_OPT_LOCK;
alter table THEME drop column ack_opt_lock;
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_;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table PERSON_NAME_PART drop column ACK_OPT_LOCK;
alter table PERSON_NAME_PART drop column ack_opt_lock;
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_;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table PAYMENT_PLAN drop column ACK_OPT_LOCK;
alter table PAYMENT_PLAN drop column ack_opt_lock;
alter table TEACHER_DEGREE_FINAL_PROJECT_STUDENT drop column ACK_OPT_LOCK;
alter table TEACHER_DEGREE_FINAL_PROJECT_STUDENT drop column ack_opt_lock;
alter table PROFESSIONAL_SITUATION drop column ACK_OPT_LOCK;
alter table PROFESSIONAL_SITUATION drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table ATTENDS drop column ACK_OPT_LOCK;
alter table ATTENDS drop column ack_opt_lock;
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_;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table LESSON_PLANNING drop column ACK_OPT_LOCK;
alter table LESSON_PLANNING drop column ack_opt_lock;
alter table PARTY_TYPE drop column ACK_OPT_LOCK;
alter table PARTY_TYPE drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table ANUAL_BONUS_INSTALLMENT drop column ACK_OPT_LOCK;
alter table ANUAL_BONUS_INSTALLMENT drop column ack_opt_lock;
alter table CASE_STUDY drop column ACK_OPT_LOCK;
alter table CASE_STUDY drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table ANNOUNCEMENT drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT drop column ack_opt_lock;
alter table SCIENTIFIC_COMMISSION drop column ACK_OPT_LOCK;
alter table SCIENTIFIC_COMMISSION drop column ack_opt_lock;
alter table MONEY_COST_CENTER drop column ACK_OPT_LOCK;
alter table MONEY_COST_CENTER drop column ack_opt_lock;
alter table PUBLICATION_TYPE_ATTRIBUTE drop column ACK_OPT_LOCK;
alter table PUBLICATION_TYPE_ATTRIBUTE drop column ack_opt_lock;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table EMPLOYEE_EXTRA_WORK_AUTHORIZATION drop column ACK_OPT_LOCK;
alter table EMPLOYEE_EXTRA_WORK_AUTHORIZATION drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table USER drop column ACK_OPT_LOCK;
alter table USER drop column ack_opt_lock;
alter table OCCUPATION_PERIOD drop column ACK_OPT_LOCK;
alter table OCCUPATION_PERIOD drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table STUDENT_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table STUDENT_CURRICULAR_PLAN drop column ack_opt_lock;
alter table TEACHER_SERVICE_DISTRIBUTION drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_DISTRIBUTION drop column ack_opt_lock;
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_;
alter table NEW_ANSWER drop column ACK_OPT_LOCK;
alter table NEW_ANSWER drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table ANNOUNCEMENT_BOARD drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT_BOARD drop column ack_opt_lock;
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_;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table ACCOUNTING_TRANSACTION drop column ACK_OPT_LOCK;
alter table ACCOUNTING_TRANSACTION drop column ack_opt_lock;
alter table VEHICLE drop column ACK_OPT_LOCK;
alter table VEHICLE drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table NEW_PRESENTATION_MATERIAL drop column ACK_OPT_LOCK;
alter table NEW_PRESENTATION_MATERIAL drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table GRANT_CONTRACT_REGIME drop column ACK_OPT_LOCK;
alter table GRANT_CONTRACT_REGIME drop column ack_opt_lock;
alter table SIBS_PAYMENT_FILE_ENTRY drop column ACK_OPT_LOCK;
alter table SIBS_PAYMENT_FILE_ENTRY drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table ANNOUNCEMENT_BOARD drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT_BOARD drop column ack_opt_lock;
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_;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table EVALUATION_METHOD drop column ACK_OPT_LOCK;
alter table EVALUATION_METHOD drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table COUNTRY drop column ACK_OPT_LOCK;
alter table COUNTRY drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table SECRETARY_ENROLMENT_STUDENT drop column ACK_OPT_LOCK;
alter table SECRETARY_ENROLMENT_STUDENT drop column ack_opt_lock;
alter table PUBLICATION_FORMAT drop column ACK_OPT_LOCK;
alter table PUBLICATION_FORMAT drop column ack_opt_lock;
alter table SERVICE_PROVIDER_REGIME drop column ACK_OPT_LOCK;
alter table SERVICE_PROVIDER_REGIME drop column ack_opt_lock;
alter table PROFESSIONAL_SITUATION drop column ACK_OPT_LOCK;
alter table PROFESSIONAL_SITUATION drop column ack_opt_lock;
alter table MASTER_DEGREE_PROOF_VERSION drop column ACK_OPT_LOCK;
alter table MASTER_DEGREE_PROOF_VERSION drop column ack_opt_lock;
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_;
alter table UNIT_EXTRA_WORK_MOVEMENT drop column ACK_OPT_LOCK;
alter table UNIT_EXTRA_WORK_MOVEMENT drop column ack_opt_lock;
alter table PAYMENT_CODE drop column ACK_OPT_LOCK;
alter table PAYMENT_CODE drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 AUTHORSHIP drop column ACK_OPT_LOCK;
alter table AUTHORSHIP drop column ack_opt_lock;
alter table CAREER drop column ACK_OPT_LOCK;
alter table CAREER drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ack_opt_lock;
alter table PROJECT drop column ACK_OPT_LOCK;
alter table PROJECT drop column ack_opt_lock;
alter table MASTER_DEGREE_CANDIDATE drop column ACK_OPT_LOCK;
alter table MASTER_DEGREE_CANDIDATE drop column ack_opt_lock;
alter table ASSIDUOUSNESS_STATUS_HISTORY drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_STATUS_HISTORY drop column ack_opt_lock;
alter table JUSTIFICATION_MOTIVE drop column ACK_OPT_LOCK;
alter table JUSTIFICATION_MOTIVE drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table NON_AFFILIATED_TEACHER drop column ACK_OPT_LOCK;
alter table NON_AFFILIATED_TEACHER drop column ack_opt_lock;
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_;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table DEPARTMENT drop column ACK_OPT_LOCK;
alter table DEPARTMENT drop column ack_opt_lock;
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_;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table PROTOCOL_HISTORY drop column ACK_OPT_LOCK;
alter table PROTOCOL_HISTORY drop column ack_opt_lock;
alter table VIGILANT_GROUP drop column ACK_OPT_LOCK;
alter table VIGILANT_GROUP drop column ack_opt_lock;
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_;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table EXEMPTION_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table EXEMPTION_JUSTIFICATION drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
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_;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table GUIDE drop column ACK_OPT_LOCK;
alter table GUIDE drop column ack_opt_lock;
alter table GROUP_PROPOSAL drop column ACK_OPT_LOCK;
alter table GROUP_PROPOSAL drop column ack_opt_lock;
alter table EXECUTION_DEGREE drop column ACK_OPT_LOCK;
alter table EXECUTION_DEGREE drop column ack_opt_lock;
alter table EMPLOYEE_MONTHLY_BONUS_INSTALLMENT drop column ACK_OPT_LOCK;
alter table EMPLOYEE_MONTHLY_BONUS_INSTALLMENT drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 GRANT_CONTRACT_MOVEMENT drop column ACK_OPT_LOCK;
alter table GRANT_CONTRACT_MOVEMENT drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table CREDITS_IN_ANY_SECUNDARY_AREA drop column ACK_OPT_LOCK;
alter table CREDITS_IN_ANY_SECUNDARY_AREA drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table ENROLMENT_LOG drop column ACK_OPT_LOCK;
alter table ENROLMENT_LOG drop column ack_opt_lock;
alter table PROJECT_SUBMISSION drop column ACK_OPT_LOCK;
alter table PROJECT_SUBMISSION drop column ack_opt_lock;
alter table ENTRY drop column ACK_OPT_LOCK;
alter table ENTRY drop column ack_opt_lock;
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_;
alter table CRON_SCRIPT_STATE drop column ACK_OPT_LOCK;
alter table CRON_SCRIPT_STATE drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST_SITUATION drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST_SITUATION drop column ack_opt_lock;
alter table COOPERATION drop column ACK_OPT_LOCK;
alter table COOPERATION drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table CONTEXT drop column ACK_OPT_LOCK;
alter table CONTEXT drop column ack_opt_lock;
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_;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table UNIT_SITE_LINK drop column ACK_OPT_LOCK;
alter table UNIT_SITE_LINK drop column ack_opt_lock;
alter table UNIVERSITY drop column ACK_OPT_LOCK;
alter table UNIVERSITY drop column ack_opt_lock;
alter table EVENT_CONFERENCE_ARTICLES_ASSOCIATION drop column ACK_OPT_LOCK;
alter table EVENT_CONFERENCE_ARTICLES_ASSOCIATION drop column ack_opt_lock;
alter table SERVICE_AGREEMENT drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT drop column ack_opt_lock;
alter table FILE_ENTRY drop column ACK_OPT_LOCK;
alter table FILE_ENTRY drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table CONVERSATION_MESSAGE drop column ACK_OPT_LOCK;
alter table CONVERSATION_MESSAGE drop column ack_opt_lock;
alter table FUNCTIONALITY_PRINTERS drop column ACK_OPT_LOCK;
alter table FUNCTIONALITY_PRINTERS drop column ack_opt_lock;
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_;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table AVAILABILITY_POLICY drop column ACK_OPT_LOCK;
alter table AVAILABILITY_POLICY drop column ack_opt_lock;
alter table EXTERNAL_ENROLMENT drop column ACK_OPT_LOCK;
alter table EXTERNAL_ENROLMENT drop column ack_opt_lock;
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_;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table EQUIVALENT_ENROLMENT_FOR_ENROLMENT_EQUIVALENCE drop column ACK_OPT_LOCK;
alter table EQUIVALENT_ENROLMENT_FOR_ENROLMENT_EQUIVALENCE drop column ack_opt_lock;
alter table CREDIT_NOTE_ENTRY drop column ACK_OPT_LOCK;
alter table CREDIT_NOTE_ENTRY drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table PROFESSORSHIP_VALUATION drop column ACK_OPT_LOCK;
alter table PROFESSORSHIP_VALUATION drop column ack_opt_lock;
alter table LESSON drop column ACK_OPT_LOCK;
alter table LESSON drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table ROOT_DOMAIN_OBJECT drop column ACK_OPT_LOCK;
alter table ROOT_DOMAIN_OBJECT drop column ack_opt_lock;
alter table GUIDE_SITUATION drop column ACK_OPT_LOCK;
alter table GUIDE_SITUATION drop column ack_opt_lock;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table PAYMENT_PLAN drop column ACK_OPT_LOCK;
alter table PAYMENT_PLAN drop column ack_opt_lock;
alter table CURRICULUM drop column ACK_OPT_LOCK;
alter table CURRICULUM drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table EXPORT_GROUPING drop column ACK_OPT_LOCK;
alter table EXPORT_GROUPING drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table PROJECT_PARTICIPATION drop column ACK_OPT_LOCK;
alter table PROJECT_PARTICIPATION drop column ack_opt_lock;
alter table PUNCTUAL_ROOMS_OCCUPATION_STATE_INSTANT drop column ACK_OPT_LOCK;
alter table PUNCTUAL_ROOMS_OCCUPATION_STATE_INSTANT drop column ack_opt_lock;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table PROJECT_ACCESS drop column ACK_OPT_LOCK;
alter table PROJECT_ACCESS drop column ack_opt_lock;
alter table CURRICULAR_COURSE_EQUIVALENCE drop column ACK_OPT_LOCK;
alter table CURRICULAR_COURSE_EQUIVALENCE drop column ack_opt_lock;
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_;
alter table REIMBURSEMENT_GUIDE_SITUATION drop column ACK_OPT_LOCK;
alter table REIMBURSEMENT_GUIDE_SITUATION drop column ack_opt_lock;
alter table ACCOUNTABILITY_TYPE drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY_TYPE drop column ack_opt_lock;
alter table DOMAIN_OBJECT_ACTION_LOG drop column ACK_OPT_LOCK;
alter table DOMAIN_OBJECT_ACTION_LOG drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table COURSE_REPORT drop column ACK_OPT_LOCK;
alter table COURSE_REPORT drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
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_;
alter table CAREER drop column ACK_OPT_LOCK;
alter table CAREER drop column ack_opt_lock;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table GRANT_INSURANCE drop column ACK_OPT_LOCK;
alter table GRANT_INSURANCE drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table GRANT_PART drop column ACK_OPT_LOCK;
alter table GRANT_PART drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table COURSE_VALUATION drop column ACK_OPT_LOCK;
alter table COURSE_VALUATION drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table SIBS_PAYMENT_FILE drop column ACK_OPT_LOCK;
alter table SIBS_PAYMENT_FILE drop column ack_opt_lock;
alter table CANDIDACY_DOCUMENT drop column ACK_OPT_LOCK;
alter table CANDIDACY_DOCUMENT drop column ack_opt_lock;
alter table CRON_REGISTRY drop column ACK_OPT_LOCK;
alter table CRON_REGISTRY drop column ack_opt_lock;
alter table STUDENT_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table STUDENT_CURRICULAR_PLAN drop column ack_opt_lock;
alter table EXEMPTION_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table EXEMPTION_JUSTIFICATION drop column ack_opt_lock;
alter table STUDENT_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table STUDENT_CURRICULAR_PLAN drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table QUALIFICATION drop column ACK_OPT_LOCK;
alter table QUALIFICATION drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table STUDENT_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table STUDENT_CURRICULAR_PLAN drop column ack_opt_lock;
alter table FORUM_SUBSCRIPTION drop column ACK_OPT_LOCK;
alter table FORUM_SUBSCRIPTION drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table WEEKLY_WORK_LOAD drop column ACK_OPT_LOCK;
alter table WEEKLY_WORK_LOAD drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table GRANT_OWNER drop column ACK_OPT_LOCK;
alter table GRANT_OWNER drop column ack_opt_lock;
alter table MARK drop column ACK_OPT_LOCK;
alter table MARK drop column ack_opt_lock;
alter table MASTER_DEGREE_THESIS drop column ACK_OPT_LOCK;
alter table MASTER_DEGREE_THESIS drop column ack_opt_lock;
alter table COMPETENCE_COURSE_LOAD drop column ACK_OPT_LOCK;
alter table COMPETENCE_COURSE_LOAD drop column ack_opt_lock;
alter table STUDENT_COURSE_REPORT drop column ACK_OPT_LOCK;
alter table STUDENT_COURSE_REPORT drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table EXTERNAL_CURRICULAR_COURSE drop column ACK_OPT_LOCK;
alter table EXTERNAL_CURRICULAR_COURSE drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 RECEIPT drop column ACK_OPT_LOCK;
alter table RECEIPT drop column ack_opt_lock;
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_;
alter table IDENTIFICATION drop column ACK_OPT_LOCK;
alter table IDENTIFICATION drop column ack_opt_lock;
alter table CANDIDATE_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDATE_SITUATION drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table MASTER_DEGREE_THESIS_DATA_VERSION drop column ACK_OPT_LOCK;
alter table MASTER_DEGREE_THESIS_DATA_VERSION drop column ack_opt_lock;
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_;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table STUDENT_GROUP drop column ACK_OPT_LOCK;
alter table STUDENT_GROUP drop column ack_opt_lock;
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_;
alter table PROFESSIONAL_SITUATION drop column ACK_OPT_LOCK;
alter table PROFESSIONAL_SITUATION drop column ack_opt_lock;
alter table ACCOUNTABILITY_TYPE drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY_TYPE drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table EMPLOYEE_BONUS_INSTALLMENT drop column ACK_OPT_LOCK;
alter table EMPLOYEE_BONUS_INSTALLMENT drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ack_opt_lock;
alter table PAYMENT_CODE drop column ACK_OPT_LOCK;
alter table PAYMENT_CODE drop column ack_opt_lock;
alter table SHIFT_DISTRIBUTION_ENTRY drop column ACK_OPT_LOCK;
alter table SHIFT_DISTRIBUTION_ENTRY drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table VIGILANT_BOUND drop column ACK_OPT_LOCK;
alter table VIGILANT_BOUND drop column ack_opt_lock;
alter table WRITTEN_EVALUATION_ENROLMENT drop column ACK_OPT_LOCK;
alter table WRITTEN_EVALUATION_ENROLMENT drop column ack_opt_lock;
alter table COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST drop column ACK_OPT_LOCK;
alter table COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST drop column ack_opt_lock;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
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_;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table GRANT_PAYMENT_ENTITY drop column ACK_OPT_LOCK;
alter table GRANT_PAYMENT_ENTITY drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table ORIENTATION drop column ACK_OPT_LOCK;
alter table ORIENTATION drop column ack_opt_lock;
alter table EXECUTION_PERIOD drop column ACK_OPT_LOCK;
alter table EXECUTION_PERIOD drop column ack_opt_lock;
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_;
alter table RESOURCE_RESPONSIBILITY drop column ACK_OPT_LOCK;
alter table RESOURCE_RESPONSIBILITY drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table CASE_STUDY_CHOICE drop column ACK_OPT_LOCK;
alter table CASE_STUDY_CHOICE drop column ack_opt_lock;
alter table COURSE_VALUATION drop column ACK_OPT_LOCK;
alter table COURSE_VALUATION drop column ack_opt_lock;
alter table ACCOUNTING_TRANSACTION_DETAIL drop column ACK_OPT_LOCK;
alter table ACCOUNTING_TRANSACTION_DETAIL drop column ack_opt_lock;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table CURRICULAR_SEMESTER drop column ACK_OPT_LOCK;
alter table CURRICULAR_SEMESTER drop column ack_opt_lock;
alter table PERIODICITY drop column ACK_OPT_LOCK;
alter table PERIODICITY drop column ack_opt_lock;
alter table VALUATION_COMPETENCE_COURSE drop column ACK_OPT_LOCK;
alter table VALUATION_COMPETENCE_COURSE drop column ack_opt_lock;
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_;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
alter table ASSIDUOUSNESS_STATUS drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_STATUS drop column ack_opt_lock;
alter table SUMMARY drop column ACK_OPT_LOCK;
alter table SUMMARY drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table CURRICULAR_COURSE_GROUP drop column ACK_OPT_LOCK;
alter table CURRICULAR_COURSE_GROUP drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table ACCOUNTING_TRANSACTION drop column ACK_OPT_LOCK;
alter table ACCOUNTING_TRANSACTION drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
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_;
alter table COORDINATOR drop column ACK_OPT_LOCK;
alter table COORDINATOR drop column ack_opt_lock;
alter table OLD_PUBLICATION drop column ACK_OPT_LOCK;
alter table OLD_PUBLICATION drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table EXTRA_WORK_HISTORIC drop column ACK_OPT_LOCK;
alter table EXTRA_WORK_HISTORIC drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table GENERAL_CLASS_PROPERTY drop column ACK_OPT_LOCK;
alter table GENERAL_CLASS_PROPERTY drop column ack_opt_lock;
alter table EXAM_COORDINATOR drop column ACK_OPT_LOCK;
alter table EXAM_COORDINATOR drop column ack_opt_lock;
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_;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table GRANT_TYPE drop column ACK_OPT_LOCK;
alter table GRANT_TYPE drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table PAYMENT_PLAN drop column ACK_OPT_LOCK;
alter table PAYMENT_PLAN drop column ack_opt_lock;
alter table UNIT_FILE_TAG drop column ACK_OPT_LOCK;
alter table UNIT_FILE_TAG drop column ack_opt_lock;
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_;
alter table PRECEDENCE drop column ACK_OPT_LOCK;
alter table PRECEDENCE drop column ack_opt_lock;
alter table AVAILABILITY_POLICY drop column ACK_OPT_LOCK;
alter table AVAILABILITY_POLICY drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table SIBS_PAYMENT_FILE_PROCESS_REPORT drop column ACK_OPT_LOCK;
alter table SIBS_PAYMENT_FILE_PROCESS_REPORT drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table ANNOUNCEMENT_BOARD drop column ACK_OPT_LOCK;
alter table ANNOUNCEMENT_BOARD drop column ack_opt_lock;
alter table EXECUTION_COURSE drop column ACK_OPT_LOCK;
alter table EXECUTION_COURSE drop column ack_opt_lock;
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_;
alter table IDENTIFICATION drop column ACK_OPT_LOCK;
alter table IDENTIFICATION drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table COMPETENCE_COURSE_INFORMATION drop column ACK_OPT_LOCK;
alter table COMPETENCE_COURSE_INFORMATION drop column ack_opt_lock;
alter table EXEMPTION_JUSTIFICATION drop column ACK_OPT_LOCK;
alter table EXEMPTION_JUSTIFICATION drop column ack_opt_lock;
alter table MANAGEMENT_GROUPS drop column ACK_OPT_LOCK;
alter table MANAGEMENT_GROUPS drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table ASSIDUOUSNESS_RECORD drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_RECORD drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table CREDIT_LINE drop column ACK_OPT_LOCK;
alter table CREDIT_LINE drop column ack_opt_lock;
alter table CONTRIBUTOR drop column ACK_OPT_LOCK;
alter table CONTRIBUTOR drop column ack_opt_lock;
alter table HOLIDAY drop column ACK_OPT_LOCK;
alter table HOLIDAY drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table SEMINARY_CANDIDACY drop column ACK_OPT_LOCK;
alter table SEMINARY_CANDIDACY drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table PRECEDENT_DEGREE_INFORMATION drop column ACK_OPT_LOCK;
alter table PRECEDENT_DEGREE_INFORMATION drop column ack_opt_lock;
alter table UNIT_EXTRA_WORK_AMOUNT drop column ACK_OPT_LOCK;
alter table UNIT_EXTRA_WORK_AMOUNT drop column ack_opt_lock;
alter table MARK_SHEET drop column ACK_OPT_LOCK;
alter table MARK_SHEET drop column ack_opt_lock;
alter table GLOSSARY_ENTRY drop column ACK_OPT_LOCK;
alter table GLOSSARY_ENTRY drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table EXTRA_WORK_AUTHORIZATION drop column ACK_OPT_LOCK;
alter table EXTRA_WORK_AUTHORIZATION drop column ack_opt_lock;
alter table PERSISTENT_GROUP_MEMBERS drop column ACK_OPT_LOCK;
alter table PERSISTENT_GROUP_MEMBERS drop column ack_opt_lock;
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_;
alter table ACCESSIBLE_ITEM drop column ACK_OPT_LOCK;
alter table ACCESSIBLE_ITEM drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table VALUATION_TEACHER drop column ACK_OPT_LOCK;
alter table VALUATION_TEACHER drop column ack_opt_lock;
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_;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table PROTOCOL drop column ACK_OPT_LOCK;
alter table PROTOCOL drop column ack_opt_lock;
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_;
alter table EMPLOYEE_HISTORIC drop column ACK_OPT_LOCK;
alter table EMPLOYEE_HISTORIC drop column ack_opt_lock;
alter table CATEGORY drop column ACK_OPT_LOCK;
alter table CATEGORY drop column ack_opt_lock;
alter table DISTRIBUTED_TEST_ADVISORY drop column ACK_OPT_LOCK;
alter table DISTRIBUTED_TEST_ADVISORY drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION_PERIOD drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table INQUIRY_RESPONSE_PERIOD drop column ACK_OPT_LOCK;
alter table INQUIRY_RESPONSE_PERIOD drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table PROJECT_SUBMISSION_LOG drop column ACK_OPT_LOCK;
alter table PROJECT_SUBMISSION_LOG drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table LOGIN_REQUEST drop column ACK_OPT_LOCK;
alter table LOGIN_REQUEST drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table PUBLICATION_TYPE drop column ACK_OPT_LOCK;
alter table PUBLICATION_TYPE drop column ack_opt_lock;
alter table CREDIT_LINE drop column ACK_OPT_LOCK;
alter table CREDIT_LINE drop column ack_opt_lock;
alter table PAYMENT_CODE drop column ACK_OPT_LOCK;
alter table PAYMENT_CODE drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table GRANT_PAYMENT_ENTITY drop column ACK_OPT_LOCK;
alter table GRANT_PAYMENT_ENTITY drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table QUESTION drop column ACK_OPT_LOCK;
alter table QUESTION drop column ack_opt_lock;
alter table TEACHER_SERVICE drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE drop column ack_opt_lock;
alter table WORK_PERIOD drop column ACK_OPT_LOCK;
alter table WORK_PERIOD drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table RESULT_UNIT_ASSOCIATION drop column ACK_OPT_LOCK;
alter table RESULT_UNIT_ASSOCIATION drop column ack_opt_lock;
alter table CLOCK_UNIT drop column ACK_OPT_LOCK;
alter table CLOCK_UNIT drop column ack_opt_lock;
alter table COURSE_LOAD drop column ACK_OPT_LOCK;
alter table COURSE_LOAD drop column ack_opt_lock;
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_;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table PUNCTUAL_ROOMS_OCCUPATION_COMMENT drop column ACK_OPT_LOCK;
alter table PUNCTUAL_ROOMS_OCCUPATION_COMMENT drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
alter table OLD_INQUIRIES_COURSES_RES drop column ACK_OPT_LOCK;
alter table OLD_INQUIRIES_COURSES_RES drop column ack_opt_lock;
alter table NEW_PARKING_DOCUMENT drop column ACK_OPT_LOCK;
alter table NEW_PARKING_DOCUMENT drop column ack_opt_lock;
alter table REIMBURSEMENT_GUIDE drop column ACK_OPT_LOCK;
alter table REIMBURSEMENT_GUIDE drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 GENERIC_EVENT drop column ACK_OPT_LOCK;
alter table GENERIC_EVENT drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 RESIDENCE_CANDIDACIES drop column ACK_OPT_LOCK;
alter table RESIDENCE_CANDIDACIES drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table NEW_PERMISSION_UNIT drop column ACK_OPT_LOCK;
alter table NEW_PERMISSION_UNIT drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table CURRICULAR_PERIOD drop column ACK_OPT_LOCK;
alter table CURRICULAR_PERIOD drop column ack_opt_lock;
alter table AVAILABILITY_POLICY drop column ACK_OPT_LOCK;
alter table AVAILABILITY_POLICY drop column ack_opt_lock;
alter table ASSIDUOUSNESS_EXTRA_WORK drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_EXTRA_WORK drop column ack_opt_lock;
alter table PARKING_DOCUMENT drop column ACK_OPT_LOCK;
alter table PARKING_DOCUMENT drop column ack_opt_lock;
alter table PUBLICATION_TEACHER drop column ACK_OPT_LOCK;
alter table PUBLICATION_TEACHER drop column ack_opt_lock;
alter table NEW_TEST_GROUP drop column ACK_OPT_LOCK;
alter table NEW_TEST_GROUP drop column ack_opt_lock;
alter table INSTALLMENT drop column ACK_OPT_LOCK;
alter table INSTALLMENT drop column ack_opt_lock;
alter table CLOSED_MONTH drop column ACK_OPT_LOCK;
alter table CLOSED_MONTH drop column ack_opt_lock;
alter table INQUIRIES_TEACHER drop column ACK_OPT_LOCK;
alter table INQUIRIES_TEACHER drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table WORK_SCHEDULE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE drop column ack_opt_lock;
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_;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table PAYMENT_PLAN drop column ACK_OPT_LOCK;
alter table PAYMENT_PLAN drop column ack_opt_lock;
alter table PAYMENT_CODE drop column ACK_OPT_LOCK;
alter table PAYMENT_CODE drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table YEAR_STUDENT_SPECIAL_SEASON_CODE drop column ACK_OPT_LOCK;
alter table YEAR_STUDENT_SPECIAL_SEASON_CODE drop column ack_opt_lock;
alter table SENT_SMS drop column ACK_OPT_LOCK;
alter table SENT_SMS drop column ack_opt_lock;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table GUIDE_ENTRY drop column ACK_OPT_LOCK;
alter table GUIDE_ENTRY drop column ack_opt_lock;
alter table STUDENT_STATUTE drop column ACK_OPT_LOCK;
alter table STUDENT_STATUTE drop column ack_opt_lock;
alter table SUPPORT_LESSON drop column ACK_OPT_LOCK;
alter table SUPPORT_LESSON drop column ack_opt_lock;
alter table PARKING_PARTY drop column ACK_OPT_LOCK;
alter table PARKING_PARTY drop column ack_opt_lock;
alter table COURSE_VALUATION drop column ACK_OPT_LOCK;
alter table COURSE_VALUATION drop column ack_opt_lock;
alter table PROFESSIONAL_SITUATION drop column ACK_OPT_LOCK;
alter table PROFESSIONAL_SITUATION drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table CANDIDATE_ENROLMENT drop column ACK_OPT_LOCK;
alter table CANDIDATE_ENROLMENT drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
alter table CONVERSATION_THREAD drop column ACK_OPT_LOCK;
alter table CONVERSATION_THREAD drop column ack_opt_lock;
alter table ASSIDUOUSNESS_CLOSED_MONTH drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_CLOSED_MONTH drop column ack_opt_lock;
alter table PAYMENT_PHASE drop column ACK_OPT_LOCK;
alter table PAYMENT_PHASE drop column ack_opt_lock;
alter table ENROLMENT_EVALUATION drop column ACK_OPT_LOCK;
alter table ENROLMENT_EVALUATION drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table USERNAME_COUNTER drop column ACK_OPT_LOCK;
alter table USERNAME_COUNTER drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table EXEMPTION drop column ACK_OPT_LOCK;
alter table EXEMPTION drop column ack_opt_lock;
alter table INQUIRIES_ROOM drop column ACK_OPT_LOCK;
alter table INQUIRIES_ROOM drop column ack_opt_lock;
alter table GAUGING_TEST_RESULT drop column ACK_OPT_LOCK;
alter table GAUGING_TEST_RESULT drop column ack_opt_lock;
alter table ASSIDUOUSNESS_VACATIONS drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_VACATIONS drop column ack_opt_lock;
alter table CRON_SCRIPT_INVOCATION drop column ACK_OPT_LOCK;
alter table CRON_SCRIPT_INVOCATION drop column ack_opt_lock;
alter table CARD drop column ACK_OPT_LOCK;
alter table CARD drop column ack_opt_lock;
alter table SCHEDULE drop column ACK_OPT_LOCK;
alter table SCHEDULE drop column ack_opt_lock;
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_;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
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_;
alter table VIGILANCY drop column ACK_OPT_LOCK;
alter table VIGILANCY drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table PERSON_NAME drop column ACK_OPT_LOCK;
alter table PERSON_NAME drop column ack_opt_lock;
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_;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table INSTALLMENT drop column ACK_OPT_LOCK;
alter table INSTALLMENT drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 EXTERNAL_REGISTRATION_DATA drop column ACK_OPT_LOCK;
alter table EXTERNAL_REGISTRATION_DATA drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ASSIDUOUSNESS_CAMPUS_HISTORY drop column ACK_OPT_LOCK;
alter table ASSIDUOUSNESS_CAMPUS_HISTORY drop column ack_opt_lock;
alter table SHIFT_ENROLMENT drop column ACK_OPT_LOCK;
alter table SHIFT_ENROLMENT drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table PROFESSORSHIP drop column ACK_OPT_LOCK;
alter table PROFESSORSHIP drop column ack_opt_lock;
alter table SCIENTIFIC_AREA drop column ACK_OPT_LOCK;
alter table SCIENTIFIC_AREA drop column ack_opt_lock;
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_;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table WEEKLY_OCUPATION drop column ACK_OPT_LOCK;
alter table WEEKLY_OCUPATION drop column ack_opt_lock;
alter table MODALITY drop column ACK_OPT_LOCK;
alter table MODALITY drop column ack_opt_lock;
alter table COMPETENCE_COURSE drop column ACK_OPT_LOCK;
alter table COMPETENCE_COURSE drop column ack_opt_lock;
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_;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table FINAL_DEGREE_WORK_GROUP drop column ACK_OPT_LOCK;
alter table FINAL_DEGREE_WORK_GROUP drop column ack_opt_lock;
alter table CREDITS drop column ACK_OPT_LOCK;
alter table CREDITS drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table TEST_SCOPE drop column ACK_OPT_LOCK;
alter table TEST_SCOPE drop column ack_opt_lock;
alter table PARTICIPATION drop column ACK_OPT_LOCK;
alter table PARTICIPATION drop column ack_opt_lock;
alter table REGISTRATION drop column ACK_OPT_LOCK;
alter table REGISTRATION drop column ack_opt_lock;
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_;
alter table EQUIVALENCE_PLAN drop column ACK_OPT_LOCK;
alter table EQUIVALENCE_PLAN drop column ack_opt_lock;
alter table BLUEPRINT drop column ACK_OPT_LOCK;
alter table BLUEPRINT drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ack_opt_lock;
alter table EXPECTATION_EVALUATION_GROUP drop column ACK_OPT_LOCK;
alter table EXPECTATION_EVALUATION_GROUP drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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_;
alter table NEW_PRESENTATION_MATERIAL drop column ACK_OPT_LOCK;
alter table NEW_PRESENTATION_MATERIAL drop column ack_opt_lock;
alter table SCHOOL_CLASS drop column ACK_OPT_LOCK;
alter table SCHOOL_CLASS drop column ack_opt_lock;
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_;
alter table TUTORSHIP drop column ACK_OPT_LOCK;
alter table TUTORSHIP drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table EMAIL drop column ACK_OPT_LOCK;
alter table EMAIL drop column ack_opt_lock;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
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_;
alter table GRANT_SUBSIDY drop column ACK_OPT_LOCK;
alter table GRANT_SUBSIDY drop column ack_opt_lock;
alter table RESOURCE_RESPONSIBILITY drop column ACK_OPT_LOCK;
alter table RESOURCE_RESPONSIBILITY drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table UNAVAILABLE_PERIOD drop column ACK_OPT_LOCK;
alter table UNAVAILABLE_PERIOD drop column ack_opt_lock;
alter table EQUIVALENCE_PLAN_ENTRY drop column ACK_OPT_LOCK;
alter table EQUIVALENCE_PLAN_ENTRY drop column ack_opt_lock;
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_;
alter table INQUIRIES_STUDENT_EXECUTION_PERIOD drop column ACK_OPT_LOCK;
alter table INQUIRIES_STUDENT_EXECUTION_PERIOD drop column ack_opt_lock;
alter table THESIS drop column ACK_OPT_LOCK;
alter table THESIS drop column ack_opt_lock;
alter table VIGILANCY drop column ACK_OPT_LOCK;
alter table VIGILANCY drop column ack_opt_lock;
alter table CURRICULAR_COURSE_GROUP drop column ACK_OPT_LOCK;
alter table CURRICULAR_COURSE_GROUP drop column ack_opt_lock;
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_;
alter table ADVISE drop column ACK_OPT_LOCK;
alter table ADVISE drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table SHIFT_DISTRIBUTION drop column ACK_OPT_LOCK;
alter table SHIFT_DISTRIBUTION drop column ack_opt_lock;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT_TEMPLATE drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table STUDENT_TEST_QUESTION drop column ACK_OPT_LOCK;
alter table STUDENT_TEST_QUESTION drop column ack_opt_lock;
alter table PROPOSAL drop column ACK_OPT_LOCK;
alter table PROPOSAL drop column ack_opt_lock;
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_;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table MARK drop column ACK_OPT_LOCK;
alter table MARK drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
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_;
alter table GENERAL_CLASS_PROPERTY drop column ACK_OPT_LOCK;
alter table GENERAL_CLASS_PROPERTY drop column ack_opt_lock;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table EXTRA_WORK_COMPENSATION drop column ACK_OPT_LOCK;
alter table EXTRA_WORK_COMPENSATION drop column ack_opt_lock;
alter table EXECUTION_YEAR drop column ACK_OPT_LOCK;
alter table EXECUTION_YEAR drop column ack_opt_lock;
alter table EQUIVALENCE_PLAN drop column ACK_OPT_LOCK;
alter table EQUIVALENCE_PLAN drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table OLD_INQUIRIES_TEACHERS_RES drop column ACK_OPT_LOCK;
alter table OLD_INQUIRIES_TEACHERS_RES drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
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_;
alter table ADMINISTRATIVE_OFFICE drop column ACK_OPT_LOCK;
alter table ADMINISTRATIVE_OFFICE drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table ENROLMENT_EQUIVALENCE drop column ACK_OPT_LOCK;
alter table ENROLMENT_EQUIVALENCE drop column ack_opt_lock;
alter table ACADEMIC_CALENDAR_ENTRY drop column ACK_OPT_LOCK;
alter table ACADEMIC_CALENDAR_ENTRY drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table RESOURCE_ALLOCATION drop column ACK_OPT_LOCK;
alter table RESOURCE_ALLOCATION drop column ack_opt_lock;
alter table VIGILANT drop column ACK_OPT_LOCK;
alter table VIGILANT drop column ack_opt_lock;
alter table INQUIRIES_COURSE drop column ACK_OPT_LOCK;
alter table INQUIRIES_COURSE drop column ack_opt_lock;
alter table CREDITS drop column ACK_OPT_LOCK;
alter table CREDITS drop column ack_opt_lock;
alter table LOGIN_ALIAS drop column ACK_OPT_LOCK;
alter table LOGIN_ALIAS drop column ack_opt_lock;
alter table CANDIDACY_SITUATION drop column ACK_OPT_LOCK;
alter table CANDIDACY_SITUATION drop column ack_opt_lock;
alter table EVALUATION drop column ACK_OPT_LOCK;
alter table EVALUATION drop column ack_opt_lock;
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_;
alter table DOMAIN_OBJECT_ACTION_LOG_ENTRY drop column ACK_OPT_LOCK;
alter table DOMAIN_OBJECT_ACTION_LOG_ENTRY drop column ack_opt_lock;
alter table F_A_Q_ENTRY drop column ACK_OPT_LOCK;
alter table F_A_Q_ENTRY drop column ack_opt_lock;
alter table ARTICLE_ASSOCIATION drop column ACK_OPT_LOCK;
alter table ARTICLE_ASSOCIATION drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table VIGILANCY drop column ACK_OPT_LOCK;
alter table VIGILANCY drop column ack_opt_lock;
alter table CURRICULAR_COURSE_GROUP drop column ACK_OPT_LOCK;
alter table CURRICULAR_COURSE_GROUP drop column ack_opt_lock;
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_;
alter table GRANT_ORIENTATION_TEACHER drop column ACK_OPT_LOCK;
alter table GRANT_ORIENTATION_TEACHER drop column ack_opt_lock;
alter table UNIT_NAME drop column ACK_OPT_LOCK;
alter table UNIT_NAME drop column ack_opt_lock;
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_;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table JOURNAL_ISSUE drop column ACK_OPT_LOCK;
alter table JOURNAL_ISSUE drop column ack_opt_lock;
alter table THESIS_EVALUATION_PARTICIPANT drop column ACK_OPT_LOCK;
alter table THESIS_EVALUATION_PARTICIPANT drop column ack_opt_lock;
alter table GRANT_CONTRACT drop column ACK_OPT_LOCK;
alter table GRANT_CONTRACT drop column ack_opt_lock;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table SCHEDULEING drop column ACK_OPT_LOCK;
alter table SCHEDULEING drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table DEGREE_MODULE drop column ACK_OPT_LOCK;
alter table DEGREE_MODULE drop column ack_opt_lock;
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_;
alter table ENROLMENT_PERIOD drop column ACK_OPT_LOCK;
alter table ENROLMENT_PERIOD drop column ack_opt_lock;
alter table MEAL drop column ACK_OPT_LOCK;
alter table MEAL drop column ack_opt_lock;
alter table EQUIVALENCE_PLAN drop column ACK_OPT_LOCK;
alter table EQUIVALENCE_PLAN drop column ack_opt_lock;
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_;
alter table INQUIRIES_REGISTRY drop column ACK_OPT_LOCK;
alter table INQUIRIES_REGISTRY drop column ack_opt_lock;
alter table TEST_QUESTION drop column ACK_OPT_LOCK;
alter table TEST_QUESTION drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table DISTRIBUTED_TEST drop column ACK_OPT_LOCK;
alter table DISTRIBUTED_TEST drop column ack_opt_lock;
alter table TEACHER_SERVICE_ITEM drop column ACK_OPT_LOCK;
alter table TEACHER_SERVICE_ITEM drop column ack_opt_lock;
alter table VALUATION_PHASE drop column ACK_OPT_LOCK;
alter table VALUATION_PHASE drop column ack_opt_lock;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table ACCOUNTABILITY_TYPE drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY_TYPE drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
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_;
alter table DELETE_FILE_REQUEST drop column ACK_OPT_LOCK;
alter table DELETE_FILE_REQUEST drop column ack_opt_lock;
alter table VALUATION_GROUPING drop column ACK_OPT_LOCK;
alter table VALUATION_GROUPING drop column ack_opt_lock;
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_;
alter table STUDENT_DATA_BY_EXECUTION_YEAR drop column ACK_OPT_LOCK;
alter table STUDENT_DATA_BY_EXECUTION_YEAR drop column ack_opt_lock;
alter table EXTRA_WORK_REQUEST drop column ACK_OPT_LOCK;
alter table EXTRA_WORK_REQUEST drop column ack_opt_lock;
alter table PARKING_REQUEST drop column ACK_OPT_LOCK;
alter table PARKING_REQUEST drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
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_;
alter table PUBLICATION_SUBTYPE drop column ACK_OPT_LOCK;
alter table PUBLICATION_SUBTYPE drop column ack_opt_lock;
alter table PROJECT_EVENT_ASSOCIATION drop column ACK_OPT_LOCK;
alter table PROJECT_EVENT_ASSOCIATION drop column ack_opt_lock;
alter table FORUM drop column ACK_OPT_LOCK;
alter table FORUM drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table STATUS_ASSIDUIDADE drop column ACK_OPT_LOCK;
alter table STATUS_ASSIDUIDADE drop column ack_opt_lock;
alter table ROOM_CLASSIFICATION drop column ACK_OPT_LOCK;
alter table ROOM_CLASSIFICATION drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
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_;
alter table IDENTIFICATION drop column ACK_OPT_LOCK;
alter table IDENTIFICATION drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table SEMINARY drop column ACK_OPT_LOCK;
alter table SEMINARY drop column ack_opt_lock;
alter table EXTRA_WORK_REQUESTS drop column ACK_OPT_LOCK;
alter table EXTRA_WORK_REQUESTS drop column ack_opt_lock;
alter table ACCOUNTABILITY drop column ACK_OPT_LOCK;
alter table ACCOUNTABILITY drop column ack_opt_lock;
alter table SHIFT drop column ACK_OPT_LOCK;
alter table SHIFT drop column ack_opt_lock;
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_;
alter table GROUP_STUDENT drop column ACK_OPT_LOCK;
alter table GROUP_STUDENT drop column ack_opt_lock;
alter table CURRICULAR_COURSE_SCOPE drop column ACK_OPT_LOCK;
alter table CURRICULAR_COURSE_SCOPE drop column ack_opt_lock;
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_;
alter table DEGREE drop column ACK_OPT_LOCK;
alter table DEGREE drop column ack_opt_lock;
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_;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table TEACHER_PERSONAL_EXPECTATION drop column ACK_OPT_LOCK;
alter table TEACHER_PERSONAL_EXPECTATION drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table GRATUITY_SITUATION drop column ACK_OPT_LOCK;
alter table GRATUITY_SITUATION drop column ack_opt_lock;
alter table WORK_SCHEDULE_TYPE drop column ACK_OPT_LOCK;
alter table WORK_SCHEDULE_TYPE drop column ack_opt_lock;
alter table LESSON_INSTANCE drop column ACK_OPT_LOCK;
alter table LESSON_INSTANCE drop column ack_opt_lock;
alter table PRIZE drop column ACK_OPT_LOCK;
alter table PRIZE drop column ack_opt_lock;
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_;
alter table COST_CENTER drop column ACK_OPT_LOCK;
alter table COST_CENTER drop column ack_opt_lock;
alter table LOGIN_PERIOD drop column ACK_OPT_LOCK;
alter table LOGIN_PERIOD drop column ack_opt_lock;
alter table FILE drop column ACK_OPT_LOCK;
alter table FILE drop column ack_opt_lock;
alter table SCIENTIFIC_JOURNAL drop column ACK_OPT_LOCK;
alter table SCIENTIFIC_JOURNAL drop column ack_opt_lock;
alter table TEST drop column ACK_OPT_LOCK;
alter table TEST drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
alter table CURRICULUM_MODULE drop column ACK_OPT_LOCK;
alter table CURRICULUM_MODULE drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table BIBLIOGRAPHIC_REFERENCE drop column ACK_OPT_LOCK;
alter table BIBLIOGRAPHIC_REFERENCE drop column ack_opt_lock;
alter table UNIT_SITE_BANNER drop column ACK_OPT_LOCK;
alter table UNIT_SITE_BANNER drop column ack_opt_lock;
alter table DELEGATE drop column ACK_OPT_LOCK;
alter table DELEGATE drop column ack_opt_lock;
alter table COURSE_HISTORIC drop column ACK_OPT_LOCK;
alter table COURSE_HISTORIC drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table RECEIPT_PRINT_VERSION drop column ACK_OPT_LOCK;
alter table RECEIPT_PRINT_VERSION drop column ack_opt_lock;
alter table PRICE drop column ACK_OPT_LOCK;
alter table PRICE drop column ack_opt_lock;
alter table NEW_CORRECTOR drop column ACK_OPT_LOCK;
alter table NEW_CORRECTOR drop column ack_opt_lock;
alter table INSTALLMENT drop column ACK_OPT_LOCK;
alter table INSTALLMENT drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table REGISTRATION_DATA_BY_EXECUTION_YEAR drop column ACK_OPT_LOCK;
alter table REGISTRATION_DATA_BY_EXECUTION_YEAR drop column ack_opt_lock;
alter table STUDENT_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table STUDENT_CURRICULAR_PLAN drop column ack_opt_lock;
alter table PARTY_CONTACT drop column ACK_OPT_LOCK;
alter table PARTY_CONTACT drop column ack_opt_lock;
alter table RESTRICTION drop column ACK_OPT_LOCK;
alter table RESTRICTION drop column ack_opt_lock;
alter table EXTRA_WORK drop column ACK_OPT_LOCK;
alter table EXTRA_WORK drop column ack_opt_lock;
alter table POSTING_RULE drop column ACK_OPT_LOCK;
alter table POSTING_RULE drop column ack_opt_lock;
alter table ROLE drop column ACK_OPT_LOCK;
alter table ROLE drop column ack_opt_lock;
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_;
alter table CREDIT_NOTE drop column ACK_OPT_LOCK;
alter table CREDIT_NOTE drop column ack_opt_lock;
alter table EMPLOYEE drop column ACK_OPT_LOCK;
alter table EMPLOYEE drop column ack_opt_lock;
alter table VALUATION_CURRICULAR_COURSE drop column ACK_OPT_LOCK;
alter table VALUATION_CURRICULAR_COURSE drop column ack_opt_lock;
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_;
alter table SHIFT_PROFESSORSHIP drop column ACK_OPT_LOCK;
alter table SHIFT_PROFESSORSHIP drop column ack_opt_lock;
alter table PERSON_EXTENSION drop column ACK_OPT_LOCK;
alter table PERSON_EXTENSION drop column ack_opt_lock;
alter table TRANSACTION drop column ACK_OPT_LOCK;
alter table TRANSACTION drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table SPACE_INFORMATION drop column ACK_OPT_LOCK;
alter table SPACE_INFORMATION drop column ack_opt_lock;
alter table PAYMENT_CODE drop column ACK_OPT_LOCK;
alter table PAYMENT_CODE drop column ack_opt_lock;
alter table RESEARCH_EVENT drop column ACK_OPT_LOCK;
alter table RESEARCH_EVENT drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table CONNECTION_RULE drop column ACK_OPT_LOCK;
alter table CONNECTION_RULE drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table SITE drop column ACK_OPT_LOCK;
alter table SITE drop column ack_opt_lock;
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_;
alter table PARTY drop column ACK_OPT_LOCK;
alter table PARTY drop column ack_opt_lock;
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 ENROLMENT_WRAPPER drop column ACK_OPT_LOCK;
alter table ENROLMENT_WRAPPER drop column ack_opt_lock;
alter table SENIOR drop column ACK_OPT_LOCK;
alter table SENIOR drop column ack_opt_lock;
alter table DEGREE_CURRICULAR_PLAN drop column ACK_OPT_LOCK;
alter table DEGREE_CURRICULAR_PLAN drop column ack_opt_lock;
alter table PARKING_GROUP drop column ACK_OPT_LOCK;
alter table PARKING_GROUP drop column ack_opt_lock;
alter table RESOURCE drop column ACK_OPT_LOCK;
alter table RESOURCE drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table RESULT_TEACHER drop column ACK_OPT_LOCK;
alter table RESULT_TEACHER drop column ack_opt_lock;
alter table ACADEMIC_SERVICE_REQUEST drop column ACK_OPT_LOCK;
alter table ACADEMIC_SERVICE_REQUEST drop column ack_opt_lock;
alter table REGISTRATION_STATE drop column ACK_OPT_LOCK;
alter table REGISTRATION_STATE drop column ack_opt_lock;
alter table CURRICULAR_RULE drop column ACK_OPT_LOCK;
alter table CURRICULAR_RULE drop column ack_opt_lock;
alter table CANDIDACY drop column ACK_OPT_LOCK;
alter table CANDIDACY drop column ack_opt_lock;
alter table LOCALITY drop column ACK_OPT_LOCK;
alter table LOCALITY drop column ack_opt_lock;
alter table EVENT drop column ACK_OPT_LOCK;
alter table EVENT drop column ack_opt_lock;
alter table NEW_PRESENTATION_MATERIAL drop column ACK_OPT_LOCK;
alter table NEW_PRESENTATION_MATERIAL drop column ack_opt_lock;
alter table NEW_TEST_ELEMENT drop column ACK_OPT_LOCK;
alter table NEW_TEST_ELEMENT drop column ack_opt_lock;
alter table SERVICE_AGREEMENT drop column ACK_OPT_LOCK;
alter table SERVICE_AGREEMENT drop column ack_opt_lock;
alter table PERSON_ACCOUNT drop column ACK_OPT_LOCK;
alter table PERSON_ACCOUNT drop column ack_opt_lock;
alter table RESEARCH_RESULT drop column ACK_OPT_LOCK;
alter table RESEARCH_RESULT drop column ack_opt_lock;
