/*
MySQL Data Transfer
Source Host: localhost
Source Database: duckdb
Target Host: localhost
Target Database: duckdb
Date: 21-7-2008 16:55:34
*/

-- ----------------------------
-- Table structure for duck_config
-- ----------------------------
CREATE TABLE `duck_config` (
  `ckey` varchar(50) collate latin1_general_ci NOT NULL,
  `cvalue` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`ckey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_fuse
-- ----------------------------
CREATE TABLE `duck_fuse` (
  `id` int(3) NOT NULL auto_increment,
  `minrank` int(1) NOT NULL,
  `fuseright` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`,`fuseright`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_stats
-- ----------------------------
CREATE TABLE `duck_stats` (
  `onlinecount` int(3) NOT NULL default '0',
  `onlinecount_peak` int(10) NOT NULL,
  `connections_accepted` int(10) NOT NULL,
  `activerooms` int(10) NOT NULL,
  `activerooms_peak` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_strings
-- ----------------------------
CREATE TABLE `duck_strings` (
  `id` int(5) NOT NULL auto_increment,
  `lkey` varchar(50) collate latin1_general_ci NOT NULL,
  `lvalue_en` varchar(200) collate latin1_general_ci NOT NULL,
  `lvalue_nl` varchar(200) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`,`lkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_subscriptions
-- ----------------------------
CREATE TABLE `duck_subscriptions` (
  `subscription` enum('club_habbo') collate latin1_general_ci NOT NULL,
  `choice` enum('3','2','1') collate latin1_general_ci NOT NULL,
  `cost` int(5) NOT NULL,
  `months` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_subscriptions_badges
-- ----------------------------
CREATE TABLE `duck_subscriptions_badges` (
  `subscription` enum('club_habbo') collate latin1_general_ci default NULL,
  `months_passed` int(5) NOT NULL,
  `badge` varchar(3) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_subscriptions_fuse
-- ----------------------------
CREATE TABLE `duck_subscriptions_fuse` (
  `subscription` enum('club_habbo') collate latin1_general_ci NOT NULL,
  `fuseright` varchar(100) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_subscriptions_items
-- ----------------------------
CREATE TABLE `duck_subscriptions_items` (
  `subscription` enum('club_habbo') collate latin1_general_ci NOT NULL,
  `months_passed` int(5) NOT NULL,
  `sprite` varchar(100) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for duck_vouchers
-- ----------------------------
CREATE TABLE `duck_vouchers` (
  `code` varchar(20) collate latin1_general_ci NOT NULL default '',
  `type` enum('item','credits') collate latin1_general_ci NOT NULL default 'credits',
  `value` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for messenger_friendrequests
-- ----------------------------
CREATE TABLE `messenger_friendrequests` (
  `userid_from` int(10) NOT NULL default '0',
  `userid_to` int(10) NOT NULL default '0',
  `requestid` int(10) NOT NULL default '0',
  PRIMARY KEY  (`userid_from`,`userid_to`,`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for messenger_friendships
-- ----------------------------
CREATE TABLE `messenger_friendships` (
  `userid` bigint(20) NOT NULL,
  `friendid` bigint(20) NOT NULL,
  KEY `index extreme` (`userid`),
  KEY `extreme the 2nd` (`friendid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for messenger_messages
-- ----------------------------
CREATE TABLE `messenger_messages` (
  `userid` int(15) NOT NULL,
  `friendid` int(15) NOT NULL,
  `messageid` int(11) NOT NULL,
  `sent_on` text collate latin1_general_ci NOT NULL,
  `message` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`userid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for room_categories
-- ----------------------------
CREATE TABLE `room_categories` (
  `id` int(3) NOT NULL default '0',
  `parent` int(3) NOT NULL default '0',
  `type` int(1) NOT NULL default '1',
  `name` varchar(100) collate latin1_general_ci NOT NULL default 'Non-named category',
  `access_rank_min` int(2) NOT NULL,
  `access_rank_hideforlower` enum('0','1') collate latin1_general_ci NOT NULL,
  `trading` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for room_modeldata
-- ----------------------------
CREATE TABLE `room_modeldata` (
  `model` varchar(100) collate latin1_general_ci NOT NULL,
  `roomomatic_subscr_only` int(1) NOT NULL default '0',
  `door_x` int(3) NOT NULL,
  `door_y` int(3) NOT NULL,
  `door_h` int(3) NOT NULL,
  `door_z` int(1) NOT NULL,
  `heightmap` text collate latin1_general_ci NOT NULL,
  `publicroom_items` text collate latin1_general_ci NOT NULL,
  `swimmingpool` enum('1','0') collate latin1_general_ci NOT NULL default '0',
  `specialcast_emitter` varchar(15) collate latin1_general_ci default NULL,
  `specialcast_interval` int(10) default NULL,
  `specialcast_rnd_min` int(10) default NULL,
  `specialcast_rnd_max` int(10) default NULL,
  PRIMARY KEY  (`model`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for users_badges
-- ----------------------------
CREATE TABLE `users_badges` (
  `userid` int(10) NOT NULL,
  `badge` varchar(3) collate latin1_general_ci NOT NULL,
  `current` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  `subscription` enum('club_habbo') collate latin1_general_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for users_club
-- ----------------------------
CREATE TABLE `users_club` (
  `userid` bigint(6) NOT NULL,
  `months_expired` int(4) default NULL,
  `months_left` int(4) default NULL,
  `date_monthstarted` varchar(25) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for users_favouriterooms
-- ----------------------------
CREATE TABLE `users_favouriterooms` (
  `userid` int(10) NOT NULL,
  `roomid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for users_subscriptions
-- ----------------------------
CREATE TABLE `users_subscriptions` (
  `userid` int(11) NOT NULL,
  `subscription` enum('club_habbo') collate latin1_general_ci NOT NULL default 'club_habbo',
  `active` enum('0','1') collate latin1_general_ci NOT NULL,
  `months_expired` int(5) NOT NULL,
  `months_left` int(5) NOT NULL,
  `date_monthstarted` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for users_transactions
-- ----------------------------
CREATE TABLE `users_transactions` (
  `id` int(10) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `date` varchar(50) collate latin1_general_ci NOT NULL,
  `time` time NOT NULL,
  `type` enum('web_internal','sms_win_vodafone','tsms_win_tmobile','messenger','creditcards_is','htk_singledrop','refunds','splashplastic','sms_win_orange','bibit','stuff_store','sms_win_btcellnet','win_voucher','club_habbo') collate latin1_general_ci NOT NULL,
  `activity` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `duck_config` VALUES ('sockets.info.port', '1337');
INSERT INTO `duck_config` VALUES ('sockets.info.maxconnections', '200');
INSERT INTO `duck_config` VALUES ('sockets.info.backlog', '10');
INSERT INTO `duck_config` VALUES ('strings.language', 'en');
INSERT INTO `duck_config` VALUES ('users.registration.motto', 'Project Duck - Habbo');
INSERT INTO `duck_config` VALUES ('users.registration.credits', '500');
INSERT INTO `duck_config` VALUES ('users.registration.tickets', '6');
INSERT INTO `duck_config` VALUES ('users.registration.films', '0');
INSERT INTO `duck_config` VALUES ('rooms.navigator.opencategory.max', '30');
INSERT INTO `duck_config` VALUES ('rooms.navigator.searchguestroom.max', '30');
INSERT INTO `duck_config` VALUES ('rooms.guestrooms.maxperuser', '15');
INSERT INTO `duck_config` VALUES ('rooms.favorites.maxperuser', '30');
INSERT INTO `duck_config` VALUES ('users.transactions.enabled', '1');
INSERT INTO `duck_fuse` VALUES ('1', '1', 'default');
INSERT INTO `duck_fuse` VALUES ('2', '1', 'fuse_login');
INSERT INTO `duck_fuse` VALUES ('3', '1', 'fuse_buy_credits');
INSERT INTO `duck_fuse` VALUES ('4', '1', 'fuse_trade');
INSERT INTO `duck_fuse` VALUES ('5', '1', 'fuse_room_queue_default');
INSERT INTO `duck_fuse` VALUES ('13', '2', 'fuse_enter_full_rooms');
INSERT INTO `duck_fuse` VALUES ('14', '3', 'fuse_enter_locked_rooms');
INSERT INTO `duck_fuse` VALUES ('16', '3', 'fuse_kick');
INSERT INTO `duck_fuse` VALUES ('17', '3', 'fuse_mute');
INSERT INTO `duck_fuse` VALUES ('18', '4', 'fuse_ban');
INSERT INTO `duck_fuse` VALUES ('19', '4', 'fuse_room_mute');
INSERT INTO `duck_fuse` VALUES ('20', '4', 'fuse_room_kick');
INSERT INTO `duck_fuse` VALUES ('21', '4', 'fuse_receive_calls_for_help');
INSERT INTO `duck_fuse` VALUES ('22', '4', 'fuse_remove_stickies');
INSERT INTO `duck_fuse` VALUES ('23', '5', 'fuse_mod');
INSERT INTO `duck_fuse` VALUES ('24', '5', 'fuse_superban');
INSERT INTO `duck_fuse` VALUES ('25', '5', 'fuse_pick_up_any_furni');
INSERT INTO `duck_fuse` VALUES ('26', '5', 'fuse_ignore_room_owner');
INSERT INTO `duck_fuse` VALUES ('27', '5', 'fuse_any_room_controller');
INSERT INTO `duck_fuse` VALUES ('28', '2', 'fuse_room_alert');
INSERT INTO `duck_fuse` VALUES ('29', '5', 'fuse_moderator_access');
INSERT INTO `duck_fuse` VALUES ('30', '6', 'fuse_administrator_access');
INSERT INTO `duck_fuse` VALUES ('31', '6', 'fuse_see_flat_ids');
INSERT INTO `duck_fuse` VALUES ('35', '5', 'fuse_chat_log');
INSERT INTO `duck_fuse` VALUES ('33', '6', 'fuse_performance_panel');
INSERT INTO `duck_fuse` VALUES ('34', '3', 'fuse_alert');
INSERT INTO `duck_fuse` VALUES ('36', '4', 'fuse_see_all_roomowners');
INSERT INTO `duck_stats` VALUES ('0', '0', '0', '0', '0');
INSERT INTO `duck_subscriptions` VALUES ('club_habbo', '1', '25', '1');
INSERT INTO `duck_subscriptions` VALUES ('club_habbo', '2', '60', '3');
INSERT INTO `duck_subscriptions` VALUES ('club_habbo', '3', '105', '6');
INSERT INTO `duck_subscriptions_badges` VALUES ('club_habbo', '0', 'HC1');
INSERT INTO `duck_subscriptions_badges` VALUES ('club_habbo', '12', 'HC2');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_outfits');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_badge');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_dance');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_special_room_layouts');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_room_queue_club');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_priority_access');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_habbo_chooser');
INSERT INTO `duck_subscriptions_fuse` VALUES ('club_habbo', 'fuse_furni_chooser');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '0', 'club_sofa');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_table');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '2', 'mocchamaster');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '3', 'edicehc');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '4', 'hcamme');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '5', 'doorD');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '6', 'hcsohva');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '7', 'hc_lmp');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '8', 'hc_tbl');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '9', 'hc_chr');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '10', 'hc_dsk');
INSERT INTO `duck_subscriptions_items` VALUES ('club_habbo', '11', 'throne');
INSERT INTO `duck_vouchers` VALUES ('meep', 'credits', '50');
INSERT INTO `room_categories` VALUES ('0', '1', '2', 'No category', '1', '0', '0');
INSERT INTO `room_categories` VALUES ('3', '0', '0', 'Public Rooms', '1', '0', '0');
INSERT INTO `room_categories` VALUES ('4', '0', '2', 'Guestrooms', '1', '0', '0');
INSERT INTO `room_categories` VALUES ('6', '4', '2', 'Duck nests', '1', '0', '1');
INSERT INTO `room_categories` VALUES ('5', '3', '0', 'Outside spaces', '1', '0', '0');
INSERT INTO `room_categories` VALUES ('7', '3', '0', 'Entertainment', '1', '0', '0');
INSERT INTO `room_modeldata` VALUES ('a', '0', '3', '5', '0', '0', 'xxxxxxxxxxxx\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxx00000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('b', '0', '0', '5', '0', '0', 'xxxxxxxxxxxx\rxxxxx0000000\rxxxxx0000000\rxxxxx0000000\rxxxxx0000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rx00000000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('c', '0', '4', '7', '0', '0', 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('d', '0', '4', '7', '0', '0', 'xxxxxxxxxxxx\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxx000000x\rxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('e', '0', '1', '5', '0', '0', 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxx0000000000\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('f', '0', '2', '5', '0', '0', 'xxxxxxxxxxxx\rxxxxxxx0000x\rxxxxxxx0000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rx0000000000x\rx0000000000x\rx0000000000x\rx0000000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('g', '0', '1', '7', '1', '0', 'xxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxx00000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxx1111000000x\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxx00000x\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx\rxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('h', '0', '4', '4', '1', '0', 'xxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx111111x\rxxxxx000000x\rxxxxx000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxx00000000x\rxxxxxxxxxxxx\rxxxxxxxxxxxx\rxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('i', '0', '0', '10', '0', '0', 'xxxxxxxxxxxxxxxxx\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rx0000000000000000\rxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('j', '0', '0', '10', '0', '0', 'xxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rxxxxxxxxxxx0000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rx0000000000xxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('k', '0', '0', '13', '0', '0', 'xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxxxxxx00000000\rxxxxxxxxxxxxxxxxx00000000\rxxxxxxxxxxxxxxxxx00000000\rxxxxxxxxxxxxxxxxx00000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rx000000000000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxxxxxxxxxxxxxxxxxx\r\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('l', '0', '0', '16', '0', '0', 'xxxxxxxxxxxxxxxxxxxxx\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rx00000000xxxx00000000\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('m', '0', '0', '15', '1', '0', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rx0000000000000000000000000000\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxx00000000xxxxxxxxxx\rxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('n', '0', '0', '16', '0', '0', 'xxxxxxxxxxxxxxxxxxxxx\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx000000xxxxxxxx000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000x000000x000000\rx000000xxxxxxxx000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rx00000000000000000000\rxxxxxxxxxxxxxxxxxxxxx\r', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('o', '0', '0', '18', '1', '0', 'xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx11111111xxxx\rxxxxxxxxxxxxx00000000xxxx\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rx111111100000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxx0000000000000000\rxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('p', '0', '0', '23', '2', '0', 'xxxxxxxxxxxxxxxxxxx\rxxxxxxx222222222222\rxxxxxxx222222222222\rxxxxxxx222222222222\rxxxxxxx222222222222\rxxxxxxx222222222222\rxxxxxxx222222222222\rxxxxxxx22222222xxxx\rxxxxxxx11111111xxxx\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx222221111111111111\rx2222xx11111111xxxx\rx2222xx00000000xxxx\rx2222xx000000000000\rx2222xx000000000000\rx2222xx000000000000\rx2222xx000000000000\rx2222xx000000000000\rx2222xx000000000000\rxxxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('q', '0', '10', '4', '2', '0', 'xxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx22222222\rxxxxxxxxxxx22222222\rxxxxxxxxxxx22222222\rxxxxxxxxxxx22222222\rxxxxxxxxxxx22222222\rxxxxxxxxxxx22222222\rx222222222222222222\rx222222222222222222\rx222222222222222222\rx222222222222222222\rx222222222222222222\rx222222222222222222\rx2222xxxxxxxxxxxxxx\rx2222xxxxxxxxxxxxxx\rx2222211111xx000000\rx222221111110000000\rx222221111110000000\rx2222211111xx000000\rxx22xxx1111xxxxxxxx\rxx11xxx1111xxxxxxxx\rx1111xx1111xx000000\rx1111xx111110000000\rx1111xx111110000000\rx1111xx1111xx000000\rxxxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('r', '0', '10', '4', '3', '0', 'xxxxxxxxxxxxxxxxxxxxxxxxx\rxxxxxxxxxxx33333333333333\rxxxxxxxxxxx33333333333333\rxxxxxxxxxxx33333333333333\rxxxxxxxxxxx33333333333333\rxxxxxxxxxxx33333333333333\rxxxxxxxxxxx33333333333333\rxxxxxxx333333333333333333\rxxxxxxx333333333333333333\rxxxxxxx333333333333333333\rxxxxxxx333333333333333333\rxxxxxxx333333333333333333\rxxxxxxx333333333333333333\rx4444433333xxxxxxxxxxxxxx\rx4444433333xxxxxxxxxxxxxx\rx44444333333222xx000000xx\rx44444333333222xx000000xx\rxxx44xxxxxxxx22xx000000xx\rxxx33xxxxxxxx11xx000000xx\rxxx33322222211110000000xx\rxxx33322222211110000000xx\rxxxxxxxxxxxxxxxxx000000xx\rxxxxxxxxxxxxxxxxx000000xx\rxxxxxxxxxxxxxxxxx000000xx\rxxxxxxxxxxxxxxxxx000000xx\rxxxxxxxxxxxxxxxxxxxxxxxxx', '', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('newbie_lobby', '0', '2', '11', '0', '2', 'xxxxxxxxxxxxxxxx000000\rxxxxx0xxxxxxxxxx000000\rxxxxx00000000xxx000000\rxxxxx000000000xx000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\r0000000000000000000000\rxxxxx000000000000000xx\rxxxxx000000000000000xx\rx0000000000000000000xx\rx0000000000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxxx0000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxxxx000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxxx00000000000xxxxx\rxxxxx000000000000xxxxx\rxxxxx000000000000xxxxx\r', 'a160 crl_lamp 16 0 0 0 1\r\ny170 crl_sofa2c 17 0 0 4 2\r\nw180 crl_sofa2b 18 0 0 4 2\r\nv190 crl_sofa2a 19 0 0 4 2\r\na200 crl_lamp 20 0 0 0 1\r\nb161 crl_chair 16 1 0 2 2\r\na72 crl_lamp 7 2 0 0 1\r\na112 crl_lamp 11 2 0 0 1\r\nb162 crl_chair 16 2 0 2 2\r\nc53 crl_pillar 5 3 0 0 1\r\nb73 crl_chair 7 3 0 2 2\r\nu93 crl_table1b 9 3 0 0 1\r\ns113 crl_sofa1c 11 3 0 6 2\r\nb163 crl_chair 16 3 0 2 2\r\nA193 crl_table2b 19 3 0 0 1\r\nz203 crl_table2a 20 3 0 0 1\r\na04 crl_lamp 0 4 0 0 1\r\ny14 crl_sofa2c 1 4 0 4 2\r\nw24 crl_sofa2b 2 4 0 4 2\r\nv34 crl_sofa2a 3 4 0 4 2\r\na44 crl_lamp 4 4 0 0 1\r\nt94 crl_table1a 9 4 0 0 1\r\nr114 crl_sofa1b 11 4 0 6 2\r\nh154 crl_wall2a 15 4 0 0 1\r\na164 crl_lamp 16 4 0 0 1\r\nb05 crl_chair 0 5 0 2 2\r\nb75 crl_chair 7 5 0 2 2\r\nq115 crl_sofa1a 11 5 0 6 2\r\nA26 crl_table2b 2 6 0 0 1\r\nz36 crl_table2a 3 6 0 0 1\r\na116 crl_lamp 11 6 0 0 1\r\nb07 crl_chair 0 7 0 2 2\r\na08 crl_lamp 0 8 0 0 1\r\nD18 crl_sofa3c 1 8 0 0 2\r\nC28 crl_sofa3b 2 8 0 0 2\r\nB38 crl_sofa3a 3 8 0 0 2\r\na48 crl_lamp 4 8 0 0 1\r\no198 crl_barchair2 19 8 0 0 2\r\np208 crl_tablebar 20 8 0 0 1\r\no218 crl_barchair2 21 8 0 0 2\r\nE59 crl_pillar2 5 9 0 0 1\r\nc99 crl_pillar 9 9 0 0 1\r\nP815 crl_desk1a 8 15 0 0 1\r\nO915 crl_deski 9 15 0 0 1\r\nN1015 crl_deskh 10 15 0 0 1\r\nM1016 crl_deskg 10 16 0 0 1\r\nL1017 crl_deskf 10 17 0 0 1\r\nK1018 crl_deske 10 18 0 0 1\r\nK1019 crl_deske 10 19 0 0 1\r\nK1020 crl_deske 10 20 0 0 1\r\nK1021 crl_deske 10 21 0 0 1\r\nK1022 crl_deske 10 22 0 0 1\r\nK1023 crl_deske 10 23 0 0 1\r\nG724 crl_wallb 7 24 0 0 1\r\nK1024 crl_deske 10 24 0 0 1\r\nF725 crl_walla 7 25 0 0 1\r\nH825 crl_desk1b 8 25 0 0 1\r\nI925 crl_desk1c 9 25 0 0 1\r\nJ1025 crl_desk1d 10 25 0 0 1\r\nd1227 crl_lamp2 12 27 0 0 1\r\nf1327 crl_cabinet2 13 27 0 0 1\r\ne1427 crl_cabinet1 14 27 0 0 1\r\nd1527 crl_lamp2 15 27 0 0 1', '', '0', '1', null, null);
INSERT INTO `room_modeldata` VALUES ('theater', '0', '20', '27', '0', '0', 'XXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXXXXXXXXXXXXXXXXXX\rXXXXXXX111111111XXXXXXX\rXXXXXXX11111111100000XX\rXXXX00X11111111100000XX\rXXXX00x11111111100000XX\r4XXX00X11111111100000XX\r4440000XXXXXXXXX00000XX\r444000000000000000000XX\r4XX000000000000000000XX\r4XX0000000000000000000X\r44400000000000000000000\r44400000000000000000000\r44X0000000000000000O000\r44X11111111111111111000\r44X11111111111111111000\r33X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22X11111111111111111000\r22211111111111111111000\r22211111111111111111000\rXXXXXXXXXXXXXXXXXXXX00X\rXXXXXXXXXXXXXXXXXXXX00X\r', 'm1110 mic 11 10 1 0 1\r\nd211 thchair2 2 11 4 2 2\r\nd212 thchair2 2 12 4 2 2\r\nd215 thchair2 2 15 4 2 2\r\nc615 thchair1 6 15 0 0 2\r\nc715 thchair1 7 15 0 0 2\r\nc815 thchair1 8 15 0 0 2\r\nc915 thchair1 9 15 0 0 2\r\nc1015 thchair1 10 15 0 0 2\r\nc1215 thchair1 12 15 0 0 2\r\nc1315 thchair1 13 15 0 0 2\r\nc1415 thchair1 14 15 0 0 2\r\nc1515 thchair1 15 15 0 0 2\r\nc1615 thchair1 16 15 0 0 2\r\nd216 thchair2 2 16 4 2 2\r\nc620 thchair1 6 20 1 0 2\r\nc720 thchair1 7 20 1 0 2\r\nc820 thchair1 8 20 1 0 2\r\nc920 thchair1 9 20 1 0 2\r\nc1020 thchair1 10 20 1 0 2\r\nc1220 thchair1 12 20 1 0 2\r\nc1320 thchair1 13 20 1 0 2\r\nc1420 thchair1 14 20 1 0 2\r\nc1520 thchair1 15 20 1 0 2\r\nc1620 thchair1 16 20 1 0 2\r\nc623 thchair1 6 23 1 0 2\r\nc723 thchair1 7 23 1 0 2\r\nc823 thchair1 8 23 1 0 2\r\nc923 thchair1 9 23 1 0 2\r\nc1023 thchair1 10 23 1 0 2\r\nc1223 thchair1 12 23 1 0 2\r\nc1323 thchair1 13 23 1 0 2\r\nc1423 thchair1 14 23 1 0 2\r\nc1523 thchair1 15 23 1 0 2\r\nc1623 thchair1 16 23 1 0 2\r\nc626 thchair1 6 26 1 0 2\r\nc726 thchair1 7 26 1 0 2\r\nc826 thchair1 8 26 1 0 2\r\nc926 thchair1 9 26 1 0 2\r\nc1026 thchair1 10 26 1 0 2\r\nc1226 thchair1 12 26 1 0 2\r\nc1326 thchair1 13 26 1 0 2\r\nc1426 thchair1 14 26 1 0 2\r\nc1526 thchair1 15 26 1 0 2\r\nc1626 thchair1 16 26 1 0 2', '', '0', '1', null, null);
INSERT INTO `users_badges` VALUES ('1', 'ADM', '0', null);
INSERT INTO `users_badges` VALUES ('1', 'HC1', '0', null);
INSERT INTO `users_club` VALUES ('1', '0', '7', '2-7-2008');
INSERT INTO `users_favouriterooms` VALUES ('1', '200');
INSERT INTO `users_favouriterooms` VALUES ('1', '101');
INSERT INTO `users_subscriptions` VALUES ('1', 'club_habbo', '1', '2', '12', '3-7-2008');
INSERT INTO `users_transactions` VALUES ('5', '1', '3-7-2008', '14:42:00', 'win_voucher', '10');
