Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql =================================================================== diff -u -N -r3999 -r4052 --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql (.../inportal_upgrade_v1.1.8.sql) (revision 3999) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql (.../inportal_upgrade_v1.1.8.sql) (revision 4052) @@ -1,4 +1,15 @@ UPDATE SearchConfig SET CustomFieldId = NULL WHERE CustomFieldId = 0; ALTER TABLE SearchConfig CHANGE CustomFieldId CustomFieldId INT(11) NULL DEFAULT NULL; +UPDATE SearchConfig SET SimpleSearch = -1 WHERE TableName = 'PortalUser' AND ModuleName = 'In-Portal'; +INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Keyword_category', 'la_config_SearchRel_DefaultKeyword', 'la_text_keyword', 'text', NULL, NULL, 0, 1); +INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Pop_category', 'la_config_DefaultPop', 'la_text_popularity', 'text', NULL, NULL, 0, 1); +INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Rating_category', 'la_config_DefaultRating', 'la_prompt_Rating', 'text', NULL, NULL, 0, 1); +INSERT INTO ConfigurationAdmin VALUES ('SearchRel_Increase_category', 'la_config_DefaultIncreaseImportance', 'la_text_increase_importance', 'text', NULL, NULL, 0, 1); + +UPDATE ConfigurationValues SET Section = 'in-portal:configuration_search' WHERE VariableName LIKE 'SearchRel_%_category' OR VariableName = 'Search_ShowMultiple_category'; + +CREATE TABLE PortalUserCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', UNIQUE KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId)); +CREATE TABLE CategoryCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', UNIQUE KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId)); + UPDATE Modules SET Version = '1.1.8' WHERE Name = 'In-Portal'; \ No newline at end of file