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`
