Install ejabberd 20 into debian buster25.02.21

1.
the the line below to the /etc/apt/sources.list

deb http://deb.debian.org/debian buster-backports main

2.
apt-get update

3.
apt install -t buster-backports ejabberd

4.
Create a ssl certificate from letsencrypt:

mv /etc/ejabberd/ejabberd.pem "/etc/ejabberd/backup.pem.$(date +%Y%m%d-%H%M%S)"; cat /root/.acme.sh/calantas.com/calantas.com.key /root/.acme.sh/calantas.com/fullchain.cer >> /etc/ejabberd/ejabberd.pem; chown ejabberd  /etc/ejabberd/ejabberd.pem;

5.
use a ejabberd.yml settings like the below(beware of correct syntax in yml)

###
###              ejabberd configuration file
###
### The parameters used in this configuration file are explained at
###
###       https://docs.ejabberd.im/admin/configuration
###
### The configuration file is written in YAML.
### *******************************************************
### *******           !!! WARNING !!!               *******
### *******     YAML IS INDENTATION SENSITIVE       *******
### ******* MAKE SURE YOU INDENT SECTIONS CORRECTLY *******
### *******************************************************
### Refer to http://en.wikipedia.org/wiki/YAML for the brief description.
### However, ejabberd treats different literals as different types:
###
### - unquoted or single-quoted strings. They are called "atoms".
###   Example: dog, 'Jupiter', '3.14159', YELLOW
###
### - numeric literals. Example: 3, -45.0, .0
###
### - quoted or folded strings.
###   Examples of quoted string: "Lizzard", "orange".
###   Example of folded string:
###   > Art thou not Romeo,
###     and a Montague?
###
#
---
## loglevel: Verbosity of log files generated by ejabberd
## 0: No ejabberd log at all (not recommended)
## 1: Critical
## 2: Error
## 3: Warning
## 4: Info
## 5: Debug
loglevel: 4

## rotation: Disable ejabberd's internal log rotation, as the Debian package
## uses logrotate(8).
log_rotate_count: 0
log_rotate_date: ""

## hosts: Domains served by ejabberd.
## You can define one or several, for example:
## hosts:
##   - "example.net"
##   - "example.com"
##   - "example.org"
hosts:
  # - "localhost"
  # - "jabber.calantas.com"
  - "calantas.com"

certfiles:
  - "/etc/ejabberd/ejabberd.pem"
  ## - "/etc/letsencrypt/live/*/*.pem"

## TLS configuration
define_macro:
  'TLS_CIPHERS': "HIGH:!aNULL:!eNULL:!3DES:@STRENGTH"
  'TLS_OPTIONS':
    - "no_sslv3"
    - "no_tlsv1"
    - "no_tlsv1_1"
    - "cipher_server_preference"
    - "no_compression"
    ## 'DH_FILE': "/path/to/dhparams.pem"
    ## generated with: openssl dhparam -out dhparams.pem 2048

c2s_ciphers: 'TLS_CIPHERS'
s2s_ciphers: 'TLS_CIPHERS'
c2s_protocol_options: 'TLS_OPTIONS'
s2s_protocol_options: 'TLS_OPTIONS'
## c2s_dhfile: 'DH_FILE'
## s2s_dhfile: 'DH_FILE'

auth_method: sql
# sql_type: pgsql
sql_type: mysql
sql_server: "127.0.0.1"
sql_database: "calantassql1"
sql_username: "calantassql1"
sql_password: "igtnehouyl"

sql_pool_size: 10
new_sql_schema: true
default_db: sql

captcha_cmd: "/usr/share/ejabberd/captcha.sh"
captcha_host: "xmpp.@HOST@:5280"
captcha_limit: 5

listen:
  -
    port: 5222
    ip: "::"
    module: ejabberd_c2s
    max_stanza_size: 262144
    shaper: c2s_shaper
    access: c2s
    starttls_required: true
    protocol_options: 'TLS_OPTIONS'
  -
    port: 5223
    ip: "::"
    module: ejabberd_c2s
    max_stanza_size: 262144
    shaper: c2s_shaper
    access: c2s
    tls: true
    protocol_options: 'TLS_OPTIONS'
  -
    port: 5269
    ip: "::"
    module: ejabberd_s2s_in
    max_stanza_size: 524288

-
    port: 5280
    ip: "::"
    module: ejabberd_http
    request_handlers:
      "/api": mod_http_api
      "/bosh": mod_bosh
      "/upload": mod_http_upload
      "/usershare": mod_http_upload
      "/ws": ejabberd_http_ws
    captcha: true
    register: true
    tls: true
    protocol_options: 'TLS_OPTIONS'
    web_admin: true

## Disabling digest-md5 SASL authentication. digest-md5 requires plain-text
## password storage (see auth_password_format option).
disable_sasl_mechanisms:
  - "digest-md5"
  - "X-OAUTH2"

s2s_use_starttls: required

## Store the plain passwords or hashed for SCRAM:
auth_password_format: scram

## Full path to a script that generates the image.
## captcha_cmd: "/usr/share/ejabberd/captcha.sh"

acl:
  admin:
    user:
      - "admin": "calantas.com"

local:
    user_regexp: ""
  loopback:
    ip:
      - "127.0.0.0/8"
      - "::1/128"
      - "::FFFF:127.0.0.1/128"

access_rules:
  local:
    - allow: local
  c2s:
    - deny: blocked
    - allow
  announce:
    - allow: admin
  configure:
    - allow: admin
  muc_create:
    - allow: local
  pubsub_createnode:
    - allow: local
  register:
    - allow
  trusted_network:
    - allow: loopback

api_permissions:
  "console commands":
    from:
      - ejabberd_ctl
    who: all
    what: "*"
  "admin access":
    who:
      - access:
          - allow:
            - acl: loopback
            - acl: admin
      - oauth:
        - scope: "ejabberd:admin"
        - access:
          - allow:
            - acl: loopback
            - acl: admin
    what:
      - "*"
      - "!stop"
      - "!start"
  "public commands":
    who:
      - ip: "127.0.0.1/8"
    what:
      - "status"
      - "connected_users_number"

shaper:
  normal: 1000
  fast: 50000

shaper_rules:
  max_user_sessions: 10
  max_user_offline_messages:
    - 5000: admin
    - 100
  c2s_shaper:
    - none: admin
    - normal
  s2s_shaper: fast

modules:
  mod_adhoc: {}
  mod_admin_extra: {}
  mod_announce:
    access: announce
  mod_avatar: {}
  mod_blocking: {}
  mod_bosh: {}
  mod_caps: {}
  mod_carboncopy: {}
  mod_client_state: {}
  mod_configure: {}
  ## mod_delegation: {}   # for xep0356
  mod_disco: {}
  mod_echo: {}
  mod_fail2ban: {}
  mod_http_api: {}
  ## mod_http_upload:
  ##   put_url: "https://@HOST@:5443/upload"
  mod_last: {}
  ## mod_mam:
  ##   ## Mnesia is limited to 2GB, better to use an SQL backend
  ##   ## For small servers SQLite is a good fit and is very easy
  ##   ## to configure. Uncomment this when you have SQL configured:
  ##   ## db_type: sql
  ##   assume_mam_usage: true
  ##   default: always
  mod_muc:
    access:
      - allow
    access_admin:
      - allow: admin
    access_create: muc_create
    access_persistent: muc_create
    default_room_options:
      mam: true
  mod_muc_admin: {}
  mod_offline:
    access_max_user_messages: max_user_offline_messages
  mod_ping: {}
  mod_pres_counter:
    count: 5
    interval: 60
  mod_privacy: {}
  mod_private: {}
  ## mod_proxy65: {}
  mod_pubsub:
    access_createnode: pubsub_createnode
    plugins:
      - "flat"
      - "pep"
    force_node_config:
      "eu.siacs.conversations.axolotl.*":
        access_model: open
      ## Avoid buggy clients to make their bookmarks public
      "storage:bookmarks":
        access_model: whitelist
  mod_push: {}
  mod_push_keepalive: {}
  mod_register:
    captcha_protected: true
    ip_access: all
    # ip_access: trusted_network
  mod_roster:
    versioning: true
  # mod_s2s_dialback: {}
  mod_shared_roster: {}
  mod_sic: {}
  mod_stream_mgmt:
    resend_on_timeout: if_offline
  mod_vcard:
    search: false
  mod_vcard_xupdate: {}
  mod_version: {}

mod_block_strangers:
    allow_local_users: true
    drop: true

mod_http_upload:
    put_url: "https://xmpp.@HOST@:5280/upload"

https://wiki.404.city/en/Installing_Ejabberd_on_Debian

Anonymous

25.02.21

Anonymous

and you need to create the mysql data schema or structure for it,
beware about the ejabbered version used.
below is for version 20
use :

-- phpMyAdmin SQL Dump
-- version 5.1.0-rc1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 25, 2021 at 10:37 AM
-- Server version: 10.3.27-MariaDB-0+deb10u1
-- PHP Version: 8.0.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!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 */;

--
-- Database: `calantassql1`
--

-- --------------------------------------------------------

--
-- Table structure for table `archive`
--

CREATE TABLE `archive` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` bigint(20) UNSIGNED NOT NULL,
  `peer` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bare_peer` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xml` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `txt` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL,
  `kind` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nick` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `archive_prefs`
--

CREATE TABLE `archive_prefs` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `def` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `always` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `never` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bosh`
--

CREATE TABLE `bosh` (
  `sid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `caps_features`
--

CREATE TABLE `caps_features` (
  `node` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subnode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `last`
--

CREATE TABLE `last` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seconds` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mix_channel`
--

CREATE TABLE `mix_channel` (
  `channel` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `service` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `hidden` tinyint(1) NOT NULL,
  `hmac_key` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mix_pam`
--

CREATE TABLE `mix_pam` (
  `username` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `service` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mix_participant`
--

CREATE TABLE `mix_participant` (
  `channel` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `service` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nick` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mix_subscription`
--

CREATE TABLE `mix_subscription` (
  `channel` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `service` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `motd`
--

CREATE TABLE `motd` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xml` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mqtt_pub`
--

CREATE TABLE `mqtt_pub` (
  `username` varchar(191) NOT NULL,
  `server_host` varchar(191) NOT NULL,
  `resource` varchar(191) NOT NULL,
  `topic` text NOT NULL,
  `qos` tinyint(4) NOT NULL,
  `payload` blob NOT NULL,
  `payload_format` tinyint(4) NOT NULL,
  `content_type` text NOT NULL,
  `response_topic` text NOT NULL,
  `correlation_data` blob NOT NULL,
  `user_properties` blob NOT NULL,
  `expiry` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `muc_online_room`
--

CREATE TABLE `muc_online_room` (
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `muc_online_users`
--

CREATE TABLE `muc_online_users` (
  `username` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `muc_registered`
--

CREATE TABLE `muc_registered` (
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nick` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `muc_room`
--

CREATE TABLE `muc_room` (
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `opts` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `muc_room_subscribers`
--

CREATE TABLE `muc_room_subscribers` (
  `room` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nick` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nodes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_client`
--

CREATE TABLE `oauth_client` (
  `client_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `grant_type` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oauth_token`
--

CREATE TABLE `oauth_token` (
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `scope` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `expire` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `privacy_default_list`
--

CREATE TABLE `privacy_default_list` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `privacy_list`
--

CREATE TABLE `privacy_list` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `privacy_list_data`
--

CREATE TABLE `privacy_list_data` (
  `id` bigint(20) DEFAULT NULL,
  `t` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ord` decimal(10,0) NOT NULL,
  `match_all` tinyint(1) NOT NULL,
  `match_iq` tinyint(1) NOT NULL,
  `match_message` tinyint(1) NOT NULL,
  `match_presence_in` tinyint(1) NOT NULL,
  `match_presence_out` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `private_storage`
--

CREATE TABLE `private_storage` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `namespace` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `proxy65`
--

CREATE TABLE `proxy65` (
  `sid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid_t` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid_i` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node_t` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node_i` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid_i` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_item`
--

CREATE TABLE `pubsub_item` (
  `nodeid` bigint(20) DEFAULT NULL,
  `itemid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `publisher` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `creation` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modification` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_node`
--

CREATE TABLE `pubsub_node` (
  `host` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `plugin` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nodeid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_node_option`
--

CREATE TABLE `pubsub_node_option` (
  `nodeid` bigint(20) DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `val` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_node_owner`
--

CREATE TABLE `pubsub_node_owner` (
  `nodeid` bigint(20) DEFAULT NULL,
  `owner` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_state`
--

CREATE TABLE `pubsub_state` (
  `nodeid` bigint(20) DEFAULT NULL,
  `jid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `affiliation` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscriptions` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `stateid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pubsub_subscription_opt`
--

CREATE TABLE `pubsub_subscription_opt` (
  `subid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `opt_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opt_value` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `push_session`
--

CREATE TABLE `push_session` (
  `username` text NOT NULL,
  `server_host` varchar(191) NOT NULL,
  `timestamp` bigint(20) NOT NULL,
  `service` text NOT NULL,
  `node` text NOT NULL,
  `xml` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `rostergroups`
--

CREATE TABLE `rostergroups` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grp` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `rosterusers`
--

CREATE TABLE `rosterusers` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nick` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ask` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `askmessage` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscribe` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roster_version`
--

CREATE TABLE `roster_version` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `route`
--

CREATE TABLE `route` (
  `domain` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `local_hint` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sm`
--

CREATE TABLE `sm` (
  `usec` bigint(20) NOT NULL,
  `pid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `node` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `info` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `spool`
--

CREATE TABLE `spool` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `xml` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `seq` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sr_group`
--

CREATE TABLE `sr_group` (
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `opts` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sr_user`
--

CREATE TABLE `sr_user` (
  `jid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `serverkey` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `salt` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `iterationcount` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vcard`
--

CREATE TABLE `vcard` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vcard` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vcard_search`
--

CREATE TABLE `vcard_search` (
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lusername` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_host` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fn` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lfn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lfamily` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `given` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lgiven` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `middle` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lmiddle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nickname` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lnickname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bday` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lbday` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ctry` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lctry` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locality` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `llocality` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lemail` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `orgname` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lorgname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `orgunit` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lorgunit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `archive`
--
ALTER TABLE `archive`
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `i_archive_sh_username_bare_peer` (`server_host`,`username`,`bare_peer`) USING BTREE,
  ADD KEY `i_archive_sh_timestamp` (`server_host`,`timestamp`) USING BTREE,
  ADD KEY `i_archive_sh_username_timestamp` (`server_host`,`username`,`timestamp`) USING BTREE,
  ADD KEY `i_archive_sh_username_peer` (`server_host`,`username`,`peer`) USING BTREE;
ALTER TABLE `archive` ADD FULLTEXT KEY `i_text` (`txt`);

--
-- Indexes for table `archive_prefs`
--
ALTER TABLE `archive_prefs`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `bosh`
--
ALTER TABLE `bosh`
  ADD UNIQUE KEY `i_bosh_sid` (`sid`(75));

--
-- Indexes for table `caps_features`
--
ALTER TABLE `caps_features`
  ADD KEY `i_caps_features_node_subnode` (`node`(75),`subnode`(75));

--
-- Indexes for table `last`
--
ALTER TABLE `last`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `mix_channel`
--
ALTER TABLE `mix_channel`
  ADD UNIQUE KEY `i_mix_channel` (`channel`(191),`service`(191)),
  ADD KEY `i_mix_channel_serv` (`service`(191));

--
-- Indexes for table `mix_pam`
--
ALTER TABLE `mix_pam`
  ADD UNIQUE KEY `i_mix_pam` (`username`(191),`server_host`,`channel`(191),`service`(191)),
  ADD KEY `i_mix_pam_us` (`username`(191),`server_host`);

--
-- Indexes for table `mix_participant`
--
ALTER TABLE `mix_participant`
  ADD UNIQUE KEY `i_mix_participant` (`channel`(191),`service`(191),`username`(191),`domain`(191)),
  ADD KEY `i_mix_participant_chan_serv` (`channel`(191),`service`(191));

--
-- Indexes for table `mix_subscription`
--
ALTER TABLE `mix_subscription`
  ADD UNIQUE KEY `i_mix_subscription` (`channel`(153),`service`(153),`username`(153),`domain`(153),`node`(153)),
  ADD KEY `i_mix_subscription_chan_serv_ud` (`channel`(191),`service`(191),`username`(191),`domain`(191)),
  ADD KEY `i_mix_subscription_chan_serv_node` (`channel`(191),`service`(191),`node`(191)),
  ADD KEY `i_mix_subscription_chan_serv` (`channel`(191),`service`(191));

--
-- Indexes for table `motd`
--
ALTER TABLE `motd`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `mqtt_pub`
--
ALTER TABLE `mqtt_pub`
  ADD UNIQUE KEY `i_mqtt_topic_server` (`topic`(191),`server_host`);

--
-- Indexes for table `muc_online_room`
--
ALTER TABLE `muc_online_room`
  ADD UNIQUE KEY `i_muc_online_room_name_host` (`name`(75),`host`(75)) USING BTREE;

--
-- Indexes for table `muc_online_users`
--
ALTER TABLE `muc_online_users`
  ADD UNIQUE KEY `i_muc_online_users` (`username`(75),`server`(75),`resource`(75),`name`(75),`host`(75)) USING BTREE,
  ADD KEY `i_muc_online_users_us` (`username`(75),`server`(75)) USING BTREE;

--
-- Indexes for table `muc_registered`
--
ALTER TABLE `muc_registered`
  ADD UNIQUE KEY `i_muc_registered_jid_host` (`jid`(75),`host`(75)) USING BTREE,
  ADD KEY `i_muc_registered_nick` (`nick`(75)) USING BTREE;

--
-- Indexes for table `muc_room`
--
ALTER TABLE `muc_room`
  ADD UNIQUE KEY `i_muc_room_name_host` (`name`(75),`host`(75)) USING BTREE;

--
-- Indexes for table `muc_room_subscribers`
--
ALTER TABLE `muc_room_subscribers`
  ADD UNIQUE KEY `i_muc_room_subscribers_host_room_jid` (`host`,`room`,`jid`),
  ADD KEY `i_muc_room_subscribers_host_jid` (`host`,`jid`) USING BTREE;

--
-- Indexes for table `oauth_client`
--
ALTER TABLE `oauth_client`
  ADD PRIMARY KEY (`client_id`);

--
-- Indexes for table `oauth_token`
--
ALTER TABLE `oauth_token`
  ADD PRIMARY KEY (`token`);

--
-- Indexes for table `privacy_default_list`
--
ALTER TABLE `privacy_default_list`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `privacy_list`
--
ALTER TABLE `privacy_list`
  ADD UNIQUE KEY `id` (`id`),
  ADD UNIQUE KEY `i_privacy_list_sh_username_name` (`server_host`,`username`(75),`name`(75)) USING BTREE,
  ADD KEY `i_privacy_list_sh_username` (`server_host`,`username`) USING BTREE;

--
-- Indexes for table `privacy_list_data`
--
ALTER TABLE `privacy_list_data`
  ADD KEY `i_privacy_list_data_id` (`id`);

--
-- Indexes for table `private_storage`
--
ALTER TABLE `private_storage`
  ADD PRIMARY KEY (`server_host`,`username`,`namespace`),
  ADD KEY `i_private_storage_sh_username` (`server_host`,`username`) USING BTREE;

--
-- Indexes for table `proxy65`
--
ALTER TABLE `proxy65`
  ADD UNIQUE KEY `i_proxy65_sid` (`sid`(191)),
  ADD KEY `i_proxy65_jid` (`jid_i`(191));

--
-- Indexes for table `pubsub_item`
--
ALTER TABLE `pubsub_item`
  ADD UNIQUE KEY `i_pubsub_item_tuple` (`nodeid`,`itemid`(36)),
  ADD KEY `i_pubsub_item_itemid` (`itemid`(36));

--
-- Indexes for table `pubsub_node`
--
ALTER TABLE `pubsub_node`
  ADD PRIMARY KEY (`nodeid`),
  ADD UNIQUE KEY `i_pubsub_node_tuple` (`host`(71),`node`(120)),
  ADD KEY `i_pubsub_node_parent` (`parent`(120));

--
-- Indexes for table `pubsub_node_option`
--
ALTER TABLE `pubsub_node_option`
  ADD KEY `i_pubsub_node_option_nodeid` (`nodeid`);

--
-- Indexes for table `pubsub_node_owner`
--
ALTER TABLE `pubsub_node_owner`
  ADD KEY `i_pubsub_node_owner_nodeid` (`nodeid`);

--
-- Indexes for table `pubsub_state`
--
ALTER TABLE `pubsub_state`
  ADD PRIMARY KEY (`stateid`),
  ADD UNIQUE KEY `i_pubsub_state_tuple` (`nodeid`,`jid`(60)),
  ADD KEY `i_pubsub_state_jid` (`jid`(60));

--
-- Indexes for table `pubsub_subscription_opt`
--
ALTER TABLE `pubsub_subscription_opt`
  ADD UNIQUE KEY `i_pubsub_subscription_opt` (`subid`(32),`opt_name`);

--
-- Indexes for table `push_session`
--
ALTER TABLE `push_session`
  ADD PRIMARY KEY (`server_host`,`username`(191),`timestamp`),
  ADD UNIQUE KEY `i_push_session_susn` (`server_host`,`username`(191),`service`(191),`node`(191));

--
-- Indexes for table `rostergroups`
--
ALTER TABLE `rostergroups`
  ADD KEY `i_rosterg_sh_user_jid` (`server_host`,`username`(75),`jid`(75));

--
-- Indexes for table `rosterusers`
--
ALTER TABLE `rosterusers`
  ADD UNIQUE KEY `i_rosteru_sh_user_jid` (`server_host`,`username`(75),`jid`(75)),
  ADD KEY `i_rosteru_sh_username` (`server_host`,`username`),
  ADD KEY `i_rosteru_sh_jid` (`server_host`,`jid`);

--
-- Indexes for table `roster_version`
--
ALTER TABLE `roster_version`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `route`
--
ALTER TABLE `route`
  ADD UNIQUE KEY `i_route` (`domain`(75),`server_host`(75),`node`(75),`pid`(75)),
  ADD KEY `i_route_domain` (`domain`(75));

--
-- Indexes for table `sm`
--
ALTER TABLE `sm`
  ADD PRIMARY KEY (`usec`,`pid`(75)),
  ADD KEY `i_sm_node` (`node`(75)),
  ADD KEY `i_sm_sh_username` (`server_host`,`username`);

--
-- Indexes for table `spool`
--
ALTER TABLE `spool`
  ADD UNIQUE KEY `seq` (`seq`),
  ADD KEY `i_spool_created_at` (`created_at`) USING BTREE,
  ADD KEY `i_spool_sh_username` (`server_host`,`username`) USING BTREE;

--
-- Indexes for table `sr_group`
--
ALTER TABLE `sr_group`
  ADD PRIMARY KEY (`server_host`,`name`);

--
-- Indexes for table `sr_user`
--
ALTER TABLE `sr_user`
  ADD PRIMARY KEY (`server_host`,`jid`,`grp`),
  ADD KEY `i_sr_user_sh_jid` (`server_host`,`jid`),
  ADD KEY `i_sr_user_sh_grp` (`server_host`,`grp`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `vcard`
--
ALTER TABLE `vcard`
  ADD PRIMARY KEY (`server_host`,`username`);

--
-- Indexes for table `vcard_search`
--
ALTER TABLE `vcard_search`
  ADD PRIMARY KEY (`server_host`,`lusername`),
  ADD KEY `i_vcard_search_sh_lfn` (`server_host`,`lfn`),
  ADD KEY `i_vcard_search_sh_llocality` (`server_host`,`llocality`),
  ADD KEY `i_vcard_search_sh_lnickname` (`server_host`,`lnickname`),
  ADD KEY `i_vcard_search_sh_lctry` (`server_host`,`lctry`),
  ADD KEY `i_vcard_search_sh_lgiven` (`server_host`,`lgiven`),
  ADD KEY `i_vcard_search_sh_lmiddle` (`server_host`,`lmiddle`),
  ADD KEY `i_vcard_search_sh_lorgname` (`server_host`,`lorgname`),
  ADD KEY `i_vcard_search_sh_lfamily` (`server_host`,`lfamily`),
  ADD KEY `i_vcard_search_sh_lbday` (`server_host`,`lbday`),
  ADD KEY `i_vcard_search_sh_lemail` (`server_host`,`lemail`),
  ADD KEY `i_vcard_search_sh_lorgunit` (`server_host`,`lorgunit`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `archive`
--
ALTER TABLE `archive`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `privacy_list`
--
ALTER TABLE `privacy_list`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pubsub_node`
--
ALTER TABLE `pubsub_node`
  MODIFY `nodeid` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pubsub_state`
--
ALTER TABLE `pubsub_state`
  MODIFY `stateid` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `spool`
--
ALTER TABLE `spool`
  MODIFY `seq` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `pubsub_item`
--
ALTER TABLE `pubsub_item`
  ADD CONSTRAINT `pubsub_item_ibfk_1` FOREIGN KEY (`nodeid`) REFERENCES `pubsub_node` (`nodeid`) ON DELETE CASCADE;

--
-- Constraints for table `pubsub_node_option`
--
ALTER TABLE `pubsub_node_option`
  ADD CONSTRAINT `pubsub_node_option_ibfk_1` FOREIGN KEY (`nodeid`) REFERENCES `pubsub_node` (`nodeid`) ON DELETE CASCADE;

--
-- Constraints for table `pubsub_node_owner`
--
ALTER TABLE `pubsub_node_owner`
  ADD CONSTRAINT `pubsub_node_owner_ibfk_1` FOREIGN KEY (`nodeid`) REFERENCES `pubsub_node` (`nodeid`) ON DELETE CASCADE;

--
-- Constraints for table `pubsub_state`
--
ALTER TABLE `pubsub_state`
  ADD CONSTRAINT `pubsub_state_ibfk_1` FOREIGN KEY (`nodeid`) REFERENCES `pubsub_node` (`nodeid`) ON DELETE CASCADE;
COMMIT;

/*!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 */;

25.02.21

https://docs.ejabberd.im/tutorials/mysql/

Anonymous

Install ejabberd 20 into debian buster25.02.21

Information Epoch 1713994557