fmsystem-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Fmsystem-commits] [17446] property: simplify initial install


From: sigurdne
Subject: [Fmsystem-commits] [17446] property: simplify initial install
Date: Fri, 15 Dec 2017 12:20:41 -0500 (EST)

Revision: 17446
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17446
Author:   sigurdne
Date:     2017-12-15 12:20:40 -0500 (Fri, 15 Dec 2017)
Log Message:
-----------
property: simplify initial install

Modified Paths:
--------------
    trunk/property/setup/default_records.inc.php
    trunk/property/setup/tables_current.inc.php

Modified: trunk/property/setup/default_records.inc.php
===================================================================
--- trunk/property/setup/default_records.inc.php        2017-12-15 16:45:28 UTC 
(rev 17445)
+++ trunk/property/setup/default_records.inc.php        2017-12-15 17:20:40 UTC 
(rev 17446)
@@ -44,13 +44,13 @@
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.invoice', 'Invoice')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.document', 'Documents')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.drawing', 'Drawing')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant) VALUES ({$app_id}, '.entity.1', 'Equipment', 
1)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.1', 'Meter', 1, 1, 
1, 'fm_entity_1_1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.2', 'Elevator', 1, 
1, 1, 'fm_entity_1_2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.3', 'Fire alarm 
central', 1, 1, 1, 'fm_entity_1_3')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant) VALUES ({$app_id}, '.entity.2', 'Report', 
1)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.2.1', 'Report type 
1', 1, 1, 1, 'fm_entity_2_1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.2.2', 'Report type 
2', 1, 1, 1, 'fm_entity_2_2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant) VALUES ({$app_id}, '.entity.1', 'Equipment', 
1)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.1', 'Meter', 1, 1, 
1, 'fm_entity_1_1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.2', 'Elevator', 1, 
1, 1, 'fm_entity_1_2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.1.3', 'Fire alarm 
central', 1, 1, 1, 'fm_entity_1_3')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant) VALUES ({$app_id}, '.entity.2', 'Report', 
1)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.2.1', 'Report type 
1', 1, 1, 1, 'fm_entity_2_1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr, allow_grant, allow_c_function, 
allow_c_attrib,c_attrib_table) VALUES ({$app_id}, '.entity.2.2', 'Report type 
2', 1, 1, 1, 'fm_entity_2_2')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.b_account', 'Budget account')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.tenant_claim', 'Tenant claim')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_locations 
(app_id, name, descr) VALUES ({$app_id}, '.budget', 'Budet')");
@@ -93,7 +93,7 @@
        $GLOBALS['phpgw']->locations->add('.location.exception', 'location 
exception', 'property');
 
        $GLOBALS['phpgw_setup']->oProc->query("DELETE from phpgw_config WHERE 
config_app='property'");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config 
(config_app, config_name, config_value) VALUES ('property','meter_table', 
'fm_entity_1_1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config 
(config_app, config_name, config_value) VALUES ('property','meter_table', 
'fm_entity_1_1')");
 
 #
 #fm_district
@@ -396,11 +396,11 @@
 # Dumping data for table fm_entity
 #
 
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity 
(location_id, id, name, descr, location_form, documentation) VALUES 
({$location_id}, 1, 'Equipment', 'equipment', 1, 1)");
-//$GLOBALS['phpgw_setup']->oProc->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";}')");
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity 
(location_id, id, name, descr, location_form, documentation, lookup_entity) 
VALUES ({$location_id}, 2, 'Report', 'report', 1, NULL, '')");
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity 
(location_id, id, name, descr, location_form, documentation) VALUES 
({$location_id}, 1, 'Equipment', 'equipment', 1, 1)");
+////$GLOBALS['phpgw_setup']->oProc->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";}')");
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity 
(location_id, id, name, descr, location_form, documentation, lookup_entity) 
VALUES ({$location_id}, 2, 'Report', 'report', 1, NULL, '')");
 
 #
 # Dumping data for table fm_entity_category
@@ -408,91 +408,91 @@
 #
 # Dumping data for table fm_entity_attribute
 #
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.1');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 1, 'Meter', 'Meter', NULL, NULL, 
NULL, 3)");
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.1');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 1, 'Meter', 'Meter', NULL, NULL, 
NULL, 3)");
+//
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'category', 'Category', 'Category statustext', 'LB', NULL, 2, 
NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'ext_system_id', 'Ext system id', 'External system id', 'V', 
NULL, 3, NULL, 12, NULL, NULL, 'False')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'maaler_nr', 'Ext meter id', 'External meter id', 'V', NULL, 
4, NULL, 12, NULL, NULL, 'False')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'remark', 'Remark', 'Remark status text', 'T', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 2, 1, 'Tenant power 
meter')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 2, 2, 'Joint power 
meter')");
+//
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.2');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 2, 'Elevator', 'Elevator', 'E', 
NULL, NULL, 3)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
+//
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.3');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 3, 'Fire alarm central', 'Fire alarm 
central', 'F', NULL, NULL, 3)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
+//
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2.1');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 2, 1, 'Report type 1', 'Report type 1', 
'RA', 1, 1, 4)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
+//
+//     $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2.2');
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 2, 2, 'Report type 2', 'Report type 2', 
'RB', 1, 1, 4)");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
+//
+//
+//#
+//# Dumping data for table fm_entity_lookup
+//#
+//
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (1, 'project', 'lookup')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (1, 'ticket', 'lookup')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (2, 'request', 'start')");
+//     $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (2, 'ticket', 'start')");
+//
 
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'category', 'Category', 'Category statustext', 'LB', NULL, 2, 
NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'ext_system_id', 'Ext system id', 'External system id', 'V', 
NULL, 3, NULL, 12, NULL, NULL, 'False')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'maaler_nr', 'Ext meter id', 'External meter id', 'V', NULL, 
4, NULL, 12, NULL, NULL, 'False')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'remark', 'Remark', 'Remark status text', 'T', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 2, 1, 'Tenant power 
meter')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 2, 2, 'Joint power 
meter')");
-
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.2');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 2, 'Elevator', 'Elevator', 'E', 
NULL, NULL, 3)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
-
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.1.3');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 1, 3, 'Fire alarm central', 'Fire alarm 
central', 'F', NULL, NULL, 3)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
-
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2.1');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 2, 1, 'Report type 1', 'Report type 1', 
'RA', 1, 1, 4)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
-
-       $location_id = $GLOBALS['phpgw']->locations->get_id('property', 
'.entity.2.2');
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(location_id, entity_id, id, name, descr, prefix, lookup_tenant, tracking, 
location_level) VALUES ({$location_id}, 2, 2, 'Report type 2', 'Report type 2', 
'RB', 1, 1, 4)");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 1, 'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, 
NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 2, 'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', 
NULL, 2, NULL, 12, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 3, 'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', 
NULL, 3, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 4, 'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', 
NULL, 4, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 5, 'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', 
NULL, 5, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_attribute 
(location_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES 
($location_id, 6, 'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', 
NULL, 6, NULL, NULL, NULL, NULL, 'True')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 1, 'status 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 1, 2, 'status 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 4, 2, 'choice 2')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 1, 'choice 1')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_cust_choice 
(location_id, attrib_id, id, value) VALUES ($location_id, 5, 2, 'choice 2')");
-
-
 #
-# Dumping data for table fm_entity_lookup
-#
-
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (1, 'project', 'lookup')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (1, 'ticket', 'lookup')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (2, 'request', 'start')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (2, 'ticket', 'start')");
-
-
-#
 # Dumping data for table fm_custom
 #
 

Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2017-12-15 16:45:28 UTC (rev 
17445)
+++ trunk/property/setup/tables_current.inc.php 2017-12-15 17:20:40 UTC (rev 
17446)
@@ -2200,7 +2200,7 @@
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
-               ),
+               ),/*
                'fm_entity_1_1' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto', 'precision' => 
'4', 'nullable' => False),
@@ -2352,7 +2352,7 @@
                        'fk' => array(),
                        'ix' => array('location_code'),
                        'uc' => array()
-               ),
+               ),*/
                'fm_custom' => array(
                        'fd' => array(
                                'id' => array('type' => 'int', 'precision' => 
'4', 'nullable' => False),




reply via email to

[Prev in Thread] Current Thread [Next in Thread]