
CREATE TABLE IF NOT EXISTS djs (
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(255) NOT NULL
);

ALTER TABLE shows
 ADD COLUMN dj_id INT NULL,
 ADD CONSTRAINT fk_dj FOREIGN KEY (dj_id) REFERENCES djs(id)
 ON DELETE SET NULL;
