X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Finsert_message.sql;h=f7faa2950f1d20485d001a9d4488119f4c645ec9;hp=20facb8aeef12fc8de86536d39aaead580672398;hb=092e6b212637ffbf68800584b7c1f32d1931b602;hpb=3cf5c49e7753be48a994917fe898730add4292b1;ds=sidebyside diff --git a/src/core/SQL/SQLite/insert_message.sql b/src/core/SQL/SQLite/insert_message.sql index 20facb8a..f7faa295 100644 --- a/src/core/SQL/SQLite/insert_message.sql +++ b/src/core/SQL/SQLite/insert_message.sql @@ -1,2 +1,5 @@ -INSERT INTO backlog (time, bufferid, type, flags, senderid, message) -VALUES (:time, :bufferid, :type, :flags, (SELECT senderid FROM sender WHERE sender = :sender), :message) +INSERT INTO backlog (time, bufferid, type, flags, senderid, senderprefixes, message) +VALUES (:time, :bufferid, :type, :flags, + (SELECT senderid FROM sender WHERE sender = :sender AND coalesce(realname, '') = coalesce(:realname, '') AND coalesce(avatarurl, '') = coalesce(:avatarurl, '')), + :senderprefixes, :message +)