diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 2 |
3 files changed, 8 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index b9c7059bef4..e4cf60dd272 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -341,7 +341,7 @@ CREATE TABLE `logs_ip_actions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID', `character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid', - `realm_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Realm ID', + `realm_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Realm ID', `type` tinyint(3) unsigned NOT NULL, `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', `systemnote` text COMMENT 'Notes inserted by system', @@ -1961,7 +1961,8 @@ INSERT INTO `updates` VALUES ('2020_03_16_00_auth.sql','B27E4CE14C713C73216930A7F3F770786D902A3F','ARCHIVED','2020-03-16 08:47:49',0), ('2020_04_07_00_auth.sql','6D73A4E1EC5382F10C39F20E2E6E764510A8A5E6','ARCHIVED','2020-04-07 22:23:35',0), ('2020_04_15_00_auth.sql','031E61B50B03E40406F07C196826DB9016A7203F','ARCHIVED','2020-04-15 11:03:56',0), -('2020_04_18_00_auth.sql','BD962B50760771B60F2785027D6957EEF2009240','ARCHIVED','2020-04-18 14:09:28',0); +('2020_04_18_00_auth.sql','BD962B50760771B60F2785027D6957EEF2009240','ARCHIVED','2020-04-18 14:09:28',0), +('2020_05_15_00_auth.sql','765389B45F97A02160A58B373D63166F7F7D4427','ARCHIVED','2020-05-15 08:55:56',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2063,4 +2064,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-04-15 11:03:58 +-- Dump completed on 2020-05-15 8:55:59 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0b7337e9339..35acdc0a6c6 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2644,7 +2644,8 @@ INSERT INTO `updates` VALUES ('2020_01_15_00_characters.sql','CCA31041B25FC4BD631D07BB2E42B3C8F32465F0','ARCHIVED','2020-01-15 07:45:18',0), ('2020_02_15_00_characters.sql','645EDA60CDD479B3D1E78D2D89DAB5D6EA1FB7BC','ARCHIVED','2020-02-15 17:36:05',0), ('2020_03_16_00_characters.sql','A38437DA80F6A5D35958A09CFC74EE1CDC465BA8','ARCHIVED','2020-03-16 08:47:49',0), -('2020_04_15_00_characters.sql','61F7DE3B81C7E479FFF9463A39DF568826926F39','ARCHIVED','2020-04-15 11:03:56',0); +('2020_04_15_00_characters.sql','61F7DE3B81C7E479FFF9463A39DF568826926F39','ARCHIVED','2020-04-15 11:03:56',0), +('2020_05_15_00_characters.sql','F1C2FECAA4EB623560914E7758E0BB8364CA135A','ARCHIVED','2020-05-15 08:55:56',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2811,4 +2812,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-04-15 11:03:58 +-- Dump completed on 2020-05-15 8:55:59 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 7b44412205a..dcea43af321 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -3863,4 +3863,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-04-15 11:03:58 +-- Dump completed on 2020-05-15 8:56:00 |