128
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_orders_customers1`
FOREIGN KEY (`customers_idcustomer`)
REFERENCES `infocomplect`.`customers` (`idcustomer`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS `infocomplect`.`productsoforders` (
`idprodoforder` INT NOT NULL AUTO_INCREMENT,
`count` FLOAT NOT NULL COMMENT 'В единицах товара',
`product_idproduct` INT NOT NULL,
`orders_idorder` INT NOT NULL,
PRIMARY KEY (`idprodoforder`),
INDEX `fk_prodoforder_product1_idx` (`product_idproduct` ASC),
INDEX `fk_productsoforders_orders1_idx` (`orders_idorder` ASC),
CONSTRAINT `fk_prodoforder_product1`
FOREIGN KEY (`product_idproduct`)
REFERENCES `infocomplect`.`products` (`idproduct`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_productsoforders_orders1`
FOREIGN KEY (`orders_idorder`)
REFERENCES `infocomplect`.`orders` (`idorder`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;