CREATE TABLE IF NOT EXISTS absences (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  membre_id INT UNSIGNED NOT NULL,
  date_absence DATE NOT NULL,
  motif VARCHAR(255) DEFAULT NULL,
  created_by INT UNSIGNED NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (membre_id) REFERENCES users(id) ON DELETE CASCADE,
  FOREIGN KEY (created_by) REFERENCES users(id)
) ENGINE=InnoDB;