25 lines
905 B
MySQL
25 lines
905 B
MySQL
|
IF COL_LENGTH('dbo.admins', 'two_factor_secret') IS NOT NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ALTER COLUMN two_factor_secret NVARCHAR(512) NULL;
|
||
|
|
END
|
||
|
|
IF COL_LENGTH('dbo.admins', 'password') IS NOT NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ALTER COLUMN password NVARCHAR(255) NOT NULL;
|
||
|
|
END
|
||
|
|
IF COL_LENGTH('dbo.admins', 'login_failed_count') IS NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ADD login_failed_count INT NOT NULL CONSTRAINT DF_admins_login_failed_count DEFAULT(0);
|
||
|
|
END
|
||
|
|
IF COL_LENGTH('dbo.admins', 'login_lock_until') IS NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ADD login_lock_until DATETIME2 NULL;
|
||
|
|
END
|
||
|
|
IF COL_LENGTH('dbo.admins', 'totp_failed_count') IS NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ADD totp_failed_count INT NOT NULL CONSTRAINT DF_admins_totp_failed_count DEFAULT(0);
|
||
|
|
END
|
||
|
|
IF COL_LENGTH('dbo.admins', 'totp_lock_until') IS NULL
|
||
|
|
BEGIN
|
||
|
|
ALTER TABLE dbo.admins ADD totp_lock_until DATETIME2 NULL;
|
||
|
|
END
|