Index: branches/RC/core/install/upgrades.sql
===================================================================
diff -u -r10294 -r10316
--- branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10294)
+++ branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10316)
@@ -175,7 +175,7 @@
 INSERT INTO ConfigurationAdmin VALUES ('u_ThumbnailImageHeight', 'la_section_ImageSettings', 'la_config_ThumbnailImageHeight', 'text', '', '', 30.03, 0, 0);
 INSERT INTO ConfigurationAdmin VALUES ('u_FullImageWidth', 'la_section_ImageSettings', 'la_config_FullImageWidth', 'text', '', '', 30.04, 0, 0);
 INSERT INTO ConfigurationAdmin VALUES ('u_FullImageHeight', 'la_section_ImageSettings', 'la_config_FullImageHeight', 'text', '', '', 30.05, 0, 0);
-            
+
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_MaxImageCount', 5, 'In-Portal:Users', 'in-portal:configure_users');
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageWidth', 120, 'In-Portal:Users', 'in-portal:configure_users');
 INSERT INTO ConfigurationValues VALUES (DEFAULT, 'u_ThumbnailImageHeight', 120, 'In-Portal:Users', 'in-portal:configure_users');
@@ -214,5 +214,26 @@
   AffectedItems int(11) NOT NULL default '0',
   PRIMARY KEY  (SessionLogId),
   KEY SessionId (SessionId),
-  KEY `Status` (`Status`)
-);
\ No newline at end of file
+  KEY `Status` (`Status`),
+  KEY PortalUserId (PortalUserId)
+);
+
+ALTER TABLE CustomField ADD INDEX (MultiLingual), ADD INDEX (DisplayOrder), ADD INDEX (OnGeneralTab), ADD INDEX (IsSystem);
+ALTER TABLE ConfigurationAdmin ADD INDEX (DisplayOrder), ADD INDEX (GroupDisplayOrder), ADD INDEX (Install);
+ALTER TABLE EmailSubscribers ADD INDEX (EmailMessageId), ADD INDEX (PortalUserId);
+ALTER TABLE Events ADD INDEX (`Type`), ADD INDEX (Enabled);
+ALTER TABLE Language ADD INDEX (Enabled), ADD INDEX (PrimaryLang), ADD INDEX (AdminInterfaceLang), ADD INDEX (Priority);
+ALTER TABLE Modules ADD INDEX (Loaded), ADD INDEX (LoadOrder);
+ALTER TABLE PhraseCache ADD INDEX (CacheDate), ADD INDEX (ThemeId), ADD INDEX (StylesheetId);
+ALTER TABLE PortalGroup ADD INDEX (CreatedOn);
+ALTER TABLE PortalUser ADD INDEX (Status), ADD INDEX (Modified), ADD INDEX (dob), ADD INDEX (IsBanned);
+ALTER TABLE Theme ADD INDEX (Enabled), ADD INDEX (StylesheetId), ADD INDEX (PrimaryTheme);
+ALTER TABLE UserGroup ADD INDEX (MembershipExpires), ADD INDEX (ExpirationReminderSent);
+ALTER TABLE EmailLog ADD INDEX (`timestamp`);
+ALTER TABLE StdDestinations ADD INDEX (DestType), ADD INDEX (DestParentId);
+ALTER TABLE Category ADD INDEX (Status), ADD INDEX (CreatedOn), ADD INDEX (EditorsPick);
+ALTER TABLE Stylesheets ADD INDEX (Enabled), ADD INDEX (LastCompiled);
+ALTER TABLE Counters ADD INDEX (IsClone), ADD INDEX (LifeTime), ADD INDEX (LastCounted);
+ALTER TABLE Skins ADD INDEX (IsPrimary), ADD INDEX (LastCompiled);
+
+