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

ALTER TABLE USER ADD COLUMN KEY_PASSWORD_RECOVER_REQUEST INT(11) DEFAULT NULL;
ALTER TABLE USER ADD INDEX KEY_PASSWORD_RECOVER_REQUEST(KEY_PASSWORD_RECOVER_REQUEST);