create table `DEGREE_CLASSIFICATION` (`OID` bigint unsigned, `DESCRIPTION1` text, `DESCRIPTION2` text, `ABBREVIATION` text, `CLASSIFICATION_ORDER` int(11), `CODE` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) ENGINE=InnoDB, character set latin1;
create table `DEGREE_DESIGNATION` (`OID` bigint unsigned, `CODE` text, `DESCRIPTION` text, `OID_DEGREE_CLASSIFICATION` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_DEGREE_CLASSIFICATION), index (OID_ROOT_DOMAIN_OBJECT)) ENGINE=InnoDB, character set latin1;