portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a..@apache.org
Subject svn commit: r514301 - /portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml
Date Sun, 04 Mar 2007 00:56:55 GMT
Author: ate
Date: Sat Mar  3 16:56:54 2007
New Revision: 514301

URL: http://svn.apache.org/viewvc?view=rev&rev=514301
Log: (empty)

Modified:
    portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml

Modified: portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml?view=diff&rev=514301&r1=514300&r2=514301
==============================================================================
--- portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml (original)
+++ portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml Sat Mar  3 16:56:54 2007
@@ -1,521 +1,548 @@
-<?xml version="1.0"?>
-<!--
-	Copyright 2004 The Apache Software Foundation
-	
-	Licensed 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>Data Migration</title>
-		<subtitle>Data Migration</subtitle>
-		<authors>
-			<person name="David Sean Taylor" email="taylor@apache.org" />
-		</authors>
-	</properties>
-	<body>
-		<section name="Migrating from 2.0 to 2.1">
-	    <p>The tables on this page 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>
-
+<?xml version="1.0"?>
+<!--
+	Copyright 2004 The Apache Software Foundation
+	
+	Licensed 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="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 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:
+	   <pre>
+	    &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;        
+	   </pre>
+	   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>
+



---------------------------------------------------------------------
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