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 строки
201 B
SQL
5 строки
201 B
SQL
DELETE o, s from OAuthAccessData o
|
|
LEFT JOIN Preferences p ON o.clientid = p.name AND o.userid = p.userid AND p.category = 'oauth_app'
|
|
INNER JOIN Sessions s ON o.token = s.token
|
|
WHERE p.name IS NULL;
|