From b01fba4bd9530213ee0c9547e09d1f16b3ce5d67 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 6 Jun 2021 00:11:06 +0200 Subject: Core/Reputation: Implemented paragon reputation --- sql/updates/hotfixes/master/2021_06_06_00_hotfixes.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_06_06_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/master/2021_06_06_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_06_06_00_hotfixes.sql new file mode 100644 index 00000000000..4f98b077074 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_06_06_00_hotfixes.sql @@ -0,0 +1,15 @@ +-- +-- Table structure for table `paragon_reputation` +-- +DROP TABLE IF EXISTS `paragon_reputation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `paragon_reputation` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FactionID` int(10) unsigned NOT NULL DEFAULT '0', + `LevelThreshold` int(11) NOT NULL DEFAULT '0', + `QuestID` int(11) 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 */; -- cgit v1.2.3