· 8 years ago · May 15, 2018, 11:10 PM
1CREATE TABLE IF NOT EXISTS `mydb`.`summary` (
2 `id` INT NOT NULL AUTO_INCREMENT ,
3 `title` VARCHAR(45) NULL ,
4 `parent_id` INT NOT NULL ,
5 PRIMARY KEY (`id`) ,
6 INDEX `fk_sumario_sumario` (`parent_id` ASC) ,
7 CONSTRAINT `fk_sumario_sumario`
8 FOREIGN KEY (`parent_id` )
9 REFERENCES `mydb`.`summary` (`id` )
10 ON DELETE NO ACTION
11 ON UPDATE NO ACTION)
12ENGINE = InnoDB