You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ki...@apache.org on 2002/03/06 19:17:46 UTC

cvs commit: jakarta-jetspeed/src/sql/external populate-db2.sql populate-mysql.sql populate-postgres.sql populate-sybase.sql

kimptoc     02/03/06 10:17:46

  Modified:    src/sql/external populate-db2.sql populate-mysql.sql
                        populate-postgres.sql populate-sybase.sql
  Log:
  fix invalid references in the sql scripts
  
  Revision  Changes    Path
  1.5       +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.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- populate-db2.sql	25 Feb 2002 16:42:37 -0000	1.4
  +++ populate-db2.sql	6 Mar 2002 18:17:46 -0000	1.5
  @@ -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(1,1,2);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,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.7       +2 -2      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.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- populate-mysql.sql	25 Feb 2002 16:42:37 -0000	1.6
  +++ populate-mysql.sql	6 Mar 2002 18:17:46 -0000	1.7
  @@ -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(1,1,2);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,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.6       +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.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- populate-postgres.sql	25 Feb 2002 16:42:37 -0000	1.5
  +++ populate-postgres.sql	6 Mar 2002 18:17:46 -0000	1.6
  @@ -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(1,1,2);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,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.5       +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.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- populate-sybase.sql	25 Feb 2002 16:42:37 -0000	1.4
  +++ populate-sybase.sql	6 Mar 2002 18:17:46 -0000	1.5
  @@ -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(1,1,2);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
  +INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>