Return-Path: 
 <jetspeed-dev-return-33525-apmail-portals-jetspeed-dev-archive=portals.apache.org@portals.apache.org>
Delivered-To: apmail-portals-jetspeed-dev-archive@www.apache.org
Received: (qmail 23373 invoked from network); 3 Mar 2009 20:15:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 3 Mar 2009 20:15:33 -0000
Received: (qmail 54436 invoked by uid 500); 3 Mar 2009 20:15:32 -0000
Delivered-To: apmail-portals-jetspeed-dev-archive@portals.apache.org
Received: (qmail 54405 invoked by uid 500); 3 Mar 2009 20:15:32 -0000
Mailing-List: contact jetspeed-dev-help@portals.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jetspeed-dev-help@portals.apache.org>
List-Unsubscribe: <mailto:jetspeed-dev-unsubscribe@portals.apache.org>
List-Post: <mailto:jetspeed-dev@portals.apache.org>
List-Id: <jetspeed-dev.portals.apache.org>
Reply-To: "Jetspeed Developers List" <jetspeed-dev@portals.apache.org>
Delivered-To: mailing list jetspeed-dev@portals.apache.org
Received: (qmail 54393 invoked by uid 99); 3 Mar 2009 20:15:32 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Mar 2009 12:15:32 -0800
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Mar 2009 20:15:31 +0000
Received: by eris.apache.org (Postfix, from userid 65534)
	id 5A0C7238896B; Tue,  3 Mar 2009 20:15:11 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r749722 -
 /portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml
Date: Tue, 03 Mar 2009 20:15:11 -0000
To: jetspeed-dev@portals.apache.org
From: taylor@apache.org
X-Mailer: svnmailer-1.0.8
Message-Id: <20090303201511.5A0C7238896B@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

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