[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php setup.inc.php
From: |
Sigurd Nes |
Subject: |
[Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php setup.inc.php |
Date: |
Tue, 03 Oct 2006 11:09:18 +0000 |
CVSROOT: /sources/phpgwapi
Module name: phpgwapi
Changes by: Sigurd Nes <sigurdne> 06/10/03 11:09:18
Modified files:
setup : tables_update.inc.php setup.inc.php
Log message:
only default value for phpgw_access_log.ip is altered - right ?
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/setup/tables_update.inc.php?cvsroot=phpgwapi&r1=1.93&r2=1.94
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/setup/setup.inc.php?cvsroot=phpgwapi&r1=1.74&r2=1.75
Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v
retrieving revision 1.93
retrieving revision 1.94
diff -u -b -r1.93 -r1.94
--- tables_update.inc.php 30 Sep 2006 07:09:01 -0000 1.93
+++ tables_update.inc.php 3 Oct 2006 11:09:18 -0000 1.94
@@ -5,7 +5,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package phpgwapi
* @subpackage setup
- * @version $Id: tables_update.inc.php,v 1.93 2006/09/30 07:09:01
skwashd Exp $
+ * @version $Id: tables_update.inc.php,v 1.94 2006/10/03 11:09:18
sigurdne Exp $
* @internal $Source:
/sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v $
*/
@@ -1401,58 +1401,18 @@
return $GLOBALS['setup_info']['phpgwapi']['currentver'];
}
-
-
$test[] = '0.9.17.505';
function phpgwapi_upgrade0_9_17_505()
{
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_config','config_app',array(
- 'type' => 'varchar',
- 'precision' => '50'
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_config','config_name',array(
- 'type' => 'varchar',
- 'precision' => '255',
- 'nullable' => False
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_config','config_value',array(
- 'type' => 'text'
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','sessionid',array(
- 'type' => 'char',
- 'precision' => '32',
- 'nullable' => False
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','loginid',array(
- 'type' => 'varchar',
- 'precision' => '30',
- 'nullable' => False
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','ip',array(
+ $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_access_log','ip',array(
'type' => 'varchar',
'precision' => '50',
'nullable' => False,
'default' => '::1'
));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','li',array(
- 'type' => 'int',
- 'precision' => '4',
- 'nullable' => False
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','lo',array(
- 'type' => 'int',
- 'precision' => '4',
- 'nullable' => True,
- 'default' => '0'
- ));
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_access_log','account_id',array(
- 'type' => 'int',
- 'precision' => '4',
- 'nullable' => False,
- 'default' => '0'
- ));
-
+ $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
$GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.17.506';
return $GLOBALS['setup_info']['phpgwapi']['currentver'];
}
Index: setup.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/setup/setup.inc.php,v
retrieving revision 1.74
retrieving revision 1.75
diff -u -b -r1.74 -r1.75
--- setup.inc.php 30 Sep 2006 07:09:01 -0000 1.74
+++ setup.inc.php 3 Oct 2006 11:09:18 -0000 1.75
@@ -5,7 +5,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package phpgwapi
* @subpackage setup
- * @version $Id: setup.inc.php,v 1.74 2006/09/30 07:09:01 skwashd Exp $
+ * @version $Id: setup.inc.php,v 1.75 2006/10/03 11:09:18 sigurdne Exp $
* @internal $Source: /sources/phpgwapi/phpgwapi/setup/setup.inc.php,v $
*/
@@ -18,47 +18,48 @@
$setup_info['phpgwapi']['app_order'] = 1;
// The tables this app creates
- $setup_info['phpgwapi']['tables'] =
array('phpgw_config','phpgw_applications','phpgw_acl','phpgw_acl_location','phpgw_accounts','phpgw_preferences','phpgw_sessions','phpgw_app_sessions','phpgw_access_log','phpgw_hooks','phpgw_languages','phpgw_lang','phpgw_nextid','phpgw_categories','phpgw_addressbook','phpgw_addressbook_extra','phpgw_log','phpgw_interserv','phpgw_vfs','phpgw_history_log','phpgw_async','phpgw_contact','phpgw_contact_person','phpgw_contact_org','phpgw_contact_org_person','phpgw_contact_addr','phpgw_contact_note','phpgw_contact_others','phpgw_contact_comm','phpgw_contact_comm_descr','phpgw_contact_comm_type','phpgw_contact_types','phpgw_contact_addr_type','phpgw_contact_note_type','phpgw_cust_fields','phpgw_cust_field_types','phpgw_cust_field_values','phpgw_cust_attribute','phpgw_cust_choice','phpgw_cust_function');
- $setup_info['phpgwapi']['tables'][] = 'phpgw_config';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_applications';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_acl';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_acl_location';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_accounts';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_preferences';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_sessions';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_app_sessions';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_access_log';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_hooks';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_languages';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_lang';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_nextid';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_categories';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_addressbook';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_addressbook_extra';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_log';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_interserv';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_vfs';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_history_log';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_async';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_person';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_org';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_org_person';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_addr';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_note';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_others';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_comm';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_comm_descr';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_comm_type';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_types';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_addr_type';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_contact_note_type';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_fields';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_field_types';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_field_values';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_attribute';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_choice';
- $setup_info['phpgwapi']['tables'][] = 'phpgw_cust_function';
+ $setup_info['phpgwapi']['tables'] = array(
+ 'phpgw_config',
+ 'phpgw_applications',
+ 'phpgw_acl',
+ 'phpgw_acl_location',
+ 'phpgw_accounts',
+ 'phpgw_preferences',
+ 'phpgw_sessions',
+ 'phpgw_app_sessions',
+ 'phpgw_access_log',
+ 'phpgw_hooks',
+ 'phpgw_languages',
+ 'phpgw_lang',
+ 'phpgw_nextid',
+ 'phpgw_categories',
+ 'phpgw_addressbook',
+ 'phpgw_addressbook_extra',
+ 'phpgw_log',
+ 'phpgw_interserv',
+ 'phpgw_vfs',
+ 'phpgw_history_log',
+ 'phpgw_async',
+ 'phpgw_contact',
+ 'phpgw_contact_person',
+ 'phpgw_contact_org',
+ 'phpgw_contact_org_person',
+ 'phpgw_contact_addr',
+ 'phpgw_contact_note',
+ 'phpgw_contact_others',
+ 'phpgw_contact_comm',
+ 'phpgw_contact_comm_descr',
+ 'phpgw_contact_comm_type',
+ 'phpgw_contact_types',
+ 'phpgw_contact_addr_type',
+ 'phpgw_contact_note_type',
+ 'phpgw_cust_fields',
+ 'phpgw_cust_field_types',
+ 'phpgw_cust_field_values',
+ 'phpgw_cust_attribute',
+ 'phpgw_cust_choice',
+ 'phpgw_cust_function'
+ );
// Basic information about this app
$setup_info['notifywindow']['name'] = 'notifywindow';
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php setup.inc.php,
Sigurd Nes <=