用mysql设计一个联系人表其中联系人表的user和contact均参考user表的user字段

CREATE TABLE contacts ( id INT NOT NULL AUTO_INCREMENT, user INT NOT NULL, contact INT NOT NULL, PRIMARY KEY (id), FOREIGN KEY (user) REFERENCES users(user), FOREIGN KEY (contact) REFERENCES users(user) );