- Timestamp:
- 01/05/12 09:51:14 (12 years ago)
- Location:
- trunk
- Files:
-
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/calendar/setup/tables_update.inc.php
r5203 r5311 16 16 return; 17 17 } 18 } 18 } 19 19 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE ".$table." ADD COLUMN ".$column." ".$attrs); 20 }21 $test[] = '0.9.2';22 function calendar_upgrade0_9_2()23 {24 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.17';25 return $GLOBALS['setup_info']['calendar']['currentver'];26 20 } 27 $test[] = '0.9.17'; 28 function calendar_upgrade0_9_17() 29 { 30 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 31 return $GLOBALS['setup_info']['calendar']['currentver']; 32 } 33 $test[] = '0.9.20'; 34 function calendar_upgrade0_9_20() 35 { 36 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 37 return $GLOBALS['setup_info']['calendar']['currentver']; 38 } 39 $test[] = '0.9.21'; 40 function calendar_upgrade0_9_21() 41 { 42 addSpecialColumn("phpgw_cal","last_status","char(1) DEFAULT 'N'::bpchar"); 43 addSpecialColumn("phpgw_cal","last_update","int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)"); 44 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.22'; 45 return $GLOBALS['setup_info']['calendar']['currentver']; 46 } 47 $test[] = '0.9.22'; 48 function calendar_upgrade0_9_22() 49 { 50 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.23'; 51 return $GLOBALS['setup_info']['calendar']['currentver']; 52 } 53 $test[] = '0.9.23'; 54 function calendar_upgrade0_9_23() 55 { 56 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.3'; 57 return $GLOBALS['setup_info']['calendar']['currentver']; 58 } 21 /// Since Expresso 1.2 using Calendar 0.9.3 59 22 $test[] = '0.9.3'; 60 23 function calendar_upgrade0_9_3() … … 102 65 function calendar_upgrade2_0_006() { 103 66 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.007'; 104 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER COLUMN title TYPE character varying(1024);");105 67 return $GLOBALS['setup_info']['calendar']['currentver']; 106 68 } 107 69 $test[] = '2.0.007'; 108 function calendar_upgrade2_0_007() { 109 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.008'; 110 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);"); 70 function calendar_upgrade2_0_007() 71 { 72 $GLOBALS['setup_info']['calendar']['currentver'] = '2.1.000'; 73 return $GLOBALS['setup_info']['calendar']['currentver']; 74 } 75 $test[] = '2.1.000'; 76 function calendar_upgrade2_1_000() 77 { 78 $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.000'; 79 return $GLOBALS['setup_info']['calendar']['currentver']; 80 } 81 $test[] = '2.2.000'; 82 function calendar_upgrade2_2_000() 83 { 84 $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.1'; 85 return $GLOBALS['setup_info']['calendar']['currentver']; 86 } 87 $test[] = '2.2.1'; 88 function calendar_upgrade2_2_1() 89 { 90 $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.6'; 91 return $GLOBALS['setup_info']['calendar']['currentver']; 92 } 93 $test[] = '2.2.6'; 94 function calendar_upgrade2_2_6() 95 { 96 $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.8'; 97 return $GLOBALS['setup_info']['calendar']['currentver']; 98 } 99 $test[] = '2.2.8'; 100 function calendar_upgrade2_2_8() 101 { 102 $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.10'; 103 return $GLOBALS['setup_info']['calendar']['currentver']; 104 } 105 $test[] = '2.2.10'; 106 function calendar_upgrade2_2_10() 107 { 108 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN notifications_owner INT NOT NULL default '0'"); 109 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text"); 110 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by varchar(160)"); 111 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text"); 112 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);"); 113 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER title TYPE varchar(1024)"); 114 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal_repeats ALTER recur_exception TYPE varchar"); 115 $GLOBALS['setup_info']['calendar']['currentver'] = '2.3.0'; 111 116 return $GLOBALS['setup_info']['calendar']['currentver']; 112 117 } 113 114 $test[] = '2.0.008'; 115 function calendar_upgrade2_0_008() { 116 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.009'; 117 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text;"); 118 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text;"); 119 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by character varying(160);"); 120 return $GLOBALS['setup_info']['calendar']['currentver']; 118 $test[] = '2.3.0'; 119 function calendar_upgrade2_3_0() 120 { 121 $GLOBALS['setup_info']['calendar']['currentver'] = '2.4.0'; 122 return $GLOBALS['setup_info']['calendar']['currentver']; 121 123 } 122 124 ?> -
trunk/contactcenter/setup/tables_update.inc.php
r5131 r5311 66 66 } 67 67 68 $test[] = '2.2.3'; 69 function contactcenter_upgrade2_2_3() { 70 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ALTER COLUMN alias TYPE character varying(100);"); 71 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.3.1'; 72 return $GLOBALS['setup_info']['contactcenter']['currentver']; 68 $test[] = '2.2.2'; 69 function contactcenter_upgrade2_2_2() { 70 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.3'; 71 return $GLOBALS['setup_info']['contactcenter']['currentver']; 73 72 } 74 $test[] = '2.2.3.1'; 75 function contactcenter_upgrade2_2_3_1() { 76 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.4.0'; 77 return $GLOBALS['setup_info']['contactcenter']['currentver']; 73 $test[] = '2.2.3'; 74 function contactcenter_upgrade2_2_3() { 75 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.10'; 76 return $GLOBALS['setup_info']['contactcenter']['currentver']; 77 } 78 $test[] = '2.2.10'; 79 function contactcenter_upgrade2_2_10() { 80 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.3.0'; 81 return $GLOBALS['setup_info']['contactcenter']['currentver']; 82 } 83 $test[] = '2.3.0'; 84 function contactcenter_upgrade2_3_0() { 85 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ALTER COLUMN alias TYPE character varying(100);"); 86 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.4.0'; 87 return $GLOBALS['setup_info']['contactcenter']['currentver']; 78 88 } 79 89 ?> -
trunk/expressoAdmin1_2/setup/tables_update.inc.php
r5133 r5311 89 89 { 90 90 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.0.005'; 91 //$GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop groupinfo");92 //$GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop appinfo");93 //$GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop msg");/94 95 91 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 96 92 } 97 93 $test[] = '2.0.005'; 98 function expressoAdmin1_2_upgrade2_0_005() { 99 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.0.006'; 94 function expressoAdmin1_2_upgrade2_0_005() 95 { 96 $GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop groupinfo"); 97 $GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop appinfo"); 98 $GLOBALS['phpgw_setup']->db->query("alter table phpgw_expressoadmin_log drop msg"); 99 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.1.000'; 100 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 101 } 102 $test[] = '2.1.000'; 103 function expressoAdmin1_2_upgrade2_1_000() 104 { 105 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.000'; 106 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 107 } 108 $test[] = '2.2.000'; 109 function expressoAdmin1_2_upgrade2_2_000() 110 { 111 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.1'; 112 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 113 } 114 $test[] = '2.2.1'; 115 function expressoAdmin1_2_upgrade2_2_1() 116 { 117 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.2'; 118 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 119 } 120 $test[] = '2.2.2'; 121 function expressoAdmin1_2_upgrade2_2_2() 122 { 123 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.3'; 124 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 125 } 126 $test[] = '2.2.3'; 127 function expressoAdmin1_2_upgrade2_2_3() 128 { 129 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.6'; 130 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 131 } 132 $test[] = '2.2.6'; 133 function expressoAdmin1_2_upgrade2_2_6() 134 { 135 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.2.8'; 136 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 137 } 138 $test[] = '2.2.8'; 139 function expressoAdmin1_2_upgrade2_2_8() 140 { 141 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.3.0'; 142 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 143 } 144 $test[] = '2.3.0'; 145 function expressoAdmin1_2_upgrade2_3_0() { 100 146 $GLOBALS['phpgw_setup']->db->query(" 101 147 … … 268 314 269 315 } 270 316 $GLOBALS['setup_info']['expressoAdmin1_2']['currentver'] = '2.4.0'; 271 317 return $GLOBALS['setup_info']['expressoAdmin1_2']['currentver']; 272 318 } -
trunk/expressoMail1_2/setup/tables_update.inc.php
r5134 r5311 116 116 return $setup_info['expressoMail1_2']['currentver']; 117 117 } 118 $test[] = '2.2.4'; 119 function expressoMail1_2_upgrade2_2_4() { 118 $test[] = '2.2.4'; 119 function expressoMail1_2_upgrade2_2_4() { 120 $setup_info['expressoMail1_2']['currentver'] = '2.2.6'; 121 return $setup_info['expressoMail1_2']['currentver']; 122 } 123 $test[] = '2.2.6'; 124 function expressoMail1_2_upgrade2_2_6() { 125 $setup_info['expressoMail1_2']['currentver'] = '2.2.8'; 126 return $setup_info['expressoMail1_2']['currentver']; 127 } 128 $test[] = '2.2.8'; 129 function expressoMail1_2_upgrade2_2_8() { 130 $setup_info['expressoMail1_2']['currentver'] = '2.2.10'; 131 return $setup_info['expressoMail1_2']['currentver']; 132 } 133 $test[] = '2.2.10'; 134 function expressoMail1_2_upgrade2_2_10() { 135 $setup_info['expressoMail1_2']['currentver'] = '2.3.0'; 136 return $setup_info['expressoMail1_2']['currentver']; 137 } 138 $test[] = '2.3.0'; 139 function expressoMail1_2_upgrade2_3_0() { 120 140 $setup_info['expressoMail1_2']['currentver'] = '2.4.0'; 121 141 return $setup_info['expressoMail1_2']['currentver']; -
trunk/news_admin/setup/tables_update.inc.php
r5128 r5311 46 46 function news_admin_upgrade2_2_1() 47 47 { 48 $GLOBALS['setup_info']['news_admin']['currentver'] = '2.2.6'; 49 return $GLOBALS['setup_info']['news_admin']['currentver']; 50 } 51 $test[] = '2.2.6'; 52 function news_admin_upgrade2_2_6() 53 { 54 $GLOBALS['setup_info']['news_admin']['currentver'] = '2.2.8'; 55 return $GLOBALS['setup_info']['news_admin']['currentver']; 56 } 57 $test[] = '2.2.8'; 58 function news_admin_upgrade2_2_8() 59 { 60 $GLOBALS['setup_info']['news_admin']['currentver'] = '2.2.10'; 61 return $GLOBALS['setup_info']['news_admin']['currentver']; 62 } 63 $test[] = '2.2.10'; 64 function news_admin_upgrade2_2_10() 65 { 66 $GLOBALS['setup_info']['news_admin']['currentver'] = '2.3.0'; 67 return $GLOBALS['setup_info']['news_admin']['currentver']; 68 } 69 $test[] = '2.3.0'; 70 function news_admin_upgrade2_3_0() 71 { 48 72 $GLOBALS['setup_info']['news_admin']['currentver'] = '2.4.0'; 49 73 return $GLOBALS['setup_info']['news_admin']['currentver']; -
trunk/phpgwapi/setup/tables_update.inc.php
r4306 r5311 116 116 } 117 117 $test[] = '2.2.1'; 118 function phpgwapi_upgrade2_2_1() 119 { 120 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.2'; 121 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 122 } 118 function phpgwapi_upgrade2_2_1() 119 { 120 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.2'; 121 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 122 } 123 $test[] = '2.2.2'; 124 function phpgwapi_upgrade2_2_2() 125 { 126 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.3'; 127 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 128 } 129 $test[] = '2.2.3'; 130 function phpgwapi_upgrade2_2_3() 131 { 132 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.4'; 133 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 134 } 135 $test[] = '2.2.4'; 136 function phpgwapi_upgrade2_2_4() 137 { 138 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.6'; 139 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 140 } 141 $test[] = '2.2.6'; 142 function phpgwapi_upgrade2_2_6() 143 { 144 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.8'; 145 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 146 } 147 $test[] = '2.2.8'; 148 function phpgwapi_upgrade2_2_8() 149 { 150 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.10'; 151 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 152 } 153 $test[] = '2.2.10'; 154 function phpgwapi_upgrade2_2_10() 155 { 156 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.3.0'; 157 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 158 } 159 $test[] = '2.3.0'; 160 function phpgwapi_upgrade2_3_0() 161 { 162 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.4.0'; 163 return $GLOBALS['setup_info']['phpgwapi']['currentver']; 164 } 123 165 ?> -
trunk/workflow/setup/tables_update.inc.php
r5307 r5311 210 210 return $GLOBALS['setup_info']['workflow']['currentver']; 211 211 } 212 213 $test[] = '2.4.000'; 214 function workflow_upgrade2_4_000() 212 $test[] = '2.2.1'; 213 function workflow_upgrade2_2_1() 214 { 215 #updating the current version 216 $GLOBALS['setup_info']['workflow']['currentver'] = '2.2.6'; 217 return $GLOBALS['setup_info']['workflow']['currentver']; 218 } 219 $test[] = '2.2.6'; 220 function workflow_upgrade2_2_6() 221 { 222 #updating the current version 223 $GLOBALS['setup_info']['workflow']['currentver'] = '2.3.0'; 224 return $GLOBALS['setup_info']['workflow']['currentver']; 225 } 226 $test[] = '2.3.0'; 227 function workflow_upgrade2_3_0() 215 228 { 216 229 #updating the current version … … 382 395 return $GLOBALS['setup_info']['workflow']['currentver']; 383 396 } 384 385 386 397 ?>
Note: See TracChangeset
for help on using the changeset viewer.