CREATE TABLE `items` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(10) NOT NULL,
  `room_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `base_item` INT(10) UNSIGNED NOT NULL,
  `extra_data` text NOT NULL,
  `x` INT(11) NOT NULL DEFAULT '0',
  `y` INT(11) NOT NULL DEFAULT '0',
  `z` DOUBLE NOT NULL DEFAULT '0',
  `rot` INT(11) NOT NULL DEFAULT '0',
  `wall_pos` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE,
  KEY `userid` (`user_id`) USING BTREE,
  KEY `roomid` (`room_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1259 DEFAULT CHARSET=latin1;