Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement