glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sync_auth_fields_to_siblings()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF pg_trigger_depth() > 1 THEN RETURN NEW; END IF; IF NEW.email IS NULL THEN RETURN NEW; END IF; IF NEW."deletedAt" IS NOT NULL THEN RETURN NEW; END IF; UPDATE "Users" SET "password" = NEW."password", "passwordLastChangedAt" = NEW."passwordLastChangedAt", "passwordResetToken" = NEW."passwordResetToken", "passwordResetTokenExpiry" = NEW."passwordResetTokenExpiry", "emailVerificationToken" = NEW."emailVerificationToken", "emailVerificationTokenExpiry" = NEW."emailVerificationTokenExpiry", "phoneNumberVerificationToken" = NEW."phoneNumberVerificationToken", "phoneNumberVerificationTokenExpiry"= NEW."phoneNumberVerificationTokenExpiry", "whatsappVerificationToken" = NEW."whatsappVerificationToken", "whatsappVerificationTokenExpiry" = NEW."whatsappVerificationTokenExpiry", "shadowBanned" = NEW."shadowBanned", "BanningOperatorId" = NEW."BanningOperatorId", "banNote" = NEW."banNote", "bannedAt" = NEW."bannedAt", "updatedAt" = NOW() WHERE LOWER("email") = LOWER(NEW."email") AND "id" <> NEW."id" AND "deletedAt" IS NULL; RETURN NEW; END;