TDB 335.20082 - 2020/08/22

TheGhostGroup · Aug 22, 2020 · ada0e32 · ada0e32
1 parent f17b9b2
commit ada0e32
Show file tree

Hide file tree

Showing 38 changed files with 18 additions and 9 deletions.
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
@@ -9,7 +9,7 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_335.20081_2020_08_15.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.20082_2020_08_22.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-2019 TrinityCore"
  #define VER_FILEVERSION            0,0,0

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
@@ -1972,7 +1972,8 @@ INSERT INTO `updates` VALUES
 ('2020_08_03_00_auth.sql','492CA77C0FAEEEF3E0492121B3A92689373ECFA3','ARCHIVED','2020-08-03 00:00:00',0),
 ('2020_08_03_01_auth.sql','EC1063396CA20A2303D83238470D41EF4439EC72','ARCHIVED','2020-08-03 00:00:01',0),
 ('2020_08_11_00_auth.sql','14C99177E43003D83A4D6F2227722F15FC15A1D0','ARCHIVED','2020-08-11 00:00:00',0),
-('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 09:34:44',0);
+('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 09:34:44',0),
+('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 16:27:26',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2078,4 +2079,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
@@ -2648,7 +2648,8 @@ INSERT INTO `updates` VALUES
 ('2020_05_15_00_characters.sql','F1C2FECAA4EB623560914E7758E0BB8364CA135A','ARCHIVED','2020-05-15 08:55:56',0),
 ('2020_06_15_00_characters.sql','99C4F85580421E928003380D8F992C4EF5E627DF','ARCHIVED','2020-06-15 07:48:08',0),
 ('2020_07_15_00_characters.sql','D87627DC6E4D222F68A1F56F0B3B986EF9A590EF','ARCHIVED','2020-07-15 10:35:41',0),
-('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0);
+('2020_08_15_00_characters.sql','70979D488ACD23DEB8E45D31C3ADC690A1B81F79','ARCHIVED','2020-08-15 09:34:44',0),
+('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2819,4 +2820,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
@@ -3842,14 +3842,14 @@ DROP TABLE IF EXISTS `warden_checks`;
 CREATE TABLE `warden_checks` (
   `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
   `type` tinyint(3) unsigned DEFAULT NULL,
-  `str` varchar(20) DEFAULT NULL,
+  `str` varchar(170) DEFAULT NULL,
   `address` int(10) unsigned DEFAULT NULL,
   `length` tinyint(3) unsigned DEFAULT NULL,
   `comment` varchar(50) DEFAULT NULL,
   `data` binary(24) DEFAULT NULL,
-  `result` varbinary(12) DEFAULT NULL,
+  `result` varbinary(24) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=787 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=791 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3948,4 +3948,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-08-15  9:34:48
+-- Dump completed on 2020-08-22 16:27:28
diff --git a/...updates/auth/3.3.5/2020_08_15_00_auth.sql → ...h/20081_2020_08_22/2020_08_15_00_auth.sql b/...updates/auth/3.3.5/2020_08_15_00_auth.sql → ...h/20081_2020_08_22/2020_08_15_00_auth.sql
diff --git a/...acters/3.3.5/2020_08_15_00_characters.sql → ...1_2020_08_22/2020_08_15_00_characters.sql b/...acters/3.3.5/2020_08_15_00_characters.sql → ...1_2020_08_22/2020_08_15_00_characters.sql
diff --git a/...dates/world/3.3.5/2020_08_15_06_world.sql → .../20081_2020_08_22/2020_08_15_06_world.sql b/...dates/world/3.3.5/2020_08_15_06_world.sql → .../20081_2020_08_22/2020_08_15_06_world.sql
diff --git a/...dates/world/3.3.5/2020_08_16_00_world.sql → .../20081_2020_08_22/2020_08_16_00_world.sql b/...dates/world/3.3.5/2020_08_16_00_world.sql → .../20081_2020_08_22/2020_08_16_00_world.sql
diff --git a/...s/world/3.3.5/2020_08_16_01_world_335.sql → ...81_2020_08_22/2020_08_16_01_world_335.sql b/...s/world/3.3.5/2020_08_16_01_world_335.sql → ...81_2020_08_22/2020_08_16_01_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_16_02_world.sql → .../20081_2020_08_22/2020_08_16_02_world.sql b/...dates/world/3.3.5/2020_08_16_02_world.sql → .../20081_2020_08_22/2020_08_16_02_world.sql
diff --git a/...dates/world/3.3.5/2020_08_16_03_world.sql → .../20081_2020_08_22/2020_08_16_03_world.sql b/...dates/world/3.3.5/2020_08_16_03_world.sql → .../20081_2020_08_22/2020_08_16_03_world.sql
diff --git a/...s/world/3.3.5/2020_08_16_04_world_335.sql → ...81_2020_08_22/2020_08_16_04_world_335.sql b/...s/world/3.3.5/2020_08_16_04_world_335.sql → ...81_2020_08_22/2020_08_16_04_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_16_05_world.sql → .../20081_2020_08_22/2020_08_16_05_world.sql b/...dates/world/3.3.5/2020_08_16_05_world.sql → .../20081_2020_08_22/2020_08_16_05_world.sql
diff --git a/...s/world/3.3.5/2020_08_16_06_world_335.sql → ...81_2020_08_22/2020_08_16_06_world_335.sql b/...s/world/3.3.5/2020_08_16_06_world_335.sql → ...81_2020_08_22/2020_08_16_06_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_16_07_world.sql → .../20081_2020_08_22/2020_08_16_07_world.sql b/...dates/world/3.3.5/2020_08_16_07_world.sql → .../20081_2020_08_22/2020_08_16_07_world.sql
diff --git a/...dates/world/3.3.5/2020_08_17_00_world.sql → .../20081_2020_08_22/2020_08_17_00_world.sql b/...dates/world/3.3.5/2020_08_17_00_world.sql → .../20081_2020_08_22/2020_08_17_00_world.sql
diff --git a/...dates/world/3.3.5/2020_08_17_01_world.sql → .../20081_2020_08_22/2020_08_17_01_world.sql b/...dates/world/3.3.5/2020_08_17_01_world.sql → .../20081_2020_08_22/2020_08_17_01_world.sql
diff --git a/...dates/world/3.3.5/2020_08_17_02_world.sql → .../20081_2020_08_22/2020_08_17_02_world.sql b/...dates/world/3.3.5/2020_08_17_02_world.sql → .../20081_2020_08_22/2020_08_17_02_world.sql
diff --git a/...s/world/3.3.5/2020_08_18_00_world_335.sql → ...81_2020_08_22/2020_08_18_00_world_335.sql b/...s/world/3.3.5/2020_08_18_00_world_335.sql → ...81_2020_08_22/2020_08_18_00_world_335.sql
diff --git a/...s/world/3.3.5/2020_08_18_01_world_335.sql → ...81_2020_08_22/2020_08_18_01_world_335.sql b/...s/world/3.3.5/2020_08_18_01_world_335.sql → ...81_2020_08_22/2020_08_18_01_world_335.sql
diff --git a/...s/world/3.3.5/2020_08_18_02_world_335.sql → ...81_2020_08_22/2020_08_18_02_world_335.sql b/...s/world/3.3.5/2020_08_18_02_world_335.sql → ...81_2020_08_22/2020_08_18_02_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_18_03_world.sql → .../20081_2020_08_22/2020_08_18_03_world.sql b/...dates/world/3.3.5/2020_08_18_03_world.sql → .../20081_2020_08_22/2020_08_18_03_world.sql
diff --git a/...dates/world/3.3.5/2020_08_18_04_world.sql → .../20081_2020_08_22/2020_08_18_04_world.sql b/...dates/world/3.3.5/2020_08_18_04_world.sql → .../20081_2020_08_22/2020_08_18_04_world.sql
diff --git a/...dates/world/3.3.5/2020_08_18_05_world.sql → .../20081_2020_08_22/2020_08_18_05_world.sql b/...dates/world/3.3.5/2020_08_18_05_world.sql → .../20081_2020_08_22/2020_08_18_05_world.sql
diff --git a/...dates/world/3.3.5/2020_08_18_06_world.sql → .../20081_2020_08_22/2020_08_18_06_world.sql b/...dates/world/3.3.5/2020_08_18_06_world.sql → .../20081_2020_08_22/2020_08_18_06_world.sql
diff --git a/...dates/world/3.3.5/2020_08_20_00_world.sql → .../20081_2020_08_22/2020_08_20_00_world.sql b/...dates/world/3.3.5/2020_08_20_00_world.sql → .../20081_2020_08_22/2020_08_20_00_world.sql
diff --git a/...dates/world/3.3.5/2020_08_20_01_world.sql → .../20081_2020_08_22/2020_08_20_01_world.sql b/...dates/world/3.3.5/2020_08_20_01_world.sql → .../20081_2020_08_22/2020_08_20_01_world.sql
diff --git a/...dates/world/3.3.5/2020_08_21_00_world.sql → .../20081_2020_08_22/2020_08_21_00_world.sql b/...dates/world/3.3.5/2020_08_21_00_world.sql → .../20081_2020_08_22/2020_08_21_00_world.sql
diff --git a/...dates/world/3.3.5/2020_08_21_01_world.sql → .../20081_2020_08_22/2020_08_21_01_world.sql b/...dates/world/3.3.5/2020_08_21_01_world.sql → .../20081_2020_08_22/2020_08_21_01_world.sql
diff --git a/...s/world/3.3.5/2020_08_21_02_world_335.sql → ...81_2020_08_22/2020_08_21_02_world_335.sql b/...s/world/3.3.5/2020_08_21_02_world_335.sql → ...81_2020_08_22/2020_08_21_02_world_335.sql
diff --git a/...s/world/3.3.5/2020_08_21_03_world_335.sql → ...81_2020_08_22/2020_08_21_03_world_335.sql b/...s/world/3.3.5/2020_08_21_03_world_335.sql → ...81_2020_08_22/2020_08_21_03_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_21_04_world.sql → .../20081_2020_08_22/2020_08_21_04_world.sql b/...dates/world/3.3.5/2020_08_21_04_world.sql → .../20081_2020_08_22/2020_08_21_04_world.sql
diff --git a/...s/world/3.3.5/2020_08_21_05_world_335.sql → ...81_2020_08_22/2020_08_21_05_world_335.sql b/...s/world/3.3.5/2020_08_21_05_world_335.sql → ...81_2020_08_22/2020_08_21_05_world_335.sql
diff --git a/...dates/world/3.3.5/2020_08_22_00_world.sql → .../20081_2020_08_22/2020_08_22_00_world.sql b/...dates/world/3.3.5/2020_08_22_00_world.sql → .../20081_2020_08_22/2020_08_22_00_world.sql
diff --git a/...dates/world/3.3.5/2020_08_22_01_world.sql → .../20081_2020_08_22/2020_08_22_01_world.sql b/...dates/world/3.3.5/2020_08_22_01_world.sql → .../20081_2020_08_22/2020_08_22_01_world.sql
diff --git a/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_22_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20082 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql b/sql/updates/characters/3.3.5/2020_08_22_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.20082 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2020_08_22_02_world.sql b/sql/updates/world/3.3.5/2020_08_22_02_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.20082 world
+UPDATE `version` SET `db_version`='TDB 335.20082', `cache_id`=20082 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- TDB 335.20082 auth
		UPDATE `updates` SET `state`='ARCHIVED';
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- TDB 335.20082 characters
		UPDATE `updates` SET `state`='ARCHIVED';