[Phpgroupware-cvs] CVS: phpgwapi/setup setup.inc.php,1.55,1.56 tables_current.inc.php,1.44,1.45 tables_update.inc.php,1.69,1.70

[Bettina Gille <address@hidden>]

Update of /cvsroot/phpgroupware/phpgwapi/setup
In directory subversions:/tmp/cvs-serv14125

Modified Files:
        setup.inc.php tables_current.inc.php tables_update.inc.php 
Log Message:
update categories plus addressbook table to add column last_mod

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/setup.inc.php,v
retrieving revision 1.55
retrieving revision 1.56
diff -C2 -r1.55 -r1.56
*** setup.inc.php       1 May 2003 09:19:33 -0000       1.55
--- setup.inc.php       1 May 2003 23:22:57 -0000       1.56
***************
*** 14,18 ****
        /* Basic information about this app */
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
!       $setup_info['phpgwapi']['version']   = '0.9.15.011';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.23';
        $setup_info['phpgwapi']['enable']    = 3;
--- 14,18 ----
        /* Basic information about this app */
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
!       $setup_info['phpgwapi']['version']   = '0.9.15.012';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.23';
        $setup_info['phpgwapi']['enable']    = 3;

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/tables_current.inc.php,v
retrieving revision 1.44
retrieving revision 1.45
diff -C2 -r1.44 -r1.45
*** tables_current.inc.php      1 May 2003 09:19:33 -0000       1.44
--- tables_current.inc.php      1 May 2003 23:22:57 -0000       1.45
***************
*** 181,185 ****
                                'cat_name' => array('type' => 'varchar', 
'precision' => 150, 'nullable' => false),
                                'cat_description' => array('type' => 'varchar', 
'precision' => 255, 'nullable' => false),
!                               'cat_data' => array('type' => 'text')
                        ),
                        'pk' => array('cat_id'),
--- 181,186 ----
                                'cat_name' => array('type' => 'varchar', 
'precision' => 150, 'nullable' => false),
                                'cat_description' => array('type' => 'varchar', 
'precision' => 255, 'nullable' => false),
!                               'cat_data' => array('type' => 'text'),
!                               'last_mod' => array('type' => 'int','precision' 
=> '4','nullable' => False)
                        ),
                        'pk' => array('cat_id'),
***************
*** 241,245 ****
                                'email_type' => array('type' => 'varchar', 
'precision' => 32,'nullable' => False,'default' => 'INTERNET'),
                                'email_home' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
!                               'email_home_type' => array('type' => 'varchar', 
'precision' => 32,'nullable' => False,'default' => 'INTERNET')
                        ),
                        'pk' => array('id'),
--- 242,247 ----
                                'email_type' => array('type' => 'varchar', 
'precision' => 32,'nullable' => False,'default' => 'INTERNET'),
                                'email_home' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
!                               'email_home_type' => array('type' => 'varchar', 
'precision' => 32,'nullable' => False,'default' => 'INTERNET'),
!                               'last_mod' => array('type' => 'int','precision' 
=> '4','nullable' => False)
                        ),
                        'pk' => array('id'),

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/tables_update.inc.php,v
retrieving revision 1.69
retrieving revision 1.70
diff -C2 -r1.69 -r1.70
*** tables_update.inc.php       1 May 2003 09:19:33 -0000       1.69
--- tables_update.inc.php       1 May 2003 23:22:57 -0000       1.70
***************
*** 124,127 ****
--- 124,143 ----
        }
  
+       $test[] = '0.9.14.504';
+       function phpgwapi_upgrade0_9_14_504()
+       {
+               // 0.9.15.001-12 are already included in 0.9.14.504
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.15.012';
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }
+ 
+       $test[] = '0.9.14.505';
+       function phpgwapi_upgrade0_9_14_505()
+       {
+               // 0.9.15.001-12 are already included in 0.9.14.505
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.15.012';
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }
+ 
        $test[] = '0.9.15.001';
        function phpgwapi_upgrade0_9_15_001()
***************
*** 349,351 ****
--- 365,385 ----
        }
  
+       $test[] = '0.9.15.011';
+       function phpgwapi_upgrade0_9_15_011()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_addressbook','last_mod',array(
+                               'type' => 'int',
+                               'precision' => '4',
+                               'nullable' => False
+                       ));
+ 
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_categories','last_mod',array(
+                               'type' => 'int',
+                               'precision' => '4',
+                               'nullable' => False
+                       ));
+ 
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.15.012';
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }
  ?>