Code:
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 07 Apr 2012 om 17:07
-- Serverversie: 5.1.33
-- PHP-Versie: 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: `drabbo`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `room_models`
--
CREATE TABLE IF NOT EXISTS `room_models` (
`id` varchar(100) NOT NULL,
`door_x` int(11) NOT NULL,
`door_y` int(11) NOT NULL,
`door_z` double NOT NULL,
`door_dir` int(4) NOT NULL DEFAULT '2',
`heightmap` text NOT NULL,
`public_items` text NOT NULL,
`club_only` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden uitgevoerd voor tabel `room_models`
--
INSERT INTO `room_models` (`id`, `door_x`, `door_y`, `door_z`, `door_dir`, `heightmap`, `public_items`, `club_only`) VALUES
('model_cafe', 5, 12, 0, 0, 'xxxxxxxxxxx\r\nxx00000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nx000000000x\r\nxxxx000xxxx\r\nxxxx000xxxx\r\nxxxxxxxxxxx', '', '0');