aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql9
-rw-r--r--sql/base/characters_database.sql9
-rw-r--r--sql/base/dev/world_database.sql8
3 files changed, 14 insertions, 12 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 5ab0f5d41c3..bbe907094e6 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.26
+-- Server version 8.0.28-0ubuntu0.20.04.3
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1999,7 +1999,8 @@ INSERT INTO `updates` VALUES
('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0),
('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','ARCHIVED','2022-01-01 19:35:19',0),
('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0),
-('2022_02_16_00_auth.sql','CFB54EB37319916B1B80E29F5572D12A7D9A33F5','ARCHIVED','2022-02-16 21:52:01',0);
+('2022_02_16_00_auth.sql','CFB54EB37319916B1B80E29F5572D12A7D9A33F5','ARCHIVED','2022-02-16 21:52:01',0),
+('2022_04_14_00_auth.sql','B1ED102EB7C9A2A0BDA866201960E70CCCA22FB5','ARCHIVED','2022-04-14 16:24:35',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2138,4 +2139,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 2022-02-16 21:52:04
+-- Dump completed on 2022-04-14 16:24:38
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index d37088cbf06..3544c1aaa4b 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.26
+-- Server version 8.0.28-0ubuntu0.20.04.3
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2672,7 +2672,8 @@ INSERT INTO `updates` VALUES
('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0),
('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0),
('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0),
-('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0);
+('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0),
+('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2843,4 +2844,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-02-16 21:52:04
+-- Dump completed on 2022-04-14 16:24:38
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index b51d070b22a..0be4a3a500c 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.28, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.26
+-- Server version 8.0.28-0ubuntu0.20.04.3
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1444,7 +1444,7 @@ CREATE TABLE `gossip_menu_option` (
`BoxMoney` int unsigned NOT NULL DEFAULT '0',
`BoxText` text,
`BoxBroadcastTextID` mediumint NOT NULL DEFAULT '0',
- `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`MenuID`,`OptionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4061,4 +4061,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2022-02-16 21:52:05
+-- Dump completed on 2022-04-14 16:24:40