CREATE TABLE PARTY_CONTACT_VALIDATION_REQUEST (ID_INTERNAL INT(11), VALIDATION_REQUEST TEXT, REQUEST_TIME TEXT, CREATION_ENTITY VARCHAR(255), CREATION_ENTITY_DATE TEXT, KEY_PARTY_CONTACT INT(11) NOT NULL, KEY_ROOT_DOMAIN_OBJECT INT(11) DEFAULT 1, PRIMARY KEY (ID_INTERNAL));
ALTER TABLE PARTY_CONTACT_VALIDATION_REQUEST ADD INDEX KEY_PARTY_CONTACT(KEY_PARTY_CONTACT);
ALTER TABLE PARTY_CONTACT_VALIDATION_REQUEST ADD INDEX KEY_ROOT_DOMAIN_OBJECT(KEY_ROOT_DOMAIN_OBJECT);

ALTER TABLE PARTY_CONTACT ADD COLUMN KEY_PARTY_CONTACT_VALIDATION_REQUEST INT(11) DEFAULT NULL;
ALTER TABLE PARTY_CONTACT ADD INDEX KEY_PARTY_CONTACT_VALIDATION_REQUEST(KEY_PARTY_CONTACT_VALIDATION_REQUEST);