nostr-rs-relay

commit b3c7852b1988c6cb1ad403d59723c2f138d104b8
parent 6910b8d945f8c811f48b169cc7f0877111add11b
Author: Greg Heartsfield <scsibug@imap.cc>
Date:   Sun, 12 Dec 2021 14:34:52 -0600

fix: correct SQL query for inserting pubkeys

Diffstat:
M
src/db.rs
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/db.rs b/src/db.rs
@@ -145,7 +145,7 @@ pub fn write_event(conn: &mut Connection, e: &Event) -> Result<usize> {
     if !ptags.is_empty() {
         for ptag in ptags.iter() {
             tx.execute(
-                "INSERT OR IGNORE INTO event_ref (event_id, referenced_pubkey) VALUES (?1, ?2)",
+                "INSERT OR IGNORE INTO pubkey_ref (event_id, referenced_pubkey) VALUES (?1, ?2)",
                 params![ev_id, hex::decode(&ptag).ok()],
             )?;
         }