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, 3 insertions, 3 deletions

diff --git a/internal/storage/storage_test.go b/internal/storage/storage_test.go
index f2fe401..89369f4 100644
--- a/internal/storage/storage_test.go
+++ b/internal/storage/storage_test.go
@@ -19,14 +19,14 @@ func TestNew(t *testing.T) {
 
         // Verify schema was created by checking if tables exist
         var count int
-        query := `SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name IN ('events', 'deletions', 'replaceable_events')`
+        query := `SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name IN ('events', 'replaceable_events')`
         err = store.DB().QueryRow(query).Scan(&count)
         if err != nil {
                 t.Fatalf("failed to query tables: %v", err)
         }
 
-        if count != 3 {
-                t.Errorf("expected 3 main tables, got %d", count)
+        if count != 2 {
+                t.Errorf("expected 2 main tables, got %d", count)
         }
 }