ON DELETE RESTRICT Causing Error 150
- by Levi Hackwith
CREATE TABLE project (
id INTEGER NOT NULL AUTO_INCREMENT,
created_at DATETIME NOT NULL,
name VARCHAR(75) NOT NULL,
description LONGTEXT NOT NULL,
is_active TINYINT NOT NULL DEFAULT '1',
PRIMARY KEY (id),
INDEX(name, created_at)
)
ENGINE = INNODB;
CREATE TABLE role (
id INTEGER NOT NULL,
name VARCHAR(50) NOT…
