--
-- Host: localhost    Database: db_integrite_miner
-- ------------------------------------------------------


--
-- Table structure for table `crawl_log`
--

CREATE TABLE `crawl_log` (
  `crawllog_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_uuid` varchar(255) NOT NULL,
  `crawllog_message` text NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`crawllog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COMMENT='log of crawl of miner for discoveries';

--
-- Dumping data for table `crawl_log`
--

INSERT INTO `crawl_log` VALUES (15,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-24 22:30:01','0000-00-00 00:00:00'),(16,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-25 09:30:01','0000-00-00 00:00:00'),(17,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-25 15:30:01','0000-00-00 00:00:00'),(18,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-26 09:30:02','0000-00-00 00:00:00'),(19,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-27 09:30:01','0000-00-00 00:00:00'),(20,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-28 09:30:01','0000-00-00 00:00:00'),(21,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-29 09:30:01','0000-00-00 00:00:00'),(22,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-30 09:30:02','0000-00-00 00:00:00'),(23,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2019-12-31 09:30:01','0000-00-00 00:00:00'),(24,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-01 09:30:01','0000-00-00 00:00:00'),(25,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-02 09:30:01','0000-00-00 00:00:00'),(26,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-03 09:30:01','0000-00-00 00:00:00'),(27,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-04 09:30:01','0000-00-00 00:00:00'),(28,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-05 09:30:01','0000-00-00 00:00:00'),(29,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-06 09:30:01','0000-00-00 00:00:00'),(30,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-07 09:30:01','0000-00-00 00:00:00'),(31,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-08 09:30:01','0000-00-00 00:00:00'),(32,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-09 09:30:01','0000-00-00 00:00:00'),(33,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-10 09:30:02','0000-00-00 00:00:00'),(34,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-11 09:30:01','0000-00-00 00:00:00'),(35,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-12 09:30:01','0000-00-00 00:00:00'),(36,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-13 09:30:01','0000-00-00 00:00:00'),(37,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-14 09:30:01','0000-00-00 00:00:00'),(38,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-15 09:30:01','0000-00-00 00:00:00'),(39,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-16 09:30:01','0000-00-00 00:00:00'),(40,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-17 09:30:01','0000-00-00 00:00:00'),(41,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-18 09:30:01','0000-00-00 00:00:00'),(42,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-19 09:30:02','0000-00-00 00:00:00'),(43,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-20 09:30:01','0000-00-00 00:00:00'),(44,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-21 09:30:01','0000-00-00 00:00:00'),(45,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-22 09:30:02','0000-00-00 00:00:00'),(46,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-23 09:30:01','0000-00-00 00:00:00'),(47,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-24 09:30:02','0000-00-00 00:00:00'),(48,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-25 09:30:01','0000-00-00 00:00:00'),(49,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-26 09:30:01','0000-00-00 00:00:00'),(50,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-27 09:30:01','0000-00-00 00:00:00'),(51,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-28 09:30:01','0000-00-00 00:00:00'),(52,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-29 09:30:01','0000-00-00 00:00:00'),(53,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-30 09:30:01','0000-00-00 00:00:00'),(54,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-01-31 09:30:01','0000-00-00 00:00:00'),(55,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-01 09:30:01','0000-00-00 00:00:00'),(56,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-02 09:30:02','0000-00-00 00:00:00'),(57,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-03 09:30:02','0000-00-00 00:00:00'),(58,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-04 09:30:01','0000-00-00 00:00:00'),(59,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-05 09:30:01','0000-00-00 00:00:00'),(60,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-06 09:30:02','0000-00-00 00:00:00'),(61,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-07 09:30:01','0000-00-00 00:00:00'),(62,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-08 04:33:00','0000-00-00 00:00:00'),(63,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-09 09:30:01','0000-00-00 00:00:00'),(64,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-10 09:30:01','0000-00-00 00:00:00'),(65,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-11 09:30:01','0000-00-00 00:00:00'),(66,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-12 09:30:01','0000-00-00 00:00:00'),(67,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-13 09:30:01','0000-00-00 00:00:00'),(68,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-14 09:30:01','0000-00-00 00:00:00'),(69,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-15 09:30:01','0000-00-00 00:00:00'),(70,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-16 09:30:01','0000-00-00 00:00:00'),(71,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-17 09:30:01','0000-00-00 00:00:00'),(72,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-18 09:30:01','0000-00-00 00:00:00'),(73,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-19 09:30:01','0000-00-00 00:00:00'),(74,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-20 09:30:01','0000-00-00 00:00:00'),(75,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-21 09:30:01','0000-00-00 00:00:00'),(76,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-22 09:30:01','0000-00-00 00:00:00'),(77,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-23 09:30:01','0000-00-00 00:00:00'),(78,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-24 09:30:01','0000-00-00 00:00:00'),(79,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-25 09:30:01','0000-00-00 00:00:00'),(80,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-26 09:30:01','0000-00-00 00:00:00'),(81,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-27 09:30:01','0000-00-00 00:00:00'),(82,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-28 09:30:01','0000-00-00 00:00:00'),(83,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-02-29 09:30:01','0000-00-00 00:00:00'),(84,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-01 09:30:01','0000-00-00 00:00:00'),(85,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-02 09:30:01','0000-00-00 00:00:00'),(86,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-03 09:30:02','0000-00-00 00:00:00'),(87,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-04 09:30:02','0000-00-00 00:00:00'),(88,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-05 09:30:01','0000-00-00 00:00:00'),(89,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-06 09:30:01','0000-00-00 00:00:00'),(90,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-07 09:30:01','0000-00-00 00:00:00'),(91,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-08 09:30:01','0000-00-00 00:00:00'),(92,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-09 09:30:01','0000-00-00 00:00:00'),(93,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-10 09:30:01','0000-00-00 00:00:00'),(94,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-11 09:30:01','0000-00-00 00:00:00'),(95,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-12 09:30:01','0000-00-00 00:00:00'),(96,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-13 09:30:01','0000-00-00 00:00:00'),(97,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-14 09:30:01','0000-00-00 00:00:00'),(98,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-15 09:30:01','0000-00-00 00:00:00'),(99,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-16 09:30:01','0000-00-00 00:00:00'),(100,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-17 09:30:01','0000-00-00 00:00:00'),(101,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-18 09:30:01','0000-00-00 00:00:00'),(102,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-19 09:30:01','0000-00-00 00:00:00'),(103,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-20 09:30:01','0000-00-00 00:00:00'),(104,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-21 09:30:01','0000-00-00 00:00:00'),(105,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-22 09:30:01','0000-00-00 00:00:00'),(106,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-23 09:30:01','0000-00-00 00:00:00'),(107,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-24 09:30:01','0000-00-00 00:00:00'),(108,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-25 09:30:02','0000-00-00 00:00:00'),(109,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-26 09:30:01','0000-00-00 00:00:00'),(110,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-27 09:30:01','0000-00-00 00:00:00'),(111,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-28 09:30:01','0000-00-00 00:00:00'),(112,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-29 09:30:01','0000-00-00 00:00:00'),(113,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-30 09:30:01','0000-00-00 00:00:00'),(114,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-03-31 09:30:01','0000-00-00 00:00:00'),(115,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-04-01 09:30:01','0000-00-00 00:00:00'),(116,'5dfdf3b38a7b4','Crawling Miner DB for posts and credentials','2020-04-02 09:30:01','0000-00-00 00:00:00');

--
-- Table structure for table `crawl_schedule`
--

CREATE TABLE `crawl_schedule` (
  `schedule_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_uuid` varchar(255) NOT NULL,
  `schedule_frequency` int(11) NOT NULL DEFAULT '1' COMMENT '1 - once a day, 2 - twice a day and so on',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`schedule_id`),
  UNIQUE KEY `client_uuid` (`client_uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='store client crawl schedule';

--
-- Dumping data for table `crawl_schedule`
--

INSERT INTO `crawl_schedule` VALUES (1,'5dfdf3b38a7b4',1,'2019-12-22 10:51:35','2019-12-26 11:58:37');

--
-- Table structure for table `crawler_credit`
--

CREATE TABLE `crawler_credit` (
  `credit_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_uuid` varchar(255) NOT NULL,
  `credit_max_count` int(11) NOT NULL DEFAULT '30',
  `credit_remaining_count` int(11) NOT NULL DEFAULT '30',
  `credit_period_startdate` date DEFAULT NULL,
  `credit_period_enddate` date DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`credit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='store crawler credit count for a client for any particular period';

--
-- Dumping data for table `crawler_credit`
--

INSERT INTO `crawler_credit` VALUES (1,'5dfdf3b38a7b4',60,4,'2020-03-05','2020-04-05','2019-12-22 10:50:49','2020-04-02 09:30:01');

--
-- Table structure for table `credentials`
--

CREATE TABLE `credentials` (
  `cred_id` int(11) NOT NULL AUTO_INCREMENT,
  `cred_type` enum('username','email') NOT NULL,
  `cred_source` varchar(255) NOT NULL COMMENT 'webhose-cyber-api, webhose-dbd-api, dehashed etc',
  `cred_value` varchar(255) NOT NULL COMMENT 'email or username',
  `cred_domain` varchar(255) DEFAULT NULL COMMENT 'Eg:- gmail.com, technisanct.com',
  `cred_published` datetime DEFAULT NULL,
  `cred_discovered_at` text COMMENT 'Eg:- website or forum where the email/username was found',
  `cred_status` enum('discovery','miner') NOT NULL DEFAULT 'miner' COMMENT 'discovery - post has been pushed to client database',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifed_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`cred_id`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=latin1 COMMENT='store breached usernames and emails';

--
-- Dumping data for table `credentials`
--

INSERT INTO `credentials` VALUES (52,'email','third-eye','teacherdnd@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(53,'email','third-eye','gaurav.singhal+100@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(54,'email','third-eye','gaurav.singhal+102@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(55,'email','third-eye','gaurav.singhal+104@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(56,'email','third-eye','gaurav.singhal+105@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(57,'email','third-eye','gaurav.singhal+106@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(58,'email','third-eye','gaurav.singhal+107@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(59,'email','third-eye','gaurav.singhal+108@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(60,'email','third-eye','gaurav.singhal+203@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(61,'email','third-eye','gaurav.singhal+204@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(62,'email','third-eye','gaurav.singhal+211@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(63,'email','third-eye','gaurav.singhal+212@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(64,'email','third-eye','gaurav.singhal+3006@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(65,'email','third-eye','gaurav.singhal+3007@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(66,'email','third-eye','gaurav.singhal+50@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(67,'email','third-eye','gaurav.singhal+51@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(68,'email','third-eye','gaurav.singhal+52@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:05'),(69,'email','third-eye','gaurav.singhal+567@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(70,'email','third-eye','gaurav.singhal+9090@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(71,'email','third-eye','gaurav.singhal+9092@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(72,'email','third-eye','gaurav.singhal+98@vedantu.com','vedantu.com','2019-08-16 00:00:00','https://pastebin.com/yKAqMyGG','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(73,'email','third-eye','ashok@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(74,'email','third-eye','mahadevqa3@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(75,'email','third-eye','test.q3@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(76,'email','third-eye','akshay.sisodiya@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(77,'email','third-eye','rajat.malhotra@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:28','2019-12-25 09:30:06'),(78,'email','third-eye','darshit.padhya+3@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(79,'email','third-eye','sreedhar.gn+31@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(80,'email','third-eye','sreedhar.gn+2@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(81,'email','third-eye','sreedhar.gn+1@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(82,'email','third-eye','dex1testt2@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(83,'email','third-eye','dextestt2@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(84,'email','third-eye','kamini.kamal090878@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(85,'email','third-eye','kamini.kamal.kamall@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:06'),(86,'email','third-eye','kamini.kamakkkkl@vedantu.com','vedantu.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(87,'email','third-eye','abc@gmail.com','gmail.com','2019-09-16 08:01:00','https://pastebin.com/irqMcyc2','miner','2019-12-25 06:13:29','0000-00-00 00:00:00'),(88,'email','third-eye','shyam.teacher@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(89,'email','third-eye','mahadevappa.hs@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(90,'email','third-eye','maahadevappa.hs@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(91,'email','third-eye','rajatmalhotra26@gmail.com','gmail.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','miner','2019-12-25 06:13:29','0000-00-00 00:00:00'),(92,'email','third-eye','teacher.dev@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(93,'email','third-eye','ashok.sahoo@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(94,'email','third-eye','mahadevqa3@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(95,'email','third-eye','akshay.sisodiya@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(96,'email','third-eye','darshit.padhya+3@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(97,'email','third-eye','sreedhar.gn+31@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(98,'email','third-eye','sreedhar.gn+2@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(99,'email','third-eye','sreedhar.gn+1@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(100,'email','third-eye','dex1testt2@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(101,'email','third-eye','dextestt2@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(102,'email','third-eye','kamini.kamal090878@vedantu.com','vedantu.com','2019-09-19 12:48:00','https://pastebin.com/00ys11sg','discovery','2019-12-25 06:13:29','2019-12-25 09:30:07'),(103,'email','third-eye','accounts@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(104,'email','third-eye','shashank.dubey@vedantu.com','vedantu.com',NULL,'Edmodo','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(105,'email','third-eye','akansha.shrivastava@vedantu.com','vedantu.com',NULL,'Adobe','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(106,'email','third-eye','71051009',NULL,NULL,'Collections','miner','2020-01-13 11:00:01','0000-00-00 00:00:00'),(107,'email','third-eye','121038830',NULL,NULL,'Collections','miner','2020-01-13 11:00:01','0000-00-00 00:00:00'),(108,'email','third-eye','Saurabh.saxena@vedantu.com','vedantu.com',NULL,'aqad.in','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(109,'email','third-eye','ashok.bhat@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(110,'email','third-eye','vss.puneeth@vedantu.com','vedantu.com',NULL,'Zomato','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(111,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'AntiPublic','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(112,'email','third-eye','41346423',NULL,NULL,'Collections','miner','2020-01-13 11:00:01','0000-00-00 00:00:00'),(113,'email','third-eye','swetha.konduru@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-13 11:00:01','2020-01-14 09:30:01'),(114,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'BreachCompilation','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(115,'email','third-eye','18161887',NULL,NULL,'Collections','miner','2020-01-13 11:00:02','0000-00-00 00:00:00'),(116,'email','third-eye','reema.narula@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(117,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'Exploit.in','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(118,'email','third-eye','vamsi.krishna@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(119,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'adbazzaar.com','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(120,'email','third-eye','garima.verdia@vedantu.com','vedantu.com',NULL,'Zomato','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(121,'email','third-eye','pulkit.jain@vedantu.com','vedantu.com',NULL,'Zomato','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(122,'email','third-eye','pushplata.verma@vedantu.com','vedantu.com',NULL,'MyFitnessPal','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(123,'email','third-eye','swetha.konduru@vedantu.com','vedantu.com',NULL,'Zomato','discovery','2020-01-13 11:00:02','2020-01-14 09:30:01'),(124,'email','third-eye','accounts@vedantu.com','vedantu.com',NULL,'16,624 Separate Data Breaches','discovery','2020-01-13 11:00:02','2020-01-14 09:30:02'),(125,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'16,624 Separate Data Breaches','discovery','2020-01-13 11:00:02','2020-01-14 09:30:02'),(126,'email','third-eye','saurabh@vedantu.com','vedantu.com',NULL,'MyFitnessPal','discovery','2020-01-13 11:00:02','2020-01-14 09:30:02'),(127,'email','third-eye','simriti@vedantu.com','vedantu.com',NULL,'Edmodo','discovery','2020-01-13 11:00:03','2020-01-14 09:30:02'),(128,'email','third-eye','alka.singh@vedantu.com','vedantu.com',NULL,'Dubsmash','discovery','2020-01-13 11:00:03','2020-01-14 09:30:02'),(129,'email','third-eye','saurabh.saxena@vedantu.com','vedantu.com',NULL,'Edmodo','discovery','2020-01-13 11:00:03','2020-01-14 09:30:02'),(130,'email','third-eye','ashok.kumar@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:02'),(131,'email','third-eye','reema.narula@vedantu.com','vedantu.com',NULL,'aqad.in','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(132,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(133,'email','third-eye','dhanashree.badhe@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(134,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'BreachCompilation','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(135,'email','third-eye','shaik.nazimunnisa@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(136,'email','third-eye','vamsi.krishna@vedantu.com','vedantu.com',NULL,'aqad.in','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(137,'email','third-eye','beetho.ub@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(138,'email','third-eye','ayan.ghosh@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(139,'email','third-eye','gaurav.parkash@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(140,'email','third-eye','ravi.ranjan@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(141,'email','third-eye','breddy.prasad@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(142,'email','third-eye','pulkit.jain@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(143,'email','third-eye','bondwithus@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(144,'email','third-eye','Saurabh.saxena@vedantu.com','vedantu.com',NULL,'Collections','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(145,'email','third-eye','shanu2412@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:03'),(146,'email','third-eye','kirana.sk@vedantu.com','vedantu.com',NULL,'Zomato','discovery','2020-01-30 03:00:01','2020-01-30 09:30:04'),(147,'email','third-eye','GAURAV.SINGHAL@VEDANTU.COM','VEDANTU.COM',NULL,'Chegg.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:04'),(148,'email','third-eye','ranjan.banerjee@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:04'),(149,'email','third-eye','anand.prakash@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:04'),(150,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:01','2020-01-30 09:30:04'),(151,'email','third-eye','karthik.devarakonda@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(152,'email','third-eye','ayan.ghosh@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(153,'email','third-eye','soumya@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(154,'email','third-eye','ayan@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(155,'email','third-eye','rahul.yeluri@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(156,'email','third-eye','simriti.goel+1@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(157,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'Zynga.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(158,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'LastFM','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(159,'email','third-eye','shreya.ghosh@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(160,'email','third-eye','simriti.goel+2@vedantu.com','vedantu.com',NULL,'Chegg.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(161,'email','third-eye','kannan.d@vedantu.com','vedantu.com',NULL,'Canva.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(162,'email','third-eye','ravi.ranjan@vedantu.com','vedantu.com',NULL,'Animoto.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(163,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'Edmodo','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(164,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'Disqus.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(165,'email','third-eye','simriti.goel@vedantu.com','vedantu.com',NULL,'8tracks','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(166,'email','third-eye','ravi.ranjan@vedantu.com','vedantu.com',NULL,'DataCamp.com','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04'),(167,'email','third-eye','ashok.bhat@vedantu.com','vedantu.com',NULL,'Dubsmash','discovery','2020-01-30 03:00:02','2020-01-30 09:30:04');

--
-- Table structure for table `credit_log`
--

CREATE TABLE `credit_log` (
  `creditlog_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_uuid` varchar(255) NOT NULL,
  `crawllog_id` int(11) NOT NULL,
  `creditlog_type` enum('addition','deduction') NOT NULL,
  `creditlog_credit_change_count` int(11) NOT NULL DEFAULT '1',
  `creditlog_message` text NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`creditlog_id`),
  KEY `fk_crawllog_id` (`crawllog_id`),
  CONSTRAINT `credit_log_ibfk_1` FOREIGN KEY (`crawllog_id`) REFERENCES `crawl_log` (`crawllog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='log of crawl of miner for discoveries';

--
-- Dumping data for table `credit_log`
--


--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` VALUES ('m000000_000000_base',1576991254),('m130524_201442_init',1576991256),('m190124_110200_add_verification_token_column_to_user_table',1576991256);

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_source` enum('third-eye','spider') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'third-eye',
  `post_network` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'tor, openweb, telegram etc',
  `client_uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique ID of client from Client dashboard database',
  `source_uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'unique ID of post in third eye DB or Spider database',
  `post_url` text COLLATE utf8mb4_unicode_ci,
  `post_title` text CHARACTER SET utf8mb4,
  `post_content` mediumtext CHARACTER SET utf8mb4,
  `post_published_date` datetime DEFAULT NULL,
  `post_crawled_date` datetime DEFAULT NULL,
  `post_cache_link` text COLLATE utf8mb4_unicode_ci,
  `post_nature` enum('Breach/Hack','phishing','malicious content','paste') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_evaluation_status` enum('pending','hold','irrelevant','relevant') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'hold - for revaluation before determining relevance',
  `post_threat_level` enum('high','medium','low','none','unknown') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unknown',
  `post_status` enum('discovery','miner') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'miner' COMMENT 'discovery - post has been pushed to client database',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`post_id`),
  UNIQUE KEY `post_uuid` (`post_uuid`),
  KEY `client_uuid` (`client_uuid`),
  KEY `post_network` (`post_network`),
  KEY `post_evaluation_status` (`post_evaluation_status`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='store results from third eye and spider databases';

--
-- Dumping data for table `post`
--




