ALTER TABLE Category ADD INDEX (Filename ( 5 ));

INSERT INTO ConfigurationAdmin VALUES ('MaxImportCategoryLevels', 'la_Text_General', 'la_prompt_max_import_category_levels', 'text', '', '', 9, 1);
INSERT INTO ConfigurationValues VALUES ('MaxImportCategoryLevels', '10', 'In-Portal', 'in-portal:configure_categories');

ALTER TABLE ItemTypes ADD Prefix VARCHAR(20) NOT NULL AFTER Module;
UPDATE ItemTypes SET Prefix = 'c' WHERE SourceTable = 'Category';
UPDATE ItemTypes SET Prefix = 'u' WHERE SourceTable = 'PortalUser';

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