diff options
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 71 |
1 files changed, 30 insertions, 41 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index be834419bdc..a70185ede3d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -591,6 +591,33 @@ LOCK TABLES `character_aura_stored_location` WRITE; UNLOCK TABLES; -- +-- Table structure for table `character_bank_tab_settings` +-- + +DROP TABLE IF EXISTS `character_bank_tab_settings`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `character_bank_tab_settings` ( + `characterGuid` bigint unsigned NOT NULL, + `tabId` tinyint unsigned NOT NULL, + `name` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `icon` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `depositFlags` int DEFAULT '0', + PRIMARY KEY (`characterGuid`,`tabId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `character_bank_tab_settings` +-- + +LOCK TABLES `character_bank_tab_settings` WRITE; +/*!40000 ALTER TABLE `character_bank_tab_settings` DISABLE KEYS */; +/*!40000 ALTER TABLE `character_bank_tab_settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `character_banned` -- @@ -1913,39 +1940,6 @@ LOCK TABLES `character_transmog_outfits` WRITE; UNLOCK TABLES; -- --- Table structure for table `character_void_storage` --- - -DROP TABLE IF EXISTS `character_void_storage`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `character_void_storage` ( - `itemId` bigint unsigned NOT NULL, - `playerGuid` bigint unsigned NOT NULL, - `itemEntry` int unsigned NOT NULL, - `slot` tinyint unsigned NOT NULL, - `creatorGuid` bigint unsigned NOT NULL DEFAULT '0', - `randomBonusListId` int unsigned NOT NULL DEFAULT '0', - `fixedScalingLevel` int unsigned DEFAULT '0', - `artifactKnowledgeLevel` int unsigned DEFAULT '0', - `context` tinyint unsigned NOT NULL DEFAULT '0', - `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (`itemId`), - UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), - KEY `idx_player` (`playerGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `character_void_storage` --- - -LOCK TABLES `character_void_storage` WRITE; -/*!40000 ALTER TABLE `character_void_storage` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_void_storage` ENABLE KEYS */; -UNLOCK TABLES; - --- -- Table structure for table `characters` -- @@ -1971,14 +1965,8 @@ CREATE TABLE `characters` ( `bagSlotFlags4` int unsigned NOT NULL DEFAULT '0', `bagSlotFlags5` int unsigned NOT NULL DEFAULT '0', `bankSlots` tinyint unsigned NOT NULL DEFAULT '0', + `bankTabs` tinyint unsigned NOT NULL DEFAULT '0', `bankBagFlags` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags1` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags2` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags3` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags4` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags5` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags6` int unsigned NOT NULL DEFAULT '0', - `bankBagSlotFlags7` int unsigned NOT NULL DEFAULT '0', `restState` tinyint unsigned NOT NULL DEFAULT '0', `playerFlags` int unsigned NOT NULL DEFAULT '0', `playerFlagsEx` int unsigned NOT NULL DEFAULT '0', @@ -3832,7 +3820,8 @@ INSERT INTO `updates` VALUES ('2025_03_29_00_characters.sql','6A49C236D0B8CCD8A5B6B51F60E116B3380772D7','ARCHIVED','2025-03-29 01:12:13',0), ('2025_05_31_00_characters.sql','C240EB5C4008B6AA0514802A18D7DD875680DE82','ARCHIVED','2025-05-31 19:45:56',0), ('2025_06_27_00_characters.sql','35088BA5BA4BD3B7FAAD6FD4FAE38E52A5B71CD8','ARCHIVED','2025-06-27 14:22:08',0), -('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0); +('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0), +('2025_08_13_00_characters.sql','9C2321777E6C34F18799C8967B1CA0C44F17DA18','RELEASED','2025-08-12 20:17:45',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |