portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.script
Date Wed, 19 Jun 2002 05:20:37 GMT
taylor      2002/06/18 22:20:37

  Modified:    src/sql/external Tag: security_14 populate-db2.sql
                        populate-mysql.sql populate-oracle.sql
                        populate-postgres.sql populate-sybase.sql
               webapp/WEB-INF/db Tag: security_14 jetspeed.script
  Log:
  Added 'guest' role to default hypersonic db and db population scripts
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.6.2.2   +3 -0      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.6.2.1
  retrieving revision 1.6.2.2
  diff -u -r1.6.2.1 -r1.6.2.2
  --- populate-db2.sql	18 Jun 2002 06:49:35 -0000	1.6.2.1
  +++ populate-db2.sql	19 Jun 2002 05:20:37 -0000	1.6.2.2
  @@ -8,6 +8,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
   INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  @@ -26,6 +27,8 @@
   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_ROLE_PERMISSION VALUES(3,1);
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
  
  
  
  1.8.2.2   +3 -0      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.8.2.1
  retrieving revision 1.8.2.2
  diff -u -r1.8.2.1 -r1.8.2.2
  --- populate-mysql.sql	18 Jun 2002 06:49:35 -0000	1.8.2.1
  +++ populate-mysql.sql	19 Jun 2002 05:20:37 -0000	1.8.2.2
  @@ -8,6 +8,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
   INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  @@ -26,6 +27,8 @@
   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_ROLE_PERMISSION VALUES(3,1);
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
  
  
  
  1.4.2.2   +3 -0      jakarta-jetspeed/src/sql/external/populate-oracle.sql
  
  Index: populate-oracle.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-oracle.sql,v
  retrieving revision 1.4.2.1
  retrieving revision 1.4.2.2
  diff -u -r1.4.2.1 -r1.4.2.2
  --- populate-oracle.sql	18 Jun 2002 06:49:35 -0000	1.4.2.1
  +++ populate-oracle.sql	19 Jun 2002 05:20:37 -0000	1.4.2.2
  @@ -8,6 +8,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
   INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','David','Turbine','taylor@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
  @@ -26,6 +27,8 @@
   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_ROLE_PERMISSION VALUES(3,1);
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
   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);
  
  
  
  1.7.2.2   +3 -0      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.7.2.1
  retrieving revision 1.7.2.2
  diff -u -r1.7.2.1 -r1.7.2.2
  --- populate-postgres.sql	18 Jun 2002 06:49:35 -0000	1.7.2.1
  +++ populate-postgres.sql	19 Jun 2002 05:20:37 -0000	1.7.2.2
  @@ -8,6 +8,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
   INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F',NULL);
  @@ -26,6 +27,8 @@
   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_ROLE_PERMISSION VALUES(3,1);
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
  
  
  
  1.6.2.2   +3 -0      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.6.2.1
  retrieving revision 1.6.2.2
  diff -u -r1.6.2.1 -r1.6.2.2
  --- populate-sybase.sql	18 Jun 2002 06:49:35 -0000	1.6.2.1
  +++ populate-sybase.sql	19 Jun 2002 05:20:37 -0000	1.6.2.2
  @@ -8,6 +8,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
   INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','raphael@apache.org','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
  @@ -26,6 +27,8 @@
   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_ROLE_PERMISSION VALUES(3,1);
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
   INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
  
  
  
  No                   revision
  
  
  No                   revision
  
  
  1.13.2.10 +3 -0      jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
  
  Index: jetspeed.script
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
  retrieving revision 1.13.2.9
  retrieving revision 1.13.2.10
  diff -u -r1.13.2.9 -r1.13.2.10
  --- jetspeed.script	19 Jun 2002 05:14:12 -0000	1.13.2.9
  +++ jetspeed.script	19 Jun 2002 05:20:37 -0000	1.13.2.10
  @@ -97,6 +97,7 @@
   INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL)
   INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL)
   INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL)
  +INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL)
   INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
   INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL)
   INSERT INTO TURBINE_USER VALUES(0,'turbine','turbine','Tommy','Turbine','david@bluesunrise.com','CONFIRMED',NULL,NULL,'2002-06-04
16:05:25.712','F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000577080000000700000003740008756e69747465737474000074000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b020000787000000076740007555345525f49447400013078')
  @@ -115,6 +116,8 @@
   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_ROLE_PERMISSION VALUES(3,1)
  +INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6)
   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)
  
  
  

--
To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message