Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2014
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.72 KB | None | 0 0
  1. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  2.  
  3. [MySQL][ODBC 3.51 Driver][mysqld-5.5.32-31.0-log]Cannot delete or update a parent row: a foreign key constraint fails (`Databasename`.`FADLSongs`, CONSTRAINT `FK_FADLSongs_OrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrderID`) ON DELETE NO ACTION ON UPDATE NO ACTION)
  4.  
  5. CREATE TABLE IF NOT EXISTS `MOrder` (
  6. `MOrderID` int(11) NOT NULL AUTO_INCREMENT,
  7. `MediaID` int(11) NOT NULL,
  8. `OrderID` int(11) NOT NULL,
  9. `MediaOption` tinyint(4) DEFAULT NULL,
  10. `UnitCost` double NOT NULL,
  11. `Quantity` int(11) NOT NULL,
  12. `BonusDeduction` double DEFAULT NULL,
  13. `MediaOptions` varchar(25) DEFAULT NULL,
  14. PRIMARY KEY (`MOrderID`),
  15. KEY `MediaID` (`MediaID`),
  16. KEY `OrderID` (`OrderID`),
  17. CONSTRAINT `FK_MOrder_MediaID` FOREIGN KEY (`MediaID`) REFERENCES `Media` (`MediaID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  18. CONSTRAINT `FK_MOrder_OrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrderID`) ON DELETE NO ACTION ON UPDATE CASCADE
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  20.  
  21. CREATE TABLE IF NOT EXISTS `Orders` (
  22. `OrderID` int(11) NOT NULL AUTO_INCREMENT,
  23. `UserID` int(11) NOT NULL,
  24. `PNMType` varchar(1) DEFAULT NULL,
  25. `PNMDeliveryOption` varchar(1) DEFAULT NULL,
  26. `PNMQuantity` smallint(5) unsigned DEFAULT NULL,
  27. `PNMSongCost` double DEFAULT NULL,
  28. `PNMDiscLabel` varchar(50) DEFAULT NULL,
  29. `ShippingCost` double DEFAULT NULL,
  30. PRIMARY KEY (`OrderID`),
  31. KEY `IDX_Orders_CouponNo` (`CouponNo`),
  32. KEY `IDX_Orders_VoucherNo` (`VoucherNo`),
  33. KEY `OrderStatusID` (`OrderStatusID`),
  34. KEY `UserID` (`UserID`),
  35. CONSTRAINT `FK_Orders_CouponNo` FOREIGN KEY (`CouponNo`) REFERENCES `Coupons` (`CouponNo`) ON DELETE NO ACTION ON UPDATE CASCADE,
  36. CONSTRAINT `FK_Orders_OrderStatusID` FOREIGN KEY (`OrderStatusID`) REFERENCES `OrderStatus_LU` (`OrderStatusID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  37. CONSTRAINT `FK_Orders_UserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`UserID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  38. CONSTRAINT `FK_Orders_VoucherNo` FOREIGN KEY (`VoucherNo`) REFERENCES `Vouchers` (`VoucherNo`) ON DELETE NO ACTION ON UPDATE CASCADE
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40.  
  41.  
  42. CREATE TABLE IF NOT EXISTS `PSGOrder` (
  43. `PSGOrderID` int(11) NOT NULL AUTO_INCREMENT,
  44. `OrderID` int(11) NOT NULL,
  45. `SongID` int(11) NOT NULL,
  46. `DateDownloaded` datetime DEFAULT NULL,
  47. PRIMARY KEY (`PSGOrderID`),
  48. KEY `IDX_PSGOrder_OrderID` (`OrderID`),
  49. KEY `IDX_PSGOrder_SongID` (`SongID`),
  50. CONSTRAINT `FK_PSGOrder_OrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrderID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  51. CONSTRAINT `FK_PSGOrder_SongID` FOREIGN KEY (`SongID`) REFERENCES `Songs` (`SongID`) ON DELETE NO ACTION ON UPDATE NO ACTION
  52. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement