F2QcqqeX

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for achievement_proto
5-- ----------------------------
6DROP TABLE IF EXISTS `achievement_proto`;
7CREATE TABLE `achievement_proto` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `name` varchar(255) NOT NULL,
10  `point_min` int(11) NOT NULL DEFAULT '0',
11  `point_max` int(11) NOT NULL DEFAULT '0',
12  `predecessor` int(11) NOT NULL DEFAULT '0',
13  `progress_flag` varchar(255) NOT NULL DEFAULT '',
14  `goal` int(11) NOT NULL DEFAULT '1',
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;
17
18-- ----------------------------
19-- Records of achievement_proto
20-- ----------------------------
21INSERT INTO `achievement_proto` VALUES ('1', 'achievement_exp_greedy_1', '0', '0', '0', 'achievement_exp_greedy', '30');
22INSERT INTO `achievement_proto` VALUES ('2', 'achievement_exp_greedy_2', '0', '0', '1', 'achievement_exp_greedy', '75');
23INSERT INTO `achievement_proto` VALUES ('3', 'achievement_exp_greedy_3', '0', '0', '2', 'achievement_exp_greedy', '100');
24INSERT INTO `achievement_proto` VALUES ('4', 'achievement_exp_greedy_4', '0', '0', '3', 'achievement_exp_greedy', '125');
25INSERT INTO `achievement_proto` VALUES ('5', 'achievement_exp_greedy_5', '0', '0', '4', 'achievement_exp_greedy', '145');
26INSERT INTO `achievement_proto` VALUES ('6', 'achievement_metin_collector_1', '0', '0', '0', 'achievement_metin_collector', '100');
27INSERT INTO `achievement_proto` VALUES ('7', 'achievement_metin_collector_2', '0', '0', '6', 'achievement_metin_collector', '1000');
28INSERT INTO `achievement_proto` VALUES ('8', 'achievement_metin_collector_3', '0', '0', '7', 'achievement_metin_collector', '10000');
29INSERT INTO `achievement_proto` VALUES ('9', 'achievement_metin_collector_4', '0', '0', '8', 'achievement_metin_collector', '25000');
30INSERT INTO `achievement_proto` VALUES ('10', 'achievement_metin_collector_5', '0', '0', '9', 'achievement_metin_collector', '50000');
31INSERT INTO `achievement_proto` VALUES ('11', 'achievement_boss_slayer_1', '0', '0', '0', 'achievement_boss_slayer', '50');
32INSERT INTO `achievement_proto` VALUES ('12', 'achievement_boss_slayer_2', '0', '0', '11', 'achievement_boss_slayer', '500');
33INSERT INTO `achievement_proto` VALUES ('13', 'achievement_boss_slayer_3', '0', '0', '12', 'achievement_boss_slayer', '5000');
34INSERT INTO `achievement_proto` VALUES ('14', 'achievement_boss_slayer_4', '0', '0', '13', 'achievement_boss_slayer', '10000');
35INSERT INTO `achievement_proto` VALUES ('15', 'achievement_boss_slayer_5', '0', '0', '14', 'achievement_boss_slayer', '25000');
36INSERT INTO `achievement_proto` VALUES ('16', 'achievement_potion_master_1', '0', '0', '0', 'achievement_potion_master', '10');
37INSERT INTO `achievement_proto` VALUES ('17', 'achievement_potion_master_2', '0', '0', '16', 'achievement_potion_master', '100');
38INSERT INTO `achievement_proto` VALUES ('18', 'achievement_potion_master_3', '0', '0', '17', 'achievement_potion_master', '1000');
39INSERT INTO `achievement_proto` VALUES ('19', 'achievement_potion_master_4', '0', '0', '18', 'achievement_potion_master', '5000');
40INSERT INTO `achievement_proto` VALUES ('20', 'achievement_potion_master_5', '0', '0', '19', 'achievement_potion_master', '10000');
41INSERT INTO `achievement_proto` VALUES ('21', 'achievement_miner_1', '0', '0', '0', 'achievement_miner', '1000');
42INSERT INTO `achievement_proto` VALUES ('22', 'achievement_miner_2', '0', '0', '21', 'achievement_miner', '10000');
43INSERT INTO `achievement_proto` VALUES ('23', 'achievement_miner_3', '0', '0', '22', 'achievement_miner', '25000');
44INSERT INTO `achievement_proto` VALUES ('24', 'achievement_miner_4', '0', '0', '23', 'achievement_miner', '50000');
45INSERT INTO `achievement_proto` VALUES ('25', 'achievement_miner_5', '0', '0', '24', 'achievement_miner', '100000');
46INSERT INTO `achievement_proto` VALUES ('26', 'achievement_alchemist_1', '0', '0', '0', 'achievement_alchemist', '10');
47INSERT INTO `achievement_proto` VALUES ('27', 'achievement_alchemist_2', '0', '0', '26', 'achievement_alchemist', '50');
48INSERT INTO `achievement_proto` VALUES ('28', 'achievement_alchemist_3', '0', '0', '27', 'achievement_alchemist', '100');
49INSERT INTO `achievement_proto` VALUES ('29', 'achievement_alchemist_4', '0', '0', '28', 'achievement_alchemist', '250');
50INSERT INTO `achievement_proto` VALUES ('30', 'achievement_alchemist_5', '0', '0', '29', 'achievement_alchemist', '500');
51INSERT INTO `achievement_proto` VALUES ('31', 'achievement_tamer_1', '0', '0', '0', 'achievement_tamer', '1');
52INSERT INTO `achievement_proto` VALUES ('32', 'achievement_tamer_2', '0', '0', '31', 'achievement_tamer', '11');
53INSERT INTO `achievement_proto` VALUES ('33', 'achievement_tamer_3', '0', '0', '32', 'achievement_tamer', '21');
54INSERT INTO `achievement_proto` VALUES ('34', 'achievement_tamer_4', '0', '0', '33', 'achievement_tamer', '31');
55INSERT INTO `achievement_proto` VALUES ('35', 'achievement_tamer_5', '0', '0', '34', 'achievement_tamer', '50');
56INSERT INTO `achievement_proto` VALUES ('36', 'achievement_serial_killer_1', '0', '0', '0', 'achievement_serial_killer', '10');
57INSERT INTO `achievement_proto` VALUES ('37', 'achievement_serial_killer_2', '0', '0', '36', 'achievement_serial_killer', '100');
58INSERT INTO `achievement_proto` VALUES ('38', 'achievement_serial_killer_3', '0', '0', '37', 'achievement_serial_killer', '1000');
59INSERT INTO `achievement_proto` VALUES ('39', 'achievement_serial_killer_4', '0', '0', '38', 'achievement_serial_killer', '5000');
60INSERT INTO `achievement_proto` VALUES ('40', 'achievement_serial_killer_5', '0', '0', '39', 'achievement_serial_killer', '10000');
61INSERT INTO `achievement_proto` VALUES ('41', 'achievement_war_veteran_1', '0', '0', '0', 'achievement_war_veteran', '1');
62INSERT INTO `achievement_proto` VALUES ('42', 'achievement_war_veteran_2', '0', '0', '41', 'achievement_war_veteran', '10');
63INSERT INTO `achievement_proto` VALUES ('43', 'achievement_war_veteran_3', '0', '0', '42', 'achievement_war_veteran', '25');
64INSERT INTO `achievement_proto` VALUES ('44', 'achievement_war_veteran_4', '0', '0', '43', 'achievement_war_veteran', '50');
65INSERT INTO `achievement_proto` VALUES ('45', 'achievement_war_veteran_5', '0', '0', '44', 'achievement_war_veteran', '100');
66INSERT INTO `achievement_proto` VALUES ('46', 'achievement_pet_tamer', '0', '0', '0', '', '1');
67INSERT INTO `achievement_proto` VALUES ('47', 'achievement_pet_bonus', '0', '0', '0', '', '1');
68INSERT INTO `achievement_proto` VALUES ('48', 'achievement_wwf_hater', '0', '0', '0', '', '1000');
69INSERT INTO `achievement_proto` VALUES ('49', 'achievement_orc_slayer', '0', '0', '0', '', '1000');
70INSERT INTO `achievement_proto` VALUES ('50', 'achievement_milgyo_slayer', '0', '0', '0', '', '1000');
71INSERT INTO `achievement_proto` VALUES ('51', 'achievement_zombie_slayer', '0', '0', '0', '', '1000');
72INSERT INTO `achievement_proto` VALUES ('52', 'achievement_devil_slayer', '0', '0', '0', '', '1000');
73INSERT INTO `achievement_proto` VALUES ('53', 'achievement_halfhuman_slayer', '0', '0', '0', '', '1000');
74INSERT INTO `achievement_proto` VALUES ('54', 'achievement_war_hero', '0', '0', '0', '', '1');
75INSERT INTO `achievement_proto` VALUES ('55', 'achievement_hwang', '0', '0', '0', '', '1');
76INSERT INTO `achievement_proto` VALUES ('56', 'achievement_water_hwang', '0', '0', '0', '', '1');
77INSERT INTO `achievement_proto` VALUES ('57', 'achievement_titan_armor', '0', '0', '0', '', '1');
78INSERT INTO `achievement_proto` VALUES ('58', 'achievement_imperial_dragon_armor', '0', '0', '0', '', '1');
79INSERT INTO `achievement_proto` VALUES ('59', 'achievement_elder_armor', '0', '0', '0', '', '1');
80INSERT INTO `achievement_proto` VALUES ('60', 'achievement_100_weapon', '0', '0', '0', '', '1');
81INSERT INTO `achievement_proto` VALUES ('61', 'achievement_115_weapon', '0', '0', '0', '', '1');
82INSERT INTO `achievement_proto` VALUES ('62', 'achievement_130_weapon', '0', '0', '0', '', '1');
83INSERT INTO `achievement_proto` VALUES ('63', 'achievement_imperial_set', '0', '0', '0', '', '1');
84INSERT INTO `achievement_proto` VALUES ('64', 'achievement_cosplayer', '0', '0', '0', '', '1');
85INSERT INTO `achievement_proto` VALUES ('65', 'achievement_emerald', '0', '0', '0', '', '1');
86INSERT INTO `achievement_proto` VALUES ('66', 'achievement_ruby', '0', '0', '0', '', '1');
87INSERT INTO `achievement_proto` VALUES ('67', 'achievement_zaphire', '0', '0', '0', '', '1');
88INSERT INTO `achievement_proto` VALUES ('68', 'achievement_coral', '0', '0', '0', '', '1');
89INSERT INTO `achievement_proto` VALUES ('69', 'achievement_hit_bonus_over_50', '0', '0', '0', '', '1');
90INSERT INTO `achievement_proto` VALUES ('70', 'achievement_ability_bonus_20', '0', '0', '0', '', '1');
91INSERT INTO `achievement_proto` VALUES ('71', 'achievement_gold_crystal_1', '0', '0', '0', 'achievement_gold_crystal', '5000');
92INSERT INTO `achievement_proto` VALUES ('72', 'achievement_gold_crystal_2', '0', '0', '0', 'achievement_gold_crystal', '50000');
93INSERT INTO `achievement_proto` VALUES ('73', 'achievement_earth_crystal_1', '0', '0', '0', 'achievement_earth_crystal', '5000');
94INSERT INTO `achievement_proto` VALUES ('74', 'achievement_earth_crystal_2', '0', '0', '0', 'achievement_earth_crystal', '50000');
95INSERT INTO `achievement_proto` VALUES ('75', 'achievement_air_crystal_1', '0', '0', '0', 'achievement_air_crystal', '5000');
96INSERT INTO `achievement_proto` VALUES ('76', 'achievement_air_crystal_2', '0', '0', '0', 'achievement_air_crystal', '50000');
97INSERT INTO `achievement_proto` VALUES ('77', 'achievement_fire_crystal_1', '0', '0', '0', 'achievement_fire_crystal', '5000');
98INSERT INTO `achievement_proto` VALUES ('78', 'achievement_fire_crystal_2', '0', '0', '0', 'achievement_fire_crystal', '50000');
99INSERT INTO `achievement_proto` VALUES ('79', 'achievement_water_crystal_1', '0', '0', '0', 'achievement_water_crystal', '5000');
100INSERT INTO `achievement_proto` VALUES ('80', 'achievement_water_crystal_2', '0', '0', '0', 'achievement_water_crystal', '50000');
101INSERT INTO `achievement_proto` VALUES ('81', 'achievement_earth_elemental_1', '0', '0', '0', 'achievement_earth_elemental', '10');
102INSERT INTO `achievement_proto` VALUES ('82', 'achievement_earth_elemental_2', '0', '0', '0', 'achievement_earth_elemental', '100');
103INSERT INTO `achievement_proto` VALUES ('83', 'achievement_air_elemental_1', '0', '0', '0', 'achievement_air_elemental', '10');
104INSERT INTO `achievement_proto` VALUES ('84', 'achievement_air_elemental_2', '0', '0', '0', 'achievement_air_elemental', '100');
105INSERT INTO `achievement_proto` VALUES ('85', 'achievement_fire_elemental_1', '0', '0', '0', 'achievement_fire_elemental', '10');
106INSERT INTO `achievement_proto` VALUES ('86', 'achievement_fire_elemental_2', '0', '0', '0', 'achievement_fire_elemental', '100');
107INSERT INTO `achievement_proto` VALUES ('87', 'achievement_water_elemental_1', '0', '0', '0', 'achievement_water_elemental', '10');
108INSERT INTO `achievement_proto` VALUES ('88', 'achievement_water_elemental_2', '0', '0', '0', 'achievement_water_elemental', '100');
109INSERT INTO `achievement_proto` VALUES ('89', 'achievement_zombie_god_slayer_1', '0', '0', '0', 'achievement_zombie_god_slayer', '1');
110INSERT INTO `achievement_proto` VALUES ('90', 'achievement_zombie_god_slayer_2', '0', '0', '0', 'achievement_zombie_god_slayer', '50');
111INSERT INTO `achievement_proto` VALUES ('91', 'achievement_zombie_god_slayer_3', '0', '0', '0', 'achievement_zombie_god_slayer', '100');
112INSERT INTO `achievement_proto` VALUES ('92', 'achievement_spider_king_slayer_1', '0', '0', '0', 'achievement_spider_king_slayer', '1');
113INSERT INTO `achievement_proto` VALUES ('93', 'achievement_spider_king_slayer_2', '0', '0', '0', 'achievement_spider_king_slayer', '50');
114INSERT INTO `achievement_proto` VALUES ('94', 'achievement_spider_king_slayer_3', '0', '0', '0', 'achievement_spider_king_slayer', '100');
115INSERT INTO `achievement_proto` VALUES ('95', 'achievement_ezreal_slayer_1', '0', '0', '0', 'achievement_ezreal_slayer', '1');
116INSERT INTO `achievement_proto` VALUES ('96', 'achievement_ezreal_slayer_2', '0', '0', '0', 'achievement_ezreal_slayer', '50');
117INSERT INTO `achievement_proto` VALUES ('97', 'achievement_ezreal_slayer_3', '0', '0', '0', 'achievement_ezreal_slayer', '100');
118INSERT INTO `achievement_proto` VALUES ('98', 'achievement_water_dragon_slayer_1', '0', '0', '0', 'achievement_water_dragon_slayer', '1');
119INSERT INTO `achievement_proto` VALUES ('99', 'achievement_water_dragon_slayer_2', '0', '0', '0', 'achievement_water_dragon_slayer', '50');
120INSERT INTO `achievement_proto` VALUES ('100', 'achievement_water_dragon_slayer_3', '0', '0', '0', 'achievement_water_dragon_slayer', '100');
121INSERT INTO `achievement_proto` VALUES ('101', 'achievement_razador_slayer_1', '0', '0', '0', 'achievement_razador_slayer', '1');
122INSERT INTO `achievement_proto` VALUES ('102', 'achievement_razador_slayer_2', '0', '0', '0', 'achievement_razador_slayer', '50');
123INSERT INTO `achievement_proto` VALUES ('103', 'achievement_razador_slayer_3', '0', '0', '0', 'achievement_razador_slayer', '100');
124INSERT INTO `achievement_proto` VALUES ('104', 'achievement_tower_express', '0', '0', '0', '', '1');
125INSERT INTO `achievement_proto` VALUES ('105', 'achievement_ascaria_express', '0', '0', '0', '', '1');
126INSERT INTO `achievement_proto` VALUES ('106', 'achievement_dark_fortress_express', '0', '0', '0', '', '1');
127INSERT INTO `achievement_proto` VALUES ('107', 'achievement_refine_low', '0', '0', '0', '', '1');
128INSERT INTO `achievement_proto` VALUES ('108', 'achievement_refine_medium', '0', '0', '0', '', '1');
129INSERT INTO `achievement_proto` VALUES ('109', 'achievement_refine_high', '0', '0', '0', '', '1');
130INSERT INTO `achievement_proto` VALUES ('110', 'achievement_refined_emerald', '0', '0', '0', '', '1');
131INSERT INTO `achievement_proto` VALUES ('111', 'achievement_refined_ruby', '0', '0', '0', '', '1');
132INSERT INTO `achievement_proto` VALUES ('112', 'achievement_refined_zaphire', '0', '0', '0', '', '1');
133INSERT INTO `achievement_proto` VALUES ('113', 'achievement_refined_coral', '0', '0', '0', '', '1');
134INSERT INTO `achievement_proto` VALUES ('114', 'achievement_hair_color', '0', '0', '0', '', '1');
135INSERT INTO `achievement_proto` VALUES ('115', 'achievement_sex_change', '0', '0', '0', '', '1');
136INSERT INTO `achievement_proto` VALUES ('116', 'achievement_job_change', '0', '0', '0', '', '1');
137INSERT INTO `achievement_proto` VALUES ('117', 'achievement_empire_change', '0', '0', '0', '', '1');
138INSERT INTO `achievement_proto` VALUES ('118', 'achievement_biology_master', '0', '0', '0', '', '1');
139INSERT INTO `achievement_proto` VALUES ('119', 'achievement_quest_story', '0', '0', '0', '', '1');
140INSERT INTO `achievement_proto` VALUES ('120', 'achievement_hunter_master', '0', '0', '0', '', '1');
141INSERT INTO `achievement_proto` VALUES ('121', 'achievement_marriage', '0', '0', '0', '', '1');
142INSERT INTO `achievement_proto` VALUES ('122', 'achievement_max_love_points', '0', '0', '0', '', '1');
143INSERT INTO `achievement_proto` VALUES ('123', 'achievement_marriage_brake', '0', '0', '0', '', '1');
144INSERT INTO `achievement_proto` VALUES ('124', 'achievement_horse_100_min', '0', '0', '0', '', '1');
145INSERT INTO `achievement_proto` VALUES ('125', 'achievement_horse_liv_21', '0', '0', '0', '', '1');
146INSERT INTO `achievement_proto` VALUES ('126', 'achievement_dark_mount', '0', '0', '0', '', '1');
147INSERT INTO `achievement_proto` VALUES ('127', 'achievement_ox_attender', '0', '0', '0', '', '1');
148INSERT INTO `achievement_proto` VALUES ('128', 'achievement_offline_shop', '0', '0', '0', '', '1');
149INSERT INTO `achievement_proto` VALUES ('129', 'achievement_reinforce_object_1', '0', '0', '0', 'achievement_reinforce_object', '1');
150INSERT INTO `achievement_proto` VALUES ('130', 'achievement_reinforce_object_2', '0', '0', '0', 'achievement_reinforce_object', '50');
151INSERT INTO `achievement_proto` VALUES ('131', 'achievement_reinforce_object_3', '0', '0', '0', 'achievement_reinforce_object', '100');
152INSERT INTO `achievement_proto` VALUES ('132', 'achievement_enchant_object_1', '0', '0', '0', 'achievement_enchant_object', '1');
153INSERT INTO `achievement_proto` VALUES ('133', 'achievement_enchant_object_2', '0', '0', '0', 'achievement_enchant_object', '50');
154INSERT INTO `achievement_proto` VALUES ('134', 'achievement_enchant_object_3', '0', '0', '0', 'achievement_enchant_object', '100');
155INSERT INTO `achievement_proto` VALUES ('135', 'achievement_first_login', '0', '0', '0', '', '1');