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

[nomail]

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

date: 2004/05/18 17:53:21;  author: sigurdne;  state: Exp;  lines: +2 -2

Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.17 property/setup/tables.xml:1.1.1.18
--- property/setup/tables.xml:1.1.1.17  Tue May 18 06:19:43 2004
+++ property/setup/tables.xml   Tue May 18 17:53:21 2004
@@ -65,7 +65,7 @@
 
        <table name="fm_tenant">
                <desc>Table desc</desc>
-               <field name="tenant_id" type="I"><descr>A unique ID assigned to 
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+               <field name="id" type="I"><descr>A unique ID assigned to 
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
                <field name="entry_date" type="I"></field>
                <field name="first_name" type="C" size="30"></field>
                <field name="last_name" type="C" size="30"></field>
@@ -1504,7 +1504,7 @@
                <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('workorder', '1000', 'workorder')</query>
                <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('request', '1000', 'request')</query>
 
-               <query>INSERT INTO fm_location_config (location_type, 
column_name, input_text, lookup_form, f_key, ref_to_category, query_value, 
reference_table, reference_id, datatype, precision_, scale, default_value, 
nullable) VALUES (4, 'tenant_id', NULL, 1, 1, NULL, 0, 'fm_tenant', 
'tenant_id', 'int', 4, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_location_config (location_type, 
column_name, input_text, lookup_form, f_key, ref_to_category, query_value, 
reference_table, reference_id, datatype, precision_, scale, default_value, 
nullable) VALUES (4, 'tenant_id', NULL, 1, 1, NULL, 0, 'fm_tenant', 'id', 
'int', 4, NULL, NULL, 'True')</query>
                <query>INSERT INTO fm_location_config (location_type, 
column_name, input_text, lookup_form, f_key, ref_to_category, query_value, 
reference_table, reference_id, datatype, precision_, scale, default_value, 
nullable) VALUES (4, 'street_id', NULL, 1, 1, NULL, 1, 'fm_streetaddress', 
'id', 'int', 4, NULL, NULL, 'True')</query>
                <query>INSERT INTO fm_location_config (location_type, 
column_name, input_text, lookup_form, f_key, ref_to_category, query_value, 
reference_table, reference_id, datatype, precision_, scale, default_value, 
nullable) VALUES (1, 'owner_id', NULL, NULL, 1, 1, NULL, 'fm_owner', 
'owner_id', 'int', 4, NULL, NULL, 'True')</query>
                <query>INSERT INTO fm_location_config (location_type, 
column_name, input_text, lookup_form, f_key, ref_to_category, query_value, 
reference_table, reference_id, datatype, precision_, scale, default_value, 
nullable) VALUES (1, 'part_of_town_id', NULL, NULL, 1, NULL, NULL, 
'fm_part_of_town', 'part_of_town_id', 'int', 0, NULL, NULL, 'True')</query>