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;

INSERT INTO ConfigurationAdmin VALUES ('UseCronForRegularEvent', 'la_Text_Website', 'la_UseCronForRegularEvent', 'checkbox', NULL, NULL, 18, 0);
INSERT INTO ConfigurationValues VALUES ('UseCronForRegularEvent', '0', 'In-Portal', 'in-portal:configure_general');

ALTER TABLE Language ADD InputDateFormat VARCHAR(50) NOT NULL AFTER TimeFormat, ADD InputTimeFormat VARCHAR(50) NOT NULL AFTER InputDateFormat;

UPDATE Language SET InputDateFormat = 'm/d/Y', InputTimeFormat = 'g:i:s A';

CREATE TABLE ImportCache (CacheId int(11) NOT NULL auto_increment, CacheName varchar(255) NOT NULL default '', VarName int(11) NOT NULL default '0', VarValue text NOT NULL, PRIMARY KEY  (CacheId), KEY CacheName (CacheName), KEY VarName (VarName));

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