portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r749722 - /portals/jetspeed-2/portal/trunk/src/site/xdoc/guides/guide-migration.xml
Date Tue, 03 Mar 2009 20:15:11 GMT
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


Mime
View raw message