create table `THESIS_SUBJECT` (`OID` bigint unsigned, `OID_TEACHER` bigint unsigned, `NAME` text, `DESCRIPTION` text, `OID_PHD_PROGRAM_FOCUS_AREA` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_TEACHER), index (OID_PHD_PROGRAM_FOCUS_AREA), index (OID_ROOT_DOMAIN_OBJECT)) ENGINE=InnoDB, character set latin1;
create table `THESIS_SUBJECT_ORDER` (`OID` bigint unsigned, `OID_THESIS_SUBJECT` bigint unsigned, `OID_PHD_INDIVIDUAL_PROGRAM_PROCESS` bigint unsigned, `ORDER` int(11), `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_THESIS_SUBJECT), index (OID_PHD_INDIVIDUAL_PROGRAM_PROCESS), index (OID_ROOT_DOMAIN_OBJECT)) ENGINE=InnoDB, character set latin1;
