db_valkyrja.sql

-- MariaDB dump 10.17  Distrib 10.4.13-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: db_valkyrja
-- ------------------------------------------------------
-- Server version	10.4.13-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 `antispam_urls`
--

DROP TABLE IF EXISTS `antispam_urls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `antispam_urls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `blacklist`
--

DROP TABLE IF EXISTS `blacklist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blacklist` (
  `id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `category_member_roles`
--

DROP TABLE IF EXISTS `category_member_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category_member_roles` (
  `serverid` bigint(20) unsigned NOT NULL,
  `mod_roleid` bigint(20) unsigned NOT NULL,
  `member_roleid` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`serverid`,`mod_roleid`,`member_roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `channels`
--

DROP TABLE IF EXISTS `channels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channels` (
  `serverid` bigint(20) unsigned NOT NULL,
  `channelid` bigint(20) unsigned NOT NULL,
  `ignored` tinyint(1) NOT NULL DEFAULT 0,
  `temporary` tinyint(1) NOT NULL DEFAULT 0,
  `muted_until` datetime NOT NULL,
  `muted` tinyint(1) NOT NULL DEFAULT 0,
  `auto_announce` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`channelid`),
  UNIQUE KEY `channelid` (`channelid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `command_channel_options`
--

DROP TABLE IF EXISTS `command_channel_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `command_channel_options` (
  `serverid` bigint(20) unsigned NOT NULL,
  `commandid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channelid` bigint(20) unsigned NOT NULL,
  `blacklisted` tinyint(1) NOT NULL,
  `whitelisted` tinyint(1) NOT NULL,
  PRIMARY KEY (`serverid`,`commandid`,`channelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `command_options`
--

DROP TABLE IF EXISTS `command_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `command_options` (
  `serverid` bigint(20) unsigned NOT NULL,
  `commandid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission_overrides` tinyint(4) NOT NULL,
  `delete_request` tinyint(1) NOT NULL,
  `delete_reply` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`,`commandid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `custom_aliases`
--

DROP TABLE IF EXISTS `custom_aliases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_aliases` (
  `serverid` bigint(20) unsigned NOT NULL,
  `commandid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`serverid`,`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `custom_commands`
--

DROP TABLE IF EXISTS `custom_commands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_commands` (
  `serverid` bigint(20) unsigned NOT NULL,
  `commandid` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `response` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mentions_enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`,`commandid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `serverid` bigint(20) unsigned NOT NULL,
  `userid` bigint(20) unsigned NOT NULL,
  `checkedin` tinyint(1) NOT NULL,
  `score` float NOT NULL,
  PRIMARY KEY (`serverid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `exceptions`
--

DROP TABLE IF EXISTS `exceptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exceptions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `shardid` bigint(20) NOT NULL,
  `serverid` bigint(20) unsigned NOT NULL,
  `datetime` datetime NOT NULL,
  `message` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stack` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2279 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `global_config`
--

DROP TABLE IF EXISTS `global_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `global_config` (
  `configuration_name` varchar(255) NOT NULL,
  `discord_token` varchar(255) NOT NULL,
  `userid` bigint(20) unsigned NOT NULL DEFAULT 278834060053446666,
  `admin_userid` bigint(20) unsigned NOT NULL DEFAULT 89805412676681728,
  `enforce_requirements` tinyint(1) NOT NULL DEFAULT 0,
  `verification_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `timers_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `polls_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `events_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `giveaways_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `livestream_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `total_shards` bigint(20) NOT NULL DEFAULT 1,
  `initial_update_delay` bigint(20) NOT NULL DEFAULT 1,
  `command_prefix` varchar(255) NOT NULL DEFAULT '!',
  `main_serverid` bigint(20) unsigned NOT NULL DEFAULT 155821059960995840,
  `main_channelid` bigint(20) unsigned NOT NULL DEFAULT 170139120318808065,
  `vip_skip_queue` tinyint(1) NOT NULL DEFAULT 0,
  `vip_members_max` bigint(20) NOT NULL DEFAULT 0,
  `vip_trial_hours` bigint(20) NOT NULL DEFAULT 36,
  `vip_trial_joins` bigint(20) NOT NULL DEFAULT 5,
  `antispam_clear_interval` bigint(20) NOT NULL DEFAULT 10,
  `antispam_safety_limit` bigint(20) NOT NULL DEFAULT 30,
  `antispam_fastmessages_per_update` bigint(20) NOT NULL DEFAULT 5,
  `antispam_update_interval` bigint(20) NOT NULL DEFAULT 6,
  `antispam_message_cache_size` bigint(20) NOT NULL DEFAULT 6,
  `antispam_allowed_duplicates` bigint(20) NOT NULL DEFAULT 2,
  `target_fps` float NOT NULL DEFAULT 0.05,
  `operations_max` bigint(20) NOT NULL DEFAULT 2,
  `operations_extra` bigint(20) NOT NULL DEFAULT 1,
  `maintenance_memory_threshold` bigint(20) NOT NULL DEFAULT 3000,
  `maintenance_thread_threshold` bigint(20) NOT NULL DEFAULT 44,
  `maintenance_operations_threshold` bigint(20) NOT NULL DEFAULT 300,
  `maintenance_disconnect_threshold` bigint(20) NOT NULL DEFAULT 20,
  `log_debug` tinyint(1) NOT NULL DEFAULT 0,
  `log_exceptions` tinyint(1) NOT NULL DEFAULT 1,
  `log_commands` tinyint(1) NOT NULL DEFAULT 1,
  `log_responses` tinyint(1) NOT NULL DEFAULT 1,
  `antispam_allowed_duplicateusers` bigint(20) NOT NULL DEFAULT 0,
  `antispam_duplicateusers_period` bigint(20) NOT NULL DEFAULT 0,
  `message_cache_size` bigint(20) NOT NULL DEFAULT 500,
  PRIMARY KEY (`configuration_name`),
  UNIQUE KEY `configuration_name` (`configuration_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `livestream`
--

DROP TABLE IF EXISTS `livestream`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `livestream` (
  `serverid` bigint(20) unsigned NOT NULL,
  `channelid` bigint(20) unsigned NOT NULL,
  `type` tinyint(4) NOT NULL,
  `channel` varchar(255) NOT NULL,
  `islive` tinyint(1) NOT NULL,
  PRIMARY KEY (`channelid`,`type`,`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `localisation`
--

DROP TABLE IF EXISTS `localisation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `localisation` (
  `id` bigint(20) unsigned NOT NULL,
  `moderation_ban_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '<|>_\\*fires them railguns at {0}*_  Ò_Ó<|>_\\*PewPewPew!!*_\nRIP {0}<|>',
  `moderation_mute_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '*Silence!!  ò_ó\n...\nI keel u, {0}!!*  Ò_Ó',
  `moderation_kick_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '<|>I\'ve fired them railguns at {0}.<|>Bye {0}! o/<|>',
  `moderation_op_missing` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '`{0}op`?',
  `moderation_op_enabled` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'Go get em tiger!',
  `moderation_op_disabled` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'All done?',
  `moderation_nth_infraction` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '`{0}` now has `{1}` infractions.',
  `role_promote_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'Done!',
  `role_demote_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'Done!',
  `role_join_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'Done!',
  `role_leave_done` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'Done!',
  `role_join_exclusiveremoved` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '\n_(I\'ve removed the other exclusive roles from the same role group.)_',
  `role_publicroles_print` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'You can use `{0}join` and `{0}leave` commands with these Public Roles: ',
  `role_publicroles_group` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT '\n\n**{0}** - you can join {1} of these:\n',
  `role_memberroles_print` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT 'You can use `{0}promote` and `{0}demote` commands with these Member Roles: {1}',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `messageid` bigint(20) unsigned NOT NULL,
  `serverid` bigint(20) unsigned NOT NULL,
  `channelid` bigint(20) unsigned NOT NULL,
  `userid` bigint(20) unsigned NOT NULL,
  `type` tinyint(4) NOT NULL,
  `datetime` datetime NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `logtype_timestamp` (`type`,`datetime`)
) ENGINE=InnoDB AUTO_INCREMENT=56393837 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `nicknames`
--

DROP TABLE IF EXISTS `nicknames`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nicknames` (
  `serverid` bigint(20) unsigned NOT NULL,
  `userid` bigint(20) unsigned NOT NULL,
  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`serverid`,`userid`,`nickname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `partners`
--

DROP TABLE IF EXISTS `partners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `partners` (
  `serverid` bigint(20) unsigned NOT NULL,
  `premium` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`),
  UNIQUE KEY `serverid` (`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `poll_options`
--

DROP TABLE IF EXISTS `poll_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `poll_options` (
  `serverid` bigint(20) unsigned NOT NULL,
  `option` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `polls`
--

DROP TABLE IF EXISTS `polls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `polls` (
  `serverid` bigint(20) unsigned NOT NULL,
  `title` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint(4) NOT NULL,
  PRIMARY KEY (`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `profile_options`
--

DROP TABLE IF EXISTS `profile_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile_options` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `property_order` bigint(20) NOT NULL DEFAULT 0,
  `option` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `option_alt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inline` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `quotes`
--

DROP TABLE IF EXISTS `quotes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quotes` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `id` bigint(20) NOT NULL DEFAULT 0,
  `created_time` datetime DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `reaction_roles`
--

DROP TABLE IF EXISTS `reaction_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reaction_roles` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `messageid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `emoji` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `role_groups`
--

DROP TABLE IF EXISTS `role_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_groups` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `groupid` bigint(20) NOT NULL DEFAULT 0,
  `role_limit` bigint(20) NOT NULL DEFAULT 1,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `serverid` bigint(20) unsigned NOT NULL,
  `roleid` bigint(20) unsigned NOT NULL,
  `permission_level` tinyint(4) NOT NULL DEFAULT 0,
  `public_id` bigint(20) NOT NULL DEFAULT 0,
  `logging_ignored` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_ignored` tinyint(1) NOT NULL DEFAULT 0,
  `level` bigint(20) NOT NULL DEFAULT 0,
  `delete_at_time` datetime NOT NULL DEFAULT from_unixtime(0),
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `server_config`
--

DROP TABLE IF EXISTS `server_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `server_config` (
  `serverid` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invite_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `localisation_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `timezone_utc_relative` bigint(20) NOT NULL DEFAULT 0,
  `use_database` tinyint(1) NOT NULL DEFAULT 1,
  `ignore_bots` tinyint(1) NOT NULL DEFAULT 1,
  `ignore_everyone` tinyint(1) NOT NULL DEFAULT 1,
  `command_prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '!',
  `command_prefix_alt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `execute_on_edit` tinyint(1) NOT NULL DEFAULT 1,
  `antispam_priority` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_invites` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_invites_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_duplicate` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_duplicate_crossserver` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_duplicate_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_mentions_max` bigint(20) NOT NULL DEFAULT 0,
  `antispam_mentions_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_mute` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_mute_duration` bigint(20) NOT NULL DEFAULT 5,
  `antispam_links_extended` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_extended_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_standard` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_standard_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_youtube` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_youtube_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_twitch` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_twitch_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_hitbox` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_hitbox_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_beam` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_beam_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_imgur` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_imgur_ban` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_tolerance` bigint(20) NOT NULL DEFAULT 2,
  `antispam_ignore_members` tinyint(1) NOT NULL DEFAULT 0,
  `operator_roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `quickban_duration` bigint(20) NOT NULL DEFAULT 0,
  `quickban_reason` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mute_roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `mute_ignore_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `karma_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `karma_limit_mentions` bigint(20) NOT NULL DEFAULT 5,
  `karma_limit_minutes` bigint(20) NOT NULL DEFAULT 30,
  `karma_limit_response` tinyint(1) NOT NULL DEFAULT 1,
  `karma_currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cookies',
  `karma_currency_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cookies',
  `karma_consume_command` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'nom',
  `karma_consume_verb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'nommed',
  `log_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `mod_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `log_bans` tinyint(1) NOT NULL DEFAULT 0,
  `log_promotions` tinyint(1) NOT NULL DEFAULT 0,
  `log_deletedmessages` tinyint(1) NOT NULL DEFAULT 0,
  `log_editedmessages` tinyint(1) NOT NULL DEFAULT 0,
  `activity_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `log_join` tinyint(1) NOT NULL DEFAULT 0,
  `log_leave` tinyint(1) NOT NULL DEFAULT 0,
  `log_message_join` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `log_message_leave` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `log_mention_join` tinyint(1) NOT NULL DEFAULT 0,
  `log_mention_leave` tinyint(1) NOT NULL DEFAULT 0,
  `log_timestamp_join` tinyint(1) NOT NULL DEFAULT 0,
  `log_timestamp_leave` tinyint(1) NOT NULL DEFAULT 0,
  `welcome_pm` tinyint(1) NOT NULL DEFAULT 0,
  `welcome_message` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `welcome_roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `verify` tinyint(1) NOT NULL DEFAULT 0,
  `verify_on_welcome` tinyint(1) NOT NULL DEFAULT 0,
  `verify_roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `verify_karma` bigint(20) NOT NULL DEFAULT 3,
  `verify_message` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exp_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `base_exp_to_levelup` bigint(20) NOT NULL,
  `exp_announce_levelup` tinyint(1) NOT NULL,
  `exp_per_message` bigint(20) NOT NULL,
  `exp_per_attachment` bigint(20) NOT NULL,
  `exp_cumulative_roles` tinyint(1) NOT NULL DEFAULT 0,
  `voice_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `antispam_voice_switching` tinyint(1) NOT NULL DEFAULT 0,
  `color_logmessages` int(10) unsigned NOT NULL DEFAULT 16776960,
  `color_modchannel` int(10) unsigned NOT NULL DEFAULT 16711680,
  `color_logchannel` int(10) unsigned NOT NULL DEFAULT 255,
  `color_activitychannel` int(10) unsigned NOT NULL DEFAULT 65535,
  `color_voicechannel` int(10) unsigned NOT NULL DEFAULT 65280,
  `embed_modchannel` tinyint(1) NOT NULL DEFAULT 0,
  `embed_logchannel` tinyint(1) NOT NULL DEFAULT 0,
  `embed_activitychannel` tinyint(1) NOT NULL DEFAULT 0,
  `embed_voicechannel` tinyint(1) NOT NULL DEFAULT 0,
  `karma_per_level` bigint(20) unsigned NOT NULL DEFAULT 3,
  `exp_max_level` bigint(20) unsigned NOT NULL DEFAULT 0,
  `exp_advance_users` tinyint(1) NOT NULL DEFAULT 0,
  `profile_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `memo_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `log_warnings` tinyint(1) NOT NULL DEFAULT 0,
  `color_logwarning` int(10) unsigned NOT NULL DEFAULT 16489984,
  `exp_member_messages` bigint(20) NOT NULL DEFAULT 0,
  `exp_member_roleid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `antispam_username` tinyint(1) NOT NULL DEFAULT 0,
  `alert_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `color_alertchannel` int(10) unsigned NOT NULL DEFAULT 10421504,
  `log_alert_regex` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `antispam_norole` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_porn` tinyint(1) NOT NULL DEFAULT 0,
  `tempchannel_categoryid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `profile_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `alert_role_mention` bigint(20) unsigned NOT NULL DEFAULT 0,
  `log_antispam_kick` tinyint(1) NOT NULL DEFAULT 0,
  `tempchannel_giveadmin` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_mute_insteadof_ban` tinyint(1) NOT NULL DEFAULT 0,
  `nicknames` tinyint(1) NOT NULL DEFAULT 1,
  `tos` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_duplicate_multiuser` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_tolerance_ban` bigint(20) NOT NULL DEFAULT 6,
  `alert_whitelistid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `antispam_norole_minutes` bigint(20) NOT NULL DEFAULT 7,
  `antispam_norole_recent` tinyint(1) NOT NULL DEFAULT 0,
  `stats` tinyint(1) NOT NULL DEFAULT 0,
  `captcha` tinyint(1) NOT NULL DEFAULT 0,
  `verify_accountage` tinyint(1) NOT NULL DEFAULT 0,
  `verify_accountage_days` bigint(20) NOT NULL DEFAULT 0,
  `notification_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `last_touched` datetime DEFAULT NULL,
  `slowmode_default` int(10) NOT NULL DEFAULT 60,
  `antispam_links_chan` tinyint(1) NOT NULL DEFAULT 0,
  `antispam_links_chan_ban` tinyint(1) NOT NULL DEFAULT 0,
  `verify_channelid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `ban_duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mute_message` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operator_enforce` tinyint(1) NOT NULL DEFAULT 1,
  `delete_alert_regex` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`serverid`),
  UNIQUE KEY `serverid` (`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `server_stats`
--

DROP TABLE IF EXISTS `server_stats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `server_stats` (
  `shardid` bigint(20) NOT NULL,
  `serverid` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ownerid` bigint(20) unsigned NOT NULL,
  `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `joined_first` datetime NOT NULL,
  `joined_last` datetime NOT NULL,
  `joined_count` bigint(20) NOT NULL DEFAULT 0,
  `user_count` bigint(20) NOT NULL DEFAULT 0,
  `vip` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `shards`
--

DROP TABLE IF EXISTS `shards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shards` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `taken` tinyint(1) NOT NULL DEFAULT 0,
  `connecting` tinyint(1) NOT NULL DEFAULT 0,
  `time_started` datetime NOT NULL,
  `memory_used` bigint(20) NOT NULL DEFAULT 0,
  `threads_active` bigint(20) NOT NULL DEFAULT 0,
  `server_count` bigint(20) NOT NULL DEFAULT 0,
  `user_count` bigint(20) NOT NULL DEFAULT 0,
  `messages_total` bigint(20) NOT NULL DEFAULT 0,
  `messages_per_minute` bigint(20) NOT NULL DEFAULT 0,
  `operations_ran` bigint(20) NOT NULL DEFAULT 0,
  `operations_active` bigint(20) NOT NULL DEFAULT 0,
  `disconnects` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stats_daily`
--

DROP TABLE IF EXISTS `stats_daily`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_daily` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_joined` bigint(20) NOT NULL DEFAULT 0,
  `user_left` bigint(20) NOT NULL DEFAULT 0,
  `user_verified` bigint(20) NOT NULL DEFAULT 0,
  `user_banned_valk` bigint(20) NOT NULL DEFAULT 0,
  `user_kicked_valk` bigint(20) NOT NULL DEFAULT 0,
  `user_kicked_discord` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`,`datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stats_total`
--

DROP TABLE IF EXISTS `stats_total`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_total` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_joined` bigint(20) NOT NULL DEFAULT 0,
  `user_left` bigint(20) NOT NULL DEFAULT 0,
  `user_verified` bigint(20) NOT NULL DEFAULT 0,
  `user_banned_valk` bigint(20) NOT NULL DEFAULT 0,
  `user_kicked_valk` bigint(20) NOT NULL DEFAULT 0,
  `user_kicked_discord` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`serverid`,`datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `subscribers`
--

DROP TABLE IF EXISTS `subscribers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribers` (
  `userid` bigint(20) unsigned NOT NULL,
  `has_bonus` tinyint(1) NOT NULL,
  `premium` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`userid`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `support_team`
--

DROP TABLE IF EXISTS `support_team`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `support_team` (
  `userid` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`userid`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_profile_options`
--

DROP TABLE IF EXISTS `user_profile_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_profile_options` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `userid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `option` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `usernames`
--

DROP TABLE IF EXISTS `usernames`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usernames` (
  `serverid` bigint(20) unsigned NOT NULL,
  `userid` bigint(20) unsigned NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`serverid`,`userid`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `userid` bigint(20) unsigned NOT NULL,
  `serverid` bigint(20) unsigned NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `karma_count` bigint(20) NOT NULL DEFAULT 1,
  `warning_count` bigint(20) NOT NULL DEFAULT 0,
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_thanks_time` datetime NOT NULL,
  `banned_until` datetime NOT NULL,
  `muted_until` datetime NOT NULL,
  `ignored` tinyint(1) NOT NULL,
  `count_message` bigint(20) NOT NULL DEFAULT 0,
  `count_attachments` bigint(20) NOT NULL DEFAULT 0,
  `level_relative` bigint(20) NOT NULL DEFAULT 0,
  `exp_relative` bigint(20) NOT NULL,
  `memo` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `muted` tinyint(1) NOT NULL DEFAULT 0,
  `banned` tinyint(1) NOT NULL DEFAULT 0,
  `exp_locked` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`userid`,`serverid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `verification_data`
--

DROP TABLE IF EXISTS `verification_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `verification_data` (
  `serverid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `userid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `value` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`serverid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `votes`
--

DROP TABLE IF EXISTS `votes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `votes` (
  `serverid` bigint(20) unsigned NOT NULL,
  `userid` bigint(20) unsigned NOT NULL,
  `voted` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`serverid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-09-18 20:49:15