Extra columns in Users and Visitors
Release 1.0 - ...
The table Users and Visitors both have an extra set of columns:
| Column name | DataType | Nullable |
|---|---|---|
| LastLockoutDate | datetime | yes |
| FailedPasswordAttemptCount | int | no |
| FailedPasswordAttemptWindowStart | datetime | yes |
| LastLogin | datetime | yes |
| SQL |
Copy Code
|
|---|---|
ALTER TABLE Users ADD LastLockoutDate datetime NULL ALTER TABLE Users ADD FailedPasswordAttemptCount int NOT NULL DEFAULT 0 ALTER TABLE Users ADD FailedPasswordAttemptWindowStart datetime NULL ALTER TABLE Users ADD LastLogin datetime NULL ALTER TABLE Users ADD Locale int NULL ALTER TABLE Visitors ADD LastLockoutDate datetime NULL ALTER TABLE Visitors ADD FailedPasswordAttemptCount int NOT NULL DEFAULT 0 ALTER TABLE Visitors ADD FailedPasswordAttemptWindowStart datetime NULL ALTER TABLE Visitors ADD LastLogin datetime NULL ALTER TABLE Visitors ADD Locale int NULL exec pr_rebuildviews |
|