ALTER TABLE ThemeFiles ADD INDEX (FileName);
ALTER TABLE ThemeFiles ADD INDEX (FilePath); 
ALTER TABLE Category CHANGE EditorsPick EditorsPick TINYINT(4) NOT NULL DEFAULT '0';

ALTER TABLE PortalUser ADD Company VARCHAR(255) NOT NULL AFTER LastName;
ALTER TABLE PortalUser ADD Fax VARCHAR(255) NOT NULL AFTER Phone;
ALTER TABLE PortalUser ADD Street2 VARCHAR(255) NOT NULL AFTER Street;

UPDATE Modules SET Version = '1.1.7' WHERE Name = 'In-Portal';