diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-27 21:29:09 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-27 21:29:09 +0200 |
| commit | 82533fa7a583490ea9cebab48c4fc0cdeb3a02f8 (patch) | |
| tree | b8ef0197652e7385233230dbea5afaa4c8f82445 /query/frequencies.sql | |
| parent | 180bb557b1f82ce81fb042442b9bce75bbefb301 (diff) | |
Fixed sqlc codegen issues
Diffstat (limited to 'query/frequencies.sql')
| -rw-r--r-- | query/frequencies.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/query/frequencies.sql b/query/frequencies.sql index 6e67c24..464f371 100644 --- a/query/frequencies.sql +++ b/query/frequencies.sql @@ -12,7 +12,7 @@ INSERT INTO frequencies ( name, hex_color, perms, position ) VALUES ( - ?, @network_id, ?, ?, ?, + @id, @network_id, @name, @hex_color, @perms, (SELECT COUNT(*) FROM frequencies WHERE network_id = @network_id) ) RETURNING *; @@ -23,7 +23,7 @@ UPDATE frequencies SET WHEN position = @pos1 THEN @pos2 WHEN position = @pos2 THEN @pos1 END -WHERE network_id = ? AND position IN (@pos1, @pos2); +WHERE network_id = @network_id AND position IN (@pos1, @pos2); -- name: SetFrequencyName :one UPDATE frequencies SET |