diff options
Diffstat (limited to 'query/networks.sql')
| -rw-r--r-- | query/networks.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/query/networks.sql b/query/networks.sql index 0b0303f..b2720b7 100644 --- a/query/networks.sql +++ b/query/networks.sql @@ -11,7 +11,7 @@ INSERT INTO networks ( id, owner_id, name, is_public, icon, bg_hex_color, fg_hex_color ) VALUES ( - ?, ?, ?, ?, + ?, ?, ?, ?, ?, ?, ? ) RETURNING *; @@ -69,13 +69,13 @@ INSERT INTO users_networks ( is_member, is_admin, is_muted, is_banned, ban_reason ) VALUES ( - ?, ?, - ?, ?, ?, - ?, ? + ?1, ?2, + ?3, ?4, ?5, + ?6, ?7 ) ON CONFLICT DO UPDATE SET - is_member = ?, is_admin = ?, is_muted = ?, - is_banned = ?, ban_reason = ? -WHERE user_id = ? AND network_id = ? + is_member = ?3, is_admin = ?4, is_muted = ?5, + is_banned = ?6, ban_reason = ?7 +WHERE user_id = ?1 AND network_id = ?2 RETURNING *; |
