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 ta...@apache.org on 2001/12/07 18:05:05 UTC
cvs commit: jakarta-jetspeed/src/sql/external populate-db2.sql populate-mysql.sql populate-postgres.sql populate-sybase.sql
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>