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 2004/12/04 00:12:12 UTC
cvs commit: jakarta-jetspeed-2/src/sql/mssql populate-userinfo-for-default-psml.sql
taylor 2004/12/03 15:12:12
Modified: src/sql/mysql drop.sql
src/sql/oracle drop.sql
src/sql/mssql populate-userinfo-for-default-psml.sql
Log:
*** keyword substitution change ***
Revision Changes Path
1.2 +11 -11 jakarta-jetspeed-2/src/sql/mysql/drop.sql
Index: drop.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/mysql/drop.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- drop.sql 3 Dec 2004 22:00:22 -0000 1.1
+++ drop.sql 3 Dec 2004 23:12:12 -0000 1.2
@@ -1,12 +1,12 @@
-drop table if exists RULE_CRITERION;
-drop table if exists PRINCIPAL_PERMISSION;
-drop table if exists PA_METADATA_FIELDS;
-drop table if exists PD_METADATA_FIELDS;
-drop table if exists USER_ATTRIBUTE_REF;
-drop table if exists USER_ATTRIBUTE;
-drop table if exists SECURITY_CREDENTIAL;
-drop table if exists SSO_SITE_TO_PRINCIPALS;
-drop table if exists SSO_PRINCIPAL_TO_REMOTE_PRINCIPAL;
-drop table if exists SECURITY_USER_ROLE;
-drop table if exists SECURITY_USER_GROUP;
+drop table if exists RULE_CRITERION;
+drop table if exists PRINCIPAL_PERMISSION;
+drop table if exists PA_METADATA_FIELDS;
+drop table if exists PD_METADATA_FIELDS;
+drop table if exists USER_ATTRIBUTE_REF;
+drop table if exists USER_ATTRIBUTE;
+drop table if exists SECURITY_CREDENTIAL;
+drop table if exists SSO_SITE_TO_PRINCIPALS;
+drop table if exists SSO_PRINCIPAL_TO_REMOTE_PRINCIPAL;
+drop table if exists SECURITY_USER_ROLE;
+drop table if exists SECURITY_USER_GROUP;
drop table if exists SECURITY_GROUP_ROLE;
1.2 +78 -78 jakarta-jetspeed-2/src/sql/oracle/drop.sql
Index: drop.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/oracle/drop.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- drop.sql 3 Dec 2004 22:00:22 -0000 1.1
+++ drop.sql 3 Dec 2004 23:12:12 -0000 1.2
@@ -1,78 +1,78 @@
-drop table A;
-drop table B;
-
-drop table OJB_HL_SEQ;
-drop table OJB_LOCKENTRY;
-drop table OJB_NRM;
-drop table OJB_DLIST;
-drop table OJB_DLIST_ENTRIES;
-drop table OJB_DSET;
-drop table OJB_DSET_ENTRIES;
-drop table OJB_DMAP;
-
-
-DROP TABLE CAPABILITY;
-DROP TABLE MIMETYPE;
-DROP TABLE CLIENT;
-DROP TABLE MEDIA_TYPE;
-
-DROP TABLE CLIENT_TO_CAPABILITY;
-DROP TABLE CLIENT_TO_MIMETYPE;
-DROP TABLE MEDIATYPE_TO_CAPABILITY;
-DROP TABLE MEDIATYPE_TO_MIMETYPE;
-
-DROP TABLE SUB_PAGES;
-DROP TABLE PAGE;
-DROP TABLE FRAGMENT;
-DROP TABLE PAGE_FRAGMENTS;
-DROP TABLE SUB_FRAGMENTS;
-DROP TABLE FRAGMENT_PARAMETER;
-DROP TABLE FRAGMENT_REF;
-DROP TABLE FRAGMENT_REFS;
-DROP TABLE RULE_CRITERION;
-DROP TABLE PRINCIPAL_RULE_ASSOC;
-DROP TABLE PROFILE_PAGE_ASSOC;
-DROP TABLE PROFILING_RULE;
-
------------------------------------------------------------------------------
--- drop preferences schema
------------------------------------------------------------------------------
-drop table PREFS_PROPERTY_VALUE;
-drop table PREFS_NODE_PROPERTY_KEY;
-drop table PREFS_PROPERTY_KEY;
-drop table PREFS_NODE;
-
-DROP TABLE PA_METADATA_FIELDS;
-DROP TABLE PD_METADATA_FIELDS;
-DROP TABLE LANGUAGE;
-DROP TABLE PORTLET_CONTENT_TYPE;
-DROP TABLE PARAMETER;
-DROP TABLE PREFERENCE_VALUE;
-DROP TABLE PORTLET_PREFERENCE;
-DROP TABLE PORTLET_ENTITY;
-DROP TABLE SECURITY_ROLE_REFERENCE;
-DROP TABLE SECURITY_ROLE;
-DROP TABLE USER_ATTRIBUTE_REF;
-DROP TABLE USER_ATTRIBUTE;
-DROP TABLE JETSPEED_SERVICE;
-
-DROP TABLE LOCALIZED_DESCRIPTION;
-DROP TABLE LOCALIZED_DISPLAY_NAME;
-
-DROP TABLE WEB_APPLICATION;
-DROP TABLE PORTLET_DEFINITION;
-DROP TABLE PORTLET_APPLICATION;
-
-drop table PRINCIPAL_PERMISSION;
-DROP TABLE SECURITY_CREDENTIAL;
-drop table SSO_SITE_TO_PRINCIPALS;
-drop table SSO_PRINCIPAL_TO_REMOTE;
-DROP TABLE SECURITY_USER_ROLE;
-DROP TABLE SECURITY_USER_GROUP;
-DROP TABLE SECURITY_GROUP_ROLE;
-
-
-drop table SSO_SITE;
-drop table SECURITY_PERMISSION;
-drop table SECURITY_PRINCIPAL;
-
+drop table A;
+drop table B;
+
+drop table OJB_HL_SEQ;
+drop table OJB_LOCKENTRY;
+drop table OJB_NRM;
+drop table OJB_DLIST;
+drop table OJB_DLIST_ENTRIES;
+drop table OJB_DSET;
+drop table OJB_DSET_ENTRIES;
+drop table OJB_DMAP;
+
+
+DROP TABLE CAPABILITY;
+DROP TABLE MIMETYPE;
+DROP TABLE CLIENT;
+DROP TABLE MEDIA_TYPE;
+
+DROP TABLE CLIENT_TO_CAPABILITY;
+DROP TABLE CLIENT_TO_MIMETYPE;
+DROP TABLE MEDIATYPE_TO_CAPABILITY;
+DROP TABLE MEDIATYPE_TO_MIMETYPE;
+
+DROP TABLE SUB_PAGES;
+DROP TABLE PAGE;
+DROP TABLE FRAGMENT;
+DROP TABLE PAGE_FRAGMENTS;
+DROP TABLE SUB_FRAGMENTS;
+DROP TABLE FRAGMENT_PARAMETER;
+DROP TABLE FRAGMENT_REF;
+DROP TABLE FRAGMENT_REFS;
+DROP TABLE RULE_CRITERION;
+DROP TABLE PRINCIPAL_RULE_ASSOC;
+DROP TABLE PROFILE_PAGE_ASSOC;
+DROP TABLE PROFILING_RULE;
+
+-----------------------------------------------------------------------------
+-- drop preferences schema
+-----------------------------------------------------------------------------
+drop table PREFS_PROPERTY_VALUE;
+drop table PREFS_NODE_PROPERTY_KEY;
+drop table PREFS_PROPERTY_KEY;
+drop table PREFS_NODE;
+
+DROP TABLE PA_METADATA_FIELDS;
+DROP TABLE PD_METADATA_FIELDS;
+DROP TABLE LANGUAGE;
+DROP TABLE PORTLET_CONTENT_TYPE;
+DROP TABLE PARAMETER;
+DROP TABLE PREFERENCE_VALUE;
+DROP TABLE PORTLET_PREFERENCE;
+DROP TABLE PORTLET_ENTITY;
+DROP TABLE SECURITY_ROLE_REFERENCE;
+DROP TABLE SECURITY_ROLE;
+DROP TABLE USER_ATTRIBUTE_REF;
+DROP TABLE USER_ATTRIBUTE;
+DROP TABLE JETSPEED_SERVICE;
+
+DROP TABLE LOCALIZED_DESCRIPTION;
+DROP TABLE LOCALIZED_DISPLAY_NAME;
+
+DROP TABLE WEB_APPLICATION;
+DROP TABLE PORTLET_DEFINITION;
+DROP TABLE PORTLET_APPLICATION;
+
+drop table PRINCIPAL_PERMISSION;
+DROP TABLE SECURITY_CREDENTIAL;
+drop table SSO_SITE_TO_PRINCIPALS;
+drop table SSO_PRINCIPAL_TO_REMOTE;
+DROP TABLE SECURITY_USER_ROLE;
+DROP TABLE SECURITY_USER_GROUP;
+DROP TABLE SECURITY_GROUP_ROLE;
+
+
+drop table SSO_SITE;
+drop table SECURITY_PERMISSION;
+drop table SECURITY_PRINCIPAL;
+
1.7 +54 -54 jakarta-jetspeed-2/src/sql/mssql/populate-userinfo-for-default-psml.sql
Index: populate-userinfo-for-default-psml.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/mssql/populate-userinfo-for-default-psml.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- populate-userinfo-for-default-psml.sql 25 Nov 2004 02:25:58 -0000 1.6
+++ populate-userinfo-for-default-psml.sql 3 Dec 2004 23:12:12 -0000 1.7
@@ -1,54 +1,54 @@
-INSERT INTO PREFS_NODE VALUES(1,NULL,'',0,'/','2004-05-22 14:57:53.586','2004-05-22 14:57:53.586');
-INSERT INTO PREFS_NODE VALUES(101,1,'user',0,'/user','2004-05-22 16:27:12.472','2004-05-22 16:27:12.472');
-INSERT INTO PREFS_NODE VALUES(102,101,'admin',0,'/user/admin','2004-05-22 16:27:12.482','2004-05-22 16:27:12.482');
-INSERT INTO PREFS_NODE VALUES(103,102,'userinfo',0,'/user/admin/userinfo','2004-05-22 16:27:12.522','2004-05-22 16:27:12.532');
-INSERT INTO SECURITY_PRINCIPAL VALUES(1,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/admin','2004-05-22 16:27:12.442','2004-05-22 16:27:12.442');
-INSERT INTO PREFS_PROPERTY_KEY VALUES(61,'user.name.given',3,'2004-05-22 16:27:12.532','2004-05-22 16:27:12.532');
-INSERT INTO PREFS_PROPERTY_VALUE VALUES(41,103,61,0,NULL,0,0.0E0,'Test Dude','2004-05-22 16:27:12.562','2004-05-22 16:27:12.562');
-INSERT INTO PREFS_PROPERTY_KEY VALUES(62,'user.name.family',3,'2004-05-22 16:27:12.532','2004-05-22 16:27:12.532');
-INSERT INTO PREFS_PROPERTY_VALUE VALUES(42,103,62,0,NULL,0,0.0E0,'Dudley','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(2,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(3,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(4,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/tomcat','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/admin','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/guest','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(10,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/guest','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/accounting','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/marketing','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PRINCIPAL VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/engineering','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
-INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
-INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
-INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
-INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
-INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
-INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
-INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
-INSERT INTO SECURITY_USER_ROLE VALUES(2,7);
-INSERT INTO SECURITY_USER_ROLE VALUES(2,8);
-INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
-INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
-INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
-INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
-INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
-INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
-INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
+INSERT INTO PREFS_NODE VALUES(1,NULL,'',0,'/','2004-05-22 14:57:53.586','2004-05-22 14:57:53.586');
+INSERT INTO PREFS_NODE VALUES(101,1,'user',0,'/user','2004-05-22 16:27:12.472','2004-05-22 16:27:12.472');
+INSERT INTO PREFS_NODE VALUES(102,101,'admin',0,'/user/admin','2004-05-22 16:27:12.482','2004-05-22 16:27:12.482');
+INSERT INTO PREFS_NODE VALUES(103,102,'userinfo',0,'/user/admin/userinfo','2004-05-22 16:27:12.522','2004-05-22 16:27:12.532');
+INSERT INTO SECURITY_PRINCIPAL VALUES(1,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/admin','2004-05-22 16:27:12.442','2004-05-22 16:27:12.442');
+INSERT INTO PREFS_PROPERTY_KEY VALUES(61,'user.name.given',3,'2004-05-22 16:27:12.532','2004-05-22 16:27:12.532');
+INSERT INTO PREFS_PROPERTY_VALUE VALUES(41,103,61,0,NULL,0,0.0E0,'Test Dude','2004-05-22 16:27:12.562','2004-05-22 16:27:12.562');
+INSERT INTO PREFS_PROPERTY_KEY VALUES(62,'user.name.family',3,'2004-05-22 16:27:12.532','2004-05-22 16:27:12.532');
+INSERT INTO PREFS_PROPERTY_VALUE VALUES(42,103,62,0,NULL,0,0.0E0,'Dudley','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(2,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(3,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(4,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/tomcat','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/admin','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/guest','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(10,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/guest','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/accounting','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/marketing','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/engineering','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
+INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
+INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
+INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
+INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
+INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
+INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
+INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
+INSERT INTO SECURITY_USER_ROLE VALUES(2,7);
+INSERT INTO SECURITY_USER_ROLE VALUES(2,8);
+INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
+INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
+INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
+INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
+INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
+INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org