CREATE TABLE MOBILITY_AGREEMENT (
	ID_INTERNAL INT(11) AUTO_INCREMENT, 
	MOBILITY_PROGRAM VARCHAR(100),
	START_DATE DATE,
	END_DATE DATE,
	KEY_REGISTRATION INT(11) NOT NULL,
	KEY_INSTITUTION INT(11) NOT NULL,
	KEY_ROOT_DOMAIN_OBJECT INT(11) DEFAULT 1,
	CREATION_ENTITY TEXT,
	CREATION_ENTITY_DATE DATE,
	UPDATE_ENTITY TEXT,
	UPDATE_ENTITY_DATE DATETIME,
	PRIMARY KEY(ID_INTERNAL)
) ENGINE = INNODB;

ALTER TABLE MOBILITY_AGREEMENT ADD INDEX KEY_REGISTRATION(KEY_REGISTRATION);
ALTER TABLE MOBILITY_AGREEMENT ADD INDEX KEY_INSTITUTION(KEY_INSTITUTION);
ALTER TABLE MOBILITY_AGREEMENT ADD INDEX KEY_ROOT_DOMAIN_OBJECT(KEY_ROOT_DOMAIN_OBJECT);