IP : 3.133.157.144Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
hizup/
../
livehelper/
../
phpwcms/
./
../
blesta/
../
mautic/
mautic.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Dumping data for table `[[dbprefix]]plugins` --
INSERT INTO `[[dbprefix]]plugins` VALUES (1, 'GrapesJS Builder', 'GrapesJS Builder with MJML support for Mautic', 0, 'GrapesJsBuilderBundle', '1.0.0', 'Mautic Community');
-- -- Constraints for table `[[dbprefix]]lead_utmtags` -- ALTER TABLE `[[dbprefix]]lead_utmtags` ADD CONSTRAINT `FK_6235E33655458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]messages` -- ALTER TABLE `[[dbprefix]]messages` ADD CONSTRAINT `FK_E723E37C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]message_channels` -- ALTER TABLE `[[dbprefix]]message_channels` ADD CONSTRAINT `FK_45AAC703537A1329` FOREIGN KEY (`message_id`) REFERENCES `[[dbprefix]]messages` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]message_queue` -- ALTER TABLE `[[dbprefix]]message_queue` ADD CONSTRAINT `FK_DC4FC4A455458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_DC4FC4A471F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]campaign_events` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]monitoring` -- ALTER TABLE `[[dbprefix]]monitoring` ADD CONSTRAINT `FK_DDD23EBB12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]monitoring_leads` -- ALTER TABLE `[[dbprefix]]monitoring_leads` ADD CONSTRAINT `FK_FAB89BEE4CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_FAB89BEE55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]monitor_post_count` -- ALTER TABLE `[[dbprefix]]monitor_post_count` ADD CONSTRAINT `FK_FECA34514CE1C902` FOREIGN KEY (`monitor_id`) REFERENCES `[[dbprefix]]monitoring` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]notifications` -- ALTER TABLE `[[dbprefix]]notifications` ADD CONSTRAINT `FK_3C14F4FFA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]oauth2_accesstokens` -- ALTER TABLE `[[dbprefix]]oauth2_accesstokens` ADD CONSTRAINT `FK_5DD8E68219EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_5DD8E682A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]oauth2_authcodes` -- ALTER TABLE `[[dbprefix]]oauth2_authcodes` ADD CONSTRAINT `FK_6D2C65DF19EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_6D2C65DFA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]oauth2_clients` -- ALTER TABLE `[[dbprefix]]oauth2_clients` ADD CONSTRAINT `FK_CB545241D60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);
-- -- Constraints for table `[[dbprefix]]oauth2_refreshtokens` -- ALTER TABLE `[[dbprefix]]oauth2_refreshtokens` ADD CONSTRAINT `FK_BAE3C1D119EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_BAE3C1D1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]oauth2_user_client_xref` -- ALTER TABLE `[[dbprefix]]oauth2_user_client_xref` ADD CONSTRAINT `FK_D078495419EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_D0784954A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]pages` -- ALTER TABLE `[[dbprefix]]pages` ADD CONSTRAINT `FK_C4C282012469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_C4C28209091A2FB` FOREIGN KEY (`translation_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_C4C282091861123` FOREIGN KEY (`variant_parent_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]page_hits` -- ALTER TABLE `[[dbprefix]]page_hits` ADD CONSTRAINT `FK_DDA85A6A55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DDA85A6A94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `[[dbprefix]]lead_devices` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DDA85A6AA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DDA85A6AA832C1C9` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DDA85A6AB42D874D` FOREIGN KEY (`redirect_id`) REFERENCES `[[dbprefix]]page_redirects` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DDA85A6AC4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]permissions` -- ALTER TABLE `[[dbprefix]]permissions` ADD CONSTRAINT `FK_64E3168BD60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]plugin_integration_settings` -- ALTER TABLE `[[dbprefix]]plugin_integration_settings` ADD CONSTRAINT `FK_7305A748EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `[[dbprefix]]plugins` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]points` -- ALTER TABLE `[[dbprefix]]points` ADD CONSTRAINT `FK_3C97139F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_3C97139FFE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]point_group_contact_score` -- ALTER TABLE `[[dbprefix]]point_group_contact_score` ADD CONSTRAINT `FK_5C0CC8E7E7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_5C0CC8E7FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]point_lead_action_log` -- ALTER TABLE `[[dbprefix]]point_lead_action_log` ADD CONSTRAINT `FK_16C00E6255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_16C00E62A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_16C00E62C028CEA2` FOREIGN KEY (`point_id`) REFERENCES `[[dbprefix]]points` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]point_lead_event_log` -- ALTER TABLE `[[dbprefix]]point_lead_event_log` ADD CONSTRAINT `FK_4ACC277055458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_4ACC277071F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]point_trigger_events` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_4ACC2770A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]point_triggers` -- ALTER TABLE `[[dbprefix]]point_triggers` ADD CONSTRAINT `FK_AE2FAB8812469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_AE2FAB88FE54D947` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]point_groups` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]point_trigger_events` -- ALTER TABLE `[[dbprefix]]point_trigger_events` ADD CONSTRAINT `FK_8539F3925FDDDCD6` FOREIGN KEY (`trigger_id`) REFERENCES `[[dbprefix]]point_triggers` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]push_ids` -- ALTER TABLE `[[dbprefix]]push_ids` ADD CONSTRAINT `FK_73026E0255458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]push_notifications` -- ALTER TABLE `[[dbprefix]]push_notifications` ADD CONSTRAINT `FK_46FD6AD412469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]push_notification_list_xref` -- ALTER TABLE `[[dbprefix]]push_notification_list_xref` ADD CONSTRAINT `FK_A0269247B9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_A0269247EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `[[dbprefix]]push_notifications` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]push_notification_stats` -- ALTER TABLE `[[dbprefix]]push_notification_stats` ADD CONSTRAINT `FK_14F864193DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_14F8641955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_14F86419A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_14F86419EF1A9D84` FOREIGN KEY (`notification_id`) REFERENCES `[[dbprefix]]push_notifications` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]reports_schedulers` -- ALTER TABLE `[[dbprefix]]reports_schedulers` ADD CONSTRAINT `FK_DA2AB2234BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `[[dbprefix]]reports` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]sms_messages` -- ALTER TABLE `[[dbprefix]]sms_messages` ADD CONSTRAINT `FK_1ADA172C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]sms_message_list_xref` -- ALTER TABLE `[[dbprefix]]sms_message_list_xref` ADD CONSTRAINT `FK_CB0BB81AB9FC8874` FOREIGN KEY (`leadlist_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_CB0BB81ABD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]sms_message_stats` -- ALTER TABLE `[[dbprefix]]sms_message_stats` ADD CONSTRAINT `FK_DEE545F93DAE168B` FOREIGN KEY (`list_id`) REFERENCES `[[dbprefix]]lead_lists` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DEE545F955458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DEE545F9A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_DEE545F9BD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `[[dbprefix]]sms_messages` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]stages` -- ALTER TABLE `[[dbprefix]]stages` ADD CONSTRAINT `FK_348FF7D212469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]stage_lead_action_log` -- ALTER TABLE `[[dbprefix]]stage_lead_action_log` ADD CONSTRAINT `FK_DE3FEB8A2298D193` FOREIGN KEY (`stage_id`) REFERENCES `[[dbprefix]]stages` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_DE3FEB8A55458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_DE3FEB8AA03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]tweets` -- ALTER TABLE `[[dbprefix]]tweets` ADD CONSTRAINT `FK_B115DD9312469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_B115DD935DA1941` FOREIGN KEY (`asset_id`) REFERENCES `[[dbprefix]]assets` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_B115DD93C4663E4` FOREIGN KEY (`page_id`) REFERENCES `[[dbprefix]]pages` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]tweet_stats` -- ALTER TABLE `[[dbprefix]]tweet_stats` ADD CONSTRAINT `FK_828260011041E39B` FOREIGN KEY (`tweet_id`) REFERENCES `[[dbprefix]]tweets` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_8282600155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]users` -- ALTER TABLE `[[dbprefix]]users` ADD CONSTRAINT `FK_38BB68BCD60322AC` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`);
-- -- Constraints for table `[[dbprefix]]user_tokens` -- ALTER TABLE `[[dbprefix]]user_tokens` ADD CONSTRAINT `FK_8606D057A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]video_hits` -- ALTER TABLE `[[dbprefix]]video_hits` ADD CONSTRAINT `FK_7A85981155458D` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_7A859811A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `[[dbprefix]]ip_addresses` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]webhooks` -- ALTER TABLE `[[dbprefix]]webhooks` ADD CONSTRAINT `FK_A5ADB23712469DE2` FOREIGN KEY (`category_id`) REFERENCES `[[dbprefix]]categories` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]webhook_events` -- ALTER TABLE `[[dbprefix]]webhook_events` ADD CONSTRAINT `FK_485036905C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]webhook_logs` -- ALTER TABLE `[[dbprefix]]webhook_logs` ADD CONSTRAINT `FK_E28D7BFC5C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]webhook_queue` -- ALTER TABLE `[[dbprefix]]webhook_queue` ADD CONSTRAINT `FK_A939DE365C9BA60B` FOREIGN KEY (`webhook_id`) REFERENCES `[[dbprefix]]webhooks` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_A939DE3671F7E88B` FOREIGN KEY (`event_id`) REFERENCES `[[dbprefix]]webhook_events` (`id`) ON DELETE CASCADE;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;