You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@portals.apache.org by ta...@apache.org on 2009/05/15 08:44:55 UTC

svn commit: r775031 [19/21] - in /portals/site/jetspeed/jetspeed-2.1: ./ jetspeed-guide-admin/ jetspeed-guide-admin/src/ jetspeed-guide-admin/src/site/ jetspeed-guide-admin/src/site/resources/ jetspeed-guide-admin/src/site/resources/css/ jetspeed-guide...

Added: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml?rev=775031&view=auto
==============================================================================
--- portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml (added)
+++ portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml Fri May 15 06:44:44 2009
@@ -0,0 +1,686 @@
+<?xml version="1.0"?>
+<!--
+	Licensed to the Apache Software Foundation (ASF) under one or more
+	contributor license agreements.  See the NOTICE file distributed with
+	this work for additional information regarding copyright ownership.
+	The ASF licenses this file to You under the Apache License, Version 2.0
+	(the "License"); you may not use this file except in compliance with
+	the License.  You may obtain a copy of the License at
+	
+	http://www.apache.org/licenses/LICENSE-2.0
+	
+	Unless required by applicable law or agreed to in writing, software
+	distributed under the License is distributed on an "AS IS" BASIS,
+	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+	See the License for the specific language governing permissions and
+	limitations under the License.
+-->
+<document>
+	<properties>
+		<title>Migration Guide</title>
+		<subtitle>Migration Guide</subtitle>
+		<authors>
+			<person name="David Sean Taylor" email="taylor@apache.org" />
+		    <person name="Ate Douma" email="ate@douma.nu" />
+		</authors>
+	</properties>
+	<body>
+	  <section name="Data Migrating from Jetspeed 2.1.3 to 2.1.4">
+	    <p>The following tables describe database schema changes from version 2.1.4 to version 2.1.3.                                  
+	    </p>
+         <subsection name="Constraint removed">
+            <table>
+                <tr>
+                <th>Table</th>
+                <th>column(s)</th>                    
+                <th>2.1.3</th>                    
+                <th>2.1.4</th>
+                </tr>
+                <tr>
+                 <td>PARAMETER</td> 
+                 <td>PARAMETER_VALUE</td> 
+                 <td>Required</td> 
+                 <td>Not required</td>                                                            
+                </tr>
+            </table>
+            <p>
+            Here is an example of the SQL migration scripts for the MySQL database:
+            <source><![CDATA[ALTER TABLE 'PARAMETER` MODIFY COLUMN `PARAMETER_VALUE` DEFAULT NULL;]]></source>            
+            </p>       
+            </subsection>                         
+	  </section>		
+	  <section name="Data Migrating from Jetspeed 2.1.2 to 2.1.3">
+	    <p>The following tables describe database schema changes from version 2.1.3 to version 2.1.2.                                  
+	    </p>
+         <subsection name="Added Indexes">
+            <table>
+                <tr>
+                <th>Table</th>
+                <th>Index</th>                    
+                <th>type</th>                    
+                <th>column(s)</th>
+                </tr>
+                <tr>
+                 <td>PREFS_NODE</td> 
+                 <td>IX_PREFS_NODE_1</td> 
+                 <td>non unique</td> 
+                 <td>PARENT_NODE_ID</td>                                                            
+                </tr>
+                <tr>
+                 <td>PREFS_NODE</td> 
+                 <td>IX_PREFS_NODE_2</td> 
+                 <td>non unique</td> 
+                 <td>FULL_PATH</td>                                                            
+                </tr>                
+                <tr>
+                 <td>PREFS_PROPERTY_VALUE</td> 
+                 <td>IX_FKPPV_1</td> 
+                 <td>non unique</td> 
+                 <td>NODE_ID</td>                                                            
+                </tr>                
+                
+             </table>
+         </subsection>            
+         <subsection name="Foreign Key Altering">
+            <table>
+                <tr>
+                <th>Table</th>                
+                <th>Name</th>
+                <th>Column(s)</th>                    
+                <th>Referencing table</th>
+                <th>Referencing column(s)</th>
+                <th>2.1.2</th>
+                <th>2.1.3</th>                    
+                </tr>
+                <tr>
+                 <td>PREFS_NODE</td> 
+                 <td>FK_PREFS_NODE_1</td>
+                 <td>PARENT_NODE_ID</td> 
+                 <td>PREFS_NODE</td>                                                            
+                 <td>NODE_ID</td>                                                            
+                 <td>(not casade delete)</td>                                                            
+                 <td>CASCADE DELETE</td>                                                            
+                </tr>
+                <tr>
+                 <td>PREFS_PROPERTY_VALUE</td> 
+                 <td>(not named)</td> 
+                 <td>NODE_ID</td>
+                 <td>PREFS_NODE</td>
+                 <td>NODE_ID</td> 
+                 <td>(not casade delete)</td>                                                            
+                 <td>CASCADE DELETE</td>                                                            
+                </tr>                
+            </table>
+			<p>
+            Here is an example of the SQL migration scripts for the MySQL database:
+            <source><![CDATA[            
+CREATE INDEX IX_PREFS_NODE_1 ON PREFS_NODE (PARENT_NODE_ID); 
+CREATE INDEX IX_PREFS_NODE_2 ON PREFS_NODE (FULL_PATH); 
+CREATE INDEX IX_FKPPV_1 ON PREFS_PROPERTY_VALUE (NODE_ID); 
+
+ALTER TABLE PREFS_NODE ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; 
+ALTER TABLE PREFS_PROPERTY_VALUE ADD CONSTRAINT FK_PREFS_PROPERTY_VALUE_1 FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE;
+            ]]></source>            
+            </p>                   
+            <p>
+            Here is an example of the SQL migration scripts for the MySQL database:
+            <source><![CDATA[            
+CREATE INDEX IX_PREFS_NODE_1 ON PREFS_NODE (PARENT_NODE_ID); 
+CREATE INDEX IX_PREFS_NODE_2 ON PREFS_NODE (FULL_PATH); 
+CREATE INDEX IX_FKPPV_1 ON PREFS_PROPERTY_VALUE (NODE_ID); 
+
+ALTER TABLE PREFS_NODE ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; 
+ALTER TABLE PREFS_PROPERTY_VALUE ADD CONSTRAINT FK_PREFS_PROPERTY_VALUE_1 FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE;
+            ]]></source>            
+            </p>       
+            </subsection>                         
+	  </section>	
+	  <section name="Data Migrating from Jetspeed 2.1 to 2.1.2">
+			<p>The following tables describe database schema changes from version 2.1 to version 2.1.2.                                  
+			</p>
+			<subsection name="Added Tables">
+				<table>
+					<tr>
+						<th>Table</th>
+					</tr>
+					<tr>
+						<td>ADMIN_ACTIVITY</td>
+					</tr>
+					<tr>
+						<td>USER_ACTIVITY</td>
+					</tr>                
+				</table>
+			</subsection>            
+		</section>	
+	 <section name="Configuration Migrating from Jetspeed 2.0 to 2.1">
+	  <p>The following items describe important functional changes in Jetspeed 2.1
+	  </p>
+	  <subsection name="Portlet API Caching">
+	  <p>Version 2.1 is the first Jetspeed version to support Portlet API Caching. In 2.0 the expiration-cache was set to -1 (infinity time) 
+	  for all layouts in the file WEB-INF\apps\jetspeed-layouts\WEB-INF\portlet.xml. When upgrading to version 2.1 or greater from 2.0, you will need 
+	  to update your database to disable portlet caching on the Jetspeed layouts. Updating the layouts can be achieved by either redeploying the jetspeed-layouts portlet application,
+	  or by updating your database as shown below (assuming the APPLICATION_ID value is 2) for the jetspeed-layouts application.
+<source><![CDATA[
+UPDATE PORTLET_DEFINITION P SET EXPIRATION_CACHE = 0 WHERE P.APPLICATION_ID = 2
+]]></source>
+	  </p>
+      </subsection>	  
+	  <subsection name="Portlet Preferences">
+	   <p>Portlet Preferences are now by default user specific on all pages. In Jetspeed 2.0, for shared pages, the Portlet Preferences were shared as well.</p>
+	   <p>To retain most of the old Jetspeed 2.0 behavior, allowing an administrator to still set/modify <i>initial</i> Preferences for other users,<br/> 
+	   modify the following setting in the registry.xml spring assembly configuration for the portletEntityAccessImpl component:
+	   <source>
+&lt;!-- 
+  All preferences were shared. With JS2-449, preferences are now
+  stored 'per user'. The username is stored in the preferences FULL_PATH
+  To turn on mergeSharedPreferences configure this property to true 
+  This will NOT turn off per user prefs, 
+  but instead merge with them, where user prefs override.
+  boolean
+--&gt;    
+&lt;constructor-arg type="boolean"&gt;
+&lt;value&gt;false&lt;/value&gt;
+&lt;/constructor-arg&gt;        
+	   </source>
+	   As is commented in the assembly configuration also, setting <i>mergeSharedPreferences</i> to <i>true</i> will <i>NOT</i> turn off per user Preferences.<br/>
+	   Once a user sets its own Preference values (if allowed), those will override the shared Preference values.<br/>
+	   See for further information: <a href="http://issues.apache.org/jira/browse/JS2-449" target="_blank">JS2-449</a>
+	   </p>
+	  </subsection>
+	 </section>  
+	 <section name="Data Migrating from Jetspeed 2.0 to 2.1">
+	    <p>The following tables describe database schema changes from version 2.0 to version 2.1.                                  
+		   </p>
+         <subsection name="Added Tables">
+            <table>
+                <tr>
+                <th>Table</th>
+                </tr>
+                <tr>
+                    <td>CUSTOM_PORTLET_MODE</td>
+                </tr>
+                <tr>
+                    <td>CUSTOM_WINDOW_STATE</td>
+                </tr>                
+            </table>
+         </subsection>            
+         <subsection name="Column Altering">
+            <table>
+                <tr>
+                <th>Table</th>
+                <th>Column</th>                    
+                <th>2.0</th>
+                <th>2.1</th>                    
+                </tr>
+                <tr>
+                 <td>PORTLET_STATISTICS</td> 
+                 <td>ELAPSED_TIME</td> 
+                 <td>INTEGER</td> 
+                 <td>BIGINT</td>                                                            
+                </tr>
+                <tr>
+                 <td>PAGE_STATISTICS</td> 
+                 <td>ELAPSED_TIME</td> 
+                 <td>INTEGER</td> 
+                 <td>BIGINT</td>                                                            
+                </tr>
+                <tr>
+                 <td>USER_STATISTICS</td> 
+                 <td>ELAPSED_TIME</td> 
+                 <td>INTEGER</td> 
+                 <td>BIGINT</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER</td> 
+                 <td>SKIN</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(80)</td>                                                            
+                </tr>
+                <tr>
+                 <td>FOLDER</td> 
+                 <td>DEFAULT_LAYOUT_DECORATOR</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(80)</td>                                                            
+                </tr>
+                <tr>
+                 <td>FOLDER</td> 
+                 <td>DEFAULT_PORTLET_DECORATOR</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(80)</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>STATE</td> 
+                 <td>VARCHAR(40)</td> 
+                 <td>VARCHAR(10)</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>PMODE</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(10)</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>LAYOUT_X</td> 
+                 <td></td> 
+                 <td>NEW: REAL</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>LAYOUT_Y</td> 
+                 <td></td> 
+                 <td>NEW: REAL</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>LAYOUT_Z</td> 
+                 <td></td> 
+                 <td>NEW: REAL</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>LAYOUT_WIDTH</td> 
+                 <td></td> 
+                 <td>NEW: REAL</td>                                                            
+                </tr>
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>LAYOUT_HEIGHT</td> 
+                 <td></td> 
+                 <td>NEW: REAL</td>                                                            
+                </tr>
+                <tr>
+                 <td>LINK</td> 
+                 <td>SKIN</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(80)</td>                                                            
+                </tr>
+                <tr>
+                 <td>PORTLET_DEFINITION</td> 
+                 <td>SECURITY_REF</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(40)</td>                                                            
+                </tr>
+                <tr>
+                 <td>PORTLET_DEFINITION</td> 
+                 <td>SECURITY_REF</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(40)</td>                                                            
+                </tr>
+                <tr>
+                 <td>PORTLET_APPLICATION</td> 
+                 <td>SECURITY_REF</td> 
+                 <td></td> 
+                 <td>NEW: VARCHAR(40)</td>                                                            
+                </tr>
+                <tr>
+                 <td>SSO_COOKIE</td> 
+                 <td>COOKIE</td> 
+                 <td>VARCHAR(250)</td> 
+                 <td>VARCHAR(1024)</td>                                                            
+                </tr>                
+            </table>
+            </subsection>                         
+         <subsection name="Index Altering">
+            <table>
+                <tr>
+                <th>Table</th>
+                <th>Index</th>                    
+                <th>2.0</th>
+                <th>2.1</th>                    
+                </tr>
+                <tr>
+                 <td>FOLDER_MENU</td> 
+                 <td>UN_FOLDER_MENU_1</td> 
+                 <td>unique</td> 
+                 <td>(non unique) index</td>                                                            
+                </tr>
+                <tr>
+                 <td>PAGE_MENU</td> 
+                 <td>UN_PAGE_MENU_1</td> 
+                 <td>unique</td> 
+                 <td>(non unique) index</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>UN_FRAGMENT_1</td> 
+                 <td>unique</td> 
+                 <td>(non unique) index</td>                                                            
+                </tr>                
+                
+             </table>
+         </subsection>            
+         <subsection name="Foreign Key Altering">
+            <table>
+                <tr>
+                <th>Table</th>
+                <th>Column</th>                    
+                <th>2.0</th>
+                <th>2.1</th>                    
+                </tr>
+                <tr>
+                 <td>FOLDER</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_1"</td>                                                            
+                </tr>
+                <tr>
+                 <td>FOLDER_METADATA</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_METADATA_1"</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER_CONSTRAINT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_CONSTRAINT_1"</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER_CONSTRAINTS_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_CONSTRAINT_REF_1"</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER_ORDER</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_ORDER_1"</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER_MENU</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_MENU_1"</td>                                                            
+                </tr>                
+                <tr>
+                 <td>FOLDER_MENU</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_MENU_2"</td>                                                            
+                </tr>                                
+                <tr>
+                 <td>FOLDER_MENU_METADATA</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FOLDER_MENU_METADATA_1"</td>
+                </tr>                                                
+                <tr>
+                 <td>PAGE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_1"</td>
+                </tr>                                                                
+                <tr>
+                 <td>PAGE_METADATA</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_METADATA_1"</td>
+                </tr>                                                                
+                <tr>
+                 <td>PAGE_CONSTRAINT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_CONSTRAINT_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_CONSTRAINT_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_CONSTRAINTS_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_MENU</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_MENU_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_MENU</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "PM_M_FK_PAGE_ID_PAGE"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_MENU_METADATA</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_MENU_METADATA_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_2"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT_CONSTRAINT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_CONSTRAINT_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT_CONSTRAINT_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_CONSTRAINT_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT_PREF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_PREF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>FRAGMENT_PREF_VALUE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_FRAGMENT_PREF_VALUE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>LINK</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_LINK_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>LINK_METADATA</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_LINK_METADATA_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>LINK_CONSTRAINT</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_LINK_CONSTRAINT_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>LINK_CONSTRAINT_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_LINK_CONSTRAINT_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_SECURITY</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_SECURITY_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_SEC_CONSTRAINTS_DEF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_DEF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_SEC_CONSTRAINT_DEF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_DEF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_SEC_CONSTRAINTS_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PAGE_SEC_CONSTRAINT_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>RULE_CRITERION</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_RULE_CRITERION_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PREFS_NODE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PREFS_NODE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PA_METADATA_FIELDS</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PA_METADATA_FIELDS_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PD_METADATA_FIELDS</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PD_METADATA_FIELDS_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>USER_ATTRIBUTE_REF</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_USER_ATTRIBUTE_REF_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>USER_ATTRIBUTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_USER_ATTRIBUTE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PRINCIPAL_PERMISSION</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PRINCIPAL_PERMISSION_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>PRINCIPAL_PERMISSION</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_PRINCIPAL_PERMISSION_2"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_CREDENTIAL</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_CREDENTIAL_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SSO_SITE_TO_PRINCIPALS</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "SSO_SITE_TO_PRINC_FK1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SSO_SITE_TO_PRINCIPALS</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "SSO_SITE_TO_PRINC_FK2"</td>
+                </tr>                                                                                                
+                <tr>
+                 <td>SSO_PRINCIPAL_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SSO_PRINCIPAL_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_2"</td>
+                </tr>                                                                                                
+                <tr>
+                 <td>SSO_SITE_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_SITE_TO_REMOTE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SSO_SITE_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_SITE_TO_REMOTE_2"</td>
+                </tr>                                                                                                
+                <tr>
+                 <td>SSO_COOKIE_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SSO_COOKIE_TO_REMOTE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_2"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_USER_ROLE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_USER_ROLE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_USER_ROLE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_USER_ROLE_2"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_USER_GROUP</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_USER_GROUP_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_USER_GROUP</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_USER_GROUP_2"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_GROUP_ROLE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_GROUP_ROLE_1"</td>
+                </tr>                                                                                
+                <tr>
+                 <td>SECURITY_GROUP_ROLE</td> 
+                 <td>(FK constraint)</td> 
+                 <td>(not named)</td> 
+                 <td>named FK constraint "FK_SECURITY_GROUP_ROLE_2"</td>
+                </tr>                                                                                
+            </table>
+            </subsection>                         
+            
+		</section>
+	</body>
+</document>
+

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/guide-migration.xml
------------------------------------------------------------------------------
    svn:keywords = Id

Added: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml?rev=775031&view=auto
==============================================================================
--- portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml (added)
+++ portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml Fri May 15 06:44:44 2009
@@ -0,0 +1,79 @@
+<?xml version="1.0"?>
+<!--
+	Licensed to the Apache Software Foundation (ASF) under one or more
+	contributor license agreements.  See the NOTICE file distributed with
+	this work for additional information regarding copyright ownership.
+	The ASF licenses this file to You under the Apache License, Version 2.0
+	(the "License"); you may not use this file except in compliance with
+	the License.  You may obtain a copy of the License at
+	
+	http://www.apache.org/licenses/LICENSE-2.0
+	
+	Unless required by applicable law or agreed to in writing, software
+	distributed under the License is distributed on an "AS IS" BASIS,
+	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+	See the License for the specific language governing permissions and
+	limitations under the License.
+-->
+<document>
+	<properties>
+		<title>How to Help?</title>
+		<subtitle>How to Help?</subtitle>
+		<authors>
+			<person name="David Le Strat" email="dlestrat@apache.org" />
+		</authors>
+	</properties>
+	<body>
+		<section name="How to Help?">
+		<subsection name="Simple Things I Can Do to Help">
+		<p>
+		There are many ways to help with Jetspeed-2 as with most open source projects:
+		<ul>
+		<li>Subscribe to the <a href="mail-lists.html">user mailing list</a> and help answer questions from the community.
+		In open source a thriving community makes the project successful.  Don't be shy to ask basic questions, we have all
+		been there.</li>
+		<li>Report bugs and issues that you encounter in <a href="http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10492">Jetspeed-2 bug tracking system</a>.
+		Prior to reporting a bug, make sure to discuss the issue on the <a href="mail-lists.html">user mailing list</a> or even the 
+		<a href="mail-lists.html">developer mailing list</a>.</li>
+		<li>When you encounter an issue, you may be compelled to fix it.  We encourage this as this makes for a vibrant
+		community.  Once you have a fix, <a href="devguide/patches.html">submit a patch</a> on the reporting issue.</li>
+		</ul>
+		</p>
+		</subsection>
+		<subsection name="Why Should I Get Involved?">
+		<p>
+		There are many reasons why you want to help, just a few strong points:
+		<ul>
+		<li>If you help others solve there issues, they will most likely help you when you run into some problems.</li>
+		<li>By contributing patches, you can influence the prioritization of functionality and get your changes incorporated.</li>
+		<li>By reporting issues, you help Jetspeed-2 become a stronger project and improve its quality overall.</li>
+		<li>You will meet and get to know great people as well as share and learn best practices which will help you on
+		your project.</li>
+		</ul>
+		We are looking forward to have you part of our community!
+		</p>
+		</subsection>
+		<subsection name="How do I Join the Project?">
+		<p>
+		Projects at Apache operate under a <a href="http://www.apache.org/foundation/how-it-works.html#meritocracy">meritocracy</a>.
+		To become a committer, you first need to demonstrate your committment.  The best way to do so is to start contributing patch,
+		participate in the community and make your interest known.  It takes time and willingness to help and contribute!  This may
+		seem a bit intimidating at first, but the community will always help people who show interest and committment.
+		</p>
+		</subsection>
+		<subection name="Other Resources for Help">
+		<p>
+		Here are some useful links for other resources for help.
+		<ul>
+		<li><a href="http://portals.apache.org/development/code-standards.html">Portals project coding standards</a>.</li>
+		<li><a href="http://portals.apache.org/development/documentation.html">Portals project documentation standards</a>.</li>
+		<li><a href="http://www.apache.org/foundation/how-it-works.html">How does the Apache Software Foundation work</a>?</li>
+		<li><a href="http://people.apache.org/~coar/mlists.html#portals.apache.org">Portals mailing lists statistics</a>.  This can be helpful
+		to help you decide which mailing list to subscribe to.</li>
+		</ul>
+		</p>
+		</subection>
+		</section>
+	</body>
+</document>
+

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/how-to-help.xml
------------------------------------------------------------------------------
    svn:keywords = Id

Added: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml?rev=775031&view=auto
==============================================================================
--- portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml (added)
+++ portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml Fri May 15 06:44:44 2009
@@ -0,0 +1,154 @@
+<?xml version="1.0"?>
+<!--
+	Licensed to the Apache Software Foundation (ASF) under one or more
+	contributor license agreements.  See the NOTICE file distributed with
+	this work for additional information regarding copyright ownership.
+	The ASF licenses this file to You under the Apache License, Version 2.0
+	(the "License"); you may not use this file except in compliance with
+	the License.  You may obtain a copy of the License at
+	
+	http://www.apache.org/licenses/LICENSE-2.0
+	
+	Unless required by applicable law or agreed to in writing, software
+	distributed under the License is distributed on an "AS IS" BASIS,
+	WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+	See the License for the specific language governing permissions and
+	limitations under the License.
+-->
+<document>
+	<properties>
+		<title>Jetspeed 2 Home Page</title>
+		<subtitle>Welcome to Jetspeed 2</subtitle>
+		<authors>
+			<person name="David Sean Taylor" email="taylor@apache.org" />
+			<person name="David Le Strat" email="dlestrat@apache.org" />
+		</authors>
+	</properties>
+	<body>
+		<section name="Welcome to Jetspeed-2">
+			<div id="downloadbox">
+				<h5>Get Jetspeed 2.1.3</h5>
+				<p>
+					<a href="download.html">
+						<img valign="top" src="images/folder-open.gif"
+							border="0" alt="" title="download" />
+						Download
+					</a>
+					Jetspeed 2.1.3
+					<small>(35MB)</small>
+				</p>
+				<ul>
+					<li>
+						<a href="getting-started.html#System_Requirements">
+							System Requirements
+						</a>
+					</li>
+					<li>
+						<a
+							href="getting-started-installer.html">
+							Installation Instructions
+						</a>
+					</li>
+					<li>
+						<a href="release-notes.html">Release Notes</a>
+					</li>
+					<li>
+						<a href="features.html">Features</a>
+					</li>
+					<li>
+						<a href="guide-migration.html">
+							Migrating Guide
+						</a>
+					</li>
+					<li>
+						<a href="demo.html">
+							Live demo!
+						</a>
+					</li>
+				</ul>
+			</div>
+				<p>
+Jetspeed is an Open Portal Platform and Enterprise Information Portal, written entirely in open source under the Apache license in Java and XML and based on open standards.
+All access to the portal is managed through a robust portal security policy. Within a Jetspeed portal, individual portlets can be aggregated to create a page. Each portlet is an independent application with 
+Jetspeed acting as the central hub making information from multiple sources available in an easy to use manner.
+				</p>
+<p>
+Version 2.1.3 is conformant to the
+				<a href="http://www.jcp.org/en/jsr/detail?id=168">Java Portlet 1.0 Standard</a>. Version 2.2 will be conformant to the  
+<a href="http://www.jcp.org/en/jsr/detail?id=286">Java Portlet 2.0 Standard</a>.</p>				
+				<p>
+A portal based on Jetspeed can make applications, database information and other data sources available to end-users through a single web site. 
+Jetspeed provides a security infrastructure so that the information and functions made available to each user can be customized on basis of the
+ user or a role that the user has. The user can access the portal via a web browser, WAP-phone, pager or any other device supported by the servlet engine.
+				</p>
+	<p>
+		
+The Jetspeed enterprise portal integrates dynamic information, people, and processes across organization boundaries. This content is aggregated using portlets from diverse sources. 
+Portlets are just mini-web applications, or web-components. Jetspeed always provides secured access to the portlets. A short overview of Jetspeed <a href="features.html">features</a>:
+<ul>
+<li>Secure Access - Security based on standards, ACLs</li> 
+<li>Single Point of Entry (SSO, Federated) </li>
+<li>Enterprise Integration -  (EAI, integration points)</li> 
+<li>Personalization - (customizers, skins) </li>
+<li>Dynamic Web Components - (portlets based on standards)</li>
+<li>Scaleable, Component Architecture featuring multi-threading</li>
+</ul>
+</p>			
+			<subsection name="Jetspeed-2 Status">
+				<p>
+					The latest 2.1.3 production release of Jetspeed-2 was released
+					on December 21, 2007.  Future development areas include alignment with the 
+					<a href="http://www.jcp.org/en/jsr/detail?id=286">Java Portlet Standard 2.0, JSR-286</a>
+				    new portlet applications, WSRP support, further improvement of the design and user experience.
+				</p>
+			</subsection>
+			
+			<subsection name="Jetspeed Documentation">
+			<p>
+			Most of Jetspeed's documentation is in the form of guides. Depending on your role at the portal, you may want to read one of these guides:
+					<ul>
+						<li>
+							<a href="usersguide/index.html">
+								Users Guide
+							</a>
+						</li>
+						<li>
+							<a href="adminguide/index.html">
+								Administration Guide
+							</a>
+						</li>
+						<li>
+							<a href="deployguide/index.html">
+								Deployment and Configuration Guide
+							</a>
+						</li>
+						<li>
+							<a href="devguide/index.html">
+								Developers Guide
+							</a>
+						</li>
+					</ul>
+			</p>
+			</subsection>
+			<subsection name="Jetspeed Tutorials">
+			<p>
+			A great place to learn how to use Jetspeed is with the Tutorials:
+					<ul>
+						<li>
+							<a href="tutorials/maven-2/index.html">
+								Custom Build Tutorial with Maven-2
+							</a>
+						</li>
+						<li>
+							<a href="tutorials/ant/index.html">
+								Custom Build Tutorial with Ant
+							</a>
+						</li>
+					</ul>			
+			</p>
+			</subsection>
+
+		
+		</section>
+	</body>
+</document>
\ No newline at end of file

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: portals/site/jetspeed/jetspeed-2.1/src/site/xdoc/index.xml
------------------------------------------------------------------------------
    svn:keywords = Id