-- phpMyAdmin SQL Dump
-- version 3.1.3.1
--
--
-- Host: localhost
-- Generato il: 12 gen, 2014 at 09:24 PM
-- Versione MySQL: 5.1.33
-- Versione PHP: 5.2.9
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 */;
--
-- Database: `napoli`
--
-- --------------------------------------------------------
--
-- Struttura della tabella `items`
--
CREATE TABLE IF NOT EXISTS `items` (
`id` int(10) unsigned NOT NULL,
`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=MyISAM DEFAULT CHARSET=latin1;
--
-- Dump dei dati per la tabella `items`
--
INSERT INTO `items` (`id`, `user_id`, `room_id`, `base_item`, `extra_data`, `x`, `y`, `z`, `rot`, `wall_pos`) VALUES
(1, 1, 10, 275, '0', 4, 6, 0, 2, ''),
(2, 21, 48, 99913, 'P4BLO 12-1-2014 ', 7, 11, 0, 0, '');