create table `KOHA_RECORD_HISTORY` (`OID` bigint unsigned, `INSTITUTIONAL_EMAIL_ADDRESS` text, `AREA_CODE` text, `DOCUMENT_IDENTIFICATION_NUMBER` text, `MOBILE_NUMBER` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, `COUNTRY_OF_RESIDENCE` text, `AREA_OF_AREA_CODE` text, `STUDENT_NUMBER` int(11), `NAME` text, `PERSONAL_EMAIL_ADDRESS` text, `DEGREE_NAME` text, `ADDRESS` text, `LIBRARY_CARD_NUMBER` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `DOCUMENT_IDENTIFICATION_TYPE` text, `DEGREE_CODE` text, `PHONE_NUMBER` text, `UPDATE_ENTITY` text, `EXPIRATION_DATE` text, `CATEGORY_CODE` text, `OID_KOHA_RECORD` bigint unsigned, `EMPLOYEE_NUMBER` int(11), `GENDER` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `BIRTH_DATE` text, `USERNAME` text, `WORKING_UNIT` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, primary key (ID_INTERNAL), index (OID), index (OID_KOHA_RECORD), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `KOHA_RECORD` (`OID` bigint unsigned, `INSTITUTIONAL_EMAIL_ADDRESS` text, `AREA_CODE` text, `DOCUMENT_IDENTIFICATION_NUMBER` text, `MOBILE_NUMBER` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, `COUNTRY_OF_RESIDENCE` text, `AREA_OF_AREA_CODE` text, `STUDENT_NUMBER` int(11), `NAME` text, `PERSONAL_EMAIL_ADDRESS` text, `DEGREE_NAME` text, `ADDRESS` text, `LIBRARY_CARD_NUMBER` text, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `DOCUMENT_IDENTIFICATION_TYPE` text, `DEGREE_CODE` text, `PHONE_NUMBER` text, `UPDATE_ENTITY` text, `EXPIRATION_DATE` text, `CATEGORY_CODE` text, `EMPLOYEE_NUMBER` int(11), `GENDER` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `BIRTH_DATE` text, `USERNAME` text, `WORKING_UNIT` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
