oProc->AddColumn('phpgw_access_log','browser', array ('type' => 'varchar', 'precision' => 200)); $GLOBALS['setup_info']['phpgwapi']['currentver'] = '1.0.0.008'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '1.0.0.008'; function phpgwapi_upgrade1_0_0_008() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.0.pre-alpha'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.0.pre-alpha'; function phpgwapi_upgrade2_0_0_prealpha() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.000'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.000'; function phpgwapi_upgrade2_0_000() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.001'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.001'; function phpgwapi_upgrade2_0_001() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.002'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.002'; function phpgwapi_upgrade2_0_002() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.003'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.003'; function phpgwapi_upgrade2_0_003() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.004'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.004'; function phpgwapi_upgrade2_0_004() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.005'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.005'; function phpgwapi_upgrade2_0_005() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.006'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.006'; function phpgwapi_upgrade2_0_006() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.007'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.007'; function phpgwapi_upgrade2_0_007() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.008'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.008'; function phpgwapi_upgrade2_0_008() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.009'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.009'; function phpgwapi_upgrade2_0_009() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.010'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.0.010'; function phpgwapi_upgrade2_0_010() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.1.000'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.1.000'; function phpgwapi_upgrade2_1_000() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.000'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.000'; function phpgwapi_upgrade2_2_000() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.1'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.1'; function phpgwapi_upgrade2_2_1() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.2'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.2'; function phpgwapi_upgrade2_2_2() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.3'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.3'; function phpgwapi_upgrade2_2_3() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.4'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.4'; function phpgwapi_upgrade2_2_4() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.6'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.6'; function phpgwapi_upgrade2_2_6() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.8'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.8'; function phpgwapi_upgrade2_2_8() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.10'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.2.10'; function phpgwapi_upgrade2_2_10() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.3.0'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.3.0'; function phpgwapi_upgrade2_3_0() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.4.0'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.4.0'; function phpgwapi_upgrade2_4_0() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.4.1'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.4.1'; function phpgwapi_upgrade2_4_1() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.4.2'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.4.2'; function phpgwapi_upgrade2_4_2() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.0'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.5.0'; function phpgwapi_upgrade2_5_0() { $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.1'; global $setup_info,$phpgw_setup; $phpgw_setup->oProc->query("ALTER TABLE phpgw_access_log ALTER COLUMN ip TYPE character varying(255) "); return $GLOBALS['setup_info']['phpgwapi']['currentver']; } $test[] = '2.5.1'; function phpgwapi_upgrade2_5_1() { global $phpgw_setup; $phpgw_setup->oProc->query( 'select * from information_schema.tables where table_name= \'phpgw_vfs\''); if( !$phpgw_setup->oProc->next_record() ) { $phpgw_setup->oProc->CreateTable('phpgw_vfs', array( 'fd' => array( 'file_id' => array('type' => 'auto','nullable' => False), 'owner_id' => array('type' => 'int','precision' => '4','nullable' => False), 'createdby_id' => array('type' => 'int','precision' => '4'), 'modifiedby_id' => array('type' => 'int','precision' => '4'), 'created' => array('type' => 'timestamp','nullable' => False,'default' => '1970-01-01'), 'modified' => array('type' => 'timestamp'), 'size' => array('type' => 'int','precision' => '4'), 'mime_type' => array('type' => 'varchar','precision' => '64'), 'deleteable' => array('type' => 'char','precision' => '1','default' => 'Y'), 'comment' => array('type' => 'varchar','precision' => '255'), 'app' => array('type' => 'varchar','precision' => '25'), 'directory' => array('type' => 'varchar','precision' => '255'), 'name' => array('type' => 'varchar','precision' => '128','nullable' => False), 'link_directory' => array('type' => 'varchar','precision' => '255'), 'link_name' => array('type' => 'varchar','precision' => '128'), 'version' => array('type' => 'varchar','precision' => '30','nullable' => False,'default' => '0.0.0.0'), 'content' => array('type' => 'longtext') ) )); } $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.1.0'; return $GLOBALS['setup_info']['phpgwapi']['currentver']; } ?>