taylor 01/12/07 09:05:05 Modified: src/sql/external populate-db2.sql populate-mysql.sql populate-postgres.sql populate-sybase.sql Log: - fixed external database population scripts thanks to John Mettraux. Revision Changes Path 1.2 +2 -2 jakarta-jetspeed/src/sql/external/populate-db2.sql Index: populate-db2.sql =================================================================== RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-db2.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- populate-db2.sql 2001/07/30 04:30:11 1.1 +++ populate-db2.sql 2001/12/07 17:05:04 1.2 @@ -25,9 +25,9 @@ INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,2); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2); INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10); INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10); INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10); 1.3 +3 -3 jakarta-jetspeed/src/sql/external/populate-mysql.sql Index: populate-mysql.sql =================================================================== RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-mysql.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- populate-mysql.sql 2001/07/30 04:30:11 1.2 +++ populate-mysql.sql 2001/12/07 17:05:04 1.3 @@ -25,9 +25,9 @@ INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,2); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1) +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1) +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2) INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10); INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10); INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10); 1.3 +2 -2 jakarta-jetspeed/src/sql/external/populate-postgres.sql Index: populate-postgres.sql =================================================================== RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-postgres.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- populate-postgres.sql 2001/08/02 01:09:23 1.2 +++ populate-postgres.sql 2001/12/07 17:05:04 1.3 @@ -25,9 +25,9 @@ INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,2); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2); INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10); INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10); INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10); 1.2 +2 -2 jakarta-jetspeed/src/sql/external/populate-sybase.sql Index: populate-sybase.sql =================================================================== RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-sybase.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- populate-sybase.sql 2001/07/30 04:30:11 1.1 +++ populate-sybase.sql 2001/12/07 17:05:04 1.2 @@ -25,9 +25,9 @@ INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6); INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1); INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1); -INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,2); +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2); INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10); INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10); INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10);
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>