From 94b14e4f6355a7bab8004dcc2ecadadbc52833de Mon Sep 17 00:00:00 2001 From: ModoX Date: Tue, 26 Oct 2021 22:49:12 +0200 Subject: Core/Conversations: Dropped time fields and calculate them using db2 data (#27151) --- sql/updates/hotfixes/master/2021_10_26_00_hotfixes.sql | 15 +++++++++++++++ sql/updates/world/master/2021_10_26_00_world.sql | 3 +++ 2 files changed, 18 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_10_26_00_hotfixes.sql create mode 100644 sql/updates/world/master/2021_10_26_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/master/2021_10_26_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_10_26_00_hotfixes.sql new file mode 100644 index 00000000000..54c1a8b9390 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_10_26_00_hotfixes.sql @@ -0,0 +1,15 @@ +-- +-- Table structure for table `broadcast_text_duration` +-- +DROP TABLE IF EXISTS `broadcast_text_duration`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `broadcast_text_duration` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID` int(11) NOT NULL DEFAULT '0', + `Locale` int(11) NOT NULL DEFAULT '0', + `Duration` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/world/master/2021_10_26_00_world.sql b/sql/updates/world/master/2021_10_26_00_world.sql new file mode 100644 index 00000000000..e1f10ae3f5c --- /dev/null +++ b/sql/updates/world/master/2021_10_26_00_world.sql @@ -0,0 +1,3 @@ +-- +ALTER TABLE `conversation_line_template` DROP `StartTime`; +ALTER TABLE `conversation_template` DROP `LastLineEndTime`; -- cgit v1.2.3