Core/Garrisons: Basics for garrisons

1 files changed, 186 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/2015_05_08_00_hotfixes.sql b/sql/updates/hotfixes/2015_05_08_00_hotfixes.sql
new file mode 100644
index 00000000000..ca04ee93c24
--- /dev/null
+++ b/sql/updates/hotfixes/2015_05_08_00_hotfixes.sql
@@ -0,0 +1,186 @@
+--
+-- Table structure for table `gameobjects_locale`
+--
+
+DROP TABLE IF EXISTS `gameobjects_locale`;
+CREATE TABLE `gameobjects_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_building`
+--
+
+DROP TABLE IF EXISTS `garr_building`;
+CREATE TABLE `garr_building` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `HordeGameObjectID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AllianceGameObjectID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Unknown` int(10) unsigned NOT NULL DEFAULT '0',
+  `Type` int(10) unsigned NOT NULL DEFAULT '0',
+  `Level` int(10) unsigned NOT NULL DEFAULT '0',
+  `NameAlliance` text,
+  `NameHorde` text,
+  `Description` text,
+  `Tooltip` text,
+  `BuildDuration` int(10) unsigned NOT NULL DEFAULT '0',
+  `CostCurrencyID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CostCurrencyAmount` int(11) NOT NULL DEFAULT '0',
+  `HordeTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AllianceTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0',
+  `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusAmount` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `AllianceActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0',
+  `HordeActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxShipments` int(10) unsigned NOT NULL DEFAULT '0',
+  `FollowerRequiredGarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0',
+  `FollowerGarrAbilityEffectID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CostMoney` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_building_locale`
+--
+
+DROP TABLE IF EXISTS `garr_building_locale`;
+CREATE TABLE `garr_building_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `NameAlliance_lang` text,
+  `NameHorde_lang` text,
+  `Description_lang` text,
+  `Tooltip_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_building_plot_inst`
+--
+
+DROP TABLE IF EXISTS `garr_building_plot_inst`;
+CREATE TABLE `garr_building_plot_inst` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrBuildingID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UiTextureAtlasMemberID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrSiteLevelPlotInstID` int(10) unsigned NOT NULL DEFAULT '0',
+  `LandmarkOffsetX` float NOT NULL DEFAULT '0',
+  `LandmarkOffsetY` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_plot`
+--
+
+DROP TABLE IF EXISTS `garr_plot`;
+CREATE TABLE `garr_plot` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrPlotUICategoryID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PlotType` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `MinCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `AllianceConstructionGameObjectID` int(10) unsigned NOT NULL DEFAULT '0',
+  `HordeConstructionGameObjectID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_plot_locale`
+--
+
+DROP TABLE IF EXISTS `garr_plot_locale`;
+CREATE TABLE `garr_plot_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_plot_building`
+--
+
+DROP TABLE IF EXISTS `garr_plot_building`;
+CREATE TABLE `garr_plot_building` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrBuildingID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_plot_instance`
+--
+
+DROP TABLE IF EXISTS `garr_plot_instance`;
+CREATE TABLE `garr_plot_instance` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_plot_instance_locale`
+--
+
+DROP TABLE IF EXISTS `garr_plot_instance_locale`;
+CREATE TABLE `garr_plot_instance_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_site_level`
+--
+
+DROP TABLE IF EXISTS `garr_site_level`;
+CREATE TABLE `garr_site_level` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Level` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SiteID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UITextureKitID` int(10) unsigned NOT NULL DEFAULT '0',
+  `TownHallX` float NOT NULL DEFAULT '0',
+  `TownHallY` float NOT NULL DEFAULT '0',
+  `MovieID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Level2` int(10) unsigned NOT NULL DEFAULT '0',
+  `UpgradeResourceCost` int(10) unsigned NOT NULL DEFAULT '0',
+  `UpgradeMoneyCost` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `garr_site_level_plot_inst`
+--
+
+DROP TABLE IF EXISTS `garr_site_level_plot_inst`;
+CREATE TABLE `garr_site_level_plot_inst` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrSiteLevelID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrPlotInstanceID` int(10) unsigned NOT NULL DEFAULT '0',
+  `LandmarkX` float NOT NULL DEFAULT '0',
+  `LandmarkY` float NOT NULL DEFAULT '0',
+  `Unknown` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;