-- phpMyAdmin SQL Dump
-- version 3.3.9.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 11 Novembre 2013 à 00:17
-- Version du serveur: 5.6.11
-- Version de PHP: 5.4.16

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

--
-- Base de données: `owna`
--

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

--
-- Structure de la table `bans`
--

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bantype` enum('user','ip') COLLATE latin1_general_ci NOT NULL,
  `value` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `reason` text COLLATE latin1_general_ci NOT NULL,
  `expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `author` int(11) NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=19 ;

--
-- Contenu de la table `bans`
--


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

--
-- Structure de la table `buddy`
--

CREATE TABLE IF NOT EXISTS `buddy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from_user` varchar(15) NOT NULL,
  `to_user` varchar(15) NOT NULL,
  `accept` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `buddy`
--


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

--
-- Structure de la table `catalogue`
--

CREATE TABLE IF NOT EXISTS `catalogue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(50) NOT NULL,
  `longname` varchar(50) NOT NULL,
  `itemname` varchar(50) NOT NULL,
  `itemdesc` varchar(100) NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `rgb` varchar(12) NOT NULL DEFAULT '0,0,0',
  `size` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;

--
-- Contenu de la table `catalogue`
--

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

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

--
-- Structure de la table `chatlogs`
--

CREATE TABLE IF NOT EXISTS `chatlogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `message` text NOT NULL,
  `roomid` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `chatlogs`
--


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

--
-- Structure de la table `favrooms`
--

CREATE TABLE IF NOT EXISTS `favrooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(15) NOT NULL,
  `roomid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `favrooms`
--


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

--
-- Structure de la table `heightmap`
--

CREATE TABLE IF NOT EXISTS `heightmap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model` varchar(10) NOT NULL DEFAULT 'model_a',
  `heightmap` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Contenu de la table `heightmap`
--

INSERT INTO `heightmap` (`id`, `model`, `heightmap`) VALUES
(1, 'model_a', 'xxxxxxxxxxxx xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxx000000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxx00000000 xxxxxxxxxxxx xxxxxxxxxxxx'),
(2, 'model_e', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xx0000000000 xx0000000000 x00000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xx0000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx'),
(3, 'lobby_a', 'XXXXXXXXX77777777777XXXXX XXXXXXXXX777777777777XXXX XXXXXXXXX777777777766XXXX XXXXXXXXX777777777755XXXX XX333333333333333334433XX XX333333333333333333333XX XX333333333333333333333XX 33333333333333333333333XX 333333XXXXXXX3333333333XX 333333XXXXXXX2222222222XX 333333XXXXXXX2222222222XX XX3333XXXXXXX2222222222XX XX3333XXXXXXX222222221111 XX3333XXXXXXX111111111111 333333XXXXXXX111111111111 3333333222211111111111111 3333333222211111111111111 3333333222211111111111111 XX33333222211111111111111 XX33333222211111111111111 XX3333322221111111XXXXXXX XXXXXXX22221111111XXXXXXX XXXXXXX22221111111XXXXXXX XXXXXXX22221111111XXXXXXX XXXXXXX22221111111XXXXXXX XXXXXXX222X1111111XXXXXXX XXXXXXX222X1111111XXXXXXX XXXXXXXXXXXX11XXXXXXXXXXX XXXXXXXXXXXX11XXXXXXXXXXX XXXXXXXXXXXX11XXXXXXXXXXX XXXXXXXXXXXX11XXXXXXXXXXX'),
(4, 'model_b', 'xxxxxxxxxxxx xxxxx0000000 xxxxx0000000 xxxxx0000000 xxxxx0000000 x00000000000 x00000000000 x00000000000 x00000000000 x00000000000 x00000000000 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx'),
(5, 'model_c', 'xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx'),
(6, 'model_d', 'xxxxxxxxxxxx xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxx000000x xxxxxxxxxxxx'),
(7, 'model_f', 'xxxxxxxxxxxx xxxxxxx0000x xxxxxxx0000x xxx00000000x xxx00000000x xxx00000000x xxx00000000x x0000000000x x0000000000x x0000000000x x0000000000x xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx'),
(8, 'pool_a', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx7xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx777xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx7777777xxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx777777777xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx7xxx777777xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx7x777777777xxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx7xxx77777777xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx7x777777777x7xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx7xxx7777777777xxxxxxxxxxxxxx xxxxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx77777777777x2111xxxxxxxxxxxx xxxxxxxxxxxxxxx7777777777x221111xxxxxxxxxxx xxxxxxxxx7777777777777777x2211111xxxxxxxxxx xxxxxxxxx7777777777777777x22211111xxxxxxxxx xxxxxxxxx7777777777777777x222211111xxxxxxxx xxxxxx77777777777777777777x222211111xxxxxxx xxxxxx7777777xx777777777777x222211111xxxxxx xxxxxx7777777xx77777777777772222111111xxxxx xxxxxx777777777777777777777x22221111111xxxx xx7777777777777777777777x322222211111111xxx 77777777777777777777777x33222222111111111xx 7777777777777777777777x333222222211111111xx xx7777777777777777777x333322222222111111xxx xx7777777777777777777333332222222221111xxxx xx777xxx777777777777733333222222222211xxxxx xx777x7x77777777777773333322222222222xxxxxx xx777x7x7777777777777x33332222222222xxxxxxx xxx77x7x7777777777777xx333222222222xxxxxxxx xxxx77777777777777777xxx3222222222xxxxxxxxx xxxxx777777777777777777xx22222222xxxxxxxxxx xxxxxx777777777777777777x2222222xxxxxxxxxxx xxxxxxx777777777777777777222222xxxxxxxxxxxx xxxxxxxx7777777777777777722222xxxxxxxxxxxxx xxxxxxxxx77777777777777772222xxxxxxxxxxxxxx xxxxxxxxxx777777777777777222xxxxxxxxxxxxxxx xxxxxxxxxxx77777777777777x2xxxxxxxxxxxxxxxx xxxxxxxxxxxx77777777777777xxxxxxxxxxxxxxxxx xxxxxxxxxxxxx777777777777xxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx7777777777xxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxx77777777xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx777777xxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx7777xxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx77xxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');

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

--
-- Structure de la table `pubs`
--

CREATE TABLE IF NOT EXISTS `pubs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `now_in` int(11) NOT NULL DEFAULT '0',
  `max_in` int(11) NOT NULL DEFAULT '25',
  `mapname` varchar(10) NOT NULL,
  `heightmap` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Contenu de la table `pubs`
--

INSERT INTO `pubs` (`id`, `name`, `now_in`, `max_in`, `mapname`, `heightmap`) VALUES
(1, 'Main Lobby', 0, 25, 'lobby', 'lobby_a');

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

--
-- Structure de la table `rights`
--

CREATE TABLE IF NOT EXISTS `rights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room` int(11) NOT NULL,
  `user` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `rights`
--


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

--
-- Structure de la table `roomitems`
--

CREATE TABLE IF NOT EXISTS `roomitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomid` int(11) NOT NULL,
  `textname` varchar(50) NOT NULL,
  `itemname` varchar(50) NOT NULL,
  `itemdesc` varchar(100) NOT NULL,
  `rgb` varchar(12) NOT NULL DEFAULT '0,0,0',
  `size` varchar(5) NOT NULL DEFAULT '1 1',
  `shortname` varchar(50) NOT NULL,
  `rotate` int(11) NOT NULL DEFAULT '0',
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Contenu de la table `roomitems`
--

INSERT INTO `roomitems` (`id`, `roomid`, `textname`, `itemname`, `itemdesc`, `rgb`, `size`, `shortname`, `rotate`, `x`, `y`) VALUES
(1, 1, 'table_silo_med', 'Coffee Table', 'Wipe cleas and unobtrusive', '0,0,0', '2 2', 'PYS', 0, 7, 9),
(3, 1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', '1 1', 'EHP', 2, 6, 9),
(4, 1, 'sofachair_silo', 'Armchair', 'Large, but worth it', '0,0,0', '1 1', 'STS', 0, 8, 11),
(5, 1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', '1 1', 'EHP', 4, 7, 8),
(6, 1, 'chair_plasto', 'Chair', 'Hip plastic furniture', '0,0,0', '1 1', 'EHP', 4, 8, 8),
(7, 1, 'pizza', 'Pizza Box', 'You dirty Habbo', '0,0,0', '1 1', 'PIZ', 0, 10, 8),
(8, 1, 'fridge', 'Pura Fridge', 'Keep cool with a chilled snack or drink', '0,0,0', '1 1', 'FDG', 0, 4, 11),
(9, 1, 'bar_basic', 'Pura Mini-bar', 'A pura series 300 minibar', '0,0,0', '1 1', 'BABA', 0, 4, 2),
(10, 1, 'shelves_silo', 'Bookcase', 'For nic and art deco books', '0,0,0', '2 1', 'KHS', 4, 9, 1),
(11, 1, 'plant_yukka', 'Yukka Plant', 'Easy to care for', '0,0,0', '1 1', 'JUKKA', 0, 4, 4),
(12, 1, 'duck', 'Rubber Duck', 'Every bather needs one', '0,0,0', '1 1', 'KUMIANKKA', 2, 4, 13),
(13, 1, 'lamp2_armas', 'Church Candle', 'Wax lyrical with some old-world charm', '0,0,0', '1 1', 'KYA', 0, 4, 9),
(14, 1, 'plant_yukka', 'Yukka Plant', 'Easy to care for', '0,0,0', '1 1', 'JUKKA', 0, 4, 10),
(15, 1, 'table_polyfon_small', 'Small Coffee Table', 'For serving a stylish latte', '0,0,0', '1 1', 'PPP', 0, 6, 1),
(16, 1, 'sofa_polyfon', 'Two-Seater Sofa', 'Comfort for stylish couples', '0,0,0', '2 1', 'SHP', 4, 6, 2),
(17, 1, 'drinks', 'Empty Cans', 'Are you a slob too?', '0,0,0', '1 1', 'DRK', 0, 9, 3),
(18, 1, 'doorC', 'Portaloo', 'Festival-chic inter-room transport', '0,0,0', '1 1', 'ovi3', 2, 4, 7),
(19, 1, 'couch_norja', 'Bench', 'Two can perch comfortablt', '0,0,0', '2 1', 'PEN', 0, 8, 6),
(28, 1, 'chair_silo', 'Dining Chair', 'Keep it simple', '0,0,0', '1 1', 'TUS', 0, 4, 1),
(29, 1, 'soft_sofachair_norja', 'Armchair', 'A soft iced sofa chair', '0,0,0', '1 1', 'STN', 0, 10, 5),
(30, 1, 'red_tv', 'Portable TV', 'Dont miss those soaps', '0,0,0', '1 1', 'RTV', 0, 4, 12),
(31, 1, 'table_armas', 'Dining Table', 'For informal dining', '0,0,0', '1 1', 'PIA', 0, 10, 3);

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

--
-- Structure de la table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `owner` varchar(15) NOT NULL,
  `floor` varchar(255) NOT NULL DEFAULT 'floor1',
  `inroom` int(11) NOT NULL DEFAULT '0',
  `model` varchar(10) NOT NULL DEFAULT 'model_a',
  `door` varchar(255) NOT NULL DEFAULT 'open',
  `pass` varchar(255) NOT NULL,
  `space_w` int(11) NOT NULL DEFAULT '100',
  `space_f` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Contenu de la table `rooms`
--

INSERT INTO `rooms` (`id`, `name`, `desc`, `owner`, `floor`, `inroom`, `model`, `door`, `pass`, `space_w`, `space_f`) VALUES
(1, 'Room-o-Matic!', '', 'Wirbelwind', 'floor5', 0, 'model_a', 'open', '', 120, 150);

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

--
-- Structure de la table `shoutbox`
--

CREATE TABLE IF NOT EXISTS `shoutbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` int(11) NOT NULL,
  `message` varchar(100) NOT NULL,
  `published` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

--
-- Contenu de la table `shoutbox`
--

INSERT INTO `shoutbox` (`id`, `author`, `message`, `published`) VALUES
(1, 1, '^^', '2013-07-31 23:08:26');

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

--
-- Structure de la table `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `maintenance` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `site_config`
--

INSERT INTO `site_config` (`maintenance`) VALUES
('0');

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

--
-- Structure de la table `site_news`
--

CREATE TABLE IF NOT EXISTS `site_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE latin1_general_ci NOT NULL,
  `story` text COLLATE latin1_general_ci NOT NULL,
  `published` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `author` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=63 ;

--
-- Contenu de la table `site_news`
--

INSERT INTO `site_news` (`id`, `title`, `story`, `published`, `author`) VALUES
(1, 'Bienvenue !', '<br>\r\n<center><img src="http://i.imm.io/13rkC.gif"></center>Bienvenue dans cette toute nouvelle version .. ancienne je devrais dire ! <br>\r\nEnfin, quoi qu''il en soit, il s''agit du meilleur rÃ©tro Habbo v1 jamais conÃ§u<br>\r\nVous pourrez donc voir comment Ã©tait Habbo Ã  cette Ã©poque ( vers l''an 2000 )<br>\r\n<br>\r\nAutre-chose, tout ce qui est sur le site est directement liÃ© Ã  ce qui se passe<br>\r\n sur l''hÃ´tel et vice-versa <br>\r\n<br>\r\nBonne Visite !<br>\r\n<br>\r\n<b>- Wirbelwind</b><br>\r\n<br>', '2013-08-04 03:22:47', 1);

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

--
-- Structure de la table `useritems`
--

CREATE TABLE IF NOT EXISTS `useritems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) NOT NULL,
  `textname` varchar(255) NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `itemdesc` varchar(255) NOT NULL,
  `rgb` varchar(255) NOT NULL DEFAULT '0,0,0',
  `size` varchar(255) NOT NULL DEFAULT '1 1',
  `shortname` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `useritems`
--


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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL,
  `password` varchar(10) NOT NULL,
  `credits` int(11) NOT NULL DEFAULT '0',
  `email` varchar(50) NOT NULL,
  `figure` varchar(255) NOT NULL,
  `birthday` varchar(10) NOT NULL DEFAULT '01.01.1990',
  `phonenumber` varchar(10) NOT NULL,
  `customData` varchar(20) NOT NULL,
  `had_read_agreement` int(11) NOT NULL DEFAULT '1',
  `sex` varchar(6) NOT NULL DEFAULT 'Male',
  `country` varchar(10) NOT NULL,
  `rank` int(11) NOT NULL DEFAULT '0',
  `badge_type` varchar(1) NOT NULL DEFAULT '0',
  `inroom` int(11) NOT NULL DEFAULT '0',
  `about` varchar(1200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `name`, `password`, `credits`, `email`, `figure`, `birthday`, `phonenumber`, `customData`, `had_read_agreement`, `sex`, `country`, `rank`, `badge_type`, `inroom`, `about`) VALUES
(1, 'Windy', 'death0', 1249, 'wirbelwind@legtux.org', 'sd=001/0&hr=001/255,255,255&hd=002/255,204,153&ey=001/0&fc=001/255,204,153&bd=001/255,204,153&lh=001/255,204,153&rh=001/255,204,153&ch=001/232,177,55&ls=001/232,177,55&rs=001/232,177,55&lg=001/119,159,187&sh=001/175,220,223', '01.01.1990', '0123456789', 'Hey !', 1, 'Female', '', 2, 'A', 0, 'Bienvenue ! &lt;!-- [avatar-panel] Hey ! [avatar] !Â¥Æ’Â¬Â± --');

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

--
-- Structure de la table `user_badges`
--

CREATE TABLE IF NOT EXISTS `user_badges` (
  `user_id` int(11) NOT NULL,
  `badge_id` varchar(5) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `user_badges`
--

INSERT INTO `user_badges` (`user_id`, `badge_id`) VALUES
(1, 'ADM'),
(1, 'BW7'),
(1, 'HB1'),
(1, 'KO1'),
(1, 'NL4'),
(1, 'XXX');

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

--
-- Structure de la table `vote_love`
--

CREATE TABLE IF NOT EXISTS `vote_love` (
  `toid` int(11) NOT NULL,
  `fromid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `vote_love`
--

INSERT INTO `vote_love` (`toid`, `fromid`) VALUES
(1, 1);

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

--
-- Structure de la table `wordfilter`
--

CREATE TABLE IF NOT EXISTS `wordfilter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `word` varchar(20) NOT NULL,
  `filter` varchar(20) NOT NULL DEFAULT 'bobba',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Contenu de la table `wordfilter`
--

INSERT INTO `wordfilter` (`id`, `word`, `filter`) VALUES
(1, 'cunt', 'bobba'),
(2, 'slut', 'bobba'),
(3, 'ho-kang-jou', 'bobba'),
(4, 'fuck', 'bobba'),
(5, 'facking', 'bobba'),
(6, 'ass', 'bobba'),
(7, 'dick', 'bobba'),
(9, 'penis', 'iJakey');
