Table_Create_Users.sql

CREATE TABLE Users (
AccountExpirationDate datetime,
accountExpires datetime,
AccountLockoutTime datetime,
AllowReversiblePasswordEncryption varchar(255),
badPasswordTime datetime,
badPwdCount int,
CannotChangePassword varchar(255),
CanonicalName varchar(255),
City varchar(255),
CN varchar(255),
Company varchar(255),
Country varchar(255),
countryCode varchar(255),
Created datetime,
Deleted datetime,
Department varchar(255),
Description varchar(255),
DisplayName varchar(255),
DistinguishedName varchar(255),
EmailAddress varchar(255),
EmployeeID varchar(255),
EmployeeNumber varchar(255),
Enabled varchar(255),
extensionAttribute14 varchar(255),
Fax varchar(255),
GivenName varchar(255),
isDeleted varchar(255),
LastBadPasswordAttempt datetime,
LastLogonDate datetime,
LockedOut varchar(255),
Manager varchar(255),
MemberOf varchar(255),
Modified datetime,
Name varchar(255),
ObjectCategory varchar(255),
ObjectClass varchar(255),
ObjectGUID varchar(255) PRIMARY KEY,
objectSid varchar(255),
PasswordExpired datetime,
PasswordLastSet datetime,
PasswordNeverExpires varchar(255),
PasswordNotRequired varchar(255),
pwdLastSet datetime,
SamAccountName varchar(255),
SID varchar(255),
SIDHistory varchar(255),
UserPrincipalName varchar(255),
whenChanged datetime,
whenCreated timestamp
)