Code:
[Err] 1062 - Duplicate entry '1' for key 'PRIMARY'[Err] -- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 11-09-2014 a las 19:18:48
-- Versión del servidor: 5.1.41
-- Versión de PHP: 5.3.1
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 datos: `mercury_english`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `achievements`
--
CREATE TABLE IF NOT EXISTS `achievements` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_name` varchar(64) NOT NULL DEFAULT 'ACH_',
`category` enum('identity','explore','music','social','games','room_builder','pets') NOT NULL DEFAULT 'identity',
`level` int(11) NOT NULL DEFAULT '1',
`reward_pixels` int(11) NOT NULL DEFAULT '100',
`reward_points` int(11) DEFAULT '10',
`progress_needed` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=295 ;
--
-- Volcar la base de datos para la tabla `achievements`
--
INSERT INTO `achievements` (`id`, `group_name`, `category`, `level`, `reward_pixels`, `reward_points`, `progress_needed`) VALUES
(1, 'ACH_AvatarTags', 'identity', 1, 5, 5, 5),
(2, 'ACH_AvatarLooks', 'identity', 1, 5, 5, 1),
(3, 'ACH_Motto', 'identity', 1, 10, 10, 1),
(4, 'ACH_EmailVerification', 'identity', 1, 20, 20, 1),
(5, 'ACH_RespectGiven', 'social', 1, 100, 100, 2),
(6, 'ACH_BasicClub', 'identity', 1, 25, 25, 1),
(7, 'ACH_VipHC', 'identity', 1, 50, 50, 1),
(8, 'ACH_BasicClub', 'identity', 2, 100, 100, 2),
(9, 'ACH_BasicClub', 'identity', 3, 250, 250, 3),
(10, 'ACH_BasicClub', 'identity', 4, 350, 350, 4),
(11, 'ACH_BasicClub', 'identity', 5, 500, 500, 5),
(12, 'ACH_VipHC', 'identity', 2, 200, 200, 2),
(13, 'ACH_VipHC', 'identity', 3, 500, 500, 3),
(14, 'ACH_VipHC', 'identity', 4, 700, 700, 4),
(15, 'ACH_VipHC', 'identity', 5, 1000, 1000, 5),
(16, 'ACH_RespectEarned', 'social', 1, 5, 5, 1),
(17, 'ACH_RespectEarned', 'social', 2, 20, 20, 10),
(18, 'ACH_RespectEarned', 'social', 3, 40, 40, 20),
(19, 'ACH_RespectEarned', 'social', 4, 100, 100, 50),
(20, 'ACH_RespectEarned', 'social', 5, 200, 200, 100),
(21, 'ACH_RespectEarned', 'social', 6, 500, 500, 250),
(22, 'ACH_RespectEarned', 'social', 7, 1000, 1000, 500),
(23, 'ACH_RespectEarned', 'social', 8, 1300, 1300, 750),
(24, 'ACH_RespectEarned', 'social', 9, 2000, 2000, 1000),
(25, 'ACH_RespectEarned', 'social', 10, 3000, 3000, 1500),
(26, 'ACH_RoomEntry', 'explore', 1, 20, 10, 5),
(27, 'ACH_RoomEntry', 'explore', 2, 20, 10, 20),
(28, 'ACH_RoomEntry', 'explore', 3, 25, 10, 20),
(29, 'ACH_RoomEntry', 'explore', 4, 30, 15, 30),
(30, 'ACH_RoomEntry', 'explore', 5, 30, 20, 30),
(31, 'ACH_RoomEntry', 'explore', 6, 60, 25, 60),
(32, 'ACH_RoomEntry', 'explore', 7, 80, 25, 75),
(33, 'ACH_RoomEntry', 'explore', 8, 80, 30, 100),
(34, 'ACH_RoomEntry', 'explore', 9, 80, 30, 120),
(35, 'ACH_RoomEntry', 'explore', 10, 85, 30, 150),
(36, 'ACH_PinataWhacker', 'explore', 1, 100, 10, 1),
(37, 'ACH_PinataWhacker', 'explore', 2, 100, 20, 24),
(38, 'ACH_PinataWhacker', 'explore', 3, 120, 30, 25),
(39, 'ACH_PinataWhacker', 'explore', 4, 130, 40, 25),
(40, 'ACH_PinataWhacker', 'explore', 5, 140, 50, 35),
(41, 'ACH_PinataWhacker', 'explore', 6, 150, 60, 45),
(42, 'ACH_PinataWhacker', 'explore', 7, 150, 60, 60),
(43, 'ACH_PinataWhacker', 'explore', 8, 150, 60, 60),
(44, 'ACH_PinataWhacker', 'explore', 9, 150, 60, 75),
(45, 'ACH_PinataWhacker', 'explore', 10, 150, 60, 75),
(46, 'ACH_PinataBreaker', 'explore', 1, 120, 50, 1),
(47, 'ACH_PinataBreaker', 'explore', 2, 120, 50, 1),
(48, 'ACH_PinataBreaker', 'explore', 3, 120, 50, 1),
(49, 'ACH_PinataBreaker', 'explore', 4, 120, 50, 2),
(50, 'ACH_PinataBreaker', 'explore', 5, 120, 50, 2),
(51, 'ACH_SafetyQuizGraduate', 'identity', 1, 100, 250, 1),
(52, 'ACH_RegistrationDuration', 'identity', 1, 100, 10, 1),
(53, 'ACH_RegistrationDuration', 'identity'
[Err] 1062 - Duplicate entry '1257' for key 'PRIMARY'
[Err] INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_loyalty`, `cost_duckets`, `amounts`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `club_only`, `extradata`, `badge`) VALUES
(1257, 30, '628', 'a2 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1258, 30, '629', 'a3 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1259, 30, '630', 'a4 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1260, 30, '631', 'a5 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1261, 30, '632', 'a6 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1262, 30, '633', 'a7 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1263, 30, '634', 'a8 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1264, 30, '635', 'a9 norkg', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1265, 30, '636', 'a2 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1266, 30, '637', 'a3 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1267, 30, '638', 'a4 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1268, 30, '639', 'a5 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1269, 30, '640', 'a6 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1270, 30, '641', 'a7 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1271, 30, '642', 'a8 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1272, 30, '643', 'a9 nordiv', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1273, 30, '671', 'a2 DVN black', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1274, 30, '672', 'a3 DVN white', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1275, 30, '673', 'a5 DVN pink', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1276, 30, '674', 'a6 DVN blue', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1277, 30, '675', 'a7 DVN green', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1278, 30, '676', 'a8 DVN yellow', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1279, 30, '677', 'a9 DVN red', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1280, 30, '678', 'a2 FLIPnor black', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1281, 30, '679', 'a3 FLIPnor white', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1282, 30, '680', 'a4 FLIPnor aquamarine', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1283, 30, '681', 'a5 FLIPnor pink', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1284, 30, '682', 'a7 FLIPnor green', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1285, 30, '683', 'a8 FLIPnor yellow', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1286, 30, '684', 'a9 FLIPnor red', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1287, 30, '685', 'a0 FLIPnor plain', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1288, 30, '686', 'a0 DVN plain', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1289, 68, '223', 'typingmachine', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1290, 13, '226', 'joulutahti', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1291, 68, '227', 'A2 HYASINTTIP', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1292, 68, '228', 'A2 HYASINTTIS', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(5620, 58, '4866', 'diner_bardesk_gate*10', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1294, 5, '237', 'mocchamaster', 25, 0, 0, 0, '1', 0, 0, 0, 0, '1', '1', '', ''),
(1295, 26, '1759', 'poster 502', 3, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1296, 13, '263', 'tree1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1297, 13, '264', 'wcandle', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1298, 13, '266', 'house2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1299, 115, '268', 'md_limukaappi', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1300, 15, '287', 'DEV doorD', 25, 0, 0, 0, '1', 0, 0, 0, 0, '1', '1', '', ''),
(1301, 103, '357', 'a7 pillow', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1302, 103, '358', 'a10 pillow', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(1303, 103, '359', 'a0 pillow', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(13
[Err] 1062 - Duplicate entry '3747' for key 'PRIMARY'
[Err] INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_loyalty`, `cost_duckets`, `amounts`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `club_only`, `extradata`, `badge`) VALUES
(3747, 18, '4398', 'eleblock5', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3748, 18, '4399', 'eleblock3', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3749, 18, '4400', 'eleblock1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3750, 18, '4401', 'pura_roundpad1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3751, 18, '4402', 'pura_roundpad2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3752, 18, '4403', 'eleblock8', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3753, 18, '4404', 'pura_roundpad5', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3754, 18, '4405', 'eleblock9', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3755, 18, '4406', 'pura_roundpad7', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3756, 18, '4407', 'eleblock6', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3757, 54, '4409', 'prizetrophy_hween11', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3758, 40, '4410', 'hween11_disflo2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3759, 40, '4411', 'hween11_punch', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3760, 40, '4412', 'hween11_dish2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3761, 40, '4413', 'hween11_pumpkin', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3762, 40, '4414', 'hween11_sofa', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3763, 40, '4415', 'hween11_dish3', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3764, 40, '4416', 'hween11_dish4', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3765, 40, '4417', 'hween11_disflo', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3766, 40, '4418', 'hween11_dish1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3767, 40, '4419', 'lm_pumpkin', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3768, 7, '3384', 'hole', 8, 0, 0, 0, '1', 0, 0, 0, 0, '1', '1', '', ''),
(5492, 106, '4863', 'holo_nelly', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3770, 143, '71000670', 'horse_poop_luxus', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3771, 115, '71000672', 'ads_liisu', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3772, 13, '71000677', 'xmas11_sofatable', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3773, 13, '71000678', 'xmas11_comfy_chair', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3774, 13, '71000679', 'xmas2011_aurora1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3775, 13, '71000680', 'xmas11_stonedivider', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3776, 13, '71000681', 'xmas11_yetifeet', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3777, 13, '71000682', 'xmas2011_tree2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3778, 13, '71000683', 'xmas11_woodfloor', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3779, 13, '71000684', 'xmas11_footstool', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3780, 13, '71000685', 'xmas11_flag', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3781, 13, '71000686', 'xmas2011_tree1', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3782, 13, '71000687', 'xmas11_firewood', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3783, 13, '71000688', 'xmas11_stool', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3784, 13, '71000689', 'xmas11_stove', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3785, 13, '71000690', 'xmas2011_snowlog', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3786, 13, '71000691', 'xmas11_stonefloor', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3787, 13, '71000692', 'xmas11_comfy_bench', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3788, 13, '71000693', 'xmas2011_icefall', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3789, 13, '71000694', 'xmas11_petfood', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3790, 13, '71000695', 'xmas2011_aurora2', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '', ''),
(3791, 13, '71000696
[Err] 1062 - Duplicate entry '714' for key 'PRIMARY'
[Err] INSERT INTO `furniture` (`id`, `flat_id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `stack_multiplier`, `subscriber`, `effectid`) VALUES
(714, -1, 'Glass Table', 'glass_table*6', 's', 2, 2, '1', '1', '0', '0', 2028, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(715, -1, 'Glass Table', 'glass_table*7', 's', 2, 2, '1', '1', '0', '0', 2029, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(716, -1, 'Glass Table', 'glass_table*8', 's', 2, 2, '1', '1', '0', '0', 2030, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(717, -1, 'Glass Table', 'glass_table*9', 's', 2, 2, '1', '1', '0', '0', 2031, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(718, -1, 'Glass Chair', 'glass_chair*2', 's', 1, 1, '1', '0', '1', '0', 2032, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(719, -1, 'Glass Chair', 'glass_chair*3', 's', 1, 1, '1', '0', '1', '0', 2033, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(720, -1, 'Glass Chair', 'glass_chair*4', 's', 1, 1, '1', '0', '1', '0', 2034, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(721, -1, 'Glass Chair', 'glass_chair*5', 's', 1, 1, '1', '0', '1', '0', 2035, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(722, -1, 'Glass Chair', 'glass_chair*6', 's', 1, 1, '1', '0', '1', '0', 2036, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(723, -1, 'Glass Chair', 'glass_chair*7', 's', 1, 1, '1', '0', '1', '0', 2037, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(724, -1, 'Glass Chair', 'glass_chair*8', 's', 1, 1, '1', '0', '1', '0', 2038, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(725, -1, 'Glass Chair', 'glass_chair*9', 's', 1, 1, '1', '0', '1', '0', 2039, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(726, -1, 'Glass Sofa', 'glass_sofa*2', 's', 2, 1, '1', '0', '1', '0', 2040, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(727, -1, 'Glass Sofa', 'glass_sofa*3', 's', 2, 1, '1', '0', '1', '0', 2041, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(728, -1, 'Glass Sofa', 'glass_sofa*4', 's', 2, 1, '1', '0', '1', '0', 2042, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(729, -1, 'Glass Sofa', 'glass_sofa*5', 's', 2, 1, '1', '0', '1', '0', 2043, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(730, -1, 'Glass Sofa', 'glass_sofa*6', 's', 2, 1, '1', '0', '1', '0', 2044, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(731, -1, 'Glass Sofa', 'glass_sofa*7', 's', 2, 1, '1', '0', '1', '0', 2045, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(732, -1, 'Glass Sofa', 'glass_sofa*8', 's', 2, 1, '1', '0', '1', '0', 2046, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(733, -1, 'Glass Sofa', 'glass_sofa*9', 's', 2, 1, '1', '0', '1', '0', 2047, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(734, -1, 'Glass Stool', 'glass_stool*2', 's', 1, 1, '1', '0', '1', '0', 2048, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(735, -1, 'Glass Stool', 'glass_stool*4', 's', 1, 1, '1', '0', '1', '0', 2050, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(736, -1, 'Glass Stool', 'glass_stool*5', 's', 1, 1, '1', '0', '1', '0', 2051, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(737, -1, 'Glass Stool', 'glass_stool*6', 's', 1, 1, '1', '0', '1', '0', 2052, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(738, -1, 'Glass Stool', 'glass_stool*7', 's', 1, 1, '1', '0', '1', '0', 2053, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(739, -1, 'Glass Stool', 'glass_stool*8', 's', 1, 1, '1', '0', '1', '0', 2054, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(740, -1, 'Glass Stool', 'glass_stool*3', 's', 1, 1, '1', '0', '1', '0', 2056, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(741, -1, 'Glass Stool', 'glas
[Err] 1062 - Duplicate entry '5721' for key 'PRIMARY'
[Err] INSERT INTO `furniture` (`id`, `flat_id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `stack_multiplier`, `subscriber`, `effectid`) VALUES
(5721, -1, 'bc_tile_9 name', 'bc_tile*9', 's', 1, 1, '1.0', '1', '0', '0', 5786, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5720, -1, 'bc_tile_8 name', 'bc_tile*8', 's', 1, 1, '1.0', '1', '0', '0', 5785, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5719, -1, 'bc_tile_7 name', 'bc_tile*7', 's', 1, 1, '1.0', '1', '0', '0', 5784, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5718, -1, 'bc_tile_6 name', 'bc_tile*6', 's', 1, 1, '1.0', '1', '0', '0', 5783, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5717, -1, 'bc_tile_5 name', 'bc_tile*5', 's', 1, 1, '1.0', '1', '0', '0', 5782, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5716, -1, 'bc_tile_4 name', 'bc_tile*4', 's', 1, 1, '1.0', '1', '0', '0', 5781, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5715, -1, 'bc_tile_3 name', 'bc_tile*3', 's', 1, 1, '1.0', '1', '0', '0', 5780, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5714, -1, 'bc_tile_2 name', 'bc_tile*2', 's', 1, 1, '1.0', '1', '0', '0', 5779, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5713, -1, 'bc_tile_1 name', 'bc_tile*1', 's', 1, 1, '1.0', '1', '0', '0', 5773, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5712, -1, 'bc_terra_14 name', 'bc_terra*14', 's', 1, 1, '1.0', '1', '0', '0', 5792, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5711, -1, 'bc_terra_13 name', 'bc_terra*13', 's', 1, 1, '1.0', '1', '0', '0', 5791, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(3357, -1, 'Ice Cream Trolley', 'qt_sum11_ictrolley', 's', 1, 1, '1', '0', '0', '0', 4018, '0', '1', '0', '1', '1', 'vendingmachine', 2, '4', '0', '0', 0),
(3358, -1, 'Pier', 'qt_sum11_platfrm', 's', 2, 2, '1', '1', '0', '1', 4022, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0),
(3359, -1, 'Blistering Barnacle', 'qt_sum11_shell3', 's', 1, 1, '1', '0', '0', '0', 4021, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0),
(3360, -1, 'Star Fish', 'qt_sum11_shell2', 's', 1, 1, '1', '0', '0', '0', 4023, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0),
(3361, -1, 'Rare Sea Throne', 'qt_sum11_chair', 's', 1, 1, '1', '0', '1', '0', 4025, '0', '1', '0', '1', '1', 'default', 4, '0', '0', '0', 0),
(3362, -1, 'Sea Shell', 'qt_sum11_shell4', 's', 1, 1, '1', '1', '0', '0', 4020, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(3363, -1, 'Clam Shell', 'qt_sum11_shell1', 's', 1, 1, '1', '0', '0', '0', 4017, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(3364, -1, 'Trumpet Shell', 'qt_sum11_shell5', 's', 1, 1, '1', '0', '0', '0', 4024, '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', 0),
(3365, -1, 'Catch of the Day', 'qt_sum11_petfood', 's', 1, 1, '0', '0', '0', '1', 4019, '0', '1', '0', '1', '1', 'petfood', 1, '0', '0', '0', 0),
(5710, -1, 'bc_terra_12 name', 'bc_terra*12', 's', 1, 1, '1.0', '1', '0', '0', 5790, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5709, -1, 'bc_terra_11 name', 'bc_terra*11', 's', 1, 1, '1.0', '1', '0', '0', 5789, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5708, -1, 'bc_terra_10 name', 'bc_terra*10', 's', 1, 1, '1.0', '1', '0', '0', 5788, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(5707, -1, 'bc_terra_9 name', 'bc_terra*9', 's', 1, 1, '1.0', '1', '0', '0', 5800, '1', '1', '1', '1', '1', 'default', 1, '', '0', '0', 0),
(3384, 10255, 'Black Hole', 'hole', 's', 2, 2, '1', '1', '0', '0', 4071, '0', '0', '0', '0', '1', 'default', 1, '0', '0', '0', 0),
(3386, -1, 'Savannah landscape', 'anc_savanna_wall', 'i', 0, 0, '0.1', '1', '0', '0', 4461, '0', '1', '0', '1', '1', 'default', 2, '0', '0', '0', 0),
(3387, -1, 'ads_hh_safe name', 'ads_hh_safe', 's', 1, 1,
[Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
[Err] --
-- Volcar la base de datos para la tabla `messenger_offline_messages`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `messenger_requests`
--
CREATE TABLE IF NOT EXISTS `messenger_requests` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`from_id` int(10) unsigned NOT NULL,
`to_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING BTREE,
KEY `to_id` (`to_id`) USING BTREE,
KEY `from_id` (`from_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `messenger_requests`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `moderation_presets`
--
CREATE TABLE IF NOT EXISTS `moderation_presets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`type` enum('message','roommessage') NOT NULL DEFAULT 'message',
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `moderation_presets`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `moderation_templates`
--
CREATE TABLE IF NOT EXISTS `moderation_templates` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`category` smallint(11) NOT NULL DEFAULT '-1',
`caption` varchar(255) NOT NULL DEFAULT 'Sexually Explicit',
`warning_message` text NOT NULL,
`ban_message` text NOT NULL,
`ban_hours` smallint(5) NOT NULL DEFAULT '24',
`avatar_ban` enum('0','1') NOT NULL DEFAULT '0',
`mute` enum('0','1') NOT NULL DEFAULT '0',
`trade_lock` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Volcar la base de datos para la tabla `moderation_templates`
--
INSERT INTO `moderation_templates` (`id`, `category`, `caption`, `warning_message`, `ban_message`, `ban_hours`, `avatar_ban`, `mute`, `trade_lock`) VALUES
(1, -1, 'Sex', '', '', 24, '0', '0', '0'),
(2, -1, 'Scammers', '', '', 24, '0', '0', '0'),
(3, 1, 'Cybersex ban', 'This bans due to cybersex.', 'You were banned! Cybersex is not allowed', 8, '0', '0', '0'),
(4, 1, 'Sexual language (Mute)', 'Use this for mute because of sexual language.', 'You were muted. Sorry, but sexual language is not allowed in the hotel.', 0, '0', '1', '0'),
(5, 2, 'Lock trading for 24 hours', 'Use this to lock trading for 24 hours.', 'Sorry but you won''t trade during the next 24 hours. You were scamming.', 24, '0', '0', '1');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `moderation_tickethints`
--
CREATE TABLE IF NOT EXISTS `moderation_tickethints` (
`word` varchar(255) NOT NULL,
`hint` varchar(255) NOT NULL,
PRIMARY KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Volcar la base de datos para la tabla `moderation_tickethints`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `moderation_tickets`
--
CREATE TABLE IF NOT EXISTS `moderation_tickets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`score` int(11) NOT NULL,
`type` int(11) NOT NULL,
`status` enum('open','picked','resolved','abusive','invalid','deleted') NOT NULL DEFAULT 'open',
`sender_id` int(10) unsigned NOT NULL,
`reported_id` int(10) unsigned NOT NULL,
`moderator_id` int(10) unsigned NOT NULL,
`message` text NOT NULL,
`room_id` int(10) unsigned NOT NULL,
`room_name` varchar(100) NOT NULL,
`timestamp` double NOT NULL,
PRIMARY KEY (`id`),
KEY `status` (`status`) USING BTREE,
KEY `sender_id` (`sender_id`) USING BTREE,
KEY `reported_id` (`reported_id`) USING BTREE,
KEY `moderator_id` (`moderator_id`) USING BTREE,
KEY `room_id` (`room_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Volcar la base de datos para la tabla `moderation_tickets`
--
-- ----------------------
[Msg] Finished - Unsuccessfully
--------------------------------------------------
