[Phpgroupware-cvs] CVS: property/setup setup.inc.php,1.39,1.40 tables_current.inc.php,1.64,1.65

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv30591/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.39
retrieving revision 1.40
diff -C2 -r1.39 -r1.40
*** setup.inc.php       28 Apr 2003 10:26:46 -0000      1.39
--- setup.inc.php       29 Apr 2003 12:20:07 -0000      1.40
***************
*** 140,144 ****
                'fm_idgenerator',
                'fm_document',
!               'fm_document_category'
                'fm_submodule',
                'fm_wo_workorder_history',
--- 140,144 ----
                'fm_idgenerator',
                'fm_document',
!               'fm_document_category',
                'fm_submodule',
                'fm_wo_workorder_history',

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.64
retrieving revision 1.65
diff -C2 -r1.64 -r1.65
*** tables_current.inc.php      28 Apr 2003 10:26:46 -0000      1.64
--- tables_current.inc.php      29 Apr 2003 12:20:07 -0000      1.65
***************
*** 1252,1267 ****
                ),
  
!               'fm_document'=> array(
                        'fd' => array(
!                               'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
!                               'entry_date' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
!                               'category' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
!                               'owner' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
!                               'location_code' => array('type' => 
'varchar','precision' => 50,'nullable' => True),
!                               'equipment_id' => array('type' => 
'varchar','precision' => 50,'nullable' => True),
!                               'title' => array('type' => 
'varchar','precision' => 100,'nullable' => True),
!                               'link_name' => array('type' => 
'varchar','precision' => 50,'nullable' => True),
!                               'link' => array('type' => 'varchar','precision' 
=> 255,'nullable' => True),
!                               'descr' => array('type' => 'text','nullable' => 
True)
                        ),
                        'pk' => array('id'),
--- 1252,1276 ----
                ),
  
! 
!               'fm_document' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
!                               'title' => array('type' => 
'varchar','precision' => '50','nullable' => True),
!                               'document_name' => array('type' => 
'varchar','precision' => '50','nullable' => False),
!                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
!                               'version' => array('type' => 
'varchar','precision' => '10','nullable' => True),
!                               'document_date' => array('type' => 
'int','precision' => '4','nullable' => True),
!                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
!                               'status' => array('type' => 
'varchar','precision' => '10','nullable' => True),
!                               'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
!                               'equipment_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
!                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
!                               'floor_id' => array('type' => 
'varchar','precision' => '8','nullable' => False),
!                               'coordinator' => array('type' => 
'int','precision' => '4','nullable' => True),
!                               'vendor_id' => array('type' => 
'int','precision' => '4','nullable' => True),
!                               'branch_id' => array('type' => 
'int','precision' => '4','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'),
***************
*** 1271,1274 ****
--- 1280,1285 ----
                ),
  
+ 
+ 
                'fm_document_category' => array(
                        'fd' => array(
***************
*** 1358,1361 ****
--- 1369,1388 ----
  
                'fm_drawing_history' => array(
+                       'fd' => array(
+                               'history_id'        => array('type' => 'auto',  
    'precision' => 4,  'nullable' => False),
+                               'history_record_id' => array('type' => 'int',   
    'precision' => 4,  'nullable' => False),
+                               'history_appname'   => array('type' => 
'varchar',   'precision' => 64, 'nullable' => False),
+                               'history_owner'     => array('type' => 'int',   
    'precision' => 4,  'nullable' => False),
+                               'history_status'    => array('type' => 'char',  
    'precision' => 2,  'nullable' => False),
+                               'history_new_value' => array('type' => 'text',  
    'nullable' => False),
+                               'history_timestamp' => array('type' => 
'timestamp', 'nullable' => False, 'default' => 'current_timestamp')
+                       ),
+                       'pk' => array('history_id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+ 
+               'fm_document_history' => array(
                        'fd' => array(
                                'history_id'        => array('type' => 'auto',  
    'precision' => 4,  'nullable' => False),