[Phpgroupware-cvs] ged/setup tables

phpgroupware-cvs
[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:	Thu, 25 Oct 2007 17:02:39 +0000
CVSROOT:        /sources/phpgroupware
Module name:    ged
Changes by:     Pascal Vilarem <maat>   07/10/25 17:02:39

Modified files:
        setup          : tables_update.inc.php 

Log message:
        bugfix in update function for version 007

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/ged/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.13&r2=1.14

Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/tables_update.inc.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -b -r1.13 -r1.14
--- tables_update.inc.php       25 Oct 2007 15:54:46 -0000      1.13
+++ tables_update.inc.php       25 Oct 2007 17:02:39 -0000      1.14
@@ -218,10 +218,10 @@
 
        }       
 
-       function ged_upgrade0_9_18_005()
+       function ged_upgrade0_9_18_006()
        {
 
-               $GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows' => 
array(
+               $GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows', 
array(
                        'fd' => array(
                                'flow' => array('type' => 'auto','nullable' => 
False),
                                'app' => array('type' => 'varchar', 'precision' 
=> 20,'nullable' => False),
@@ -234,13 +234,13 @@
                )
                );
                
-               $GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_roles' 
=> array(
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_roles', array(
                        'fd' => array(
                                'role' => array('type' => 'auto','nullable' => 
False),
                                'transition' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'account_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'context' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True)
-                       )
+                       ),
                        'pk' => array('role'),
                        'fk' => array(),
                        'ix' => array(),
@@ -248,7 +248,7 @@
                )
                );
                
-               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_statuses' => array(
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_statuses', array(
                        'fd' => array(
                                'status_id' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False),
                                'app' => array('type' => 'varchar', 'precision' 
=> 20,'nullable' => False),
@@ -261,7 +261,7 @@
                )
                );
                
-               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_transitions' => array(
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_transitions', array(
                        'fd' => array(
                                'transition' => array('type' => 
'auto','nullable' => False),
                                'flow' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
@@ -277,7 +277,7 @@
                )
                );
                
-               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_transitions_custom_values'
 => array(
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_transitions_custom_values',
 array(
                        'fd' => array(
                                'custom_value_id' => array('type' => 
'auto','nullable' => False),
                                'transition' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
@@ -291,7 +291,7 @@
                )
                );
                
-               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_triggers' => array(
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_flows_triggers', array(
                        'fd' => array(
                                'trigger_id' => array('type' => 
'auto','nullable' => False),
                                'transition' => array('type' => 'int', 
'precision' => 4,'nullable' => False,'default' => '11'),
@@ -309,72 +309,72 @@
                
                // ged default flow : flow
                
-               $oProc->query ("INSERT INTO `phpgw_flows` VALUES 
(1,'ged','default');" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows` VALUES (1,'ged','default');" );
                
                // ged default flow : statuses
                
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('working','ged','working')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('pending_for_technical_review','ged','pending for technical review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('pending_for_quality_review','ged','pending for quality review')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('ready_for_delivery','ged','ready for delivery')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('pending_for_acceptation','ged','pending for final acceptation')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('current','ged','current')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('refused','ged','refused')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('obsolete','ged','obsolete')," );
-               $oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES 
('alert','ged','alert');" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('working','ged','working')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('pending_for_technical_review','ged','pending 
for technical review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('pending_for_quality_review','ged','pending for 
quality review')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('ready_for_delivery','ged','ready for 
delivery')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('pending_for_acceptation','ged','pending for 
final acceptation')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('current','ged','current')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('refused','ged','refused')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('obsolete','ged','obsolete')," );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_statuses` VALUES ('alert','ged','alert');" );
                
                // ged default flow : transitions
                
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(1,1,'working','pending_for_technical_review','submit file','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(2,1,'pending_for_technical_review','pending_for_quality_review','approve file 
(technical)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(3,1,'pending_for_quality_review','ready_for_delivery','approve file 
(quality)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(4,1,'ready_for_delivery','pending_for_acceptation','deliver 
file','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(5,1,'pending_for_acceptation','current','accept file 
(final)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(6,1,'pending_for_acceptation','refused','refuse file 
(final)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(7,1,'pending_for_technical_review','working','reject file 
(technical)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(8,1,'pending_for_quality_review','working','reject file 
(quality)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(9,1,'pending_for_technical_review','current','accept file 
(force)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(10,1,'pending_for_quality_review','current','accept file 
(force)','set_status_with_review')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(11,1,'current','obsolete','obsolete','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(12,1,'working','current','accept file (force)','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(13,1,'current','alert','alert','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(14,1,'alert','current','cancel alert','set_status')" );
-               $oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES 
(15,1,'alert','obsolete','obsolete','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(1,1,'working','pending_for_technical_review','submit file','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(2,1,'pending_for_technical_review','pending_for_quality_review','approve file 
(technical)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(3,1,'pending_for_quality_review','ready_for_delivery','approve file 
(quality)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(4,1,'ready_for_delivery','pending_for_acceptation','deliver 
file','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(5,1,'pending_for_acceptation','current','accept file 
(final)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(6,1,'pending_for_acceptation','refused','refuse file 
(final)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(7,1,'pending_for_technical_review','working','reject file 
(technical)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(8,1,'pending_for_quality_review','working','reject file 
(quality)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(9,1,'pending_for_technical_review','current','accept file 
(force)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(10,1,'pending_for_quality_review','current','accept file 
(force)','set_status_with_review')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(11,1,'current','obsolete','obsolete','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (12,1,'working','current','accept file 
(force)','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (13,1,'current','alert','alert','set_status')" 
);
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES (14,1,'alert','current','cancel 
alert','set_status')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions` VALUES 
(15,1,'alert','obsolete','obsolete','set_status')" );
                
                // ged default flow : transitions custom values
                
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(1,2,'review_file_type','fiche-relecture-interne')" );
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(2,3,'review_file_type','fiche-relecture-interne')" );
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(3,5,'review_file_type','fiche-relecture-externe')" );
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(4,6,'review_file_type','fiche-relecture-externe')" );
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(5,7,'review_file_type','fiche-relecture-interne')" );
-               $oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(6,8,'review_file_type','fiche-relecture-interne')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(1,2,'review_file_type','fiche-relecture-interne')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(2,3,'review_file_type','fiche-relecture-interne')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(3,5,'review_file_type','fiche-relecture-externe')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(4,6,'review_file_type','fiche-relecture-externe')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(5,7,'review_file_type','fiche-relecture-interne')" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_transitions_custom_values` VALUES 
(6,8,'review_file_type','fiche-relecture-interne')" );
                
                // ged default flow : triggers
                
-               $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(1,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:11;}')"
 );
-               $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(2,11,'ged','flow_client','apply_transition_to_linking_versions_with_link_type','a:2:{s:10:\"transition\";i:13;s:9:\"link_type\";s:10:\"dependancy\";}')"
 );
-               $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(3,4,'ged','flow_client','apply_transition_to_linked_versions_with_link_type','a:2:{s:10:\"transition\";i:4;s:9:\"link_type\";s:8:\"delivery\";}')"
 );
-               $oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES 
(4,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:15;}')"
 );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(1,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:11;}')"
 );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(2,11,'ged','flow_client','apply_transition_to_linking_versions_with_link_type','a:2:{s:10:\"transition\";i:13;s:9:\"link_type\";s:10:\"dependancy\";}')"
 );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(3,4,'ged','flow_client','apply_transition_to_linked_versions_with_link_type','a:2:{s:10:\"transition\";i:4;s:9:\"link_type\";s:8:\"delivery\";}')"
 );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_triggers` VALUES 
(4,5,'ged','flow_client','apply_transition_to_previous_versions_matching_status','a:1:{s:10:\"transition\";i:15;}')"
 );
                
                // ged default flow : admin roles
                
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(1,1,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(2,2,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(3,3,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(4,4,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(5,5,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(6,6,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(7,7,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(8,8,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(9,9,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(10,10,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(11,11,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(12,12,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(13,13,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(14,14,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(15,15,6,NULL)" );
-               $oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES 
(16,1,16,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (1,1,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (2,2,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (3,3,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (4,4,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (5,5,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (6,6,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (7,7,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (8,8,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (9,9,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (10,10,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (11,11,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (12,12,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (13,13,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (14,14,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (15,15,6,NULL)" );
+               $GLOBALS['phpgw_setup']->oProc->query ("INSERT INTO 
`phpgw_flows_roles` VALUES (16,1,16,NULL)" );
                
                $GLOBALS['setup_info']['ged']['currentver']='0.9.18.007';
                return $GLOBALS['setup_info']['ged']['currentver'];
[Prev in Thread]
Current Thread
[Next in Thread]
[Phpgroupware-cvs] ged/setup tables_update.inc.php, Pascal Vilarem <=
Prev by Date: [Phpgroupware-cvs] ged inc/class.ged_dm.inc.php inc/class.flow_cli...
Next by Date: [Phpgroupware-cvs] ged inc/class.ged_dm.inc.php inc/class.flows.in...
Previous by thread: [Phpgroupware-cvs] ged inc/class.ged_dm.inc.php inc/class.flow_cli...
Next by thread: [Phpgroupware-cvs] ged inc/class.ged_dm.inc.php inc/class.flows.in...
Index(es):
- Date
- Thread