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

[nomail]

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

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

Log Message:
no message
=====================================================================
Index: property/setup/default_records.inc.php
diff -u property/setup/default_records.inc.php:1.1.1.7 
property/setup/default_records.inc.php:1.1.1.8
--- property/setup/default_records.inc.php:1.1.1.7      Fri May 28 21:53:42 2004
+++ property/setup/default_records.inc.php      Sat May 29 23:23:56 2004
@@ -174,6 +174,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.location', 'Location')");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.tenant', 'Tenant')");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.owner', 'Owner')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.vendor', 'Vendor')");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.custom', 'custom queries')");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.project', 'Demand -> Workorder', 1)");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.ticket', 'Helpdesk', 1)");
@@ -235,6 +236,16 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tenant_category (id, 
descr) VALUES (2, 'female')");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tenant_category (id, 
descr) VALUES (3, 'organization')");
 
+
+#
+# Dumping data for table fm_tenant_attribute
+#
+
+$GLOBALS['phpgw_setup']->oProc->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')");
+$GLOBALS['phpgw_setup']->oProc->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')");
+$GLOBALS['phpgw_setup']->oProc->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')");
+
+
 #
 # Dumping data for table fm_ecoart
 #
@@ -290,7 +301,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location4_category (id, 
descr) VALUES (99, 'not active')");
 
 #
-# Dumping data for table `fm_entity`
+# Dumping data for table fm_entity
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity (id, name, descr, 
location_form, documentation) VALUES (1, 'Equipment', 'equipment', 1, 1)");
@@ -298,7 +309,7 @@
 
 
 #
-# Dumping data for table `fm_entity_category`
+# Dumping data for table fm_entity_category
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(entity_id, id, name, descr, prefix, lookup_tenant, tracking, location_level) 
VALUES (1, 1, 'Elevator', 'Elevator', 'E', NULL, NULL, 3)");
@@ -308,7 +319,7 @@
 
 
 #
-# Dumping data for table `fm_entity_attribute`
+# Dumping data for table fm_entity_attribute
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_attribute 
(entity_id, cat_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES (1, 1, 1, 
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
@@ -337,7 +348,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_attribute 
(entity_id, cat_id, id, column_name, input_text, statustext, datatype, list, 
attrib_sort, size, precision_, scale, default_value, nullable) VALUES (2, 2, 6, 
'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, 
NULL, NULL, NULL, 'True')");
 
 #
-# Dumping data for table `fm_entity_choice`
+# Dumping data for table fm_entity_choice
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice 
(entity_id, cat_id, attrib_id, id, value) VALUES (1, 1, 1, 1, 'status 1')");
@@ -366,7 +377,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice 
(entity_id, cat_id, attrib_id, id, value) VALUES (2, 2, 5, 2, 'choice 2')");
 
 #
-# Dumping data for table `fm_entity_lookup`
+# 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')");
@@ -375,7 +386,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup 
(entity_id, location, type) VALUES (2, 'ticket', 'start')");
 
 #
-# Dumping data for table `fm_location_attrib`
+# Dumping data for table fm_location_attrib
 #
 
 $GLOBALS['phpgw_setup']->oProc->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')");
@@ -385,7 +396,7 @@
 
 
 #
-# Dumping data for table `fm_location_choice`
+# Dumping data for table fm_location_choice
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (1, 1, 1, 'OK')");
@@ -398,7 +409,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (4, 1, 2, 'Not Active')");
 
 #
-# Dumping data for table `fm_custom`
+# Dumping data for table fm_custom
 #
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom (id, name, sql) 
VALUES (1, 'test query', 'select * from phpgw_accounts')");