aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2021-10-15 10:18:03 +0000
committerTDB Release <tdb-release@build.bot>2021-10-15 10:18:03 +0000
commit251ad7f8a838c0de1495b351ad6bead2e5968896 (patch)
tree0b0b57124142e16bcb4ac4396c6a624040fa3a11 /sql/base
parent990e4d86576751c517549eecc0747b2a8b65129a (diff)
TDB 910.21101 - 2021/10/15TDB910.21101
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql15
-rw-r--r--sql/base/characters_database.sql7
-rw-r--r--sql/base/dev/hotfixes_database.sql19
-rw-r--r--sql/base/dev/world_database.sql227
4 files changed, 171 insertions, 97 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index eb063d433e4..5c3f6b59337 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2353,7 +2353,7 @@ INSERT INTO `updates` VALUES
('2018_02_18_00_auth.sql','8489DD3EFFE14A7486B593435F0BA2BC69B6EABF','ARCHIVED','2018-02-18 16:35:55',0),
('2018_02_19_00_auth.sql','07CE658C5EF88693D3C047EF8E724F94ADA74C15','ARCHIVED','2018-02-19 22:33:32',0),
('2018_02_28_00_auth.sql','E92EF4ABF7FA0C66649E1633DD0459F44C09EB83','ARCHIVED','2018-02-28 23:07:59',0),
-('2018_03_08_00_auth.sql','624C58A07E0B4DDC4C1347E8BA8EFEEFD5B43DA7','RELEASED','2018-01-12 15:10:11',0),
+('2018_03_08_00_auth.sql','624C58A07E0B4DDC4C1347E8BA8EFEEFD5B43DA7','ARCHIVED','2018-01-12 15:10:11',0),
('2018_03_14_00_auth.sql','2D71E93DF7419A30D0D21D8A80CF05698302575A','ARCHIVED','2018-03-14 23:07:59',0),
('2018_04_06_00_auth.sql','D8416F0C4751763202B1997C81423F6EE2FCF9A6','ARCHIVED','2018-04-06 18:00:32',0),
('2018_05_13_00_auth.sql','A9E20F2EB1E2FDBB982DB6B00DB7301852B27CD4','ARCHIVED','2018-05-13 20:22:32',0),
@@ -2423,11 +2423,12 @@ INSERT INTO `updates` VALUES
('2021_07_04_00_auth.sql','3CF056F8F04E49C1E236060202AA8DA7E186B590','ARCHIVED','2021-07-04 22:23:24',0),
('2021_08_07_00_auth.sql','D615C2CACC999FF8804AEF56BAAA08D02217D671','ARCHIVED','2021-08-07 23:18:57',0),
('2021_08_18_00_auth.sql','162590897AC0020E68EB6845637901C3EB6509B4','ARCHIVED','2021-08-18 15:14:17',0),
-('2021_08_19_00_auth.sql','DE008EDFB1FEBA49567E245A64BFE70DA72D9E7B','RELEASED','2021-08-19 10:58:58',0),
-('2021_09_02_00_auth.sql','907344F4F0113A13D5E0A1D95E2C3E4C4150090C','RELEASED','2021-09-02 12:38:08',0),
-('2021_09_10_00_auth.sql','DE94812ABC7B395C6C3405FB6718A8AF2C9F8FEC','RELEASED','2021-09-10 12:18:54',0),
-('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','RELEASED','2021-10-07 10:32:05',0),
-('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','RELEASED','2021-10-13 21:15:05',0);
+('2021_08_19_00_auth.sql','DE008EDFB1FEBA49567E245A64BFE70DA72D9E7B','ARCHIVED','2021-08-19 10:58:58',0),
+('2021_09_02_00_auth.sql','907344F4F0113A13D5E0A1D95E2C3E4C4150090C','ARCHIVED','2021-09-02 12:38:08',0),
+('2021_09_10_00_auth.sql','DE94812ABC7B395C6C3405FB6718A8AF2C9F8FEC','ARCHIVED','2021-09-10 12:18:54',0),
+('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','ARCHIVED','2021-10-07 10:32:05',0),
+('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','ARCHIVED','2021-10-13 21:15:05',0),
+('2021_10_15_00_auth.sql','C8AA212AB2BB2DB5B3C2C9622A3874475AEFBD7B','ARCHIVED','2021-10-15 10:11:47',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2500,4 +2501,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-18 15:14:18
+-- Dump completed on 2021-10-15 10:11:48
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index e1c4d6162cd..54a95be7806 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3721,8 +3721,9 @@ INSERT INTO `updates` VALUES
('2021_07_04_00_characters.sql','E0E7AD664DDB553E96B457DD9ED8976665E94007','ARCHIVED','2021-07-04 22:23:24',0),
('2021_08_11_00_characters.sql','2137A52A45B045104B97D39626CE3C0214625B17','ARCHIVED','2021-08-11 21:48:57',0),
('2021_08_18_00_characters.sql','5BA1326EE8EC907CDE82E6E8BCB38EA2E661F10A','ARCHIVED','2021-08-18 15:14:17',0),
-('2021_10_02_00_characters.sql','31CEACE4E9A4BE58A659A2BDE4A7C51D2DB8AC41','RELEASED','2021-10-02 21:21:37',0),
-('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','RELEASED','2021-10-02 21:47:38',0);
+('2021_10_02_00_characters.sql','31CEACE4E9A4BE58A659A2BDE4A7C51D2DB8AC41','ARCHIVED','2021-10-02 21:21:37',0),
+('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','ARCHIVED','2021-10-02 21:47:38',0),
+('2021_10_15_00_characters.sql','906FECD65CBA7C406969F45FDF28DDEF8AAF8715','ARCHIVED','2021-10-15 10:11:47',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3821,4 +3822,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-18 15:14:18
+-- Dump completed on 2021-10-15 10:11:48
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 917a38e1065..d27b8f2a777 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -7663,6 +7663,23 @@ CREATE TABLE `spell_reagents` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `spell_reagents_currency`
+--
+
+DROP TABLE IF EXISTS `spell_reagents_currency`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_reagents_currency` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID` int(11) NOT NULL DEFAULT '0',
+ `CurrencyTypesID` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `CurrencyCount` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `spell_scaling`
--
@@ -8799,4 +8816,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-18 15:14:20
+-- Dump completed on 2021-10-15 10:11:51
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index ee2d8694807..21798f11323 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -112,12 +112,108 @@ CREATE TABLE `areatrigger` (
`PhaseUseFlags` tinyint(3) unsigned DEFAULT '0',
`PhaseId` int(10) unsigned DEFAULT '0',
`PhaseGroup` int(10) unsigned DEFAULT '0',
+ `Shape` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `ShapeData0` float NOT NULL DEFAULT '0',
+ `ShapeData1` float NOT NULL DEFAULT '0',
+ `ShapeData2` float NOT NULL DEFAULT '0',
+ `ShapeData3` float NOT NULL DEFAULT '0',
+ `ShapeData4` float NOT NULL DEFAULT '0',
+ `ShapeData5` float NOT NULL DEFAULT '0',
`Comment` varchar(255) DEFAULT NULL,
PRIMARY KEY (`SpawnId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `areatrigger_create_properties`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties` (
+ `Id` int(10) unsigned NOT NULL,
+ `AreaTriggerId` int(10) unsigned NOT NULL,
+ `MoveCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+ `ScaleCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+ `MorphCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+ `FacingCurveId` int(10) unsigned NOT NULL DEFAULT '0',
+ `AnimId` int(11) NOT NULL DEFAULT '0',
+ `AnimKitId` int(11) NOT NULL DEFAULT '0',
+ `DecalPropertiesId` int(10) unsigned NOT NULL DEFAULT '0',
+ `TimeToTarget` int(10) unsigned NOT NULL DEFAULT '0',
+ `TimeToTargetScale` int(10) unsigned NOT NULL DEFAULT '0',
+ `Shape` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `ShapeData0` float NOT NULL DEFAULT '0',
+ `ShapeData1` float NOT NULL DEFAULT '0',
+ `ShapeData2` float NOT NULL DEFAULT '0',
+ `ShapeData3` float NOT NULL DEFAULT '0',
+ `ShapeData4` float NOT NULL DEFAULT '0',
+ `ShapeData5` float NOT NULL DEFAULT '0',
+ `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_orbit`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_orbit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_orbit` (
+ `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+ `StartDelay` int(10) unsigned NOT NULL DEFAULT '0',
+ `CircleRadius` float NOT NULL DEFAULT '0',
+ `BlendFromRadius` float NOT NULL DEFAULT '0',
+ `InitialAngle` float NOT NULL DEFAULT '0',
+ `ZOffset` float NOT NULL DEFAULT '0',
+ `CounterClockwise` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `CanLoop` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`AreaTriggerCreatePropertiesId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_polygon_vertex`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_polygon_vertex`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_polygon_vertex` (
+ `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+ `Idx` int(10) unsigned NOT NULL,
+ `VerticeX` float NOT NULL DEFAULT '0',
+ `VerticeY` float NOT NULL DEFAULT '0',
+ `VerticeTargetX` float DEFAULT NULL,
+ `VerticeTargetY` float DEFAULT NULL,
+ `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`AreaTriggerCreatePropertiesId`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `areatrigger_create_properties_spline_point`
+--
+
+DROP TABLE IF EXISTS `areatrigger_create_properties_spline_point`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `areatrigger_create_properties_spline_point` (
+ `AreaTriggerCreatePropertiesId` int(10) unsigned NOT NULL,
+ `Idx` int(10) unsigned NOT NULL,
+ `X` float NOT NULL DEFAULT '0',
+ `Y` float NOT NULL DEFAULT '0',
+ `Z` float NOT NULL DEFAULT '0',
+ `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`AreaTriggerCreatePropertiesId`,`Idx`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `areatrigger_involvedrelation`
--
@@ -217,25 +313,6 @@ CREATE TABLE `areatrigger_template_actions` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `areatrigger_template_polygon_vertices`
---
-
-DROP TABLE IF EXISTS `areatrigger_template_polygon_vertices`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `areatrigger_template_polygon_vertices` (
- `AreaTriggerId` int(10) unsigned NOT NULL,
- `Idx` int(10) unsigned NOT NULL,
- `VerticeX` float NOT NULL DEFAULT '0',
- `VerticeY` float NOT NULL DEFAULT '0',
- `VerticeTargetX` float DEFAULT NULL,
- `VerticeTargetY` float DEFAULT NULL,
- `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`AreaTriggerId`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `battle_pet_breeds`
--
@@ -627,6 +704,23 @@ CREATE TABLE `creature_model_info` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_movement_override`
+--
+
+DROP TABLE IF EXISTS `creature_movement_override`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_movement_override` (
+ `SpawnId` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`SpawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_onkill_reputation`
--
@@ -781,7 +875,6 @@ CREATE TABLE `creature_template` (
`maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
`AIName` varchar(64) NOT NULL DEFAULT '',
`MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
`HoverHeight` float NOT NULL DEFAULT '1',
`HealthModifier` float NOT NULL DEFAULT '1',
`HealthModifierExtra` float NOT NULL DEFAULT '1',
@@ -866,6 +959,23 @@ CREATE TABLE `creature_template_model` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_template_movement`
+--
+
+DROP TABLE IF EXISTS `creature_template_movement`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_template_movement` (
+ `CreatureId` int(10) unsigned NOT NULL DEFAULT '0',
+ `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`CreatureId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_template_scaling`
--
@@ -1311,7 +1421,7 @@ CREATE TABLE `game_tele` (
`map` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1689 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
+) ENGINE=MyISAM AUTO_INCREMENT=1758 DEFAULT CHARSET=utf8 COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -2538,11 +2648,19 @@ CREATE TABLE `playercreateinfo` (
`race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`map` smallint(5) unsigned NOT NULL DEFAULT '0',
- `zone` mediumint(8) unsigned NOT NULL DEFAULT '0',
`position_x` float NOT NULL DEFAULT '0',
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
+ `npe_map` int(10) unsigned DEFAULT NULL,
+ `npe_position_x` float DEFAULT NULL,
+ `npe_position_y` float DEFAULT NULL,
+ `npe_position_z` float DEFAULT NULL,
+ `npe_orientation` float DEFAULT NULL,
+ `npe_transport_guid` bigint(20) unsigned DEFAULT NULL,
+ `intro_movie_id` int(10) unsigned DEFAULT NULL,
+ `intro_scene_id` int(10) unsigned DEFAULT NULL,
+ `npe_intro_scene_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3790,69 +3908,6 @@ CREATE TABLE `spell_area` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `spell_areatrigger`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger` (
- `SpellMiscId` int(10) unsigned NOT NULL,
- `AreaTriggerId` int(10) unsigned NOT NULL,
- `MoveCurveId` int(10) unsigned NOT NULL DEFAULT '0',
- `ScaleCurveId` int(10) unsigned NOT NULL DEFAULT '0',
- `MorphCurveId` int(10) unsigned NOT NULL DEFAULT '0',
- `FacingCurveId` int(10) unsigned NOT NULL DEFAULT '0',
- `AnimId` int(11) NOT NULL DEFAULT '0',
- `AnimKitId` int(11) NOT NULL DEFAULT '0',
- `DecalPropertiesId` int(10) unsigned NOT NULL DEFAULT '0',
- `TimeToTarget` int(10) unsigned NOT NULL DEFAULT '0',
- `TimeToTargetScale` int(10) unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`SpellMiscId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `spell_areatrigger_circular`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger_circular`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger_circular` (
- `SpellMiscId` int(10) unsigned NOT NULL,
- `StartDelay` int(10) unsigned NOT NULL DEFAULT '0',
- `CircleRadius` float NOT NULL DEFAULT '0',
- `BlendFromRadius` float NOT NULL DEFAULT '0',
- `InitialAngle` float NOT NULL DEFAULT '0',
- `ZOffset` float NOT NULL DEFAULT '0',
- `CounterClockwise` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `CanLoop` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`SpellMiscId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `spell_areatrigger_splines`
---
-
-DROP TABLE IF EXISTS `spell_areatrigger_splines`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `spell_areatrigger_splines` (
- `SpellMiscId` int(10) unsigned NOT NULL,
- `Idx` int(10) unsigned NOT NULL,
- `X` float NOT NULL DEFAULT '0',
- `Y` float NOT NULL DEFAULT '0',
- `Z` float NOT NULL DEFAULT '0',
- `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`SpellMiscId`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `spell_custom_attr`
--
@@ -4450,4 +4505,4 @@ CREATE TABLE `world_safe_locs` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-18 15:14:19
+-- Dump completed on 2021-10-15 10:11:49