[Pedido] DB p/ Atom Emulador sem BUG's

DELIMITER $$
--
-- Procedimientos
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(
IN roomid int(10) unsigned
)
BEGIN
SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data
FROM items_rooms
JOIN items ON (items.item_id = items_rooms.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_rooms.room_id = roomid;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(
IN userid int(10) unsigned
)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.data
FROM items_users
JOIN items ON (items.item_id = items_users.item_id)
LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
WHERE items_users.user_id = userid;
END$$

DELIMITER ;

ALTER TABLE user_pets ADD COLUMN hairdye int(11) NOT NULL DEFAULT '1';
ALTER TABLE user_pets ADD COLUMN pethair int(11) NOT NULL DEFAULT '1';

DROP TABLE IF EXISTS `navigator_publics_new`;
CREATE TABLE `navigator_publics_new` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ordernum` int(11) NOT NULL DEFAULT '1',
`bannertype` enum('0','1') NOT NULL COMMENT '0 = big, 1 = normal',
`caption` varchar(100) NOT NULL,
`description` varchar(5000) NOT NULL DEFAULT '',
`image` text NOT NULL,
`image_type` enum('internal','external') NOT NULL DEFAULT 'internal',
`room_id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '0',
`category_parent_id` int(11) NOT NULL DEFAULT '-1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`recommended` enum('0','1') NOT NULL DEFAULT '0',
`typeofdata` int(255) NOT NULL DEFAULT '1',
`tag` varchar(50000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO `navigator_publics_new` VALUES ('1', '1', '0', 'Juegos', '', 'officialrooms_hq/gamefolder.gif', 'internal', '0', '0', '-1', '1', '0', '4', '');
INSERT INTO `navigator_publics_new` VALUES ('3', '1', '0', 'Espacios Públicos', '', 'officialrooms_hq/official_rooms_nav_img.png', 'internal', '0', '0', '-1', '1', '0', '4', '');
INSERT INTO `navigator_publics_new` VALUES ('4', '1', '0', 'El Recibidor', '', 'officialrooms_hq/welcome_lobby.png', 'internal', '57', '3', '3', '1', '1', '3', '');