taylor 2004/10/15 00:06:48 Modified: src/sql populate-db-default.sql Added: src/sql/mssql populate-userinfo-for-default-psml.sql Log: add MS SQL support to population scripts patch from Randy Watler Revision Changes Path 1.6 +3 -3 jakarta-jetspeed-2/src/sql/populate-db-default.sql Index: populate-db-default.sql =================================================================== RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/populate-db-default.sql,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- populate-db-default.sql 8 Oct 2004 06:49:37 -0000 1.5 +++ populate-db-default.sql 15 Oct 2004 07:06:48 -0000 1.6 @@ -307,6 +307,6 @@ insert into PRINCIPAL_RULE_ASSOC values ( 'guest', 'page', 'j1' ); insert into PRINCIPAL_RULE_ASSOC values ( 'jetspeed', 'page', 'role-fallback' ); - - - +insert into PRINCIPAL_RULE_ASSOC values ( 'jetspeed', 'docset', 'role-group' ); +insert into PRINCIPAL_RULE_ASSOC values ( 'user', 'page', 'j1' ); +insert into PRINCIPAL_RULE_ASSOC values ( 'user', 'docset', 'role-group' ); 1.1 jakarta-jetspeed-2/src/sql/mssql/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_PRINCIPAL VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl','/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','/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','/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','/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','/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.PasswordCredential','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.PasswordCredential','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572'); INSERT INTO SECURITY_CREDENTIAL VALUES(9,9,'guest',0,'org.apache.jetspeed.security.PasswordCredential','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); INSERT INTO SECURITY_USER_ROLE VALUES(9,10); INSERT INTO SECURITY_USER_ROLE VALUES(5,7); --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
