[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.100,1.10
From: |
Sigurd Nes <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.100,1.101 default_records.inc.php,1.23,1.24 |
Date: |
Fri, 27 Jun 2003 07:14:53 -0400 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv4980/setup
Modified Files:
tables_current.inc.php default_records.inc.php
Log Message:
no message
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.100
retrieving revision 1.101
diff -C2 -r1.100 -r1.101
*** tables_current.inc.php 26 Jun 2003 12:23:05 -0000 1.100
--- tables_current.inc.php 27 Jun 2003 11:14:50 -0000 1.101
***************
*** 30,33 ****
--- 30,34 ----
'uc' => array()
),
+
'fm_building' => array(
'fd' => array(
***************
*** 372,375 ****
--- 373,377 ----
'uc' => array()
),
+
'fm_location_attrib' => array(
'fd' => array(
***************
*** 450,457 ****
'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'),
--- 452,458 ----
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_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'),
***************
*** 478,485 ****
'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'),
--- 479,485 ----
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_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'),
***************
*** 496,499 ****
--- 496,500 ----
'uc' => array()
),
+
'fm_location4' => array(
'fd' => array(
***************
*** 509,520 ****
'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(
--- 510,523 ----
'street_number' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
! 'tenant_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(
***************
*** 527,530 ****
--- 530,534 ----
'uc' => array()
),
+
'fm_location_config' => array(
'fd' => array(
***************
*** 549,553 ****
),
-
'fm_location_type_column' => array(
'fd' => array(
--- 553,556 ----
***************
*** 560,569 ****
'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),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
! 'default_value' => array('type' =>
'varchar','precision' => '10','nullable' => True),
! 'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False)
),
'pk' => array('id'),
--- 563,572 ----
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
! 'size' => array('type' => 'int','precision' =>
'4','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('id'),
***************
*** 573,592 ****
),
- 'fm_location_config' => array(
- 'fd' => array(
- 'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
- 'location_type' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
- 'precision_' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
- 'default_value' => array('type' =>
'varchar','precision' => '18','nullable' => True),
- 'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False)
- ),
- 'pk' => array('column_name'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
'fm_property_attrib' => array(
'fd' => array(
--- 576,579 ----
***************
*** 687,691 ****
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
! 'owner' => array('type' => 'int','precision' =>
'4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
--- 674,678 ----
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
! 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
***************
*** 1677,1680 ****
--- 1664,1668 ----
'uc' => array()
),
+
'fm_owner_category' => array(
'fd' => array(
Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/default_records.inc.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -r1.23 -r1.24
*** default_records.inc.php 26 Jun 2003 12:23:05 -0000 1.23
--- default_records.inc.php 27 Jun 2003 11:14:50 -0000 1.24
***************
*** 80,91 ****
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id,
descr) VALUES ('3', 'warranty')");
- #
- # `fm_location_type`
- #
-
- $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
descr) VALUES ('1', 'Propetry')");
- $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
descr) VALUES ('2', 'Building')");
- $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
descr) VALUES ('3', 'Entrance')");
- $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
descr) VALUES ('4', 'Apartment')");
#
--- 80,83 ----
***************
*** 139,142 ****
--- 131,135 ----
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_submodule (id, descr)
VALUES ('.report', 'Report')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_submodule (id, descr)
VALUES ('.document', 'Documents')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_submodule (id, descr)
VALUES ('.drawing', 'Drawing')");
#
***************
*** 161,169 ****
#
! $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')");
--- 154,162 ----
#
! $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, 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_text, 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_text, 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_text, 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_text, 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')");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.100,1.101 default_records.inc.php,1.23,1.24,
Sigurd Nes <address@hidden> <=