Not a member yet? Why not Sign up today
Create an account  

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
conso.ru

#1

Please login or register to view this content

Reply

#2
(05-05-2024, 10:21 AM)letmein Wrote: conso.ru

format sql
5k users

sample

Code:
INSERT INTO `b_user` (`ID`, `TIMESTAMP_X`, `LOGIN`, `PASSWORD`, `CHECKWORD`, `ACTIVE`, `NAME`, `LAST_NAME`, `EMAIL`, `LAST_LOGIN`, `DATE_REGISTER`, `LID`, `PERSONAL_PROFESSION`, `PERSONAL_WWW`, `PERSONAL_ICQ`, `PERSONAL_GENDER`, `PERSONAL_BIRTHDATE`, `PERSONAL_PHOTO`, `PERSONAL_PHONE`, `PERSONAL_FAX`, `PERSONAL_MOBILE`, `PERSONAL_PAGER`, `PERSONAL_STREET`, `PERSONAL_MAILBOX`, `PERSONAL_CITY`, `PERSONAL_STATE`, `PERSONAL_ZIP`, `PERSONAL_COUNTRY`, `PERSONAL_NOTES`, `WORK_COMPANY`, `WORK_DEPARTMENT`, `WORK_POSITION`, `WORK_WWW`, `WORK_PHONE`, `WORK_FAX`, `WORK_PAGER`, `WORK_STREET`, `WORK_MAILBOX`, `WORK_CITY`, `WORK_STATE`, `WORK_ZIP`, `WORK_COUNTRY`, `WORK_PROFILE`, `WORK_LOGO`, `WORK_NOTES`, `ADMIN_NOTES`, `STORED_HASH`, `XML_ID`, `PERSONAL_BIRTHDAY`, `EXTERNAL_AUTH_ID`, `CHECKWORD_TIME`, `SECOND_NAME`, `CONFIRM_CODE`, `LOGIN_ATTEMPTS`, `LAST_ACTIVITY_DATE`, `AUTO_TIME_ZONE`, `TIME_ZONE`, `TIME_ZONE_OFFSET`, `TITLE`, `BX_USER_ID`, `LANGUAGE_ID`, `BLOCKED`, `PASSWORD_EXPIRED`) VALUES

(1, '2023-09-30 11:24:22', 'admin', '$6$BwtnoNKSqoprohUz$Ri4WRwD8aJFwYtZc98q3EoseT5XisFk1ffjLJttVxOPoBIjdGfgezvlQHSfsz8MzH9WyMVGIiGXc8c2ZyzR3M0', '$6$HYML1ITxUBo7QUcb$vOVp/868Q4g9Ft5ZxDE.GnfWKdu77K2bhQydujRm6OSsMkp8PWDvEtPBLwQgnf0ue.bu1FCO4lv7ltJFRjCag/', 'Y', 'LEX', 'LUTER', 'sd@viteh.ru', '2024-05-04 20:46:53', '2021-07-13 17:48:16', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '1#admin#LUTER LEX ', NULL, NULL, '2023-10-30 16:15:11', '', NULL, 0, '2024-05-02 18:16:02', '', NULL, NULL, '', 'e7f5423b46502427699cc243562d729d', 'ru', 'N', 'N'),
(2, '2022-08-22 13:46:19', 'anonymous_9GL8GBNEh', '$6$WDxOo3cCCnlyfHXg$0PuQ.mU4trRq0d1bFHGK0qz09/2.g9VWCvVn94hIeORMtjDhBeOsfE8WUGOVjg0PSd2qml4eTTMFLphIJa/mM0', '$6$6M0v4SHrCIWgzd9f$tQa/HofITPFrBY7KzDz2aglNHcCshv4NKspK.NSJeLmdoIYrQpAa7ao0e/xQ.SD33POMEDqPWNiK6M3XXJmcQ.', 'N', 'Анонимный пользователь', NULL, 'anonymous_9GL8GBNEh@example.com', NULL, '2021-07-14 20:42: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, 'saleanonymous', '2021-07-14 20:42:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N'),
(3, '2022-09-05 17:23:41', 'Administrator', '$6$POSCZapLye4YE5CC$lABOc1FqSZO.DtTXuLMivbyBNFKzKwb5d73LKuYoAFvJ21p8z82BRm1hUZKBd2qaDPKKhwPW//5.pvl/KRApU/', '$6$belFa5Ue3oxUSnG0$wv2B0tqQjLsMQwCU8LryClucsFlpTSeZoY43LSQJPp33SAyEYn8W753l7m8iRDJ6tipwbDOiFBr0S32x3vz6p.', 'Y', '', '', 'qs@viteh.ru', '2022-10-14 11:08:25', '2021-07-20 08:44:41', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '', NULL, NULL, '2022-09-05 17:23:41', '', NULL, 542, NULL, '', NULL, NULL, '', '5a8cbac7527a98cdc0afd116a88e2c98', '', 'N', 'N'),
(4, '2022-09-02 12:17:34', 'tele', '$6$1GbvDtSf71TOZcax$Jc5TBH8b/sEilFJPgeFZ8uo8I8LwP.eL/zuPegq.zs7V5mExUxCeClqErnS5y9QOOGxfalcmK.KmbSkWLjYtV0', '$6$RwEPMuVK0V2PnP5s$NTvBNGruZ2jt5wKsoHlAcbqbT8BiiVW0Yv4yQ.ZkFK.tNDq3WJV3jclsND28xoKQdBrog01WzxleHm8N9Q8Yt.', 'Y', 'Иван', 'Иванов', 'tele@live.ru', '2021-07-20 09:18:31', '2021-07-20 09:18:31', '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, '4#tele#Иванов Иван ', NULL, NULL, '2021-07-20 09:18:31', NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, '29d847bd375dbf799e5b2ab01cb5b657', NULL, 'N', 'N'),
(5, '2022-09-02 12:17:34', '1306614', '$6$KktEDZB1hlGQwDy9$ri0W7GBKwsy/4jNMRIWrF/z23KUKXpivas5StzdIuFokdXvtQh7Oi.zpCifnob5zLLJduWrgvLZh46Nbzlpwf/', '$6$WRT1pTHL9EI197fR$8dUHbzv6JEw57mIKk2bxg69XfEP5T3eBwmSERvtB3MPx/byjGA3OYy5orIYw6dwvBchYgrfAKsbPIVFu1DbRz0', 'Y', 'Ноавак', '', '1306614@mail.ru', '2021-07-20 10:15:41', '2021-07-20 10:15:41', '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, '5#1306614# Ноавак ', NULL, NULL, '2021-07-20 10:15:41', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '7cf0f7319c67ef2b5cf8236732317dc6', NULL, 'N', 'N'),
(6, '2022-08-22 13:46:19', 'alexx8408@gmail.com', '$6$p1QlAgky69nv3FmP$jQAyWIVjKPQ9ZR7nwZFhtZbtoNq02fGNkV/0MuSXEmFZO/7K4T2CI97dyRVL/AhqXEtEB5urmt1uB3C/VC6va.', '$6$yacKqlMQxVJYqM2m$r117cUIuxDLwNwUw0299DjWZWI9OhkLnzA5PUzJrDzDdT7nYxZETTuxylx68R1H5hVUPL4NVnozwvB.taja.D/', 'Y', '', '', 'alexx8408@gmail.com', '2021-10-06 04:59:22', '2021-08-18 18:26:19', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', NULL, '', '', NULL, '', NULL, NULL, '2021-08-18 18:26:19', '', NULL, 0, NULL, '', NULL, NULL, '', '19aa9b4ed176e795f4445cb7f391d54f', '', 'N', 'N'),
(7, '2022-09-02 12:17:34', 'lev', '$6$UG3hAYO7MNOiShMB$wzfMdmH6VzfVbsYI4T/JRMwKgwtBCiuu5VDdlDs4jIz2sY3pMs23gOSOXW5uEqM/fMQ5TrzbgqNoueb.NvQvY1', '$6$JTkTYFkJN14RjMzA$wPUFD1QtN30gS6y87xsklPRdJZw/NHjAMPPpLttezYLj3WonAD5tR4OvMhI7P7CJkkKM9e3EwKsdcU5SUzx7G.', 'Y', 'тестик', '', 'lev@viteh.ru', '2021-08-19 20:21:50', '2021-08-19 20:21:50', '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, '7#lev# тестик ', NULL, NULL, '2021-08-19 20:21:50', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '6d6a76c5ca651cf674092d820759acc5', NULL, 'N', 'N'),
(8, '2022-09-02 12:17:34', '130661472429', '$6$D6HpFAZmlBEN0Ou8$5cd1kQpibpOmiQG2goZy3A.Igl2cCmHRyyOmgGt0mRWJKGvhUWNajfPX38WNDgE6EKcNwftM7TfPBXhwUp6iC/', '$6$gtdDcRhxu7UxjfWs$ivJpEWkVrIwdJNtVL7a2OmF22hfWVYPgceKIdHFn3kiVfNiLkMzZT27uitUAtpH9amhHrwDC2mt9mfWiO2Urx/', 'Y', 'fffffffffffffffffff', '', '1306614@mail.ru', '2021-08-31 10:39:20', '2021-08-31 10:39:20', '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, '8#130661472429# fffffffffffffffffff ', NULL, NULL, '2021-08-31 10:39:20', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
(9, '2022-09-02 12:17:34', '130661460747', '$6$whsa0hokNCDjDYyU$KcSNGnaaIG1gLLDKO5SECXkdkEmPg4.OJ8/F7r0RBuU.2WitlXtIeNzn7pia..C4H5aweiH7rZROfTSUvRuoU.', '$6$e51GwlDJ962yqjb5$DwQnDqM05zUqA3wJsZklxOHpVTDyyD5EMnk.HwsxyWQ5gtBRZBs/k5DrVVumUIA1Aqo9hop7qfmJuILN9bKiW1', 'Y', 'Hjd', '', '1306614@mail.ru', '2021-09-05 10:28:24', '2021-09-05 10:28:24', '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, '9#130661460747# Hjd ', NULL, NULL, '2021-09-05 10:28:24', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
Reply

#3
(05-05-2024, 10:21 AM)letmein Wrote: conso.ru

format sql
5k users

sample

Code:
INSERT INTO `b_user` (`ID`, `TIMESTAMP_X`, `LOGIN`, `PASSWORD`, `CHECKWORD`, `ACTIVE`, `NAME`, `LAST_NAME`, `EMAIL`, `LAST_LOGIN`, `DATE_REGISTER`, `LID`, `PERSONAL_PROFESSION`, `PERSONAL_WWW`, `PERSONAL_ICQ`, `PERSONAL_GENDER`, `PERSONAL_BIRTHDATE`, `PERSONAL_PHOTO`, `PERSONAL_PHONE`, `PERSONAL_FAX`, `PERSONAL_MOBILE`, `PERSONAL_PAGER`, `PERSONAL_STREET`, `PERSONAL_MAILBOX`, `PERSONAL_CITY`, `PERSONAL_STATE`, `PERSONAL_ZIP`, `PERSONAL_COUNTRY`, `PERSONAL_NOTES`, `WORK_COMPANY`, `WORK_DEPARTMENT`, `WORK_POSITION`, `WORK_WWW`, `WORK_PHONE`, `WORK_FAX`, `WORK_PAGER`, `WORK_STREET`, `WORK_MAILBOX`, `WORK_CITY`, `WORK_STATE`, `WORK_ZIP`, `WORK_COUNTRY`, `WORK_PROFILE`, `WORK_LOGO`, `WORK_NOTES`, `ADMIN_NOTES`, `STORED_HASH`, `XML_ID`, `PERSONAL_BIRTHDAY`, `EXTERNAL_AUTH_ID`, `CHECKWORD_TIME`, `SECOND_NAME`, `CONFIRM_CODE`, `LOGIN_ATTEMPTS`, `LAST_ACTIVITY_DATE`, `AUTO_TIME_ZONE`, `TIME_ZONE`, `TIME_ZONE_OFFSET`, `TITLE`, `BX_USER_ID`, `LANGUAGE_ID`, `BLOCKED`, `PASSWORD_EXPIRED`) VALUES

(1, '2023-09-30 11:24:22', 'admin', '$6$BwtnoNKSqoprohUz$Ri4WRwD8aJFwYtZc98q3EoseT5XisFk1ffjLJttVxOPoBIjdGfgezvlQHSfsz8MzH9WyMVGIiGXc8c2ZyzR3M0', '$6$HYML1ITxUBo7QUcb$vOVp/868Q4g9Ft5ZxDE.GnfWKdu77K2bhQydujRm6OSsMkp8PWDvEtPBLwQgnf0ue.bu1FCO4lv7ltJFRjCag/', 'Y', 'LEX', 'LUTER', 'sd@viteh.ru', '2024-05-04 20:46:53', '2021-07-13 17:48:16', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '1#admin#LUTER LEX ', NULL, NULL, '2023-10-30 16:15:11', '', NULL, 0, '2024-05-02 18:16:02', '', NULL, NULL, '', 'e7f5423b46502427699cc243562d729d', 'ru', 'N', 'N'),
(2, '2022-08-22 13:46:19', 'anonymous_9GL8GBNEh', '$6$WDxOo3cCCnlyfHXg$0PuQ.mU4trRq0d1bFHGK0qz09/2.g9VWCvVn94hIeORMtjDhBeOsfE8WUGOVjg0PSd2qml4eTTMFLphIJa/mM0', '$6$6M0v4SHrCIWgzd9f$tQa/HofITPFrBY7KzDz2aglNHcCshv4NKspK.NSJeLmdoIYrQpAa7ao0e/xQ.SD33POMEDqPWNiK6M3XXJmcQ.', 'N', 'Анонимный пользователь', NULL, 'anonymous_9GL8GBNEh@example.com', NULL, '2021-07-14 20:42: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, 'saleanonymous', '2021-07-14 20:42:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N'),
(3, '2022-09-05 17:23:41', 'Administrator', '$6$POSCZapLye4YE5CC$lABOc1FqSZO.DtTXuLMivbyBNFKzKwb5d73LKuYoAFvJ21p8z82BRm1hUZKBd2qaDPKKhwPW//5.pvl/KRApU/', '$6$belFa5Ue3oxUSnG0$wv2B0tqQjLsMQwCU8LryClucsFlpTSeZoY43LSQJPp33SAyEYn8W753l7m8iRDJ6tipwbDOiFBr0S32x3vz6p.', 'Y', '', '', 'qs@viteh.ru', '2022-10-14 11:08:25', '2021-07-20 08:44:41', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '', NULL, NULL, '2022-09-05 17:23:41', '', NULL, 542, NULL, '', NULL, NULL, '', '5a8cbac7527a98cdc0afd116a88e2c98', '', 'N', 'N'),
(4, '2022-09-02 12:17:34', 'tele', '$6$1GbvDtSf71TOZcax$Jc5TBH8b/sEilFJPgeFZ8uo8I8LwP.eL/zuPegq.zs7V5mExUxCeClqErnS5y9QOOGxfalcmK.KmbSkWLjYtV0', '$6$RwEPMuVK0V2PnP5s$NTvBNGruZ2jt5wKsoHlAcbqbT8BiiVW0Yv4yQ.ZkFK.tNDq3WJV3jclsND28xoKQdBrog01WzxleHm8N9Q8Yt.', 'Y', 'Иван', 'Иванов', 'tele@live.ru', '2021-07-20 09:18:31', '2021-07-20 09:18:31', '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, '4#tele#Иванов Иван ', NULL, NULL, '2021-07-20 09:18:31', NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, '29d847bd375dbf799e5b2ab01cb5b657', NULL, 'N', 'N'),
(5, '2022-09-02 12:17:34', '1306614', '$6$KktEDZB1hlGQwDy9$ri0W7GBKwsy/4jNMRIWrF/z23KUKXpivas5StzdIuFokdXvtQh7Oi.zpCifnob5zLLJduWrgvLZh46Nbzlpwf/', '$6$WRT1pTHL9EI197fR$8dUHbzv6JEw57mIKk2bxg69XfEP5T3eBwmSERvtB3MPx/byjGA3OYy5orIYw6dwvBchYgrfAKsbPIVFu1DbRz0', 'Y', 'Ноавак', '', '1306614@mail.ru', '2021-07-20 10:15:41', '2021-07-20 10:15:41', '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, '5#1306614# Ноавак ', NULL, NULL, '2021-07-20 10:15:41', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '7cf0f7319c67ef2b5cf8236732317dc6', NULL, 'N', 'N'),
(6, '2022-08-22 13:46:19', 'alexx8408@gmail.com', '$6$p1QlAgky69nv3FmP$jQAyWIVjKPQ9ZR7nwZFhtZbtoNq02fGNkV/0MuSXEmFZO/7K4T2CI97dyRVL/AhqXEtEB5urmt1uB3C/VC6va.', '$6$yacKqlMQxVJYqM2m$r117cUIuxDLwNwUw0299DjWZWI9OhkLnzA5PUzJrDzDdT7nYxZETTuxylx68R1H5hVUPL4NVnozwvB.taja.D/', 'Y', '', '', 'alexx8408@gmail.com', '2021-10-06 04:59:22', '2021-08-18 18:26:19', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', NULL, '', '', NULL, '', NULL, NULL, '2021-08-18 18:26:19', '', NULL, 0, NULL, '', NULL, NULL, '', '19aa9b4ed176e795f4445cb7f391d54f', '', 'N', 'N'),
(7, '2022-09-02 12:17:34', 'lev', '$6$UG3hAYO7MNOiShMB$wzfMdmH6VzfVbsYI4T/JRMwKgwtBCiuu5VDdlDs4jIz2sY3pMs23gOSOXW5uEqM/fMQ5TrzbgqNoueb.NvQvY1', '$6$JTkTYFkJN14RjMzA$wPUFD1QtN30gS6y87xsklPRdJZw/NHjAMPPpLttezYLj3WonAD5tR4OvMhI7P7CJkkKM9e3EwKsdcU5SUzx7G.', 'Y', 'тестик', '', 'lev@viteh.ru', '2021-08-19 20:21:50', '2021-08-19 20:21:50', '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, '7#lev# тестик ', NULL, NULL, '2021-08-19 20:21:50', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '6d6a76c5ca651cf674092d820759acc5', NULL, 'N', 'N'),
(8, '2022-09-02 12:17:34', '130661472429', '$6$D6HpFAZmlBEN0Ou8$5cd1kQpibpOmiQG2goZy3A.Igl2cCmHRyyOmgGt0mRWJKGvhUWNajfPX38WNDgE6EKcNwftM7TfPBXhwUp6iC/', '$6$gtdDcRhxu7UxjfWs$ivJpEWkVrIwdJNtVL7a2OmF22hfWVYPgceKIdHFn3kiVfNiLkMzZT27uitUAtpH9amhHrwDC2mt9mfWiO2Urx/', 'Y', 'fffffffffffffffffff', '', '1306614@mail.ru', '2021-08-31 10:39:20', '2021-08-31 10:39:20', '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, '8#130661472429# fffffffffffffffffff ', NULL, NULL, '2021-08-31 10:39:20', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
(9, '2022-09-02 12:17:34', '130661460747', '$6$whsa0hokNCDjDYyU$KcSNGnaaIG1gLLDKO5SECXkdkEmPg4.OJ8/F7r0RBuU.2WitlXtIeNzn7pia..C4H5aweiH7rZROfTSUvRuoU.', '$6$e51GwlDJ962yqjb5$DwQnDqM05zUqA3wJsZklxOHpVTDyyD5EMnk.HwsxyWQ5gtBRZBs/k5DrVVumUIA1Aqo9hop7qfmJuILN9bKiW1', 'Y', 'Hjd', '', '1306614@mail.ru', '2021-09-05 10:28:24', '2021-09-05 10:28:24', '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, '9#130661460747# Hjd ', NULL, NULL, '2021-09-05 10:28:24', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
Reply

#4
(05-05-2024, 10:21 AM)letmein Wrote: conso.ru

format sql
5k users

sample

Code:
INSERT INTO `b_user` (`ID`, `TIMESTAMP_X`, `LOGIN`, `PASSWORD`, `CHECKWORD`, `ACTIVE`, `NAME`, `LAST_NAME`, `EMAIL`, `LAST_LOGIN`, `DATE_REGISTER`, `LID`, `PERSONAL_PROFESSION`, `PERSONAL_WWW`, `PERSONAL_ICQ`, `PERSONAL_GENDER`, `PERSONAL_BIRTHDATE`, `PERSONAL_PHOTO`, `PERSONAL_PHONE`, `PERSONAL_FAX`, `PERSONAL_MOBILE`, `PERSONAL_PAGER`, `PERSONAL_STREET`, `PERSONAL_MAILBOX`, `PERSONAL_CITY`, `PERSONAL_STATE`, `PERSONAL_ZIP`, `PERSONAL_COUNTRY`, `PERSONAL_NOTES`, `WORK_COMPANY`, `WORK_DEPARTMENT`, `WORK_POSITION`, `WORK_WWW`, `WORK_PHONE`, `WORK_FAX`, `WORK_PAGER`, `WORK_STREET`, `WORK_MAILBOX`, `WORK_CITY`, `WORK_STATE`, `WORK_ZIP`, `WORK_COUNTRY`, `WORK_PROFILE`, `WORK_LOGO`, `WORK_NOTES`, `ADMIN_NOTES`, `STORED_HASH`, `XML_ID`, `PERSONAL_BIRTHDAY`, `EXTERNAL_AUTH_ID`, `CHECKWORD_TIME`, `SECOND_NAME`, `CONFIRM_CODE`, `LOGIN_ATTEMPTS`, `LAST_ACTIVITY_DATE`, `AUTO_TIME_ZONE`, `TIME_ZONE`, `TIME_ZONE_OFFSET`, `TITLE`, `BX_USER_ID`, `LANGUAGE_ID`, `BLOCKED`, `PASSWORD_EXPIRED`) VALUES

(1, '2023-09-30 11:24:22', 'admin', '$6$BwtnoNKSqoprohUz$Ri4WRwD8aJFwYtZc98q3EoseT5XisFk1ffjLJttVxOPoBIjdGfgezvlQHSfsz8MzH9WyMVGIiGXc8c2ZyzR3M0', '$6$HYML1ITxUBo7QUcb$vOVp/868Q4g9Ft5ZxDE.GnfWKdu77K2bhQydujRm6OSsMkp8PWDvEtPBLwQgnf0ue.bu1FCO4lv7ltJFRjCag/', 'Y', 'LEX', 'LUTER', 'sd@viteh.ru', '2024-05-04 20:46:53', '2021-07-13 17:48:16', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '1#admin#LUTER LEX ', NULL, NULL, '2023-10-30 16:15:11', '', NULL, 0, '2024-05-02 18:16:02', '', NULL, NULL, '', 'e7f5423b46502427699cc243562d729d', 'ru', 'N', 'N'),
(2, '2022-08-22 13:46:19', 'anonymous_9GL8GBNEh', '$6$WDxOo3cCCnlyfHXg$0PuQ.mU4trRq0d1bFHGK0qz09/2.g9VWCvVn94hIeORMtjDhBeOsfE8WUGOVjg0PSd2qml4eTTMFLphIJa/mM0', '$6$6M0v4SHrCIWgzd9f$tQa/HofITPFrBY7KzDz2aglNHcCshv4NKspK.NSJeLmdoIYrQpAa7ao0e/xQ.SD33POMEDqPWNiK6M3XXJmcQ.', 'N', 'Анонимный пользователь', NULL, 'anonymous_9GL8GBNEh@example.com', NULL, '2021-07-14 20:42: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, 'saleanonymous', '2021-07-14 20:42:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'N'),
(3, '2022-09-05 17:23:41', 'Administrator', '$6$POSCZapLye4YE5CC$lABOc1FqSZO.DtTXuLMivbyBNFKzKwb5d73LKuYoAFvJ21p8z82BRm1hUZKBd2qaDPKKhwPW//5.pvl/KRApU/', '$6$belFa5Ue3oxUSnG0$wv2B0tqQjLsMQwCU8LryClucsFlpTSeZoY43LSQJPp33SAyEYn8W753l7m8iRDJ6tipwbDOiFBr0S32x3vz6p.', 'Y', '', '', 'qs@viteh.ru', '2022-10-14 11:08:25', '2021-07-20 08:44:41', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '', NULL, NULL, '2022-09-05 17:23:41', '', NULL, 542, NULL, '', NULL, NULL, '', '5a8cbac7527a98cdc0afd116a88e2c98', '', 'N', 'N'),
(4, '2022-09-02 12:17:34', 'tele', '$6$1GbvDtSf71TOZcax$Jc5TBH8b/sEilFJPgeFZ8uo8I8LwP.eL/zuPegq.zs7V5mExUxCeClqErnS5y9QOOGxfalcmK.KmbSkWLjYtV0', '$6$RwEPMuVK0V2PnP5s$NTvBNGruZ2jt5wKsoHlAcbqbT8BiiVW0Yv4yQ.ZkFK.tNDq3WJV3jclsND28xoKQdBrog01WzxleHm8N9Q8Yt.', 'Y', 'Иван', 'Иванов', 'tele@live.ru', '2021-07-20 09:18:31', '2021-07-20 09:18:31', '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, '4#tele#Иванов Иван ', NULL, NULL, '2021-07-20 09:18:31', NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, '29d847bd375dbf799e5b2ab01cb5b657', NULL, 'N', 'N'),
(5, '2022-09-02 12:17:34', '1306614', '$6$KktEDZB1hlGQwDy9$ri0W7GBKwsy/4jNMRIWrF/z23KUKXpivas5StzdIuFokdXvtQh7Oi.zpCifnob5zLLJduWrgvLZh46Nbzlpwf/', '$6$WRT1pTHL9EI197fR$8dUHbzv6JEw57mIKk2bxg69XfEP5T3eBwmSERvtB3MPx/byjGA3OYy5orIYw6dwvBchYgrfAKsbPIVFu1DbRz0', 'Y', 'Ноавак', '', '1306614@mail.ru', '2021-07-20 10:15:41', '2021-07-20 10:15:41', '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, '5#1306614# Ноавак ', NULL, NULL, '2021-07-20 10:15:41', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '7cf0f7319c67ef2b5cf8236732317dc6', NULL, 'N', 'N'),
(6, '2022-08-22 13:46:19', 'alexx8408@gmail.com', '$6$p1QlAgky69nv3FmP$jQAyWIVjKPQ9ZR7nwZFhtZbtoNq02fGNkV/0MuSXEmFZO/7K4T2CI97dyRVL/AhqXEtEB5urmt1uB3C/VC6va.', '$6$yacKqlMQxVJYqM2m$r117cUIuxDLwNwUw0299DjWZWI9OhkLnzA5PUzJrDzDdT7nYxZETTuxylx68R1H5hVUPL4NVnozwvB.taja.D/', 'Y', '', '', 'alexx8408@gmail.com', '2021-10-06 04:59:22', '2021-08-18 18:26:19', 's1', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', NULL, '', '', NULL, '', NULL, NULL, '2021-08-18 18:26:19', '', NULL, 0, NULL, '', NULL, NULL, '', '19aa9b4ed176e795f4445cb7f391d54f', '', 'N', 'N'),
(7, '2022-09-02 12:17:34', 'lev', '$6$UG3hAYO7MNOiShMB$wzfMdmH6VzfVbsYI4T/JRMwKgwtBCiuu5VDdlDs4jIz2sY3pMs23gOSOXW5uEqM/fMQ5TrzbgqNoueb.NvQvY1', '$6$JTkTYFkJN14RjMzA$wPUFD1QtN30gS6y87xsklPRdJZw/NHjAMPPpLttezYLj3WonAD5tR4OvMhI7P7CJkkKM9e3EwKsdcU5SUzx7G.', 'Y', 'тестик', '', 'lev@viteh.ru', '2021-08-19 20:21:50', '2021-08-19 20:21:50', '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, '7#lev# тестик ', NULL, NULL, '2021-08-19 20:21:50', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '6d6a76c5ca651cf674092d820759acc5', NULL, 'N', 'N'),
(8, '2022-09-02 12:17:34', '130661472429', '$6$D6HpFAZmlBEN0Ou8$5cd1kQpibpOmiQG2goZy3A.Igl2cCmHRyyOmgGt0mRWJKGvhUWNajfPX38WNDgE6EKcNwftM7TfPBXhwUp6iC/', '$6$gtdDcRhxu7UxjfWs$ivJpEWkVrIwdJNtVL7a2OmF22hfWVYPgceKIdHFn3kiVfNiLkMzZT27uitUAtpH9amhHrwDC2mt9mfWiO2Urx/', 'Y', 'fffffffffffffffffff', '', '1306614@mail.ru', '2021-08-31 10:39:20', '2021-08-31 10:39:20', '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, '8#130661472429# fffffffffffffffffff ', NULL, NULL, '2021-08-31 10:39:20', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
(9, '2022-09-02 12:17:34', '130661460747', '$6$whsa0hokNCDjDYyU$KcSNGnaaIG1gLLDKO5SECXkdkEmPg4.OJ8/F7r0RBuU.2WitlXtIeNzn7pia..C4H5aweiH7rZROfTSUvRuoU.', '$6$e51GwlDJ962yqjb5$DwQnDqM05zUqA3wJsZklxOHpVTDyyD5EMnk.HwsxyWQ5gtBRZBs/k5DrVVumUIA1Aqo9hop7qfmJuILN9bKiW1', 'Y', 'Hjd', '', '1306614@mail.ru', '2021-09-05 10:28:24', '2021-09-05 10:28:24', '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, '9#130661460747# Hjd ', NULL, NULL, '2021-09-05 10:28:24', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '281b7201d44251db16f7ffabeb04ab96', NULL, 'N', 'N'),
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)