From 5b725db033c656bda5e718ea05a79005946e089e Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 8 May 2015 00:03:15 +0200 Subject: Core/Garrisons: Basics for garrisons --- sql/base/characters_database.sql | 73 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 73 insertions(+) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 5c864dc8cf7..37b84dfc29d 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -753,6 +753,79 @@ LOCK TABLES `character_equipmentsets` WRITE; /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `character_garrison` +-- + +DROP TABLE IF EXISTS `character_garrison`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_garrison` ( + `guid` bigint(20) unsigned NOT NULL, + `siteLevelId` int(10) unsigned NOT NULL DEFAULT '0', + `followerActivationsRemainingToday` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!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 */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_garrison_blueprints` ( + `guid` bigint(20) unsigned NOT NULL, + `buildingId` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`buildingId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!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 */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_garrison_buildings` ( + `guid` bigint(20) unsigned NOT NULL, + `plotInstanceId` int(10) unsigned NOT NULL DEFAULT '0', + `buildingId` int(10) unsigned NOT NULL DEFAULT '0', + `timeBuilt` bigint(20) unsigned NOT NULL, + `active` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`plotInstanceId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!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_gifts` -- -- cgit v1.2.3