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

[nomail]

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

date: 2004/04/28 09:37:10;  author: sigurdne;  state: Exp;  lines: +21 -21

Log Message:
pgsql insert problem - at least for cygwin - ok for mysql
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.4 property/setup/tables.xml:1.1.1.5
--- property/setup/tables.xml:1.1.1.4   Wed Apr 28 08:00:39 2004
+++ property/setup/tables.xml   Wed Apr 28 09:37:10 2004
@@ -1394,23 +1394,23 @@
                <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_ecoart (id, name, description) VALUES (1, 
'faktura', NULL)</query>
-               <query>INSERT INTO fm_ecoart (id, name, description) VALUES (2, 
'kreditnota', NULL)</query>
+               <query>INSERT INTO fm_ecoart (id, name) VALUES (1, 
'faktura')</query>
+               <query>INSERT INTO fm_ecoart (id, name) VALUES (2, 
'kreditnota')</query>
 
-               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (1, 'Drift, vedlikehold', NULL)</query>
-               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (2, 'Prosjekt, Kontrakt', NULL)</query>
-               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (3, 'Prosjekt, Tillegg', NULL)</query>
-               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (4, 'Prosjekt, LP-stign', NULL)</query>
-               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (5, 'Adminstrasjon', NULL)</query>
-
-               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (2, 
'Mva 2', NULL)</query>
-               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (1, 
'Mva 1', NULL)</query>
-               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (0, 
'ingen', NULL)</query>
-               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (3, 
'Mva 3', NULL)</query>
-               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (4, 
'Mva 4', NULL)</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name) VALUES (1, 
'Drift, vedlikehold')</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name) VALUES (2, 
'Prosjekt, Kontrakt')</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name) VALUES (3, 
'Prosjekt, Tillegg')</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name) VALUES (4, 
'Prosjekt, LP-stign')</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name) VALUES (5, 
'Adminstrasjon')</query>
+
+               <query>INSERT INTO fm_ecomva (id, name) VALUES (2, 'Mva 
2')</query>
+               <query>INSERT INTO fm_ecomva (id, name) VALUES (1, 'Mva 
1')</query>
+               <query>INSERT INTO fm_ecomva (id, name) VALUES (0, 
'ingen')</query>
+               <query>INSERT INTO fm_ecomva (id, name) VALUES (3, 'Mva 
3')</query>
+               <query>INSERT INTO fm_ecomva (id, name) VALUES (4, 'Mva 
4')</query>
                <query>INSERT INTO fm_ecomva (id, name, description) VALUES (5, 
'Mva 5', 'Renhold')</query>
 
-               <query>INSERT INTO fm_location1_category (id, descr) VALUES (1, 
'SOMETHING')</query>
+       <!--    <query>INSERT INTO fm_location1_category (id, descr) VALUES (1, 
'SOMETHING')</query>
                <query>INSERT INTO fm_location1_category (id, descr) VALUES 
(99, 'not active')</query>
 
                <query>INSERT INTO fm_location2_category (id, descr) VALUES (1, 
'SOMETHING')</query>
@@ -1422,7 +1422,7 @@
                <query>INSERT INTO fm_location4_category (id, descr) VALUES (1, 
'SOMETHING')</query>
                <query>INSERT INTO fm_location4_category (id, descr) VALUES 
(99, 'not active')</query>
 
-               <query>INSERT INTO fm_entity (id, name, descr, location_form, 
documentation) VALUES (1, 'Equipment', 'equipment', 1, 1)</query>
+               <query>INSERT INTO fm_entity (id, name, descr, location_form, 
documentation) VALUES (1, 'Equipment', 'equipment', 1, 1)</query>-->
         
        <!--    <query>INSERT INTO fm_entity (id, name, descr, location_form, 
documentation, lookup_entity) VALUES (2, 'Report', 'report', 1, NULL, 
'a:1:{i:0;s:1:"1";}')</query>-->
 
@@ -1481,23 +1481,23 @@
                <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 5, 1, 'choice 1')</query>
                <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 5, 2, 'choice 2')</query>
 
-               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (1, 'project', 'lookup')</query>
+       <!--    <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (1, 'project', 'lookup')</query>
                <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (1, 'ticket', 'lookup')</query>
                <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (2, 'request', 'start')</query>
-               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (2, 'ticket', 'start')</query>
+               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (2, 'ticket', 'start')</query>-->
 
-               <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+       <!--    <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
                <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
                <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (3, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
-               <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (4, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_location_attrib ( type_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (4, 1, 'status', 'Status', 
'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>-->
 
-               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (1, 1, 1, 'OK')</query>
+       <!--    <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (1, 1, 1, 'OK')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (1, 1, 2, 'Not Active')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (2, 1, 1, 'OK')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (2, 1, 2, 'Not Active')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (3, 1, 1, 'OK')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (3, 1, 2, 'Not Active')</query>
                <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (4, 1, 1, 'OK')</query>
-               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (4, 1, 2, 'Not Active')</query>
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (4, 1, 2, 'Not Active')</query>-->
        </sql>  
 </schema>