· 6 years ago · Sep 15, 2019, 08:26 PM
1CREATE TABLE IF NOT EXISTS `shoplista`.`lists` (
2 `idlists` INT NOT NULL,
3 `name` VARCHAR(45) NULL,
4 `owner` INT NULL,
5 PRIMARY KEY (`idlists`),
6 CONSTRAINT `owner`
7 FOREIGN KEY (`owner`)
8 REFERENCES `shoplista`.`users` (`id`)
9 ON DELETE NO ACTION
10 ON UPDATE NO ACTION)
11ENGINE = InnoDB;