SQL mmdm.ru

[tudos]

sql таблицы юзеров сайта mmdm.ru
дата 08/07/2020 15:27:52

Спойлер: поля

`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`activation_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`persist_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`reset_password_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
`is_activated` tinyint(1) NOT NULL DEFAULT 0,
`activated_at` timestamp NULL DEFAULT NULL,
`last_login` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`surname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`last_seen` timestamp NULL DEFAULT NULL,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`is_superuser` tinyint(1) NOT NULL DEFAULT 0,
`patronymic` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`old_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `users_email_unique`(`email`) USING BTREE,
UNIQUE INDEX `users_login_unique`(`username`) USING BTREE,
INDEX `users_activation_code_index`(`activation_code`) USING BTREE,
INDEX `users_reset_password_code_index`(`reset_password_code`) USING BTREE,
INDEX `users_login_index`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 400889 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = COMPACT;

Спойлер: пример

INSERT INTO `users` VALUES (15, 'Наталья', 'starikova@mmdm.ru', '$S$DtLR4kSgr04bqChRE2DlPwv7e3mJKOC0PRjLeJckKEqC/kglWFWl', NULL, '$S$D/5kiI7Uvj4x3PIyMwVDBCD1N4M8UQCwNOcD9r5WExiFsD92Ik76', NULL, NULL, 1, '2018-11-20 13:12:22', '2020-04-09 13:33:55', '2018-11-20 13:12:22', '2020-04-09 13:33:55', 'starikova@mmdm.ru', 'Старикова', NULL, '2020-07-08 13:24:36', 0, 0, '', '+7(917)513-46-15', '+ 79175134615');
INSERT INTO `users` VALUES (16, 'PASSWORD TEST', 'itsupport@mmdm.ru', '$S$DuVPc01x2PWq8lGkCe5wDccp7QUpmM9tNxhxH1Ck5pmITMZbhQ0e', NULL, '$S$DRCCGGul/wpjc37F.sgb0KyMHe5CT1GxPGcpJHjp/3aHhJtlOTQy', NULL, NULL, 1, '2018-11-03 12:30:22', '2018-11-26 14:50:57', '2018-11-03 12:30:22', '2018-11-26 14:50:57', 'itsupport@mmdm.ru', NULL, NULL, '2018-12-03 11:53:40', 0, 0, NULL, NULL, NULL);
INSERT INTO `users` VALUES (17, 'testtest', 'maizbest@gmail.com', '$2y$10$PEOqhcxVhjYV6CVUIPYchOdDSNeGTOogSIVhf.5BsZgAW4C7wDpDS', NULL, '$S$DT4VKo8Pb.RB9nSZIVGK8U/NgHs2rQDK3fXMvBjYQFSppkj1NTIT', NULL, NULL, 1, '2018-11-21 10:09:58', '2018-11-26 14:19:38', '2018-11-21 10:09:58', '2018-11-26 14:19:38', 'maizbest@gmail.com', NULL, NULL, '2018-11-27 12:54:12', 0, 0, NULL, NULL, NULL);
INSERT INTO `users` VALUES (476, 'filatovat.ne_98320', 'filatovat.ne@mail.ru', '$S$Drm4G6tpBl.WsjX/gqqfrqoyhQyVHM/U91LECtH4p0cpzi902RWy', NULL, NULL, NULL, NULL, 1, NULL, '2018-11-22 00:00:00', '2016-12-06 00:00:00', '2020-04-30 15:09:24', 'filatovat.ne@mail.ru', NULL, NULL, '2018-11-23 00:00:00', 0, 0, NULL, NULL, NULL);
INSERT INTO `users` VALUES (477, 'Anna_moseykina_98321', 'Anna_moseykina@bk.ru', '$S$D9kA9.DbYt8UyhQhAh.XAX/hpkVfcVdoDC8PQ/L/Oii0T2jTo0cu', NULL, NULL, NULL, NULL, 1, NULL, '2016-12-13 00:00:00', '2016-12-06 00:00:00', NULL, NULL, NULL, NULL, '2016-12-15 00:00:00', 0, 0, NULL, NULL, NULL);

mmdm.ru.zip

View and download from Yandex.Disk

yadi.sk