Code Duplication    Length = 7-14 lines in 8 locations

calendar/setup/tables_update.inc.php 5 locations

@@ 845-851 (lines=7) @@
842
}
843
844
845
function calendar_upgrade0_9_13_002()
846
{
847
	$GLOBALS['egw_setup']->oProc->AddColumn('phpgw_cal','reference',array('type' => 'int', 'precision' => 8,'nullable' => False, 'default' => '0'));
848
849
	$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.13.003';
850
	return $GLOBALS['setup_info']['calendar']['currentver'];
851
}
852
853
854
function calendar_upgrade0_9_13_003()
@@ 880-886 (lines=7) @@
877
}
878
879
880
function calendar_upgrade0_9_13_004()
881
{
882
	$GLOBALS['egw_setup']->oProc->AddColumn('phpgw_cal_alarm','alarm_enabled',array('type' => 'int', 'precision' => 4,'nullable' => False, 'default' => '1'));
883
884
	$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.13.005';
885
	return $GLOBALS['setup_info']['calendar']['currentver'];
886
}
887
888
889
function calendar_upgrade0_9_13_005()
@@ 910-916 (lines=7) @@
907
}
908
909
910
function calendar_upgrade0_9_13_006()
911
{
912
	$GLOBALS['egw_setup']->oProc->AddColumn('phpgw_cal_repeats','recur_exception',array('type' => 'varchar', 'precision' => 255, 'nullable' => True, 'default' => ''));
913
914
	$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.13.007';
915
	return $GLOBALS['setup_info']['calendar']['currentver'];
916
}
917
918
919
@@ 949-961 (lines=13) @@
946
947
948
949
function calendar_upgrade0_9_16_001()
950
{
951
	// this is to set the default as schema_proc was not setting an empty default
952
	$GLOBALS['egw_setup']->oProc->AlterColumn('phpgw_cal_user','cal_type',array(
953
		'type' => 'varchar',
954
		'precision' => '1',
955
		'nullable' => False,
956
		'default' => 'u'
957
	));
958
959
	$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.16.002';
960
	return $GLOBALS['setup_info']['calendar']['currentver'];
961
}
962
963
964
// the following series of updates add some indices, to speedup the selects
@@ 1127-1138 (lines=12) @@
1124
1125
1126
1127
function calendar_upgrade1_0_0_003()
1128
{
1129
	$GLOBALS['egw_setup']->oProc->AlterColumn('phpgw_cal','cal_title',array(
1130
		'type' => 'varchar',
1131
		'precision' => '255',
1132
		'nullable' => False,
1133
		'default' => '1'
1134
	));
1135
1136
	$GLOBALS['setup_info']['calendar']['currentver'] = '1.0.0.004';
1137
	return $GLOBALS['setup_info']['calendar']['currentver'];
1138
}
1139
1140
1141

infolog/setup/tables_update.inc.php 3 locations

@@ 14-25 (lines=12) @@
11
 * @version $Id$
12
 */
13
14
function infolog_upgrade0_9_11()
15
{
16
	$GLOBALS['egw_setup']->oProc->RenameColumn('phpgw_infolog','info_datecreated','info_datemodified');
17
	$GLOBALS['egw_setup']->oProc->AddColumn('phpgw_infolog','info_event_id',array(
18
		'type' => 'int',
19
		'precision' => '4',
20
		'default' => '0',
21
		'nullable' => False
22
	));
23
24
	return $GLOBALS['setup_info']['infolog']['currentver'] = '0.9.15.001';
25
}
26
27
28
function infolog_upgrade0_9_15_001()
@@ 443-456 (lines=14) @@
440
}
441
442
443
function infolog_upgrade1_2()
444
{
445
	$GLOBALS['egw_setup']->oProc->AddColumn('egw_infolog','pl_id',array(
446
		'type' => 'int',
447
		'precision' => '4'
448
	));
449
450
	$GLOBALS['egw_setup']->oProc->AddColumn('egw_infolog','info_price',array(
451
		'type' => 'float',
452
		'precision' => '8'
453
	));
454
455
	return $GLOBALS['setup_info']['infolog']['currentver'] = '1.2.001';
456
}
457
458
459
function infolog_upgrade1_2_001()
@@ 588-601 (lines=14) @@
585
 *
586
 * @return string version
587
 */
588
function infolog_upgrade1_5_002()
589
{
590
	$GLOBALS['egw_setup']->oProc->AlterColumn('egw_infolog_extra','info_extra_name',array(
591
		'type' => 'varchar',
592
		'precision' => '64',
593
		'nullable' => False
594
	));
595
	$GLOBALS['egw_setup']->oProc->AlterColumn('egw_infolog_extra','info_extra_value',array(
596
		'type' => 'text',
597
		'nullable' => False
598
	));
599
600
	return $GLOBALS['setup_info']['infolog']['currentver'] = '1.5.003';
601
}
602
603
604
/**