6 lines
294 B
SQL
6 lines
294 B
SQL
ALTER TABLE users
|
|
MODIFY COLUMN reception_connu INT UNSIGNED DEFAULT NULL,
|
|
MODIFY COLUMN reception_inconnu INT UNSIGNED DEFAULT NULL,
|
|
ADD FOREIGN KEY (reception_connu) REFERENCES users(id) ON DELETE SET NULL,
|
|
ADD FOREIGN KEY (reception_inconnu) REFERENCES users(id) ON DELETE SET NULL;
|