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 ta...@apache.org on 2009/03/03 21:16:16 UTC
svn commit: r749723 -
/portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml
Author: taylor
Date: Tue Mar 3 20:16:15 2009
New Revision: 749723
URL: http://svn.apache.org/viewvc?rev=749723&view=rev
Log:
example of MySQL specific modifications
Modified:
portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml
Modified: portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml?rev=749723&r1=749722&r2=749723&view=diff
==============================================================================
--- portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml (original)
+++ portals/jetspeed-2/portal/branches/JETSPEED-2.1.3-POSTRELEASE/xdocs/guide-migration.xml Tue Mar 3 20:16:15 2009
@@ -86,7 +86,18 @@
<td>(not casade delete)</td>
<td>CASCADE DELETE</td>
</tr>
- </table>
+ </table>
+ <p>
+ Here is an example of the SQL migration scripts for the MySQL database:
+ <source><![CDATA[
+CREATE INDEX IX_PREFS_NODE_1 ON PREFS_NODE (PARENT_NODE_ID);
+CREATE INDEX IX_PREFS_NODE_2 ON PREFS_NODE (FULL_PATH);
+CREATE INDEX IX_FKPPV_1 ON PREFS_PROPERTY_VALUE (NODE_ID);
+
+ALTER TABLE PREFS_NODE ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE;
+ALTER TABLE PREFS_PROPERTY_VALUE ADD CONSTRAINT FK_PREFS_PROPERTY_VALUE_1 FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE;
+ ]]></source>
+ </p>
<p>
Here is an example of the SQL migration scripts for the MySQL database:
<source><![CDATA[
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org