| @@ 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 | ||
| @@ 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 | /** |
|