From 06b9be494a7e4d1249d11550cc0eec2e35712d25 Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Wed, 17 Nov 2021 13:31:04 +0000
Subject: TDB 915.21111 - 2021/11/17

---
 sql/base/auth_database.sql | 37 +++++++++++++++++++------------------
 1 file changed, 19 insertions(+), 18 deletions(-)

(limited to 'sql/base/auth_database.sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 2c71e98a497..8dfa767df28 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.35, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.36, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	5.7.35
+-- Server version	5.7.36
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -205,16 +205,16 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `battle_pet_declinedname`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `battle_pet_declinedname` (
-  `guid` bigint NOT NULL,
+  `guid` bigint(20) NOT NULL,
   `genitive` varchar(12) NOT NULL DEFAULT '',
   `dative` varchar(12) NOT NULL DEFAULT '',
   `accusative` varchar(12) NOT NULL DEFAULT '',
   `instrumental` varchar(12) NOT NULL DEFAULT '',
   `prepositional` varchar(12) NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`),
-  CONSTRAINT `fk_battle_pet__battle_pet_declinedname` FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`) ON DELETE RESTRICT ON UPDATE RESTRICT
+  CONSTRAINT `fk_battle_pet__battle_pet_declinedname` FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -226,7 +226,6 @@ LOCK TABLES `battle_pet_declinedname` WRITE;
 /*!40000 ALTER TABLE `battle_pet_declinedname` DISABLE KEYS */;
 /*!40000 ALTER TABLE `battle_pet_declinedname` ENABLE KEYS */;
 UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 --
 -- Table structure for table `battle_pet_slots`
@@ -1240,6 +1239,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,872),
 (196,873),
 (196,881),
+(196,882),
 (197,232),
 (197,236),
 (197,237),
@@ -2374,9 +2374,9 @@ INSERT INTO `updates` VALUES
 ('2018_06_22_00_auth.sql','9DA24F70B8A365AFDEF58A9B578255CDEDFCA47C','ARCHIVED','2018-06-22 17:45:45',0),
 ('2018_06_23_00_auth.sql','BE35312C386A127D047E5A7CE0D14DB41D905F8E','ARCHIVED','2018-06-23 00:00:00',0),
 ('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','ARCHIVED','2018-06-29 22:34:04',0),
-('2018_08_30_00_auth.sql','22F69864361D3E72F800379338310172C0576D1C','RELEASED','2018-08-30 00:00:00',0),
+('2018_08_30_00_auth.sql','22F69864361D3E72F800379338310172C0576D1C','ARCHIVED','2018-08-30 00:00:00',0),
 ('2018_09_06_00_auth.sql','309D21E0DF82ED8921F77EAFDE741F38AC32BB13','ARCHIVED','2018-09-06 00:00:00',0),
-('2018_09_17_00_auth.sql','4DB671F0A4FA1A93AF28FB6426AF13DE72C7DA3D','RELEASED','2018-09-17 00:00:00',0),
+('2018_09_17_00_auth.sql','4DB671F0A4FA1A93AF28FB6426AF13DE72C7DA3D','ARCHIVED','2018-09-17 00:00:00',0),
 ('2018_12_09_00_auth_2017_01_06_00_auth.sql','6CCFE6A9774EC733C9863D36A0F15F3534189BBD','ARCHIVED','2017-01-06 00:00:00',0),
 ('2018_12_09_01_auth.sql','576C2A11BE671D8420FA3EB705E594E381ECCC56','ARCHIVED','2018-12-09 14:49:17',0),
 ('2019_06_08_00_auth.sql','EA5A78F5A26C17BC790481EA9B3772D3A6912459','ARCHIVED','2019-05-20 17:21:20',0),
@@ -2444,15 +2444,16 @@ INSERT INTO `updates` VALUES
 ('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','ARCHIVED','2021-10-07 10:32:05',0),
 ('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','ARCHIVED','2021-10-13 21:15:05',0),
 ('2021_10_15_00_auth.sql','C8AA212AB2BB2DB5B3C2C9622A3874475AEFBD7B','ARCHIVED','2021-10-15 10:11:47',0),
-('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0),
-('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','RELEASED','2021-10-16 11:24:39',0),
-('2021_10_22_00_auth.sql','6F55BAD44B9299BE23F79DB09AA90CB42AA63A00','RELEASED','2021-10-10 17:23:09',0),
-('2021_10_23_00_auth.sql','97A8F2C2CEDB99C942D38F5B65DAD1DC11296E20','RELEASED','2021-10-23 00:00:00',0),
-('2021_10_26_00_auth.sql','91E8B308267847569D9A669BC34794F154242ECF','RELEASED','2021-10-26 00:41:04',0),
-('2021_11_05_00_auth.sql','4A4510436578B6486E8399602D3060376E96A8C7','RELEASED','2021-11-05 00:33:00',0),
-('2021_11_06_00_auth.sql','3646F9356429CCE7C1CECC7D9BA7960E011C7B6B','RELEASED','2021-11-06 11:54:12',0),
-('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','RELEASED','2021-11-10 14:07:05',0),
-('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','RELEASED','2021-11-12 12:17:24',0);
+('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','ARCHIVED','2021-10-16 00:15:25',0),
+('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','ARCHIVED','2021-10-16 11:24:39',0),
+('2021_10_22_00_auth.sql','07D7397061A5A906357DC6E91FC33C74638EFDC3','ARCHIVED','2021-11-17 13:21:03',0),
+('2021_10_23_00_auth.sql','97A8F2C2CEDB99C942D38F5B65DAD1DC11296E20','ARCHIVED','2021-10-23 00:00:00',0),
+('2021_10_26_00_auth.sql','91E8B308267847569D9A669BC34794F154242ECF','ARCHIVED','2021-10-26 00:41:04',0),
+('2021_11_05_00_auth.sql','4A4510436578B6486E8399602D3060376E96A8C7','ARCHIVED','2021-11-05 00:33:00',0),
+('2021_11_06_00_auth.sql','3646F9356429CCE7C1CECC7D9BA7960E011C7B6B','ARCHIVED','2021-11-06 11:54:12',0),
+('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','ARCHIVED','2021-11-10 14:07:05',0),
+('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','ARCHIVED','2021-11-12 12:17:24',0),
+('2021_11_17_00_auth.sql','298DA8468B30042B15FA17A90325C72879DF6D8E','ARCHIVED','2021-11-17 13:23:17',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2525,4 +2526,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-10-15 10:11:48
+-- Dump completed on 2021-11-17 13:23:18
-- 
cgit v1.2.3

