| [ Index ] |
|
Code source de eGroupWare 1.2.106-2 |
1 <?php 2 /**************************************************************************\ 3 * eGroupWare - Setup * 4 * http://www.egroupware.org * 5 * -------------------------------------------- * 6 * This program is free software; you can redistribute it and/or modify it * 7 * under the terms of the GNU General Public License as published by the * 8 * Free Software Foundation; either version 2 of the License, or (at your * 9 * option) any later version. * 10 \**************************************************************************/ 11 12 /* $Id: tables_update_0_9_9.inc.php 16306 2004-08-09 12:40:51Z reinerj $ */ 13 14 $test[] = '0.9.1'; 15 function phpgwapi_upgrade0_9_1() 16 { 17 global $phpgw_info, $setup_info, $phpgw_setup; 18 19 $phpgw_setup->oProc->AlterColumn('access_log', 'lo', array('type' => 'varchar', 'precision' => 255)); 20 21 $phpgw_setup->oProc->query("update lang set lang='da' where lang='dk'"); 22 $phpgw_setup->oProc->query("update lang set lang='ko' where lang='kr'"); 23 24 $phpgw_setup->oProc->AddColumn('addressbook', 'ab_company_id', array('type' => 'int', 'precision' => 4)); 25 $phpgw_setup->oProc->AddColumn('addressbook', 'ab_title', array('type' => 'varchar', 'precision' => 60)); 26 $phpgw_setup->oProc->AddColumn('addressbook', 'ab_address2', array('type' => 'varchar', 'precision' => 60)); 27 28 $phpgw_setup->oProc->query("update preferences set preference_name='da' where preference_name='dk'"); 29 $phpgw_setup->oProc->query("update preferences set preference_name='ko' where preference_name='kr'"); 30 31 //install weather support 32 $phpgw_setup->oProc->query("insert into applications (app_name, app_title, app_enabled, app_order, app_tables, app_version) values ('weather', 'Weather', 1, 12, NULL, '".$phpgw_info['server']['version']."')"); 33 $phpgw_setup->oProc->query("INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'weather','Weather','en','weather')"); 34 35 $setup_info['phpgwapi']['currentver'] = '0.9.2'; 36 return $setup_info['phpgwapi']['currentver']; 37 //return True; 38 } 39 40 function phpgwapi_v0_9_2to0_9_3update_owner($table, $field) 41 { 42 global $phpgw_setup; 43 44 $phpgw_setup->oProc->query("select distinct($field) from $table"); 45 if ($phpgw_setup->oProc->num_rows()) { 46 while ($phpgw_setup->oProc->next_record()) 47 { 48 $owner[count($owner)] = $phpgw_setup->oProc->f($field); 49 } 50 for($i=0;$i<count($owner);$i++) 51 { 52 $phpgw_setup->oProc->query("select account_id from accounts where account_lid='".$owner[$i]."'"); 53 $phpgw_setup->oProc->next_record(); 54 $phpgw_setup->oProc->query("update $table set $field=".$phpgw_setup->oProc->f("account_id")." where $field='".$owner[$i]."'"); 55 } 56 } 57 58 $phpgw_setup->oProc->AlterColumn($table, $field, array('type' => 'int', 'precision' => 4, 'nullable' => false, 'default' => 0)); 59 } 60 61 $test[] = '0.9.2'; 62 function phpgwapi_upgrade0_9_2() 63 { 64 global $setup_info; 65 66 $setup_info['phpgwapi']['currentver'] = '0.9.3pre1'; 67 return $setup_info['phpgwapi']['currentver']; 68 //return True; 69 } 70 $test[] = '0.9.3pre1'; 71 function phpgwapi_upgrade0_9_3pre1() 72 { 73 global $setup_info; 74 75 $setup_info['phpgwapi']['currentver'] = '0.9.3pre2'; 76 return $setup_info['phpgwapi']['currentver']; 77 //return True; 78 } 79 80 $test[] = '0.9.3pre2'; 81 function phpgwapi_upgrade0_9_3pre2() 82 { 83 global $setup_info; 84 85 $setup_info['phpgwapi']['currentver'] = '0.9.3pre3'; 86 return $setup_info['phpgwapi']['currentver']; 87 //return True; 88 } 89 90 $test[] = '0.9.3pre3'; 91 function phpgwapi_upgrade0_9_3pre3() 92 { 93 global $setup_info; 94 95 $setup_info['phpgwapi']['currentver'] = '0.9.3pre4'; 96 return $setup_info['phpgwapi']['currentver']; 97 //return True; 98 } 99 100 $test[] = '0.9.3pre4'; 101 function phpgwapi_upgrade0_9_3pre4() 102 { 103 global $setup_info, $phpgw_setup; 104 105 $phpgw_setup->oProc->AlterColumn("config", "config_name", array("type" => "varchar", "precision" => 255, "nullable" => false)); 106 107 $setup_info['phpgwapi']['currentver'] = '0.9.3pre5'; 108 return $setup_info['phpgwapi']['currentver']; 109 //return True; 110 } 111 112 $test[] = '0.9.3pre5'; 113 function phpgwapi_upgrade0_9_3pre5() 114 { 115 global $setup_info, $phpgw_setup; 116 117 $phpgw_setup->oProc->CreateTable( 118 'categories', array( 119 'fd' => array( 120 'cat_id' => array('type' => 'auto', 'nullable' => false), 121 'account_id' => array('type' => 'int', 'precision' => 4, 'nullable' => false, 'default' => 0), 122 'app_name' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false), 123 'cat_name' => array('type' => 'varchar', 'precision' => 150, 'nullable' => false), 124 'cat_description' => array('type' => 'text', 'nullable' => false) 125 ), 126 'pk' => array('cat_id'), 127 'ix' => array(), 128 'fk' => array(), 129 'uc' => array() 130 ) 131 ); 132 133 $setup_info['phpgwapi']['currentver'] = '0.9.3pre6'; 134 return $setup_info['phpgwapi']['currentver']; 135 //return True; 136 } 137 138 $test[] = '0.9.3pre6'; 139 function phpgwapi_upgrade0_9_3pre6() 140 { 141 global $setup_info, $phpgw_setup; 142 143 $phpgw_setup->oProc->query("insert into applications (app_name, app_title, app_enabled, app_order, app_tables, app_version) values ('transy', 'Translation Management', 0, 13, NULL, '".$setup_info['phpgwapi']['version']."')"); 144 145 $phpgw_setup->oProc->AddColumn('addressbook', 'ab_url', array('type' => 'varchar', 'precision' => 255)); 146 147 $setup_info['phpgwapi']['currentver'] = '0.9.3pre7'; 148 return $setup_info['phpgwapi']['currentver']; 149 //return True; 150 } 151 152 $test[] = '0.9.3pre7'; 153 function phpgwapi_upgrade0_9_3pre7() 154 { 155 global $setup_info, $phpgw_setup; 156 157 $phpgw_setup->oProc->CreateTable('languages', array( 158 'fd' => array( 159 'lang_id' => array('type' => 'varchar', 'precision' => 2, 'nullable' => false), 160 'lang_name' => array('type' => 'varchar', 'precision' => 50, 'nullable' => false), 161 'available' => array('type' => 'char', 'precision' => 3, 'nullable' => false, 'default' => 'No') 162 ), 163 'pk' => array('lang_id'), 164 'ix' => array(), 165 'fk' => array(), 166 'uc' => array() 167 ) 168 ); 169 170 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AA','Afar','No')"); 171 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AB','Abkhazian','No')"); 172 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AF','Afrikaans','No')"); 173 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AM','Amharic','No')"); 174 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AR','Arabic','No')"); 175 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AS','Assamese','No')"); 176 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AY','Aymara','No')"); 177 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AZ','Azerbaijani','No')"); 178 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BA','Bashkir','No')"); 179 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BE','Byelorussian','No')"); 180 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BG','Bulgarian','No')"); 181 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BH','Bihari','No')"); 182 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BI','Bislama','No')"); 183 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BN','Bengali / Bangla','No')"); 184 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BO','Tibetan','No')"); 185 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BR','Breton','No')"); 186 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CA','Catalan','No')"); 187 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CO','Corsican','No')"); 188 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CS','Czech','No')"); 189 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CY','Welsh','No')"); 190 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DA','Danish','Yes')"); 191 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DE','German','Yes')"); 192 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DZ','Bhutani','No')"); 193 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EL','Greek','No')"); 194 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EN','English / US','Yes')"); 195 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EO','Esperanto','No')"); 196 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ES','Spanish','Yes')"); 197 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ET','Estonian','No')"); 198 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EU','Basque','No')"); 199 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FA','Persian','No')"); 200 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FI','Finnish','No')"); 201 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FJ','Fiji','No')"); 202 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FO','Faeroese','No')"); 203 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FR','French','Yes')"); 204 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FY','Frisian','No')"); 205 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GA','Irish','No')"); 206 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GD','Gaelic / Scots Gaelic','No')"); 207 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GL','Galician','No')"); 208 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GN','Guarani','No')"); 209 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GU','Gujarati','No')"); 210 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HA','Hausa','No')"); 211 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HI','Hindi','No')"); 212 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HR','Croatian','No')"); 213 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HU','Hungarian','No')"); 214 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HY','Armenian','No')"); 215 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IA','Interlingua','No')"); 216 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IE','Interlingue','No')"); 217 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IK','Inupiak','No')"); 218 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IN','Indonesian','No')"); 219 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IS','Icelandic','No')"); 220 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IT','Italian','Yes')"); 221 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IW','Hebrew','No')"); 222 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JA','Japanese','No')"); 223 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JI','Yiddish','No')"); 224 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JW','Javanese','No')"); 225 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KA','Georgian','No')"); 226 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KK','Kazakh','No')"); 227 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KL','Greenlandic','No')"); 228 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KM','Cambodian','No')"); 229 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KN','Kannada','No')"); 230 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KO','Korean','Yes')"); 231 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KS','Kashmiri','No')"); 232 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KU','Kurdish','No')"); 233 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KY','Kirghiz','No')"); 234 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LA','Latin','No')"); 235 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LN','Lingala','No')"); 236 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LO','Laothian','No')"); 237 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LT','Lithuanian','No')"); 238 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LV','Latvian / Lettish','No')"); 239 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MG','Malagasy','No')"); 240 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MI','Maori','No')"); 241 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MK','Macedonian','No')"); 242 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ML','Malayalam','No')"); 243 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MN','Mongolian','No')"); 244 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MO','Moldavian','No')"); 245 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MR','Marathi','No')"); 246 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MS','Malay','No')"); 247 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MT','Maltese','No')"); 248 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MY','Burmese','No')"); 249 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NA','Nauru','No')"); 250 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NE','Nepali','No')"); 251 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NL','Dutch','Yes')"); 252 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NO','Norwegian','Yes')"); 253 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OC','Occitan','No')"); 254 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OM','Oromo / Afan','No')"); 255 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OR','Oriya','No')"); 256 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PA','Punjabi','No')"); 257 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PL','Polish','No')"); 258 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PS','Pashto / Pushto','No')"); 259 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PT','Portuguese','Yes')"); 260 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('QU','Quechua','No')"); 261 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RM','Rhaeto-Romance','No')"); 262 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RN','Kirundi','No')"); 263 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RO','Romanian','No')"); 264 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RU','Russian','No')"); 265 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RW','Kinyarwanda','No')"); 266 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SA','Sanskrit','No')"); 267 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SD','Sindhi','No')"); 268 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SG','Sangro','No')"); 269 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SH','Serbo-Croatian','No')"); 270 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SI','Singhalese','No')"); 271 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SK','Slovak','No')"); 272 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SL','Slovenian','No')"); 273 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SM','Samoan','No')"); 274 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SN','Shona','No')"); 275 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SO','Somali','No')"); 276 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SQ','Albanian','No')"); 277 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SR','Serbian','No')"); 278 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SS','Siswati','No')"); 279 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ST','Sesotho','No')"); 280 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SU','Sudanese','No')"); 281 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SV','Swedish','Yes')"); 282 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SW','Swahili','No')"); 283 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TA','Tamil','No')"); 284 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TE','Tegulu','No')"); 285 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TG','Tajik','No')"); 286 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TH','Thai','No')"); 287 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TI','Tigrinya','No')"); 288 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TK','Turkmen','No')"); 289 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TL','Tagalog','No')"); 290 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TN','Setswana','No')"); 291 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TO','Tonga','No')"); 292 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TR','Turkish','No')"); 293 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TS','Tsonga','No')"); 294 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TT','Tatar','No')"); 295 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TW','Twi','No')"); 296 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UK','Ukrainian','No')"); 297 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UR','Urdu','No')"); 298 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UZ','Uzbek','No')"); 299 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('VI','Vietnamese','No')"); 300 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('VO','Volapuk','No')"); 301 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('WO','Wolof','No')"); 302 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('XH','Xhosa','No')"); 303 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('YO','Yoruba','No')"); 304 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ZH','Chinese','No')"); 305 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ZU','Zulu','No')"); 306 307 $setup_info['phpgwapi']['currentver'] = '0.9.3pre8'; 308 return $setup_info['phpgwapi']['currentver']; 309 //return True; 310 } 311 312 $test[] = '0.9.3pre8'; 313 function phpgwapi_upgrade0_9_3pre8() 314 { 315 global $setup_info, $phpgw_setup; 316 $setup_info['phpgwapi']['currentver'] = '0.9.3pre9'; 317 return $setup_info['phpgwapi']['currentver']; 318 //return True; 319 } 320 $test[] = '0.9.3pre9'; 321 function phpgwapi_upgrade0_9_3pre9() 322 { 323 global $setup_info, $phpgw_setup; 324 $setup_info['phpgwapi']['currentver'] = '0.9.3pre10'; 325 return $setup_info['phpgwapi']['currentver']; 326 //return True; 327 } 328 $test[] = '0.9.3pre10'; 329 function phpgwapi_upgrade0_9_3pre10() 330 { 331 global $setup_info, $phpgw_setup; 332 $setup_info['phpgwapi']['currentver'] = '0.9.3'; 333 return $setup_info['phpgwapi']['currentver']; 334 //return True; 335 } 336 $test[] = '0.9.3'; 337 function phpgwapi_upgrade0_9_3() 338 { 339 global $setup_info, $phpgw_setup; 340 $setup_info['phpgwapi']['currentver'] = '0.9.4pre1'; 341 return $setup_info['phpgwapi']['currentver']; 342 //return True; 343 } 344 $test[] = '0.9.4pre1'; 345 function phpgwapi_upgrade0_9_4pre1() 346 { 347 global $setup_info, $phpgw_setup; 348 $setup_info['phpgwapi']['currentver'] = '0.9.4pre2'; 349 return $setup_info['phpgwapi']['currentver']; 350 //return True; 351 } 352 $test[] = '0.9.4pre2'; 353 function phpgwapi_upgrade0_9_4pre2() 354 { 355 global $setup_info, $phpgw_setup; 356 $setup_info['phpgwapi']['currentver'] = '0.9.4pre3'; 357 return $setup_info['phpgwapi']['currentver']; 358 //return True; 359 } 360 $test[] = '0.9.4pre3'; 361 function phpgwapi_upgrade0_9_4pre3() 362 { 363 global $setup_info, $phpgw_setup; 364 $setup_info['phpgwapi']['currentver'] = '0.9.4pre4'; 365 return $setup_info['phpgwapi']['currentver']; 366 //return True; 367 } 368 369 $test[] = '0.9.4pre4'; 370 function phpgwapi_upgrade0_9_4pre4() 371 { 372 global $setup_info, $phpgw_setup; 373 374 $phpgw_setup->oProc->AlterColumn('sessions', 'session_lid', array('type' => 'varchar', 'precision' => 255)); 375 376 $setup_info['phpgwapi']['currentver'] = '0.9.4pre5'; 377 return $setup_info['phpgwapi']['currentver']; 378 //return True; 379 } 380 381 $test[] = '0.9.4pre5'; 382 function phpgwapi_upgrade0_9_4pre5() 383 { 384 global $setup_info, $phpgw_setup; 385 $setup_info['phpgwapi']['currentver'] = '0.9.4'; 386 return $setup_info['phpgwapi']['currentver']; 387 //return True; 388 } 389 390 $test[] = '0.9.4'; 391 function phpgwapi_upgrade0_9_4() 392 { 393 global $setup_info, $phpgw_setup; 394 395 $phpgw_setup->oProc->query('delete from languages'); 396 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('aa','Afar','No')"); 397 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ab','Abkhazian','No')"); 398 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('af','Afrikaans','No')"); 399 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('am','Amharic','No')"); 400 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ar','Arabic','No')"); 401 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('as','Assamese','No')"); 402 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ay','Aymara','No')"); 403 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('az','Azerbaijani','No')"); 404 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ba','Bashkir','No')"); 405 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('be','Byelorussian','No')"); 406 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bg','Bulgarian','No')"); 407 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bh','Bihari','No')"); 408 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bi','Bislama','No')"); 409 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bn','Bengali / Bangla','No')"); 410 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bo','Tibetan','No')"); 411 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('br','Breton','No')"); 412 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ca','Catalan','No')"); 413 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('co','Corsican','No')"); 414 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('cs','Czech','No')"); 415 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('cy','Welsh','No')"); 416 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('da','Danish','Yes')"); 417 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('de','German','Yes')"); 418 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('dz','Bhutani','No')"); 419 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('el','Greek','No')"); 420 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('en','English / US','Yes')"); 421 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('eo','Esperanto','No')"); 422 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('es','Spanish','Yes')"); 423 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('et','Estonian','No')"); 424 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('eu','Basque','No')"); 425 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fa','Persian','No')"); 426 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fi','Finnish','No')"); 427 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fj','Fiji','No')"); 428 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fo','Faeroese','No')"); 429 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fr','French','Yes')"); 430 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fy','Frisian','No')"); 431 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ga','Irish','No')"); 432 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gd','Gaelic / Scots Gaelic','No')"); 433 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gl','Galician','No')"); 434 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gn','Guarani','No')"); 435 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gu','Gujarati','No')"); 436 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ha','Hausa','No')"); 437 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hi','Hindi','No')"); 438 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hr','Croatian','No')"); 439 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hu','Hungarian','No')"); 440 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hy','Armenian','No')"); 441 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ia','Interlingua','No')"); 442 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ie','Interlingue','No')"); 443 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ik','Inupiak','No')"); 444 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('in','Indonesian','No')"); 445 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('is','Icelandic','No')"); 446 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('it','Italian','Yes')"); 447 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('iw','Hebrew','No')"); 448 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ja','Japanese','No')"); 449 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ji','Yiddish','No')"); 450 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('jw','Javanese','No')"); 451 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ka','Georgian','No')"); 452 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kk','Kazakh','No')"); 453 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kl','Greenlandic','No')"); 454 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('km','Cambodian','No')"); 455 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kn','Kannada','No')"); 456 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ko','Korean','Yes')"); 457 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ks','Kashmiri','No')"); 458 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ku','Kurdish','No')"); 459 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ky','Kirghiz','No')"); 460 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('la','Latin','No')"); 461 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ln','Lingala','No')"); 462 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lo','Laothian','No')"); 463 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lt','Lithuanian','No')"); 464 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lv','Latvian / Lettish','No')"); 465 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mg','Malagasy','No')"); 466 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mi','Maori','No')"); 467 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mk','Macedonian','No')"); 468 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ml','Malayalam','No')"); 469 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mn','Mongolian','No')"); 470 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mo','Moldavian','No')"); 471 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mr','Marathi','No')"); 472 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ms','Malay','No')"); 473 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mt','Maltese','No')"); 474 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('my','Burmese','No')"); 475 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('na','Nauru','No')"); 476 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ne','Nepali','No')"); 477 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('nl','Dutch','Yes')"); 478 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('no','Norwegian','Yes')"); 479 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('oc','Occitan','No')"); 480 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('om','Oromo / Afan','No')"); 481 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('or','Oriya','No')"); 482 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pa','Punjabi','No')"); 483 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pl','Polish','No')"); 484 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ps','Pashto / Pushto','No')"); 485 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pt','Portuguese','Yes')"); 486 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('qu','Quechua','No')"); 487 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rm','Rhaeto-Romance','No')"); 488 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rn','Kirundi','No')"); 489 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ro','Romanian','No')"); 490 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ru','Russian','No')"); 491 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rw','Kinyarwanda','No')"); 492 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sa','Sanskrit','No')"); 493 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sd','Sindhi','No')"); 494 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sg','Sangro','No')"); 495 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sh','Serbo-Croatian','No')"); 496 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('si','Singhalese','No')"); 497 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sk','Slovak','No')"); 498 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sl','Slovenian','No')"); 499 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sm','Samoan','No')"); 500 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sn','Shona','No')"); 501 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('so','Somali','No')"); 502 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sq','Albanian','No')"); 503 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sr','Serbian','No')"); 504 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ss','Siswati','No')"); 505 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('st','Sesotho','No')"); 506 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('su','Sudanese','No')"); 507 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sv','Swedish','Yes')"); 508 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sw','Swahili','No')"); 509 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ta','Tamil','No')"); 510 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('te','Tegulu','No')"); 511 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tg','Tajik','No')"); 512 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('th','Thai','No')"); 513 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ti','Tigrinya','No')"); 514 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tk','Turkmen','No')"); 515 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tl','Tagalog','No')"); 516 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tn','Setswana','No')"); 517 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('to','Tonga','No')"); 518 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tr','Turkish','No')"); 519 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ts','Tsonga','No')"); 520 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tt','Tatar','No')"); 521 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tw','Twi','No')"); 522 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('uk','Ukrainian','No')"); 523 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ur','Urdu','No')"); 524 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('uz','Uzbek','No')"); 525 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('vi','Vietnamese','No')"); 526 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('vo','Volapuk','No')"); 527 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('wo','Wolof','No')"); 528 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('xh','Xhosa','No')"); 529 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('yo','Yoruba','No')"); 530 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('zh','Chinese','No')"); 531 @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('zu','Zulu','No')"); 532 533 $setup_info['phpgwapi']['currentver'] = '0.9.5pre1'; 534 return $setup_info['phpgwapi']['currentver']; 535 //return True; 536 } 537 538 $test[] = '0.9.5pre1'; 539 function phpgwapi_upgrade0_9_5pre1() 540 { 541 global $phpgw_info, $phpgw_setup; 542 543 $phpgw_setup->oProc->DropTable('sessions'); 544 $phpgw_setup->oProc->CreateTable('phpgw_sessions', array( 545 'fd' => array( 546 'session_id' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), 547 'session_lid' => array('type' => 'varchar', 'precision' => 255), 548 'session_pwd' => array('type' => 'varchar', 'precision' => 255), 549 'session_ip' => array('type' => 'varchar', 'precision' => 255), 550 'session_logintime' => array('type' => 'int', 'precision' => 4), 551 'session_dla' => array('type' => 'int', 'precision' => 4) 552 ), 553 'pk' => array(), 554 'ix' => array(), 555 'fk' => array(), 556 'uc' => array('session_id') 557 )); 558 559 $phpgw_setup->oProc->CreateTable('phpgw_acl', array( 560 'fd' => array( 561 'acl_appname' => array('type' => 'varchar', 'precision' => 50), 562 'acl_location' => array('type' => 'varchar', 'precision' => 255), 563 'acl_account' => array('type' => 'int', 'precision' => 4), 564 'acl_account_type' => array('type' => 'char', 'precision' => 1), 565 'acl_rights' => array('type' => 'int', 'precision' => 4) 566 ), 567 'pk' => array(), 568 'ix' => array(), 569 'fk' => array(), 570 'uc' => array() 571 )); 572 573 $phpgw_setup->oProc->DropTable('app_sessions'); 574 $phpgw_setup->oProc->CreateTable('phpgw_app_sessions', array( 575 'fd' => array( 576 'sessionid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), 577 'loginid' => array('type' => 'varchar', 'precision' => 20), 578 'app' => array('type' => 'varchar', 'precision' => 20), 579 'content' => array('type' => 'text') 580 ), 581 'pk' => array(), 582 'ix' => array(), 583 'fk' => array(), 584 'uc' => array() 585 )); 586 587 $phpgw_setup->oProc->DropTable('access_log'); 588 $phpgw_setup->oProc->CreateTable('phpgw_access_log', array( 589 'fd' => array( 590 'sessionid' => array('type' => 'varchar', 'precision' => 255), 591 'loginid' => array('type' => 'varchar', 'precision' => 30), 592 'ip' => array('type' => 'varchar', 'precision' => 30), 593 'li' => array('type' => 'int', 'precision' => 4), 594 'lo' => array('type' => 'varchar', 'precision' => 255) 595 ), 596 'pk' => array(), 597 'ix' => array(), 598 'fk' => array(), 599 'uc' => array() 600 )); 601 602 $setup_info['phpgwapi']['currentver'] = '0.9.5pre2'; 603 return $setup_info['phpgwapi']['currentver']; 604 //return True; 605 } 606 607 $test[] = '0.9.5pre2'; 608 function phpgwapi_upgrade0_9_5pre2() 609 { 610 global $setup_info; 611 $setup_info['phpgwapi']['currentver'] = '0.9.5'; 612 return $setup_info['phpgwapi']['currentver']; 613 //return True; 614 } 615 616 $test[] = '0.9.5'; 617 function phpgwapi_upgrade0_9_5() 618 { 619 global $setup_info; 620 $setup_info['phpgwapi']['currentver'] = '0.9.6'; 621 return $setup_info['phpgwapi']['currentver']; 622 //return True; 623 } 624 625 $test[] = '0.9.6'; 626 function phpgwapi_upgrade0_9_6() 627 { 628 global $setup_info; 629 $setup_info['phpgwapi']['currentver'] = '0.9.7pre1'; 630 return $setup_info['phpgwapi']['currentver']; 631 //return True; 632 } 633 634 $test[] = '0.9.7pre1'; 635 function phpgwapi_upgrade0_9_7pre1() 636 { 637 global $setup_info; 638 $setup_info['phpgwapi']['currentver'] = '0.9.7pre2'; 639 return $setup_info['phpgwapi']['currentver']; 640 //return True; 641 } 642 $test[] = '0.9.7pre2'; 643 function phpgwapi_upgrade0_9_7pre2() 644 { 645 global $setup_info; 646 $setup_info['phpgwapi']['currentver'] = '0.9.7pre3'; 647 return $setup_info['phpgwapi']['currentver']; 648 //return True; 649 } 650 651 $test[] = '0.9.7pre3'; 652 function phpgwapi_upgrade0_9_7pre3() 653 { 654 global $setup_info; 655 $setup_info['phpgwapi']['currentver'] = '0.9.7'; 656 return $setup_info['phpgwapi']['currentver']; 657 //return True; 658 } 659 660 $test[] = '0.9.7'; 661 function phpgwapi_upgrade0_9_7() 662 { 663 global $setup_info; 664 $setup_info['phpgwapi']['currentver'] = '0.9.8pre1'; 665 return $setup_info['phpgwapi']['currentver']; 666 //return True; 667 } 668 669 $test[] = '0.9.8pre1'; 670 function phpgwapi_upgrade0_9_8pre1() 671 { 672 global $setup_info, $phpgw_setup; 673 674 $phpgw_setup->oProc->query("SELECT * FROM preferences ORDER BY preference_owner"); 675 $t = array(); 676 while ($phpgw_setup->oProc->next_record()) 677 { 678 $t[$phpgw_setup->oProc->f('preference_owner')][$phpgw_setup->oProc->f('preference_appname')][$phpgw_setup->oProc->f('preference_var')] = $phpgw_setup->oProc->f('preference_value'); 679 } 680 681 $phpgw_setup->oProc->DropTable('preferences'); 682 $phpgw_setup->oProc->CreateTable('preferences', array( 683 'fd' => array( 684 'preference_owner' => array('type' => 'int', 'precision' => 4, 'nullable' => false), 685 'preference_value' => array('type' => 'text') 686 ), 687 'pk' => array(), 688 'ix' => array(), 689 'fk' => array(), 690 'uc' => array() 691 )); 692 693 while ($tt = each($t)) 694 { 695 $phpgw_setup->oProc->query("insert into preferences values ('$tt[0]','" . serialize($tt[1]) . "')"); 696 } 697 698 $setup_info['phpgwapi']['currentver'] = '0.9.8pre2'; 699 return $setup_info['phpgwapi']['currentver']; 700 //return True; 701 } 702 703 $test[] = '0.9.8pre2'; 704 function phpgwapi_upgrade0_9_8pre2() 705 { 706 global $setup_info, $phpgw_setup; 707 $setup_info['phpgwapi']['currentver'] = '0.9.8pre3'; 708 return $setup_info['phpgwapi']['currentver']; 709 //return True; 710 } 711 712 $test[] = '0.9.8pre3'; 713 function phpgwapi_upgrade0_9_8pre3() 714 { 715 global $setup_info, $phpgw_setup; 716 717 $phpgw_setup->oProc->DropTable('phpgw_sessions'); 718 $phpgw_setup->oProc->CreateTable( 719 'phpgw_sessions', array( 720 'fd' => array( 721 'session_id' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), 722 'session_lid' => array('type' => 'varchar', 'precision' => 255), 723 'session_ip' => array('type' => 'varchar', 'precision' => 255), 724 'session_logintime' => array('type' => 'int', 'precision' => 4), 725 'session_dla' => array('type' => 'int', 'precision' => 4), 726 'session_info' => array('type' => 'text') 727 ), 728 'pk' => array(), 729 'ix' => array(), 730 'fk' => array(), 731 'uc' => array('session_id') 732 ) 733 ); 734 735 $setup_info['phpgwapi']['currentver'] = '0.9.8pre4'; 736 return $setup_info['phpgwapi']['currentver']; 737 //return True; 738 } 739 740 $test[] = '0.9.8pre4'; 741 function phpgwapi_upgrade0_9_8pre4() 742 { 743 global $setup_info, $phpgw_setup; 744 745 $phpgw_setup->oProc->CreateTable( 746 'phpgw_hooks', array( 747 'fd' => array( 748 'hook_id' => array('type' => 'auto', 'nullable' => false), 749 'hook_appname' => array('type' => 'varchar', 'precision' => 255), 750 'hook_location' => array('type' => 'varchar', 'precision' => 255), 751 'hook_filename' => array('type' => 'varchar', 'precision' => 255) 752 ), 753 'pk' => array("hook_id"), 754 'ix' => array(), 755 'fk' => array(), 756 'uc' => array() 757 ) 758 ); 759 760 $setup_info['phpgwapi']['currentver'] = '0.9.8pre5'; 761 return $setup_info['phpgwapi']['currentver']; 762 //return True; 763 } 764 765 $test[] = '0.9.8pre5'; 766 function phpgwapi_upgrade0_9_8pre5() 767 { 768 global $setup_info, $phpgw_setup; 769 770 // Since no applications are using it yet. I am gonna drop it and create a new one. 771 // This is becuase I never finished the classes 772 $phpgw_setup->oProc->DropTable('categories'); 773 774 $phpgw_setup->oProc->CreateTable( 775 'phpgw_categories', array( 776 'fd' => array( 777 'cat_id' => array('type' => 'auto', 'nullable' => false), 778 'cat_parent' => array('type' => 'int', 'precision' => 4, 'default' => 0, 'nullable' => false), 779 'cat_owner' => array('type' => 'int', 'precision' => 4, 'default' => 0, 'nullable' => false), 780 'cat_appname' => array('type' => 'varchar', 'precision' => 50, 'nullable' => false), 781 'cat_name' => array('type' => 'varchar', 'precision' => 150, 'nullable' => false), 782 'cat_description' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), 783 'cat_data' => array('type' => 'text') 784 ), 785 'pk' => array('cat_id'), 786 'ix' => array(), 787 'fk' => array(), 788 'uc' => array() 789 ) 790 ); 791 792 $setup_info['phpgwapi']['currentver'] = '0.9.9pre1'; 793 return $setup_info['phpgwapi']['currentver']; 794 //return True; 795 } 796 797 $test[] = '0.9.9pre1'; 798 function phpgwapi_upgrade0_9_9pre1() 799 { 800 global $setup_info; 801 $setup_info['phpgwapi']['currentver'] = '0.9.9'; 802 return $setup_info['phpgwapi']['currentver']; 803 //return True; 804 } 805 ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Sun Feb 25 17:20:01 2007 | par Balluche grâce à PHPXref 0.7 |