Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql
===================================================================
diff -u -r2801 -r3145
--- trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql	(.../inportal_upgrade_v1.1.2.sql)	(revision 2801)
+++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.2.sql	(.../inportal_upgrade_v1.1.2.sql)	(revision 3145)
@@ -1,4 +1,4 @@
-CREATE TABLE Visits (VisitId int(11) NOT NULL auto_increment, VisitDate int(10) unsigned NOT NULL default '0', Referer varchar(255) NOT NULL default '', IPAddress varchar(15) NOT NULL default '', AffiliateId int(10) unsigned NOT NULL default '0', PortalUserId int(11) NOT NULL default '0', PRIMARY KEY  (VisitId) );
+CREATE TABLE Visits (VisitId int(11) NOT NULL auto_increment, VisitDate int(10) unsigned NOT NULL default '0', Referer varchar(255) NOT NULL default '', IPAddress varchar(15) NOT NULL default '', AffiliateId int(10) unsigned NOT NULL default '0', PortalUserId int(11) NOT NULL default '0', PRIMARY KEY  (VisitId), KEY PortalUserId (PortalUserId), KEY AffiliateId (AffiliateId) );
 
 INSERT INTO ConfigurationAdmin VALUES ('FirstDayOfWeek', 'la_Text_Date_Time_Settings', 'la_config_first_day_of_week', 'select', '', '0=la_sunday,1=la_monday', 8, 1);
 INSERT INTO ConfigurationValues VALUES ('FirstDayOfWeek', '1', 'In-Portal', 'in-portal:configure_general');
