[Phpgroupware-cvs] CVS: property/setup setup.inc.php,1.47,1.48 tables_current.inc.php,1.74,1.75

[Sigurd Nes <address@hidden>]

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

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

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.47
retrieving revision 1.48
diff -C2 -r1.47 -r1.48
*** setup.inc.php       8 May 2003 13:56:29 -0000       1.47
--- setup.inc.php       13 May 2003 09:00:59 -0000      1.48
***************
*** 152,156 ****
                'fm_document_status',
                'fm_submodule',
!               'fm_standard_unit'
        );
  
--- 152,162 ----
                'fm_document_status',
                'fm_submodule',
!               'fm_standard_unit',
!               'fm_report',
!               'fm_report_status',
!               'fm_report_attrib',
!               'fm_report_type',
!               'fm_report_type_attrib',
!               'fm_report_origin'
        );
  

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.74
retrieving revision 1.75
diff -C2 -r1.74 -r1.75
*** tables_current.inc.php      11 May 2003 15:55:09 -0000      1.74
--- tables_current.inc.php      13 May 2003 09:00:59 -0000      1.75
***************
*** 337,344 ****
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','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('entity_id','type_id','attrib_id'),
--- 337,341 ----
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','nullable' => 
True)
                        ),
                        'pk' => array('entity_id','type_id','attrib_id'),
***************
*** 381,388 ****
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','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('entity_id','type_id','attrib_id'),
--- 378,382 ----
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','nullable' => 
True)
                        ),
                        'pk' => array('entity_id','type_id','attrib_id'),
***************
*** 426,433 ****
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','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('location_code','property_type_id','p_type_attrib_id'),
--- 420,424 ----
                                'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
                                'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
!                               't' => array('type' => 'text','nullable' => 
True)
                        ),
                        'pk' => 
array('location_code','property_type_id','p_type_attrib_id'),
***************
*** 1362,1365 ****
--- 1353,1438 ----
                        ),
                        'pk' => array('history_id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_report' => array(
+                       'fd' => array(
+                               'report_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
+                               'report_type_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'title' => array('type' => 
'varchar','precision' => '100','nullable' => True),
+                               'abstract' => array('type' => 
'varchar','precision' => '255','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),
+                               'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => True),
+                               'property_id' => array('type' => 
'varchar','precision' => '4','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'status' => array('type' => 
'varchar','precision' => '10','nullable' => True)
+                       ),
+                       'pk' => array('report_id'),
+                       'fk' => array(),
+                       'ix' => array('location_code','report_id'),
+                       'uc' => array()
+               ),
+               'fm_report_status' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
+                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => False)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_report_attrib' => array(
+                       'fd' => array(
+                               'entity_id' => array('type' => 
'varchar','precision' => '20','nullable' => False),
+                               'type_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
+                               'attrib_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'c' => array('type' => 'varchar','precision' => 
'50','nullable' => True),
+                               'i' => array('type' => 'int','precision' => 
'4','nullable' => True),
+                               'n' => array('type' => 'decimal','precision' => 
'10','scale' => '2','nullable' => True),
+                               'd' => array('type' => 'timestamp','nullable' 
=> True,'default' => 'current_timestamp'),
+                               't' => array('type' => 'text','nullable' => 
True)
+                       ),
+                       'pk' => array('entity_id','type_id','attrib_id'),
+                       'fk' => array(),
+                       'ix' => array('entity_id'),
+                       'uc' => array()
+               ),
+               'fm_report_type' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'name' => array('type' => 'varchar','precision' 
=> '20','nullable' => True),
+                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'prefix' => array('type' => 
'varchar','precision' => '8','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_report_type_attrib' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'type_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
+                               'name' => array('type' => 'varchar','precision' 
=> '20','nullable' => True),
+                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
+                               'datatype' => array('type' => 
'char','precision' => '1','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_report_origin' => array(
+                       'fd' => array(
+                               'origin' => array('type' => 
'varchar','precision' => '10','nullable' => False),
+                               'origin_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'report_id' => array('type' => 
'varchar','precision' => '15','nullable' => False)
+                       ),
+                       'pk' => array('origin','origin_id','report_id'),
                        'fk' => array(),
                        'ix' => array(),