/*
MySQL Data Transfer
Source Host: localhost
Source Database: wpdb
Target Host: localhost
Target Database: wpdb
Date: 21-7-2008 16:58:35
*/


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

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

-- ----------------------------
-- Table structure for woodpecker_connectionblacklist
-- ----------------------------
CREATE TABLE `woodpecker_connectionblacklist` (
  `ipaddress` varchar(200) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for woodpecker_fuse
-- ----------------------------
CREATE TABLE `woodpecker_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 woodpecker_strings
-- ----------------------------
CREATE TABLE `woodpecker_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 woodpecker_subscriptions
-- ----------------------------
CREATE TABLE `woodpecker_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 woodpecker_subscriptions_badges
-- ----------------------------
CREATE TABLE `woodpecker_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 woodpecker_subscriptions_fuse
-- ----------------------------
CREATE TABLE `woodpecker_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 woodpecker_subscriptions_items
-- ----------------------------
CREATE TABLE `woodpecker_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;
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');
INSERT INTO `woodpecker_config` VALUES ('sockets.info.port', '1337');
INSERT INTO `woodpecker_config` VALUES ('sockets.info.maxconnections', '200');
INSERT INTO `woodpecker_config` VALUES ('sockets.info.backlog', '10');
INSERT INTO `woodpecker_config` VALUES ('strings.language', 'en');
INSERT INTO `woodpecker_config` VALUES ('users.registration.motto', 'Woodpecker Emulator');
INSERT INTO `woodpecker_config` VALUES ('users.registration.credits', '500');
INSERT INTO `woodpecker_config` VALUES ('users.registration.tickets', '6');
INSERT INTO `woodpecker_config` VALUES ('users.registration.films', '0');
INSERT INTO `woodpecker_config` VALUES ('rooms.navigator.opencategory.max', '30');
INSERT INTO `woodpecker_config` VALUES ('rooms.navigator.searchguestroom.max', '30');
INSERT INTO `woodpecker_config` VALUES ('rooms.guestrooms.maxperuser', '15');
INSERT INTO `woodpecker_config` VALUES ('rooms.favorites.maxperuser', '30');
INSERT INTO `woodpecker_config` VALUES ('users.transactions.enabled', '1');
INSERT INTO `woodpecker_config` VALUES ('client.charset', '[100,105,110,115,120,125,130,135,140,145,150,155,160,165,170,175,176,177,178,180,185,190,195,200,205,206,207,210,215,220,225,230,235,240,245,250,255,260,265,266,267,270,275,280,281,285,290,295,300,305,500,505,510,515,520,525,530,535,540,545,550,555,565,570,575,580,585,590,595,596,600,605,610,615,620,625,626,627,630,635,640,645,650,655,660,665,667,669,670,675,680,685,690,695,696,700,705,710,715,720,725,730,735,740]');
INSERT INTO `woodpecker_connectionblacklist` VALUES ('127.0.0.1');
INSERT INTO `woodpecker_fuse` VALUES ('1', '1', 'default');
INSERT INTO `woodpecker_fuse` VALUES ('2', '1', 'fuse_login');
INSERT INTO `woodpecker_fuse` VALUES ('3', '1', 'fuse_buy_credits');
INSERT INTO `woodpecker_fuse` VALUES ('4', '1', 'fuse_trade');
INSERT INTO `woodpecker_fuse` VALUES ('5', '1', 'fuse_room_queue_default');
INSERT INTO `woodpecker_fuse` VALUES ('13', '2', 'fuse_enter_full_rooms');
INSERT INTO `woodpecker_fuse` VALUES ('14', '3', 'fuse_enter_locked_rooms');
INSERT INTO `woodpecker_fuse` VALUES ('16', '3', 'fuse_kick');
INSERT INTO `woodpecker_fuse` VALUES ('17', '3', 'fuse_mute');
INSERT INTO `woodpecker_fuse` VALUES ('18', '4', 'fuse_ban');
INSERT INTO `woodpecker_fuse` VALUES ('19', '4', 'fuse_room_mute');
INSERT INTO `woodpecker_fuse` VALUES ('20', '4', 'fuse_room_kick');
INSERT INTO `woodpecker_fuse` VALUES ('21', '4', 'fuse_receive_calls_for_help');
INSERT INTO `woodpecker_fuse` VALUES ('22', '4', 'fuse_remove_stickies');
INSERT INTO `woodpecker_fuse` VALUES ('23', '5', 'fuse_mod');
INSERT INTO `woodpecker_fuse` VALUES ('24', '5', 'fuse_superban');
INSERT INTO `woodpecker_fuse` VALUES ('25', '5', 'fuse_pick_up_any_furni');
INSERT INTO `woodpecker_fuse` VALUES ('26', '5', 'fuse_ignore_room_owner');
INSERT INTO `woodpecker_fuse` VALUES ('27', '5', 'fuse_any_room_controller');
INSERT INTO `woodpecker_fuse` VALUES ('28', '2', 'fuse_room_alert');
INSERT INTO `woodpecker_fuse` VALUES ('29', '5', 'fuse_moderator_access');
INSERT INTO `woodpecker_fuse` VALUES ('30', '6', 'fuse_administrator_access');
INSERT INTO `woodpecker_fuse` VALUES ('31', '6', 'fuse_see_flat_ids');
INSERT INTO `woodpecker_fuse` VALUES ('35', '5', 'fuse_chat_log');
INSERT INTO `woodpecker_fuse` VALUES ('33', '6', 'fuse_performance_panel');
INSERT INTO `woodpecker_fuse` VALUES ('34', '3', 'fuse_alert');
INSERT INTO `woodpecker_fuse` VALUES ('36', '4', 'fuse_see_all_roomowners');
INSERT INTO `woodpecker_subscriptions` VALUES ('club_habbo', '1', '25', '1');
INSERT INTO `woodpecker_subscriptions` VALUES ('club_habbo', '2', '60', '3');
INSERT INTO `woodpecker_subscriptions` VALUES ('club_habbo', '3', '105', '6');
INSERT INTO `woodpecker_subscriptions_badges` VALUES ('club_habbo', '0', 'HC1');
INSERT INTO `woodpecker_subscriptions_badges` VALUES ('club_habbo', '12', 'HC2');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_outfits');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_badge');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_club_dance');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_use_special_room_layouts');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_room_queue_club');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_priority_access');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_habbo_chooser');
INSERT INTO `woodpecker_subscriptions_fuse` VALUES ('club_habbo', 'fuse_furni_chooser');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '0', 'club_sofa');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_table');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '1', 'aqua_chair');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '2', 'mocchamaster');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '3', 'edicehc');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '4', 'hcamme');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '5', 'doorD');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '6', 'hcsohva');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '7', 'hc_lmp');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '8', 'hc_tbl');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '9', 'hc_chr');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '10', 'hc_dsk');
INSERT INTO `woodpecker_subscriptions_items` VALUES ('club_habbo', '11', 'throne');
