CREATE TABLE CANDIDACY_DOCUMENT (ID_INTERNAL INT(11), DOCUMENT_DESCRIPTION TEXT, KEY_ROOT_DOMAIN_OBJECT INT(11) DEFAULT 1, CREATION_ENTITY TEXT, CREATION_ENTITY_DATE TEXT, KEY_FILE INT(11), KEY_CANDIDACY INT(11) NOT NULL, PRIMARY KEY(ID_INTERNAL));
ALTER TABLE CANDIDACY_DOCUMENT ADD INDEX KEY_ROOT_DOMAIN_OBJECT(KEY_ROOT_DOMAIN_OBJECT);
ALTER TABLE CANDIDACY_DOCUMENT ADD INDEX KEY_FILE(KEY_FILE); 
ALTER TABLE CANDIDACY_DOCUMENT ADD INDEX KEY_CANDIDACY(KEY_CANDIDACY);