chatroom

CREATE TABLE chat
(
  chat_id int NOT NULL auto_increment,
  posted_on datetime NOT NULL,
  userid int NOT NULL,
  message text NOT NULL,
  PRIMARY KEY (chat_id),
  FOREIGN KEY(userid) references users(id) on update cascade on delete cascade
);