[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] ged/setup tables_update.inc.php
|
From: |
Pascal Vilarem |
|
Subject: |
[Phpgroupware-cvs] ged/setup tables_update.inc.php |
|
Date: |
Tue, 10 Apr 2007 13:30:28 +0000 |
CVSROOT: /sources/phpgroupware
Module name: ged
Changes by: Pascal Vilarem <maat> 07/04/10 13:30:28
Modified files:
setup : tables_update.inc.php
Log message:
order of functions switched from Z to A
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/ged/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.5&r2=1.6
Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/tables_update.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -b -r1.5 -r1.6
--- tables_update.inc.php 10 Apr 2007 09:41:09 -0000 1.5
+++ tables_update.inc.php 10 Apr 2007 13:30:28 -0000 1.6
@@ -15,64 +15,6 @@
$test[]='0.9.16.001';
$test[]='0.9.18.001';
- function ged_upgrade0_9_18_001()
- {
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('ged_elements','project_name',
- array('type' => 'varchar', 'precision' => 255,'nullable' =>
True));
-
-
$GLOBALS['phpgw_setup']->oProc->AddColumn('ged_elements','project_root',
- array('type' => 'int', 'precision' => 4,'nullable' => True));
-
-
$GLOBALS['phpgw_setup']->oProc->AlterColumn('ged_versions','url',
- array('type' => 'varchar', 'precision' => 100,'nullable' =>
True));
-
- $GLOBALS['setup_info']['ged']['currentver']='0.9.18.002';
- return $GLOBALS['setup_info']['ged']['currentver'];
-
- }
-
- function ged_upgrade0_9_16_001()
- {
-
- $GLOBALS['phpgw_setup']->oProc->CreateTable( 'ged_relations'
,array(
- 'fd' => array(
- 'relation_id' => array('type' =>
'auto','nullable' => False),
- 'linked_version_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
- 'linking_version_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
- 'relation_type' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
- ),
- 'pk' => array('relation_id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ) );
-
- $GLOBALS['phpgw_setup']->oProc->DropTable('ged_history');
-
- $GLOBALS['phpgw_setup']->oProc->CreateTable('ged_history' ,
array(
- 'fd' => array(
- 'history_id' => array('type' =>
'auto','nullable' => False),
- 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'version_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'status' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
- 'action' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
- 'ip' => array('type' => 'varchar', 'precision'
=> 16,'nullable' => True),
- 'agent' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
- 'logdate' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
- 'comment' => array('type' => 'text','nullable'
=> True)
- ),
- 'pk' => array('history_id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ) );
-
- $GLOBALS['setup_info']['ged']['currentver']='0.9.18.001';
- return $GLOBALS['setup_info']['ged']['currentver'];
-
- }
-
function ged_upgrade0_9_16_000()
{
$GLOBALS['phpgw_setup']->oProc->AddColumn('ged_elements','validity_period',array('type'=>'int',
'precision'=>4, 'nullable'=>True, 'default'=>NULL));
@@ -141,4 +83,62 @@
return $GLOBALS['setup_info']['ged']['currentver'];
}
+ function ged_upgrade0_9_16_001()
+ {
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable( 'ged_relations'
,array(
+ 'fd' => array(
+ 'relation_id' => array('type' =>
'auto','nullable' => False),
+ 'linked_version_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'linking_version_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'relation_type' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
+ ),
+ 'pk' => array('relation_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ) );
+
+ $GLOBALS['phpgw_setup']->oProc->DropTable('ged_history');
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable('ged_history' ,
array(
+ 'fd' => array(
+ 'history_id' => array('type' =>
'auto','nullable' => False),
+ 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'version_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'status' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'action' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'ip' => array('type' => 'varchar', 'precision'
=> 16,'nullable' => True),
+ 'agent' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'logdate' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'comment' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('history_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ) );
+
+ $GLOBALS['setup_info']['ged']['currentver']='0.9.18.001';
+ return $GLOBALS['setup_info']['ged']['currentver'];
+
+ }
+
+ function ged_upgrade0_9_18_001()
+ {
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('ged_elements','project_name',
+ array('type' => 'varchar', 'precision' => 255,'nullable' =>
True));
+
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('ged_elements','project_root',
+ array('type' => 'int', 'precision' => 4,'nullable' => True));
+
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('ged_versions','url',
+ array('type' => 'varchar', 'precision' => 100,'nullable' =>
True));
+
+ $GLOBALS['setup_info']['ged']['currentver']='0.9.18.002';
+ return $GLOBALS['setup_info']['ged']['currentver'];
+
+ }
+
?>
\ No newline at end of file
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] ged/setup tables_update.inc.php,
Pascal Vilarem <=