[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....
From: |
Sigurd Nes |
Subject: |
[Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php setup.inc.... |
Date: |
Sun, 26 Mar 2006 19:55:33 +0000 |
CVSROOT: /sources/phpgwapi
Module name: phpgwapi
Branch:
Changes by: Sigurd Nes <address@hidden> 06/03/26 19:55:33
Modified files:
setup : tables_update.inc.php setup.inc.php
tables_current.inc.php
Log message:
custom attrib
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/phpgwapi/setup/tables_update.inc.php.diff?tr1=1.86&tr2=1.87&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/phpgwapi/setup/setup.inc.php.diff?tr1=1.69&tr2=1.70&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/phpgwapi/setup/tables_current.inc.php.diff?tr1=1.57&tr2=1.58&r1=text&r2=text
Patches:
Index: phpgwapi/setup/setup.inc.php
diff -u phpgwapi/setup/setup.inc.php:1.69 phpgwapi/setup/setup.inc.php:1.70
--- phpgwapi/setup/setup.inc.php:1.69 Sat Mar 18 16:30:55 2006
+++ phpgwapi/setup/setup.inc.php Sun Mar 26 19:55:33 2006
@@ -5,14 +5,14 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package phpgwapi
* @subpackage setup
- * @version $Id: setup.inc.php,v 1.69 2006/03/18 16:30:55 sigurdne Exp $
+ * @version $Id: setup.inc.php,v 1.70 2006/03/26 19:55:33 sigurdne Exp $
* @internal $Source: /sources/phpgwapi/phpgwapi/setup/setup.inc.php,v $
*/
// Basic information about this app
$setup_info['phpgwapi']['name'] = 'phpgwapi';
$setup_info['phpgwapi']['title'] = 'phpgwapi';
- $setup_info['phpgwapi']['version'] = '0.9.17.502';
+ $setup_info['phpgwapi']['version'] = '0.9.17.503';
$setup_info['phpgwapi']['versions']['current_header'] = '1.24';
$setup_info['phpgwapi']['enable'] = 3;
$setup_info['phpgwapi']['app_order'] = 1;
@@ -56,6 +56,8 @@
$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';
// Basic information about this app
$setup_info['notifywindow']['name'] = 'notifywindow';
Index: phpgwapi/setup/tables_current.inc.php
diff -u phpgwapi/setup/tables_current.inc.php:1.57
phpgwapi/setup/tables_current.inc.php:1.58
--- phpgwapi/setup/tables_current.inc.php:1.57 Tue Mar 14 08:34:44 2006
+++ phpgwapi/setup/tables_current.inc.php Sun Mar 26 19:55:33 2006
@@ -5,7 +5,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package phpgwapi
* @subpackage setup
- * @version $Id: tables_current.inc.php,v 1.57 2006/03/14 08:34:44
sigurdne Exp $
+ * @version $Id: tables_current.inc.php,v 1.58 2006/03/26 19:55:33
sigurdne Exp $
* @internal $Source:
/sources/phpgwapi/phpgwapi/setup/tables_current.inc.php,v $
*/
@@ -601,5 +601,42 @@
'ix' =>
array('cust_field_value_val','cust_field_id','appname','location','rec_id'),
'uc' => array()
)
+ 'phpgw_cust_attribute' => array(
+ 'fd' => array(
+ 'appname' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'location' => array('type' =>
'varchar','precision' => '30','nullable' => False),
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'input_text' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'statustext' => array('type' =>
'varchar','precision' => '150','nullable' => False),
+ 'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
+ 'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'history' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'list' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
+ 'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => True)
+ ),
+ 'pk' => array('appname','location','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'phpgw_cust_choice' => array(
+ 'fd' => array(
+ 'appname' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'location' => array('type' =>
'varchar','precision' => '30','nullable' => False),
+ 'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'value' => array('type' => 'text','nullable' =>
False)
+ ),
+ 'pk' => array('appname','location','attrib_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
);
?>
Index: phpgwapi/setup/tables_update.inc.php
diff -u phpgwapi/setup/tables_update.inc.php:1.86
phpgwapi/setup/tables_update.inc.php:1.87
--- phpgwapi/setup/tables_update.inc.php:1.86 Mon Mar 13 13:46:47 2006
+++ phpgwapi/setup/tables_update.inc.php Sun Mar 26 19:55:33 2006
@@ -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.86 2006/03/13 13:46:47
sigurdne Exp $
+ * @version $Id: tables_update.inc.php,v 1.87 2006/03/26 19:55:33
sigurdne Exp $
* @internal $Source:
/sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v $
*/
@@ -1256,4 +1256,74 @@
return $GLOBALS['setup_info']['phpgwapi']['currentver'];
}
+
+ $test[] = '0.9.17.502';
+ function phpgwapi_upgrade0_9_17_502()
+ {
+ $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable(
+ 'phpgw_cust_attribute', array(
+ 'fd' => array(
+ 'appname' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'location' => array('type' =>
'varchar','precision' => '30','nullable' => False),
+ 'id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'input_text' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'statustext' => array('type' =>
'varchar','precision' => '150','nullable' => False),
+ 'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
+ 'search' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'history' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'list' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'size' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'scale' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
+ 'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => True)
+ ),
+ 'pk' => array('appname','location','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable(
+ 'phpgw_cust_choice', array(
+ 'fd' => array(
+ 'appname' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'location' => array('type' =>
'varchar','precision' => '30','nullable' => False),
+ 'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'value' => array('type' =>
'text','nullable' => False)
+ ),
+ 'pk' =>
array('appname','location','attrib_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
+
+
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_acl_location','allow_c_attrib',array(
+ 'type' => 'int',
+ 'precision' => '2',
+ 'nullable' => True
+ ));
+
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_acl_location','c_attrib_table
',array(
+ 'type' => 'varchar',
+ 'precision' => '25',
+ 'nullable' => True
+ ));
+
+ $GLOBALS['phpgw_setup']->oProc->query("DELETE FROM
phpgw_acl_location WHERE appname = 'tts' AND id = '.')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_acl_location (appname,id,
descr,allow_grant,allow_c_attrib,c_attrib_table) VALUES ('tts', '.',
'Top',1,1,'phpgw_tts_tickets')");
+
+ $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.17.503';
+ $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
+ return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+ }
+
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php setup.inc....,
Sigurd Nes <=