[Phpgroupware-cvs] tts/setup default_records.inc.php, NONE, 1.1.2.1 tables_update.inc.php, NONE, 1.1.2.1

[Dave Hall <address@hidden>]

Update of /cvsroot/phpgroupware/tts/setup
In directory subversions:/tmp/cvs-serv19735/setup

Added Files:
      Tag: Version-0_9_16-branch
        default_records.inc.php tables_update.inc.php 
Log Message:
probiz changes from lars - untested

--- NEW FILE: default_records.inc.php ---
<?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.                                              *
  \**************************************************************************/

        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description) VALUES ('public','phpgw','tts','Subcategories for 
tts')");
        
        $oProc->query("SELECT cat_id FROM phpgw_categories WHERE 
cat_name='tts'");
        $oProc->next_record();
        $parent_id = $oProc->f('cat_id');
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','platform','Subcategories for tts'," . $cat_id . ",'1')");
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','type','Subcategories for tts'," . $cat_id . ",'1')");
        
        $oProc->query("SELECT cat_id FROM phpgw_categories WHERE 
cat_name='platform'");
        $oProc->next_record();
        $parent_id = $oProc->f('cat_id');
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','Windows','Subcategories for tts'," . $cat_id . ",'2')");
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','Linux','Subcategories for tts'," . $cat_id . ",'2')");
        
        $oProc->query("SELECT cat_id FROM phpgw_categories WHERE 
cat_name='type'");
        $oProc->next_record();
        $parent_id = $oProc->f('cat_id');
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','Bug','Subcategories for tts'," . $cat_id . ",'2')");
        $oProc->query ("INSERT INTO phpgw_categories (cat_access, cat_appname, 
cat_name, cat_description, cat_parent, cat_level) VALUES 
('public','phpgw','Feature Request','Subcategories for tts'," . $cat_id . 
",'2')");
        
?>

--- NEW FILE: tables_update.inc.php ---
<?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.2.1 2003/10/31 07:08:30 skwashd Exp 
$
        // $Source: 
/cvsroot/phpgroupware/tts/setup/Attic/tables_update.inc.php,v $

        /* This is since the last release */
        $test[] = '0.9.16';
        function phpgwapi_upgrade0_9_16()
        {
                global $setup_info,$phpgw_setup;
                
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','type',array(
                        'type' => 'int',
                        'precision' => '',
                        'nullable' => True
                        ));
                        
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','deadline',array(
                        'type' => 'varchar',
                        'precision' => '10',
                        'nullable' => True
                        ));
                
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','effort',array(
                        'type' => 'varchar',
                        'precision' => '4',
                        'nullable' => True
                        ));
                        
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','platform',array(
                        'type' => 'int',
                        'precision' => '',
                        'nullable' => True
                        ));
                        
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','attachment',array(
                        'type' => 'int',
                        'precision' => '',
                        'nullable' => True
                        ));
                
                $setup_info['phpgwapi']['currentver'] = '0.9.16.001';
                return $setup_info['phpgwapi']['currentver'];
        }

?>