Author: jfthomps
Date: Fri Nov 11 16:25:17 2011
New Revision: 1200932

URL: http://svn.apache.org/viewvc?rev=1200932&view=rev
Log:
added ON DELETE CASCADE to existing constraint for provisioningOSinstalltype 
for both OSinstalltypeid and provisioningid

Modified:
    incubator/vcl/trunk/mysql/vcl.sql

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1200932&r1=1200931&r2=1200932&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Fri Nov 11 16:25:17 2011
@@ -1949,8 +1949,8 @@ ALTER TABLE `provisioning`
 -- Constraints for table `provisioningOSinstalltype`
 --
 ALTER TABLE `provisioningOSinstalltype`
-  ADD CONSTRAINT `provisioningOSinstalltype_ibfk_2` FOREIGN KEY 
(`OSinstalltypeid`) REFERENCES `OSinstalltype` (`id`) ON UPDATE CASCADE,
-  ADD CONSTRAINT `provisioningOSinstalltype_ibfk_1` FOREIGN KEY 
(`provisioningid`) REFERENCES `provisioning` (`id`) ON UPDATE CASCADE;
+  ADD CONSTRAINT `provisioningOSinstalltype_ibfk_2` FOREIGN KEY 
(`OSinstalltypeid`) REFERENCES `OSinstalltype` (`id`) ON DELETE CASCADE ON 
UPDATE CASCADE,
+  ADD CONSTRAINT `provisioningOSinstalltype_ibfk_1` FOREIGN KEY 
(`provisioningid`) REFERENCES `provisioning` (`id`) ON DELETE CASCADE ON UPDATE 
CASCADE;
 
 -- 
 -- Constraints for table `querylog`


Reply via email to