Core/GameObjects: Implement destructible_hitpoint table to store health info about destructible buildings (#29836)

(cherry picked from commit 1f855ef56336c6a7fd74898e9c9beba77828c69b)

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_03_28_01_world_2024_03_27_00_world.sql b/sql/updates/world/cata_classic/2024_03_28_01_world_2024_03_27_00_world.sql
new file mode 100644
index 00000000000..72e570ad1f6
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_28_01_world_2024_03_27_00_world.sql
@@ -0,0 +1,49 @@
+DROP TABLE IF EXISTS `destructible_hitpoint`;
+CREATE TABLE `destructible_hitpoint` (
+  `Id` int unsigned NOT NULL,
+  `IntactNumHits` int unsigned NOT NULL,
+  `DamagedNumHits` int unsigned NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='This table contains data about destructible building health';
+
+INSERT INTO `destructible_hitpoint` (`Id`, `IntactNumHits`, `DamagedNumHits`) VALUES
+(1, 0, 0),
+(3, 50000, 50000),
+(4, 50000, 50000),
+(5, 2000, 9000),
+(6, 4000, 9000),
+(8, 5000, 9000),
+(9, 1000, 0),
+(10, 30000, 0),
+(11, 1000, 0),
+(12, 40000, 40000),
+(13, 5000, 25000),
+(14, 15000, 15000),
+(15, 25000, 0),
+(16, 5000, 25000),
+(18, 50000, 50000),
+(22, 15000, 15000),
+(23, 26000, 26000),
+(25, 100, 0),
+(26, 10, 0),
+(27, 1, 20000),
+(28, 1, 600000),
+(29, 30000, 30000),
+(30, 5000, 5000),
+(31, 19999, 1),
+(32, 1, 600000),
+(34, 0, 0),
+(35, 0, 0),
+(36, 0, 0),
+(37, 0, 0),
+(38, 0, 0),
+(48, 0, 0),
+(49, 0, 0),
+(54, 0, 0),
+(57, 0, 0),
+(58, 0, 0),
+(67, 0, 0),
+(69, 0, 0),
+(72, 0, 0),
+(81, 0, 0),
+(82, 0, 0);