Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql =================================================================== diff -u -N --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql (revision 437) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.7.sql (revision 0) @@ -1,11 +0,0 @@ -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', 'time_sent', 'In-Portal', ''); -INSERT INTO ConfigurationValues VALUES ('Perpage_EmailsL', '20', 'In-Portal', ''); -UPDATE ConfigurationValues SET VariableValue = 'u.CreatedOn' WHERE VariableName = 'User_SortField'; -INSERT INTO ConfigurationValues VALUES ('Perpage_CustomData', '20', 'In-Portal', ''); - -ALTER TABLE ThemeFiles ADD INDEX theme (ThemeId); - -UPDATE Modules SET Version = '1.0.7' WHERE Name = 'In-Portal'; \ No newline at end of file