-- MariaDB dump 10.19 Distrib 10.5.15-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: juick
-- ------------------------------------------------------
-- Server version 10.5.15-MariaDB-0+deb11u1
/*!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 `android`
--
DROP TABLE IF EXISTS `android`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `android` (
`user_id` int(10) unsigned NOT NULL,
`regid` char(255) NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
UNIQUE KEY `regid` (`regid`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth`
--
DROP TABLE IF EXISTS `auth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth` (
`user_id` int(10) unsigned DEFAULT NULL,
`protocol` enum('xmpp','email','sms') NOT NULL,
`account` char(64) NOT NULL,
`authcode` char(8) NOT NULL,
`ts` timestamp(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `bl_tags`
--
DROP TABLE IF EXISTS `bl_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bl_tags` (
`user_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
KEY `tag_id` (`tag_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `bl_users`
--
DROP TABLE IF EXISTS `bl_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bl_users` (
`user_id` int(10) unsigned NOT NULL,
`bl_user_id` int(10) unsigned NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`user_id`,`bl_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `emails`
--
DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emails` (
`user_id` int(10) unsigned NOT NULL,
`email` char(64) NOT NULL,
`subscr_hour` tinyint(4) DEFAULT NULL,
KEY `email` (`email`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `facebook`
--
DROP TABLE IF EXISTS `facebook`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facebook` (
`user_id` int(10) unsigned DEFAULT NULL,
`fb_id` bigint(20) unsigned DEFAULT NULL,
`loginhash` char(36) DEFAULT NULL,
`access_token` char(255) DEFAULT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`fb_name` char(64) DEFAULT NULL,
`fb_link` char(255) DEFAULT NULL,
`crosspost` tinyint(1) unsigned NOT NULL DEFAULT 1,
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `favorites`
--
DROP TABLE IF EXISTS `favorites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `favorites` (
`user_id` int(10) unsigned NOT NULL,
`message_id` int(10) unsigned NOT NULL,
`ts` datetime NOT NULL,
`like_id` int(10) unsigned NOT NULL DEFAULT 1,
`user_uri` char(255) NOT NULL DEFAULT '',
KEY `user_id` (`user_id`),
KEY `message_id` (`message_id`),
KEY `like_id` (`like_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `followers`
--
DROP TABLE IF EXISTS `followers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `followers` (
`user_id` int(10) unsigned DEFAULT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`acct` char(64) NOT NULL,
KEY `user_id` (`user_id`),
CONSTRAINT `followers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `images`
--
DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
`mid` int(10) unsigned NOT NULL,
`rid` int(10) unsigned NOT NULL,
`thumb` int(10) unsigned NOT NULL,
`small` int(10) unsigned NOT NULL,
`medium` int(10) unsigned NOT NULL,
`height` int(10) unsigned NOT NULL,
`width` int(10) unsigned NOT NULL,
PRIMARY KEY (`mid`,`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ios`
--
DROP TABLE IF EXISTS `ios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ios` (
`user_id` int(10) unsigned NOT NULL,
`token` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
UNIQUE KEY `token` (`token`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `jids`
--
DROP TABLE IF EXISTS `jids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jids` (
`user_id` int(10) unsigned DEFAULT NULL,
`jid` char(64) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT 1,
`loginhash` char(36) DEFAULT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
UNIQUE KEY `jid` (`jid`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `logins`
--
DROP TABLE IF EXISTS `logins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logins` (
`user_id` int(10) unsigned NOT NULL,
`hash` char(16) NOT NULL,
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mail`
--
DROP TABLE IF EXISTS `mail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mail` (
`user_id` int(10) unsigned NOT NULL,
`hash` char(16) NOT NULL,
`ts` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `meon`
--
DROP TABLE IF EXISTS `meon`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meon` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`link` char(255) NOT NULL,
`name` char(32) NOT NULL,
`ico` smallint(5) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`lang` enum('en','ru','fr','fa','__') NOT NULL DEFAULT '__',
`ts` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
`replies` smallint(5) unsigned NOT NULL DEFAULT 0,
`maxreplyid` smallint(5) unsigned NOT NULL DEFAULT 0,
`privacy` tinyint(4) NOT NULL DEFAULT 1,
`readonly` tinyint(1) NOT NULL DEFAULT 0,
`attach` enum('jpg','mp4','png') DEFAULT NULL,
`place_id` int(10) unsigned DEFAULT NULL,
`lat` decimal(10,7) DEFAULT NULL,
`lon` decimal(10,7) DEFAULT NULL,
`popular` tinyint(4) NOT NULL DEFAULT 0,
`hidden` tinyint(3) unsigned NOT NULL DEFAULT 0,
`likes` smallint(6) NOT NULL DEFAULT 0,
`updated` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
PRIMARY KEY (`message_id`),
KEY `user_id` (`user_id`),
KEY `ts` (`ts`),
KEY `attach` (`attach`),
KEY `place_id` (`place_id`),
KEY `popular` (`popular`),
KEY `hidden` (`hidden`),
KEY `updated_indx` (`updated`,`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages_access`
--
DROP TABLE IF EXISTS `messages_access`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_access` (
`message_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
KEY `message_id` (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages_properties`
--
DROP TABLE IF EXISTS `messages_properties`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_properties` (
`message_id` int(10) unsigned NOT NULL,
`reply_id` smallint(5) unsigned NOT NULL,
`property_key` varchar(255) NOT NULL,
`property_value` mediumtext NOT NULL,
UNIQUE KEY `message_key` (`message_id`,`reply_id`,`property_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages_tags`
--
DROP TABLE IF EXISTS `messages_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_tags` (
`message_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
UNIQUE KEY `message_id_2` (`message_id`,`tag_id`),
KEY `message_id` (`message_id`),
KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages_txt`
--
DROP TABLE IF EXISTS `messages_txt`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_txt` (
`message_id` int(10) unsigned NOT NULL,
`repliesby` varchar(96) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`txt` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`updated_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messenger`
--
DROP TABLE IF EXISTS `messenger`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messenger` (
`user_id` int(10) unsigned DEFAULT NULL,
`sender_id` bigint(20) NOT NULL,
`display_name` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`loginhash` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `places`
--
DROP TABLE IF EXISTS `places`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `places` (
`place_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lat` decimal(10,7) NOT NULL,
`lon` decimal(10,7) NOT NULL,
`name` char(64) NOT NULL,
`descr` char(255) DEFAULT NULL,
`url` char(128) DEFAULT NULL,
`user_id` int(10) unsigned NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `places_tags`
--
DROP TABLE IF EXISTS `places_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `places_tags` (
`place_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `pm`
--
DROP TABLE IF EXISTS `pm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm` (
`user_id` int(10) unsigned NOT NULL,
`user_id_to` int(10) unsigned NOT NULL,
`ts` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
`txt` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `pm_inroster`
--
DROP TABLE IF EXISTS `pm_inroster`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pm_inroster` (
`user_id` int(10) unsigned NOT NULL,
`jid` char(64) NOT NULL,
UNIQUE KEY `user_id_2` (`user_id`,`jid`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reactions`
--
DROP TABLE IF EXISTS `reactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reactions` (
`like_id` int(10) unsigned NOT NULL,
`description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `replies`
--
DROP TABLE IF EXISTS `replies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `replies` (
`message_id` int(10) unsigned NOT NULL,
`reply_id` smallint(5) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`replyto` smallint(5) unsigned NOT NULL DEFAULT 0,
`ts` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
`attach` enum('jpg','mp4','png') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`txt` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`updated_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
`user_uri` char(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reply_uri` char(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`html` tinyint(4) NOT NULL DEFAULT 0,
KEY `ts` (`ts`),
KEY `message_id` (`message_id`),
KEY `uid` (`user_id`),
KEY `reply_indx` (`message_id`,`reply_id`),
KEY `reply_uri_index` (`reply_uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `subscr_messages`
--
DROP TABLE IF EXISTS `subscr_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscr_messages` (
`message_id` int(10) unsigned NOT NULL,
`suser_id` int(10) unsigned NOT NULL,
`last_read_rid` smallint(5) NOT NULL DEFAULT 0,
UNIQUE KEY `message_id` (`message_id`,`suser_id`),
KEY `last_read_indx` (`suser_id`,`last_read_rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `subscr_tags`
--
DROP TABLE IF EXISTS `subscr_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscr_tags` (
`tag_id` int(10) unsigned NOT NULL,
`suser_id` int(10) unsigned NOT NULL,
UNIQUE KEY `tag_id` (`tag_id`,`suser_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `subscr_users`
--
DROP TABLE IF EXISTS `subscr_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscr_users` (
`user_id` int(10) unsigned NOT NULL,
`suser_id` int(10) unsigned NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
UNIQUE KEY `user_id` (`user_id`,`suser_id`),
KEY `suser_id` (`suser_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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` (
`tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`synonym_id` int(10) unsigned DEFAULT NULL,
`name` char(70) CHARACTER SET utf8mb4 DEFAULT NULL,
`top` tinyint(1) unsigned NOT NULL DEFAULT 0,
`noindex` tinyint(1) unsigned NOT NULL DEFAULT 0,
`stat_messages` int(10) unsigned NOT NULL DEFAULT 0,
`stat_users` smallint(5) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`tag_id`),
KEY `synonym_id` (`synonym_id`),
KEY `stat_msg_indx` (`name`,`stat_messages`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tags_ignore`
--
DROP TABLE IF EXISTS `tags_ignore`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_ignore` (
`tag_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tags_synonyms`
--
DROP TABLE IF EXISTS `tags_synonyms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags_synonyms` (
`name` char(64) NOT NULL,
`changeto` char(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `telegram`
--
DROP TABLE IF EXISTS `telegram`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `telegram` (
`user_id` int(10) unsigned DEFAULT NULL,
`tg_id` bigint(20) NOT NULL,
`tg_name` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`loginhash` char(36) 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 `top_ignore_messages`
--
DROP TABLE IF EXISTS `top_ignore_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top_ignore_messages` (
`message_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `top_ignore_tags`
--
DROP TABLE IF EXISTS `top_ignore_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top_ignore_tags` (
`tag_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `top_ignore_users`
--
DROP TABLE IF EXISTS `top_ignore_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `top_ignore_users` (
`user_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `twitter`
--
DROP TABLE IF EXISTS `twitter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `twitter` (
`user_id` int(10) unsigned NOT NULL,
`access_token` char(64) NOT NULL,
`access_token_secret` char(64) NOT NULL,
`uname` char(64) NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`crosspost` tinyint(1) unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `useroptions`
--
DROP TABLE IF EXISTS `useroptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `useroptions` (
`user_id` int(10) unsigned NOT NULL,
`jnotify` tinyint(1) NOT NULL DEFAULT 1,
`subscr_active` tinyint(1) NOT NULL DEFAULT 1,
`off_ts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`xmppxhtml` tinyint(1) NOT NULL DEFAULT 0,
`subscr_notify` tinyint(1) NOT NULL DEFAULT 1,
`recommendations` tinyint(1) NOT NULL DEFAULT 1,
`privacy_view` tinyint(1) NOT NULL DEFAULT 1,
`privacy_reply` tinyint(1) NOT NULL DEFAULT 1,
`privacy_pm` tinyint(1) NOT NULL DEFAULT 1,
`repliesview` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`user_id`),
KEY `recommendations` (`recommendations`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nick` char(64) NOT NULL,
`passw` char(32) NOT NULL,
`lang` enum('en','ru','fr','fa','__') NOT NULL DEFAULT '__',
`banned` tinyint(3) unsigned NOT NULL DEFAULT 0,
`lastmessage` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
`lastpm` int(11) NOT NULL DEFAULT 0,
`lastphoto` int(11) NOT NULL DEFAULT 0,
`karma` smallint(6) NOT NULL DEFAULT 0,
`last_seen` timestamp(6) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users_subscr`
--
DROP TABLE IF EXISTS `users_subscr`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_subscr` (
`user_id` int(10) unsigned NOT NULL,
`cnt` smallint(5) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `usersinfo`
--
DROP TABLE IF EXISTS `usersinfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usersinfo` (
`user_id` int(10) unsigned NOT NULL,
`jid` char(32) DEFAULT NULL,
`fullname` char(32) DEFAULT NULL,
`country` char(32) DEFAULT NULL,
`url` char(64) DEFAULT NULL,
`gender` char(32) DEFAULT NULL,
`bday` char(10) DEFAULT NULL,
`descr` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `version`
--
DROP TABLE IF EXISTS `version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `version` (
`version` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `vk`
--
DROP TABLE IF EXISTS `vk`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vk` (
`user_id` int(10) unsigned DEFAULT NULL,
`vk_id` bigint(20) unsigned DEFAULT NULL,
`loginhash` char(36) DEFAULT NULL,
`access_token` char(128) DEFAULT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`vk_name` char(64) DEFAULT NULL,
`vk_link` char(64) NOT NULL,
`crosspost` tinyint(3) unsigned NOT NULL DEFAULT 1,
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `winphone`
--
DROP TABLE IF EXISTS `winphone`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `winphone` (
`user_id` int(10) unsigned NOT NULL,
`url` char(255) NOT NULL,
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
UNIQUE KEY `url` (`url`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wl_users`
--
DROP TABLE IF EXISTS `wl_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wl_users` (
`user_id` int(10) unsigned NOT NULL,
`wl_user_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`,`wl_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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 2022-12-16 16:03:20