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)
)

CREATE TABLE ImportScripts (
  is_id smallint(5) unsigned NOT NULL auto_increment,
  is_Module varchar(50) NOT NULL default '',
  is_string_id varchar(10) NOT NULL default '',
  is_script varchar(100) NOT NULL default '',
  is_label varchar(255) NOT NULL default '',
  is_field_prefix varchar(50) NOT NULL default '',
  is_requred_fields varchar(255) NOT NULL default '',
  is_enabled tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (is_id)
)

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';