ALTER TABLE SysCache DROP INDEX Expire;
ALTER TABLE Category MODIFY COLUMN Priority INTEGER(11) DEFAULT NULL;
ALTER TABLE Phrase ADD COLUMN LastChanged INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE Phrase ADD COLUMN LastChangeIP VARCHAR(15) NOT NULL;
ALTER TABLE Phrase ADD COLUMN Module VARCHAR(30) NOT NULL;
ALTER TABLE PortalUser MODIFY COLUMN State VARCHAR(20) NOT NULL;
ALTER TABLE SearchConfig MODIFY COLUMN ForeignField TEXT;
ALTER TABLE SearchConfig MODIFY COLUMN JoinClause TEXT;
ALTER TABLE Theme ADD COLUMN StylesheetId INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE Phrase ADD KEY LanguageId (LanguageId);

CREATE TABLE Cache (VarName varchar(255) NOT NULL default '', Data longtext, Cached int(11) default NULL, PRIMARY KEY  (VarName), KEY Cached (Cached) );
CREATE TABLE StylesheetSelectors (SelectorId int(11) NOT NULL auto_increment, StylesheetId int(11) NOT NULL default '0', Name varchar(255) NOT NULL default '', SelectorName varchar(255) NOT NULL default '', SelectorData text NOT NULL, Description text NOT NULL, Type tinyint(4) NOT NULL default '0', AdvancedCSS text NOT NULL, ParentId int(11) NOT NULL default '0', PRIMARY KEY  (SelectorId) );
CREATE TABLE Stylesheets ( StylesheetId int(11) NOT NULL auto_increment, Name varchar(255) NOT NULL default '', Description varchar(255) NOT NULL default '', AdvancedCSS text NOT NULL, LastCompiled int(10) unsigned NOT NULL default '0', Enabled int(11) NOT NULL default '0', PRIMARY KEY  (StylesheetId) );

INSERT INTO ConfigurationAdmin VALUES ('Email_As_Login', 'la_Text_General', 'la_use_emails_as_login', 'checkbox', NULL, NULL, 1, 0);
INSERT INTO ConfigurationValues VALUES ('Email_As_Login', '1', 'In-Portal:Users', 'in-portal:configure_users');

ALTER TABLE Language ADD COLUMN UnitSystem TINYINT DEFAULT '1' NOT NULL;

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