Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- [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)
- CREATE TABLE IF NOT EXISTS `MOrder` (
- `MOrderID` int(11) NOT NULL AUTO_INCREMENT,
- `MediaID` int(11) NOT NULL,
- `OrderID` int(11) NOT NULL,
- `MediaOption` tinyint(4) DEFAULT NULL,
- `UnitCost` double NOT NULL,
- `Quantity` int(11) NOT NULL,
- `BonusDeduction` double DEFAULT NULL,
- `MediaOptions` varchar(25) DEFAULT NULL,
- PRIMARY KEY (`MOrderID`),
- KEY `MediaID` (`MediaID`),
- KEY `OrderID` (`OrderID`),
- CONSTRAINT `FK_MOrder_MediaID` FOREIGN KEY (`MediaID`) REFERENCES `Media` (`MediaID`) ON DELETE NO ACTION ON UPDATE CASCADE,
- CONSTRAINT `FK_MOrder_OrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrderID`) ON DELETE NO ACTION ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `Orders` (
- `OrderID` int(11) NOT NULL AUTO_INCREMENT,
- `UserID` int(11) NOT NULL,
- `PNMType` varchar(1) DEFAULT NULL,
- `PNMDeliveryOption` varchar(1) DEFAULT NULL,
- `PNMQuantity` smallint(5) unsigned DEFAULT NULL,
- `PNMSongCost` double DEFAULT NULL,
- `PNMDiscLabel` varchar(50) DEFAULT NULL,
- `ShippingCost` double DEFAULT NULL,
- PRIMARY KEY (`OrderID`),
- KEY `IDX_Orders_CouponNo` (`CouponNo`),
- KEY `IDX_Orders_VoucherNo` (`VoucherNo`),
- KEY `OrderStatusID` (`OrderStatusID`),
- KEY `UserID` (`UserID`),
- CONSTRAINT `FK_Orders_CouponNo` FOREIGN KEY (`CouponNo`) REFERENCES `Coupons` (`CouponNo`) ON DELETE NO ACTION ON UPDATE CASCADE,
- CONSTRAINT `FK_Orders_OrderStatusID` FOREIGN KEY (`OrderStatusID`) REFERENCES `OrderStatus_LU` (`OrderStatusID`) ON DELETE NO ACTION ON UPDATE CASCADE,
- CONSTRAINT `FK_Orders_UserID` FOREIGN KEY (`UserID`) REFERENCES `Users` (`UserID`) ON DELETE NO ACTION ON UPDATE CASCADE,
- CONSTRAINT `FK_Orders_VoucherNo` FOREIGN KEY (`VoucherNo`) REFERENCES `Vouchers` (`VoucherNo`) ON DELETE NO ACTION ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `PSGOrder` (
- `PSGOrderID` int(11) NOT NULL AUTO_INCREMENT,
- `OrderID` int(11) NOT NULL,
- `SongID` int(11) NOT NULL,
- `DateDownloaded` datetime DEFAULT NULL,
- PRIMARY KEY (`PSGOrderID`),
- KEY `IDX_PSGOrder_OrderID` (`OrderID`),
- KEY `IDX_PSGOrder_SongID` (`SongID`),
- CONSTRAINT `FK_PSGOrder_OrderID` FOREIGN KEY (`OrderID`) REFERENCES `Orders` (`OrderID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT `FK_PSGOrder_SongID` FOREIGN KEY (`SongID`) REFERENCES `Songs` (`SongID`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement