CREATE TABLE chat_room ( handle NOT NULL PRIMARY KEY VARCHAR(30), password NOT NULL VARCHAR(30), INDEX (handle) );