/*
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 `world_db_version` */

CREATE TABLE `world_db_version` (
  `id` smallint NOT NULL AUTO_INCREMENT,
  `LastUpdate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='WorldDB version';

/*Data for the table `world_db_version` */

insert  into `world_db_version`(`id`,`LastUpdate`) values (1,'20180331-00_build_creature_properties'),(2,'20180331-01_world_db_version'),(3,'20180331-02_build_player_xp_for_level'),(4,'20180401-00_build_creature_properties'),(5,'20180401-01_build_gameobject_properties'),(6,'20180401-02_build_item_properties'),(7,'20180401-03_build_quest_properties'),(8,'20180401-04_build_map_info'),(9,'20180402-00_build_playercreateinfo'),(10,'20180403-00_build_totemdisplayids'),(11,'20180403-01_staticspawns'),(12,'20180403-02_spell_custom_override'),(13,'20180404-00_build_creature_spawns'),(14,'20180405-00_build_gameobject_spawns'),(15,'20180416-00_playercreateinfo'),(16,'20180417-00_playercreateinfo_misc'),(17,'20180418-00_playercreateinfo_introid'),(18,'20180418-01_playercreateinfo_faction'),(19,'20180418-02_playercreateinfo_displayid'),(20,'20180419-00_worgen_goblin_language'),(21,'20180420-00_recall'),(22,'20180420-01_event_properties'),(23,'20180422-00_quest_properties'),(24,'20180423-00_kezan_initiale_data'),(25,'20180423-01_missing_properties'),(26,'20180423-02_build_transports'),(27,'20180424-00_quest_text_fix'),(28,'20180427-00_world_db_version'),(29,'20180501-00_build_creature_properties'),(30,'20180501-01_creature_spawns'),(31,'20180501-02_gameobject_spawns'),(32,'20180619-01_misc_tbc'),(33,'20180916-02_update_utf8'),(37,'20180930-00_creature_properties'),(38,'20181006-00_spell_custom_override'),(39,'20181201-00_creature_quest_starter_ender'),(40,'20181201-01_gameobject_quest_starter_ender'),(41,'20181201-02_creature_quest_starter'),(42,'20181201-03_creature_quest_finisher'),(43,'20181201-04_gameobject_quest_starter'),(44,'20181201-05_gameobject_quest_finisher'),(45,'20181208-00_spell_coefficient_override'),(46,'20190114-00_spell_custom_override'),(47,'20190806-00_spell_required'),(48,'20190807-00_recall'),(49,'20191108-00_duplicate_event_spawns'),(50,'20191117-00_creature_properties_gossip'),(51,'20200221-00_utf8mb4_unicode_ci'),(52,'20200324-00_gossips'),(53,'20200428-00_gossips_actions'),(54,'20200428-01_gossips'),(55,'20200428-02_gossips'),(56,'20200429-00_gossips'),(57,'20200429-01_gameobject_event_spawns'),(58,'20200429-02_recall_fix'),(59,'20200430-00_new_years_spawns'),(60,'20201012-00_worldstring_tables'),(61,'20201116-00_instance_encounters'),(62,'20201209-00_remove_duplicate_spawns'),(63,'20201216-00_rename_event_properties'),(64,'20201216-01_creature_spawns'),(65,'20201220-00_creature_properties'),(66,'20201226-00_transport_data'),(67,'20210331-00_creature_properties'),(68,'20210413-00_creature_properties'),(69,'20210501-00_playercreateinfo_skills'),(70,'20210501-01_gossip_menu_option'),(71,'20210501-02_creature_spawn'),(72,'20210518-00_creature_properties_movement'),(73,'20210518-02_creature_movement'),(74,'20210521-00_creature_movement_override'),(75,'20210522-00_creature_script_waypoint'),(76,'20210525-00_creature_spawns'),(77,'20210605-00_creature_spawns'),(78,'20210605-01_creature_spawns'),(79,'20210620-00_npc_script_text'),(80,'20210620-01_npc_monstersay'),(81,'20210620-02_npc_text_cleanup'),(82,'20210621-00_world_db_version'),(83,'20210808-00_playercreateinfo'),(84,'20210814-00_guild_data'),(85,'20210814-01_creature_ai_scripts'),(86,'20210818-00_creature_ai_scripts'),(87,'20210818-01_creature_ai_scripts'),(88,'20210825-00_multiversion_corrections'),(89,'20210825-01_hardcoded_ai_scripts'),(90,'20210829-00_hardcoded_ai_scripts'),(91,'20210908-00_creature_spawns_waypoint'),(92,'20210930-00_group_spawns'),(93,'20211015-00_group_spawns'),(94,'20211015-01_fuelling_the_project'),(95,'20211025-00_magtheridon_spawns');

/*!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 */;
