[Phpgroupware-cvs] tts/setup setup.inc.php tables_current.inc.php ...

[Dave Hall]

CVSROOT:        /cvsroot/phpgroupware
Module name:    tts
Changes by:     Dave Hall <skwashd>     06/12/26 12:54:44

Modified files:
        setup          : setup.inc.php tables_current.inc.php 
                         tables_update.inc.php 

Log message:
        add new table to map mail queues to ticket types

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/tts/setup/setup.inc.php?cvsroot=phpgroupware&r1=1.14&r2=1.15
http://cvs.savannah.gnu.org/viewcvs/tts/setup/tables_current.inc.php?cvsroot=phpgroupware&r1=1.11&r2=1.12
http://cvs.savannah.gnu.org/viewcvs/tts/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.5&r2=1.6

Patches:
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/setup.inc.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -b -r1.14 -r1.15
--- setup.inc.php       24 Oct 2006 00:50:09 -0000      1.14
+++ setup.inc.php       26 Dec 2006 12:54:44 -0000      1.15
@@ -6,20 +6,20 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package tts
        * @subpackage setup
-       * @version $Id: setup.inc.php,v 1.14 2006/10/24 00:50:09 skwashd Exp $
+       * @version $Id: setup.inc.php,v 1.15 2006/12/26 12:54:44 skwashd Exp $
        */
 
        /* Basic information about this app */
        $setup_info['tts']['name']              = 'tts';
        $setup_info['tts']['title']             = 'Trouble Ticket System';
-       $setup_info['tts']['version']           = '0.9.17.500';
+       $setup_info['tts']['version']           = '0.9.17.501';
        $setup_info['tts']['app_order']         = 99;
        $setup_info['tts']['enable']            = 1;
        $setup_info['tts']['globals_checked']   = True;
        $setup_info['tts']['app_group']         = 'development';
 
        /* The tables this app creates */
-       $setup_info['tts']['tables']    = 
array('phpgw_tts_tickets','phpgw_tts_views');
+       $setup_info['tts']['tables']    = 
array('phpgw_tts_tickets','phpgw_tts_views','phpgw_tts_email_map');
 
        /* The hooks this app includes, needed for hooks registration */
        $setup_info['tts']['hooks'][] = 'admin';

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/tables_current.inc.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -b -r1.11 -r1.12
--- tables_current.inc.php      24 Oct 2006 00:50:09 -0000      1.11
+++ tables_current.inc.php      26 Dec 2006 12:54:44 -0000      1.12
@@ -6,7 +6,7 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package tts
        * @subpackage setup
-       * @version $Id: tables_current.inc.php,v 1.11 2006/10/24 00:50:09 
skwashd Exp $
+       * @version $Id: tables_current.inc.php,v 1.12 2006/12/26 12:54:44 
skwashd Exp $
        */
 
        $phpgw_baseline = array(
@@ -45,5 +45,17 @@
                        'ix' => array(),
                        'fk' => array(),
                        'uc' => array()
+               ),
+               'phpgw_tts_email_map' => array(
+                       'fd' => array(
+                               'tts_email_map_id' => array('type' => 
'auto','nullable' => False),
+                               'api_handler_id' => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'tts_cat_id' => array('type' => 
'varchar','precision' => '8','nullable' => False),
+                               'is_active' => array('type' => 
'varchar','precision' => '4','nullable' => False)
+                       ),
+                       'pk' => array('tts_email_map_id'),
+                       'fk' => array(),
+                       'ix' => 
array('api_handler_id','tts_cat_id','is_active'),
+                       'uc' => array()
                )
        );

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/tables_update.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -b -r1.5 -r1.6
--- tables_update.inc.php       24 Oct 2006 00:50:09 -0000      1.5
+++ tables_update.inc.php       26 Dec 2006 12:54:44 -0000      1.6
@@ -6,7 +6,7 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package tts
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.5 2006/10/24 00:50:09 skwashd 
Exp $
+       * @version $Id: tables_update.inc.php,v 1.6 2006/12/26 12:54:44 skwashd 
Exp $
        */
 
        /* This is since the last release */
@@ -160,4 +160,26 @@
                $GLOBALS['setup_info']['tts']['currentver'] = '0.9.17.500';
                return $GLOBALS['setup_info']['tts']['currentver'];
        }
+
+
+       $test[] = '0.9.17.500';
+       function tts_upgrade0_9_17_500()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_tts_email_map',array(
+                       'fd' => array(
+                               'tts_email_map_id' => array('type' => 
'auto','nullable' => False),
+                               'api_handler_id' => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'tts_cat_id' => array('type' => 
'varchar','precision' => '8','nullable' => False),
+                               'is_active' => array('type' => 
'varchar','precision' => '4','nullable' => False)
+                       ),
+                       'pk' => array('tts_email_map_id'),
+                       'fk' => array(),
+                       'ix' => 
array('api_handler_id','tts_cat_id','is_active'),
+                       'uc' => array()
+               ));
+
+
+               $GLOBALS['setup_info']['tts']['currentver'] = '0.9.17.501';
+               return $GLOBALS['setup_info']['tts']['currentver'];
+       }
 ?>