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:15:11 UTC
svn commit: r749722 -
/portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml
Author: taylor
Date: Tue Mar 3 20:15:10 2009
New Revision: 749722
URL: http://svn.apache.org/viewvc?rev=749722&view=rev
Log:
example of MySQL specific modifications
Modified:
portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml
Modified: portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml?rev=749722&r1=749721&r2=749722&view=diff
==============================================================================
--- portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml (original)
+++ portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml Tue Mar 3 20:15:10 2009
@@ -359,6 +359,17 @@
<td>CASCADE DELETE</td>
</tr>
</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>
</subsection>
</section>
<section name="Data Migrating from Jetspeed 2.1 to 2.1.2">
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org