diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2025-07-19 13:16:46 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-07-19 13:16:46 +0200 |
| commit | 129434bb42cc1169247e94df2f67406bc31777fc (patch) | |
| tree | f33c4135e20b2dfe942cc30561e6b300cdf5d8fa /data/sql/base/db_characters | |
| parent | 3ca377fed39a53f047fdbe45005401773be06af6 (diff) | |
feat(DB): Release ACDB 13.0.0 (#22508)
Diffstat (limited to 'data/sql/base/db_characters')
106 files changed, 778 insertions, 688 deletions
diff --git a/data/sql/base/db_characters/account_data.sql b/data/sql/base/db_characters/account_data.sql index 8806023022..9445aaf63d 100644 --- a/data/sql/base/db_characters/account_data.sql +++ b/data/sql/base/db_characters/account_data.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:57 - +-- Dump completed on 2025-07-19 12:09:53 diff --git a/data/sql/base/db_characters/account_instance_times.sql b/data/sql/base/db_characters/account_instance_times.sql index fae461c21f..2dd1f4dcb8 100644 --- a/data/sql/base/db_characters/account_instance_times.sql +++ b/data/sql/base/db_characters/account_instance_times.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:57 - +-- Dump completed on 2025-07-19 12:09:54 diff --git a/data/sql/base/db_characters/account_tutorial.sql b/data/sql/base/db_characters/account_tutorial.sql index f26020ab3c..677a6041e9 100644 --- a/data/sql/base/db_characters/account_tutorial.sql +++ b/data/sql/base/db_characters/account_tutorial.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -51,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:57 - +-- Dump completed on 2025-07-19 12:09:54 diff --git a/data/sql/base/db_characters/active_arena_season.sql b/data/sql/base/db_characters/active_arena_season.sql new file mode 100644 index 0000000000..057318a44a --- /dev/null +++ b/data/sql/base/db_characters/active_arena_season.sql @@ -0,0 +1,48 @@ +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) +-- +-- Host: localhost Database: acore_characters +-- ------------------------------------------------------ +-- Server version 8.4.3 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `active_arena_season` +-- + +DROP TABLE IF EXISTS `active_arena_season`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `active_arena_season` ( + `season_id` tinyint unsigned NOT NULL, + `season_state` tinyint unsigned NOT NULL COMMENT 'Supported 2 states: 0 - disabled; 1 - in progress.' +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `active_arena_season` +-- + +LOCK TABLES `active_arena_season` WRITE; +/*!40000 ALTER TABLE `active_arena_season` DISABLE KEYS */; +INSERT INTO `active_arena_season` VALUES +(8,1); +/*!40000 ALTER TABLE `active_arena_season` ENABLE KEYS */; +UNLOCK TABLES; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2025-07-19 12:09:54 diff --git a/data/sql/base/db_characters/addons.sql b/data/sql/base/db_characters/addons.sql index 9eaffd51e3..7674571b79 100644 --- a/data/sql/base/db_characters/addons.sql +++ b/data/sql/base/db_characters/addons.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -68,5 +68,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:54 diff --git a/data/sql/base/db_characters/arena_team.sql b/data/sql/base/db_characters/arena_team.sql index d15cdaea88..a63dc14886 100644 --- a/data/sql/base/db_characters/arena_team.sql +++ b/data/sql/base/db_characters/arena_team.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -57,5 +57,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:55 diff --git a/data/sql/base/db_characters/arena_team_member.sql b/data/sql/base/db_characters/arena_team_member.sql index 5d335a591a..631b62bb4b 100644 --- a/data/sql/base/db_characters/arena_team_member.sql +++ b/data/sql/base/db_characters/arena_team_member.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -49,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:55 diff --git a/data/sql/base/db_characters/auctionhouse.sql b/data/sql/base/db_characters/auctionhouse.sql index b5e648a74e..6870fe1aec 100644 --- a/data/sql/base/db_characters/auctionhouse.sql +++ b/data/sql/base/db_characters/auctionhouse.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -32,7 +32,6 @@ CREATE TABLE `auctionhouse` ( `startbid` int unsigned NOT NULL DEFAULT '0', `deposit` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), - UNIQUE KEY `item_guid` (`itemguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -54,5 +53,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:55 diff --git a/data/sql/base/db_characters/banned_addons.sql b/data/sql/base/db_characters/banned_addons.sql index 5133d1b88e..8907ea8daa 100644 --- a/data/sql/base/db_characters/banned_addons.sql +++ b/data/sql/base/db_characters/banned_addons.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `banned_addons` ( `Version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), - UNIQUE KEY `idx_name_ver` (`Name`,`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:55 diff --git a/data/sql/base/db_characters/battleground_deserters.sql b/data/sql/base/db_characters/battleground_deserters.sql index 2f2c126f86..47242ec766 100644 --- a/data/sql/base/db_characters/battleground_deserters.sql +++ b/data/sql/base/db_characters/battleground_deserters.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -44,5 +44,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:58 - +-- Dump completed on 2025-07-19 12:09:56 diff --git a/data/sql/base/db_characters/bugreport.sql b/data/sql/base/db_characters/bugreport.sql index 6ba8213917..7cc3c82cfd 100644 --- a/data/sql/base/db_characters/bugreport.sql +++ b/data/sql/base/db_characters/bugreport.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:56 diff --git a/data/sql/base/db_characters/calendar_events.sql b/data/sql/base/db_characters/calendar_events.sql index 0cca5619c5..60d415c66d 100644 --- a/data/sql/base/db_characters/calendar_events.sql +++ b/data/sql/base/db_characters/calendar_events.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -51,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:56 diff --git a/data/sql/base/db_characters/calendar_invites.sql b/data/sql/base/db_characters/calendar_invites.sql index 169ba8679f..41a4c4b609 100644 --- a/data/sql/base/db_characters/calendar_invites.sql +++ b/data/sql/base/db_characters/calendar_invites.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -50,5 +50,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:56 diff --git a/data/sql/base/db_characters/channels.sql b/data/sql/base/db_characters/channels.sql index 58b910d068..c8feaffdb6 100644 --- a/data/sql/base/db_characters/channels.sql +++ b/data/sql/base/db_characters/channels.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -49,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:57 diff --git a/data/sql/base/db_characters/channels_bans.sql b/data/sql/base/db_characters/channels_bans.sql index 30c3197511..0eea1be063 100644 --- a/data/sql/base/db_characters/channels_bans.sql +++ b/data/sql/base/db_characters/channels_bans.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:57 diff --git a/data/sql/base/db_characters/channels_rights.sql b/data/sql/base/db_characters/channels_rights.sql index 85217a1814..d9a9c0df65 100644 --- a/data/sql/base/db_characters/channels_rights.sql +++ b/data/sql/base/db_characters/channels_rights.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:57 diff --git a/data/sql/base/db_characters/character_account_data.sql b/data/sql/base/db_characters/character_account_data.sql index d779bb7a4b..3da7884147 100644 --- a/data/sql/base/db_characters/character_account_data.sql +++ b/data/sql/base/db_characters/character_account_data.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:32:59 - +-- Dump completed on 2025-07-19 12:09:57 diff --git a/data/sql/base/db_characters/character_achievement.sql b/data/sql/base/db_characters/character_achievement.sql index 93a849b96d..a10aa19639 100644 --- a/data/sql/base/db_characters/character_achievement.sql +++ b/data/sql/base/db_characters/character_achievement.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:58 diff --git a/data/sql/base/db_characters/character_achievement_offline_updates.sql b/data/sql/base/db_characters/character_achievement_offline_updates.sql index ec1dbc227e..6264755e5d 100644 --- a/data/sql/base/db_characters/character_achievement_offline_updates.sql +++ b/data/sql/base/db_characters/character_achievement_offline_updates.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:58 diff --git a/data/sql/base/db_characters/character_achievement_progress.sql b/data/sql/base/db_characters/character_achievement_progress.sql index 7e72e39890..ac9b50fca7 100644 --- a/data/sql/base/db_characters/character_achievement_progress.sql +++ b/data/sql/base/db_characters/character_achievement_progress.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:58 diff --git a/data/sql/base/db_characters/character_action.sql b/data/sql/base/db_characters/character_action.sql index 039b0599ce..bd68ff8cd0 100644 --- a/data/sql/base/db_characters/character_action.sql +++ b/data/sql/base/db_characters/character_action.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:58 diff --git a/data/sql/base/db_characters/character_arena_stats.sql b/data/sql/base/db_characters/character_arena_stats.sql index beeb425f71..866e4f98bf 100644 --- a/data/sql/base/db_characters/character_arena_stats.sql +++ b/data/sql/base/db_characters/character_arena_stats.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:59 diff --git a/data/sql/base/db_characters/character_aura.sql b/data/sql/base/db_characters/character_aura.sql index bbad6c0eab..b066b961ab 100644 --- a/data/sql/base/db_characters/character_aura.sql +++ b/data/sql/base/db_characters/character_aura.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -58,5 +58,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:00 - +-- Dump completed on 2025-07-19 12:09:59 diff --git a/data/sql/base/db_characters/character_banned.sql b/data/sql/base/db_characters/character_banned.sql index 5b6a4ebd0a..71970dd328 100644 --- a/data/sql/base/db_characters/character_banned.sql +++ b/data/sql/base/db_characters/character_banned.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:09:59 diff --git a/data/sql/base/db_characters/character_battleground_random.sql b/data/sql/base/db_characters/character_battleground_random.sql index 37fc14547a..21a566f41d 100644 --- a/data/sql/base/db_characters/character_battleground_random.sql +++ b/data/sql/base/db_characters/character_battleground_random.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -43,5 +43,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:09:59 diff --git a/data/sql/base/db_characters/character_brew_of_the_month.sql b/data/sql/base/db_characters/character_brew_of_the_month.sql index 46290bd849..f26b530808 100644 --- a/data/sql/base/db_characters/character_brew_of_the_month.sql +++ b/data/sql/base/db_characters/character_brew_of_the_month.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -44,5 +44,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:09:59 diff --git a/data/sql/base/db_characters/character_declinedname.sql b/data/sql/base/db_characters/character_declinedname.sql index e167439ee3..37df069925 100644 --- a/data/sql/base/db_characters/character_declinedname.sql +++ b/data/sql/base/db_characters/character_declinedname.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:10:00 diff --git a/data/sql/base/db_characters/character_entry_point.sql b/data/sql/base/db_characters/character_entry_point.sql index 30f0c7da9b..dfd53261a1 100644 --- a/data/sql/base/db_characters/character_entry_point.sql +++ b/data/sql/base/db_characters/character_entry_point.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -51,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:10:00 diff --git a/data/sql/base/db_characters/character_equipmentsets.sql b/data/sql/base/db_characters/character_equipmentsets.sql index f12e1f2711..1e59f5ef31 100644 --- a/data/sql/base/db_characters/character_equipmentsets.sql +++ b/data/sql/base/db_characters/character_equipmentsets.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,9 +47,7 @@ CREATE TABLE `character_equipmentsets` ( `item17` int unsigned NOT NULL DEFAULT '0', `item18` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`setguid`), - UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), - KEY `Idx_setindex` (`setindex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -71,5 +69,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:01 - +-- Dump completed on 2025-07-19 12:10:00 diff --git a/data/sql/base/db_characters/character_gifts.sql b/data/sql/base/db_characters/character_gifts.sql index 85fc330bde..8802c3a42a 100644 --- a/data/sql/base/db_characters/character_gifts.sql +++ b/data/sql/base/db_characters/character_gifts.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `character_gifts` ( `entry` int unsigned NOT NULL DEFAULT '0', `flags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:00 diff --git a/data/sql/base/db_characters/character_glyphs.sql b/data/sql/base/db_characters/character_glyphs.sql index 403785a558..785884e620 100644 --- a/data/sql/base/db_characters/character_glyphs.sql +++ b/data/sql/base/db_characters/character_glyphs.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -50,5 +50,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:01 diff --git a/data/sql/base/db_characters/character_homebind.sql b/data/sql/base/db_characters/character_homebind.sql index 913adabbc4..4514ad1c94 100644 --- a/data/sql/base/db_characters/character_homebind.sql +++ b/data/sql/base/db_characters/character_homebind.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:01 diff --git a/data/sql/base/db_characters/character_instance.sql b/data/sql/base/db_characters/character_instance.sql index 7c9c2ec202..9e25243d56 100644 --- a/data/sql/base/db_characters/character_instance.sql +++ b/data/sql/base/db_characters/character_instance.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `character_instance` ( `permanent` tinyint unsigned NOT NULL DEFAULT '0', `extended` tinyint unsigned NOT NULL, PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:01 diff --git a/data/sql/base/db_characters/character_inventory.sql b/data/sql/base/db_characters/character_inventory.sql index cdf16e4376..fdc821677c 100644 --- a/data/sql/base/db_characters/character_inventory.sql +++ b/data/sql/base/db_characters/character_inventory.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,9 +26,7 @@ CREATE TABLE `character_inventory` ( `slot` tinyint unsigned NOT NULL DEFAULT '0', `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), - UNIQUE KEY `guid` (`guid`,`bag`,`slot`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -50,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:01 diff --git a/data/sql/base/db_characters/character_pet.sql b/data/sql/base/db_characters/character_pet.sql index a632023196..165cb50dd6 100644 --- a/data/sql/base/db_characters/character_pet.sql +++ b/data/sql/base/db_characters/character_pet.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -39,9 +39,7 @@ CREATE TABLE `character_pet` ( `savetime` int unsigned NOT NULL DEFAULT '0', `abdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), - KEY `owner` (`owner`), - KEY `idx_slot` (`slot`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -63,5 +61,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:02 diff --git a/data/sql/base/db_characters/character_pet_declinedname.sql b/data/sql/base/db_characters/character_pet_declinedname.sql index 7564ca1e18..84fd15e481 100644 --- a/data/sql/base/db_characters/character_pet_declinedname.sql +++ b/data/sql/base/db_characters/character_pet_declinedname.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -29,7 +29,6 @@ CREATE TABLE `character_pet_declinedname` ( `instrumental` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `prepositional` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), - KEY `owner_key` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -51,5 +50,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:02 - +-- Dump completed on 2025-07-19 12:10:02 diff --git a/data/sql/base/db_characters/character_queststatus.sql b/data/sql/base/db_characters/character_queststatus.sql index 75a2eb4be2..23997ded7b 100644 --- a/data/sql/base/db_characters/character_queststatus.sql +++ b/data/sql/base/db_characters/character_queststatus.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -58,5 +58,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:02 diff --git a/data/sql/base/db_characters/character_queststatus_daily.sql b/data/sql/base/db_characters/character_queststatus_daily.sql index 6cb599aee1..bdaa333460 100644 --- a/data/sql/base/db_characters/character_queststatus_daily.sql +++ b/data/sql/base/db_characters/character_queststatus_daily.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -25,7 +25,6 @@ CREATE TABLE `character_queststatus_daily` ( `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `time` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -47,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:02 diff --git a/data/sql/base/db_characters/character_queststatus_monthly.sql b/data/sql/base/db_characters/character_queststatus_monthly.sql index 44c70ff1a1..a5bc77b251 100644 --- a/data/sql/base/db_characters/character_queststatus_monthly.sql +++ b/data/sql/base/db_characters/character_queststatus_monthly.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -24,7 +24,6 @@ CREATE TABLE `character_queststatus_monthly` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -46,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:03 diff --git a/data/sql/base/db_characters/character_queststatus_rewarded.sql b/data/sql/base/db_characters/character_queststatus_rewarded.sql index 5b43ca78a0..0f02cf5a2f 100644 --- a/data/sql/base/db_characters/character_queststatus_rewarded.sql +++ b/data/sql/base/db_characters/character_queststatus_rewarded.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:03 diff --git a/data/sql/base/db_characters/character_queststatus_seasonal.sql b/data/sql/base/db_characters/character_queststatus_seasonal.sql index ae0b19b270..8dfac8aea6 100644 --- a/data/sql/base/db_characters/character_queststatus_seasonal.sql +++ b/data/sql/base/db_characters/character_queststatus_seasonal.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -25,7 +25,6 @@ CREATE TABLE `character_queststatus_seasonal` ( `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `event` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -47,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:03 diff --git a/data/sql/base/db_characters/character_queststatus_weekly.sql b/data/sql/base/db_characters/character_queststatus_weekly.sql index f8258dc55d..22ce0ffd96 100644 --- a/data/sql/base/db_characters/character_queststatus_weekly.sql +++ b/data/sql/base/db_characters/character_queststatus_weekly.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -24,7 +24,6 @@ CREATE TABLE `character_queststatus_weekly` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), - KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -46,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:03 - +-- Dump completed on 2025-07-19 12:10:03 diff --git a/data/sql/base/db_characters/character_reputation.sql b/data/sql/base/db_characters/character_reputation.sql index e5ec25de58..2f1e096d09 100644 --- a/data/sql/base/db_characters/character_reputation.sql +++ b/data/sql/base/db_characters/character_reputation.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:03 diff --git a/data/sql/base/db_characters/character_settings.sql b/data/sql/base/db_characters/character_settings.sql index fabf25ca8a..edb649168e 100644 --- a/data/sql/base/db_characters/character_settings.sql +++ b/data/sql/base/db_characters/character_settings.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:04 diff --git a/data/sql/base/db_characters/character_skills.sql b/data/sql/base/db_characters/character_skills.sql index 1634c8922b..6dc1be0f9a 100644 --- a/data/sql/base/db_characters/character_skills.sql +++ b/data/sql/base/db_characters/character_skills.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:04 diff --git a/data/sql/base/db_characters/character_social.sql b/data/sql/base/db_characters/character_social.sql index 7e0a0b7db7..df6a6c52a5 100644 --- a/data/sql/base/db_characters/character_social.sql +++ b/data/sql/base/db_characters/character_social.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `character_social` ( `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', `note` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), - KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:04 diff --git a/data/sql/base/db_characters/character_spell.sql b/data/sql/base/db_characters/character_spell.sql index 8a1c35129f..842eed0163 100644 --- a/data/sql/base/db_characters/character_spell.sql +++ b/data/sql/base/db_characters/character_spell.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:04 diff --git a/data/sql/base/db_characters/character_spell_cooldown.sql b/data/sql/base/db_characters/character_spell_cooldown.sql index bd26556325..dcecb5b1c1 100644 --- a/data/sql/base/db_characters/character_spell_cooldown.sql +++ b/data/sql/base/db_characters/character_spell_cooldown.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:04 - +-- Dump completed on 2025-07-19 12:10:05 diff --git a/data/sql/base/db_characters/character_stats.sql b/data/sql/base/db_characters/character_stats.sql index e2efc43ffc..70745e05f4 100644 --- a/data/sql/base/db_characters/character_stats.sql +++ b/data/sql/base/db_characters/character_stats.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -53,7 +53,6 @@ CREATE TABLE `character_stats` ( `spellPower` int unsigned NOT NULL DEFAULT '0', `resilience` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), - CONSTRAINT `character_stats_chk_1` CHECK (((`blockPct` >= 0) and (`dodgePct` >= 0) and (`parryPct` >= 0) and (`critPct` >= 0) and (`rangedCritPct` >= 0) and (`spellCritPct` >= 0))) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -75,5 +74,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:05 diff --git a/data/sql/base/db_characters/character_talent.sql b/data/sql/base/db_characters/character_talent.sql index 26cd14018e..906765a967 100644 --- a/data/sql/base/db_characters/character_talent.sql +++ b/data/sql/base/db_characters/character_talent.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:05 diff --git a/data/sql/base/db_characters/characters.sql b/data/sql/base/db_characters/characters.sql index a8561f9284..63f8b110f8 100644 --- a/data/sql/base/db_characters/characters.sql +++ b/data/sql/base/db_characters/characters.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -102,11 +102,8 @@ CREATE TABLE `characters` ( `innTriggerId` int unsigned NOT NULL, `extraBonusTalentCount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), - KEY `idx_account` (`account`), - KEY `idx_online` (`online`), - KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -128,5 +125,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:05 diff --git a/data/sql/base/db_characters/corpse.sql b/data/sql/base/db_characters/corpse.sql index 4ad358f537..c490a7908a 100644 --- a/data/sql/base/db_characters/corpse.sql +++ b/data/sql/base/db_characters/corpse.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -39,11 +39,8 @@ CREATE TABLE `corpse` ( `corpseType` tinyint unsigned NOT NULL DEFAULT '0', `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`), - KEY `idx_type` (`corpseType`), - KEY `idx_instance` (`instanceId`), - KEY `idx_time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Death System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -65,5 +62,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:06 diff --git a/data/sql/base/db_characters/creature_respawn.sql b/data/sql/base/db_characters/creature_respawn.sql index 4aab398371..8281a3adbc 100644 --- a/data/sql/base/db_characters/creature_respawn.sql +++ b/data/sql/base/db_characters/creature_respawn.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `creature_respawn` ( `mapId` smallint unsigned NOT NULL DEFAULT '0', `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), - KEY `idx_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Grid Loading System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:06 diff --git a/data/sql/base/db_characters/game_event_condition_save.sql b/data/sql/base/db_characters/game_event_condition_save.sql index 61e8941d80..4c1be65d74 100644 --- a/data/sql/base/db_characters/game_event_condition_save.sql +++ b/data/sql/base/db_characters/game_event_condition_save.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:05 - +-- Dump completed on 2025-07-19 12:10:06 diff --git a/data/sql/base/db_characters/game_event_save.sql b/data/sql/base/db_characters/game_event_save.sql index a4bc8a71e5..c986c8552f 100644 --- a/data/sql/base/db_characters/game_event_save.sql +++ b/data/sql/base/db_characters/game_event_save.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:06 diff --git a/data/sql/base/db_characters/gameobject_respawn.sql b/data/sql/base/db_characters/gameobject_respawn.sql index 6bfad054c5..b0d114e66e 100644 --- a/data/sql/base/db_characters/gameobject_respawn.sql +++ b/data/sql/base/db_characters/gameobject_respawn.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `gameobject_respawn` ( `mapId` smallint unsigned NOT NULL DEFAULT '0', `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), - KEY `idx_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Grid Loading System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:06 diff --git a/data/sql/base/db_characters/gm_subsurvey.sql b/data/sql/base/db_characters/gm_subsurvey.sql index 630f1f045b..4ad05042af 100644 --- a/data/sql/base/db_characters/gm_subsurvey.sql +++ b/data/sql/base/db_characters/gm_subsurvey.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:07 diff --git a/data/sql/base/db_characters/gm_survey.sql b/data/sql/base/db_characters/gm_survey.sql index 971355967e..834c7bd6f3 100644 --- a/data/sql/base/db_characters/gm_survey.sql +++ b/data/sql/base/db_characters/gm_survey.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -48,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:07 diff --git a/data/sql/base/db_characters/gm_ticket.sql b/data/sql/base/db_characters/gm_ticket.sql index d16780c360..9bbb6f91b6 100644 --- a/data/sql/base/db_characters/gm_ticket.sql +++ b/data/sql/base/db_characters/gm_ticket.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -62,5 +62,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:07 diff --git a/data/sql/base/db_characters/group_member.sql b/data/sql/base/db_characters/group_member.sql index b3cda24ce6..e303607d59 100644 --- a/data/sql/base/db_characters/group_member.sql +++ b/data/sql/base/db_characters/group_member.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:06 - +-- Dump completed on 2025-07-19 12:10:07 diff --git a/data/sql/base/db_characters/groups.sql b/data/sql/base/db_characters/groups.sql index bb22a1fcfe..522a91e44e 100644 --- a/data/sql/base/db_characters/groups.sql +++ b/data/sql/base/db_characters/groups.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -39,7 +39,6 @@ CREATE TABLE `groups` ( `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '0', `masterLooterGuid` int unsigned NOT NULL, PRIMARY KEY (`guid`), - KEY `leaderGuid` (`leaderGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -61,5 +60,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:08 diff --git a/data/sql/base/db_characters/guild.sql b/data/sql/base/db_characters/guild.sql index a2113b508b..440c59597e 100644 --- a/data/sql/base/db_characters/guild.sql +++ b/data/sql/base/db_characters/guild.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -54,5 +54,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:08 diff --git a/data/sql/base/db_characters/guild_bank_eventlog.sql b/data/sql/base/db_characters/guild_bank_eventlog.sql index 5a276a75ff..202d7acc54 100644 --- a/data/sql/base/db_characters/guild_bank_eventlog.sql +++ b/data/sql/base/db_characters/guild_bank_eventlog.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -31,11 +31,8 @@ CREATE TABLE `guild_bank_eventlog` ( `DestTabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', `TimeStamp` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), - KEY `guildid_key` (`guildid`), - KEY `Idx_PlayerGuid` (`PlayerGuid`), - KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -57,5 +54,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:08 diff --git a/data/sql/base/db_characters/guild_bank_item.sql b/data/sql/base/db_characters/guild_bank_item.sql index f11aa9cb39..e342556e52 100644 --- a/data/sql/base/db_characters/guild_bank_item.sql +++ b/data/sql/base/db_characters/guild_bank_item.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,9 +26,7 @@ CREATE TABLE `guild_bank_item` ( `SlotId` tinyint unsigned NOT NULL DEFAULT '0', `item_guid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`SlotId`), - KEY `guildid_key` (`guildid`), - KEY `Idx_item_guid` (`item_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -50,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:08 diff --git a/data/sql/base/db_characters/guild_bank_right.sql b/data/sql/base/db_characters/guild_bank_right.sql index 9645b96d21..5a3600dbd2 100644 --- a/data/sql/base/db_characters/guild_bank_right.sql +++ b/data/sql/base/db_characters/guild_bank_right.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,7 +27,6 @@ CREATE TABLE `guild_bank_right` ( `gbright` tinyint unsigned NOT NULL DEFAULT '0', `SlotPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), - KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -49,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:09 diff --git a/data/sql/base/db_characters/guild_bank_tab.sql b/data/sql/base/db_characters/guild_bank_tab.sql index 70068e4804..9fa27cf435 100644 --- a/data/sql/base/db_characters/guild_bank_tab.sql +++ b/data/sql/base/db_characters/guild_bank_tab.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,7 +27,6 @@ CREATE TABLE `guild_bank_tab` ( `TabIcon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `TabText` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), - KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -49,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:09 diff --git a/data/sql/base/db_characters/guild_eventlog.sql b/data/sql/base/db_characters/guild_eventlog.sql index f6ad718e80..fe8a2991f5 100644 --- a/data/sql/base/db_characters/guild_eventlog.sql +++ b/data/sql/base/db_characters/guild_eventlog.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -29,11 +29,8 @@ CREATE TABLE `guild_eventlog` ( `NewRank` tinyint unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', `TimeStamp` int unsigned NOT NULL COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), - KEY `Idx_PlayerGuid1` (`PlayerGuid1`), - KEY `Idx_PlayerGuid2` (`PlayerGuid2`), - KEY `Idx_LogGuid` (`LogGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Eventlog'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -55,5 +52,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:07 - +-- Dump completed on 2025-07-19 12:10:09 diff --git a/data/sql/base/db_characters/guild_member.sql b/data/sql/base/db_characters/guild_member.sql index 80e61974a5..4c78198000 100644 --- a/data/sql/base/db_characters/guild_member.sql +++ b/data/sql/base/db_characters/guild_member.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,9 +27,7 @@ CREATE TABLE `guild_member` ( `pnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `offnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), - KEY `guildid_key` (`guildid`), - KEY `guildid_rank_key` (`guildid`,`rank`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -51,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:09 diff --git a/data/sql/base/db_characters/guild_member_withdraw.sql b/data/sql/base/db_characters/guild_member_withdraw.sql index eee70adda8..c1a6bb5171 100644 --- a/data/sql/base/db_characters/guild_member_withdraw.sql +++ b/data/sql/base/db_characters/guild_member_withdraw.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -50,5 +50,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:10 diff --git a/data/sql/base/db_characters/guild_rank.sql b/data/sql/base/db_characters/guild_rank.sql index 5298d5a5de..3e827fa79a 100644 --- a/data/sql/base/db_characters/guild_rank.sql +++ b/data/sql/base/db_characters/guild_rank.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,7 +27,6 @@ CREATE TABLE `guild_rank` ( `rights` int unsigned DEFAULT '0', `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), - KEY `Idx_rid` (`rid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -49,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:10 diff --git a/data/sql/base/db_characters/instance.sql b/data/sql/base/db_characters/instance.sql index 7ab3828663..4aa4f2a3e1 100644 --- a/data/sql/base/db_characters/instance.sql +++ b/data/sql/base/db_characters/instance.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -28,11 +28,8 @@ CREATE TABLE `instance` ( `completedEncounters` int unsigned NOT NULL DEFAULT '0', `data` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), - KEY `map` (`map`), - KEY `resettime` (`resettime`), - KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -54,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:10 diff --git a/data/sql/base/db_characters/instance_reset.sql b/data/sql/base/db_characters/instance_reset.sql index 677f59729f..965c55a352 100644 --- a/data/sql/base/db_characters/instance_reset.sql +++ b/data/sql/base/db_characters/instance_reset.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -25,7 +25,6 @@ CREATE TABLE `instance_reset` ( `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `resettime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`mapid`,`difficulty`), - KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -37,77 +36,77 @@ CREATE TABLE `instance_reset` ( LOCK TABLES `instance_reset` WRITE; /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; INSERT INTO `instance_reset` VALUES -(249,0,1734696000), -(249,1,1734696000), -(269,1,1734494400), -(309,0,1734580800), -(409,0,1734696000), -(469,0,1734696000), -(509,0,1734580800), -(531,0,1734696000), -(532,0,1734696000), -(533,0,1734696000), -(533,1,1734696000), -(534,0,1734696000), -(540,1,1734494400), -(542,1,1734494400), -(543,1,1734494400), -(544,0,1734696000), -(545,1,1734494400), -(546,1,1734494400), -(547,1,1734494400), -(548,0,1734696000), -(550,0,1734696000), -(552,1,1734494400), -(553,1,1734494400), -(554,1,1734494400), -(555,1,1734494400), -(556,1,1734494400), -(557,1,1734494400), -(558,1,1734494400), -(560,1,1734494400), -(564,0,1734696000), -(565,0,1734696000), -(568,0,1734580800), -(574,1,1734494400), -(575,1,1734494400), -(576,1,1734494400), -(578,1,1734494400), -(580,0,1734696000), -(585,1,1734494400), -(595,1,1734494400), -(598,1,1734494400), -(599,1,1734494400), -(600,1,1734494400), -(601,1,1734494400), -(602,1,1734494400), -(603,0,1734696000), -(603,1,1734696000), -(604,1,1734494400), -(608,1,1734494400), -(615,0,1734696000), -(615,1,1734696000), -(616,0,1734696000), -(616,1,1734696000), -(619,1,1734494400), -(624,0,1734696000), -(624,1,1734696000), -(631,0,1734696000), -(631,1,1734696000), -(631,2,1734696000), -(631,3,1734696000), -(632,1,1734494400), -(649,0,1734696000), -(649,1,1734696000), -(649,2,1734696000), -(649,3,1734696000), -(650,1,1734494400), -(658,1,1734494400), -(668,1,1734494400), -(724,0,1734696000), -(724,1,1734696000), -(724,2,1734696000), -(724,3,1734696000); +(249,0,1753459200), +(249,1,1753459200), +(269,1,1752984000), +(309,0,1752998400), +(409,0,1753459200), +(469,0,1753459200), +(509,0,1752998400), +(531,0,1753459200), +(532,0,1753459200), +(533,0,1753459200), +(533,1,1753459200), +(534,0,1753459200), +(540,1,1752984000), +(542,1,1752984000), +(543,1,1752984000), +(544,0,1753459200), +(545,1,1752984000), +(546,1,1752984000), +(547,1,1752984000), +(548,0,1753459200), +(550,0,1753459200), +(552,1,1752984000), +(553,1,1752984000), +(554,1,1752984000), +(555,1,1752984000), +(556,1,1752984000), +(557,1,1752984000), +(558,1,1752984000), +(560,1,1752984000), +(564,0,1753459200), +(565,0,1753459200), +(568,0,1752998400), +(574,1,1752984000), +(575,1,1752984000), +(576,1,1752984000), +(578,1,1752984000), +(580,0,1753459200), +(585,1,1752984000), +(595,1,1752984000), +(598,1,1752984000), +(599,1,1752984000), +(600,1,1752984000), +(601,1,1752984000), +(602,1,1753012800), +(603,0,1753459200), +(603,1,1753459200), +(604,1,1753012800), +(608,1,1753012800), +(615,0,1753459200), +(615,1,1753459200), +(616,0,1753459200), +(616,1,1753459200), +(619,1,1753012800), +(624,0,1753459200), +(624,1,1753459200), +(631,0,1753459200), +(631,1,1753459200), +(631,2,1753459200), +(631,3,1753459200), +(632,1,1753012800), +(649,0,1753459200), +(649,1,1753459200), +(649,2,1753459200), +(649,3,1753459200), +(650,1,1753012800), +(658,1,1753012800), +(668,1,1753012800), +(724,0,1753459200), +(724,1,1753459200), +(724,2,1753459200), +(724,3,1753459200); /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; UNLOCK TABLES; @@ -119,5 +118,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:10 diff --git a/data/sql/base/db_characters/instance_saved_go_state_data.sql b/data/sql/base/db_characters/instance_saved_go_state_data.sql index 50851ecbe6..768695dc5d 100644 --- a/data/sql/base/db_characters/instance_saved_go_state_data.sql +++ b/data/sql/base/db_characters/instance_saved_go_state_data.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:08 - +-- Dump completed on 2025-07-19 12:10:10 diff --git a/data/sql/base/db_characters/item_instance.sql b/data/sql/base/db_characters/item_instance.sql index 200ee807c1..d4a7042df2 100644 --- a/data/sql/base/db_characters/item_instance.sql +++ b/data/sql/base/db_characters/item_instance.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,7 +36,6 @@ CREATE TABLE `item_instance` ( `playedTime` int unsigned NOT NULL DEFAULT '0', `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), - KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -58,5 +57,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:11 diff --git a/data/sql/base/db_characters/item_loot_storage.sql b/data/sql/base/db_characters/item_loot_storage.sql index 3296701438..f279ff2ba5 100644 --- a/data/sql/base/db_characters/item_loot_storage.sql +++ b/data/sql/base/db_characters/item_loot_storage.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -54,5 +54,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:11 diff --git a/data/sql/base/db_characters/item_refund_instance.sql b/data/sql/base/db_characters/item_refund_instance.sql index 06639f6eda..a8452eb1be 100644 --- a/data/sql/base/db_characters/item_refund_instance.sql +++ b/data/sql/base/db_characters/item_refund_instance.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:11 diff --git a/data/sql/base/db_characters/item_soulbound_trade_data.sql b/data/sql/base/db_characters/item_soulbound_trade_data.sql index 53a86afc7e..57c54024fc 100644 --- a/data/sql/base/db_characters/item_soulbound_trade_data.sql +++ b/data/sql/base/db_characters/item_soulbound_trade_data.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -44,5 +44,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:11 diff --git a/data/sql/base/db_characters/lag_reports.sql b/data/sql/base/db_characters/lag_reports.sql index 3fb01dffc1..35e5f751e3 100644 --- a/data/sql/base/db_characters/lag_reports.sql +++ b/data/sql/base/db_characters/lag_reports.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -51,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:12 diff --git a/data/sql/base/db_characters/lfg_data.sql b/data/sql/base/db_characters/lfg_data.sql index 8451ec7841..5a817695c1 100644 --- a/data/sql/base/db_characters/lfg_data.sql +++ b/data/sql/base/db_characters/lfg_data.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:09 - +-- Dump completed on 2025-07-19 12:10:12 diff --git a/data/sql/base/db_characters/log_arena_fights.sql b/data/sql/base/db_characters/log_arena_fights.sql index b89b58650e..9f9ce73654 100644 --- a/data/sql/base/db_characters/log_arena_fights.sql +++ b/data/sql/base/db_characters/log_arena_fights.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -55,5 +55,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:12 diff --git a/data/sql/base/db_characters/log_arena_memberstats.sql b/data/sql/base/db_characters/log_arena_memberstats.sql index c486c80745..f94170eb52 100644 --- a/data/sql/base/db_characters/log_arena_memberstats.sql +++ b/data/sql/base/db_characters/log_arena_memberstats.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -52,5 +52,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:12 diff --git a/data/sql/base/db_characters/log_encounter.sql b/data/sql/base/db_characters/log_encounter.sql index 5fa908eaa5..44fb61a788 100644 --- a/data/sql/base/db_characters/log_encounter.sql +++ b/data/sql/base/db_characters/log_encounter.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:13 diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index 46a60096cd..d9a4444e70 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -51,5 +51,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:13 diff --git a/data/sql/base/db_characters/mail.sql b/data/sql/base/db_characters/mail.sql index 463fe7132e..062c358317 100644 --- a/data/sql/base/db_characters/mail.sql +++ b/data/sql/base/db_characters/mail.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,7 +36,6 @@ CREATE TABLE `mail` ( `cod` int unsigned NOT NULL DEFAULT '0', `checked` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), - KEY `idx_receiver` (`receiver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -58,5 +57,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:13 diff --git a/data/sql/base/db_characters/mail_items.sql b/data/sql/base/db_characters/mail_items.sql index 16e2d13002..c44b241ac3 100644 --- a/data/sql/base/db_characters/mail_items.sql +++ b/data/sql/base/db_characters/mail_items.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -25,9 +25,7 @@ CREATE TABLE `mail_items` ( `item_guid` int unsigned NOT NULL DEFAULT '0', `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`item_guid`), - KEY `idx_receiver` (`receiver`), - KEY `idx_mail_id` (`mail_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -49,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:13 diff --git a/data/sql/base/db_characters/mail_server_character.sql b/data/sql/base/db_characters/mail_server_character.sql index 23e69c85a5..85fbc89090 100644 --- a/data/sql/base/db_characters/mail_server_character.sql +++ b/data/sql/base/db_characters/mail_server_character.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -23,7 +23,9 @@ DROP TABLE IF EXISTS `mail_server_character`; CREATE TABLE `mail_server_character` ( `guid` int unsigned NOT NULL, `mailId` int unsigned NOT NULL, - PRIMARY KEY (`guid`,`mailId`) + PRIMARY KEY (`guid`,`mailId`), + KEY `fk_mail_server_character` (`mailId`), + CONSTRAINT `fk_mail_server_character` FOREIGN KEY (`mailId`) REFERENCES `mail_server_template` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -44,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:10 - +-- Dump completed on 2025-07-19 12:10:14 diff --git a/data/sql/base/db_characters/mail_server_template.sql b/data/sql/base/db_characters/mail_server_template.sql index 2d6d772f35..2b48884459 100644 --- a/data/sql/base/db_characters/mail_server_template.sql +++ b/data/sql/base/db_characters/mail_server_template.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -22,14 +22,8 @@ DROP TABLE IF EXISTS `mail_server_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_server_template` ( `id` int unsigned NOT NULL AUTO_INCREMENT, - `reqLevel` tinyint unsigned NOT NULL DEFAULT '0', - `reqPlayTime` int unsigned NOT NULL DEFAULT '0', `moneyA` int unsigned NOT NULL DEFAULT '0', `moneyH` int unsigned NOT NULL DEFAULT '0', - `itemA` int unsigned NOT NULL DEFAULT '0', - `itemCountA` int unsigned NOT NULL DEFAULT '0', - `itemH` int unsigned NOT NULL DEFAULT '0', - `itemCountH` int unsigned NOT NULL DEFAULT '0', `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', @@ -54,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:14 diff --git a/data/sql/base/db_characters/mail_server_template_conditions.sql b/data/sql/base/db_characters/mail_server_template_conditions.sql new file mode 100644 index 0000000000..43274459ad --- /dev/null +++ b/data/sql/base/db_characters/mail_server_template_conditions.sql @@ -0,0 +1,52 @@ +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) +-- +-- Host: localhost Database: acore_characters +-- ------------------------------------------------------ +-- Server version 8.4.3 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `mail_server_template_conditions` +-- + +DROP TABLE IF EXISTS `mail_server_template_conditions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `mail_server_template_conditions` ( + `id` int unsigned NOT NULL AUTO_INCREMENT, + `templateID` int unsigned NOT NULL, + `conditionType` enum('Level','PlayTime','Quest','Achievement','Reputation','Faction','Race','Class') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `conditionValue` int unsigned NOT NULL, + `conditionState` int unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `fk_mail_template_conditions` (`templateID`), + CONSTRAINT `fk_mail_template_conditions` FOREIGN KEY (`templateID`) REFERENCES `mail_server_template` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `mail_server_template_conditions` +-- + +LOCK TABLES `mail_server_template_conditions` WRITE; +/*!40000 ALTER TABLE `mail_server_template_conditions` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail_server_template_conditions` ENABLE KEYS */; +UNLOCK TABLES; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2025-07-19 12:10:14 diff --git a/data/sql/base/db_characters/mail_server_template_items.sql b/data/sql/base/db_characters/mail_server_template_items.sql new file mode 100644 index 0000000000..4ef7a744f4 --- /dev/null +++ b/data/sql/base/db_characters/mail_server_template_items.sql @@ -0,0 +1,52 @@ +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) +-- +-- Host: localhost Database: acore_characters +-- ------------------------------------------------------ +-- Server version 8.4.3 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `mail_server_template_items` +-- + +DROP TABLE IF EXISTS `mail_server_template_items`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `mail_server_template_items` ( + `id` int unsigned NOT NULL AUTO_INCREMENT, + `templateID` int unsigned NOT NULL, + `faction` enum('Alliance','Horde') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `item` int unsigned NOT NULL, + `itemCount` int unsigned NOT NULL, + PRIMARY KEY (`id`), + KEY `fk_mail_template` (`templateID`), + CONSTRAINT `fk_mail_template` FOREIGN KEY (`templateID`) REFERENCES `mail_server_template` (`id`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `mail_server_template_items` +-- + +LOCK TABLES `mail_server_template_items` WRITE; +/*!40000 ALTER TABLE `mail_server_template_items` DISABLE KEYS */; +/*!40000 ALTER TABLE `mail_server_template_items` ENABLE KEYS */; +UNLOCK TABLES; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2025-07-19 12:10:14 diff --git a/data/sql/base/db_characters/pet_aura.sql b/data/sql/base/db_characters/pet_aura.sql index 8d11d3774d..e380fdb888 100644 --- a/data/sql/base/db_characters/pet_aura.sql +++ b/data/sql/base/db_characters/pet_aura.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -57,5 +57,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:14 diff --git a/data/sql/base/db_characters/pet_spell.sql b/data/sql/base/db_characters/pet_spell.sql index 52188df1da..731f50fdb2 100644 --- a/data/sql/base/db_characters/pet_spell.sql +++ b/data/sql/base/db_characters/pet_spell.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -45,5 +45,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:15 diff --git a/data/sql/base/db_characters/pet_spell_cooldown.sql b/data/sql/base/db_characters/pet_spell_cooldown.sql index c14e05a457..f6f5887987 100644 --- a/data/sql/base/db_characters/pet_spell_cooldown.sql +++ b/data/sql/base/db_characters/pet_spell_cooldown.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:15 diff --git a/data/sql/base/db_characters/petition.sql b/data/sql/base/db_characters/petition.sql index 56d73b961d..ecc137b00d 100644 --- a/data/sql/base/db_characters/petition.sql +++ b/data/sql/base/db_characters/petition.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -26,7 +26,6 @@ CREATE TABLE `petition` ( `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerguid`,`type`), - UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -48,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:15 diff --git a/data/sql/base/db_characters/petition_sign.sql b/data/sql/base/db_characters/petition_sign.sql index c5b13421ca..ec684d50d3 100644 --- a/data/sql/base/db_characters/petition_sign.sql +++ b/data/sql/base/db_characters/petition_sign.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,9 +27,7 @@ CREATE TABLE `petition_sign` ( `player_account` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petitionguid`,`playerguid`), - KEY `Idx_playerguid` (`playerguid`), - KEY `Idx_ownerguid` (`ownerguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -51,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:11 - +-- Dump completed on 2025-07-19 12:10:15 diff --git a/data/sql/base/db_characters/pool_quest_save.sql b/data/sql/base/db_characters/pool_quest_save.sql index 608365f4a0..752115f2f1 100644 --- a/data/sql/base/db_characters/pool_quest_save.sql +++ b/data/sql/base/db_characters/pool_quest_save.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -34,44 +34,44 @@ CREATE TABLE `pool_quest_save` ( LOCK TABLES `pool_quest_save` WRITE; /*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */; INSERT INTO `pool_quest_save` VALUES -(348,24636), -(349,14101), -(350,13904), -(351,13917), -(352,11379), -(353,11669), -(354,13422), -(356,11373), -(357,11371), -(358,14074), -(359,14076), -(360,14136), -(361,14141), -(362,12703), -(363,14108), -(380,12737), -(381,12741), -(382,12705), -(384,13191), -(385,13156), -(386,12587), -(5662,13675), -(5663,13762), -(5664,13770), -(5665,13774), -(5666,13778), -(5667,13785), -(5668,13670), -(5669,13616), -(5670,13741), -(5671,13747), -(5672,13759), -(5673,13754), -(5674,13107), -(5675,13113), -(5676,13833), -(5677,12960), -(5678,24580); +(348,24629), +(349,14104), +(350,13889), +(351,13916), +(352,11381), +(353,11665), +(354,13423), +(356,11499), +(357,11383), +(358,14152), +(359,14112), +(360,14140), +(361,14145), +(362,12759), +(363,14107), +(380,12726), +(381,12758), +(382,12761), +(384,13194), +(385,13153), +(386,12501), +(5662,13673), +(5663,13764), +(5664,13769), +(5665,13773), +(5666,13780), +(5667,13783), +(5668,13666), +(5669,13600), +(5670,13743), +(5671,13748), +(5672,13758), +(5673,13753), +(5674,13100), +(5675,13115), +(5676,13836), +(5677,12959), +(5678,24585); /*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */; UNLOCK TABLES; @@ -83,5 +83,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:16 diff --git a/data/sql/base/db_characters/profanity_name.sql b/data/sql/base/db_characters/profanity_name.sql index 4c4d3f3218..2c95353d0c 100644 --- a/data/sql/base/db_characters/profanity_name.sql +++ b/data/sql/base/db_characters/profanity_name.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -43,5 +43,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:16 diff --git a/data/sql/base/db_characters/pvpstats_battlegrounds.sql b/data/sql/base/db_characters/pvpstats_battlegrounds.sql index e2a53762d5..6badec52ae 100644 --- a/data/sql/base/db_characters/pvpstats_battlegrounds.sql +++ b/data/sql/base/db_characters/pvpstats_battlegrounds.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -47,5 +47,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:16 diff --git a/data/sql/base/db_characters/pvpstats_players.sql b/data/sql/base/db_characters/pvpstats_players.sql index 44b35e707c..28fa8649ba 100644 --- a/data/sql/base/db_characters/pvpstats_players.sql +++ b/data/sql/base/db_characters/pvpstats_players.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -56,5 +56,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:16 diff --git a/data/sql/base/db_characters/quest_tracker.sql b/data/sql/base/db_characters/quest_tracker.sql index b62db445a4..912c6dcfa6 100644 --- a/data/sql/base/db_characters/quest_tracker.sql +++ b/data/sql/base/db_characters/quest_tracker.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -49,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:17 diff --git a/data/sql/base/db_characters/recovery_item.sql b/data/sql/base/db_characters/recovery_item.sql index 58905892a1..5aee4f62b2 100644 --- a/data/sql/base/db_characters/recovery_item.sql +++ b/data/sql/base/db_characters/recovery_item.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -27,7 +27,6 @@ CREATE TABLE `recovery_item` ( `Count` int unsigned NOT NULL DEFAULT '0', `DeleteDate` int unsigned DEFAULT NULL, PRIMARY KEY (`Id`), - KEY `idx_guid` (`Guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -49,5 +48,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:17 diff --git a/data/sql/base/db_characters/reserved_name.sql b/data/sql/base/db_characters/reserved_name.sql index 53ae48e812..1c27ee9251 100644 --- a/data/sql/base/db_characters/reserved_name.sql +++ b/data/sql/base/db_characters/reserved_name.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -43,5 +43,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:12 - +-- Dump completed on 2025-07-19 12:10:17 diff --git a/data/sql/base/db_characters/updates.sql b/data/sql/base/db_characters/updates.sql index 26f657a9c7..ff7a0893f3 100644 --- a/data/sql/base/db_characters/updates.sql +++ b/data/sql/base/db_characters/updates.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `updates`; CREATE TABLE `updates` ( `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','CUSTOM','MODULE','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `state` enum('RELEASED','CUSTOM','MODULE','ARCHIVED','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) USING BTREE @@ -44,7 +44,12 @@ INSERT INTO `updates` VALUES ('2024_07_05_00.sql','1C9590EBB81D192A2DF101D6B0B2178E45306500','RELEASED','2024-07-17 00:46:08',88), ('2024_09_03_00.sql','6D7992803C7747E9CDE15A6EF0A0319DEE93DA51','RELEASED','2024-12-17 21:51:20',146), ('2024_09_22_00.sql','CC603A632BB6E01737A3D2DF7A85D1BEFF16C102','RELEASED','2024-12-17 21:51:20',96), -('2024_11_15_00.sql','AC109BE8DC3ABD09435A700F8ADE0050B9CB5170','RELEASED','2024-12-17 21:51:20',72); +('2024_11_15_00.sql','AC109BE8DC3ABD09435A700F8ADE0050B9CB5170','RELEASED','2024-12-17 21:51:20',72), +('2025_01_31_00.sql','49B70E7107D57C75198BA707B849A6243A32863F','RELEASED','2025-07-19 10:16:15',44), +('2025_02_12_00.sql','BF2260040A6B47500D6C24BE74DB61198E5DA966','RELEASED','2025-07-19 10:16:15',80), +('2025_02_16_00.sql','BF15638A8F522A4D9DE51D42A71B860B95FB8031','RELEASED','2025-07-19 10:16:15',60), +('2025_03_09_00.sql','9BC72C8A080EDC1B3ECCB81C8146C8A5EA7E4266','RELEASED','2025-07-19 10:16:16',540), +('2025_07_11_00.sql','EA89D9F35FC3237E8B443902D6A7AD94DC7C8645','RELEASED','2025-07-19 10:16:16',127); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -56,5 +61,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:13 - +-- Dump completed on 2025-07-19 12:10:17 diff --git a/data/sql/base/db_characters/updates_include.sql b/data/sql/base/db_characters/updates_include.sql index fc0990de7e..b740884403 100644 --- a/data/sql/base/db_characters/updates_include.sql +++ b/data/sql/base/db_characters/updates_include.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `updates_include`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED','CUSTOM') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `state` enum('RELEASED','ARCHIVED','CUSTOM','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -36,7 +36,8 @@ LOCK TABLES `updates_include` WRITE; INSERT INTO `updates_include` VALUES ('$/data/sql/archive/db_characters','ARCHIVED'), ('$/data/sql/custom/db_characters','CUSTOM'), -('$/data/sql/updates/db_characters','RELEASED'); +('$/data/sql/updates/db_characters','RELEASED'), +('$/data/sql/updates/pending_db_characters','PENDING'); /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; UNLOCK TABLES; @@ -48,5 +49,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:13 - +-- Dump completed on 2025-07-19 12:10:18 diff --git a/data/sql/base/db_characters/warden_action.sql b/data/sql/base/db_characters/warden_action.sql index b8d9d9bd6f..9bd9e2d091 100644 --- a/data/sql/base/db_characters/warden_action.sql +++ b/data/sql/base/db_characters/warden_action.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -46,5 +46,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:13 - +-- Dump completed on 2025-07-19 12:10:18 diff --git a/data/sql/base/db_characters/world_state.sql b/data/sql/base/db_characters/world_state.sql new file mode 100644 index 0000000000..25b38a7525 --- /dev/null +++ b/data/sql/base/db_characters/world_state.sql @@ -0,0 +1,49 @@ +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) +-- +-- Host: localhost Database: acore_characters +-- ------------------------------------------------------ +-- Server version 8.4.3 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!50503 SET NAMES utf8mb4 */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `world_state` +-- + +DROP TABLE IF EXISTS `world_state`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `world_state` ( + `Id` int unsigned NOT NULL COMMENT 'Internal save ID', + `Data` longtext, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='WorldState save system'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `world_state` +-- + +LOCK TABLES `world_state` WRITE; +/*!40000 ALTER TABLE `world_state` DISABLE KEYS */; +INSERT INTO `world_state` VALUES +(20,'3 15 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 3 80 80 80'); +/*!40000 ALTER TABLE `world_state` ENABLE KEYS */; +UNLOCK TABLES; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2025-07-19 12:10:18 diff --git a/data/sql/base/db_characters/worldstates.sql b/data/sql/base/db_characters/worldstates.sql index 5732b5b064..105b340641 100644 --- a/data/sql/base/db_characters/worldstates.sql +++ b/data/sql/base/db_characters/worldstates.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64) -- --- Host: 127.0.0.1 Database: acore_characters +-- Host: localhost Database: acore_characters -- ------------------------------------------------------ --- Server version 8.0.34 +-- Server version 8.4.3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,7 +36,7 @@ LOCK TABLES `worldstates` WRITE; /*!40000 ALTER TABLE `worldstates` DISABLE KEYS */; INSERT INTO `worldstates` VALUES (1,0,NULL), -(2,1734471110,NULL), +(2,0,NULL), (3,0,NULL), (4,0,NULL), (5,0,NULL), @@ -125,6 +125,46 @@ INSERT INTO `worldstates` VALUES (88,0,NULL), (89,0,NULL), (90,0,NULL), +(91,0,NULL), +(92,0,NULL), +(93,0,NULL), +(94,0,NULL), +(95,0,NULL), +(96,0,NULL), +(97,0,NULL), +(98,0,NULL), +(99,0,NULL), +(100,0,NULL), +(101,0,NULL), +(102,0,NULL), +(103,0,NULL), +(104,0,NULL), +(105,0,NULL), +(106,0,NULL), +(107,0,NULL), +(108,0,NULL), +(109,0,NULL), +(110,0,NULL), +(111,0,NULL), +(112,0,NULL), +(113,0,NULL), +(114,0,NULL), +(115,0,NULL), +(116,0,NULL), +(117,0,NULL), +(118,0,NULL), +(119,0,NULL), +(120,0,NULL), +(121,0,NULL), +(122,0,NULL), +(123,0,NULL), +(124,0,NULL), +(125,0,NULL), +(126,0,NULL), +(127,0,NULL), +(128,0,NULL), +(129,0,NULL), +(130,0,NULL), (197,0,'Fishing Extravaganza - STV_FISHING_PREV_WIN_TIME'), (198,0,'Fishing Extravaganza - STV_FISHING_HAS_WINNER'), (199,0,'Fishing Extravaganza - STV_FISHING_ANNOUNCE_EVENT_BEGIN'), @@ -133,13 +173,13 @@ INSERT INTO `worldstates` VALUES (3801,0,NULL), (3802,1,NULL), (20001,1454691600,'NextArenaPointDistributionTime'), -(20002,1734584400,'NextWeeklyQuestResetTime'), -(20003,1734498000,'NextBGRandomDailyResetTime'), +(20002,1753329600,'NextWeeklyQuestResetTime'), +(20003,1752984000,'NextBGRandomDailyResetTime'), (20004,0,'cleaning_flags'), -(20005,1734498000,'NextDailyQuestResetTime'), -(20006,1734498000,'NextGuildDailyResetTime'), -(20007,1735707600,'NextMonthlyQuestResetTime'), -(20008,1734498000,NULL); +(20005,1752984000,'NextDailyQuestResetTime'), +(20006,1752984000,'NextGuildDailyResetTime'), +(20007,1754020800,'NextMonthlyQuestResetTime'), +(20008,1752984000,NULL); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; UNLOCK TABLES; @@ -151,5 +191,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-12-17 22:33:13 - +-- Dump completed on 2025-07-19 12:10:18 |