diff options
Diffstat (limited to 'query/users_networks.sql')
| -rw-r--r-- | query/users_networks.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/query/users_networks.sql b/query/users_networks.sql index f467753..76cecf4 100644 --- a/query/users_networks.sql +++ b/query/users_networks.sql @@ -22,6 +22,10 @@ JOIN users_networks ON networks.id = users_networks.network_id WHERE users_networks.user_id = ? ORDER BY users_networks.position; +-- name: GetUserNetwork :one +SELECT * FROM users_networks +WHERE user_id = ? AND network_id = ?; + -- name: SetNetworkUser :one INSERT INTO users_networks ( user_id, network_id, |