fix: ensure we cleanup all tables when deleting (#2191)

1 files changed, 14 insertions, 2 deletions

diff --git a/crates/atuin-server-postgres/src/lib.rs b/crates/atuin-server-postgres/src/lib.rs
index 7aa87424..e28b6e09 100644
--- a/crates/atuin-server-postgres/src/lib.rs
+++ b/crates/atuin-server-postgres/src/lib.rs
@@ -401,13 +401,19 @@ impl Database for Postgres {
             .await
             .map_err(fix_error)?;
 
-        sqlx::query("delete from users where id = $1")
+        sqlx::query("delete from history where user_id = $1")
             .bind(u.id)
             .execute(&self.pool)
             .await
             .map_err(fix_error)?;
 
-        sqlx::query("delete from history where user_id = $1")
+        sqlx::query("delete from store where user_id = $1")
+            .bind(u.id)
+            .execute(&self.pool)
+            .await
+            .map_err(fix_error)?;
+
+        sqlx::query("delete from user_verification_token where user_id = $1")
             .bind(u.id)
             .execute(&self.pool)
             .await
@@ -419,6 +425,12 @@ impl Database for Postgres {
             .await
             .map_err(fix_error)?;
 
+        sqlx::query("delete from users where id = $1")
+            .bind(u.id)
+            .execute(&self.pool)
+            .await
+            .map_err(fix_error)?;
+
         Ok(())
     }