From c73ce93f4cf84667d23c2ec7e425f40a845eaf4f Mon Sep 17 00:00:00 2001
From: Traesh <Traesh@users.noreply.github.com>
Date: Sun, 14 May 2017 11:40:55 +0200
Subject: Core/Entities : Basic Conversation Implementation (#18010)

---
 sql/updates/auth/master/2017_05_14_00_auth.sql     |  9 +++++
 .../hotfixes/master/2017_05_14_00_hotfixes.sql     | 14 ++++++++
 sql/updates/world/master/2017_05_14_01_world.sql   | 42 ++++++++++++++++++++++
 3 files changed, 65 insertions(+)
 create mode 100644 sql/updates/auth/master/2017_05_14_00_auth.sql
 create mode 100644 sql/updates/hotfixes/master/2017_05_14_00_hotfixes.sql
 create mode 100644 sql/updates/world/master/2017_05_14_01_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/auth/master/2017_05_14_00_auth.sql b/sql/updates/auth/master/2017_05_14_00_auth.sql
new file mode 100644
index 00000000000..792ba10bc06
--- /dev/null
+++ b/sql/updates/auth/master/2017_05_14_00_auth.sql
@@ -0,0 +1,9 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (853, 854);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(853, 'Command: .reload conversation_template'),
+(854, 'Command: .debug conversation');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 192 AND `linkedId` IN (853, 854);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(192, 853),
+(192, 854);
diff --git a/sql/updates/hotfixes/master/2017_05_14_00_hotfixes.sql b/sql/updates/hotfixes/master/2017_05_14_00_hotfixes.sql
new file mode 100644
index 00000000000..03cd2e19698
--- /dev/null
+++ b/sql/updates/hotfixes/master/2017_05_14_00_hotfixes.sql
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS `conversation_line`;
+CREATE TABLE `conversation_line` (
+  `Id` int (10) UNSIGNED NOT NULL,
+  `BroadcastTextID` int (10) UNSIGNED NOT NULL,
+  `SpellVisualKitID` int (10) UNSIGNED NOT NULL,
+  `Duration` int (10) UNSIGNED NOT NULL,
+  `NextLineID` smallint (5) UNSIGNED NOT NULL,
+  `Unk1` smallint (5) UNSIGNED NOT NULL,
+  `Yell` tinyint (3) UNSIGNED NOT NULL,
+  `Unk2` tinyint (3) UNSIGNED NOT NULL,
+  `Unk3` tinyint (3) UNSIGNED NOT NULL,
+  `VerifiedBuild` int (10) UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/master/2017_05_14_01_world.sql b/sql/updates/world/master/2017_05_14_01_world.sql
new file mode 100644
index 00000000000..b8f19333d39
--- /dev/null
+++ b/sql/updates/world/master/2017_05_14_01_world.sql
@@ -0,0 +1,42 @@
+DROP TABLE IF EXISTS `conversation_template`;
+CREATE TABLE `conversation_template` (
+  `Id` INT (10) UNSIGNED NOT NULL,
+  `FirstLineId` INT (10) UNSIGNED NOT NULL,
+  `LastLineEndTime` INT (10) UNSIGNED NOT NULL,
+  `VerifiedBuild` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `conversation_actor_template`;
+CREATE TABLE `conversation_actor_template` (
+  `Id` INT (10) UNSIGNED NOT NULL,
+  `CreatureId` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  `CreatureModelId` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  `VerifiedBuild` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `conversation_line_template`;
+CREATE TABLE `conversation_line_template` (
+  `Id` INT (10) UNSIGNED NOT NULL,
+  `StartTime` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  `UiCameraID` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  `ActorIdx` SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0,
+  `Unk` SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0,
+  `VerifiedBuild` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `conversation_actors`;
+CREATE TABLE `conversation_actors` (
+  `ConversationId` INT (10) UNSIGNED NOT NULL,
+  `ConversationActorId` INT (10) UNSIGNED NOT NULL,
+  `Idx` SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0,
+  `VerifiedBuild` INT (10) UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`ConversationId`, `ConversationActorId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DELETE FROM `command` WHERE `name` IN ('debug conversation', 'reload conversation_template');
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('debug conversation', 854, 'Syntax: .debug conversation $conversationId\r\nPlay given conversation.'),
+('reload conversation_template', 853, 'Syntax: .reload conversation_template\r\nReload conversation tables.');
-- 
cgit v1.2.3