1 files changed, 18 insertions, 16 deletions
diff --git a/packages/meshbay-hub/src/meshbay_hub/db/models.py b/packages/meshbay-hub/src/meshbay_hub/db/models.py
index 09eb437..5b140f1 100644
--- a/packages/meshbay-hub/src/meshbay_hub/db/models.py
+++ b/packages/meshbay-hub/src/meshbay_hub/db/models.py
@@ -266,22 +266,6 @@ class UserDevice(Base):
     __table_args__ = (Index("ix_user_devices_user", "user_id"),)
 
 
-class SwarmSource(Base):
-    """
-    Tracks which nodes can serve a given content hash (public swarm).
-    Hub maintains this for load-balanced public content delivery.
-    """
-    __tablename__ = "swarm_sources"
-
-    content_hash: Mapped[str] = mapped_column(String(64), primary_key=True)
-    node_id:      Mapped[str] = mapped_column(String(36), primary_key=True)
-    endpoint:     Mapped[str] = mapped_column(String(128), nullable=False)
-    registered_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=_now)
-    last_seen:    Mapped[datetime] = mapped_column(DateTime(timezone=True), default=_now)
-
-    __table_args__ = (Index("ix_swarm_hash", "content_hash"),)
-
-
 class Notification(Base):
     __tablename__ = "notifications"
 
@@ -341,6 +325,24 @@ class ContentBlocklist(Base):
     added_by:     Mapped[str | None] = mapped_column(String(64))  # "auto" or admin username
 
 
+class ContentReview(Base):
+    """
+    A reported hash waiting for — or given — an administrator's decision.
+
+    Opened when enough distinct accounts have reported it; `status` is
+    `pending`, then `blocked` or `dismissed`. A dismissed hash stays dismissed:
+    more reports of it do not reopen it, and an administrator can still block
+    it from the blocklist. The reports themselves stay in `content_reports`.
+    """
+    __tablename__ = "content_reviews"
+
+    content_hash: Mapped[str] = mapped_column(String(64), primary_key=True)
+    status:       Mapped[str] = mapped_column(String(16), default="pending")
+    opened_at:    Mapped[datetime] = mapped_column(DateTime(timezone=True), default=_now)
+    decided_at:   Mapped[datetime | None] = mapped_column(DateTime(timezone=True))
+    decided_by:   Mapped[str | None] = mapped_column(String(64))
+
+
 class UserPreference(Base):
     __tablename__ = "user_preferences"