initial commit
[squeep-indie-auther] / src / db / postgres / sql / profile-scopes-set-all.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 = ANY ($(scopes))
5