CREATE TABLE ACCOUNT_ACTIVATION (ID_INTERNAL INT(11), REQUEST_TIME TEXT, SEND_REQUEST_ADDRESS TEXT, IS_ACTIVE tinyint(1) NOT NULL DEFAULT 0, DELIVERED tinyint(1) NOT NULL DEFAULT 0, 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 ACCOUNT_ACTIVATION ADD INDEX KEY_USER(KEY_USER);
ALTER TABLE ACCOUNT_ACTIVATION ADD INDEX KEY_ROOT_DOMAIN_OBJECT(KEY_ROOT_DOMAIN_OBJECT);

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