ALTER TABLE News DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);

UPDATE ConfigurationValues SET VariableName = 'News_SortField' WHERE VariableName = 'News_Sortfield' LIMIT 1;
UPDATE ConfigurationValues SET VariableName = 'News_SortField2' WHERE VariableName = 'News_Sortfield2' LIMIT 1;

UPDATE ConfigurationAdmin SET VariableName = 'News_SortField' WHERE VariableName = 'News_Sortfield' LIMIT 1;
UPDATE ConfigurationAdmin SET VariableName = 'News_SortField2' WHERE VariableName = 'News_Sortfield2' LIMIT 1;

UPDATE Modules SET Version = '1.0.10' WHERE Name = 'In-News';