CREATE TABLE hotelposts ( roomactionid int(10) NOT NULL auto_increment, roomnumber int(10) NOT NULL, username varchar(50) NOT NULL, userid int(10) NOT NULL DEFAULT '0', roomaction mediumtext, PRIMARY KEY (roomactionid) );