[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.3,1.4 se
|
From: |
Sigurd Nes <address@hidden> |
|
Subject: |
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.3,1.4 setup.inc.php,1.2,1.3 tables_update.inc.php,1.1,1.2 |
|
Date: |
Tue, 03 Sep 2002 18:15:41 -0400 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv30475/setup
Modified Files:
tables_current.inc.php setup.inc.php tables_update.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.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** tables_current.inc.php 1 Sep 2002 21:45:29 -0000 1.3
--- tables_current.inc.php 3 Sep 2002 22:15:38 -0000 1.4
***************
*** 272,276 ****
'fd' => array(
'equipment_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'equipment_type_id' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
--- 272,276 ----
'fd' => array(
'equipment_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'equipment_type_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
***************
*** 299,304 ****
'fd' => array(
'equipment_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'equipment_type_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'e_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),
--- 299,304 ----
'fd' => array(
'equipment_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'equipment_type_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'c' => array('type' => 'varchar','precision' =>
'50','nullable' => True),
'i' => array('type' => 'int','precision' =>
'4','nullable' => True),
***************
*** 308,312 ****
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
! 'pk' =>
array('equipment_id','equipment_type_id','e_type_attrib_id'),
'fk' => array(),
'ix' => array(),
--- 308,312 ----
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
! 'pk' =>
array('equipment_id','equipment_type_id','attrib_id'),
'fk' => array(),
'ix' => array(),
***************
*** 315,319 ****
'fm_equipment_type' => array(
'fd' => array(
! 'equipment_type_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'type_descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
--- 315,320 ----
'fm_equipment_type' => array(
'fd' => array(
! 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
! 'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'type_descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
***************
*** 321,325 ****
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
! 'pk' => array('equipment_type_id'),
'fk' => array(),
'ix' => array(),
--- 322,326 ----
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
! 'pk' => array('id'),
'fk' => array(),
'ix' => array(),
***************
*** 328,337 ****
'fm_equipment_type_attrib' => array(
'fd' => array(
! 'e_type_attrib_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
! 'equipment_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('e_type_attrib_id','equipment_type_id'),
'fk' => array(),
'ix' => array(),
--- 329,339 ----
'fm_equipment_type_attrib' => array(
'fd' => array(
! 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
! 'equipment_type_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'attrib_descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'datatype' => array('type' =>
'char','precision' => '1','nullable' => True)
),
! 'pk' => array('id'),
'fk' => array(),
'ix' => array(),
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** setup.inc.php 1 Sep 2002 19:43:49 -0000 1.2
--- setup.inc.php 3 Sep 2002 22:15:38 -0000 1.3
***************
*** 10,14 ****
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
! $setup_info['property']['version'] = '0.1.1.002';
$setup_info['property']['app_order'] = 14;
$setup_info['property']['enable'] = 1;
--- 10,14 ----
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
! $setup_info['property']['version'] = '0.1.1.003';
$setup_info['property']['app_order'] = 14;
$setup_info['property']['enable'] = 1;
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_update.inc.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** tables_update.inc.php 2 Sep 2002 22:55:56 -0000 1.1
--- tables_update.inc.php 3 Sep 2002 22:15:38 -0000 1.2
***************
*** 91,93 ****
--- 91,114 ----
}
+ $test[] = '0.1.1.002';
+ function property_upgrade0_1_1_002()
+ {
+ global $setup_info, $phpgw_setup;
+
+
$phpgw_setup->oProc->AlterColumn('fm_equipment','equipment_type_id',array('type'
=> 'int','precision' => 4,'nullable' => True));
+
$phpgw_setup->oProc->AlterColumn('fm_equipment_attrib','equipment_type_id',array('type'
=> 'int','precision' => 4,'nullable' => False));
+
$phpgw_setup->oProc->RenameColumn('fm_equipment_attrib','e_type_attrib_id','attrib_id');
+
$phpgw_setup->oProc->AlterColumn('fm_equipment_attrib','attrib_id',array('type'
=> 'int','precision' => 4,'nullable' => False));
+
$phpgw_setup->oProc->RenameColumn('fm_equipment_type','equipment_type_id','id');
+
$phpgw_setup->oProc->AlterColumn('fm_equipment_type','id',array('type' =>
'int','precision' => 4,'nullable' => False));
+ $phpgw_setup->oProc->AddColumn('fm_equipment_type','name',
array('type' => 'varchar', 'precision' => 20,'nullable' => True));
+
$phpgw_setup->oProc->RenameColumn('fm_equipment_type_attrib','e_type_attrib_id','id');
+
$phpgw_setup->oProc->AlterColumn('fm_equipment_type_attrib','id',array('type'
=> 'int','precision' => 4,'nullable' => False));
+
$phpgw_setup->oProc->AlterColumn('fm_equipment_type_attrib','equipment_type_id',array('type'
=> 'int','precision' => 4,'nullable' => False));
+
$phpgw_setup->oProc->AddColumn('fm_equipment_type_attrib','name', array('type'
=> 'varchar', 'precision' => 20,'nullable' => True));
+
+ $setup_info['property']['currentver'] = '0.1.1.003';
+ return $setup_info['property']['currentver'];
+ }
+
?>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.3,1.4 setup.inc.php,1.2,1.3 tables_update.inc.php,1.1,1.2,
Sigurd Nes <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: etemplate/inc class.uietemplate.inc.php,1.14,1.15
- Next by Date:
[Phpgroupware-cvs] CVS: property/inc header.inc.php,1.4,1.5 functions.inc.php,1.3,1.4 class.fm_wo_activities.inc.php,1.1.1.1,1.2 class.fm_wrkorder.inc.php,1.1.1.1,1.2
- Previous by thread:
[Phpgroupware-cvs] CVS: etemplate/inc class.uietemplate.inc.php,1.14,1.15
- Next by thread:
[Phpgroupware-cvs] CVS: property/inc header.inc.php,1.4,1.5 functions.inc.php,1.3,1.4 class.fm_wo_activities.inc.php,1.1.1.1,1.2 class.fm_wrkorder.inc.php,1.1.1.1,1.2
- Index(es):