CREATE TABLE messages (messageid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, receiverid INT(10) UNSIGNED NOT NULL, senderid INT(10) UNSIGNED NOT NULL, body TEXT, PRIMARY KEY (messageid), FOREIGN KEY (receiverid) REFERENCES users(userid) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (senderid) REFERENCES users(userid) ON DELETE CASCADE ON UPDATE CASCADE);