You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by wo...@apache.org on 2008/10/20 17:50:03 UTC

svn commit: r706324 - /portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml

Author: woonsan
Date: Mon Oct 20 08:50:03 2008
New Revision: 706324

URL: http://svn.apache.org/viewvc?rev=706324&view=rev
Log:
Adjusted tables.

Modified:
    portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml

Modified: portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml?rev=706324&r1=706323&r2=706324&view=diff
==============================================================================
--- portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml (original)
+++ portals/jetspeed-2/portal/branches/JS2-871-pluto-2.0-upgrade/xdocs/guides/guide-migration.xml Mon Oct 20 08:50:03 2008
@@ -71,272 +71,172 @@
         <subsection name="Columns Altering">
           <table>
             <tr>
-              <th rowspan="2">Altering Action</th>
-              <th rowspan="2">Table</th>
-              <th rowspan="2">Column</th>
-              <th colspan="3">2.1.3</th>
-              <th colspan="3">2.2</th>
-            </tr>
-            <tr>
-              <th>Type</th>
-              <th>Size</th>
-              <th>Required</th>
-              <th>Type</th>
-              <th>Size</th>
-              <th>Required</th>
+              <th>Table</th>
+              <th>Column</th>
+              <th>Altering Action</th>
+              <th>2.1.3</th>
+              <th>2.2</th>
             </tr>
             <tr>
-              <td>MODIFY</td>
               <td>PARAMETER</td>
               <td>PARAMETER_VALUE</td>
-              <td>LONGVARCHAR</td>
-              <td></td>
-              <td>Yes</td>
-              <td>LONGVARCHAR</td>
-              <td></td>
-              <td>No</td>
+              <td>MODIFY</td>
+              <td>LONGVARCHAR, Required</td>
+              <td>LONGVARCHAR, Not required</td>
             </tr>
             <tr>
-              <td>MODIFY</td>
               <td>PORTLET_ENTITY</td>
               <td>ID</td>
-              <td>VARCHAR</td>
-              <td>255</td>
-              <td>Yes</td>
-              <td>VARCHAR</td>
-              <td>80</td>
-              <td>Yes</td>
+              <td>MODIFY</td>
+              <td>VARCHAR(255), Required</td>
+              <td>VARCHAR(80), Required</td>
             </tr>
             <tr>
-              <td>MODIFY</td>
               <td>PORTLET_ENTITY</td>
               <td>APP_NAME</td>
-              <td>VARCHAR</td>
-              <td>255</td>
-              <td>Yes</td>
-              <td>VARCHAR</td>
-              <td>80</td>
-              <td>Yes</td>
+              <td>MODIFY</td>
+              <td>VARCHAR(255), Required</td>
+              <td>VARCHAR(80), Required</td>
             </tr>
             <tr>
-              <td>MODIFY</td>
               <td>PORTLET_ENTITY</td>
               <td>PORTLET_NAME</td>
-              <td>VARCHAR</td>
-              <td>255</td>
-              <td>Yes</td>
-              <td>VARCHAR</td>
-              <td>80</td>
-              <td>Yes</td>
+              <td>MODIFY</td>
+              <td>VARCHAR(255), Required</td>
+              <td>VARCHAR(80), Required</td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>CLASSNAME</td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>VARCHAR(254), Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_MAPPING_ONLY</td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>BOOLEANINT, Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_ENABLED</td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>BOOLEANINT, Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>FULL_PATH</td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>VARCHAR(254), Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>PRINCIPAL_TYPE</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>VARCHAR</td>
-              <td>20</td>
-              <td>Yes</td>
+              <td>VARCHAR(20), Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>PRINCIPAL_NAME</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>VARCHAR</td>
-              <td>200</td>
-              <td>Yes</td>
+              <td>VARCHAR(200), Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_MAPPED</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_ENABLED</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_READONLY</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PRINCIPAL</td>
               <td>IS_REMOVABLE</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PERMISSION</td>
               <td>CLASSNAME</td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>VARCHAR(254), Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_PERMISSION</td>
               <td>PERMISSION_TYPE</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>VARCHAR</td>
-              <td>30</td>
-              <td>Yes</td>
+              <td>VARCHAR(30), Required</td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PERMISSION</td>
               <td>CREATION_DATE</td>
-              <td>TIMESTAMP</td>
-              <td></td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>TIMESTAMP, Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_PERMISSION</td>
               <td>MODIFIED_DATE</td>
-              <td>TIMESTAMP</td>
-              <td></td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>TIMESTAMP, Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_CREDENTIAL</td>
               <td>COLUMN_VALUE</td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>Yes</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>VARCHAR(254), Required</td>
               <td></td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_CREDENTIAL</td>
               <td>CREDENTIAL_VALUE</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>Yes</td>
+              <td>VARCHAR(254), Required</td>
             </tr>
             <tr>
-              <td>DROP</td>
               <td>SECURITY_CREDENTIAL</td>
               <td>CLASSNAME</td>
-              <td>VARCHAR</td>
-              <td>254</td>
-              <td>No</td>
-              <td></td>
-              <td></td>
+              <td>DROP</td>
+              <td>VARCHAR(254), Not required</td>
               <td></td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_CREDENTIAL</td>
               <td>UPDATE_ALLOWED</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
             <tr>
-              <td>ADD</td>
               <td>SECURITY_CREDENTIAL</td>
               <td>IS_STATE_READONLY</td>
+              <td>ADD</td>
               <td></td>
-              <td></td>
-              <td></td>
-              <td>BOOLEANINT</td>
-              <td></td>
-              <td>Yes</td>
+              <td>BOOLEANINT, Required</td>
             </tr>
           </table>
         </subsection>
@@ -359,16 +259,12 @@
         <subsection name="Indexes Altering">
           <table>
             <tr>
-              <th rowspan="2">Table</th>
-              <th rowspan="2">Index</th>
-              <th colspan="2">2.1.3</th>
-              <th colspan="2">2.2</th>
-            </tr>
-            <tr>
-              <th>Type</th>
-              <th>Column(s)</th>
-              <th>Type</th>
-              <th>Column(s)</th>
+              <th>Table</th>
+              <th>Index</th>
+              <th>2.1.3 - Type</th>
+              <th>2.1.3 - Column(s)</th>
+              <th>2.2 - Type</th>
+              <th>2.2 - Column(s)</th>
             </tr>
             <tr>
               <td>SECURITY_PRINCIPAL</td> 



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org