mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
bd6c471652
* feat: Workflow — Send Email to Specific Email * disable button when verifyEmail pending * add verified emails table and routes * fix: include teamId in verifyEmailCode * fix: include email address in activate handler * fix: check team before adding email * feat: check verified email, add to team if only users * remove logs * fix: if statement Co-authored-by: Carina Wollendorfer <[email protected]> * change email to verify your email * fix: show error if saving unverified email * fix: show email in subject * verify email when editing steps * remove double calls from same block * verify email when creating new step --------- Co-authored-by: v0ltZzie <[email protected]> Co-authored-by: Carina Wollendorfer <[email protected]>
22 lines
721 B
SQL
22 lines
721 B
SQL
-- CreateTable
|
|
CREATE TABLE "VerifiedEmail" (
|
|
"id" SERIAL NOT NULL,
|
|
"userId" INTEGER,
|
|
"teamId" INTEGER,
|
|
"email" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "VerifiedEmail_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "VerifiedEmail_userId_idx" ON "VerifiedEmail"("userId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "VerifiedEmail_teamId_idx" ON "VerifiedEmail"("teamId");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "VerifiedEmail" ADD CONSTRAINT "VerifiedEmail_userId_fkey" FOREIGN KEY ("userId") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "VerifiedEmail" ADD CONSTRAINT "VerifiedEmail_teamId_fkey" FOREIGN KEY ("teamId") REFERENCES "Team"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|