[Phpgroupware-cvs] property/setup/default

phpgroupware-cvs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/default_records.inc.php, 1.2

From:	nomail
Subject:	[Phpgroupware-cvs] property/setup/default_records.inc.php, 1.2
Date:	Wed, 2 Jun 2004 20:42:30 +0200
Update of /property/setup
Added Files:
        Branch: 
          default_records.inc.php

date: 2004/06/02 18:42:30;  author: sigurdne;  state: Exp;  lines: +436 -0

Log Message:
no message
=====================================================================
<?php
        
/**************************************************************************\
        * phpGroupWare - property                                               
   *
        * http://www.phpgroupware.org                                           
   *
        *                                                                       
   *
        * Facilities Management                                                 
   *
        * Written by Sigurd Nes [sigurdne at online.no]                         
   *
        * 
------------------------------------------------------------------------ *
        * Copyright 2000 - 2003 Free Software Foundation, Inc                   
   *
        * This program is part of the GNU project, see http://www.gnu.org/      
   *
        * 
------------------------------------------------------------------------ *
        * This program is free software; you can redistribute it and/or modify 
it  *
        * under the terms of the GNU General Public License as published by the 
   *
        * Free Software Foundation; either version 2 of the License, or (at 
your   *
        * option) any later version.                                            
   *
        
\**************************************************************************/

  /* $Id: default_records.inc.php,v 1.2 2004/06/02 18:42:30 sigurdne Exp $ */

#
#fm_workorder_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_category (id, 
descr) VALUES (1, 'Preventive')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_category (id, 
descr) VALUES (2, 'Ad Hoc')");

#
#fm_meter_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_meter_category (id, 
descr) VALUES ('1', 'Power meter')");

#
#fm_district
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_district (id, descr) 
VALUES ('1', 'District 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_district (id, descr) 
VALUES ('2', 'District 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_district (id, descr) 
VALUES ('3', 'District 3')");

#
#fm_part_of_town
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_part_of_town 
(part_of_town_id, name, district_id) VALUES ('1', 'Part of town 1','1')");


#
#fm_owner_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner_category (id, 
descr) VALUES ('1', 'Owner category 1')");

#
#fm_owner
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner (id, abid, 
org_name, category) VALUES (1, 1, 'demo-owner 1',1)");

#
#fm_location1
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location1 ( location_code 
, loc1 , loc1_name , part_of_town_id , entry_date , category ,status, user_id , 
owner_id , remark )VALUES ('5000', '5000', 'Location name', '1', NULL , 
'1','1', '6', '1', 'remark')");

#
#fm_location2
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location2 ( location_code 
, loc1 , loc2 , loc2_name , entry_date , category, status, user_id , remark 
)VALUES ('5000-01', '5000', '01', 'Location name', NULL , '1','1', '6', 
'remark')");

#
# fm_branch
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (1, 'rør', 'rørlegger')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (2, 'maler', 'maler')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (3, 'tomrer', 'Tømrer')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (4, 'renhold', 'Renhold')");

#
# fm_workorder_status
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('active', 'Active')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('ordered', 'Ordered')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('request', 'Request')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('closed', 'Closed')");

#
# fm_request_status
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('request', 'Request')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('canceled', 'Canceled')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('closed', 'avsluttet')");


#
# fm_request_priority_key
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_priority_key (id, 
safety, aesthetics, indoor_climate, consequential_damage, user_gratification, 
residential_environment, authorities_demands) VALUES (0, 12, 3, 4, 5, 6, 2, 
50)");


#
# fm_drawing_status
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_status (id, 
descr) VALUES ('sketch', 'Sketch')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_status (id, 
descr) VALUES ('production', 'Production')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_status (id, 
descr) VALUES ('asbuilt', 'As built')");

#
# fm_drawing_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_category (id, 
descr) VALUES ('1', 'Plane')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_category (id, 
descr) VALUES ('2', 'Cross section')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_drawing_category (id, 
descr) VALUES ('3', 'Facade')");

#
# fm_document_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_category (id, 
descr) VALUES ('1', 'Picture')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_category (id, 
descr) VALUES ('2', 'Report')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_category (id, 
descr) VALUES ('3', 'Instruction')");

#
# fm_tts_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, descr) 
VALUES ('1', 'damage')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, descr) 
VALUES ('2', 'user request')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, descr) 
VALUES ('3', 'warranty')");


#
# fm_document_status
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_status (id, 
descr) VALUES ('draft', 'Draft')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_status (id, 
descr) VALUES ('final', 'Final')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_document_status (id, 
descr) VALUES ('obsolete', 'obsolete')");


#
# fm_standard_unit
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('m', 'Meter')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('m2', 'Square meters')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('m3', 'Cubic meters')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('km', 'Kilometre')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('Stk', 'Stk')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('kg', 'Kilogram')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('tonn', 'Tonn')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('h', 'Hours')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_standard_unit (id, descr) 
VALUES ('RS', 'Round Sum')");


#
#  fm_agreement_status
#
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('closed', 'Closed')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('active', 'Active agreement')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('planning', 'Planning')");

#
#  fm_acl_location
#
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.', 'Top', 1)");
$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)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.pricebook', 'Pricebook')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.invoice', 'Invoice')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.document', 'Documents')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.drawing', 'Drawing')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.meter', 'Meter')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.1', 'Equipment', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.1.1', 'Elevator', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.1.2', 'Fire alarm central', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.2', 'Report', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.2.1', 'Report type 1', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.2.2', 'Report type 2', 1)");


#
#  fm_ns3420
#
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ns3420 (id, tekst1, 
enhet) VALUES ('D00', 'RIGGING, KLARGJØRING', 'RS')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ns3420 (id, tekst1, 
enhet,tekst2) VALUES ('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFØRSEL- OG 
FORSYNINGSANLEGG')");

#
# Data-ark for tabell fm_idgenerator
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('Bilagsnummer', '2003100000', 'Bilagsnummer')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('Ecobatchid', '1', 'Ecobatchid')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('project', '1000', 'project')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('Statuslog', '1', 'Statuslog')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('workorder', '1000', 'workorder')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, value, 
descr) VALUES ('request', '1000', 'request')");

#
# Dumping data for table fm_location_config
#

$GLOBALS['phpgw_setup']->oProc->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')");
$GLOBALS['phpgw_setup']->oProc->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')");
$GLOBALS['phpgw_setup']->oProc->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', 'id', 'int', 4, NULL, NULL, 'True')");
$GLOBALS['phpgw_setup']->oProc->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')");


#
# Dumping data for table fm_location_type
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name, 
descr) VALUES (1, 'property', 'Property')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name, 
descr) VALUES (2, 'building', 'Building')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name, 
descr) VALUES (3, 'entrance', 'Entrance')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name, 
descr) VALUES (4, 'apartment', 'Apartment')");


#
# Dumping data for table fm_tenant_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tenant_category (id, 
descr) VALUES (1, 'male')");
$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, 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')");
$GLOBALS['phpgw_setup']->oProc->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')");
$GLOBALS['phpgw_setup']->oProc->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')");


#
# Dumping data for table fm_ecoart
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecoart (id, name, 
description) VALUES (1, 'faktura', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecoart (id, name, 
description) VALUES (2, 'kreditnota', NULL)");


#
# Dumping data for table fm_ecobilagtype
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecobilagtype (id, name, 
description) VALUES (1, 'Drift, vedlikehold', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecobilagtype (id, name, 
description) VALUES (2, 'Prosjekt, Kontrakt', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecobilagtype (id, name, 
description) VALUES (3, 'Prosjekt, Tillegg', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecobilagtype (id, name, 
description) VALUES (4, 'Prosjekt, LP-stign', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecobilagtype (id, name, 
description) VALUES (5, 'Adminstrasjon', NULL)");

#
# Dumping data for table fm_ecomva
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (2, 'Mva 2', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (1, 'Mva 1', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (0, 'ingen', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (3, 'Mva 3', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (4, 'Mva 4', NULL)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ecomva (id, name, 
description) VALUES (5, 'Mva 5', 'Renhold')");

#
# Dumping data for table fm_location1_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location1_category (id, 
descr) VALUES (1, 'SOMETHING')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location1_category (id, 
descr) VALUES (99, 'not active')");
#
# Dumping data for table fm_location2_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location2_category (id, 
descr) VALUES (1, 'SOMETHING')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location2_category (id, 
descr) VALUES (99, 'not active')");
#
# Dumping data for table fm_location3_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location3_category (id, 
descr) VALUES (1, 'SOMETHING')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location3_category (id, 
descr) VALUES (99, 'not active')");
#
# Dumping data for table fm_location4_category
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location4_category (id, 
descr) VALUES (1, 'SOMETHING')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location4_category (id, 
descr) VALUES (99, 'not active')");

#
# 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)");
//$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";}')");


#
# 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)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(entity_id, id, name, descr, prefix, lookup_tenant, tracking, location_level) 
VALUES (1, 2, 'Fire alarm central', 'Fire alarm central', 'F', NULL, NULL, 3)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(entity_id, id, name, descr, prefix, lookup_tenant, tracking, location_level) 
VALUES (2, 1, 'Report type 1', 'Report type 1', 'RA', 1, 1, 4)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_category 
(entity_id, id, name, descr, prefix, lookup_tenant, tracking, location_level) 
VALUES (2, 2, 'Report type 2', 'Report type 2', 'RB', 1, 1, 4)");


#
# 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')");
$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, 2, 
'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, 
NULL, NULL, 'True')");
$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, 3, 
'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, 
NULL, NULL, NULL, 'True')");
$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, 4, 
'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, 
NULL, NULL, NULL, 'True')");
$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, 5, 
'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
$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, 6, 
'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, 
NULL, NULL, NULL, 'True')");
$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, 2, 1, 
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
$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, 2, 2, 
'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, 
NULL, NULL, 'True')");
$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, 2, 3, 
'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, 
NULL, NULL, NULL, 'True')");
$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, 2, 4, 
'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, 
NULL, NULL, NULL, 'True')");
$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, 2, 5, 
'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
$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, 2, 6, 
'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, 
NULL, NULL, NULL, 'True')");
$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, 1, 1, 
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
$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, 1, 2, 
'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, 
NULL, NULL, 'True')");
$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, 1, 3, 
'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, 
NULL, NULL, NULL, 'True')");
$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, 1, 4, 
'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, 
NULL, NULL, NULL, 'True')");
$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, 1, 5, 
'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
$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, 1, 6, 
'attribute5', 'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, 
NULL, NULL, NULL, 'True')");
$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, 1, 
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
$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, 2, 
'attribute1', 'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, 
NULL, NULL, 'True')");
$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, 3, 
'attribute2', 'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, 
NULL, NULL, NULL, 'True')");
$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, 4, 
'attribute3', 'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, 
NULL, NULL, NULL, 'True')");
$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, 5, 
'attribute4', 'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, 
NULL, NULL, NULL, 'True')");
$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
#

$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')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 1, 1, 2, 'status 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 1, 4, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 1, 4, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 1, 5, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 1, 5, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 1, 1, 'status 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 1, 2, 'status 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 4, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 4, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 5, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (1, 2, 5, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 1, 1, 'status 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 1, 2, 'status 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 4, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 4, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 5, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 1, 5, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 2, 1, 1, 'status 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 2, 1, 2, 'status 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 2, 4, 1, 'choice 1')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 2, 4, 2, 'choice 2')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_choice (entity_id, 
cat_id, attrib_id, id, value) VALUES (2, 2, 5, 1, 'choice 1')");
$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
#

$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_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')");
$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 (2, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
$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 (3, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
$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 (4, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");


#
# 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')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (1, 1, 2, 'Not Active')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (2, 1, 1, 'OK')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (2, 1, 2, 'Not Active')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (3, 1, 1, 'OK')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (3, 1, 2, 'Not Active')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice ( 
type_id, attrib_id, id, value) VALUES (4, 1, 1, 'OK')");
$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
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom (id, name, sql) 
VALUES (1, 'test query', 'select * from phpgw_accounts')");

#
# Dumping data for table fm_custom_cols
#

$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom_cols (custom_id, 
id, name, descr, sorting) VALUES (1, 1, 'account_id', 'ID', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom_cols (custom_id, 
id, name, descr, sorting) VALUES (1, 2, 'account_lid', 'Lid', 2)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom_cols (custom_id, 
id, name, descr, sorting) VALUES (1, 3, 'account_firstname', 'First Name', 3)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_custom_cols (custom_id, 
id, name, descr, sorting) VALUES (1, 4, 'account_lastname', 'Last Name', 4)");


#
# Dumping data for table fm_vendor_attribute
#

$GLOBALS['phpgw_setup']->oProc->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)");
$GLOBALS['phpgw_setup']->oProc->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)");
$GLOBALS['phpgw_setup']->oProc->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)");


?>
[Prev in Thread]
Current Thread
[Next in Thread]
[Phpgroupware-cvs] property/setup/default_records.inc.php, 1.2, nomail <=
Prev by Date: [Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.2
Next by Date: [Phpgroupware-cvs] property/setup/phpgw_en.lang, 1.2
Previous by thread: [Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.2
Next by thread: [Phpgroupware-cvs] property/setup/phpgw_en.lang, 1.2
Index(es):
- Date
- Thread