CREATE TABLE IF NOT EXISTS `achievements` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(100) NOT NULL DEFAULT '',
`levels` int(11) NOT NULL DEFAULT '1',
`dynamic_badgelevel` enum('0','1') NOT NULL DEFAULT '1',
`badge` varchar(100) NOT NULL,
`pixels_base` int(5) NOT NULL DEFAULT '50',
`score_base` int(5) NOT NULL DEFAULT '10',
`pixels_multiplier` double NOT NULL DEFAULT '1.25',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=40 ;
--
-- Dump dei dati per la tabella `achievements`
--
INSERT INTO `achievements` (`id`, `type`, `levels`, `dynamic_badgelevel`, `badge`, `pixels_base`, `score_base`, `pixels_multiplier`) VALUES
(1, 'identity', 1, '0', 'ACH_AvatarLooks1', 50, 10, 0.5),
(2, 'identity', 1, '0', 'ACH_EmailVerification1', 2500, 10, 0.5),
(3, 'identity', 1, '0', 'ACH_Graduate1', 50, 10, 0.5),
(4, 'identity', 1, '0', 'ACH_HappyHour1', 50, 10, 0.5),
(5, 'identity', 1, '0', 'ACH_Motto1', 100, 10, 0.5),
(6, 'identity', 1, '0', 'ACH_Student1', 50, 10, 0.5),
(7, 'identity', 1, '0', 'ACH_AvatarTags1', 50, 10, 0.5),
(8, 'social', 1, '0', 'ACH_RespectGiven1', 50, 10, 0.5),
(9, 'identity', 1, '0', 'ACH_Name1', 50, 10, 0.5),
(10, 'identity', 10, '1', 'ACH_RegistrationDuration', 50, 10, 0.5),
(11, 'identity', 10, '1', 'ACH_Login', 50, 10, 0.5),
(13, 'explore', 10, '1', 'ACH_RoomEntry', 5, 10, 0.5),
(14, 'social', 10, '1', 'ACH_RespectEarned', 50, 10, 0.5),
(15, 'social', 10, '1', 'ACH_MGM', 50, 10, 0.5),
(16, 'identity', 10, '1', 'ACH_AllTimeHotelPresence', 50, 10, 0.5),
(17, 'identity', 1, '0', 'ACH_TraderPass', 50, 10, 0.5),
(18, 'identity', 1, '0', 'ACH_AIPerformanceVote', 50, 10, 0.5),
(19, 'pets', 10, '1', 'ACH_PetFeeding', 50, 10, 0.5),
(20, 'pets', 10, '1', 'ACH_PetLevelUp', 50, 10, 0.5),
(21, 'pets', 10, '1', 'ACH_PetLover', 50, 10, 0.5),
(22, 'pets', 10, '1', 'ACH_PetRespectGiver', 50, 10, 0.5),
(23, 'pets', 10, '1', 'ACH_PetRespectReceiver', 50, 10, 0.5),
(24, 'social', 10, '1', 'ACH_GiftGiver', 50, 10, 0.5),
(25, 'social', 10, '1', 'ACH_GiftReceiver', 50, 10, 0.5),
(26, 'identity', 5, '1', 'ACH_BasicClub', 50, 10, 0.5),
(27, 'identity', 5, '1', 'ACH_VipClub', 50, 10, 0.5),
(28, 'games', 20, '1', 'ACH_BattleBallTilesLocked', 50, 10, 0.5),
(29, 'games', 20, '1', 'ACH_GamePlayerExperience', 50, 10, 0.5),
(30, 'games', 20, '1', 'ACH_GameAuthorExperience', 50, 10, 0.5),
(31, 'identity', 1, '0', 'Z64', 50, 10, 0.5),
(32, 'identity', 1, '0', 'XXX', 0, 10, 0.5),
(33, 'identity', 1, '0', 'RLX01', 200, 10, 0.5),
(34, 'identity', 1, '0', 'AC5', 200, 10, 0.5),
(35, 'identity', 1, '0', 'IT5', 200, 10, 0.5),
(36, 'identity', 1, '0', 'ACH_Forum1', 50, 10, 0.5),
(37, 'identity', 1, '0', 'RU3', 200, 10, 0.5),
(38, 'identity', 1, '0', 'VA2', 200, 10, 0.5),
(39, 'identity', 1, '0', 'EGG15', 200, 10, 0.5);