5 lines
286 B
SQL
5 lines
286 B
SQL
ALTER TABLE absences
|
|
ADD COLUMN remplace_par_type ENUM('member','guest') DEFAULT 'member' AFTER remplace_par_id,
|
|
ADD COLUMN remplace_par_guest_id INT UNSIGNED DEFAULT NULL AFTER remplace_par_type,
|
|
ADD FOREIGN KEY (remplace_par_guest_id) REFERENCES invites(id) ON DELETE SET NULL;
|