[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: infolog/setup setup.inc.php,1.13,1.14 tables_cur
|
From: |
Ralf Becker <address@hidden> |
|
Subject: |
[Phpgroupware-cvs] CVS: infolog/setup setup.inc.php,1.13,1.14 tables_current.inc.php,1.9,1.10 tables_update.inc.php,1.2,1.3 |
|
Date: |
Sun, 01 Sep 2002 16:41:38 -0400 |
Update of /cvsroot/phpgroupware/infolog/setup
In directory subversions:/tmp/cvs-serv17262
Modified Files:
setup.inc.php tables_current.inc.php tables_update.inc.php
Log Message:
moved infolog links to addressbook,projects and calendar to new link-class and
its table phpgw_links
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/infolog/setup/setup.inc.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** setup.inc.php 14 May 2002 12:03:56 -0000 1.13
--- setup.inc.php 1 Sep 2002 20:41:36 -0000 1.14
***************
*** 14,20 ****
$setup_info['infolog']['name'] = 'infolog';
$setup_info['infolog']['title'] = 'Info Log';
! $setup_info['infolog']['version'] = '0.9.15.001';
$setup_info['infolog']['app_order'] = 20;
! $setup_info['infolog']['tables'] = array('phpgw_infolog');
$setup_info['infolog']['enable'] = 1;
--- 14,20 ----
$setup_info['infolog']['name'] = 'infolog';
$setup_info['infolog']['title'] = 'Info Log';
! $setup_info['infolog']['version'] = '0.9.15.003';
$setup_info['infolog']['app_order'] = 20;
! $setup_info['infolog']['tables'] =
array('phpgw_infolog','phpgw_links');
$setup_info['infolog']['enable'] = 1;
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/infolog/setup/tables_current.inc.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** tables_current.inc.php 1 Sep 2002 18:59:01 -0000 1.9
--- tables_current.inc.php 1 Sep 2002 20:41:36 -0000 1.10
***************
*** 17,22 ****
'info_id' => array('type' => 'auto','nullable'
=> False),
'info_type' => array('type' =>
'varchar','precision' => '255','default' => 'task','nullable' => False),
- 'info_addr_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
- 'info_proj_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
'info_from' => array('type' =>
'varchar','precision' => '64','nullable' => True),
'info_addr' => array('type' =>
'varchar','precision' => '64','nullable' => True),
--- 17,20 ----
***************
*** 35,40 ****
'info_bill_cat' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
'info_status' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'done'),
! 'info_confirm' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'not'),
! 'info_event_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False)
),
'pk' => array('info_id'),
--- 33,37 ----
'info_bill_cat' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
'info_status' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'done'),
! 'info_confirm' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'not')
),
'pk' => array('info_id'),
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/infolog/setup/tables_update.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** tables_update.inc.php 1 Sep 2002 18:59:01 -0000 1.2
--- tables_update.inc.php 1 Sep 2002 20:41:36 -0000 1.3
***************
*** 53,55 ****
--- 53,161 ----
return $GLOBALS['setup_info']['phpgwapi']['currentver'];
}
+
+
+ $test[] = '0.9.15.002';
+ function infolog_upgrade0_9_15_002()
+ {
+ echo "<p>infolog_upgrade0_9_15_002</p>\n";
+ $insert = 'INSERT INTO phpgw_links
(link_app1,link_id1,link_app2,link_id2,link_remark,link_lastmod,link_owner) ';
+ $select = "SELECT
'infolog',info_id,'addressbook',info_addr_id,info_from,info_datemodified,info_owner
FROM phpgw_infolog WHERE info_addr_id != 0";
+ echo "<p>copying address-links: $insert.$select</p>\n";
+ $GLOBALS['phpgw_setup']->oProc->query($insert.$select);
+ $select = "SELECT
'infolog',info_id,'projects',info_proj_id,'',info_datemodified,info_owner FROM
phpgw_infolog WHERE info_proj_id != 0";
+ echo "<p>copying projects-links: $insert.$select</p>\n";
+ $GLOBALS['phpgw_setup']->oProc->query($insert.$select);
+ $select = "SELECT
'infolog',info_id,'calendar',info_event_id,'',info_datemodified,info_owner FROM
phpgw_infolog WHERE info_event_id != 0";
+ echo "<p>copying calendar-links: $insert.$select</p>\n";
+ $GLOBALS['phpgw_setup']->oProc->query($insert.$select);
+
+
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_infolog',array(
+ 'fd' => array(
+ 'info_id' => array('type' => 'auto','nullable'
=> False),
+ 'info_type' => array('type' =>
'varchar','precision' => '255','default' => 'task','nullable' => False),
+ 'info_proj_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_from' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_addr' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_subject' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_des' => array('type' => 'text','nullable'
=> True),
+ 'info_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_responsible' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_access' => array('type' =>
'varchar','precision' => '10','nullable' => True,'default' => 'public'),
+ 'info_cat' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => False),
+ 'info_datemodified' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_startdate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_enddate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_id_parent' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_pri' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'normal'),
+ 'info_time' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_bill_cat' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_status' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'done'),
+ 'info_confirm' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'not'),
+ 'info_event_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False)
+ ),
+ 'pk' => array('info_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),'info_addr_id');
+
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_infolog',array(
+ 'fd' => array(
+ 'info_id' => array('type' => 'auto','nullable'
=> False),
+ 'info_type' => array('type' =>
'varchar','precision' => '255','default' => 'task','nullable' => False),
+ 'info_from' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_addr' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_subject' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_des' => array('type' => 'text','nullable'
=> True),
+ 'info_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_responsible' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_access' => array('type' =>
'varchar','precision' => '10','nullable' => True,'default' => 'public'),
+ 'info_cat' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => False),
+ 'info_datemodified' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_startdate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_enddate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_id_parent' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_pri' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'normal'),
+ 'info_time' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_bill_cat' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_status' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'done'),
+ 'info_confirm' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'not'),
+ 'info_event_id' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False)
+ ),
+ 'pk' => array('info_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),'info_proj_id');
+
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_infolog',array(
+ 'fd' => array(
+ 'info_id' => array('type' => 'auto','nullable'
=> False),
+ 'info_type' => array('type' =>
'varchar','precision' => '255','default' => 'task','nullable' => False),
+ 'info_from' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_addr' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_subject' => array('type' =>
'varchar','precision' => '64','nullable' => True),
+ 'info_des' => array('type' => 'text','nullable'
=> True),
+ 'info_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_responsible' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_access' => array('type' =>
'varchar','precision' => '10','nullable' => True,'default' => 'public'),
+ 'info_cat' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => False),
+ 'info_datemodified' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'info_startdate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_enddate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_id_parent' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_pri' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'normal'),
+ 'info_time' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_bill_cat' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
+ 'info_status' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'done'),
+ 'info_confirm' => array('type' =>
'varchar','precision' => '255','nullable' => True,'default' => 'not')
+ ),
+ 'pk' => array('info_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),'info_event_id');
+
+
+ $GLOBALS['setup_info']['infolog']['currentver'] = '0.9.15.003';
+ return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+ }
?>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: infolog/setup setup.inc.php,1.13,1.14 tables_current.inc.php,1.9,1.10 tables_update.inc.php,1.2,1.3,
Ralf Becker <address@hidden> <=