<?php
	/**************************************************************************\
	* phpGroupWare - Setup                                                     *
	* http://www.phpgroupware.org                                              *
	* --------------------------------------------                             *
	*  This program is free software; you can redistribute it and/or modify it *
	*  under the terms of the GNU General Public License as published by the   *
	*  Free Software Foundation; either version 2 of the License, or (at your  *
	*  option) any later version.                                              *
	\**************************************************************************/

	// Since Expresso 1.2 using API EgroupWare 1.0.0.007 
	$test[] = '1.0.0.007';
	function phpgwapi_upgrade1_0_0_007()
	{

		global $setup_info,$phpgw_setup;

		$phpgw_setup->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.1.000';
		return $GLOBALS['setup_info']['phpgwapi']['currentver'];
	}	
	$test[] = '2.1.000';
	function phpgwapi_upgrade2_1_000()
	{
		global $setup_info,$phpgw_setup;
		$phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN created TYPE timestamp;");
	        $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN modified TYPE timestamp;");
	        $phpgw_setup->oProc->query("CREATE TABLE phpgw_vfs_quota (directory VARCHAR(100), quota_size INT NOT NULL, PRIMARY KEY (directory));");
	        $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ADD COLUMN type integer DEFAULT 0;");
	        $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ADD COLUMN summary bytea;");
		$phpgw_setup->oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_quota_size',500);");
	        $phpgw_setup->oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_Max_file_size',20);");
		$phpgw_setup->oProc->query('INSERT INTO phpgw_preferences VALUES (-2,\'filemanager\',\'a:19:{s:4:"name";s:1:"1";s:9:"mime_type";s:1:"1";s:4:"size";s:1:"1";s:7:"created";s:1:"1";s:8:"modified";s:1:"1";s:5:"owner";s:1:"1";s:12:"createdby_id";s:1:"1";s:13:"modifiedby_id";s:1:"1";s:3:"app";s:1:"0";s:7:"comment";s:1:"1";s:7:"version";s:1:"1";s:12:"viewinnewwin";s:1:"1";s:12:"viewonserver";s:1:"1";s:13:"viewtextplain";s:1:"1";s:6:"dotdot";s:1:"1";s:8:"dotfiles";s:1:"1";s:8:"pdf_type";s:8:"portrait";s:14:"pdf_paper_type";s:2:"a4";s:14:"files_per_page";s:3:"200";}\');');
		$phpgw_setup->oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (1,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', NULL, NULL);");
		$phpgw_setup->oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (2,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', NULL, NULL);");
		$GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.000';
		return $GLOBALS['setup_info']['phpgwapi']['currentver'];
	}
?>