xUCp3PJ5

1CREATE TABLE IF NOT EXISTS `db`.`parents` (
2  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR(45) NOT NULL,
4  `uuid` VARCHAR(45) NOT NULL,
5  PRIMARY KEY (`id`),
6  UNIQUE INDEX `uuid_UNIQUE` (`uuid` ASC),
7  UNIQUE INDEX `name_UNIQUE` (`name` ASC))
8ENGINE = InnoDB;
9
10
11-- -----------------------------------------------------
12-- Table `db`.`kids`
13-- -----------------------------------------------------
14DROP TABLE IF EXISTS `db`.`kids` ;
15
16CREATE TABLE IF NOT EXISTS `db`.`kids` (
17  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
18  `name` VARCHAR(450) NOT NULL,
19  `parents_id` INT UNSIGNED NOT NULL,
20  PRIMARY KEY (`id`, `parents_id`),
21  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
22  INDEX `fk_kids_parents_idx` (`parents_id` ASC),
23  CONSTRAINT `fk_kids_parents`
24    FOREIGN KEY (`parents_id`)
25    REFERENCES `db`.`parents` (`id`)
26    ON DELETE CASCADE
27    ON UPDATE NO ACTION)
28ENGINE = InnoDB;