|
@@ 967-987 (lines=21) @@
|
| 964 |
|
// the following series of updates add some indices, to speedup the selects |
| 965 |
|
|
| 966 |
|
|
| 967 |
|
function calendar_upgrade0_9_16_002() |
| 968 |
|
{ |
| 969 |
|
$GLOBALS['egw_setup']->oProc->RefreshTable('phpgw_cal_repeats',array( |
| 970 |
|
'fd' => array( |
| 971 |
|
'cal_id' => array('type' => 'int','precision' => '8','nullable' => False), |
| 972 |
|
'recur_type' => array('type' => 'int','precision' => '8','nullable' => False), |
| 973 |
|
'recur_use_end' => array('type' => 'int','precision' => '8','default' => '0'), |
| 974 |
|
'recur_enddate' => array('type' => 'int','precision' => '8'), |
| 975 |
|
'recur_interval' => array('type' => 'int','precision' => '8','default' => '1'), |
| 976 |
|
'recur_data' => array('type' => 'int','precision' => '8','default' => '1'), |
| 977 |
|
'recur_exception' => array('type' => 'varchar','precision' => '255','default' => '') |
| 978 |
|
), |
| 979 |
|
'pk' => array(), |
| 980 |
|
'fk' => array(), |
| 981 |
|
'ix' => array('cal_id'), |
| 982 |
|
'uc' => array() |
| 983 |
|
)); |
| 984 |
|
|
| 985 |
|
$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.16.003'; |
| 986 |
|
return $GLOBALS['setup_info']['calendar']['currentver']; |
| 987 |
|
} |
| 988 |
|
|
| 989 |
|
|
| 990 |
|
|
|
@@ 1142-1162 (lines=21) @@
|
| 1139 |
|
|
| 1140 |
|
|
| 1141 |
|
|
| 1142 |
|
function calendar_upgrade1_0_0_004() |
| 1143 |
|
{ |
| 1144 |
|
$GLOBALS['egw_setup']->oProc->RefreshTable('phpgw_cal_repeats',array( |
| 1145 |
|
'fd' => array( |
| 1146 |
|
'cal_id' => array('type' => 'int','precision' => '8','nullable' => False), |
| 1147 |
|
'recur_type' => array('type' => 'int','precision' => '8','nullable' => False), |
| 1148 |
|
'recur_use_end' => array('type' => 'int','precision' => '8','default' => '0'), |
| 1149 |
|
'recur_enddate' => array('type' => 'int','precision' => '8'), |
| 1150 |
|
'recur_interval' => array('type' => 'int','precision' => '8','default' => '1'), |
| 1151 |
|
'recur_data' => array('type' => 'int','precision' => '8','default' => '1'), |
| 1152 |
|
'recur_exception' => array('type' => 'varchar','precision' => '255','default' => '') |
| 1153 |
|
), |
| 1154 |
|
'pk' => array('cal_id'), |
| 1155 |
|
'fk' => array(), |
| 1156 |
|
'ix' => array(), |
| 1157 |
|
'uc' => array() |
| 1158 |
|
)); |
| 1159 |
|
|
| 1160 |
|
$GLOBALS['setup_info']['calendar']['currentver'] = '1.0.0.005'; |
| 1161 |
|
return $GLOBALS['setup_info']['calendar']['currentver']; |
| 1162 |
|
} |
| 1163 |
|
|
| 1164 |
|
|
| 1165 |
|
|
EGroupware /
egroupware
