CREATE TABLE `position` (
  `position_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `position_name` VARCHAR(255) NOT NULL,
   PRIMARY KEY(`position_id`)
) ENGINE=InnoDB;

CREATE TABLE `staff` (
  `staff_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `qualifications` VARCHAR(255) NOT NULL,
  `school_id` INT(11) UNSIGNED NOT NULL,
  `dept_id` INT(11) UNSIGNED NOT NULL,
  `position_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  KEY(`user_id`),
  KEY(`school_id`),
  KEY(`position_id`),
  KEY(`dept_id`),
  CONSTRAINT `pos_fk_e` FOREIGN KEY(`position_id`) REFERENCES `position`(`position_id`) ON DELETE CASCADE,
  CONSTRAINT `userid_fk_e` FOREIGN KEY(`user_id`) REFERENCES `admin_user`(`user_id`) ON DELETE CASCADE,
  CONSTRAINT `school_fk_e` FOREIGN KEY(`school_id`) REFERENCES `schools`(`school_id`) ON DELETE CASCADE,
  CONSTRAINT `department_fk_e` FOREIGN KEY(`dept_id`) REFERENCES `departments`(`dept_id`) ON DELETE CASCADE,
  PRIMARY KEY(`staff_id`)
) ENGINE=InnoDB;

Yields -> ERROR 1005 (HY000): Can't create table './chucky/staff.frm' (errno: 150)