[Phpgroupware-cvs] property/setup tables_current.inc.php, 1.142, 1.143 setup.inc.php, 1.61, 1.62

[Sigurd Nes <address@hidden>]

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

Modified Files:
        tables_current.inc.php setup.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.142
retrieving revision 1.143
diff -C2 -d -r1.142 -r1.143
*** tables_current.inc.php      3 Nov 2003 18:03:31 -0000       1.142
--- tables_current.inc.php      6 Nov 2003 18:51:03 -0000       1.143
***************
*** 58,61 ****
--- 58,64 ----
                                'name' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => False),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
***************
*** 460,463 ****
--- 463,469 ----
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'status' => array('type' => 
'varchar','precision' => '10','nullable' => True),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
                                'equipment_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
***************
*** 741,744 ****
--- 747,753 ----
                                'title' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'project_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
***************
*** 849,852 ****
--- 858,864 ----
                                'details' => array('type' => 'text','nullable' 
=> False),
                                'location_code' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'equipment_id' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
***************
*** 1139,1142 ****
--- 1151,1157 ----
                                'descr' => array('type' => 'text','nullable' => 
True),
                                'budget' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
***************
*** 1241,1244 ****
--- 1256,1262 ----
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'status' => array('type' => 
'varchar','precision' => '10','nullable' => True),
+                               'p_num' => array('type' => 
'varchar','precision' => '15','nullable' => True),
+                               'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
***************
*** 1577,1580 ****
--- 1595,1608 ----
                        ),
                        'pk' => array('entity_id','cat_id','attrib_id','id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_entity_lookup' => array(
+                       'fd' => array(
+                               'entity_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'location' => array('type' => 
'varchar','precision' => '30','nullable' => False)
+                       ),
+                       'pk' => array('entity_id','location'),
                        'fk' => array(),
                        'ix' => array(),

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.61
retrieving revision 1.62
diff -C2 -d -r1.61 -r1.62
*** setup.inc.php       18 Oct 2003 22:15:52 -0000      1.61
--- setup.inc.php       6 Nov 2003 18:51:04 -0000       1.62
***************
*** 170,174 ****
                'fm_entity_attribute',
                'fm_entity_category',
!               'fm_entity_choice'
        );
  
--- 170,175 ----
                'fm_entity_attribute',
                'fm_entity_category',
!               'fm_entity_choice',
!               'fm_entity_lookup'
        );