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

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv2757/setup

Modified Files:
        tables_current.inc.php setup.inc.php tables_update.inc.php 
Log Message:
no message

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** tables_current.inc.php      5 Sep 2002 16:48:15 -0000       1.5
--- tables_current.inc.php      6 Sep 2002 20:33:34 -0000       1.6
***************
*** 662,666 ****
                'fm_request' => array(
                        'fd' => array(
!                               'request_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
                                'request_type_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
                                'descr' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
--- 662,666 ----
                'fm_request' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
                                'request_type_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
                                'descr' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
***************
*** 682,688 ****
                                'date' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
                                'cost' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
!                               'status' => array('type' => 'varchar', 
'precision' => 10,'nullable' => True)
                        ),
!                       'pk' => array('request_id'),
                        'fk' => array(),
                        'ix' => array(),
--- 682,707 ----
                                'date' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
                                'cost' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
!                               'status' => array('type' => 'varchar', 
'precision' => 10,'nullable' => True),
!                               'd_safety' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'd_aesthetics' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'd_indoor_climate' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'd_consequential_damage' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'd_user_gratification' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'd_residential_environment' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'p_safety' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'p_aesthetics' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'p_indoor_climate' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'p_consequential_damage' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'p_user_gratification' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'p_residential_environment' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'c_safety' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'c_aesthetics' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'c_indoor_climate' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
!                               'c_consequential_damage' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'c_user_gratification' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'c_residential_environment' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
!                               'authorities_demands' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
                        ),
!                       'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
***************
*** 692,696 ****
                'fm_request_attrib' => array(
                        'fd' => array(
!                               'request_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
                                'request_type_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
                                'r_type_attrib_id' => array('type' => 
'varchar', 'precision' => 20,'nullable' => False),
--- 711,715 ----
                'fm_request_attrib' => array(
                        'fd' => array(
!                               'request_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'request_type_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
                                'r_type_attrib_id' => array('type' => 
'varchar', 'precision' => 20,'nullable' => False),

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** setup.inc.php       5 Sep 2002 16:48:15 -0000       1.4
--- setup.inc.php       6 Sep 2002 20:33:34 -0000       1.5
***************
*** 10,14 ****
        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']     = 'Property';
!       $setup_info['property']['version']   = '0.1.1.004';
        $setup_info['property']['app_order'] = 14;
        $setup_info['property']['enable']    = 1;
--- 10,14 ----
        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']     = 'Property';
!       $setup_info['property']['version']   = '0.1.1.005';
        $setup_info['property']['app_order'] = 14;
        $setup_info['property']['enable']    = 1;

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_update.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** tables_update.inc.php       5 Sep 2002 16:48:15 -0000       1.3
--- tables_update.inc.php       6 Sep 2002 20:33:34 -0000       1.4
***************
*** 111,114 ****
--- 111,115 ----
                return $setup_info['property']['currentver'];
        }
+ 
        $test[] = '0.1.1.003';
        function property_upgrade0_1_1_003()
***************
*** 122,124 ****
--- 123,156 ----
        }
  
+       $test[] = '0.1.1.004';
+       function property_upgrade0_1_1_004()
+       {
+               global $setup_info, $phpgw_setup;
+ 
+               $phpgw_setup->oProc->AddColumn('fm_request','d_safety', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','d_aesthetics', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','d_indoor_climate', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','d_consequential_damage', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','d_user_gratification', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','d_residential_environment', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','p_safety', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','p_aesthetics', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','p_indoor_climate', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','p_consequential_damage', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','p_user_gratification', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','p_residential_environment', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','c_safety', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','c_aesthetics', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               $phpgw_setup->oProc->AddColumn('fm_request','c_indoor_climate', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','c_consequential_damage', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','c_user_gratification', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','c_residential_environment', 
array('type' => 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AddColumn('fm_request','authorities_demands', array('type' 
=> 'int', 'precision' => 2,'nullable' => True));
+               
$phpgw_setup->oProc->AlterColumn('fm_request','descr',array('type' => 
'text','nullable' => False));
+               
$phpgw_setup->oProc->RenameColumn('fm_request','request_id','id');
+               $phpgw_setup->oProc->AlterColumn('fm_request','id',array('type' 
=> 'int','precision' => 4,'nullable' => False));
+ 
+               $setup_info['property']['currentver'] = '0.1.1.005';
+               return $setup_info['property']['currentver'];
+       }
  ?>