SQL joinpiggy.com

[tudos]

sql dump таблицы юзеров сайта joinpiggy.com, 1,25kk юзеров с данными (мыло, пароль (мд-5 и Ша-1), имя, телефон, итг. исходя из данных дамп 2018 года

Спойлер: тыц

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: prod-cofund.ccxg8cv5mnie.us-east-1.rds.amazonaws.com Database: xiopal
-- ------------------------------------------------------
-- Server version 5.6.48-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cofunduser_orig`
--

DROP TABLE IF EXISTS `cofunduser_orig`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cofunduser_orig` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`old_user_id` int(11) DEFAULT NULL,
`site_id` int(11) NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`gender` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`hashpass` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`address1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`zip` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` tinyint(1) unsigned DEFAULT NULL,
`clearance` int(11) unsigned DEFAULT NULL,
`created` datetime DEFAULT NULL,
`payment_method` int(11) unsigned DEFAULT NULL,
`paypal_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_updated` datetime DEFAULT NULL,
`ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref1` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref2` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref3` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref4` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref5` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`ref6` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`tid` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
`referrer_entity_id` int(11) DEFAULT NULL,
`referer_entity_id` int(11) DEFAULT NULL,
`fb_user_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`google_user_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`signup_browser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`signup_browser_version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`signup_os` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`signup_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`device` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`homephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`cellphone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`app_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`app_installed` tinyint(1) unsigned DEFAULT NULL,
`app_installed_datetime` datetime DEFAULT NULL,
`app_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`payable1` tinyint(1) unsigned DEFAULT NULL,
`payable2` tinyint(1) unsigned DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_api_access` datetime DEFAULT NULL,
`identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identifier` (`identifier`,`site_id`) USING BTREE,
KEY `site_id` (`site_id`),
KEY `old_user` (`old_user_id`,`site_id`),
KEY `email` (`email`),
KEY `ip` (`ip`),
KEY `ref3` (`ref3`),
KEY `created` (`created`),
KEY `google_user_site` (`google_user_id`,`site_id`),
KEY `fb_user_site` (`fb_user_id`,`site_id`),
KEY `referrer_entity_id` (`referrer_entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1589120 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cofunduser_orig`
--

LOCK TABLES `cofunduser_orig` WRITE;
/*!40000 ALTER TABLE `cofunduser_orig` DISABLE KEYS */;

Спойлер: тыц

INSERT INTO `cofunduser_orig` VALUES (1,1,1,'dev@cofundraising.com','Cofund','Admin','','Save1234!','fake street','','Sartell','MN','32746','',1,NULL,'2013-08-23 00:15:56',0,'','2015-03-19 11:06:21','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','c2edf89975abc086ea1c8ede3b4d4c72',NULL,NULL,NULL,NULL,NULL,'2015-04-25 17:20:48',NULL,'20eb2c3b39102ef86630641af983fafe'),(2,2,1,'john@allimaronline.com','John','Anderson','',NULL,'1234 primera',NULL,'Lake mary','FL','32746','',1,NULL,'2013-01-04 16:57:28',2,'','2015-03-19 11:06:21','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'23fa31c93346c4915924a6962f452ae9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1d907197ad91665e1d90163a59de9236')

piggyllc

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[herleett]

reupload pls