btcpayserver-plugin-builder/PluginBuilder/Data/Scripts/20.UnconfirmedUserCleanup.sql

6 lines
239 B
SQL

ALTER TABLE "AspNetUsers"
ADD COLUMN IF NOT EXISTS "CreatedAt" TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE INDEX IF NOT EXISTS "IX_AspNetUsers_EmailConfirmed_CreatedAt"
ON "AspNetUsers" ("EmailConfirmed", "CreatedAt");