aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2021-06-04 21:18:29 +0200
committerShauren <shauren.trinity@gmail.com>2021-06-04 21:18:29 +0200
commite1f3f1254c3214c0a5b71db6de33f8900903d314 (patch)
tree22d284b13abf3fa99cda418e45307b8f499b1601 /sql
parenta0796179b33dd7042330d245b43e8c91534bf8b3 (diff)
Core/Spells: Load spell label data for future use
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/master/2021_06_04_01_hotfixes.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2021_06_04_01_hotfixes.sql b/sql/updates/hotfixes/master/2021_06_04_01_hotfixes.sql
new file mode 100644
index 00000000000..c0c6e8a73e0
--- /dev/null
+++ b/sql/updates/hotfixes/master/2021_06_04_01_hotfixes.sql
@@ -0,0 +1,14 @@
+--
+-- Table structure for table `spell_label`
+--
+DROP TABLE IF EXISTS `spell_label`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spell_label` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `LabelID` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID` 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 */;