Hello ahmaddanial,
ah, there is some work to do for me, great 
I will try it soon and get back to you.
Thank you very much.
1 Like
Hello ahmaddanial,
first let me say to the content/settings of mattermost.service:
NO, that was not intended in this manner. I guess I read that somewhere as a workaround to my previous failed update attempts before I wrote in this forum.
Well, I’ve done as written by you above – what I already knew
Below that’s now my new part:
remove mattermost.service -> I’ve found two of them, so I removed both
rm /etc/systemd/system/multi-user.target.wants/mattermost.service
rm /lib/systemd/system/mattermost.service
cd /opt/mattermost
sudo -u mattermost ./bin/mattermost
{“level”:“info”,“ts”:1610571078.3621776,“caller”:“utils/i18n.go:83”,“msg”:“Loaded system translations”,“for locale”:“de”,“from locale”:"/opt/mattermost/i18n/de.json"}
{“level”:“info”,“ts”:1610571078.3624952,“caller”:“app/server_app_adapters.go:58”,“msg”:“Server is initializing…”}
{“level”:“info”,“ts”:1610571078.364868,“caller”:“sqlstore/supplier.go:227”,“msg”:“Pinging SQL”,“database”:“master”}
{“level”:“error”,“ts”:1610571078.418023,“caller”:“sqlstore/supplier.go:915”,“msg”:“Failed to create index”,“error”:“Error 1709: Index column size too large. The maximum column size is 767 bytes.”}
now there are no mattermost.service files available
I created mattermost.service as described in DOCS 10b
vi /lib/systemd/system/mattermost.service
1 [Unit]
2 Description=Mattermost
3 After=network.target
4 After=mysql.service
5 BindsTo=mysql.service
6
7 [Service]
8 Type=notify
9 ExecStart=/opt/mattermost/bin/mattermost
10 TimeoutStartSec=3600
11 Restart=always
12 RestartSec=10
13 WorkingDirectory=/opt/mattermost
14 User=mattermost
15 Group=mattermost
16 LimitNOFILE=49152
17
18 [Install]
19 WantedBy=mysql.service
systemctl start mattermost
Failed to start mattermost.service: Unit mattermost.service not found.
I guess: copy mattermost.service to second location (see above)
cp /lib/systemd/system/mattermost.service /etc/systemd/system/multi-user.target.wants
but the same issue
systemctl start mattermost
Failed to start mattermost.service: Unit mattermost.service not found.
systemctl status mattermost
● mattermost.service
Loaded: not-found (Reason: No such file or directory)
Active: failed (Result: resources) since Mit 2021-01-13 21:57:22 CET; 40min ago
Main PID: 842 (code=exited, status=119)
Jän 13 21:57:15 VIEASS3 systemd[1]: mattermost.service: Unit entered failed state.
Jän 13 21:57:15 VIEASS3 systemd[1]: mattermost.service: Failed with result ‘exit-code’.
Jän 13 21:57:22 VIEASS3 systemd[1]: mattermost.service: Service hold-off time over, scheduling restart.
Jän 13 21:57:22 VIEASS3 systemd[1]: mattermost.service: Failed to schedule restart job: Unit mattermost.service not found.
Jän 13 21:57:22 VIEASS3 systemd[1]: mattermost.service: Unit entered failed state.
Jän 13 21:57:22 VIEASS3 systemd[1]: mattermost.service: Failed with result ‘resources’.
I hope you can see any issue. But it may also be that I have misunderstood something.
Let me know how I can further assist.
Hello, @SuziQ
No worries. Moving back to starting Mattermost manually without using the mattermost.service, can you please remove any existing systemd file(s) tied to Mattermost and start Mattermost manually using the command I asked you earlier within /opt/mattermost/:
sudo -u mattermost ./bin/mattermost
Hello ahmaddanial,
I’m sorry, which are the existing systemd file(s) tied to Mattermost?
You mean
- /lib/systemd/system/mattermost.service and
- /etc/systemd/system/multi-user.target.wants/mattermost.service?
Ok, I’ve tried it and have removed this two files.
But where’s my MM config now?
If there’s no mattermost.service needed what should happen after “sudo -u mattermost ./bin/mattermost”? What should I try? What should I get or see?
sudo -u mattermost ./bin/mattermost
{“level”:“info”,“ts”:1610657383.0816736,“caller”:“utils/i18n.go:83”,“msg”:“Loaded system translations”,“for locale”:“de”,“from locale”:"/opt/mattermost/i18n/de.json"}
{“level”:“info”,“ts”:1610657383.0973482,“caller”:“app/server_app_adapters.go:58”,“msg”:“Server is initializing…”}
{“level”:“info”,“ts”:1610657383.2245412,“caller”:“sqlstore/supplier.go:227”,“msg”:“Pinging SQL”,“database”:“master”}
{“level”:“error”,“ts”:1610657383.6669023,“caller”:“sqlstore/supplier.go:915”,“msg”:“Failed to create index”,“error”:“Error 1709: Index column size too large. The maximum column size is 767 bytes.”}
I’m a little bit confused about what you plan and what should happen or what should I try or get or see!
How big is your Mattermost database, if I can ask? For example, how many users and total messages do you have?
According to phpMyAdmin, the database is 15.6 MiB in size, 7-8 teams, about 4,000 messages. These are clubs that have deposited their protocols and agreements, their strategies for the future here.
Why do you ask?
Is there a way to convert the database from old Mattermost version to the new one?
What says this error message > “Failed to create index”,“error”:“Error 1709: Index column size too large. The maximum column size is 767 bytes.”
Within a major version (v5) I would not have thought there would be such problems updating. But I go along with everything so that I can get the clubs their data. I just need to know WHAT to do …
Hey @SuziQ, don’t worry, we’re going to get this figured out. I think I may have found a solution, but before I tell you to do anything to your database, I just want to make sure I have the right information from you, so that I don’t inadvertently have you do the wrong thing.
So, to be safe, can you confirm the Database and Engine that you are using?
An example would be MySQL running with MariaDB
Also, and more importantly, could you provide the schema of the table OutgoingWebhooks in your Mattermost database?
This is what mine looks like, I’m running Mattermost 5.28.1. I will be able to see based on what you provide, if the issue I suspect, which is incorrect database character type on upgrade, is the actual issue. This is my schema for the OutgoingWebhooks table:
mysql> describe OutgoingWebhooks;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| Id | varchar(26) | NO | PRI | NULL | |
| Token | varchar(26) | YES | | NULL | |
| CreateAt | bigint | YES | MUL | NULL | |
| UpdateAt | bigint | YES | MUL | NULL | |
| DeleteAt | bigint | YES | MUL | NULL | |
| CreatorId | varchar(26) | YES | | NULL | |
| ChannelId | varchar(26) | YES | | NULL | |
| TeamId | varchar(26) | YES | MUL | NULL | |
| TriggerWords | text | YES | | NULL | |
| TriggerWhen | int | YES | | NULL | |
| CallbackURLs | text | YES | | NULL | |
| DisplayName | varchar(64) | YES | | NULL | |
| Description | text | YES | | NULL | |
| ContentType | varchar(128) | YES | | NULL | |
| Username | varchar(64) | YES | | NULL | |
| IconURL | text | YES | | NULL | |
+--------------+--------------+------+-----+---------+-------+
16 rows in set (0.01 sec)
Thank you! If you encounter any troubles getting your schema, it’s quite alright, just let me know and I will be glad to help you out!
Hello @XxLilBoPeepsxX,
thank you for your help and also for your confidence. (y)
current version MySQL running with MariaDB
mysql -V
mysql Ver 15.1 Distrib 10.0.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
my schema for the OutgoingWebhooks table
mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 548
Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]>
MariaDB [(none)]> use mattermost;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mattermost]> describe OutgoingWebhooks;
+--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | Id | varchar(26) | NO | PRI | NULL | | | Token | varchar(26) | YES | | NULL | | | CreateAt | bigint(20) | YES | MUL | NULL | | | UpdateAt | bigint(20) | YES | MUL | NULL | | | DeleteAt | bigint(20) | YES | MUL | NULL | | | CreatorId | varchar(26) | YES | | NULL | | | ChannelId | varchar(26) | YES | | NULL | | | TeamId | varchar(26) | YES | MUL | NULL | | | TriggerWords | text | YES | | NULL | | | TriggerWhen | int(11) | YES | | NULL | | | CallbackURLs | text | YES | | NULL | | | DisplayName | varchar(64) | YES | | NULL | | | Description | text | YES | | NULL | | | ContentType | varchar(128) | YES | | NULL | | | Username | varchar(64) | YES | | NULL | | | IconURL | text | YES | | NULL | | +--------------+--------------+------+-----+---------+-------+ 16 rows in set (0.00 sec)
1 Like
Alright so it looks like your database schema is correct, that eliminates the first of two potential issues. The first one I referenced a Github issue that has already been closed for Mattermost from, the second has to do with the default correlation and reading of the database as a whole, which if not set the correct way, makes it so Mattermost cannot function properly.
By any chance, could you provide the contents of your my.cnf MySQL configuration file?
My first thought was also a faulty database. However, where should this error come from? Mattermost v5.3 is running correctly, as you know.
Here is my /etc/mysql/my.cnf:
cat /etc/mysql/my.cnf
> # This file has been automatically moved from your previous
> # /etc/mysql/my.cnf, with just this comment added at the top, to maintain MySQL
> # operation using your previously customised configuration.
>
> # To switch to the new packaging configuration for automated management of
> # /etc/mysql/my.cnf across multiple variants:
> #
> # 1. Move your customisations from this file to /etc/mysql/conf.d/ and
> # to /etc/mysql/<variant>.conf.d/ as appropriate.
> # 2. Run "update-alternatives --remove my.cnf /etc/mysql/my.cnf.migrated"
> # 3. Remove the file /etc/mysql/my.cnf.migrated
>
> # MariaDB database server configuration file.
> #
> # You can copy this file to one of:
> # - "/etc/mysql/my.cnf" to set global options,
> # - "~/.my.cnf" to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> #
> # For explanations see
> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> # This will be passed to all mysql clients
> # It has been reported that passwords should be enclosed with ticks/quotes
> # escpecially if they contain "#" chars...
> # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
> [client]
> port = 3306
> socket = /var/run/mysqld/mysqld.sock
>
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
>
> # This was formally known as [safe_mysqld]. Both versions are currently parsed.
> [mysqld_safe]
> socket = /var/run/mysqld/mysqld.sock
> nice = 0
>
> [mysqld]
> ### 8.Nov-16: Added by Gruppe-ASS
> ### See also: https://dba.stackexchange.com/questions/8982/what-is-the-best-way-to-reduce-the-size-of-ibdata-in-mysql
> innodb_file_per_table = 1
> ### innodb_flush_method = 0_DIRECT
> ### innodb_log_file_size = 2G
> ### innodb_buffer_pool_size = 8G
>
> # needed by NC 15.0.7+
> innodb_large_prefix = true
> innodb_file_format = Barracuda
>
> #
> # * Basic Settings
> #
> user = mysql
> pid-file = /var/run/mysqld/mysqld.pid
> socket = /var/run/mysqld/mysqld.sock
> port = 3306
> basedir = /usr
> datadir = /var/lib/mysql
> tmpdir = /tmp
> lc_messages_dir = /usr/share/mysql
> lc_messages = en_US
> skip-external-locking
> #
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> ### ASS: bind-address = 127.0.0.1
> bind-address = 0.0.0.0
> #
> # * Fine Tuning
> #
> max_connections = 100
> connect_timeout = 5
> wait_timeout = 600
> max_allowed_packet = 16M
> thread_cache_size = 128
> sort_buffer_size = 4M
> bulk_insert_buffer_size = 16M
> tmp_table_size = 32M
> max_heap_table_size = 32M
> #
> # * MyISAM
> #
> # This replaces the startup script and checks MyISAM tables if needed
> # the first time they are touched. On error, make copy and try a repair.
> myisam_recover = BACKUP
> key_buffer_size = 128M
> #open-files-limit = 2000
> table_open_cache = 400
> myisam_sort_buffer_size = 512M
> concurrent_insert = 2
> read_buffer_size = 2M
> read_rnd_buffer_size = 1M
> #
> # * Query Cache Configuration
> #
> # Cache only tiny result sets, so we can fit more in the query cache.
> query_cache_limit = 128K
> query_cache_size = 64M
> # for more write intensive setups, set to DEMAND or OFF
> #query_cache_type = DEMAND
> #
> # * Logging and Replication
> #
> # Both location gets rotated by the cronjob.
> # Be aware that this log type is a performance killer.
> # As of 5.1 you can enable the log at runtime!
> #general_log_file = /var/log/mysql/mysql.log
> #general_log = 1
> #
> # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
> #
> # we do want to know about network errors and such
> log_warnings = 2
> #
> # Enable the slow query log to see queries with especially long duration
> #slow_query_log[={0|1}]
> slow_query_log_file = /var/log/mysql/mariadb-slow.log
> long_query_time = 10
> #log_slow_rate_limit = 1000
> log_slow_verbosity = query_plan
>
> #log-queries-not-using-indexes
> #log_slow_admin_statements
> #
> # The following can be used as easy to replay backup logs or for replication.
> # note: if you are setting up a replication slave, see README.Debian about
> # other settings you may need to change.
> #server-id = 1
> #report_host = master1
> #auto_increment_increment = 2
> #auto_increment_offset = 1
> log_bin = /var/log/mysql/mariadb-bin
> log_bin_index = /var/log/mysql/mariadb-bin.index
> # not fab for performance, but safer
> #sync_binlog = 1
> expire_logs_days = 10
> max_binlog_size = 100M
> # slaves
> #relay_log = /var/log/mysql/relay-bin
> #relay_log_index = /var/log/mysql/relay-bin.index
> #relay_log_info_file = /var/log/mysql/relay-bin.info
> #log_slave_updates
> #read_only
> #
> # If applications support it, this stricter sql_mode prevents some
> # mistakes like inserting invalid dates etc.
> #sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL
> #
> # * InnoDB
> #
> # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
> # Read the manual for more InnoDB related options. There are many!
> default_storage_engine = InnoDB
> # you can't just change log file size, requires special procedure
> #innodb_log_file_size = 50M
> innodb_buffer_pool_size = 256M
> innodb_log_buffer_size = 8M
> innodb_file_per_table = 1
> innodb_open_files = 400
> innodb_io_capacity = 400
> innodb_flush_method = O_DIRECT
> #
> # * Security Features
> #
> # Read the manual, too, if you want chroot!
> # chroot = /var/lib/mysql/
> #
> # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
> #
> # ssl-ca=/etc/mysql/cacert.pem
> # ssl-cert=/etc/mysql/server-cert.pem
> # ssl-key=/etc/mysql/server-key.pem
>
>
>
> [mysqldump]
> quick
> quote-names
> max_allowed_packet = 16M
>
> [mysql]
> #no-auto-rehash # faster start of mysql but no tab completition
>
> [isamchk]
> key_buffer = 16M
>
> #
> # * IMPORTANT: Additional settings that can override those from this file!
> # The files must end with '.cnf', otherwise they'll be ignored.
> #
> !includedir /etc/mysql/conf.d/It would come from the configuration of the Database formatting, schema, etc that, if incorrect, would hinder the proper operations of Mattermost even while it is running. I have been referring to this Mattermost Github issue, which seems to be exactly what you are experiencing. If you read it from top-down, you will see me asking about the schema of the table is related to the first posted possible solution in the Github thread. At this point in time, I am now asking about this possible solution, which from what I can see, is what your configuration is set to be:
cedarice commented on Feb 28, 2019
I found a solution:
For mariadb, update your *my.cnf file with following configuration,
innodb_default_row_format=dynamic
innodb_file_format=barracuda
innodb_file_per_table=true
innodb_large_prefix=true
Then, you have to restart mariadb service for updated configuration to take effect.
reference: https://stackoverflow.com/a/52778785
If you take a look at that, could you let me know what you find, from the various schemas that you may want to check, as well as from your configuration files?
I’m sorry, but at the moment I have no idea what to do, what to find, what schemas are meant.
Your my.cnf entries are all there except:
“innodb_default_row_format=dynamic”.
I added this line and can’t restart MariaDB now.
systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Die 2021-01-19 19:31:09 CET; 39s ago
Docs: man:systemd-sysv-generator(8)
Process: 7469 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
Process: 7509 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Jän 19 19:30:38 SERVER systemd[1]: Starting LSB: Start and stop the mysql database server daemon…
Jän 19 19:30:38 SERVER mysql[7509]: * Starting MariaDB database server mysqld
Jän 19 19:31:09 SERVER mysql[7509]: …fail!
Jän 19 19:31:09 SERVER systemd[1]: mysql.service: Control process exited, code=exited status=1
Jän 19 19:31:09 SERVER systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jän 19 19:31:09 SERVER systemd[1]: mysql.service: Unit entered failed state.
Jän 19 19:31:09 SERVER systemd[1]: mysql.service: Failed with result ‘exit-code’.
I also have a number of websites running on Apache, including Nextcloud for these clubs, which are created in Mattermost.
And what other configuration files do you mean?
I found as follows:
updatedb; locate my.cnf
/etc/alternatives/my.cnf
/etc/mysql/my.cnf
/etc/mysql/my.cnf.dpkg-old
/etc/mysql/my.cnf.fallback
/etc/mysql/my.cnf.migrated
/root/.my.cnf
/var/lib/dpkg/alternatives/my.cnf
locate mariadb.cnf
/etc/mysql/mariadb.cnf
/etc/mysql/conf.d/mariadb.cnf
If these files are of interest, I’ll post their contents here.
I’m sorry, I need more specific instructions on what to try.
No more instructions? 
Alright, it seems to be database customizations that are preventing my Mattermost installation from updating. Is there any documentation on WHAT needs to be changed? Or is there a routine that does this?
Or is it better if I update previous Mattermost versions one by one? If so, which earlier version should I try?
Another idea:
Is there a possibility to export data from version 5.3.1 and import them in last mattermost version?
I don’t want to believe that I have to give up all the previous data to get to a new version.
Also the new Android clients don’t work with my old version anymore …
1 Like
Hi! I’m sorry about the delay in response, I’ve been swamped with work lately.
To clarify what a database schema is, I took this definition from Wikipedia:
The database schema of a database is its structure described in a formal language supported by the database management system. The term "schema" refers to the organization of data as a blueprint of how the database is constructed.
A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.
Knowing this, when I was referencing your database schema, and asking about the schema, It is because a schema error, such as a data table in the wrong format, etc, could be causing a lot of issues.
On that note, would you be willing to provide your entire Mattermost database schema for us to look over?
You can do this with the following command, from your command line:
mysqldump -d -u someuser -p mattermost
Note: Replace someuser with your MySQL user’s username.
Then, if you could, copy and paste the output of running this command into a response post here, if you could, and format it by putting it between a set of three backticks (```) so that the formatting of the output is preserved.
Thanks!
Hello XxLilBoPeepsxX,
I now understand WHAT is meant by schema, I already know that, I just didn’t understand it by that name. Below is the output of your command.
One other question:
I need to upgrade MariaDB to version 10.2 for Nextcloud 21. Does this also fit for Mattermost?
# mysqldump -d -u root -p mattermost
Enter password:
-- MySQL dump 10.15 Distrib 10.0.38-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: mattermost
-- ------------------------------------------------------
-- Server version 10.0.38-MariaDB-0ubuntu0.16.04.1
/*!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 utf8 */;
/*!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 `Audits`
--
DROP TABLE IF EXISTS `Audits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Audits` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`Action` text,
`ExtraInfo` text,
`IpAddress` varchar(64) DEFAULT NULL,
`SessionId` varchar(26) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `idx_audits_user_id` (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ChannelMemberHistory`
--
DROP TABLE IF EXISTS `ChannelMemberHistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ChannelMemberHistory` (
`ChannelId` varchar(26) NOT NULL,
`UserId` varchar(26) NOT NULL,
`JoinTime` bigint(20) NOT NULL,
`LeaveTime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ChannelId`,`UserId`,`JoinTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ChannelMembers`
--
DROP TABLE IF EXISTS `ChannelMembers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ChannelMembers` (
`ChannelId` varchar(26) NOT NULL,
`UserId` varchar(26) NOT NULL,
`Roles` varchar(64) DEFAULT NULL,
`LastViewedAt` bigint(20) DEFAULT NULL,
`MsgCount` bigint(20) DEFAULT NULL,
`MentionCount` bigint(20) DEFAULT NULL,
`NotifyProps` text,
`LastUpdateAt` bigint(20) DEFAULT NULL,
`SchemeUser` tinyint(1) DEFAULT NULL,
`SchemeAdmin` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`ChannelId`,`UserId`),
KEY `idx_channelmembers_channel_id` (`ChannelId`),
KEY `idx_channelmembers_user_id` (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`TeamId` varchar(26) DEFAULT NULL,
`Type` varchar(1) DEFAULT NULL,
`DisplayName` varchar(64) DEFAULT NULL,
`Name` varchar(64) DEFAULT NULL,
`Header` text,
`Purpose` varchar(250) DEFAULT NULL,
`LastPostAt` bigint(20) DEFAULT NULL,
`TotalMsgCount` bigint(20) DEFAULT NULL,
`ExtraUpdateAt` bigint(20) DEFAULT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`SchemeId` varchar(26) DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`,`TeamId`),
KEY `idx_channels_team_id` (`TeamId`),
KEY `idx_channels_name` (`Name`),
KEY `idx_channels_update_at` (`UpdateAt`),
KEY `idx_channels_create_at` (`CreateAt`),
KEY `idx_channels_delete_at` (`DeleteAt`),
FULLTEXT KEY `idx_channel_search_txt` (`Name`,`DisplayName`,`Purpose`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ClusterDiscovery`
--
DROP TABLE IF EXISTS `ClusterDiscovery`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ClusterDiscovery` (
`Id` varchar(26) NOT NULL,
`Type` varchar(64) DEFAULT NULL,
`ClusterName` varchar(64) DEFAULT NULL,
`Hostname` text,
`GossipPort` int(11) DEFAULT NULL,
`Port` int(11) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`LastPingAt` bigint(20) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `CommandWebhooks`
--
DROP TABLE IF EXISTS `CommandWebhooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CommandWebhooks` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`CommandId` varchar(26) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`ChannelId` varchar(26) DEFAULT NULL,
`RootId` varchar(26) DEFAULT NULL,
`ParentId` varchar(26) DEFAULT NULL,
`UseCount` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `idx_command_webhook_create_at` (`CreateAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Commands`
--
DROP TABLE IF EXISTS `Commands`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Commands` (
`Id` varchar(26) NOT NULL,
`Token` varchar(26) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`TeamId` varchar(26) DEFAULT NULL,
`Trigger` varchar(128) DEFAULT NULL,
`Method` varchar(1) DEFAULT NULL,
`Username` varchar(64) DEFAULT NULL,
`IconURL` text,
`AutoComplete` tinyint(1) DEFAULT NULL,
`AutoCompleteDesc` text,
`AutoCompleteHint` text,
`DisplayName` varchar(64) DEFAULT NULL,
`Description` varchar(128) DEFAULT NULL,
`URL` text,
PRIMARY KEY (`Id`),
KEY `idx_command_team_id` (`TeamId`),
KEY `idx_command_update_at` (`UpdateAt`),
KEY `idx_command_create_at` (`CreateAt`),
KEY `idx_command_delete_at` (`DeleteAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Compliances`
--
DROP TABLE IF EXISTS `Compliances`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Compliances` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`Status` varchar(64) DEFAULT NULL,
`Count` int(11) DEFAULT NULL,
`Desc` text,
`Type` varchar(64) DEFAULT NULL,
`StartAt` bigint(20) DEFAULT NULL,
`EndAt` bigint(20) DEFAULT NULL,
`Keywords` text,
`Emails` text,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Emoji`
--
DROP TABLE IF EXISTS `Emoji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Emoji` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`Name` varchar(64) DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`,`DeleteAt`),
KEY `idx_emoji_update_at` (`UpdateAt`),
KEY `idx_emoji_create_at` (`CreateAt`),
KEY `idx_emoji_delete_at` (`DeleteAt`),
KEY `idx_emoji_name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `FileInfo`
--
DROP TABLE IF EXISTS `FileInfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `FileInfo` (
`Id` varchar(26) NOT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`PostId` varchar(26) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`Path` text,
`ThumbnailPath` text,
`PreviewPath` text,
`Name` text,
`Extension` varchar(64) DEFAULT NULL,
`Size` bigint(20) DEFAULT NULL,
`MimeType` text,
`Width` int(11) DEFAULT NULL,
`Height` int(11) DEFAULT NULL,
`HasPreviewImage` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `idx_fileinfo_update_at` (`UpdateAt`),
KEY `idx_fileinfo_create_at` (`CreateAt`),
KEY `idx_fileinfo_delete_at` (`DeleteAt`),
KEY `idx_fileinfo_postid_at` (`PostId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `IncomingWebhooks`
--
DROP TABLE IF EXISTS `IncomingWebhooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `IncomingWebhooks` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`ChannelId` varchar(26) DEFAULT NULL,
`TeamId` varchar(26) DEFAULT NULL,
`DisplayName` varchar(64) DEFAULT NULL,
`Description` varchar(128) DEFAULT NULL,
`Username` varchar(64) DEFAULT '',
`IconURL` varchar(1024) DEFAULT '',
`ChannelLocked` tinyint(1) DEFAULT '0',
PRIMARY KEY (`Id`),
KEY `idx_incoming_webhook_user_id` (`UserId`),
KEY `idx_incoming_webhook_team_id` (`TeamId`),
KEY `idx_incoming_webhook_update_at` (`UpdateAt`),
KEY `idx_incoming_webhook_create_at` (`CreateAt`),
KEY `idx_incoming_webhook_delete_at` (`DeleteAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Jobs`
--
DROP TABLE IF EXISTS `Jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Jobs` (
`Id` varchar(26) NOT NULL,
`Type` varchar(32) DEFAULT NULL,
`Priority` bigint(20) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`StartAt` bigint(20) DEFAULT NULL,
`LastActivityAt` bigint(20) DEFAULT NULL,
`Status` varchar(32) DEFAULT NULL,
`Progress` bigint(20) DEFAULT NULL,
`Data` text,
PRIMARY KEY (`Id`),
KEY `idx_jobs_type` (`Type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Licenses`
--
DROP TABLE IF EXISTS `Licenses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Licenses` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`Bytes` text,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `OAuthAccessData`
--
DROP TABLE IF EXISTS `OAuthAccessData`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OAuthAccessData` (
`ClientId` varchar(26) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`Token` varchar(26) NOT NULL,
`RefreshToken` varchar(26) DEFAULT NULL,
`RedirectUri` text,
`ExpiresAt` bigint(20) DEFAULT NULL,
`Scope` varchar(128) DEFAULT NULL,
PRIMARY KEY (`Token`),
UNIQUE KEY `ClientId` (`ClientId`,`UserId`),
KEY `idx_oauthaccessdata_client_id` (`ClientId`),
KEY `idx_oauthaccessdata_user_id` (`UserId`),
KEY `idx_oauthaccessdata_refresh_token` (`RefreshToken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `OAuthApps`
--
DROP TABLE IF EXISTS `OAuthApps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OAuthApps` (
`Id` varchar(26) NOT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`ClientSecret` varchar(128) DEFAULT NULL,
`Name` varchar(64) DEFAULT NULL,
`Description` text,
`IconURL` text,
`CallbackUrls` text,
`Homepage` text,
`IsTrusted` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `idx_oauthapps_creator_id` (`CreatorId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `OAuthAuthData`
--
DROP TABLE IF EXISTS `OAuthAuthData`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OAuthAuthData` (
`ClientId` varchar(26) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`Code` varchar(128) NOT NULL,
`ExpiresIn` int(11) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`RedirectUri` text,
`State` varchar(1024) DEFAULT NULL,
`Scope` varchar(128) DEFAULT NULL,
PRIMARY KEY (`Code`),
KEY `idx_oauthauthdata_client_id` (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `OutgoingWebhooks`
--
DROP TABLE IF EXISTS `OutgoingWebhooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OutgoingWebhooks` (
`Id` varchar(26) NOT NULL,
`Token` varchar(26) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`CreatorId` varchar(26) DEFAULT NULL,
`ChannelId` varchar(26) DEFAULT NULL,
`TeamId` varchar(26) DEFAULT NULL,
`TriggerWords` text,
`TriggerWhen` int(11) DEFAULT NULL,
`CallbackURLs` text,
`DisplayName` varchar(64) DEFAULT NULL,
`Description` varchar(128) DEFAULT NULL,
`ContentType` varchar(128) DEFAULT NULL,
`Username` varchar(64) DEFAULT '',
`IconURL` varchar(1024) DEFAULT '',
PRIMARY KEY (`Id`),
KEY `idx_outgoing_webhook_team_id` (`TeamId`),
KEY `idx_outgoing_webhook_update_at` (`UpdateAt`),
KEY `idx_outgoing_webhook_create_at` (`CreateAt`),
KEY `idx_outgoing_webhook_delete_at` (`DeleteAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `PluginKeyValueStore`
--
DROP TABLE IF EXISTS `PluginKeyValueStore`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PluginKeyValueStore` (
`PluginId` varchar(190) NOT NULL,
`PKey` varchar(50) NOT NULL,
`PValue` mediumblob,
PRIMARY KEY (`PluginId`,`PKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Posts`
--
DROP TABLE IF EXISTS `Posts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Posts` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`EditAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`IsPinned` tinyint(1) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`ChannelId` varchar(26) DEFAULT NULL,
`RootId` varchar(26) DEFAULT NULL,
`ParentId` varchar(26) DEFAULT NULL,
`OriginalId` varchar(26) DEFAULT NULL,
`Message` text,
`Type` varchar(26) DEFAULT NULL,
`Props` text,
`Hashtags` text,
`Filenames` text,
`FileIds` varchar(150) DEFAULT NULL,
`HasReactions` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `idx_posts_update_at` (`UpdateAt`),
KEY `idx_posts_create_at` (`CreateAt`),
KEY `idx_posts_delete_at` (`DeleteAt`),
KEY `idx_posts_channel_id` (`ChannelId`),
KEY `idx_posts_root_id` (`RootId`),
KEY `idx_posts_user_id` (`UserId`),
KEY `idx_posts_is_pinned` (`IsPinned`),
KEY `idx_posts_channel_id_update_at` (`ChannelId`,`UpdateAt`),
KEY `idx_posts_channel_id_delete_at_create_at` (`ChannelId`,`DeleteAt`,`CreateAt`),
FULLTEXT KEY `idx_posts_message_txt` (`Message`),
FULLTEXT KEY `idx_posts_hashtags_txt` (`Hashtags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Preferences`
--
DROP TABLE IF EXISTS `Preferences`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Preferences` (
`UserId` varchar(26) NOT NULL,
`Category` varchar(32) NOT NULL,
`Name` varchar(32) NOT NULL,
`Value` text,
PRIMARY KEY (`UserId`,`Category`,`Name`),
KEY `idx_preferences_user_id` (`UserId`),
KEY `idx_preferences_category` (`Category`),
KEY `idx_preferences_name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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` (
`UserId` varchar(26) NOT NULL,
`PostId` varchar(26) NOT NULL,
`EmojiName` varchar(64) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
PRIMARY KEY (`UserId`,`PostId`,`EmojiName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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` (
`Id` varchar(26) NOT NULL,
`Name` varchar(64) DEFAULT NULL,
`DisplayName` varchar(128) DEFAULT NULL,
`Description` text,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`Permissions` text,
`SchemeManaged` tinyint(1) DEFAULT NULL,
`BuiltIn` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Schemes`
--
DROP TABLE IF EXISTS `Schemes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Schemes` (
`Id` varchar(26) NOT NULL,
`Name` varchar(64) DEFAULT NULL,
`DisplayName` varchar(128) DEFAULT NULL,
`Description` text,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`Scope` varchar(32) DEFAULT NULL,
`DefaultTeamAdminRole` varchar(64) DEFAULT NULL,
`DefaultTeamUserRole` varchar(64) DEFAULT NULL,
`DefaultChannelAdminRole` varchar(64) DEFAULT NULL,
`DefaultChannelUserRole` varchar(64) DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Sessions`
--
DROP TABLE IF EXISTS `Sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Sessions` (
`Id` varchar(26) NOT NULL,
`Token` varchar(26) DEFAULT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`ExpiresAt` bigint(20) DEFAULT NULL,
`LastActivityAt` bigint(20) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`DeviceId` text,
`Roles` varchar(64) DEFAULT NULL,
`IsOAuth` tinyint(1) DEFAULT NULL,
`Props` text,
PRIMARY KEY (`Id`),
KEY `idx_sessions_user_id` (`UserId`),
KEY `idx_sessions_token` (`Token`),
KEY `idx_sessions_expires_at` (`ExpiresAt`),
KEY `idx_sessions_create_at` (`CreateAt`),
KEY `idx_sessions_last_activity_at` (`LastActivityAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Status`
--
DROP TABLE IF EXISTS `Status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Status` (
`UserId` varchar(26) NOT NULL,
`Status` varchar(32) DEFAULT NULL,
`Manual` tinyint(1) DEFAULT NULL,
`LastActivityAt` bigint(20) DEFAULT NULL,
PRIMARY KEY (`UserId`),
KEY `idx_status_user_id` (`UserId`),
KEY `idx_status_status` (`Status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Systems`
--
DROP TABLE IF EXISTS `Systems`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Systems` (
`Name` varchar(64) NOT NULL,
`Value` text,
PRIMARY KEY (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `TeamMembers`
--
DROP TABLE IF EXISTS `TeamMembers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TeamMembers` (
`TeamId` varchar(26) NOT NULL,
`UserId` varchar(26) NOT NULL,
`Roles` varchar(64) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`SchemeUser` tinyint(1) DEFAULT NULL,
`SchemeAdmin` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`TeamId`,`UserId`),
KEY `idx_teammembers_team_id` (`TeamId`),
KEY `idx_teammembers_user_id` (`UserId`),
KEY `idx_teammembers_delete_at` (`DeleteAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Teams`
--
DROP TABLE IF EXISTS `Teams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Teams` (
`Id` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`DisplayName` varchar(64) DEFAULT NULL,
`Name` varchar(64) DEFAULT NULL,
`Description` varchar(255) DEFAULT NULL,
`Email` varchar(128) DEFAULT NULL,
`Type` varchar(255) DEFAULT NULL,
`CompanyName` varchar(64) DEFAULT NULL,
`AllowedDomains` text,
`InviteId` varchar(32) DEFAULT NULL,
`AllowOpenInvite` tinyint(1) DEFAULT NULL,
`LastTeamIconUpdate` bigint(20) DEFAULT '0',
`SchemeId` varchar(26) DEFAULT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`),
KEY `idx_teams_name` (`Name`),
KEY `idx_teams_invite_id` (`InviteId`),
KEY `idx_teams_update_at` (`UpdateAt`),
KEY `idx_teams_create_at` (`CreateAt`),
KEY `idx_teams_delete_at` (`DeleteAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Tokens`
--
DROP TABLE IF EXISTS `Tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Tokens` (
`Token` varchar(64) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`Type` varchar(64) DEFAULT NULL,
`Extra` varchar(128) DEFAULT NULL,
PRIMARY KEY (`Token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `UserAccessTokens`
--
DROP TABLE IF EXISTS `UserAccessTokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `UserAccessTokens` (
`Id` varchar(26) NOT NULL,
`Token` varchar(26) DEFAULT NULL,
`UserId` varchar(26) DEFAULT NULL,
`Description` text,
`IsActive` tinyint(1) DEFAULT '1',
PRIMARY KEY (`Id`),
UNIQUE KEY `Token` (`Token`),
KEY `idx_user_access_tokens_token` (`Token`),
KEY `idx_user_access_tokens_user_id` (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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` varchar(26) NOT NULL,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`Username` varchar(64) DEFAULT NULL,
`Password` varchar(128) DEFAULT NULL,
`AuthData` varchar(128) DEFAULT NULL,
`AuthService` varchar(32) DEFAULT NULL,
`Email` varchar(128) DEFAULT NULL,
`EmailVerified` tinyint(1) DEFAULT NULL,
`Nickname` varchar(64) DEFAULT NULL,
`FirstName` varchar(64) DEFAULT NULL,
`LastName` varchar(64) DEFAULT NULL,
`Position` varchar(128) DEFAULT NULL,
`Roles` text,
`AllowMarketing` tinyint(1) DEFAULT NULL,
`Props` text,
`NotifyProps` text,
`LastPasswordUpdate` bigint(20) DEFAULT NULL,
`LastPictureUpdate` bigint(20) DEFAULT NULL,
`FailedAttempts` int(11) DEFAULT NULL,
`Locale` varchar(5) DEFAULT NULL,
`MfaActive` tinyint(1) DEFAULT NULL,
`MfaSecret` varchar(128) DEFAULT NULL,
`Timezone` varchar(256) DEFAULT '{"automaticTimezone":"","manualTimezone":"","useAutomaticTimezone":"true"}',
PRIMARY KEY (`Id`),
UNIQUE KEY `Username` (`Username`),
UNIQUE KEY `AuthData` (`AuthData`),
UNIQUE KEY `Email` (`Email`),
KEY `idx_users_email` (`Email`),
KEY `idx_users_update_at` (`UpdateAt`),
KEY `idx_users_create_at` (`CreateAt`),
KEY `idx_users_delete_at` (`DeleteAt`),
FULLTEXT KEY `idx_users_all_txt` (`Username`,`FirstName`,`LastName`,`Nickname`,`Email`),
FULLTEXT KEY `idx_users_all_no_full_name_txt` (`Username`,`Nickname`,`Email`),
FULLTEXT KEY `idx_users_names_txt` (`Username`,`FirstName`,`LastName`,`Nickname`),
FULLTEXT KEY `idx_users_names_no_full_name_txt` (`Username`,`Nickname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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 2021-01-28 16:46:49
Since we last deleted the mattermost.service, I now start “sudo -u mattermost /opt/mattermost/bin/mattermost” in the /etc/rc.local file.
I don’t know if this is related, but images are now no longer displayed, but PDF and Office files are. PDF files can be downloaded only, their content is no longer displayed in a window.
(EDIT: No file is downloadable. The Linux download window appears, but nothing more happens; no file downloaded)
What could be to blame for this?
Hello, I’m sorry for the delay in response, I’ve been unusually busy with a new job I recently just took.
@ahmaddanial It looks like there are major differences between the database schema that @SuziQ provided from the schema output command, compared to that of my instance’s database. I’ve included screenshots below, from a small portion of the differences. SuziQ provided from the schema output command, compared to that of my instance’s database. I’ve included screenshots below, from a small portion of the differences. @SuziQ’s database schema is on the left side of the images, mine is on the right.
Note that there are entire tables that are shown as not present in his schema, and that many of the charsets are also different. Could this perhaps be causing issues?
On the note of the issues downloading and sending files from your instance @SuziQ , it seems that your database is missing some information in it’s schema that would tell it where to find the files it’s being requested to download, as you can see in the following two screenshots, which seem to indicate that there are more than a few columns missing from this table in particular.
Since there are over 900 lines of each schema, I’m not going to fully screenshot the entire thing, and show all of the differences since it would be a lot to do. However, if It is useful to the troubleshooting, I’d be more than happy to in the future!
Hi, everyone.
I have been very busy on my end juggling between things. So sorry for the radio silence.
I read back the entire thread from the top just to see if I miss out on any details. At this point of time, I think we will have to take the longer route to upgrade this instance especially when @SuziQ mentioned this:
Gathering all the information that has been shared, clearly there is an issue with the database schema after the upgrade takes place. So, what are your thoughts on upgrading based on ESR while we also check on the Important Upgrade Notes here?
In this case, this is what I have in mind.
5.3.1 > 5.9 (observe that everything works) > 5.19 (observe that everything works) > 5.25 (at least until the end of support)
Does that make sense? Maybe we can schedule a session to do this (hopefully if I don’t get too busy)?
1 Like
Hello,
yes, I’m happy to try the updates step by step, however I currently no longer have a correctly working version 5.3.1 as all files won’t open. I have no idea how this could happen this time (sql export/import). I must have restored my Mattermost instance 10 times already.
There is little point in upgrading to version 5.9 in this state, I think.
@XxLilBoPeepsxX: Is it possible that the database differences shown are from two different MM versions? I’m guessing that there has been development here over time as well.
Can we work together to solve the unopenable files problem first?