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

[Patrick Walsh <address@hidden>]

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

Modified Files:
        setup.inc.php tables_current.inc.php tables_update.inc.php 
Log Message:
DB changes to allow for hidden pages and nested categories.


Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/setup/setup.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** setup.inc.php       30 Aug 2002 09:15:23 -0000      1.3
--- setup.inc.php       1 Sep 2002 21:47:35 -0000       1.4
***************
*** 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');
--- 14,18 ----
        $setup_info['sitemgr']['name']      = 'sitemgr';
        $setup_info['sitemgr']['title']     = 'Web Content Manager';
!       $setup_info['sitemgr']['version']   = '0.9.14.002';
        $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.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** tables_current.inc.php      30 Aug 2002 09:15:23 -0000      1.2
--- tables_current.inc.php      1 Sep 2002 21:47:35 -0000       1.3
***************
*** 18,21 ****
--- 18,22 ----
                                'cat_id' => array('type' => 'int', 'precision' 
=> 4),
                                'sort_order' => array('type' => 'int', 
'precision' => 4),
+                               'hide_page' => array('type' => 'int', 
'precision' => 4),
                                'name' => array('type' => 'varchar', 
'precision' => 100),
                                'title' => array('type' => 'varchar', 
'precision' => 256),
***************
*** 32,35 ****
--- 33,37 ----
                                'cat_id' => array('type' => 'auto', 'nullable' 
=> false),
                                'sort_order' => array('type' => 'int', 
'precision' => 4),
+                               'parent' => 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.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** tables_update.inc.php       30 Aug 2002 09:15:23 -0000      1.2
--- tables_update.inc.php       1 Sep 2002 21:47:35 -0000       1.3
***************
*** 25,27 ****
--- 25,40 ----
                return $setup_info['sitemgr']['currentver'];
        }
+       $test[] = '0.9.14.001';
+       function sitemgr_upgrade0_9_14_001()
+       {
+               global $setup_info,$phpgw_setup;
+               $setup_info['sitemgr']['currentver'] = '0.9.14.002';
+ 
+               $phpgw_setup->oProc->AddColumn('phpgw_sitemgr_pages',
+                       'hide_page',array('type'=>int, 'precision'=>4));
+               $phpgw_setup->oProc->AddColumn('phpgw_sitemgr_categories',
+                       'parent',array('type'=>int, 'precision'=>4));
+ 
+               return $setup_info['sitemgr']['currentver'];
+       }
  ?>