CREATE TABLE EmailLog ( EmailLogId INT(11) NOT NULL , fromuser VARCHAR(200) NOT NULL , addressto VARCHAR(255) NOT NULL , subject VARCHAR(255) NOT NULL , timestamp BIGINT NOT NULL , event VARCHAR(100) NOT NULL , PRIMARY KEY (EmailLogId) ) UPDATE Modules SET Version = '1.0.7' WHERE Name = 'In-Portal';