From 7ad5f5aa60cc940dbd4c6ec6cb091e7214a3fdb4 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 2 Nov 2024 13:13:11 +0200 Subject: feat(data): update message queries --- query/messages.sql | 12 ++---------- 1 file changed, 2 insertions(+), 10 deletions(-) (limited to 'query') diff --git a/query/messages.sql b/query/messages.sql index 1e982b1..a598754 100644 --- a/query/messages.sql +++ b/query/messages.sql @@ -2,18 +2,10 @@ SELECT * FROM messages ORDER BY id; --- name: CreateDirectMessage :one -INSERT INTO messages ( - id, content, sender_id, receiver_id -) VALUES ( - ?, ?, ?, ? -) -RETURNING *; - -- name: CreateMessage :one INSERT INTO messages ( - id, content, sender_id, frequency_id + id, content, sender_id, frequency_id, receiver_id ) VALUES ( - ?, ?, ?, ? + ?, ?, ?, ?, ? ) RETURNING *; -- cgit v1.3.1