• XSS.stack #1 – первый литературный журнал от юзеров форума

SQL hospitalityjobs.com FULL 2020-10

Отслеживать

rx26386

(L3) cache
Пользователь
Регистрация
21.05.2019
Сообщения
205
Реакции
762
Код: 
2020-10-07 01:35        Folder  hospilatiydbs
2020-10-06 21:36            57  hospilatiydbs\aliases-blog.hospitalityjobs.com.gz
2020-10-06 21:37            55  hospilatiydbs\aliases-consultancyforsale (1).com.gz
2020-10-06 21:36            55  hospilatiydbs\aliases-consultancyforsale.com.gz
2020-10-06 21:37            71  hospilatiydbs\aliases-consultancyforsale.hospitalityjobs (1).com.gz
2020-10-06 21:37            71  hospilatiydbs\aliases-consultancyforsale.hospitalityjobs (2).com.gz
2020-10-06 21:37            71  hospilatiydbs\aliases-consultancyforsale.hospitalityjobs.com.gz
2020-10-06 21:37            54  hospilatiydbs\aliases-floridalawyerhelp (1).com.gz
2020-10-06 21:37            54  hospilatiydbs\aliases-floridalawyerhelp.com.gz
2020-10-06 21:37            70  hospilatiydbs\aliases-floridalawyerhelp.hospitalityjobs.com.gz
2020-10-06 21:37            51  hospilatiydbs\aliases-globalsofttech.net.gz
2020-10-06 21:37            51  hospilatiydbs\aliases-globalsoftware.net.gz
2020-10-06 21:36           154  hospilatiydbs\aliases-hospitalityjobs.com.gz
2020-10-06 21:37            49  hospilatiydbs\aliases-quantilusinc.com.gz
2020-10-06 21:37            65  hospilatiydbs\aliases-quantilusinc.hospitalityjobs.com.gz
2020-10-07 01:31    3798231707  hospilatiydbs\backup-10.6.2020_10-19-03_hospitr3 (1).tar.gz
2020-10-06 21:23            13  hospilatiydbs\backup-10.6.2020_10-19-03_hospitr3.tar.gz
2020-10-06 20:21    3636435053  hospilatiydbs\hospitalityjobs.combackup-2020.10.03_00-00-00_hospitr3.tar.gz
2020-10-06 21:25      60278822  hospilatiydbs\hospitr3_hospitalityjobs.sql.gz
2020-10-06 21:25           367  hospilatiydbs\hospitr3_hospitalityjobs_corrupted (1).sql.gz
2020-10-06 21:24           367  hospilatiydbs\hospitr3_hospitalityjobs_corrupted.sql.gz
2020-10-06 21:25      17689761  hospilatiydbs\hospitr3_hospitalityjobs_qa_14092019.sql.gz
2020-10-06 21:31      19561562  hospilatiydbs\hospitr3_qa1_14092019.sql.gz
2020-10-06 21:33      13163465  hospilatiydbs\hospitr3_qa3.sql.gz
2020-10-06 21:34      15562605  hospilatiydbs\hospitr3_qa4.sql.gz
2020-10-06 21:36      10110463  hospilatiydbs\hospitr3_qa_14092019.sql.gz
2020-10-06 21:36       6441037  hospilatiydbs\hospitr3_vbulletin.sql.gz
2020-10-06 21:36        118432  hospilatiydbs\hospitr3_wrdp1.sql.gz
 
в "hospitr3_hospitalityjobs.sql"

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`user_group_sid` int(10) unsigned DEFAULT NULL,
`registration_date` datetime DEFAULT NULL,
`active` int(1) unsigned DEFAULT '0',
`verification_key` varchar(255) DEFAULT NULL,
`featured` tinyint(4) NOT NULL DEFAULT '0',
`ip` varchar(15) DEFAULT NULL,
`reference_uid` varchar(255) DEFAULT NULL,
`Location_Country` text,
`Location_State` text,
`Location_City` varchar(255) DEFAULT NULL,
`CompanyName` varchar(255) DEFAULT NULL,
`FullName` varchar(255) DEFAULT NULL,
`WebSite` varchar(255) DEFAULT NULL,
`CompanyDescription` longtext,
`Logo` varchar(255) DEFAULT NULL,
`trial` text,
`Location_ZipCode` varchar(255) DEFAULT NULL,
`Location_Latitude` double DEFAULT NULL,
`Location_Longitude` double DEFAULT NULL,
`GooglePlace` varchar(255) DEFAULT NULL,
`Location` text,
`extUserID` varchar(255) DEFAULT NULL,
`Phone` varchar(255) DEFAULT NULL,
`referral_code` varchar(255) DEFAULT NULL,
`giftcard_enable` tinyint(1) DEFAULT '0',
`blog_subscription` tinyint(1) DEFAULT '0',
`passcode` varchar(255) NOT NULL,
PRIMARY KEY (`sid`),
UNIQUE KEY `username` (`username`),
KEY `email` (`email`),
KEY `user_group_sid` (`user_group_sid`),
KEY `active` (`active`),
KEY `featured` (`featured`),
KEY `password` (`password`),
KEY `registration_date` (`registration_date`),
KEY `verification_key` (`verification_key`),
KEY `ip` (`ip`),
KEY `reference_uid` (`reference_uid`),
KEY `extUserID` (`extUserID`),
KEY `CompanyName` (`CompanyName`),
KEY `FullName` (`FullName`),
KEY `Location_Latitude` (`Location_Latitude`),
KEY `Location_Longitude` (`Location_Longitude`),
KEY `GooglePlace` (`GooglePlace`),
FULLTEXT KEY `GooglePlaceF` (`GooglePlace`)
) ENGINE=MyISAM AUTO_INCREMENT=85235 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

(3997,'jobg8_St._Mary_s_Medical_Center_Home_Health_Services,_LLC','0791305b6f46be56f7c8dabbe06dfb1f','jobg8_St._Mary_s_Medical_Center_Home_Health_Services,_LLC',41,'2017-09-10 11:25:43',1,'nobuse5y7i8kglj2drwczpt1x34fhvq0m9a6',0,NULL,NULL,'','','','St. Mary\'s Medical Center Home Health Services, LLC','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(3998,'jobg8_Onion_River_Cooperative','899c56aa57989b8829c80bbf966dd3db','jobg8_Onion_River_Cooperative',41,'2017-09-10 11:25:47',1,'7y85ts3gvdibnhwl46zopeq1rjak2m90cxfu',0,NULL,NULL,'','','','Onion River Cooperative','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(3999,'jobg8_Cheetah_Ad_Platform','37120123a487fcd878f0096e31fcb84f','jobg8_Cheetah_Ad_Platform',41,'2017-09-10 11:26:16',1,'a2znumcw3eox80ldjhvk76p49i5q1ytrgfsb',0,NULL,NULL,'','','','Cheetah Ad Platform','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4000,'jobg8_Crisp_Regional_Hospital','d89b1ed02539caeb8cbde49ce728377a','jobg8_Crisp_Regional_Hospital',41,'2017-09-10 11:26:20',1,'4odlatv536qfeh0gwkuy1br9ciz2s7xmj8np',0,NULL,NULL,'','','','Crisp Regional Hospital','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4001,'jobg8_Tesla_Motors','f9d361d5cc5ce497df6c1869286f2507','jobg8_Tesla_Motors',41,'2017-09-10 11:26:24',1,'vy3n5uf6imhzole74p20a9qrkcjbgsxw8d1t',0,NULL,NULL,'','','','Tesla Motors','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4002,'jobg8_Mammoth','f0ecadf7bd19d55ed082cf51f9aef16d','jobg8_Mammoth',41,'2017-09-10 11:29:32',1,'ck9172yw6fspqglo8hbex3zvajd0itu4rn5m',0,NULL,NULL,'','','','Mammoth','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4003,'jobg8_Mediterranean_Exploration_Company','dd6726a532ce0484eb8b6038582312b9','jobg8_Mediterranean_Exploration_Company',41,'2017-09-10 11:29:32',1,'nagq2ipsdwvjrkzcmb01u587oxfey394tl6h',0,NULL,NULL,'','','','Mediterranean Exploration Company','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4004,'jobg8_New_Luck_Toy','6612e2bff485cae202b08237300d88ca','jobg8_New_Luck_Toy',41,'2017-09-10 11:29:32',1,'wsxbltgi52ankjz0y9pq87rueo46h1d3cvmf',0,NULL,NULL,'','','','New Luck Toy','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4005,'jobg8_Poached','35b6aa0db7518ff8f9c757ba7acb4a0f','jobg8_Poached',41,'2017-09-10 11:29:32',1,'hojmvs4r673fb1zge8dyli02kn9cu5pxawtq',0,NULL,NULL,'','','','Poached','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4006,'jobg8_Burgerville','ff89bf3a2171c880a2ee7ac3e7c293e1','jobg8_Burgerville',41,'2017-09-10 11:29:33',1,'z5xw2udcl1br6kgpnyqhej8a4vt09fmios37',0,NULL,NULL,'','','','Burgerville','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4007,'jobg8_Clementine','1413e844f40796fd0abcc707bb238b5e','jobg8_Clementine',41,'2017-09-10 11:29:33',1,'xznbvrh6d08i2c9tk71e5gqj3yfamospw4ul',0,NULL,NULL,'','','','Clementine','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4008,'jobg8_Bodega_Wine_Bar','51e964d21ea0d5a154c6ebbd1d045d60','jobg8_Bodega_Wine_Bar',41,'2017-09-10 11:29:36',1,'a4qnye2wo10i8d3fh6j7xmlcbu9kzrpgt5vs',0,NULL,NULL,'','','','Bodega Wine Bar','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4009,'jobg8_Giggles_N__Hugs','d8e49d97db3b2396dcf2598a04fd2cdd','jobg8_Giggles_N__Hugs',41,'2017-09-10 11:29:36',1,'5p4nc3imxqlyv2o68dzwg7a9s0rjfkhu1etb',0,NULL,NULL,'','','','Giggles N\' Hugs','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4010,'jobg8_Cafe_Gratitude_Arts_District','32cd525b8aadcf6bb6ac76bec8a3ec8c','jobg8_Cafe_Gratitude_Arts_District',41,'2017-09-10 11:29:37',1,'dg4a10si72lq8uxftbz5pvrjye39h6ocknmw',0,NULL,NULL,'','','','Cafe Gratitude Arts District','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4011,'jobg8_Patricia_Perez','f00b109617db2ddf57c8bb058325f27a','jobg8_Patricia_Perez',41,'2017-09-10 11:29:37',1,'u7gwnr40yhv9kboc3s2t8dimxe16qflp5jza',0,NULL,NULL,'','','','Patricia Perez','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4012,'jobg8_Dialog_Cafe','707558efb177302e425346dcfc5a0e9a','jobg8_Dialog_Cafe',41,'2017-09-10 11:29:38',1,'fnxulz20aewjp38cst16qohy95kvimrd7bg4',0,NULL,NULL,'','','','Dialog Cafe','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4013,'jobg8_Eat_Drink_Americano','7727052db9b6d65aa0e680c7e18df576','jobg8_Eat_Drink_Americano',41,'2017-09-10 11:29:38',1,'6fndqzhjwsckypx1t0e4789uo25rml3vgbia',0,NULL,NULL,'','','','Eat Drink Americano','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,''),(4014,'jobg8_FAIRFIELD_INN_CHATTANOOGA','56abfe6cfa3ab79e1c7277f7be61576b','jobg8_FAIRFIELD_INN_CHATTANOOGA',41,'2017-09-10 11:29:38',1,'6e2qt70jz1vmulbsdkf5hi8rgcaxynwop439',0,NULL,NULL,'','','','FAIRFIELD INN CHATTANOOGA','','','','',NULL,'',0,0,'','',NULL,'',NULL,0,0,'')

также таблица только для emails, но не связанных с users. Всего около 8к уникальных emails
 
admin


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх