?HAMA

Navigation

Breadcrumbs

/ / var / softaculous / mautic

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 189.34 KB

//var/softaculous/mautic/mautic_mariadb.sql

Text Base64

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 */;

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 7 × Files: 19

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
images DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
languages DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
php53 DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
php56 DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
php71 DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
php81 DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
php82 DIR	-	drwxr-xr-x	2026-06-04 03:19:16	Edit Download recursive recursive
.htaccess	5.99 KB	lrw-r--r--	2025-05-29 11:01:26	Edit Download recursive recursive
check_webserver.php	254 B	lrw-r--r--	2025-01-13 09:11:02	Edit Download recursive recursive
edit.php	4.91 KB	lrw-r--r--	2026-06-03 12:36:10	Edit Download recursive recursive
edit.xml	433 B	lrw-r--r--	2024-10-29 10:40:36	Edit Download recursive recursive
extend.php	8.81 KB	lrw-r--r--	2026-06-03 12:36:10	Edit Download recursive recursive
fileindex.php	464 B	lrw-r--r--	2026-02-06 06:34:06	Edit Download recursive recursive
import.php	3.38 KB	lrw-r--r--	2026-06-03 12:36:10	Edit Download recursive recursive
info.xml	4.60 KB	lrw-r--r--	2026-06-02 09:57:12	Edit Download recursive recursive
install.js	921 B	lrw-r--r--	2021-12-23 11:54:36	Edit Download recursive recursive
install.php	8.65 KB	lrw-r--r--	2026-06-03 12:36:10	Edit Download recursive recursive
install.xml	2.12 KB	lrw-r--r--	2024-06-14 09:39:06	Edit Download recursive recursive
local.php	487 B	lrw-r--r--	2026-05-06 10:21:42	Edit Download recursive recursive
mautic.sql	175.12 KB	lrw-r--r--	2026-06-02 09:57:12	Edit Download recursive recursive
mautic.zip	87.36 MB	lrw-r--r--	2026-06-02 09:57:12	Edit Download recursive recursive
mautic_mariadb.sql	189.34 KB	lrw-r--r--	2026-06-02 09:57:12	Edit Download recursive recursive
md5	6.21 KB	lrw-r--r--	2026-06-03 12:36:10	Edit Download recursive recursive
notes.txt	2.88 KB	lrw-r--r--	2026-06-02 09:57:12	Edit Download recursive recursive
update_pass.php	496 B	lrw-r--r--	2021-12-23 11:54:36	Edit Download recursive recursive
_clone.php	3.87 KB	lrw-r--r--	2024-01-17 09:25:40	Edit Download recursive recursive