CREATE TABLE al_tree (
`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`parent_id` BIGINT NULL,
`name` VARCHAR(50) NOT NULL
) TYPE=InnoDB DEFAULT CHARSET=utf8;
CREATE INDEX fk_tree_tree ON al_tree (parent_id);
ALTER TABLE al_tree ADD CONSTRAINT fk_tree_tree //Вот этот !!!
FOREIGN KEY (parent_id) REFERENCES al_tree (id) ON UPDATE CASCADE ON DELETE CASCADE;
`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`parent_id` BIGINT NULL,
`name` VARCHAR(50) NOT NULL
) TYPE=InnoDB DEFAULT CHARSET=utf8;
CREATE INDEX fk_tree_tree ON al_tree (parent_id);
ALTER TABLE al_tree ADD CONSTRAINT fk_tree_tree //Вот этот !!!
FOREIGN KEY (parent_id) REFERENCES al_tree (id) ON UPDATE CASCADE ON DELETE CASCADE;