DROP TABLE IF EXISTS RESEARCH_PROJECT_RESEARCH_EVENT_ASSOCIATION;

CREATE TABLE `RESEARCH_PROJECT_RESEARCH_EVENT_ASSOCIATION` (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_EVENT_EDITION` int(11) default NULL,
  `KEY_PROJECT` int(11) default NULL,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) default NULL,
  `ROLE` text,
  `CREATION_ENTITY` text,
  `CREATION_ENTITY_DATE` date default NULL,
  PRIMARY KEY  (`ID_INTERNAL`),
  KEY `KEY_EVENT_EDITION` (`KEY_EVENT_EDITION`),
  KEY `KEY_PROJECT` (`KEY_PROJECT`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;