ALTER TABLE Category DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
ALTER TABLE Category CHANGE Priority Priority INT(11) NOT NULL DEFAULT '0';
ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
UPDATE Modules SET Version = '1.0.12' WHERE Name = 'In-Portal';