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 2005/11/21 08:03:22 UTC
svn commit: r345855 - in /portals/jetspeed-2/trunk/etc/sql: ./ hsql/ mssql/
mysql/ oracle/
Author: taylor
Date: Sun Nov 20 23:03:20 2005
New Revision: 345855
URL: http://svn.apache.org/viewcvs?rev=345855&view=rev
Log:
http://issues.apache.org/jira/browse/JS2-412
seed data was missing association table entries for sample user attributes
Modified:
portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql
portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql
portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql
portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql
portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql
Modified: portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql?rev=345855&r1=345854&r2=345855&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql Sun Nov 20 23:03:20 2005
@@ -7,6 +7,8 @@
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 PREFS_NODE_PROPERTY_KEY VALUES(103, 61);
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 62);
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');
Modified: portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql?rev=345855&r1=345854&r2=345855&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql Sun Nov 20 23:03:20 2005
@@ -7,6 +7,8 @@
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 PREFS_NODE_PROPERTY_KEY VALUES(103, 61);
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 62);
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');
Modified: portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql?rev=345855&r1=345854&r2=345855&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql Sun Nov 20 23:03:20 2005
@@ -7,6 +7,8 @@
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 PREFS_NODE_PROPERTY_KEY VALUES(103, 61);
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 62);
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');
Modified: portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql?rev=345855&r1=345854&r2=345855&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql Sun Nov 20 23:03:20 2005
@@ -7,6 +7,8 @@
INSERT INTO PREFS_PROPERTY_VALUE VALUES(41,103,61,0,NULL,0,0.0E0,'Test Dude',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO PREFS_PROPERTY_KEY VALUES(62,'user.name.family',3,to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO PREFS_PROPERTY_VALUE VALUES(42,103,62,0,NULL,0,0.0E0,'Dudley',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 61);
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 62);
INSERT INTO SECURITY_PRINCIPAL VALUES(2,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/manager',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO SECURITY_PRINCIPAL VALUES(3,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/user',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO SECURITY_PRINCIPAL VALUES(4,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/tomcat',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
Modified: portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql?rev=345855&r1=345854&r2=345855&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql Sun Nov 20 23:03:20 2005
@@ -7,6 +7,8 @@
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 PREFS_NODE_PROPERTY_KEY VALUES(103, 61);
+INSERT INTO PREFS_NODE_PROPERTY_KEY VALUES(103, 62);
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');
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org