ALTER TABLE Category DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); INSERT INTO ConfigurationValues VALUES ('Search_MinKeyword_Length', '3', 'In-Portal', ''); UPDATE Modules SET Version = '1.0.10' WHERE Name = 'In-Portal';