· 5 years ago · Nov 15, 2020, 09:52 AM
1-- Dumping structure for table cm.animal_breeds
2DROP TABLE IF EXISTS `animal_breeds`;
3CREATE TABLE IF NOT EXISTS `animal_breeds` (
4 `ID` int(10) unsigned NOT NULL,
5 `is_strong_animal` tinyint(3) unsigned NOT NULL,
6 `base_hp` float unsigned NOT NULL,
7 `weapon_datablock_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8 `weapon_weight` float unsigned NOT NULL,
9 `fast_hit_damaging_distance` float unsigned NOT NULL,
10 `fast_hit_starting_distance` float unsigned NOT NULL,
11 `fast_hit_damaging_sector` float unsigned NOT NULL,
12 `fast_hit_base_speed_min` float unsigned NOT NULL,
13 `fast_hit_base_speed_max` float unsigned NOT NULL,
14 `power_hit_damaging_distance` float unsigned NOT NULL,
15 `power_hit_starting_distance` float unsigned NOT NULL,
16 `power_hit_damaging_sector` float unsigned NOT NULL,
17 `power_hit_base_speed_min` float unsigned NOT NULL,
18 `power_hit_base_speed_max` float unsigned NOT NULL,
19 `power_attack_probability` float unsigned NOT NULL,
20 `walk_animation_speed` float unsigned NOT NULL,
21 `run_animation_speed` float unsigned NOT NULL,
22 `walk_speed` float unsigned NOT NULL,
23 `run_speed` float unsigned NOT NULL,
24 `creature_body_radius` float unsigned NOT NULL,
25 `alertness_range_min` float unsigned NOT NULL,
26 `alertness_range_max` float unsigned NOT NULL,
27 `aggression_range_min` float unsigned NOT NULL,
28 `aggression_range_max` float unsigned NOT NULL,
29 `alertness_range_presence_threat_speed` float unsigned NOT NULL,
30 `alertness_range_presence_memory_duration` float unsigned NOT NULL,
31 `aggression_range_presence_threat_speed` float unsigned NOT NULL,
32 `aggression_range_presence_memory_duration` float unsigned NOT NULL,
33 `threat_from_damage_per_hit_point` float unsigned NOT NULL,
34 `become_alerted_threshold_on` float unsigned NOT NULL,
35 `become_alerted_threshold_off` float unsigned NOT NULL,
36 `become_aggressive_threshold_on` float unsigned NOT NULL,
37 `become_aggressive_threshold_off` float unsigned NOT NULL,
38 `sleep_probab` float unsigned NOT NULL,
39 `eat_probab` float unsigned NOT NULL,
40 `stand_probab` float unsigned NOT NULL,
41 `walk_probab` float unsigned NOT NULL,
42 `run_probab` float unsigned NOT NULL,
43 `sleep_duration_min` float unsigned NOT NULL,
44 `sleep_duration_max` float unsigned NOT NULL,
45 `non_sleep_action_duration_max` float unsigned NOT NULL,
46 `traveling_distance_min` float unsigned NOT NULL,
47 `traveling_distance_max` float unsigned NOT NULL,
48 `start_flee_condition_distance` float unsigned NOT NULL,
49 `flee_mode_threat_afteraction_duration` float unsigned NOT NULL,
50 `flee_order_distance_min` float unsigned NOT NULL,
51 `flee_order_distance_max` float unsigned NOT NULL,
52 `raw_corpse_object_type_id` int(11) unsigned NOT NULL,
53 `skinned_corpse_object_type_id` int(11) unsigned NOT NULL,
54 PRIMARY KEY (`ID`),
55 KEY `FK_raw_corpse_object_type_id` (`raw_corpse_object_type_id`),
56 KEY `FK_skinned_corpse_object_type_id` (`skinned_corpse_object_type_id`),
57 CONSTRAINT `FK_animal_breeds__objects_types` FOREIGN KEY (`ID`) REFERENCES `objects_types` (`ID`),
58 CONSTRAINT `FK_raw_corpse_object_type_id` FOREIGN KEY (`raw_corpse_object_type_id`) REFERENCES `objects_types` (`ID`),
59 CONSTRAINT `FK_skinned_corpse_object_type_id` FOREIGN KEY (`skinned_corpse_object_type_id`) REFERENCES `objects_types` (`ID`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61
62/*!40000 ALTER TABLE `animal_breeds` DISABLE KEYS */;
63INSERT INTO `animal_breeds` (`ID`, `is_strong_animal`, `base_hp`, `weapon_datablock_name`, `weapon_weight`, `fast_hit_damaging_distance`, `fast_hit_starting_distance`, `fast_hit_damaging_sector`, `fast_hit_base_speed_min`, `fast_hit_base_speed_max`, `power_hit_damaging_distance`, `power_hit_starting_distance`, `power_hit_damaging_sector`, `power_hit_base_speed_min`, `power_hit_base_speed_max`, `power_attack_probability`, `walk_animation_speed`, `run_animation_speed`, `walk_speed`, `run_speed`, `creature_body_radius`, `alertness_range_min`, `alertness_range_max`, `aggression_range_min`, `aggression_range_max`, `alertness_range_presence_threat_speed`, `alertness_range_presence_memory_duration`, `aggression_range_presence_threat_speed`, `aggression_range_presence_memory_duration`, `threat_from_damage_per_hit_point`, `become_alerted_threshold_on`, `become_alerted_threshold_off`, `become_aggressive_threshold_on`, `become_aggressive_threshold_off`, `sleep_probab`, `eat_probab`, `stand_probab`, `walk_probab`, `run_probab`, `sleep_duration_min`, `sleep_duration_max`, `non_sleep_action_duration_max`, `traveling_distance_min`, `traveling_distance_max`, `start_flee_condition_distance`, `flee_mode_threat_afteraction_duration`, `flee_order_distance_min`, `flee_order_distance_max`, `raw_corpse_object_type_id`, `skinned_corpse_object_type_id`) VALUES
64 (752, 1, 300, 'Bear_Paw', 10, 1, 0.7, 60, 10, 15, 1.3, 1.2, 90, 25, 40, 0.25, 0.87, 0.75, 2, 6, 3, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 911, 924),
65 (753, 0, 200, 'Wild_Horse_Hoof', 10, 0.5, 0.4, 45, 10, 15, 0.7, 0.5, 90, 20, 30, 0.25, 1.09, 0.59, 2, 6, 1.5, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 912, 925),
66 (754, 0, 100, 'Deer_Hoof', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 0.95, 0.52, 2, 6, 1.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 913, 926),
67 (755, 1, 100, 'Wolf_Fang', 10, 0.5, 0.4, 45, 5, 10, 0.7, 0.5, 90, 15, 25, 0.25, 1.72, 1.21, 2, 6, 1.2, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 915, 928),
68 (756, 0, 200, 'Moose_Hoof', 10, 0.5, 0.4, 45, 10, 15, 0.7, 0.5, 90, 20, 30, 0.25, 1, 0.55, 2, 6, 1.5, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 916, 929),
69 (757, 1, 100, 'Boar_Tusk', 10, 0.5, 0.4, 45, 5, 10, 0.7, 0.5, 90, 15, 25, 0.25, 1.76, 1.06, 2, 6, 1.5, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 917, 930),
70 (758, 0, 50, 'Sow_Tusk', 10, 0.5, 0.4, 45, 3, 5, 0.7, 0.5, 90, 10, 15, 0.25, 1.76, 1.06, 2, 6, 1, 10, 20, 10, 20, 10, 8, 25, 5, 50, 20, 0, 50, 30, 1, 3, 4, 1, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 918, 931),
71 (759, 0, 100, 'Mutton_Horns', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 2.17, 1.04, 2, 6, 2.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 919, 932),
72 (760, 0, 100, 'Bull_Horns', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 1.08, 0.55, 2, 6, 2.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 920, 933),
73 (761, 0, 100, 'Cow_Horns', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 1.08, 0.55, 2, 6, 2.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 921, 934),
74 (762, 2, 10, '', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 4, 2.57, 2, 6, 2.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 922, 935),
75 (763, 2, 10, '', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 1.05, 0.98, 2, 6, 2.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 923, 936),
76 (778, 0, 100, 'Hind_Hoof', 10, 0.5, 0.4, 45, 1, 3, 0.7, 0.5, 90, 2, 4, 0.5, 0.95, 0.52, 2, 6, 1.5, 20, 30, 20, 30, 20, 8, 50, 5, 50, 10, 0, 40, 20, 0, 3, 6, 0, 0, 10, 20, 8, 15, 40, 15, 15, 20, 40, 914, 927);
77/*!40000 ALTER TABLE `animal_breeds` ENABLE KEYS */;
78
79
80-- Dumping structure for table cm.animal_breeds_spawn_units
81DROP TABLE IF EXISTS `animal_breeds_spawn_units`;
82CREATE TABLE IF NOT EXISTS `animal_breeds_spawn_units` (
83 `animal_id` int(10) unsigned NOT NULL,
84 `spawn_pattern_id` int(10) unsigned NOT NULL,
85 `count_min` smallint(5) unsigned NOT NULL,
86 `count_max` smallint(5) unsigned NOT NULL,
87 `random_animal_quality_delta_min` float NOT NULL,
88 `random_animal_quality_delta_max` float NOT NULL,
89 PRIMARY KEY (`animal_id`,`spawn_pattern_id`),
90 KEY `spawn_pattern_id` (`spawn_pattern_id`),
91 KEY `FK_animal_breeds_spawn_units__animal_breeds` (`animal_id`),
92 CONSTRAINT `FK_animal_breeds_spawn_units__animal_breeds` FOREIGN KEY (`animal_id`) REFERENCES `animal_breeds` (`ID`),
93 CONSTRAINT `FK_animal_breeds_spawn_units__animal_spawn_patterns` FOREIGN KEY (`spawn_pattern_id`) REFERENCES `animal_spawn_patterns` (`ID`)
94) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95
96/*!40000 ALTER TABLE `animal_breeds_spawn_units` DISABLE KEYS */;
97INSERT INTO `animal_breeds_spawn_units` (`animal_id`, `spawn_pattern_id`, `count_min`, `count_max`, `random_animal_quality_delta_min`, `random_animal_quality_delta_max`) VALUES
98 (752, 2, 1, 1, -20, 10),
99 (753, 4, 1, 2, -30, 10),
100 (754, 1, 1, 1, -10, 20),
101 (757, 3, 1, 1, -20, 10),
102 (758, 3, 1, 1, -20, 0),
103 (760, 1, 1, 1, -10, 20);
104/*!40000 ALTER TABLE `animal_breeds_spawn_units` ENABLE KEYS */;
105
106
107-- Dumping structure for table cm.animal_drop_items
108DROP TABLE IF EXISTS `animal_drop_items`;
109CREATE TABLE IF NOT EXISTS `animal_drop_items` (
110 `animal_id` int(10) unsigned NOT NULL,
111 `drop_item_id` int(10) unsigned NOT NULL,
112 `probability` float unsigned NOT NULL,
113 `count_min` smallint(5) unsigned NOT NULL,
114 `count_max` smallint(5) unsigned NOT NULL,
115 PRIMARY KEY (`animal_id`,`drop_item_id`),
116 KEY `FK_animal_drop_items_objectstypeID` (`drop_item_id`),
117 KEY `FK_animal_id_objectstypeID` (`animal_id`),
118 CONSTRAINT `FK_animal_drop_items_objectstypeID` FOREIGN KEY (`drop_item_id`) REFERENCES `objects_types` (`ID`),
119 CONSTRAINT `FK_animal_drop_items__animal_breeds` FOREIGN KEY (`animal_id`) REFERENCES `animal_breeds` (`ID`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
121
122/*!40000 ALTER TABLE `animal_drop_items` DISABLE KEYS */;
123INSERT INTO `animal_drop_items` (`animal_id`, `drop_item_id`, `probability`, `count_min`, `count_max`) VALUES
124 (752, 336, 1, 2, 3),
125 (752, 342, 0.5, 10, 15),
126 (752, 386, 1, 3, 5),
127 (752, 474, 1, 3, 5),
128 (753, 336, 1, 3, 4),
129 (753, 342, 0.5, 8, 14),
130 (753, 386, 1, 3, 5),
131 (753, 475, 1, 3, 5),
132 (754, 386, 1, 1, 4),
133 (754, 474, 0.2, 1, 4),
134 (757, 336, 1, 1, 2),
135 (757, 342, 0.5, 5, 9),
136 (757, 386, 1, 2, 3),
137 (757, 475, 1, 2, 3),
138 (758, 336, 1, 1, 2),
139 (758, 342, 0.5, 5, 9),
140 (758, 386, 1, 2, 3),
141 (758, 475, 1, 2, 3);
142/*!40000 ALTER TABLE `animal_drop_items` ENABLE KEYS */;
143
144
145-- Dumping structure for table cm.animal_spawn_patterns
146DROP TABLE IF EXISTS `animal_spawn_patterns`;
147CREATE TABLE IF NOT EXISTS `animal_spawn_patterns` (
148 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
149 `spawn_probability` float unsigned NOT NULL,
150 PRIMARY KEY (`ID`)
151) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
152
153/*!40000 ALTER TABLE `animal_spawn_patterns` DISABLE KEYS */;
154INSERT INTO `animal_spawn_patterns` (`ID`, `spawn_probability`) VALUES
155 (1, 0.4),
156 (2, 0.05),
157 (3, 0.3),
158 (4, 0.2);
159/*!40000 ALTER TABLE `animal_spawn_patterns` ENABLE KEYS */;
160