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'];
_______________________________________________
phpGroupWare-cvs mailing list
phpGroupWare-cvs@gnu.org
http://lists.gnu.org/mailman/listinfo/phpgroupware-cvs
