w9y0k7RU

1-- -----------------------------------------------------
2-- Table `seconddb`.`Orders`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `seconddb`.`Orders` (
5  `id` INT NOT NULL AUTO_INCREMENT,
6  `shop_id` INT NOT NULL,
7  `product_id` INT NOT NULL,
8  `fio` VARCHAR(255) NOT NULL,
9  `date` DATE NULL,
10  `quantity` TINYINT NULL,
11  `tel` VARCHAR(100) NULL,
12  `confirm` TINYINT NULL,
13  PRIMARY KEY (`id`, `shop_id`, `product_id`, `fio`),
14  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
15  INDEX `id_from_shop_idx` (`shop_id` ASC) VISIBLE,
16  INDEX `id_from_product_idx` (`product_id` ASC) VISIBLE,
17  INDEX `fio_from_users_idx` (`fio` ASC) VISIBLE,
18  CONSTRAINT `id_from_shop`
19    FOREIGN KEY (`shop_id`)
20    REFERENCES `seconddb`.`Shops` (`id`)
21    ON DELETE CASCADE
22    ON UPDATE CASCADE,
23  CONSTRAINT `id_from_product`
24    FOREIGN KEY (`product_id`)
25    REFERENCES `seconddb`.`Products` (`id`)
26    ON DELETE CASCADE
27    ON UPDATE CASCADE,
28  CONSTRAINT `fio_from_users`
29    FOREIGN KEY (`fio`)
30    REFERENCES `seconddb`.`users` (`fio`)
31    ON DELETE CASCADE
32    ON UPDATE CASCADE)
33ENGINE = InnoDB;