--
-- Host: localhost    Database: mauticsystem
-- ------------------------------------------------------


--
-- Table structure for table `ms_asset_downloads`
--

CREATE TABLE `ms_asset_downloads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `email_id` int(10) unsigned DEFAULT NULL,
  `date_download` datetime NOT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext COLLATE utf8mb4_unicode_ci,
  `tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `utm_campaign` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_medium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_term` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_737CBD375DA1941` (`asset_id`),
  KEY `IDX_737CBD37A03F5E9F` (`ip_id`),
  KEY `IDX_737CBD3755458D` (`lead_id`),
  KEY `IDX_737CBD37A832C1C9` (`email_id`),
  KEY `ms_download_tracking_search` (`tracking_id`),
  KEY `ms_download_source_search` (`source`,`source_id`),
  KEY `ms_asset_date_download` (`date_download`),
  CONSTRAINT `FK_737CBD3755458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_737CBD375DA1941` FOREIGN KEY (`asset_id`) REFERENCES `ms_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_737CBD37A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_737CBD37A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_asset_downloads`
--


--
-- Table structure for table `ms_assets`
--

CREATE TABLE `ms_assets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `storage_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remote_path` longtext COLLATE utf8mb4_unicode_ci,
  `original_file_name` longtext COLLATE utf8mb4_unicode_ci,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `download_count` int(11) NOT NULL,
  `unique_download_count` int(11) NOT NULL,
  `revision` int(11) NOT NULL,
  `extension` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `disallow` tinyint(1) DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_7474A15D12469DE2` (`category_id`),
  KEY `ms_asset_alias_search` (`alias`),
  CONSTRAINT `FK_7474A15D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_assets`
--


--
-- Table structure for table `ms_audit_log`
--

CREATE TABLE `ms_audit_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `user_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object_id` bigint(20) unsigned NOT NULL,
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `date_added` datetime NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ms_object_search` (`object`,`object_id`),
  KEY `ms_timeline_search` (`bundle`,`object`,`action`,`object_id`),
  KEY `ms_date_added_index` (`date_added`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_audit_log`
--

INSERT INTO `ms_audit_log` VALUES (1,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-20 11:17:56','127.0.0.1'),(2,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-20 11:21:29','127.0.0.1'),(3,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-20 11:44:42','49.156.107.42'),(4,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-20 12:04:43','82.166.173.65'),(5,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-20 12:07:27','127.0.0.1'),(6,1,'kulvir Kaur','email','email',1,'create','a:8:{s:12:\"dateModified\";a:2:{i:0;N;i:1;s:25:\"2025-05-20T12:19:58+00:00\";}s:4:\"name\";a:2:{i:0;N;i:1;s:4:\"test\";}s:7:\"subject\";a:2:{i:0;N;i:1;s:4:\"test\";}s:8:\"fromName\";a:2:{i:0;N;i:1;s:4:\"Test\";}s:11:\"fromAddress\";a:2:{i:0;N;i:1;s:13:\"test@test.com\";}s:7:\"utmTags\";a:2:{i:0;a:0:{}i:1;a:4:{s:9:\"utmSource\";N;s:9:\"utmMedium\";N;s:11:\"utmCampaign\";N;s:10:\"utmContent\";N;}}s:8:\"template\";a:2:{i:0;N;i:1;s:15:\"_1-2-1-2-column\";}s:5:\"lists\";a:2:{i:0;a:0:{}i:1;a:0:{}}}','2025-05-20 12:19:58','82.166.173.65'),(7,1,'kulvir Kaur','email','email',1,'update','a:1:{s:5:\"lists\";a:2:{i:0;a:0:{}i:1;a:0:{}}}','2025-05-20 12:20:05','82.166.173.65'),(8,1,'kulvir Kaur','email','email',1,'update','a:1:{s:5:\"lists\";a:2:{i:0;a:0:{}i:1;a:0:{}}}','2025-05-20 12:26:58','82.166.173.65'),(9,1,'kulvir Kaur','email','email',1,'update','a:1:{s:5:\"lists\";a:2:{i:0;a:0:{}i:1;a:0:{}}}','2025-05-20 12:30:50','82.166.173.65'),(10,1,'kulvir Kaur','lead','segment',1,'create','a:4:{s:4:\"name\";a:2:{i:0;N;i:1;s:4:\"test\";}s:12:\"dateModified\";a:2:{i:0;N;i:1;s:25:\"2025-05-20T13:03:19+00:00\";}s:5:\"alias\";a:2:{i:0;N;i:1;s:4:\"test\";}s:10:\"publicName\";a:2:{i:0;N;i:1;s:4:\"test\";}}','2025-05-20 13:03:19','82.166.173.65'),(11,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-21 06:35:58','127.0.0.1'),(12,1,'kulvir Kaur','user','security',1,'login','a:1:{s:8:\"username\";s:5:\"admin\";}','2025-05-21 07:20:23','127.0.0.1'),(13,0,'System','lead','lead',2,'create','a:1:{s:11:\"ipAddresses\";a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}}','2025-05-21 07:24:10','159.223.19.225'),(14,0,'System','lead','lead',1,'create','a:1:{s:11:\"ipAddresses\";a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}}','2025-05-21 07:24:10','159.223.19.225'),(15,0,'System','lead','lead',2,'ipadded','a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}','2025-05-21 07:24:10','159.223.19.225'),(16,0,'System','lead','lead',1,'ipadded','a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}','2025-05-21 07:24:11','159.223.19.225'),(17,0,'System','lead','lead',3,'create','a:1:{s:11:\"ipAddresses\";a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}}','2025-05-21 07:24:11','159.223.19.225'),(18,0,'System','lead','lead',3,'ipadded','a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}','2025-05-21 07:24:11','159.223.19.225'),(19,0,'System','lead','lead',4,'create','a:1:{s:11:\"ipAddresses\";a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}}','2025-05-21 07:24:11','159.223.19.225'),(20,0,'System','lead','lead',4,'ipadded','a:2:{i:0;s:0:\"\";i:1;s:14:\"159.223.19.225\";}','2025-05-21 07:24:11','159.223.19.225');

--
-- Table structure for table `ms_bundle_grapesjsbuilder`
--

CREATE TABLE `ms_bundle_grapesjsbuilder` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email_id` int(10) unsigned DEFAULT NULL,
  `custom_mjml` longtext COLLATE utf8mb4_unicode_ci,
  `draft_custom_mjml` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_E3BE5E21A832C1C9` (`email_id`),
  CONSTRAINT `FK_E3BE5E21A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_bundle_grapesjsbuilder`
--

INSERT INTO `ms_bundle_grapesjsbuilder` VALUES (1,1,'<mjml><mj-head><!-- CSS-STYLE --><mj-style inline=\"inline\"> p, li {margin:0 !important; padding:0; line-height:1.4em;}\r\n	</mj-style></mj-head><!-- BODY --><mj-body background-color=\"#d0d0d0\"><mj-section background-color=\"#ffffff\"><mj-column><mj-text font-size=\"11px\" align=\"center\"><p><span data-fr-verified=\"true\"><span data-fr-verified=\"true\" class=\"atwho-inserted\">{webview_text}</span>⁠⁠⁠⁠⁠⁠⁠</span></p></mj-text><mj-spacer></mj-spacer><mj-image src=\"https://mauticsystem.urtestsite.com/media/images/maxresdefault.jpg\" padding-bottom=\"0px\" padding-top=\"0px\"></mj-image></mj-column></mj-section><mj-section background-color=\"#ffffff\"><mj-column width=\"550px\"><mj-text font-size=\"30px\" align=\"center\" font-weight=\"700\"><p>Hi <span data-fr-verified=\"true\"><span class=\"atwho-inserted\" data-fr-verified=\"true\">{contactfield=firstname}</span>&nbsp;</span></p></mj-text><mj-text font-size=\"16px\" align=\"center\"><p><span data-fr-verified=\"true\">welcome to <span class=\"atwho-inserted\" data-fr-verified=\"true\">{brand=name}</span>&nbsp;</span></p><p><span data-fr-verified=\"true\">date is: <span class=\"atwho-inserted\" data-fr-verified=\"true\">{today}</span></span></p><p><a href=\"https://ttrack.link.com/?i={contactfield=id}\"><span data-fr-verified=\"true\">click here</span></a></p></mj-text><mj-spacer></mj-spacer></mj-column></mj-section><mj-section background-color=\"#f4f4f4\"><mj-column width=\"275px\"><mj-spacer></mj-spacer><mj-text font-size=\"22px\" align=\"center\" font-weight=\"700\"><p>Rami Avital</p></mj-text><mj-text font-size=\"16px\" align=\"center\"><p>Share a story about your company, team, or production process. \r\n		  </p></mj-text><mj-spacer></mj-spacer><mj-text data-gjs-type=\"dynamic-content\" data-slot=\"dynamicContent\" data-param-dec-id=\"2\" style=\"padding-top:10px;padding-bottom:10px;padding-right:25px;padding-left:25px;font-size:13px;align:left;display:block;\">{dynamiccontent=\"Dynamic Content 2\"}</mj-text></mj-column><mj-column width=\"275px\"><mj-spacer></mj-spacer><mj-image src=\"https://mauticsystem.urtestsite.com/media/images/1715757576075.jfif\"></mj-image><mj-spacer></mj-spacer></mj-column></mj-section><mj-section background-color=\"#ffffff\"><mj-column width=\"550px\"><mj-text font-size=\"16px\" align=\"center\"><p>You can also encourage readers to subscribe to your newsletter. Briefly explain what kind of content they can expect and how often.\r\n		  </p></mj-text></mj-column></mj-section><mj-section background-color=\"#f4f4f4\"><mj-column width=\"275px\"><mj-spacer></mj-spacer><mj-image src=\"/app/assets/images/placeholder-image.png?v9446ae26\"></mj-image><mj-spacer></mj-spacer></mj-column><mj-column width=\"275px\"><mj-spacer></mj-spacer><mj-text font-size=\"22px\" align=\"center\" font-weight=\"700\"><p>Inverse column title\r\n		  </p></mj-text><mj-text font-size=\"16px\" align=\"center\"><p>Keep it brief but engaging.\r\n		  </p></mj-text><mj-spacer></mj-spacer></mj-column></mj-section><mj-section padding-top=\"0\" background-color=\"#000000\"><mj-column><mj-spacer></mj-spacer><mj-social font-size=\"12px\" icon-size=\"30px\" border-radius=\"12px\" mode=\"horizontal\"><mj-social-element name=\"facebook\" border-radius=\"14px 14px 14px 14px\" padding-right=\"10px\" color=\"#000000\" background-color=\"#000000\">\r\n		  </mj-social-element><mj-social-element name=\"instagram\" border-radius=\"14px 14px 14px 14px\" padding-right=\"10px\" padding-left=\"10px\" color=\"#000000\" background-color=\"#000000\">\r\n		  </mj-social-element><mj-social-element name=\"youtube\" border-radius=\"14px 14px 14px 14px\" padding-left=\"10px\" color=\"#000000\" background-color=\"#000000\">\r\n		  </mj-social-element></mj-social><mj-spacer></mj-spacer><mj-text font-family=\"Ubuntu, Helvetica, Arial, sans-serif\" line-height=\"1.5\" align=\"center\" padding-top=\"0px\" padding-bottom=\"0px\" font-size=\"12px\" color=\"#ffffff\"><p>{brand=name}\r\n			<br/>11111 Beautiful City, 1212 Nice Street\r\n			<br/>Brazil\r\n			<br/></p></mj-text><mj-spacer></mj-spacer><mj-text font-size=\"11px\" align=\"center\" color=\"#b3b3b3\"><p>Fancy seeing you down here. You’re getting this email because you gave us your email address.\r\n		  </p><p>Want to change how you receive these emails?\r\n		  </p></mj-text><mj-text font-size=\"11px\" align=\"center\" color=\"#b3b3b3\"><p><span data-fr-verified=\"true\"><span data-fr-verified=\"true\" class=\"atwho-inserted\">{unsubscribe_text}</span>⁠⁠⁠⁠⁠⁠⁠</span></p></mj-text><mj-spacer></mj-spacer></mj-column></mj-section></mj-body></mjml>',NULL);

--
-- Table structure for table `ms_cache_items`
--

CREATE TABLE `ms_cache_items` (
  `item_id` varbinary(255) NOT NULL,
  `item_data` longblob NOT NULL,
  `item_lifetime` int(10) unsigned DEFAULT NULL,
  `item_time` int(10) unsigned NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_cache_items`
--

INSERT INTO `ms_cache_items` VALUES (_binary 'ms:segment.1.lead',_binary 'i:0;',NULL,1747811058);

--
-- Table structure for table `ms_campaign_events`
--

CREATE TABLE `ms_campaign_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `campaign_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_order` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `deleted` datetime DEFAULT NULL,
  `trigger_date` datetime DEFAULT NULL,
  `trigger_interval` int(11) DEFAULT NULL,
  `trigger_interval_unit` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trigger_hour` time DEFAULT NULL,
  `trigger_restricted_start_hour` time DEFAULT NULL,
  `trigger_restricted_stop_hour` time DEFAULT NULL,
  `trigger_restricted_dow` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `trigger_window` int(11) DEFAULT NULL,
  `trigger_mode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `decision_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `temp_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `failed_count` int(11) NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_5BF1DF5FF639F774` (`campaign_id`),
  KEY `IDX_5BF1DF5F727ACA70` (`parent_id`),
  KEY `ms_campaign_event_search` (`type`,`event_type`),
  KEY `ms_campaign_event_type` (`event_type`),
  KEY `ms_campaign_event_channel` (`channel`,`channel_id`),
  CONSTRAINT `FK_5BF1DF5F727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `ms_campaign_events` (`id`),
  CONSTRAINT `FK_5BF1DF5FF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_events`
--


--
-- Table structure for table `ms_campaign_form_xref`
--

CREATE TABLE `ms_campaign_form_xref` (
  `campaign_id` int(10) unsigned NOT NULL,
  `form_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`campaign_id`,`form_id`),
  KEY `IDX_A01113105FF69B7D` (`form_id`),
  CONSTRAINT `FK_A01113105FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `ms_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A0111310F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_form_xref`
--


--
-- Table structure for table `ms_campaign_lead_event_failed_log`
--

CREATE TABLE `ms_campaign_lead_event_failed_log` (
  `log_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `reason` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`log_id`),
  KEY `ms_campaign_event_failed_date` (`date_added`),
  CONSTRAINT `FK_82F5282EEA675D86` FOREIGN KEY (`log_id`) REFERENCES `ms_campaign_lead_event_log` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_lead_event_failed_log`
--


--
-- Table structure for table `ms_campaign_lead_event_log`
--

CREATE TABLE `ms_campaign_lead_event_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `campaign_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `rotation` int(11) NOT NULL,
  `date_triggered` datetime DEFAULT NULL,
  `is_scheduled` tinyint(1) NOT NULL,
  `trigger_date` datetime DEFAULT NULL,
  `system_triggered` tinyint(1) NOT NULL,
  `metadata` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `non_action_path_taken` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ms_campaign_rotation` (`event_id`,`lead_id`,`rotation`),
  KEY `IDX_65FA91E971F7E88B` (`event_id`),
  KEY `IDX_65FA91E955458D` (`lead_id`),
  KEY `IDX_65FA91E9F639F774` (`campaign_id`),
  KEY `IDX_65FA91E9A03F5E9F` (`ip_id`),
  KEY `ms_campaign_event_upcoming_search` (`is_scheduled`,`lead_id`),
  KEY `ms_campaign_event_schedule_counts` (`campaign_id`,`is_scheduled`,`trigger_date`),
  KEY `ms_campaign_date_triggered` (`date_triggered`),
  KEY `ms_campaign_leads` (`lead_id`,`campaign_id`,`rotation`),
  KEY `ms_campaign_log_channel` (`channel`,`channel_id`,`lead_id`),
  KEY `ms_campaign_actions` (`campaign_id`,`event_id`,`date_triggered`),
  KEY `ms_campaign_stats` (`campaign_id`,`date_triggered`,`event_id`,`non_action_path_taken`),
  KEY `ms_campaign_trigger_date_order` (`trigger_date`),
  CONSTRAINT `FK_65FA91E955458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_65FA91E971F7E88B` FOREIGN KEY (`event_id`) REFERENCES `ms_campaign_events` (`id`),
  CONSTRAINT `FK_65FA91E9A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_65FA91E9F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_lead_event_log`
--


--
-- Table structure for table `ms_campaign_leadlist_xref`
--

CREATE TABLE `ms_campaign_leadlist_xref` (
  `campaign_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`campaign_id`,`leadlist_id`),
  KEY `IDX_D19FB008B9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_D19FB008B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D19FB008F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_leadlist_xref`
--


--
-- Table structure for table `ms_campaign_leads`
--

CREATE TABLE `ms_campaign_leads` (
  `campaign_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `manually_removed` tinyint(1) NOT NULL,
  `manually_added` tinyint(1) NOT NULL,
  `date_last_exited` datetime DEFAULT NULL,
  `rotation` int(11) NOT NULL,
  PRIMARY KEY (`campaign_id`,`lead_id`),
  KEY `IDX_C257D1F55458D` (`lead_id`),
  KEY `ms_campaign_leads_date_added` (`date_added`),
  KEY `ms_campaign_leads_date_exited` (`date_last_exited`),
  KEY `ms_campaign_leads` (`campaign_id`,`manually_removed`,`lead_id`,`rotation`),
  CONSTRAINT `FK_C257D1F55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C257D1FF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_leads`
--


--
-- Table structure for table `ms_campaign_summary`
--

CREATE TABLE `ms_campaign_summary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `campaign_id` int(10) unsigned DEFAULT NULL,
  `event_id` int(10) unsigned NOT NULL,
  `date_triggered` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `scheduled_count` int(11) NOT NULL,
  `triggered_count` int(11) NOT NULL,
  `non_action_path_taken_count` int(11) NOT NULL,
  `failed_count` int(11) NOT NULL,
  `log_counts_processed` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ms_campaign_event_date_triggered` (`campaign_id`,`event_id`,`date_triggered`),
  KEY `IDX_A3FDF400F639F774` (`campaign_id`),
  KEY `IDX_A3FDF40071F7E88B` (`event_id`),
  CONSTRAINT `FK_A3FDF40071F7E88B` FOREIGN KEY (`event_id`) REFERENCES `ms_campaign_events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A3FDF400F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `ms_campaigns` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaign_summary`
--


--
-- Table structure for table `ms_campaigns`
--

CREATE TABLE `ms_campaigns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `canvas_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `allow_restart` tinyint(1) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT '1',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_E78D226012469DE2` (`category_id`),
  CONSTRAINT `FK_E78D226012469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_campaigns`
--


--
-- Table structure for table `ms_categories`
--

CREATE TABLE `ms_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `ms_category_alias_search` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_categories`
--


--
-- Table structure for table `ms_channel_url_trackables`
--

CREATE TABLE `ms_channel_url_trackables` (
  `channel_id` int(11) NOT NULL,
  `redirect_id` bigint(20) unsigned NOT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL,
  PRIMARY KEY (`redirect_id`,`channel_id`),
  KEY `ms_channel_url_trackable_search` (`channel`,`channel_id`),
  CONSTRAINT `FK_9A9E113BB42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `ms_page_redirects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_channel_url_trackables`
--


--
-- Table structure for table `ms_companies`
--

CREATE TABLE `ms_companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_cache` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `score` int(11) DEFAULT NULL,
  `companyemail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyaddress1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyaddress2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyphone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companycity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companystate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyzipcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companycountry` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companywebsite` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyindustry` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companydescription` longtext COLLATE utf8mb4_unicode_ci,
  `companynumber_of_employees` double DEFAULT NULL,
  `companyfax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companyannual_revenue` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_86BAFC2A7E3C61F9` (`owner_id`),
  KEY `companynumber_of_employees_search` (`companynumber_of_employees`),
  KEY `companyfax_search` (`companyfax`),
  KEY `companyannual_revenue_search` (`companyannual_revenue`),
  KEY `company_filter` (`companyname`,`companyemail`),
  KEY `company_match` (`companyname`,`companycity`,`companycountry`,`companystate`),
  CONSTRAINT `FK_86BAFC2A7E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `ms_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_companies`
--


--
-- Table structure for table `ms_companies_leads`
--

CREATE TABLE `ms_companies_leads` (
  `company_id` int(11) NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `is_primary` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`company_id`,`lead_id`),
  KEY `IDX_212CFB0E55458D` (`lead_id`),
  CONSTRAINT `FK_212CFB0E55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_212CFB0E979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `ms_companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_companies_leads`
--


--
-- Table structure for table `ms_contact_export_scheduler`
--

CREATE TABLE `ms_contact_export_scheduler` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `scheduled_datetime` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `data` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_7215D104A76ED395` (`user_id`),
  CONSTRAINT `FK_7215D104A76ED395` FOREIGN KEY (`user_id`) REFERENCES `ms_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_contact_export_scheduler`
--


--
-- Table structure for table `ms_contact_merge_records`
--

CREATE TABLE `ms_contact_merge_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contact_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `merged_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_16CEE502E7A1254A` (`contact_id`),
  KEY `ms_contact_merge_date_added` (`date_added`),
  KEY `ms_contact_merge_ids` (`merged_id`),
  CONSTRAINT `FK_16CEE502E7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_contact_merge_records`
--


--
-- Table structure for table `ms_dynamic_content`
--

CREATE TABLE `ms_dynamic_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `translation_parent_id` int(10) unsigned DEFAULT NULL,
  `variant_parent_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `sent_count` int(11) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `utm_tags` json DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `filters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `is_campaign_based` tinyint(1) NOT NULL DEFAULT '1',
  `slot_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_F58C2F0A12469DE2` (`category_id`),
  KEY `IDX_F58C2F0A9091A2FB` (`translation_parent_id`),
  KEY `IDX_F58C2F0A91861123` (`variant_parent_id`),
  KEY `ms_is_campaign_based_index` (`is_campaign_based`),
  KEY `ms_slot_name_index` (`slot_name`),
  CONSTRAINT `FK_F58C2F0A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_F58C2F0A9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `ms_dynamic_content` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F58C2F0A91861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `ms_dynamic_content` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_dynamic_content`
--


--
-- Table structure for table `ms_dynamic_content_lead_data`
--

CREATE TABLE `ms_dynamic_content_lead_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `dynamic_content_id` int(10) unsigned DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `slot` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_79214FF455458D` (`lead_id`),
  KEY `IDX_79214FF4D9D0CD7` (`dynamic_content_id`),
  CONSTRAINT `FK_79214FF455458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_79214FF4D9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `ms_dynamic_content` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_dynamic_content_lead_data`
--


--
-- Table structure for table `ms_dynamic_content_stats`
--

CREATE TABLE `ms_dynamic_content_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dynamic_content_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `sent_count` int(11) DEFAULT NULL,
  `last_sent` datetime DEFAULT NULL,
  `sent_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_2BF5A83DD9D0CD7` (`dynamic_content_id`),
  KEY `IDX_2BF5A83D55458D` (`lead_id`),
  KEY `ms_stat_dynamic_content_search` (`dynamic_content_id`,`lead_id`),
  KEY `ms_stat_dynamic_content_source_search` (`source`,`source_id`),
  KEY `ms_stat_dynamic_content_date_sent` (`date_sent`),
  CONSTRAINT `FK_2BF5A83D55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2BF5A83DD9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `ms_dynamic_content` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_dynamic_content_stats`
--


--
-- Table structure for table `ms_email_assets_xref`
--

CREATE TABLE `ms_email_assets_xref` (
  `email_id` int(10) unsigned NOT NULL,
  `asset_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`email_id`,`asset_id`),
  KEY `IDX_2C9764775DA1941` (`asset_id`),
  CONSTRAINT `FK_2C9764775DA1941` FOREIGN KEY (`asset_id`) REFERENCES `ms_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2C976477A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_assets_xref`
--


--
-- Table structure for table `ms_email_copies`
--

CREATE TABLE `ms_email_copies` (
  `id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci,
  `body_text` longtext COLLATE utf8mb4_unicode_ci,
  `subject` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_copies`
--


--
-- Table structure for table `ms_email_list_excluded`
--

CREATE TABLE `ms_email_list_excluded` (
  `email_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`email_id`,`leadlist_id`),
  KEY `IDX_574BA04B9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_574BA04A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_574BA04B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_list_excluded`
--


--
-- Table structure for table `ms_email_list_xref`
--

CREATE TABLE `ms_email_list_xref` (
  `email_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`email_id`,`leadlist_id`),
  KEY `IDX_FB1101A4B9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_FB1101A4A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_FB1101A4B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_list_xref`
--


--
-- Table structure for table `ms_email_stat_replies`
--

CREATE TABLE `ms_email_stat_replies` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
  `stat_id` bigint(20) unsigned NOT NULL,
  `date_replied` datetime NOT NULL,
  `message_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_81B04D429502F0B` (`stat_id`),
  KEY `ms_email_replies` (`stat_id`,`message_id`),
  KEY `ms_date_email_replied` (`date_replied`),
  CONSTRAINT `FK_81B04D429502F0B` FOREIGN KEY (`stat_id`) REFERENCES `ms_email_stats` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_stat_replies`
--


--
-- Table structure for table `ms_email_stats`
--

CREATE TABLE `ms_email_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `list_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `copy_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_sent` datetime NOT NULL,
  `is_read` tinyint(1) NOT NULL,
  `is_failed` tinyint(1) NOT NULL,
  `viewed_in_browser` tinyint(1) NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `open_count` int(11) DEFAULT NULL,
  `last_opened` datetime DEFAULT NULL,
  `open_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `generated_sent_date` date GENERATED ALWAYS AS (concat(year(`date_sent`),'-',lpad(month(`date_sent`),2,'0'),'-',lpad(dayofmonth(`date_sent`),2,'0'))) VIRTUAL COMMENT '(DC2Type:generated)',
  PRIMARY KEY (`id`),
  KEY `IDX_2C0C44BA832C1C9` (`email_id`),
  KEY `IDX_2C0C44B55458D` (`lead_id`),
  KEY `IDX_2C0C44B3DAE168B` (`list_id`),
  KEY `IDX_2C0C44BA03F5E9F` (`ip_id`),
  KEY `IDX_2C0C44BA8752772` (`copy_id`),
  KEY `ms_stat_email_search` (`email_id`,`lead_id`),
  KEY `ms_stat_email_search2` (`lead_id`,`email_id`),
  KEY `ms_stat_email_failed_search` (`is_failed`),
  KEY `ms_is_read_date_sent` (`is_read`,`date_sent`),
  KEY `ms_stat_email_hash_search` (`tracking_hash`),
  KEY `ms_stat_email_source_search` (`source`,`source_id`),
  KEY `ms_email_date_sent` (`date_sent`),
  KEY `ms_email_date_read_lead` (`date_read`,`lead_id`),
  KEY `ms_stat_email_lead_id_date_sent` (`lead_id`,`date_sent`),
  KEY `ms_stat_email_email_id_is_read` (`email_id`,`is_read`),
  KEY `ms_generated_sent_date_email_id` (`generated_sent_date`,`email_id`),
  CONSTRAINT `FK_2C0C44B3DAE168B` FOREIGN KEY (`list_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2C0C44B55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2C0C44BA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2C0C44BA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2C0C44BA8752772` FOREIGN KEY (`copy_id`) REFERENCES `ms_email_copies` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_stats`
--


--
-- Table structure for table `ms_email_stats_devices`
--

CREATE TABLE `ms_email_stats_devices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `device_id` bigint(20) unsigned DEFAULT NULL,
  `stat_id` bigint(20) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_opened` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_42C2871094A4C7D4` (`device_id`),
  KEY `IDX_42C287109502F0B` (`stat_id`),
  KEY `IDX_42C28710A03F5E9F` (`ip_id`),
  KEY `ms_date_opened_search` (`date_opened`),
  CONSTRAINT `FK_42C2871094A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `ms_lead_devices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_42C287109502F0B` FOREIGN KEY (`stat_id`) REFERENCES `ms_email_stats` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_42C28710A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_email_stats_devices`
--


--
-- Table structure for table `ms_emails`
--

CREATE TABLE `ms_emails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `translation_parent_id` int(10) unsigned DEFAULT NULL,
  `variant_parent_id` int(10) unsigned DEFAULT NULL,
  `unsubscribeform_id` int(10) unsigned DEFAULT NULL,
  `preference_center_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `subject` longtext COLLATE utf8mb4_unicode_ci,
  `preheader_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reply_to_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bcc_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `use_owner_as_mailer` tinyint(1) DEFAULT NULL,
  `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `plain_text` longtext COLLATE utf8mb4_unicode_ci,
  `custom_html` longtext COLLATE utf8mb4_unicode_ci,
  `email_type` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `read_count` int(11) NOT NULL,
  `sent_count` int(11) NOT NULL,
  `variant_sent_count` int(11) NOT NULL,
  `variant_read_count` int(11) NOT NULL,
  `revision` int(11) NOT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `dynamic_content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `headers` json NOT NULL,
  `public_preview` tinyint(1) DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_4124348112469DE2` (`category_id`),
  KEY `IDX_412434819091A2FB` (`translation_parent_id`),
  KEY `IDX_4124348191861123` (`variant_parent_id`),
  KEY `IDX_412434812DC494F6` (`unsubscribeform_id`),
  KEY `IDX_41243481834F9C5B` (`preference_center_id`),
  CONSTRAINT `FK_4124348112469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_412434812DC494F6` FOREIGN KEY (`unsubscribeform_id`) REFERENCES `ms_forms` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_41243481834F9C5B` FOREIGN KEY (`preference_center_id`) REFERENCES `ms_pages` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_412434819091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4124348191861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `ms_emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_emails`
--

INSERT INTO `ms_emails` VALUES (1,NULL,NULL,NULL,NULL,NULL,1,'2025-05-20 12:19:58',1,'kulvir Kaur','2025-05-20 12:19:58',1,'kulvir Kaur',NULL,NULL,'kulvir Kaur','test',NULL,'test',NULL,'test@test.com','Test',NULL,NULL,0,'_1-2-1-2-column','a:0:{}','a:4:{s:9:\"utmSource\";N;s:9:\"utmMedium\";N;s:11:\"utmCampaign\";N;s:10:\"utmContent\";N;}',NULL,'<!doctype html>\r\n<html lang=\"und\" dir=\"auto\" xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\">\r\n\r\n<head>\r\n  <title></title>\r\n  <!--[if !mso]><!-->\r\n  <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n  <!--<![endif]-->\r\n  <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n  <style type=\"text/css\">\r\n    #outlook a {\r\n      padding: 0;\r\n    }\r\n\r\n    body {\r\n      margin: 0;\r\n      padding: 0;\r\n      -webkit-text-size-adjust: 100%;\r\n      -ms-text-size-adjust: 100%;\r\n    }\r\n\r\n    table,\r\n    td {\r\n      border-collapse: collapse;\r\n      mso-table-lspace: 0pt;\r\n      mso-table-rspace: 0pt;\r\n    }\r\n\r\n    img {\r\n      border: 0;\r\n      height: auto;\r\n      line-height: 100%;\r\n      outline: none;\r\n      text-decoration: none;\r\n      -ms-interpolation-mode: bicubic;\r\n    }\r\n\r\n    p {\r\n      display: block;\r\n      margin: 13px 0;\r\n    }\r\n  </style>\r\n  <!--[if mso]>\r\n    <noscript>\r\n    <xml>\r\n    <o:OfficeDocumentSettings>\r\n      <o:AllowPNG/>\r\n      <o:PixelsPerInch>96</o:PixelsPerInch>\r\n    </o:OfficeDocumentSettings>\r\n    </xml>\r\n    </noscript>\r\n    <![endif]-->\r\n  <!--[if lte mso 11]>\r\n    <style type=\"text/css\">\r\n      .mj-outlook-group-fix { width:100% !important; }\r\n    </style>\r\n    <![endif]-->\r\n  <!--[if !mso]><!-->\r\n  <link href=\"https://fonts.googleapis.com/css?family=Ubuntu:300,400,500,700\" rel=\"stylesheet\" type=\"text/css\">\r\n  <style type=\"text/css\">\r\n    @import url(https://fonts.googleapis.com/css?family=Ubuntu:300,400,500,700);\r\n  </style>\r\n  <!--<![endif]-->\r\n  <style type=\"text/css\">\r\n    @media only screen and (min-width:480px) {\r\n      .mj-column-per-100 {\r\n        width: 100% !important;\r\n        max-width: 100%;\r\n      }\r\n\r\n      .mj-column-px-550 {\r\n        width: 550px !important;\r\n        max-width: 550px;\r\n      }\r\n\r\n      .mj-column-px-275 {\r\n        width: 275px !important;\r\n        max-width: 275px;\r\n      }\r\n    }\r\n  </style>\r\n  <style media=\"screen and (min-width:480px)\">\r\n    .moz-text-html .mj-column-per-100 {\r\n      width: 100% !important;\r\n      max-width: 100%;\r\n    }\r\n\r\n    .moz-text-html .mj-column-px-550 {\r\n      width: 550px !important;\r\n      max-width: 550px;\r\n    }\r\n\r\n    .moz-text-html .mj-column-px-275 {\r\n      width: 275px !important;\r\n      max-width: 275px;\r\n    }\r\n  </style>\r\n  <style type=\"text/css\">\r\n    @media only screen and (max-width:479px) {\r\n      table.mj-full-width-mobile {\r\n        width: 100% !important;\r\n      }\r\n\r\n      td.mj-full-width-mobile {\r\n        width: auto !important;\r\n      }\r\n    }\r\n  </style>\r\n  <!-- CSS-STYLE -->\r\n</head>\r\n\r\n<body style=\"word-spacing:normal;background-color:#d0d0d0;\">\r\n  <div style=\"background-color:#d0d0d0;\" lang=\"und\" dir=\"auto\">\r\n    <!--[if mso | IE]><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#ffffff\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#ffffff;background-color:#ffffff;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#ffffff;background-color:#ffffff;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:600px;\" ><![endif]-->\r\n              <div class=\"mj-column-per-100 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:11px;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\"><span data-fr-verified=\"true\"><span data-fr-verified=\"true\" class=\"atwho-inserted\">{webview_text}</span>⁠⁠⁠⁠⁠⁠⁠</span></p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;padding-top:0px;padding-bottom:0px;word-break:break-word;\">\r\n                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"border-collapse:collapse;border-spacing:0px;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"width:550px;\">\r\n                                <img alt src=\"https://mauticsystem.urtestsite.com/media/images/maxresdefault.jpg\" style=\"border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px;\" width=\"550\" height=\"auto\">\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#ffffff\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#ffffff;background-color:#ffffff;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#ffffff;background-color:#ffffff;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:550px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-550 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:30px;font-weight:700;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Hi <span data-fr-verified=\"true\"><span class=\"atwho-inserted\" data-fr-verified=\"true\">{contactfield=firstname}</span>&nbsp;</span></p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:16px;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\"><span data-fr-verified=\"true\">welcome to <span class=\"atwho-inserted\" data-fr-verified=\"true\">{brand=name}</span>&nbsp;</span></p>\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\"><span data-fr-verified=\"true\">date is: <span class=\"atwho-inserted\" data-fr-verified=\"true\">{today}</span></span></p>\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\"><a href=\"https://ttrack.link.com/?i={contactfield=id}\"><span data-fr-verified=\"true\">click here</span></a></p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#f4f4f4\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#f4f4f4;background-color:#f4f4f4;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#f4f4f4;background-color:#f4f4f4;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:275px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-275 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:22px;font-weight:700;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Rami Avital</p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:16px;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Share a story about your company, team, or production process.  </p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"left\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:13px;line-height:1;text-align:left;color:#000000;\">{dynamiccontent=\"Dynamic Content 2\"}</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td><td class=\"\" style=\"vertical-align:top;width:275px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-275 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"border-collapse:collapse;border-spacing:0px;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"width:225px;\">\r\n                                <img alt src=\"https://mauticsystem.urtestsite.com/media/images/1715757576075.jfif\" style=\"border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px;\" width=\"225\" height=\"auto\">\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#ffffff\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#ffffff;background-color:#ffffff;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#ffffff;background-color:#ffffff;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:550px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-550 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:16px;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">You can also encourage readers to subscribe to your newsletter. Briefly explain what kind of content they can expect and how often. </p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#f4f4f4\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#f4f4f4;background-color:#f4f4f4;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#f4f4f4;background-color:#f4f4f4;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:275px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-275 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"border-collapse:collapse;border-spacing:0px;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"width:225px;\">\r\n                                <img alt src=\"/app/assets/images/placeholder-image.png?v9446ae26\" style=\"border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px;\" width=\"225\" height=\"auto\">\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td><td class=\"\" style=\"vertical-align:top;width:275px;\" ><![endif]-->\r\n              <div class=\"mj-column-px-275 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:22px;font-weight:700;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Inverse column title </p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:16px;line-height:1;text-align:center;color:#000000;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Keep it brief but engaging. </p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"\" role=\"presentation\" style=\"width:600px;\" width=\"600\" bgcolor=\"#000000\" ><tr><td style=\"line-height:0px;font-size:0px;mso-line-height-rule:exactly;\"><![endif]-->\r\n    <div style=\"background:#000000;background-color:#000000;margin:0px auto;max-width:600px;\">\r\n      <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#000000;background-color:#000000;width:100%;\">\r\n        <tbody>\r\n          <tr>\r\n            <td style=\"direction:ltr;font-size:0px;padding:20px 0;padding-top:0;text-align:center;\">\r\n              <!--[if mso | IE]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"\" style=\"vertical-align:top;width:600px;\" ><![endif]-->\r\n              <div class=\"mj-column-per-100 mj-outlook-group-fix\" style=\"font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%;\">\r\n                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"vertical-align:top;\" width=\"100%\">\r\n                  <tbody>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <!--[if mso | IE]><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" ><tr><td><![endif]-->\r\n                        <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"float:none;display:inline-table;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"padding:4px;padding-right:10px;vertical-align:middle;\">\r\n                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#000000;border-radius:14px 14px 14px 14px;width:30px;\">\r\n                                  <tbody>\r\n                                    <tr>\r\n                                      <td style=\"font-size:0;height:30px;vertical-align:middle;width:30px;\">\r\n                                        <img alt height=\"30\" src=\"https://www.mailjet.com/images/theme/v1/icons/ico-social/facebook.png\" style=\"border-radius:14px 14px 14px 14px;display:block;\" width=\"30\">\r\n                                      </td>\r\n                                    </tr>\r\n                                  </tbody>\r\n                                </table>\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                        <!--[if mso | IE]></td><td><![endif]-->\r\n                        <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"float:none;display:inline-table;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"padding:4px;padding-right:10px;padding-left:10px;vertical-align:middle;\">\r\n                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#000000;border-radius:14px 14px 14px 14px;width:30px;\">\r\n                                  <tbody>\r\n                                    <tr>\r\n                                      <td style=\"font-size:0;height:30px;vertical-align:middle;width:30px;\">\r\n                                        <img alt height=\"30\" src=\"https://www.mailjet.com/images/theme/v1/icons/ico-social/instagram.png\" style=\"border-radius:14px 14px 14px 14px;display:block;\" width=\"30\">\r\n                                      </td>\r\n                                    </tr>\r\n                                  </tbody>\r\n                                </table>\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                        <!--[if mso | IE]></td><td><![endif]-->\r\n                        <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"float:none;display:inline-table;\">\r\n                          <tbody>\r\n                            <tr>\r\n                              <td style=\"padding:4px;padding-left:10px;vertical-align:middle;\">\r\n                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" role=\"presentation\" style=\"background:#000000;border-radius:14px 14px 14px 14px;width:30px;\">\r\n                                  <tbody>\r\n                                    <tr>\r\n                                      <td style=\"font-size:0;height:30px;vertical-align:middle;width:30px;\">\r\n                                        <img alt height=\"30\" src=\"https://www.mailjet.com/images/theme/v1/icons/ico-social/youtube.png\" style=\"border-radius:14px 14px 14px 14px;display:block;\" width=\"30\">\r\n                                      </td>\r\n                                    </tr>\r\n                                  </tbody>\r\n                                </table>\r\n                              </td>\r\n                            </tr>\r\n                          </tbody>\r\n                        </table>\r\n                        <!--[if mso | IE]></td></tr></table><![endif]-->\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;padding-top:0px;padding-bottom:0px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:12px;line-height:1.5;text-align:center;color:#ffffff;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">{brand=name} <br>11111 Beautiful City, 1212 Nice Street <br>Brazil <br></p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:11px;line-height:1;text-align:center;color:#b3b3b3;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Fancy seeing you down here. You’re getting this email because you gave us your email address. </p>\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\">Want to change how you receive these emails? </p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td align=\"center\" style=\"font-size:0px;padding:10px 25px;word-break:break-word;\">\r\n                        <div style=\"font-family:Ubuntu, Helvetica, Arial, sans-serif;font-size:11px;line-height:1;text-align:center;color:#b3b3b3;\">\r\n                          <p style=\"padding: 0; line-height: 1.4em; margin: 0;\"><span data-fr-verified=\"true\"><span data-fr-verified=\"true\" class=\"atwho-inserted\">{unsubscribe_text}</span>⁠⁠⁠⁠⁠⁠⁠</span></p>\r\n                        </div>\r\n                      </td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td style=\"font-size:0px;word-break:break-word;\">\r\n                        <div style=\"height:20px;line-height:20px;\">&#8202;</div>\r\n                      </td>\r\n                    </tr>\r\n                  </tbody>\r\n                </table>\r\n              </div>\r\n              <!--[if mso | IE]></td></tr></table><![endif]-->\r\n            </td>\r\n          </tr>\r\n        </tbody>\r\n      </table>\r\n    </div>\r\n    <!--[if mso | IE]></td></tr></table><![endif]-->\r\n  </div>\r\n</body>\r\n\r\n</html>','template',NULL,NULL,0,0,0,0,4,'en','a:0:{}',NULL,'a:2:{i:0;a:3:{s:9:\"tokenName\";s:17:\"Dynamic Content 1\";s:7:\"content\";s:30:\"<p>Default Dynamic Content</p>\";s:7:\"filters\";a:1:{i:0;a:2:{s:7:\"content\";N;s:7:\"filters\";a:0:{}}}}i:1;a:3:{s:9:\"tokenName\";s:17:\"Dynamic Content 2\";s:7:\"content\";s:18:\"<p>Hello&nbsp;</p>\";s:7:\"filters\";a:1:{i:0;a:2:{s:7:\"content\";s:17:\"<p>Ciao&nbsp;</p>\";s:7:\"filters\";a:1:{i:0;a:7:{s:4:\"glue\";s:3:\"and\";s:5:\"field\";s:16:\"preferred_locale\";s:6:\"object\";s:4:\"lead\";s:4:\"type\";s:6:\"locale\";s:6:\"filter\";s:2:\"it\";s:7:\"display\";N;s:8:\"operator\";s:1:\"=\";}}}}}}','[]',0,'e6576c65-db8e-4211-aaf2-a492d568698f');

--
-- Table structure for table `ms_emails_draft`
--

CREATE TABLE `ms_emails_draft` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email_id` int(10) unsigned NOT NULL,
  `html` longtext COLLATE utf8mb4_unicode_ci,
  `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_preview` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_13017CADA832C1C9` (`email_id`),
  CONSTRAINT `FK_13017CADA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_emails_draft`
--


--
-- Table structure for table `ms_focus`
--

CREATE TABLE `ms_focus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `focus_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `style` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `form_id` int(11) DEFAULT NULL,
  `cache` longtext COLLATE utf8mb4_unicode_ci,
  `html_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `editor` longtext COLLATE utf8mb4_unicode_ci,
  `html` longtext COLLATE utf8mb4_unicode_ci,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_AA76A76312469DE2` (`category_id`),
  KEY `ms_focus_type` (`focus_type`),
  KEY `ms_focus_style` (`style`),
  KEY `ms_focus_form` (`form_id`),
  KEY `ms_focus_name` (`name`),
  CONSTRAINT `FK_AA76A76312469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_focus`
--


--
-- Table structure for table `ms_focus_stats`
--

CREATE TABLE `ms_focus_stats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `focus_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_id` int(11) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BA392B251804B42` (`focus_id`),
  KEY `IDX_BA392B255458D` (`lead_id`),
  KEY `ms_focus_type` (`type`),
  KEY `ms_focus_type_id` (`type`,`type_id`),
  KEY `ms_focus_date_added` (`date_added`),
  CONSTRAINT `FK_BA392B251804B42` FOREIGN KEY (`focus_id`) REFERENCES `ms_focus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_BA392B255458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_focus_stats`
--


--
-- Table structure for table `ms_form_actions`
--

CREATE TABLE `ms_form_actions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_order` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_9EE617695FF69B7D` (`form_id`),
  KEY `ms_form_action_type_search` (`type`),
  CONSTRAINT `FK_9EE617695FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `ms_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_form_actions`
--


--
-- Table structure for table `ms_form_fields`
--

CREATE TABLE `ms_form_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(10) unsigned NOT NULL,
  `label` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `show_label` tinyint(1) DEFAULT NULL,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_custom` tinyint(1) NOT NULL,
  `custom_parameters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `default_value` longtext COLLATE utf8mb4_unicode_ci,
  `is_required` tinyint(1) NOT NULL,
  `validation_message` longtext COLLATE utf8mb4_unicode_ci,
  `help_message` longtext COLLATE utf8mb4_unicode_ci,
  `field_order` int(11) DEFAULT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `validation` json DEFAULT NULL,
  `parent_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conditions` json DEFAULT NULL,
  `label_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `container_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lead_field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `save_result` tinyint(1) DEFAULT NULL,
  `is_auto_fill` tinyint(1) DEFAULT NULL,
  `is_read_only` tinyint(1) NOT NULL DEFAULT '0',
  `show_when_value_exists` tinyint(1) DEFAULT NULL,
  `show_after_x_submissions` int(11) DEFAULT NULL,
  `always_display` tinyint(1) DEFAULT NULL,
  `mapped_object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mapped_field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_B4C1D5485FF69B7D` (`form_id`),
  KEY `ms_form_field_type_search` (`type`),
  CONSTRAINT `FK_B4C1D5485FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `ms_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_form_fields`
--


--
-- Table structure for table `ms_form_submissions`
--

CREATE TABLE `ms_form_submissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(10) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `page_id` int(10) unsigned DEFAULT NULL,
  `tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_submitted` datetime NOT NULL,
  `referer` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D65F7A95FF69B7D` (`form_id`),
  KEY `IDX_D65F7A9A03F5E9F` (`ip_id`),
  KEY `IDX_D65F7A955458D` (`lead_id`),
  KEY `IDX_D65F7A9C4663E4` (`page_id`),
  KEY `ms_form_submission_tracking_search` (`tracking_id`),
  KEY `ms_form_date_submitted` (`date_submitted`),
  CONSTRAINT `FK_D65F7A955458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_D65F7A95FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `ms_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D65F7A9A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_D65F7A9C4663E4` FOREIGN KEY (`page_id`) REFERENCES `ms_pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_form_submissions`
--


--
-- Table structure for table `ms_forms`
--

CREATE TABLE `ms_forms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cached_html` longtext COLLATE utf8mb4_unicode_ci,
  `post_action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_action_property` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `in_kiosk_mode` tinyint(1) DEFAULT NULL,
  `render_style` tinyint(1) DEFAULT NULL,
  `form_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_index` tinyint(1) DEFAULT NULL,
  `progressive_profiling_limit` int(11) DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_3589F67D12469DE2` (`category_id`),
  CONSTRAINT `FK_3589F67D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_forms`
--


--
-- Table structure for table `ms_imports`
--

CREATE TABLE `ms_imports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `line_count` int(11) NOT NULL,
  `inserted_count` int(11) NOT NULL,
  `updated_count` int(11) NOT NULL,
  `ignored_count` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `date_started` datetime DEFAULT NULL,
  `date_ended` datetime DEFAULT NULL,
  `object` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `properties` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ms_import_object` (`object`),
  KEY `ms_import_status` (`status`),
  KEY `ms_import_priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_imports`
--


--
-- Table structure for table `ms_integration_entity`
--

CREATE TABLE `ms_integration_entity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_added` datetime NOT NULL,
  `integration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_entity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_entity_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `internal_entity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `internal_entity_id` int(11) DEFAULT NULL,
  `last_sync_date` datetime DEFAULT NULL,
  `internal` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `ms_integration_external_entity` (`integration`,`integration_entity`,`integration_entity_id`),
  KEY `ms_integration_internal_entity` (`integration`,`internal_entity`,`internal_entity_id`),
  KEY `ms_integration_entity_match` (`integration`,`internal_entity`,`integration_entity`),
  KEY `ms_integration_last_sync_date` (`integration`,`last_sync_date`),
  KEY `ms_internal_integration_entity` (`internal_entity_id`,`integration_entity_id`,`internal_entity`,`integration_entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_integration_entity`
--


--
-- Table structure for table `ms_ip_addresses`
--

CREATE TABLE `ms_ip_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `ms_ip_search` (`ip_address`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_ip_addresses`
--

INSERT INTO `ms_ip_addresses` VALUES (1,'159.223.19.225','a:10:{s:4:\"city\";s:0:\"\";s:6:\"region\";s:0:\"\";s:7:\"zipcode\";s:0:\"\";s:7:\"country\";s:0:\"\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:3:\"isp\";s:0:\"\";s:12:\"organization\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:5:\"extra\";s:0:\"\";}'),(2,'159.223.19.225','a:10:{s:4:\"city\";s:0:\"\";s:6:\"region\";s:0:\"\";s:7:\"zipcode\";s:0:\"\";s:7:\"country\";s:0:\"\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:3:\"isp\";s:0:\"\";s:12:\"organization\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:5:\"extra\";s:0:\"\";}'),(3,'159.223.19.225','a:10:{s:4:\"city\";s:0:\"\";s:6:\"region\";s:0:\"\";s:7:\"zipcode\";s:0:\"\";s:7:\"country\";s:0:\"\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:3:\"isp\";s:0:\"\";s:12:\"organization\";s:0:\"\";s:8:\"timezone\";s:0:\"\";s:5:\"extra\";s:0:\"\";}');

--
-- Table structure for table `ms_lead_categories`
--

CREATE TABLE `ms_lead_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `manually_removed` tinyint(1) NOT NULL,
  `manually_added` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C75DAC4C12469DE2` (`category_id`),
  KEY `IDX_C75DAC4C55458D` (`lead_id`),
  CONSTRAINT `FK_C75DAC4C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C75DAC4C55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_categories`
--


--
-- Table structure for table `ms_lead_companies_change_log`
--

CREATE TABLE `ms_lead_companies_change_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `type` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_884EA5F455458D` (`lead_id`),
  KEY `ms_company_date_added` (`date_added`),
  CONSTRAINT `FK_884EA5F455458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_companies_change_log`
--


--
-- Table structure for table `ms_lead_devices`
--

CREATE TABLE `ms_lead_devices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `client_info` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `device` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_os_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_os_shortname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_os_version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_os_platform` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_brand` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E20B94497D05ABBE` (`tracking_id`),
  KEY `IDX_E20B944955458D` (`lead_id`),
  KEY `ms_date_added_search` (`date_added`),
  KEY `ms_device_search` (`device`),
  KEY `ms_device_os_name_search` (`device_os_name`),
  KEY `ms_device_os_shortname_search` (`device_os_shortname`),
  KEY `ms_device_os_version_search` (`device_os_version`),
  KEY `ms_device_os_platform_search` (`device_os_platform`),
  KEY `ms_device_brand_search` (`device_brand`),
  KEY `ms_device_model_search` (`device_model`),
  CONSTRAINT `FK_E20B944955458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_devices`
--

INSERT INTO `ms_lead_devices` VALUES (1,1,'2025-05-21 07:24:11','a:7:{s:4:\"type\";s:7:\"browser\";s:4:\"name\";s:6:\"Chrome\";s:10:\"short_name\";s:2:\"CH\";s:7:\"version\";s:4:\"58.0\";s:6:\"engine\";s:5:\"Blink\";s:14:\"engine_version\";s:0:\"\";s:6:\"family\";s:6:\"Chrome\";}','desktop','Windows','WIN','10','x64','','','uw5w18fwvl3z6pbsxdsrujx'),(2,2,'2025-05-21 07:24:11','a:7:{s:4:\"type\";s:7:\"browser\";s:4:\"name\";s:6:\"Safari\";s:10:\"short_name\";s:2:\"SF\";s:7:\"version\";s:4:\"17.5\";s:6:\"engine\";s:6:\"WebKit\";s:14:\"engine_version\";s:8:\"605.1.15\";s:6:\"family\";s:6:\"Safari\";}','desktop','Mac','MAC','10.15','','Apple','','89fukj8hughxxmekef88mig'),(3,3,'2025-05-21 07:24:11','a:7:{s:4:\"type\";s:7:\"browser\";s:4:\"name\";s:6:\"Safari\";s:10:\"short_name\";s:2:\"SF\";s:7:\"version\";s:4:\"11.6\";s:6:\"engine\";s:6:\"WebKit\";s:14:\"engine_version\";s:6:\"537.36\";s:6:\"family\";s:6:\"Safari\";}','desktop','Mac','MAC','11.7','','Apple','','c0b4u77pbpd8s1x025p8j02'),(4,4,'2025-05-21 07:24:11','a:7:{s:4:\"type\";s:7:\"browser\";s:4:\"name\";s:14:\"Microsoft Edge\";s:10:\"short_name\";s:2:\"PS\";s:7:\"version\";s:8:\"17.17134\";s:6:\"engine\";s:4:\"Edge\";s:14:\"engine_version\";s:8:\"17.17134\";s:6:\"family\";s:17:\"Internet Explorer\";}','desktop','Windows','WIN','10','x64','','','c2h2z8st632fxkmhkymng8u');

--
-- Table structure for table `ms_lead_donotcontact`
--

CREATE TABLE `ms_lead_donotcontact` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `reason` smallint(6) NOT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `comments` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_977A381255458D` (`lead_id`),
  KEY `ms_leadid_reason_channel` (`lead_id`,`channel`,`reason`),
  KEY `ms_dnc_reason_search` (`reason`),
  KEY `ms_dnc_date_added` (`date_added`),
  CONSTRAINT `FK_977A381255458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_donotcontact`
--


--
-- Table structure for table `ms_lead_event_log`
--

CREATE TABLE `ms_lead_event_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bundle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `properties` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ms_lead_id_index` (`lead_id`),
  KEY `ms_lead_object_index` (`object`,`object_id`),
  KEY `ms_lead_timeline_index` (`bundle`,`object`,`action`,`object_id`),
  KEY `ms_IDX_SEARCH` (`bundle`,`object`,`action`,`object_id`,`date_added`),
  KEY `ms_lead_timeline_action_index` (`action`),
  KEY `ms_lead_date_added_index` (`date_added`),
  CONSTRAINT `FK_52E3F30C55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_event_log`
--

INSERT INTO `ms_lead_event_log` VALUES (1,2,NULL,NULL,'page','hit','created_contact',2,'2025-05-21 07:24:12','{\"object_description\": \"https://mauticsystem.urtestsite.com/hardhat.config.js\"}'),(2,3,NULL,NULL,'page','hit','created_contact',3,'2025-05-21 07:24:12','{\"object_description\": \"https://mauticsystem.urtestsite.com/.git/config\"}'),(3,1,NULL,NULL,'page','hit','created_contact',1,'2025-05-21 07:24:12','{\"object_description\": \"https://mauticsystem.urtestsite.com/auth.json\"}'),(4,4,NULL,NULL,'page','hit','created_contact',4,'2025-05-21 07:24:12','{\"object_description\": \"https://mauticsystem.urtestsite.com/ftpsync.settings\"}');

--
-- Table structure for table `ms_lead_fields`
--

CREATE TABLE `ms_lead_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL,
  `is_fixed` tinyint(1) NOT NULL,
  `is_visible` tinyint(1) NOT NULL,
  `is_short_visible` tinyint(1) NOT NULL DEFAULT '0',
  `is_listable` tinyint(1) NOT NULL,
  `is_publicly_updatable` tinyint(1) NOT NULL,
  `is_unique_identifer` tinyint(1) DEFAULT NULL,
  `is_index` tinyint(1) NOT NULL DEFAULT '0',
  `char_length_limit` int(11) DEFAULT NULL,
  `field_order` int(11) DEFAULT NULL,
  `object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `column_is_not_created` tinyint(1) NOT NULL DEFAULT '0',
  `original_is_published_value` tinyint(1) NOT NULL DEFAULT '0',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `ms_idx_object_field_order_is_published` (`object`,`field_order`,`is_published`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_fields`
--

INSERT INTO `ms_lead_fields` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Title','title','lookup','core',NULL,0,1,1,0,1,0,0,0,64,1,'lead','a:1:{s:4:\"list\";a:3:{i:0;s:2:\"Mr\";i:1;s:3:\"Mrs\";i:2;s:4:\"Miss\";}}',0,0,'8e85b294-6377-49c7-a243-5bfdd3c77e16'),(2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'First Name','firstname','text','core',NULL,0,1,1,1,1,0,0,0,64,2,'lead','a:0:{}',0,0,'f97933ca-241b-4c20-93a8-fa0cb1bf7a33'),(3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Last Name','lastname','text','core',NULL,0,1,1,1,1,0,0,0,64,3,'lead','a:0:{}',0,0,'890c93ad-70de-4ce7-90eb-75bb6ce1bcfb'),(4,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Primary company','company','text','core',NULL,0,1,1,0,1,0,0,0,64,4,'lead','a:0:{}',0,0,'b2ead410-13ed-4af4-8eb7-3a914a4e2a83'),(5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Position','position','text','core',NULL,0,1,1,0,1,0,0,0,64,5,'lead','a:0:{}',0,0,'e6fbde98-4a42-44dc-a198-468b72c5d524'),(6,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Email','email','email','core',NULL,0,1,1,1,1,0,1,1,64,6,'lead','a:0:{}',0,0,'6f113f26-b06e-4b87-bda4-922d7880cbc1'),(7,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mobile','mobile','tel','core',NULL,0,1,1,0,1,0,0,0,64,7,'lead','a:0:{}',0,0,'1b0dbbf6-240d-4ba5-9e6b-39df026542f4'),(8,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phone','phone','tel','core',NULL,0,1,1,0,1,0,0,0,64,8,'lead','a:0:{}',0,0,'36a67748-18b2-48ea-a9cf-5ce3f612b9bb'),(9,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Points','points','number','core','0',0,1,1,0,1,0,0,0,64,9,'lead','a:0:{}',0,0,'3eb6e60b-4f2e-40ee-873c-3037b09d69a1'),(10,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fax','fax','tel','core',NULL,0,0,1,0,1,0,0,0,64,10,'lead','a:0:{}',0,0,'cfb1670e-ff88-4956-97c0-bab297d0aa5f'),(11,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Address Line 1','address1','text','core',NULL,0,1,1,0,1,0,0,0,64,11,'lead','a:0:{}',0,0,'1cf0a216-7245-4768-a549-8d912dd1f24b'),(12,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Address Line 2','address2','text','core',NULL,0,1,1,0,1,0,0,0,64,12,'lead','a:0:{}',0,0,'1f09d957-b045-4eee-912b-3ae88149d909'),(13,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'City','city','text','core',NULL,0,1,1,0,1,0,0,0,64,13,'lead','a:0:{}',0,0,'676a40fd-c8d6-49d6-80d3-97b2a3d0d1cf'),(14,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'State','state','region','core',NULL,0,1,1,0,1,0,0,0,64,14,'lead','a:0:{}',0,0,'9c37edf8-d82f-4902-bb6b-f584fdb9cb78'),(15,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Zip Code','zipcode','text','core',NULL,0,1,1,0,1,0,0,0,64,15,'lead','a:0:{}',0,0,'d9c10d07-e13e-44a6-b379-0a713a4300b1'),(16,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Country','country','country','core',NULL,0,1,1,0,1,0,0,0,64,16,'lead','a:0:{}',0,0,'690df744-0e66-4cfa-8a34-12752ccd598c'),(17,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Preferred Locale','preferred_locale','locale','core',NULL,0,1,1,0,1,0,0,0,64,17,'lead','a:0:{}',0,0,'75da967f-e6b9-4657-b686-6ef854755ac0'),(18,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Preferred Timezone','timezone','timezone','core',NULL,0,1,1,0,1,0,0,0,64,18,'lead','a:0:{}',0,0,'18eb4959-aa7a-47fa-9f96-0aa6286dc674'),(19,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Date Last Active','last_active','datetime','core',NULL,0,1,1,0,1,0,0,0,64,19,'lead','a:0:{}',0,0,'12b2d458-a380-493e-8d03-00cb1fbdc8c0'),(20,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Attribution Date','attribution_date','datetime','core',NULL,0,1,1,0,1,0,0,0,64,20,'lead','a:0:{}',0,0,'c16e4f6d-c247-4ec8-94e1-91ac08b113ab'),(21,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Attribution','attribution','number','core',NULL,0,1,1,0,1,0,0,0,64,21,'lead','a:2:{s:9:\"roundmode\";i:4;s:5:\"scale\";i:2;}',0,0,'cc7a5df8-8755-463d-bf7a-efca67a14b8a'),(22,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Website','website','url','core',NULL,0,0,1,0,1,0,0,0,64,22,'lead','a:0:{}',0,0,'0437a757-13b7-4c40-9f5b-a97167d207b0'),(23,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Facebook','facebook','text','social',NULL,0,0,1,0,1,0,0,0,64,23,'lead','a:0:{}',0,0,'35667647-d060-4e91-84d8-1e3f352f7070'),(24,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Foursquare','foursquare','text','social',NULL,0,0,1,0,1,0,0,0,64,24,'lead','a:0:{}',0,0,'3cb2f4c8-bc38-41b5-92e8-92e5daa1a452'),(25,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Instagram','instagram','text','social',NULL,0,0,1,0,1,0,0,0,64,25,'lead','a:0:{}',0,0,'ee1ea83b-56be-4914-a36a-5941649738d7'),(26,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mautic.lead.field.linkedin','linkedin','text','social',NULL,0,0,1,0,1,0,0,0,64,26,'lead','a:0:{}',0,0,'5b18763a-f4fb-42ac-8fe2-691f525f7a1c'),(27,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Skype','skype','text','social',NULL,0,0,1,0,1,0,0,0,64,27,'lead','a:0:{}',0,0,'e67eb871-e6e2-4aa8-9bff-93bdd6f4b709'),(28,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Twitter','twitter','text','social',NULL,0,0,1,0,1,0,0,0,64,28,'lead','a:0:{}',0,0,'22a5e702-28db-4af1-9488-b99ef72c85b3'),(29,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Address 1','companyaddress1','text','core',NULL,0,1,1,0,1,0,0,0,64,1,'company','a:0:{}',0,0,'89ff6cea-72ba-44b7-9f41-ce75855d513a'),(30,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Address 2','companyaddress2','text','core',NULL,0,1,1,0,1,0,0,0,64,2,'company','a:0:{}',0,0,'afbd75c2-d679-41d8-a69b-402f3114fc43'),(31,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Company Email','companyemail','email','core',NULL,0,1,1,0,1,0,0,0,64,3,'company','a:0:{}',0,0,'eef09a41-3070-41ab-b3d7-13ea620dd533'),(32,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phone','companyphone','tel','core',NULL,0,1,1,0,1,0,0,0,64,4,'company','a:0:{}',0,0,'5b2bdeb9-ed72-4571-8b7b-de8202bf12ae'),(33,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'City','companycity','text','core',NULL,0,1,1,0,1,0,0,0,64,5,'company','a:0:{}',0,0,'55d06f72-7932-4d11-b406-30ea96968795'),(34,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'State','companystate','region','core',NULL,0,1,1,0,1,0,0,0,64,6,'company','a:0:{}',0,0,'3e99b3b7-bc80-4c71-ae12-fc832b60b973'),(35,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Zip Code','companyzipcode','text','core',NULL,0,1,1,0,1,0,0,0,64,7,'company','a:0:{}',0,0,'a9963850-3082-435b-8ef2-ec81ff325935'),(36,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Country','companycountry','country','core',NULL,0,1,1,0,1,0,0,0,64,8,'company','a:0:{}',0,0,'09425666-f7e0-49b4-9a03-3a106de886d7'),(37,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Company Name','companyname','text','core',NULL,1,1,1,0,1,0,1,1,64,9,'company','a:0:{}',0,0,'76138444-8566-4445-89f4-7300f4237326'),(38,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Website','companywebsite','url','core',NULL,0,1,1,0,1,0,0,0,64,10,'company','a:0:{}',0,0,'a6c92f92-0671-4312-968d-da24d2e7e608'),(39,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Number of Employees','companynumber_of_employees','number','professional',NULL,0,0,1,0,1,0,0,0,64,11,'company','a:2:{s:9:\"roundmode\";i:4;s:5:\"scale\";i:0;}',0,0,'c2d489ac-8c44-45eb-b32f-30851e4af056'),(40,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fax','companyfax','tel','professional',NULL,0,0,1,0,1,0,0,0,64,12,'company','a:0:{}',0,0,'6727fe20-67cd-40eb-b20e-843fe431159a'),(41,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Annual Revenue','companyannual_revenue','number','professional',NULL,0,0,1,0,1,0,0,0,64,13,'company','a:2:{s:9:\"roundmode\";i:4;s:5:\"scale\";i:2;}',0,0,'1e9492a8-6dc8-44d9-87a7-768b6f852240'),(42,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Industry','companyindustry','select','professional',NULL,0,1,1,0,1,0,0,0,64,14,'company','a:1:{s:4:\"list\";a:41:{i:0;a:2:{s:5:\"label\";s:19:\"Aerospace & Defense\";s:5:\"value\";s:19:\"Aerospace & Defense\";}i:1;a:2:{s:5:\"label\";s:11:\"Agriculture\";s:5:\"value\";s:11:\"Agriculture\";}i:2;a:2:{s:5:\"label\";s:7:\"Apparel\";s:5:\"value\";s:7:\"Apparel\";}i:3;a:2:{s:5:\"label\";s:21:\"Automotive & Assembly\";s:5:\"value\";s:21:\"Automotive & Assembly\";}i:4;a:2:{s:5:\"label\";s:7:\"Banking\";s:5:\"value\";s:7:\"Banking\";}i:5;a:2:{s:5:\"label\";s:13:\"Biotechnology\";s:5:\"value\";s:13:\"Biotechnology\";}i:6;a:2:{s:5:\"label\";s:9:\"Chemicals\";s:5:\"value\";s:9:\"Chemicals\";}i:7;a:2:{s:5:\"label\";s:14:\"Communications\";s:5:\"value\";s:14:\"Communications\";}i:8;a:2:{s:5:\"label\";s:12:\"Construction\";s:5:\"value\";s:12:\"Construction\";}i:9;a:2:{s:5:\"label\";s:23:\"Consumer Packaged Goods\";s:5:\"value\";s:23:\"Consumer Packaged Goods\";}i:10;a:2:{s:5:\"label\";s:9:\"Education\";s:5:\"value\";s:9:\"Education\";}i:11;a:2:{s:5:\"label\";s:11:\"Electronics\";s:5:\"value\";s:11:\"Electronics\";}i:12;a:2:{s:5:\"label\";s:6:\"Energy\";s:5:\"value\";s:6:\"Energy\";}i:13;a:2:{s:5:\"label\";s:11:\"Engineering\";s:5:\"value\";s:11:\"Engineering\";}i:14;a:2:{s:5:\"label\";s:13:\"Entertainment\";s:5:\"value\";s:13:\"Entertainment\";}i:15;a:2:{s:5:\"label\";s:13:\"Environmental\";s:5:\"value\";s:13:\"Environmental\";}i:16;a:2:{s:5:\"label\";s:7:\"Finance\";s:5:\"value\";s:7:\"Finance\";}i:17;a:2:{s:5:\"label\";s:15:\"Food & Beverage\";s:5:\"value\";s:15:\"Food & Beverage\";}i:18;a:2:{s:5:\"label\";s:10:\"Government\";s:5:\"value\";s:10:\"Government\";}i:19;a:2:{s:5:\"label\";s:10:\"Healthcare\";s:5:\"value\";s:10:\"Healthcare\";}i:20;a:2:{s:5:\"label\";s:11:\"Hospitality\";s:5:\"value\";s:11:\"Hospitality\";}i:21;a:2:{s:5:\"label\";s:9:\"Insurance\";s:5:\"value\";s:9:\"Insurance\";}i:22;a:2:{s:5:\"label\";s:9:\"Machinery\";s:5:\"value\";s:9:\"Machinery\";}i:23;a:2:{s:5:\"label\";s:13:\"Manufacturing\";s:5:\"value\";s:13:\"Manufacturing\";}i:24;a:2:{s:5:\"label\";s:5:\"Media\";s:5:\"value\";s:5:\"Media\";}i:25;a:2:{s:5:\"label\";s:15:\"Metals & Mining\";s:5:\"value\";s:15:\"Metals & Mining\";}i:26;a:2:{s:5:\"label\";s:14:\"Not for Profit\";s:5:\"value\";s:14:\"Not for Profit\";}i:27;a:2:{s:5:\"label\";s:9:\"Oil & Gas\";s:5:\"value\";s:9:\"Oil & Gas\";}i:28;a:2:{s:5:\"label\";s:17:\"Packaging & Paper\";s:5:\"value\";s:17:\"Packaging & Paper\";}i:29;a:2:{s:5:\"label\";s:36:\"Private Equity & Principal Investors\";s:5:\"value\";s:36:\"Private Equity & Principal Investors\";}i:30;a:2:{s:5:\"label\";s:10:\"Recreation\";s:5:\"value\";s:10:\"Recreation\";}i:31;a:2:{s:5:\"label\";s:11:\"Real Estate\";s:5:\"value\";s:11:\"Real Estate\";}i:32;a:2:{s:5:\"label\";s:6:\"Retail\";s:5:\"value\";s:6:\"Retail\";}i:33;a:2:{s:5:\"label\";s:14:\"Semiconductors\";s:5:\"value\";s:14:\"Semiconductors\";}i:34;a:2:{s:5:\"label\";s:8:\"Shipping\";s:5:\"value\";s:8:\"Shipping\";}i:35;a:2:{s:5:\"label\";s:13:\"Social Sector\";s:5:\"value\";s:13:\"Social Sector\";}i:36;a:2:{s:5:\"label\";s:10:\"Technology\";s:5:\"value\";s:10:\"Technology\";}i:37;a:2:{s:5:\"label\";s:18:\"Telecommunications\";s:5:\"value\";s:18:\"Telecommunications\";}i:38;a:2:{s:5:\"label\";s:14:\"Transportation\";s:5:\"value\";s:14:\"Transportation\";}i:39;a:2:{s:5:\"label\";s:9:\"Utilities\";s:5:\"value\";s:9:\"Utilities\";}i:40;a:2:{s:5:\"label\";s:5:\"Other\";s:5:\"value\";s:5:\"Other\";}}}',0,0,'a3c96ddb-b2da-42f2-a3d5-836ff3e8f97a'),(43,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Description','companydescription','text','professional',NULL,0,1,1,0,1,0,0,0,64,15,'company','a:0:{}',0,0,'3da308c5-5915-4480-865c-f584e9acb40a');

--
-- Table structure for table `ms_lead_frequencyrules`
--

CREATE TABLE `ms_lead_frequencyrules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `frequency_number` smallint(6) DEFAULT NULL,
  `frequency_time` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `preferred_channel` tinyint(1) NOT NULL,
  `pause_from_date` datetime DEFAULT NULL,
  `pause_to_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_92C2CC8B55458D` (`lead_id`),
  KEY `ms_channel_frequency` (`channel`),
  KEY `ms_idx_frequency_date_added` (`lead_id`,`date_added`),
  CONSTRAINT `FK_92C2CC8B55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_frequencyrules`
--


--
-- Table structure for table `ms_lead_ips_xref`
--

CREATE TABLE `ms_lead_ips_xref` (
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`lead_id`,`ip_id`),
  KEY `IDX_2B9773D1A03F5E9F` (`ip_id`),
  CONSTRAINT `FK_2B9773D155458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2B9773D1A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_ips_xref`
--

INSERT INTO `ms_lead_ips_xref` VALUES (2,1),(4,1),(3,2),(1,3);

--
-- Table structure for table `ms_lead_lists`
--

CREATE TABLE `ms_lead_lists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `public_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filters` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `is_global` tinyint(1) NOT NULL,
  `is_preference_center` tinyint(1) NOT NULL,
  `last_built_date` datetime DEFAULT NULL,
  `last_built_time` double DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_7372BC1812469DE2` (`category_id`),
  KEY `ms_lead_list_alias` (`alias`),
  CONSTRAINT `FK_7372BC1812469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_lists`
--

INSERT INTO `ms_lead_lists` VALUES (1,NULL,1,'2025-05-20 13:03:19',1,'kulvir Kaur','2025-05-20 13:03:19',1,'kulvir Kaur',NULL,NULL,'kulvir Kaur','test',NULL,'test','test','a:0:{}',1,0,NULL,NULL,'7ddf9173-8fa8-4e5d-b159-aa3e10e5e4a4');

--
-- Table structure for table `ms_lead_lists_leads`
--

CREATE TABLE `ms_lead_lists_leads` (
  `leadlist_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `manually_removed` tinyint(1) NOT NULL,
  `manually_added` tinyint(1) NOT NULL,
  PRIMARY KEY (`leadlist_id`,`lead_id`),
  KEY `IDX_309B723355458D` (`lead_id`),
  KEY `ms_manually_removed` (`manually_removed`),
  KEY `ms_lead_id_lists_id_removed` (`lead_id`,`leadlist_id`,`manually_removed`),
  CONSTRAINT `FK_309B723355458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_309B7233B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_lists_leads`
--


--
-- Table structure for table `ms_lead_notes`
--

CREATE TABLE `ms_lead_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7A4F853155458D` (`lead_id`),
  CONSTRAINT `FK_7A4F853155458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_notes`
--


--
-- Table structure for table `ms_lead_points_change_log`
--

CREATE TABLE `ms_lead_points_change_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `type` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delta` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_218399EA55458D` (`lead_id`),
  KEY `IDX_218399EAA03F5E9F` (`ip_id`),
  KEY `IDX_218399EAFE54D947` (`group_id`),
  KEY `ms_point_date_added` (`date_added`),
  CONSTRAINT `FK_218399EA55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_218399EAA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_218399EAFE54D947` FOREIGN KEY (`group_id`) REFERENCES `ms_point_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_points_change_log`
--


--
-- Table structure for table `ms_lead_stages_change_log`
--

CREATE TABLE `ms_lead_stages_change_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `stage_id` int(10) unsigned DEFAULT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C6AB9BD555458D` (`lead_id`),
  KEY `IDX_C6AB9BD52298D193` (`stage_id`),
  KEY `ms_lead_stages_change_log_date_added` (`date_added`),
  CONSTRAINT `FK_C6AB9BD52298D193` FOREIGN KEY (`stage_id`) REFERENCES `ms_stages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C6AB9BD555458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_stages_change_log`
--


--
-- Table structure for table `ms_lead_tags`
--

CREATE TABLE `ms_lead_tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `ms_lead_tag_search` (`tag`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_tags`
--

INSERT INTO `ms_lead_tags` VALUES (1,'test',NULL,'71769ec8-9a58-41f1-961a-1bd60d443cee');

--
-- Table structure for table `ms_lead_tags_xref`
--

CREATE TABLE `ms_lead_tags_xref` (
  `lead_id` bigint(20) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`lead_id`,`tag_id`),
  KEY `IDX_A7554294BAD26311` (`tag_id`),
  CONSTRAINT `FK_A755429455458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A7554294BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `ms_lead_tags` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_tags_xref`
--


--
-- Table structure for table `ms_lead_utmtags`
--

CREATE TABLE `ms_lead_utmtags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  `query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `referer` longtext COLLATE utf8mb4_unicode_ci,
  `remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `user_agent` longtext COLLATE utf8mb4_unicode_ci,
  `utm_campaign` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_medium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `utm_term` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6FD94D3055458D` (`lead_id`),
  KEY `ms_utm_date_added` (`date_added`),
  CONSTRAINT `FK_6FD94D3055458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_lead_utmtags`
--


--
-- Table structure for table `ms_leads`
--

CREATE TABLE `ms_leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` int(10) unsigned DEFAULT NULL,
  `stage_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `points` int(11) NOT NULL,
  `last_active` datetime DEFAULT NULL,
  `internal` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `social_cache` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `date_identified` datetime DEFAULT NULL,
  `preferred_profile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preferred_locale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribution_date` datetime DEFAULT NULL,
  `attribution` double DEFAULT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foursquare` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `skype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generated_email_domain` varchar(255) COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (substr(`email`,(locate('@',`email`) + 1))) VIRTUAL COMMENT '(DC2Type:generated)',
  PRIMARY KEY (`id`),
  KEY `IDX_DF26A8D87E3C61F9` (`owner_id`),
  KEY `IDX_DF26A8D82298D193` (`stage_id`),
  KEY `ms_lead_date_added` (`date_added`),
  KEY `ms_lead_date_modified` (`date_modified`),
  KEY `ms_date_identified` (`date_identified`),
  KEY `fax_search` (`fax`),
  KEY `preferred_locale_search` (`preferred_locale`),
  KEY `attribution_date_search` (`attribution_date`),
  KEY `attribution_search` (`attribution`),
  KEY `website_search` (`website`),
  KEY `facebook_search` (`facebook`),
  KEY `foursquare_search` (`foursquare`),
  KEY `instagram_search` (`instagram`),
  KEY `linkedin_search` (`linkedin`),
  KEY `skype_search` (`skype`),
  KEY `twitter_search` (`twitter`),
  KEY `contact_attribution` (`attribution`,`attribution_date`),
  KEY `date_added_country_index` (`date_added`,`country`),
  KEY `ms_generated_email_domain` (`generated_email_domain`),
  CONSTRAINT `FK_DF26A8D82298D193` FOREIGN KEY (`stage_id`) REFERENCES `ms_stages` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_DF26A8D87E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `ms_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_leads`
--

INSERT INTO `ms_leads` (`id`, `owner_id`, `stage_id`, `is_published`, `date_added`, `created_by`, `created_by_user`, `date_modified`, `modified_by`, `modified_by_user`, `checked_out`, `checked_out_by`, `checked_out_by_user`, `points`, `last_active`, `internal`, `social_cache`, `date_identified`, `preferred_profile_image`, `title`, `firstname`, `lastname`, `company`, `position`, `email`, `phone`, `mobile`, `address1`, `address2`, `city`, `state`, `zipcode`, `timezone`, `country`, `fax`, `preferred_locale`, `attribution_date`, `attribution`, `website`, `facebook`, `foursquare`, `instagram`, `linkedin`, `skype`, `twitter`) VALUES (1,NULL,NULL,1,'2025-05-21 07:24:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-05-21 07:24:11','a:0:{}','a:0:{}',NULL,'gravatar',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),(2,NULL,NULL,1,'2025-05-21 07:24:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-05-21 07:24:11','a:0:{}','a:0:{}',NULL,'gravatar',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),(3,NULL,NULL,1,'2025-05-21 07:24:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-05-21 07:24:11','a:0:{}','a:0:{}',NULL,'gravatar',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,NULL,NULL,1,'2025-05-21 07:24:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2025-05-21 07:24:12','a:0:{}','a:0:{}',NULL,'gravatar',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);

--
-- Table structure for table `ms_message_channels`
--

CREATE TABLE `ms_message_channels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `message_id` int(10) unsigned NOT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `properties` json NOT NULL,
  `is_enabled` tinyint(1) NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ms_channel_index` (`message_id`,`channel`),
  KEY `IDX_3F5D28E8537A1329` (`message_id`),
  KEY `ms_channel_entity_index` (`channel`,`channel_id`),
  KEY `ms_channel_enabled_index` (`channel`,`is_enabled`),
  CONSTRAINT `FK_3F5D28E8537A1329` FOREIGN KEY (`message_id`) REFERENCES `ms_messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_message_channels`
--


--
-- Table structure for table `ms_message_queue`
--

CREATE TABLE `ms_message_queue` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` int(11) NOT NULL,
  `priority` smallint(6) NOT NULL,
  `max_attempts` smallint(6) NOT NULL,
  `attempts` smallint(6) NOT NULL,
  `success` tinyint(1) NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `last_attempt` datetime DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `options` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_35218D3F71F7E88B` (`event_id`),
  KEY `IDX_35218D3F55458D` (`lead_id`),
  KEY `ms_message_status_search` (`status`),
  KEY `ms_message_date_sent` (`date_sent`),
  KEY `ms_message_scheduled_date` (`scheduled_date`),
  KEY `ms_message_priority` (`priority`),
  KEY `ms_message_success` (`success`),
  KEY `ms_message_channel_search` (`channel`,`channel_id`),
  KEY `ms_message_queue_date_published` (`date_published`),
  CONSTRAINT `FK_35218D3F55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_35218D3F71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `ms_campaign_events` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_message_queue`
--


--
-- Table structure for table `ms_messages`
--

CREATE TABLE `ms_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_FE721B1012469DE2` (`category_id`),
  KEY `ms_date_message_added` (`date_added`),
  CONSTRAINT `FK_FE721B1012469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_messages`
--


--
-- Table structure for table `ms_monitor_post_count`
--

CREATE TABLE `ms_monitor_post_count` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `monitor_id` int(10) unsigned DEFAULT NULL,
  `post_date` date NOT NULL,
  `post_count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_73F59B684CE1C902` (`monitor_id`),
  CONSTRAINT `FK_73F59B684CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `ms_monitoring` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_monitor_post_count`
--


--
-- Table structure for table `ms_monitoring`
--

CREATE TABLE `ms_monitoring` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `lists` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `network_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revision` int(11) NOT NULL,
  `stats` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A7FC796F12469DE2` (`category_id`),
  CONSTRAINT `FK_A7FC796F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_monitoring`
--


--
-- Table structure for table `ms_monitoring_leads`
--

CREATE TABLE `ms_monitoring_leads` (
  `monitor_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`monitor_id`,`lead_id`),
  KEY `IDX_804F740555458D` (`lead_id`),
  CONSTRAINT `FK_804F74054CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `ms_monitoring` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_804F740555458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_monitoring_leads`
--


--
-- Table structure for table `ms_notifications`
--

CREATE TABLE `ms_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `header` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_added` datetime NOT NULL,
  `icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL,
  `deduplicate` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D57ABD64A76ED395` (`user_id`),
  KEY `ms_notification_read_status` (`is_read`),
  KEY `ms_notification_type` (`type`),
  KEY `ms_notification_user_read_status` (`is_read`,`user_id`),
  KEY `ms_deduplicate_date_added` (`deduplicate`,`date_added`),
  CONSTRAINT `FK_D57ABD64A76ED395` FOREIGN KEY (`user_id`) REFERENCES `ms_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_notifications`
--


--
-- Table structure for table `ms_oauth2_user_client_xref`
--

CREATE TABLE `ms_oauth2_user_client_xref` (
  `client_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`client_id`,`user_id`),
  KEY `IDX_C85BDE5BA76ED395` (`user_id`),
  CONSTRAINT `FK_C85BDE5B19EB6921` FOREIGN KEY (`client_id`) REFERENCES `ms_oauth2_clients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C85BDE5BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `ms_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_oauth2_user_client_xref`
--


--
-- Table structure for table `ms_page_hits`
--

CREATE TABLE `ms_page_hits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(10) unsigned DEFAULT NULL,
  `redirect_id` bigint(20) unsigned DEFAULT NULL,
  `email_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `device_id` bigint(20) unsigned DEFAULT NULL,
  `date_hit` datetime NOT NULL,
  `date_left` datetime DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext COLLATE utf8mb4_unicode_ci,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `url_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` longtext COLLATE utf8mb4_unicode_ci,
  `remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser_languages` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_99B526E1C4663E4` (`page_id`),
  KEY `IDX_99B526E1B42D874D` (`redirect_id`),
  KEY `IDX_99B526E1A832C1C9` (`email_id`),
  KEY `IDX_99B526E155458D` (`lead_id`),
  KEY `IDX_99B526E1A03F5E9F` (`ip_id`),
  KEY `IDX_99B526E194A4C7D4` (`device_id`),
  KEY `ms_page_hit_tracking_search` (`tracking_id`),
  KEY `ms_page_hit_code_search` (`code`),
  KEY `ms_page_hit_source_search` (`source`,`source_id`),
  KEY `ms_date_hit_left_index` (`date_hit`,`date_left`),
  KEY `ms_page_hit_url` (`url`(128)),
  CONSTRAINT `FK_99B526E155458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_99B526E194A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `ms_lead_devices` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_99B526E1A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_99B526E1A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `ms_emails` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_99B526E1B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `ms_page_redirects` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_99B526E1C4663E4` FOREIGN KEY (`page_id`) REFERENCES `ms_pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_page_hits`
--

INSERT INTO `ms_page_hits` VALUES (1,NULL,NULL,NULL,1,3,1,'2025-05-21 07:24:10',NULL,'','','','','',404,NULL,'https://mauticsystem.urtestsite.com/auth.json',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36',NULL,NULL,'a:0:{}','uw5w18fwvl3z6pbsxdsrujx',NULL,NULL,'a:1:{s:8:\"page_url\";s:45:\"https://mauticsystem.urtestsite.com/auth.json\";}'),(2,NULL,NULL,NULL,2,1,2,'2025-05-21 07:24:10',NULL,'','','','','',404,NULL,'https://mauticsystem.urtestsite.com/hardhat.config.js',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.5.26',NULL,NULL,'a:0:{}','89fukj8hughxxmekef88mig',NULL,NULL,'a:1:{s:8:\"page_url\";s:53:\"https://mauticsystem.urtestsite.com/hardhat.config.js\";}'),(3,NULL,NULL,NULL,3,2,3,'2025-05-21 07:24:10',NULL,'','','','','',404,NULL,'https://mauticsystem.urtestsite.com/.git/config',NULL,'Mozilla/5.0 (Macintosh; Intel Mac OS X 11_7) AppleWebKit/537.36 (KHTML, like Gecko) Version/11.6.52 Safari/614.17.8',NULL,NULL,'a:0:{}','c0b4u77pbpd8s1x025p8j02',NULL,NULL,'a:1:{s:8:\"page_url\";s:47:\"https://mauticsystem.urtestsite.com/.git/config\";}'),(4,NULL,NULL,NULL,4,1,4,'2025-05-21 07:24:11',NULL,'','','','','',404,NULL,'https://mauticsystem.urtestsite.com/ftpsync.settings',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/17.17134',NULL,NULL,'a:0:{}','c2h2z8st632fxkmhkymng8u',NULL,NULL,'a:1:{s:8:\"page_url\";s:52:\"https://mauticsystem.urtestsite.com/ftpsync.settings\";}');

--
-- Table structure for table `ms_page_redirects`
--

CREATE TABLE `ms_page_redirects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_id` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_page_redirects`
--


--
-- Table structure for table `ms_pages`
--

CREATE TABLE `ms_pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `translation_parent_id` int(10) unsigned DEFAULT NULL,
  `variant_parent_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_html` longtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL,
  `variant_hits` int(11) NOT NULL,
  `revision` int(11) NOT NULL,
  `meta_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `head_script` longtext COLLATE utf8mb4_unicode_ci,
  `footer_script` longtext COLLATE utf8mb4_unicode_ci,
  `redirect_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_preference_center` tinyint(1) DEFAULT NULL,
  `no_index` tinyint(1) DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_E8C208FF12469DE2` (`category_id`),
  KEY `IDX_E8C208FF9091A2FB` (`translation_parent_id`),
  KEY `IDX_E8C208FF91861123` (`variant_parent_id`),
  KEY `ms_page_alias_search` (`alias`),
  CONSTRAINT `FK_E8C208FF12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_E8C208FF9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `ms_pages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E8C208FF91861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `ms_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_pages`
--


--
-- Table structure for table `ms_permissions`
--

CREATE TABLE `ms_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bitwise` int(11) NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ms_unique_perm` (`bundle`,`name`,`role_id`),
  KEY `IDX_E5272E01D60322AC` (`role_id`),
  CONSTRAINT `FK_E5272E01D60322AC` FOREIGN KEY (`role_id`) REFERENCES `ms_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_permissions`
--


--
-- Table structure for table `ms_plugin_integration_settings`
--

CREATE TABLE `ms_plugin_integration_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_published` tinyint(1) NOT NULL,
  `supported_features` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `api_keys` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `feature_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_7EFFF65CEC942BCF` (`plugin_id`),
  CONSTRAINT `FK_7EFFF65CEC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `ms_plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_plugin_integration_settings`
--

INSERT INTO `ms_plugin_integration_settings` VALUES (1,1,'GrapesJsBuilder',1,'a:0:{}','a:0:{}','a:0:{}'),(2,NULL,'OneSignal',0,'a:4:{i:0;s:6:\"mobile\";i:1;s:20:\"landing_page_enabled\";i:2;s:28:\"welcome_notification_enabled\";i:3;s:21:\"tracking_page_enabled\";}','a:0:{}','a:0:{}'),(3,NULL,'Twilio',0,'a:0:{}','a:0:{}','a:0:{}'),(4,2,'Vtiger',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(5,2,'Salesforce',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(6,2,'Dynamics',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(7,2,'Connectwise',0,'a:2:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";}','a:0:{}','a:0:{}'),(8,2,'Zoho',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(9,2,'Hubspot',0,'a:2:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";}','a:0:{}','a:0:{}'),(10,2,'Sugarcrm',0,'a:3:{i:0;s:9:\"push_lead\";i:1;s:9:\"get_leads\";i:2;s:10:\"push_leads\";}','a:0:{}','a:0:{}'),(11,3,'Outlook',0,'a:0:{}','a:0:{}','a:0:{}'),(12,4,'Clearbit',0,'a:0:{}','a:0:{}','a:0:{}'),(13,5,'FullContact',0,'a:0:{}','a:0:{}','a:0:{}'),(14,6,'AmazonS3',1,'a:1:{i:0;s:13:\"cloud_storage\";}','a:5:{s:9:\"client_id\";s:169:\"S29RODhvc21RVXplNFpPQTFya0RVVE5zNTM0YnNlVnd5d0hqZ1FkUlFPQ3N3NXJHSy95aE1CdU1tOGxHTlZOSFhUK0RYK3pLZzVWM0ZOSldLN1ZCeU9YOVNRVS9hZEhvcUNxcDhQRHdlVm89|bKO7P95B3bh4vpk53j4idQ==\";s:13:\"client_secret\";s:197:\"VHUrMThVbzBGYXdOSnBTMFA4aTRXQ1lvRVFSMDFhUk5hWUFoOHhSb0RHaHN2M2JjTkVXWDF1bG52Q0JsNjhFcjk4MjdSK0VYdHFZMndvNFdxbk5NMG5ScW5PWGFseTVoRldXSDZCR1Z3V0dQejNLdWpGb0M4R29abVh1bTZSS0w=|FmUwM3kwoenxW2GNWBql5g==\";s:6:\"bucket\";s:169:\"Nll4aU9xM3c4YjlJVmF0clZHb0YxMVc5bEYxbEd1bDhRUFNhUVJaNDRVYlhuWDhHNVNvU0hWWGhDdHZ2am1Ha0IwejRMUUhoeE9yd1JEMXpaQlFxT1ZROXNTRVpQSERGeFVhSDYzYnQ2MmM9|pN6Op726GYAlYeOsipXDtw==\";s:6:\"region\";s:197:\"ODIvNU5MTjBEdkVpWFdKSlk4a20yR1ZuOGNnbGZHdEk5bGNaSmtBbXpGL2VLc2FrTXBPSldBZWhOUHROK0Q3Q1hybTVaVTZJNGNIY01tV0hWR3ZYUXV5SEFzTjQrVmZvbDBGL3ZIMVZhbXZZUkE2U0p2NmpwY3JHN09FQnoyT0s=|YSpAcS2mYarQLrlR568Emw==\";s:8:\"endpoint\";s:169:\"Y0NRWnJoZGs1SkdGdVMzdmRjcGxhalRveklqNEY1TndiUkE4OWQzZjdKcFlyWWxQK2VmaWtvWnJKTXZId3dkdFdOZUlnSjFSclVhZFVvcFNIelFsdjZreXR1YXlVSmRQK3psQlVnOHpTWHM9|onf9TVLr1AKzbbaTNaJgTg==\";}','a:0:{}'),(15,7,'ConstantContact',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(16,7,'Mailchimp',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(17,7,'Icontact',0,'a:1:{i:0;s:9:\"push_lead\";}','a:0:{}','a:0:{}'),(18,8,'Facebook',0,'a:3:{i:0;s:12:\"share_button\";i:1;s:12:\"login_button\";i:2;s:14:\"public_profile\";}','a:0:{}','a:0:{}'),(19,8,'Instagram',0,'a:2:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";}','a:0:{}','a:0:{}'),(20,8,'Foursquare',0,'a:2:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";}','a:0:{}','a:0:{}'),(21,8,'Twitter',0,'a:4:{i:0;s:14:\"public_profile\";i:1;s:15:\"public_activity\";i:2;s:12:\"share_button\";i:3;s:12:\"login_button\";}','a:0:{}','a:0:{}'),(22,9,'Gmail',0,'a:0:{}','a:0:{}','a:0:{}'),(23,11,'TagManager',0,'a:0:{}','a:0:{}','a:0:{}');

--
-- Table structure for table `ms_plugins`
--

CREATE TABLE `ms_plugins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `is_missing` tinyint(1) NOT NULL,
  `bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ms_unique_bundle` (`bundle`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_plugins`
--

INSERT INTO `ms_plugins` VALUES (1,'GrapesJS Builder','GrapesJS Builder with MJML support for Mautic',0,'GrapesJsBuilderBundle','1.0.0','Mautic Community'),(2,'CRM','Enables integration with Mautic supported CRMs.',0,'MauticCrmBundle','1.0','Mautic'),(3,'Outlook','Enables integrations with Outlook for email tracking',0,'MauticOutlookBundle','1.0','Mautic'),(4,'Clearbit','Enables integration with Clearbit for contact and company lookup',0,'MauticClearbitBundle','1.0','Werner Garcia'),(5,'FullContact','Enables integration with FullContact for contact and company lookup',0,'MauticFullContactBundle','1.0','Mautic'),(6,'Cloud Storage','Enables integrations with Mautic supported cloud storage services.',0,'MauticCloudStorageBundle','1.0','Mautic'),(7,'Email Marketing','Enables integration with Mautic supported email marketing services.',0,'MauticEmailMarketingBundle','1.0','Mautic'),(8,'Social Media','Enables integrations with Mautic supported social media services.',0,'MauticSocialBundle','1.0','Mautic'),(9,'Gmail','Enables integrations with Gmail for email tracking',0,'MauticGmailBundle','1.0','Mautic'),(10,'Zapier Integration','Zapier lets you connect Mautic with 1100+ other apps\n---\nLearn more about Zapier integration in the <a href=\"https://mautic.org/docs/en/plugins/zapier.html\">docs</a>. Make sure Mautic API and Basic Auth is enabled in the <a href=\"config/edit\" target=\"_blank\">configuration</a>.\n<br>\n<br>\nUse these predefined Zap templates as a starting point:\n<div id=\"zaps\"></div>\n<script src=\"https://zapier.com/apps/embed/widget.js?services=mautic&html_id=zaps\"></script>',0,'MauticZapierBundle','1.0','Mautic'),(11,'Mautic tag manager bundle','Provides an interface for tags management.',0,'MauticTagManagerBundle','1.0','Leuchtfeuer'),(12,'Mautic Focus','Drive visitor\'s focus on your website with Mautic Focus',0,'MauticFocusBundle','1.0','Mautic, Inc'),(13,'Example plugin','Example plugin for testing Integration',0,'ExampleBundle','1.0.1','Kulvir Kaur Impinge');

--
-- Table structure for table `ms_point_group_contact_score`
--

CREATE TABLE `ms_point_group_contact_score` (
  `contact_id` bigint(20) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  `score` int(11) NOT NULL,
  PRIMARY KEY (`contact_id`,`group_id`),
  KEY `IDX_B5FFCAECFE54D947` (`group_id`),
  CONSTRAINT `FK_B5FFCAECE7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B5FFCAECFE54D947` FOREIGN KEY (`group_id`) REFERENCES `ms_point_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_group_contact_score`
--


--
-- Table structure for table `ms_point_groups`
--

CREATE TABLE `ms_point_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_groups`
--


--
-- Table structure for table `ms_point_lead_action_log`
--

CREATE TABLE `ms_point_lead_action_log` (
  `point_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`point_id`,`lead_id`),
  KEY `IDX_A2835DEB55458D` (`lead_id`),
  KEY `IDX_A2835DEBA03F5E9F` (`ip_id`),
  CONSTRAINT `FK_A2835DEB55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A2835DEBA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_A2835DEBC028CEA2` FOREIGN KEY (`point_id`) REFERENCES `ms_points` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_lead_action_log`
--


--
-- Table structure for table `ms_point_lead_event_log`
--

CREATE TABLE `ms_point_lead_event_log` (
  `event_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`event_id`,`lead_id`),
  KEY `IDX_221998C55458D` (`lead_id`),
  KEY `IDX_221998CA03F5E9F` (`ip_id`),
  CONSTRAINT `FK_221998C55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_221998C71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `ms_point_trigger_events` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_221998CA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_lead_event_log`
--


--
-- Table structure for table `ms_point_trigger_events`
--

CREATE TABLE `ms_point_trigger_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `trigger_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_order` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_CDD44D6E5FDDDCD6` (`trigger_id`),
  KEY `ms_trigger_type_search` (`type`),
  CONSTRAINT `FK_CDD44D6E5FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `ms_point_triggers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_trigger_events`
--


--
-- Table structure for table `ms_point_triggers`
--

CREATE TABLE `ms_point_triggers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `points` int(11) NOT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
  `trigger_existing_leads` tinyint(1) NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_C91B8F0D12469DE2` (`category_id`),
  KEY `IDX_C91B8F0DFE54D947` (`group_id`),
  CONSTRAINT `FK_C91B8F0D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_C91B8F0DFE54D947` FOREIGN KEY (`group_id`) REFERENCES `ms_point_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_point_triggers`
--


--
-- Table structure for table `ms_points`
--

CREATE TABLE `ms_points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `group_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `repeatable` tinyint(1) NOT NULL,
  `delta` int(11) NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_2A1F52FA12469DE2` (`category_id`),
  KEY `IDX_2A1F52FAFE54D947` (`group_id`),
  KEY `ms_point_type_search` (`type`),
  CONSTRAINT `FK_2A1F52FA12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2A1F52FAFE54D947` FOREIGN KEY (`group_id`) REFERENCES `ms_point_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_points`
--


--
-- Table structure for table `ms_push_ids`
--

CREATE TABLE `ms_push_ids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `push_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6A53966E55458D` (`lead_id`),
  CONSTRAINT `FK_6A53966E55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_push_ids`
--


--
-- Table structure for table `ms_push_notification_list_xref`
--

CREATE TABLE `ms_push_notification_list_xref` (
  `notification_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`notification_id`,`leadlist_id`),
  KEY `IDX_ADDCC353B9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_ADDCC353B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_ADDCC353EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `ms_push_notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_push_notification_list_xref`
--


--
-- Table structure for table `ms_push_notification_stats`
--

CREATE TABLE `ms_push_notification_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `list_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `is_clicked` tinyint(1) NOT NULL,
  `date_clicked` datetime DEFAULT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `click_count` int(11) DEFAULT NULL,
  `last_clicked` datetime DEFAULT NULL,
  `click_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_CDBF316EF1A9D84` (`notification_id`),
  KEY `IDX_CDBF31655458D` (`lead_id`),
  KEY `IDX_CDBF3163DAE168B` (`list_id`),
  KEY `IDX_CDBF316A03F5E9F` (`ip_id`),
  KEY `ms_stat_notification_search` (`notification_id`,`lead_id`),
  KEY `ms_stat_notification_clicked_search` (`is_clicked`),
  KEY `ms_stat_notification_hash_search` (`tracking_hash`),
  KEY `ms_stat_notification_source_search` (`source`,`source_id`),
  CONSTRAINT `FK_CDBF3163DAE168B` FOREIGN KEY (`list_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CDBF31655458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CDBF316A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CDBF316EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `ms_push_notifications` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_push_notification_stats`
--


--
-- Table structure for table `ms_push_notifications`
--

CREATE TABLE `ms_push_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `heading` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `button` longtext COLLATE utf8mb4_unicode_ci,
  `utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `notification_type` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `read_count` int(11) NOT NULL,
  `sent_count` int(11) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  `mobileSettings` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_CBC2C5ED12469DE2` (`category_id`),
  CONSTRAINT `FK_CBC2C5ED12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_push_notifications`
--


--
-- Table structure for table `ms_reports`
--

CREATE TABLE `ms_reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `system` tinyint(1) NOT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `columns` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `filters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `table_order` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `graphs` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `group_by` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `aggregators` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `settings` json DEFAULT NULL,
  `is_scheduled` tinyint(1) NOT NULL,
  `schedule_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_month_frequency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_reports`
--

INSERT INTO `ms_reports` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Visits published Pages',NULL,1,'page.hits','a:7:{i:0;s:11:\"ph.date_hit\";i:1;s:6:\"ph.url\";i:2;s:12:\"ph.url_title\";i:3;s:10:\"ph.referer\";i:4;s:12:\"i.ip_address\";i:5;s:7:\"ph.city\";i:6;s:10:\"ph.country\";}','a:2:{i:0;a:3:{s:6:\"column\";s:7:\"ph.code\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:3:\"200\";}i:1;a:3:{s:6:\"column\";s:14:\"p.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:11:\"ph.date_hit\";s:9:\"direction\";s:3:\"ASC\";}}','a:8:{i:0;s:35:\"mautic.page.graph.line.time.on.site\";i:1;s:27:\"mautic.page.graph.line.hits\";i:2;s:38:\"mautic.page.graph.pie.new.vs.returning\";i:3;s:31:\"mautic.page.graph.pie.languages\";i:4;s:34:\"mautic.page.graph.pie.time.on.site\";i:5;s:27:\"mautic.page.table.referrers\";i:6;s:30:\"mautic.page.table.most.visited\";i:7;s:37:\"mautic.page.table.most.visited.unique\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL,'f09f950e-499c-4478-8c31-7d4ef41e79a5'),(2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Downloads of all Assets',NULL,1,'asset.downloads','a:7:{i:0;s:16:\"ad.date_download\";i:1;s:7:\"a.title\";i:2;s:12:\"i.ip_address\";i:3;s:11:\"l.firstname\";i:4;s:10:\"l.lastname\";i:5;s:7:\"l.email\";i:6;s:4:\"a.id\";}','a:1:{i:0;a:3:{s:6:\"column\";s:14:\"a.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:16:\"ad.date_download\";s:9:\"direction\";s:3:\"ASC\";}}','a:4:{i:0;s:33:\"mautic.asset.graph.line.downloads\";i:1;s:31:\"mautic.asset.graph.pie.statuses\";i:2;s:34:\"mautic.asset.table.most.downloaded\";i:3;s:32:\"mautic.asset.table.top.referrers\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL,'abf8179a-33d8-4551-a43e-281d84a36f2f'),(3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Submissions of published Forms',NULL,1,'form.submissions','a:0:{}','a:1:{i:1;a:3:{s:6:\"column\";s:14:\"f.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:0:{}','a:3:{i:0;s:34:\"mautic.form.graph.line.submissions\";i:1;s:32:\"mautic.form.table.most.submitted\";i:2;s:31:\"mautic.form.table.top.referrers\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL,'3dfef21d-3fde-47d0-8011-1d5bad6741d2'),(4,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All Emails',NULL,1,'email.stats','a:5:{i:0;s:12:\"es.date_sent\";i:1;s:12:\"es.date_read\";i:2;s:9:\"e.subject\";i:3;s:16:\"es.email_address\";i:4;s:4:\"e.id\";}','a:1:{i:0;a:3:{s:6:\"column\";s:14:\"e.is_published\";s:9:\"condition\";s:2:\"eq\";s:5:\"value\";s:1:\"1\";}}','a:1:{i:0;a:2:{s:6:\"column\";s:12:\"es.date_sent\";s:9:\"direction\";s:3:\"ASC\";}}','a:6:{i:0;s:29:\"mautic.email.graph.line.stats\";i:1;s:42:\"mautic.email.graph.pie.ignored.read.failed\";i:2;s:35:\"mautic.email.table.most.emails.read\";i:3;s:35:\"mautic.email.table.most.emails.sent\";i:4;s:43:\"mautic.email.table.most.emails.read.percent\";i:5;s:37:\"mautic.email.table.most.emails.failed\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL,'e2f9d6a0-2d6a-4a40-a4f6-94abbaaacfa5'),(5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Leads and Points',NULL,1,'lead.pointlog','a:7:{i:0;s:13:\"lp.date_added\";i:1;s:7:\"lp.type\";i:2;s:13:\"lp.event_name\";i:3;s:11:\"l.firstname\";i:4;s:10:\"l.lastname\";i:5;s:7:\"l.email\";i:6;s:8:\"lp.delta\";}','a:0:{}','a:1:{i:0;a:2:{s:6:\"column\";s:13:\"lp.date_added\";s:9:\"direction\";s:3:\"ASC\";}}','a:6:{i:0;s:29:\"mautic.lead.graph.line.points\";i:1;s:29:\"mautic.lead.table.most.points\";i:2;s:29:\"mautic.lead.table.top.actions\";i:3;s:28:\"mautic.lead.table.top.cities\";i:4;s:31:\"mautic.lead.table.top.countries\";i:5;s:28:\"mautic.lead.table.top.events\";}','a:0:{}','a:0:{}','[]',0,NULL,NULL,NULL,NULL,'b5023349-0e00-4fee-aff8-5ff282ec3b06');

--
-- Table structure for table `ms_reports_schedulers`
--

CREATE TABLE `ms_reports_schedulers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `report_id` int(10) unsigned NOT NULL,
  `schedule_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_57151D1A4BD2A4C0` (`report_id`),
  CONSTRAINT `FK_57151D1A4BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `ms_reports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_reports_schedulers`
--


--
-- Table structure for table `ms_roles`
--

CREATE TABLE `ms_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `is_admin` tinyint(1) NOT NULL,
  `readable_permissions` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_roles`
--

INSERT INTO `ms_roles` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Administrator','Full system access',1,'N;','5674ff48-df80-4ef1-8d72-7608f7a4e3b2');

--
-- Table structure for table `ms_saml_id_entry`
--

CREATE TABLE `ms_saml_id_entry` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiryTimestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_saml_id_entry`
--


--
-- Table structure for table `ms_sms_message_list_xref`
--

CREATE TABLE `ms_sms_message_list_xref` (
  `sms_id` int(10) unsigned NOT NULL,
  `leadlist_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sms_id`,`leadlist_id`),
  KEY `IDX_7F48EB93B9FC8874` (`leadlist_id`),
  CONSTRAINT `FK_7F48EB93B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_7F48EB93BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `ms_sms_messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_sms_message_list_xref`
--


--
-- Table structure for table `ms_sms_message_stats`
--

CREATE TABLE `ms_sms_message_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sms_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `list_id` int(10) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `is_failed` tinyint(1) DEFAULT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `details` json NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E94789E6BD5C7E60` (`sms_id`),
  KEY `IDX_E94789E655458D` (`lead_id`),
  KEY `IDX_E94789E63DAE168B` (`list_id`),
  KEY `IDX_E94789E6A03F5E9F` (`ip_id`),
  KEY `ms_stat_sms_search` (`sms_id`,`lead_id`),
  KEY `ms_stat_sms_hash_search` (`tracking_hash`),
  KEY `ms_stat_sms_source_search` (`source`,`source_id`),
  KEY `ms_stat_sms_failed_search` (`is_failed`),
  CONSTRAINT `FK_E94789E63DAE168B` FOREIGN KEY (`list_id`) REFERENCES `ms_lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_E94789E655458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_E94789E6A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_E94789E6BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `ms_sms_messages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_sms_message_stats`
--


--
-- Table structure for table `ms_sms_messages`
--

CREATE TABLE `ms_sms_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `sms_type` longtext COLLATE utf8mb4_unicode_ci,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `sent_count` int(11) NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_1736B92A12469DE2` (`category_id`),
  CONSTRAINT `FK_1736B92A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_sms_messages`
--


--
-- Table structure for table `ms_stage_lead_action_log`
--

CREATE TABLE `ms_stage_lead_action_log` (
  `stage_id` int(10) unsigned NOT NULL,
  `lead_id` bigint(20) unsigned NOT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_fired` datetime NOT NULL,
  PRIMARY KEY (`stage_id`,`lead_id`),
  KEY `IDX_6A7CB80355458D` (`lead_id`),
  KEY `IDX_6A7CB803A03F5E9F` (`ip_id`),
  CONSTRAINT `FK_6A7CB8032298D193` FOREIGN KEY (`stage_id`) REFERENCES `ms_stages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6A7CB80355458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6A7CB803A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_stage_lead_action_log`
--


--
-- Table structure for table `ms_stages`
--

CREATE TABLE `ms_stages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `weight` int(11) NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
  PRIMARY KEY (`id`),
  KEY `IDX_2207B6B712469DE2` (`category_id`),
  CONSTRAINT `FK_2207B6B712469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_stages`
--


--
-- Table structure for table `ms_sync_object_field_change_report`
--

CREATE TABLE `ms_sync_object_field_change_report` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object_id` bigint(20) unsigned NOT NULL,
  `object_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modified_at` datetime NOT NULL,
  `column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ms_object_composite_key` (`object_type`,`object_id`,`column_name`),
  KEY `ms_integration_object_composite_key` (`integration`,`object_type`,`object_id`,`column_name`),
  KEY `ms_integration_object_type_modification_composite_key` (`integration`,`object_type`,`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_sync_object_field_change_report`
--


--
-- Table structure for table `ms_sync_object_mapping`
--

CREATE TABLE `ms_sync_object_mapping` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `internal_object_id` bigint(20) unsigned NOT NULL,
  `integration_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `integration_object_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_sync_date` datetime NOT NULL,
  `internal_storage` json NOT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  `integration_reference_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ms_internal_object_id_idx` (`internal_object_id`),
  KEY `ms_integration_object` (`integration`,`integration_object_name`,`integration_object_id`,`integration_reference_id`),
  KEY `ms_integration_reference` (`integration`,`integration_object_name`,`integration_reference_id`,`integration_object_id`),
  KEY `ms_integration_integration_object_name_last_sync_date` (`integration`,`internal_object_name`,`last_sync_date`),
  KEY `ms_integration_last_sync_date` (`integration`,`last_sync_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_sync_object_mapping`
--


--
-- Table structure for table `ms_tweet_stats`
--

CREATE TABLE `ms_tweet_stats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tweet_id` int(10) unsigned DEFAULT NULL,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `twitter_tweet_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `handle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_sent` datetime DEFAULT NULL,
  `is_failed` tinyint(1) DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `response_details` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_346588B1041E39B` (`tweet_id`),
  KEY `IDX_346588B55458D` (`lead_id`),
  KEY `ms_stat_tweet_search` (`tweet_id`,`lead_id`),
  KEY `ms_stat_tweet_search2` (`lead_id`,`tweet_id`),
  KEY `ms_stat_tweet_failed_search` (`is_failed`),
  KEY `ms_stat_tweet_source_search` (`source`,`source_id`),
  KEY `ms_favorite_count_index` (`favorite_count`),
  KEY `ms_retweet_count_index` (`retweet_count`),
  KEY `ms_tweet_date_sent` (`date_sent`),
  KEY `ms_twitter_tweet_id_index` (`twitter_tweet_id`),
  CONSTRAINT `FK_346588B1041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `ms_tweets` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_346588B55458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_tweet_stats`
--


--
-- Table structure for table `ms_tweets`
--

CREATE TABLE `ms_tweets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned DEFAULT NULL,
  `page_id` int(10) unsigned DEFAULT NULL,
  `asset_id` int(10) unsigned DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `media_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent_count` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A79D9CF612469DE2` (`category_id`),
  KEY `IDX_A79D9CF6C4663E4` (`page_id`),
  KEY `IDX_A79D9CF65DA1941` (`asset_id`),
  KEY `ms_sent_count_index` (`sent_count`),
  KEY `ms_favorite_count_index` (`favorite_count`),
  KEY `ms_retweet_count_index` (`retweet_count`),
  CONSTRAINT `FK_A79D9CF612469DE2` FOREIGN KEY (`category_id`) REFERENCES `ms_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_A79D9CF65DA1941` FOREIGN KEY (`asset_id`) REFERENCES `ms_assets` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_A79D9CF6C4663E4` FOREIGN KEY (`page_id`) REFERENCES `ms_pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_tweets`
--


--
-- Table structure for table `ms_video_hits`
--

CREATE TABLE `ms_video_hits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned DEFAULT NULL,
  `ip_id` int(10) unsigned DEFAULT NULL,
  `date_hit` datetime NOT NULL,
  `date_left` datetime DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext COLLATE utf8mb4_unicode_ci,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `user_agent` longtext COLLATE utf8mb4_unicode_ci,
  `remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser_languages` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `time_watched` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_ABDFC555458D` (`lead_id`),
  KEY `IDX_ABDFC5A03F5E9F` (`ip_id`),
  KEY `ms_video_date_hit` (`date_hit`),
  KEY `ms_video_channel_search` (`channel`,`channel_id`),
  KEY `ms_video_guid_lead_search` (`guid`,`lead_id`),
  CONSTRAINT `FK_ABDFC555458D` FOREIGN KEY (`lead_id`) REFERENCES `ms_leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_ABDFC5A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ms_ip_addresses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_video_hits`
--


--
-- Table structure for table `ms_webhook_events`
--

CREATE TABLE `ms_webhook_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2F6412155C9BA60B` (`webhook_id`),
  CONSTRAINT `FK_2F6412155C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `ms_webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_webhook_events`
--


--
-- Table structure for table `ms_webhook_logs`
--

CREATE TABLE `ms_webhook_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `status_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `runtime` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EF61D5FA5C9BA60B` (`webhook_id`),
  KEY `ms_webhook_id_date_added` (`webhook_id`,`date_added`),
  CONSTRAINT `FK_EF61D5FA5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `ms_webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_webhook_logs`
--


--
-- Table structure for table `ms_webhook_queue`
--

CREATE TABLE `ms_webhook_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `webhook_id` int(10) unsigned NOT NULL,
  `event_id` int(10) unsigned NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci,
  `payload_compressed` mediumblob,
  PRIMARY KEY (`id`),
  KEY `IDX_405797AD5C9BA60B` (`webhook_id`),
  KEY `IDX_405797AD71F7E88B` (`event_id`),
  CONSTRAINT `FK_405797AD5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `ms_webhooks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_405797AD71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `ms_webhook_events` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_webhook_queue`
--


--
-- Table structure for table `ms_widgets`
--

CREATE TABLE `ms_widgets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_published` tinyint(1) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `cache_timeout` int(11) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `params` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ms_widgets`
--

INSERT INTO `ms_widgets` VALUES (1,1,'2025-05-20 11:17:56',1,'kulvir Kaur','2025-05-20 11:17:56',1,'kulvir Kaur',NULL,NULL,NULL,'Contacts Created','created.leads.in.time',100,330,NULL,0,'a:1:{s:5:\"lists\";s:21:\"identifiedVsAnonymous\";}'),(2,1,'2025-05-20 11:17:56',1,'kulvir Kaur','2025-05-20 11:17:56',1,'kulvir Kaur',NULL,NULL,NULL,'Page Visits','page.hits.in.time',50,330,NULL,1,'a:1:{s:4:\"flag\";s:6:\"unique\";}'),(3,1,'2025-05-20 11:17:56',1,'kulvir Kaur','2025-05-20 11:17:56',1,'kulvir Kaur',NULL,NULL,NULL,'Form Submissions','submissions.in.time',50,330,NULL,2,'a:0:{}'),(4,1,'2025-05-20 11:17:57',1,'kulvir Kaur','2025-05-20 11:17:57',1,'kulvir Kaur',NULL,NULL,NULL,'Recent Activity','recent.activity',50,330,NULL,3,'a:0:{}'),(5,1,'2025-05-20 11:17:57',1,'kulvir Kaur','2025-05-20 11:17:57',1,'kulvir Kaur',NULL,NULL,NULL,'Upcoming Emails','upcoming.emails',50,330,NULL,4,'a:0:{}');


