[reignviper]

Table sample: Works with all data. There is some junk in the set that would need to be removed

CREATE TABLE `idtech_users` (   `UserID` int DEFAULT NULL,   `CompanyID` int DEFAULT NULL,   `ExternalCompanyID` int DEFAULT NULL,   `DepartmentID` int DEFAULT NULL,   `PrefUserContMethodID` int DEFAULT NULL,   `UserTypeID` int DEFAULT NULL,   `UserStatusTypeID` int DEFAULT NULL,   `EmployeeStatusTypeID` int DEFAULT NULL,   `GenderTypeID` int DEFAULT NULL,   `GenderPronounTypeID` int DEFAULT NULL,   `TeeShirtSizeTypeID` int DEFAULT NULL,   `AccessRestrictionTypeID` int DEFAULT NULL,   `VIPTypeID` int DEFAULT NULL,   `RefContactedTypeID` int DEFAULT NULL,   `OKToBeRefTypeID` int DEFAULT NULL,   `TimeZoneTypeID` int DEFAULT NULL,   `UserName` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,   `FirstName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,   `LastName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,   `MiddleInit` varchar(50) DEFAULT NULL,   `NickName` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,   `DisplayName` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,   `Initials` varchar(24) DEFAULT NULL,   `Suffix` varchar(50) DEFAULT NULL,   `Title` varchar(100) DEFAULT NULL,   `DateOfBirth` date DEFAULT NULL,   `LoginDisabled` tinyint(1) DEFAULT NULL,   `AccountLocked` tinyint(1) DEFAULT NULL,   `ForcePWChange` tinyint(1) DEFAULT NULL,   `FailedLoginCount` int DEFAULT NULL,   `LastLoginDate` datetime DEFAULT NULL,   `AccountNumber` varchar(70) DEFAULT NULL,   `CompanyName` varchar(100) DEFAULT NULL,   `COFToken` varchar(255) DEFAULT NULL,   `KermitAdminUserID` int DEFAULT NULL,   `KermitStaffAppID` int DEFAULT NULL,   `KermitRegNum` int DEFAULT NULL,   `KermitRegNumNM` varchar(100) DEFAULT NULL,   `RefContactsUsed` int DEFAULT NULL,   `AcctTypeMask` int DEFAULT NULL,   `AutoPayDayOrdinal` int DEFAULT NULL,   `AutoPayRegDate` date DEFAULT NULL,   `HideTermStaffEmpRec` tinyint(1) DEFAULT NULL,   `UserGuid` varchar(255) DEFAULT NULL,   `GuidString` varchar(255) DEFAULT NULL,   `Company` varchar(100) DEFAULT NULL,   `Department` varchar(100) DEFAULT NULL,   `UserAccountActivities` text,   `UserAddresses` text,   `UserRoles` text,   `PasswordClearText` varchar(255) DEFAULT NULL,   `Age` int DEFAULT NULL,   `FullName` varchar(170) DEFAULT NULL,   `FullNameOrUserName` varchar(170) DEFAULT NULL,   `LastNameThenFirst` varchar(170) DEFAULT NULL,   `FullNameAndCodeRed` varchar(170) DEFAULT NULL,   `PreferedFullName` varchar(170) DEFAULT NULL,   `CreatedUserID` varchar(255) DEFAULT NULL,   `CreatedDate` datetime DEFAULT NULL,   `LastUpdatedUserID` int DEFAULT NULL,   `LastUpdatedDate` datetime DEFAULT NULL,   `RowVersion` text,   `RecordStateID` int DEFAULT NULL )

[ssdkl]

brooooooooo !!!! cool stuff,grat skill

[ssdkl]

great database dude!

[komputahhakka]

Thank you so much!

[trowaway42000]

thanks for sharing

[Syednoor]

Thank you so much

[millicent143]

this is great

[willm506]

hey thank you so much

[hcaptcha]

This looks like an interesting post I will check this out when I get enough credits!

[darkm8866]

this for sharing