Author: taylor Date: Thu Jan 25 15:03:34 2007 New Revision: 500040 URL: http://svn.apache.org/viewvc?view=rev&rev=500040 Log: Data Migration guide from 2.0 to 2.1
Added:
portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml
Modified:
portals/jetspeed-2/trunk/xdocs/guides/index.xml
Added: 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=auto&rev=500040
==============================================================================
--- portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml (added)
+++ portals/jetspeed-2/trunk/xdocs/guides/guide-migration.xml Thu Jan 25
15:03:34 2007
@@ -0,0 +1,521 @@
+<?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="[EMAIL
PROTECTED]" />
+ </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>
+
Modified: portals/jetspeed-2/trunk/xdocs/guides/index.xml
URL:
http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/xdocs/guides/index.xml?view=diff&rev=500040&r1=500039&r2=500040
==============================================================================
--- portals/jetspeed-2/trunk/xdocs/guides/index.xml (original)
+++ portals/jetspeed-2/trunk/xdocs/guides/index.xml Thu Jan 25 15:03:34 2007
@@ -48,6 +48,7 @@
<li><a href="guide-sso.html">Guide to using Jetspeed-2
single sign-on</a></li>
<li><a href="guide-user-attributes.html">Guide to
defining user attributes (PLT.17 user information configuration)</a></li>
<li><a href="guide-profiler.html">Guide to using
profilers</a></li>
+ <li><a href="guide-migration.html">Guide to Data
Migration from 2.0 to 2.1</a></li>
</ul>
</subsection>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
