[Phpgroupware-cvs] CVS: sitemgr/setup setup.inc.php,1.2,1.3 tables_current.inc.php,1.1.1.1,1.2 tables_update.inc.php,1.1.1.1,1.2

[Patrick Walsh <address@hidden>]

Update of /cvsroot/phpgroupware/sitemgr/setup
In directory subversions:/tmp/cvs-serv31236/setup

Modified Files:
        setup.inc.php tables_current.inc.php tables_update.inc.php 
Log Message:
adding sort_order column to db's


Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/setup/setup.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** setup.inc.php       29 Aug 2002 06:16:13 -0000      1.2
--- setup.inc.php       30 Aug 2002 09:15:23 -0000      1.3
***************
*** 14,18 ****
        $setup_info['sitemgr']['name']      = 'sitemgr';
        $setup_info['sitemgr']['title']     = 'Web Content Manager';
!       $setup_info['sitemgr']['version']   = '0.9.13.001';
        $setup_info['sitemgr']['app_order'] = 8;
        $setup_info['sitemgr']['tables']    = 
array('phpgw_sitemgr_pages','phpgw_sitemgr_categories','phpgw_sitemgr_blocks','phpgw_sitemgr_preferences');
--- 14,18 ----
        $setup_info['sitemgr']['name']      = 'sitemgr';
        $setup_info['sitemgr']['title']     = 'Web Content Manager';
!       $setup_info['sitemgr']['version']   = '0.9.14.001';
        $setup_info['sitemgr']['app_order'] = 8;
        $setup_info['sitemgr']['tables']    = 
array('phpgw_sitemgr_pages','phpgw_sitemgr_categories','phpgw_sitemgr_blocks','phpgw_sitemgr_preferences');

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/setup/tables_current.inc.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** tables_current.inc.php      29 Aug 2002 03:03:17 -0000      1.1.1.1
--- tables_current.inc.php      30 Aug 2002 09:15:23 -0000      1.2
***************
*** 17,20 ****
--- 17,21 ----
                                'page_id' => array('type' => 'auto', 'nullable' 
=> false),
                                'cat_id' => array('type' => 'int', 'precision' 
=> 4),
+                               'sort_order' => array('type' => 'int', 
'precision' => 4),
                                'name' => array('type' => 'varchar', 
'precision' => 100),
                                'title' => array('type' => 'varchar', 
'precision' => 256),
***************
*** 30,33 ****
--- 31,35 ----
                        'fd' => array(
                                'cat_id' => array('type' => 'auto', 'nullable' 
=> false),
+                               'sort_order' => array('type' => 'int', 
'precision' => 4),
                                'name' => array('type' => 'varchar', 
'precision' => 100),
                                'description' => array('type' => 'varchar', 
'precision' => 256)

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/setup/tables_update.inc.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -r1.1.1.1 -r1.2
*** tables_update.inc.php       29 Aug 2002 03:03:17 -0000      1.1.1.1
--- tables_update.inc.php       30 Aug 2002 09:15:23 -0000      1.2
***************
*** 12,14 ****
--- 12,27 ----
        /* $Id$ */
  
+       $test[] = '0.9.13.001';
+       function sitemgr_upgrade0_9_13_001()
+       {
+               global $setup_info,$phpgw_setup;
+               $setup_info['sitemgr']['currentver'] = '0.9.14.001';
+ 
+               $phpgw_setup->oProc->AddColumn('phpgw_sitemgr_pages',
+                       'sort_order',array('type'=>int, 'precision'=>4));
+               $phpgw_setup->oProc->AddColumn('phpgw_sitemgr_categories',
+                       'sort_order',array('type'=>int, 'precision'=>4));
+ 
+               return $setup_info['sitemgr']['currentver'];
+       }
  ?>