[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] [20892] Code cleaning : removed ` in SQL statements t
From: |
Pascal Vilarem |
Subject: |
[Phpgroupware-cvs] [20892] Code cleaning : removed ` in SQL statements to make them PostgreSQL compliant |
Date: |
Wed, 25 Nov 2009 12:58:15 +0000 |
Revision: 20892
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=20892
Author: maat
Date: 2009-11-25 12:58:14 +0000 (Wed, 25 Nov 2009)
Log Message:
-----------
Code cleaning : removed ` in SQL statements to make them PostgreSQL compliant
Modified Paths:
--------------
modules/ged/trunk/setup/default_records.inc.php
Modified: modules/ged/trunk/setup/default_records.inc.php
===================================================================
--- modules/ged/trunk/setup/default_records.inc.php 2009-11-23 20:14:55 UTC
(rev 20891)
+++ modules/ged/trunk/setup/default_records.inc.php 2009-11-25 12:58:14 UTC
(rev 20892)
@@ -167,163 +167,163 @@
// ged default flow : flow
-$oProc->query ("INSERT INTO `phpgw_flows` VALUES (1,'ged','default')" );
+$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')" );
-$oProc->query ("INSERT INTO `phpgw_flows_statuses` VALUES ('working_locked',
'ged', 'working (locked)')" );
+$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')" );
+$oProc->query ("INSERT INTO phpgw_flows_statuses VALUES ('working_locked',
'ged', 'working (locked)')" );
// 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')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (16, 1,
'working', 'working', 'update', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (17, 1,
'current', 'current', 'update', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (18, 1,
'refused', 'refused', 'update', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (19, 1,
'working', 'working_locked', 'lock', 'set_status')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (20, 1,
'working_locked', 'working', 'unlock', 'set_status')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (21, 1,
'working_locked', 'working_locked', 'update', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions` VALUES (22, 1,
'pending_for_acceptation', 'pending_for_acceptation', 'update', 'update')" );
+$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')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (16, 1, 'working',
'working', 'update', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (17, 1, 'current',
'current', 'update', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (18, 1, 'refused',
'refused', 'update', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (19, 1, 'working',
'working_locked', 'lock', 'set_status')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (20, 1,
'working_locked', 'working', 'unlock', 'set_status')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (21, 1,
'working_locked', 'working_locked', 'update', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions VALUES (22, 1,
'pending_for_acceptation', 'pending_for_acceptation', 'update', 'update')" );
// 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')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (7,
16, 'update_mode', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (8,
17, 'update_mode', 'new')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES (9,
18, 'update_mode', 'new')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES
(10, 21, 'update_mode', 'update')" );
-$oProc->query ("INSERT INTO `phpgw_flows_transitions_custom_values` VALUES
(11, 22, 'update_mode', 'new')" );
+$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')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions_custom_values VALUES (7,
16, 'update_mode', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions_custom_values VALUES (8,
17, 'update_mode', 'new')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions_custom_values VALUES (9,
18, 'update_mode', 'new')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions_custom_values VALUES (10,
21, 'update_mode', 'update')" );
+$oProc->query ("INSERT INTO phpgw_flows_transitions_custom_values VALUES (11,
22, 'update_mode', 'new')" );
// 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;}')"
);
-$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (5,19, 'ged',
'flows', 'grant_role', 'a:1:{s:10:\"transition\";i:20;}')" );
-$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (6,20, 'ged',
'flows', 'remove_role', 'a:1:{s:10:\"transition\";i:20;}')" );
-$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (7,19, 'ged',
'flows', 'grant_role', 'a:1:{s:10:\"transition\";i:21;}')" );
-$oProc->query ("INSERT INTO `phpgw_flows_triggers` VALUES (8,20, 'ged',
'flows', 'remove_role', 'a:1:{s:10:\"transition\";i:21;}')" );
+$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;}')"
);
+$oProc->query ("INSERT INTO phpgw_flows_triggers VALUES (5,19, 'ged', 'flows',
'grant_role', 'a:1:{s:10:\"transition\";i:20;}')" );
+$oProc->query ("INSERT INTO phpgw_flows_triggers VALUES (6,20, 'ged', 'flows',
'remove_role', 'a:1:{s:10:\"transition\";i:20;}')" );
+$oProc->query ("INSERT INTO phpgw_flows_triggers VALUES (7,19, 'ged', 'flows',
'grant_role', 'a:1:{s:10:\"transition\";i:21;}')" );
+$oProc->query ("INSERT INTO phpgw_flows_triggers VALUES (8,20, 'ged', 'flows',
'remove_role', 'a:1:{s:10:\"transition\";i:21;}')" );
// ged default flow : conditions
-$oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`,
`transition`, `app`, `class`, `method`, `context`) VALUES (1, 17, 'ged',
'flow_client', 'is_last_version', '')");
-$oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`,
`transition`, `app`, `class`, `method`, `context`) VALUES (2, 18, 'ged',
'flow_client', 'is_last_version', '')");
-$oProc->query ("INSERT INTO `phpgw_flows_conditions` (`condition_id`,
`transition`, `app`, `class`, `method`, `context`) VALUES (3, 22, 'ged',
'flow_client', 'is_last_version', '')");
+$oProc->query ("INSERT INTO phpgw_flows_conditions (condition_id, transition,
app, class, method, context) VALUES (1, 17, 'ged', 'flow_client',
'is_last_version', '')");
+$oProc->query ("INSERT INTO phpgw_flows_conditions (condition_id, transition,
app, class, method, context) VALUES (2, 18, 'ged', 'flow_client',
'is_last_version', '')");
+$oProc->query ("INSERT INTO phpgw_flows_conditions (condition_id, transition,
app, class, method, context) VALUES (3, 22, 'ged', 'flow_client',
'is_last_version', '')");
// ged default flow : admin roles
$admins_uid=2;
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,1,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,2,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,3,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,4,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,5,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,6,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,7,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,8,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,9,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,10,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,11,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,12,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,13,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,14,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,15,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,16,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,17,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,18,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,19,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,21,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,21,$admins_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,22,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,1,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,2,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,3,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,4,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,5,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,6,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,7,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,8,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,9,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,10,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,11,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,12,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,13,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,14,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,15,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,16,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,17,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,18,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,19,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,22,$admins_uid,NULL)" );
// ged default flow : managers roles
$managers_uid=3;
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,1,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,2,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,3,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,4,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,5,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,6,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,7,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,8,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,9,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,10,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,11,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,12,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,13,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,14,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,15,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,16,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,17,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,18,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,19,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,20,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,21,$managers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,22,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,1,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,2,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,3,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,4,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,5,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,6,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,7,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,8,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,9,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,10,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,11,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,12,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,13,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,14,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,15,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,16,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,17,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,18,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,19,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,20,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,21,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,22,$managers_uid,NULL)" );
// ged default flow : team roles
$teams_uid=4;
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,1,$teams_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,16,$teams_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,17,$teams_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,18,$teams_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,19,$teams_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,22,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES (NULL,1,$teams_uid,NULL)"
);
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,16,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,17,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,18,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,19,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,22,$teams_uid,NULL)" );
// ged default flow : quality roles
$quality_uid=5;
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,1,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,16,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,17,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,18,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,19,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,22,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,3,$quality_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,8,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,1,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,16,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,17,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,18,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,19,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,22,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,3,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,8,$quality_uid,NULL)" );
// ged default flow : customer roles
$customers_uid=6;
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,5,$customers_uid,NULL)" );
-$oProc->query ("INSERT INTO `phpgw_flows_roles` VALUES
(NULL,6,$customers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,5,$customers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles VALUES
(NULL,6,$customers_uid,NULL)" );
?>
\ No newline at end of file
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] [20892] Code cleaning : removed ` in SQL statements to make them PostgreSQL compliant,
Pascal Vilarem <=