Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql =================================================================== diff -u -r402 -r424 --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql (.../inportal_upgrade_v1.0.7.sql) (revision 402) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql (.../inportal_upgrade_v1.0.7.sql) (revision 424) @@ -1,24 +1,6 @@ -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 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) -) +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', 'time_sent', 'In-Portal', ''); INSERT INTO ConfigurationValues VALUES ('Perpage_EmailsL', '20', 'In-Portal', '');