ALTER TABLE absences
  ADD COLUMN prevenu TINYINT(1) NOT NULL DEFAULT 0 AFTER motif,
  ADD COLUMN remplace_par_id INT UNSIGNED DEFAULT NULL AFTER prevenu,
  ADD FOREIGN KEY (remplace_par_id) REFERENCES users(id) ON DELETE SET NULL;