Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql
===================================================================
diff -u -r1566 -r1588
--- trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql	(.../inportal_upgrade_v1.1.0.sql)	(revision 1566)
+++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql	(.../inportal_upgrade_v1.1.0.sql)	(revision 1588)
@@ -1,7 +1,20 @@
-ALTER TABLE Category CHANGE CreatedOn CreatedOn INT(11) DEFAULT '0' NOT NULL , CHANGE Modified Modified INT(11) DEFAULT '0' NOT NULL;
-ALTER TABLE CategoryItems DROP PRIMARY KEY;
-ALTER TABLE CategoryItems ADD INDEX (CategoryId);
-ALTER TABLE SessionData ADD PRIMARY KEY (SessionKey, VariableName);
-ALTER TABLE SearchConfig CHANGE JoinClause JoinClause TEXT DEFAULT NULL , CHANGE ForeignField ForeignField TEXT DEFAULT NULL;
-ALTER TABLE Theme ADD StylesheetId INT UNSIGNED NOT NULL ;
+ALTER TABLE SysCache DROP INDEX Expire;
+ALTER TABLE Category MODIFY COLUMN Priority INTEGER(11) DEFAULT NULL;
+ALTER TABLE CustomField ADD COLUMN Multilingual TINYINT(4) NOT NULL DEFAULT '0';
+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');
+
 UPDATE Modules SET Version = '1.1.0' WHERE Name = 'In-Portal';
\ No newline at end of file