[Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.12

[nomail]

Update of /property/setup
Modified Files:
        Branch: 
          tables_current.inc.php

date: 2004/08/20 15:15:21;  author: sigurdne;  state: Exp;  lines: +67 -6

Log Message:
no message
=====================================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.11 
property/setup/tables_current.inc.php:1.12
--- property/setup/tables_current.inc.php:1.11  Thu Aug 12 18:56:23 2004
+++ property/setup/tables_current.inc.php       Fri Aug 20 15:15:21 2004
@@ -590,14 +590,14 @@
                                '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)
+                               'agreement_group_id' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
-               'fm_agreement' => array(
+               'fm_agreement_group' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
                                'num' => array('type' => 'varchar','precision' 
=> '25','nullable' => False),
@@ -609,6 +609,26 @@
                        'ix' => array(),
                        'uc' => array()
                ),
+               'fm_agreement' => array(
+                       'fd' => array(
+                               'group_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'vendor_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'name' => array('type' => 'varchar','precision' 
=> '100','nullable' => False),
+                               'descr' => array('type' => 'text','nullable' => 
True),
+                               'status' => array('type' => 
'varchar','precision' => '10','nullable' => True)
+                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'start_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'end_date' => array('type' => 'int','precision' 
=> '4','nullable' => True),
+                               'termination_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'category' => array('type' => 'int','precision' 
=> '4','nullable' => True),
+                               'user_id' => array('type' => 'int','precision' 
=> '4','nullable' => True)
+                       ),
+                       'pk' => array('group_id','id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
                'fm_agreement_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
@@ -619,19 +639,60 @@
                        'ix' => array(),
                        'uc' => array()
                ),
+
+               'fm_agreement_attribute' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int', 'precision' => 
4,'nullable' => False,'default' => '0'),
+                               'attrib_detail' => array('type' => 'int', 
'precision' => 2,'nullable' => False,'default' => '0'),
+                               'list' => array('type' => 'int', 'precision' => 
2,'nullable' => True),
+                               'location_form' => array('type' => 'int', 
'precision' => 2,'nullable' => True),
+                               'lookup_form' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
+                               'column_name' => array('type' => 'varchar', 
'precision' => 20,'nullable' => False),
+                               'input_text' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
+                               'statustext' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False),
+                               'size' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
+                               'datatype' => array('type' => 'varchar', 
'precision' => 10,'nullable' => False),
+                               'attrib_sort' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
+                               'precision_' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
+                               'scale' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
+                               'default_value' => array('type' => 'varchar', 
'precision' => 18,'nullable' => True),
+                               'nullable' => array('type' => 'varchar', 
'precision' => 5,'nullable' => False,'default' => 'True'),
+                               'search' => array('type' => 'int', 'precision' 
=> 2,'nullable' => True)
+                       ),
+                       'pk' => array('id','attrib_detail'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+
+               'fm_agreement_choice' => array(
+                       'fd' => array(
+                               'attrib_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '0'),
+                               'id' => array('type' => 'int', 'precision' => 
4,'nullable' => False,'default' => '0'),
+                               'value' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
+                               'attrib_detail' => array('type' => 'int', 
'precision' => 2,'nullable' => False,'default' => '0')
+                       ),
+                       'pk' => array('attrib_id','id','attrib_detail'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+
                'fm_activity_price_index' => array(
                        'fd' => array(
                                'activity_id' => array('type' => 
'int','precision' => '4','nullable' => False),
-                               'vendor_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'agreement_id' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'index_count' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'current_index' => array('type' => 
'int','precision' => '2','nullable' => True),
                                'this_index' => array('type' => 
'decimal','precision' => '20','scale' => '4','nullable' => True,'default' => 
'0.00'),
                                'm_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
                                'w_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
                                'total_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
-                               'date' => array('type' => 'int','precision' => 
'4','nullable' => True)
+                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'date' => array('type' => 'int','precision' => 
'4','nullable' => True),
+                               'user_id' => array('type' => 'int','precision' 
=> '4','nullable' => True)
                        ),
-                       'pk' => array('activity_id','vendor_id','index_count'),
+                       'pk' => 
array('activity_id','agreement_id','index_count'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()