ALTER TABLE News ADD INDEX (Filename ( 5 )); UPDATE ItemTypes SET Prefix = 'n' WHERE SourceTable = 'News'; UPDATE Modules SET Version = '1.1.4' WHERE Name = 'In-News';