From 737d94d7efe0b6c308ac1bf3692b6aa2e43f5adb Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 25 Jun 2022 22:48:27 +0200 Subject: Core/World: implement database support for default map and realm wide world states Co-Authored-By: Shauren --- sql/updates/world/master/2022_06_25_01_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/master/2022_06_25_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_06_25_01_world.sql b/sql/updates/world/master/2022_06_25_01_world.sql new file mode 100644 index 00000000000..72693acf060 --- /dev/null +++ b/sql/updates/world/master/2022_06_25_01_world.sql @@ -0,0 +1,19 @@ +-- +-- Table structure for table `world_state` +-- +DROP TABLE IF EXISTS `world_state`; +CREATE TABLE `world_state` ( + `ID` int NOT NULL, + `DefaultValue` int NOT NULL, + `MapID` int unsigned DEFAULT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapID`, `Comment`) VALUES +(5644, 0, 669, 'Blackwing Descent - Omnotron Defense System - Achieve-a-tron'), +(5645, 0, 669, 'Blackwing Descent - Omnotron Defense System - Achieve-a-tron'), +(5646, 0, 669, 'Blackwing Descent - Omnotron Defense System - Achieve-a-tron'), +(5647, 0, 669, 'Blackwing Descent - Omnotron Defense System - Achieve-a-tron'), +(5117, 0, 670, 'Grim Batol - Erudax - Don\'t need to Break Eggs to Make an Omelet'); -- cgit v1.2.3