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

[nomail]

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

date: 2004/05/29 23:23:56;  author: sigurdne;  state: Exp;  lines: +56 -18

Log Message:
no message
=====================================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.1.1.7 
property/setup/tables_current.inc.php:1.1.1.8
--- property/setup/tables_current.inc.php:1.1.1.7       Fri May 28 13:06:40 2004
+++ property/setup/tables_current.inc.php       Sat May 29 23:23:56 2004
@@ -105,19 +105,10 @@
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
-                               'first_name' => array('type' => 
'char','precision' => '30','nullable' => True),
-                               'last_name' => array('type' => 
'char','precision' => '30','nullable' => True),
+                               'first_name' => array('type' => 
'varchar','precision' => '30','nullable' => True),
+                               'last_name' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
-                               'category' => array('type' => 'int','precision' 
=> '2','nullable' => True),
-                               'Flytte_ID' => array('type' => 
'int','precision' => '2','nullable' => True),
-                               'status_eco' => array('type' => 
'char','precision' => '2','nullable' => True),
-                               'status_drift' => array('type' => 
'char','precision' => '2','nullable' => True),
-                               'KontraktTilDato' => array('type' => 
'char','precision' => '50','nullable' => True),
-                               'Fornyelseskode' => array('type' => 
'int','precision' => '2','nullable' => True),
-                               'Undernivaa' => array('type' => 
'int','precision' => '2','nullable' => True),
-                               'Fornyelseskommentar' => array('type' => 
'char','precision' => '150','nullable' => True),
-                               'AntallNklUtlevert' => array('type' => 
'int','precision' => '2','nullable' => True),
-                               'AntallNklInnlevert' => array('type' => 
'int','precision' => '2','nullable' => True)
+                               'category' => array('type' => 'int','precision' 
=> '2','nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
@@ -134,11 +125,22 @@
                        'ix' => array(),
                        'uc' => array()
                ),
-               'fm_tenant_status' => array(
+               'fm_tenant_attribute' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
-                               'type' => array('type' => 'char','precision' => 
'1','nullable' => False),
-                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => False)
+                               'column_name' => array('type' => 
'varchar','precision' => '20','nullable' => False),
+                               'input_text' => array('type' => 
'varchar','precision' => '20','nullable' => False),
+                               'list' => array('type' => 'int','precision' => 
'2','nullable' => True),
+                               'location_form' => array('type' => 
'int','precision' => '2','nullable' => True),
+                               'lookup_form' => array('type' => 
'int','precision' => '2','nullable' => True),
+                               'statustext' => array('type' => 
'varchar','precision' => '100','nullable' => False),
+                               'size' => array('type' => 'int','precision' => 
'4','nullable' => True),
+                               'datatype' => array('type' => 
'varchar','precision' => '10','nullable' => True),
+                               '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' => '20','nullable' => True),
+                               'nullable' => array('type' => 
'varchar','precision' => '5','nullable' => False,'default' => 'True')
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
@@ -146,7 +148,43 @@
                        'uc' => array()
                ),
 
-               'fm_tenant_attribute' => array(
+               'fm_tenant_choice' => array(
+                       'fd' => array(
+                               'attrib_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'value' => array('type' => 'text','nullable' => 
False)
+                       ),
+                       'pk' => array('attrib_id','id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+
+               'fm_vendor' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
+                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'org_name' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'email' => array('type' => 
'varchar','precision' => '64','nullable' => True),
+                               'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
+                               'category' => array('type' => 'int','precision' 
=> '2','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_vendor_category' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => False)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_vendor_attribute' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
                                'column_name' => array('type' => 
'varchar','precision' => '20','nullable' => False),
@@ -169,7 +207,7 @@
                        'uc' => array()
                ),
 
-               'fm_tenant_choice' => array(
+               'fm_vendor_choice' => array(
                        'fd' => array(
                                'attrib_id' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),