CREATE TABLE "AppOwnerShop" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "ownerId" TEXT NOT NULL,
    "shopId" TEXT NOT NULL,
    "assignedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "AppOwnerShop_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "AppAccount" ("id") ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE UNIQUE INDEX "AppOwnerShop_shopId_key" ON "AppOwnerShop"("shopId");
CREATE INDEX "AppOwnerShop_ownerId_idx" ON "AppOwnerShop"("ownerId");