aboutsummaryrefslogtreecommitdiff
path: root/sql/base/characters_database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base/characters_database.sql')
-rw-r--r--sql/base/characters_database.sql59
1 files changed, 2 insertions, 57 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index bed77f5de1f..21d4ff0ae5c 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2509,62 +2509,6 @@ LOCK TABLES `guild_eventlog` WRITE;
UNLOCK TABLES;
--
--- Table structure for table `guild_finder_applicant`
---
-
-DROP TABLE IF EXISTS `guild_finder_applicant`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `guild_finder_applicant` (
- `guildId` bigint(20) unsigned NOT NULL DEFAULT '0',
- `playerGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
- `availability` tinyint(3) unsigned DEFAULT '0',
- `classRole` tinyint(3) unsigned DEFAULT '0',
- `interests` tinyint(3) unsigned DEFAULT '0',
- `comment` varchar(255) DEFAULT NULL,
- `submitTime` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`guildId`,`playerGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `guild_finder_applicant`
---
-
-LOCK TABLES `guild_finder_applicant` WRITE;
-/*!40000 ALTER TABLE `guild_finder_applicant` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_finder_applicant` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `guild_finder_guild_settings`
---
-
-DROP TABLE IF EXISTS `guild_finder_guild_settings`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `guild_finder_guild_settings` (
- `guildId` bigint(20) unsigned NOT NULL,
- `availability` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `interests` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `listed` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `comment` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`guildId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `guild_finder_guild_settings`
---
-
-LOCK TABLES `guild_finder_guild_settings` WRITE;
-/*!40000 ALTER TABLE `guild_finder_guild_settings` DISABLE KEYS */;
-/*!40000 ALTER TABLE `guild_finder_guild_settings` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `guild_member`
--
@@ -3725,7 +3669,8 @@ INSERT INTO `updates` VALUES
('2021_10_02_00_characters.sql','31CEACE4E9A4BE58A659A2BDE4A7C51D2DB8AC41','ARCHIVED','2021-10-02 21:21:37',0),
('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','ARCHIVED','2021-10-02 21:47:38',0),
('2021_10_15_00_characters.sql','906FECD65CBA7C406969F45FDF28DDEF8AAF8715','ARCHIVED','2021-10-15 10:11:47',0),
-('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','RELEASED','2021-10-16 01:12:20',0);
+('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','RELEASED','2021-10-16 01:12:20',0),
+('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','RELEASED','2021-11-02 18:11:13',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;