2026-02-23

ALTER TABLE `lecon`ADD FOREIGN KEY(`id`) REFERENCES `cours`(`lecon_id`)ON UPDATE CASCADE ON DELETE CASCADE;

#1005 - Can't create table `cours`.`lecon` (errno: 150 "Foreign key constraint is incorrectly formed")

ALTER TABLE cours
ADD CONSTRAINT fk_cours_teacher
FOREIGN KEY (teacher_id) REFERENCES users(id)
ON DELETE RESTRICT
ON UPDATE CASCADE

Transclude of Template-Message