mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
4f26ca1a7b
* feat: Base implementation of v2 of avatars * Make avatarUrl and logoUrl entirely optional * Made necessary backwards compat changes * fix: type errors * Fix: OG image * fix types * Consistency with other behaviour, ux tweak --------- Co-authored-by: Peer Richelsen <[email protected]>
20 lines
499 B
SQL
20 lines
499 B
SQL
-- AlterTable
|
|
ALTER TABLE "Team" ADD COLUMN "logoUrl" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "users" ADD COLUMN "avatarUrl" TEXT;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "avatars" (
|
|
"teamId" INTEGER NOT NULL DEFAULT 0,
|
|
"userId" INTEGER NOT NULL DEFAULT 0,
|
|
"data" TEXT NOT NULL,
|
|
"objectKey" TEXT NOT NULL
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "avatars_objectKey_key" ON "avatars"("objectKey");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "avatars_teamId_userId_key" ON "avatars"("teamId", "userId");
|