diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-12-01 10:09:21 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-12-01 10:09:21 +0200 |
| commit | 78a38f508e7b9d2389c9c422c2d164b9059b03f8 (patch) | |
| tree | 67550791d99597eaa6ab50334ccc880f06a8de17 /query/users_networks.sql | |
| parent | 94166da109cf19ce48311d07aa67875fcb85f178 (diff) | |
Implemented frequency creation, BROKEN right now
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, |