[2] | 1 | <?php |
---|
| 2 | /**************************************************************************\ |
---|
| 3 | * phpGroupWare - Setup * |
---|
| 4 | * http://www.phpgroupware.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 | |
---|
| 13 | $test[] = '0.9.9'; |
---|
| 14 | function phpgwapi_upgrade0_9_9() |
---|
| 15 | { |
---|
| 16 | global $setup_info, $phpgw_setup; |
---|
| 17 | |
---|
| 18 | $db2 = $phpgw_setup->db; |
---|
| 19 | //convert user settings |
---|
| 20 | $phpgw_setup->oProc->query("select account_id, account_permissions from accounts",__LINE__,__FILE__); |
---|
| 21 | if($phpgw_setup->oProc->num_rows()) |
---|
| 22 | { |
---|
| 23 | while($phpgw_setup->oProc->next_record()) |
---|
| 24 | { |
---|
| 25 | $apps_perms = explode(":",$phpgw_setup->oProc->f('account_permissions')); |
---|
| 26 | for($i=1;$i<count($apps_perms)-1;$i++) |
---|
| 27 | { |
---|
| 28 | if ($apps_perms[$i] != "") |
---|
| 29 | { |
---|
| 30 | $sql = "insert into phpgw_acl (acl_appname, acl_location, acl_account, acl_account_type, acl_rights)"; |
---|
| 31 | $sql .= " values('".$apps_perms[$i]."', 'run', ".$phpgw_setup->oProc->f("account_id").", 'u', 1)"; |
---|
| 32 | $db2->query($sql ,__LINE__,__FILE__); |
---|
| 33 | } |
---|
| 34 | } |
---|
| 35 | } |
---|
| 36 | } |
---|
| 37 | $phpgw_setup->oProc->query("update accounts set account_permissions = ''",__LINE__,__FILE__); |
---|
| 38 | //convert group settings |
---|
| 39 | $phpgw_setup->oProc->query("select group_id, group_apps from groups",__LINE__,__FILE__); |
---|
| 40 | if($phpgw_setup->oProc->num_rows()) |
---|
| 41 | { |
---|
| 42 | while($phpgw_setup->oProc->next_record()) |
---|
| 43 | { |
---|
| 44 | $apps_perms = explode(":",$phpgw_setup->oProc->f('group_apps')); |
---|
| 45 | for($i=1;$i<count($apps_perms)-1;$i++) |
---|
| 46 | { |
---|
| 47 | if ($apps_perms[$i] != '') |
---|
| 48 | { |
---|
| 49 | $sql = "insert into phpgw_acl (acl_appname, acl_location, acl_account, acl_account_type, acl_rights)"; |
---|
| 50 | $sql .= " values('".$apps_perms[$i]."', 'run', ".$phpgw_setup->oProc->f("group_id").", 'g', 1)"; |
---|
| 51 | $db2->query($sql ,__LINE__,__FILE__); |
---|
| 52 | } |
---|
| 53 | } |
---|
| 54 | } |
---|
| 55 | } |
---|
| 56 | $phpgw_setup->oProc->query("update groups set group_apps = ''",__LINE__,__FILE__); |
---|
| 57 | |
---|
| 58 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre1'; |
---|
| 59 | return $setup_info['phpgwapi']['currentver']; |
---|
| 60 | //return True; |
---|
| 61 | } |
---|
| 62 | |
---|
| 63 | $test[] = '0.9.10pre1'; |
---|
| 64 | function phpgwapi_upgrade0_9_10pre1() |
---|
| 65 | { |
---|
| 66 | global $setup_info, $phpgw_setup; |
---|
| 67 | |
---|
| 68 | $phpgw_setup->oProc->AddColumn('phpgw_categories','cat_access',array('type' => 'varchar', 'precision' => 25)); |
---|
| 69 | |
---|
| 70 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre2'; |
---|
| 71 | return $setup_info['phpgwapi']['currentver']; |
---|
| 72 | //return True; |
---|
| 73 | } |
---|
| 74 | |
---|
| 75 | $test[] = '0.9.10pre2'; |
---|
| 76 | function phpgwapi_upgrade0_9_10pre2() |
---|
| 77 | { |
---|
| 78 | global $setup_info, $phpgw_setup; |
---|
| 79 | |
---|
| 80 | $db2 = $phpgw_setup->oProc; |
---|
| 81 | |
---|
| 82 | $phpgw_setup->oProc->query("SELECT account_groups,account_id FROM accounts",__LINE__,__FILE__); |
---|
| 83 | if($phpgw_setup->oProc->num_rows()) |
---|
| 84 | { |
---|
| 85 | while($phpgw_setup->oProc->next_record()) |
---|
| 86 | { |
---|
| 87 | $gl = explode(',',$phpgw_setup->oProc->f('account_groups')); |
---|
| 88 | for ($i=1; $i<(count($gl)-1); $i++) |
---|
| 89 | { |
---|
| 90 | $ga = explode(':',$gl[$i]); |
---|
| 91 | $sql = "INSERT INTO phpgw_acl (acl_appname, acl_location, acl_account, acl_account_type, acl_rights)"; |
---|
| 92 | $sql .= " VALUES('phpgw_group', '".$ga[0]."', ".$phpgw_setup->oProc->f("account_id").", 'u', 1)"; |
---|
| 93 | $db2->query($sql ,__LINE__,__FILE__); |
---|
| 94 | } |
---|
| 95 | } |
---|
| 96 | } |
---|
| 97 | $phpgw_setup->oProc->query("UPDATE accounts SET account_groups= ''",__LINE__,__FILE__); |
---|
| 98 | |
---|
| 99 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre3'; |
---|
| 100 | return $setup_info['phpgwapi']['currentver']; |
---|
| 101 | //return True; |
---|
| 102 | } |
---|
| 103 | |
---|
| 104 | $test[] = '0.9.10pre3'; |
---|
| 105 | function phpgwapi_upgrade0_9_10pre3() |
---|
| 106 | { |
---|
| 107 | global $setup_info, $phpgw_setup; |
---|
| 108 | |
---|
| 109 | $phpgw_setup->oProc->RenameTable('accounts','phpgw_accounts'); |
---|
| 110 | |
---|
| 111 | $newtbldef = array( |
---|
| 112 | 'fd' => array( |
---|
| 113 | 'account_id' => array('type' => 'auto', 'nullable' => false), |
---|
| 114 | 'account_lid' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false), |
---|
| 115 | 'account_pwd' => array('type' => 'varchar', 'precision' => 32, 'nullable' => false), |
---|
| 116 | 'account_firstname' => array('type' => 'varchar', 'precision' => 50), |
---|
| 117 | 'account_lastname' => array('type' => 'varchar', 'precision' => 50), |
---|
| 118 | 'account_groups' => array('type' => 'varchar', 'precision' => 30), |
---|
| 119 | 'account_lastlogin' => array('type' => 'int', 'precision' => 4), |
---|
| 120 | 'account_lastloginfrom' => array('type' => 'varchar', 'precision' => 255), |
---|
| 121 | 'account_lastpwd_change' => array('type' => 'int', 'precision' => 4), |
---|
| 122 | 'account_status' => array('type' => 'char', 'precision' => 1, 'nullable' => false, 'default' => 'A') |
---|
| 123 | ), |
---|
| 124 | 'pk' => array('account_id'), |
---|
| 125 | 'fk' => array(), |
---|
| 126 | 'ix' => array(), |
---|
| 127 | 'uc' => array('account_lid') |
---|
| 128 | ); |
---|
| 129 | $phpgw_setup->oProc->DropColumn('phpgw_accounts',$newtbldef,'account_permissions'); |
---|
| 130 | |
---|
| 131 | $newtbldef = array( |
---|
| 132 | 'fd' => array( |
---|
| 133 | 'account_id' => array('type' => 'auto', 'nullable' => false), |
---|
| 134 | 'account_lid' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false), |
---|
| 135 | 'account_pwd' => array('type' => 'varchar', 'precision' => 32, 'nullable' => false), |
---|
| 136 | 'account_firstname' => array('type' => 'varchar', 'precision' => 50), |
---|
| 137 | 'account_lastname' => array('type' => 'varchar', 'precision' => 50), |
---|
| 138 | 'account_lastlogin' => array('type' => 'int', 'precision' => 4), |
---|
| 139 | 'account_lastloginfrom' => array('type' => 'varchar', 'precision' => 255), |
---|
| 140 | 'account_lastpwd_change' => array('type' => 'int', 'precision' => 4), |
---|
| 141 | 'account_status' => array('type' => 'char', 'precision' => 1, 'nullable' => false, 'default' => 'A') |
---|
| 142 | ), |
---|
| 143 | 'pk' => array('account_id'), |
---|
| 144 | 'fk' => array(), |
---|
| 145 | 'ix' => array(), |
---|
| 146 | 'uc' => array('account_lid') |
---|
| 147 | ); |
---|
| 148 | $phpgw_setup->oProc->DropColumn('phpgw_accounts',$newtbldef,'account_groups'); |
---|
| 149 | |
---|
| 150 | $phpgw_setup->oProc->AddColumn('phpgw_accounts','account_type', array('type' => 'char', 'precision' => 1)); |
---|
| 151 | $phpgw_setup->oProc->query("update phpgw_accounts set account_type='u'",__LINE__,__FILE__); |
---|
| 152 | |
---|
| 153 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre4'; |
---|
| 154 | return $setup_info['phpgwapi']['currentver']; |
---|
| 155 | //return True; |
---|
| 156 | } |
---|
| 157 | |
---|
| 158 | // TODO see next function |
---|
| 159 | /* |
---|
| 160 | $tables = Array('addressbook','calendar_entry','f_forums','todo'); |
---|
| 161 | $fields["addressbook"] = Array('ab_access','ab_id'); |
---|
| 162 | $fields["calendar_entry"] = Array('cal_group','cal_id'); |
---|
| 163 | $fields["f_forums"] = Array('groups','id'); |
---|
| 164 | $fields["phpgw_categories"] = Array('cat_access','cat_id'); |
---|
| 165 | $fields["todo"] = Array('todo_access','todo_id'); |
---|
| 166 | */ |
---|
| 167 | function change_groups($table,$field,$old_id,$new_id,$db2,$db3) |
---|
| 168 | { |
---|
| 169 | $sql = $field[0]; |
---|
| 170 | for($i=1;$i<count($field);$i++) |
---|
| 171 | { |
---|
| 172 | $sql .= ", ".$field[$i]; |
---|
| 173 | } |
---|
| 174 | $db2->query("SELECT $sql FROM $table WHERE $field[0] like '%,".$old_id.",%'",__LINE__,__FILE__); |
---|
| 175 | if($db2->num_rows()) |
---|
| 176 | { |
---|
| 177 | while($db2->next_record()) |
---|
| 178 | { |
---|
| 179 | $access = $db2->f($field[0]); |
---|
| 180 | $id = $db2->f($field[1]); |
---|
| 181 | $access = str_replace(','.$old_id.',' , ','.$new_id.',' , $access); |
---|
| 182 | $db3->query("UPDATE $table SET ".$field[0]."='".$access."' WHERE ".$field[1]."=".$id,__LINE__,__FILE__); |
---|
| 183 | } |
---|
| 184 | } |
---|
| 185 | } |
---|
| 186 | |
---|
| 187 | $test[] = '0.9.10pre4'; |
---|
| 188 | function phpgwapi_upgrade0_9_10pre4() |
---|
| 189 | { |
---|
| 190 | global $setup_info, $phpgw_setup; |
---|
| 191 | |
---|
| 192 | $db2 = $phpgw_setup->oProc; |
---|
| 193 | $db3 = $phpgw_setup->oProc; |
---|
| 194 | |
---|
| 195 | $phpgw_setup->oProc->query("SELECT MAX(group_id) FROM groups",__LINE__,__FILE__); |
---|
| 196 | $phpgw_setup->oProc->next_record(); |
---|
| 197 | $max_group_id = $phpgw_setup->oProc->f(0); |
---|
| 198 | |
---|
| 199 | // This is for use by former CORE apps to use in this version number's upgrade locally |
---|
| 200 | $phpgw_setup->oProc->CreateTable( |
---|
| 201 | 'phpgw_temp_groupmap', array( |
---|
| 202 | 'fd' => array( |
---|
| 203 | 'oldid' => array('type' => 'int', 'precision' => 4, 'nullable' => False), |
---|
| 204 | 'oldlid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => True), |
---|
| 205 | 'newid' => array('type' => 'int', 'precision' => 4, 'nullable' => True), |
---|
| 206 | 'newlid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => True) |
---|
| 207 | ), |
---|
| 208 | 'pk' => array('oldid'), |
---|
| 209 | 'fk' => array(), |
---|
| 210 | 'ix' => array(), |
---|
| 211 | 'uc' => array() |
---|
| 212 | ) |
---|
| 213 | ); |
---|
| 214 | |
---|
| 215 | $phpgw_setup->oProc->query("SELECT group_id, group_name FROM groups",__LINE__,__FILE__); |
---|
| 216 | while($phpgw_setup->oProc->next_record()) |
---|
| 217 | { |
---|
| 218 | $old_group_id = $phpgw_setup->oProc->f('group_id'); |
---|
| 219 | $old_group_name = $phpgw_setup->oProc->f('group_name'); |
---|
| 220 | $group_name = $phpgw_setup->oProc->f('group_name'); |
---|
| 221 | while(1) |
---|
| 222 | { |
---|
| 223 | $new_group_id = mt_rand ($max_group_id, 60000); |
---|
| 224 | $db2->query("SELECT account_id FROM phpgw_accounts WHERE account_id=$new_group_id",__LINE__,__FILE__); |
---|
| 225 | if(!$db2->num_rows()) { break; } |
---|
| 226 | } |
---|
| 227 | $db2->query("SELECT account_lid FROM phpgw_accounts WHERE account_lid='$group_name'",__LINE__,__FILE__); |
---|
| 228 | if($db2->num_rows()) |
---|
| 229 | { |
---|
| 230 | $group_name .= '_group'; |
---|
| 231 | } |
---|
| 232 | $db2->query("INSERT INTO phpgw_accounts(account_id, account_lid, account_pwd, " |
---|
| 233 | ."account_firstname, account_lastname, account_lastlogin, " |
---|
| 234 | ."account_lastloginfrom, account_lastpwd_change, " |
---|
| 235 | ."account_status, account_type) " |
---|
| 236 | ."VALUES ($new_group_id,'$group_name','x','','',$old_group_id,NULL,NULL,'A','g')"); |
---|
| 237 | |
---|
| 238 | // insert oldid/newid into temp table (for use by other apps in this version upgrade |
---|
| 239 | $db2->query("INSERT INTO phpgw_temp_groupmap (oldid,oldlid,newid,newlid) VALUES ($old_group_id,'$old_group_name',$new_group_id,'$group_name')",__LINE__,__FILE__); |
---|
| 240 | |
---|
| 241 | $db2->query("UPDATE phpgw_acl SET acl_location='$new_group_id' " |
---|
| 242 | ."WHERE acl_appname='phpgw_group' AND acl_account_type='u' " |
---|
| 243 | ."AND acl_location='$old_group_id'"); |
---|
| 244 | $db2->query("UPDATE phpgw_acl SET acl_account=$new_group_id " |
---|
| 245 | ."WHERE acl_location='run' AND acl_account_type='g' " |
---|
| 246 | ."AND acl_account=$old_group_id"); |
---|
| 247 | |
---|
| 248 | $db2->query("SELECT cat_access,cat_id FROM phpgw_categories WHERE cat_access LIKE '%,".$old_group_id.",%'",__LINE__,__FILE__); |
---|
| 249 | if($db2->num_rows()) |
---|
| 250 | { |
---|
| 251 | while($db2->next_record()) |
---|
| 252 | { |
---|
| 253 | $access = $db2->f('cat_access'); |
---|
| 254 | $id = $db2->f('cat_id'); |
---|
| 255 | $access = str_replace(','.$old_group_id.',' , ','.$new_group_id.',' , $access); |
---|
| 256 | $db3->query("UPDATE phpgw_categories SET cat_access='".$access."' WHERE cat_id=".$id,__LINE__,__FILE__); |
---|
| 257 | } |
---|
| 258 | } |
---|
| 259 | } |
---|
| 260 | |
---|
| 261 | $phpgw_setup->oProc->DropTable('groups'); |
---|
| 262 | |
---|
| 263 | /* Moved back from addressbook */ |
---|
| 264 | $phpgw_setup->oProc->query('SELECT oldid,newid FROM phpgw_temp_groupmap',__LINE__,__FILE__); |
---|
| 265 | if($phpgw_setup->oProc->num_rows()) |
---|
| 266 | { |
---|
| 267 | while($phpgw_setup->oProc->next_record()) |
---|
| 268 | { |
---|
| 269 | $old_group_id = $phpgw_setup->oProc->f(0); |
---|
| 270 | $new_group_id = $phpgw_setup->oProc->f(1); |
---|
| 271 | $db2->query("SELECT ab_access,ab_id FROM addressbook WHERE ab_access LIKE '%,".$old_group_id.",%'",__LINE__,__FILE__); |
---|
| 272 | if($db2->num_rows()) |
---|
| 273 | { |
---|
| 274 | while($db2->next_record()) |
---|
| 275 | { |
---|
| 276 | $access = $db2->f('cat_access'); |
---|
| 277 | $id = $db2->f('cat_id'); |
---|
| 278 | $access = str_replace(','.$old_group_id.',' , ','.$new_group_id.',' , $access); |
---|
| 279 | $db3->query("UPDATE phpgw_categories SET cat_access='".$access."' WHERE cat_id=".$id,__LINE__,__FILE__); |
---|
| 280 | } |
---|
| 281 | } |
---|
| 282 | } |
---|
| 283 | } |
---|
| 284 | |
---|
| 285 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre5'; |
---|
| 286 | return $setup_info['phpgwapi']['currentver']; |
---|
| 287 | //return True; |
---|
| 288 | } |
---|
| 289 | |
---|
| 290 | $test[] = '0.9.10pre5'; |
---|
| 291 | function phpgwapi_upgrade0_9_10pre5() |
---|
| 292 | { |
---|
| 293 | global $setup_info, $phpgw_setup; |
---|
| 294 | |
---|
| 295 | /* This is only temp data, so we can kill it. */ |
---|
| 296 | $phpgw_setup->oProc->DropTable('phpgw_app_sessions'); |
---|
| 297 | $phpgw_setup->oProc->CreateTable( |
---|
| 298 | 'phpgw_app_sessions', array( |
---|
| 299 | 'fd' => array( |
---|
| 300 | 'sessionid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => False), |
---|
| 301 | 'loginid' => array('type' => 'varchar', 'precision' => 20), |
---|
| 302 | 'location' => array('type' => 'varchar', 'precision' => 255), |
---|
| 303 | 'app' => array('type' => 'varchar', 'precision' => 20), |
---|
| 304 | 'content' => array('type' => 'text') |
---|
| 305 | ), |
---|
| 306 | 'pk' => array(), |
---|
| 307 | 'fk' => array(), |
---|
| 308 | 'ix' => array(), |
---|
| 309 | 'uc' => array() |
---|
| 310 | ) |
---|
| 311 | ); |
---|
| 312 | |
---|
| 313 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre6'; |
---|
| 314 | return $setup_info['phpgwapi']['currentver']; |
---|
| 315 | //return True; |
---|
| 316 | } |
---|
| 317 | |
---|
| 318 | $test[] = '0.9.10pre6'; |
---|
| 319 | function phpgwapi_upgrade0_9_10pre6() |
---|
| 320 | { |
---|
| 321 | global $setup_info, $phpgw_setup; |
---|
| 322 | |
---|
| 323 | $phpgw_setup->oProc->RenameTable('config','phpgw_config'); |
---|
| 324 | |
---|
| 325 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre7'; |
---|
| 326 | return $setup_info['phpgwapi']['currentver']; |
---|
| 327 | //return True; |
---|
| 328 | } |
---|
| 329 | |
---|
| 330 | $test[] = '0.9.10pre7'; |
---|
| 331 | function phpgwapi_upgrade0_9_10pre7() |
---|
| 332 | { |
---|
| 333 | global $setup_info, $phpgw_setup; |
---|
| 334 | |
---|
| 335 | $phpgw_setup->oProc->RenameTable('applications','phpgw_applications'); |
---|
| 336 | |
---|
| 337 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre8'; |
---|
| 338 | return $setup_info['phpgwapi']['currentver']; |
---|
| 339 | //return True; |
---|
| 340 | } |
---|
| 341 | |
---|
| 342 | $test[] = '0.9.10pre8'; |
---|
| 343 | function phpgwapi_upgrade0_9_10pre8() |
---|
| 344 | { |
---|
| 345 | global $setup_info, $phpgw_setup; |
---|
| 346 | |
---|
| 347 | $phpgw_setup->oProc->RenameColumn('phpgw_sessions', 'session_info', 'session_action'); |
---|
| 348 | $phpgw_setup->oProc->AlterColumn('phpgw_sessions', 'session_action', array('type' => 'varchar', 'precision' => '255')); |
---|
| 349 | |
---|
| 350 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre9'; |
---|
| 351 | return $setup_info['phpgwapi']['currentver']; |
---|
| 352 | //return True; |
---|
| 353 | } |
---|
| 354 | |
---|
| 355 | $test[] = '0.9.10pre9'; |
---|
| 356 | function phpgwapi_upgrade0_9_10pre9() |
---|
| 357 | { |
---|
| 358 | global $setup_info, $phpgw_setup; |
---|
| 359 | |
---|
| 360 | $phpgw_setup->oProc->RenameTable('preferences','phpgw_preferences'); |
---|
| 361 | |
---|
| 362 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre10'; |
---|
| 363 | return $setup_info['phpgwapi']['currentver']; |
---|
| 364 | //return True; |
---|
| 365 | } |
---|
| 366 | |
---|
| 367 | $test[] = '0.9.10pre10'; |
---|
| 368 | function phpgwapi_upgrade0_9_10pre10() |
---|
| 369 | { |
---|
| 370 | global $setup_info, $phpgw_setup; |
---|
| 371 | |
---|
| 372 | $newtbldef = array( |
---|
| 373 | "fd" => array( |
---|
| 374 | 'acl_appname' => array('type' => 'varchar', 'precision' => 50), |
---|
| 375 | 'acl_location' => array('type' => 'varchar', 'precision' => 255), |
---|
| 376 | 'acl_account' => array('type' => 'int', 'precision' => 4), |
---|
| 377 | 'acl_rights' => array('type' => 'int', 'precision' => 4) |
---|
| 378 | ), |
---|
| 379 | 'pk' => array(), |
---|
| 380 | 'ix' => array(), |
---|
| 381 | 'fk' => array(), |
---|
| 382 | 'uc' => array() |
---|
| 383 | ); |
---|
| 384 | |
---|
| 385 | $phpgw_setup->oProc->DropColumn('phpgw_acl',$newtbldef,'acl_account_type'); |
---|
| 386 | |
---|
| 387 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre11'; |
---|
| 388 | return $setup_info['phpgwapi']['currentver']; |
---|
| 389 | //return True; |
---|
| 390 | } |
---|
| 391 | |
---|
| 392 | $test[] = '0.9.10pre11'; |
---|
| 393 | function phpgwapi_upgrade0_9_10pre11() |
---|
| 394 | { |
---|
| 395 | global $setup_info; |
---|
| 396 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre12'; |
---|
| 397 | return $setup_info['phpgwapi']['currentver']; |
---|
| 398 | //return True; |
---|
| 399 | } |
---|
| 400 | |
---|
| 401 | $test[] = '0.9.10pre12'; |
---|
| 402 | function phpgwapi_upgrade0_9_10pre12() |
---|
| 403 | { |
---|
| 404 | global $setup_info, $phpgw_setup; |
---|
| 405 | |
---|
| 406 | $db1 = $phpgw_setup->db; |
---|
| 407 | |
---|
| 408 | $phpgw_setup->oProc->CreateTable( |
---|
| 409 | 'phpgw_addressbook', array( |
---|
| 410 | 'fd' => array( |
---|
| 411 | 'id' => array('type' => 'auto', 'nullable' => False), |
---|
| 412 | 'lid' => array('type' => 'varchar', 'precision' => 32), |
---|
| 413 | 'tid' => array('type' => 'char', 'precision' => 1), |
---|
| 414 | 'owner' => array('type' => 'int', 'precision' => 4), |
---|
| 415 | 'fn' => array('type' => 'varchar', 'precision' => 64), |
---|
| 416 | 'sound' => array('type' => 'varchar', 'precision' => 64), |
---|
| 417 | 'org_name' => array('type' => 'varchar', 'precision' => 64), |
---|
| 418 | 'org_unit' => array('type' => 'varchar', 'precision' => 64), |
---|
| 419 | 'title' => array('type' => 'varchar', 'precision' => 64), |
---|
| 420 | 'n_family' => array('type' => 'varchar', 'precision' => 64), |
---|
| 421 | 'n_given' => array('type' => 'varchar', 'precision' => 64), |
---|
| 422 | 'n_middle' => array('type' => 'varchar', 'precision' => 64), |
---|
| 423 | 'n_prefix' => array('type' => 'varchar', 'precision' => 64), |
---|
| 424 | 'n_suffix' => array('type' => 'varchar', 'precision' => 64), |
---|
| 425 | 'label' => array('type' => 'text'), |
---|
| 426 | 'adr_poaddr' => array('type' => 'varchar', 'precision' => 64), |
---|
| 427 | 'adr_extaddr' => array('type' => 'varchar', 'precision' => 64), |
---|
| 428 | 'adr_street' => array('type' => 'varchar', 'precision' => 64), |
---|
| 429 | 'adr_locality' => array('type' => 'varchar', 'precision' => 32), |
---|
| 430 | 'adr_region' => array('type' => 'varchar', 'precision' => 32), |
---|
| 431 | 'adr_postalcode' => array('type' => 'varchar', 'precision' => 32), |
---|
| 432 | 'adr_countryname' => array('type' => 'varchar', 'precision' => 32), |
---|
| 433 | 'adr_work' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 434 | 'adr_home' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 435 | 'adr_parcel' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 436 | 'adr_postal' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 437 | 'tz' => array('type' => 'varchar', 'precision' => 8), |
---|
| 438 | 'geo' => array('type' => 'varchar', 'precision' => 32), |
---|
| 439 | 'a_tel' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 440 | 'a_tel_work' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 441 | 'a_tel_home' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 442 | 'a_tel_voice' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 443 | 'a_tel_msg' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 444 | 'a_tel_fax' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 445 | 'a_tel_prefer' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 446 | 'b_tel' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 447 | 'b_tel_work' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 448 | 'b_tel_home' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 449 | 'b_tel_voice' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 450 | 'b_tel_msg' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 451 | 'b_tel_fax' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 452 | 'b_tel_prefer' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 453 | 'c_tel' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 454 | 'c_tel_work' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 455 | 'c_tel_home' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 456 | 'c_tel_voice' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 457 | 'c_tel_msg' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 458 | 'c_tel_fax' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 459 | 'c_tel_prefer' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 460 | 'd_emailtype' => array('type' => 'varchar', 'precision' => 32), |
---|
| 461 | 'd_email' => array('type' => 'varchar', 'precision' => 64), |
---|
| 462 | 'd_email_work' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False), |
---|
| 463 | 'd_email_home' => array('type' => 'char', 'precision' => '1', 'default' => 'n', 'nullable' => False) |
---|
| 464 | ), |
---|
| 465 | 'pk' => array('id'), |
---|
| 466 | 'fk' => array(), |
---|
| 467 | 'ix' => array(), |
---|
| 468 | 'uc' => array('id') |
---|
| 469 | ) |
---|
| 470 | ); |
---|
| 471 | |
---|
| 472 | $phpgw_setup->oProc->CreateTable( |
---|
| 473 | 'phpgw_addressbook_extra', array( |
---|
| 474 | 'fd' => array( |
---|
| 475 | 'contact_id' => array('type' => 'int', 'precision' => 4), |
---|
| 476 | 'contact_owner' => array('type' => 'int', 'precision' => 4), |
---|
| 477 | 'contact_name' => array('type' => 'varchar', 'precision' => 255), |
---|
| 478 | 'contact_value' => array('type' => 'varchar', 'precision' => 255) |
---|
| 479 | ), |
---|
| 480 | 'pk' => array(), |
---|
| 481 | 'fk' => array(), |
---|
| 482 | 'ix' => array(), |
---|
| 483 | 'uc' => array() |
---|
| 484 | ) |
---|
| 485 | ); |
---|
| 486 | |
---|
| 487 | $phpgw_setup->oProc->query("SELECT * FROM addressbook"); |
---|
| 488 | /* echo '<br>numrows: ' . $phpgw_setup->oProc->num_rows; */ |
---|
| 489 | |
---|
| 490 | while ($phpgw_setup->oProc->next_record()) |
---|
| 491 | { |
---|
| 492 | $fields = $extra = array(); |
---|
| 493 | |
---|
| 494 | $fields['id'] = $phpgw_setup->oProc->f('ab_id'); |
---|
| 495 | $fields['owner'] = addslashes($phpgw_setup->oProc->f('ab_owner')); |
---|
| 496 | $fields['n_given'] = addslashes($phpgw_setup->oProc->f('ab_firstname')); |
---|
| 497 | $fields['n_family'] = addslashes($phpgw_setup->oProc->f('ab_lastname')); |
---|
| 498 | $fields['d_email'] = addslashes($phpgw_setup->oProc->f('ab_email')); |
---|
| 499 | $fields['b_tel'] = addslashes($phpgw_setup->oProc->f('ab_hphone')); |
---|
| 500 | $fields['a_tel'] = addslashes($phpgw_setup->oProc->f('ab_wphone')); |
---|
| 501 | $fields['c_tel'] = addslashes($phpgw_setup->oProc->f('ab_fax')); |
---|
| 502 | $fields['fn'] = addslashes($phpgw_setup->oProc->f('ab_firstname').' '.$phpgw_setup->oProc->f('ab_lastname')); |
---|
| 503 | $fields['a_tel_work'] = 'y'; |
---|
| 504 | $fields['b_tel_home'] = 'y'; |
---|
| 505 | $fields['c_tel_fax'] = 'y'; |
---|
| 506 | $fields['org_name'] = addslashes($phpgw_setup->oProc->f('ab_company')); |
---|
| 507 | $fields['title'] = addslashes($phpgw_setup->oProc->f('ab_title')); |
---|
| 508 | $fields['adr_street'] = addslashes($phpgw_setup->oProc->f('ab_street')); |
---|
| 509 | $fields['adr_locality'] = addslashes($phpgw_setup->oProc->f('ab_city')); |
---|
| 510 | $fields['adr_region'] = addslashes($phpgw_setup->oProc->f('ab_state')); |
---|
| 511 | $fields['adr_postalcode'] = addslashes($phpgw_setup->oProc->f('ab_zip')); |
---|
| 512 | |
---|
| 513 | $extra['pager'] = $phpgw_setup->oProc->f('ab_pager'); |
---|
| 514 | $extra['mphone'] = $phpgw_setup->oProc->f('ab_mphone'); |
---|
| 515 | $extra['ophone'] = $phpgw_setup->oProc->f('ab_ophone'); |
---|
| 516 | $extra['bday'] = $phpgw_setup->oProc->f('ab_bday'); |
---|
| 517 | $extra['notes'] = $phpgw_setup->oProc->f('ab_notes'); |
---|
| 518 | $extra['address2'] = $phpgw_setup->oProc->f('ab_address2'); |
---|
| 519 | $extra['url'] = $phpgw_setup->oProc->f('ab_url'); |
---|
| 520 | |
---|
| 521 | $sql = "INSERT INTO phpgw_addressbook (org_name,n_given,n_family,fn,d_email,title,a_tel,a_tel_work," |
---|
| 522 | . "b_tel,b_tel_home,c_tel,c_tel_fax,adr_street,adr_locality,adr_region,adr_postalcode,owner)" |
---|
| 523 | . " VALUES ('".$fields['org_name']."','".$fields['n_given']."','".$fields['n_family']."','" |
---|
| 524 | . $fields['fn']."','".$fields['d_email']."','".$fields['title']."','".$fields['a_tel']."','" |
---|
| 525 | . $fields['a_tel_work']."','".$fields['b_tel']."','".$fields['b_tel_home']."','" |
---|
| 526 | . $fields['c_tel']."','".$fields['c_tel_fax']."','".$fields['adr_street']."','" |
---|
| 527 | . $fields['adr_locality']."','".$fields['adr_region']."','".$fields['adr_postalcode']."','" |
---|
| 528 | . $fields['owner'] ."')"; |
---|
| 529 | |
---|
| 530 | $db1->query($sql); |
---|
| 531 | |
---|
| 532 | while (list($name,$value) = each($extra)) |
---|
| 533 | { |
---|
| 534 | $sql = "INSERT INTO phpgw_addressbook_extra VALUES ('".$fields['id']."','" . $fields['owner'] . "','" |
---|
| 535 | . addslashes($name) . "','" . addslashes($value) . "')"; |
---|
| 536 | $db1->query($sql); |
---|
| 537 | } |
---|
| 538 | } |
---|
| 539 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre13'; |
---|
| 540 | return $setup_info['phpgwapi']['currentver']; |
---|
| 541 | //return True; |
---|
| 542 | // Note we are still leaving the old addressbook table alone here... for third party apps if they need it |
---|
| 543 | } |
---|
| 544 | |
---|
| 545 | $test[] = '0.9.10pre13'; |
---|
| 546 | function phpgwapi_upgrade0_9_10pre13() |
---|
| 547 | { |
---|
| 548 | global $setup_info, $phpgw_setup; |
---|
| 549 | |
---|
| 550 | $db1 = $phpgw_setup->db; |
---|
| 551 | |
---|
| 552 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook', 'url', array('type' => 'varchar', 'precision' => 128)); |
---|
| 553 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook', 'bday', array('type' => 'varchar', 'precision' => 32)); |
---|
| 554 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook', 'note', array('type' => 'text')); |
---|
| 555 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook_extra', 'contact_value', array('type' => 'text')); |
---|
| 556 | |
---|
| 557 | $sql = "SELECT * FROM phpgw_addressbook_extra WHERE contact_name='url'"; |
---|
| 558 | $phpgw_setup->oProc->query($sql,__LINE__,__FILE__); |
---|
| 559 | |
---|
| 560 | while($phpgw_setup->oProc->next_record()) |
---|
| 561 | { |
---|
| 562 | $cid = $phpgw_setup->oProc->f('contact_id'); |
---|
| 563 | $cvalu = $phpgw_setup->oProc->f('contact_value'); |
---|
| 564 | if ($cid && $cvalu) |
---|
| 565 | { |
---|
| 566 | $update = "UPDATE phpgw_addressbook SET url='" . $cvalu . "' WHERE id=" . $cid; |
---|
| 567 | $db1->query($update); |
---|
| 568 | $delete = "DELETE FROM phpgw_addressbook_extra WHERE contact_id=" . $cid . " AND contact_name='url'"; |
---|
| 569 | $db1->query($delete); |
---|
| 570 | } |
---|
| 571 | } |
---|
| 572 | |
---|
| 573 | $sql = "SELECT * FROM phpgw_addressbook_extra WHERE contact_name='bday'"; |
---|
| 574 | $phpgw_setup->oProc->query($sql,__LINE__,__FILE__); |
---|
| 575 | |
---|
| 576 | while($phpgw_setup->oProc->next_record()) |
---|
| 577 | { |
---|
| 578 | $cid = $phpgw_setup->oProc->f('contact_id'); |
---|
| 579 | $cvalu = $phpgw_setup->oProc->f('contact_value'); |
---|
| 580 | if ($cid && $cvalu) |
---|
| 581 | { |
---|
| 582 | $update = "UPDATE phpgw_addressbook set bday='" . $cvalu . "' WHERE id=" . $cid; |
---|
| 583 | $db1->query($update); |
---|
| 584 | $delete = "DELETE FROM phpgw_addressbook_extra WHERE contact_id=" . $cid . " AND contact_name='bday'"; |
---|
| 585 | $db1->query($delete); |
---|
| 586 | } |
---|
| 587 | } |
---|
| 588 | |
---|
| 589 | $sql = "SELECT * FROM phpgw_addressbook_extra WHERE contact_name='notes'"; |
---|
| 590 | $phpgw_setup->oProc->query($sql,__LINE__,__FILE__); |
---|
| 591 | |
---|
| 592 | while($phpgw_setup->oProc->next_record()) |
---|
| 593 | { |
---|
| 594 | $cid = $phpgw_setup->oProc->f('contact_id'); |
---|
| 595 | $cvalu = $phpgw_setup->oProc->f('contact_value'); |
---|
| 596 | if ($cvalu) |
---|
| 597 | { |
---|
| 598 | $update = "UPDATE phpgw_addressbook set note='" . $cvalu . "' WHERE id=" . $cid; |
---|
| 599 | $db1->query($update); |
---|
| 600 | $delete = "DELETE FROM phpgw_addressbook_extra WHERE contact_id=" . $cid . " AND contact_name='notes'"; |
---|
| 601 | $db1->query($delete); |
---|
| 602 | } |
---|
| 603 | } |
---|
| 604 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre14'; |
---|
| 605 | return $setup_info['phpgwapi']['currentver']; |
---|
| 606 | //return True; |
---|
| 607 | } |
---|
| 608 | |
---|
| 609 | $test[] = '0.9.10pre14'; |
---|
| 610 | function phpgwapi_upgrade0_9_10pre14() |
---|
| 611 | { |
---|
| 612 | global $setup_info, $phpgw_setup; |
---|
| 613 | |
---|
| 614 | $phpgw_setup->oProc->AddColumn('phpgw_sessions','session_flags', array('type' => 'char', 'precision' => 2)); |
---|
| 615 | |
---|
| 616 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre15'; |
---|
| 617 | return $setup_info['phpgwapi']['currentver']; |
---|
| 618 | //return True; |
---|
| 619 | } |
---|
| 620 | |
---|
| 621 | $test[] = '0.9.10pre15'; |
---|
| 622 | function phpgwapi_upgrade0_9_10pre15() |
---|
| 623 | { |
---|
| 624 | global $setup_info, $phpgw_setup; |
---|
| 625 | |
---|
| 626 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'adr_work', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 627 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'adr_home', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 628 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'adr_parcel', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 629 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'adr_postal', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 630 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_work', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 631 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_home', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 632 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_voice', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 633 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_msg', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 634 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_fax', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 635 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'a_tel_prefer', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 636 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_work', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 637 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_home', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 638 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_voice', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 639 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_msg', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 640 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_fax', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 641 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'b_tel_prefer', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 642 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_work', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 643 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_home', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 644 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_voice', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 645 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_msg', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 646 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_fax', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 647 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'c_tel_prefer', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 648 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'd_email_work', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 649 | $phpgw_setup->oProc->AlterColumn('phpgw_addressbook', 'd_email_home', array('type' => 'char', 'precision' => 1, 'default' => 'n', 'nullable' => False)); |
---|
| 650 | |
---|
| 651 | $setup_info['addressbook']['currentver'] = '0.9.10pre16'; |
---|
| 652 | return $setup_info['addressbook']['currentver']; |
---|
| 653 | //return True; |
---|
| 654 | } |
---|
| 655 | |
---|
| 656 | $test[] = '0.9.10pre16'; |
---|
| 657 | function phpgwapi_upgrade0_9_10pre16() |
---|
| 658 | { |
---|
| 659 | global $setup_info, $phpgw_setup; |
---|
| 660 | |
---|
| 661 | $db1 = $phpgw_setup->db; |
---|
| 662 | |
---|
| 663 | $phpgw_setup->oProc->RenameTable('phpgw_addressbook', 'phpgw_addressbook_old'); |
---|
| 664 | $phpgw_setup->oProc->CreateTable( |
---|
| 665 | 'phpgw_addressbook', array( |
---|
| 666 | 'fd' => array( |
---|
| 667 | 'id' => array('type' => 'auto', 'nullable' => False), |
---|
| 668 | 'lid' => array('type' => 'varchar', 'precision' => 32), |
---|
| 669 | 'tid' => array('type' => 'char', 'precision' => 1), |
---|
| 670 | 'owner' => array('type' => 'int', 'precision' => 4), |
---|
| 671 | 'fn' => array('type' => 'varchar', 'precision' => 64), |
---|
| 672 | 'n_family' => array('type' => 'varchar', 'precision' => 64), |
---|
| 673 | 'n_given' => array('type' => 'varchar', 'precision' => 64), |
---|
| 674 | 'n_middle' => array('type' => 'varchar', 'precision' => 64), |
---|
| 675 | 'n_prefix' => array('type' => 'varchar', 'precision' => 64), |
---|
| 676 | 'n_suffix' => array('type' => 'varchar', 'precision' => 64), |
---|
| 677 | 'sound' => array('type' => 'varchar', 'precision' => 64), |
---|
| 678 | 'bday' => array('type' => 'varchar', 'precision' => 32), |
---|
| 679 | 'note' => array('type' => 'text'), |
---|
| 680 | 'tz' => array('type' => 'varchar', 'precision' => 8), |
---|
| 681 | 'geo' => array('type' => 'varchar', 'precision' => 32), |
---|
| 682 | 'url' => array('type' => 'varchar', 'precision' => 128), |
---|
| 683 | 'org_name' => array('type' => 'varchar', 'precision' => 64), |
---|
| 684 | 'org_unit' => array('type' => 'varchar', 'precision' => 64), |
---|
| 685 | 'title' => array('type' => 'varchar', 'precision' => 64), |
---|
| 686 | 'adr_one_street' => array('type' => 'varchar', 'precision' => 64), |
---|
| 687 | 'adr_one_locality' => array('type' => 'varchar', 'precision' => 32), |
---|
| 688 | 'adr_one_region' => array('type' => 'varchar', 'precision' => 32), |
---|
| 689 | 'adr_one_postalcode' => array('type' => 'varchar', 'precision' => 32), |
---|
| 690 | 'adr_one_countryname' => array('type' => 'varchar', 'precision' => 32), |
---|
| 691 | 'adr_one_type' => array('type' => 'varchar', 'precision' => 64), |
---|
| 692 | 'label' => array('type' => 'text'), |
---|
| 693 | 'adr_two_street' => array('type' => 'varchar', 'precision' => 64), |
---|
| 694 | 'adr_two_locality' => array('type' => 'varchar', 'precision' => 32), |
---|
| 695 | 'adr_two_region' => array('type' => 'varchar', 'precision' => 32), |
---|
| 696 | 'adr_two_postalcode' => array('type' => 'varchar', 'precision' => 32), |
---|
| 697 | 'adr_two_type' => array('type' => 'varchar', 'precision' => 64), |
---|
| 698 | 'tel_work' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 699 | 'tel_home' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 700 | 'tel_voice' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 701 | 'tel_fax' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 702 | 'tel_msg' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 703 | 'tel_cell' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 704 | 'tel_pager' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 705 | 'tel_bbs' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 706 | 'tel_modem' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 707 | 'tel_car' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 708 | 'tel_isdn' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 709 | 'tel_video' => array('type' => 'varchar', 'precision' => 40, 'default' => '+1 (000) 000-0000', 'nullable' => False), |
---|
| 710 | 'tel_prefer' => array('type' => 'varchar', 'precision' => 32), |
---|
| 711 | 'email' => array('type' => 'varchar', 'precision' => 64), |
---|
| 712 | 'email_type' => array('type' => 'varchar', 'precision' => 32, 'default' => 'INTERNET'), |
---|
| 713 | 'email_home' => array('type' => 'varchar', 'precision' => 64), |
---|
| 714 | 'email_home_type' => array('type' => 'varchar', 'precision' => 32, 'default' => 'INTERNET') |
---|
| 715 | ), |
---|
| 716 | 'pk' => array('id'), |
---|
| 717 | 'fk' => array(), |
---|
| 718 | 'ix' => array(), |
---|
| 719 | 'uc' => array() |
---|
| 720 | ) |
---|
| 721 | ); |
---|
| 722 | |
---|
| 723 | $phpgw_setup->oProc->query("SELECT * FROM phpgw_addressbook_old"); |
---|
| 724 | while ($phpgw_setup->oProc->next_record()) |
---|
| 725 | { |
---|
| 726 | $fields['id'] = $phpgw_setup->oProc->f("id"); |
---|
| 727 | $fields['owner'] = $phpgw_setup->oProc->f("owner"); |
---|
| 728 | $fields['n_given'] = $phpgw_setup->oProc->f("firstname"); |
---|
| 729 | $fields['n_family'] = $phpgw_setup->oProc->f("lastname"); |
---|
| 730 | $fields['email'] = $phpgw_setup->oProc->f("d_email"); |
---|
| 731 | $fields['email_type'] = $phpgw_setup->oProc->f("d_emailtype"); |
---|
| 732 | $fields['tel_home'] = $phpgw_setup->oProc->f("b_tel"); |
---|
| 733 | $fields['tel_work'] = $phpgw_setup->oProc->f("a_tel"); |
---|
| 734 | $fields['tel_fax'] = $phpgw_setup->oProc->f("c_tel"); |
---|
| 735 | $fields['fn'] = $phpgw_setup->oProc->f("fn"); |
---|
| 736 | $fields['org_name'] = $phpgw_setup->oProc->f("org_name"); |
---|
| 737 | $fields['title'] = $phpgw_setup->oProc->f("title"); |
---|
| 738 | $fields['adr_one_street'] = $phpgw_setup->oProc->f("adr_street"); |
---|
| 739 | $fields['adr_one_locality'] = $phpgw_setup->oProc->f("adr_locality"); |
---|
| 740 | $fields['adr_one_region'] = $phpgw_setup->oProc->f("adr_region"); |
---|
| 741 | $fields['adr_one_postalcode'] = $phpgw_setup->oProc->f("adr_postalcode"); |
---|
| 742 | $fields['adr_one_countryname'] = $phpgw_setup->oProc->f("adr_countryname"); |
---|
| 743 | $fields['bday'] = $phpgw_setup->oProc->f("bday"); |
---|
| 744 | $fields['note'] = $phpgw_setup->oProc->f("note"); |
---|
| 745 | $fields['url'] = $phpgw_setup->oProc->f("url"); |
---|
| 746 | |
---|
| 747 | $sql="INSERT INTO phpgw_addressbook (org_name,n_given,n_family,fn,email,email_type,title,tel_work," |
---|
| 748 | . "tel_home,tel_fax,adr_one_street,adr_one_locality,adr_one_region,adr_one_postalcode,adr_one_countryname," |
---|
| 749 | . "owner,bday,url,note)" |
---|
| 750 | . " VALUES ('".$fields["org_name"]."','".$fields["n_given"]."','".$fields["n_family"]."','" |
---|
| 751 | . $fields["fn"]."','".$fields["email"]."','".$fields["email_type"]."','".$fields["title"]."','".$fields["tel_work"]."','" |
---|
| 752 | . $fields["tel_home"]."','".$fields["tel_fax"] ."','".$fields["adr_one_street"]."','" |
---|
| 753 | . $fields["adr_one_locality"]."','".$fields["adr_one_region"]."','".$fields["adr_one_postalcode"]."','" |
---|
| 754 | . $fields["adr_one_countryname"]."','".$fields["owner"] ."','".$fields["bday"]."','".$fields["url"]."','".$fields["note"]."')"; |
---|
| 755 | |
---|
| 756 | $db1->query($sql,__LINE__,__FILE__); |
---|
| 757 | } |
---|
| 758 | |
---|
| 759 | $phpgw_setup->oProc->query("DROP TABLE phpgw_addressbook_old"); |
---|
| 760 | |
---|
| 761 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_home='' WHERE tel_home='n' OR tel_home='y'"); |
---|
| 762 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_work='' WHERE tel_work='n' OR tel_work='y'"); |
---|
| 763 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_cell='' WHERE tel_cell='n' OR tel_cell='y'"); |
---|
| 764 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_voice='' WHERE tel_voice='n' OR tel_voice='y'"); |
---|
| 765 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_fax='' WHERE tel_fax='n' OR tel_fax='y'"); |
---|
| 766 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_car='' WHERE tel_car='n' OR tel_car='y'"); |
---|
| 767 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_pager='' WHERE tel_pager='n' OR tel_pager='y'"); |
---|
| 768 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_msg='' WHERE tel_msg='n' OR tel_msg='y'"); |
---|
| 769 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_bbs='' WHERE tel_bbs='n' OR tel_bbs='y'"); |
---|
| 770 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_modem='' WHERE tel_modem='n' OR tel_modem='y'"); |
---|
| 771 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_prefer='' WHERE tel_prefer='n' OR tel_prefer='y'"); |
---|
| 772 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_video='' WHERE tel_video='n' OR tel_video='y'"); |
---|
| 773 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tel_isdn='' WHERE tel_isdn='n' OR tel_isdn='y'"); |
---|
| 774 | |
---|
| 775 | $sql = "SELECT * FROM phpgw_addressbook_extra WHERE contact_name='mphone'"; |
---|
| 776 | $phpgw_setup->oProc->query($sql,__LINE__,__FILE__); |
---|
| 777 | |
---|
| 778 | while($phpgw_setup->oProc->next_record()) |
---|
| 779 | { |
---|
| 780 | $cid = $phpgw_setup->oProc->f('contact_id'); |
---|
| 781 | $cvalu = $phpgw_setup->oProc->f('contact_value'); |
---|
| 782 | if ($cvalu) |
---|
| 783 | { |
---|
| 784 | $update = "UPDATE phpgw_addressbook SET tel_cell='" . $cvalu . "' WHERE id=" . $cid; |
---|
| 785 | $db1->query($update); |
---|
| 786 | $delete = "DELETE FROM phpgw_addressbook_extra WHERE contact_id=" . $cid . " AND contact_name='mphone'"; |
---|
| 787 | $db1->query($delete); |
---|
| 788 | } |
---|
| 789 | } |
---|
| 790 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre17'; |
---|
| 791 | return $setup_info['phpgwapi']['currentver']; |
---|
| 792 | //return True; |
---|
| 793 | } |
---|
| 794 | |
---|
| 795 | $test[] = '0.9.10pre17'; |
---|
| 796 | function phpgwapi_upgrade0_9_10pre17() |
---|
| 797 | { |
---|
| 798 | global $phpgw_info, $phpgw_setup; |
---|
| 799 | |
---|
| 800 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook','pubkey', array('type' => 'text')); |
---|
| 801 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook','adr_two_countryname', array('type' => 'varchar', 'precision' => 32)); |
---|
| 802 | |
---|
| 803 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre18'; |
---|
| 804 | return $setup_info['phpgwapi']['currentver']; |
---|
| 805 | //return True; |
---|
| 806 | } |
---|
| 807 | |
---|
| 808 | $test[] = '0.9.10pre18'; |
---|
| 809 | function phpgwapi_upgrade0_9_10pre18() |
---|
| 810 | { |
---|
| 811 | global $setup_info, $phpgw_setup; |
---|
| 812 | |
---|
| 813 | $phpgw_setup->oProc->CreateTable( |
---|
| 814 | 'phpgw_nextid', array( |
---|
| 815 | 'fd' => array( |
---|
| 816 | 'appname' => array('type' => 'varchar', 'precision' => 25), |
---|
| 817 | 'id' => array('type' => 'int', 'precision' => 4) |
---|
| 818 | ), |
---|
| 819 | 'pk' => array(), |
---|
| 820 | 'fk' => array(), |
---|
| 821 | 'ix' => array(), |
---|
| 822 | 'uc' => array('appname') |
---|
| 823 | ) |
---|
| 824 | ); |
---|
| 825 | |
---|
| 826 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre19'; |
---|
| 827 | return $setup_info['phpgwapi']['currentver']; |
---|
| 828 | //return True; |
---|
| 829 | } |
---|
| 830 | |
---|
| 831 | $test[] = '0.9.10pre19'; |
---|
| 832 | function phpgwapi_upgrade0_9_10pre19() |
---|
| 833 | { |
---|
| 834 | global $setup_info, $phpgw_setup; |
---|
| 835 | |
---|
| 836 | $phpgw_setup->oProc->DropTable('phpgw_nextid'); |
---|
| 837 | |
---|
| 838 | $phpgw_setup->oProc->CreateTable( |
---|
| 839 | 'phpgw_nextid', array( |
---|
| 840 | 'fd' => array( |
---|
| 841 | 'appname' => array('type' => 'varchar', 'precision' => 25, 'nullable' => False), |
---|
| 842 | 'id' => array('type' => 'int', 'precision' => 4) |
---|
| 843 | ), |
---|
| 844 | 'pk' => array(), |
---|
| 845 | 'fk' => array(), |
---|
| 846 | 'ix' => array(), |
---|
| 847 | 'uc' => array('appname') |
---|
| 848 | ) |
---|
| 849 | ); |
---|
| 850 | |
---|
| 851 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre20'; |
---|
| 852 | return $setup_info['phpgwapi']['currentver']; |
---|
| 853 | //return True; |
---|
| 854 | } |
---|
| 855 | $test[] = '0.9.10pre20'; |
---|
| 856 | function phpgwapi_upgrade0_9_10pre20() |
---|
| 857 | { |
---|
| 858 | global $setup_info, $phpgw_setup; |
---|
| 859 | |
---|
| 860 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook', 'access', array('type' => 'char', 'precision' => 7)); |
---|
| 861 | |
---|
| 862 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre21'; |
---|
| 863 | return $setup_info['phpgwapi']['currentver']; |
---|
| 864 | //return True; |
---|
| 865 | } |
---|
| 866 | |
---|
| 867 | $test[] = '0.9.10pre21'; |
---|
| 868 | function phpgwapi_upgrade0_9_10pre21() |
---|
| 869 | { |
---|
| 870 | global $setup_info, $phpgw_setup; |
---|
| 871 | |
---|
| 872 | $phpgw_setup->oProc->AddColumn('phpgw_addressbook', 'cat_id', array('type' => 'varchar', 'precision' => 32)); |
---|
| 873 | |
---|
| 874 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre22'; |
---|
| 875 | return $setup_info['phpgwapi']['currentver']; |
---|
| 876 | //return True; |
---|
| 877 | } |
---|
| 878 | |
---|
| 879 | $test[] = '0.9.10pre22'; |
---|
| 880 | function phpgwapi_upgrade0_9_10pre22() |
---|
| 881 | { |
---|
| 882 | global $setup_info; |
---|
| 883 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre23'; |
---|
| 884 | return $setup_info['phpgwapi']['currentver']; |
---|
| 885 | //return True; |
---|
| 886 | } |
---|
| 887 | |
---|
| 888 | $test[] = '0.9.10pre23'; |
---|
| 889 | function phpgwapi_upgrade0_9_10pre23() |
---|
| 890 | { |
---|
| 891 | global $setup_info, $phpgw_setup; |
---|
| 892 | |
---|
| 893 | $phpgw_setup->oProc->query("UPDATE phpgw_addressbook SET tid='n' WHERE tid is null"); |
---|
| 894 | |
---|
| 895 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre24'; |
---|
| 896 | return $setup_info['phpgwapi']['currentver']; |
---|
| 897 | //return True; |
---|
| 898 | } |
---|
| 899 | |
---|
| 900 | $test[] = '0.9.10pre24'; |
---|
| 901 | function phpgwapi_upgrade0_9_10pre24() |
---|
| 902 | { |
---|
| 903 | global $setup_info, $phpgw_setup; |
---|
| 904 | |
---|
| 905 | $phpgw_setup->oProc->AlterColumn('phpgw_categories','cat_access', array('type' => 'char', 'precision' => 7)); |
---|
| 906 | |
---|
| 907 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre25'; |
---|
| 908 | return $setup_info['phpgwapi']['currentver']; |
---|
| 909 | //return True; |
---|
| 910 | } |
---|
| 911 | |
---|
| 912 | $test[] = '0.9.10pre25'; |
---|
| 913 | function phpgwapi_upgrade0_9_10pre25() |
---|
| 914 | { |
---|
| 915 | global $setup_info, $phpgw_setup; |
---|
| 916 | |
---|
| 917 | $phpgw_setup->oProc->AddColumn('phpgw_app_sessions','session_dla', array('type' => 'int', 'precision' => 4)); |
---|
| 918 | |
---|
| 919 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre26'; |
---|
| 920 | return $setup_info['phpgwapi']['currentver']; |
---|
| 921 | //return True; |
---|
| 922 | } |
---|
| 923 | |
---|
| 924 | $test[] = '0.9.10pre26'; |
---|
| 925 | function phpgwapi_upgrade0_9_10pre26() |
---|
| 926 | { |
---|
| 927 | global $setup_info; |
---|
| 928 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre27'; |
---|
| 929 | return $setup_info['phpgwapi']['currentver']; |
---|
| 930 | //return True; |
---|
| 931 | } |
---|
| 932 | |
---|
| 933 | $test[] = '0.9.10pre27'; |
---|
| 934 | function phpgwapi_upgrade0_9_10pre27() |
---|
| 935 | { |
---|
| 936 | global $setup_info, $phpgw_setup; |
---|
| 937 | |
---|
| 938 | $phpgw_setup->oProc->AlterColumn('phpgw_app_sessions', 'content', array('type' => 'longtext')); |
---|
| 939 | |
---|
| 940 | $setup_info['phpgwapi']['currentver'] = '0.9.10pre28'; |
---|
| 941 | return $setup_info['phpgwapi']['currentver']; |
---|
| 942 | //return True; |
---|
| 943 | } |
---|
| 944 | |
---|
| 945 | $test[] = '0.9.10pre28'; |
---|
| 946 | function phpgwapi_upgrade0_9_10pre28() |
---|
| 947 | { |
---|
| 948 | global $setup_info; |
---|
| 949 | $setup_info['phpgwapi']['currentver'] = '0.9.10'; |
---|
| 950 | return $setup_info['phpgwapi']['currentver']; |
---|
| 951 | //return True; |
---|
| 952 | } |
---|
| 953 | ?> |
---|