5TUPjtpG

1DROP TABLE IF EXISTS `items`;
2CREATE TABLE `items` (
3  `id` int(10) unsigned NOT NULL,
4  `user_id` int(10) NOT NULL,
5  `room_id` int(10) unsigned NOT NULL DEFAULT '0',
6  `base_item` int(10) unsigned NOT NULL,
7  `extra_data` text NOT NULL,
8  `x` int(11) NOT NULL DEFAULT '0',
9  `y` int(11) NOT NULL DEFAULT '0',
10  `z` double NOT NULL DEFAULT '0',
11  `rot` int(11) NOT NULL DEFAULT '0',
12  `wall_pos` varchar(100) NOT NULL,
13  PRIMARY KEY (`id`),
14  UNIQUE KEY `id` (`id`) USING BTREE,
15  KEY `userid` (`user_id`) USING BTREE,
16  KEY `roomid` (`room_id`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1;