[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] projects/setup setup.inc.php, 1.24, 1.25 tables_curre
From: |
Bettina Gille <address@hidden> |
Subject: |
[Phpgroupware-cvs] projects/setup setup.inc.php, 1.24, 1.25 tables_current.inc.php, 1.17, 1.18 tables_update.inc.php, 1.24, 1.25 |
Date: |
Fri, 14 Nov 2003 13:04:07 +0000 |
Update of /cvsroot/phpgroupware/projects/setup
In directory subversions:/tmp/cvs-serv4718/setup
Modified Files:
setup.inc.php tables_current.inc.php tables_update.inc.php
Log Message:
sapdb support table column update
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_current.inc.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** tables_current.inc.php 23 Oct 2003 12:15:46 -0000 1.17
--- tables_current.inc.php 14 Nov 2003 13:04:04 -0000 1.18
***************
*** 19,23 ****
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'num' => array('type' => 'varchar','precision'
=> 25,'nullable' => False),
'owner' => array('type' => 'int','precision' =>
4,'default' => 0,'nullable' => False),
'access' => array('type' =>
'varchar','precision' => 7,'nullable' => True),
--- 19,23 ----
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'p_number' => array('type' =>
'varchar','precision' => 25,'nullable' => False),
'owner' => array('type' => 'int','precision' =>
4,'default' => 0,'nullable' => False),
'access' => array('type' =>
'varchar','precision' => 7,'nullable' => True),
***************
*** 44,54 ****
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','num'),
! 'uc' => array('num')
),
'phpgw_p_activities' => array(
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'num' => array('type' => 'varchar','precision'
=> 20,'nullable' => False),
'descr' => array('type' =>
'varchar','precision' => 255,'nullable' => False),
'remarkreq' => array('type' =>
'char','precision' => 1,'default' => 'N','nullable' => False),
--- 44,54 ----
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','p_number'),
! 'uc' => array('p_number')
),
'phpgw_p_activities' => array(
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'a_number' => array('type' =>
'varchar','precision' => 20,'nullable' => False),
'descr' => array('type' =>
'varchar','precision' => 255,'nullable' => False),
'remarkreq' => array('type' =>
'char','precision' => 1,'default' => 'N','nullable' => False),
***************
*** 59,63 ****
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','num'),
'uc' => array()
),
--- 59,63 ----
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','a_number'),
'uc' => array()
),
***************
*** 112,117 ****
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'num' => array('type' => 'varchar','precision'
=> 20,'nullable' => False),
! 'date' => array('type' => 'int','precision' =>
4,'default' => 0,'nullable' => False),
'project_id' => array('type' =>
'int','precision' => 4,'default' => 0,'nullable' => False),
'customer' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
--- 112,117 ----
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'i_number' => array('type' =>
'varchar','precision' => 20,'nullable' => False),
! 'i_date' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
'project_id' => array('type' =>
'int','precision' => 4,'default' => 0,'nullable' => False),
'customer' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
***************
*** 121,126 ****
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','num'),
! 'uc' => array('num')
),
'phpgw_p_invoicepos' => array(
--- 121,126 ----
'pk' => array('id'),
'fk' => array(),
! 'ix' => array('id','i_number'),
! 'uc' => array('i_number')
),
'phpgw_p_invoicepos' => array(
***************
*** 138,143 ****
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'num' => array('type' => 'varchar','precision'
=> 20,'nullable' => False),
! 'date' => array('type' => 'int','precision' =>
4,'default' => 0,'nullable' => False),
'project_id' => array('type' =>
'int','precision' => 4,'default' => 0,'nullable' => False),
'customer' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
--- 138,143 ----
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
! 'd_number' => array('type' =>
'varchar','precision' => 20,'nullable' => False),
! 'd_date' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
'project_id' => array('type' =>
'int','precision' => 4,'default' => 0,'nullable' => False),
'customer' => array('type' => 'int','precision'
=> 4,'default' => 0,'nullable' => False),
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/setup.inc.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** setup.inc.php 23 Oct 2003 12:15:46 -0000 1.24
--- setup.inc.php 14 Nov 2003 13:04:04 -0000 1.25
***************
*** 12,16 ****
$setup_info['projects']['name'] = 'projects';
! $setup_info['projects']['version'] = '0.8.7.010';
$setup_info['projects']['app_order'] = 13;
$setup_info['projects']['enable'] = 1;
--- 12,16 ----
$setup_info['projects']['name'] = 'projects';
! $setup_info['projects']['version'] = '0.8.7.011';
$setup_info['projects']['app_order'] = 13;
$setup_info['projects']['enable'] = 1;
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_update.inc.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** tables_update.inc.php 23 Oct 2003 12:15:46 -0000 1.24
--- tables_update.inc.php 14 Nov 2003 13:04:04 -0000 1.25
***************
*** 497,499 ****
--- 497,514 ----
return $GLOBALS['setup_info']['projects']['currentver'];
}
+
+ $test[] = '0.8.7.010';
+ function projects_upgrade0_8_7_010()
+ {
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_projects','num','p_number');
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_activities','num','a_number');
+
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_invoice','num','i_number');
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_invoice','date','i_date');
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_delivery','num','d_number');
+
$GLOBALS['phpgw_setup']->oProc->RenameColumn('phpgw_p_delivery','date','d_date');
+
+ $GLOBALS['setup_info']['projects']['currentver'] = '0.8.7.011';
+ return $GLOBALS['setup_info']['projects']['currentver'];
+ }
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] projects/setup setup.inc.php, 1.24, 1.25 tables_current.inc.php, 1.17, 1.18 tables_update.inc.php, 1.24, 1.25,
Bettina Gille <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] projects/inc class.sobilling.inc.php, 1.16, 1.17 class.sodeliveries.inc.php, 1.20, 1.21 class.soprojects.inc.php, 1.47, 1.48
- Next by Date:
[Phpgroupware-cvs] projects/setup setup.inc.php, 1.25, 1.26 tables_current.inc.php, 1.18, 1.19 tables_update.inc.php, 1.25, 1.26
- Previous by thread:
[Phpgroupware-cvs] projects/inc class.sobilling.inc.php, 1.16, 1.17 class.sodeliveries.inc.php, 1.20, 1.21 class.soprojects.inc.php, 1.47, 1.48
- Next by thread:
[Phpgroupware-cvs] projects/setup setup.inc.php, 1.25, 1.26 tables_current.inc.php, 1.18, 1.19 tables_update.inc.php, 1.25, 1.26
- Index(es):