aboutsummaryrefslogtreecommitdiff
path: root/sql/base/characters_database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base/characters_database.sql')
-rw-r--r--sql/base/characters_database.sql255
1 files changed, 3 insertions, 252 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index f5806f977f6..3c767dcf735 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -888,138 +888,6 @@ LOCK TABLES `character_fishingsteps` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `character_garrison`
---
-
-DROP TABLE IF EXISTS `character_garrison`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison` (
- `guid` bigint unsigned NOT NULL,
- `siteLevelId` int unsigned NOT NULL DEFAULT '0',
- `followerActivationsRemainingToday` int unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison`
---
-
-LOCK TABLES `character_garrison` WRITE;
-/*!40000 ALTER TABLE `character_garrison` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_blueprints`
---
-
-DROP TABLE IF EXISTS `character_garrison_blueprints`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_blueprints` (
- `guid` bigint unsigned NOT NULL,
- `buildingId` int unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`,`buildingId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_blueprints`
---
-
-LOCK TABLES `character_garrison_blueprints` WRITE;
-/*!40000 ALTER TABLE `character_garrison_blueprints` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_blueprints` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_buildings`
---
-
-DROP TABLE IF EXISTS `character_garrison_buildings`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_buildings` (
- `guid` bigint unsigned NOT NULL,
- `plotInstanceId` int unsigned NOT NULL DEFAULT '0',
- `buildingId` int unsigned NOT NULL DEFAULT '0',
- `timeBuilt` bigint NOT NULL,
- `active` tinyint unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`guid`,`plotInstanceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_buildings`
---
-
-LOCK TABLES `character_garrison_buildings` WRITE;
-/*!40000 ALTER TABLE `character_garrison_buildings` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_buildings` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_follower_abilities`
---
-
-DROP TABLE IF EXISTS `character_garrison_follower_abilities`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_follower_abilities` (
- `dbId` bigint unsigned NOT NULL,
- `abilityId` int unsigned NOT NULL,
- `slot` tinyint unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`dbId`,`abilityId`,`slot`),
- CONSTRAINT `fk_foll_dbid` FOREIGN KEY (`dbId`) REFERENCES `character_garrison_followers` (`dbId`) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_follower_abilities`
---
-
-LOCK TABLES `character_garrison_follower_abilities` WRITE;
-/*!40000 ALTER TABLE `character_garrison_follower_abilities` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_follower_abilities` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_followers`
---
-
-DROP TABLE IF EXISTS `character_garrison_followers`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_followers` (
- `dbId` bigint unsigned NOT NULL,
- `guid` bigint unsigned NOT NULL,
- `followerId` int unsigned NOT NULL,
- `quality` int unsigned NOT NULL DEFAULT '2',
- `level` int unsigned NOT NULL DEFAULT '90',
- `itemLevelWeapon` int unsigned NOT NULL DEFAULT '600',
- `itemLevelArmor` int unsigned NOT NULL DEFAULT '600',
- `xp` int unsigned NOT NULL DEFAULT '0',
- `currentBuilding` int unsigned NOT NULL DEFAULT '0',
- `currentMission` int unsigned NOT NULL DEFAULT '0',
- `status` int unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`dbId`),
- UNIQUE KEY `idx_guid_id` (`guid`,`followerId`),
- CONSTRAINT `fk_foll_owner` FOREIGN KEY (`guid`) REFERENCES `characters` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_followers`
---
-
-LOCK TABLES `character_garrison_followers` WRITE;
-/*!40000 ALTER TABLE `character_garrison_followers` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_followers` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `character_gifts`
--
@@ -2778,125 +2646,6 @@ LOCK TABLES `item_instance_artifact_powers` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `item_instance_azerite`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite` (
- `itemGuid` bigint unsigned NOT NULL,
- `xp` bigint unsigned NOT NULL DEFAULT '0',
- `level` int unsigned NOT NULL DEFAULT '1',
- `knowledgeLevel` int unsigned NOT NULL DEFAULT '0',
- `selectedAzeriteEssences1specId` int unsigned DEFAULT '0',
- `selectedAzeriteEssences1azeriteEssenceId1` int unsigned DEFAULT '0',
- `selectedAzeriteEssences1azeriteEssenceId2` int unsigned DEFAULT '0',
- `selectedAzeriteEssences1azeriteEssenceId3` int unsigned DEFAULT '0',
- `selectedAzeriteEssences1azeriteEssenceId4` int unsigned DEFAULT '0',
- `selectedAzeriteEssences2specId` int unsigned DEFAULT '0',
- `selectedAzeriteEssences2azeriteEssenceId1` int unsigned DEFAULT '0',
- `selectedAzeriteEssences2azeriteEssenceId2` int unsigned DEFAULT '0',
- `selectedAzeriteEssences2azeriteEssenceId3` int unsigned DEFAULT '0',
- `selectedAzeriteEssences2azeriteEssenceId4` int unsigned DEFAULT '0',
- `selectedAzeriteEssences3specId` int unsigned DEFAULT '0',
- `selectedAzeriteEssences3azeriteEssenceId1` int unsigned DEFAULT '0',
- `selectedAzeriteEssences3azeriteEssenceId2` int unsigned DEFAULT '0',
- `selectedAzeriteEssences3azeriteEssenceId3` int unsigned DEFAULT '0',
- `selectedAzeriteEssences3azeriteEssenceId4` int unsigned DEFAULT '0',
- `selectedAzeriteEssences4specId` int unsigned DEFAULT '0',
- `selectedAzeriteEssences4azeriteEssenceId1` int unsigned DEFAULT '0',
- `selectedAzeriteEssences4azeriteEssenceId2` int unsigned DEFAULT '0',
- `selectedAzeriteEssences4azeriteEssenceId3` int unsigned DEFAULT '0',
- `selectedAzeriteEssences4azeriteEssenceId4` int unsigned DEFAULT '0',
- PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite`
---
-
-LOCK TABLES `item_instance_azerite` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_empowered`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_empowered`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_empowered` (
- `itemGuid` bigint unsigned NOT NULL,
- `azeritePowerId1` int NOT NULL,
- `azeritePowerId2` int NOT NULL,
- `azeritePowerId3` int NOT NULL,
- `azeritePowerId4` int NOT NULL,
- `azeritePowerId5` int NOT NULL,
- PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_empowered`
---
-
-LOCK TABLES `item_instance_azerite_empowered` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_empowered` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_empowered` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_milestone_power`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_milestone_power` (
- `itemGuid` bigint unsigned NOT NULL,
- `azeriteItemMilestonePowerId` int unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_milestone_power`
---
-
-LOCK TABLES `item_instance_azerite_milestone_power` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_milestone_power` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_milestone_power` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_unlocked_essence`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_unlocked_essence` (
- `itemGuid` bigint unsigned NOT NULL,
- `azeriteEssenceId` int unsigned NOT NULL DEFAULT '0',
- `rank` int unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`itemGuid`,`azeriteEssenceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_unlocked_essence`
---
-
-LOCK TABLES `item_instance_azerite_unlocked_essence` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `item_instance_gems`
--
@@ -3724,7 +3473,9 @@ INSERT INTO `updates` VALUES
('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','ARCHIVED','2023-11-02 18:59:41',0),
('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0),
('2023_11_15_00_characters.sql','441E0F17DE3E3945307AC400DF86FCDF06C61653','ARCHIVED','2023-11-15 00:53:47',0),
-('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0);
+('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0),
+('2024_03_12_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','ARCHIVED','2024-03-13 17:10:46',0),
+('2024_03_13_00_characters.sql','6360F50059E5DB1F248FA8A270CDC4788A03A0EC','ARCHIVED','2024-03-13 17:10:46',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;