CREATE TABLE EmailLog ( EmailLogId int(11) NOT NULL auto_increment, fromuser varchar(200) default NULL, addressto varchar(255) default NULL, subject varchar(255) default NULL, timestamp bigint(20) default '0', event varchar(100) default NULL, PRIMARY KEY (EmailLogId) ) INSERT INTO ConfigurationValues VALUES ('EmailsL_SortField', 'timestamp', 'In-Portal', ''); INSERT INTO ConfigurationValues VALUES ('Perpage_EmailsL', '20', 'In-Portal', ''); UPDATE Modules SET Version = '1.0.7' WHERE Name = 'In-Portal';