[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.12,1.13
|
From: |
Sigurd Nes <address@hidden> |
|
Subject: |
[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.12,1.13 setup.inc.php,1.34,1.35 tables_current.inc.php,1.59,1.60 |
|
Date: |
Sat, 12 Apr 2003 13:55:07 -0400 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv27354/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.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** default_records.inc.php 8 Apr 2003 12:38:09 -0000 1.12
--- default_records.inc.php 12 Apr 2003 17:55:03 -0000 1.13
***************
*** 97,100 ****
--- 97,101 ----
$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 ('workorder', '1000', 'request')");
?>
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -r1.34 -r1.35
*** setup.inc.php 8 Apr 2003 12:38:09 -0000 1.34
--- setup.inc.php 12 Apr 2003 17:55:03 -0000 1.35
***************
*** 110,119 ****
'fm_wo_hours',
'fm_wo_key_loc',
! 'fm_request',
! 'fm_request_attrib',
! 'fm_request_priority_key',
! 'fm_request_status',
! 'fm_request_type',
! 'fm_request_type_attrib',
'fm_wo_template',
'fm_wo_template_hours',
--- 110,118 ----
'fm_wo_hours',
'fm_wo_key_loc',
! 'fm_wo_request',
! 'fm_wo_request_priority_key',
! 'fm_wo_request_status',
! 'fm_wo_request_category',
! 'fm_wo_request_history',
'fm_wo_template',
'fm_wo_template_hours',
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.59
retrieving revision 1.60
diff -C2 -r1.59 -r1.60
*** tables_current.inc.php 10 Apr 2003 10:14:27 -0000 1.59
--- tables_current.inc.php 12 Apr 2003 17:55:03 -0000 1.60
***************
*** 601,607 ****
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
! 'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
! 'owner' => array('type' => 'int','precision' =>
'4','nullable' => True),
! 'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
'pk' => array('id'),
--- 601,605 ----
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
! 'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
***************
*** 793,799 ****
),
! 'fm_request' => array(
'fd' => array(
'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
'request_type_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
--- 791,798 ----
),
! 'fm_wo_request' => array(
'fd' => array(
'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
+ 'title' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
'request_type_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
***************
*** 807,813 ****
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'contact_phone' => array('type' => 'varchar',
'precision' => 12,'nullable' => True),
! 'date' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
! 'cost' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
'status' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
'd_safety' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'd_aesthetics' => array('type' => 'int',
'precision' => 4,'nullable' => True),
--- 806,814 ----
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'contact_phone' => array('type' => 'varchar',
'precision' => 12,'nullable' => True),
! 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
! 'budget' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
'status' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
+ 'branch_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'coordinator' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'd_safety' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'd_aesthetics' => array('type' => 'int',
'precision' => 4,'nullable' => True),
***************
*** 828,832 ****
'c_user_gratification' => array('type' =>
'int', 'precision' => 4,'nullable' => True),
'c_residential_environment' => array('type' =>
'int', 'precision' => 4,'nullable' => True),
! 'authorities_demands' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'score' => array('type' => 'int', 'precision'
=> 4,'nullable' => True)
),
--- 829,833 ----
'c_user_gratification' => array('type' =>
'int', 'precision' => 4,'nullable' => True),
'c_residential_environment' => array('type' =>
'int', 'precision' => 4,'nullable' => True),
! 'authorities_demands' => array('type' => 'int',
'precision' => 2,'nullable' => True),
'score' => array('type' => 'int', 'precision'
=> 4,'nullable' => True)
),
***************
*** 837,859 ****
),
! 'fm_request_attrib' => array(
! 'fd' => array(
! 'request_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
! 'request_type_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
! 'r_type_attrib_id' => array('type' =>
'varchar', 'precision' => 20,'nullable' => False),
! 'c' => array('type' => 'varchar', 'precision'
=> 50,'nullable' => True),
! 'i' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
! 'n' => array('type' => 'decimal', 'precision'
=> 10, 'scale' => 2,'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)
! ),
! 'pk' =>
array('request_id','request_type_id','r_type_attrib_id'),
! 'fk' => array(),
! 'ix' => array(),
! 'uc' => array()
! ),
!
! 'fm_request_status' => array(
'fd' => array(
'id' => array('type' => 'varchar', 'precision'
=> 20,'nullable' => False),
--- 838,842 ----
),
! 'fm_wo_request_status' => array(
'fd' => array(
'id' => array('type' => 'varchar', 'precision'
=> 20,'nullable' => False),
***************
*** 866,872 ****
),
! 'fm_request_type' => array(
'fd' => array(
! 'id' => array('type' => 'varchar', 'precision'
=> 20,'nullable' => False),
'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True)
),
--- 849,855 ----
),
! 'fm_wo_request_category' => array(
'fd' => array(
! 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True)
),
***************
*** 877,893 ****
),
- 'fm_request_type_attrib' => array(
- 'fd' => array(
- 'r_type_attrib_id' => array('type' =>
'varchar', 'precision' => 20,'nullable' => False),
- 'request_type_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
- 'attrib_descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
- 'datatype' => array('type' => 'char',
'precision' => 1,'nullable' => True)
- ),
- 'pk' => array('r_type_attrib_id','request_type_id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
'fm_wo_ns3420'=> array(
'fd' => array(
--- 860,863 ----
***************
*** 1128,1132 ****
),
! 'fm_request_priority_key' => array(
'fd' => array(
'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
--- 1098,1102 ----
),
! 'fm_wo_request_priority_key' => array(
'fd' => array(
'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
***************
*** 1273,1276 ****
--- 1243,1262 ----
),
'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_wo_request_history' => array(
+ 'fd' => array(
+ 'history_id' => array('type' => 'auto',
'precision' => 4, 'nullable' => False),
+ 'history_record_id' => array('type' => 'int',
'precision' => 4, 'nullable' => False),
+ 'history_appname' => array('type' =>
'varchar', 'precision' => 64, 'nullable' => False),
+ 'history_owner' => array('type' => 'int',
'precision' => 4, 'nullable' => False),
+ 'history_status' => array('type' => 'char',
'precision' => 2, 'nullable' => False),
+ 'history_new_value' => array('type' => 'text',
'nullable' => False),
+ 'history_timestamp' => array('type' =>
'timestamp', 'nullable' => False, 'default' => 'current_timestamp')
+ ),
+ 'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.12,1.13 setup.inc.php,1.34,1.35 tables_current.inc.php,1.59,1.60,
Sigurd Nes <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: developer_tools/setup phpgw_de.lang,1.1.2.2,1.1.2.3 phpgw_en.lang,1.5.2.2,1.5.2.3
- Next by Date:
[Phpgroupware-cvs] CVS: property/templates/default request.xsl,NONE,1.1 lookup.xsl,1.14,1.15
- Previous by thread:
[Phpgroupware-cvs] CVS: developer_tools/setup phpgw_de.lang,1.1.2.2,1.1.2.3 phpgw_en.lang,1.5.2.2,1.5.2.3
- Next by thread:
[Phpgroupware-cvs] CVS: property/templates/default request.xsl,NONE,1.1 lookup.xsl,1.14,1.15
- Index(es):