| Server IP : 104.21.64.206 / Your IP : 216.73.216.92 Web Server : LiteSpeed System : Linux premium234.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : pawazvgw ( 969) PHP Version : 8.1.32 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/mautic/ |
Upload File : |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
--
-- Database: `mautic602`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]assets`
--
CREATE TABLE `[[dbprefix]]assets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`storage_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remote_path` longtext COLLATE utf8mb4_unicode_ci,
`original_file_name` longtext COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`download_count` int(11) NOT NULL,
`unique_download_count` int(11) NOT NULL,
`revision` int(11) NOT NULL,
`extension` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`disallow` tinyint(1) DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_CA4DDFB712469DE2` (`category_id`),
KEY `[[dbprefix]]asset_alias_search` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]asset_downloads`
--
CREATE TABLE `[[dbprefix]]asset_downloads` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`asset_id` int(10) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`email_id` int(10) unsigned DEFAULT NULL,
`date_download` datetime NOT NULL,
`code` int(11) NOT NULL,
`referer` longtext COLLATE utf8mb4_unicode_ci,
`tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`utm_campaign` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_medium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_term` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7885A7645DA1941` (`asset_id`),
KEY `IDX_7885A764A03F5E9F` (`ip_id`),
KEY `IDX_7885A76455458D` (`lead_id`),
KEY `IDX_7885A764A832C1C9` (`email_id`),
KEY `[[dbprefix]]download_tracking_search` (`tracking_id`),
KEY `[[dbprefix]]download_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]asset_date_download` (`date_download`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]audit_log`
--
CREATE TABLE `[[dbprefix]]audit_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`user_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`object` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` bigint(20) unsigned NOT NULL,
`action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`date_added` datetime NOT NULL,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `[[dbprefix]]object_search` (`object`,`object_id`),
KEY `[[dbprefix]]timeline_search` (`bundle`,`object`,`action`,`object_id`),
KEY `[[dbprefix]]date_added_index` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]bundle_grapesjsbuilder`
--
CREATE TABLE `[[dbprefix]]bundle_grapesjsbuilder` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_id` int(10) unsigned DEFAULT NULL,
`custom_mjml` longtext COLLATE utf8mb4_unicode_ci,
`draft_custom_mjml` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_C1EB39DBA832C1C9` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`item_id`)
) 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`canvas_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`allow_restart` tinyint(1) NOT NULL,
`deleted` datetime DEFAULT NULL,
`version` int(10) unsigned NOT NULL DEFAULT '1',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_AD41ABD812469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]campaign_events`
--
CREATE TABLE `[[dbprefix]]campaign_events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` int(10) unsigned NOT NULL,
`parent_id` int(10) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_order` int(11) NOT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`deleted` datetime DEFAULT NULL,
`trigger_date` datetime DEFAULT NULL,
`trigger_interval` int(11) DEFAULT NULL,
`trigger_interval_unit` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`trigger_hour` time DEFAULT NULL,
`trigger_restricted_start_hour` time DEFAULT NULL,
`trigger_restricted_stop_hour` time DEFAULT NULL,
`trigger_restricted_dow` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`trigger_window` int(11) DEFAULT NULL,
`trigger_mode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`decision_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`temp_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int(11) DEFAULT NULL,
`failed_count` int(11) NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_5008C50CF639F774` (`campaign_id`),
KEY `IDX_5008C50C727ACA70` (`parent_id`),
KEY `[[dbprefix]]campaign_event_search` (`type`,`event_type`),
KEY `[[dbprefix]]campaign_event_type` (`event_type`),
KEY `[[dbprefix]]campaign_event_channel` (`channel`,`channel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`campaign_id`,`form_id`),
KEY `IDX_BAA733915FF69B7D` (`form_id`)
) 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,
PRIMARY KEY (`campaign_id`,`leadlist_id`),
KEY `IDX_F3CAD7F2B9FC8874` (`leadlist_id`)
) 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,
PRIMARY KEY (`campaign_id`,`lead_id`),
KEY `IDX_2EE00FD055458D` (`lead_id`),
KEY `[[dbprefix]]campaign_leads_date_added` (`date_added`),
KEY `[[dbprefix]]campaign_leads_date_exited` (`date_last_exited`),
KEY `[[dbprefix]]campaign_leads` (`campaign_id`,`manually_removed`,`lead_id`,`rotation`)
) 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 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`log_id`),
KEY `[[dbprefix]]campaign_event_failed_date` (`date_added`)
) 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 AUTO_INCREMENT,
`event_id` int(10) unsigned NOT NULL,
`lead_id` bigint(20) unsigned NOT NULL,
`campaign_id` int(10) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`rotation` int(11) NOT NULL,
`date_triggered` datetime DEFAULT NULL,
`is_scheduled` tinyint(1) NOT NULL,
`trigger_date` datetime DEFAULT NULL,
`system_triggered` tinyint(1) NOT NULL,
`metadata` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int(11) DEFAULT NULL,
`non_action_path_taken` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]campaign_rotation` (`event_id`,`lead_id`,`rotation`),
KEY `IDX_38B0DF8C71F7E88B` (`event_id`),
KEY `IDX_38B0DF8C55458D` (`lead_id`),
KEY `IDX_38B0DF8CF639F774` (`campaign_id`),
KEY `IDX_38B0DF8CA03F5E9F` (`ip_id`),
KEY `[[dbprefix]]campaign_event_upcoming_search` (`is_scheduled`,`lead_id`),
KEY `[[dbprefix]]campaign_event_schedule_counts` (`campaign_id`,`is_scheduled`,`trigger_date`),
KEY `[[dbprefix]]campaign_date_triggered` (`date_triggered`),
KEY `[[dbprefix]]campaign_leads` (`lead_id`,`campaign_id`,`rotation`),
KEY `[[dbprefix]]campaign_log_channel` (`channel`,`channel_id`,`lead_id`),
KEY `[[dbprefix]]campaign_actions` (`campaign_id`,`event_id`,`date_triggered`),
KEY `[[dbprefix]]campaign_stats` (`campaign_id`,`date_triggered`,`event_id`,`non_action_path_taken`),
KEY `[[dbprefix]]campaign_trigger_date_order` (`trigger_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]campaign_summary`
--
CREATE TABLE `[[dbprefix]]campaign_summary` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` int(10) unsigned DEFAULT NULL,
`event_id` int(10) unsigned NOT NULL,
`date_triggered` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`scheduled_count` int(11) NOT NULL,
`triggered_count` int(11) NOT NULL,
`non_action_path_taken_count` int(11) NOT NULL,
`failed_count` int(11) NOT NULL,
`log_counts_processed` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]campaign_event_date_triggered` (`campaign_id`,`event_id`,`date_triggered`),
KEY `IDX_51940D54F639F774` (`campaign_id`),
KEY `IDX_51940D5471F7E88B` (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]categories`
--
CREATE TABLE `[[dbprefix]]categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `[[dbprefix]]category_alias_search` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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) COLLATE utf8mb4_unicode_ci NOT NULL,
`hits` int(11) NOT NULL,
`unique_hits` int(11) NOT NULL,
PRIMARY KEY (`redirect_id`,`channel_id`),
KEY `[[dbprefix]]channel_url_trackable_search` (`channel`,`channel_id`)
) 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 AUTO_INCREMENT,
`owner_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`social_cache` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`score` int(11) DEFAULT NULL,
`companyemail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyaddress1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyaddress2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyphone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companycity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companystate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyzipcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companycountry` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companywebsite` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyindustry` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companydescription` longtext COLLATE utf8mb4_unicode_ci,
`companynumber_of_employees` double DEFAULT NULL,
`companyfax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyannual_revenue` double DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_CC7675927E3C61F9` (`owner_id`),
KEY `companynumber_of_employees_search` (`companynumber_of_employees`),
KEY `companyfax_search` (`companyfax`),
KEY `companyannual_revenue_search` (`companyannual_revenue`),
KEY `company_filter` (`companyname`,`companyemail`),
KEY `company_match` (`companyname`,`companycity`,`companycountry`,`companystate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`company_id`,`lead_id`),
KEY `IDX_2AD5E15D55458D` (`lead_id`)
) 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 AUTO_INCREMENT,
`user_id` int(10) unsigned DEFAULT NULL,
`scheduled_datetime` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`data` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_4F900E9DA76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]contact_merge_records`
--
CREATE TABLE `[[dbprefix]]contact_merge_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`contact_id` bigint(20) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`merged_id` int(11) NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_41BFA6B4E7A1254A` (`contact_id`),
KEY `[[dbprefix]]contact_merge_date_added` (`date_added`),
KEY `[[dbprefix]]contact_merge_ids` (`merged_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]dynamic_content`
--
CREATE TABLE `[[dbprefix]]dynamic_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`translation_parent_id` int(10) unsigned DEFAULT NULL,
`variant_parent_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`sent_count` int(11) NOT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci,
`utm_tags` json DEFAULT NULL,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
`filters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`is_campaign_based` tinyint(1) NOT NULL DEFAULT '1',
`slot_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_FE75355912469DE2` (`category_id`),
KEY `IDX_FE7535599091A2FB` (`translation_parent_id`),
KEY `IDX_FE75355991861123` (`variant_parent_id`),
KEY `[[dbprefix]]is_campaign_based_index` (`is_campaign_based`),
KEY `[[dbprefix]]slot_name_index` (`slot_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]dynamic_content_lead_data`
--
CREATE TABLE `[[dbprefix]]dynamic_content_lead_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`dynamic_content_id` int(10) unsigned DEFAULT NULL,
`date_added` datetime DEFAULT NULL,
`slot` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_F0CFE1CB55458D` (`lead_id`),
KEY `IDX_F0CFE1CBD9D0CD7` (`dynamic_content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]dynamic_content_stats`
--
CREATE TABLE `[[dbprefix]]dynamic_content_stats` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`dynamic_content_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`date_sent` datetime NOT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`sent_count` int(11) DEFAULT NULL,
`last_sent` datetime DEFAULT NULL,
`sent_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_7C84EB8BD9D0CD7` (`dynamic_content_id`),
KEY `IDX_7C84EB8B55458D` (`lead_id`),
KEY `[[dbprefix]]stat_dynamic_content_search` (`dynamic_content_id`,`lead_id`),
KEY `[[dbprefix]]stat_dynamic_content_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]stat_dynamic_content_date_sent` (`date_sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]emails`
--
CREATE TABLE `[[dbprefix]]emails` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`translation_parent_id` int(10) unsigned DEFAULT NULL,
`variant_parent_id` int(10) unsigned DEFAULT NULL,
`unsubscribeform_id` int(10) unsigned DEFAULT NULL,
`preference_center_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`subject` longtext COLLATE utf8mb4_unicode_ci,
`preheader_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`from_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`from_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reply_to_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bcc_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`use_owner_as_mailer` tinyint(1) DEFAULT NULL,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`plain_text` longtext COLLATE utf8mb4_unicode_ci,
`custom_html` longtext COLLATE utf8mb4_unicode_ci,
`email_type` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`read_count` int(11) NOT NULL,
`sent_count` int(11) NOT NULL,
`variant_sent_count` int(11) NOT NULL,
`variant_read_count` int(11) NOT NULL,
`revision` int(11) NOT NULL,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
`dynamic_content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`headers` json NOT NULL,
`public_preview` tinyint(1) DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_FF1D4A6B12469DE2` (`category_id`),
KEY `IDX_FF1D4A6B9091A2FB` (`translation_parent_id`),
KEY `IDX_FF1D4A6B91861123` (`variant_parent_id`),
KEY `IDX_FF1D4A6B2DC494F6` (`unsubscribeform_id`),
KEY `IDX_FF1D4A6B834F9C5B` (`preference_center_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]emails_draft`
--
CREATE TABLE `[[dbprefix]]emails_draft` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_id` int(10) unsigned NOT NULL,
`html` longtext COLLATE utf8mb4_unicode_ci,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`public_preview` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_A0DF7ED6A832C1C9` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`email_id`,`asset_id`),
KEY `IDX_406398635DA1941` (`asset_id`)
) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_created` datetime NOT NULL,
`body` longtext COLLATE utf8mb4_unicode_ci,
`body_text` longtext COLLATE utf8mb4_unicode_ci,
`subject` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`email_id`,`leadlist_id`),
KEY `IDX_9FD1BF92B9FC8874` (`leadlist_id`)
) 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,
PRIMARY KEY (`email_id`,`leadlist_id`),
KEY `IDX_F0E81BF7B9FC8874` (`leadlist_id`)
) 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 AUTO_INCREMENT,
`email_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`list_id` int(10) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`copy_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_sent` datetime NOT NULL,
`is_read` tinyint(1) NOT NULL,
`is_failed` tinyint(1) NOT NULL,
`viewed_in_browser` tinyint(1) NOT NULL,
`date_read` datetime DEFAULT NULL,
`tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`retry_count` int(11) DEFAULT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`open_count` int(11) DEFAULT NULL,
`last_opened` datetime DEFAULT NULL,
`open_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`generated_sent_date` date GENERATED ALWAYS AS (concat(year(`date_sent`),'-',lpad(month(`date_sent`),2,'0'),'-',lpad(dayofmonth(`date_sent`),2,'0'))) VIRTUAL COMMENT '(DC2Type:generated)',
PRIMARY KEY (`id`),
KEY `IDX_BAB891B3A832C1C9` (`email_id`),
KEY `IDX_BAB891B355458D` (`lead_id`),
KEY `IDX_BAB891B33DAE168B` (`list_id`),
KEY `IDX_BAB891B3A03F5E9F` (`ip_id`),
KEY `IDX_BAB891B3A8752772` (`copy_id`),
KEY `[[dbprefix]]stat_email_search` (`email_id`,`lead_id`),
KEY `[[dbprefix]]stat_email_search2` (`lead_id`,`email_id`),
KEY `[[dbprefix]]stat_email_failed_search` (`is_failed`),
KEY `[[dbprefix]]is_read_date_sent` (`is_read`,`date_sent`),
KEY `[[dbprefix]]stat_email_hash_search` (`tracking_hash`),
KEY `[[dbprefix]]stat_email_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]email_date_sent` (`date_sent`),
KEY `[[dbprefix]]email_date_read_lead` (`date_read`,`lead_id`),
KEY `[[dbprefix]]stat_email_lead_id_date_sent` (`lead_id`,`date_sent`),
KEY `[[dbprefix]]stat_email_email_id_is_read` (`email_id`,`is_read`),
KEY `[[dbprefix]]generated_sent_date_email_id` (`generated_sent_date`,`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]email_stats_devices`
--
CREATE TABLE `[[dbprefix]]email_stats_devices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`device_id` bigint(20) unsigned DEFAULT NULL,
`stat_id` bigint(20) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`date_opened` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_D867828694A4C7D4` (`device_id`),
KEY `IDX_D86782869502F0B` (`stat_id`),
KEY `IDX_D8678286A03F5E9F` (`ip_id`),
KEY `[[dbprefix]]date_opened_search` (`date_opened`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]email_stat_replies`
--
CREATE TABLE `[[dbprefix]]email_stat_replies` (
`id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
`stat_id` bigint(20) unsigned NOT NULL,
`date_replied` datetime NOT NULL,
`message_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_9B066DC39502F0B` (`stat_id`),
KEY `[[dbprefix]]email_replies` (`stat_id`,`message_id`),
KEY `[[dbprefix]]date_email_replied` (`date_replied`)
) 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`focus_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`style` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`form_id` int(11) DEFAULT NULL,
`cache` longtext COLLATE utf8mb4_unicode_ci,
`html_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`editor` longtext COLLATE utf8mb4_unicode_ci,
`html` longtext COLLATE utf8mb4_unicode_ci,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_98185D1112469DE2` (`category_id`),
KEY `[[dbprefix]]focus_type` (`focus_type`),
KEY `[[dbprefix]]focus_style` (`style`),
KEY `[[dbprefix]]focus_form` (`form_id`),
KEY `[[dbprefix]]focus_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]focus_stats`
--
CREATE TABLE `[[dbprefix]]focus_stats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`focus_id` int(10) unsigned NOT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type_id` int(11) DEFAULT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_B3DBC74A51804B42` (`focus_id`),
KEY `IDX_B3DBC74A55458D` (`lead_id`),
KEY `[[dbprefix]]focus_type` (`type`),
KEY `[[dbprefix]]focus_type_id` (`type`,`type_id`),
KEY `[[dbprefix]]focus_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forms`
--
CREATE TABLE `[[dbprefix]]forms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`form_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cached_html` longtext COLLATE utf8mb4_unicode_ci,
`post_action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`post_action_property` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`in_kiosk_mode` tinyint(1) DEFAULT NULL,
`render_style` tinyint(1) DEFAULT NULL,
`form_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`no_index` tinyint(1) DEFAULT NULL,
`progressive_profiling_limit` int(11) DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_7E70C0F12469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]form_actions`
--
CREATE TABLE `[[dbprefix]]form_actions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` int(10) unsigned NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`action_order` int(11) NOT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_2D3815125FF69B7D` (`form_id`),
KEY `[[dbprefix]]form_action_type_search` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]form_fields`
--
CREATE TABLE `[[dbprefix]]form_fields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` int(10) unsigned NOT NULL,
`label` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`show_label` tinyint(1) DEFAULT NULL,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_custom` tinyint(1) NOT NULL,
`custom_parameters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`default_value` longtext COLLATE utf8mb4_unicode_ci,
`is_required` tinyint(1) NOT NULL,
`validation_message` longtext COLLATE utf8mb4_unicode_ci,
`help_message` longtext COLLATE utf8mb4_unicode_ci,
`field_order` int(11) DEFAULT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`validation` json DEFAULT NULL,
`parent_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conditions` json DEFAULT NULL,
`label_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`input_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`container_attr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lead_field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`save_result` tinyint(1) DEFAULT NULL,
`is_auto_fill` tinyint(1) DEFAULT NULL,
`is_read_only` tinyint(1) NOT NULL DEFAULT '0',
`show_when_value_exists` tinyint(1) DEFAULT NULL,
`show_after_x_submissions` int(11) DEFAULT NULL,
`always_display` tinyint(1) DEFAULT NULL,
`mapped_object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mapped_field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_CB980B05FF69B7D` (`form_id`),
KEY `[[dbprefix]]form_field_type_search` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]form_submissions`
--
CREATE TABLE `[[dbprefix]]form_submissions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`form_id` int(10) unsigned NOT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`page_id` int(10) unsigned DEFAULT NULL,
`tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_submitted` datetime NOT NULL,
`referer` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_FF0C0EFD5FF69B7D` (`form_id`),
KEY `IDX_FF0C0EFDA03F5E9F` (`ip_id`),
KEY `IDX_FF0C0EFD55458D` (`lead_id`),
KEY `IDX_FF0C0EFDC4663E4` (`page_id`),
KEY `[[dbprefix]]form_submission_tracking_search` (`tracking_id`),
KEY `[[dbprefix]]form_date_submitted` (`date_submitted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]imports`
--
CREATE TABLE `[[dbprefix]]imports` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`original_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`line_count` int(11) NOT NULL,
`inserted_count` int(11) NOT NULL,
`updated_count` int(11) NOT NULL,
`ignored_count` int(11) NOT NULL,
`priority` int(11) NOT NULL,
`status` int(11) NOT NULL,
`date_started` datetime DEFAULT NULL,
`date_ended` datetime DEFAULT NULL,
`object` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`properties` json DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `[[dbprefix]]import_object` (`object`),
KEY `[[dbprefix]]import_status` (`status`),
KEY `[[dbprefix]]import_priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]integration_entity`
--
CREATE TABLE `[[dbprefix]]integration_entity` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date_added` datetime NOT NULL,
`integration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`integration_entity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`integration_entity_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`internal_entity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`internal_entity_id` int(11) DEFAULT NULL,
`last_sync_date` datetime DEFAULT NULL,
`internal` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `[[dbprefix]]integration_external_entity` (`integration`,`integration_entity`,`integration_entity_id`),
KEY `[[dbprefix]]integration_internal_entity` (`integration`,`internal_entity`,`internal_entity_id`),
KEY `[[dbprefix]]integration_entity_match` (`integration`,`internal_entity`,`integration_entity`),
KEY `[[dbprefix]]integration_last_sync_date` (`integration`,`last_sync_date`),
KEY `[[dbprefix]]internal_integration_entity` (`internal_entity_id`,`integration_entity_id`,`internal_entity`,`integration_entity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]ip_addresses`
--
CREATE TABLE `[[dbprefix]]ip_addresses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`ip_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `[[dbprefix]]ip_search` (`ip_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]leads`
--
CREATE TABLE `[[dbprefix]]leads` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(10) unsigned DEFAULT NULL,
`stage_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`points` int(11) NOT NULL,
`last_active` datetime DEFAULT NULL,
`internal` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`social_cache` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`date_identified` datetime DEFAULT NULL,
`preferred_profile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zipcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`timezone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`preferred_locale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attribution_date` datetime DEFAULT NULL,
`attribution` double DEFAULT NULL,
`website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`facebook` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`foursquare` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`instagram` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`linkedin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`skype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`twitter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`generated_email_domain` varchar(255)[[collation]] GENERATED ALWAYS AS (substr(`email`,(locate('@',`email`) + 1))) VIRTUAL COMMENT '(DC2Type:generated)',
PRIMARY KEY (`id`),
KEY `IDX_ED4852AA7E3C61F9` (`owner_id`),
KEY `IDX_ED4852AA2298D193` (`stage_id`),
KEY `[[dbprefix]]lead_date_added` (`date_added`),
KEY `[[dbprefix]]lead_date_modified` (`date_modified`),
KEY `[[dbprefix]]date_identified` (`date_identified`),
KEY `fax_search` (`fax`),
KEY `preferred_locale_search` (`preferred_locale`),
KEY `attribution_date_search` (`attribution_date`),
KEY `attribution_search` (`attribution`),
KEY `website_search` (`website`),
KEY `facebook_search` (`facebook`),
KEY `foursquare_search` (`foursquare`),
KEY `instagram_search` (`instagram`),
KEY `linkedin_search` (`linkedin`),
KEY `skype_search` (`skype`),
KEY `twitter_search` (`twitter`),
KEY `contact_attribution` (`attribution`,`attribution_date`),
KEY `date_added_country_index` (`date_added`,`country`),
KEY `[[dbprefix]]generated_email_domain` (`generated_email_domain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_categories`
--
CREATE TABLE `[[dbprefix]]lead_categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned NOT NULL,
`lead_id` bigint(20) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`manually_removed` tinyint(1) NOT NULL,
`manually_added` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_CCA4B61F12469DE2` (`category_id`),
KEY `IDX_CCA4B61F55458D` (`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_companies_change_log`
--
CREATE TABLE `[[dbprefix]]lead_companies_change_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`type` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
`event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`company_id` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_1A00BCB55458D` (`lead_id`),
KEY `[[dbprefix]]company_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_devices`
--
CREATE TABLE `[[dbprefix]]lead_devices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`client_info` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`device` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_shortname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_platform` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_brand` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_51D596327D05ABBE` (`tracking_id`),
KEY `IDX_51D5963255458D` (`lead_id`),
KEY `[[dbprefix]]date_added_search` (`date_added`),
KEY `[[dbprefix]]device_search` (`device`),
KEY `[[dbprefix]]device_os_name_search` (`device_os_name`),
KEY `[[dbprefix]]device_os_shortname_search` (`device_os_shortname`),
KEY `[[dbprefix]]device_os_version_search` (`device_os_version`),
KEY `[[dbprefix]]device_os_platform_search` (`device_os_platform`),
KEY `[[dbprefix]]device_brand_search` (`device_brand`),
KEY `[[dbprefix]]device_model_search` (`device_model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_donotcontact`
--
CREATE TABLE `[[dbprefix]]lead_donotcontact` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`date_added` datetime NOT NULL,
`reason` smallint(6) NOT NULL,
`channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int(11) DEFAULT NULL,
`comments` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_FB8EC40655458D` (`lead_id`),
KEY `[[dbprefix]]leadid_reason_channel` (`lead_id`,`channel`,`reason`),
KEY `[[dbprefix]]dnc_reason_search` (`reason`),
KEY `[[dbprefix]]dnc_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_event_log`
--
CREATE TABLE `[[dbprefix]]lead_event_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`user_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bundle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`object_id` int(11) DEFAULT NULL,
`date_added` datetime NOT NULL,
`properties` json DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `[[dbprefix]]lead_id_index` (`lead_id`),
KEY `[[dbprefix]]lead_object_index` (`object`,`object_id`),
KEY `[[dbprefix]]lead_timeline_index` (`bundle`,`object`,`action`,`object_id`),
KEY `[[dbprefix]]IDX_SEARCH` (`bundle`,`object`,`action`,`object_id`,`date_added`),
KEY `[[dbprefix]]lead_timeline_action_index` (`action`),
KEY `[[dbprefix]]lead_date_added_index` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_fields`
--
CREATE TABLE `[[dbprefix]]lead_fields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`field_group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`default_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_required` tinyint(1) NOT NULL,
`is_fixed` tinyint(1) NOT NULL,
`is_visible` tinyint(1) NOT NULL,
`is_short_visible` tinyint(1) NOT NULL DEFAULT '0',
`is_listable` tinyint(1) NOT NULL,
`is_publicly_updatable` tinyint(1) NOT NULL,
`is_unique_identifer` tinyint(1) DEFAULT NULL,
`is_index` tinyint(1) NOT NULL DEFAULT '0',
`char_length_limit` int(11) DEFAULT NULL,
`field_order` int(11) DEFAULT NULL,
`object` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`column_is_not_created` tinyint(1) NOT NULL DEFAULT '0',
`original_is_published_value` tinyint(1) NOT NULL DEFAULT '0',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `[[dbprefix]]idx_object_field_order_is_published` (`object`,`field_order`,`is_published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=44 ;
--
-- 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, 'a3ab0919-9443-45de-a3e5-ef8e7391ddae'),
(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, '2d4e9b51-7d23-49b2-bdd8-501b907aad3e'),
(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, '0ab9e0fe-9d86-411e-857f-b5273c8563cb'),
(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, '81237a6b-1a12-4e53-9152-721fc501b819'),
(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, '60718bc1-8208-4f20-bbcf-80fadd2cd081'),
(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, '29ca33bb-1323-4c33-9c4c-ae6a97e696a8'),
(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, '3d2eb6db-4a39-4ef6-87d9-6ff671e8e03b'),
(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, '552c63a1-24a8-4dfe-a6a6-f37430f72dff'),
(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, '64345f9e-8e08-4135-a1f6-e3bbd2025e20'),
(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, 'ed54ca28-d4b8-482f-83f1-64e7ae668437'),
(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, 'f4e5bc9a-1e47-4bc7-863d-09f3fa513fd1'),
(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, '91a9ec92-7ed4-49a6-8624-147782fa5ae7'),
(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, 'b9c9dd1d-039a-4002-aaba-9cfe8091c659'),
(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, '27289330-2650-4577-b840-caaf8ec8e56c'),
(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, 'a59ee86c-db38-4f2d-947c-9d86784f7451'),
(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, '75fffa53-126f-45ff-8431-18b78a69e0b6'),
(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, '9ba41175-7524-4190-8240-9eba1641a055'),
(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, '225397dc-658c-4f7e-acbc-66e10059d016'),
(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, '89494791-5ec0-47aa-a2ec-fd580e93c832'),
(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, '7fdccf29-22b7-40f9-b5e0-a74a8458a13f'),
(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, '92df283f-874d-46a6-9e86-7829d5c6856c'),
(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, 'b6f59e89-35b2-4ae5-8936-799859e9fc5e'),
(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, '4802c208-1ece-49d8-b167-0966d6e88824'),
(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, '720fc443-3e8b-42fd-89c9-6ab988430ce8'),
(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, '8d3f2e6c-3935-4c3b-afc1-406d4fae5b05'),
(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, 'bea159df-faad-4609-9cc6-3eb4c09b8db8'),
(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, '5495e8fc-0dc0-4fae-80ef-b836a8e8100e'),
(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, '7e891fbb-8d61-4f95-b6fa-5a7192dd68c8'),
(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, '0f001fa8-b7d6-4d5b-99a2-6fbdab452d59'),
(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, 'bb21e6c3-b757-4d5e-a880-21f7d9a85102'),
(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, 'ff1aaa11-1681-40ed-9b9f-a25adadba821'),
(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, '424509b5-5470-40c8-9633-e237c08a2757'),
(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, '0b04ecc7-15fe-4acf-91d8-9ba82159cdee'),
(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, '932813b2-0268-4c13-8da3-e3646005ac2e'),
(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, '49eb7abb-a052-408a-8113-5bd5fc9ebb01'),
(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, 'dd3fe7fb-692c-4446-a238-4055117a741b'),
(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, 'b94686d6-b7c5-4ec4-9690-05a283395107'),
(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, 'c1d8c6d1-22f4-4900-a4a9-50228c4e6e46'),
(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, '9fa68df7-b64a-4991-a179-ae976403cd3e'),
(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, 'c757d09d-fc63-441b-9c0f-57f6fbfaa6f6'),
(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, '7fc34e00-ff19-419d-af0f-492f04116e08'),
(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, 'a16892f8-de69-4301-be6a-752eb828f4a8'),
(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, '438e1b04-e73a-42af-ae07-d092f51debfb');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_frequencyrules`
--
CREATE TABLE `[[dbprefix]]lead_frequencyrules` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`frequency_number` smallint(6) DEFAULT NULL,
`frequency_time` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`preferred_channel` tinyint(1) NOT NULL,
`pause_from_date` datetime DEFAULT NULL,
`pause_to_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_867C91D55458D` (`lead_id`),
KEY `[[dbprefix]]channel_frequency` (`channel`),
KEY `[[dbprefix]]idx_frequency_date_added` (`lead_id`,`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`lead_id`,`ip_id`),
KEY `IDX_ECF30567A03F5E9F` (`ip_id`)
) 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`public_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`filters` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`is_global` tinyint(1) NOT NULL,
`is_preference_center` tinyint(1) NOT NULL,
`last_built_date` datetime DEFAULT NULL,
`last_built_time` double DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_B6824B2F12469DE2` (`category_id`),
KEY `[[dbprefix]]lead_list_alias` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`leadlist_id`,`lead_id`),
KEY `IDX_C2F28B6755458D` (`lead_id`),
KEY `[[dbprefix]]manually_removed` (`manually_removed`),
KEY `[[dbprefix]]lead_id_lists_id_removed` (`lead_id`,`leadlist_id`,`manually_removed`)
) 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 AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_BFBF720655458D` (`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_points_change_log`
--
CREATE TABLE `[[dbprefix]]lead_points_change_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`group_id` int(10) unsigned DEFAULT NULL,
`type` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
`event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`delta` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_3D6FE1055458D` (`lead_id`),
KEY `IDX_3D6FE10A03F5E9F` (`ip_id`),
KEY `IDX_3D6FE10FE54D947` (`group_id`),
KEY `[[dbprefix]]point_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_stages_change_log`
--
CREATE TABLE `[[dbprefix]]lead_stages_change_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`stage_id` int(10) unsigned DEFAULT NULL,
`event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_E4FEFC2F55458D` (`lead_id`),
KEY `IDX_E4FEFC2F2298D193` (`stage_id`),
KEY `[[dbprefix]]lead_stages_change_log_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]lead_tags`
--
CREATE TABLE `[[dbprefix]]lead_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `[[dbprefix]]lead_tag_search` (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`lead_id`,`tag_id`),
KEY `IDX_8590305BBAD26311` (`tag_id`)
) 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 AUTO_INCREMENT,
`lead_id` bigint(20) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`referer` longtext COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` longtext COLLATE utf8mb4_unicode_ci,
`user_agent` longtext COLLATE utf8mb4_unicode_ci,
`utm_campaign` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_medium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_term` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_DC074F4B55458D` (`lead_id`),
KEY `[[dbprefix]]utm_date_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]messages`
--
CREATE TABLE `[[dbprefix]]messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_ED5EE27412469DE2` (`category_id`),
KEY `[[dbprefix]]date_message_added` (`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]message_channels`
--
CREATE TABLE `[[dbprefix]]message_channels` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`message_id` int(10) unsigned NOT NULL,
`channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int(11) DEFAULT NULL,
`properties` json NOT NULL,
`is_enabled` tinyint(1) NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]channel_index` (`message_id`,`channel`),
KEY `IDX_CD34D1BC537A1329` (`message_id`),
KEY `[[dbprefix]]channel_entity_index` (`channel`,`channel_id`),
KEY `[[dbprefix]]channel_enabled_index` (`channel`,`is_enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]message_queue`
--
CREATE TABLE `[[dbprefix]]message_queue` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned NOT NULL,
`channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int(11) NOT NULL,
`priority` smallint(6) NOT NULL,
`max_attempts` smallint(6) NOT NULL,
`attempts` smallint(6) NOT NULL,
`success` tinyint(1) NOT NULL,
`status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_published` datetime DEFAULT NULL,
`scheduled_date` datetime DEFAULT NULL,
`last_attempt` datetime DEFAULT NULL,
`date_sent` datetime DEFAULT NULL,
`options` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_F245FB8971F7E88B` (`event_id`),
KEY `IDX_F245FB8955458D` (`lead_id`),
KEY `[[dbprefix]]message_status_search` (`status`),
KEY `[[dbprefix]]message_date_sent` (`date_sent`),
KEY `[[dbprefix]]message_scheduled_date` (`scheduled_date`),
KEY `[[dbprefix]]message_priority` (`priority`),
KEY `[[dbprefix]]message_success` (`success`),
KEY `[[dbprefix]]message_channel_search` (`channel`,`channel_id`),
KEY `[[dbprefix]]message_queue_date_published` (`date_published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]monitoring`
--
CREATE TABLE `[[dbprefix]]monitoring` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`lists` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`network_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revision` int(11) NOT NULL,
`stats` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`properties` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_620C8E5812469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`monitor_id`,`lead_id`),
KEY `IDX_72268D5155458D` (`lead_id`)
) 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 AUTO_INCREMENT,
`monitor_id` int(10) unsigned DEFAULT NULL,
`post_date` date NOT NULL,
`post_count` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_6943BBE94CE1C902` (`monitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]notifications`
--
CREATE TABLE `[[dbprefix]]notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`type` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`header` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
`icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_read` tinyint(1) NOT NULL,
`deduplicate` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_121ECBD2A76ED395` (`user_id`),
KEY `[[dbprefix]]notification_read_status` (`is_read`),
KEY `[[dbprefix]]notification_type` (`type`),
KEY `[[dbprefix]]notification_user_read_status` (`is_read`,`user_id`),
KEY `[[dbprefix]]deduplicate_date_added` (`deduplicate`,`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]oauth2_accesstokens`
--
CREATE TABLE `[[dbprefix]]oauth2_accesstokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint(20) DEFAULT NULL,
`scope` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_98F554B35F37A13B` (`token`),
KEY `IDX_98F554B319EB6921` (`client_id`),
KEY `IDX_98F554B3A76ED395` (`user_id`),
KEY `[[dbprefix]]oauth2_access_token_search` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]oauth2_authcodes`
--
CREATE TABLE `[[dbprefix]]oauth2_authcodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint(20) DEFAULT NULL,
`scope` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_uri` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_E5B273605F37A13B` (`token`),
KEY `IDX_E5B2736019EB6921` (`client_id`),
KEY `IDX_E5B27360A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]oauth2_clients`
--
CREATE TABLE `[[dbprefix]]oauth2_clients` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`role_id` int(10) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`random_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`redirect_uris` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`allowed_grant_types` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_8EA5040BD60322AC` (`role_id`),
KEY `[[dbprefix]]client_id_search` (`random_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]oauth2_refreshtokens`
--
CREATE TABLE `[[dbprefix]]oauth2_refreshtokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint(20) DEFAULT NULL,
`scope` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_EBF8EC595F37A13B` (`token`),
KEY `IDX_EBF8EC5919EB6921` (`client_id`),
KEY `IDX_EBF8EC59A76ED395` (`user_id`),
KEY `[[dbprefix]]oauth2_refresh_token_search` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`client_id`,`user_id`),
KEY `IDX_9511903EA76ED395` (`user_id`)
) 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`translation_parent_id` int(10) unsigned DEFAULT NULL,
`variant_parent_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`alias` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_html` longtext COLLATE utf8mb4_unicode_ci,
`content` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`hits` int(11) NOT NULL,
`unique_hits` int(11) NOT NULL,
`variant_hits` int(11) NOT NULL,
`revision` int(11) NOT NULL,
`meta_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`head_script` longtext COLLATE utf8mb4_unicode_ci,
`footer_script` longtext COLLATE utf8mb4_unicode_ci,
`redirect_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_url` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_preference_center` tinyint(1) DEFAULT NULL,
`no_index` tinyint(1) DEFAULT NULL,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_DAACF28D12469DE2` (`category_id`),
KEY `IDX_DAACF28D9091A2FB` (`translation_parent_id`),
KEY `IDX_DAACF28D91861123` (`variant_parent_id`),
KEY `[[dbprefix]]page_alias_search` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]page_hits`
--
CREATE TABLE `[[dbprefix]]page_hits` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`page_id` int(10) unsigned DEFAULT NULL,
`redirect_id` bigint(20) unsigned DEFAULT NULL,
`email_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`device_id` bigint(20) unsigned DEFAULT NULL,
`date_hit` datetime NOT NULL,
`date_left` datetime DEFAULT NULL,
`country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` int(11) NOT NULL,
`referer` longtext COLLATE utf8mb4_unicode_ci,
`url` longtext COLLATE utf8mb4_unicode_ci,
`url_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` longtext COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`page_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`browser_languages` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`tracking_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_D379AF59C4663E4` (`page_id`),
KEY `IDX_D379AF59B42D874D` (`redirect_id`),
KEY `IDX_D379AF59A832C1C9` (`email_id`),
KEY `IDX_D379AF5955458D` (`lead_id`),
KEY `IDX_D379AF59A03F5E9F` (`ip_id`),
KEY `IDX_D379AF5994A4C7D4` (`device_id`),
KEY `[[dbprefix]]page_hit_tracking_search` (`tracking_id`),
KEY `[[dbprefix]]page_hit_code_search` (`code`),
KEY `[[dbprefix]]page_hit_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]date_hit_left_index` (`date_hit`,`date_left`),
KEY `[[dbprefix]]page_hit_url` (`url`(128))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]page_redirects`
--
CREATE TABLE `[[dbprefix]]page_redirects` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_id` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
`url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`hits` int(11) NOT NULL,
`unique_hits` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]permissions`
--
CREATE TABLE `[[dbprefix]]permissions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`role_id` int(10) unsigned NOT NULL,
`bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`bitwise` int(11) NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]unique_perm` (`bundle`,`name`,`role_id`),
KEY `IDX_5D5F7BF9D60322AC` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]plugins`
--
CREATE TABLE `[[dbprefix]]plugins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`is_missing` tinyint(1) NOT NULL,
`bundle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `[[dbprefix]]unique_bundle` (`bundle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- 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 AUTO_INCREMENT,
`plugin_id` int(10) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_published` tinyint(1) NOT NULL,
`supported_features` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`api_keys` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`feature_settings` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_174FDB61EC942BCF` (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=4 ;
--
-- 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`group_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`repeatable` tinyint(1) NOT NULL,
`delta` int(11) NOT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_94262C1012469DE2` (`category_id`),
KEY `IDX_94262C10FE54D947` (`group_id`),
KEY `[[dbprefix]]point_type_search` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]point_groups`
--
CREATE TABLE `[[dbprefix]]point_groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`contact_id`,`group_id`),
KEY `IDX_3C1164D3FE54D947` (`group_id`)
) 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,
PRIMARY KEY (`point_id`,`lead_id`),
KEY `IDX_F5F21E5D55458D` (`lead_id`),
KEY `IDX_F5F21E5DA03F5E9F` (`ip_id`)
) 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,
PRIMARY KEY (`event_id`,`lead_id`),
KEY `IDX_1BD70AF855458D` (`lead_id`),
KEY `IDX_1BD70AF8A03F5E9F` (`ip_id`)
) 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 AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`group_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`points` int(11) NOT NULL,
`color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
`trigger_existing_leads` tinyint(1) NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_EBDEFDC212469DE2` (`category_id`),
KEY `IDX_EBDEFDC2FE54D947` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]point_trigger_events`
--
CREATE TABLE `[[dbprefix]]point_trigger_events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`trigger_id` int(10) unsigned NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`action_order` int(11) NOT NULL,
`properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_D422DE1A5FDDDCD6` (`trigger_id`),
KEY `[[dbprefix]]trigger_type_search` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]push_ids`
--
CREATE TABLE `[[dbprefix]]push_ids` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`push_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`enabled` tinyint(1) NOT NULL,
`mobile` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_797F6F0A55458D` (`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]push_notifications`
--
CREATE TABLE `[[dbprefix]]push_notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`url` longtext COLLATE utf8mb4_unicode_ci,
`heading` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`button` longtext COLLATE utf8mb4_unicode_ci,
`utm_tags` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`notification_type` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`read_count` int(11) NOT NULL,
`sent_count` int(11) NOT NULL,
`mobile` tinyint(1) NOT NULL,
`mobileSettings` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_D174E56C12469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`notification_id`,`leadlist_id`),
KEY `IDX_C46CEE6EB9FC8874` (`leadlist_id`)
) 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 AUTO_INCREMENT,
`notification_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`list_id` int(10) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`date_sent` datetime NOT NULL,
`date_read` datetime DEFAULT NULL,
`is_clicked` tinyint(1) NOT NULL,
`date_clicked` datetime DEFAULT NULL,
`tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`retry_count` int(11) DEFAULT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`click_count` int(11) DEFAULT NULL,
`last_clicked` datetime DEFAULT NULL,
`click_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_5191BD73EF1A9D84` (`notification_id`),
KEY `IDX_5191BD7355458D` (`lead_id`),
KEY `IDX_5191BD733DAE168B` (`list_id`),
KEY `IDX_5191BD73A03F5E9F` (`ip_id`),
KEY `[[dbprefix]]stat_notification_search` (`notification_id`,`lead_id`),
KEY `[[dbprefix]]stat_notification_clicked_search` (`is_clicked`),
KEY `[[dbprefix]]stat_notification_hash_search` (`tracking_hash`),
KEY `[[dbprefix]]stat_notification_source_search` (`source`,`source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reports`
--
CREATE TABLE `[[dbprefix]]reports` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`system` tinyint(1) NOT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`columns` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`filters` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`table_order` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`graphs` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`group_by` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`aggregators` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`settings` json DEFAULT NULL,
`is_scheduled` tinyint(1) NOT NULL,
`schedule_unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`to_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`schedule_day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`schedule_month_frequency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=6 ;
--
-- 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, 'e9418c76-a908-4077-bd73-6789b4135d05'),
(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, 'bc1bb114-44ef-43c5-9517-838b0f6d647b'),
(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, 'e1918c7a-e7db-46b4-8ab9-b7f41ce35e12'),
(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, '97a922a7-be9b-4e14-a621-56e674b2be57'),
(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, '93625f84-5b7b-42ee-bc38-49540ad81a7c');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]reports_schedulers`
--
CREATE TABLE `[[dbprefix]]reports_schedulers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`report_id` int(10) unsigned NOT NULL,
`schedule_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_4DA33D9B4BD2A4C0` (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]roles`
--
CREATE TABLE `[[dbprefix]]roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`is_admin` tinyint(1) NOT NULL,
`readable_permissions` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- 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;', 'd06fe186-62b1-40db-b588-cf8735620920');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]saml_id_entry`
--
CREATE TABLE `[[dbprefix]]saml_id_entry` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`entity_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`expiryTimestamp` int(11) NOT NULL,
PRIMARY KEY (`id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sms_messages`
--
CREATE TABLE `[[dbprefix]]sms_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`sms_type` longtext COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`sent_count` int(11) NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_A4E8BB5112469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`sms_id`,`leadlist_id`),
KEY `IDX_2839A825B9FC8874` (`leadlist_id`)
) 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 AUTO_INCREMENT,
`sms_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`list_id` int(10) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`date_sent` datetime NOT NULL,
`is_failed` tinyint(1) DEFAULT NULL,
`tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`details` json NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_85B375F2BD5C7E60` (`sms_id`),
KEY `IDX_85B375F255458D` (`lead_id`),
KEY `IDX_85B375F23DAE168B` (`list_id`),
KEY `IDX_85B375F2A03F5E9F` (`ip_id`),
KEY `[[dbprefix]]stat_sms_search` (`sms_id`,`lead_id`),
KEY `[[dbprefix]]stat_sms_hash_search` (`tracking_hash`),
KEY `[[dbprefix]]stat_sms_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]stat_sms_failed_search` (`is_failed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]stages`
--
CREATE TABLE `[[dbprefix]]stages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`weight` int(11) NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '(DC2Type:guid)',
PRIMARY KEY (`id`),
KEY `IDX_9C3EC85D12469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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,
PRIMARY KEY (`stage_id`,`lead_id`),
KEY `IDX_3D0DFBB555458D` (`lead_id`),
KEY `IDX_3D0DFBB5A03F5E9F` (`ip_id`)
) 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 AUTO_INCREMENT,
`integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` bigint(20) unsigned NOT NULL,
`object_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`modified_at` datetime NOT NULL,
`column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`column_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`column_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `[[dbprefix]]object_composite_key` (`object_type`,`object_id`,`column_name`),
KEY `[[dbprefix]]integration_object_composite_key` (`integration`,`object_type`,`object_id`,`column_name`),
KEY `[[dbprefix]]integration_object_type_modification_composite_key` (`integration`,`object_type`,`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sync_object_mapping`
--
CREATE TABLE `[[dbprefix]]sync_object_mapping` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date_created` datetime NOT NULL,
`integration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`internal_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`internal_object_id` bigint(20) unsigned NOT NULL,
`integration_object_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`integration_object_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_sync_date` datetime NOT NULL,
`internal_storage` json NOT NULL,
`is_deleted` tinyint(1) NOT NULL,
`integration_reference_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `[[dbprefix]]internal_object_id_idx` (`internal_object_id`),
KEY `[[dbprefix]]integration_object` (`integration`,`integration_object_name`,`integration_object_id`,`integration_reference_id`),
KEY `[[dbprefix]]integration_reference` (`integration`,`integration_object_name`,`integration_reference_id`,`integration_object_id`),
KEY `[[dbprefix]]integration_integration_object_name_last_sync_date` (`integration`,`internal_object_name`,`last_sync_date`),
KEY `[[dbprefix]]integration_last_sync_date` (`integration`,`last_sync_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tweets`
--
CREATE TABLE `[[dbprefix]]tweets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`page_id` int(10) unsigned DEFAULT NULL,
`asset_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`media_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`media_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`sent_count` int(11) DEFAULT NULL,
`favorite_count` int(11) DEFAULT NULL,
`retweet_count` int(11) DEFAULT NULL,
`lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_19A4E21C12469DE2` (`category_id`),
KEY `IDX_19A4E21CC4663E4` (`page_id`),
KEY `IDX_19A4E21C5DA1941` (`asset_id`),
KEY `[[dbprefix]]sent_count_index` (`sent_count`),
KEY `[[dbprefix]]favorite_count_index` (`favorite_count`),
KEY `[[dbprefix]]retweet_count_index` (`retweet_count`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]tweet_stats`
--
CREATE TABLE `[[dbprefix]]tweet_stats` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tweet_id` int(10) unsigned DEFAULT NULL,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`twitter_tweet_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`handle` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_sent` datetime DEFAULT NULL,
`is_failed` tinyint(1) DEFAULT NULL,
`retry_count` int(11) DEFAULT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int(11) DEFAULT NULL,
`favorite_count` int(11) DEFAULT NULL,
`retweet_count` int(11) DEFAULT NULL,
`response_details` json DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_BB3E0D731041E39B` (`tweet_id`),
KEY `IDX_BB3E0D7355458D` (`lead_id`),
KEY `[[dbprefix]]stat_tweet_search` (`tweet_id`,`lead_id`),
KEY `[[dbprefix]]stat_tweet_search2` (`lead_id`,`tweet_id`),
KEY `[[dbprefix]]stat_tweet_failed_search` (`is_failed`),
KEY `[[dbprefix]]stat_tweet_source_search` (`source`,`source_id`),
KEY `[[dbprefix]]favorite_count_index` (`favorite_count`),
KEY `[[dbprefix]]retweet_count_index` (`retweet_count`),
KEY `[[dbprefix]]tweet_date_sent` (`date_sent`),
KEY `[[dbprefix]]twitter_tweet_id_index` (`twitter_tweet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]users`
--
CREATE TABLE `[[dbprefix]]users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`timezone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`locale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_active` datetime DEFAULT NULL,
`preferences` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`signature` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_EE5BB211F85E0677` (`username`),
UNIQUE KEY `UNIQ_EE5BB211E7927C74` (`email`),
KEY `IDX_EE5BB211D60322AC` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- 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 AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`authorizator` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` datetime DEFAULT NULL,
`one_time_only` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_BFBABD255CA2E8E5` (`secret`),
KEY `IDX_BFBABD25A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]video_hits`
--
CREATE TABLE `[[dbprefix]]video_hits` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint(20) unsigned DEFAULT NULL,
`ip_id` int(10) unsigned DEFAULT NULL,
`date_hit` datetime NOT NULL,
`date_left` datetime DEFAULT NULL,
`country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` int(11) NOT NULL,
`referer` longtext COLLATE utf8mb4_unicode_ci,
`url` longtext COLLATE utf8mb4_unicode_ci,
`user_agent` longtext COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`guid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`page_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`browser_languages` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`channel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int(11) DEFAULT NULL,
`time_watched` int(11) DEFAULT NULL,
`duration` int(11) DEFAULT NULL,
`query` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_C55B28F255458D` (`lead_id`),
KEY `IDX_C55B28F2A03F5E9F` (`ip_id`),
KEY `[[dbprefix]]video_date_hit` (`date_hit`),
KEY `[[dbprefix]]video_channel_search` (`channel`,`channel_id`),
KEY `[[dbprefix]]video_guid_lead_search` (`guid`,`lead_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]webhooks`
--
CREATE TABLE `[[dbprefix]]webhooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(10) unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci,
`webhook_url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`events_orderby_dir` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_AFD0B33F12469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]webhook_events`
--
CREATE TABLE `[[dbprefix]]webhook_events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int(10) unsigned NOT NULL,
`event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_DA160DA5C9BA60B` (`webhook_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]webhook_logs`
--
CREATE TABLE `[[dbprefix]]webhook_logs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int(10) unsigned NOT NULL,
`status_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime DEFAULT NULL,
`note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`runtime` double DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_5CBFD7815C9BA60B` (`webhook_id`),
KEY `[[dbprefix]]webhook_id_date_added` (`webhook_id`,`date_added`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]webhook_queue`
--
CREATE TABLE `[[dbprefix]]webhook_queue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int(10) unsigned NOT NULL,
`event_id` int(10) unsigned NOT NULL,
`date_added` datetime DEFAULT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci,
`payload_compressed` mediumblob,
PRIMARY KEY (`id`),
KEY `IDX_8733E11B5C9BA60B` (`webhook_id`),
KEY `IDX_8733E11B71F7E88B` (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]widgets`
--
CREATE TABLE `[[dbprefix]]widgets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`created_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`modified_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int(11) DEFAULT NULL,
`checked_out_by_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL,
`cache_timeout` int(11) DEFAULT NULL,
`ordering` int(11) DEFAULT NULL,
`params` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `[[dbprefix]]assets`
--
ALTER TABLE `[[dbprefix]]assets`
ADD CONSTRAINT `FK_CA4DDFB712469DE2` 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_7885A76455458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_7885A7645DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_7885A764A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_7885A764A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]bundle_grapesjsbuilder`
--
ALTER TABLE `[[dbprefix]]bundle_grapesjsbuilder`
ADD CONSTRAINT `FK_C1EB39DBA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]campaigns`
--
ALTER TABLE `[[dbprefix]]campaigns`
ADD CONSTRAINT `FK_AD41ABD812469DE2` 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_5008C50C727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`),
ADD CONSTRAINT `FK_5008C50CF639F774` 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_BAA733915FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_BAA73391F639F774` 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_F3CAD7F2B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_F3CAD7F2F639F774` 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_2EE00FD055458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_2EE00FD0F639F774` 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_450DB7E7EA675D86` 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_38B0DF8C55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_38B0DF8C71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`),
ADD CONSTRAINT `FK_38B0DF8CA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_38B0DF8CF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`);
--
-- Constraints for table `[[dbprefix]]campaign_summary`
--
ALTER TABLE `[[dbprefix]]campaign_summary`
ADD CONSTRAINT `FK_51940D5471F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_51940D54F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `[[dbprefix]]campaigns` (`id`);
--
-- Constraints for table `[[dbprefix]]channel_url_trackables`
--
ALTER TABLE `[[dbprefix]]channel_url_trackables`
ADD CONSTRAINT `FK_B8CB76C1B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `[[dbprefix]]page_redirects` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]companies`
--
ALTER TABLE `[[dbprefix]]companies`
ADD CONSTRAINT `FK_CC7675927E3C61F9` 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_2AD5E15D55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_2AD5E15D979B1AD6` 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_4F900E9DA76ED395` 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_41BFA6B4E7A1254A` 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_FE75355912469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FE7535599091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]dynamic_content` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_FE75355991861123` 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_F0CFE1CB55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_F0CFE1CBD9D0CD7` 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_7C84EB8B55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_7C84EB8BD9D0CD7` 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_FF1D4A6B12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FF1D4A6B2DC494F6` FOREIGN KEY (`unsubscribeform_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FF1D4A6B834F9C5B` FOREIGN KEY (`preference_center_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FF1D4A6B9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_FF1D4A6B91861123` 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_A0DF7ED6A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`);
--
-- Constraints for table `[[dbprefix]]email_assets_xref`
--
ALTER TABLE `[[dbprefix]]email_assets_xref`
ADD CONSTRAINT `FK_406398635DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_40639863A832C1C9` 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_9FD1BF92A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_9FD1BF92B9FC8874` 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_F0E81BF7A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_F0E81BF7B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]email_stats`
--
ALTER TABLE `[[dbprefix]]email_stats`
ADD CONSTRAINT `FK_BAB891B33DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_BAB891B355458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_BAB891B3A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_BAB891B3A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_BAB891B3A8752772` 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_D867828694A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `[[dbprefix]]lead_devices` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_D86782869502F0B` FOREIGN KEY (`stat_id`) REFERENCES `[[dbprefix]]email_stats` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_D8678286A03F5E9F` 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_9B066DC39502F0B` FOREIGN KEY (`stat_id`) REFERENCES `[[dbprefix]]email_stats` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]focus`
--
ALTER TABLE `[[dbprefix]]focus`
ADD CONSTRAINT `FK_98185D1112469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]focus_stats`
--
ALTER TABLE `[[dbprefix]]focus_stats`
ADD CONSTRAINT `FK_B3DBC74A51804B42` FOREIGN KEY (`focus_id`) REFERENCES `[[dbprefix]]focus` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_B3DBC74A55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]forms`
--
ALTER TABLE `[[dbprefix]]forms`
ADD CONSTRAINT `FK_7E70C0F12469DE2` 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_2D3815125FF69B7D` 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_CB980B05FF69B7D` 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_FF0C0EFD55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FF0C0EFD5FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `[[dbprefix]]forms` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_FF0C0EFDA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_FF0C0EFDC4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]leads`
--
ALTER TABLE `[[dbprefix]]leads`
ADD CONSTRAINT `FK_ED4852AA2298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_ED4852AA7E3C61F9` 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_CCA4B61F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_CCA4B61F55458D` 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_1A00BCB55458D` 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_51D5963255458D` 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_FB8EC40655458D` 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_702681C355458D` 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_867C91D55458D` 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_ECF3056755458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_ECF30567A03F5E9F` 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_B6824B2F12469DE2` 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_C2F28B6755458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_C2F28B67B9FC8874` 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_BFBF720655458D` 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_3D6FE1055458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_3D6FE10A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_3D6FE10FE54D947` 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_E4FEFC2F2298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_E4FEFC2F55458D` 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_8590305B55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_8590305BBAD26311` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]lead_tags` (`id`);
--
-- Constraints for table `[[dbprefix]]lead_utmtags`
--
ALTER TABLE `[[dbprefix]]lead_utmtags`
ADD CONSTRAINT `FK_DC074F4B55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]messages`
--
ALTER TABLE `[[dbprefix]]messages`
ADD CONSTRAINT `FK_ED5EE27412469DE2` 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_CD34D1BC537A1329` 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_F245FB8955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_F245FB8971F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]monitoring`
--
ALTER TABLE `[[dbprefix]]monitoring`
ADD CONSTRAINT `FK_620C8E5812469DE2` 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_72268D514CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_72268D5155458D` 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_6943BBE94CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]notifications`
--
ALTER TABLE `[[dbprefix]]notifications`
ADD CONSTRAINT `FK_121ECBD2A76ED395` 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_98F554B319EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_98F554B3A76ED395` 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_E5B2736019EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_E5B27360A76ED395` 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_8EA5040BD60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);
--
-- Constraints for table `[[dbprefix]]oauth2_refreshtokens`
--
ALTER TABLE `[[dbprefix]]oauth2_refreshtokens`
ADD CONSTRAINT `FK_EBF8EC5919EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_EBF8EC59A76ED395` 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_9511903E19EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_9511903EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]pages`
--
ALTER TABLE `[[dbprefix]]pages`
ADD CONSTRAINT `FK_DAACF28D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_DAACF28D9091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_DAACF28D91861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]page_hits`
--
ALTER TABLE `[[dbprefix]]page_hits`
ADD CONSTRAINT `FK_D379AF5955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_D379AF5994A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `[[dbprefix]]lead_devices` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_D379AF59A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_D379AF59A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_D379AF59B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `[[dbprefix]]page_redirects` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_D379AF59C4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]permissions`
--
ALTER TABLE `[[dbprefix]]permissions`
ADD CONSTRAINT `FK_5D5F7BF9D60322AC` 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_174FDB61EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `[[dbprefix]]plugins` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]points`
--
ALTER TABLE `[[dbprefix]]points`
ADD CONSTRAINT `FK_94262C1012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_94262C10FE54D947` 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_3C1164D3E7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_3C1164D3FE54D947` 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_F5F21E5D55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_F5F21E5DA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_F5F21E5DC028CEA2` 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_1BD70AF855458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_1BD70AF871F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]point_trigger_events` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_1BD70AF8A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]point_triggers`
--
ALTER TABLE `[[dbprefix]]point_triggers`
ADD CONSTRAINT `FK_EBDEFDC212469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_EBDEFDC2FE54D947` 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_D422DE1A5FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `[[dbprefix]]point_triggers` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `[[dbprefix]]push_ids`
--
ALTER TABLE `[[dbprefix]]push_ids`
ADD CONSTRAINT `FK_797F6F0A55458D` 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_D174E56C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]push_notification_list_xref`
--
ALTER TABLE `[[dbprefix]]push_notification_list_xref`
ADD CONSTRAINT `FK_C46CEE6EB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_C46CEE6EEF1A9D84` 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_5191BD733DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_5191BD7355458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_5191BD73A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_5191BD73EF1A9D84` 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_4DA33D9B4BD2A4C0` 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_A4E8BB5112469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]sms_message_list_xref`
--
ALTER TABLE `[[dbprefix]]sms_message_list_xref`
ADD CONSTRAINT `FK_2839A825B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_2839A825BD5C7E60` 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_85B375F23DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_85B375F255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_85B375F2A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_85B375F2BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]stages`
--
ALTER TABLE `[[dbprefix]]stages`
ADD CONSTRAINT `FK_9C3EC85D12469DE2` 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_3D0DFBB52298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_3D0DFBB555458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_3D0DFBB5A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]tweets`
--
ALTER TABLE `[[dbprefix]]tweets`
ADD CONSTRAINT `FK_19A4E21C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_19A4E21C5DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_19A4E21CC4663E4` 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_BB3E0D731041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `[[dbprefix]]tweets` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_BB3E0D7355458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `[[dbprefix]]users`
--
ALTER TABLE `[[dbprefix]]users`
ADD CONSTRAINT `FK_EE5BB211D60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);
--
-- Constraints for table `[[dbprefix]]user_tokens`
--
ALTER TABLE `[[dbprefix]]user_tokens`
ADD CONSTRAINT `FK_BFBABD25A76ED395` 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_C55B28F255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `FK_C55B28F2A03F5E9F` 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_AFD0B33F12469DE2` 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_DA160DA5C9BA60B` 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_5CBFD7815C9BA60B` 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_8733E11B5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_8733E11B71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]webhook_events` (`id`) ON DELETE CASCADE;
/*!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 */;