olliedean
ollie.cool
- Jan 28, 2013
- 433
- 107
Comes up with these errors, using Navicat, 371 errors:
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('300003', 'ads_mpu_720', 'Square Glass Window', 's', '1', '1', '0', '1', '0', '1', '4036', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('360005', 'anc_comfy_tree', 'Not so tall tree', 's', '1', '1', '5', '1', '1', '0', '4653', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('360006', 'anc_sunset_wall', 'Jungle landscape', 'i', '0', '0', '0', '1', '0', '0', '4462', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('381982', 'prizetrophy_frank', 'Frank Trophy', 's', '1', '1', '1', '1', '0', '0', '4641', '1', '1', '1', '1', '1', 'trophy', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'Room Background', 's', '1', '1', '0', '1', '0', '1', '3996', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('445457', 'CF_200_ruby', 'Big Ruby', 's', '1', '1', '1', '1', '0', '0', '4613', '1', '1', '1', '1', '1', 'exchange', '200', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('445458', 'CF_75_ruby_small', 'Small Ruby', 's', '1', '1', '1', '1', '0', '0', '4612', '1', '1', '1', '1', '1', 'exchange', '75', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('456456', 'tstool', 'tstool', 's', '1', '1', '1', '1', '1', '0', '456456', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('461932', 'kuurna_red_chair1', 'Pixel Dining Table', 's', '1', '1', '1', '0', '1', '0', '461932', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462033', 'kuurna_table', 'Pixel Dining Table', 's', '2', '2', '1.3', '1', '0', '0', '3926', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462133', 'kuurna_red_table1', 'Pixel Side Table', 's', '1', '1', '1.3', '1', '0', '0', '4621', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462233', 'kuurna_red_lamp', 'Pixel Lamp', 's', '1', '1', '1', '0', '0', '0', '4622', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490312', 'ads_vpiggy_flag', 'Piggy Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5195', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490412', 'ads_vpiggy_pig', 'Golden Pig', 's', '1', '1', '1', '0', '0', '0', '5196', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490512', 'pirate_side1', 'pirate_side1 name', 's', '1', '1', '1', '1', '0', '1', '5215', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490612', 'pirate_stage', 'Stage', 's', '2', '2', '0.9', '1', '0', '1', '5230', '1', '1', '1', '1', '1', 'default', '0', '5', '0', '0.8,2.0,3.0,4.0,5.0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490712', 'pirate_roombg', 'Pirate Room Background', 's', '1', '1', '1', '1', '0', '1', '5216', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490812', 'pirate_flag', 'Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5232', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490912', 'pirate_gunrack', 'Gun Rack', 's', '2', '1', '1', '1', '0', '0', '5236', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('491012', 'pirate_cannon', 'Pirate Cannon', 's', '2', '1', '1', '1', '0', '0', '5222', '1', '1', '1', '1', '1', 'cannon', '0', '2', '0', '0', '0', '0', '0', '0', '0')
[Err] 1265 - Data truncated for column 'tab_colour' at row 1
[Err] INSERT INTO `permissions_rights` VALUES ('236', '9', '49');
-- ----------------------------
-- Table structure for `permissions_subscriptions`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_subscriptions`;
CREATE TABLE `permissions_subscriptions` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`subscription_id` int(10) NOT NULL,
`permission_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of permissions_subscriptions
-- ----------------------------
INSERT INTO `permissions_subscriptions` VALUES ('1', '1', '1');
INSERT INTO `permissions_subscriptions` VALUES ('2', '2', '2');
INSERT INTO `permissions_subscriptions` VALUES ('3', '3', '3');
-- ----------------------------
-- Table structure for `quests`
-- ----------------------------
DROP TABLE IF EXISTS `quests`;
CREATE TABLE `quests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(32) NOT NULL DEFAULT '',
`level_num` int(11) NOT NULL DEFAULT '0',
`goal_type` int(10) NOT NULL DEFAULT '0',
`goal_data` int(10) unsigned NOT NULL DEFAULT '0',
`action` varchar(32) NOT NULL DEFAULT '',
`pixel_reward` int(11) NOT NULL DEFAULT '10',
`data_bit` varchar(2) NOT NULL DEFAULT '',
`reward_type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`timestamp_unlock` int(11) NOT NULL DEFAULT '0',
`timestamp_lock` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of quests
-- ----------------------------
INSERT INTO `quests` VALUES ('2', 'identity', '1', '14', '1', 'CHANGEFIGURE', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('3', 'social', '2', '9', '1', 'CHATWITHSOMEONE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('6', 'social', '5', '12', '1', 'DANCE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('15', 'social', '1', '8', '1', 'ENTEROTHERSROOM', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('17', 'identity', '2', '15', '1', 'CHANGEMOTTO', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('101', 'room_builder', '1', '0', '3', 'MOVEITEM', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('104', 'explore', '1', '17', '1936', 'FINDLIFEGUARDTOWER', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('105', 'room_builder', '2', '1', '3', 'ROTATEITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('106', 'room_builder', '3', '2', '1', 'PLACEITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('107', 'room_builder', '4', '3', '1', 'PICKUPITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('108', 'room_builder', '5', '4', '2', 'SWITCHSTATE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('109', 'room_builder', '6', '5', '1', 'STACKITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('110', 'room_builder', '7', '6', '1', 'PLACEFLOOR', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('111', 'room_builder', '8', '7', '1', 'PLACEWALLPAPER', '10', '_1', '0', '0', '0');
INSERT INTO `quests` VALUES ('113', 'identity', '3', '16', '1', 'WEARBADGE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('115', 'social', '3', '10', '1', 'REQUESTFRIEND', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('116', 'social', '4', '11', '1', 'GIVERESPECT', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('118', 'social', '6', '13', '1', 'WAVE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('119', 'explore', '2', '17', '1948', 'SWIM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('120', 'explore', '3', '17', '1969', 'FINDSURFBOARD', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('121', 'explore', '4', '17', '1956', 'FINDBEETLE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('122', 'explore', '5', '17', '1369', 'FINDNEONFLOOR', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('123', 'explore', '6', '17', '1375', 'FINDDISCOBALL', '10', '', '0', '0',
[Err] 1146 - Table 'retro.room_chat_styles' doesn't exist
[Err] INSERT INTO `room_chat_styles` VALUES ('18', '', '');
INSERT INTO `room_chat_styles` VALUES ('19', 'piglet', '');
INSERT INTO `room_chat_styles` VALUES ('20', 'sausagedog', '');
INSERT INTO `room_chat_styles` VALUES ('21', 'firingmylazer', '');
INSERT INTO `room_chat_styles` VALUES ('22', 'dragon', '');
INSERT INTO `room_chat_styles` VALUES ('23', 'staff', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('24', 'bats', '');
INSERT INTO `room_chat_styles` VALUES ('25', 'console', '');
INSERT INTO `room_chat_styles` VALUES ('26', '', '');
INSERT INTO `room_chat_styles` VALUES ('27', 'storm', '');
INSERT INTO `room_chat_styles` VALUES ('28', 'parrot', '');
INSERT INTO `room_chat_styles` VALUES ('29', 'pirate', '');
INSERT INTO `room_chat_styles` VALUES ('30', 'bot_guide', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('31', 'bot_rentable', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('32', 'skelestock', '');
INSERT INTO `room_chat_styles` VALUES ('33', 'bot_frank', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('34', 'notification', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('35', 'goat', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('36', 'santa', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('37', '', 'mod_tool');
-- ----------------------------
-- Table structure for `room_filter`
-- ----------------------------
DROP TABLE IF EXISTS `room_filter`;
CREATE TABLE `room_filter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(15) NOT NULL DEFAULT '',
`room_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `room_id` (`room_id`),
KEY `word` (`word`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_filter
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_moodlight`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_moodlight`;
CREATE TABLE `room_items_moodlight` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(10) unsigned NOT NULL,
`enabled` enum('0','1') NOT NULL DEFAULT '0',
`current_preset` int(11) NOT NULL,
`preset_one` text NOT NULL,
`preset_two` text NOT NULL,
`preset_three` text NOT NULL,
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_items_moodlight
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_tele_links`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_tele_links`;
CREATE TABLE `room_items_tele_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tele_one_id` int(10) unsigned NOT NULL,
`tele_two_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `tele_one_id` (`tele_one_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_items_tele_links
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_toner`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_toner`;
CREATE TABLE `room_items_toner` (
`id` int(11) unsigned NOT NULL,
`enabled` enum('0','1') DEFAULT '0',
`data1` int(11) NOT NULL,
`data2` int(11) NOT NULL,
`data3` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of room_items_toner
-- ----------------------------
-- ----------------------------
-- Table structure for `room_models`
-- ----------------------------
DROP TABLE IF EXISTS `room_models`;
CREATE TABLE `room_models` (
`id` varchar(100) NOT NULL,
`door_x` int(11) NOT NULL,
`door_y` int(11) NOT NULL,
`door_z` double NOT NULL,
`door_dir` int(4) NOT NULL DEFAULT '2',
`heightmap` text NOT NULL,
`public_items` text NOT NULL,
`club_only` enum('0','1') NOT NULL DEFAULT '0',
`poolmap` varchar(100) NOT NULL DEFAU
[Err] 1146 - Table 'retro.server_settings' doesn't exist
[Err] INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.');
INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes');
INSERT INTO `server_settings` VALUES ('user.login.message.enabled', '0', 'If this is enabled, a message from the server_locale table will be given to the user.');
-- ----------------------------
-- Table structure for `server_status`
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status` (
`users_online` int(11) NOT NULL DEFAULT '0',
`loaded_rooms` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `users_online` (`users_online`) USING BT
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of server_status
-- ----------------------------
INSERT INTO `server_status` VALUES ('0', '0');
-- ----------------------------
-- Table structure for `subscriptions`
-- ----------------------------
DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions` (
`id` int(10) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
`badge_code` varchar(10) NOT NULL,
`credits` int(11) NOT NULL DEFAULT '100',
`duckets` int(11) NOT NULL DEFAULT '100',
`respects` int(11) NOT NULL DEFAULT '3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of subscriptions
-- ----------------------------
INSERT INTO `subscriptions` VALUES ('1', 'Silver VIP', 'SVIP', '200', '150', '15');
INSERT INTO `subscriptions` VALUES ('2', 'Gold VIP', 'GVIP', '300', '200', '20');
INSERT INTO `subscriptions` VALUES ('3', 'Events Staff', 'EVENT', '500', '250', '20');
-- ----------------------------
-- Table structure for `talents`
-- ----------------------------
DROP TABLE IF EXISTS `talents`;
CREATE TABLE `talents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` enum('citizenship','helper') NOT NULL,
`level` int(11) DEFAULT '0',
`data_actions` text NOT NULL,
`data_gifts` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of talents
-- ----------------------------
INSERT INTO `talents` VALUES ('1', 'citizenship', '0', '', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('2', 'citizenship', '1', '', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('3', 'citizenship', '2', 'TRADE', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('4', 'citizenship', '3', 'CITIZEN', 'A1 KUMIANKKA|pixel_walldeco');
-- ----------------------------
-- Table structure for `talents_sub_levels`
-- ----------------------------
DROP TABLE IF EXISTS `talents_sub_levels`;
CREATE TABLE `talents_sub_levels` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`talent_level` int(11) NOT NULL DEFAULT '0',
`sub_level` int(11) NOT NULL DEFAULT '0',
`badge_code` varchar(45) NOT NULL DEFAULT '',
`required_progress` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of talents_sub_levels
-- ----------------------------
INSERT INTO `talents_sub_levels` VALUES ('1', '0', '1', 'ACH_SafetyQuizGraduate1', '1');
INSERT INTO `talents_sub_levels` VALUES ('2', '1', '1', 'ACH_AvatarLooks1', '1');
INSERT INTO `talents_sub_levels` VALUES ('3', '1', '2', 'ACH_RespectGiven1', '2');
INSERT INTO `talents_sub_levels` VALUES ('4', '1', '3', 'ACH_AllTimeHotelPresence1', '60');
INSERT INTO `talents_sub_levels` VALUES
[Msg] Finished - Unsuccessfully
--------------------------------------------------
[Err] 1265 - Data truncated for column 'is_rare' at row 1
[Err] INSERT INTO `furniture` VALUES ('300003', 'ads_mpu_720', 'Square Glass Window', 's', '1', '1', '0', '1', '0', '1', '4036', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('360005', 'anc_comfy_tree', 'Not so tall tree', 's', '1', '1', '5', '1', '1', '0', '4653', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('360006', 'anc_sunset_wall', 'Jungle landscape', 'i', '0', '0', '0', '1', '0', '0', '4462', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('381982', 'prizetrophy_frank', 'Frank Trophy', 's', '1', '1', '1', '1', '0', '0', '4641', '1', '1', '1', '1', '1', 'trophy', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'Room Background', 's', '1', '1', '0', '1', '0', '1', '3996', '1', '1', '1', '1', '1', 'background', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('445457', 'CF_200_ruby', 'Big Ruby', 's', '1', '1', '1', '1', '0', '0', '4613', '1', '1', '1', '1', '1', 'exchange', '200', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('445458', 'CF_75_ruby_small', 'Small Ruby', 's', '1', '1', '1', '1', '0', '0', '4612', '1', '1', '1', '1', '1', 'exchange', '75', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('456456', 'tstool', 'tstool', 's', '1', '1', '1', '1', '1', '0', '456456', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `furniture` VALUES ('461932', 'kuurna_red_chair1', 'Pixel Dining Table', 's', '1', '1', '1', '0', '1', '0', '461932', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462033', 'kuurna_table', 'Pixel Dining Table', 's', '2', '2', '1.3', '1', '0', '0', '3926', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462133', 'kuurna_red_table1', 'Pixel Side Table', 's', '1', '1', '1.3', '1', '0', '0', '4621', '1', '1', '1', '1', '1', 'default', '0', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('462233', 'kuurna_red_lamp', 'Pixel Lamp', 's', '1', '1', '1', '0', '0', '0', '4622', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490312', 'ads_vpiggy_flag', 'Piggy Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5195', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490412', 'ads_vpiggy_pig', 'Golden Pig', 's', '1', '1', '1', '0', '0', '0', '5196', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490512', 'pirate_side1', 'pirate_side1 name', 's', '1', '1', '1', '1', '0', '1', '5215', '1', '1', '1', '1', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490612', 'pirate_stage', 'Stage', 's', '2', '2', '0.9', '1', '0', '1', '5230', '1', '1', '1', '1', '1', 'default', '0', '5', '0', '0.8,2.0,3.0,4.0,5.0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490712', 'pirate_roombg', 'Pirate Room Background', 's', '1', '1', '1', '1', '0', '1', '5216', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490812', 'pirate_flag', 'Pirate Flag', 's', '1', '1', '1', '1', '0', '0', '5232', '1', '1', '1', '1', '1', 'default', '0', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('490912', 'pirate_gunrack', 'Gun Rack', 's', '2', '1', '1', '1', '0', '0', '5236', '1', '1', '1', '1', '1', 'default', '0', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('491012', 'pirate_cannon', 'Pirate Cannon', 's', '2', '1', '1', '1', '0', '0', '5222', '1', '1', '1', '1', '1', 'cannon', '0', '2', '0', '0', '0', '0', '0', '0', '0')
[Err] 1265 - Data truncated for column 'tab_colour' at row 1
[Err] INSERT INTO `permissions_rights` VALUES ('236', '9', '49');
-- ----------------------------
-- Table structure for `permissions_subscriptions`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_subscriptions`;
CREATE TABLE `permissions_subscriptions` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`subscription_id` int(10) NOT NULL,
`permission_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of permissions_subscriptions
-- ----------------------------
INSERT INTO `permissions_subscriptions` VALUES ('1', '1', '1');
INSERT INTO `permissions_subscriptions` VALUES ('2', '2', '2');
INSERT INTO `permissions_subscriptions` VALUES ('3', '3', '3');
-- ----------------------------
-- Table structure for `quests`
-- ----------------------------
DROP TABLE IF EXISTS `quests`;
CREATE TABLE `quests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(32) NOT NULL DEFAULT '',
`level_num` int(11) NOT NULL DEFAULT '0',
`goal_type` int(10) NOT NULL DEFAULT '0',
`goal_data` int(10) unsigned NOT NULL DEFAULT '0',
`action` varchar(32) NOT NULL DEFAULT '',
`pixel_reward` int(11) NOT NULL DEFAULT '10',
`data_bit` varchar(2) NOT NULL DEFAULT '',
`reward_type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`timestamp_unlock` int(11) NOT NULL DEFAULT '0',
`timestamp_lock` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of quests
-- ----------------------------
INSERT INTO `quests` VALUES ('2', 'identity', '1', '14', '1', 'CHANGEFIGURE', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('3', 'social', '2', '9', '1', 'CHATWITHSOMEONE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('6', 'social', '5', '12', '1', 'DANCE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('15', 'social', '1', '8', '1', 'ENTEROTHERSROOM', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('17', 'identity', '2', '15', '1', 'CHANGEMOTTO', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('101', 'room_builder', '1', '0', '3', 'MOVEITEM', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('104', 'explore', '1', '17', '1936', 'FINDLIFEGUARDTOWER', '10', '_2', '0', '0', '0');
INSERT INTO `quests` VALUES ('105', 'room_builder', '2', '1', '3', 'ROTATEITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('106', 'room_builder', '3', '2', '1', 'PLACEITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('107', 'room_builder', '4', '3', '1', 'PICKUPITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('108', 'room_builder', '5', '4', '2', 'SWITCHSTATE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('109', 'room_builder', '6', '5', '1', 'STACKITEM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('110', 'room_builder', '7', '6', '1', 'PLACEFLOOR', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('111', 'room_builder', '8', '7', '1', 'PLACEWALLPAPER', '10', '_1', '0', '0', '0');
INSERT INTO `quests` VALUES ('113', 'identity', '3', '16', '1', 'WEARBADGE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('115', 'social', '3', '10', '1', 'REQUESTFRIEND', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('116', 'social', '4', '11', '1', 'GIVERESPECT', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('118', 'social', '6', '13', '1', 'WAVE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('119', 'explore', '2', '17', '1948', 'SWIM', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('120', 'explore', '3', '17', '1969', 'FINDSURFBOARD', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('121', 'explore', '4', '17', '1956', 'FINDBEETLE', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('122', 'explore', '5', '17', '1369', 'FINDNEONFLOOR', '10', '', '0', '0', '0');
INSERT INTO `quests` VALUES ('123', 'explore', '6', '17', '1375', 'FINDDISCOBALL', '10', '', '0', '0',
[Err] 1146 - Table 'retro.room_chat_styles' doesn't exist
[Err] INSERT INTO `room_chat_styles` VALUES ('18', '', '');
INSERT INTO `room_chat_styles` VALUES ('19', 'piglet', '');
INSERT INTO `room_chat_styles` VALUES ('20', 'sausagedog', '');
INSERT INTO `room_chat_styles` VALUES ('21', 'firingmylazer', '');
INSERT INTO `room_chat_styles` VALUES ('22', 'dragon', '');
INSERT INTO `room_chat_styles` VALUES ('23', 'staff', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('24', 'bats', '');
INSERT INTO `room_chat_styles` VALUES ('25', 'console', '');
INSERT INTO `room_chat_styles` VALUES ('26', '', '');
INSERT INTO `room_chat_styles` VALUES ('27', 'storm', '');
INSERT INTO `room_chat_styles` VALUES ('28', 'parrot', '');
INSERT INTO `room_chat_styles` VALUES ('29', 'pirate', '');
INSERT INTO `room_chat_styles` VALUES ('30', 'bot_guide', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('31', 'bot_rentable', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('32', 'skelestock', '');
INSERT INTO `room_chat_styles` VALUES ('33', 'bot_frank', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('34', 'notification', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('35', 'goat', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('36', 'santa', 'mod_tool');
INSERT INTO `room_chat_styles` VALUES ('37', '', 'mod_tool');
-- ----------------------------
-- Table structure for `room_filter`
-- ----------------------------
DROP TABLE IF EXISTS `room_filter`;
CREATE TABLE `room_filter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(15) NOT NULL DEFAULT '',
`room_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `room_id` (`room_id`),
KEY `word` (`word`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_filter
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_moodlight`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_moodlight`;
CREATE TABLE `room_items_moodlight` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(10) unsigned NOT NULL,
`enabled` enum('0','1') NOT NULL DEFAULT '0',
`current_preset` int(11) NOT NULL,
`preset_one` text NOT NULL,
`preset_two` text NOT NULL,
`preset_three` text NOT NULL,
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_items_moodlight
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_tele_links`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_tele_links`;
CREATE TABLE `room_items_tele_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tele_one_id` int(10) unsigned NOT NULL,
`tele_two_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `tele_one_id` (`tele_one_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of room_items_tele_links
-- ----------------------------
-- ----------------------------
-- Table structure for `room_items_toner`
-- ----------------------------
DROP TABLE IF EXISTS `room_items_toner`;
CREATE TABLE `room_items_toner` (
`id` int(11) unsigned NOT NULL,
`enabled` enum('0','1') DEFAULT '0',
`data1` int(11) NOT NULL,
`data2` int(11) NOT NULL,
`data3` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of room_items_toner
-- ----------------------------
-- ----------------------------
-- Table structure for `room_models`
-- ----------------------------
DROP TABLE IF EXISTS `room_models`;
CREATE TABLE `room_models` (
`id` varchar(100) NOT NULL,
`door_x` int(11) NOT NULL,
`door_y` int(11) NOT NULL,
`door_z` double NOT NULL,
`door_dir` int(4) NOT NULL DEFAULT '2',
`heightmap` text NOT NULL,
`public_items` text NOT NULL,
`club_only` enum('0','1') NOT NULL DEFAULT '0',
`poolmap` varchar(100) NOT NULL DEFAU
[Err] 1146 - Table 'retro.server_settings' doesn't exist
[Err] INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.');
INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes');
INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes');
INSERT INTO `server_settings` VALUES ('user.login.message.enabled', '0', 'If this is enabled, a message from the server_locale table will be given to the user.');
-- ----------------------------
-- Table structure for `server_status`
-- ----------------------------
DROP TABLE IF EXISTS `server_status`;
CREATE TABLE `server_status` (
`users_online` int(11) NOT NULL DEFAULT '0',
`loaded_rooms` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `users_online` (`users_online`) USING BT
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of server_status
-- ----------------------------
INSERT INTO `server_status` VALUES ('0', '0');
-- ----------------------------
-- Table structure for `subscriptions`
-- ----------------------------
DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions` (
`id` int(10) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
`badge_code` varchar(10) NOT NULL,
`credits` int(11) NOT NULL DEFAULT '100',
`duckets` int(11) NOT NULL DEFAULT '100',
`respects` int(11) NOT NULL DEFAULT '3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of subscriptions
-- ----------------------------
INSERT INTO `subscriptions` VALUES ('1', 'Silver VIP', 'SVIP', '200', '150', '15');
INSERT INTO `subscriptions` VALUES ('2', 'Gold VIP', 'GVIP', '300', '200', '20');
INSERT INTO `subscriptions` VALUES ('3', 'Events Staff', 'EVENT', '500', '250', '20');
-- ----------------------------
-- Table structure for `talents`
-- ----------------------------
DROP TABLE IF EXISTS `talents`;
CREATE TABLE `talents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` enum('citizenship','helper') NOT NULL,
`level` int(11) DEFAULT '0',
`data_actions` text NOT NULL,
`data_gifts` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of talents
-- ----------------------------
INSERT INTO `talents` VALUES ('1', 'citizenship', '0', '', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('2', 'citizenship', '1', '', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('3', 'citizenship', '2', 'TRADE', 'A1 KUMIANKKA');
INSERT INTO `talents` VALUES ('4', 'citizenship', '3', 'CITIZEN', 'A1 KUMIANKKA|pixel_walldeco');
-- ----------------------------
-- Table structure for `talents_sub_levels`
-- ----------------------------
DROP TABLE IF EXISTS `talents_sub_levels`;
CREATE TABLE `talents_sub_levels` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`talent_level` int(11) NOT NULL DEFAULT '0',
`sub_level` int(11) NOT NULL DEFAULT '0',
`badge_code` varchar(45) NOT NULL DEFAULT '',
`required_progress` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of talents_sub_levels
-- ----------------------------
INSERT INTO `talents_sub_levels` VALUES ('1', '0', '1', 'ACH_SafetyQuizGraduate1', '1');
INSERT INTO `talents_sub_levels` VALUES ('2', '1', '1', 'ACH_AvatarLooks1', '1');
INSERT INTO `talents_sub_levels` VALUES ('3', '1', '2', 'ACH_RespectGiven1', '2');
INSERT INTO `talents_sub_levels` VALUES ('4', '1', '3', 'ACH_AllTimeHotelPresence1', '60');
INSERT INTO `talents_sub_levels` VALUES
[Msg] Finished - Unsuccessfully
--------------------------------------------------
