--- portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml	2007-07-12 01:02:54.000000000 +0300
+++ portals/jetspeed-2/trunk/etc/schema/phase2-schema.xml	2007-12-26 21:48:37.000000000 +0200
@@ -43,7 +43,7 @@
         <column name="EXT_ATTR_NAME" size="15" type="VARCHAR"/>
         <column name="EXT_ATTR_VALUE" size="40" type="VARCHAR"/>
         <column name="OWNER_PRINCIPAL" size="40" type="VARCHAR"/>
-        <foreign-key foreignTable="FOLDER" name="FK_FOLDER_1" onDelete="cascade">
+        <foreign-key foreignTable="FOLDER" name="FK_FOLDER_1" onDelete="none">
             <reference foreign="FOLDER_ID" local="PARENT_ID"/>
         </foreign-key>
         <index name="IX_FOLDER_1">
@@ -142,7 +142,7 @@
         <column name="OPTIONS_ORDER" size="255" type="VARCHAR"/>
         <column name="SKIN" size="80" type="VARCHAR"/>
         <column name="IS_NEST" type="BOOLEANINT"/>
-        <foreign-key foreignTable="FOLDER_MENU" name="FK_FOLDER_MENU_1" onDelete="cascade">
+        <foreign-key foreignTable="FOLDER_MENU" name="FK_FOLDER_MENU_1" onDelete="none">
             <reference foreign="MENU_ID" local="PARENT_ID"/>
         </foreign-key>
         <foreign-key foreignTable="FOLDER" name="FK_FOLDER_MENU_2" onDelete="cascade">
@@ -284,7 +284,7 @@
         <column name="OPTIONS_ORDER" size="255" type="VARCHAR"/>
         <column name="SKIN" size="80" type="VARCHAR"/>
         <column name="IS_NEST" type="BOOLEANINT"/>
-        <foreign-key foreignTable="PAGE_MENU" name="FK_PAGE_MENU_1" onDelete="cascade">
+        <foreign-key foreignTable="PAGE_MENU" name="FK_PAGE_MENU_1" onDelete="none">
             <reference foreign="MENU_ID" local="PARENT_ID"/>
         </foreign-key>
         <foreign-key foreignTable="PAGE" name="PM_M_FK_PAGE_ID_PAGE" onDelete="cascade">
@@ -348,7 +348,7 @@
         <column name="EXT_PROP_NAME_2" size="40" type="VARCHAR"/>
         <column name="EXT_PROP_VALUE_2" size="80" type="VARCHAR"/>
         <column name="OWNER_PRINCIPAL" size="40" type="VARCHAR"/>
-        <foreign-key foreignTable="FRAGMENT" name="FK_FRAGMENT_1" onDelete="cascade">
+        <foreign-key foreignTable="FRAGMENT" name="FK_FRAGMENT_1" onDelete="none">
             <reference foreign="FRAGMENT_ID" local="PARENT_ID"/>
         </foreign-key>
         <foreign-key foreignTable="PAGE" name="FK_FRAGMENT_2" onDelete="cascade">
diff -u old/prefs-schema.xml new/prefs-schema.xml
--- portals/jetspeed-2/trunk/etc/schema/prefs-schema.xml	2008-01-04 18:40:33.000000000 +0200
+++ portals/jetspeed-2/trunk/etc/schema/prefs-schema.xml	2008-01-04 18:27:49.000000000 +0200
@@ -30,7 +30,7 @@
         <column name="FULL_PATH" size="254" type="VARCHAR"/>
         <column name="CREATION_DATE" type="TIMESTAMP"/>
         <column name="MODIFIED_DATE" type="TIMESTAMP"/>
-        <foreign-key foreignTable="PREFS_NODE" name="FK_PREFS_NODE_1" onDelete="cascade">
+        <foreign-key foreignTable="PREFS_NODE" name="FK_PREFS_NODE_1" onDelete="none">
             <reference foreign="NODE_ID" local="PARENT_NODE_ID"/>
         </foreign-key>        
         <index name="IX_PREFS_NODE_1">
diff -u old/security-schema.xml new/security-schema.xml
--- portals/jetspeed-2/trunk/etc/schema/security-schema.xml	2007-07-12 01:02:54.000000000 +0300
+++ portals/jetspeed-2/trunk/etc/schema/security-schema.xml	2007-12-26 21:48:53.000000000 +0200
@@ -140,7 +140,7 @@
          <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SSO_PRINCIPAL_TO_REMOTE_1" onDelete="cascade">
             <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
         </foreign-key>
-       <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SSO_PRINCIPAL_TO_REMOTE_2" onDelete="cascade">
+       <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SSO_PRINCIPAL_TO_REMOTE_2" onDelete="none">
             <reference foreign="PRINCIPAL_ID" local="REMOTE_PRINCIPAL_ID"/>
         </foreign-key>
     </table>
@@ -178,7 +178,7 @@
         <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_ROLE_1" onDelete="cascade">
             <reference foreign="PRINCIPAL_ID" local="ROLE_ID"/>
         </foreign-key>
-        <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_ROLE_2" onDelete="cascade">
+        <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_ROLE_2" onDelete="none">
             <reference foreign="PRINCIPAL_ID" local="USER_ID"/>
         </foreign-key>
     </table>
@@ -192,7 +192,7 @@
         <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_GROUP_1" onDelete="cascade">
             <reference foreign="PRINCIPAL_ID" local="GROUP_ID"/>
         </foreign-key>
-        <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_GROUP_2" onDelete="cascade">
+        <foreign-key foreignTable="SECURITY_PRINCIPAL" name="FK_SECURITY_USER_GROUP_2" onDelete="none">
             <reference foreign="PRINCIPAL_ID" local="USER_ID"/>
         </foreign-key>
     </table>
@@ -206,7 +206,7 @@
         <foreign-key foreignTable="SECURITY_PRINCIPAL"  name="FK_SECURITY_GROUP_ROLE_1" onDelete="cascade">
             <reference foreign="PRINCIPAL_ID" local="GROUP_ID"/>
         </foreign-key>
-        <foreign-key foreignTable="SECURITY_PRINCIPAL"  name="FK_SECURITY_GROUP_ROLE_2" onDelete="cascade">
+        <foreign-key foreignTable="SECURITY_PRINCIPAL"  name="FK_SECURITY_GROUP_ROLE_2" onDelete="none">
             <reference foreign="PRINCIPAL_ID" local="ROLE_ID"/>
         </foreign-key>
     </table>