[Phpgroupware-cvs] old/wcm/setup/tables_update.inc.php, 1.1

[nomail]

Update of /old/wcm/setup
Added Files:
        Branch: 
          tables_update.inc.php

date: 2004/12/30 08:13:58;  author: skwashd;  state: Exp;

Log Message:
keep historic record for wcm
=====================================================================
<?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.                                            
   *
        
\**************************************************************************/

        /* $Id: tables_update.inc.php,v 1.1 2004/12/30 08:13:58 skwashd Exp $ */

        $test[] = '0.1.0';
        function wcm_upgrade0_1_0()
        {
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_elements', 
'element_hf', array('type' => 'varchar', 'precision' => 16, 'nullable' => 
True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.1';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }

        $test[] = '0.1.1';
        function wcm_upgrade0_1_1()
        {
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites', 
'site_left', array('type' => 'int', 'precision' => 4, 'nullable' => True));
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites', 
'site_mid', array('type' => 'int', 'precision' => 4, 'nullable' => True));
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites', 
'site_right', array('type' => 'int', 'precision' => 4, 'nullable' => True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.2';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }

        $test[] = '0.1.2';
        function wcm_upgrade0_1_2()
        {
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites', 
'site_paneo', array('type' => 'int', 'precision' => 4, 'nullable' => True));
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_pages', 
'page_left', array('type' => 'int', 'precision' => 4, 'nullable' => True));
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_pages', 
'page_mid', array('type' => 'int', 'precision' => 4, 'nullable' => True));
                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_pages', 
'page_right', array('type' => 'int', 'precision' => 4, 'nullable' => True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.3';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }

        $test[] = '0.1.3';
        function wcm_upgrade0_1_3()
        {
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites','site_pubtype', 
array('type' => 'varchar', 'precision' => 16,'nullable' => True));
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites','site_puburl',  
array('type' => 'varchar', 'precision' => 255, 'nullable' => True));
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites','site_pubport', 
array('type' => 'int', 'precision' => 4, 'nullable' => True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.4';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }

        $test[] = '0.1.4';
        function wcm_upgrade0_1_4()
        {
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_sites','site_bgcolor', 
array('type' => 'varchar', 'precision' => 8, 'nullable' => True));
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_pages','page_bgcolor', 
array('type' => 'varchar', 'precision' => 8, 'nullable' => True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.5';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }

        $test[] = '0.1.5';
        function wcm_upgrade0_1_5()
        {
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_pages','page_sites', 
array('type' => 'varchar', 'precision' => 64, 'nullable' => True));
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_wcm_elements','element_pages', 
array('type' => 'varchar', 'precision' => 64, 'nullable' => True));

                $GLOBALS['setup_info']['wcm']['currentver'] = '0.1.6';
                return $GLOBALS['setup_info']['inv']['currentver'];
        }
?>