DarkForums Members
Posts
16
Threads
0
Joined
Jun 2025
7 Months
DarkForums Members
Posts
89
Threads
0
Joined
Aug 2025
6 Months
DarkForums Members
Posts
4
Threads
0
Joined
Oct 2025
4 Months
Banned
Posts
85
Threads
0
Joined
Oct 2025
Reputation
4 Months
Thank you very much
Ban reason: leeching (Permanent)
DarkForums Members
Posts
30
Threads
0
Joined
Oct 2025
4 Months
DarkForums Members
Posts
494
Threads
5
Joined
Aug 2023
2 Years
Thank you for the content.
Banned
Posts
19
Threads
3
Joined
Oct 2025
Reputation
4 Months
(30-09-25, 04:32 PM)UNIT_PEGASUS Wrote: Hello DarkForums Community,
Today I've uploaded the Supered.com.au breach data for you to download. Thank you for reading and enjoy!
SuperEd is a financial technology company specializing in digital retirement advice solutions for the Australian superannuation industry. The platform empowers super funds to deliver scalable, compliant, and personalized retirement services, including Age Pension entitlement support, hybrid financial advice models, and income forecasting tools. Through a suite of integrated technologies—such as its Retirement Essentials partnership, Financial Advice Platform, and Retirement Income Forecasting Engine (RIFE)—SuperEd enables funds to enhance member engagement, optimize retirement outcomes, and lead in retirement innovation across Australia.
Breached by @UNIT_PEGASUS
Code: Uncompressed : 1,5 GB
Breach Date : SEP, 2025
Format : SQL
Country : Australia
File Sharing : biteblob
Price : Free Version
Sample :
Code: --
-- Table structure for table `prospect_lists`
--
DROP TABLE IF EXISTS `prospect_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists` (
`assigned_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`list_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`domain_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`auto_updating` tinyint(1) DEFAULT '0',
`acl_team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_list_name_c` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_default_module_c` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_prospect_list_name` (`name`),
KEY `idx_prospect_list_list_type` (`list_type`),
KEY `idx_prospect_list_date_entered` (`date_entered`),
KEY `idx_prospect_lists_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_prospect_lists_tmst_id` (`team_set_id`,`deleted`),
KEY `idx_prospect_lists_acl_tmst_id` (`acl_team_set_id`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists`
--
LOCK TABLES `prospect_lists` WRITE;
/*!40000 ALTER TABLE `prospect_lists` DISABLE KEYS */;
INSERT INTO `prospect_lists` VALUES ('76e975ce-66dd-11ed-b9ff-1b3f43ea39a6','1','1','7b0b7f04-fd4e-11ee-97e8-956f2626fc7e','Test TL 1 - N18','default','2024-04-18 06:40:00','2024-07-05 12:23:50','1','76e975ce-66dd-11ed-b9ff-1b3f43ea39a6',1,NULL,NULL,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `prospect_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_cstm`
--
DROP TABLE IF EXISTS `prospect_lists_cstm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_cstm` (
`id_c` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`auto_sync_reports_c` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_cstm`
--
LOCK TABLES `prospect_lists_cstm` WRITE;
/*!40000 ALTER TABLE `prospect_lists_cstm` DISABLE KEYS */;
INSERT INTO `prospect_lists_cstm` VALUES ('7b0b7f04-fd4e-11ee-97e8-956f2626fc7e',0);
/*!40000 ALTER TABLE `prospect_lists_cstm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_prospects`
--
DROP TABLE IF EXISTS `prospect_lists_prospects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_prospects` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`prospect_list_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`related_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`related_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_plp_rel_id` (`related_id`,`related_type`,`prospect_list_id`),
KEY `idx_plp_pro_id` (`prospect_list_id`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_prospects`
--
LOCK TABLES `prospect_lists_prospects` WRITE;
/*!40000 ALTER TABLE `prospect_lists_prospects` DISABLE KEYS */;
INSERT INTO `prospect_lists_prospects` VALUES ('7b0cfc4e-fd4e-11ee-89da-7bf55aeea71a','7b0b7f04-fd4e-11ee-97e8-956f2626fc7e','8cfcee06-eeb4-0bf6-9a5b-661f5f660519','Contacts','2024-04-18 06:40:00',0);
/*!40000 ALTER TABLE `prospect_lists_prospects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_reports`
--
DROP TABLE IF EXISTS `prospect_lists_reports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_reports` (
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`prospectlist_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`report_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`related_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
`active_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1',
PRIMARY KEY (`id`),
KEY `idx_pros_con_proj` (`prospectlist_id`),
KEY `idx_report_prosp` (`report_id`),
KEY `prosp_rep_alt` (`prospectlist_id`,`report_id`,`related_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_reports`
--
LOCK TABLES `prospect_lists_reports` WRITE;
/*!40000 ALTER TABLE `prospect_lists_reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `prospect_lists_reports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospectlists_reports_1_c`
--
DROP TABLE IF EXISTS `prospectlists_reports_1_c`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospectlists_reports_1_c` (
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
`prospectlists_reports_1pl_ida` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`prospectlists_reports_1r_idb` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `prospectlists_reports_1_alt` (`prospectlists_reports_1pl_ida`,`prospectlists_reports_1r_idb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospectlists_reports_1_c`
--
LOCK TABLES `prospectlists_reports_1_c` WRITE;
/*!40000 ALTER TABLE `prospectlists_reports_1_c` DISABLE KEYS */;
/*!40000 ALTER TABLE `prospectlists_reports_1_c` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospects`
--
DROP TABLE IF EXISTS `prospects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospects` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`salutation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`facebook` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`twitter` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`googleplus` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`do_not_call` tinyint(1) DEFAULT '0',
`phone_home` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_mobile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_work` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_other` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_fax` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_street` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_postalcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_street` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_postalcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`assistant` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`assistant_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`tracker_key` int NOT NULL AUTO_INCREMENT,
`birthdate` date DEFAULT NULL,
`lead_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`account_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`campaign_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`dnb_principal_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`acl_team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_rating_c` int DEFAULT '0',
`dp_business_purpose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`dp_consent_last_updated` date DEFAULT NULL,
`sync_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`geocode_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`external_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_prospects_skey` (`sync_key`),
KEY `prospectsmod` (`date_modified`),
KEY `prospect_auto_tracker_key` (`tracker_key`),
KEY `idx_prospects_last_first` (`last_name`,`first_name`,`deleted`),
KEY `idx_prospecs_del_last` (`last_name`,`deleted`),
KEY `idx_prospects_id_del` (`id`,`deleted`),
KEY `idx_prospect_title` (`title`),
KEY `idx_prospect_date_entered` (`date_entered`),
KEY `idx_prospects_first_last` (`first_name`,`last_name`,`deleted`),
KEY `idx_prospects_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_prospects_tmst_id` (`team_set_id`,`deleted`),
KEY `idx_prospects_acl_tmst_id` (`acl_team_set_id`,`deleted`),
KEY `idx_prospects_del_d_m` (`deleted`,`date_modified`,`id`),
KEY `idx_prospects_del_d_e` (`deleted`,`date_entered`,`id`),
KEY `idx_prospects_external_user_id` (`external_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
Download :
Contact Only Sessions / DM : 05c1a8cb9ec237cc18ff765e47b7dad20fefc4d01a1cb9cd53dabfc722ec259756
asdsad
Ban reason: IDIOT (Permanent)
DarkForums Members
Posts
16
Threads
1
Joined
Sep 2025
5 Months
(30-09-25, 04:32 PM)UNIT_PEGASUS Wrote: Hello DarkForums Community,
Today I've uploaded the Supered.com.au breach data for you to download. Thank you for reading and enjoy!
SuperEd is a financial technology company specializing in digital retirement advice solutions for the Australian superannuation industry. The platform empowers super funds to deliver scalable, compliant, and personalized retirement services, including Age Pension entitlement support, hybrid financial advice models, and income forecasting tools. Through a suite of integrated technologies—such as its Retirement Essentials partnership, Financial Advice Platform, and Retirement Income Forecasting Engine (RIFE)—SuperEd enables funds to enhance member engagement, optimize retirement outcomes, and lead in retirement innovation across Australia.
Breached by @UNIT_PEGASUS
Code: Uncompressed : 1,5 GB
Breach Date : SEP, 2025
Format : SQL
Country : Australia
File Sharing : biteblob
Price : Free Version
Sample :
Code: --
-- Table structure for table `prospect_lists`
--
DROP TABLE IF EXISTS `prospect_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists` (
`assigned_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`list_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`domain_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`auto_updating` tinyint(1) DEFAULT '0',
`acl_team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_list_name_c` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_default_module_c` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_prospect_list_name` (`name`),
KEY `idx_prospect_list_list_type` (`list_type`),
KEY `idx_prospect_list_date_entered` (`date_entered`),
KEY `idx_prospect_lists_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_prospect_lists_tmst_id` (`team_set_id`,`deleted`),
KEY `idx_prospect_lists_acl_tmst_id` (`acl_team_set_id`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists`
--
LOCK TABLES `prospect_lists` WRITE;
/*!40000 ALTER TABLE `prospect_lists` DISABLE KEYS */;
INSERT INTO `prospect_lists` VALUES ('76e975ce-66dd-11ed-b9ff-1b3f43ea39a6','1','1','7b0b7f04-fd4e-11ee-97e8-956f2626fc7e','Test TL 1 - N18','default','2024-04-18 06:40:00','2024-07-05 12:23:50','1','76e975ce-66dd-11ed-b9ff-1b3f43ea39a6',1,NULL,NULL,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `prospect_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_cstm`
--
DROP TABLE IF EXISTS `prospect_lists_cstm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_cstm` (
`id_c` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`auto_sync_reports_c` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_cstm`
--
LOCK TABLES `prospect_lists_cstm` WRITE;
/*!40000 ALTER TABLE `prospect_lists_cstm` DISABLE KEYS */;
INSERT INTO `prospect_lists_cstm` VALUES ('7b0b7f04-fd4e-11ee-97e8-956f2626fc7e',0);
/*!40000 ALTER TABLE `prospect_lists_cstm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_prospects`
--
DROP TABLE IF EXISTS `prospect_lists_prospects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_prospects` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`prospect_list_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`related_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`related_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_plp_rel_id` (`related_id`,`related_type`,`prospect_list_id`),
KEY `idx_plp_pro_id` (`prospect_list_id`,`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_prospects`
--
LOCK TABLES `prospect_lists_prospects` WRITE;
/*!40000 ALTER TABLE `prospect_lists_prospects` DISABLE KEYS */;
INSERT INTO `prospect_lists_prospects` VALUES ('7b0cfc4e-fd4e-11ee-89da-7bf55aeea71a','7b0b7f04-fd4e-11ee-97e8-956f2626fc7e','8cfcee06-eeb4-0bf6-9a5b-661f5f660519','Contacts','2024-04-18 06:40:00',0);
/*!40000 ALTER TABLE `prospect_lists_prospects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospect_lists_reports`
--
DROP TABLE IF EXISTS `prospect_lists_reports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect_lists_reports` (
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`prospectlist_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`report_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`related_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
`active_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1',
PRIMARY KEY (`id`),
KEY `idx_pros_con_proj` (`prospectlist_id`),
KEY `idx_report_prosp` (`report_id`),
KEY `prosp_rep_alt` (`prospectlist_id`,`report_id`,`related_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospect_lists_reports`
--
LOCK TABLES `prospect_lists_reports` WRITE;
/*!40000 ALTER TABLE `prospect_lists_reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `prospect_lists_reports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospectlists_reports_1_c`
--
DROP TABLE IF EXISTS `prospectlists_reports_1_c`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospectlists_reports_1_c` (
`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
`prospectlists_reports_1pl_ida` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`prospectlists_reports_1r_idb` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `prospectlists_reports_1_alt` (`prospectlists_reports_1pl_ida`,`prospectlists_reports_1r_idb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `prospectlists_reports_1_c`
--
LOCK TABLES `prospectlists_reports_1_c` WRITE;
/*!40000 ALTER TABLE `prospectlists_reports_1_c` DISABLE KEYS */;
/*!40000 ALTER TABLE `prospectlists_reports_1_c` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `prospects`
--
DROP TABLE IF EXISTS `prospects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospects` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`salutation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`facebook` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`twitter` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`googleplus` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`do_not_call` tinyint(1) DEFAULT '0',
`phone_home` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_mobile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_work` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_other` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_fax` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_street` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_postalcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`primary_address_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_street` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_postalcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`alt_address_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`assistant` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`assistant_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`tracker_key` int NOT NULL AUTO_INCREMENT,
`birthdate` date DEFAULT NULL,
`lead_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`account_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`campaign_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`dnb_principal_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`acl_team_set_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mailchimp_rating_c` int DEFAULT '0',
`dp_business_purpose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`dp_consent_last_updated` date DEFAULT NULL,
`sync_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`geocode_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`external_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_prospects_skey` (`sync_key`),
KEY `prospectsmod` (`date_modified`),
KEY `prospect_auto_tracker_key` (`tracker_key`),
KEY `idx_prospects_last_first` (`last_name`,`first_name`,`deleted`),
KEY `idx_prospecs_del_last` (`last_name`,`deleted`),
KEY `idx_prospects_id_del` (`id`,`deleted`),
KEY `idx_prospect_title` (`title`),
KEY `idx_prospect_date_entered` (`date_entered`),
KEY `idx_prospects_first_last` (`first_name`,`last_name`,`deleted`),
KEY `idx_prospects_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_prospects_tmst_id` (`team_set_id`,`deleted`),
KEY `idx_prospects_acl_tmst_id` (`acl_team_set_id`,`deleted`),
KEY `idx_prospects_del_d_m` (`deleted`,`date_modified`,`id`),
KEY `idx_prospects_del_d_e` (`deleted`,`date_entered`,`id`),
KEY `idx_prospects_external_user_id` (`external_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
Download :
Contact Only Sessions / DM : 05c1a8cb9ec237cc18ff765e47b7dad20fefc4d01a1cb9cd53dabfc722ec259756
thnx bro
lets see how it is
DarkForums Members
Posts
10
Threads
0
Joined
Oct 2025
4 Months
DarkForums Members
Posts
12
Threads
0
Joined
Jul 2025
7 Months
|