-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 09-11-2012 a las 07:55:36
-- Versión del servidor: 5.1.41
-- Versión de PHP: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de datos: `habbo`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `navigator_publics`
--
CREATE TABLE IF NOT EXISTS `navigator_publics` (
`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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;
--
-- Volcar la base de datos para la tabla `navigator_publics`
--
INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `description`, `image`, `image_type`, `room_id`, `category_id`, `category_parent_id`, `enabled`, `recommended`, `typeofdata`, `tag`) VALUES
(1, 2, '0', 'Espacios Públicos', '', 'officialrooms/official_rooms_nav_img.png', 'internal', 0, 0, -1, '1', '0', 4, ''),
(2, 1, '0', 'El Recibidor', '', 'officialrooms/welcome_lobby.png', 'internal', 108, 3, 1, '1', '1', 3, ''),
(3, 8, '0', 'Caballos', '', 'officialrooms/horse_official_room.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(4, 2, '0', 'Establo Oficial', '', 'officialrooms/horse_official_room.gif', 'internal', 100, 3, 3, '1', '1', 3, ''),
(5, 10, '0', 'Estudio Antena 3', '', 'officialrooms/antena3.png', 'internal', 101, 3, -1, '1', '1', 3, ''),
(6, 5, '0', 'Mascotas', '', 'officialrooms/petfolder.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(7, 2, '0', 'MASCOTAS', '', 'officialrooms/petfolder.gif', 'internal', 102, 3, 6, '1', '1', 3, ''),
(8, 2, '0', 'MASCOTAS', '', 'officialrooms/petfolder.gif', 'internal', 103, 3, 6, '1', '1', 3, ''),
(9, 2, '0', 'MASCOTAS', '', 'officialrooms/petfolder.gif', 'internal', 105, 3, 6, '1', '1', 3, ''),
(11, 1, '0', 'Juegos', '', 'officialrooms/gamefolder.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(12, 4, '0', 'Retos', '', 'officialrooms/questfolder.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(13, 6, '0', 'Moda', '', 'officialrooms/fashionfolder.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(14, 7, '0', 'Musica y Fiesta', '', 'officialrooms/partyfolder.gif', 'internal', 0, 0, -1, '1', '0', 4, ''),
(16, 2, '0', 'Teatro', '', 'officialrooms/teatro.png', 'internal', 107, 3, 1, '1', '1', 3, ''),
(17, 1, '0', 'Futbol 25 Horas', '', 'officialrooms/navigator_football.png', 'internal', 110, 3, 11, '1', '1', 3, ''),
(18, 1, '0', 'MODA', '', 'officialrooms/fashionfolder.gif', 'internal', 111, 3, 13, '1', '1', 3, ''),
(19, 1, '0', 'MODA', '', 'officialrooms/fashionfolder.gif', 'internal', 112, 3, 13, '1', '1', 3, ''),
(20, 1, '0', 'MODA', '', 'officialrooms/fashionfolder.gif', 'internal', 113, 3, 13, '1', '1', 3, ''),
(21, 1, '0', 'FIESTA', '', 'officialrooms/partyfolder.gif', 'internal', 114, 3, 14, '1', '1', 3, ''),
(22, 1, '0', 'Futbol 25 Horas', '', 'officialrooms/navigator_football.png', 'internal', 110, 3, 12, '1', '1', 3, '');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;