[20893] Code cleaning : Removing NULL vars for auto-incremented fields ( works with MySQL but not with PostgreSQL)

Pascal Vilarem <[email protected]>
Newsgroups gmane.comp.web.phpgroupware.cvs
Message-ID <[email protected]> 
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.