CREATE TABLE COLLABORATOR (ID_INTERNAL INT(11) AUTO_INCREMENT, ACTIVE TINYINT(1) NOT NULL DEFAULT 1, CREATION_ENTITY TEXT, CREATION_ENTITY_DATE TEXT, KEY_ROOT_DOMAIN_OBJECT INT(11) NOT NULL DEFAULT 1, KEY_PERSON INT(11) NOT NULL DEFAULT 1, PRIMARY KEY(ID_INTERNAL));
ALTER TABLE COLLABORATOR ADD INDEX KEY_ROOT_DOMAIN_OBJECT(KEY_ROOT_DOMAIN_OBJECT);
ALTER TABLE COLLABORATOR ADD INDEX KEY_PERSON(KEY_PERSON);

ALTER TABLE PARTY ADD COLUMN KEY_COLLABORATOR INT(11);
ALTER TABLE PARTY ADD INDEX KEY_COLLABORATOR(KEY_COLLABORATOR);
