Database schema for a password reset functionality.

gistfile1.sql

CREATE TABLE [DataBaseName].[dbo].[PasswordResetTokens] (
    [token] varchar(36) NOT NULL, // 36 characters to fit GUID with delimiters
    [userId] int NOT NULL,
    [lastUpdate] datetime NOT NULL,
    [tokenUsed] bit NOT NULL,
    CONSTRAINT PasswordResetTokens_PK PRIMARY KEY (token),
    CONSTRAINT PasswordResetTokens_FK FOREIGN KEY (userId) REFERENCES [DataBaseName].[dbo].[User](id)
) GO
EXEC [DataBaseName].sys.sp_addextendedproperty 'MS_Description', 'Store Password Reset Tokens	', 'schema', 'dbo', 'table', 'PasswordResetTokens' GO