Добавление нового заказа в высоконагруженную систему

CREATE TABLE IF NOT EXISTS `MyDB_Inno_DB`.`Order`
(
`id_order` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`fk_client` INT UNSIGNED NOT NULL,
`fk_delivery` INT UNSIGNED NULL,
`date` DATE NOT NULL,
`st_initiate` BIT(1) NOT NULL,
`st_executed` BIT(1) NOT NULL,
`address` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL,
`delivery_price` FLOAT(6,2) NULL,
`delivery_date` DATE NULL,
`delivery_time` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL,
`delivery_phone` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL,
PRIMARY KEY (`id_order`),
INDEX `fk_Order_Client_id_name` (`fk_client` ASC),
INDEX `fk_Order_Delivery_id_name` (`fk_delivery` ASC),
CONSTRAINT `fk_Order_Client_name` FOREIGN KEY (`fk_client`)
REFERENCES `MyDB_InnoDB`.`Client` (`id_client`)
ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `fk_Order_Delivery_name` FOREIGN KEY (`fk_delivery`)
REFERENCES `MyDB_InnoDB`.`Delivery` (`id_delivery`)
ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `MyDB_InnoDB`.`Shopping_Cart`
(
`fk_order` INT UNSIGNED NOT NULL DEFAULT 0,
`fk_product` INT UNSIGNED NOT NULL DEFAULT 0,
`shop_quantity` INT NOT NULL,
PRIMARY KEY (`fk_order`, `fk_product`),
INDEX `fk_Shopping_Cart_Order_id_name` (`fk_order` ASC),
INDEX `fk_Shopping_Cart_Products_id_name` (`fk_product` ASC),
CONSTRAINT `fk_Shopping_Cart_Order_name` FOREIGN KEY (`fk_order`)
REFERENCES `MyDB_InnoDB`.`Order` (`id_order`)
ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_Shopping_Cart_Products_name` FOREIGN KEY (`fk_product`)
REFERENCES `MyDB_InnoDB`.`Products` (`id_product`)
ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci

CREATE TABLE IF NOT EXISTS `MyDB_InnoDB`.`Products`
(
`id_product` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`fk_catalog` INT UNSIGNED NOT NULL DEFAULT 0,
`product_name` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
`release_date` DATE NOT NULL,
`price` FLOAT(6,2) NOT NULL,
`quantity` INT NOT NULL,
`description` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL,
PRIMARY KEY (`id_product`),
INDEX `fk_Products_Catalog_id_name` (`fk_catalog` ASC),
CONSTRAINT `fk_Products_Catalog_name` FOREIGN KEY (`fk_catalog`)
REFERENCES `MyDB_InnoDB`.`Catalog` (`id_catalog`)
ON DELETE RESTRICT ON UPDATE RESTRICT
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci;