portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r345855 - in /portals/jetspeed-2/trunk/etc/sql: ./ hsql/ mssql/ mysql/ oracle/
Date Mon, 21 Nov 2005 07:03:22 GMT
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


Mime
View raw message