Merge branch 'feat/group-name-per-owner'

1 files changed, 9 insertions, 2 deletions

diff --git a/packages/meshbay-hub/src/meshbay_hub/db/models.py b/packages/meshbay-hub/src/meshbay_hub/db/models.py
index 0c337c1..dbabfc2 100644
--- a/packages/meshbay-hub/src/meshbay_hub/db/models.py
+++ b/packages/meshbay-hub/src/meshbay_hub/db/models.py
@@ -15,7 +15,7 @@ from datetime import datetime, timezone
 
 from sqlalchemy import (
     Boolean, DateTime, ForeignKey, Index, Integer,
-    String, Text, UniqueConstraint,
+    String, Text, UniqueConstraint, text,
 )
 from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, relationship
 
@@ -109,7 +109,14 @@ class Group(Base):
 
     members:     Mapped[list["GroupMember"]] = relationship(back_populates="group")
 
-    __table_args__ = (Index("ix_groups_name", "name"),)
+    __table_args__ = (
+        Index("ix_groups_name", "name"),
+        # One name per owner, case-insensitively. The group's identity stays its
+        # UUID; this is what makes `name@owner` a handle a human can rely on
+        # (two different owners may still both have a "photos"). Enforced in the
+        # DB so a race cannot slip a second one past the check in create_group.
+        Index("uq_groups_owner_name", "admin_id", text("lower(name)"), unique=True),
+    )
 
 
 class GroupMember(Base):