phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Dave Hall
Subject: [Phpgroupware-cvs] phpgwapi/setup setup.inc.php tables_current.inc...
Date: Tue, 24 Oct 2006 10:32:27 +0000

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Changes by:     Dave Hall <skwashd>     06/10/24 10:32:27

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

Log message:
        drop old custom fields tables which are not used any more, use custom 
attributes

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/setup/setup.inc.php?cvsroot=phpgwapi&r1=1.80&r2=1.81
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/setup/tables_current.inc.php?cvsroot=phpgwapi&r1=1.70&r2=1.71
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/setup/tables_update.inc.php?cvsroot=phpgwapi&r1=1.99&r2=1.100

Patches:
Index: setup.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/setup/setup.inc.php,v
retrieving revision 1.80
retrieving revision 1.81
diff -u -b -r1.80 -r1.81
--- setup.inc.php       23 Oct 2006 13:13:07 -0000      1.80
+++ setup.inc.php       24 Oct 2006 10:32:27 -0000      1.81
@@ -5,14 +5,14 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package phpgwapi
        * @subpackage setup
-       * @version $Id: setup.inc.php,v 1.80 2006/10/23 13:13:07 sigurdne Exp $
+       * @version $Id: setup.inc.php,v 1.81 2006/10/24 10:32:27 skwashd Exp $
        * @internal $Source: /sources/phpgwapi/phpgwapi/setup/setup.inc.php,v $
        */
 
        // Basic information about this app
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
-       $setup_info['phpgwapi']['version']   = '0.9.17.510';
+       $setup_info['phpgwapi']['version']   = '0.9.17.511';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.25';
        $setup_info['phpgwapi']['enable']    = 3;
        $setup_info['phpgwapi']['app_order'] = 1;
@@ -53,9 +53,6 @@
                'phpgw_contact_types',
                'phpgw_contact_addr_type',
                'phpgw_contact_note_type',
-               'phpgw_cust_fields',
-               'phpgw_cust_field_types',
-               'phpgw_cust_field_values',
                'phpgw_cust_attribute',
                'phpgw_cust_choice',
                'phpgw_cust_function',

Index: tables_current.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/setup/tables_current.inc.php,v
retrieving revision 1.70
retrieving revision 1.71
diff -u -b -r1.70 -r1.71
--- tables_current.inc.php      23 Oct 2006 13:13:07 -0000      1.70
+++ tables_current.inc.php      24 Oct 2006 10:32:27 -0000      1.71
@@ -5,7 +5,7 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package phpgwapi
        * @subpackage setup
-       * @version $Id: tables_current.inc.php,v 1.70 2006/10/23 13:13:07 
sigurdne Exp $
+       * @version $Id: tables_current.inc.php,v 1.71 2006/10/24 10:32:27 
skwashd Exp $
        * @internal $Source: 
/sources/phpgwapi/phpgwapi/setup/tables_current.inc.php,v $
        */
 
@@ -561,45 +561,6 @@
                        'ix' => array(),
                        'uc' => array()
                ),
-               'phpgw_cust_fields' => array(
-                       'fd' => array(
-                               'cust_field_id' => array('type' => 
'auto','nullable' => False),
-                               'cust_field_name' => array('type' => 
'varchar','precision' => '255','nullable' => False),
-                               'cust_field_type_id' => array('type' => 
'int','precision' => '8','nullable' => False),
-                               'cust_field_label' => array('type' => 
'varchar','precision' => '255','nullable' => False),
-                               'appname' => array('type' => 
'varchar','precision' => '25','nullable' => True),
-                               'cust_field_active' => array('type' => 
'varchar','precision' => '255','nullable' => False,'default' => '1')
-                       ),
-                       'pk' => array('cust_field_id'),
-                       'fk' => array(),
-                       'ix' => array('cust_field_name','cust_field_type_id'),
-                       'uc' => array()
-               ),
-               'phpgw_cust_field_types' => array(
-                       'fd' => array(
-                               'cust_field_type_id' => array('type' => 
'auto','nullable' => False),
-                               'cust_field_type_descr' => array('type' => 
'varchar','precision' => '255','nullable' => False),
-                               'cust_field_type_active' => array('type' => 
'int','precision' => '8','nullable' => False,'default' => '1')
-                       ),
-                       'pk' => array('cust_field_type_id'),
-                       'fk' => array(),
-                       'ix' => array(),
-                       'uc' => array()
-               ),
-               'phpgw_cust_field_values' => array(
-                       'fd' => array(
-                               'cust_field_value_id' => array('type' => 
'auto','nullable' => False),
-                               'cust_field_value_val' => array('type' => 
'varchar','precision' => '255','nullable' => False),
-                               'cust_field_id' => array('type' => 
'int','precision' => '8','nullable' => False),
-                               'appname' => array('type' => 
'varchar','precision' => '25','nullable' => False),
-                               'location' => array('type' => 
'varchar','precision' => '255','nullable' => True),
-                               'rec_id' => array('type' => 'int','precision' 
=> '8','nullable' => False)
-                       ),
-                       'pk' => array('cust_field_value_id'),
-                       'fk' => array(),
-                       'ix' => 
array('cust_field_value_val','cust_field_id','appname','location','rec_id'),
-                       'uc' => array()
-               ),
                'phpgw_cust_attribute' => array(
                        'fd' => array(
                                'appname' => array('type' => 
'varchar','precision' => '20','nullable' => False),

Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v
retrieving revision 1.99
retrieving revision 1.100
diff -u -b -r1.99 -r1.100
--- tables_update.inc.php       23 Oct 2006 13:13:07 -0000      1.99
+++ tables_update.inc.php       24 Oct 2006 10:32:27 -0000      1.100
@@ -5,7 +5,7 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package phpgwapi
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.99 2006/10/23 13:13:07 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.100 2006/10/24 10:32:27 
skwashd Exp $
        * @internal $Source: 
/sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v $
        */
 
@@ -1553,5 +1553,18 @@
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
 
+       $test[] = '0.9.17.510';
+       function phpgwapi_upgrade0_9_17_510()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
        
+               $GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cust_fields');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_cust_field_types');
+               $GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_field_values');
+
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
+
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.17.511';
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }       
 ?>




reply via email to

[Prev in Thread] Current Thread [Next in Thread]