initial commit
[squeep-indie-auther] / src / db / sqlite / sql / profile-scope-insert.sql
1 --
2 INSERT INTO profile_scope (profile_id, scope_id)
3 SELECT p.profile_id, s.scope_id FROM profile p, scope s
4 WHERE p.profile = :profile AND s.scope = :scope
5 ON CONFLICT (profile_id, scope_id) DO NOTHING