projects
/
squeep-indie-auther
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
c3ea5bb877dc1d4ca4c3216c8678010484b1e71b
[squeep-indie-auther]
/
src
/
db
/
sqlite
/
sql
/
token-get-by-code-id.sql
1
--
2
SELECT
3
t.code_id
,
4
p.profile
,
5
t.created
,
6
t.expires
,
7
t.refresh_expires
,
8
t.refreshed
,
9
t.duration
,
10
t.refresh_duration
,
11
t.refresh_count
,
12
t.is_revoked
,
13
t.is_token
,
14
t.client_id
,
15
t.profile_data
,
16
a.identifier
17
FROM token
t
18
INNER JOIN
profile p
USING
(
profile_id
)
19
INNER JOIN
authentication a
USING
(
identifier_id
)
20
WHERE
code_id
=
:codeId