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:48:56 UTC
svn commit: r706323 -
/portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml
Author: woonsan
Date: Mon Oct 20 08:48:55 2008
New Revision: 706323
URL: http://svn.apache.org/viewvc?rev=706323&view=rev
Log:
Adjusted tables.
Modified:
portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml
Modified: portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml?rev=706323&r1=706322&r2=706323&view=diff
==============================================================================
--- portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml (original)
+++ portals/jetspeed-2/portal/trunk/xdocs/guides/guide-migration.xml Mon Oct 20 08:48:55 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