CREATE TABLE `PROFESSORSHIP_SCHOOL_CLASS` (
	`KEY_PROFESSORSHIP` INT(11) NOT NULL, 
	`KEY_SCHOOL_CLASS` INT(11) NOT NULL, 
	PRIMARY KEY(`KEY_PROFESSORSHIP`, `KEY_SCHOOL_CLASS`), 
	KEY(`KEY_PROFESSORSHIP`), 
	KEY(`KEY_SCHOOL_CLASS`)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;