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, 11 deletions

diff --git a/internal/handler/grpc/server.go b/internal/handler/grpc/server.go
index b1ffd96..b65b527 100644
--- a/internal/handler/grpc/server.go
+++ b/internal/handler/grpc/server.go
@@ -13,7 +13,6 @@ import (
 type EventStore interface {
         StoreEvent(context.Context, *storage.EventData) error
         QueryEvents(context.Context, []*pb.Filter, *storage.QueryOptions) ([]*pb.Event, error)
-        ProcessDeletion(context.Context, *pb.Event) error
 }
 
 type Server struct {
@@ -76,16 +75,6 @@ func (s *Server) PublishEvent(ctx context.Context, req *pb.PublishEventRequest)
                 return nil, fmt.Errorf("failed to store event: %w", err)
         }
 
-        if req.Event.Kind == 5 {
-                if err := s.store.ProcessDeletion(ctx, req.Event); err != nil {
-                        return &pb.PublishEventResponse{
-                                Accepted:      false,
-                                Message:       fmt.Sprintf("deletion processing failed: %v", err),
-                                CanonicalJson: canonicalJSON,
-                        }, nil
-                }
-        }
-
         s.subs.MatchAndFan(req.Event)
 
         return &pb.PublishEventResponse{