ALTER TABLE ThemeFiles ADD INDEX (FileName); ALTER TABLE ThemeFiles ADD INDEX (FilePath); UPDATE Modules SET Version = '1.1.7' WHERE Name = 'In-Portal';