We're Hiring!

Mattermost, Inc.

Changed team URL by DB is it safe?

Hi
I have found workaround for changeing team’s URL using database update on teams.name
(https://mattermost.atlassian.net/browse/MM-1546)
But On that ticket someone asked an important question about an impact of that action.
Is it safe for data consistency to change team name (URL) in data base?

Hi, @piotr.gryzlo

In general, any direct database manipulation can cause data inconsistencies. I noticed in the MM-1546 that there were questions around side effects of the SQL query:

UPDATE teams SET name='<newname>' WHERE id='<teamid>';

Checking on the Teams table, the Name column is a unique key:

mysql> SHOW COLUMNS FROM Teams LIKE "Name";
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| Name  | varchar(64) | YES  | UNI | NULL    |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.01 sec)

So, I won’t recommend to do it. If you decide to proceed, please make sure you backup the database to make sure that you have a working backup that you can roll back to. Thanks.