-- http://www.phpmyadmin.net
-- 
-- Generatie Tijd: 05 Oct 2006 om 22:54
-- Server versie: 5.0.18
-- PHP Versie: 5.1.2
-- 
-- Database: `habbov1`
-- 

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

-- 
-- 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 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `buddy_messages`
-- 


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

-- 
-- 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 '',
  `walk` char(2) NOT NULL default '',
  `weight` varchar(20) NOT NULL default '',
  `otype` varchar(20) NOT NULL default '',
  `ovalue` varchar(20) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

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

INSERT INTO `catalogue` (`id`, `sprite`, `name`, `details`, `color`, `call_id`, `price`, `cat`, `walk`, `weight`, `otype`, `ovalue`) VALUES (1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', 'EHP', 2, 'A1', '1', '1 1', '', ''),
(2, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'BHP', 2, 'A1', '1', '1 1', '', ''),
(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', '1', '2 2', '', ''),
(4, 'door', 'Telephone Box', 'Move to another room in traditional English style', '0,0,0', 'ovi', 5, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(5, 'doorB', 'Wardrobe', 'Narnia has nothing on this teleport device!', '0,0,0', 'ovi2', 3, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(6, 'doorC', 'Portaloo', 'Festival-chic inter-room transport', '0,0,0', 'ovi3', 4, 'a2', '0', '1 1', 'DOOROPEN', 'FALSE'),
(8, 'pizza', 'Pizza Box', 'You dirty Habbo', '0,0,0', 'PIZ', 2, 'A1', '1', '1 1', '', ''),
(9, 'drinks', 'Empty Cans', 'Are you a slob too?', '0,0,0', 'DRK', 2, 'A1', '1', '1 1', '', ''),
(10, 'bottle', 'Empty Spinning Bottl', 'For interesting games!', '0,0,0', 'PUL', 1, 'A2', '1', '1 1', '', ''),
(11, 'red_tv', 'Portable TV', 'Don\\''t miss those soaps', '0,0,0', 'RTV', 3, 'A2', '1', '1 1', '', ''),
(12, 'wood_tv', 'Large TV', 'For family viewing', '0,0,0', 'WTV', 4, 'A2', '1', '2 1', '', ''),
(13, 'tv_luxus', 'Digital TV', 'Bang up to date', '0,0,0', 'DIGITV', 6, 'A2', '1', '2 1', '', ''),
(14, 'sink', 'Sink', 'Hot and cold thrown in for no charge', '0,0,0', 'LAVUAARI', 3, 'A1', '1', '1 1', 'DOOROPEN', 'FALSE'),
(15, 'toilet', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYSIN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(16, 'toilet_red', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYPUN', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(17, 'toilet_yell', 'Loo Seat', 'Loo Seat', '0,0,0', 'PYTTYKELT', 2, 'A2', '1', '1 1', 'SWITCHON', 'OFF'),
(18, 'bath', 'Bubble Bath', 'The ultimate in pampering', '0,0,0', 'AMME', 6, 'A2', '1', '1 2', 'SWITCHON', 'OFF'),
(19, 'tile', 'Floor Tiles', 'In Variety of Colors', '0,0,0', 'KAAKELISIN', 2, 'A2', '0', '2 2', '', ''),
(20, 'tile_red', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIPUN', 2, 'A2', '0', '2 2', '', ''),
(21, 'tile_yell', 'Floor Tiles', 'In a choice of colors', '0,0,0', 'KAAKELIKELT', 2, 'A2', '0', '2 2', '', ''),
(22, 'sofachair_polyfon_girl', 'Armchair', 'Think pink', '0,0,0', 'GIRLSTP', 3, 'A1', '1', '1 1', '', ''),
(23, 'bed_polyfon_girl_one', 'Single Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS1P', 3, 'A1', '1', '1 3', '', ''),
(24, 'bed_polyfon_girl', 'Double Bed', 'Snuggle down in princess pink', '0,0,0', 'GIRLS2P', 4, 'A2', '1', '2 2', '', ''),
(25, 'sofa_polyfon_girl', 'Two-seater Sofa', 'Romantic pink for two', '0,0,0', 'GIRLSHP', 4, 'A2', '1', '2 1', '', ''),
(26, 'carpet_polar', 'Pink Faux-Fur Bear Rug', 'Soft and cute', '5,5,5', 'MURLOVE', 4, 'A2', '0', '', '', ''),
(27, 'sofachair_polyfon', 'Armchair', 'Loft-style comfort\r\n', '0,0,0', 'STP', 3, 'A1', '1', '1 1', '', ''),
(28, 'table_plasto_square', 'Square Dining Table', 'Hip plastic furniture', '0,0,0', 'B9P', 2, 'A1', '1', '1 1', '', ''),
(29, 'duck', 'Rubber Duck', 'Every bather needs one', '0,0,0', 'KUMIANKKA', 1, 'A1', '1', '1 1', '', ''),
(30, 'carpet_armas', 'Hand-Woven Rug', 'Adds instant warmth', '0,0,0', 'RMA', 2, 'A1', '1', '2 2', '', ''),
(31, 'bar_chair_armas', 'Barrel Stool', 'The ultimate recycled furniture', '0,0,0', 'BJA', 1, 'A1', '1', '1 1', '', ''),
(32, 'bar_armas', 'Barrel Minibar', 'It''s a barrel of laughs and a great talking point', '0,0,0', 'BAA', 4, 'A2', '1', '1 1', 'DOOROPEN', 'FALSE'),
(33, 'lamp_armas', 'Floor Lamp', 'Ambient lightung is essential', '0,0,0', 'JLA', 2, 'A1', '1', '1 1', '', ''),
(34, 'small_chair_armas', 'Stool', 'Rustic charm at it''s best', '0,0,0', 'JAA', 1, 'A1', '1', '1 1', '', ''),
(35, 'small_table_armas', 'Occacional Table', 'Practical and beautiful', '0,0,0', 'PPA', 2, 'A1', '1', '1 1', '', ''),
(36, 'bed_armas_one', 'Single Bed', 'Rustic charm for one', '0,0,0', 'S1A', 2, 'A1', '1', '1 3', '', ''),
(37, 'bed_armas_two', 'Double  Bed', 'King-sized pine comfort', '0,0,0', 'S2A', 3, 'A2', '1', '2 3', '', ''),
(38, 'fireplace_armas', 'Fireplace', 'Authentic, real flame fire', '0,0,0', 'TAA', 4, 'A2', '1', '1 1', '', ''),
(39, 'shelves_armas', 'Bookcase', 'For all those fire-side stories', '0,0,0', 'KHA', 3, 'A1', '1', '1 1', '', ''),
(40, 'lamp2_armas', 'Church Candle', 'Wax lyrical with some old-world charm', '0,0,0', 'KYA', 2, 'A2', '1', '1 1', '', ''),
(41, 'soft_sofachair_norja', 'Armchair', 'A soft iced sofa chair', '0,0,0', 'STN', 3, 'A2', '1', '1 1', '', ''),
(42, 'chair_norja', 'Chair', 'Sleek and chico for each cheek', '0,0,0', 'TUN', 2, 'A1', '1', '1 1', '', ''),
(43, 'couch_norja', 'Bench', 'Two can perch comfortablt', '0,0,0', 'PEN', 2, 'A1', '1', '2 1', '', ''),
(44, 'table_norja_med', 'Coffee Table', 'Elegance embodied', '0,0,0', 'PYN', 2, 'A1', '1', '2 2', '', ''),
(45, 'shelves_norja', 'Bookcase', 'For nic naks and art deco books', '0,0,0', 'HYN', 3, 'A1', '1', '1 1', '', ''),
(46, 'soft_sofa_norja', 'Sofa', 'A soft iced sofa', '0,0,0', 'PSN', 4, 'A2', '1', '2 1', '', ''),
(48, 'bed_silo_one', 'Simgle Bed', 'Plain and simple', '0,0,0', 'S1S', 3, 'A1', '1', '1 3', '', ''),
(49, 'bed_silo_two', 'Souble Bed', 'Plan and simple X2', '0,0,0', 'S2S', 3, 'A1', '1', '2 3', '', ''),
(50, 'shelves_silo', 'Bookcase', 'For nic and art deco books', '0,0,0', 'KHS', 3, 'A1', '1', '2 1', '', ''),
(51, 'table_silo_med', 'Coffee Table', 'Wipe cleas and unobtrusive', '0,0,0', 'PYS', 2, 'A1', '1', '2 2', '', ''),
(52, 'sofa_silo', 'Two-Seater Sofa', 'Cushioned, understarted comfort', '0,0,0', 'SHS', 3, 'A1', '1', '2 1', '', ''),
(53, 'sofachair_silo', 'Armchair', 'Large, but worth it', '0,0,0', 'STS', 2, 'A1', '1', '1 1', '', ''),
(54, 'chesstable_silo', 'Cheese Table', 'The catalogue Secret Furni!', '0,0,0', 'TLP', 20, 'A2', '1', '1 1', '', ''),
(55, 'chair_silo', 'Dining Chair', 'Keep it simple', '0,0,0', 'TUS', 2, 'A1', '1', '1 1', '', ''),
(56, 'table_silo_small', 'Occacional Table', 'For those random moments', '0,0,0', 'PPS', 1, 'A1', '1', '1 1', '', ''),
(57, 'table_plasto_round', 'Round DinningTable', 'Hip plastic furniture', '0,0,0', 'CHP', 2, 'A1', '1', '1 1', '', ''),
(58, 'table_plasto_4leg', 'Ocassional Table', 'Hipplastic furniture', '0,0,0', 'AHP', 0, 'A1', '1', '1 1', '', ''),
(59, 'chair_plasty', 'Plastic Pod Chair', 'Hip plastic furniture', '0,0,0', 'PL1', 2, 'A2', '1', '1 1', '', ''),
(60, 'table_armas', 'Dining Table', 'For informal dining', '0,0,0', 'PIA', 3, 'A2', '1', '1 1', '', ''),
(61, 'bench_armas', 'Bench', 'To complete the dining set', '0,0,0', 'PEA', 2, 'A1', '1', '1 1', '', ''),
(62, 'bartable_armas', 'Bar-Style Table', 'Essential for extra  guests', '0,0,0', 'BTA', 3, 'A1', '1', '1 1', '', ''),
(63, 'bed_budgetb_one', 'Plain Single Bed', 'All you need for a good night', '0,0,0', 'S1BVALKO', 2, 'A1', '1', '2 3', '', ''),
(64, 'bed_budgetb', 'Plain Double Bed', 'Sweet dreams for two', '0,0,0', 'S2BVALKO', 3, 'A1', '1', '2 3', '', ''),
(65, 'bed_budget_one', 'Single Bed (Aqua)', 'All you need for a good night Blue', '0,0,0', 'S1B', 2, 'A1', '1', '2 3', '', ''),
(66, 'bed_budget', 'Double Bed (Aqua)', 'Sweet dreams for two', '0,0,0', 'S2B', 3, 'A1', '2', '2 3', '', ''),
(67, 'bar_basic', 'Pura Mini-bar', 'A pura series 300 minibar', '0,0,0', 'BABA', 4, 'A2', '1', '1 1', 'DOOROPEN', 'FALSE'),
(68, 'fridge', 'Pura Fridge', 'Keep cool with a chilled snack or drink', '0,0,0', 'FDG', 6, 'A2', '1', '1 1', '', ''),
(69, 'lamp_basic', 'Pura Lamp', 'Switch on the atmosphere with this sophisticated light', '0,0,0', 'BLMP', 3, 'A1', '1', '1 1', '', ''),
(70, 'bed_polyfon_one', 'Single Bed', 'Cot of the artistic', '0,0,0', 'S1P', 3, 'A1', '1', '1 3', '', ''),
(71, 'table_polyfon_small', 'Small Coffee Table', 'For serving a stylish latte', '0,0,0', 'PPP', 1, 'A1', '1', '1 1', '', ''),
(72, 'chair_polyfon', 'Dining Chair', 'Metallic seating experience', '0,0,0', 'TUP', 2, 'A1', '1', '1 1', '', ''),
(73, 'sofa_polyfon', 'Two-Seater Sofa', 'Comfort for stylish couples', '0,0,0', 'SHP', 4, 'A2', '1', '2 1', '', ''),
(74, 'bed_polyfon', 'Double  Bed', 'Give youtself space to stretch out', '0,0,0', 'S2P', 3, 'A2', '1', '2 3', '', ''),
(75, 'table_polyfon_med', 'Large Coffee Table', 'For larger gatherings', '0,0,0', 'PMP', 3, 'A1', '1', '2 2', '', ''),
(76, 'stand_polyfon_z', 'Shelf', 'Tidy up', '0,0,0', 'LTP', 1, 'A1', '1', '1 1', '', ''),
(77, 'bardesk_polyfon', 'Bar/desk', 'Perfect for work or play', '0,0,0', 'BTP', 2, 'A1', '1', '1 1', '', ''),
(78, 'bardeskcorner_polyfon', 'Corner Cabinet/Desk', 'Tuck it away', '0,0,0', 'BKP', 2, 'A1', '1', '1 1', '', ''),
(79, 'bar_polyfon', 'Mini-Bar', 'You naughty Habbo!', '0,0,0', 'BAP', 5, 'A2', '1', '1 1', '', ''),
(80, 'shelves_polyfon', 'Bookcase', 'For the arty pad', '0,0,0', 'KHP', 4, 'A2', '1', '1 1', '', ''),
(81, 'doormat_love', 'Doormat', 'Welcome Habbos in style', '0,0,0', 'OSB', 1, 'A1', '0', '1 1', '', ''),
(82, 'plant_pineapple', 'Pineapple Plant', 'Needs loving glances', '0,0,0', 'ANANAS', 2, 'A1', '1', '1 1', '', ''),
(83, 'plant_small_cactus', 'Small Cactus', 'Even less watering than the real world', '0,0,0', 'PIKKUKAKTUS', 1, 'A1', '1', '1 1', '', ''),
(84, 'plant_fruittree', 'Fruit Tree', 'Great yield and sweet fruit', '0,0,0', 'PUU', 2, 'A1', '1', '1 1', '', ''),
(85, 'plant_bonsai', 'Bonsai Tree', 'You can be sure it lives', '0,0,0', 'BONSAI', 3, 'A2', '1', '1 1', '', ''),
(86, 'plant_yukka', 'Yukka Plant', 'Easy to care for', '0,0,0', 'JUKKA', 3, 'A2', '1', '1 1', '', ''),
(87, 'plant_big_cactus', 'Mature Cactus', 'Habbo Dreams monster in hiding! Shhhh', '0,0,0', 'ISOKAKTUS', 2, 'A2', '1', '1 1', '', ''),
(88, 'plant_rose', 'Cut Roses', 'Sleek and chic', '0,0,0', 'RUUSU', 3, 'A2', '1', '1 1', '', ''),
(89, 'plant_sunflower', 'Cut Sunflower', 'For happy Habbos', '0,0,0', 'AURINKO', 3, 'A2', '1', '1 1', '', '');

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

-- 
-- 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 '',
  `walk` bigint(20) NOT NULL,
  `weight` varchar(20) NOT NULL,
  `otype` varchar(20) NOT NULL,
  `ovalue` varchar(20) NOT NULL,
  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',
  `weight` varchar(20) NOT NULL default '',
  `otype` varchar(20) NOT NULL default '',
  `ovalue` varchar(20) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- 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` (`id`, `model`, `heightmap`, `location`) VALUES (1, 'model_a', 'xxxxxxxxxxxx$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxx000000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxx00000000$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '3 5 2 0'),
(3, 'model_b', 'xxxxxxxxxxxx$13xxxxx0000000$13xxxxx0000000$13xxxxx0000000$13xxxxx0000000$13000000000000$13x00000000000$13x00000000000$13x00000000000$13x00000000000$13x00000000000$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '0 5 2 0'),
(4, 'model_c', 'xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxx000000x$13xxxxx000000x$13xxxx0000000x$13xxxxx000000x$13xxxxx000000x$13xxxxx000000x$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx$13xxxxxxxxxxxx', '4 7 2 0'),
(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 `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=7 ;

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

INSERT INTO `word_filter` (`id`, `word_filter`) VALUES (1, 'fuck'),
(2, 'penis'),
(3, 'shit'),
(4, 'bitch'),
(5, 'slut'),
(6, 'cunt');
