diff options
Diffstat (limited to 'sql/base/dev')
| -rw-r--r-- | sql/base/dev/world_database.sql | 48 |
1 files changed, 33 insertions, 15 deletions
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index ef21172ddbb..32d12d9dcb5 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -623,20 +623,6 @@ CREATE TABLE `creature_template` ( `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0', `pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0', `skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0', - `resistance1` smallint(6) NOT NULL DEFAULT '0', - `resistance2` smallint(6) NOT NULL DEFAULT '0', - `resistance3` smallint(6) NOT NULL DEFAULT '0', - `resistance4` smallint(6) NOT NULL DEFAULT '0', - `resistance5` smallint(6) NOT NULL DEFAULT '0', - `resistance6` smallint(6) NOT NULL DEFAULT '0', - `spell1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell3` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell4` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell5` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0', `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0', `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0', `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -719,6 +705,38 @@ CREATE TABLE `creature_template_movement` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `creature_template_resistance` +-- + +DROP TABLE IF EXISTS `creature_template_resistance`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_template_resistance` ( + `CreatureID` mediumint(8) unsigned NOT NULL, + `School` tinyint(6) unsigned NOT NULL, + `Resistance` smallint(6) DEFAULT NULL, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`CreatureID`,`School`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_template_spell` +-- + +DROP TABLE IF EXISTS `creature_template_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_template_spell` ( + `CreatureID` mediumint(8) unsigned NOT NULL, + `Index` tinyint(6) unsigned NOT NULL DEFAULT '0', + `Spell` mediumint(8) unsigned DEFAULT NULL, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`CreatureID`,`Index`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `creature_text` -- @@ -3826,4 +3844,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-06-15 7:33:48 +-- Dump completed on 2019-07-15 5:57:44 |