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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to