refactor: simplify deletion handling (remove NIP-09 processing)

Remove deletion processing logic in favor of simpler approach:
- Remove deletions table from schema
- Delete deletions.go and deletions_test.go
- Remove ProcessDeletion from EventStore interface
- Kind 5 events now stored like any other event (no special handling)
- Update storage test to expect 2 tables instead of 3
- All 41 tests passing

1 files changed, 0 insertions, 70 deletions

diff --git a/internal/storage/deletions.go b/internal/storage/deletions.go
deleted file mode 100644
index 1a07e3c..0000000
--- a/internal/storage/deletions.go
+++ /dev/null
@@ -1,70 +0,0 @@
-package storage
-
-import (
-        "context"
-        "fmt"
-
-        pb "northwest.io/nostr-grpc/api/nostr/v1"
-)
-
-const KindDeletion = 5
-
-func (s *Storage) ProcessDeletion(ctx context.Context, deletionEvent *pb.Event) error {
-        if deletionEvent.Kind != KindDeletion {
-                return fmt.Errorf("not a deletion event")
-        }
-
-        var eventIDsToDelete []string
-        for _, tag := range deletionEvent.Tags {
-                if len(tag.Values) >= 2 && tag.Values[0] == "e" {
-                        eventIDsToDelete = append(eventIDsToDelete, tag.Values[1])
-                }
-        }
-
-        if len(eventIDsToDelete) == 0 {
-                return nil
-        }
-
-        tx, err := s.db.BeginTx(ctx, nil)
-        if err != nil {
-                return fmt.Errorf("failed to begin transaction: %w", err)
-        }
-        defer tx.Rollback()
-
-        for _, eventID := range eventIDsToDelete {
-                var eventPubkey string
-                err := tx.QueryRowContext(ctx,
-                        "SELECT pubkey FROM events WHERE id = ? AND deleted = 0",
-                        eventID,
-                ).Scan(&eventPubkey)
-
-                if err != nil {
-                        continue
-                }
-
-                if eventPubkey != deletionEvent.Pubkey {
-                        continue
-                }
-
-                _, err = tx.ExecContext(ctx,
-                        "UPDATE events SET deleted = 1 WHERE id = ?",
-                        eventID,
-                )
-                if err != nil {
-                        return fmt.Errorf("failed to mark event as deleted: %w", err)
-                }
-
-                _, err = tx.ExecContext(ctx,
-                        "INSERT OR IGNORE INTO deletions (deleted_event_id, deletion_event_id, pubkey, created_at) VALUES (?, ?, ?, ?)",
-                        eventID,
-                        deletionEvent.Id,
-                        deletionEvent.Pubkey,
-                        deletionEvent.CreatedAt,
-                )
-                if err != nil {
-                        return fmt.Errorf("failed to record deletion: %w", err)
-                }
-        }
-
-        return tx.Commit()
-}