taylor 2004/05/24 10:54:09 Added: src/sql/mysql populate-userinfo-for-default-psml.sql Log: MySQL script for UserInfo
PR: Obtained from: Submitted by: Reviewed by: CVS: ---------------------------------------------------------------------- CVS: PR: CVS: If this change addresses a PR in the problem report tracking CVS: database, then enter the PR number(s) here. CVS: Obtained from: CVS: If this change has been taken from another system, such as NCSA, CVS: then name the system in this line, otherwise delete it. CVS: Submitted by: CVS: If this code has been contributed to Apache by someone else; i.e., CVS: they sent us a patch or a new module, then include their name/email CVS: address here. If this is your work then delete this line. CVS: Reviewed by: CVS: If we are doing pre-commit code reviews and someone else has CVS: reviewed your changes, include their name(s) here. CVS: If you have not had it reviewed then delete this line. Revision Changes Path 1.1 jakarta-jetspeed-2/src/sql/mysql/populate-userinfo-for-default-psml.sql Index: populate-userinfo-for-default-psml.sql =================================================================== 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','/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','/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','/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','/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','/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','/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','/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','/role/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,null,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,null,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,null,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,null,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,null,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); 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); --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
