source: trunk/calendar/setup/tables_update.inc.php @ 204

<?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'];
        }

?>