-- MariaDB dump 10.19-11.2.2-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: mastostart -- ------------------------------------------------------ -- Server version 11.2.2-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 `Admins` -- DROP TABLE IF EXISTS `Admins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Admins` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL, `Email` varchar(64) NOT NULL, `Password` varchar(256) NOT NULL, `Level` varchar(16) NOT NULL, `Page` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxLocalities` tinyint(3) unsigned DEFAULT NULL, `MaxLanguages` tinyint(3) unsigned DEFAULT NULL, `MaxFinancing` tinyint(3) unsigned DEFAULT NULL, `MaxPolicies` tinyint(3) unsigned DEFAULT NULL, `MaxTags` tinyint(3) unsigned DEFAULT NULL, `Enabled` tinyint(1) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Financing` -- DROP TABLE IF EXISTS `Financing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Financing` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Type` varchar(256) NOT NULL, `AddedBy` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY `AddedBy` (`AddedBy`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstActivity` -- DROP TABLE IF EXISTS `InstActivity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstActivity` ( `InstID` bigint(20) unsigned NOT NULL, `Week` int(10) unsigned NOT NULL, `Statuses` int(10) unsigned NOT NULL, `Logins` int(10) unsigned NOT NULL, `Registrations` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstBlocks` -- DROP TABLE IF EXISTS `InstBlocks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstBlocks` ( `InstID` bigint(20) unsigned NOT NULL, `Domain` varchar(256) NOT NULL, `Severity` varchar(32) NOT NULL, `Comment` varchar(8192) DEFAULT NULL, KEY `InstID` (`InstID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstChecks` -- DROP TABLE IF EXISTS `InstChecks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstChecks` ( `InstID` bigint(20) unsigned NOT NULL, `Time` int(10) unsigned NOT NULL, `Status` tinyint(1) unsigned NOT NULL, KEY `InstID` (`InstID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstFinancing` -- DROP TABLE IF EXISTS `InstFinancing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstFinancing` ( `InstID` bigint(20) unsigned NOT NULL, `FinID` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) USING BTREE, KEY `FinID` (`FinID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstLangs` -- DROP TABLE IF EXISTS `InstLangs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstLangs` ( `InstID` bigint(20) unsigned NOT NULL, `LangID` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) USING BTREE, KEY `LangID` (`LangID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstOurLangs` -- DROP TABLE IF EXISTS `InstOurLangs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstOurLangs` ( `InstID` bigint(20) unsigned NOT NULL, `OurLangID` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) USING BTREE, KEY `OurLangID` (`OurLangID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstPolicies` -- DROP TABLE IF EXISTS `InstPolicies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstPolicies` ( `InstID` bigint(20) unsigned NOT NULL, `PolID` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) USING BTREE, KEY `PolID` (`PolID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstRules` -- DROP TABLE IF EXISTS `InstRules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstRules` ( `InstID` bigint(20) unsigned NOT NULL, `Text` varchar(8192) NOT NULL, KEY `InstID` (`InstID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstTags` -- DROP TABLE IF EXISTS `InstTags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstTags` ( `InstID` bigint(20) unsigned NOT NULL, `TagID` int(10) unsigned NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `InstID` (`InstID`) USING BTREE, KEY `TagID` (`TagID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `InstTrends` -- DROP TABLE IF EXISTS `InstTrends`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `InstTrends` ( `InstID` bigint(20) unsigned NOT NULL, `LastDay` int(10) unsigned NOT NULL, `Name` varchar(512) NOT NULL, `URL` varchar(512) NOT NULL, `Pos` smallint(5) unsigned NOT NULL, KEY `InstID` (`InstID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Instances` -- DROP TABLE IF EXISTS `Instances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Instances` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `FirstSeen` int(10) unsigned DEFAULT NULL, `IsMastodon` tinyint(1) unsigned DEFAULT NULL, `Priority` tinyint(3) unsigned DEFAULT NULL, `Visible` tinyint(1) unsigned NOT NULL DEFAULT 1, `Noxious` tinyint(1) unsigned NOT NULL DEFAULT 0, `NoxReason` varchar(2048) DEFAULT NULL, `NoxLastModTS` int(10) unsigned DEFAULT NULL, `URI` varchar(256) NOT NULL, `Title` varchar(256) DEFAULT NULL, `ShortDesc` text DEFAULT NULL, `LongDesc` text DEFAULT NULL, `OurDesc` text DEFAULT NULL, `OurDescEN` text DEFAULT NULL, `LocalityID` int(10) unsigned DEFAULT NULL, `OurLangsLock` tinyint(1) unsigned NOT NULL DEFAULT 0, `Email` varchar(64) DEFAULT NULL, `Software` varchar(64) DEFAULT NULL, `Version` varchar(128) DEFAULT NULL, `UserCount` int(10) unsigned DEFAULT NULL, `StatusCount` bigint(20) unsigned DEFAULT NULL, `DomainCount` int(10) unsigned DEFAULT NULL, `ActiveUsersMonth` int(10) unsigned DEFAULT NULL, `ActiveUsersHalfYear` int(10) unsigned DEFAULT NULL, `Thumb` varchar(512) DEFAULT NULL, `RegOpen` tinyint(1) unsigned DEFAULT NULL, `RegReqApproval` tinyint(1) unsigned DEFAULT NULL, `MaxTootChars` mediumint(8) unsigned DEFAULT NULL, `AdmAccount` varchar(128) DEFAULT NULL, `AdmDisplayName` varchar(64) DEFAULT NULL, `AdmCreatedAt` int(10) DEFAULT NULL, `AdmNote` varchar(4096) DEFAULT NULL, `AdmURL` varchar(128) DEFAULT NULL, `AdmAvatar` varchar(512) DEFAULT NULL, `AdmHeader` varchar(512) DEFAULT NULL, `Threads` varchar(16) DEFAULT NULL, `TotChecks` int(10) unsigned NOT NULL DEFAULT 0, `OkChecks` int(10) unsigned NOT NULL DEFAULT 0, `WasLastCheckOk` tinyint(1) unsigned NOT NULL DEFAULT 0, `LastOkCheckTS` int(10) unsigned DEFAULT NULL, `GuestID` int(10) unsigned DEFAULT NULL, `LastGuestEdit` int(10) unsigned DEFAULT NULL, `InsertTS` int(10) unsigned DEFAULT NULL, `RPos` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`ID`), KEY `LocalityID` (`LocalityID`) USING BTREE, KEY `GuestID` (`GuestID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Languages` -- DROP TABLE IF EXISTS `Languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Languages` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `Code` varchar(16) NOT NULL, `NameOrig` varchar(64) DEFAULT NULL, `NamePT_BR` varchar(64) DEFAULT NULL, `NameDE` varchar(64) DEFAULT NULL, `NameUK` varchar(64) DEFAULT NULL, `NameCA` varchar(64) DEFAULT NULL, `NameEN` varchar(64) DEFAULT NULL, `NameES` varchar(64) DEFAULT NULL, `NameFR` varchar(64) DEFAULT NULL, `NameGL` varchar(64) DEFAULT NULL, `NameIT` varchar(64) DEFAULT NULL, `AddedBy` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY `AddedBy` (`AddedBy`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Localities` -- DROP TABLE IF EXISTS `Localities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Localities` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `OSMID` bigint(20) unsigned NOT NULL, `NameOrig` varchar(128) DEFAULT NULL, `NameCA` varchar(128) DEFAULT NULL, `NameEN` varchar(128) DEFAULT NULL, `NameES` varchar(128) DEFAULT NULL, `NameFR` varchar(128) DEFAULT NULL, `NameGL` varchar(128) DEFAULT NULL, `NameIT` varchar(128) DEFAULT NULL, `AddedBy` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY `AddedBy` (`AddedBy`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Notifications` -- DROP TABLE IF EXISTS `Notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Notifications` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Notification` varchar(15000) NOT NULL, `Severity` tinyint(3) unsigned NOT NULL, `Microtime` decimal(14,4) unsigned NOT NULL, `Seen` tinyint(1) unsigned NOT NULL DEFAULT 0, `Deleted` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Peers` -- DROP TABLE IF EXISTS `Peers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Peers` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Hostname` varchar(256) NOT NULL, `FirstCheckTS` int(11) DEFAULT NULL, `LastOkCheckTS` int(11) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Platforms` -- DROP TABLE IF EXISTS `Platforms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Platforms` ( `ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(128) NOT NULL, `Consider` tinyint(1) DEFAULT NULL, `Comment` varchar(1024) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Policies` -- DROP TABLE IF EXISTS `Policies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Policies` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(64) NOT NULL, `AddedBy` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY `AddedBy` (`AddedBy`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PresFiltConds` -- DROP TABLE IF EXISTS `PresFiltConds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PresFiltConds` ( `PresID` int(10) unsigned NOT NULL, `OpenPar` varchar(3) DEFAULT NULL, `Field` varchar(64) NOT NULL, `Cond` varchar(32) NOT NULL, `ValueSel` varchar(64) DEFAULT NULL, `ValueInp` varchar(256) DEFAULT NULL, `ClosePar` varchar(3) DEFAULT NULL, `AndOr` varchar(3) DEFAULT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `PresID` (`PresID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PresFiltCondsAdm` -- DROP TABLE IF EXISTS `PresFiltCondsAdm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PresFiltCondsAdm` ( `AdmID` int(10) unsigned NOT NULL, `OpenPar` varchar(3) DEFAULT NULL, `Field` varchar(64) NOT NULL, `Cond` varchar(32) NOT NULL, `ValueSel` varchar(64) DEFAULT NULL, `ValueInp` varchar(256) DEFAULT NULL, `ClosePar` varchar(3) DEFAULT NULL, `AndOr` varchar(3) DEFAULT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `AdmID` (`AdmID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PresOrdConds` -- DROP TABLE IF EXISTS `PresOrdConds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PresOrdConds` ( `PresID` int(10) unsigned NOT NULL, `Field` varchar(64) NOT NULL, `Sort` varchar(4) NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `PresID` (`PresID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PresOrdCondsAdm` -- DROP TABLE IF EXISTS `PresOrdCondsAdm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PresOrdCondsAdm` ( `AdmID` int(10) unsigned NOT NULL, `Field` varchar(64) NOT NULL, `Sort` varchar(4) NOT NULL, `Pos` tinyint(3) unsigned NOT NULL, KEY `AdmID` (`AdmID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Presets` -- DROP TABLE IF EXISTS `Presets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Presets` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(256) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Stats` -- DROP TABLE IF EXISTS `Stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Stats` ( `ID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `TotInsts` mediumint(8) unsigned NOT NULL, `GoodInsts` mediumint(8) unsigned NOT NULL, `FeatInsts` mediumint(8) unsigned NOT NULL, `TotUsers` bigint(20) unsigned NOT NULL, `Time` int(10) unsigned NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Tags` -- DROP TABLE IF EXISTS `Tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Tags` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(64) NOT NULL, `AddedBy` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY `AddedBy` (`AddedBy`) USING BTREE ) 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` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `InstID` bigint(20) unsigned DEFAULT NULL, `host` varchar(256) DEFAULT NULL, `locid` bigint(20) unsigned DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `display_name` varchar(64) DEFAULT NULL, `locked` tinyint(1) unsigned DEFAULT NULL, `bot` tinyint(1) unsigned DEFAULT NULL, `created_at` int(10) unsigned DEFAULT NULL, `note` varchar(4096) DEFAULT NULL, `url` varchar(256) DEFAULT NULL, `avatar` varchar(256) DEFAULT NULL, `header` varchar(256) DEFAULT NULL, `statuses_count` int(10) unsigned DEFAULT NULL, `last_status_at` int(10) unsigned DEFAULT NULL, `tags` varchar(4096) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `InstID` (`InstID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `UsersFields` -- DROP TABLE IF EXISTS `UsersFields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `UsersFields` ( `UserID` bigint(20) unsigned NOT NULL, `name` varchar(4096) DEFAULT NULL, `value` varchar(4096) DEFAULT NULL, `verified` tinyint(1) unsigned DEFAULT NULL, KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ZHits` -- DROP TABLE IF EXISTS `ZHits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ZHits` ( `UID` char(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `URL` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `Lang` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `TS` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ZStats` -- DROP TABLE IF EXISTS `ZStats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ZStats` ( `TS` int(10) unsigned NOT NULL, `Hits` int(10) unsigned NOT NULL, `HitsLang` varchar(5000) NOT NULL, `HitsPage` varchar(5000) NOT NULL, `Visits` int(10) unsigned NOT NULL ) 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 2023-12-31 20:33:04