-- -----------------------------------
-- Dumping table b_user
-- -----------------------------------
DROP TABLE IF EXISTS `b_user`;
CREATE TABLE `b_user` (
  `ID` int(18) NOT NULL AUTO_INCREMENT,
  `TIMESTAMP_X` timestamp NULL DEFAULT NULL,
  `LOGIN` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `PASSWORD` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `CHECKWORD` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LAST_NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EMAIL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LAST_LOGIN` datetime DEFAULT NULL,
  `DATE_REGISTER` datetime NOT NULL,
  `LID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_PROFESSION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_WWW` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_ICQ` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_GENDER` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_BIRTHDATE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_PHOTO` int(18) DEFAULT NULL,
  `PERSONAL_PHONE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_FAX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_MOBILE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_PAGER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_STREET` text COLLATE utf8_unicode_ci,
  `PERSONAL_MAILBOX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_CITY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_STATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_ZIP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_COUNTRY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_NOTES` text COLLATE utf8_unicode_ci,
  `WORK_COMPANY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_DEPARTMENT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_POSITION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_WWW` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_PHONE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_FAX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_PAGER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_STREET` text COLLATE utf8_unicode_ci,
  `WORK_MAILBOX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_CITY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_STATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_ZIP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_COUNTRY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_PROFILE` text COLLATE utf8_unicode_ci,
  `WORK_LOGO` int(18) DEFAULT NULL,
  `WORK_NOTES` text COLLATE utf8_unicode_ci,
  `ADMIN_NOTES` text COLLATE utf8_unicode_ci,
  `STORED_HASH` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `XML_ID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERSONAL_BIRTHDAY` date DEFAULT NULL,
  `EXTERNAL_AUTH_ID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CHECKWORD_TIME` datetime DEFAULT NULL,
  `SECOND_NAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONFIRM_CODE` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LOGIN_ATTEMPTS` int(18) DEFAULT NULL,
  `LAST_ACTIVITY_DATE` datetime DEFAULT NULL,
  `AUTO_TIME_ZONE` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TIME_ZONE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TIME_ZONE_OFFSET` int(18) DEFAULT NULL,
  `TITLE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BX_USER_ID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LANGUAGE_ID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BLOCKED` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `PASSWORD_EXPIRED` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`ID`),

(36, NULL, 'EOTechuns', '$6$IjsZ4Xk86tSlTDVa$qx1znMj916jX9gUK4FYmafAAwkS1PZ3ypInhldZjD8Rc8mdS7IS3OlBEXeGSNTwFxJDfYAZaqq524BbOB5Mtx0', '$6$ZvEHDwY3fcqfomki$6LWYgJOCE/uBpBbVGQd2G0Pwuk0Xj3AwSJ4O6CJ1zamLBh8izOwDTT9ChzVqnfTulQRq20x2HQ2gVnWIuHnz5/', 'Y', 'EOTechuns', 'xwusalmetnbeciqGP', '[email protected]', '2020-12-05 15:32:46', '2020-12-05 15:32:46', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-12-05 15:32:46', NULL, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ru', 'N', 'N'),
(37, NULL, 'EOTechwbi', '$6$8fTh9igcGT25wreE$d7saod2c9EkD2OGOAIQQ3YDzL.gHV2gIyXa3dW6efacCYJuxjqeWN.yEF/8fUt12dBRyKsOm6kNLqYo4pTmbS/', '$6$fUr2UAjFqfTVxjn5$AKX1EDGsFsn8vUdIjaERC2HYnfm43ITjNl8/2XJw7ejnij8nWhgaAr0be4wYmscn1uPqkThTTXIc8U8eAil9m.', 'Y', 'EOTechwbi', 'svusaymektnbxqbGP', '[email protected]', '2020-12-05 18:02:05', '2020-12-05 18:02:05', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-12-05 18:02:05', NULL, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ru', 'N', 'N'),
(38, NULL, 'JerryAlten', '$6$Mbegl7dC1eHb2uhn$TiTfz.m0/y.CdtMWlommQGSQdzmSRTNFTiiTeL1WZgMELzIJam.fLnrFcwMhldIrmc5DrB9Far2H78dAKpm6r/', '$6$L6muJYwQ8iKHsqm5$gV65oBJrLyLczc.dGrlMwdJkgCAJTgj.m3eC1DDxKCBSgfFgADpnbh.HmVQ7iLcyyrkZtbT74KucxJ7FoXcYv.', 'Y', 'JerryAlten', 'JerryAltenQR', '[email protected]', '2020-12-05 21:44:55', '2020-12-05 21:44:55', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-12-05 21:44:55', NULL, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ru', 'N', 'N'),
(39, '2021-12-06 02:05:16', 'Tasha', '$6$zjApnG4CCduXMA4T$9UauQylbYZCIOSxcMK/qe4qOP/uoRGMvk6JJwQvasKAwW76Cp6ktJ.cRfF.9HGL9rluRm/Qw9cr9DPBKiEbi9/', '$6$bOp7SRJoMshjZbLn$kUGULaIfb9I8BTSp.WuzB5e/Ci8UxogL2zFOorD43xvQ3e9rmLbQoPFNygffTC.edK/1FkfkLNBNPBjGQ0NlF.', 'Y', 'Наталья', 'Горелова', '[email protected]', '2022-04-12 20:12:47', '2020-12-05 22:52:27', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-06 02:05:16', NULL, '', 0, NULL, NULL, NULL, NULL, NULL, 'e51d8e521ce7e8dbba8a75df9c26faa5', 'ru', 'N', 'N'),
(40, NULL, 'Дмитрий', '$6$qE2D5a313BXowsZM$ct5WnWqTKzkAwqcoRpA8eEy8/R1sFNzc7SXfMa4SlXFBeqWBePqqiWrhxu5UGNiBOwoogbMrxosEsvBYltcVY1', '$6$i0VjWvtPfHUrZ5I3$sht0asOxs3Nc8fGcZIz02EsVF2xwki8N4xM.aUFnyFTEra/vRIYVg88NP1jn8RBqrNZQzCKE82Cyx1eG9C8hr1', 'Y', 'Дмитрий', 'Дмитрий', '[email protected]', '2020-12-06 03:35:14', '2020-12-06 03:35:14', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-12-06 03:35:14', NULL, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ru', 'N', 'N'),