update ATTENDS as t1, EXECUTION_COURSE as t2 set t1.OID_DISCIPLINA_EXECUCAO = t2.OID where t2.ID_INTERNAL = t1.KEY_DISCIPLINA_EXECUCAO;
update ATTENDS as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update ATTENDS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_GROUP_ATTEND as t1, ATTENDS as t2 set t1.OID_ATTENDS = t2.OID where t2.ID_INTERNAL = t1.KEY_ATTENDS;
update STUDENT_GROUP_ATTEND as t1, STUDENT_GROUP as t2 set t1.OID_STUDENT_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_GROUP;
update ATTENDS as t1, REGISTRATION as t2 set t1.OID_ALUNO = t2.OID where t2.ID_INTERNAL = t1.KEY_ALUNO;
update ENROLMENT_EVALUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ENROLMENT_EVALUATION as t1, MARK_SHEET as t2 set t1.OID_MARK_SHEET = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_MARK_SHEET;
update ENROLMENT_EVALUATION as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update ENROLMENT_EVALUATION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update ENROLMENT_EVALUATION as t1, PARTY as t2 set t1.OID_PERSON_RESPONSIBLE_FOR_GRADE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PERSON_RESPONSIBLE_FOR_GRADE;
update ENROLMENT_EVALUATION as t1, ENROLMENT_EVALUATION as t2 set t1.OID_RECTIFIED = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RECTIFIED;
update ENROLMENT_EVALUATION as t1, ENROLMENT_EVALUATION as t2 set t1.OID_RECTIFICATION = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RECTIFICATION;
update ENROLMENT_EVALUATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update ENROLMENT_EVALUATION as t1, EVENT as t2 set t1.OID_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_IMPROVEMENT_OF_APPROVED_ENROLMENT_EVENT;
update PROFESSIONAL_CATEGORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update UNIT_EXTRA_WORK_AMOUNT as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update UNIT_EXTRA_WORK_AMOUNT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXECUTION_PATH as t1, CONTENT as t2 set t1.OID_FUNCTIONALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_FUNCTIONALITY;
update EXECUTION_PATH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update IDENTIFICATION as t1, CARD as t2 set t1.OID_CARD = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_CARD;
update IDENTIFICATION as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update TEACHER_SERVICE_ITEM as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update RESOURCE_ALLOCATION as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update EVENT as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_CANDIDACY;
-- update PHD_PROCESS_STATE as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PROCESS;
update LIBRARY_CARD as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.CARD_EMITION_DATE = t1.CARD_EMITION_DATE, t1.LETTER_GENERATION_DATE = t1.LETTER_GENERATION_DATE where t2.ID_INTERNAL = t1.KEY_PERSON;
update LIBRARY_CARD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CARD_EMITION_DATE = t1.CARD_EMITION_DATE, t1.LETTER_GENERATION_DATE = t1.LETTER_GENERATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update LIBRARY_MISSING_LETTERS_DOCUMENTS as t1, LIBRARY_CARD as t2 set t1.OID_LIBRARY_CARD = t2.OID where t2.ID_INTERNAL = t1.KEY_LIBRARY_CARD;
update LIBRARY_MISSING_LETTERS_DOCUMENTS as t1, FILE as t2 set t1.OID_LIBRARY_MISSING_LETTERS_DOCUMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_LIBRARY_MISSING_LETTERS_DOCUMENT;
update LIBRARY_MISSING_CARDS_DOCUMENTS as t1, LIBRARY_CARD as t2 set t1.OID_LIBRARY_CARD = t2.OID where t2.ID_INTERNAL = t1.KEY_LIBRARY_CARD;
update LIBRARY_MISSING_CARDS_DOCUMENTS as t1, FILE as t2 set t1.OID_LIBRARY_MISSING_CARDS_DOCUMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_LIBRARY_MISSING_CARDS_DOCUMENT;
update CANDIDACY as t1, EVENT as t2 set t1.OID_DFA_CANDIDACY_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_DFA_CANDIDACY_EVENT;
update EVALUATION_METHOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVALUATION_METHOD as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update RESIDENCE_PRICE_TABLE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONTENT as t1, EXECUTION_PATH as t2 set t1.OID_EXECUTION_PATH_VALUE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PATH_VALUE;
update EMPLOYEE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_PERSON;
update EMPLOYEE as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update EMPLOYEE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ID_DOCUMENT_TYPE_OBJECT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update YEAR_DELEGATE_COURSE_INQUIRY as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update YEAR_DELEGATE_COURSE_INQUIRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update YEAR_DELEGATE_COURSE_INQUIRY as t1, DELEGATE as t2 set t1.OID_DELEGATE = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_DELEGATE;
update GRATUITY_VALUES as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update GRATUITY_VALUES as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRATUITY_VALUES as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update CONCLUSION_PROCESS as t1, EXECUTION_INTERVAL as t2 set t1.OID_CONCLUSION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_CONCLUSION_YEAR;
update CONCLUSION_PROCESS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONCLUSION_PROCESS as t1, CONCLUSION_PROCESS_VERSION as t2 set t1.OID_LAST_VERSION = t2.OID where t2.ID_INTERNAL = t1.KEY_LAST_VERSION;
update ANNOUNCEMENT_BOARD_BOOKMARK as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update ANNOUNCEMENT_BOARD_BOOKMARK as t1, CONTENT as t2 set t1.OID_ANNOUNCEMENT_BOARD = t2.OID where t2.ID_INTERNAL = t1.KEY_ANNOUNCEMENT_BOARD;
update TEST as t1, TEST_SCOPE as t2 set t1.OID_TEST_SCOPE = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEST_SCOPE;
update TEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update YEAR_STUDENT_SPECIAL_SEASON_CODE as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update YEAR_STUDENT_SPECIAL_SEASON_CODE as t1, SPECIAL_SEASON_CODE as t2 set t1.OID_SPECIAL_SEASON_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_SPECIAL_SEASON_CODE;
update YEAR_STUDENT_SPECIAL_SEASON_CODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update YEAR_STUDENT_SPECIAL_SEASON_CODE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update UNIT_COST_CENTER_CODE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update UNIT_COST_CENTER_CODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PHD_STUDY_PLAN as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_DEGREE;
-- update PHD_STUDY_PLAN as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PHD_STUDY_PLAN as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PROCESS;
update CREDIT_LINE as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update FILE as t1, THESIS as t2 set t1.OID_DISSERTATION_THESIS = t2.OID where t2.ID_INTERNAL = t1.KEY_DISSERTATION_THESIS;
update FILE as t1, THESIS as t2 set t1.OID_ABSTRACT_THESIS = t2.OID where t2.ID_INTERNAL = t1.KEY_ABSTRACT_THESIS;
update PERSONAL_GROUP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERSONAL_GROUP as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update GROUP_STUDENT as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update GROUP_STUDENT as t1, PROPOSAL as t2 set t1.OID_FINAL_DEGREE_WORK_PROPOSAL_CONFIRMATION = t2.OID where t2.ID_INTERNAL = t1.KEY_FINAL_DEGREE_WORK_PROPOSAL_CONFIRMATION;
update GROUP_STUDENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GROUP_STUDENT as t1, FINAL_DEGREE_WORK_GROUP as t2 set t1.OID_FINAL_DEGREE_DEGREE_WORK_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_FINAL_DEGREE_DEGREE_WORK_GROUP;
update NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update ENROLMENT_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t1, NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE as t2 set t1.OID_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_NOT_NEED_TO_ENROLL_IN_CURRICULAR_COURSE;
update PROCESS as t1, PROCESS as t2 set t1.OID_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PROCESS;
update PROCESS as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update PROCESS as t1, PUBLIC_CANDIDACY_HASH_CODE as t2 set t1.OID_CANDIDACY_HASH_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_HASH_CODE;
update UTIL_EMAIL_SENDER_UTIL_EMAIL_RECIPIENT as t1, SENDER as t2 set t1.OID_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER;
update UTIL_EMAIL_SENDER_UTIL_EMAIL_RECIPIENT as t1, RECIPIENT as t2 set t1.OID_RECIPIENT = t2.OID where t2.ID_INTERNAL = t1.KEY_RECIPIENT;
update SENDER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESEARCH_RESULT as t1, PARTY as t2 set t1.OID_CREATOR = t2.OID, t1.LAST_MODIFICATION_DATE = t1.LAST_MODIFICATION_DATE where t2.ID_INTERNAL = t1.KEY_CREATOR;
update RESEARCH_RESULT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE = t1.LAST_MODIFICATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESEARCH_RESULT as t1, COUNTRY as t2 set t1.OID_COUNTRY = t2.OID, t1.LAST_MODIFICATION_DATE = t1.LAST_MODIFICATION_DATE where t2.ID_INTERNAL = t1.KEY_COUNTRY;
update STUDENT_INQUIRIES_COURSE_RESULT as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID, t1.UPLOAD_DATE_TIME = t1.UPLOAD_DATE_TIME, t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE = t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update STUDENT_INQUIRIES_COURSE_RESULT as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID, t1.UPLOAD_DATE_TIME = t1.UPLOAD_DATE_TIME, t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE = t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update STUDENT_INQUIRIES_COURSE_RESULT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.UPLOAD_DATE_TIME = t1.UPLOAD_DATE_TIME, t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE = t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_INQUIRIES_COURSE_RESULT as t1, COORDINATOR as t2 set t1.OID_COORDINATOR_COMMENT = t2.OID, t1.UPLOAD_DATE_TIME = t1.UPLOAD_DATE_TIME, t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE = t1.COURSE_RESULTS_COORDINATOR_COMMENT_DATE where t2.ID_INTERNAL = t1.KEY_COORDINATOR_COMMENT;
update COURSE_LOAD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COURSE_LOAD as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update COURSE_LOAD_SHIFT as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update COURSE_LOAD_SHIFT as t1, COURSE_LOAD as t2 set t1.OID_COURSE_LOAD = t2.OID where t2.ID_INTERNAL = t1.KEY_COURSE_LOAD;
update PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t1, PARTY as t2 set t1.OID_OWNER = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_OWNER;
update PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t1, PARTY as t2 set t1.OID_REQUESTOR = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_REQUESTOR;
update TEACHER_SERVICE as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update TEACHER_SERVICE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update TEACHER_SERVICE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_TEST_QUESTION as t1, DISTRIBUTED_TEST as t2 set t1.OID_DISTRIBUTED_TEST = t2.OID where t2.ID_INTERNAL = t1.KEY_DISTRIBUTED_TEST;
update STUDENT_TEST_QUESTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_TEST_QUESTION as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update STUDENT_TEST_QUESTION as t1, QUESTION as t2 set t1.OID_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_QUESTION;
update REQUEST_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REQUEST_LOG as t1, REQUEST_MAPPING as t2 set t1.OID_MAPPING = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_MAPPING;
update REQUEST_LOG as t1, ERROR_LOG as t2 set t1.OID_ERROR_LOG = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_ERROR_LOG;
update GUIDE_ENTRY as t1, TRANSACTION as t2 set t1.OID_PAYMENT_TRANSACTION = t2.OID where t2.ID_INTERNAL = t1.KEY_PAYMENT_TRANSACTION;
update GUIDE_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GUIDE_ENTRY as t1, GUIDE as t2 set t1.OID_GUIDE = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDE;
update INDIVIDUAL_CANDIDACY as t1, DEGREE as t2 set t1.OID_ACCEPTED_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCEPTED_DEGREE;
update METADATA as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update METADATA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COMPETENCE_COURSE_LOAD as t1, COMPETENCE_COURSE_INFORMATION as t2 set t1.OID_COMPETENCE_COURSE_INFORMATION = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE_INFORMATION;
update COMPETENCE_COURSE_LOAD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ERROR_LOG as t1, EXCEPTION_TYPE as t2 set t1.OID_EXCEPTION = t2.OID where t2.ID_INTERNAL = t1.KEY_EXCEPTION;
update ERROR_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY_CONTACT as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update PARTY_CONTACT as t1, RESEARCHER as t2 set t1.OID_RESEARCHER = t2.OID where t2.ID_INTERNAL = t1.KEY_RESEARCHER;
update PARTY_CONTACT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SPACE_INFORMATION as t1, LOCALITY as t2 set t1.OID_LOCALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_LOCALITY;
update CONTENT as t1, FILE as t2 set t1.OID_LOGO = t2.OID where t2.ID_INTERNAL = t1.KEY_LOGO;
update UNIT_SITE_MANAGERS as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update UNIT_SITE_MANAGERS as t1, CONTENT as t2 set t1.OID_UNIT_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_SITE;
update CONTENT as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update PUBLIC_CANDIDACY_HASH_CODE as t1, PROCESS as t2 set t1.OID_PHD_PROGRAM_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM_CANDIDACY_PROCESS;
update SIBS_PAYMENT_FILE_ENTRY as t1, SIBS_PAYMENT_FILE as t2 set t1.OID_SIBS_PAYMENT_FILE = t2.OID, t1.TRANSACTION_DATE_DATE_TIME = t1.TRANSACTION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_SIBS_PAYMENT_FILE;
update SIBS_PAYMENT_FILE_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.TRANSACTION_DATE_DATE_TIME = t1.TRANSACTION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WEEKLY_WORK_LOAD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WEEKLY_WORK_LOAD as t1, ATTENDS as t2 set t1.OID_ATTENDS = t2.OID where t2.ID_INTERNAL = t1.KEY_ATTENDS;
update UNIT_SITE_BANNER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update UNIT_SITE_BANNER as t1, CONTENT as t2 set t1.OID_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_SITE;
update UNIT_SITE_BANNER as t1, FILE as t2 set t1.OID_MAIN_IMAGE = t2.OID where t2.ID_INTERNAL = t1.KEY_MAIN_IMAGE;
update UNIT_SITE_BANNER as t1, FILE as t2 set t1.OID_BACKGROUND_IMAGE = t2.OID where t2.ID_INTERNAL = t1.KEY_BACKGROUND_IMAGE;
update CONCLUSION_PROCESS as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update RESEARCH_INTEREST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESEARCH_INTEREST as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update DELEGATE_ELECTION_VOTING_STUDENT as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update DELEGATE_ELECTION_VOTING_STUDENT as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update STUDENT as t1, ALUMNI as t2 set t1.OID_ALUMNI = t2.OID where t2.ID_INTERNAL = t1.KEY_ALUMNI;
update DELEGATE_ELECTION_STUDENT as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update DELEGATE_ELECTION_STUDENT as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update STUDENT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update STUDENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE_ELECTION_CANDIDATES_STUDENT as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update DELEGATE_ELECTION_CANDIDATES_STUDENT as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update PHD_ALERT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_ACTIVE_PHD_ALERTS = t2.OID, t1.FIRE_DATE = t1.FIRE_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_ACTIVE_PHD_ALERTS;
update PHD_ALERT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.FIRE_DATE = t1.FIRE_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHD_ALERT as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID, t1.FIRE_DATE = t1.FIRE_DATE where t2.ID_INTERNAL = t1.KEY_PROCESS;
update PUBLICATION_COLLABORATORS as t1, PARTY as t2 set t1.OID_RESEARCH_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESEARCH_UNIT;
update PUBLICATION_COLLABORATORS as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update CURRICULAR_PERIOD as t1, CURRICULAR_PERIOD as t2 set t1.OID_PARENT = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT;
update CURRICULAR_PERIOD as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update CURRICULAR_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_SERVICE_REQUEST_YEAR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SHIFT_ENROLMENT as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID, t1.CREATED_ON = t1.CREATED_ON where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SHIFT_ENROLMENT as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID, t1.CREATED_ON = t1.CREATED_ON where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update SHIFT_ENROLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATED_ON = t1.CREATED_ON where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOCK_UNIT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHOTOGRAPH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_PENDING_HOLDER = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_PENDING_HOLDER;
update PHOTOGRAPH as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_PERSON;
update PHOTOGRAPH as t1, PHOTOGRAPH as t2 set t1.OID_NEXT = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_NEXT;
update PHOTOGRAPH as t1, PHOTOGRAPH as t2 set t1.OID_PREVIOUS = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_PREVIOUS;
update PHOTOGRAPH as t1, PARTY as t2 set t1.OID_REJECTOR = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_REJECTOR;
update PHOTOGRAPH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.SUBMISSION = t1.SUBMISSION, t1.STATE_CHANGE = t1.STATE_CHANGE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESIDENCE_CANDIDACIES as t1, STUDENT_DATA_BY_EXECUTION_YEAR as t2 set t1.OID_STUDENT_DATA_BY_EXECUTION_YEAR = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT_DATA_BY_EXECUTION_YEAR;
update RESIDENCE_CANDIDACIES as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_MODULE as t1, STUDENT_COURSE_REPORT as t2 set t1.OID_STUDENT_COURSE_REPORT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_COURSE_REPORT;
update STANDALONE_INDIVIDUAL_CANDIDACY_CURRICULAR_COURSES as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update STANDALONE_INDIVIDUAL_CANDIDACY_CURRICULAR_COURSES as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_STANDALONE_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_STANDALONE_INDIVIDUAL_CANDIDACY;
update OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE as t1, CURRICULAR_COURSE_EQUIVALENCE as t2 set t1.OID_CURRICULAR_COURSE_EQUIVALENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE_EQUIVALENCE;
update OLD_CURRICULAR_COURSE_CURRICULAR_COURSE_EQUIVALENCE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update DEGREE_MODULE as t1, SCIENTIFIC_AREA as t2 set t1.OID_SCIENTIFIC_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_SCIENTIFIC_AREA;
update DEGREE_MODULE as t1, COMPETENCE_COURSE as t2 set t1.OID_COMPETENCE_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE;
update CURRICULAR_COURSE_EXECUTION_COURSE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update CURRICULAR_COURSE_EXECUTION_COURSE as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update DEGREE_MODULE as t1, UNIVERSITY as t2 set t1.OID_UNIVERSITY = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIVERSITY;
update DEGREE_MODULE as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES as t1, CURRICULUM_MODULE as t2 set t1.OID_CREDITS_DISMISSAL = t2.OID where t2.ID_INTERNAL = t1.KEY_CREDITS_DISMISSAL;
update CREDITS_DISMISSAL_NO_ENROL_CURRICULAR_COURSES as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update SCHEDULE_WORK_SCHEDULE as t1, SCHEDULE as t2 set t1.OID_SCHEDULE = t2.OID where t2.ID_INTERNAL = t1.KEY_SCHEDULE;
update SCHEDULE_WORK_SCHEDULE as t1, WORK_SCHEDULE as t2 set t1.OID_WORK_SCHEDULE = t2.OID where t2.ID_INTERNAL = t1.KEY_WORK_SCHEDULE;
update WORK_SCHEDULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WORK_SCHEDULE as t1, PERIODICITY as t2 set t1.OID_PERIODICITY = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIODICITY;
update WORK_SCHEDULE as t1, WORK_SCHEDULE_TYPE as t2 set t1.OID_WORK_SCHEDULE_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_WORK_SCHEDULE_TYPE;
update ACADEMIC_SERVICE_REQUEST_SITUATION as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_ACADEMIC_SERVICE_REQUEST = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_ACADEMIC_SERVICE_REQUEST;
update ACADEMIC_SERVICE_REQUEST_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_SERVICE_REQUEST_SITUATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update CONTENT as t1, EXECUTION_COURSE as t2 set t1.OID_SITE_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_SITE_EXECUTION_COURSE;
update RESOURCE as t1, RESOURCE as t2 set t1.OID_SUROUNDING_SPACE = t2.OID where t2.ID_INTERNAL = t1.KEY_SUROUNDING_SPACE;
update TEACHING_INQUIRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHING_INQUIRY as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update SCHEDULEING as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_ALLOCATION as t1, PARTY as t2 set t1.OID_REQUESTOR = t2.OID, t1.BEGIN_DATE_TIME = t1.BEGIN_DATE_TIME, t1.END_DATE_TIME = t1.END_DATE_TIME where t2.ID_INTERNAL = t1.KEY_REQUESTOR;
update PROFESSIONAL_RELATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_SECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SECTION;
update NEW_TEST_ELEMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROJECT_EVENT_ASSOCIATION as t1, EVENT_EDITION as t2 set t1.OID_EVENT_EDITION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT_EDITION;
update PROJECT_EVENT_ASSOCIATION as t1, PROJECT as t2 set t1.OID_PROJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_PROJECT;
update PROJECT_EVENT_ASSOCIATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update VIGILANT_WRAPPER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update VIGILANT_WRAPPER as t1, VIGILANT_GROUP as t2 set t1.OID_VIGILANT_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_VIGILANT_GROUP;
update VIGILANT_WRAPPER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update EXTRA_CURRICULAR_CERTIFICATE_REQUEST_ENROLMENT as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update EXTRA_CURRICULAR_CERTIFICATE_REQUEST_ENROLMENT as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_EXTRA_CURRICULAR_CERTIFICATE_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTRA_CURRICULAR_CERTIFICATE_REQUEST;
update PUBLIC_CANDIDACY_HASH_CODE as t1, PROCESS as t2 set t1.OID_PHD_PROGRAM_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM_CANDIDACY_PROCESS;
update PUBLIC_CANDIDACY_HASH_CODE as t1, PHD_CANDIDACY_REFEREE_LETTER as t2 set t1.OID_LETTER = t2.OID where t2.ID_INTERNAL = t1.KEY_LETTER;
update ARTICLE_ASSOCIATION as t1, PARTY as t2 set t1.OID_CREATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_CREATOR;
update ARTICLE_ASSOCIATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ARTICLE_ASSOCIATION as t1, JOURNAL_ISSUE as t2 set t1.OID_JOURNAL_ISSUE = t2.OID where t2.ID_INTERNAL = t1.KEY_JOURNAL_ISSUE;
update ARTICLE_ASSOCIATION as t1, RESEARCH_RESULT as t2 set t1.OID_ARTICLE = t2.OID where t2.ID_INTERNAL = t1.KEY_ARTICLE;
update RESOURCE_ALLOCATION as t1, RESOURCE as t2 set t1.OID_MATERIAL = t2.OID where t2.ID_INTERNAL = t1.KEY_MATERIAL;
update ACCOUNTING_TRANSACTION_DETAIL as t1, ACCOUNTING_TRANSACTION as t2 set t1.OID_TRANSACTION = t2.OID, t1.WHEN_PROCESSED = t1.WHEN_PROCESSED, t1.WHEN_REGISTERED = t1.WHEN_REGISTERED where t2.ID_INTERNAL = t1.KEY_TRANSACTION;
update ACCOUNTING_TRANSACTION_DETAIL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_PROCESSED = t1.WHEN_PROCESSED, t1.WHEN_REGISTERED = t1.WHEN_REGISTERED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_SERVICE_REQUEST as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_EQUIVALENCE_PLAN_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN_REQUEST;
update CONCLUSION_PROCESS_VERSION as t1, PARTY as t2 set t1.OID_RESPONSIBLE = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE;
update CONCLUSION_PROCESS_VERSION as t1, EXECUTION_INTERVAL as t2 set t1.OID_CONCLUSION_YEAR = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CONCLUSION_YEAR;
update CONCLUSION_PROCESS_VERSION as t1, CONCLUSION_PROCESS as t2 set t1.OID_LAST_VERSION_CONCLUSION_PROCESS = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_LAST_VERSION_CONCLUSION_PROCESS;
update CONCLUSION_PROCESS_VERSION as t1, EXECUTION_INTERVAL as t2 set t1.OID_INGRESSION_YEAR = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_INGRESSION_YEAR;
update CONCLUSION_PROCESS_VERSION as t1, CONCLUSION_PROCESS as t2 set t1.OID_CONCLUSION_PROCESS = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CONCLUSION_PROCESS;
update CONCLUSION_PROCESS_VERSION as t1, MASTER_DEGREE_THESIS as t2 set t1.OID_MASTER_DEGREE_THESIS = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_THESIS;
update CONCLUSION_PROCESS_VERSION as t1, CURRICULUM_MODULE as t2 set t1.OID_DISSERTATION_ENROLMENT = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_DISSERTATION_ENROLMENT;
update CONCLUSION_PROCESS_VERSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update UNIVERSITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SHIFT_SCHOOL_CLASS as t1, SCHOOL_CLASS as t2 set t1.OID_SCHOOL_CLASS = t2.OID where t2.ID_INTERNAL = t1.KEY_SCHOOL_CLASS;
update SHIFT_SCHOOL_CLASS as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SHIFT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SHIFT_STUDENT as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SHIFT_STUDENT as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update REQUEST_MAPPING as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_ANSWER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_ANSWER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update NEW_ANSWER as t1, NEW_TEST_ELEMENT as t2 set t1.OID_ATOMIC_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_ATOMIC_QUESTION;
update FILE as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_SOURCE = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE;
update TEST_QUESTION as t1, TEST as t2 set t1.OID_TEST = t2.OID where t2.ID_INTERNAL = t1.KEY_TEST;
update TEST_QUESTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEST_QUESTION as t1, QUESTION as t2 set t1.OID_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_QUESTION;
update EMPLOYEE_PROFESSIONAL_EXEMPTION as t1, SERVICE_EXEMPTION as t2 set t1.OID_SERVICE_EXEMPTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SERVICE_EXEMPTION;
update ACCOUNT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACCOUNT as t1, PARTY as t2 set t1.OID_PARTY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_PARTY;
update EVENT as t1, CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update GRANT_OWNER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_OWNER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update MARK_SHEET as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update MARK_SHEET as t1, EMPLOYEE as t2 set t1.OID_CONFIRMATION_EMPLOYEE = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CONFIRMATION_EMPLOYEE;
update MARK_SHEET as t1, TEACHER as t2 set t1.OID_RESPONSIBLE_TEACHER = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_TEACHER;
update MARK_SHEET as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MARK_SHEET as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update MARK_SHEET as t1, EMPLOYEE as t2 set t1.OID_CREATION_EMPLOYEE = t2.OID, t1.CONFIRMATION_DATE_DATE_TIME = t1.CONFIRMATION_DATE_DATE_TIME, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME, t1.EVALUATION_DATE_DATE_TIME = t1.EVALUATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CREATION_EMPLOYEE;
update PHD_PROGRAM_GUIDING as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update SPACE_INFORMATION as t1, RESOURCE as t2 set t1.OID_SPACE = t2.OID where t2.ID_INTERNAL = t1.KEY_SPACE;
update SPACE_INFORMATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_ALLOCATION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update TEACHER_DEGREE_FINAL_PROJECT_STUDENT as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update TEACHER_DEGREE_FINAL_PROJECT_STUDENT as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update TEACHER_DEGREE_FINAL_PROJECT_STUDENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_DEGREE_FINAL_PROJECT_STUDENT as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update SENDER as t1, EXECUTION_COURSE as t2 set t1.OID_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_COURSE;
update GENERAL_CLASS_PROPERTY as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update RESTRICTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESTRICTION as t1, PRECEDENCE as t2 set t1.OID_PRECEDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_PRECEDENCE;
update PRECEDENCE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PRECEDENCE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update CONNECTION_RULE as t1, PARTY_TYPE as t2 set t1.OID_ALLOWED_PARENT_PARTY_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_ALLOWED_PARENT_PARTY_TYPE;
update CONNECTION_RULE as t1, PARTY_TYPE as t2 set t1.OID_ALLOWED_CHILD_PARTY_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_ALLOWED_CHILD_PARTY_TYPE;
update CONNECTION_RULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONNECTION_RULE as t1, ACCOUNTABILITY_TYPE as t2 set t1.OID_ACCOUNTABILITY_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCOUNTABILITY_TYPE;
-- update PHD_PROCESS_STATE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PERSON;
-- update PHD_PROCESS_STATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SERVICE_EXEMPTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PUBLIC_CANDIDACY_HASH_CODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SENDER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_SYSTEM_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_SYSTEM_ROOT_DOMAIN_OBJECT;
update PARTY as t1, PHD_PROGRAM as t2 set t1.OID_PHD_PROGRAM = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM;
update CREDIT_LINE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_PROFESSIONAL_EXEMPTION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_PROFESSIONAL_EXEMPTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_RESPONSIBILITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_RESPONSIBILITY as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update RESOURCE_RESPONSIBILITY as t1, RESOURCE as t2 set t1.OID_RESOURCE = t2.OID where t2.ID_INTERNAL = t1.KEY_RESOURCE;
update CONTENT as t1, FILE as t2 set t1.OID_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_FILE;
update PROCESS as t1, PUBLIC_CANDIDACY_HASH_CODE as t2 set t1.OID_CANDIDACY_HASH_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_HASH_CODE;
update PROCESS as t1, PROCESS as t2 set t1.OID_INDIVIDUAL_PROGRAM_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_PROGRAM_PROCESS;
update PROCESS as t1, EVENT as t2 set t1.OID_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT;
update PROCESS as t1, CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update PUBLICATIONS_NUMBER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PUBLICATIONS_NUMBER as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update QUEUE_JOB as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update CREDIT_NOTE as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update CREDIT_NOTE as t1, RECEIPT as t2 set t1.OID_RECEIPT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_RECEIPT;
update CREDIT_NOTE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SIBS_PAYMENT_FILE_PROCESS_REPORT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_PROCESSED = t1.WHEN_PROCESSED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTICIPATION as t1, SCIENTIFIC_JOURNAL as t2 set t1.OID_SCIENTIFIC_JOURNAL = t2.OID where t2.ID_INTERNAL = t1.KEY_SCIENTIFIC_JOURNAL;
update EXAM_DATE_CERTIFICATE_REQUEST_EXAM as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_EXAM_DATE_CERTIFICATE_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_EXAM_DATE_CERTIFICATE_REQUEST;
update EXAM_DATE_CERTIFICATE_REQUEST_EXAM as t1, EVALUATION as t2 set t1.OID_EXAM = t2.OID where t2.ID_INTERNAL = t1.KEY_EXAM;
update ACADEMIC_SERVICE_REQUEST as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update EXAM_DATE_CERTIFICATE_REQUEST_ENROLMENT as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_EXAM_DATE_CERTIFICATE_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_EXAM_DATE_CERTIFICATE_REQUEST;
update EXAM_DATE_CERTIFICATE_REQUEST_ENROLMENT as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update GROUP_PROPOSAL as t1, PROPOSAL as t2 set t1.OID_FINAL_DEGREE_WORK_PROPOSAL = t2.OID where t2.ID_INTERNAL = t1.KEY_FINAL_DEGREE_WORK_PROPOSAL;
update GROUP_PROPOSAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GROUP_PROPOSAL as t1, FINAL_DEGREE_WORK_GROUP as t2 set t1.OID_FINAL_DEGREE_DEGREE_WORK_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_FINAL_DEGREE_DEGREE_WORK_GROUP;
update ASSIDUOUSNESS_RECORD as t1, JUSTIFICATION_MOTIVE as t2 set t1.OID_JUSTIFICATION_MOTIVE = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_JUSTIFICATION_MOTIVE;
update ASSIDUOUSNESS_RECORD as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update PROJECT_PARTICIPATION as t1, PROJECT as t2 set t1.OID_PROJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_PROJECT;
update PROJECT_PARTICIPATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROJECT_PARTICIPATION as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update JUSTIFICATION_MOTIVE as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update JUSTIFICATION_MOTIVE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE_LOCAL_CONTENT_METADATA as t1, FILE_LOCAL_CONTENT as t2 set t1.OID_CONTENT = t2.OID where t2.ID_INTERNAL = t1.KEY_CONTENT;
update ACADEMIC_CALENDAR_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_DEFAULT_ROOT_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_DEFAULT_ROOT_ENTRY;
update ACADEMIC_CALENDAR_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_ROOT_ENTRIES = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_ROOT_ENTRIES;
update ASSIDUOUSNESS_STATUS_HISTORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_STATUS_HISTORY as t1, ASSIDUOUSNESS_STATUS as t2 set t1.OID_ASSIDUOUSNESS_STATUS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_STATUS;
update ASSIDUOUSNESS_STATUS_HISTORY as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update ASSIDUOUSNESS_STATUS_HISTORY as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update CANDIDATE_ENROLMENT as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update CANDIDATE_ENROLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDATE_ENROLMENT as t1, MASTER_DEGREE_CANDIDATE as t2 set t1.OID_MASTER_DEGREE_CANDIDATE = t2.OID where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_CANDIDATE;
update TUTORSHIP as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update TUTORSHIP as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update TUTORSHIP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STANDALONE_ENROLMENT_CERTIFICATE_REQUEST_ENROLMENT as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update STANDALONE_ENROLMENT_CERTIFICATE_REQUEST_ENROLMENT as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_STANDALONE_ENROLMENT_CERTIFICATE_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_STANDALONE_ENROLMENT_CERTIFICATE_REQUEST;
update ASSIDUOUSNESS_CAMPUS_HISTORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_CAMPUS_HISTORY as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update ASSIDUOUSNESS_CAMPUS_HISTORY as t1, RESOURCE as t2 set t1.OID_CAMPUS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_CAMPUS;
update ASSIDUOUSNESS_CAMPUS_HISTORY as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update QUALIFICATION as t1, PARTY as t2 set t1.OID_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION;
update QUALIFICATION as t1, EDUCATION_AREA as t2 set t1.OID_EDUCATION_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_EDUCATION_AREA;
update PARKING_REQUEST as t1, PARKING_PARTY as t2 set t1.OID_PARKING_PARTY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_PARKING_PARTY;
update PARKING_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARKING_REQUEST as t1, NEW_PARKING_DOCUMENT as t2 set t1.OID_DRIVER_LICENSE_DOCUMENT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_DRIVER_LICENSE_DOCUMENT;
update EVALUATION_COMPLAIN as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVALUATION_COMPLAIN as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update EVALUATION_COMPLAIN as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update EVALUATION_COMPLAIN as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update FORUM_SUBSCRIPTION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update FORUM_SUBSCRIPTION as t1, CONTENT as t2 set t1.OID_FORUM = t2.OID where t2.ID_INTERNAL = t1.KEY_FORUM;
update FORUM_SUBSCRIPTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update THESIS_LIBRARY_OPERATION as t1, PARTY as t2 set t1.OID_PERFORMER = t2.OID, t1.OPERATION = t1.OPERATION where t2.ID_INTERNAL = t1.KEY_PERFORMER;
update THESIS_LIBRARY_OPERATION as t1, THESIS_LIBRARY_OPERATION as t2 set t1.OID_NEXT = t2.OID, t1.OPERATION = t1.OPERATION where t2.ID_INTERNAL = t1.KEY_NEXT;
update THESIS_LIBRARY_OPERATION as t1, THESIS_LIBRARY_OPERATION as t2 set t1.OID_PREVIOUS = t2.OID, t1.OPERATION = t1.OPERATION where t2.ID_INTERNAL = t1.KEY_PREVIOUS;
update THESIS_LIBRARY_OPERATION as t1, THESIS as t2 set t1.OID_THESIS = t2.OID, t1.OPERATION = t1.OPERATION where t2.ID_INTERNAL = t1.KEY_THESIS;
update EXTRA_WORK_AUTHORIZATION as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update EXTRA_WORK_AUTHORIZATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXTRA_WORK_AUTHORIZATION as t1, PARTY as t2 set t1.OID_PAYING_UNIT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_PAYING_UNIT;
update EXTRA_WORK_AUTHORIZATION as t1, PARTY as t2 set t1.OID_WORKING_UNIT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_WORKING_UNIT;
update INSTALLMENT as t1, PAYMENT_PLAN as t2 set t1.OID_PAYMENT_PLAN = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PAYMENT_PLAN;
update INSTALLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ANNOUNCEMENT_CATEGORY_ANNOUNCEMENT as t1, ANNOUNCEMENT_CATEGORY as t2 set t1.OID_ANNOUNCEMENT_CATEGORY = t2.OID where t2.ID_INTERNAL = t1.KEY_ANNOUNCEMENT_CATEGORY;
update ANNOUNCEMENT_CATEGORY_ANNOUNCEMENT as t1, CONTENT as t2 set t1.OID_ANNOUNCEMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ANNOUNCEMENT;
update ANNOUNCEMENT_CATEGORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WORK_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_PERSONAL_EXPECTATION_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_PERSONAL_EXPECTATION_PERIOD as t1, DEPARTMENT as t2 set t1.OID_DEPARTMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_DEPARTMENT;
update TEACHER_PERSONAL_EXPECTATION_PERIOD as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update RESEARCHER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update RESEARCHER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXECUTION_INTERVAL as t1, INSURANCE_VALUE as t2 set t1.OID_INSURANCE_VALUE = t2.OID where t2.ID_INTERNAL = t1.KEY_INSURANCE_VALUE;
update EXECUTION_INTERVAL as t1, SHIFT_DISTRIBUTION as t2 set t1.OID_SHIFT_DISTRIBUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT_DISTRIBUTION;
update EXECUTION_INTERVAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR;
update FILE_TAGGING as t1, UNIT_FILE_TAG as t2 set t1.OID_UNIT_FILE_TAG = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_FILE_TAG;
update FILE_TAGGING as t1, FILE as t2 set t1.OID_UNIT_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_FILE;
update UNIT_FILE_TAG as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update UNIT_FILE_TAG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVALUATION_EXECUTION_COURSE as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update EVALUATION_EXECUTION_COURSE as t1, EVALUATION as t2 set t1.OID_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVALUATION;
update EVALUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_PERMISSION_UNIT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_QUESTION;
update NEW_PERMISSION_UNIT as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update NEW_PERMISSION_UNIT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, PHD_CANDIDACY_REFEREE_LETTER as t2 set t1.OID_LETTER = t2.OID where t2.ID_INTERNAL = t1.KEY_LETTER;
update CREDITS_IN_ANY_SECUNDARY_AREA as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update CREDITS_IN_ANY_SECUNDARY_AREA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CREDITS_IN_ANY_SECUNDARY_AREA as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update STUDENT_STATUTE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_STATUTE as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update STUDENT_STATUTE as t1, EXECUTION_INTERVAL as t2 set t1.OID_END_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_END_EXECUTION_PERIOD;
update STUDENT_STATUTE as t1, EXECUTION_INTERVAL as t2 set t1.OID_BEGIN_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_BEGIN_EXECUTION_PERIOD;
update PARTICIPATION as t1, RESEARCH_EVENT as t2 set t1.OID_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT;
update TEACHER_PERSONAL_EXPECTATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_PERSONAL_EXPECTATION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update TEACHER_PERSONAL_EXPECTATION as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update COURSE_EQUIVALENCY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COURSE_EQUIVALENCY as t1, MODALITY as t2 set t1.OID_MODALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_MODALITY;
update COURSE_EQUIVALENCY_THEME as t1, COURSE_EQUIVALENCY as t2 set t1.OID_COURSE_EQUIVALENCY = t2.OID where t2.ID_INTERNAL = t1.KEY_COURSE_EQUIVALENCY;
update COURSE_EQUIVALENCY_THEME as t1, THEME as t2 set t1.OID_THEME = t2.OID where t2.ID_INTERNAL = t1.KEY_THEME;
update COURSE_EQUIVALENCY as t1, SEMINARY as t2 set t1.OID_SEMINARY = t2.OID where t2.ID_INTERNAL = t1.KEY_SEMINARY;
update COURSE_EQUIVALENCY as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update REPLY_TO as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update EMPLOYEE_EXTRA_WORK_AUTHORIZATION as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update EMPLOYEE_EXTRA_WORK_AUTHORIZATION as t1, EXTRA_WORK_AUTHORIZATION as t2 set t1.OID_EXTRA_WORK_AUTHORIZATION = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_EXTRA_WORK_AUTHORIZATION;
update EMPLOYEE_EXTRA_WORK_AUTHORIZATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_EXTRA_WORK_AUTHORIZATION as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update GRANT_INSURANCE as t1, GRANT_PAYMENT_ENTITY as t2 set t1.OID_GRANT_PAYMENT_ENTITY = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_PAYMENT_ENTITY;
update GRANT_INSURANCE as t1, GRANT_CONTRACT as t2 set t1.OID_GRANT_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_CONTRACT;
update GRANT_INSURANCE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROCESS_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROCESS_LOG as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PROCESS;
update FILE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.UPLOAD_TIME = t1.UPLOAD_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, FILE_LOCAL_CONTENT as t2 set t1.OID_LOCAL_CONTENT = t2.OID, t1.UPLOAD_TIME = t1.UPLOAD_TIME where t2.ID_INTERNAL = t1.KEY_LOCAL_CONTENT;
update ACADEMIC_SERVICE_REQUEST as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update MODALITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SUPPORT_REQUEST as t1, CONTENT as t2 set t1.OID_REQUEST_CONTEXT = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_REQUEST_CONTEXT;
update SUPPORT_REQUEST as t1, PARTY as t2 set t1.OID_REQUESTER = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_REQUESTER;
update SUPPORT_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROPOSAL_BRANCH as t1, PROPOSAL as t2 set t1.OID_PROPOSAL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROPOSAL;
update PROPOSAL_BRANCH as t1, BRANCH as t2 set t1.OID_BRANCH = t2.OID where t2.ID_INTERNAL = t1.KEY_BRANCH;
update PROPOSAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROPOSAL as t1, FINAL_DEGREE_WORK_GROUP as t2 set t1.OID_GROUP_ATTRIBUTED = t2.OID where t2.ID_INTERNAL = t1.KEY_GROUP_ATTRIBUTED;
update PROPOSAL as t1, SCHEDULEING as t2 set t1.OID_SCHEDULEING = t2.OID where t2.ID_INTERNAL = t1.KEY_SCHEDULEING;
update PROPOSAL as t1, FINAL_DEGREE_WORK_GROUP as t2 set t1.OID_GROUP_ATTRIBUTED_BY_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_GROUP_ATTRIBUTED_BY_TEACHER;
update PROPOSAL as t1, PARTY as t2 set t1.OID_COORIENTATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_COORIENTATOR;
update PROPOSAL as t1, PARTY as t2 set t1.OID_ORIENTATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_ORIENTATOR;
update FILE as t1, RESEARCH_RESULT as t2 set t1.OID_RESULT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESULT;
update INQUIRY_RESPONSE_PERIOD as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.BEGIN = t1.BEGIN, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update INQUIRY_RESPONSE_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN = t1.BEGIN, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PAYMENT_CODE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update CANDIDACY as t1, PROCESS as t2 set t1.OID_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PROCESS;
update GRANT_SUBSIDY as t1, GRANT_CONTRACT as t2 set t1.OID_GRANT_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_CONTRACT;
update GRANT_SUBSIDY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update ASSIDUOUSNESS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_CLOSED_DAY as t1, ASSIDUOUSNESS_CLOSED_MONTH as t2 set t1.OID_ASSIDUOUSNESS_CLOSED_MONTH = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_CLOSED_MONTH;
update ASSIDUOUSNESS_CLOSED_DAY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REGISTRATION_DATA_BY_EXECUTION_YEAR as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update REGISTRATION_DATA_BY_EXECUTION_YEAR as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update REGISTRATION_DATA_BY_EXECUTION_YEAR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVENT as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update NEW_PRESENTATION_MATERIAL as t1, NEW_TEST_ELEMENT as t2 set t1.OID_TEST_ELEMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_TEST_ELEMENT;
update NEW_PRESENTATION_MATERIAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PAYMENT_PLAN as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PAYMENT_PLAN as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update PAYMENT_PHASE as t1, GRATUITY_VALUES as t2 set t1.OID_GRATUITY_VALUES = t2.OID where t2.ID_INTERNAL = t1.KEY_GRATUITY_VALUES;
update PAYMENT_PHASE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY as t1, ADMINISTRATIVE_OFFICE as t2 set t1.OID_ADMINISTRATIVE_OFFICE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE;
update UNIT_ACRONYM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, UNIT_SITE_BANNER as t2 set t1.OID_MAIN_BANNER = t2.OID where t2.ID_INTERNAL = t1.KEY_MAIN_BANNER;
update FILE as t1, UNIT_SITE_BANNER as t2 set t1.OID_BACKGROUND_BANNER = t2.OID where t2.ID_INTERNAL = t1.KEY_BACKGROUND_BANNER;
update SUPPORT_REQUEST as t1, ERROR_LOG as t2 set t1.OID_ERROR_LOG = t2.OID where t2.ID_INTERNAL = t1.KEY_ERROR_LOG;
-- update PHD_ALERT as t1, PUBLIC_CANDIDACY_HASH_CODE as t2 set t1.OID_REFEREE = t2.OID where t2.ID_INTERNAL = t1.KEY_REFEREE;
update EXECUTION_INTERVAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESULT_PARTICIPATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESULT_PARTICIPATION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update RESULT_PARTICIPATION as t1, RESEARCH_RESULT as t2 set t1.OID_RESULT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESULT;
update COUNTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COMPETENCE_COURSE_INFORMATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COMPETENCE_COURSE_INFORMATION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update COMPETENCE_COURSE_INFORMATION as t1, COMPETENCE_COURSE as t2 set t1.OID_COMPETENCE_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE;
update GRANT_ORIENTATION_TEACHER as t1, GRANT_CONTRACT as t2 set t1.OID_GRANT_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_CONTRACT;
update GRANT_ORIENTATION_TEACHER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_ORIENTATION_TEACHER as t1, TEACHER as t2 set t1.OID_ORIENTATION_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_ORIENTATION_TEACHER;
update INDIVIDUAL_CANDIDACY as t1, DEGREE as t2 set t1.OID_SELECTED_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_SELECTED_DEGREE;
update CURRICULAR_COURSE_SCOPE as t1, CURRICULAR_SEMESTER as t2 set t1.OID_CURRICULAR_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_SEMESTER;
update WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE as t1, EVALUATION as t2 set t1.OID_WRITTEN_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION;
update WRITTEN_EVALUATION_CURRICULAR_COURSE_SCOPE as t1, CURRICULAR_COURSE_SCOPE as t2 set t1.OID_CURRICULAR_COURSE_SCOPE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE_SCOPE;
update CURRICULAR_COURSE_SCOPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULAR_COURSE_SCOPE as t1, BRANCH as t2 set t1.OID_BRANCH = t2.OID where t2.ID_INTERNAL = t1.KEY_BRANCH;
update CURRICULAR_COURSE_SCOPE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update EXPORT_GROUPING as t1, GROUPING as t2 set t1.OID_GROUPING = t2.OID where t2.ID_INTERNAL = t1.KEY_GROUPING;
update EXPORT_GROUPING as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXPORT_GROUPING as t1, PARTY as t2 set t1.OID_SENDER_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER_PERSON;
update EXPORT_GROUPING as t1, PARTY as t2 set t1.OID_RECEIVER_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_RECEIVER_PERSON;
update EXPORT_GROUPING as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update EXPORT_GROUPING as t1, EXECUTION_COURSE as t2 set t1.OID_SENDER_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER_EXECUTION_COURSE;
update CAREER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CAREER as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update ACADEMIC_SERVICE_REQUEST as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update THEME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update AVAILABILITY_POLICY as t1, CONTENT as t2 set t1.OID_CONTENT = t2.OID where t2.ID_INTERNAL = t1.KEY_CONTENT;
update AVAILABILITY_POLICY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVENT as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update PAYMENT_PLAN as t1, SERVICE_AGREEMENT as t2 set t1.OID_SERVICE_AGREEMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_SERVICE_AGREEMENT;
update ENROLMENT_WRAPPER as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update DEGREE_INFO_FUTURE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_INFO_FUTURE as t1, DEGREE_INFO as t2 set t1.OID_DEGREE_INFO = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_INFO;
update ACCOUNTABILITY_TYPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_VIRTUAL_COURSE_GROUP_DEGREE_CURRICULAR_PLAN as t1, T_S_D_COURSE as t2 set t1.OID_T_S_D_VIRTUAL_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_VIRTUAL_COURSE_GROUP;
update T_S_D_VIRTUAL_COURSE_GROUP_DEGREE_CURRICULAR_PLAN as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update SEMINARY_CANDIDACY as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update SEMINARY_CANDIDACY as t1, THEME as t2 set t1.OID_THEME = t2.OID where t2.ID_INTERNAL = t1.KEY_THEME;
update SEMINARY_CANDIDACY as t1, SEMINARY as t2 set t1.OID_SEMINARY = t2.OID where t2.ID_INTERNAL = t1.KEY_SEMINARY;
update SEMINARY_CANDIDACY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SEMINARY_CANDIDACY as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update SEMINARY_CANDIDACY as t1, MODALITY as t2 set t1.OID_MODALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_MODALITY;
update EVENT as t1, ADMINISTRATIVE_OFFICE as t2 set t1.OID_ADMINISTRATIVE_OFFICE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE;
update GRANT_PAYMENT_ENTITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_PAYMENT_ENTITY as t1, TEACHER as t2 set t1.OID_RESPONSIBLE_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_TEACHER;
update REGISTRATION_NUMBER as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update REGISTRATION_NUMBER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TRANSACTION as t1, PARTY as t2 set t1.OID_RESPONSIBLE_PERSON = t2.OID, t1.TRANSACTION_DATE_DATE_TIME = t1.TRANSACTION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_PERSON;
update TRANSACTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.TRANSACTION_DATE_DATE_TIME = t1.TRANSACTION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TRANSACTION as t1, PERSON_ACCOUNT as t2 set t1.OID_PERSON_ACCOUNT = t2.OID, t1.TRANSACTION_DATE_DATE_TIME = t1.TRANSACTION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PERSON_ACCOUNT;
update ADMINISTRATIVE_OFFICE_PERMISSION_GROUP as t1, ADMINISTRATIVE_OFFICE as t2 set t1.OID_ADMINISTRATIVE_OFFICE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE;
update ADMINISTRATIVE_OFFICE_PERMISSION_GROUP as t1, RESOURCE as t2 set t1.OID_CAMPUS = t2.OID where t2.ID_INTERNAL = t1.KEY_CAMPUS;
update ADMINISTRATIVE_OFFICE_PERMISSION_GROUP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PRICE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INDIVIDUAL_CANDIDACY as t1, DEGREE as t2 set t1.OID_SELECTED_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_SELECTED_DEGREE;
update RESEARCH_RESULT as t1, THESIS as t2 set t1.OID_THESIS = t2.OID where t2.ID_INTERNAL = t1.KEY_THESIS;
update DELETE_FILE_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update USERNAME_COUNTER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEST_SCOPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INTERNSHIP_CANDIDACY as t1, PARTY as t2 set t1.OID_UNIVERSITY = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_UNIVERSITY;
update INTERNSHIP_CANDIDACY as t1, COUNTRY as t2 set t1.OID_THIRD_DESTINATION = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_THIRD_DESTINATION;
update INTERNSHIP_CANDIDACY as t1, COUNTRY as t2 set t1.OID_FIRST_DESTINATION = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_FIRST_DESTINATION;
update INTERNSHIP_CANDIDACY as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_BIRTH = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_BIRTH;
update INTERNSHIP_CANDIDACY as t1, COUNTRY as t2 set t1.OID_SECOND_DESTINATION = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_SECOND_DESTINATION;
update INTERNSHIP_CANDIDACY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CANDIDACY_DATE = t1.CANDIDACY_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_GROUP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_GROUP as t1, GROUPING as t2 set t1.OID_GROUPING = t2.OID where t2.ID_INTERNAL = t1.KEY_GROUPING;
update STUDENT_GROUP as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update GUIDE_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GUIDE_SITUATION as t1, GUIDE as t2 set t1.OID_GUIDE = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDE;
-- update PHD_STUDY_PLAN_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PHD_STUDY_PLAN_ENTRY as t1, PHD_STUDY_PLAN as t2 set t1.OID_STUDY_PLAN = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_STUDY_PLAN;
update NEW_PRESENTATION_MATERIAL as t1, FILE as t2 set t1.OID_PICTURE_MATERIAL_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_PICTURE_MATERIAL_FILE;
update WORK_SCHEDULE_TYPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WORK_SCHEDULE_TYPE as t1, WORK_PERIOD as t2 set t1.OID_NORMAL_WORK_PERIOD = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_NORMAL_WORK_PERIOD;
update WORK_SCHEDULE_TYPE as t1, WORK_PERIOD as t2 set t1.OID_FIXED_WORK_PERIOD = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_FIXED_WORK_PERIOD;
update WORK_SCHEDULE_TYPE as t1, MEAL as t2 set t1.OID_MEAL = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MEAL;
update WORK_SCHEDULE_TYPE as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update OLD_PUBLICATION as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update OLD_PUBLICATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update QUEUE_JOB as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update ACADEMIC_SERVICE_REQUEST as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update INDIVIDUAL_CANDIDACY_PERSONAL_DETAILS as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update INDIVIDUAL_CANDIDACY_PERSONAL_DETAILS as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PARTY_SOCIAL_SECURITY_NUMBER as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update PARTY_SOCIAL_SECURITY_NUMBER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GLOSSARY_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVENT as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update EVENT as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update PARKING_GROUP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FUNCTIONS_ACCUMULATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERIODICITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESIDENCE_YEAR as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update RESIDENCE_YEAR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_TEST_ELEMENT as t1, TEACHER as t2 set t1.OID_CREATOR = t2.OID, t1.CREATED = t1.CREATED where t2.ID_INTERNAL = t1.KEY_CREATOR;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_BAG = t2.OID, t1.CREATED = t1.CREATED where t2.ID_INTERNAL = t1.KEY_BAG;
update BRANCH as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update BRANCH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONTENT as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update CONTEXT as t1, DEGREE_MODULE as t2 set t1.OID_CHILD_DEGREE_MODULE = t2.OID where t2.ID_INTERNAL = t1.KEY_CHILD_DEGREE_MODULE;
update CONTEXT as t1, DEGREE_MODULE as t2 set t1.OID_PARENT_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_COURSE_GROUP;
update CONTEXT as t1, EXECUTION_INTERVAL as t2 set t1.OID_BEGIN_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_BEGIN_EXECUTION_PERIOD;
update CONTEXT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WRITTEN_EVALUATION_CONTEXT as t1, EVALUATION as t2 set t1.OID_WRITTEN_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION;
update WRITTEN_EVALUATION_CONTEXT as t1, CONTEXT as t2 set t1.OID_CONTEXT = t2.OID where t2.ID_INTERNAL = t1.KEY_CONTEXT;
update CONTEXT as t1, CURRICULAR_PERIOD as t2 set t1.OID_CURRICULAR_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_PERIOD;
update CONTEXT as t1, EXECUTION_INTERVAL as t2 set t1.OID_END_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_END_EXECUTION_PERIOD;
update EDUCATION_AREA as t1, EDUCATION_AREA as t2 set t1.OID_PARENT_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_AREA;
update EDUCATION_AREA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHOTOGRAPH_CONTENT as t1, PHOTOGRAPH as t2 set t1.OID_PHOTOGRAPH = t2.OID where t2.ID_INTERNAL = t1.KEY_PHOTOGRAPH;
update TRANSACTION as t1, GRATUITY_SITUATION as t2 set t1.OID_GRATUITY_SITUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_GRATUITY_SITUATION;
update MASTER_DEGREE_CANDIDATE as t1, TEACHER as t2 set t1.OID_GUIDER = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDER;
update MASTER_DEGREE_CANDIDATE as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update MASTER_DEGREE_CANDIDATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_CANDIDATE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION as t1, EVALUATION as t2 set t1.OID_WRITTEN_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION;
update WRITTEN_EVALUATION_WRITTEN_EVALUATION_SPACE_OCCUPATION as t1, RESOURCE_ALLOCATION as t2 set t1.OID_WRITTEN_EVALUATION_SPACE_OCCUPATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION_SPACE_OCCUPATION;
update EVALUATION as t1, GROUPING as t2 set t1.OID_GROUPING = t2.OID, t1.PROJECT_BEGIN_DATE_TIME = t1.PROJECT_BEGIN_DATE_TIME, t1.PROJECT_END_DATE_TIME = t1.PROJECT_END_DATE_TIME where t2.ID_INTERNAL = t1.KEY_GROUPING;
update EMPLOYEE_FUNCTIONS_ACCUMULATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_FUNCTIONS_ACCUMULATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_FUNCTIONS_ACCUMULATION as t1, PROFESSIONAL_REGIME as t2 set t1.OID_PROFESSIONAL_REGIME = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_REGIME;
update EMPLOYEE_FUNCTIONS_ACCUMULATION as t1, FUNCTIONS_ACCUMULATION as t2 set t1.OID_FUNCTIONS_ACCUMULATION = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_FUNCTIONS_ACCUMULATION;
update ASSIDUOUSNESS_EXEMPTION_SHIFT as t1, ASSIDUOUSNESS_EXEMPTION as t2 set t1.OID_ASSIDUOUSNESS_EXEMPTION = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_EXEMPTION;
update ASSIDUOUSNESS_EXEMPTION_SHIFT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CREDIT_NOTE_ENTRY as t1, ENTRY as t2 set t1.OID_ACCOUNTING_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCOUNTING_ENTRY;
update CREDIT_NOTE_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CREDIT_NOTE_ENTRY as t1, CREDIT_NOTE as t2 set t1.OID_CREDIT_NOTE = t2.OID where t2.ID_INTERNAL = t1.KEY_CREDIT_NOTE;
update CREDIT_NOTE_ENTRY as t1, ENTRY as t2 set t1.OID_ADJUSTMENT_ACCOUNTING_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_ADJUSTMENT_ACCOUNTING_ENTRY;
update FILE as t1, BLUEPRINT as t2 set t1.OID_BLUEPRINT = t2.OID where t2.ID_INTERNAL = t1.KEY_BLUEPRINT;
update OCCUPATION_PERIOD as t1, OCCUPATION_PERIOD as t2 set t1.OID_NEXT_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_NEXT_PERIOD;
update OCCUPATION_PERIOD as t1, OCCUPATION_PERIOD as t2 set t1.OID_PREVIOUS_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_PREVIOUS_PERIOD;
update OCCUPATION_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SHIFT_DISTRIBUTION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update SHIFT_DISTRIBUTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXTERNAL_CURRICULAR_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXTERNAL_CURRICULAR_COURSE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update TEACHER_INSTITUTION_WORK_TIME as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update TEACHER_INSTITUTION_WORK_TIME as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update TEACHER_INSTITUTION_WORK_TIME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE as t1, PHD_PROGRAM as t2 set t1.OID_PHD_PROGRAM = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM;
update DEGREE as t1, SENDER as t2 set t1.OID_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER;
update DEGREE as t1, CONTENT as t2 set t1.OID_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_SITE;
update DEGREE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update DEGREE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROTOCOL_HISTORY as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update PROTOCOL_HISTORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ENROLMENT_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.END_DATE_DATE_TIME = t1.END_DATE_DATE_TIME, t1.START_DATE_DATE_TIME = t1.START_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ENROLMENT_PERIOD as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.END_DATE_DATE_TIME = t1.END_DATE_DATE_TIME, t1.START_DATE_DATE_TIME = t1.START_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update ENROLMENT_PERIOD as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID, t1.END_DATE_DATE_TIME = t1.END_DATE_DATE_TIME, t1.START_DATE_DATE_TIME = t1.START_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update CANDIDACY as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update CANDIDACY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OLD_INQUIRIES_SUMMARY as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update OLD_INQUIRIES_SUMMARY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OLD_INQUIRIES_SUMMARY as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update ROLE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERSON_ROLE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PERSON_ROLE as t1, ROLE as t2 set t1.OID_ROLE = t2.OID where t2.ID_INTERNAL = t1.KEY_ROLE;
update MEAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PRECEDENT_DEGREE_INFORMATION as t1, PARTY as t2 set t1.OID_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION;
update PRECEDENT_DEGREE_INFORMATION as t1, COUNTRY as t2 set t1.OID_COUNTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY;
update PRECEDENT_DEGREE_INFORMATION as t1, PARTY as t2 set t1.OID_SOURCE_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE_INSTITUTION;
update PRECEDENT_DEGREE_INFORMATION as t1, CANDIDACY as t2 set t1.OID_STUDENT_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CANDIDACY;
update PRECEDENT_DEGREE_INFORMATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PRECEDENT_DEGREE_INFORMATION as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update DEGREE_CURRICULAR_PLAN as t1, EQUIVALENCE_PLAN as t2 set t1.OID_EQUIVALENCE_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN;
update DEGREE_CURRICULAR_PLAN as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_CURRICULAR_PLAN as t1, DEGREE_MODULE as t2 set t1.OID_ROOT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT;
update DEGREE_CURRICULAR_PLAN as t1, CURRICULAR_PERIOD as t2 set t1.OID_DEGREE_STRUCTURE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_STRUCTURE;
update DEGREE_CURRICULAR_PLAN as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update DEGREE_CURRICULAR_PLAN as t1, SERVICE_AGREEMENT_TEMPLATE as t2 set t1.OID_SERVICE_AGREEMENT_TEMPLATE = t2.OID where t2.ID_INTERNAL = t1.KEY_SERVICE_AGREEMENT_TEMPLATE;
update PRIZE as t1, RESEARCH_RESULT as t2 set t1.OID_RESEARCH_RESULT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESEARCH_RESULT;
update PRIZE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PRIZE_WINNERS as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update PRIZE_WINNERS as t1, PRIZE as t2 set t1.OID_PRIZE = t2.OID where t2.ID_INTERNAL = t1.KEY_PRIZE;
update CREDITS_IN_SCIENTIFIC_AREA as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update CREDITS_IN_SCIENTIFIC_AREA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CREDITS_IN_SCIENTIFIC_AREA as t1, SCIENTIFIC_AREA as t2 set t1.OID_SCIENTIFIC_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_SCIENTIFIC_AREA;
update CREDITS_IN_SCIENTIFIC_AREA as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update LOCALITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_THESIS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_THESIS as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update NODE as t1, CONTENT as t2 set t1.OID_CHILD = t2.OID where t2.ID_INTERNAL = t1.KEY_CHILD;
update NODE as t1, CONTENT as t2 set t1.OID_PARENT = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT;
update NODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM_MODULE as t1, DEGREE_MODULE as t2 set t1.OID_OPTIONAL_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_OPTIONAL_CURRICULAR_COURSE;
update CONTRIBUTOR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_INFO_CANDIDACY as t1, DEGREE_INFO as t2 set t1.OID_DEGREE_INFO = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_INFO;
update DEGREE_INFO_CANDIDACY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PHD_ALERT_MESSAGE_PERSON as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
-- update PHD_ALERT_MESSAGE_PERSON as t1, PHD_ALERT_MESSAGE as t2 set t1.OID_PHD_ALERT_MESSAGE = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_ALERT_MESSAGE;
update PARTY as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update PROTOCOL_RESPONSIBLE_PARTNER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PROTOCOL_RESPONSIBLE_PARTNER as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update PARTY as t1, REPLY_TO as t2 set t1.OID_REPLY_TO = t2.OID where t2.ID_INTERNAL = t1.KEY_REPLY_TO;
update PARTY as t1, PERSON_ACCOUNT as t2 set t1.OID_ASSOCIATED_PERSON_ACCOUNT = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSOCIATED_PERSON_ACCOUNT;
update PERSISTENT_GROUP_MEMBERS_PERSON as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PERSISTENT_GROUP_MEMBERS_PERSON as t1, PERSISTENT_GROUP_MEMBERS as t2 set t1.OID_PERSISTENT_GROUP_MEMBERS = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSISTENT_GROUP_MEMBERS;
update PARTY as t1, USER as t2 set t1.OID_USER = t2.OID where t2.ID_INTERNAL = t1.KEY_USER;
update PARTY as t1, RESEARCHER as t2 set t1.OID_RESEARCHER = t2.OID where t2.ID_INTERNAL = t1.KEY_RESEARCHER;
update PARTY as t1, LIBRARY_CARD as t2 set t1.OID_LIBRARY_CARD = t2.OID where t2.ID_INTERNAL = t1.KEY_LIBRARY_CARD;
update PARTY as t1, PERSON_NAME as t2 set t1.OID_PERSON_NAME = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON_NAME;
update PARTY as t1, SENDER as t2 set t1.OID_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER;
update ALLOWED_TO_UPLOAD_IN_UNIT as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update ALLOWED_TO_UPLOAD_IN_UNIT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PARTY as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update PROTOCOL_RESPONSIBLE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PROTOCOL_RESPONSIBLE as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update PARTY as t1, PHOTOGRAPH as t2 set t1.OID_PERSONAL_PHOTO = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSONAL_PHOTO;
update PARTY as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update PARTY as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_BIRTH = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_BIRTH;
update PARTY as t1, PARTY as t2 set t1.OID_INCOMPATIBLE_VIGILANT = t2.OID where t2.ID_INTERNAL = t1.KEY_INCOMPATIBLE_VIGILANT;
update PARTY as t1, PARTY as t2 set t1.OID_INCOMPATIBLE_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_INCOMPATIBLE_PERSON;
update PARTY as t1, CONTENT as t2 set t1.OID_HOMEPAGE = t2.OID where t2.ID_INTERNAL = t1.KEY_HOMEPAGE;
update TEST_PERSON as t1, NEW_TEST_ELEMENT as t2 set t1.OID_NEW_TEST = t2.OID where t2.ID_INTERNAL = t1.KEY_NEW_TEST;
update TEST_PERSON as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PARTY as t1, GRANT_OWNER as t2 set t1.OID_GRANT_OWNER = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_OWNER;
update PARTICIPATION as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update PARTICIPATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RECEIPT_PRINT_VERSION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update RECEIPT_PRINT_VERSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RECEIPT_PRINT_VERSION as t1, RECEIPT as t2 set t1.OID_RECEIPT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_RECEIPT;
update SCIENTIFIC_JOURNAL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_CONTEXT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_CONTEXT as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update INSURANCE_VALUE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update INSURANCE_VALUE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update HOLIDAY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update HOLIDAY as t1, LOCALITY as t2 set t1.OID_LOCALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_LOCALITY;
update SHIFT_DISTRIBUTION_ENTRY as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SHIFT_DISTRIBUTION_ENTRY as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update SHIFT_DISTRIBUTION_ENTRY as t1, SHIFT_DISTRIBUTION as t2 set t1.OID_SHIFT_DISTRIBUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT_DISTRIBUTION;
update SHIFT_DISTRIBUTION_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY as t1, PARTY_SOCIAL_SECURITY_NUMBER as t2 set t1.OID_PARTY_SOCIAL_SECURITY_NUMBER = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY_SOCIAL_SECURITY_NUMBER;
update PARTY as t1, NEW_TEST_ELEMENT as t2 set t1.OID_QUESTION_BANK = t2.OID where t2.ID_INTERNAL = t1.KEY_QUESTION_BANK;
update PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY as t1, PARKING_PARTY as t2 set t1.OID_PARKING_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_PARTY;
update PARTY as t1, PARTY_TYPE as t2 set t1.OID_PARTY_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY_TYPE;
update PARTY as t1, COUNTRY as t2 set t1.OID_NATIONALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_NATIONALITY;
update ASSIDUOUSNESS_RECORD as t1, ASSIDUOUSNESS_RECORD as t2 set t1.OID_ANULATION = t2.OID, t1.DATE = t1.DATE where t2.ID_INTERNAL = t1.KEY_ANULATION;
update ASSIDUOUSNESS_RECORD as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.DATE = t1.DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update ASSIDUOUSNESS_RECORD_ASSIDUOUSNESS_RECORD_MONTH_INDEX as t1, ASSIDUOUSNESS_RECORD_MONTH_INDEX as t2 set t1.OID_ASSIDUOUSNESS_RECORD_MONTH_INDEX = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_RECORD_MONTH_INDEX;
update ASSIDUOUSNESS_RECORD_ASSIDUOUSNESS_RECORD_MONTH_INDEX as t1, ASSIDUOUSNESS_RECORD as t2 set t1.OID_ASSIDUOUSNESS_RECORD = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_RECORD;
update ASSIDUOUSNESS_RECORD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.DATE = t1.DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ALUMNI_IDENTITY_CHECK_REQUEST as t1, PARTY as t2 set t1.OID_OPERATOR = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME, t1.DECISION_DATE_TIME = t1.DECISION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_OPERATOR;
update ALUMNI_IDENTITY_CHECK_REQUEST as t1, ALUMNI as t2 set t1.OID_ALUMNI = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME, t1.DECISION_DATE_TIME = t1.DECISION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ALUMNI;
update ALUMNI_IDENTITY_CHECK_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE_TIME = t1.CREATION_DATE_TIME, t1.DECISION_DATE_TIME = t1.DECISION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OLD_INQUIRIES_TEACHERS_RES as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OLD_INQUIRIES_TEACHERS_RES as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update OLD_INQUIRIES_TEACHERS_RES as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update OLD_INQUIRIES_TEACHERS_RES as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update STUDENT_COURSE_REPORT as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update STUDENT_COURSE_REPORT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COST_CENTER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_SERVICE_ITEM as t1, TEACHER_SERVICE as t2 set t1.OID_TEACHER_SERVICE = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER_SERVICE;
update TEACHER_SERVICE_ITEM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update FILE as t1, PARTY as t2 set t1.OID_UPLOADER = t2.OID where t2.ID_INTERNAL = t1.KEY_UPLOADER;
update DEGREE_MODULE as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_PARENT_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_DEGREE_CURRICULAR_PLAN;
update PROTOCOL_UNIT as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update PROTOCOL_UNIT as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update PROTOCOL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROTOCOL_RESPONSIBLE_FUNCTION as t1, ACCOUNTABILITY_TYPE as t2 set t1.OID_FUNCTION = t2.OID where t2.ID_INTERNAL = t1.KEY_FUNCTION;
update PROTOCOL_RESPONSIBLE_FUNCTION as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update PROTOCOL_PARTNER as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update PROTOCOL_PARTNER as t1, PROTOCOL as t2 set t1.OID_PROTOCOL = t2.OID where t2.ID_INTERNAL = t1.KEY_PROTOCOL;
update GENERAL_CLASS_PROPERTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ROOT_DOMAIN_OBJECT as t1, PARTY as t2 set t1.OID_RESIDENCE_MANAGEMENT_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESIDENCE_MANAGEMENT_UNIT;
update ROOT_DOMAIN_OBJECT as t1, PARTY as t2 set t1.OID_INSTITUTION_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION_UNIT;
update ROOT_DOMAIN_OBJECT as t1, USERNAME_COUNTER as t2 set t1.OID_USERNAME_COUNTER = t2.OID where t2.ID_INTERNAL = t1.KEY_USERNAME_COUNTER;
update ROOT_DOMAIN_OBJECT as t1, SENDER as t2 set t1.OID_SYSTEM_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SYSTEM_SENDER;
update ROOT_DOMAIN_OBJECT as t1, DEPLOY_NOTIFIER as t2 set t1.OID_DEPLOY_NOTIFIER = t2.OID where t2.ID_INTERNAL = t1.KEY_DEPLOY_NOTIFIER;
update ROOT_DOMAIN_OBJECT as t1, PARTY as t2 set t1.OID_EXTERNAL_INSTITUTION_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTERNAL_INSTITUTION_UNIT;
update ROOT_DOMAIN_OBJECT as t1, PARTY as t2 set t1.OID_EARTH_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_EARTH_UNIT;
update ROOT_DOMAIN_OBJECT as t1, ACADEMIC_CALENDAR_ENTRY as t2 set t1.OID_DEFAULT_ACADEMIC_CALENDAR = t2.OID where t2.ID_INTERNAL = t1.KEY_DEFAULT_ACADEMIC_CALENDAR;
update ROOT_DOMAIN_OBJECT as t1, CONTENT as t2 set t1.OID_ROOT_MODULE = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_MODULE;
update ROOT_DOMAIN_OBJECT as t1, CONTENT as t2 set t1.OID_ROOT_PORTAL = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_PORTAL;
update ALUMNI as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update ALUMNI as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_RESIDENCE_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_RESIDENCE_UNIT;
update PARTY as t1, RESIDENCE_PRICE_TABLE as t2 set t1.OID_RESIDENCE_PRICE_TABLE = t2.OID where t2.ID_INTERNAL = t1.KEY_RESIDENCE_PRICE_TABLE;
update ASSIDUOUSNESS_VACATIONS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_VACATIONS as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update ASSIDUOUSNESS_RECORD_MONTH_INDEX as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_RECORD_MONTH_INDEX as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update ASSIDUOUSNESS_EXTRA_WORK as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_EXTRA_WORK as t1, ASSIDUOUSNESS_CLOSED_MONTH as t2 set t1.OID_ASSIDUOUSNESS_CLOSED_MONTH = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_CLOSED_MONTH;
update ASSIDUOUSNESS_EXTRA_WORK as t1, WORK_SCHEDULE_TYPE as t2 set t1.OID_WORK_SCHEDULE_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_WORK_SCHEDULE_TYPE;
update ADMINISTRATIVE_OFFICE_PERMISSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ADMINISTRATIVE_OFFICE_PERMISSION as t1, ADMINISTRATIVE_OFFICE_PERMISSION_GROUP as t2 set t1.OID_ADMINISTRATIVE_OFFICE_PERMISSION_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE_PERMISSION_GROUP;
update PARTICIPATION as t1, JOURNAL_ISSUE as t2 set t1.OID_JOURNAL_ISSUE = t2.OID where t2.ID_INTERNAL = t1.KEY_JOURNAL_ISSUE;
update CONTENT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update REIMBURSEMENT_GUIDE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REIMBURSEMENT_GUIDE as t1, GUIDE as t2 set t1.OID_GUIDE = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDE;
update PHD_PROGRAM as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_DEGREE;
update PHD_PROGRAM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHD_PROGRAM as t1, PARTY as t2 set t1.OID_PHD_PROGRAM_UNIT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM_UNIT;
update PHD_PROGRAM as t1, SERVICE_AGREEMENT_TEMPLATE as t2 set t1.OID_SERVICE_AGREEMENT_TEMPLATE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_SERVICE_AGREEMENT_TEMPLATE;
update NON_AFFILIATED_TEACHER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NON_AFFILIATED_TEACHER_EXECUTION_COURSE as t1, NON_AFFILIATED_TEACHER as t2 set t1.OID_NON_AFFILIATED_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_NON_AFFILIATED_TEACHER;
update NON_AFFILIATED_TEACHER_EXECUTION_COURSE as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update NON_AFFILIATED_TEACHER as t1, PARTY as t2 set t1.OID_INSTITUTION_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION_UNIT;
update STUDENT_DATA_BY_EXECUTION_YEAR as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update STUDENT_DATA_BY_EXECUTION_YEAR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update STUDENT_DATA_BY_EXECUTION_YEAR as t1, RESIDENCE_CANDIDACIES as t2 set t1.OID_RESIDENCE_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_RESIDENCE_CANDIDACY;
update STUDENT_DATA_BY_EXECUTION_YEAR as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update DELEGATE_ELECTION_PERIOD as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update PUNCTUAL_ROOMS_OCCUPATION_STATE_INSTANT as t1, PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t2 set t1.OID_REQUEST = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_REQUEST;
update PUNCTUAL_ROOMS_OCCUPATION_STATE_INSTANT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARKING_REQUEST_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN_DATE = t1.BEGIN_DATE, t1.END_DATE = t1.END_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_MODULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE as t1, DEGREE_MODULE as t2 set t1.OID_DEGREE_MODULE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_MODULE;
update EQUIVALENCE_PLAN_ENTRY_NEW_DEGREE_MODULE as t1, EQUIVALENCE_PLAN_ENTRY as t2 set t1.OID_EQUIVALENCE_PLAN_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN_ENTRY;
update EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE as t1, DEGREE_MODULE as t2 set t1.OID_DEGREE_MODULE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_MODULE;
update EQUIVALENCE_PLAN_ENTRY_OLD_DEGREE_MODULE as t1, EQUIVALENCE_PLAN_ENTRY as t2 set t1.OID_EQUIVALENCE_PLAN_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN_ENTRY;
update EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP as t1, EXAM_COORDINATOR as t2 set t1.OID_EXAM_COORDINATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXAM_COORDINATOR;
update EXAM_COORDINATOR_MANAGES_VIGILANT_GROUP as t1, VIGILANT_GROUP as t2 set t1.OID_VIGILANT_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_VIGILANT_GROUP;
update VIGILANT_GROUP as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID, t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update VIGILANT_GROUP as t1, PARTY as t2 set t1.OID_UNIT = t2.OID, t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS where t2.ID_INTERNAL = t1.KEY_UNIT;
update VIGILANT_GROUP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.BEGIN_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_FIRST_PERIOD_FOR_UNAVAILABLE_PERIODS, t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS = t1.END_OF_SECOND_PERIOD_FOR_UNAVAILABLE_PERIODS where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY_CONTACT as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_RESIDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_RESIDENCE;
update OVER23_INDIVIDUAL_CANDIDACY_DEGREE_ENTRY as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update OVER23_INDIVIDUAL_CANDIDACY_DEGREE_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OVER23_INDIVIDUAL_CANDIDACY_DEGREE_ENTRY as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_OVER23_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_OVER23_INDIVIDUAL_CANDIDACY;
update DELEGATE_ELECTION_VOTE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE_ELECTION_VOTE as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update DELEGATE_ELECTION_VOTE as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update EMPLOYEE_PROFESSIONAL_EXEMPTION as t1, COUNTRY as t2 set t1.OID_COUNTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY;
update EMPLOYEE_PROFESSIONAL_EXEMPTION as t1, GRANT_OWNER_EQUIVALENT as t2 set t1.OID_GRANT_OWNER_EQUIVALENT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_OWNER_EQUIVALENT;
update PARTY as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update PERSON_EXTENSION as t1, RESOURCE as t2 set t1.OID_EXTENSION = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTENSION;
update PERSON_EXTENSION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update ROOM_CLASSIFICATION as t1, ROOM_CLASSIFICATION as t2 set t1.OID_PARENT_ROOM_CLASSIFICATION = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_ROOM_CLASSIFICATION;
update ROOM_CLASSIFICATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXEMPTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXEMPTION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EXEMPTION as t1, EXEMPTION_JUSTIFICATION as t2 set t1.OID_EXEMPTION_JUSTIFICATION = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EXEMPTION_JUSTIFICATION;
update EXEMPTION as t1, EVENT as t2 set t1.OID_EVENT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EVENT;
update WEEKLY_OCUPATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WEEKLY_OCUPATION as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update ID_DOCUMENT as t1, ID_DOCUMENT_TYPE_OBJECT as t2 set t1.OID_ID_DOCUMENT_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_ID_DOCUMENT_TYPE;
update ID_DOCUMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ID_DOCUMENT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update INQUIRIES_COURSE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update INQUIRIES_COURSE as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE_COURSE = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE_COURSE;
update INQUIRIES_COURSE as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE_STUDENT = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE_STUDENT;
update INQUIRIES_COURSE as t1, SCHOOL_CLASS as t2 set t1.OID_STUDENT_SCHOOL_CLASS = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT_SCHOOL_CLASS;
update INQUIRIES_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INQUIRIES_COURSE as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID, t1.RESPONSE_DATE_TIME = t1.RESPONSE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update INQUIRIES_ROOM as t1, INQUIRIES_COURSE as t2 set t1.OID_INQUIRIES_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_INQUIRIES_COURSE;
update INQUIRIES_ROOM as t1, RESOURCE as t2 set t1.OID_ROOM = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOM;
update INQUIRIES_ROOM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SUPPORT_LESSON as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SUPPORT_LESSON as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update CURRICULUM_MODULE as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update CURRICULUM_MODULE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update PROGRAM_CERTIFICATE_REQUEST_ENROLMENT as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update PROGRAM_CERTIFICATE_REQUEST_ENROLMENT as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_PROGRAM_CERTIFICATE_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_PROGRAM_CERTIFICATE_REQUEST;
update COURSE_LOAD_REQUEST_ENROLMENT as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update COURSE_LOAD_REQUEST_ENROLMENT as t1, ACADEMIC_SERVICE_REQUEST as t2 set t1.OID_COURSE_LOAD_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_COURSE_LOAD_REQUEST;
update T_S_D_COURSE as t1, T_S_D_COURSE as t2 set t1.OID_T_S_D_CURRICULAR_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_CURRICULAR_COURSE_GROUP;
update T_S_D_COURSE as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_BAG_MODEL = t2.OID where t2.ID_INTERNAL = t1.KEY_BAG_MODEL;
update PROCESS as t1, CANDIDACY_PERIOD as t2 set t1.OID_CANDIDACY_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PERIOD;
update DISTRIBUTED_TEST as t1, EVALUATION as t2 set t1.OID_ONLINE_TEST = t2.OID where t2.ID_INTERNAL = t1.KEY_ONLINE_TEST;
update DISTRIBUTED_TEST as t1, TEST_SCOPE as t2 set t1.OID_TEST_SCOPE = t2.OID where t2.ID_INTERNAL = t1.KEY_TEST_SCOPE;
update DISTRIBUTED_TEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_CORRECTOR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_CORRECTOR as t1, NEW_TEST_ELEMENT as t2 set t1.OID_ATOMIC_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_ATOMIC_QUESTION;
update OLD_INQUIRIES_COURSES_RES as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update OLD_INQUIRIES_COURSES_RES as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update OLD_INQUIRIES_COURSES_RES as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
-- update PHD_ALERT_MESSAGE as t1, PARTY as t2 set t1.OID_PERSON_WHO_MARKED_AS_READED = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON_WHO_MARKED_AS_READED;
update PHD_ALERT_MESSAGE as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PROCESS;
update PHD_ALERT_MESSAGE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FUNCTIONALITY_PARAMETER as t1, META_DOMAIN_OBJECT as t2 set t1.OID_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_TYPE;
update FUNCTIONALITY_PARAMETER as t1, CONTENT as t2 set t1.OID_FUNCTIONALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_FUNCTIONALITY;
update FUNCTIONALITY_PARAMETER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EQUIVALENCE_PLAN as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update EQUIVALENCE_PLAN as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_SOURCE_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE_DEGREE_CURRICULAR_PLAN;
update WRITTEN_EVALUATION_ENROLMENT as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update WRITTEN_EVALUATION_ENROLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update WRITTEN_EVALUATION_ENROLMENT as t1, EVALUATION as t2 set t1.OID_WRITTEN_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION;
update WRITTEN_EVALUATION_ENROLMENT as t1, RESOURCE as t2 set t1.OID_ROOM = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOM;
update FILE as t1, CONTENT as t2 set t1.OID_ATTACHMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ATTACHMENT;
update EXEMPTION_JUSTIFICATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXEMPTION_JUSTIFICATION as t1, EXEMPTION as t2 set t1.OID_EXEMPTION = t2.OID where t2.ID_INTERNAL = t1.KEY_EXEMPTION;
update GRANT_OWNER_EQUIVALENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PUBLIC_CANDIDACY_HASH_CODE as t1, PROCESS as t2 set t1.OID_INDIVIDUAL_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_CANDIDACY_PROCESS;
update PUNCTUAL_ROOMS_OCCUPATION_COMMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PUNCTUAL_ROOMS_OCCUPATION_COMMENT as t1, PARTY as t2 set t1.OID_OWNER = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_OWNER;
update PUNCTUAL_ROOMS_OCCUPATION_COMMENT as t1, PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t2 set t1.OID_REQUEST = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_REQUEST;
update RESOURCE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY_TYPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- update PHD_STUDY_PLAN_ENTRY as t1, COMPETENCE_COURSE as t2 set t1.OID_COMPETENCE_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE;
update EQUIVALENCE_PLAN as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_OLD_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_OLD_STUDENT_CURRICULAR_PLAN;
update STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE as t1, EQUIVALENCE_PLAN_ENTRY as t2 set t1.OID_EQUIVALENCE_PLAN_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN_ENTRY;
update STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN_ENTRY_TO_REMOVE as t1, EQUIVALENCE_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN_EQUIVALENCE_PLAN;
update PROCESS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROJECT_SUBMISSION_LOG as t1, ATTENDS as t2 set t1.OID_ATTENDS = t2.OID, t1.SUBMISSION_DATE_TIME = t1.SUBMISSION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ATTENDS;
update PROJECT_SUBMISSION_LOG as t1, EVALUATION as t2 set t1.OID_PROJECT = t2.OID, t1.SUBMISSION_DATE_TIME = t1.SUBMISSION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PROJECT;
update PROJECT_SUBMISSION_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.SUBMISSION_DATE_TIME = t1.SUBMISSION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROJECT_SUBMISSION_LOG as t1, STUDENT_GROUP as t2 set t1.OID_STUDENT_GROUP = t2.OID, t1.SUBMISSION_DATE_TIME = t1.SUBMISSION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT_GROUP;
update T_S_D_PROFESSORSHIP as t1, T_S_D_TEACHER as t2 set t1.OID_T_S_D_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_TEACHER;
update T_S_D_PROFESSORSHIP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_PROFESSORSHIP as t1, T_S_D_COURSE as t2 set t1.OID_T_S_D_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_COURSE;
update SCHOOL_CLASS as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update SCHOOL_CLASS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SCHOOL_CLASS as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update COURSE_REPORT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COURSE_REPORT as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update PARKING_PARTY as t1, NEW_PARKING_DOCUMENT as t2 set t1.OID_DRIVER_LICENSE_DOCUMENT = t2.OID, t1.CARD_END_DATE = t1.CARD_END_DATE, t1.CARD_START_DATE = t1.CARD_START_DATE where t2.ID_INTERNAL = t1.KEY_DRIVER_LICENSE_DOCUMENT;
update PARKING_PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CARD_END_DATE = t1.CARD_END_DATE, t1.CARD_START_DATE = t1.CARD_START_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARKING_PARTY as t1, PARKING_GROUP as t2 set t1.OID_PARKING_GROUP = t2.OID, t1.CARD_END_DATE = t1.CARD_END_DATE, t1.CARD_START_DATE = t1.CARD_START_DATE where t2.ID_INTERNAL = t1.KEY_PARKING_GROUP;
update PARKING_PARTY as t1, PARTY as t2 set t1.OID_PARTY = t2.OID, t1.CARD_END_DATE = t1.CARD_END_DATE, t1.CARD_START_DATE = t1.CARD_START_DATE where t2.ID_INTERNAL = t1.KEY_PARTY;
update CURRICULUM_MODULE as t1, CREDITS as t2 set t1.OID_CREDITS = t2.OID where t2.ID_INTERNAL = t1.KEY_CREDITS;
update PARTY as t1, DEPARTMENT as t2 set t1.OID_DEPARTMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_DEPARTMENT;
update DOMAIN_OBJECT_ACTION_LOG as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_PERSON;
update DOMAIN_OBJECT_ACTION_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.INSTANT = t1.INSTANT where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_COURSE_TEACHER_SERVICE_DISTRIBUTION as t1, T_S_D_COURSE as t2 set t1.OID_T_S_D_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_COURSE;
update T_S_D_COURSE_TEACHER_SERVICE_DISTRIBUTION as t1, TEACHER_SERVICE_DISTRIBUTION as t2 set t1.OID_TEACHER_SERVICE_DISTRIBUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER_SERVICE_DISTRIBUTION;
update T_S_D_COURSE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update T_S_D_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EQUIVALENCE_PLAN as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PARTY as t1, SERVICE_AGREEMENT_TEMPLATE as t2 set t1.OID_UNIT_SERVICE_AGREEMENT_TEMPLATE = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_SERVICE_AGREEMENT_TEMPLATE;
update PARTY as t1, UNIT_COST_CENTER_CODE as t2 set t1.OID_UNIT_COST_CENTER_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_COST_CENTER_CODE;
update PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_INSTITUTION_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_INSTITUTION_UNIT;
update PARTY as t1, UNIT_NAME as t2 set t1.OID_UNIT_NAME = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_NAME;
update PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_EXTERNAL_INSTITUTION_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_EXTERNAL_INSTITUTION_UNIT;
update PARTY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_FOR_EARTH_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_FOR_EARTH_UNIT;
update PARTY as t1, UNIT_ACRONYM as t2 set t1.OID_UNIT_ACRONYM = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_ACRONYM;
update PARTY as t1, CONTENT as t2 set t1.OID_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_SITE;
update PARTY as t1, RESOURCE as t2 set t1.OID_CAMPUS = t2.OID where t2.ID_INTERNAL = t1.KEY_CAMPUS;
update ACADEMIC_SERVICE_REQUEST as t1, EVENT as t2 set t1.OID_EVENT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.REQUEST_DATE = t1.REQUEST_DATE where t2.ID_INTERNAL = t1.KEY_EVENT;
update ACADEMIC_SERVICE_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.REQUEST_DATE = t1.REQUEST_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_SERVICE_REQUEST as t1, ADMINISTRATIVE_OFFICE as t2 set t1.OID_ADMINISTRATIVE_OFFICE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.REQUEST_DATE = t1.REQUEST_DATE where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE;
update ACADEMIC_SERVICE_REQUEST as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.REQUEST_DATE = t1.REQUEST_DATE where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update ACADEMIC_SERVICE_REQUEST as t1, ACADEMIC_SERVICE_REQUEST_YEAR as t2 set t1.OID_ACADEMIC_SERVICE_REQUEST_YEAR = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.REQUEST_DATE = t1.REQUEST_DATE where t2.ID_INTERNAL = t1.KEY_ACADEMIC_SERVICE_REQUEST_YEAR;
update CONTENT as t1, RESOURCE as t2 set t1.OID_CAMPUS = t2.OID, t1.LAST_MODIFICATION = t1.LAST_MODIFICATION, t1.PUBLICATION_BEGIN = t1.PUBLICATION_BEGIN, t1.PUBLICATION_END = t1.PUBLICATION_END, t1.REFERED_SUBJECT_BEGIN = t1.REFERED_SUBJECT_BEGIN, t1.REFERED_SUBJECT_END = t1.REFERED_SUBJECT_END where t2.ID_INTERNAL = t1.KEY_CAMPUS;
update SUMMARY as t1, LESSON_INSTANCE as t2 set t1.OID_LESSON_INSTANCE = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_LESSON_INSTANCE;
update SUMMARY as t1, RESOURCE as t2 set t1.OID_ROOM = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOM;
update SUMMARY as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update SUMMARY as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SUMMARY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SUMMARY as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update SUMMARY as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFIED_DATE_DATE_TIME = t1.LAST_MODIFIED_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update PARTICIPATION as t1, EVENT_EDITION as t2 set t1.OID_EVENT_EDITION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT_EDITION;
update CONTENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_PORTAL_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_PORTAL_ROOT_DOMAIN_OBJECT;
update FILE as t1, PARTY as t2 set t1.OID_OPERATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_OPERATOR;
update FILE as t1, PARTY as t2 set t1.OID_ADDRESSEE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADDRESSEE;
update LOGIN_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update LOGIN_REQUEST as t1, USER as t2 set t1.OID_USER = t2.OID where t2.ID_INTERNAL = t1.KEY_USER;
update UNAVAILABLE_PERIOD as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.BEGIN_DATE = t1.BEGIN_DATE, t1.END_DATE = t1.END_DATE where t2.ID_INTERNAL = t1.KEY_PERSON;
update UNAVAILABLE_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN_DATE = t1.BEGIN_DATE, t1.END_DATE = t1.END_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROJECT_ACCESS as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.BEGIN_DATE_TIME = t1.BEGIN_DATE_TIME, t1.END_DATE_TIME = t1.END_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PERSON;
update PROJECT_ACCESS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN_DATE_TIME = t1.BEGIN_DATE_TIME, t1.END_DATE_TIME = t1.END_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHD_PROGRAM_GUIDING as t1, PROCESS as t2 set t1.OID_ASSISTANT_PHD_INDIVIDUAL_PROGRAM_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSISTANT_PHD_INDIVIDUAL_PROGRAM_PROCESS;
update PHD_PROGRAM_GUIDING as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHD_PROGRAM_GUIDING as t1, PROCESS as t2 set t1.OID_PHD_INDIVIDUAL_PROGRAM_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_INDIVIDUAL_PROGRAM_PROCESS;
update PROCESS as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PROCESS as t1, PROCESS as t2 set t1.OID_CANDIDACY_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PROCESS;
update PROCESS as t1, PHD_INDIVIDUAL_PROGRAM_PROCESS_NUMBER as t2 set t1.OID_PHD_INDIVIDUAL_PROCESS_NUMBER = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_INDIVIDUAL_PROCESS_NUMBER;
update PROCESS as t1, PHD_PROGRAM as t2 set t1.OID_PHD_PROGRAM = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM;
update PROCESS as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update PROCESS as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
-- update PROCESS as t1, PHD_STUDY_PLAN as t2 set t1.OID_STUDY_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDY_PLAN;
update PROCESS as t1, PHD_PROGRAM_FOCUS_AREA as t2 set t1.OID_PHD_PROGRAM_FOCUS_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM_FOCUS_AREA;
update BUSINESS_AREA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update BUSINESS_AREA as t1, BUSINESS_AREA as t2 set t1.OID_PARENT_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_AREA;
update CARD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update THESIS_EVALUATION_PARTICIPANT as t1, THESIS as t2 set t1.OID_THESIS = t2.OID where t2.ID_INTERNAL = t1.KEY_THESIS;
update THESIS_EVALUATION_PARTICIPANT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update THESIS_EVALUATION_PARTICIPANT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update EQUIVALENCE_PLAN_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EQUIVALENCE_PLAN_ENTRY as t1, DEGREE_MODULE as t2 set t1.OID_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES = t2.OID where t2.ID_INTERNAL = t1.KEY_PREVIOUS_COURSE_GROUP_FOR_NEW_DEGREE_MODULES;
update EQUIVALENCE_PLAN_ENTRY as t1, EQUIVALENCE_PLAN as t2 set t1.OID_EQUIVALENCE_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENCE_PLAN;
update PROFESSORSHIP as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update PROFESSORSHIP as t1, TEACHING_INQUIRY as t2 set t1.OID_TEACHING_INQUIRY = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHING_INQUIRY;
update PROFESSORSHIP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROFESSORSHIP as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update REIMBURSEMENT_GUIDE_SITUATION as t1, REIMBURSEMENT_GUIDE as t2 set t1.OID_REIMBURSEMENT_GUIDE = t2.OID where t2.ID_INTERNAL = t1.KEY_REIMBURSEMENT_GUIDE;
update REIMBURSEMENT_GUIDE_SITUATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update REIMBURSEMENT_GUIDE_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERSON_ACCOUNT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PERSON_ACCOUNT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update QUALIFICATION as t1, EXECUTION_INTERVAL as t2 set t1.OID_CONCLUSION_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_CONCLUSION_EXECUTION_YEAR;
update QUALIFICATION as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_CANDIDACY;
update ASSIDUOUSNESS_EXEMPTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REGISTRATION_REGIME as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update REGISTRATION_REGIME as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update REGISTRATION_REGIME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update LOGIN_ALIAS as t1, IDENTIFICATION as t2 set t1.OID_LOGIN = t2.OID where t2.ID_INTERNAL = t1.KEY_LOGIN;
update LOGIN_ALIAS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SECRETARY_ENROLMENT_STUDENT as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update SECRETARY_ENROLMENT_STUDENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_PROCESS_PHASE as t1, T_S_D_PROCESS as t2 set t1.OID_T_S_D_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_PROCESS;
update T_S_D_PROCESS_PHASE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_PROCESS_PHASE as t1, T_S_D_PROCESS_PHASE as t2 set t1.OID_NEXT_T_S_D_PROCESS_PHASE = t2.OID where t2.ID_INTERNAL = t1.KEY_NEXT_T_S_D_PROCESS_PHASE;
update T_S_D_PROCESS_PHASE as t1, T_S_D_PROCESS_PHASE as t2 set t1.OID_PREVIOUS_T_S_D_PROCESS_PHASE = t2.OID where t2.ID_INTERNAL = t1.KEY_PREVIOUS_T_S_D_PROCESS_PHASE;
update FILE as t1, CLOSED_MONTH_DOCUMENT as t2 set t1.OID_CLOSED_MONTH_DOCUMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_CLOSED_MONTH_DOCUMENT;
update ASSIDUOUSNESS_RECORD as t1, CLOCK_UNIT as t2 set t1.OID_CLOCK_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_CLOCK_UNIT;
update RESOURCE_ALLOCATION as t1, LESSON as t2 set t1.OID_LESSON = t2.OID where t2.ID_INTERNAL = t1.KEY_LESSON;
update CANDIDACY_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDACY_SITUATION as t1, CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update CANDIDACY_SITUATION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.SITUATION_DATE = t1.SITUATION_DATE where t2.ID_INTERNAL = t1.KEY_PERSON;
update MASTER_DEGREE_PROOF_VERSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_PROOF_VERSION as t1, MASTER_DEGREE_THESIS as t2 set t1.OID_MASTER_DEGREE_THESIS = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_THESIS;
update MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY as t1, MASTER_DEGREE_PROOF_VERSION as t2 set t1.OID_MASTER_DEGREE_PROOF_VERSION = t2.OID where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_PROOF_VERSION;
update MASTER_DEGREE_PROOF_VERSION_EXTERNAL_JURY as t1, ACCOUNTABILITY as t2 set t1.OID_EXTERNAL_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTERNAL_CONTRACT;
update MASTER_DEGREE_PROOF_VERSION as t1, EMPLOYEE as t2 set t1.OID_RESPONSIBLE_EMPLOYEE = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_EMPLOYEE;
update T_S_D_TEACHER_TEACHER_SERVICE_DISTRIBUTION as t1, T_S_D_TEACHER as t2 set t1.OID_T_S_D_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_TEACHER;
update T_S_D_TEACHER_TEACHER_SERVICE_DISTRIBUTION as t1, TEACHER_SERVICE_DISTRIBUTION as t2 set t1.OID_TEACHER_SERVICE_DISTRIBUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER_SERVICE_DISTRIBUTION;
update T_S_D_TEACHER as t1, CATEGORY as t2 set t1.OID_CATEGORY = t2.OID where t2.ID_INTERNAL = t1.KEY_CATEGORY;
update T_S_D_TEACHER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_PROFESSIONAL_CATEGORY as t1, PROFESSIONAL_REGIME as t2 set t1.OID_PROFESSIONAL_REGIME = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_REGIME;
update EMPLOYEE_PROFESSIONAL_CATEGORY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_PROFESSIONAL_CATEGORY as t1, PROFESSIONAL_CATEGORY as t2 set t1.OID_PROFESSIONAL_CATEGORY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_CATEGORY;
update EMPLOYEE_PROFESSIONAL_CATEGORY as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_PROFESSIONAL_CATEGORY as t1, PROFESSIONAL_RELATION as t2 set t1.OID_PROFESSIONAL_RELATION = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_RELATION;
update GRANT_PART as t1, TEACHER as t2 set t1.OID_RESPONSIBLE_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_TEACHER;
update GRANT_PART as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_PART as t1, GRANT_SUBSIDY as t2 set t1.OID_GRANT_SUBSIDY = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_SUBSIDY;
update GRANT_PART as t1, GRANT_PAYMENT_ENTITY as t2 set t1.OID_GRANT_PAYMENT_ENTITY = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_PAYMENT_ENTITY;
update PERSISTENT_GROUP_MEMBERS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERSISTENT_GROUP_MEMBERS as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update SIBS_PAYMENT_FILE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONTENT as t1, CONTENT as t2 set t1.OID_INITIAL_CONTENT = t2.OID where t2.ID_INTERNAL = t1.KEY_INITIAL_CONTENT;
update MARK as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MARK as t1, EVALUATION as t2 set t1.OID_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVALUATION;
update MARK as t1, ATTENDS as t2 set t1.OID_ATTEND = t2.OID where t2.ID_INTERNAL = t1.KEY_ATTEND;
update ACCOUNTABILITY_TYPE as t1, ACCOUNTABILITY_TYPE as t2 set t1.OID_PARENT_INHERENT_FUNCTION = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_INHERENT_FUNCTION;
update ACCOUNTABILITY_TYPE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update CURRICULUM as t1, PARTY as t2 set t1.OID_PERSON_WHO_ALTERED = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PERSON_WHO_ALTERED;
update CURRICULUM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update DELEGATE_ELECTION_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXEMPTION as t1, INSTALLMENT as t2 set t1.OID_INSTALLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTALLMENT;
update COOPERATION as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update COOPERATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REPLY_TO as t1, SENDER as t2 set t1.OID_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER;
update REPLY_TO as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, CONTENT as t2 set t1.OID_UNIT_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT_SITE;
update REGISTRATION_STATE as t1, PARTY as t2 set t1.OID_RESPONSIBLE_PERSON = t2.OID, t1.STATE_DATE = t1.STATE_DATE where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_PERSON;
update REGISTRATION_STATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.STATE_DATE = t1.STATE_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REGISTRATION_STATE as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID, t1.STATE_DATE = t1.STATE_DATE where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update CRON_SCRIPT_STATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.REGISTRATION_DATE = t1.REGISTRATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update JOB as t1, COUNTRY as t2 set t1.OID_COUNTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY;
update JOB as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update JOB as t1, PARTY as t2 set t1.OID_CREATOR = t2.OID where t2.ID_INTERNAL = t1.KEY_CREATOR;
update JOB as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update JOB as t1, BUSINESS_AREA as t2 set t1.OID_BUSINESS_AREA = t2.OID where t2.ID_INTERNAL = t1.KEY_BUSINESS_AREA;
update TRANSACTION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update TRANSACTION as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update CURRICULAR_RULE as t1, CURRICULAR_RULE as t2 set t1.OID_WRAPPED_RULE = t2.OID where t2.ID_INTERNAL = t1.KEY_WRAPPED_RULE;
update GRANT_CONTRACT_MOVEMENT as t1, GRANT_CONTRACT as t2 set t1.OID_GRANT_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_CONTRACT;
update GRANT_CONTRACT_MOVEMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DOMAIN_OBJECT_ACTION_LOG_ENTRY as t1, DOMAIN_OBJECT_ACTION_LOG as t2 set t1.OID_DOMAIN_OBJECT_ACTION_LOG = t2.OID where t2.ID_INTERNAL = t1.KEY_DOMAIN_OBJECT_ACTION_LOG;
update DOMAIN_OBJECT_ACTION_LOG_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE as t1, CANDIDACY_DOCUMENT as t2 set t1.OID_CANDIDACY_DOCUMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_DOCUMENT;
update FILE_LOCAL_CONTENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update FILE_LOCAL_CONTENT as t1, FILE as t2 set t1.OID_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_FILE;
update MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER as t1, MASTER_DEGREE_THESIS_DATA_VERSION as t2 set t1.OID_MASTER_DEGREE_THESIS_DATA_VERSION = t2.OID where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_THESIS_DATA_VERSION;
update MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_GUIDER as t1, ACCOUNTABILITY as t2 set t1.OID_EXTERNAL_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTERNAL_CONTRACT;
update MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER as t1, MASTER_DEGREE_THESIS_DATA_VERSION as t2 set t1.OID_MASTER_DEGREE_THESIS_DATA_VERSION = t2.OID where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_THESIS_DATA_VERSION;
update MASTER_DEGREE_THESIS_DATA_VERSION_EXTERNAL_ASSISTENT_GUIDER as t1, ACCOUNTABILITY as t2 set t1.OID_EXTERNAL_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTERNAL_CONTRACT;
update CONTENT as t1, PARTY as t2 set t1.OID_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARTY;
update EXAM_COORDINATOR as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update EXAM_COORDINATOR as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update EXAM_COORDINATOR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXAM_COORDINATOR as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update TEACHER_SERVICE_DISTRIBUTION as t1, T_S_D_PROCESS_PHASE as t2 set t1.OID_T_S_D_PROCESS_PHASE = t2.OID where t2.ID_INTERNAL = t1.KEY_T_S_D_PROCESS_PHASE;
update TEACHER_SERVICE_DISTRIBUTION as t1, TEACHER_SERVICE_DISTRIBUTION as t2 set t1.OID_PARENT = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT;
update TEACHER_SERVICE_DISTRIBUTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GENERIC_EVENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GENERIC_EVENT as t1, PUNCTUAL_ROOMS_OCCUPATION_REQUEST as t2 set t1.OID_PUNCTUAL_ROOMS_OCCUPATION_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_PUNCTUAL_ROOMS_OCCUPATION_REQUEST;
update CURRICULUM_LINE_LOG as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID, t1.DATE_DATE_TIME = t1.DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT;
update CURRICULUM_LINE_LOG as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID, t1.DATE_DATE_TIME = t1.DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update CURRICULUM_LINE_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.DATE_DATE_TIME = t1.DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM_LINE_LOG as t1, DEGREE_MODULE as t2 set t1.OID_DEGREE_MODULE = t2.OID, t1.DATE_DATE_TIME = t1.DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_DEGREE_MODULE;
update INDIVIDUAL_CANDIDACY_PERSONAL_DETAILS as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_RESIDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_RESIDENCE;
update INDIVIDUAL_CANDIDACY_PERSONAL_DETAILS as t1, COUNTRY as t2 set t1.OID_NATIONALITY = t2.OID where t2.ID_INTERNAL = t1.KEY_NATIONALITY;
update DELEGATE_ELECTION_PERIOD as t1, DELEGATE_ELECTION as t2 set t1.OID_DELEGATE_ELECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_ELECTION;
update ORIENTATION as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_TEACHER;
update ORIENTATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update UNIT_NAME_PART as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOSED_MONTH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELETE_FILE_LOG as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.REQUEST_TIME = t1.REQUEST_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEPLOY_NOTIFIER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.TIME_STAMP = t1.TIME_STAMP where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVENT as t1, PAYMENT_PLAN as t2 set t1.OID_GRATUITY_PAYMENT_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_GRATUITY_PAYMENT_PLAN;
update TEST_CHECKSUM as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update T_S_D_TEACHER as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update T_S_D_COURSE as t1, COMPETENCE_COURSE as t2 set t1.OID_COMPETENCE_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE;
update NEW_TEST_ELEMENT as t1, PARTY as t2 set t1.OID_OWNER = t2.OID where t2.ID_INTERNAL = t1.KEY_OWNER;
update COMPETENCE_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COMPETENCE_COURSE as t1, PARTY as t2 set t1.OID_COMPETENCE_COURSE_GROUP_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_COMPETENCE_COURSE_GROUP_UNIT;
update ENROLMENT_WRAPPER as t1, CREDITS as t2 set t1.OID_CREDITS = t2.OID where t2.ID_INTERNAL = t1.KEY_CREDITS;
update ENROLMENT_WRAPPER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESTRICTION as t1, DEGREE_MODULE as t2 set t1.OID_PRECEDENT_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_PRECEDENT_CURRICULAR_COURSE;
update THESIS as t1, FILE as t2 set t1.OID_DISSERTATION = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_DISSERTATION;
update THESIS as t1, CURRICULUM_MODULE as t2 set t1.OID_ENROLMENT = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_ENROLMENT;
update THESIS as t1, THESIS_LIBRARY_OPERATION as t2 set t1.OID_LAST_LIBRARY_OPERATION = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_LAST_LIBRARY_OPERATION;
update THESIS as t1, CONTENT as t2 set t1.OID_SITE = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_SITE;
update THESIS as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_DEGREE;
update THESIS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update THESIS as t1, RESEARCH_RESULT as t2 set t1.OID_PUBLICATION = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_PUBLICATION;
update THESIS as t1, FILE as t2 set t1.OID_EXTENDED_ABSTRACT = t2.OID, t1.APPROVAL = t1.APPROVAL, t1.CONFIRMATION = t1.CONFIRMATION, t1.CREATION = t1.CREATION, t1.DECLARATION_ACCEPTED_TIME = t1.DECLARATION_ACCEPTED_TIME, t1.PROPOSED_DISCUSSED = t1.PROPOSED_DISCUSSED, t1.DISCUSSED = t1.DISCUSSED, t1.DOCUMENTS_AVAILABLE_AFTER = t1.DOCUMENTS_AVAILABLE_AFTER, t1.EVALUATION = t1.EVALUATION, t1.SUBMISSION = t1.SUBMISSION, t1.CONFIRMMED_DOCUMENTS = t1.CONFIRMMED_DOCUMENTS where t2.ID_INTERNAL = t1.KEY_EXTENDED_ABSTRACT;
update PARTICIPATION as t1, COOPERATION as t2 set t1.OID_COOPERATION = t2.OID where t2.ID_INTERNAL = t1.KEY_COOPERATION;
update GRANT_CONTRACT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_CONTRACT as t1, GRANT_PAYMENT_ENTITY as t2 set t1.OID_GRANT_COST_CENTER = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_COST_CENTER;
update GRANT_CONTRACT as t1, GRANT_INSURANCE as t2 set t1.OID_GRANT_INSURANCE = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_INSURANCE;
update GRANT_CONTRACT as t1, GRANT_OWNER as t2 set t1.OID_GRANT_OWNER = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_OWNER;
update GRANT_CONTRACT as t1, GRANT_TYPE as t2 set t1.OID_GRANT_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_TYPE;
update RECIPIENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INDIVIDUAL_CANDIDACY as t1, DEGREE as t2 set t1.OID_SELECTED_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_SELECTED_DEGREE;
update TRANSACTION as t1, GUIDE_ENTRY as t2 set t1.OID_GUIDE_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDE_ENTRY;
update CAREER as t1, CATEGORY as t2 set t1.OID_CATEGORY = t2.OID where t2.ID_INTERNAL = t1.KEY_CATEGORY;
update DEGREE_INFO as t1, DEGREE_INFO_CANDIDACY as t2 set t1.OID_DEGREE_INFO_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_INFO_CANDIDACY;
update DEGREE_INFO as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DEGREE_INFO as t1, DEGREE_INFO_FUTURE as t2 set t1.OID_DEGREE_INFO_FUTURE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_INFO_FUTURE;
update DEGREE_INFO as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update DEGREE_INFO as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update SENDER as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update QUEUE_JOB as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT_QUEUE_UNDONE = t2.OID, t1.REQUEST_DATE = t1.REQUEST_DATE, t1.JOB_START_TIME = t1.JOB_START_TIME, t1.JOB_END_TIME = t1.JOB_END_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT_QUEUE_UNDONE;
update QUEUE_JOB as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.REQUEST_DATE = t1.REQUEST_DATE, t1.JOB_START_TIME = t1.JOB_START_TIME, t1.JOB_END_TIME = t1.JOB_END_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update QUEUE_JOB as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.REQUEST_DATE = t1.REQUEST_DATE, t1.JOB_START_TIME = t1.JOB_START_TIME, t1.JOB_END_TIME = t1.JOB_END_TIME where t2.ID_INTERNAL = t1.KEY_PERSON;
update CURRICULAR_COURSE_EQUIVALENCE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULAR_COURSE_EQUIVALENCE as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update CURRICULAR_COURSE_EQUIVALENCE as t1, DEGREE_MODULE as t2 set t1.OID_EQUIVALENT_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EQUIVALENT_CURRICULAR_COURSE;
update CONTENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_MODULE_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_MODULE_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_PROFESSIONAL_REGIME as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_PROFESSIONAL_REGIME as t1, PROFESSIONAL_REGIME as t2 set t1.OID_PROFESSIONAL_REGIME = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_REGIME;
update EMPLOYEE_PROFESSIONAL_REGIME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SENIOR as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID, t1.EXPECTED_DEGREE_TERMINATION_DATE_TIME = t1.EXPECTED_DEGREE_TERMINATION_DATE_TIME, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT;
update SENIOR as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.EXPECTED_DEGREE_TERMINATION_DATE_TIME = t1.EXPECTED_DEGREE_TERMINATION_DATE_TIME, t1.LAST_MODIFICATION_DATE_DATE_TIME = t1.LAST_MODIFICATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDACY as t1, DISTRICT_SUBDIVISION as t2 set t1.OID_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE;
update CANDIDACY as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update CANDIDACY as t1, PRECEDENT_DEGREE_INFORMATION as t2 set t1.OID_PRECEDENT_DEGREE_INFORMATION = t2.OID where t2.ID_INTERNAL = t1.KEY_PRECEDENT_DEGREE_INFORMATION;
update CANDIDACY as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_RESIDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_RESIDENCE;
update CANDIDACY as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update CANDIDACY as t1, DISTRICT_SUBDIVISION as t2 set t1.OID_DISTRICT_SUBDIVISION_OF_RESIDENCE = t2.OID where t2.ID_INTERNAL = t1.KEY_DISTRICT_SUBDIVISION_OF_RESIDENCE;
update CANDIDACY as t1, PARTY as t2 set t1.OID_GRANT_OWNER_PROVIDER = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_OWNER_PROVIDER;
update PAYMENT_CODE as t1, INSTALLMENT as t2 set t1.OID_INSTALLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTALLMENT;
update GRATUITY_SITUATION as t1, EMPLOYEE as t2 set t1.OID_PENALTY_EXEMPTION_EMPLOYEE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PENALTY_EXEMPTION_EMPLOYEE;
update GRATUITY_SITUATION as t1, PAYMENT_CODE as t2 set t1.OID_PAYMENT_CODE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_PAYMENT_CODE;
update GRATUITY_SITUATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update GRATUITY_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRATUITY_SITUATION as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_STUDENT_CURRICULAR_PLAN = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_STUDENT_CURRICULAR_PLAN;
update GRATUITY_SITUATION as t1, GRATUITY_VALUES as t2 set t1.OID_GRATUITY_VALUES = t2.OID, t1.WHEN_DATE_TIME = t1.WHEN_DATE_TIME where t2.ID_INTERNAL = t1.KEY_GRATUITY_VALUES;
update ANUAL_BONUS_INSTALLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM_MODULE as t1, CONCLUSION_PROCESS as t2 set t1.OID_CONCLUSION_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_CONCLUSION_PROCESS;
update COURSE_HISTORIC as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update COURSE_HISTORIC as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update RESEARCH_EVENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RECEIPT_ENTRY as t1, RECEIPT as t2 set t1.OID_RECEIPT = t2.OID where t2.ID_INTERNAL = t1.KEY_RECEIPT;
update RECEIPT_ENTRY as t1, ENTRY as t2 set t1.OID_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_ENTRY;
update ENTRY as t1, ACCOUNTING_TRANSACTION as t2 set t1.OID_ACCOUNTING_TRANSACTION = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCOUNTING_TRANSACTION;
update ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ENTRY as t1, ACCOUNT as t2 set t1.OID_ACCOUNT = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCOUNT;
update ENTRY as t1, CREDIT_NOTE_ENTRY as t2 set t1.OID_ADJUSTMENT_CREDIT_NOTE_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_ADJUSTMENT_CREDIT_NOTE_ENTRY;
update SPECIAL_SEASON_CODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_CONTRACT_REGIME as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update GRANT_CONTRACT_REGIME as t1, GRANT_PAYMENT_ENTITY as t2 set t1.OID_GRANT_COST_CENTER = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_COST_CENTER;
update GRANT_CONTRACT_REGIME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update GRANT_CONTRACT_REGIME as t1, GRANT_CONTRACT as t2 set t1.OID_GRANT_CONTRACT = t2.OID where t2.ID_INTERNAL = t1.KEY_GRANT_CONTRACT;
update EVENT_CONFERENCE_ARTICLES_ASSOCIATION as t1, RESEARCH_RESULT as t2 set t1.OID_CONFERENCE_ARTICLE = t2.OID where t2.ID_INTERNAL = t1.KEY_CONFERENCE_ARTICLE;
update EVENT_CONFERENCE_ARTICLES_ASSOCIATION as t1, EVENT_EDITION as t2 set t1.OID_EVENT_EDITION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT_EDITION;
update EVENT_CONFERENCE_ARTICLES_ASSOCIATION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update EVENT_CONFERENCE_ARTICLES_ASSOCIATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REGISTRATION as t1, EVENT as t2 set t1.OID_DFA_REGISTRATION_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_DFA_REGISTRATION_EVENT;
update REGISTRATION as t1, EXECUTION_INTERVAL as t2 set t1.OID_REGISTRATION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION_YEAR;
update REGISTRATION as t1, REGISTRATION_NUMBER as t2 set t1.OID_REGISTRATION_NUMBER = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION_NUMBER;
update REGISTRATION as t1, CONCLUSION_PROCESS as t2 set t1.OID_CONCLUSION_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_CONCLUSION_PROCESS;
update REGISTRATION as t1, CANDIDACY as t2 set t1.OID_STUDENT_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT_CANDIDACY;
update REGISTRATION as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update REGISTRATION as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update REGISTRATION as t1, GAUGING_TEST_RESULT as t2 set t1.OID_ASSOCIATED_GAUGING_TEST_RESULT = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSOCIATED_GAUGING_TEST_RESULT;
update REGISTRATION as t1, PROCESS as t2 set t1.OID_PHD_INDIVIDUAL_PROGRAM_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_INDIVIDUAL_PROGRAM_PROCESS;
update REGISTRATION as t1, SENIOR as t2 set t1.OID_SENIOR = t2.OID where t2.ID_INTERNAL = t1.KEY_SENIOR;
update REGISTRATION as t1, PRECEDENT_DEGREE_INFORMATION as t2 set t1.OID_PRECEDENT_DEGREE_INFORMATION = t2.OID where t2.ID_INTERNAL = t1.KEY_PRECEDENT_DEGREE_INFORMATION;
update REGISTRATION as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_CANDIDACY;
update REGISTRATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update REGISTRATION as t1, EXTERNAL_REGISTRATION_DATA as t2 set t1.OID_EXTERNAL_REGISTRATION_DATA = t2.OID where t2.ID_INTERNAL = t1.KEY_EXTERNAL_REGISTRATION_DATA;
update REGISTRATION as t1, REGISTRATION as t2 set t1.OID_SOURCE_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE_REGISTRATION;
update PHD_INDIVIDUAL_PROGRAM_PROCESS_NUMBER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PHD_INDIVIDUAL_PROGRAM_PROCESS_NUMBER as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PROCESS;
update SERVICE_AGREEMENT_TEMPLATE as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, PARTY as t2 set t1.OID_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, PARTY as t2 set t1.OID_SOURCE_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE_INSTITUTION;
update EXTRA_WORK_REQUEST as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update EXTRA_WORK_REQUEST as t1, PARTY as t2 set t1.OID_UNIT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_UNIT;
update EXTRA_WORK_REQUEST as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXTRA_WORK_REQUEST as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update CREDIT_LINE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update CREDIT_LINE as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update EVENT as t1, RESIDENCE_MONTH as t2 set t1.OID_RESIDENCE_MONTH = t2.OID where t2.ID_INTERNAL = t1.KEY_RESIDENCE_MONTH;
update F_A_Q_ENTRY as t1, F_A_Q_SECTION as t2 set t1.OID_PARENT_SECTION = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_SECTION;
update F_A_Q_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INDIVIDUAL_CANDIDACY as t1, EVENT as t2 set t1.OID_EVENT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EVENT;
update INDIVIDUAL_CANDIDACY as t1, DISTRICT_SUBDIVISION as t2 set t1.OID_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_SCHOOL_TIME_DISTRICT_SUB_DIVISION_OF_RESIDENCE;
update INDIVIDUAL_CANDIDACY as t1, COUNTRY as t2 set t1.OID_COUNTRY_OF_RESIDENCE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_COUNTRY_OF_RESIDENCE;
update INDIVIDUAL_CANDIDACY as t1, PARTY as t2 set t1.OID_GRANT_OWNER_PROVIDER = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_GRANT_OWNER_PROVIDER;
update INDIVIDUAL_CANDIDACY as t1, INDIVIDUAL_CANDIDACY_PERSONAL_DETAILS as t2 set t1.OID_PERSONAL_DETAILS = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PERSONAL_DETAILS;
update INDIVIDUAL_CANDIDACY as t1, DISTRICT_SUBDIVISION as t2 set t1.OID_DISTRICT_SUBDIVISION_OF_RESIDENCE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_DISTRICT_SUBDIVISION_OF_RESIDENCE;
update INDIVIDUAL_CANDIDACY as t1, CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t2 set t1.OID_PRECEDENT_DEGREE_INFORMATION = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_PRECEDENT_DEGREE_INFORMATION;
update INDIVIDUAL_CANDIDACY as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update INDIVIDUAL_CANDIDACY as t1, PROCESS as t2 set t1.OID_CANDIDACY_PROCESS = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PROCESS;
update INDIVIDUAL_CANDIDACY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_ALLOCATION as t1, GENERIC_EVENT as t2 set t1.OID_GENERIC_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_GENERIC_EVENT;
update SERVICE_AGREEMENT_TEMPLATE as t1, ADMINISTRATIVE_OFFICE as t2 set t1.OID_ADMINISTRATIVE_OFFICE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADMINISTRATIVE_OFFICE;
update POSTING_RULE as t1, SERVICE_AGREEMENT_TEMPLATE as t2 set t1.OID_SERVICE_AGREEMENT_TEMPLATE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.END_DATE = t1.END_DATE, t1.START_DATE = t1.START_DATE where t2.ID_INTERNAL = t1.KEY_SERVICE_AGREEMENT_TEMPLATE;
update POSTING_RULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.END_DATE = t1.END_DATE, t1.START_DATE = t1.START_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULAR_RULE as t1, CURRICULAR_RULE as t2 set t1.OID_NOT_RULE = t2.OID where t2.ID_INTERNAL = t1.KEY_NOT_RULE;
update CURRICULAR_RULE as t1, DEGREE_MODULE as t2 set t1.OID_CONTEXT_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_CONTEXT_COURSE_GROUP;
update CURRICULAR_RULE as t1, DEGREE_MODULE as t2 set t1.OID_DEGREE_MODULE_TO_APPLY_RULE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_MODULE_TO_APPLY_RULE;
update CURRICULAR_RULE as t1, CURRICULAR_RULE as t2 set t1.OID_PARENT_COMPOSITE_RULE = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_COMPOSITE_RULE;
update CURRICULAR_RULE as t1, EXECUTION_INTERVAL as t2 set t1.OID_END = t2.OID where t2.ID_INTERNAL = t1.KEY_END;
update CURRICULAR_RULE as t1, EXECUTION_INTERVAL as t2 set t1.OID_BEGIN = t2.OID where t2.ID_INTERNAL = t1.KEY_BEGIN;
update CURRICULAR_RULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_SERVICE_REQUEST as t1, PARTY as t2 set t1.OID_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION;
update PAYMENT_CODE_MAPPING as t1, PAYMENT_CODE as t2 set t1.OID_NEW_PAYMENT_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_NEW_PAYMENT_CODE;
update PAYMENT_CODE_MAPPING as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_INTERVAL = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_INTERVAL;
update PAYMENT_CODE_MAPPING as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PAYMENT_CODE_MAPPING as t1, PAYMENT_CODE as t2 set t1.OID_OLD_PAYMENT_CODE = t2.OID where t2.ID_INTERNAL = t1.KEY_OLD_PAYMENT_CODE;
update SERVICE_AGREEMENT_TEMPLATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PERSON_NAME_PERSON_NAME_PART as t1, PERSON_NAME as t2 set t1.OID_PERSON_NAME = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON_NAME;
update PERSON_NAME_PERSON_NAME_PART as t1, PERSON_NAME_PART as t2 set t1.OID_PERSON_NAME_PART = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON_NAME_PART;
update PERSON_NAME_PART as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SENDER as t1, ACCOUNTABILITY as t2 set t1.OID_PERSON_FUNCTION = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON_FUNCTION;
update CRON_REGISTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BUILD_VERSION = t1.BUILD_VERSION where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONTENT as t1, META_DOMAIN_OBJECT as t2 set t1.OID_META_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_META_DOMAIN_OBJECT;
update DISCOUNT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DISCOUNT as t1, EVENT as t2 set t1.OID_EVENT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED where t2.ID_INTERNAL = t1.KEY_EVENT;
update QUEUE_JOB as t1, FILE as t2 set t1.OID_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_FILE;
update SCIENTIFIC_COMMISSION as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update SCIENTIFIC_COMMISSION as t1, EXECUTION_DEGREE as t2 set t1.OID_EXECUTION_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_DEGREE;
update SCIENTIFIC_COMMISSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACCOUNTING_TRANSACTION as t1, ACCOUNTING_TRANSACTION as t2 set t1.OID_ADJUSTED_TRANSACTION = t2.OID where t2.ID_INTERNAL = t1.KEY_ADJUSTED_TRANSACTION;
update ACCOUNTING_TRANSACTION as t1, ACCOUNTING_TRANSACTION_DETAIL as t2 set t1.OID_TRANSACTION_DETAIL = t2.OID where t2.ID_INTERNAL = t1.KEY_TRANSACTION_DETAIL;
update ACCOUNTING_TRANSACTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACCOUNTING_TRANSACTION as t1, USER as t2 set t1.OID_RESPONSIBLE_USER = t2.OID where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_USER;
update ACCOUNTING_TRANSACTION as t1, EVENT as t2 set t1.OID_EVENT = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT;
update EMPLOYEE_MONTHLY_BONUS_INSTALLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_MONTHLY_BONUS_INSTALLMENT as t1, EMPLOYEE_BONUS_INSTALLMENT as t2 set t1.OID_EMPLOYEE_BONUS_INSTALLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_EMPLOYEE_BONUS_INSTALLMENT;
update INDIVIDUAL_CANDIDACY as t1, DEGREE as t2 set t1.OID_SELECTED_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_SELECTED_DEGREE;
update FILE as t1, CREDIT_NOTE as t2 set t1.OID_SOURCE = t2.OID where t2.ID_INTERNAL = t1.KEY_SOURCE;
update SHIFT_PROFESSORSHIP as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update SHIFT_PROFESSORSHIP as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update SHIFT_PROFESSORSHIP as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CASE_STUDY_CHOICE as t1, CASE_STUDY as t2 set t1.OID_CASE_STUDY = t2.OID where t2.ID_INTERNAL = t1.KEY_CASE_STUDY;
update CASE_STUDY_CHOICE as t1, SEMINARY_CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update CASE_STUDY_CHOICE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DISTRICT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOSED_MONTH_JUSTIFICATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOSED_MONTH_JUSTIFICATION as t1, JUSTIFICATION_MOTIVE as t2 set t1.OID_JUSTIFICATION_MOTIVE = t2.OID where t2.ID_INTERNAL = t1.KEY_JUSTIFICATION_MOTIVE;
update CLOSED_MONTH_JUSTIFICATION as t1, ASSIDUOUSNESS_CLOSED_MONTH as t2 set t1.OID_ASSIDUOUSNESS_CLOSED_MONTH = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_CLOSED_MONTH;
update SENDER as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update CURRICULAR_RULE as t1, DEGREE_MODULE as t2 set t1.OID_EXCLUSIVE_DEGREE_MODULE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXCLUSIVE_DEGREE_MODULE;
update PAYMENT_CODE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
-- Linkare - The column is created by the file changeStudentToPersonPaymentCodeTable.sql (2009-07-27)
-- update PAYMENT_CODE as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_PERSON;
update VEHICLE as t1, PARKING_PARTY as t2 set t1.OID_PARKING_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_PARTY;
update VEHICLE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update VEHICLE as t1, PARKING_REQUEST as t2 set t1.OID_PARKING_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_REQUEST;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, COUNTRY as t2 set t1.OID_COUNTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_COUNTRY;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDACY_PRECEDENT_DEGREE_INFORMATION as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update MANAGEMENT_GROUPS as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROFESSIONAL_REGIME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INQUIRIES_REGISTRY as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update INQUIRIES_REGISTRY as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update INQUIRIES_REGISTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INQUIRIES_REGISTRY as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update INQUIRIES_REGISTRY as t1, DEGREE_MODULE as t2 set t1.OID_CURRICULAR_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_CURRICULAR_COURSE;
update RESOURCE_ALLOCATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESOURCE_ALLOCATION as t1, RESOURCE as t2 set t1.OID_RESOURCE = t2.OID where t2.ID_INTERNAL = t1.KEY_RESOURCE;
update EXTERNAL_REGISTRATION_DATA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXTERNAL_REGISTRATION_DATA as t1, PARTY as t2 set t1.OID_INSTITUTION = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTITUTION;
update EXTERNAL_REGISTRATION_DATA as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_PARENT_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_GROUP;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_QUESTION;
update CANDIDATE_SITUATION as t1, MASTER_DEGREE_CANDIDATE as t2 set t1.OID_MASTER_DEGREE_CANDIDATE = t2.OID where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_CANDIDATE;
update CANDIDATE_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM_MODULE as t1, STUDENT_CURRICULAR_PLAN as t2 set t1.OID_PARENT_STUDENT_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_STUDENT_CURRICULAR_PLAN;
update EXECUTION_COURSE as t1, CONTENT as t2 set t1.OID_BOARD = t2.OID where t2.ID_INTERNAL = t1.KEY_BOARD;
update EXECUTION_COURSE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update EXECUTION_COURSE as t1, SENDER as t2 set t1.OID_SENDER = t2.OID where t2.ID_INTERNAL = t1.KEY_SENDER;
update EXECUTION_COURSE as t1, COURSE_REPORT as t2 set t1.OID_COURSE_REPORT = t2.OID where t2.ID_INTERNAL = t1.KEY_COURSE_REPORT;
update EXECUTION_COURSE as t1, EVALUATION_METHOD as t2 set t1.OID_EVALUATION_METHOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EVALUATION_METHOD;
update EXECUTION_COURSE as t1, CONTENT as t2 set t1.OID_SITE = t2.OID where t2.ID_INTERNAL = t1.KEY_SITE;
update EXECUTION_COURSE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXECUTION_COURSE as t1, VIGILANT_GROUP as t2 set t1.OID_VIGILANT_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_VIGILANT_GROUP;
update CARD_GENERATION_ENTRY as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.CREATED = t1.CREATED where t2.ID_INTERNAL = t1.KEY_PERSON;
update CARD_GENERATION_ENTRY as t1, CARD_GENERATION_BATCH as t2 set t1.OID_CARD_GENERATION_BATCH = t2.OID, t1.CREATED = t1.CREATED where t2.ID_INTERNAL = t1.KEY_CARD_GENERATION_BATCH;
update CARD_GENERATION_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATED = t1.CREATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update TEACHER_SERVICE_ITEM as t1, ADVISE as t2 set t1.OID_ADVISE = t2.OID where t2.ID_INTERNAL = t1.KEY_ADVISE;
update TRANSACTION as t1, REIMBURSEMENT_GUIDE_ENTRY as t2 set t1.OID_REIMBURSEMENT_GUIDE_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_REIMBURSEMENT_GUIDE_ENTRY;
update ACADEMIC_CALENDAR_ENTRY as t1, ACADEMIC_CALENDAR_ENTRY as t2 set t1.OID_TEMPLATE_ENTRY = t2.OID, t1.BEGIN = t1.BEGIN, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_TEMPLATE_ENTRY;
update ACADEMIC_CALENDAR_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN = t1.BEGIN, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACADEMIC_CALENDAR_ENTRY as t1, ACADEMIC_CALENDAR_ENTRY as t2 set t1.OID_PARENT_ENTRY = t2.OID, t1.BEGIN = t1.BEGIN, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_PARENT_ENTRY;
update ACCOUNTABILITY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ACCOUNTABILITY as t1, PARTY as t2 set t1.OID_PARENT_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT_PARTY;
update ACCOUNTABILITY as t1, PARTY as t2 set t1.OID_CHILD_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_CHILD_PARTY;
update ACCOUNTABILITY as t1, ACCOUNTABILITY_TYPE as t2 set t1.OID_ACCOUNTABILITY_TYPE = t2.OID where t2.ID_INTERNAL = t1.KEY_ACCOUNTABILITY_TYPE;
update EVALUATION as t1, DISTRIBUTED_TEST as t2 set t1.OID_DISTRIBUTED_TEST = t2.OID where t2.ID_INTERNAL = t1.KEY_DISTRIBUTED_TEST;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_EXAMS_SPECIAL_SEASON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_EXAMS_SPECIAL_SEASON;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_LESSONS_SECOND_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_LESSONS_SECOND_SEMESTER;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_SECOND_SEMESTER;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_EXAMS_FIRST_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_EXAMS_FIRST_SEMESTER;
update EXECUTION_DEGREE as t1, DEGREE_CURRICULAR_PLAN as t2 set t1.OID_DEGREE_CURRICULAR_PLAN = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE_CURRICULAR_PLAN;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_LESSONS_FIRST_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_LESSONS_FIRST_SEMESTER;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_GRADE_SUBMISSION_NORMAL_SEASON_FIRST_SEMESTER;
update EXECUTION_DEGREE as t1, GRATUITY_VALUES as t2 set t1.OID_GRATUITY_VALUES = t2.OID where t2.ID_INTERNAL = t1.KEY_GRATUITY_VALUES;
update EXECUTION_DEGREE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_EXAMS_SECOND_SEMESTER = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_EXAMS_SECOND_SEMESTER;
update EXECUTION_DEGREE as t1, RESOURCE as t2 set t1.OID_CAMPUS = t2.OID where t2.ID_INTERNAL = t1.KEY_CAMPUS;
update EXECUTION_DEGREE as t1, SCHEDULEING as t2 set t1.OID_SCHEDULING = t2.OID where t2.ID_INTERNAL = t1.KEY_SCHEDULING;
update EXECUTION_DEGREE as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD_GRADE_SUBMISSION_SPECIAL_SEASON;
update EXECUTION_DEGREE as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update SERVICE_AGREEMENT_TEMPLATE as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update ACCOUNTABILITY as t1, PARTY as t2 set t1.OID_RESPONSIBLE = t2.OID where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE;
update BIBLIOGRAPHIC_REFERENCE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update BIBLIOGRAPHIC_REFERENCE as t1, EXECUTION_COURSE as t2 set t1.OID_EXECUTION_COURSE = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_COURSE;
update CONTENT as t1, CONTENT as t2 set t1.OID_PORTAL = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_PORTAL;
update CONTENT as t1, AVAILABILITY_POLICY as t2 set t1.OID_AVAILABILITY_POLICY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_AVAILABILITY_POLICY;
update CONTENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CONTENT as t1, PARTY as t2 set t1.OID_CREATOR = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE where t2.ID_INTERNAL = t1.KEY_CREATOR;
update ACCOUNTING_TRANSACTION as t1, INSTALLMENT as t2 set t1.OID_INSTALLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_INSTALLMENT;
update CANDIDACY_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.START = t1.START, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CANDIDACY_PERIOD as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_INTERVAL = t2.OID, t1.START = t1.START, t1.END = t1.END where t2.ID_INTERNAL = t1.KEY_EXECUTION_INTERVAL;
update TEACHER_SERVICE_ITEM as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update TEACHER_SERVICE_ITEM as t1, PROFESSORSHIP as t2 set t1.OID_PROFESSORSHIP = t2.OID where t2.ID_INTERNAL = t1.KEY_PROFESSORSHIP;
update EMPLOYEE_PROFESSIONAL_RELATION as t1, PROFESSIONAL_RELATION as t2 set t1.OID_PROFESSIONAL_RELATION = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_RELATION;
update EMPLOYEE_PROFESSIONAL_RELATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_PROFESSIONAL_RELATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_PROFESSIONAL_RELATION as t1, PROFESSIONAL_CATEGORY as t2 set t1.OID_PROFESSIONAL_CATEGORY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_CATEGORY;
update GAUGING_TEST_RESULT as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update GAUGING_TEST_RESULT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESIDENCE_MONTH as t1, RESIDENCE_YEAR as t2 set t1.OID_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_YEAR;
update RESIDENCE_MONTH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_TEST_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_MULTIPLE_CHOICE_QUESTION = t2.OID where t2.ID_INTERNAL = t1.KEY_MULTIPLE_CHOICE_QUESTION;
update EMAIL as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ADVISE as t1, TEACHER as t2 set t1.OID_TEACHER = t2.OID where t2.ID_INTERNAL = t1.KEY_TEACHER;
update ADVISE as t1, REGISTRATION as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update ADVISE as t1, EXECUTION_INTERVAL as t2 set t1.OID_END_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_END_EXECUTION_PERIOD;
update ADVISE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ADVISE as t1, EXECUTION_INTERVAL as t2 set t1.OID_START_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_START_EXECUTION_PERIOD;
update EXCEPTION_TYPE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SCIENTIFIC_AREA as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INQUIRIES_STUDENT_EXECUTION_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update INQUIRIES_STUDENT_EXECUTION_PERIOD as t1, STUDENT as t2 set t1.OID_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_STUDENT;
update INQUIRIES_STUDENT_EXECUTION_PERIOD as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_PERIOD;
update EVENT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.EVENT_STATE_DATE = t1.EVENT_STATE_DATE, t1.WHEN_OCCURED = t1.WHEN_OCCURED where t2.ID_INTERNAL = t1.KEY_PERSON;
update EVENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.EVENT_STATE_DATE = t1.EVENT_STATE_DATE, t1.WHEN_OCCURED = t1.WHEN_OCCURED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EVENT as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE_RESPONSIBLE_FOR_CANCEL = t2.OID, t1.EVENT_STATE_DATE = t1.EVENT_STATE_DATE, t1.WHEN_OCCURED = t1.WHEN_OCCURED where t2.ID_INTERNAL = t1.KEY_EMPLOYEE_RESPONSIBLE_FOR_CANCEL;
update NEW_PARKING_DOCUMENT as t1, PARKING_PARTY as t2 set t1.OID_PARKING_PARTY = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_PARTY;
update NEW_PARKING_DOCUMENT as t1, VEHICLE as t2 set t1.OID_VEHICLE = t2.OID where t2.ID_INTERNAL = t1.KEY_VEHICLE;
update NEW_PARKING_DOCUMENT as t1, PARKING_REQUEST as t2 set t1.OID_PARKING_REQUEST = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_REQUEST;
update NEW_PARKING_DOCUMENT as t1, FILE as t2 set t1.OID_PARKING_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_PARKING_FILE;
update NEW_PARKING_DOCUMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update PROFILE_REPORT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DISTRICT_SUBDIVISION as t1, DISTRICT as t2 set t1.OID_DISTRICT = t2.OID where t2.ID_INTERNAL = t1.KEY_DISTRICT;
update DISTRICT_SUBDIVISION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update BLUEPRINT as t1, PARTY as t2 set t1.OID_CREATION_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_CREATION_PERSON;
update BLUEPRINT as t1, FILE as t2 set t1.OID_BLUEPRINT_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_BLUEPRINT_FILE;
update BLUEPRINT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update BLUEPRINT as t1, RESOURCE as t2 set t1.OID_SPACE = t2.OID where t2.ID_INTERNAL = t1.KEY_SPACE;
update RESEARCH_RESULT as t1, EVENT_CONFERENCE_ARTICLES_ASSOCIATION as t2 set t1.OID_EVENT_CONFERENCE_ARTICLES_ASSOCIATION = t2.OID where t2.ID_INTERNAL = t1.KEY_EVENT_CONFERENCE_ARTICLES_ASSOCIATION;
update NEW_TEST_ELEMENT as t1, NEW_TEST_GROUP as t2 set t1.OID_TEST_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_TEST_GROUP;
update USER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME = t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME, t1.LAST_LOGIN_DATE_TIME_DATE_TIME = t1.LAST_LOGIN_DATE_TIME_DATE_TIME, t1.LOGOUT_DATE_TIME = t1.LOGOUT_DATE_TIME, t1.PRIVATE_KEY_CREATION = t1.PRIVATE_KEY_CREATION, t1.PRIVATE_KEY_VALIDITY = t1.PRIVATE_KEY_VALIDITY where t2.ID_INTERNAL = t1.KEY_PERSON;
update USER as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME = t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME, t1.LAST_LOGIN_DATE_TIME_DATE_TIME = t1.LAST_LOGIN_DATE_TIME_DATE_TIME, t1.LOGOUT_DATE_TIME = t1.LOGOUT_DATE_TIME, t1.PRIVATE_KEY_CREATION = t1.PRIVATE_KEY_CREATION, t1.PRIVATE_KEY_VALIDITY = t1.PRIVATE_KEY_VALIDITY where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update USER as t1, LOGIN_REQUEST as t2 set t1.OID_LOGIN_REQUEST = t2.OID, t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME = t1.CURRENT_LOGIN_DATE_TIME_DATE_TIME, t1.LAST_LOGIN_DATE_TIME_DATE_TIME = t1.LAST_LOGIN_DATE_TIME_DATE_TIME, t1.LOGOUT_DATE_TIME = t1.LOGOUT_DATE_TIME, t1.PRIVATE_KEY_CREATION = t1.PRIVATE_KEY_CREATION, t1.PRIVATE_KEY_VALIDITY = t1.PRIVATE_KEY_VALIDITY where t2.ID_INTERNAL = t1.KEY_LOGIN_REQUEST;
update CURRICULUM_MODULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CURRICULUM_MODULE as t1, CURRICULUM_MODULE as t2 set t1.OID_CURRICULUM_GROUP = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_CURRICULUM_GROUP;
update CURRICULUM_MODULE as t1, DEGREE_MODULE as t2 set t1.OID_DEGREE_MODULE = t2.OID, t1.CREATION_DATE_DATE_TIME = t1.CREATION_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_DEGREE_MODULE;
update LOGIN_PERIOD as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update LOGIN_PERIOD as t1, IDENTIFICATION as t2 set t1.OID_LOGIN = t2.OID where t2.ID_INTERNAL = t1.KEY_LOGIN;
update FILE as t1, INDIVIDUAL_CANDIDACY as t2 set t1.OID_INDIVIDUAL_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_INDIVIDUAL_CANDIDACY;
-- update PHD_PROCESS_STATE as t1, PROCESS as t2 set t1.OID_PROCESS = t2.OID where t2.ID_INTERNAL = t1.KEY_PROCESS;
update REIMBURSEMENT_GUIDE_ENTRY as t1, REIMBURSEMENT_GUIDE as t2 set t1.OID_REIMBURSEMENT_GUIDE = t2.OID where t2.ID_INTERNAL = t1.KEY_REIMBURSEMENT_GUIDE;
update REIMBURSEMENT_GUIDE_ENTRY as t1, GUIDE_ENTRY as t2 set t1.OID_GUIDE_ENTRY = t2.OID where t2.ID_INTERNAL = t1.KEY_GUIDE_ENTRY;
update REIMBURSEMENT_GUIDE_ENTRY as t1, TRANSACTION as t2 set t1.OID_REIMBURSEMENT_TRANSACTION = t2.OID where t2.ID_INTERNAL = t1.KEY_REIMBURSEMENT_TRANSACTION;
update REIMBURSEMENT_GUIDE_ENTRY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update SERVICE_AGREEMENT_TEMPLATE as t1, PHD_PROGRAM as t2 set t1.OID_PHD_PROGRAM = t2.OID where t2.ID_INTERNAL = t1.KEY_PHD_PROGRAM;
update VIGILANCY as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update VIGILANCY as t1, EVALUATION as t2 set t1.OID_WRITTEN_EVALUATION = t2.OID where t2.ID_INTERNAL = t1.KEY_WRITTEN_EVALUATION;
update VIGILANCY as t1, VIGILANT_WRAPPER as t2 set t1.OID_VIGILANT_WRAPPER = t2.OID where t2.ID_INTERNAL = t1.KEY_VIGILANT_WRAPPER;
update RESEARCH_RESULT as t1, ARTICLE_ASSOCIATION as t2 set t1.OID_ARTICLE_ASSOCIATION = t2.OID where t2.ID_INTERNAL = t1.KEY_ARTICLE_ASSOCIATION;
update EMPLOYEE_CONTRACT_SITUATION as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_CONTRACT_SITUATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_CONTRACT_SITUATION as t1, PROFESSIONAL_CATEGORY as t2 set t1.OID_PROFESSIONAL_CATEGORY = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_PROFESSIONAL_CATEGORY;
update EMPLOYEE_CONTRACT_SITUATION as t1, CONTRACT_SITUATION as t2 set t1.OID_CONTRACT_SITUATION = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_CONTRACT_SITUATION;
update ACADEMIC_SERVICE_REQUEST as t1, DEGREE_MODULE as t2 set t1.OID_OLD_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_OLD_COURSE_GROUP;
update ACADEMIC_SERVICE_REQUEST as t1, DEGREE_MODULE as t2 set t1.OID_NEW_COURSE_GROUP = t2.OID where t2.ID_INTERNAL = t1.KEY_NEW_COURSE_GROUP;
update LESSON as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update LESSON as t1, OCCUPATION_PERIOD as t2 set t1.OID_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_PERIOD;
update LESSON as t1, RESOURCE_ALLOCATION as t2 set t1.OID_LESSON_SPACE_OCCUPATION = t2.OID where t2.ID_INTERNAL = t1.KEY_LESSON_SPACE_OCCUPATION;
update LESSON as t1, SHIFT as t2 set t1.OID_SHIFT = t2.OID where t2.ID_INTERNAL = t1.KEY_SHIFT;
update PAYMENT_PLAN as t1, SERVICE_AGREEMENT_TEMPLATE as t2 set t1.OID_SERVICE_AGREEMENT_TEMPLATE = t2.OID where t2.ID_INTERNAL = t1.KEY_SERVICE_AGREEMENT_TEMPLATE;
update PERSON_NAME as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update PERSON_NAME as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update IDENTIFICATION as t1, USER as t2 set t1.OID_USER = t2.OID, t1.BEGIN_DATE_DATE_TIME = t1.BEGIN_DATE_DATE_TIME, t1.END_DATE_DATE_TIME = t1.END_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_USER;
update IDENTIFICATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.BEGIN_DATE_DATE_TIME = t1.BEGIN_DATE_DATE_TIME, t1.END_DATE_DATE_TIME = t1.END_DATE_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update ASSIDUOUSNESS_CLOSED_MONTH as t1, ASSIDUOUSNESS_STATUS_HISTORY as t2 set t1.OID_ASSIDUOUSNESS_STATUS_HISTORY = t2.OID where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS_STATUS_HISTORY;
update ASSIDUOUSNESS_CLOSED_MONTH as t1, CLOSED_MONTH as t2 set t1.OID_CLOSED_MONTH = t2.OID where t2.ID_INTERNAL = t1.KEY_CLOSED_MONTH;
update ASSIDUOUSNESS_CLOSED_MONTH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOSED_MONTH_DOCUMENT as t1, FILE as t2 set t1.OID_CLOSED_MONTH_FILE = t2.OID, t1.CREATED_WHEN = t1.CREATED_WHEN where t2.ID_INTERNAL = t1.KEY_CLOSED_MONTH_FILE;
update CLOSED_MONTH_DOCUMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATED_WHEN = t1.CREATED_WHEN where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CLOSED_MONTH_DOCUMENT as t1, CLOSED_MONTH as t2 set t1.OID_CLOSED_MONTH = t2.OID, t1.CREATED_WHEN = t1.CREATED_WHEN where t2.ID_INTERNAL = t1.KEY_CLOSED_MONTH;
update NEW_GROUP_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_CHILD = t2.OID where t2.ID_INTERNAL = t1.KEY_CHILD;
update NEW_GROUP_ELEMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update NEW_GROUP_ELEMENT as t1, NEW_TEST_ELEMENT as t2 set t1.OID_PARENT = t2.OID where t2.ID_INTERNAL = t1.KEY_PARENT;
update CANDIDACY_DOCUMENT as t1, CANDIDACY as t2 set t1.OID_CANDIDACY = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY;
update CANDIDACY_DOCUMENT as t1, FILE as t2 set t1.OID_FILE = t2.OID where t2.ID_INTERNAL = t1.KEY_FILE;
update CANDIDACY_DOCUMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE_ELECTION as t1, STUDENT as t2 set t1.OID_ELECTED_STUDENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ELECTED_STUDENT;
update DELEGATE_ELECTION as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update DELEGATE_ELECTION as t1, DELEGATE_ELECTION_PERIOD as t2 set t1.OID_VOTING_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_VOTING_PERIOD;
update DELEGATE_ELECTION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE_ELECTION as t1, DEGREE as t2 set t1.OID_DEGREE = t2.OID where t2.ID_INTERNAL = t1.KEY_DEGREE;
update DELEGATE_ELECTION as t1, DELEGATE_ELECTION_PERIOD as t2 set t1.OID_CANDIDACY_PERIOD = t2.OID where t2.ID_INTERNAL = t1.KEY_CANDIDACY_PERIOD;
update SCHEDULE as t1, EMPLOYEE as t2 set t1.OID_MODIFIED_BY = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_MODIFIED_BY;
update SCHEDULE as t1, ASSIDUOUSNESS as t2 set t1.OID_ASSIDUOUSNESS = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ASSIDUOUSNESS;
update SCHEDULE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFIED_DATE = t1.LAST_MODIFIED_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update CARD_GENERATION_BATCH as t1, EXECUTION_INTERVAL as t2 set t1.OID_EXECUTION_YEAR = t2.OID, t1.CREATED = t1.CREATED, t1.UPDATED = t1.UPDATED, t1.SENT = t1.SENT where t2.ID_INTERNAL = t1.KEY_EXECUTION_YEAR;
update CARD_GENERATION_BATCH as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATED = t1.CREATED, t1.UPDATED = t1.UPDATED, t1.SENT = t1.SENT where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_THESIS_DATA_VERSION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update MASTER_DEGREE_THESIS_DATA_VERSION as t1, EMPLOYEE as t2 set t1.OID_RESPONSIBLE_EMPLOYEE = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_RESPONSIBLE_EMPLOYEE;
update MASTER_DEGREE_THESIS_DATA_VERSION as t1, MASTER_DEGREE_THESIS as t2 set t1.OID_MASTER_DEGREE_THESIS = t2.OID, t1.LAST_MODIFICATION_DATE_TIME = t1.LAST_MODIFICATION_DATE_TIME where t2.ID_INTERNAL = t1.KEY_MASTER_DEGREE_THESIS;
update CRON_SCRIPT_INVOCATION as t1, CRON_SCRIPT_STATE as t2 set t1.OID_CRON_SCRIPT_STATE = t2.OID, t1.END_TIME = t1.END_TIME, t1.START_TIME = t1.START_TIME where t2.ID_INTERNAL = t1.KEY_CRON_SCRIPT_STATE;
update CRON_SCRIPT_INVOCATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.END_TIME = t1.END_TIME, t1.START_TIME = t1.START_TIME where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE as t1, REGISTRATION as t2 set t1.OID_REGISTRATION = t2.OID where t2.ID_INTERNAL = t1.KEY_REGISTRATION;
update DELEGATE as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update DELEGATE as t1, ACCOUNTABILITY as t2 set t1.OID_DELEGATE_FUNCTION = t2.OID where t2.ID_INTERNAL = t1.KEY_DELEGATE_FUNCTION;
update ASSIDUOUSNESS_RECORD as t1, ASSIDUOUSNESS_RECORD as t2 set t1.OID_ANULATED_ASSIDUOUSNESS_RECORD = t2.OID where t2.ID_INTERNAL = t1.KEY_ANULATED_ASSIDUOUSNESS_RECORD;
update EMPLOYEE_PROFESSIONAL_CONTRACT as t1, CONTRACT_SITUATION as t2 set t1.OID_CONTRACT_SITUATION = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_CONTRACT_SITUATION;
update EMPLOYEE_PROFESSIONAL_CONTRACT as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_PROFESSIONAL_CONTRACT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.CREATION_DATE = t1.CREATION_DATE, t1.MODIFIED_DATE = t1.MODIFIED_DATE, t1.IMPORTATION_DATE = t1.IMPORTATION_DATE, t1.ANULATION_DATE = t1.ANULATION_DATE where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RECEIPT as t1, PARTY as t2 set t1.OID_OWNER_UNIT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_OWNER_UNIT;
update RECEIPT as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update RECEIPT as t1, PARTY as t2 set t1.OID_PERSON = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_PERSON;
update RECEIPT as t1, PARTY as t2 set t1.OID_CREATOR_UNIT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_CREATOR_UNIT;
update RECEIPT as t1, PARTY as t2 set t1.OID_CONTRIBUTOR_PARTY = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_CONTRIBUTOR_PARTY;
update RECEIPT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID, t1.WHEN_CREATED = t1.WHEN_CREATED, t1.WHEN_UPDATED = t1.WHEN_UPDATED where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESULT_UNIT_ASSOCIATION as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update RESULT_UNIT_ASSOCIATION as t1, PARTY as t2 set t1.OID_UNIT = t2.OID where t2.ID_INTERNAL = t1.KEY_UNIT;
update RESULT_UNIT_ASSOCIATION as t1, RESEARCH_RESULT as t2 set t1.OID_RESULT = t2.OID where t2.ID_INTERNAL = t1.KEY_RESULT;
update SENDER as t1, PARTY as t2 set t1.OID_PERSON = t2.OID where t2.ID_INTERNAL = t1.KEY_PERSON;
update EMPLOYEE_BONUS_INSTALLMENT as t1, EMPLOYEE as t2 set t1.OID_EMPLOYEE = t2.OID where t2.ID_INTERNAL = t1.KEY_EMPLOYEE;
update EMPLOYEE_BONUS_INSTALLMENT as t1, ROOT_DOMAIN_OBJECT as t2 set t1.OID_ROOT_DOMAIN_OBJECT = t2.OID where t2.ID_INTERNAL = t1.KEY_ROOT_DOMAIN_OBJECT;
update EMPLOYEE_BONUS_INSTALLMENT as t1, ANUAL_BONUS_INSTALLMENT as t2 set t1.OID_ANUAL_BONUS_INSTALLMENT = t2.OID where t2.ID_INTERNAL = t1.KEY_ANUAL_BONUS_INSTALLMENT;

commit;



begin;

create temporary table _XPTO_
   select CURRICULUM_LINE_LOG.ID_INTERNAL
   from CURRICULUM_LINE_LOG left join REGISTRATION on REGISTRATION.ID_INTERNAL = CURRICULUM_LINE_LOG.KEY_STUDENT
   where CURRICULUM_LINE_LOG.KEY_STUDENT is not null and REGISTRATION.ID_INTERNAL is null;
   
delete from CURRICULUM_LINE_LOG where CURRICULUM_LINE_LOG.ID_INTERNAL in (select * from _XPTO_);

drop temporary table _XPTO_;

commit;



begin;

create temporary table _XPTO_
   select TEST_QUESTION.ID_INTERNAL
   from TEST_QUESTION left join TEST on TEST.ID_INTERNAL = TEST_QUESTION.KEY_TEST
   where TEST_QUESTION.KEY_TEST is not null and TEST.ID_INTERNAL is null;
   
delete from TEST_QUESTION where TEST_QUESTION.ID_INTERNAL in (select * from _XPTO_);

drop temporary table _XPTO_;

commit;



begin;

create temporary table _XPTO_
   select EXECUTION_DEGREE.ID_INTERNAL
   from EXECUTION_DEGREE left join OCCUPATION_PERIOD on OCCUPATION_PERIOD.ID_INTERNAL = EXECUTION_DEGREE.KEY_PERIOD_EXAMS_SPECIAL_SEASON
   where EXECUTION_DEGREE.KEY_PERIOD_EXAMS_SPECIAL_SEASON is not null and OCCUPATION_PERIOD.ID_INTERNAL is null;

update EXECUTION_DEGREE, _XPTO_
set EXECUTION_DEGREE.KEY_PERIOD_EXAMS_SPECIAL_SEASON = null
where EXECUTION_DEGREE.ID_INTERNAL = _XPTO_.ID_INTERNAL;

drop temporary table _XPTO_;

commit;



begin;

create temporary table _XPTO_
   select EXPORT_GROUPING.ID_INTERNAL
   from EXPORT_GROUPING left join GROUPING on GROUPING.ID_INTERNAL = EXPORT_GROUPING.KEY_GROUPING
   where EXPORT_GROUPING.KEY_GROUPING is not null and GROUPING.ID_INTERNAL is null;
   
delete from EXPORT_GROUPING where EXPORT_GROUPING.ID_INTERNAL in (select * from _XPTO_);

drop temporary table _XPTO_;

commit;



begin;

create temporary table _XPTO_
   select CURRICULUM_MODULE.ID_INTERNAL
   from CURRICULUM_MODULE left join STUDENT_CURRICULAR_PLAN on STUDENT_CURRICULAR_PLAN.ID_INTERNAL = CURRICULUM_MODULE.KEY_STUDENT_CURRICULAR_PLAN
   where CURRICULUM_MODULE.KEY_STUDENT_CURRICULAR_PLAN is not null and STUDENT_CURRICULAR_PLAN.ID_INTERNAL is null;

update CURRICULUM_MODULE, _XPTO_
set CURRICULUM_MODULE.KEY_STUDENT_CURRICULAR_PLAN = null
where CURRICULUM_MODULE.ID_INTERNAL = _XPTO_.ID_INTERNAL;

drop temporary table _XPTO_;

commit;



begin;

create temporary table _XPTO_
   select GROUP_STUDENT.ID_INTERNAL
   from GROUP_STUDENT left join REGISTRATION on REGISTRATION.ID_INTERNAL = GROUP_STUDENT.KEY_STUDENT
   where GROUP_STUDENT.KEY_STUDENT is not null and REGISTRATION.ID_INTERNAL is null;
   
delete from GROUP_STUDENT where GROUP_STUDENT.ID_INTERNAL in (select * from _XPTO_);

drop temporary table _XPTO_;

commit;







