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 --- .../characters/2015_05_08_00_characters.sql | 36 ++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 sql/updates/characters/2015_05_08_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/2015_05_08_00_characters.sql b/sql/updates/characters/2015_05_08_00_characters.sql new file mode 100644 index 00000000000..56a48474801 --- /dev/null +++ b/sql/updates/characters/2015_05_08_00_characters.sql @@ -0,0 +1,36 @@ +-- +-- Table structure for table `character_garrison` +-- + +DROP TABLE IF EXISTS `character_garrison`; +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; + +-- +-- Table structure for table `character_garrison_blueprints` +-- + +DROP TABLE IF EXISTS `character_garrison_blueprints`; +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; + +-- +-- Table structure for table `character_garrison_buildings` +-- + +DROP TABLE IF EXISTS `character_garrison_buildings`; +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; -- cgit v1.2.3