Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -r2414 -r2633
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 2414)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 2633)
@@ -683,6 +683,8 @@
   IPAddress varchar(15) NOT NULL default '',
   AffiliateId int(10) unsigned NOT NULL default '0',
   PortalUserId int(11) NOT NULL default '0',
-  PRIMARY KEY  (VisitId)
+  PRIMARY KEY  (VisitId),
+  KEY PortalUserId (PortalUserId),
+  KEY AffiliateId (AffiliateId)
 )
 # --------------------------------------------------------
\ No newline at end of file