From b3a754cd7bef73c4f29a3fa819d2bac9f173685a Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 22 May 2015 00:17:48 +0200 Subject: Core/Garrisons: Implemented follower class/spec abilities and saving them to database --- sql/base/characters_database.sql | 60 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 60 insertions(+) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 37b84dfc29d..d73924aa76d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -826,6 +826,66 @@ LOCK TABLES `character_garrison_buildings` WRITE; /*!40000 ALTER TABLE `character_garrison_buildings` 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 */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_garrison_followers` ( + `dbId` bigint(20) unsigned NOT NULL, + `guid` bigint(20) unsigned NOT NULL, + `followerId` int(10) unsigned NOT NULL, + `quality` int(10) unsigned NOT NULL DEFAULT '2', + `level` int(10) unsigned NOT NULL DEFAULT '90', + `itemLevelWeapon` int(10) unsigned NOT NULL DEFAULT '600', + `itemLevelArmor` int(10) unsigned NOT NULL DEFAULT '600', + `xp` int(10) unsigned NOT NULL DEFAULT '0', + `currentBuilding` int(10) unsigned NOT NULL DEFAULT '0', + `currentMission` int(10) unsigned NOT NULL DEFAULT '0', + `status` int(10) 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=utf8; +/*!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_garrison_follower_abilities` +-- + +DROP TABLE IF EXISTS `character_garrison_follower_abilities`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_garrison_follower_abilities` ( + `dbId` bigint(20) unsigned NOT NULL, + `abilityId` int(10) unsigned NOT NULL, + `slot` tinyint(3) 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=utf8; +/*!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; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + -- -- Table structure for table `character_gifts` -- -- cgit v1.2.3