Mine

CREATE TABLE `userrooms` (
  `uid` int(6) UNSIGNED ZEROFILL NOT NULL COMMENT 'User ID',
  `rid1` int(6) UNSIGNED ZEROFILL NOT NULL COMMENT 'Room ID',
  `rid2` int(6) UNSIGNED ZEROFILL NOT NULL COMMENT 'Room ID',
  `rid3` int(6) UNSIGNED ZEROFILL NOT NULL COMMENT 'Room ID',
  PRIMARY KEY(`uid`),
)
ENGINE=INNODB;

CREATE TABLE `rooms` (
  `rid` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT 'Room Number',
  `uid` int(6) NOT NULL COMMENT 'Room Owner ID',
  `opt` varchar(10) NOT NULL COMMENT 'Room Options',
  PRIMARY KEY(`rid`)
)
ENGINE=INNODB
COMMENT = 'Chat Rooms Data'
CHARACTER SET latin1 ;