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

[Sigurd Nes <address@hidden>]

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

Modified Files:
        tables_current.inc.php setup.inc.php tables_update.inc.php 
Log Message:
Historical values of buildings

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** tables_current.inc.php      6 Sep 2002 20:33:34 -0000       1.6
--- tables_current.inc.php      7 Sep 2002 00:35:16 -0000       1.7
***************
*** 1040,1043 ****
--- 1040,1058 ----
                        'ix' => array(),
                        'uc' => array()
+               ),
+               'fm_building_value_index' => array(
+                       'fd' => array(
+                               'objekt_id' => array('type' => 
'char','precision' => 4,'default' => 0,'nullable' => False),
+                               'bygg_id' => array('type' => 'char','precision' 
=> 2,'nullable' => False),
+                               'index_count' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
+                               'current_index' => array('type' => 'int', 
'precision' => 2,'nullable' => True),
+                               'this_index' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
+                               'value' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
+                               'date' => array('type' => 'int', 'precision' => 
4,'nullable' => True)
+                       ),
+                       'pk' => array('objekt_id','bygg_id','index_count' ),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
                )
        );

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** setup.inc.php       6 Sep 2002 20:33:34 -0000       1.5
--- setup.inc.php       7 Sep 2002 00:35:16 -0000       1.6
***************
*** 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;
--- 10,14 ----
        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']     = 'Property';
!       $setup_info['property']['version']   = '0.1.1.006';
        $setup_info['property']['app_order'] = 14;
        $setup_info['property']['enable']    = 1;
***************
*** 57,60 ****
--- 57,61 ----
                'fm_wo_chapter',
                'fm_wo_ns3420',
+               'fm_building_value_index',
                'phpgw_fm_tts_tickets',
                'phpgw_fm_tts_views',

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_update.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** tables_update.inc.php       6 Sep 2002 20:33:34 -0000       1.4
--- tables_update.inc.php       7 Sep 2002 00:35:16 -0000       1.5
***************
*** 154,156 ****
--- 154,190 ----
                return $setup_info['property']['currentver'];
        }
+ 
+ 
+       $test[] = '0.1.1.005';
+       function property_upgrade0_1_1_005()
+       {
+               global $setup_info, $phpgw_setup;
+ 
+               $phpgw_setup->oProc->CreateTable(
+                       'fm_building_value_index', array(
+                       'fd' => array(
+                               'objekt_id' => array('type' => 
'char','precision' => 4,'default' => 0,'nullable' => False),
+                               'bygg_id' => array('type' => 'char','precision' 
=> 2,'nullable' => False),
+                               'index_count' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
+                               'current_index' => array('type' => 'int', 
'precision' => 2,'nullable' => True),
+                               'this_index' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
+                               'value' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
+                               'date' => array('type' => 'int', 'precision' => 
4,'nullable' => True)
+                       ),
+                       'pk' => array('objekt_id','bygg_id','index_count' ),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+ 
+                       )
+               );
+ 
+               $setup_info['property']['currentver'] = '0.1.1.006';
+               return $setup_info['property']['currentver'];
+       }
+ 
+ 
+ 
+ 
+ 
  ?>