Core/Creatures: added PetSpellDataId and Civilian fields to creature_template, replaced level delta fields with MinLevel and MaxLevel in creature_template_difficulty and backported creature_classlevel_stats from 4.3.4

1 files changed, 439 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_03_13_01_world.sql b/sql/updates/world/cata_classic/2024_03_13_01_world.sql
new file mode 100644
index 00000000000..17257aa625f
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_13_01_world.sql
@@ -0,0 +1,439 @@
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMax`= 1;
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`= 1;
+
+ALTER TABLE `creature_template_difficulty`   
+	DROP COLUMN `ContentTuningID`, 
+	CHANGE `LevelScalingDeltaMin` `MinLevel` TINYINT DEFAULT 1 NOT NULL,
+	CHANGE `LevelScalingDeltaMax` `MaxLevel` TINYINT DEFAULT 1 NOT NULL;
+
+DROP TABLE IF EXISTS `creature_classlevelstats`;
+CREATE TABLE `creature_classlevelstats`  (
+  `level` tinyint NOT NULL,
+  `class` tinyint NOT NULL,
+  `basehp0` int UNSIGNED NOT NULL DEFAULT 1,
+  `basehp1` int UNSIGNED NOT NULL DEFAULT 1,
+  `basehp2` int UNSIGNED NOT NULL DEFAULT 1,
+  `basehp3` int UNSIGNED NOT NULL DEFAULT 1,
+  `basemana` int UNSIGNED NOT NULL DEFAULT 1,
+  `basearmor` int UNSIGNED NOT NULL DEFAULT 1,
+  `attackpower` smallint NOT NULL DEFAULT 0,
+  `rangedattackpower` smallint NOT NULL DEFAULT 0,
+  `damage_base` float NOT NULL DEFAULT 0,
+  `damage_exp1` float NOT NULL DEFAULT 0,
+  `damage_exp2` float NOT NULL DEFAULT 0,
+  `damage_exp3` float NOT NULL DEFAULT 0,
+  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
+  PRIMARY KEY (`level`, `class`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
+
+INSERT INTO `creature_classlevelstats` (`level`, `class`, `basehp0`, `basehp1`, `basehp2`, `basehp3`, `basemana`, `basearmor`, `attackpower`, `rangedattackpower`, `damage_base`, `damage_exp1`, `damage_exp2`, `damage_exp3`, `comment`) VALUES 
+(1, 1, 42, 1, 1, 1, 0, 15, 10, 1, 0.0607, 0, 0, 0, NULL),
+(1, 2, 41, 1, 1, 1, 60, 13, 1, 1, 0.746, 0, 0, 0, 'armor estimated'),
+(1, 4, 42, 1, 1, 1, 0, 6, 24, 1, 0.25, 0, 0, 0, NULL),
+(1, 8, 40, 1, 1, 1, 120, 5, 1, 10, 0.4564, 0, 0, 0, NULL),
+(2, 1, 55, 1, 1, 1, 0, 16, 10, 1, 0.3603, 0, 0, 0, NULL),
+(2, 2, 54, 1, 1, 1, 69, 14, 3, 1, 0.7365, 0, 0, 0, 'armor estimated'),
+(2, 4, 55, 1, 1, 1, 0, 18, 26, 1, 0.54, 0, 0, 0, NULL),
+(2, 8, 52, 1, 1, 1, 147, 16, 3, 10, 0.4564, 0, 0, 0, NULL),
+(3, 1, 71, 1, 1, 1, 0, 41, 11, 1, 0.6976, 0, 0, 0, NULL),
+(3, 2, 69, 1, 1, 1, 79, 37, 7, 1, 0.6984, 0, 0, 0, NULL),
+(3, 4, 71, 1, 1, 1, 0, 31, 28, 1, 0.74, 0, 0, 0, NULL),
+(3, 8, 67, 1, 1, 1, 174, 28, 7, 10, 0.7334, 0, 0, 0, NULL),
+(4, 1, 86, 1, 1, 1, 0, 76, 13, 1, 1.0863, 0, 0, 0, NULL),
+(4, 2, 83, 1, 1, 1, 104, 67, 18, 1, 1.2138, 0, 0, 0, NULL),
+(4, 4, 86, 1, 1, 1, 0, 63, 30, 1, 0.9435, 0, 0, 0, NULL),
+(4, 8, 81, 1, 1, 1, 202, 57, 8, 11, 1.1235, 0, 0, 0, NULL),
+(5, 1, 102, 1, 1, 1, 0, 120, 17, 1, 1.4422, 0, 0, 0, NULL),
+(5, 2, 98, 1, 1, 1, 115, 105, 19, 1, 1.8471, 0, 0, 0, NULL),
+(5, 4, 102, 1, 1, 1, 0, 102, 32, 1, 1.5, 0, 0, 0, NULL),
+(5, 8, 95, 1, 1, 1, 230, 93, 9, 11, 1.3456, 0, 0, 0, NULL),
+(6, 1, 120, 1, 1, 1, 0, 174, 19, 1, 2.1375, 0, 0, 0, NULL),
+(6, 2, 115, 1, 1, 1, 126, 150, 24, 1, 2.6006, 0, 0, 0, NULL),
+(6, 4, 120, 1, 1, 1, 0, 152, 34, 1, 2.2, 0, 0, 0, NULL),
+(6, 8, 111, 1, 1, 1, 259, 139, 10, 11, 1.9557, 0, 0, 0, NULL),
+(7, 1, 137, 1, 1, 1, 0, 239, 21, 1, 2.9811, 0, 0, 0, NULL),
+(7, 2, 131, 1, 1, 1, 138, 205, 28, 1, 3.5412, 0, 0, 0, NULL),
+(7, 4, 137, 1, 1, 1, 0, 212, 36, 1, 3, 0, 0, 0, NULL),
+(7, 8, 126, 1, 1, 1, 289, 194, 13, 11, 2.7876, 0, 0, 0, NULL),
+(8, 1, 156, 1, 1, 1, 0, 316, 24, 1, 3.485, 0, 0, 0, NULL),
+(8, 2, 148, 1, 1, 1, 165, 268, 32, 1, 4.1435, 0, 0, 0, NULL),
+(8, 4, 156, 1, 1, 1, 0, 286, 38, 1, 4.3597, 0, 0, 0, NULL),
+(8, 8, 143, 1, 1, 1, 319, 265, 15, 11, 3.2334, 0, 0, 0, NULL),
+(9, 1, 176, 1, 1, 1, 0, 406, 28, 1, 3.0304, 0, 0, 0, NULL),
+(9, 2, 166, 1, 1, 1, 178, 342, 36, 1, 4.7933, 0, 0, 0, NULL),
+(9, 4, 176, 1, 1, 1, 0, 363, 40, 1, 4.6993, 0, 0, 0, NULL),
+(9, 8, 160, 1, 1, 1, 350, 339, 16, 11, 3.7654, 0, 0, 0, NULL),
+(10, 1, 198, 1, 1, 1, 0, 512, 32, 1, 3.2707, 0, 0, 0, NULL),
+(10, 2, 186, 1, 1, 1, 191, 426, 38, 1, 5.066, 0, 0, 0, NULL),
+(10, 4, 198, 1, 1, 1, 0, 443, 42, 1, 4.8281, 0, 0, 0, NULL),
+(10, 8, 178, 1, 1, 1, 382, 423, 17, 12, 4.2456, 0, 0, 0, NULL),
+(11, 1, 222, 1, 1, 1, 0, 538, 36, 1, 4.8425, 0, 0, 0, NULL),
+(11, 2, 208, 1, 1, 1, 205, 450, 40, 1, 5.3387, 0, 0, 0, NULL),
+(11, 4, 222, 1, 1, 1, 0, 488, 44, 1, 5.1609, 0, 0, 0, NULL),
+(11, 8, 199, 1, 1, 1, 459, 447, 17, 12, 4.7654, 0, 0, 0, NULL),
+(12, 1, 247, 1, 1, 1, 0, 573, 40, 1, 5.603, 0, 0, 0, NULL),
+(12, 2, 230, 1, 1, 1, 249, 479, 42, 1, 5.6114, 0, 0, 0, NULL),
+(12, 4, 247, 1, 1, 1, 0, 519, 46, 1, 5.6558, 0, 0, 0, NULL),
+(12, 8, 219, 1, 1, 1, 537, 475, 18, 12, 5.0345, 0, 0, 0, NULL),
+(13, 1, 273, 1, 1, 1, 0, 608, 44, 1, 6.0787, 0, 0, 0, NULL),
+(13, 2, 253, 1, 1, 1, 264, 507, 44, 1, 5.8841, 0, 0, 0, NULL),
+(13, 4, 273, 1, 1, 1, 0, 553, 48, 1, 6.0221, 0, 0, 0, NULL),
+(13, 8, 241, 1, 1, 1, 601, 509, 19, 12, 5.199, 0, 0, 0, NULL),
+(14, 1, 300, 1, 1, 1, 0, 642, 50, 1, 6.6101, 0, 0, 0, NULL),
+(14, 2, 276, 1, 1, 1, 295, 537, 46, 1, 6.1568, 0, 0, 0, NULL),
+(14, 4, 300, 1, 1, 1, 0, 577, 50, 1, 6.6101, 0, 0, 0, NULL),
+(14, 8, 263, 1, 1, 1, 710, 523, 21, 12, 5.7241, 0, 0, 0, NULL),
+(15, 1, 328, 1, 1, 1, 0, 677, 54, 2, 7.1981, 0, 0, 0, NULL),
+(15, 2, 301, 1, 1, 1, 326, 566, 48, 2, 6.8211, 0, 0, 0, NULL),
+(15, 4, 328, 1, 1, 1, 0, 612, 54, 2, 7.1981, 0, 0, 0, NULL),
+(15, 8, 285, 1, 1, 1, 790, 559, 22, 13, 6.3298, 0, 0, 0, NULL),
+(16, 1, 356, 1, 1, 1, 0, 713, 56, 2, 7.7861, 0, 0, 0, NULL),
+(16, 2, 325, 1, 1, 1, 357, 596, 52, 2, 7.1374, 0, 0, 0, NULL),
+(16, 4, 356, 1, 1, 1, 0, 645, 56, 2, 7.7861, 0, 0, 0, NULL),
+(16, 8, 307, 1, 1, 1, 856, 589, 24, 13, 6.6051, 0, 0, 0, NULL),
+(17, 1, 386, 1, 1, 1, 0, 748, 60, 2, 8.3741, 0, 0, 0, NULL),
+(17, 2, 350, 1, 1, 1, 390, 625, 56, 2, 7.6355, 0, 0, 0, NULL),
+(17, 4, 386, 1, 1, 1, 0, 676, 60, 2, 8.3741, 0, 0, 0, NULL),
+(17, 8, 330, 1, 1, 1, 938, 617, 26, 13, 7.0485, 0, 0, 0, NULL),
+(18, 1, 417, 1, 1, 1, 0, 782, 64, 3, 8.9621, 0, 0, 0, NULL),
+(18, 2, 377, 1, 1, 1, 408, 652, 58, 3, 8.1353, 0, 0, 0, NULL),
+(18, 4, 417, 1, 1, 1, 0, 706, 64, 3, 8.9621, 0, 0, 0, NULL),
+(18, 8, 354, 1, 1, 1, 1020, 643, 27, 13, 7.4083, 0, 0, 0, NULL),
+(19, 1, 449, 1, 1, 1, 0, 817, 68, 3, 9.5501, 0, 0, 0, NULL),
+(19, 2, 404, 1, 1, 1, 456, 683, 60, 3, 8.6351, 0, 0, 0, NULL),
+(19, 4, 449, 1, 1, 1, 0, 738, 68, 3, 9.5501, 0, 0, 0, NULL),
+(19, 8, 379, 1, 1, 1, 1118, 674, 28, 13, 7.9334, 0, 0, 0, NULL),
+(20, 1, 484, 1, 1, 1, 0, 852, 70, 4, 10.1381, 0, 0, 0, NULL),
+(20, 2, 433, 1, 1, 1, 490, 712, 64, 4, 9.0674, 0, 0, 0, NULL),
+(20, 4, 484, 1, 1, 1, 0, 769, 70, 4, 10.1381, 0, 0, 0, NULL),
+(20, 8, 405, 1, 1, 1, 1202, 701, 30, 14, 8.3382, 0, 0, 0, NULL),
+(21, 1, 521, 1, 1, 1, 0, 888, 74, 4, 10.7261, 0, 0, 0, NULL),
+(21, 2, 464, 1, 1, 1, 510, 740, 68, 4, 9.3169, 0, 0, 0, NULL),
+(21, 4, 521, 1, 1, 1, 0, 801, 74, 4, 10.7261, 0, 0, 0, NULL),
+(21, 8, 432, 1, 1, 1, 1272, 729, 32, 14, 8.5517, 0, 0, 0, NULL),
+(22, 1, 562, 1, 1, 1, 0, 922, 78, 4, 11.3141, 0, 0, 0, NULL),
+(22, 2, 498, 1, 1, 1, 545, 770, 72, 5, 9.7231, 0, 0, 0, NULL),
+(22, 4, 562, 1, 1, 1, 0, 833, 78, 4, 11.3141, 0, 0, 0, NULL),
+(22, 8, 463, 1, 1, 1, 1357, 759, 34, 14, 8.9102, 0, 0, 0, NULL),
+(23, 1, 605, 1, 1, 1, 0, 957, 80, 5, 11.9021, 0, 0, 0, NULL),
+(23, 2, 533, 1, 1, 1, 581, 800, 74, 5, 10.0761, 0, 0, 0, NULL),
+(23, 4, 605, 1, 1, 1, 0, 863, 80, 5, 11.9021, 0, 0, 0, NULL),
+(23, 8, 494, 1, 1, 1, 1443, 786, 35, 14, 9.228, 0, 0, 0, NULL),
+(24, 1, 651, 1, 1, 1, 0, 992, 84, 6, 12.4901, 0, 0, 0, NULL),
+(24, 2, 571, 1, 1, 1, 618, 829, 78, 6, 10.4619, 0, 0, 0, NULL),
+(24, 4, 651, 1, 1, 1, 0, 895, 84, 6, 12.4901, 0, 0, 0, NULL),
+(24, 8, 528, 1, 1, 1, 1545, 815, 36, 15, 9.6818, 0, 0, 0, NULL),
+(25, 1, 699, 1, 1, 1, 0, 1026, 86, 6, 13.0781, 0, 0, 0, NULL),
+(25, 2, 610, 1, 1, 1, 655, 858, 80, 6, 10.8234, 0, 0, 0, NULL),
+(25, 4, 699, 1, 1, 1, 0, 926, 86, 6, 13.0781, 0, 0, 0, NULL),
+(25, 8, 562, 1, 1, 1, 1633, 843, 37, 15, 10.1014, 0, 0, 0, NULL),
+(26, 1, 750, 1, 1, 1, 0, 1061, 90, 7, 13.6661, 0, 0, 0, NULL),
+(26, 2, 651, 1, 1, 1, 693, 887, 84, 6, 11.185, 0, 0, 0, NULL),
+(26, 4, 750, 1, 1, 1, 0, 957, 90, 7, 13.6661, 0, 0, 0, NULL),
+(26, 8, 598, 1, 1, 1, 1707, 871, 39, 15, 10.3246, 0, 0, 0, NULL),
+(27, 1, 800, 1, 1, 1, 0, 1097, 92, 7, 14.2541, 0, 0, 0, NULL),
+(27, 2, 690, 1, 1, 1, 732, 916, 86, 7, 11.7126, 0, 0, 0, NULL),
+(27, 4, 800, 1, 1, 1, 0, 989, 92, 7, 14.2541, 0, 0, 0, NULL),
+(27, 8, 633, 1, 1, 1, 1812, 900, 40, 15, 10.804, 0, 0, 0, NULL),
+(28, 1, 853, 1, 1, 1, 0, 1130, 96, 8, 14.8421, 0, 0, 0, NULL),
+(28, 2, 732, 1, 1, 1, 756, 946, 90, 7, 11.9663, 0, 0, 0, NULL),
+(28, 4, 853, 1, 1, 1, 0, 1020, 96, 8, 14.8421, 0, 0, 0, NULL),
+(28, 8, 669, 1, 1, 1, 1977, 928, 42, 15, 11.0214, 0, 0, 0, NULL),
+(29, 1, 905, 1, 1, 1, 0, 1165, 100, 8, 15.4301, 0, 0, 0, NULL),
+(29, 2, 773, 1, 1, 1, 811, 975, 94, 8, 12.352, 0, 0, 0, NULL),
+(29, 4, 905, 1, 1, 1, 0, 1051, 100, 8, 15.4301, 0, 0, 0, NULL),
+(29, 8, 704, 1, 1, 1, 2068, 957, 44, 16, 11.3608, 0, 0, 0, NULL),
+(30, 1, 955, 1, 1, 1, 0, 1200, 102, 9, 16.0181, 0, 0, 0, NULL),
+(30, 2, 811, 1, 1, 1, 852, 1004, 94, 8, 13.0007, 0, 0, 0, NULL),
+(30, 4, 955, 1, 1, 1, 0, 1082, 102, 9, 16.0181, 0, 0, 0, NULL),
+(30, 8, 737, 1, 1, 1, 2175, 984, 44, 16, 11.9607, 0, 0, 0, NULL),
+(31, 1, 1006, 1, 1, 1, 0, 1234, 106, 9, 16.6061, 0, 0, 0, NULL),
+(31, 2, 850, 1006, 1, 1, 878, 1033, 98, 9, 13.2348, 0, 0, 0, NULL),
+(31, 4, 1006, 1, 1, 1, 0, 1113, 106, 9, 16.6061, 0, 0, 0, NULL),
+(31, 8, 770, 1, 1, 1, 2253, 1012, 46, 16, 12.16, 0, 0, 0, NULL),
+(32, 1, 1057, 1, 1, 1, 0, 1270, 108, 10, 17.1941, 0, 0, 0, NULL),
+(32, 2, 888, 1, 1, 1, 935, 1063, 100, 9, 13.6924, 0, 0, 0, NULL),
+(32, 4, 1057, 1, 1, 1, 0, 1146, 108, 10, 17.1941, 0, 0, 0, NULL),
+(32, 8, 802, 1, 1, 1, 2362, 1042, 47, 16, 12.5746, 0, 0, 0, NULL),
+(33, 1, 1110, 1, 1, 1, 0, 1304, 112, 10, 17.7821, 0, 0, 0, NULL),
+(33, 2, 928, 1, 1, 1, 963, 1091, 104, 10, 13.9511, 0, 0, 0, NULL),
+(33, 4, 1110, 1, 1, 1, 0, 1173, 112, 10, 17.7821, 0, 0, 0, NULL),
+(33, 8, 835, 1, 1, 1, 2457, 1065, 49, 17, 12.7966, 0, 0, 0, NULL),
+(34, 1, 1163, 1, 1, 1, 0, 1340, 114, 11, 18.3701, 0, 0, 0, NULL),
+(34, 2, 967, 1, 1, 1, 1007, 1121, 106, 10, 14.4142, 0, 0, 0, NULL),
+(34, 4, 1163, 1, 1, 1, 0, 1208, 114, 11, 18.3701, 0, 0, 0, NULL),
+(34, 8, 867, 1, 1, 1, 2553, 1098, 50, 17, 13.2162, 0, 0, 0, NULL),
+(35, 1, 1220, 1, 1, 1, 0, 1373, 118, 11, 18.9581, 0, 0, 0, NULL),
+(35, 2, 1009, 1, 1, 1, 1067, 1149, 110, 11, 14.7365, 0, 0, 0, NULL),
+(35, 4, 1220, 1, 1, 1, 0, 1237, 118, 11, 18.9581, 0, 0, 0, NULL),
+(35, 8, 902, 1, 1, 1, 2680, 1124, 52, 17, 13.497, 0, 0, 0, NULL),
+(36, 1, 1277, 1, 1, 1, 0, 1480, 120, 12, 19.5461, 0, 0, 0, NULL),
+(36, 2, 1050, 1, 1, 1, 1097, 1234, 112, 11, 15.1346, 0, 0, 0, NULL),
+(36, 4, 1277, 1, 1, 1, 0, 1349, 120, 12, 19.5461, 0, 0, 0, NULL),
+(36, 8, 935, 1, 1, 1, 2763, 1241, 53, 18, 13.8566, 0, 0, 0, NULL),
+(37, 1, 1336, 1, 1, 1, 0, 1593, 124, 12, 20.1341, 0, 0, 0, NULL),
+(37, 2, 1093, 1, 1, 1, 1142, 1325, 116, 11, 15.5816, 0, 0, 0, NULL),
+(37, 4, 1336, 1, 1, 1, 0, 1434, 124, 12, 20.1341, 0, 0, 0, NULL),
+(37, 8, 970, 1, 1, 1, 2861, 1300, 54, 18, 14.367, 0, 0, 0, NULL),
+(38, 1, 1395, 1, 1, 1, 0, 1709, 128, 13, 20.7221, 0, 0, 0, NULL),
+(38, 2, 1135, 1, 1, 1, 1189, 1418, 120, 12, 15.9286, 0, 0, 0, NULL),
+(38, 4, 1395, 1, 1, 1, 0, 1538, 128, 13, 20.7221, 0, 0, 0, NULL),
+(38, 8, 1004, 1, 1, 1, 2975, 1391, 56, 18, 14.6707, 0, 0, 0, NULL),
+(39, 1, 1459, 1, 1, 1, 0, 1834, 132, 13, 21.3101, 0, 0, 0, NULL),
+(39, 2, 1180, 1, 1, 1, 1236, 1517, 124, 12, 16.4168, 0, 0, 0, NULL),
+(39, 4, 1459, 1, 1, 1, 0, 1649, 132, 13, 21.3101, 0, 0, 0, NULL),
+(39, 8, 1040, 1, 1, 1, 3075, 1489, 58, 18, 15.1049, 0, 0, 0, NULL),
+(40, 1, 1524, 1, 1, 1, 0, 1964, 136, 14, 21.8981, 0, 0, 0, NULL),
+(40, 2, 1226, 1, 1, 1, 1283, 1619, 128, 13, 16.9294, 0, 0, 0, NULL),
+(40, 4, 1524, 1, 1, 1, 0, 1764, 136, 14, 21.8981, 0, 0, 0, NULL),
+(40, 8, 1077, 1, 1, 1, 3191, 1590, 60, 19, 15.5617, 0, 0, 0, NULL),
+(41, 1, 1585, 1, 1, 1, 0, 2101, 142, 15, 22.4861, 0, 0, 0, NULL),
+(41, 2, 1268, 1, 1, 1, 1332, 1727, 132, 13, 17.8592, 0, 0, 0, NULL),
+(41, 4, 1585, 1, 1, 1, 0, 1886, 142, 15, 22.4861, 0, 0, 0, NULL),
+(41, 8, 1110, 1, 1, 1, 3293, 1697, 62, 19, 16.4044, 0, 0, 0, NULL),
+(42, 1, 1651, 1, 1, 1, 0, 2246, 152, 15, 23.0741, 0, 0, 0, NULL),
+(42, 2, 1321, 1, 1, 1, 1381, 1841, 142, 15, 18.8825, 0, 0, 0, NULL),
+(42, 4, 1651, 1, 1, 1, 0, 2015, 152, 15, 23.0741, 0, 0, 0, NULL),
+(42, 8, 1156, 1, 1, 1, 3471, 1811, 67, 19, 17.3076, 0, 0, 0, NULL),
+(43, 1, 1716, 1, 1, 1, 0, 2397, 162, 16, 23.6621, 0, 0, 0, NULL),
+(43, 2, 1373, 1, 1, 1, 1432, 1958, 152, 14, 20.1126, 0, 0, 0, NULL),
+(43, 4, 1716, 1, 1, 1, 0, 2148, 162, 16, 23.6621, 0, 0, 0, NULL),
+(43, 8, 1201, 1, 1, 1, 3575, 1926, 71, 19, 18.5165, 0, 0, 0, NULL),
+(44, 1, 1782, 1, 1, 1, 0, 2557, 174, 16, 24.2501, 0, 0, 0, NULL),
+(44, 2, 1426, 1, 1, 1, 1483, 2082, 166, 15, 21.6981, 0, 0, 0, NULL),
+(44, 4, 1782, 1, 1, 1, 0, 2303, 174, 16, 24.2501, 0, 0, 0, NULL),
+(44, 8, 1247, 1, 1, 1, 3680, 2078, 78, 20, 19.9224, 0, 0, 0, NULL),
+(45, 1, 1848, 1, 1, 1, 0, 2725, 184, 17, 24.8381, 0, 0, 0, NULL),
+(45, 2, 1478, 1, 1, 1, 1534, 2211, 172, 15, 22.9018, 0, 0, 0, NULL),
+(45, 4, 1848, 1, 1, 1, 0, 2436, 184, 17, 24.8381, 0, 0, 0, NULL),
+(45, 8, 1294, 1, 1, 1, 3801, 2177, 81, 20, 21.0097, 0, 0, 0, NULL),
+(46, 1, 1919, 1, 1, 1, 0, 2780, 188, 17, 25.4261, 0, 0, 0, NULL),
+(46, 2, 1535, 1, 1, 1, 1587, 2255, 176, 16, 23.345, 0, 0, 0, NULL),
+(46, 4, 1919, 1, 1, 1, 0, 2485, 188, 17, 25.4261, 0, 0, 0, NULL),
+(46, 8, 1343, 1, 1, 1, 3923, 2220, 83, 20, 21.4023, 0, 0, 0, NULL),
+(47, 1, 1990, 1, 1, 1, 0, 2835, 192, 18, 26.0141, 0, 0, 0, NULL),
+(47, 2, 1592, 1, 1, 1, 1640, 2300, 180, 16, 23.9542, 0, 0, 0, NULL),
+(47, 4, 1990, 1, 1, 1, 0, 2535, 192, 18, 26.0141, 0, 0, 0, NULL),
+(47, 8, 1393, 1, 1, 1, 4031, 2265, 85, 21, 21.9484, 0, 0, 0, NULL),
+(48, 1, 2062, 1, 1, 1, 0, 2888, 196, 19, 26.6021, 0, 0, 0, NULL),
+(48, 2, 1650, 1, 1, 1, 1695, 2344, 184, 17, 24.401, 0, 0, 0, NULL),
+(48, 4, 2062, 1, 1, 1, 0, 2582, 196, 19, 26.6021, 0, 0, 0, NULL),
+(48, 8, 1443, 1, 1, 1, 4140, 2307, 87, 21, 22.3444, 0, 0, 0, NULL),
+(49, 1, 2138, 1, 1, 1, 0, 2944, 200, 19, 27.1901, 0, 0, 0, NULL),
+(49, 2, 1710, 1, 1, 1, 1750, 2389, 188, 17, 24.9975, 0, 0, 0, NULL),
+(49, 4, 2138, 1, 1, 1, 0, 2631, 200, 19, 27.1901, 0, 0, 0, NULL),
+(49, 8, 1497, 1, 1, 1, 4281, 2349, 89, 21, 22.8788, 0, 0, 0, NULL),
+(50, 1, 2215, 1, 1, 1, 0, 2999, 206, 20, 27.7781, 0, 0, 0, NULL),
+(50, 2, 1772, 1, 1, 1, 1807, 2432, 194, 18, 25.5204, 0, 0, 0, NULL),
+(50, 4, 2215, 1, 1, 1, 0, 2680, 206, 20, 27.7781, 0, 0, 0, NULL),
+(50, 8, 1551, 1, 1, 1, 4393, 2393, 91, 22, 23.4508, 0, 0, 0, NULL),
+(51, 1, 2292, 1, 1, 1, 0, 3052, 210, 20, 28.3661, 0, 0, 0, NULL),
+(51, 2, 1834, 1, 1, 1, 1864, 2477, 198, 19, 26.0047, 0, 0, 0, NULL),
+(51, 4, 2292, 1, 1, 1, 0, 2728, 210, 20, 28.3661, 0, 0, 0, NULL),
+(51, 8, 1604, 1, 1, 1, 4506, 2437, 93, 22, 23.8815, 0, 0, 0, NULL),
+(52, 1, 2371, 1, 1, 1, 0, 3108, 214, 21, 28.9541, 0, 0, 0, NULL),
+(52, 2, 1897, 1, 1, 1, 1923, 2522, 202, 19, 26.6877, 0, 0, 0, NULL),
+(52, 4, 2371, 1, 1, 1, 0, 2778, 214, 21, 28.9541, 0, 0, 0, NULL),
+(52, 8, 1660, 1, 1, 1, 4650, 2481, 95, 22, 24.4958, 0, 0, 0, NULL),
+(53, 1, 2453, 1, 1, 1, 0, 3163, 218, 22, 29.5421, 0, 0, 0, NULL),
+(53, 2, 1962, 1, 1, 1, 1982, 2566, 206, 20, 27.1912, 0, 0, 0, NULL),
+(53, 4, 2453, 1, 1, 1, 0, 2826, 218, 22, 29.5421, 0, 0, 0, NULL),
+(53, 8, 1717, 1, 1, 1, 4765, 2524, 97, 23, 24.9442, 0, 0, 0, NULL),
+(54, 1, 2533, 1, 1, 1, 0, 3216, 224, 22, 30.1301, 0, 0, 0, NULL),
+(54, 2, 2026, 1, 1, 1, 2041, 2610, 210, 20, 27.8506, 0, 0, 0, NULL),
+(54, 4, 2533, 1, 1, 1, 0, 2874, 224, 22, 30.1301, 0, 0, 0, NULL),
+(54, 8, 1773, 1, 1, 1, 4896, 2567, 99, 23, 25.5368, 0, 0, 0, NULL),
+(55, 1, 2614, 1, 1, 1, 0, 3271, 228, 23, 30.7177, 0, 0, 0, NULL),
+(55, 2, 2091, 1, 1, 1, 2117, 2654, 214, 21, 28.3834, 0, 0, 0, NULL),
+(55, 4, 2614, 1, 1, 1, 0, 2922, 228, 23, 30.7177, 0, 0, 0, NULL),
+(55, 8, 1830, 1, 1, 1, 5013, 2609, 101, 23, 26.079, 0, 0, 0, NULL),
+(56, 1, 2699, 1, 1, 1, 0, 3327, 234, 23, 31.3057, 0, 0, 0, NULL),
+(56, 2, 2159, 1, 1, 1, 2163, 2699, 220, 21, 28.9161, 0, 0, 0, NULL),
+(56, 4, 2699, 1, 1, 1, 0, 2972, 234, 23, 31.3057, 0, 0, 0, NULL),
+(56, 8, 1889, 1, 1, 1, 5206, 2654, 104, 24, 26.4791, 0, 0, 0, NULL),
+(57, 1, 2784, 1, 1, 1, 0, 3380, 238, 24, 31.8937, 42.1353, 0, 0, NULL),
+(57, 2, 2227, 1, 1, 1, 2241, 2744, 224, 22, 29.5702, 41.2575, 0, 0, NULL),
+(57, 4, 2784, 1, 1, 1, 0, 3020, 238, 24, 31.8937, 42.1353, 0, 0, NULL),
+(57, 8, 1949, 1, 1, 1, 5340, 2698, 106, 24, 27.0667, 39.5236, 0, 0, NULL),
+(58, 1, 2871, 3989, 1, 1, 0, 3435, 242, 25, 32.4817, 46.9207, 0, 0, NULL),
+(58, 2, 2297, 3191, 1, 1, 2289, 2788, 228, 23, 30.1469, 45.5251, 0, 0, NULL),
+(58, 4, 2871, 3989, 1, 1, 0, 3068, 242, 25, 32.4817, 46.9207, 0, 0, NULL),
+(58, 8, 2010, 2793, 1, 1, 5461, 2740, 107, 24, 27.6972, 43.1021, 0, 0, NULL),
+(59, 1, 2961, 4142, 1, 1, 0, 3489, 248, 25, 33.0697, 51.7061, 0, 0, NULL),
+(59, 2, 2369, 3314, 1, 1, 2369, 2832, 234, 23, 30.7656, 49.7927, 0, 0, NULL),
+(59, 4, 2961, 4142, 1, 1, 0, 3117, 248, 25, 33.0697, 51.7061, 0, 0, NULL),
+(59, 8, 2073, 2899, 1, 1, 5598, 2784, 110, 25, 28.1686, 46.5379, 0, 0, NULL),
+(60, 1, 3052, 4979, 1, 1, 0, 3791, 252, 26, 33.6577, 56.4915, 0, 0, NULL),
+(60, 2, 2442, 3984, 1, 1, 2434, 3075, 238, 24, 31.3842, 54.0603, 0, 0, NULL),
+(60, 4, 3052, 4979, 1, 1, 0, 3388, 252, 26, 33.6577, 56.4915, 0, 0, NULL),
+(60, 8, 2136, 3484, 1, 1, 5751, 3025, 112, 25, 28.7983, 50.045, 0, 0, NULL),
+(61, 1, 3144, 5158, 1, 1, 0, 4091, 258, 28, 34.2457, 61.2769, 0, 0, NULL),
+(61, 2, 2515, 4126, 5776, 1, 2486, 3316, 244, 25, 31.9807, 58.3279, 0, 0, NULL),
+(61, 4, 3144, 5158, 1, 1, 0, 3655, 258, 28, 34.2457, 61.2769, 0, 0, NULL),
+(61, 8, 2201, 3611, 1, 1, 5875, 3263, 115, 25, 29.2976, 53.4807, 0, 0, NULL),
+(62, 1, 3237, 5341, 1, 1, 0, 4391, 262, 30, 34.8337, 66.0623, 0, 0, NULL),
+(62, 2, 2590, 4274, 1, 1, 2568, 3555, 246, 26, 32.5772, 62.4676, 0, 0, NULL),
+(62, 4, 3237, 5341, 1, 1, 0, 3922, 262, 30, 34.8337, 66.0623, 0, 0, NULL),
+(62, 8, 2266, 3739, 1, 1, 6015, 3500, 116, 25, 29.7969, 57.2713, 0, 0, NULL),
+(63, 1, 3331, 5527, 1, 1, 0, 4691, 268, 32, 35.4217, 70.8477, 0, 0, NULL),
+(63, 2, 2665, 4422, 1, 1, 2620, 3795, 252, 26, 33.1737, 66.121, 0, 0, NULL),
+(63, 4, 3331, 5527, 1, 1, 0, 4189, 268, 32, 35.4217, 70.8477, 0, 0, NULL),
+(63, 8, 2332, 3870, 1, 1, 6156, 3736, 119, 26, 30.2962, 60.577, 0, 0, NULL),
+(64, 1, 3427, 5715, 1, 1, 0, 4991, 272, 33, 36.0097, 75.6331, 0, 0, NULL),
+(64, 2, 2740, 4572, 1, 1, 2705, 4036, 256, 27, 33.7702, 70.2568, 0, 0, NULL),
+(64, 4, 3427, 5715, 1, 1, 0, 4457, 272, 33, 36.0097, 75.6331, 0, 0, NULL),
+(64, 8, 2399, 4000, 1, 1, 6299, 3977, 121, 26, 30.7955, 64.3364, 0, 0, NULL),
+(65, 1, 3524, 5914, 1, 1, 0, 5291, 278, 35, 36.5977, 80.4185, 0, 0, NULL),
+(65, 2, 2819, 4731, 1, 1, 2790, 4275, 262, 29, 34.3667, 74.3252, 0, 0, NULL),
+(65, 4, 3524, 5914, 1, 1, 0, 4724, 278, 35, 36.5977, 80.4185, 0, 0, NULL),
+(65, 8, 2467, 4140, 4731, 1, 6443, 4214, 124, 26, 31.2948, 68.0244, 0, 0, NULL),
+(66, 1, 3635, 6116, 1, 1, 0, 5591, 282, 37, 37.1857, 85.2039, 0, 0, NULL),
+(66, 2, 2899, 4892, 6116, 1, 2846, 4515, 266, 29, 34.9632, 78.472, 0, 0, NULL),
+(66, 4, 3635, 6116, 1, 1, 0, 5104, 282, 37, 37.1857, 85.2039, 0, 0, NULL),
+(66, 8, 2552, 4281, 4892, 1, 6588, 4460, 125, 27, 31.7941, 72.0499, 0, 0, NULL),
+(67, 1, 3728, 6326, 1, 1, 0, 5892, 288, 39, 37.7737, 89.9893, 111.174, 0, NULL),
+(67, 2, 2982, 5060, 1, 1, 2933, 4755, 272, 31, 35.5597, 82.7944, 110.698, 0, NULL),
+(67, 4, 3728, 6326, 1, 1, 0, 5326, 288, 39, 37.7737, 89.9893, 111.174, 0, NULL),
+(67, 8, 2610, 4429, 5060, 1, 6749, 4710, 128, 27, 32.2934, 75.9676, 87.7106, 0, NULL),
+(68, 1, 3834, 6542, 6986, 1, 0, 6192, 292, 41, 38.3617, 94.7747, 115.224, 0, NULL),
+(68, 2, 3067, 5233, 6986, 1, 2991, 4995, 276, 31, 36.1562, 87.2676, 114.869, 0, NULL),
+(68, 4, 3834, 6542, 6986, 1, 0, 5527, 292, 41, 38.3617, 94.7747, 115.224, 0, NULL),
+(68, 8, 2684, 4580, 5588, 1, 6882, 4928, 130, 27, 32.7927, 79.9198, 96.6868, 0, NULL),
+(69, 1, 3942, 6761, 7984, 1, 0, 6492, 298, 43, 38.9497, 99.5601, 119.274, 0, NULL),
+(69, 2, 3153, 5409, 7984, 1, 3080, 5235, 282, 32, 36.7527, 91.8915, 119.04, 0, NULL),
+(69, 4, 3942, 6761, 7984, 1, 0, 5795, 298, 43, 38.9497, 99.5601, 119.274, 0, NULL),
+(69, 8, 2759, 4733, 6387, 1, 7031, 5167, 133, 28, 33.292, 83.8005, 105.591, 0, NULL),
+(70, 1, 4050, 6986, 8982, 1, 0, 6792, 304, 44, 39.5377, 104.346, 123.324, 0, NULL),
+(70, 2, 3240, 5589, 8982, 1, 3155, 5474, 286, 33, 37.3492, 96.7365, 123.212, 0, NULL),
+(70, 4, 4050, 6986, 8982, 1, 0, 6062, 304, 44, 39.5377, 104.346, 123.324, 0, NULL),
+(70, 8, 2835, 4890, 7185, 1, 7196, 5404, 135, 28, 33.7913, 87.7526, 114.496, 0, NULL),
+(71, 1, 4163, 7181, 9291, 1, 0, 7089, 308, 48, 40.1257, 109.131, 127.374, 0, NULL),
+(71, 2, 3330, 5744, 9291, 1, 3231, 5714, 290, 37, 37.9457, 101.004, 127.383, 0, NULL),
+(71, 4, 4163, 7181, 9291, 1, 0, 6332, 308, 48, 40.1257, 109.131, 127.374, 0, NULL),
+(71, 8, 2914, 5027, 7432, 1, 7332, 5645, 137, 31, 34.2906, 91.7048, 117.829, 0, NULL),
+(72, 1, 4278, 7380, 9610, 1, 0, 7387, 314, 53, 40.7137, 113.916, 131.424, 0, NULL),
+(72, 2, 3422, 5903, 9610, 1, 3309, 5954, 296, 40, 38.5422, 105.272, 131.092, 0, NULL),
+(72, 4, 4278, 7380, 9610, 1, 0, 6602, 314, 53, 40.7137, 113.916, 131.424, 0, NULL),
+(72, 8, 2995, 5166, 7688, 1, 7500, 5886, 140, 34, 34.7899, 95.5855, 121.259, 0, NULL),
+(73, 1, 4399, 7588, 9940, 19880, 0, 7684, 320, 58, 41.3017, 118.702, 135.474, 0, NULL),
+(73, 2, 3519, 6070, 9940, 19880, 3387, 6193, 302, 44, 39.1387, 109.539, 134.908, 0, NULL),
+(73, 4, 4399, 7580, 9940, 1, 0, 6872, 320, 58, 41.3017, 118.702, 135.474, 0, NULL),
+(73, 8, 3098, 5311, 7952, 1, 7654, 6126, 143, 37, 35.2892, 99.4662, 124.79, 0, NULL),
+(74, 1, 4524, 7804, 10282, 1, 0, 7918, 354, 63, 41.8897, 0, 139.524, 0, NULL),
+(74, 2, 3619, 6243, 10282, 1, 3466, 7903, 334, 48, 39.7352, 0, 138.836, 0, NULL),
+(74, 4, 4524, 1, 10282, 1, 0, 7143, 354, 63, 41.8897, 0, 139.524, 0, NULL),
+(74, 8, 3186, 1, 8225, 1, 7809, 6368, 158, 41, 35.7885, 0, 128.423, 0, NULL),
+(75, 1, 4652, 8025, 10635, 1, 0, 8219, 392, 68, 42.4777, 0, 143.574, 0, NULL),
+(75, 2, 3722, 6420, 10635, 1, 3561, 8204, 370, 53, 40.3317, 0, 142.878, 0, NULL),
+(75, 4, 4652, 1, 10635, 1, 0, 7415, 392, 68, 42.4777, 0, 143.574, 0, NULL),
+(75, 8, 3256, 5617, 8508, 1, 7981, 6610, 175, 45, 36.2878, 0, 132.162, 0, NULL),
+(76, 1, 4781, 8247, 11001, 22002, 0, 8520, 432, 74, 43.0657, 0, 147.624, 0, NULL),
+(76, 2, 3825, 6602, 11001, 1, 3643, 8503, 408, 57, 40.9282, 0, 147.038, 0, NULL),
+(76, 4, 4781, 1, 11001, 1, 0, 7686, 432, 74, 43.0657, 0, 147.624, 0, NULL),
+(76, 8, 3367, 1, 8800, 1, 8139, 6851, 193, 49, 36.7871, 0, 136.01, 0, NULL),
+(77, 1, 4916, 8480, 11379, 22758, 0, 8822, 478, 81, 43.6537, 0, 151.674, 0, NULL),
+(77, 2, 3933, 6784, 11379, 1, 3725, 8803, 452, 62, 41.5247, 0, 151.319, 0, NULL),
+(77, 4, 4916, 1, 11379, 1, 0, 7958, 478, 81, 43.6537, 0, 151.674, 0, NULL),
+(77, 8, 3462, 1, 9103, 1, 8313, 7094, 214, 54, 37.2864, 0, 139.97, 0, NULL),
+(78, 1, 5052, 8715, 11770, 1, 0, 9124, 528, 88, 44.2417, 0, 155.724, 0, NULL),
+(78, 2, 4042, 6972, 11770, 1, 3809, 9104, 500, 68, 42.1212, 0, 155.724, 0, NULL),
+(78, 4, 5052, 1, 11770, 1, 0, 8230, 528, 88, 44.2417, 0, 155.724, 0, NULL),
+(78, 8, 3558, 1, 9416, 1, 8459, 7335, 236, 58, 37.7857, 0, 144.045, 0, NULL),
+(79, 1, 5194, 8960, 12175, 1, 0, 9426, 582, 95, 44.8297, 0, 160.258, 0, NULL),
+(79, 2, 4155, 7167, 12175, 1, 3893, 9405, 550, 74, 42.7177, 0, 160.258, 0, NULL),
+(79, 4, 5194, 1, 12175, 1, 0, 8503, 582, 95, 44.8297, 0, 160.258, 0, NULL),
+(79, 8, 3658, 1, 9740, 1, 8636, 7579, 260, 64, 38.285, 0, 148.239, 0, NULL),
+(80, 1, 5342, 9215, 12600, 30951, 0, 9729, 642, 103, 45.4177, 0, 164.924, 197.377, NULL),
+(80, 2, 4274, 7373, 12600, 30951, 3994, 9706, 608, 80, 43.3142, 0, 164.924, 195.237, NULL),
+(80, 4, 5342, 1, 12600, 30951, 0, 8776, 642, 103, 45.4177, 0, 164.924, 191.179, NULL),
+(80, 8, 3739, 1, 10080, 24761, 8814, 7822, 289, 69, 38.7843, 0, 152.412, 183.236, NULL),
+(81, 1, 5492, 9474, 13033, 37187, 0, 10033, 708, 112, 46.0057, 0, 168.974, 197.377, NULL),
+(81, 2, 4394, 7581, 13033, 37187, 4081, 10007, 670, 86, 43.9107, 0, 169.095, 195.237, NULL),
+(81, 4, 5496, 1, 13033, 37187, 0, 9068, 708, 112, 46.0057, 0, 168.974, 191.179, NULL),
+(81, 8, 3870, 1, 10486, 29750, 8979, 8102, 304, 74, 39.2836, 0, 157.584, 183.236, NULL),
+(82, 1, 5647, 9741, 13481, 44679, 0, 10356, 782, 121, 46.5937, 0, 173.024, 197.377, NULL),
+(82, 2, 4518, 7794, 13481, 44679, 4169, 10253, 726, 91, 44.5072, 0, 173.266, 195.237, NULL),
+(82, 4, 5647, 1, 13481, 44679, 0, 9348, 782, 121, 46.5937, 0, 173.024, 191.179, NULL),
+(82, 8, 3977, 1, 10784, 35743, 9160, 8340, 326, 79, 39.7829, 0, 162.257, 183.236, NULL),
+(83, 1, 5808, 10019, 13945, 53681, 0, 10643, 805, 135, 47.1817, 0, 177.074, 197.377, NULL),
+(83, 2, 4646, 1, 13945, 53681, 4258, 10643, 783, 98, 45.1037, 0, 177.438, 195.237, NULL),
+(83, 4, 5808, 1, 13945, 53681, 0, 9589, 805, 135, 47.1817, 0, 177.074, 191.179, NULL),
+(83, 8, 4090, 1, 11156, 42945, 9328, 8505, 343, 84, 40.2822, 0, 167.286, 183.236, NULL),
+(84, 1, 5971, 10300, 14409, 64496, 0, 10099, 930, 149, 47.7697, 171.348, 181.124, 197.377, ''),
+(84, 2, 4774, 8220, 14409, 64496, 4363, 10893, 840, 105, 45.7002, 156.476, 181.61, 195.237, ''),
+(84, 4, 5969, 9780, 14409, 64496, 0, 9830, 828, 149, 47.7697, 171.348, 181.124, 191.179, ''),
+(84, 8, 4203, 6906, 11528, 51597, 9512, 8670, 360, 89, 40.7815, 142.154, 172.315, 183.236, ''),
+(85, 1, 6141, 10595, 14873, 77490, 0, 10419, 1004, 163, 48.3577, 176.134, 185.174, 197.377, ''),
+(85, 2, 4902, 8433, 14873, 77490, 4454, 11213, 897, 112, 46.2967, 160.743, 185.782, 195.237, ''),
+(85, 4, 6130, 9980, 14873, 77490, 0, 10071, 851, 163, 48.3577, 176.134, 185.174, 191.179, ''),
+(85, 8, 4316, 7051, 11900, 61992, 9697, 8835, 377, 94, 41.2808, 146.035, 177.344, 183.236, ''),
+(86, 1, 6306, 10890, 15337, 80195, 0, 10470, 1078, 177, 48.9457, 180.92, 189.224, 217.475, ''),
+(86, 2, 5030, 8646, 15337, 80195, 4502, 11533, 954, 119, 46.8932, 165.01, 189.954, 215.339, ''),
+(86, 4, 6291, 10180, 15337, 80195, 0, 10312, 874, 177, 48.9457, 180.92, 189.224, 211.376, ''),
+(86, 8, 4429, 7196, 12272, 86077, 9873, 9000, 394, 99, 41.7801, 149.915, 182.373, 203.275, ''),
+(87, 1, 6472, 11185, 15801, 82994, 0, 10522, 1152, 191, 49.5337, 185.706, 193.274, 217.475, ''),
+(87, 2, 5158, 8859, 15801, 82994, 4655, 11853, 1011, 126, 47.4897, 169.277, 194.126, 215.339, ''),
+(87, 4, 6452, 10380, 15801, 82994, 0, 10553, 897, 191, 49.5337, 185.706, 193.274, 211.376, ''),
+(87, 8, 4542, 7341, 12644, 107596, 10052, 9165, 411, 104, 42.2794, 153.796, 187.402, 203.275, ''),
+(88, 1, 6639, 11480, 16265, 85892, 0, 1057, 1226, 205, 50.1217, 190.492, 197.324, 217.475, ''),
+(88, 2, 5286, 9072, 16265, 85892, 4735, 12173, 1068, 133, 48.0862, 173.544, 198.298, 215.339, ''),
+(88, 4, 6613, 10580, 16265, 85892, 0, 10794, 920, 205, 50.1217, 190.492, 197.324, 211.376, ''),
+(88, 8, 4655, 7486, 13016, 68714, 10232, 9330, 428, 109, 42.7787, 157.677, 192.431, 203.275, ''),
+(89, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(89, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(89, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(89, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(90, 1, 1, 17672, 17672, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(90, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(90, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(90, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(91, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(91, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(91, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(91, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(92, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(92, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(92, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(92, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(93, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(93, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(93, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(93, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(94, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(94, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(94, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(94, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(95, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(95, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(95, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(95, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(96, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(96, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(96, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(96, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(97, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(97, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(97, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(97, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(98, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(98, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(98, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(98, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(99, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(99, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(99, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(99, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL),
+(100, 1, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 217.475, NULL),
+(100, 2, 1, 1, 1, 107596, 5502, 1, 0, 0, 0, 0, 0, 215.339, NULL),
+(100, 4, 1, 1, 1, 107596, 0, 1, 0, 0, 0, 0, 0, 211.376, NULL),
+(100, 8, 1, 1, 1, 107596, 10052, 1, 0, 0, 0, 0, 0, 203.275, NULL);
+
+ALTER TABLE `creature_template`   
+	ADD COLUMN `Civilian` TINYINT UNSIGNED DEFAULT 0 NOT NULL AFTER `ExperienceModifier`,
+	ADD COLUMN `PetSpellDataId` INT UNSIGNED DEFAULT 0 NOT NULL AFTER `type`;
+
+ALTER TABLE `player_classlevelstats`   
+	ADD COLUMN `spi` SMALLINT NOT NULL COMMENT 'spirit' AFTER `inte`;
+
+ALTER TABLE `player_racestats`   
+	ADD COLUMN `spi` SMALLINT NOT NULL COMMENT 'spirit' AFTER `inte`;