You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@portals.apache.org by at...@apache.org on 2012/01/12 01:51:43 UTC
svn commit: r1230341 -
/portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml
Author: ate
Date: Thu Jan 12 00:51:43 2012
New Revision: 1230341
URL: http://svn.apache.org/viewvc?rev=1230341&view=rev
Log:
Adding jetspeed 2.2.1 to 2.2.2 database migration info and example MySQL script to do so.
Modified:
portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml
Modified: portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml?rev=1230341&r1=1230340&r2=1230341&view=diff
==============================================================================
--- portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml (original)
+++ portals/site/jetspeed/jetspeed-2.2/src/site/xdoc/guide-migration.xml Thu Jan 12 00:51:43 2012
@@ -26,6 +26,181 @@
</authors>
</properties>
<body>
+ <section name="Data Migration from Jetspeed 2.2.1 to 2.2.2">
+ <p>The following tables describe database schema changes from version 2.2.1 to version 2.2.2.</p>
+ <p>Note: besides the below modifications, there are a few renames of index and foreign key names
+ for naming consistency reasons only, which can be ignored and are not mentioned in the below tables either.</p>
+
+ <subsection name="Dropped Foreign Keys (and their Indexes)">
+ <table>
+ <tr>
+ <th>Table</th>
+ <th>Foreign Key</th>
+ </tr>
+ <tr>
+ <td>CUSTOM_PORTLET_MODE</td>
+ <td>FK_CUSTOM_PORTLET_MODE_1</td>
+ </tr>
+ <tr>
+ <td>CUSTOM_WINDOW_STATE</td>
+ <td>FK_CUSTOM_WINDOW_STATE_1</td>
+ </tr>
+ <tr>
+ <td>EVENT_DEFINITION</td>
+ <td>FK_EVENT_DEFINITION_1</td>
+ </tr>
+ <tr>
+ <td>PA_METADATA_FIELDS</td>
+ <td>FK_PA_METADATA_FIELDS_1</td>
+ </tr>
+ <tr>
+ <td>PD_METADATA_FIELDS</td>
+ <td>FK_PD_METADATA_FIELDS_1</td>
+ </tr>
+ <tr>
+ <td>SECURITY_ROLE</td>
+ <td>SECURITY_ROLE_REF_1</td>
+ </tr>
+ <tr>
+ <td>USER_ATTRIBUTE</td>
+ <td>USER_ATTRIBUTE_1</td>
+ </tr>
+ <tr>
+ <td>USER_ATTRIBUTE_REF</td>
+ <td>USER_ATTRIBUTE_REF_1</td>
+ </tr>
+ </table>
+ </subsection>
+ <subsection name="Dropped Indexes">
+ <table>
+ <tr>
+ <th>Table</th>
+ <th>Index</th>
+ </tr>
+ <tr>
+ <td>PROFILE_PAGE_ASSOC</td>
+ <td>UN_PROFILE_PAGE_1</td>
+ </tr>
+ </table>
+ </subsection>
+ <subsection name="Added Columns">
+ <table>
+ <tr>
+ <th>Table</th>
+ <th>Column</th>
+ <th>Type</th>
+ <th>Required</th>
+ </tr>
+ <tr>
+ <td>PORTLET_DEFINITION</td>
+ <td>CLONE_PARENT</td>
+ <td>VARCHAR(80)</td>
+ <td>false</td>
+ </tr>
+ </table>
+ </subsection>
+ <subsection name="Added Indexes">
+ <table>
+ <tr>
+ <th>Table</th>
+ <th>Index</th>
+ <th>Unique</th>
+ <th>Column(s)</th>
+ </tr>
+ <tr>
+ <td>FOLDER_MENU</td>
+ <td>IX_FOLDER_MENU_2</td>
+ <td>non unique</td>
+ <td>FOLDER_ID</td>
+ </tr>
+ <tr>
+ <td>PAGE_MENU</td>
+ <td>IX_PAGE_MENU_2</td>
+ <td>non unique</td>
+ <td>PAGE_ID</td>
+ </tr>
+ <tr>
+ <td>PRINCIPAL_PERMISSION</td>
+ <td>IX_PRINCIPAL_PERMISSION_2</td>
+ <td>non unique</td>
+ <td>PRINICIPAL_ID</td>
+ </tr>
+ <tr>
+ <td>RULE_CRITERION</td>
+ <td>IX_RULE_CRITERION_0</td>
+ <td>non unique</td>
+ <td>RULE_ID</td>
+ </tr>
+ </table>
+ </subsection>
+ <subsection name="Added Primary Keys">
+ <table>
+ <tr>
+ <th>Table</th>
+ <th>Column(s)</th>
+ </tr>
+ <tr>
+ <td>CLIENT_TO_CAPABILITY</td>
+ <td>CLIENT_ID, CAPABILITY_ID</td>
+ </tr>
+ <tr>
+ <td>CLIENT_TO_MIMETYPE</td>
+ <td>CLIENT_ID, MIMETYPE_ID</td>
+ </tr>
+ <tr>
+ <td>MEDIATYPE_TO_CAPABILITY</td>
+ <td>MEDIATYPE_ID, CAPABILITY_ID</td>
+ </tr>
+ <tr>
+ <td>MEDIATYPE_TO_MIMETYPE</td>
+ <td>MEDIATYPE_ID, MIMETYPE_ID</td>
+ </tr>
+ <tr>
+ <td>PROFILE_PAGE_ASSOC</td>
+ <td>LOCATOR_HASH, PAGE_ID</td>
+ </tr>
+ </table>
+ </subsection>
+ <subsection name="Example SQL migration script from 2.2.1 to 2.2.2">
+ <p>
+ Here is an example of a SQL migration script for a MySQL database:
+ <source><![CDATA[
+ALTER TABLE CUSTOM_PORTLET_MODE DROP FOREIGN KEY FK_CUSTOM_PORTLET_MODE_1;
+ALTER TABLE CUSTOM_WINDOW_STATE DROP FOREIGN KEY FK_CUSTOM_WINDOW_STATE_1;
+ALTER TABLE EVENT_DEFINITION DROP FOREIGN KEY FK_EVENT_DEFINITION_1;
+ALTER TABLE PA_METADATA_FIELDS DROP FOREIGN KEY FK_PA_METADATA_FIELDS_1;
+ALTER TABLE PD_METADATA_FIELDS DROP FOREIGN KEY FK_PD_METADATA_FIELDS_1;
+ALTER TABLE SECURITY_ROLE DROP FOREIGN KEY FK_SECURITY_ROLE_REF_1;
+ALTER TABLE USER_ATTRIBUTE DROP FOREIGN KEY FK_USER_ATTRIBUTE_1;
+ALTER TABLE USER_ATTRIBUTE_REF DROP FOREIGN KEY FK_USER_ATTRIBUTE_REF_1;
+
+ALTER TABLE CUSTOM_PORTLET_MODE DROP INDEX FK_CUSTOM_PORTLET_MODE_1;
+ALTER TABLE CUSTOM_WINDOW_STATE DROP INDEX FK_CUSTOM_WINDOW_STATE_1;
+ALTER TABLE EVENT_DEFINITION DROP INDEX FK_EVENT_DEFINITION_1;
+ALTER TABLE PA_METADATA_FIELDS DROP INDEX FK_PA_METADATA_FIELDS_1;
+ALTER TABLE PD_METADATA_FIELDS DROP INDEX FK_PD_METADATA_FIELDS_1;
+ALTER TABLE SECURITY_ROLE DROP INDEX FK_SECURITY_ROLE_REF_1;
+ALTER TABLE USER_ATTRIBUTE DROP INDEX FK_USER_ATTRIBUTE_1;
+ALTER TABLE USER_ATTRIBUTE_REF DROP INDEX FK_USER_ATTRIBUTE_REF_1;
+
+ALTER TABLE PROFILE_PAGE_ASSOC DROP INDEX UN_PROFILE_PAGE_1;
+
+ALTER TABLE PORTLET_DEFINITION ADD COLUMN CLONE_PARENT VARCHAR(80);
+
+CREATE INDEX IX_FOLDER_MENU_2 ON FOLDER_MENU ( FOLDER_ID );
+CREATE INDEX IX_PAGE_MENU_2 ON PAGE_MENU ( PAGE_ID );
+CREATE INDEX IX_PRINICIPAL_PERMISSION_2 ON PRINCIPAL_PERMISSION ( PRINCIPAL_ID );
+CREATE INDEX IX_RULE_CRITERION_0 ON RULE_CRITERION ( RULE_ID );
+
+ALTER TABLE CLIENT_TO_CAPABILITY ADD PRIMARY KEY (CLIENT_ID, CAPABILITY_ID);
+ALTER TABLE CLIENT_TO_MIMETYPE ADD PRIMARY KEY (CLIENT_ID, MIMETYPE_ID);
+ALTER TABLE MEDIATYPE_TO_CAPABILITY ADD PRIMARY KEY (MEDIATYPE_ID, CAPABILITY_ID);
+ALTER TABLE MEDIATYPE_TO_MIMETYPE ADD PRIMARY KEY (MEDIATYPE_ID, MIMETYPE_ID);
+ALTER TABLE PROFILE_PAGE_ASSOC ADD PRIMARY KEY (LOCATOR_HASH, PAGE_ID );
+ ]]></source>
+ </p>
+ </subsection>
+ </section>
<section name="Data Migrating from Jetspeed 2.1.3/2.1.4 to 2.2.1">
<p>
Extensive schema changes were made between the 2.1 and 2.2 versions related to the Portlet API 2.0 Standard