dd667f2960f2690a6c9630995559f326bc45f808
[squeep-indie-auther] / src / db / postgres / sql / token-scopes-remove.sql
1 --
2 DELETE FROM token_scope
3 WHERE (code_id, scope_id) IN (
4 SELECT code_id, scope_id FROM token_scope ts
5 INNER JOIN scope s USING (scope_id)
6 WHERE scope = ANY($(removeScopes)) AND code_id = $(codeId)
7 )