[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.24,1.25

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv15509/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.24
retrieving revision 1.25
diff -C2 -r1.24 -r1.25
*** tables_current.inc.php      21 Jan 2003 17:53:01 -0000      1.24
--- tables_current.inc.php      3 Feb 2003 21:50:22 -0000       1.25
***************
*** 465,468 ****
--- 465,470 ----
                                'rig_addition' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'location_code' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'equipment_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'equipment_type' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
                                'objekt_id' => array('type' => 'varchar', 
'precision' => 4,'nullable' => True),
                                'property_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
***************
*** 513,517 ****
                                'billperae' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
                                'dim_d' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
!                               'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'branch_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'agreement_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
--- 515,519 ----
                                'billperae' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
                                'dim_d' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
!                               'descr' => array('type' => 'text','nullable' => 
True),
                                'branch_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'agreement_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
***************
*** 613,616 ****
--- 615,619 ----
                                'unit' => array('type' => 'varchar', 
'precision' => 6,'nullable' => True),
                                'ns3420_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'tolerance' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'building_part' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'quantity' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True),
***************
*** 808,822 ****
                'phpgw_fm_tts_tickets' => array(
                        'fd' => array(
!                               'ticket_id'             => array('type' => 
'auto', 'nullable' => False),
!                               'ticket_group'          => array('type' => 
'varchar', 'precision' => 40, 'nullable' => True),
!                               'ticket_priority'       => array('type' => 
'int', 'precision' => 2, 'nullable' => False),
!                               'ticket_owner'          => array('type' => 
'varchar', 'precision' => 10, 'nullable' => True),
!                               'ticket_assignedto'     => array('type' => 
'varchar', 'precision' => 10, 'nullable' => True),
!                               'ticket_subject'        => array('type' => 
'varchar', 'precision' => 255, 'nullable' => True),
!                               'ticket_category'       => array('type' => 
'varchar', 'precision' => 25, 'nullable' => True),
!                               'ticket_billable_hours' => array('type' => 
'decimal', 'precision' => 8, 'scale' => 2, 'nullable' => True),
!                               'ticket_billable_rate'  => array('type' => 
'decimal', 'precision' => 8, 'scale' => 2, 'nullable' => True),
!                               'ticket_status'         => array('type' => 
'char','precision' => 1, 'nullable' => False),
!                               'ticket_details'        => array('type' => 
'text','nullable' => False),
                                'objekt_id' => array('type' => 'varchar', 
'precision' => 4,'nullable' => True),
                                'property_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
--- 811,825 ----
                'phpgw_fm_tts_tickets' => array(
                        'fd' => array(
!                               'id'             => array('type' => 'auto', 
'nullable' => False),
!                               'group'          => array('type' => 'varchar', 
'precision' => 40, 'nullable' => True),
!                               'priority'       => array('type' => 'int', 
'precision' => 2, 'nullable' => False),
!                               'owner'          => array('type' => 'varchar', 
'precision' => 10, 'nullable' => True),
!                               'assignedto'     => array('type' => 'varchar', 
'precision' => 10, 'nullable' => True),
!                               'subject'        => array('type' => 'varchar', 
'precision' => 255, 'nullable' => True),
!                               'cat_id'       => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
!                               'billable_hours' => array('type' => 'decimal', 
'precision' => 8, 'scale' => 2, 'nullable' => True),
!                               'billable_rate'  => array('type' => 'decimal', 
'precision' => 8, 'scale' => 2, 'nullable' => True),
!                               'status'         => array('type' => 
'char','precision' => 1, 'nullable' => False),
!                               'details'        => array('type' => 
'text','nullable' => False),
                                'objekt_id' => array('type' => 'varchar', 
'precision' => 4,'nullable' => True),
                                'property_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
***************
*** 831,835 ****
                                'contact_phone' => array('type' => 'varchar', 
'precision' => 12,'nullable' => True)
                        ),
!                       'pk' => array('ticket_id'),
                        'ix' => array(),
                        'fk' => array(),
--- 834,838 ----
                                'contact_phone' => array('type' => 'varchar', 
'precision' => 12,'nullable' => True)
                        ),
!                       'pk' => array('id'),
                        'ix' => array(),
                        'fk' => array(),
***************
*** 1123,1127 ****
                                'invest_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'entity_type' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
!                               'location_code' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'writeoff_year' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
--- 1126,1130 ----
                                'invest_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'entity_type' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
!                               'location_code' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
                                'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'writeoff_year' => array('type' => 'int', 
'precision' => 4,'nullable' => True)