-- http://www.phpmyadmin.net
-- 
-- Generatie Tijd: 04 Aug 2006 om 08:41
-- Server versie: 4.1.20
-- PHP Versie: 4.4.2
-- 
-- Database: `habbo`
-- 

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

-- 
-- Tabel structuur voor tabel `buddy`
-- 

CREATE TABLE `buddy` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `buddy` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `buddy_messages`
-- 

CREATE TABLE `buddy_messages` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `buddy` varchar(20) NOT NULL default '',
  `message` tinytext NOT NULL,
  PRIMARY KEY  (`name`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `buddy_requests`
-- 

CREATE TABLE `buddy_requests` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `request` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `catalogue`
-- 

CREATE TABLE `catalogue` (
  `id` bigint(20) NOT NULL auto_increment,
  `sprite` varchar(100) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `details` tinytext NOT NULL,
  `color` varchar(20) NOT NULL default '',
  `call_id` varchar(20) NOT NULL default '',
  `price` bigint(20) NOT NULL default '0',
  `cat` char(3) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `catalogue`
-- 

INSERT INTO `catalogue` VALUES (1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', 'EHP', 2, 'A1');
INSERT INTO `catalogue` VALUES (2, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'BHP', 2, 'A1');
INSERT INTO `catalogue` VALUES (3, 'table_plasto_bigsquare', 'Plaso big square table', 'Need a bigger table then this plasto table is perfect for you.', '0,0,0', 'DHP', 2, 'A1');
INSERT INTO `catalogue` VALUES (4, 'door', 'Telephone Box', 'Move to another room in traditional English style', '0,0,0', 'ovi', 5, 'a2');
INSERT INTO `catalogue` VALUES (5, 'doorB', 'Wardrobe', 'Narnia has nothing on this teleport device!', '0,0,0', 'ovi2', 3, 'a2');
INSERT INTO `catalogue` VALUES (6, 'doorC', 'Portaloo', 'Festival-chic inter-room transport', '0,0,0', 'ovi3', 4, 'a2');
INSERT INTO `catalogue` VALUES (8, 'pizza', 'Pizza Box', 'You dirty Habbo', '0,0,0', 'PIZ', 2, 'A1');
INSERT INTO `catalogue` VALUES (9, 'drinks', 'Empty Cans', 'Are you a slob too?', '0,0,0', 'DRK', 2, 'A1');
INSERT INTO `catalogue` VALUES (10, 'bottle', 'Empty Spinning Bottl', 'For interesting games!', '0,0,0', 'PUL', 2, 'A2');
INSERT INTO `catalogue` VALUES (11, 'red_tv', 'Portable TV', 'Don\\''t miss those soaps', '0,0,0', 'RTV', 3, 'A2');
INSERT INTO `catalogue` VALUES (12, 'wood_tv', 'Large TV', 'For family viewing', '0,0,0', 'WTV', 4, 'A2');
INSERT INTO `catalogue` VALUES (13, 'tv_luxus', 'Digital TV', 'Bang up to date', '0,0,0', 'DIGITV', 6, 'A2');
INSERT INTO `catalogue` VALUES (14, 'sink', 'Sink', 'Hot and cold thrown in for no charge', '0,0,0', 'LAVUAARI', 3, 'A1');
INSERT INTO `catalogue` VALUES (15, 'toilet', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYSIN', 2, 'A2');
INSERT INTO `catalogue` VALUES (16, 'toilet_red', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYPUN', 2, 'A2');
INSERT INTO `catalogue` VALUES (17, 'toilet_yell', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYKELT', 2, 'A2');
INSERT INTO `catalogue` VALUES (18, 'bath', 'Bubble Bath', 'The ultimate in pampering', '0,0,0', 'AMME', 6, 'A2');
INSERT INTO `catalogue` VALUES (19, 'tile', 'Floor Tiles', 'In Variety of Colors', '0,0,0', 'KAAKELISIN', 2, 'A2');
INSERT INTO `catalogue` VALUES (20, 'tile_red', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIPUN', 2, 'A2');
INSERT INTO `catalogue` VALUES (21, 'tile_yell', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIKELT', 2, 'A2');
INSERT INTO `catalogue` VALUES (22, 'sofachair_polyfon_girl', 'Armchair', 'Think pink', '0,0,0', 'GIRLSTP', 3, 'A1');
INSERT INTO `catalogue` VALUES (23, 'bed_polyfon_girl_one', 'Single Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS1P', 3, 'A1');
INSERT INTO `catalogue` VALUES (24, 'bed_polyfon_girl', 'Double Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS2P', 4, 'A2');
INSERT INTO `catalogue` VALUES (25, 'sofa_polyfon_girl', 'Two-seater Sofa', 'Romantic pink for two', '0,0,0', 'GIRLSHP', 4, 'A2');
INSERT INTO `catalogue` VALUES (26, 'carpet_polar', 'Pink Faux-Fur Bear Rug', 'Soft and cute', '5,5,5', 'MURLOVE', 4, 'A2');
INSERT INTO `catalogue` VALUES (27, 'sofachair_polyfon', 'Armchair', 'Loft-style comfort\r\n', '0,0,0', 'STP', 3, 'A1');

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

-- 
-- Tabel structuur voor tabel `my_cry`
-- 

CREATE TABLE `my_cry` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `room` varchar(50) NOT NULL default '',
  `details` tinytext NOT NULL,
  `extra` tinytext NOT NULL,
  `picked` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `my_furni`
-- 

CREATE TABLE `my_furni` (
  `id` bigint(20) NOT NULL auto_increment,
  `owner` varchar(20) NOT NULL default '',
  `sprite` varchar(100) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `details` tinytext NOT NULL,
  `color` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `priv_objects`
-- 

CREATE TABLE `priv_objects` (
  `id` bigint(20) NOT NULL auto_increment,
  `room_id` bigint(20) NOT NULL default '0',
  `sprite` varchar(20) NOT NULL default '',
  `location` varchar(20) NOT NULL default '',
  `rotation` bigint(20) NOT NULL default '0',
  `height` varchar(20) NOT NULL default '',
  `color` varchar(20) NOT NULL default '',
  `name` tinytext NOT NULL,
  `details` tinytext NOT NULL,
  `walk` bigint(20) NOT NULL default '0',
  `otype` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `priv_objects`
-- 

INSERT INTO `priv_objects` VALUES (1, 1, 'bar_armas', '4 13', 2, '0.0', '0,0,0', 'Barrel Minibar', 'It''s a barrel of laughs and a great talking point', 1, 'DOOROPEN');
INSERT INTO `priv_objects` VALUES (2, 1, 'doormat_plain', '4 5', 2, '0.0', '0,0,0', 'Doormat', 'Available in a variety of colors', 0, '');

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

-- 
-- Tabel structuur voor tabel `priv_rooms`
-- 

CREATE TABLE `priv_rooms` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `model` bigint(20) NOT NULL default '0',
  `wallpaper` varchar(10) NOT NULL default '',
  `floor` varchar(10) NOT NULL default '',
  `owner` varchar(20) NOT NULL default '',
  `status` varchar(20) NOT NULL default '',
  `details` tinytext NOT NULL,
  PRIMARY KEY  (`name`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `priv_rooms`
-- 

INSERT INTO `priv_rooms` VALUES (1, 'Play Ground', 'nopass', 1, '222', '333', 'ThuGie', 'open', 'Where gone chill!!');
INSERT INTO `priv_rooms` VALUES (2, 'Silver Wing', 'nopass', 3, '610', '403', 'ThuGie', 'open', 'When a wolve dance''s it makes you laugh.');
INSERT INTO `priv_rooms` VALUES (3, 'Scripting!!!', 'nopass', 4, '610', '403', 'ThuGie', 'open', 'You script until you get tired ;).');
INSERT INTO `priv_rooms` VALUES (4, 'GamePlay', 'nopass', 5, '600', '403', 'ThuGie', 'password', 'Playing a game is fun!!, Password=nopass');


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

-- 
-- Tabel structuur voor tabel `priv_types`
-- 

CREATE TABLE `priv_types` (
  `id` bigint(20) NOT NULL auto_increment,
  `model` varchar(20) NOT NULL default '',
  `heightmap` text NOT NULL,
  `location` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`model`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `priv_types`
-- 

INSERT INTO `priv_types` VALUES (1, 'model_a', 'xxxxxxxxxxxx$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxx000000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '3 5 2 0');
INSERT INTO `priv_types` VALUES (3, 'model_b', 'xxxxxxxxxxxx$13xxxxx0000000$13xxxxx0000000$13xxxxx0000000$13xxxxx0000000$13000000000000$13x00000000000$13x00000000000$13x00000000000$13x00000000000$13x00000000000$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '0 5 2 0');
INSERT INTO `priv_types` VALUES (4, 'model_c', 'xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxx000000x$13xxxxx000000x$13xxxx0000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '4 7 2 0');
INSERT INTO `priv_types` VALUES (5, 'model_d', 'xxxxxxxxxxxx$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxx0000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxxxxxxxxx', '4 7 2 0');

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

-- 
-- Tabel structuur voor tabel `userban`
-- 

CREATE TABLE `userban` (
  `id` bigint(20) NOT NULL auto_increment,
  `username` varchar(14) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`ip`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `users`
-- 

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `figure` text NOT NULL,
  `directmail` tinyint(1) NOT NULL default '0',
  `birthday` varchar(10) NOT NULL default '',
  `phonenumber` varchar(10) NOT NULL default '',
  `customdata` varchar(120) NOT NULL default '',
  `had_read_agreement` tinyint(1) NOT NULL default '0',
  `sex` varchar(6) NOT NULL default '',
  `country` varchar(20) NOT NULL default '',
  `has_special_rights` varchar(5) NOT NULL default '0',
  `badge_type` varchar(5) NOT NULL default '0',
  `on_time` varchar(20) NOT NULL default '',
  `credits` bigint(20) NOT NULL default '0',
  `online` varchar(20) NOT NULL default '',
  `info` tinytext NOT NULL,
  `state` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Tabel structuur voor tabel `word_filter`
-- 

CREATE TABLE `word_filter` (
  `id` bigint(20) NOT NULL auto_increment,
  `word_filter` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`word_filter`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `word_filter`
-- 

INSERT INTO `word_filter` VALUES (1, 'fuck');
INSERT INTO `word_filter` VALUES (2, 'penis');
INSERT INTO `word_filter` VALUES (3, 'shit');
INSERT INTO `word_filter` VALUES (4, 'bitch');
