/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
CREATE TABLE Bugs ( reported_by BIGINT UNSIGNED NOT NULL, STATUS VARCHAR(20) NOT NULL DEFAULT 'NEW' , FOREIGN KEY (reported_by) REFERENCES Accounts(account_id) ON UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY (STATUS) REFERENCES BugStatus(STATUS) ON UPDATE CASCADE ON DELETE SET DEFAULT );