Skip to content

Instantly share code, notes, and snippets.

@leoborlot

leoborlot/_Instruções.md

Last active August 30, 2023 18:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save leoborlot/307e3e9cd3da773cd859bdb97da9fdc0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save leoborlot/307e3e9cd3da773cd859bdb97da9fdc0 to your computer and use it in GitHub Desktop.
Download ZIP
Processo de atualização de banco de dados dos mautic 2 para o Mautic 4. Processo exclusivo para as versões 2.16 -> 4.4.3. Para utilizar para outras versões é necessário revisar a estrutura do banco em anexo para adequações.
Raw
_Instruções.md

Instruções para migração do Mautic 2 para o Mautic 4.

SERVIDOR DOADOR

1- Copiar o arquivo baixar.sh para o servidor doador.

1- Utilizar o script 'baixar.sh' no servidor doador, informando <nome_do_banco> <host_do_banco> <senha_do_banco>. (Pegar estes dados usuario root no Agiuscloud). Execute conforme o exemplo abaixo.

bash baixar.sh nome_do_banco host_do_banco senha_do_banco

2- Copiar arquivos NOMEDOBANCO_forms_result.sql NOMEDOBANCO_dados.sql para o servidor receptor. Para facilitar o processo execute o zip dos arquivos de acordo com o comando abaixo:

zip NOMEDOBANCO.zip NOMEDOBANCO_forms_result.sql NOMEDOBANCO_dados.sql

3- Mova os arquivos para a pasta raiz do Mautic para facilitar a transferencia dos arquivos entre os servidores.

mv  NOMEDOBANCO.zip /var/opv/DOMINIO.com.br/htdocs

SERVIDOR RECEPTOR

4- Baixe o arquivo com os bancos de dados no servidor Receptor.

wget https://DOMINIODOMAUTIC.com.br/NOMEDOBANCO.zip

3- Ao baixar o banco de dados do servidor doador no servidor receptor. Execute o unzip.

unzip NOMEDOBANCO_dados.sql

4- Na mesma pasta que estão os arquivos do banco doador. Execute o script que irá modificar e subir o banco.

bash subir.sh nome_do_banco host_do_banco senha_do_banco

5- Execute o script de instalação novamente e instale o Mautic de acordo com o banco migrado.

wget leob.cc/mtcf4 && bash mtcf4

6- Após a completa instalação, acesse o console do container por dentro do Portainer. E execute os comandos abaixo.

mysql -e "ALTER TABLE forms ADD form_attr VARCHAR(255) DEFAULT NULL;";mysql -e "ALTER TABLE lead_donotcontact DROP INDEX dnc_channel_id_search;"; mysql -e "ALTER TABLE pages DROP COLUMN head_script;"; mtc-db-update -f; php /var/www/html/bin/console mautic:plugins:update; mtc-cache;

7- Caso tudo tenha dado certo, aponte o dominio do Mautic para o novo servidor e teste todas opções.

Raw
baixar.sh
#!/bin/bash
# Verifica se todos os parâmetros foram fornecidos
if [ $# -ne 3 ]; then
echo "Erro: Faltando parâmetros."
echo "Uso: ./script.sh <nome_do_banco> <host_do_banco> <senha_do_banco>"
exit 1
fi
# Atribui os valores dos parâmetros
DB_NAME=$1
DB_HOST=$2
DB_USER='root'
DB_PASSWORD=$3
# Baixa o banco de dados
echo "Baixando o banco de dados"
# Dump do banco de dados com sed
mysqldump --no-create-info --extended-insert -h$DB_HOST -u$DB_USER -p$DB_PASSWORD $DB_NAME | \
sed 's/`generated_sent_date` date GENERATED ALWAYS AS (concat(year(`date_sent`),\x27-\x27,lpad(month(`date_sent`),2,\x270\x27),\x27-\x27,lpad(dayofmonth(`date_sent`),2,\x270\x27))) VIRTUAL COMMENT \x27(DC2Type:generated)\x27/`generated_sent_date` date DEFAULT NULL/g' | \
sed 's/`generated_email_domain` varchar(255) GENERATED ALWAYS AS (substr(`email`,locate(\x27@\x27,`email`) + 1)) VIRTUAL COMMENT \x27(DC2Type:generated)\x27/`generated_email_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL/g' | \
sed 's/`mtc_/`/g' \
> ${DB_NAME}_dados.sql
echo "Banco de dados baixado"
#exit
# Baixa o banco de dados customizado
echo "Baixando o banco de custom"
# Dump do banco de dados ignorando tabelas específicas
mysqldump --no-data -h$DB_HOST -u$DB_USER -p$DB_PASSWORD \
--ignore-table=${DB_NAME}.mtc_asset_downloads \
--ignore-table=${DB_NAME}.mtc_assets \
--ignore-table=${DB_NAME}.mtc_audit_log \
--ignore-table=${DB_NAME}.mtc_cache_items \
--ignore-table=${DB_NAME}.mtc_campaign_events \
--ignore-table=${DB_NAME}.mtc_campaign_form_xref \
--ignore-table=${DB_NAME}.mtc_campaign_lead_event_failed_log \
--ignore-table=${DB_NAME}.mtc_campaign_lead_event_log \
--ignore-table=${DB_NAME}.mtc_campaign_leadlist_xref \
--ignore-table=${DB_NAME}.mtc_campaign_leads \
--ignore-table=${DB_NAME}.mtc_campaigns \
--ignore-table=${DB_NAME}.mtc_categories \
--ignore-table=${DB_NAME}.mtc_channel_url_trackables \
--ignore-table=${DB_NAME}.mtc_companies \
--ignore-table=${DB_NAME}.mtc_companies_leads \
--ignore-table=${DB_NAME}.mtc_contact_merge_records \
--ignore-table=${DB_NAME}.mtc_dynamic_content \
--ignore-table=${DB_NAME}.mtc_dynamic_content_lead_data \
--ignore-table=${DB_NAME}.mtc_dynamic_content_stats \
--ignore-table=${DB_NAME}.mtc_email_assets_xref \
--ignore-table=${DB_NAME}.mtc_email_copies \
--ignore-table=${DB_NAME}.mtc_email_list_xref \
--ignore-table=${DB_NAME}.mtc_email_stat_replies \
--ignore-table=${DB_NAME}.mtc_email_stats \
--ignore-table=${DB_NAME}.mtc_email_stats_devices \
--ignore-table=${DB_NAME}.mtc_emails \
--ignore-table=${DB_NAME}.mtc_focus \
--ignore-table=${DB_NAME}.mtc_focus_stats \
--ignore-table=${DB_NAME}.mtc_form_actions \
--ignore-table=${DB_NAME}.mtc_form_fields \
--ignore-table=${DB_NAME}.mtc_form_submissions \
--ignore-table=${DB_NAME}.mtc_forms \
--ignore-table=${DB_NAME}.mtc_imports \
--ignore-table=${DB_NAME}.mtc_integration_entity \
--ignore-table=${DB_NAME}.mtc_ip_addresses \
--ignore-table=${DB_NAME}.mtc_lead_categories \
--ignore-table=${DB_NAME}.mtc_lead_companies_change_log \
--ignore-table=${DB_NAME}.mtc_lead_devices \
--ignore-table=${DB_NAME}.mtc_lead_donotcontact \
--ignore-table=${DB_NAME}.mtc_lead_event_log \
--ignore-table=${DB_NAME}.mtc_lead_frequencyrules \
--ignore-table=${DB_NAME}.mtc_lead_ips_xref \
--ignore-table=${DB_NAME}.mtc_lead_lists \
--ignore-table=${DB_NAME}.mtc_lead_lists_leads \
--ignore-table=${DB_NAME}.mtc_lead_notes \
--ignore-table=${DB_NAME}.mtc_lead_points_change_log \
--ignore-table=${DB_NAME}.mtc_lead_stages_change_log \
--ignore-table=${DB_NAME}.mtc_lead_tags \
--ignore-table=${DB_NAME}.mtc_lead_tags_xref \
--ignore-table=${DB_NAME}.mtc_leads \
--ignore-table=${DB_NAME}.mtc_lead_fields \
--ignore-table=${DB_NAME}.mtc_lead_utmtags \
--ignore-table=${DB_NAME}.mtc_message_channels \
--ignore-table=${DB_NAME}.mtc_message_queue \
--ignore-table=${DB_NAME}.mtc_messages \
--ignore-table=${DB_NAME}.mtc_monitor_post_count \
--ignore-table=${DB_NAME}.mtc_monitoring \
--ignore-table=${DB_NAME}.mtc_monitoring_leads \
--ignore-table=${DB_NAME}.mtc_notifications \
--ignore-table=${DB_NAME}.mtc_oauth1_access_tokens \
--ignore-table=${DB_NAME}.mtc_oauth1_consumers \
--ignore-table=${DB_NAME}.mtc_oauth1_nonces \
--ignore-table=${DB_NAME}.mtc_oauth1_request_tokens \
--ignore-table=${DB_NAME}.mtc_oauth2_accesstokens \
--ignore-table=${DB_NAME}.mtc_oauth2_authcodes \
--ignore-table=${DB_NAME}.mtc_oauth2_clients \
--ignore-table=${DB_NAME}.mtc_oauth2_refreshtokens \
--ignore-table=${DB_NAME}.mtc_oauth2_user_client_xref \
--ignore-table=${DB_NAME}.mtc_page_hits \
--ignore-table=${DB_NAME}.mtc_page_redirects \
--ignore-table=${DB_NAME}.mtc_pages \
--ignore-table=${DB_NAME}.mtc_permissions \
--ignore-table=${DB_NAME}.mtc_plugin_citrix_events \
--ignore-table=${DB_NAME}.mtc_plugin_crm_pipedrive_owners \
--ignore-table=${DB_NAME}.mtc_plugin_integration_settings \
--ignore-table=${DB_NAME}.mtc_plugins \
--ignore-table=${DB_NAME}.mtc_point_lead_action_log \
--ignore-table=${DB_NAME}.mtc_point_lead_event_log \
--ignore-table=${DB_NAME}.mtc_point_trigger_events \
--ignore-table=${DB_NAME}.mtc_point_triggers \
--ignore-table=${DB_NAME}.mtc_points \
--ignore-table=${DB_NAME}.mtc_push_ids \
--ignore-table=${DB_NAME}.mtc_push_notification_list_xref \
--ignore-table=${DB_NAME}.mtc_push_notification_stats \
--ignore-table=${DB_NAME}.mtc_push_notifications \
--ignore-table=${DB_NAME}.mtc_reports \
--ignore-table=${DB_NAME}.mtc_reports_schedulers \
--ignore-table=${DB_NAME}.mtc_roles \
--ignore-table=${DB_NAME}.mtc_saml_id_entry \
--ignore-table=${DB_NAME}.mtc_sms_message_list_xref \
--ignore-table=${DB_NAME}.mtc_sms_message_stats \
--ignore-table=${DB_NAME}.mtc_sms_messages \
--ignore-table=${DB_NAME}.mtc_stage_lead_action_log \
--ignore-table=${DB_NAME}.mtc_stages \
--ignore-table=${DB_NAME}.mtc_tweet_stats \
--ignore-table=${DB_NAME}.mtc_tweets \
--ignore-table=${DB_NAME}.mtc_user_tokens \
--ignore-table=${DB_NAME}.mtc_users \
--ignore-table=${DB_NAME}.mtc_video_hits \
--ignore-table=${DB_NAME}.mtc_webhook_events \
--ignore-table=${DB_NAME}.mtc_webhook_logs \
--ignore-table=${DB_NAME}.mtc_widgets \
--ignore-table=${DB_NAME}.mtc_webhook_queue \
--ignore-table=${DB_NAME}.mtc_webhooks ${DB_NAME} | sed 's/`mtc_/`/g' > ${DB_NAME}_forms_result.sql
echo "Dump finalizado"
zip "${DB_NAME}.zip" "${DB_NAME}_dados.sql" "${DB_NAME}_forms_result.sql"
echo "Arquivos Zipados"
rm "${DB_NAME}_dados.sql"
rm "${DB_NAME}_forms_result.sql"
echo "Arquivos temporários removidos"
Raw
estrutura_mtc4_ajustado.sql
-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)
--
-- Host: 147.182.219.231 Database: mautic_hotelgloria_com_br
-- ------------------------------------------------------
-- Server version 8.0.33
/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `asset_downloads`
--
DROP TABLE IF EXISTS `asset_downloads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_downloads` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`asset_id` int unsigned DEFAULT NULL,
`ip_id` int unsigned NOT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`email_id` int unsigned DEFAULT NULL,
`date_download` datetime NOT NULL,
`code` int NOT NULL,
`referer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`tracking_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_A6494C8F5DA1941` (`asset_id`),
KEY `IDX_A6494C8FA03F5E9F` (`ip_id`),
KEY `IDX_A6494C8F55458D` (`lead_id`),
KEY `IDX_A6494C8FA832C1C9` (`email_id`),
KEY `download_tracking_search` (`tracking_id`),
KEY `download_source_search` (`source`,`source_id`),
KEY `asset_date_download` (`date_download`),
CONSTRAINT `FK_A6494C8F55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_A6494C8F5DA1941` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_A6494C8FA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_A6494C8FA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2240 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `assets`
--
DROP TABLE IF EXISTS `assets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `assets` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`storage_location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remote_path` longtext COLLATE utf8mb4_unicode_ci,
`original_file_name` longtext COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`download_count` int NOT NULL,
`unique_download_count` int NOT NULL,
`revision` int NOT NULL,
`extension` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`size` int DEFAULT NULL,
`disallow` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_79D17D8E12469DE2` (`category_id`),
KEY `asset_alias_search` (`alias`),
CONSTRAINT `FK_79D17D8E12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `audit_log`
--
DROP TABLE IF EXISTS `audit_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `audit_log` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`user_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`bundle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`object` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` bigint unsigned NOT NULL,
`action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`date_added` datetime NOT NULL,
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `object_search` (`object`,`object_id`),
KEY `timeline_search` (`bundle`,`object`,`action`,`object_id`),
KEY `date_added_index` (`date_added`)
) ENGINE=InnoDB AUTO_INCREMENT=358488 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `bundle_grapesjsbuilder`
--
DROP TABLE IF EXISTS `bundle_grapesjsbuilder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bundle_grapesjsbuilder` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`email_id` int unsigned DEFAULT NULL,
`custom_mjml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_56A1EB07A832C1C9` (`email_id`),
CONSTRAINT `FK_56A1EB07A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cache_items`
--
DROP TABLE IF EXISTS `cache_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_items` (
`item_id` varbinary(191) NOT NULL,
`item_data` longblob NOT NULL,
`item_lifetime` int unsigned DEFAULT NULL,
`item_time` int unsigned NOT NULL,
PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_events`
--
DROP TABLE IF EXISTS `campaign_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_events` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` int unsigned NOT NULL,
`parent_id` int unsigned DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_order` int NOT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`trigger_date` datetime DEFAULT NULL,
`trigger_interval` int DEFAULT NULL,
`trigger_interval_unit` varchar(1) CHARACTER SET utf8mb4 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`trigger_mode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`decision_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`temp_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_8EC42EE7F639F774` (`campaign_id`),
KEY `IDX_8EC42EE7727ACA70` (`parent_id`),
KEY `campaign_event_search` (`type`,`event_type`),
KEY `campaign_event_type` (`event_type`),
KEY `campaign_event_channel` (`channel`,`channel_id`),
CONSTRAINT `FK_8EC42EE7727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `campaign_events` (`id`),
CONSTRAINT `FK_8EC42EE7F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_form_xref`
--
DROP TABLE IF EXISTS `campaign_form_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_form_xref` (
`campaign_id` int unsigned NOT NULL,
`form_id` int unsigned NOT NULL,
PRIMARY KEY (`campaign_id`,`form_id`),
KEY `IDX_3048A8B2F639F774` (`campaign_id`),
KEY `IDX_3048A8B25FF69B7D` (`form_id`),
CONSTRAINT `FK_3048A8B25FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_3048A8B2F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_lead_event_failed_log`
--
DROP TABLE IF EXISTS `campaign_lead_event_failed_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_lead_event_failed_log` (
`log_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`log_id`),
KEY `campaign_event_failed_date` (`date_added`),
CONSTRAINT `FK_E50614D2EA675D86` FOREIGN KEY (`log_id`) REFERENCES `campaign_lead_event_log` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_lead_event_log`
--
DROP TABLE IF EXISTS `campaign_lead_event_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_lead_event_log` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`event_id` int unsigned NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`campaign_id` int unsigned DEFAULT NULL,
`ip_id` int unsigned DEFAULT NULL,
`rotation` int 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int DEFAULT NULL,
`non_action_path_taken` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `campaign_rotation` (`event_id`,`lead_id`,`rotation`),
KEY `IDX_B7420BA171F7E88B` (`event_id`),
KEY `IDX_B7420BA155458D` (`lead_id`),
KEY `IDX_B7420BA1F639F774` (`campaign_id`),
KEY `IDX_B7420BA1A03F5E9F` (`ip_id`),
KEY `campaign_event_upcoming_search` (`is_scheduled`,`lead_id`),
KEY `campaign_event_schedule_counts` (`campaign_id`,`is_scheduled`,`trigger_date`),
KEY `campaign_date_triggered` (`date_triggered`),
KEY `campaign_leads` (`lead_id`,`campaign_id`,`rotation`),
KEY `campaign_log_channel` (`channel`,`channel_id`,`lead_id`),
KEY `campaign_actions` (`campaign_id`,`event_id`,`date_triggered`),
KEY `campaign_stats` (`campaign_id`,`date_triggered`,`event_id`,`non_action_path_taken`),
KEY `campaign_trigger_date_order` (`trigger_date`),
CONSTRAINT `FK_B7420BA155458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_B7420BA171F7E88B` FOREIGN KEY (`event_id`) REFERENCES `campaign_events` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_B7420BA1A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_B7420BA1F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38417 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_leadlist_xref`
--
DROP TABLE IF EXISTS `campaign_leadlist_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_leadlist_xref` (
`campaign_id` int unsigned NOT NULL,
`leadlist_id` int unsigned NOT NULL,
PRIMARY KEY (`campaign_id`,`leadlist_id`),
KEY `IDX_6480052EF639F774` (`campaign_id`),
KEY `IDX_6480052EB9FC8874` (`leadlist_id`),
CONSTRAINT `FK_6480052EB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_6480052EF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_leads`
--
DROP TABLE IF EXISTS `campaign_leads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_leads` (
`campaign_id` int unsigned NOT NULL,
`lead_id` bigint 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 NOT NULL,
PRIMARY KEY (`campaign_id`,`lead_id`),
KEY `IDX_5995213DF639F774` (`campaign_id`),
KEY `IDX_5995213D55458D` (`lead_id`),
KEY `campaign_leads_date_added` (`date_added`),
KEY `campaign_leads_date_exited` (`date_last_exited`),
KEY `campaign_leads` (`campaign_id`,`manually_removed`,`lead_id`,`rotation`),
CONSTRAINT `FK_5995213D55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_5995213DF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaign_summary`
--
DROP TABLE IF EXISTS `campaign_summary`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign_summary` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`campaign_id` int unsigned DEFAULT NULL,
`event_id` int unsigned NOT NULL,
`date_triggered` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`scheduled_count` int NOT NULL,
`triggered_count` int NOT NULL,
`non_action_path_taken_count` int NOT NULL,
`failed_count` int NOT NULL,
`log_counts_processed` int DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `campaign_event_date_triggered` (`campaign_id`,`event_id`,`date_triggered`),
KEY `IDX_6692FA4FF639F774` (`campaign_id`),
KEY `IDX_6692FA4F71F7E88B` (`event_id`),
CONSTRAINT `FK_6692FA4F71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `campaign_events` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_6692FA4FF639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `campaigns`
--
DROP TABLE IF EXISTS `campaigns`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaigns` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`canvas_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`allow_restart` int NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_E373747012469DE2` (`category_id`),
CONSTRAINT `FK_E373747012469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`color` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bundle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `category_alias_search` (`alias`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `channel_url_trackables`
--
DROP TABLE IF EXISTS `channel_url_trackables`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `channel_url_trackables` (
`channel_id` int NOT NULL,
`redirect_id` bigint unsigned NOT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`hits` int NOT NULL,
`unique_hits` int NOT NULL,
PRIMARY KEY (`redirect_id`,`channel_id`),
KEY `IDX_2F81A41DB42D874D` (`redirect_id`),
KEY `channel_url_trackable_search` (`channel`,`channel_id`),
CONSTRAINT `FK_2F81A41DB42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `page_redirects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `companies`
--
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies` (
`id` int NOT NULL AUTO_INCREMENT,
`owner_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`social_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`score` int DEFAULT NULL,
`companyemail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyaddress1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyaddress2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyphone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companycity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companystate` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyzipcode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companycountry` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companywebsite` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`companyindustry` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companydescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`companynumber_of_employees` double DEFAULT NULL,
`companyfax` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`companyannual_revenue` double DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_8244AA3A7E3C61F9` (`owner_id`),
KEY `companyaddress1_search` (`companyaddress1`),
KEY `companyaddress2_search` (`companyaddress2`),
KEY `companyemail_search` (`companyemail`),
KEY `companyphone_search` (`companyphone`),
KEY `companycity_search` (`companycity`),
KEY `companystate_search` (`companystate`),
KEY `companyzipcode_search` (`companyzipcode`),
KEY `companycountry_search` (`companycountry`),
KEY `companyname_search` (`companyname`),
KEY `companynumber_of_employees_search` (`companynumber_of_employees`),
KEY `companyfax_search` (`companyfax`),
KEY `companyannual_revenue_search` (`companyannual_revenue`),
KEY `companyindustry_search` (`companyindustry`),
KEY `company_filter` (`companyname`,`companyemail`),
KEY `company_match` (`companyname`,`companycity`,`companycountry`,`companystate`),
KEY `unique_identifier_search` (`companyemail`,`companyname`),
CONSTRAINT `FK_8244AA3A7E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `companies_leads`
--
DROP TABLE IF EXISTS `companies_leads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies_leads` (
`company_id` int NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`is_primary` tinyint(1) DEFAULT NULL,
`manually_removed` tinyint(1) NOT NULL,
`manually_added` tinyint(1) NOT NULL,
PRIMARY KEY (`company_id`,`lead_id`),
KEY `IDX_F4190AB6979B1AD6` (`company_id`),
KEY `IDX_F4190AB655458D` (`lead_id`),
CONSTRAINT `FK_F4190AB655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_F4190AB6979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `contact_merge_records`
--
DROP TABLE IF EXISTS `contact_merge_records`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_merge_records` (
`id` int NOT NULL AUTO_INCREMENT,
`contact_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`merged_id` int NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_D9B4F2BFE7A1254A` (`contact_id`),
KEY `contact_merge_date_added` (`date_added`),
KEY `contact_merge_ids` (`merged_id`),
CONSTRAINT `FK_D9B4F2BFE7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27221 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `dynamic_content`
--
DROP TABLE IF EXISTS `dynamic_content`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dynamic_content` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`translation_parent_id` int unsigned DEFAULT NULL,
`variant_parent_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`sent_count` int NOT NULL,
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`utm_tags` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
`filters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`is_campaign_based` tinyint(1) NOT NULL DEFAULT '1',
`slot_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_20B9DEB212469DE2` (`category_id`),
KEY `IDX_20B9DEB29091A2FB` (`translation_parent_id`),
KEY `IDX_20B9DEB291861123` (`variant_parent_id`),
KEY `is_campaign_based_index` (`is_campaign_based`),
KEY `slot_name_index` (`slot_name`),
CONSTRAINT `FK_20B9DEB212469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_20B9DEB29091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `dynamic_content` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_20B9DEB291861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `dynamic_content` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `dynamic_content_lead_data`
--
DROP TABLE IF EXISTS `dynamic_content_lead_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dynamic_content_lead_data` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`dynamic_content_id` int unsigned DEFAULT NULL,
`date_added` datetime DEFAULT NULL,
`slot` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_515B221B55458D` (`lead_id`),
KEY `IDX_515B221BD9D0CD7` (`dynamic_content_id`),
CONSTRAINT `FK_515B221B55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_515B221BD9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `dynamic_content` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `dynamic_content_stats`
--
DROP TABLE IF EXISTS `dynamic_content_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dynamic_content_stats` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`dynamic_content_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`date_sent` datetime NOT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`tokens` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`sent_count` int DEFAULT NULL,
`last_sent` datetime DEFAULT NULL,
`sent_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_E48FBF80D9D0CD7` (`dynamic_content_id`),
KEY `IDX_E48FBF8055458D` (`lead_id`),
KEY `stat_dynamic_content_search` (`dynamic_content_id`,`lead_id`),
KEY `stat_dynamic_content_source_search` (`source`,`source_id`),
CONSTRAINT `FK_E48FBF8055458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_E48FBF80D9D0CD7` FOREIGN KEY (`dynamic_content_id`) REFERENCES `dynamic_content` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_assets_xref`
--
DROP TABLE IF EXISTS `email_assets_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_assets_xref` (
`email_id` int unsigned NOT NULL,
`asset_id` int unsigned NOT NULL,
PRIMARY KEY (`email_id`,`asset_id`),
KEY `IDX_CA3157785DA1941` (`asset_id`),
CONSTRAINT `FK_CA3157785DA1941` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_CA315778A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_copies`
--
DROP TABLE IF EXISTS `email_copies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_copies` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_created` datetime NOT NULL,
`body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_list_xref`
--
DROP TABLE IF EXISTS `email_list_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_list_xref` (
`email_id` int unsigned NOT NULL,
`leadlist_id` int unsigned NOT NULL,
PRIMARY KEY (`email_id`,`leadlist_id`),
KEY `IDX_2E24F01CB9FC8874` (`leadlist_id`),
CONSTRAINT `FK_2E24F01CA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_2E24F01CB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_stat_replies`
--
DROP TABLE IF EXISTS `email_stat_replies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_stat_replies` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
`stat_id` bigint unsigned NOT NULL,
`date_replied` datetime NOT NULL,
`message_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_11E9F6E09502F0B` (`stat_id`),
KEY `email_replies` (`stat_id`,`message_id`),
KEY `date_email_replied` (`date_replied`),
CONSTRAINT `FK_11E9F6E09502F0B` FOREIGN KEY (`stat_id`) REFERENCES `email_stats` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_stats`
--
DROP TABLE IF EXISTS `email_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_stats` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`email_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`list_id` int unsigned DEFAULT NULL,
`ip_id` int unsigned DEFAULT NULL,
`copy_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_address` varchar(191) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`retry_count` int DEFAULT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`tokens` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`open_count` int DEFAULT NULL,
`last_opened` datetime DEFAULT NULL,
`open_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_CA0A2625A832C1C9` (`email_id`),
KEY `IDX_CA0A262555458D` (`lead_id`),
KEY `IDX_CA0A26253DAE168B` (`list_id`),
KEY `IDX_CA0A2625A03F5E9F` (`ip_id`),
KEY `IDX_CA0A2625A8752772` (`copy_id`),
KEY `stat_email_search` (`email_id`,`lead_id`),
KEY `stat_email_search2` (`lead_id`,`email_id`),
KEY `stat_email_failed_search` (`is_failed`),
KEY `is_read_date_sent` (`is_read`,`date_sent`),
KEY `stat_email_hash_search` (`tracking_hash`),
KEY `stat_email_source_search` (`source`,`source_id`),
KEY `email_date_sent` (`date_sent`),
KEY `email_date_read_lead` (`date_read`,`lead_id`),
-- KEY `generated_sent_date_email_id` (`generated_sent_date`,`email_id`),
CONSTRAINT `FK_CA0A26253DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_CA0A262555458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_CA0A2625A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_CA0A2625A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_CA0A2625A8752772` FOREIGN KEY (`copy_id`) REFERENCES `email_copies` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `email_stats_devices`
--
DROP TABLE IF EXISTS `email_stats_devices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_stats_devices` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`device_id` bigint unsigned DEFAULT NULL,
`stat_id` bigint unsigned DEFAULT NULL,
`ip_id` int unsigned DEFAULT NULL,
`date_opened` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7A8A1C6F94A4C7D4` (`device_id`),
KEY `IDX_7A8A1C6F9502F0B` (`stat_id`),
KEY `IDX_7A8A1C6FA03F5E9F` (`ip_id`),
KEY `date_opened_search` (`date_opened`),
CONSTRAINT `FK_7A8A1C6F94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `lead_devices` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_7A8A1C6F9502F0B` FOREIGN KEY (`stat_id`) REFERENCES `email_stats` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_7A8A1C6FA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78461 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `emails`
--
DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emails` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`translation_parent_id` int unsigned DEFAULT NULL,
`variant_parent_id` int unsigned DEFAULT NULL,
`unsubscribeform_id` int unsigned DEFAULT NULL,
`preference_center_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`from_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`from_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reply_to_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bcc_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`template` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`utm_tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`plain_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`custom_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`email_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`read_count` int NOT NULL,
`sent_count` int NOT NULL,
`variant_sent_count` int NOT NULL,
`variant_read_count` int NOT NULL,
`revision` int NOT NULL,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
`dynamic_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`headers` json NOT NULL COMMENT '(DC2Type:json_array)',
`public_preview` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_4C81E85212469DE2` (`category_id`),
KEY `IDX_4C81E8529091A2FB` (`translation_parent_id`),
KEY `IDX_4C81E85291861123` (`variant_parent_id`),
KEY `IDX_4C81E8522DC494F6` (`unsubscribeform_id`),
KEY `IDX_4C81E852834F9C5B` (`preference_center_id`),
CONSTRAINT `FK_4C81E85212469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_4C81E8522DC494F6` FOREIGN KEY (`unsubscribeform_id`) REFERENCES `forms` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_4C81E852834F9C5B` FOREIGN KEY (`preference_center_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_4C81E8529091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_4C81E85291861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `focus`
--
DROP TABLE IF EXISTS `focus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `focus` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`focus_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`style` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`website` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`utm_tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`form_id` int DEFAULT NULL,
`cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`html_mode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`editor` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_62C04AE912469DE2` (`category_id`),
KEY `focus_type` (`focus_type`),
KEY `focus_style` (`style`),
KEY `focus_form` (`form_id`),
CONSTRAINT `FK_62C04AE912469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `focus_stats`
--
DROP TABLE IF EXISTS `focus_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `focus_stats` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`focus_id` int unsigned NOT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type_id` int DEFAULT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_C36970DC51804B42` (`focus_id`),
KEY `IDX_C36970DC55458D` (`lead_id`),
KEY `focus_type` (`type`),
KEY `focus_type_id` (`type`,`type_id`),
KEY `focus_date_added` (`date_added`),
CONSTRAINT `FK_C36970DC51804B42` FOREIGN KEY (`focus_id`) REFERENCES `focus` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_C36970DC55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=58709 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `form_actions`
--
DROP TABLE IF EXISTS `form_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `form_actions` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`form_id` int unsigned NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`action_order` int NOT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_342491D45FF69B7D` (`form_id`),
KEY `form_action_type_search` (`type`),
CONSTRAINT `FK_342491D45FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `form_fields`
--
DROP TABLE IF EXISTS `form_fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `form_fields` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`form_id` int unsigned NOT NULL,
`label` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`show_label` tinyint(1) DEFAULT NULL,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`is_custom` tinyint(1) NOT NULL,
`custom_parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`default_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`is_required` tinyint(1) NOT NULL,
`validation_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`help_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`field_order` int DEFAULT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`validation` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
`label_attr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`input_attr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`container_attr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lead_field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`save_result` tinyint(1) DEFAULT NULL,
`is_auto_fill` tinyint(1) DEFAULT NULL,
`show_when_value_exists` tinyint(1) DEFAULT NULL,
`show_after_x_submissions` int DEFAULT NULL,
-- `always_display` tinyint(1) DEFAULT NULL,
-- `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:json_array)',
-- `parent_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7C0B37265FF69B7D` (`form_id`),
KEY `form_field_type_search` (`type`),
CONSTRAINT `FK_7C0B37265FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `form_submissions`
--
DROP TABLE IF EXISTS `form_submissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `form_submissions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`form_id` int unsigned NOT NULL,
`ip_id` int unsigned NOT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`page_id` int unsigned DEFAULT NULL,
`tracking_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_submitted` datetime NOT NULL,
`referer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_C80AF9E65FF69B7D` (`form_id`),
KEY `IDX_C80AF9E6A03F5E9F` (`ip_id`),
KEY `IDX_C80AF9E655458D` (`lead_id`),
KEY `IDX_C80AF9E6C4663E4` (`page_id`),
KEY `form_submission_tracking_search` (`tracking_id`),
KEY `form_date_submitted` (`date_submitted`),
CONSTRAINT `FK_C80AF9E655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_C80AF9E65FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_C80AF9E6A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_C80AF9E6C4663E4` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=14718 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `forms`
--
DROP TABLE IF EXISTS `forms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `forms` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`cached_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`post_action` varchar(191) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`in_kiosk_mode` tinyint(1) DEFAULT NULL,
`render_style` tinyint(1) DEFAULT NULL,
`form_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`no_index` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_FD3F1BF712469DE2` (`category_id`),
CONSTRAINT `FK_FD3F1BF712469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `imports`
--
DROP TABLE IF EXISTS `imports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `imports` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dir` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`original_file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`line_count` int NOT NULL,
`inserted_count` int NOT NULL,
`updated_count` int NOT NULL,
`ignored_count` int NOT NULL,
`priority` int NOT NULL,
`status` int NOT NULL,
`date_started` datetime DEFAULT NULL,
`date_ended` datetime DEFAULT NULL,
`object` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`properties` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`),
KEY `import_object` (`object`),
KEY `import_status` (`status`),
KEY `import_priority` (`priority`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `integration_entity`
--
DROP TABLE IF EXISTS `integration_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `integration_entity` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`date_added` datetime NOT NULL,
`integration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`integration_entity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`integration_entity_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`internal_entity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`internal_entity_id` int DEFAULT NULL,
`last_sync_date` datetime DEFAULT NULL,
`internal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `integration_external_entity` (`integration`,`integration_entity`,`integration_entity_id`),
KEY `integration_internal_entity` (`integration`,`internal_entity`,`internal_entity_id`),
KEY `integration_entity_match` (`integration`,`internal_entity`,`integration_entity`),
KEY `integration_last_sync_date` (`integration`,`last_sync_date`),
KEY `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;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ip_addresses`
--
DROP TABLE IF EXISTS `ip_addresses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ip_addresses` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`ip_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `ip_search` (`ip_address`)
) ENGINE=InnoDB AUTO_INCREMENT=2875189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_categories`
--
DROP TABLE IF EXISTS `lead_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_categories` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned NOT NULL,
`lead_id` bigint 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_12685DF412469DE2` (`category_id`),
KEY `IDX_12685DF455458D` (`lead_id`),
CONSTRAINT `FK_12685DF412469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_12685DF455458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_companies_change_log`
--
DROP TABLE IF EXISTS `lead_companies_change_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_companies_change_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`type` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`company_id` int NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_A034C81B55458D` (`lead_id`),
KEY `company_date_added` (`date_added`),
CONSTRAINT `FK_A034C81B55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=367 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_devices`
--
DROP TABLE IF EXISTS `lead_devices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_devices` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`client_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`device` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_shortname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_os_platform` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_brand` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`device_fingerprint` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tracking_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_48C912F47D05ABBE` (`tracking_id`),
KEY `IDX_48C912F455458D` (`lead_id`),
KEY `date_added_search` (`date_added`),
KEY `device_search` (`device`),
KEY `device_os_name_search` (`device_os_name`),
KEY `device_os_shortname_search` (`device_os_shortname`),
KEY `device_os_version_search` (`device_os_version`),
KEY `device_os_platform_search` (`device_os_platform`),
KEY `device_brand_search` (`device_brand`),
KEY `device_model_search` (`device_model`),
CONSTRAINT `FK_48C912F455458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_donotcontact`
--
DROP TABLE IF EXISTS `lead_donotcontact`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_donotcontact` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned DEFAULT NULL,
`date_added` datetime NOT NULL,
`reason` smallint NOT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int DEFAULT NULL,
`comments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_71DC0B1D55458D` (`lead_id`),
KEY `dnc_reason_search` (`reason`),
KEY `dnc_channel_id_search` (`channel_id`),
CONSTRAINT `FK_71DC0B1D55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=677 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_event_log`
--
DROP TABLE IF EXISTS `lead_event_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_event_log` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned DEFAULT NULL,
`user_id` int DEFAULT NULL,
`user_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bundle` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`object` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`action` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`object_id` int DEFAULT NULL,
`date_added` datetime NOT NULL,
`properties` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`),
KEY `lead_id_index` (`lead_id`),
KEY `lead_object_index` (`object`,`object_id`),
KEY `lead_timeline_index` (`bundle`,`object`,`action`,`object_id`),
KEY `lead_timeline_action_index` (`action`),
KEY `lead_date_added_index` (`date_added`),
KEY `IDX_SEARCH` (`bundle`,`object`,`action`,`object_id`,`date_added`),
CONSTRAINT `FK_753AF2E55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82796 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_fields`
--
DROP TABLE IF EXISTS `lead_fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_fields` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`field_group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`default_value` varchar(191) CHARACTER SET utf8mb4 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,
`is_listable` tinyint(1) NOT NULL,
`is_publicly_updatable` tinyint(1) NOT NULL,
`is_unique_identifer` tinyint(1) DEFAULT NULL,
`field_order` int DEFAULT NULL,
`object` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`properties` longtext CHARACTER SET utf8mb4 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',
PRIMARY KEY (`id`),
KEY `search_by_object` (`object`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_frequencyrules`
--
DROP TABLE IF EXISTS `lead_frequencyrules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_frequencyrules` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`frequency_number` smallint DEFAULT NULL,
`frequency_time` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 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_AA8A57F455458D` (`lead_id`),
KEY `channel_frequency` (`channel`),
CONSTRAINT `FK_AA8A57F455458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_ips_xref`
--
DROP TABLE IF EXISTS `lead_ips_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_ips_xref` (
`lead_id` bigint unsigned NOT NULL,
`ip_id` int unsigned NOT NULL,
PRIMARY KEY (`lead_id`,`ip_id`),
KEY `IDX_9EED7E6655458D` (`lead_id`),
KEY `IDX_9EED7E66A03F5E9F` (`ip_id`),
CONSTRAINT `FK_9EED7E6655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_9EED7E66A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_lists`
--
DROP TABLE IF EXISTS `lead_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_lists` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`filters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`is_global` tinyint(1) NOT NULL,
`is_preference_center` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_lists_leads`
--
DROP TABLE IF EXISTS `lead_lists_leads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_lists_leads` (
`leadlist_id` int unsigned NOT NULL,
`lead_id` bigint 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_F5F47C7CB9FC8874` (`leadlist_id`),
KEY `IDX_F5F47C7C55458D` (`lead_id`),
KEY `manually_removed` (`manually_removed`),
CONSTRAINT `FK_F5F47C7C55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_F5F47C7CB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_notes`
--
DROP TABLE IF EXISTS `lead_notes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_notes` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_67FC6B0355458D` (`lead_id`),
CONSTRAINT `FK_67FC6B0355458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_points_change_log`
--
DROP TABLE IF EXISTS `lead_points_change_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_points_change_log` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`ip_id` int unsigned NOT NULL,
`type` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`delta` int NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_949C2CCC55458D` (`lead_id`),
KEY `IDX_949C2CCCA03F5E9F` (`ip_id`),
KEY `point_date_added` (`date_added`),
CONSTRAINT `FK_949C2CCC55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_949C2CCCA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_stages_change_log`
--
DROP TABLE IF EXISTS `lead_stages_change_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_stages_change_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`stage_id` int unsigned DEFAULT NULL,
`event_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`action_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_73B42EF355458D` (`lead_id`),
KEY `IDX_73B42EF32298D193` (`stage_id`),
CONSTRAINT `FK_73B42EF32298D193` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_73B42EF355458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_tags`
--
DROP TABLE IF EXISTS `lead_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_tags` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
-- `description` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `lead_tag_search` (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_tags_xref`
--
DROP TABLE IF EXISTS `lead_tags_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_tags_xref` (
`lead_id` bigint unsigned NOT NULL,
`tag_id` int unsigned NOT NULL,
PRIMARY KEY (`lead_id`,`tag_id`),
KEY `IDX_F2E51EB655458D` (`lead_id`),
KEY `IDX_F2E51EB6BAD26311` (`tag_id`),
CONSTRAINT `FK_F2E51EB655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_F2E51EB6BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `lead_tags` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lead_utmtags`
--
DROP TABLE IF EXISTS `lead_utmtags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_utmtags` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
`query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`referer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`user_agent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`utm_campaign` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_content` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_medium` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`utm_term` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_C51BCB8D55458D` (`lead_id`),
CONSTRAINT `FK_C51BCB8D55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `leads`
--
DROP TABLE IF EXISTS `leads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `leads` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int unsigned DEFAULT NULL,
`stage_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`points` int NOT NULL,
`last_active` datetime DEFAULT NULL,
`internal` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`social_cache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`date_identified` datetime DEFAULT NULL,
`preferred_profile_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`position` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zipcode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`timezone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fax` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`preferred_locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attribution_date` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
`attribution` double DEFAULT NULL,
`website` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`facebook` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`foursquare` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`googleplus` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`instagram` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`linkedin` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`skype` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`twitter` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_179045527E3C61F9` (`owner_id`),
KEY `IDX_179045522298D193` (`stage_id`),
KEY `lead_date_added` (`date_added`),
KEY `date_identified` (`date_identified`),
KEY `title_search` (`title`),
KEY `firstname_search` (`firstname`),
KEY `lastname_search` (`lastname`),
KEY `company_search` (`company`),
KEY `position_search` (`position`),
KEY `email_search` (`email`),
KEY `mobile_search` (`mobile`),
KEY `phone_search` (`phone`),
KEY `points_search` (`points`),
KEY `fax_search` (`fax`),
KEY `address1_search` (`address1`),
KEY `address2_search` (`address2`),
KEY `city_search` (`city`),
KEY `state_search` (`state`),
KEY `zipcode_search` (`zipcode`),
KEY `country_search` (`country`),
KEY `preferred_locale_search` (`preferred_locale`),
KEY `timezone_search` (`timezone`),
KEY `last_active_search` (`last_active`),
KEY `attribution_date_search` (`attribution_date`),
KEY `attribution_search` (`attribution`),
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 `generated_email_domain` (`generated_email_domain`),
CONSTRAINT `FK_179045522298D193` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_179045527E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `message_channels`
--
DROP TABLE IF EXISTS `message_channels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `message_channels` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`message_id` int unsigned NOT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int DEFAULT NULL,
`properties` json NOT NULL COMMENT '(DC2Type:json_array)',
`is_enabled` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `channel_index` (`message_id`,`channel`),
KEY `IDX_FA3226A7537A1329` (`message_id`),
KEY `channel_entity_index` (`channel`,`channel_id`),
KEY `channel_enabled_index` (`channel`,`is_enabled`),
CONSTRAINT `FK_FA3226A7537A1329` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `message_queue`
--
DROP TABLE IF EXISTS `message_queue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `message_queue` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`event_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned NOT NULL,
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`channel_id` int NOT NULL,
`priority` smallint NOT NULL,
`max_attempts` smallint NOT NULL,
`attempts` smallint NOT NULL,
`success` tinyint(1) NOT NULL,
`status` varchar(191) CHARACTER SET utf8mb4 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_805B808871F7E88B` (`event_id`),
KEY `IDX_805B808855458D` (`lead_id`),
KEY `message_status_search` (`status`),
KEY `message_date_sent` (`date_sent`),
KEY `message_scheduled_date` (`scheduled_date`),
KEY `message_priority` (`priority`),
KEY `message_success` (`success`),
KEY `message_channel_search` (`channel`,`channel_id`),
CONSTRAINT `FK_805B808855458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_805B808871F7E88B` FOREIGN KEY (`event_id`) REFERENCES `campaign_events` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_DB021E9612469DE2` (`category_id`),
KEY `date_message_added` (`date_added`),
CONSTRAINT `FK_DB021E9612469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
`version` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`executed_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `monitor_post_count`
--
DROP TABLE IF EXISTS `monitor_post_count`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `monitor_post_count` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`monitor_id` int unsigned DEFAULT NULL,
`post_date` date NOT NULL,
`post_count` int NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_E3AC20CA4CE1C902` (`monitor_id`),
CONSTRAINT `FK_E3AC20CA4CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `monitoring` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `monitoring`
--
DROP TABLE IF EXISTS `monitoring`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `monitoring` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`lists` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`network_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revision` int NOT NULL,
`stats` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_BA4F975D12469DE2` (`category_id`),
CONSTRAINT `FK_BA4F975D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `monitoring_leads`
--
DROP TABLE IF EXISTS `monitoring_leads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `monitoring_leads` (
`monitor_id` int unsigned NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`monitor_id`,`lead_id`),
KEY `IDX_45207A4A4CE1C902` (`monitor_id`),
KEY `IDX_45207A4A55458D` (`lead_id`),
CONSTRAINT `FK_45207A4A4CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `monitoring` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_45207A4A55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL,
`type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`header` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
`icon_class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_read` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_6000B0D3A76ED395` (`user_id`),
KEY `notification_read_status` (`is_read`),
KEY `notification_type` (`type`),
KEY `notification_user_read_status` (`is_read`,`user_id`),
CONSTRAINT `FK_6000B0D3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth1_access_tokens`
--
DROP TABLE IF EXISTS `oauth1_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth1_access_tokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`consumer_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`token` varchar(255) NOT NULL,
`secret` varchar(255) NOT NULL,
`expires_at` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth1_consumers`
--
DROP TABLE IF EXISTS `oauth1_consumers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth1_consumers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`consumer_key` varchar(191) NOT NULL,
`consumer_secret` varchar(191) NOT NULL,
`callback` varchar(191) NOT NULL,
PRIMARY KEY (`id`),
KEY `consumer_search` (`consumer_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth1_nonces`
--
DROP TABLE IF EXISTS `oauth1_nonces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth1_nonces` (
`nonce` varchar(191) NOT NULL,
`timestamp` varchar(191) NOT NULL,
PRIMARY KEY (`nonce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth1_request_tokens`
--
DROP TABLE IF EXISTS `oauth1_request_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth1_request_tokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`consumer_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`token` varchar(191) NOT NULL,
`secret` varchar(191) NOT NULL,
`expires_at` bigint(20) NOT NULL,
`verifier` varchar(191) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth2_accesstokens`
--
DROP TABLE IF EXISTS `oauth2_accesstokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth2_accesstokens` (
`id` int NOT NULL AUTO_INCREMENT,
`client_id` int unsigned NOT NULL,
`user_id` int unsigned DEFAULT NULL,
`token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint DEFAULT NULL,
`scope` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_3A18CA5A5F37A13B` (`token`),
KEY `IDX_3A18CA5A19EB6921` (`client_id`),
KEY `IDX_3A18CA5AA76ED395` (`user_id`),
KEY `oauth2_access_token_search` (`token`),
CONSTRAINT `FK_3A18CA5A19EB6921` FOREIGN KEY (`client_id`) REFERENCES `oauth2_clients` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_3A18CA5AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth2_authcodes`
--
DROP TABLE IF EXISTS `oauth2_authcodes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth2_authcodes` (
`id` int NOT NULL AUTO_INCREMENT,
`client_id` int unsigned NOT NULL,
`user_id` int unsigned NOT NULL,
`token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint DEFAULT NULL,
`scope` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_uri` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_D2B4847B5F37A13B` (`token`),
KEY `IDX_D2B4847B19EB6921` (`client_id`),
KEY `IDX_D2B4847BA76ED395` (`user_id`),
CONSTRAINT `FK_D2B4847B19EB6921` FOREIGN KEY (`client_id`) REFERENCES `oauth2_clients` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_D2B4847BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth2_clients`
--
DROP TABLE IF EXISTS `oauth2_clients`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth2_clients` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`random_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`redirect_uris` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`allowed_grant_types` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`role_id` int unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `client_id_search` (`random_id`),
KEY `IDX_F9D02AE6D60322AC` (`role_id`),
CONSTRAINT `FK_CLIENT_ROLE` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth2_refreshtokens`
--
DROP TABLE IF EXISTS `oauth2_refreshtokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth2_refreshtokens` (
`id` int NOT NULL AUTO_INCREMENT,
`client_id` int unsigned NOT NULL,
`user_id` int unsigned NOT NULL,
`token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expires_at` bigint DEFAULT NULL,
`scope` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_328C5B1B5F37A13B` (`token`),
KEY `IDX_328C5B1B19EB6921` (`client_id`),
KEY `IDX_328C5B1BA76ED395` (`user_id`),
KEY `oauth2_refresh_token_search` (`token`),
CONSTRAINT `FK_328C5B1B19EB6921` FOREIGN KEY (`client_id`) REFERENCES `oauth2_clients` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_328C5B1BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `oauth2_user_client_xref`
--
DROP TABLE IF EXISTS `oauth2_user_client_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth2_user_client_xref` (
`client_id` int unsigned NOT NULL,
`user_id` int unsigned NOT NULL,
PRIMARY KEY (`client_id`,`user_id`),
KEY `IDX_1AE3441319EB6921` (`client_id`),
KEY `IDX_1AE34413A76ED395` (`user_id`),
CONSTRAINT `FK_1AE3441319EB6921` FOREIGN KEY (`client_id`) REFERENCES `oauth2_clients` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_1AE34413A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `page_hits`
--
DROP TABLE IF EXISTS `page_hits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_hits` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`page_id` int unsigned DEFAULT NULL,
`redirect_id` bigint unsigned DEFAULT NULL,
`email_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`ip_id` int unsigned NOT NULL,
`device_id` bigint unsigned DEFAULT NULL,
`date_hit` datetime NOT NULL,
`date_left` datetime DEFAULT NULL,
`country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`region` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` int NOT NULL,
`referer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`url_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`page_language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`browser_languages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`tracking_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_9D4B70F1C4663E4` (`page_id`),
KEY `IDX_9D4B70F1B42D874D` (`redirect_id`),
KEY `IDX_9D4B70F1A832C1C9` (`email_id`),
KEY `IDX_9D4B70F155458D` (`lead_id`),
KEY `IDX_9D4B70F1A03F5E9F` (`ip_id`),
KEY `IDX_9D4B70F194A4C7D4` (`device_id`),
KEY `page_hit_tracking_search` (`tracking_id`),
KEY `page_hit_code_search` (`code`),
KEY `page_hit_source_search` (`source`,`source_id`),
KEY `date_hit_left_index` (`date_hit`,`date_left`),
CONSTRAINT `FK_9D4B70F155458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_9D4B70F194A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `lead_devices` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_9D4B70F1A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_9D4B70F1A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_9D4B70F1B42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `page_redirects` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_9D4B70F1C4663E4` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=172586 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `page_redirects`
--
DROP TABLE IF EXISTS `page_redirects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_redirects` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`hits` int NOT NULL,
`unique_hits` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`translation_parent_id` int unsigned DEFAULT NULL,
`variant_parent_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`template` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`custom_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`hits` int NOT NULL,
`unique_hits` int NOT NULL,
`variant_hits` int NOT NULL,
`revision` int NOT NULL,
`meta_description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect_url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_preference_center` tinyint(1) DEFAULT NULL,
`no_index` tinyint(1) DEFAULT NULL,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`variant_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`variant_start_date` datetime DEFAULT NULL,
-- `head_script` longtext COLLATE utf8mb4_unicode_ci,
-- `footer_script` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `IDX_2074E57512469DE2` (`category_id`),
KEY `IDX_2074E5759091A2FB` (`translation_parent_id`),
KEY `IDX_2074E57591861123` (`variant_parent_id`),
KEY `page_alias_search` (`alias`),
CONSTRAINT `FK_2074E57512469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_2074E5759091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_2074E57591861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`role_id` int unsigned NOT NULL,
`bundle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`bitwise` int NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_perm` (`bundle`,`name`,`role_id`),
KEY `IDX_2DEDCC6FD60322AC` (`role_id`),
CONSTRAINT `FK_2DEDCC6FD60322AC` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `plugin_citrix_events`
--
DROP TABLE IF EXISTS `plugin_citrix_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_citrix_events` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned NOT NULL,
`product` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_desc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`event_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_D77731055458D` (`lead_id`),
KEY `citrix_event_email` (`product`,`email`),
KEY `citrix_event_name` (`product`,`event_name`,`event_type`),
KEY `citrix_event_type` (`product`,`event_type`,`event_date`),
KEY `citrix_event_product` (`product`,`email`,`event_type`),
KEY `citrix_event_product_name` (`product`,`email`,`event_type`,`event_name`),
KEY `citrix_event_product_name_lead` (`product`,`event_type`,`event_name`,`lead_id`),
KEY `citrix_event_product_type_lead` (`product`,`event_type`,`lead_id`),
KEY `citrix_event_date` (`event_date`),
CONSTRAINT `FK_D77731055458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `plugin_crm_pipedrive_owners`
--
DROP TABLE IF EXISTS `plugin_crm_pipedrive_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_crm_pipedrive_owners` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `email` (`email`),
KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `plugin_integration_settings`
--
DROP TABLE IF EXISTS `plugin_integration_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_integration_settings` (
`id` int NOT NULL AUTO_INCREMENT,
`plugin_id` int unsigned DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`is_published` tinyint(1) NOT NULL,
`supported_features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`api_keys` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
`feature_settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_941A2CE0EC942BCF` (`plugin_id`),
CONSTRAINT `FK_941A2CE0EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `plugins`
--
DROP TABLE IF EXISTS `plugins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugins` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`is_missing` tinyint(1) NOT NULL,
`bundle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_bundle` (`bundle`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `point_lead_action_log`
--
DROP TABLE IF EXISTS `point_lead_action_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `point_lead_action_log` (
`point_id` int unsigned NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`ip_id` int unsigned DEFAULT NULL,
`date_fired` datetime NOT NULL,
PRIMARY KEY (`point_id`,`lead_id`),
KEY `IDX_6DF94A56C028CEA2` (`point_id`),
KEY `IDX_6DF94A5655458D` (`lead_id`),
KEY `IDX_6DF94A56A03F5E9F` (`ip_id`),
CONSTRAINT `FK_6DF94A5655458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_6DF94A56A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_6DF94A56C028CEA2` FOREIGN KEY (`point_id`) REFERENCES `points` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `point_lead_event_log`
--
DROP TABLE IF EXISTS `point_lead_event_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `point_lead_event_log` (
`event_id` int unsigned NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`ip_id` int unsigned DEFAULT NULL,
`date_fired` datetime NOT NULL,
PRIMARY KEY (`event_id`,`lead_id`),
KEY `IDX_C2A3BDBA71F7E88B` (`event_id`),
KEY `IDX_C2A3BDBA55458D` (`lead_id`),
KEY `IDX_C2A3BDBAA03F5E9F` (`ip_id`),
CONSTRAINT `FK_C2A3BDBA55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_C2A3BDBA71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `point_trigger_events` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_C2A3BDBAA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `point_trigger_events`
--
DROP TABLE IF EXISTS `point_trigger_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `point_trigger_events` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`trigger_id` int unsigned NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`action_order` int NOT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_D5669585FDDDCD6` (`trigger_id`),
KEY `trigger_type_search` (`type`),
CONSTRAINT `FK_D5669585FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `point_triggers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `point_triggers`
--
DROP TABLE IF EXISTS `point_triggers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `point_triggers` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`points` int NOT NULL,
`color` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`trigger_existing_leads` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_9CABD32F12469DE2` (`category_id`),
CONSTRAINT `FK_9CABD32F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `points`
--
DROP TABLE IF EXISTS `points`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `points` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`repeatable` tinyint(1) NOT NULL,
`delta` int NOT NULL,
`properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_27BA8E2912469DE2` (`category_id`),
KEY `point_type_search` (`type`),
CONSTRAINT `FK_27BA8E2912469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `push_ids`
--
DROP TABLE IF EXISTS `push_ids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `push_ids` (
`id` int NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned DEFAULT NULL,
`push_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`enabled` tinyint(1) NOT NULL,
`mobile` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_4F2393E855458D` (`lead_id`),
CONSTRAINT `FK_4F2393E855458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `push_notification_list_xref`
--
DROP TABLE IF EXISTS `push_notification_list_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `push_notification_list_xref` (
`notification_id` int unsigned NOT NULL,
`leadlist_id` int unsigned NOT NULL,
PRIMARY KEY (`notification_id`,`leadlist_id`),
KEY `IDX_473919EFEF1A9D84` (`notification_id`),
KEY `IDX_473919EFB9FC8874` (`leadlist_id`),
CONSTRAINT `FK_473919EFB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_473919EFEF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `push_notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `push_notification_stats`
--
DROP TABLE IF EXISTS `push_notification_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `push_notification_stats` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`notification_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`list_id` int unsigned DEFAULT NULL,
`ip_id` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`retry_count` int DEFAULT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`tokens` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`click_count` int DEFAULT NULL,
`last_clicked` datetime DEFAULT NULL,
`click_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_DE63695EEF1A9D84` (`notification_id`),
KEY `IDX_DE63695E55458D` (`lead_id`),
KEY `IDX_DE63695E3DAE168B` (`list_id`),
KEY `IDX_DE63695EA03F5E9F` (`ip_id`),
KEY `stat_notification_search` (`notification_id`,`lead_id`),
KEY `stat_notification_clicked_search` (`is_clicked`),
KEY `stat_notification_hash_search` (`tracking_hash`),
KEY `stat_notification_source_search` (`source`,`source_id`),
CONSTRAINT `FK_DE63695E3DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_DE63695E55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_DE63695EA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_DE63695EEF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `push_notifications` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `push_notifications`
--
DROP TABLE IF EXISTS `push_notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `push_notifications` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`heading` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`button` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`utm_tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`notification_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`read_count` int NOT NULL,
`sent_count` int NOT NULL,
`mobile` tinyint(1) NOT NULL,
`mobileSettings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_5B9B7E4F12469DE2` (`category_id`),
CONSTRAINT `FK_5B9B7E4F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reports`
--
DROP TABLE IF EXISTS `reports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reports` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`system` tinyint(1) NOT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`columns` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`filters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`table_order` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`graphs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`group_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`aggregators` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`settings` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
`is_scheduled` tinyint(1) NOT NULL,
`schedule_unit` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`to_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`schedule_day` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`schedule_month_frequency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reports_schedulers`
--
DROP TABLE IF EXISTS `reports_schedulers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reports_schedulers` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`report_id` int unsigned NOT NULL,
`schedule_date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_C74CA6B84BD2A4C0` (`report_id`),
CONSTRAINT `FK_C74CA6B84BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `reports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`is_admin` tinyint(1) NOT NULL,
`readable_permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `saml_id_entry`
--
DROP TABLE IF EXISTS `saml_id_entry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `saml_id_entry` (
`id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`entity_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expiryTimestamp` int NOT NULL,
PRIMARY KEY (`id`,`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sms_message_list_xref`
--
DROP TABLE IF EXISTS `sms_message_list_xref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_message_list_xref` (
`sms_id` int unsigned NOT NULL,
`leadlist_id` int unsigned NOT NULL,
PRIMARY KEY (`sms_id`,`leadlist_id`),
KEY `IDX_B032FC2EBD5C7E60` (`sms_id`),
KEY `IDX_B032FC2EB9FC8874` (`leadlist_id`),
CONSTRAINT `FK_B032FC2EB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `lead_lists` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_B032FC2EBD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `sms_messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sms_message_stats`
--
DROP TABLE IF EXISTS `sms_message_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_message_stats` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`sms_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`list_id` int unsigned DEFAULT NULL,
`ip_id` int unsigned DEFAULT NULL,
`date_sent` datetime NOT NULL,
`is_failed` tinyint(1) DEFAULT NULL,
`tracking_hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`tokens` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`details` json NOT NULL COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`),
KEY `IDX_FE1BAE9BD5C7E60` (`sms_id`),
KEY `IDX_FE1BAE955458D` (`lead_id`),
KEY `IDX_FE1BAE93DAE168B` (`list_id`),
KEY `IDX_FE1BAE9A03F5E9F` (`ip_id`),
KEY `stat_sms_search` (`sms_id`,`lead_id`),
KEY `stat_sms_hash_search` (`tracking_hash`),
KEY `stat_sms_source_search` (`source`,`source_id`),
KEY `stat_sms_failed_search` (`is_failed`),
CONSTRAINT `FK_FE1BAE93DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_FE1BAE955458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_FE1BAE9A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
CONSTRAINT `FK_FE1BAE9BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `sms_messages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sms_messages`
--
DROP TABLE IF EXISTS `sms_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_messages` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`sms_type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
`sent_count` int NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_BDF43F9712469DE2` (`category_id`),
CONSTRAINT `FK_BDF43F9712469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `stage_lead_action_log`
--
DROP TABLE IF EXISTS `stage_lead_action_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stage_lead_action_log` (
`stage_id` int unsigned NOT NULL,
`lead_id` bigint unsigned NOT NULL,
`ip_id` int unsigned DEFAULT NULL,
`date_fired` datetime NOT NULL,
PRIMARY KEY (`stage_id`,`lead_id`),
KEY `IDX_A506AFBE2298D193` (`stage_id`),
KEY `IDX_A506AFBE55458D` (`lead_id`),
KEY `IDX_A506AFBEA03F5E9F` (`ip_id`),
CONSTRAINT `FK_A506AFBE2298D193` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_A506AFBE55458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_A506AFBEA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `stages`
--
DROP TABLE IF EXISTS `stages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stages` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`weight` int NOT NULL,
`publish_up` datetime DEFAULT NULL,
`publish_down` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_2FA26A6412469DE2` (`category_id`),
CONSTRAINT `FK_2FA26A6412469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sync_object_field_change_report`
--
DROP TABLE IF EXISTS `sync_object_field_change_report`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sync_object_field_change_report` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`integration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` bigint unsigned NOT NULL,
`object_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`modified_at` datetime NOT NULL,
`column_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`column_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`column_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `object_composite_key` (`object_type`,`object_id`,`column_name`),
KEY `integration_object_composite_key` (`integration`,`object_type`,`object_id`,`column_name`),
KEY `integration_object_type_modification_composite_key` (`integration`,`object_type`,`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sync_object_mapping`
--
DROP TABLE IF EXISTS `sync_object_mapping`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sync_object_mapping` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`date_created` datetime NOT NULL,
`integration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`internal_object_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`internal_object_id` bigint unsigned NOT NULL,
`integration_object_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`integration_object_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_sync_date` datetime NOT NULL,
`internal_storage` json NOT NULL COMMENT '(DC2Type:json_array)',
`is_deleted` tinyint(1) NOT NULL,
`integration_reference_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `integration_object` (`integration`,`integration_object_name`,`integration_object_id`,`integration_reference_id`),
KEY `integration_reference` (`integration`,`integration_object_name`,`integration_reference_id`,`integration_object_id`),
KEY `integration_last_sync_date` (`integration`,`last_sync_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tweet_stats`
--
DROP TABLE IF EXISTS `tweet_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tweet_stats` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`tweet_id` int unsigned DEFAULT NULL,
`lead_id` bigint unsigned DEFAULT NULL,
`twitter_tweet_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`handle` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_sent` datetime DEFAULT NULL,
`is_failed` tinyint(1) DEFAULT NULL,
`retry_count` int DEFAULT NULL,
`source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_id` int DEFAULT NULL,
`favorite_count` int DEFAULT NULL,
`retweet_count` int DEFAULT NULL,
`response_details` json DEFAULT NULL COMMENT '(DC2Type:json_array)',
PRIMARY KEY (`id`),
KEY `IDX_CB8CBAE51041E39B` (`tweet_id`),
KEY `IDX_CB8CBAE555458D` (`lead_id`),
KEY `stat_tweet_search` (`tweet_id`,`lead_id`),
KEY `stat_tweet_search2` (`lead_id`,`tweet_id`),
KEY `stat_tweet_failed_search` (`is_failed`),
KEY `stat_tweet_source_search` (`source`,`source_id`),
KEY `favorite_count_index` (`favorite_count`),
KEY `retweet_count_index` (`retweet_count`),
KEY `tweet_date_sent` (`date_sent`),
KEY `twitter_tweet_id_index` (`twitter_tweet_id`),
CONSTRAINT `FK_CB8CBAE51041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `tweets` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_CB8CBAE555458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tweets`
--
DROP TABLE IF EXISTS `tweets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tweets` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`page_id` int unsigned DEFAULT NULL,
`asset_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`media_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`media_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`sent_count` int DEFAULT NULL,
`favorite_count` int DEFAULT NULL,
`retweet_count` int DEFAULT NULL,
`lang` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_AA38402512469DE2` (`category_id`),
KEY `IDX_AA384025C4663E4` (`page_id`),
KEY `IDX_AA3840255DA1941` (`asset_id`),
KEY `sent_count_index` (`sent_count`),
KEY `favorite_count_index` (`favorite_count`),
KEY `retweet_count_index` (`retweet_count`),
CONSTRAINT `FK_AA38402512469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_AA3840255DA1941` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_AA384025C4663E4` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `user_tokens`
--
DROP TABLE IF EXISTS `user_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_tokens` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL,
`authorizator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` datetime DEFAULT NULL,
`one_time_only` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_CF080AB35CA2E8E5` (`secret`),
KEY `IDX_CF080AB3A76ED395` (`user_id`),
CONSTRAINT `FK_CF080AB3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`role_id` int unsigned NOT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`position` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`timezone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_active` datetime DEFAULT NULL,
`online_status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`preferences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`signature` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_1483A5E9F85E0677` (`username`),
UNIQUE KEY `UNIQ_1483A5E9E7927C74` (`email`),
KEY `IDX_1483A5E9D60322AC` (`role_id`),
CONSTRAINT `FK_1483A5E9D60322AC` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `video_hits`
--
DROP TABLE IF EXISTS `video_hits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `video_hits` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`lead_id` bigint unsigned DEFAULT NULL,
`ip_id` int unsigned NOT NULL,
`date_hit` datetime NOT NULL,
`date_left` datetime DEFAULT NULL,
`country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`region` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`organization` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` int NOT NULL,
`referer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`user_agent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`remote_host` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`guid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`page_language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`browser_languages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
`channel` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`channel_id` int DEFAULT NULL,
`time_watched` int DEFAULT NULL,
`duration` int DEFAULT NULL,
`query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
KEY `IDX_1D1831F755458D` (`lead_id`),
KEY `IDX_1D1831F7A03F5E9F` (`ip_id`),
KEY `video_date_hit` (`date_hit`),
KEY `video_channel_search` (`channel`,`channel_id`),
KEY `video_guid_lead_search` (`guid`,`lead_id`),
CONSTRAINT `FK_1D1831F755458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_1D1831F7A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `webhook_events`
--
DROP TABLE IF EXISTS `webhook_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `webhook_events` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int unsigned NOT NULL,
`event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7AD44E375C9BA60B` (`webhook_id`),
CONSTRAINT `FK_7AD44E375C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `webhook_logs`
--
DROP TABLE IF EXISTS `webhook_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `webhook_logs` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int unsigned NOT NULL,
`status_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_added` datetime DEFAULT NULL,
`note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`runtime` double DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_45A353475C9BA60B` (`webhook_id`),
CONSTRAINT `FK_45A353475C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `webhook_queue`
--
DROP TABLE IF EXISTS `webhook_queue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `webhook_queue` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`webhook_id` int unsigned NOT NULL,
`event_id` int unsigned NOT NULL,
`date_added` datetime DEFAULT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_F52D9A1A5C9BA60B` (`webhook_id`),
KEY `IDX_F52D9A1A71F7E88B` (`event_id`),
KEY `webhook_id_date` (`webhook_id`,`date_added`),
CONSTRAINT `FK_F52D9A1A5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_F52D9A1A71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `webhook_events` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `webhooks`
--
DROP TABLE IF EXISTS `webhooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `webhooks` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`category_id` int unsigned DEFAULT NULL,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`webhook_url` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`events_orderby_dir` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`secret` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_998C4FDD12469DE2` (`category_id`),
CONSTRAINT `FK_998C4FDD12469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `widgets`
--
DROP TABLE IF EXISTS `widgets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `widgets` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`is_published` tinyint(1) NOT NULL,
`date_added` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`created_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_by` int DEFAULT NULL,
`modified_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`checked_out` datetime DEFAULT NULL,
`checked_out_by` int DEFAULT NULL,
`checked_out_by_user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`width` int NOT NULL,
`height` int NOT NULL,
`cache_timeout` int DEFAULT NULL,
`ordering` int DEFAULT NULL,
`params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-07-13 13:00:12
Raw
subir.sh
#!/bin/bash
# Verifica se todos os parâmetros foram fornecidos
if [ $# -ne 3 ]; then
echo "Erro: Faltando parâmetros."
echo "Uso: ./script.sh <nome_do_banco> <host_do_banco> <senha_do_banco>"
exit 1
fi
# Atribui os valores dos parâmetros
DB_NAME=$1
DB_HOST=$2
DB_USER='root'
DB_PASSWORD=$3
# Verifica se o arquivo de estrutura existe
if [ ! -f "estrutura_mtc4_ajustado.sql" ]; then
echo "Erro: Arquivo de estrutura 'estrutura_mtc4_ajustado.sql' não encontrado."
exit 1
fi
# Copia a estrutura do banco de dados
echo "Copiando estrutura do banco"
cp estrutura_mtc4_ajustado.sql "${DB_NAME}_estrutura.sql"
# Cria o banco de dados
echo "Criando banco de dados"
mysql -h $DB_HOST -u $DB_USER -p$DB_PASSWORD -e "DROP DATABASE IF EXISTS $DB_NAME; CREATE DATABASE $DB_NAME;"
# Importa a estrutura do banco de dados
echo "Importando estrutura do banco de dados"
mysql -h $DB_HOST -P 3306 -u $DB_USER -p$DB_PASSWORD $DB_NAME < "${DB_NAME}_estrutura.sql"
# Importa os dados do formulário
if [ -f "${DB_NAME}_forms_result.sql" ]; then
echo "Importando dados do formulário"
mysql -h $DB_HOST -P 3306 -u $DB_USER -p$DB_PASSWORD $DB_NAME < "${DB_NAME}_forms_result.sql"
fi
# Importa os dados
if [ -f "${DB_NAME}_dados.sql" ]; then
echo "Importando dados"
mysql -f -h $DB_HOST -P 3306 -u $DB_USER -p$DB_PASSWORD $DB_NAME < "${DB_NAME}_dados.sql"
fi
# Altera a tabela 'forms'
echo "Alterando tabela 'forms'"
# Comando MySQL com as duas instruções SQL adicionadas
mysql -f -h $DB_HOST -u $DB_USER -p$DB_PASSWORD $DB_NAME -e "ALTER TABLE forms ADD form_attr VARCHAR(255) DEFAULT NULL; ALTER TABLE lead_donotcontact DROP INDEX dnc_channel_id_search; ALTER TABLE pages DROP COLUMN head_script;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment