UPDATE SearchConfig SET Priority = 2 WHERE FieldName = 'Name' AND TableName = 'Category';
UPDATE SearchConfig SET Priority = 2 WHERE FieldName = 'Description' AND TableName = 'Category';
ALTER TABLE ConfigurationAdmin CHANGE ValueList ValueList TEXT;
UPDATE ConfigurationAdmin SET ValueList='Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,Pop=la_Category_Pop,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=0</SQL>' WHERE VariableName='Category_Sortfield';
UPDATE ConfigurationAdmin SET ValueList='Name=la_Category_Name,Description=la_Category_Description,CreatedOn=la_Category_Date,EditorsPick=la_Category_Pick,Pop=la_Category_Pop,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=0</SQL>' WHERE VariableName='Category_Sortfield2';
UPDATE ItemTypes SET CreatorField = 'PortalUserId' WHERE Module = 'In-Portal' AND SourceTable = 'PortalUser';

UPDATE Modules SET Version = '1.0.8' WHERE Name = 'In-Portal';