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

[Brian Morel <address@hidden>]

Update of /cvsroot/phpgroupware/cdb/setup
In directory subversions:/tmp/cvs-serv24069

Modified Files:
        tables_update.inc.php tables_current.inc.php setup.inc.php 
Log Message:
updates for new tables

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/setup/tables_update.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** tables_update.inc.php       22 Feb 2002 03:10:57 -0000      1.2
--- tables_update.inc.php       1 Mar 2002 21:13:51 -0000       1.3
***************
*** 77,79 ****
--- 77,142 ----
                return $GLOBALS['setup_info']['cdb']['currentver'];
        }
+ 
+       $test[] = '0.9.13.003';
+       function cdb_upgrade0_9_13_003()
+       {
+               
+               $GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_cdb_views', 
+                       array(
+                               'fd' => array(
+                                       'view_id' => array('type' => 'auto'),
+                                       'cache_date' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                                       'owner' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                                       'group_owner' => array('type' => 
'varchar', 'precision' => 255,'nullable' => False),
+                                       'public' => array('type' => 'char', 
'precision' => 32,'nullable' => False),
+                                       'name' => array('type' => 'varchar', 
'precision' => 30,'nullable' => False),
+                                       'type' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                                       'view_fields' => array('type' => 
'varchar', 'precision' => 255,'nullable' => False),
+                                       'view_filter' => array('type' => 
'text','nullable' => False, 'default' => ''),
+                                       'sort' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False),
+                                       'view_group' => array('type' => 
'varchar', 'precision' => 100,'nullable' => False)
+                               ),
+                               'pk' => array('view_id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+ 
+               $GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_cdb_recent', 
+                       array(
+                               'fd' => array(
+                                       'account_id' => array('type' => 'auto'),
+                                       'orgs' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
+                                       'contacts' => array('type' => 
'varchar', 'precision' => 20,'nullable' => False),
+                                       'views' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False)
+                               ),
+                               'pk' => array('account_id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+ 
+               $newtbldef = array(
+                       'fd' => array(
+                               'category_link_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                               'category_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                               'entity_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0')
+                               
+                       ),
+                       'pk' => array('category_link_id'),
+                       'fk' => array(),
+                       'ix' => array('entity_id', 'category_id', 
'contact_type'),
+                       'uc' => array()
+               );
+               
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_cdb_category_link', 
$newtbldef, 'contact_type');
+               
+               $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cdb_org', 
'main_location', array('type' => 'int', 'precision' => 4,'nullable' => False) );
+ 
+               $GLOBALS['setup_info']['cdb']['currentver'] = '0.9.13.003';
+               return $GLOBALS['setup_info']['cdb']['currentver'];
+       }
+ 
+               
  ?>

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/setup/tables_current.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** tables_current.inc.php      21 Feb 2002 12:41:48 -0000      1.3
--- tables_current.inc.php      1 Mar 2002 21:13:51 -0000       1.4
***************
*** 89,93 ****
                                'organization_home_page' => array('type' => 
'text','nullable' => False),
                                'organization_network_name' => array('type' => 
'varchar', 'precision' => 100,'nullable' => False),
!                               'organization_gov_id_num' => array('type' => 
'varchar', 'precision' => 20,'nullable' => False)
                        ),
                        'pk' => array('organization_id'),
--- 89,94 ----
                                'organization_home_page' => array('type' => 
'text','nullable' => False),
                                'organization_network_name' => array('type' => 
'varchar', 'precision' => 100,'nullable' => False),
!                               'organization_gov_id_num' => array('type' => 
'varchar', 'precision' => 20,'nullable' => False),
!                               'main_location' => array('type' => 'int', 
'precision' => 4,'nullable' => False)
                        ),
                        'pk' => array('organization_id'),
***************
*** 207,212 ****
                                'category_link_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
                                'category_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
!                               'entity_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
!                               'contact_type' => array('type' => 'char', 
'precision' => 32,'nullable' => False,'default' => 'individual')
                        ),
                        'pk' => array('category_link_id'),
--- 208,213 ----
                                'category_link_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
                                'category_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
!                               'entity_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0')
!                               
                        ),
                        'pk' => array('category_link_id'),
***************
*** 315,318 ****
--- 316,350 ----
                        'fk' => array(),
                        'ix' => array('contact_id', 'address_category_id'),
+                       'uc' => array()
+               ),
+               'phpgw_cdb_views' => array(
+                       'fd' => array(
+                               'view_id' => array('type' => 'auto'),
+                               'cache_date' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
+                               'owner' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
+                               'group_owner' => array('type' => 'varchar', 
'precision' => 255,'nullable' => False),
+                               'public' => array('type' => 'char', 'precision' 
=> 32,'nullable' => False),
+                               'name' => array('type' => 'varchar', 
'precision' => 30,'nullable' => False),
+                               'type' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
+                               'view_fields' => array('type' => 'varchar', 
'precision' => 255,'nullable' => False),
+                               'view_filter' => array('type' => 
'text','nullable' => False),
+                               'sort' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False),
+                               'view_group' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False)
+                       ),
+                       'pk' => array('view_id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'phpgw_cdb_recent' => array(
+                       'fd' => array(
+                               'account_id' => array('type' => 'auto'),
+                               'orgs' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
+                               'contacts' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
+                               'views' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False)
+                       ),
+                       'pk' => array('account_id'),
+                       'fk' => array(),
+                       'ix' => array(),
                        'uc' => array()
                )

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/cdb/setup/setup.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** setup.inc.php       20 Feb 2002 22:14:35 -0000      1.4
--- setup.inc.php       1 Mar 2002 21:13:51 -0000       1.5
***************
*** 15,19 ****
        $setup_info['cdb']['name']      = 'cdb';
        $setup_info['cdb']['title']     = 'CDB';
!       $setup_info['cdb']['version']   = '0.9.13.003';
        $setup_info['cdb']['app_order'] = 4;
        $setup_info['cdb']['enable']    = 1;
--- 15,19 ----
        $setup_info['cdb']['name']      = 'cdb';
        $setup_info['cdb']['title']     = 'CDB';
!       $setup_info['cdb']['version']   = '0.9.13.004';
        $setup_info['cdb']['app_order'] = 4;
        $setup_info['cdb']['enable']    = 1;
***************
*** 42,46 ****
                'phpgw_cdb_contact_internet',
                'phpgw_cdb_contact_addr_cat',
!               'phpgw_cdb_contact_addr'
        );
  
--- 42,48 ----
                'phpgw_cdb_contact_internet',
                'phpgw_cdb_contact_addr_cat',
!               'phpgw_cdb_contact_addr',
!               'phpgw_cdb_views',
!               'phpgw_cdb_recent'
        );