IF OBJECT_ID(N'[dbo].[Users]', N'U') IS NULL
BEGIN
CREATE TABLE [dbo].[Users] (
[Id] BIGINT NOT NULL PRIMARY KEY IDENTITY(1, 1),
[Username] NVARCHAR(25) NOT NULL UNIQUE,
[PasswordHash] VARBINARY(MAX) NOT NULL,
[PasswordSalt] NVARCHAR(32) NOT NULL,
[EmailAddress] NVARCHAR(60) NOT NULL,
[Nickname] NVARCHAR(35) NOT NULL,
[SmallBio] NVARCHAR(300) NULL DEFAULT NULL,
[IsLocked] BIT NOT NULL DEFAULT ((0)),
[IsVerified] BIT NOT NULL DEFAULT ((0)),