[eGroupWare-svn] r29378 - in /trunk/calendar/setup: setup.inc.php tables_current.inc.php tables_update.inc.php

[<ral...@us...>]

Author: ralfbecker
Date: Thu Mar  4 16:39:52 2010
New Revision: 29378

URL: http://www.egroupware.org/viewvc/egroupware?rev=29378&view=rev
Log:
Create an index over egw_cal_user.cal_user_type and cal_user_id, to speed up calendar queries

Modified:
    trunk/calendar/setup/setup.inc.php
    trunk/calendar/setup/tables_current.inc.php
    trunk/calendar/setup/tables_update.inc.php

Modified: trunk/calendar/setup/setup.inc.php
URL: http://www.egroupware.org/viewvc/egroupware/trunk/calendar/setup/setup.inc.php?rev=29378&r1=29377&r2=29378&view=diff
==============================================================================
--- trunk/calendar/setup/setup.inc.php (original)
+++ trunk/calendar/setup/setup.inc.php Thu Mar  4 16:39:52 2010
@@ -10,7 +10,7 @@
  */
 
 $setup_info['calendar']['name']    = 'calendar';
-$setup_info['calendar']['version'] = '1.7.008';
+$setup_info['calendar']['version'] = '1.7.009';
 $setup_info['calendar']['app_order'] = 3;
 $setup_info['calendar']['enable']  = 1;
 $setup_info['calendar']['index']   = 'calendar.calendar_uiviews.index';
@@ -65,8 +65,3 @@
 		'from' => 'Calendar',
 	),
 );
-
-
-
-
-

Modified: trunk/calendar/setup/tables_current.inc.php
URL: http://www.egroupware.org/viewvc/egroupware/trunk/calendar/setup/tables_current.inc.php?rev=29378&r1=29377&r2=29378&view=diff
==============================================================================
--- trunk/calendar/setup/tables_current.inc.php (original)
+++ trunk/calendar/setup/tables_current.inc.php Thu Mar  4 16:39:52 2010
@@ -80,7 +80,7 @@
 		),
 		'pk' => array('cal_id','cal_recur_date','cal_user_type','cal_user_id'),
 		'fk' => array(),
-		'ix' => array(),
+		'ix' => array(array('cal_user_type','cal_user_id')),
 		'uc' => array()
 	),
 	'egw_cal_extra' => array(

Modified: trunk/calendar/setup/tables_update.inc.php
URL: http://www.egroupware.org/viewvc/egroupware/trunk/calendar/setup/tables_update.inc.php?rev=29378&r1=29377&r2=29378&view=diff
==============================================================================
--- trunk/calendar/setup/tables_update.inc.php (original)
+++ trunk/calendar/setup/tables_update.inc.php Thu Mar  4 16:39:52 2010
@@ -2052,3 +2052,16 @@
 	}
 	return $GLOBALS['setup_info']['calendar']['currentver'] = '1.7.008';
 }
+
+/**
+ * Create an index over egw_cal_user.cal_user_type and cal_user_id, to speed up calendar queries
+ * 
+ * @return string
+ */
+function calendar_upgrade1_7_008()
+{
+	$GLOBALS['egw_setup']->oProc->CreateIndex('egw_cal_user',array('cal_user_type','cal_user_id'));
+
+	return $GLOBALS['setup_info']['calendar']['currentver'] = '1.7.009';
+}
+