Develop and Download Open Source Software

Portal Application Laboratory

Browse CVS Repository

/[OSDN]/pal/pal-portal/portal/patches/etc/sql/mysql/populate-userinfo-for-default-psml.sql

Contents of /pal/pal-portal/portal/patches/etc/sql/mysql/populate-userinfo-for-default-psml.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph

Revision 1.3 - (show annotations) (download)
Mon Dec 25 21:55:54 2006 UTC (17 years, 2 months ago) by shinsuke
Branch: MAIN
CVS Tags: RELEASE-1_0_BETA3, RELEASE-1_0_BETA4
Changes since 1.2: +6 -2 lines 
added cms-portlet permission
1 Index: etc/sql/mysql/populate-userinfo-for-default-psml.sql
2 ===================================================================
3 --- etc/sql/mysql/populate-userinfo-for-default-psml.sql (リビジョン 488564)
4 +++ etc/sql/mysql/populate-userinfo-for-default-psml.sql (作業コピー)
5 @@ -6,9 +6,9 @@
6 INSERT INTO PREFS_PROPERTY_VALUE VALUES(41,103,'user.name.given','Test Dude','2004-05-22 16:27:12.562','2004-05-22 16:27:12.562');
7 INSERT INTO PREFS_PROPERTY_VALUE VALUES(42,103,'user.name.family','Dudley','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
8 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');
9 -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');
10 -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');
11 -INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
12 +--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');
13 +--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');
14 +--INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
15 INSERT INTO SECURITY_PRINCIPAL VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/admin','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
16 INSERT INTO SECURITY_PRINCIPAL VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
17 INSERT INTO SECURITY_PRINCIPAL VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
18 @@ -17,21 +17,23 @@
19 INSERT INTO SECURITY_PRINCIPAL VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/accounting','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
20 INSERT INTO SECURITY_PRINCIPAL VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/marketing','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
21 INSERT INTO SECURITY_PRINCIPAL VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/engineering','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
22 -INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',1,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
23 -INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
24 -INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
25 -INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
26 -INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
27 +INSERT INTO SECURITY_PRINCIPAL VALUES(14,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/site','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
28 +INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'@@ADMIN_PASSWORD@@',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',1,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
29 +INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'@@MANAGER_PASSWORD@@',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
30 +--INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
31 +--INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
32 +--INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
33 INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
34 INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
35 INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
36 INSERT INTO SECURITY_USER_ROLE VALUES(2,7);
37 INSERT INTO SECURITY_USER_ROLE VALUES(2,8);
38 -INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
39 +--INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
40 INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
41 -INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
42 -INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
43 -INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
44 +INSERT INTO SECURITY_USER_ROLE VALUES(9,14);
45 +--INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
46 +--INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
47 +--INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
48 INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
49 INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
50 INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
51 @@ -46,8 +48,8 @@
52 INSERT INTO SECURITY_PERMISSION VALUES(12,'org.apache.jetspeed.security.PagePermission','/rss.psml','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
53 INSERT INTO SECURITY_PERMISSION VALUES(13,'org.apache.jetspeed.security.FolderPermission','/_user/user','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
54 INSERT INTO SECURITY_PERMISSION VALUES(14,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
55 -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
56 -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
57 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
58 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
59 INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
60 INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
61 INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
62 @@ -64,36 +66,39 @@
63 INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
64
65
66 -INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
67 -INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
68 -INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01 00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
69 -INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01 00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
70 +--INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
71 +--INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
72 +--INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01 00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
73 +--INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01 00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
74
75 -INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
76 -INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
77 +--INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
78 +--INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2','2005-01-01 00:00:00.000','2005-01-01 00:00:00.000');
79
80 -INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
81 -INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
82 -INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
83 -INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
84 +--INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
85 +--INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
86 +--INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
87 +--INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
88
89 -INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
90 -INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
91 -INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
92 -INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
93 -INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
94 -INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
95 -INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
96 -INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
97 -INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
98 -INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
99 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
100 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
101 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
102 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
103 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
104 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
105 +--INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
106 +--INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
107 +--INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
108 +--INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
109 +--INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
110 +--INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
111 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
112 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
113 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
114 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
115 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
116 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
117 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
118 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
119 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
120 +--INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
121
122 INSERT INTO SECURITY_PERMISSION VALUES(100,'org.apache.jetspeed.security.PortletPermission','j2-admin::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
123 INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
124
125 +INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','cms-portlets::*','view, edit','2006-12-23 22:37:42','2006-12-23 22:37:42');
126 +INSERT INTO PRINCIPAL_PERMISSION VALUES(14,101);
127 +
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help