<?php
  /**************************************************************************\
  * eGroupWare - Setup                                                       *
  * http://www.egroupware.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.                                              *
  \**************************************************************************/
	$test[] = '0.9.2';
	function calendar_upgrade0_9_2()
	{
		$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.17';
		return $GLOBALS['setup_info']['calendar']['currentver'];
	}
	$test[] = '0.9.17';
	function calendar_upgrade0_9_17()
	{
		$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21';
		return $GLOBALS['setup_info']['calendar']['currentver'];
	}
	$test[] = '0.9.20';
	function calendar_upgrade0_9_20()
	{
		$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21';
		return $GLOBALS['setup_info']['calendar']['currentver'];
	}	
	$test[] = '0.9.21';
	function calendar_upgrade0_9_21()
	{
		/*
		$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_status',array(
			'type' => 'char',
			'precision' => '1',
			'default' => 'N::bpchar'));
		$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_update',array(
			'type' => 'int8',
			'precision' => '8',
			'default' => '(date_part(\'epoch\'::text, (\'now\'::text)::timestamp(3) with time zone) * (1000)::double precision)'));
		*/
		$GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar");
		$GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)");

		$GLOBALS['setup_info']['calendar']['currentver'] = '0.9.22';
		return $GLOBALS['setup_info']['calendar']['currentver'];
	}

?>