[Phpgroupware-cvs] [20893] Code cleaning : Removing NULL vars for auto-i

phpgroupware-cvs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] [20893] Code cleaning : Removing NULL vars for auto-i

From:	Pascal Vilarem
Subject:	[Phpgroupware-cvs] [20893] Code cleaning : Removing NULL vars for auto-incremented fields ( works with MySQL but not with PostgreSQL)
Date:	Wed, 25 Nov 2009 13:25:37 +0000
Revision: 20893
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=20893
Author:   maat
Date:     2009-11-25 13:25:37 +0000 (Wed, 25 Nov 2009)
Log Message:
-----------
Code cleaning : Removing NULL vars for auto-incremented fields (works with 
MySQL but not with PostgreSQL)

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-25 12:58:14 UTC 
(rev 20892)
+++ modules/ged/trunk/setup/default_records.inc.php     2009-11-25 13:25:37 UTC 
(rev 20893)
@@ -244,86 +244,86 @@
 
 $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 (transition, account_id, 
context) VALUES (1,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (2,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (3,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (4,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (5,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (6,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (7,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (8,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (9,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (10,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (11,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (12,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (13,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (14,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (15,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (16,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (17,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (18,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (19,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (21,$admins_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (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 (transition, account_id, 
context) VALUES (1,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (2,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (3,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (4,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (5,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (6,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (7,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (8,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (9,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (10,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (11,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (12,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (13,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (14,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (15,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (16,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (17,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (18,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (19,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (20,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (21,$managers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (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 (transition, account_id, 
context) VALUES (1,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (16,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (17,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (18,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (19,$teams_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (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 (transition, account_id, 
context) VALUES (1,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (16,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (17,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (18,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (19,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (22,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (3,$quality_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (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 (transition, account_id, 
context) VALUES (5,$customers_uid,NULL)" );
+$oProc->query ("INSERT INTO phpgw_flows_roles (transition, account_id, 
context) VALUES (6,$customers_uid,NULL)" );
 
 ?>
\ No newline at end of file
[Prev in Thread]
Current Thread
[Next in Thread]
[Phpgroupware-cvs] [20893] Code cleaning : Removing NULL vars for auto-incremented fields ( works with MySQL but not with PostgreSQL), Pascal Vilarem <=
Prev by Date: [Phpgroupware-cvs] [20892] Code cleaning : removed ` in SQL statements to make them PostgreSQL compliant
Next by Date: [Phpgroupware-cvs] [20894] Bug fix : Fixing get_var to phpgw::get_var stuff
Previous by thread: [Phpgroupware-cvs] [20892] Code cleaning : removed ` in SQL statements to make them PostgreSQL compliant
Next by thread: [Phpgroupware-cvs] [20894] Bug fix : Fixing get_var to phpgw::get_var stuff
Index(es):
- Date
- Thread