mirror of
https://github.com/mattermost/mattermost.git
synced 2026-02-03 20:40:00 -05:00
c943ed6859
Combines the following repositories into one: https://github.com/mattermost/mattermost-server https://github.com/mattermost/mattermost-webapp https://github.com/mattermost/focalboard https://github.com/mattermost/mattermost-plugin-playbooks
5 lines
328 B
SQL
5 lines
328 B
SQL
-- Drop any existing TeamId column from 000094_threads_teamid.up.sql
|
|
ALTER TABLE threads DROP COLUMN IF EXISTS teamid;
|
|
|
|
ALTER TABLE threads ADD COLUMN IF NOT EXISTS threadteamid VARCHAR(26);
|
|
UPDATE threads SET threadteamid = channels.teamid FROM channels WHERE threads.threadteamid IS NULL AND channels.id = threads.channelid;
|