[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.19,1.20
From: |
Sigurd Nes <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.19,1.20 setup.inc.php,1.52,1.53 tables_current.inc.php,1.87,1.88 |
Date: |
Fri, 13 Jun 2003 07:05:32 -0400 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv2715/setup
Modified Files:
default_records.inc.php setup.inc.php tables_current.inc.php
Log Message:
no message
Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/default_records.inc.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** default_records.inc.php 15 May 2003 09:08:02 -0000 1.19
--- default_records.inc.php 13 Jun 2003 11:05:30 -0000 1.20
***************
*** 156,158 ****
--- 156,178 ----
$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_name, lookup_form, f_key, ref_to_category,
query_value, reference_table, datatype, precision_, scale, default_value,
nullable) VALUES (4, 'tenant_id', NULL, 1, 1, NULL, 0, 'fm_tenant', 'int', 4,
NULL, NULL, 'True')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_config
(location_type, column_name, input_name, lookup_form, f_key, ref_to_category,
query_value, reference_table, datatype, precision_, scale, default_value,
nullable) VALUES (4, 'street_id', NULL, 1, 1, NULL, NULL, 'fm_streetaddress',
'int', 4, NULL, NULL, 'True')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_config
(location_type, column_name, input_name, lookup_form, f_key, ref_to_category,
query_value, reference_table, datatype, precision_, scale, default_value,
nullable) VALUES (4, 'street_number', 'street number', NULL, NULL, NULL, 1,
NULL, 'varchar', 4, NULL, NULL, 'True')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_config
(location_type, column_name, input_name, lookup_form, f_key, ref_to_category,
query_value, reference_table, datatype, precision_, scale, default_value,
nullable) VALUES (1, 'owner_id', NULL, NULL, 1, 1, NULL, 'fm_owner', 'int', 4,
NULL, NULL, 'True');
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_config
(location_type, column_name, input_name, lookup_form, f_key, ref_to_category,
query_value, reference_table, datatype, precision_, scale, default_value,
nullable) VALUES (1, 'part_of_town_id', NULL, NULL, 1, NULL, NULL,
'fm_part_of_town', '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')");
+
?>
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.52
retrieving revision 1.53
diff -C2 -r1.52 -r1.53
*** setup.inc.php 30 May 2003 10:43:03 -0000 1.52
--- setup.inc.php 13 Jun 2003 11:05:30 -0000 1.53
***************
*** 82,85 ****
--- 82,98 ----
'fm_entrance',
'fm_location',
+ 'fm_location1',
+ 'fm_location1_category',
+ 'fm_location2',
+ 'fm_location2_category',
+ 'fm_location3',
+ 'fm_location3_category',
+ 'fm_location4',
+ 'fm_location4_category',
+ 'fm_location_type',
+ 'fm_location_type_column',
+ 'fm_location_config',
+ 'fm_location_attrib',
+ 'fm_location_type_attrib', // to be deleted - shortly
'fm_meter',
'fm_meter_category',
***************
*** 89,97 ****
'fm_equipment_type',
'fm_equipment_type_attrib',
- 'fm_location_type',
- 'fm_location_type_column',
- 'fm_location_config',
- 'fm_location_attrib',
- 'fm_location_type_attrib', // to be deleted - shortly
'fm_property_attrib',
'fm_property_category',
--- 102,105 ----
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.87
retrieving revision 1.88
diff -C2 -r1.87 -r1.88
*** tables_current.inc.php 1 Jun 2003 21:38:06 -0000 1.87
--- tables_current.inc.php 13 Jun 2003 11:05:30 -0000 1.88
***************
*** 21,29 ****
'fm_part_of_town' => array(
'fd' => array(
! 'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'district_id' => array('type' =>
'int','precision' => '2','nullable' => True)
),
! 'pk' => array('id'),
'fk' => array(),
'ix' => array(),
--- 21,29 ----
'fm_part_of_town' => array(
'fd' => array(
! 'part_of_town_id' => array('type' =>
'int','precision' => '2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'district_id' => array('type' =>
'int','precision' => '2','nullable' => True)
),
! 'pk' => array('part_of_town_id'),
'fk' => array(),
'ix' => array(),
***************
*** 294,298 ****
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
--- 294,298 ----
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
! 'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
***************
*** 409,419 ****
'uc' => array()
),
'fm_location_type_column' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'type_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'input_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => False),
--- 409,560 ----
'uc' => array()
),
+
+ 'fm_location1' => array(
+ 'fd' => array(
+ 'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => False),
+ 'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc1_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'part_of_town_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'owner_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('loc1'),
+ 'fk' => array(),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location1_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_location2' => array(
+ 'fd' => array(
+ 'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc2_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'owner_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('loc1',loc2'),
+ 'fk' => array('loc1' => 'fm_location1.loc1'),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location2_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_location3' => array(
+ 'fd' => array(
+ 'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc3_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'owner_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('loc1',loc2','loc3'),
+ 'fk' => array('loc1' => 'fm_location2.loc1','loc2' =>
'fm_location2.loc2'),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location3_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_location4' => array(
+ 'fd' => array(
+ 'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
+ 'loc4_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'street_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'street_number' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'owner_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('loc1',loc2','loc3',loc4'),
+ 'fk' => array('loc1' => 'fm_location3.loc1','loc2' =>
'fm_location3.loc2','loc3' => 'fm_location3.loc3'),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location4_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_location_config' => array(
+ 'fd' => array(
+ 'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'location_type' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => True),
+ 'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'f_key' => array('type' => 'int','precision' =>
'2','nullable' => True),
+ 'ref_to_category' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'query_value' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'reference_table' => array('type' =>
'varchar','precision' => '30','nullable' => True),
+ 'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
+ 'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
+ ),
+ 'pk' => array('column_name'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+
'fm_location_type_column' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'type_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
! 'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
! 'location_form' => array('type' =>
'int','precision' => '2','nullable' => True),
! 'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
+ 'size' => array('type' => 'varchar','int' =>
'4','nullable' => False),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => False),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.19,1.20 setup.inc.php,1.52,1.53 tables_current.inc.php,1.87,1.88,
Sigurd Nes <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: property/templates/default admin_location.xsl,1.2,1.3 location.xsl,1.9,1.10 location_form_2.xsl,1.1,1.2 lookup.xsl,1.17,1.18 menu.xsl,1.11,1.12
- Next by Date:
[Phpgroupware-cvs] CVS: property/inc class.boadmin_location.inc.php,1.2,1.3 class.bocommon.inc.php,1.50,1.51 class.bolocation.inc.php,1.5,1.6 class.bolookup.inc.php,1.7,1.8class.soadmin_location.inc.php,1.7,1.8 class.soapartment.inc.php,1.5,1.6 class.socommon.inc.php,1.21,1.22 class.soequipment.inc.php,1.12,1.13class.soinvestment.inc.php,1.12,1.13 class.soinvoice.inc.php,1.21,1.22 class.solocation.inc.php,1.3,1.4 class.solookup.inc.php,1.17,1.18 class.soproperty.inc.php,1.17,1.18 class.soreport.inc.php,1.1,1.2 class.soXport.inc.php,1.23,1.24 class.uilocation.inc.php,1.6,1.7 class.uilookup.inc.php,1.19,1.20
- Previous by thread:
[Phpgroupware-cvs] CVS: property/templates/default admin_location.xsl,1.2,1.3 location.xsl,1.9,1.10 location_form_2.xsl,1.1,1.2 lookup.xsl,1.17,1.18 menu.xsl,1.11,1.12
- Next by thread:
[Phpgroupware-cvs] CVS: property/inc class.boadmin_location.inc.php,1.2,1.3 class.bocommon.inc.php,1.50,1.51 class.bolocation.inc.php,1.5,1.6 class.bolookup.inc.php,1.7,1.8class.soadmin_location.inc.php,1.7,1.8 class.soapartment.inc.php,1.5,1.6 class.socommon.inc.php,1.21,1.22 class.soequipment.inc.php,1.12,1.13class.soinvestment.inc.php,1.12,1.13 class.soinvoice.inc.php,1.21,1.22 class.solocation.inc.php,1.3,1.4 class.solookup.inc.php,1.17,1.18 class.soproperty.inc.php,1.17,1.18 class.soreport.inc.php,1.1,1.2 class.soXport.inc.php,1.23,1.24 class.uilocation.inc.php,1.6,1.7 class.uilookup.inc.php,1.19,1.20
- Index(es):