From 27cba3f52309dad5be964fec11d80cd8cad128cf Mon Sep 17 00:00:00 2001 From: Meji Date: Tue, 8 Feb 2022 23:23:05 +0100 Subject: Core/Scripts: Added script hook to execute actions after completing an achievement (#27718) --- sql/updates/world/master/2022_02_08_00_world.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/master/2022_02_08_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_02_08_00_world.sql b/sql/updates/world/master/2022_02_08_00_world.sql new file mode 100644 index 00000000000..c8078a19e6d --- /dev/null +++ b/sql/updates/world/master/2022_02_08_00_world.sql @@ -0,0 +1,24 @@ +-- +-- Table structure for table `achievement_scripts` +-- + +DROP TABLE IF EXISTS `achievement_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `achievement_scripts` ( + `AchievementId` int NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + PRIMARY KEY (`AchievementId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `achievement_scripts` +-- +LOCK TABLES `achievement_scripts` WRITE; +/*!40000 ALTER TABLE `achievement_scripts` DISABLE KEYS */; +INSERT INTO `achievement_scripts` (`AchievementId`, `ScriptName`) VALUES +(6566,'achievement_just_a_pup'), +(7433,'achievement_newbie'); +/*!40000 ALTER TABLE `achievement_scripts` ENABLE KEYS */; +UNLOCK TABLES; -- cgit v1.2.3