initial commit

[squeep-indie-auther] / src / db / sqlite / sql / token-scopes-get-by-code-id.sql

diff --git a/src/db/sqlite/sql/token-scopes-get-by-code-id.sql b/src/db/sqlite/sql/token-scopes-get-by-code-id.sql
new file mode 100644 (file)
index 0000000..5bd7b30
--- /dev/null
+++ b/src/db/sqlite/sql/token-scopes-get-by-code-id.sql
@@ -0,0 +1,4 @@
+--
+SELECT s.scope FROM token_scope ts
+       INNER JOIN scope s USING (scope_id)
+       WHERE ts.code_id = :codeId