/*
SQLyog Professional v13.1.7 (64 bit)
MySQL - 8.0.21 : Database - asc_world_new
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `spell_area` */

CREATE TABLE `spell_area` (
  `spell` mediumint unsigned NOT NULL DEFAULT '0',
  `area` mediumint unsigned NOT NULL DEFAULT '0',
  `quest_start` mediumint unsigned NOT NULL DEFAULT '0',
  `quest_start_active` tinyint unsigned NOT NULL DEFAULT '0',
  `quest_end` mediumint unsigned NOT NULL DEFAULT '0',
  `aura_spell` mediumint NOT NULL DEFAULT '0',
  `racemask` mediumint unsigned NOT NULL DEFAULT '0',
  `gender` tinyint unsigned NOT NULL DEFAULT '2',
  `autocast` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`spell`,`area`,`quest_start`,`quest_start_active`,`aura_spell`,`racemask`,`gender`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `spell_area` */

insert  into `spell_area`(`spell`,`area`,`quest_start`,`quest_start_active`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) values (53405,4298,12779,0,0,0,0,2,1),(51915,4298,0,0,0,0,0,2,1),(54119,4028,0,0,0,0,0,2,1),(54119,4029,0,0,0,0,0,2,1),(54119,4031,0,0,0,0,0,2,1),(54119,4106,0,0,0,0,0,2,1),(35480,2367,0,0,0,0,690,0,1),(35481,2367,0,0,0,0,690,1,1),(35482,2367,0,0,0,0,1032,0,1),(35483,2367,0,0,0,0,1032,1,1),(45373,4075,0,0,0,0,0,2,0),(40567,3522,0,0,0,0,0,2,0),(40567,3923,0,0,0,0,0,2,0),(40568,3522,0,0,0,0,0,2,0),(40568,3923,0,0,0,0,0,2,0),(40572,3522,0,0,0,0,0,2,0),(40572,3923,0,0,0,0,0,2,0),(40573,3522,0,0,0,0,0,2,0),(40573,3923,0,0,0,0,0,2,0),(40575,3522,0,0,0,0,0,2,0),(40575,3923,0,0,0,0,0,2,0),(40576,3522,0,0,0,0,0,2,0),(40576,3923,0,0,0,0,0,2,0),(41608,3606,0,0,0,0,0,2,0),(41608,3607,0,0,0,0,0,2,0),(41608,3845,0,0,0,0,0,2,0),(41608,3847,0,0,0,0,0,2,0),(41608,3848,0,0,0,0,0,2,0),(41608,3849,0,0,0,0,0,2,0),(41608,3959,0,0,0,0,0,2,0),(41608,4075,0,0,0,0,0,2,0),(41609,3606,0,0,0,0,0,2,0),(41609,3607,0,0,0,0,0,2,0),(41609,3845,0,0,0,0,0,2,0),(41609,3847,0,0,0,0,0,2,0),(41609,3848,0,0,0,0,0,2,0),(41609,3849,0,0,0,0,0,2,0),(41609,3959,0,0,0,0,0,2,0),(41609,4075,0,0,0,0,0,2,0),(41610,3606,0,0,0,0,0,2,0),(41610,3607,0,0,0,0,0,2,0),(41610,3845,0,0,0,0,0,2,0),(41610,3847,0,0,0,0,0,2,0),(41610,3848,0,0,0,0,0,2,0),(41610,3849,0,0,0,0,0,2,0),(41610,3959,0,0,0,0,0,2,0),(41610,4075,0,0,0,0,0,2,0),(41611,3606,0,0,0,0,0,2,0),(41611,3607,0,0,0,0,0,2,0),(41611,3845,0,0,0,0,0,2,0),(41611,3847,0,0,0,0,0,2,0),(41611,3848,0,0,0,0,0,2,0),(41611,3849,0,0,0,0,0,2,0),(41611,3959,0,0,0,0,0,2,0),(41611,4075,0,0,0,0,0,2,0),(46837,3606,0,0,0,0,0,2,0),(46837,3607,0,0,0,0,0,2,0),(46837,3845,0,0,0,0,0,2,0),(46837,3847,0,0,0,0,0,2,0),(46837,3848,0,0,0,0,0,2,0),(46837,3849,0,0,0,0,0,2,0),(46837,3959,0,0,0,0,0,2,0),(46837,4075,0,0,0,0,0,2,0),(46839,3606,0,0,0,0,0,2,0),(46839,3607,0,0,0,0,0,2,0),(46839,3845,0,0,0,0,0,2,0),(46839,3847,0,0,0,0,0,2,0),(46839,3848,0,0,0,0,0,2,0),(46839,3849,0,0,0,0,0,2,0),(46839,3959,0,0,0,0,0,2,0),(46839,4075,0,0,0,0,0,2,0),(41618,3845,0,0,0,0,0,2,0),(41618,3847,0,0,0,0,0,2,0),(41618,3848,0,0,0,0,0,2,0),(41618,3849,0,0,0,0,0,2,0),(41620,3845,0,0,0,0,0,2,0),(41620,3847,0,0,0,0,0,2,0),(41620,3848,0,0,0,0,0,2,0),(41620,3849,0,0,0,0,0,2,0),(41617,3607,0,0,0,0,0,2,0),(41617,3715,0,0,0,0,0,2,0),(41617,3716,0,0,0,0,0,2,0),(41617,3717,0,0,0,0,0,2,0),(41619,3607,0,0,0,0,0,2,0),(41619,3715,0,0,0,0,0,2,0),(41619,3716,0,0,0,0,0,2,0),(41619,3717,0,0,0,0,0,2,0),(51852,4298,0,0,0,0,0,2,0),(53107,4298,12757,0,12779,0,0,2,1),(52597,4298,12706,0,12757,0,0,2,1),(52707,4298,12716,0,0,0,0,2,1),(52950,4298,12727,0,0,0,0,2,1),(52598,4298,12706,0,0,0,0,2,1),(53081,4298,12755,1,12756,0,0,2,1),(58530,0,13165,0,13188,-58354,1101,2,1),(58551,0,13165,0,13189,-58354,690,2,1),(58354,4281,13165,1,13189,0,690,2,1),(58354,4281,13165,1,13188,0,1101,2,1),(58361,4281,13166,1,13166,0,0,2,1),(40214,3759,11013,1,0,0,0,2,1),(40214,3939,11013,1,0,0,0,2,1),(40214,3966,11013,1,0,0,0,2,1),(51721,4281,12657,0,0,0,0,2,1),(51721,4342,12657,0,0,0,0,2,1),(33836,3803,0,0,0,0,0,2,0),(50426,4161,0,0,0,0,0,2,0),(50426,4173,0,0,0,0,0,2,0),(50426,4254,0,0,0,0,0,2,0),(46023,4116,0,0,0,0,0,2,0),(55173,210,0,0,0,8326,8,2,1),(55164,210,0,0,0,8326,65527,2,1),(55173,67,0,0,0,8326,8,2,1),(55164,67,0,0,0,8326,65527,2,1),(55173,4161,0,0,0,8326,8,2,1),(55164,4161,0,0,0,8326,65527,2,1),(52693,4298,12687,1,12687,0,0,2,1),(55012,4438,12856,1,12856,0,0,2,1),(55012,4437,12972,1,13063,0,0,2,1),(55012,4535,12905,1,0,0,0,2,1),(55012,4422,12905,1,0,0,0,2,1),(55012,4425,12905,1,0,0,0,2,1),(42316,2079,11142,1,0,0,1101,2,1),(44017,3990,11504,0,0,0,0,2,1),(35480,4100,0,0,0,0,690,0,1),(35481,4100,0,0,0,0,690,1,1),(35482,4100,0,0,0,0,1032,0,1),(35483,4100,0,0,0,0,1032,1,1),(64373,4670,0,0,0,0,0,2,1),(64373,4671,0,0,0,0,0,2,1),(64373,4673,0,0,0,0,0,2,1),(64373,4669,0,0,0,0,0,2,1),(64373,4672,0,0,0,0,0,2,1),(64373,4658,0,0,0,0,0,2,1),(68085,4742,0,0,0,0,0,2,1),(68085,4760,0,0,0,0,0,2,1),(72914,4535,12905,1,0,0,0,2,1),(72914,4438,12856,1,12856,0,0,2,1),(72914,4437,12972,1,13063,0,0,2,1),(72914,4425,12905,1,0,0,0,2,1),(72914,4422,12905,1,0,0,0,2,1),(54119,4269,0,0,0,0,0,2,1),(73822,4812,0,0,0,0,690,2,1),(69127,4812,0,0,0,0,0,2,1),(73828,4812,0,0,0,0,1101,2,1),(58600,4395,0,0,0,0,0,2,1),(58600,4560,0,0,0,0,0,2,1),(58600,4567,0,0,0,0,0,2,1),(58600,4568,0,0,0,0,0,2,1),(58600,4570,0,0,0,0,0,2,1),(58600,4598,0,0,0,0,0,2,1),(58600,4613,0,0,0,0,0,2,1),(58600,4614,0,0,0,0,0,2,1),(58600,4616,0,0,0,0,0,2,1),(58600,4618,0,0,0,0,0,2,1),(58600,4619,0,0,0,0,0,2,1),(58600,4620,0,0,0,0,0,2,1),(58600,4637,0,0,0,0,0,2,1),(58600,4739,0,0,0,0,0,2,1),(58600,4740,0,0,0,0,0,2,1),(57745,4591,13068,0,13082,0,0,2,1),(57673,4501,0,0,13086,0,0,2,1),(57673,4504,0,0,13086,0,0,2,1),(57673,4505,0,0,13086,0,0,2,1),(57673,4506,0,0,13086,0,0,2,1),(57673,4580,0,0,13086,0,0,2,1),(57673,4593,0,0,13086,0,0,2,1),(74411,3820,0,0,0,0,0,2,1),(74411,3869,0,0,0,0,0,2,1),(74411,3870,0,0,0,0,0,2,1),(74411,3871,0,0,0,0,0,2,1),(74411,3872,0,0,0,0,0,2,1),(74411,3358,0,0,0,0,0,2,1),(74411,3317,0,0,0,0,0,2,1),(74411,3418,0,0,0,0,0,2,1),(74411,3420,0,0,0,0,0,2,1),(74411,3421,0,0,0,0,0,2,1),(74411,3422,0,0,0,0,0,2,1),(74411,3424,0,0,0,0,0,2,1),(74411,3423,0,0,0,0,0,2,1),(74411,3277,0,0,0,0,0,2,1),(74411,3320,0,0,0,0,0,2,1),(74411,3321,0,0,0,0,0,2,1),(74411,4571,0,0,0,0,0,2,1),(74411,4572,0,0,0,0,0,2,1),(74411,2597,0,0,0,0,0,2,1),(74411,2957,0,0,0,0,0,2,1),(74411,2958,0,0,0,0,0,2,1),(74411,2959,0,0,0,0,0,2,1),(74411,2960,0,0,0,0,0,2,1),(74411,2961,0,0,0,0,0,2,1),(74411,2962,0,0,0,0,0,2,1),(74411,2963,0,0,0,0,0,2,1),(74411,2964,0,0,0,0,0,2,1),(74411,2977,0,0,0,0,0,2,1),(74411,2978,0,0,0,0,0,2,1),(74411,3017,0,0,0,0,0,2,1),(74411,3057,0,0,0,0,0,2,1),(74411,3058,0,0,0,0,0,2,1),(74411,3297,0,0,0,0,0,2,1),(74411,3298,0,0,0,0,0,2,1),(74411,3299,0,0,0,0,0,2,1),(74411,3300,0,0,0,0,0,2,1),(74411,3301,0,0,0,0,0,2,1),(74411,3302,0,0,0,0,0,2,1),(74411,3303,0,0,0,0,0,2,1),(74411,3304,0,0,0,0,0,2,1),(74411,3305,0,0,0,0,0,2,1),(74411,3306,0,0,0,0,0,2,1),(74411,3318,0,0,0,0,0,2,1),(74411,3337,0,0,0,0,0,2,1),(74411,3338,0,0,0,0,0,2,1),(74411,4407,0,0,0,0,0,2,1),(74411,4408,0,0,0,0,0,2,1),(74411,4384,0,0,0,0,0,2,1),(74411,4604,0,0,0,0,0,2,1),(74411,4605,0,0,0,0,0,2,1),(74411,4606,0,0,0,0,0,2,1),(74411,4607,0,0,0,0,0,2,1),(74411,4608,0,0,0,0,0,2,1),(74411,4609,0,0,0,0,0,2,1),(74411,4610,0,0,0,0,0,2,1),(74411,4710,0,0,0,0,0,2,1),(74411,4741,0,0,0,0,0,2,1),(74411,4747,0,0,0,0,0,2,1),(74411,4748,0,0,0,0,0,2,1),(74411,4749,0,0,0,0,0,2,1),(74411,4750,0,0,0,0,0,2,1),(74411,4751,0,0,0,0,0,2,1),(74411,4752,0,0,0,0,0,2,1),(74411,4753,0,0,0,0,0,2,1),(74410,4406,0,0,0,0,0,2,1),(74410,3968,0,0,0,0,0,2,1),(74410,3638,0,0,0,0,0,2,1),(74410,3698,0,0,0,0,0,2,1),(74410,3702,0,0,0,0,0,2,1),(74410,4378,0,0,0,0,0,2,1),(64576,4519,13847,1,13847,0,0,2,1),(64576,4519,13851,1,13851,0,0,2,1),(64576,4519,13852,1,13852,0,0,2,1),(64576,4519,13854,1,13854,0,0,2,1),(64576,4519,13855,1,13855,0,0,2,1),(64576,4519,13856,1,13856,0,0,2,1),(64576,4519,13857,1,13857,0,0,2,1),(64576,4519,13858,1,13858,0,0,2,1),(64576,4519,13859,1,13859,0,0,2,1),(64576,4519,13860,1,13860,0,0,2,1),(64576,4519,13861,1,13861,0,0,2,1),(64576,4519,13862,1,13862,0,0,2,1),(64576,4519,13863,1,13863,0,0,2,1),(64576,4519,13864,1,13864,0,0,2,1),(72293,4812,0,0,0,0,0,2,0),(73001,4892,0,0,0,0,0,2,0),(68719,4741,0,0,0,0,0,2,0),(68719,4747,0,0,0,0,0,2,0),(68719,4748,0,0,0,0,0,2,0),(68719,4749,0,0,0,0,0,2,0),(68719,4750,0,0,0,0,0,2,0),(68719,4751,0,0,0,0,0,2,0),(68719,4752,0,0,0,0,0,2,0),(68719,4753,0,0,0,0,0,2,0),(68719,4710,0,0,0,0,0,2,0),(68720,4741,0,0,0,0,0,2,0),(68720,4747,0,0,0,0,0,2,0),(68720,4748,0,0,0,0,0,2,0),(68720,4749,0,0,0,0,0,2,0),(68720,4750,0,0,0,0,0,2,0),(68720,4751,0,0,0,0,0,2,0),(68720,4752,0,0,0,0,0,2,0),(68720,4710,0,0,0,0,0,2,0),(68720,4753,0,0,0,0,0,2,0),(40214,3965,11013,1,0,0,0,2,1),(75434,393,25444,1,25444,0,0,2,1),(75434,367,25444,1,25444,0,0,2,1),(75434,14,25444,1,25444,0,0,2,1),(74982,368,25446,1,25446,0,0,2,1),(60197,4395,0,0,0,0,690,2,1),(60194,4395,0,0,0,0,1101,2,1),(64373,4666,0,0,0,0,0,2,1),(64373,4667,0,0,0,0,0,2,1),(64373,4674,0,0,0,0,0,2,1),(55164,4197,0,0,0,8326,65527,2,1),(48358,4151,0,0,0,0,0,2,1),(48358,4152,0,0,0,0,0,2,1),(48358,4153,0,0,0,0,0,2,1),(48358,4154,0,0,0,0,0,2,1),(48358,4155,0,0,0,0,0,2,1),(48358,4156,0,0,0,0,0,2,1),(48358,4157,0,0,0,0,0,2,1),(48358,4158,0,0,0,0,0,2,1),(48358,4160,0,0,0,0,0,2,1),(48358,4161,0,0,0,0,0,2,1),(48358,4162,0,0,0,0,0,2,1),(48358,4163,0,0,0,0,0,2,1),(48358,4164,0,0,0,0,0,2,1),(48358,4165,0,0,0,0,0,2,1),(48358,4166,0,0,0,0,0,2,1),(48358,4167,0,0,0,0,0,2,1),(48358,4168,0,0,0,0,0,2,1),(48358,4169,0,0,0,0,0,2,1),(48358,4170,0,0,0,0,0,2,1),(48358,4171,0,0,0,0,0,2,1),(48358,4172,0,0,0,0,0,2,1),(48358,4173,0,0,0,0,0,2,1),(48358,4174,0,0,0,0,0,2,1),(48358,4175,0,0,0,0,0,2,1),(48358,4176,0,0,0,0,0,2,1),(48358,4177,0,0,0,0,0,2,1),(48358,4178,0,0,0,0,0,2,1),(48358,4179,0,0,0,0,0,2,1),(48358,4180,0,0,0,0,0,2,1),(48358,4181,0,0,0,0,0,2,1),(48358,4182,0,0,0,0,0,2,1),(48358,4183,0,0,0,0,0,2,1),(48358,4184,0,0,0,0,0,2,1),(48358,4185,0,0,0,0,0,2,1),(48358,4186,0,0,0,0,0,2,1),(48358,4187,0,0,0,0,0,2,1),(48358,4188,0,0,0,0,0,2,1),(48358,4189,0,0,0,0,0,2,1),(48358,4190,0,0,0,0,0,2,1),(48358,4191,0,0,0,0,0,2,1),(48358,4192,0,0,0,0,0,2,1),(48358,4193,0,0,0,0,0,2,1),(48358,4194,0,0,0,0,0,2,1),(48358,4195,0,0,0,0,0,2,1),(48358,4198,0,0,0,0,0,2,1),(48358,4123,0,0,0,0,0,2,1),(48358,4124,0,0,0,0,0,2,1),(48358,4125,0,0,0,0,0,2,1),(48358,4127,0,0,0,0,0,2,1),(48358,4130,0,0,0,0,0,2,1),(48358,4132,0,0,0,0,0,2,1),(48358,4133,0,0,0,0,0,2,1),(48358,4134,0,0,0,0,0,2,1),(48358,4141,0,0,0,0,0,2,1),(48358,4143,0,0,0,0,0,2,1),(48358,4146,0,0,0,0,0,2,1),(48358,4396,0,0,0,0,0,2,1),(48358,4414,0,0,0,0,0,2,1),(48358,4478,0,0,0,0,0,2,1),(30181,4477,0,0,12896,0,1101,2,1),(30181,4477,0,0,12897,0,690,2,1),(55857,4455,12983,1,12983,0,0,2,1),(56526,4436,13007,1,13007,0,0,2,1),(56526,4435,13007,1,13007,0,0,2,1),(74276,4910,0,0,0,0,0,2,1),(67471,4658,13663,1,13663,0,0,2,1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
