mirror of
https://github.com/documenso/documenso.git
synced 2025-11-19 03:01:59 +10:00
7 lines
180 B
SQL
7 lines
180 B
SQL
UPDATE "User"
|
|
SET "emailVerified" = NOW()
|
|
FROM "Subscription"
|
|
WHERE "User"."id" = "Subscription"."userId"
|
|
AND "Subscription"."status" = 'ACTIVE'
|
|
AND "User"."emailVerified" IS NULL
|