From 9b924522d0549dd67b10e2cbdfc20297dd21e182 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 2 Jan 2020 14:19:35 +0100 Subject: Core/Instances: Delete InstanceSaveMgr and replace most of its uses with new InstanceLockMgr --- sql/base/characters_database.sql | 79 +--------------------------------------- 1 file changed, 2 insertions(+), 77 deletions(-) (limited to 'sql/base/characters_database.sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 9f9f7482298..8fed83db228 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1093,32 +1093,6 @@ LOCK TABLES `character_homebind` WRITE; /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `character_instance` --- - -DROP TABLE IF EXISTS `character_instance`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `character_instance` ( - `guid` bigint unsigned NOT NULL DEFAULT '0', - `instance` int unsigned NOT NULL DEFAULT '0', - `permanent` tinyint unsigned NOT NULL DEFAULT '0', - `extendState` tinyint unsigned NOT NULL DEFAULT '1', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `character_instance` --- - -LOCK TABLES `character_instance` WRITE; -/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `character_instance_lock` -- @@ -2174,31 +2148,6 @@ LOCK TABLES `gm_suggestion` WRITE; /*!40000 ALTER TABLE `gm_suggestion` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `group_instance` --- - -DROP TABLE IF EXISTS `group_instance`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `group_instance` ( - `guid` int unsigned NOT NULL DEFAULT '0', - `instance` int unsigned NOT NULL DEFAULT '0', - `permanent` tinyint unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`guid`,`instance`), - KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `group_instance` --- - -LOCK TABLES `group_instance` WRITE; -/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */; -/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `group_member` -- @@ -2637,31 +2586,6 @@ LOCK TABLES `instance` WRITE; /*!40000 ALTER TABLE `instance` ENABLE KEYS */; UNLOCK TABLES; --- --- Table structure for table `instance_reset` --- - -DROP TABLE IF EXISTS `instance_reset`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `instance_reset` ( - `mapid` smallint unsigned NOT NULL DEFAULT '0', - `difficulty` tinyint unsigned NOT NULL DEFAULT '0', - `resettime` bigint NOT NULL DEFAULT '0', - PRIMARY KEY (`mapid`,`difficulty`), - KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `instance_reset` --- - -LOCK TABLES `instance_reset` WRITE; -/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; -/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; -UNLOCK TABLES; - -- -- Table structure for table `instance_scenario_progress` -- @@ -3704,7 +3628,8 @@ INSERT INTO `updates` VALUES ('2022_08_19_00_characters.sql','1C076A24F2B48F32E8EF835C01F8907CA9E86491','ARCHIVED','2022-08-19 23:43:01',0), ('2022_08_21_00_characters.sql','1D75688392FBDA18CD8494F32CF682DCB49642EC','ARCHIVED','2022-08-21 00:02:03',0), ('2022_09_18_00_characters.sql','A7DF0C1F0E074F3E63A6CDD0AF873A1F3DC33B29','RELEASED','2022-09-18 21:48:42',0), -('2022_10_03_00_characters.sql','7B062787230D9158A622EB4AFE7FA6D18AB47BB3','RELEASED','2022-10-03 22:32:58',0); +('2022_10_03_00_characters.sql','7B062787230D9158A622EB4AFE7FA6D18AB47BB3','RELEASED','2022-10-03 22:32:58',0), +('2022_10_03_01_characters.sql','7CF58BD9CC366301CC992017028568C8774C4BC2','RELEASED','2022-10-03 22:36:38',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3