Gfjfj

-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 22-11-2009 a las 20:42:57
-- Versión del servidor: 5.1.33
-- Versión de PHP: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de datos: `infodb`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla`applications`
--

CREATE TABLE IF NOT EXISTS `applications` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`userid` int(100) NOT NULL,
`username` text NOT NULL,
`appstatus` text NOT NULL,
`age` text NOT NULL,
`country` text NOT NULL,
`timezone` text NOT NULL,
`realname` text NOT NULL,
`modname` text NOT NULL,
`time` text NOT NULL,
`experience` text NOT NULL,`message1` text NOT NULL,
`message2` text NOT NULL,
`message3` text NOT NULL,
`users` text NOT NULL,
`visitoripaddy` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `applications`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla`catalogue_categories`
--

CREATE TABLE IF NOT EXISTS `catalogue_categories` (
`indexid` tinyint(3) NOT NULL,
`minrank` tinyint(1) NOT NULL,
`indexname` varchar(50) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
`colour` varchar(1) CHARACTER SET latin1 COLLATE latin1_german1_ci DEFAULT NULL,
`icon` varchar(1) CHARACTER SET latin1 COLLATE latin1_german1_ci DEFAULT NULL,`content` varchar(3) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`indexid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `catalogue_categories`
--

INSERT INTO `catalogue_categories` (`indexid`, `minrank`, `indexname`, `colour`, `icon`, `content`) VALUES
(0, 1, 'Inicio', '1', '1', '1'),
(1, 1, 'Mobiliario', '2','2', '0'),
(2, 1, 'Mascotas', '1', '8', '0'),
(4, 1, 'Trax', '4', '4', '0'),
(5, 1, 'Tienda Pixel', '5', '5', '0'),
(6, 1, 'Reciclaje', '3', '7', '0'),
(8, 2, 'Rares', '6', '0', '0'),
(3, 1, 'PvP Cambio', '7', '6', '22'),
(9, 5, 'Administrador', '6', '0', '0'),
(7, 1, 'Noobs', '7', '3', '0');

-- --------------------------------------------------------

--
-- Estructura de tabla para latabla `catalogue_items`
--

CREATE TABLE IF NOT EXISTS `catalogue_items` (
`tid` int(10) NOT NULL AUTO_INCREMENT,
`catalogue_cost_credits` int(5) NOT NULL DEFAULT '0',
`catalogue_cost_pixels` int(5) NOT NULL,
`typeid` int(1) NOT NULL DEFAULT '0',
`top` double(4,2) NOT NULL DEFAULT '0.00',
`name_cct` varchar(110) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`status_max`int(3) NOT NULL DEFAULT '1',
`rights_required` int(1) NOT NULL DEFAULT '1',
`next_to_required` int(1) NOT NULL DEFAULT '0',
`drink_ids` text COLLATE latin1_general_ci NOT NULL,
`catalogue_id_page` int(3) NOT NULL DEFAULT '0',
`door` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`tradeable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',`recycleable` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`catalogue_id_index` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`),
KEY `typeid` (`typeid`),
KEY `catalogue_id_index` (`catalogue_id_index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=179589661 ;

--
-- Volcar la base de datos para la tabla `catalogue_items`
--

INSERT INTO`catalogue_items` (`tid`, `catalogue_cost_credits`, `catalogue_cost_pixels`, `typeid`, `top`, `name_cct`, `status_max`, `rights_required`, `next_to_required`, `drink_ids`, `catalogue_id_page`, `door`, `tradeable`, `recycleable`, `catalogue_id_index`) VALUES
(1, 25, 0, 1, 0.00, 'rare_parasol*0', 1, 1, 0, '', 68, '0', '1', '1', 1),
(2, 3, 0, 0, 0.00, 'floor', 1, 1, 0, '', 6, '0', '1', '1', 2),...