[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.19,1.20

[Sigurd Nes <address@hidden>]

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

Modified Files:
        tables_current.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.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** tables_current.inc.php      12 Dec 2002 18:15:34 -0000      1.19
--- tables_current.inc.php      13 Dec 2002 18:13:34 -0000      1.20
***************
*** 75,79 ****
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True),
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => True)
                        ),
                        'pk' => array('objekt_id','bygg_id'),
--- 75,79 ----
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True),
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
!                               'property_type_id' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('objekt_id','bygg_id'),
***************
*** 184,188 ****
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
                                'el_meter_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => True)
                        ),
                        'pk' => array('objekt_id','leie_id'),
--- 184,188 ----
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
                                'el_meter_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
!                               'property_type_id' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('objekt_id','leie_id'),
***************
*** 231,235 ****
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True),
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => True)
                        ),
                        'pk' => array('objekt_id'),
--- 231,235 ----
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True),
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
!                               'property_type_id' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('objekt_id'),
***************
*** 262,266 ****
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
                                'el_meter_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => True)
                        ),
                        'pk' => array('objekt_id','bygg_id','seksjons_id'),
--- 262,266 ----
                                'cat_id' => array('type' => 
'varchar','precision' => '32','nullable' => True),
                                'el_meter_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
!                               'property_type_id' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('objekt_id','bygg_id','seksjons_id'),
***************
*** 327,333 ****
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'equipment_type_id' => array('type' => 
'int','precision' => '4','nullable' => False),
!                               'name' => array('type' => 'varchar','precision' 
=> '20','nullable' => True),
!                               'attrib_descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
                                'datatype' => array('type' => 
'char','precision' => '1','nullable' => True)
                        ),
--- 327,333 ----
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'type_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
!                               'num' => array('type' => 'varchar','precision' 
=> '20','nullable' => True),
!                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
                                'datatype' => array('type' => 
'char','precision' => '1','nullable' => True)
                        ),
***************
*** 340,344 ****
                        'fd' => array(
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
                                'property_type_attrib_class_id' => array('type' 
=> 'varchar','precision' => '20','nullable' => True),
                                'p_type_attrib_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
--- 340,344 ----
                        'fd' => array(
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'property_type_id' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'property_type_attrib_class_id' => array('type' 
=> 'varchar','precision' => '20','nullable' => True),
                                'p_type_attrib_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
***************
*** 357,367 ****
                'fm_property_type' => array(
                        'fd' => array(
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'type_descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True)
                        ),
!                       'pk' => array('property_type_id'),
                        'fk' => array(),
                        'ix' => array(),
--- 357,368 ----
                'fm_property_type' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'num' => array('type' => 'varchar','precision' 
=> '50','nullable' => False),
!                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True)
                        ),
!                       'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
***************
*** 370,393 ****
                'fm_property_type_attrib' => array(
                        'fd' => array(
!                               'p_type_attrib_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'property_type_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'property_type_attrib_class_id' => array('type' 
=> 'varchar','precision' => '20','nullable' => True),
!                               'attrib_descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'datatype' => array('type' => 
'char','precision' => '1','nullable' => True)
                        ),
!                       'pk' => array('p_type_attrib_id','property_type_id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'fm_property_type_attrib_class' => array(
                        'fd' => array(
!                               'property_type_attrib_class_id' => array('type' 
=> 'varchar','precision' => '20','nullable' => False),
!                               'type_descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True)
                        ),
!                       'pk' => array('property_type_attrib_class_id'),
                        'fk' => array(),
                        'ix' => array(),
--- 371,396 ----
                'fm_property_type_attrib' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'type_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
!                               'num' => array('type' => 'varchar','precision' 
=> '20','nullable' => True),
!                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'datatype' => array('type' => 
'char','precision' => '1','nullable' => True)
                        ),
!                       'pk' => array('id','property_type_id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
+ 
                'fm_property_type_attrib_class' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'num' => array('type' => 'varchar','precision' 
=> '50','nullable' => False),
!                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True)
                        ),
!                       'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),