[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.21

[nomail]

Update of /property/setup
Modified Files:
        Branch: 
          tables.xml

date: 2004/06/01 13:06:22;  author: sigurdne;  state: Exp;  lines: +8 -5

Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.20 property/setup/tables.xml:1.1.1.21
--- property/setup/tables.xml:1.1.1.20  Sun May 30 12:27:32 2004
+++ property/setup/tables.xml   Tue Jun  1 13:06:22 2004
@@ -123,6 +123,7 @@
                <field name="first_name" type="C" size="30"></field>
                <field name="last_name" type="C" size="30"></field>
                <field name="contact_phone" type="C" size="20"></field>
+               <field name="klasse" type="C" size="10"></field>
                <field name="category" type="I"></field>
        </table>
 
@@ -1219,7 +1220,7 @@
                <field name="column_name" type="C" size="20"><NOTNULL/></field>
                <field name="input_text" type="C" size="50"><NOTNULL/></field>
                <field name="statustext" type="C" size="150"><NOTNULL/></field>
-               <field name="datatype" type="C" size="2"><NOTNULL/></field>
+               <field name="datatype" type="C" size="10"><NOTNULL/></field>
                <field name="list" type="I"></field>
                <field name="attrib_sort" type="I"></field>
                <field name="size" type="I"></field>
@@ -1603,9 +1604,9 @@
                <query>INSERT INTO fm_tenant_category (id, descr) VALUES (2, 
'female')</query>
                <query>INSERT INTO fm_tenant_category (id, descr) VALUES (3, 
'organization')</query>
 
-               <query>INSERT INTO fm_tenant_attribute (id, list, 
location_form, lookup_form, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (1, 
NULL, NULL, NULL, 'first_name', 'First name', 'First name', NULL, 'V', 1, 50, 
NULL, NULL, 'True')</query>
-               <query>INSERT INTO fm_tenant_attribute (id, list, 
location_form, lookup_form, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (2, 
NULL, NULL, NULL, 'last_name', 'Last name', 'Last name', NULL, 'V', 2, 50, 
NULL, NULL, 'True')</query>
-               <query>INSERT INTO fm_tenant_attribute (id, list, 
location_form, lookup_form, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (3, 
NULL, NULL, NULL, 'contact_phone', 'contact phone', 'contact phone', NULL, 'V', 
3, 20, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_tenant_attribute (id, list, search, 
lookup_form, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable) VALUES (1, 1, 1, NULL, 
'first_name', 'First name', 'First name', NULL, 'V', 1, 50, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_tenant_attribute (id, list, search, 
lookup_form, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable) VALUES (2, 1, 1, NULL, 'last_name', 
'Last name', 'Last name', NULL, 'V', 2, 50, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_tenant_attribute (id, list, search, 
lookup_form, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable) VALUES (3, 1, 1, NULL, 
'contact_phone', 'contact phone', 'contact phone', NULL, 'V', 3, 20, NULL, 
NULL, 'True')</query>
 
                <query>INSERT INTO fm_ecoart (id, name) VALUES (1, 
'faktura')</query>
                <query>INSERT INTO fm_ecoart (id, name) VALUES (2, 
'kreditnota')</query>
@@ -1720,6 +1721,8 @@
                <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr, 
sorting) VALUES (1, 3, 'account_firstname', 'First Name', 3)</query>
                <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr, 
sorting) VALUES (1, 4, 'account_lastname', 'Last Name', 4)</query>
 
-               
+               <query>INSERT INTO fm_vendor_attribute (id, list, column_name, 
input_text, statustext, size, datatype, attrib_sort, precision_, scale, 
default_value, nullable, search) VALUES (1, 1, 'org_name', 'Name', 'The Name of 
the vendor', NULL, 'V', 1, 50, NULL, NULL, 'True', 1)</query>
+               <query>INSERT INTO fm_vendor_attribute (id, list, column_name, 
input_text, statustext, size, datatype, attrib_sort, precision_, scale, 
default_value, nullable, search) VALUES (2, 1, 'contact_phone', 'Contact 
phone', 'Contact phone', NULL, 'V', 2, 20, NULL, NULL, 'True', 1)</query>
+               <query>INSERT INTO fm_vendor_attribute (id, list, column_name, 
input_text, statustext, size, datatype, attrib_sort, precision_, scale, 
default_value, nullable, search) VALUES (3, 1, 'email', 'email', 'email', NULL, 
'email', 3, 64, NULL, NULL, 'True', 1)</query>
        </sql>  
 </schema>